o gistspgistz;Exclusion constraints only support GiST or SP-GiST indexes.zFAt least one expression is required to define an exclusion constraint.css*|]}t|ttfot|dkVqdS)N) isinstancelisttuplelen).0exprrrr .s z/ExclusionConstraint.__init__..z+The expressions must be a list of 2-tuples.z3ExclusionConstraint.condition must be a Q instance.z=ExclusionConstraint.deferrable must be a Deferrable instance.z4ExclusionConstraint.include must be a list or tuple.GISTr)namerr)lower ValueErrorallr#rr r r$r% expressionsrrrrsuper__init__) selfr+r/rrrrrr __class__rrr1s<   zExclusionConstraint.__init__cCs^g}t|jD] \}\}}t|trt|}t||d}||j||qt | |S)N)operator) enumerater/r#strr rset_wrapper_classes connectionappendrresolve_expression)r2 schema_editorqueryr/idx expressionr5rrr_get_expressionsEs    z$ExclusionConstraint._get_expressionscCsDt}|jD]\}}t|trt|}|||q|||SN)setr/r#r7r update_get_expr_references_check_references)r2modelr9 referencesr(_rrr_checkOs   zExclusionConstraint._checkcsF|jdurdS||j}||j\}}|tfdd|DS)Nc3s|]}|VqdSrA) quote_value)r'pr<rrr)\sz9ExclusionConstraint._get_condition_sql..)r build_whereas_sqlr9r%)r2compilerr<r=wheresqlparamsrrLr_get_condition_sqlWs  z&ExclusionConstraint._get_condition_sqlc stdd}|j|jd}|||}jj}||||}fdd|jD}t|j t ||j | |j |j t||||j|rDd|nd||||jdS) NF) alias_cols)r9csg|] }j|jqSr)_meta get_fieldcolumn)r' field_namerFrr dsz6ExclusionConstraint.constraint_sql..z WHERE (%s))tabler+rr/rPrr)r get_compilerr9r@rUdb_tablerSrrrr quote_namer+rrrJ_index_include_sql_deferrable_constraint_sqlr) r2rFr<r=rOr/r\rrrrYrconstraint_sql^s(        z"ExclusionConstraint.constraint_sqlcCs,||tdt|jj|j|||dS)Nz(ALTER TABLE %(table)s ADD %(constraint)s)r\ constraint)check_supportedrrrUr^r_rbr2rFr<rrr create_sqlts  zExclusionConstraint.create_sqlcCs||j|||jSrA)_delete_constraint_sqlsql_delete_checkr_r+rerrr remove_sql|s  zExclusionConstraint.remove_sqlcCs2|jr|jdkr|jjjstddSdSdS)Nr!zMCovering exclusion constraints using an SP-GiST index require PostgreSQL 14+.)rrr,r9features supports_covering_spgist_indexesr)r2r<rrrrdsz#ExclusionConstraint.check_supportedcspt\}}}|j|d<|jdur|j|d<|jdkr#|j|d<|jr+|j|d<|jr3|j|d<|||fS)Nr/rr rrr)r0 deconstructr/rrr,rr)r2pathargskwargsr3rrrls       zExclusionConstraint.deconstructcsxt||jr6|j|jko5|j|jko5|j|jko5|j|jko5|j|jko5|j|jko5|j|jko5|j |j kSt |SrA) r#r4r+rr/rrrrrr0__eq__)r2otherr3rrrps"          zExclusionConstraint.__eq__c Csd|jjt|jt|jt|j|jdurdnd|j|jdur"dnd|j|js+dndt|j|j dur8dnd|j |j dusG|j |j krKdf Sd|j f S)Nz4<%s: index_type=%s expressions=%s name=%s%s%s%s%s%s>r[z condition=%sz deferrable=%rz include=%sz violation_error_code=%rz violation_error_message=%r) r4rreprrr/r+rrrrrdefault_violation_error_message)r2rrr__repr__s"   zExclusionConstraint.__repr__cCs||j|}|j|j|d}dd|D}g}t|jD]Y\} \} } t| tr-t | } |rRt| t r=| j |vr<dSn| D]} t| t rQ| j |vrQdSqA| |} t | dr`| } t | dri| } t| | d}| |_||q|j|}||j}|jjs|dur|j|d}|js|rt||jddS|jt||j@j||drt||jddS) N)metaexcludecSsi|] \}}t||qSr)r )r'fieldvaluerrr sz0ExclusionConstraint.validate..get_expression_for_validation)lhsrhs)pk)code)using)_default_managerr_get_field_expression_maprUitemsr6r/r#r7r r+flattenreplace_expressionshasattrrzrpostgres_operatorr:filter _get_pk_val_stateaddingrvrexistsrget_violation_error_messagerr check)r2rFinstancervrquerysetreplacement_map replacementslookupsr>r?r5r(rhs_expressionlookupmodel_class_pkrrrvalidatesV               zExclusionConstraint.validate)rrrrr1r@rIrSrbrfrirdrlrprtrr __classcell__rrr3rrs* ,  N)typesrdjango.core.exceptionsr django.dbrr!django.db.backends.ddl_referencesrrrdjango.db.modelsr r r r django.db.models.expressionsr rdjango.db.models.indexesrdjango.db.models.lookupsrdjango.db.models.sqlr__all__rrrrrrs