o zBaseConstraint.constraint_sqlcCr2r3r4r6r-r-r. create_sqlAr:zBaseConstraint.create_sqlcCr2r3r4r6r-r-r. remove_sqlDr:zBaseConstraint.remove_sqlcCr2r3r4)r)r7instanceexcludeusingr-r-r.validateGr:zBaseConstraint.validatecCs|jd|jiS)Nr)rrr0r-r-r.get_violation_error_messageJsz*BaseConstraint.get_violation_error_messagecCsgSNr-)r)r7 connectionr-r-r._checkMszBaseConstraint._checkc Csg}t}|D]e^}}|dkr|||sqz|dkr!|jj}n|j|}|jr0|js0|jr2WqWn ty<Yqw|d}t |drlt |drl| |durl| |durl| t jdt|g||ddq|||d|S) Npkr get_transform get_lookupz.'constraints' refers to the joined field '%s'.z models.E041)objid constraints)setadd_metarE get_field is_relation many_to_many one_to_manyrhasattrrFrGappendrErrorr joinextend_check_local_fields) r)r7 referenceserrorsfields field_namelookupsfield first_lookupr-r-r._check_referencesPsH     z BaseConstraint._check_referencescCshd|jj|jjf}|dd}d|ji}|jdur%|j|jkr%|j|d<|jdur/|j|d<|d|fS)Nz%s.%szdjango.db.models.constraintszdjango.db.modelsrrrr-)r" __module__r#replacerrr$r)r)pathkwargsr-r-r. deconstructvs        zBaseConstraint.deconstructcCs|\}}}|j|i|SrB)rdr")r)_r*rcr-r-r.cloneszBaseConstraint.clone)r#r` __qualname__rer$rrr/propertyr1r9r;r<rr@rArDr_rdrfr-r-r-r.rs"  & rcseZdZdddddfdd ZddZddZeeeZd d Zd d Z d dZ ddZ ddZ de fddZddZfddZfddZZS)rN) conditioncheckrrcsL|durtjdtdd|}||_t|ddstdtj|||ddS)N=CheckConstraint.check is deprecated in favor of `.condition`.rr conditionalFzECheckConstraint.condition must be a Q instance or boolean expression.r)r%r&rrigetattrr!superr/)r)rrirjrrr"r-r.r/s"   zCheckConstraint.__init__cCstjdtdd|jSNrkrrr%r&rrir0r-r-r. _get_checks zCheckConstraint._get_checkcCstjdtdd||_dSrprq)r)valuer-r-r. _set_checks  zCheckConstraint._set_checkcCsg}|jjsd|jjvs|tj|jdd|dd|S|jjs(d|jjvr`t}|j }t |t r;| | |tdd|DrW|tjd|jd d |d d|||||S) N supports_table_check_constraintsz$ does not support check constraints.OA constraint won't be created. Silence this warning if you don't care about it.z models.W027hintrHrIcss|]}t|tVqdSrB) isinstancer ).0exprr-r-r. z)CheckConstraint._check..zCheck constraint zS contains RawSQL() expression and won't be validated during the model full_clean().z0Silence this warning if you don't care about it.z models.W045)featuresrurMrequired_db_featuresrSrWarning display_namerKriryrupdate_get_expr_referencesanyflattenrrVr_)r)r7rCrYrXrir-r-r.rDsB     zCheckConstraint._checkcsRt|dd}||j}|jjd}||j\}}|tfdd|DS)NFr7 alias_colsrCc3|]}|VqdSrB quote_valuerzpr8r-r.r|r}z1CheckConstraint._get_check_sql..)r build_whereri get_compilerrCas_sqltupler)r7r8querywherecompilersqlparamsr-rr._get_check_sqls  zCheckConstraint._get_check_sqlcCs|||}||j|SrB)r _check_sqlrr)r7r8rjr-r-r.r9s zCheckConstraint.constraint_sqlcCs|||}|||j|SrB)r_create_check_sqlrrr-r-r.r;s zCheckConstraint.create_sqlcCs|||jSrB)_delete_check_sqlrr6r-r-r.r<szCheckConstraint.remove_sqlcCsR|j|j|d}zt|jj||dst||jdWdSty(YdSw)Nmetar>r?code) _get_field_expression_maprMrrirjrrArr)r)r7r=r>r?againstr-r-r.r@s  zCheckConstraint.validatecCsVd|jj|jt|j|jdurdnd|j|jdus |j|jkr$dfSd|jfS)Nz<%s: condition=%s name=%s%s%s> violation_error_code=%r violation_error_message=%r)r"rgrireprrrrr$r0r-r-r.__repr__s    zCheckConstraint.__repr__csFt|tr|j|jko|j|jko|j|jko|j|jkSt|SrB)ryrrrirrrn__eq__r)otherror-r.rs      zCheckConstraint.__eq__cs$t\}}}|j|d<|||fS)Nri)rnrdrir)rbr*rcror-r.rds  zCheckConstraint.deconstruct)r#r`rgr/rrrtrhrjrDrr9r;r<rr@rrrd __classcell__r-r-ror.rs$  '  rc@seZdZdZdZddZdS)rdeferred immediatecCs|jjd|jS)N.)r"rg_name_r0r-r-r.r$szDeferrable.__repr__N)r#r`rgDEFERRED IMMEDIATErr-r-r-r.rs rc seZdZdddddddddd fdd ZeddZdd Zd d Zd d ZddZ ddZ ddZ ddZ fddZ fddZdefddZZS)rr-N) rZrri deferrableinclude opclassesnulls_distinctrrc sf|std| s|std| r|rtdt|ttfs!td|r)|r)td|r1|r1td|r9|r9td| rA|rAtd| rI|rItd t|ttfsTtd t|tttfs`td t|ttfsktd t|ttfsvtd |rt |t |krtdt||_ ||_ ||_ |rt|nd|_ ||_||_tdd| D|_tj||| ddS)Nz"A unique constraint must be named.zKAt least one field or expression is required to define a unique constraint.z?UniqueConstraint.fields and expressions are mutually exclusive.z0UniqueConstraint.condition must be a Q instance.z4UniqueConstraint with conditions cannot be deferred.z8UniqueConstraint with include fields cannot be deferred.z3UniqueConstraint with opclasses cannot be deferred.z5UniqueConstraint with expressions cannot be deferred.zrUniqueConstraint.opclasses cannot be used with expressions. Use django.contrib.postgres.indexes.OpClass() instead.z:UniqueConstraint.deferrable must be a Deferrable instance.z1UniqueConstraint.include must be a list or tuple.z3UniqueConstraint.opclasses must be a list or tuple.z/UniqueConstraint.nulls_distinct must be a bool.z]UniqueConstraint.fields and UniqueConstraint.opclasses must have the same number of elements.r-css&|]}t|tr t|n|VqdSrB)rystrr )rz expressionr-r-r.r|es  z,UniqueConstraint.__init__..r) ValueErrorryrrrr!listrboollenrZrirrrr expressionsrnr/) r)rZrrirrrrrrrror-r.r/)sh    zUniqueConstraint.__init__cCs t|jSrB)rrr0r-r-r.r1os z%UniqueConstraint.contains_expressionscCs|h|j|jd}|jj}|jdur-|jjs-d|vs-|t j |j dd|dd|j durJ|jj sJd|vsJ|t j |j dd|d d|jre|jjsed |vse|t j |j d d|d d|jr|jjsd |vs|t j |j dd|dd|jdur|jjsd|vs|t j |j dd|ddt}|jjsd|vrt|jtr|||j|jr|jjsd |vr|jD] }|||q|||||S)NrJsupports_partial_indexesz5 does not support unique constraints with conditions.rvz models.W036rw&supports_deferrable_unique_constraintsz0 does not support deferrable unique constraints.z models.W038supports_covering_indexesz: does not support unique constraints with non-key columns.z models.W039supports_expression_indexesz4 does not support unique constraints on expressions.z models.W044*supports_nulls_distinct_unique_constraintsz9 does not support unique constraints with nulls distinct.z models.W047)rWrZrrMrrir~rrSrrrrrrr1rrrrKryrrrrrVr_)r)r7rCrYrrXrr-r-r.rDss             zUniqueConstraint._checkcs`|jdurdSt|dd}||j}|jjd}||j\}}|tfdd|DS)NFrrc3rrBrrrr-r.r|r}z6UniqueConstraint._get_condition_sql..)rirrrrCrrrr-rr._get_condition_sqls   z#UniqueConstraint._get_condition_sqlcCsN|jsdSg}|jD]}t|}||j||q t|t|ddS)NF)r)rrset_wrapper_classesrCrSr resolve_expressionr)r)r7r8index_expressionsrindex_expressionr-r-r._get_index_expressionss    z'UniqueConstraint._get_index_expressionsc dfdd|jD}fdd|jD}||}||}|j||j||j||j||jd S)Ncg|]}j|qSr-rMrNrzr[r7r-r. z3UniqueConstraint.constraint_sql..cg|] }j|jqSr-rMrNcolumnrrr-r.rrirrrrr) rZrrr _unique_sqlrrrrr)r7r8rZrrirr-rr.r9"   zUniqueConstraint.constraint_sqlc r)Ncrr-rrrr-r.rrz/UniqueConstraint.create_sql..crr-rrrr-r.rrr) rZrrr_create_unique_sqlrrrrrr-rr.r;rzUniqueConstraint.create_sqlc sN||}fdd|jD}||}|j|j||j||j||jdS)Ncrr-rrrr-r.rrz/UniqueConstraint.remove_sql..r)rrr_delete_unique_sqlrrrr)r)r7r8rirrr-rr.r<s   zUniqueConstraint.remove_sqlc Csd|jj|js dndt|j|jsdndt|jdt|j|jdur'dnd|j|jdur2dnd|j|js;dndt|j|j sFdnd t|j |j durSdnd |j |j dur^dnd |j |j dusm|j |j krqdf Sd |j f S) Nz<%s:%s%s%s%s%s%s%s%s%s%s>rz fields=%sz expressions=%sz name=%sz condition=%sz deferrable=%rz include=%sz opclasses=%sz nulls_distinct=%rrr)r"rgrZrrrrirrrrrrr$r0r-r-r.r!s*     zUniqueConstraint.__repr__cst|trA|j|jko@|j|jko@|j|jko@|j|jko@|j|jko@|j|jko@|j|jko@|j |j uo@|j |j ko@|j |j kSt |SrB)ryrrrZrirrrrrrrrnrrror-r.r=s*            zUniqueConstraint.__eq__cst\}}}|jr|j|d<|jr|j|d<|jr |j|d<|jr(|j|d<|jr0|j|d<|jdur:|j|d<||j|fS)NrZrirrrr) rnrdrZrirrrrrrror-r.rdMs        zUniqueConstraint.deconstructcCsJ|j|}|jrJi}|jD]2}|r||vrdS|j|}t||j} |jdur.| dus8| dkr;t|j j r;dS| ||j <q|j d i|}nx|rz|j D]*} t| drl| D]} t| trj| j |vrjdSqZqOt| try| j |vrydSqOdd|j|j|dD} g} |j D].} t| dr| } | | }t| |}|jdurt|tt| dt|dB}| |q|j | }||j}|jjs|dur|j|d }|js|r|jrt |!||jt |"|j#d dS|j|j|d}z|jt$| |j@j%||d rt |"|j#d WdSt&y$YdSw) NFrrcSsi|] \}}t||qSr-)r )rzr]rsr-r-r. sz-UniqueConstraint.validate..rget_expression_for_validationT)rErrr-)'_default_managerr?rZrMrNrmattnamerrr~!interprets_empty_strings_as_nullsrfilterrrRrryr ritemsrreplace_expressionsrrrrS _get_pk_val_stateaddingr>riexistsrunique_error_messagerArr rjr)r)r7r=r>r?queryset lookup_kwargsr[r] lookup_valuerr{ replacementsfiltersrhsrimodel_class_pkrr-r-r.r@]s                     zUniqueConstraint.validate)r#r`rgr/rhr1rDrrr9r;r<rrrdrr@rr-r-ror.r(s.F b    r))r%enumrtypesr django.corerdjango.core.exceptionsrrr django.dbrdjango.db.models.constantsr django.db.models.expressionsr r r r django.db.models.indexesrdjango.db.models.lookupsrrdjango.db.models.query_utilsrdjango.db.models.sql.queryrdjango.db.utilsrdjango.utils.deprecationrdjango.utils.translationrre__all__rrrrr-r-r-r.s*           s