o بf@sddlZddlmZddlmZmZmZmZmZddlm Z m Z ddl m Z ddl mZmZddlmZedZd d Zd d ZGd ddZdS)N)datetime)ColumnsForeignKeyName IndexName StatementTable) names_digestsplit_identifier)Index)TransactionManagementErroratomic)timezonezdjango.db.backends.schemacCs2|j}|jrdS|jr|jdgkrdS|j|jvS)zz When altering the given field, must constraints on its model from the given relation be temporarily dropped? FNT)field many_to_many primary_keyZ to_fieldsname)ZrelationZ altered_fieldrrV/var/www/dscantool/venv/lib/python3.10/site-packages/django/db/backends/base/schema.py_is_relevant_relations  rcs2tfddjjjDfddjjjDS)Nc3|] }t|r|VqdSNr.0obj) old_fieldrr #z+_related_non_m2m_objects..c3rrrr) new_fieldrrr$r)zipmodel_metarelated_objects)rrr)rrr_related_non_m2m_objectssr#c @seZdZdZdZdZdZdZdZdZ dZ d Z d Z d Z d Zd ZdZdZdZdZdZdZdZeZdZeZdZdZeZdZdZdZdZ eZ!dZ"ddd Z#d!d"Z$d#d$Z%dd&d'Z&d(d)Z'dd*d+Z(d,d-Z)d.d/Z*e+d0d1Z,d2d3Z-d4d5Z.d6d7Z/d8d9Z0d:d;Z1dd?Z3d@dAZ4dBdCZ5dDdEZ6dFdGZ7dHdIZ8dJdKZ9dLdMZ:dNdOZ;ddPdQZ< ddRdSZ=dTdUZ>ddVdWZ?dXdYZ@dZd[ZAdd]d^ZBdd_d`ZCdd\d\dd%dd%ddadbdcZDdddeZEdfdgZFdhdiZGdjdkZHdldmZIdndoZJdpdqZKdrdsZLdtduZMdvdwZNddxdyZOddzd{ZPdd|d}ZQd~dZRddZSddZTddZU   dddZVdddZWddZXddZYdddZZdS)BaseDatabaseSchemaEditorz This class and its subclasses are responsible for emitting schema-changing statements to the databases - model creation/removal/alteration, field renaming, index fiddling, and so on. z'CREATE TABLE %(table)s (%(definition)s)z1ALTER TABLE %(old_table)s RENAME TO %(new_table)sz7ALTER TABLE %(table)s SET TABLESPACE %(new_tablespace)szDROP TABLE %(table)s CASCADEz:ALTER TABLE %(table)s ADD COLUMN %(column)s %(definition)sz!ALTER TABLE %(table)s %(changes)sz%ALTER COLUMN %(column)s TYPE %(type)sz%ALTER COLUMN %(column)s DROP NOT NULLz$ALTER COLUMN %(column)s SET NOT NULLz/ALTER COLUMN %(column)s SET DEFAULT %(default)sz$ALTER COLUMN %(column)s DROP DEFAULTz4ALTER TABLE %(table)s DROP COLUMN %(column)s CASCADEzDALTER TABLE %(table)s RENAME COLUMN %(old_column)s TO %(new_column)szFUPDATE %(table)s SET %(column)s = %(default)s WHERE %(column)s IS NULLzUNIQUE (%(columns)s)zCHECK (%(check)s)z.ALTER TABLE %(table)s DROP CONSTRAINT %(name)sz"CONSTRAINT %(name)s %(constraint)sz?ALTER TABLE %(table)s ADD CONSTRAINT %(name)s CHECK (%(check)s)zBALTER TABLE %(table)s ADD CONSTRAINT %(name)s UNIQUE (%(columns)s)z|ALTER TABLE %(table)s ADD CONSTRAINT %(name)s FOREIGN KEY (%(column)s) REFERENCES %(to_table)s (%(to_column)s)%(deferrable)sNzFCREATE INDEX %(name)s ON %(table)s (%(columns)s)%(extra)s%(condition)szDCREATE UNIQUE INDEX %(name)s ON %(table)s (%(columns)s)%(condition)szDROP INDEX %(name)szGALTER TABLE %(table)s ADD CONSTRAINT %(name)s PRIMARY KEY (%(columns)s)zDROP PROCEDURE %(procedure)sFTcCs,||_||_|jr g|_|jjjo||_dSr) connection collect_sql collected_sqlfeaturescan_rollback_ddlatomic_migration)selfr%r&r rrr__init__[s z!BaseDatabaseSchemaEditor.__init__cCs(g|_|jrt|jj|_|j|Sr) deferred_sqlr*r r%alias __enter__r+rrrr/ds  z"BaseDatabaseSchemaEditor.__enter__cCs<|dur|jD]}||q|jr|j|||dSdSr)r-executer*r __exit__)r+exc_type exc_value tracebacksqlrrrr2ks   z!BaseDatabaseSchemaEditor.__exit__rcCs|js|jjr|jjjstdt|}tjd||||dd|jrL| dr*dnd}|durB|j |t t |j||dS|j ||dS|j}|||WddS1scwYdS)z:Execute the given SQL statement, with optional parameters.ziExecuting DDL statements while in a transaction on databases that can't perform a rollback is prohibited.z%s; (params %r))paramsr6)extra;N)r&r%Zin_atomic_blockr(r)r strloggerdebugendswithr'appendtuplemap quote_valuecursorr1)r+r6r7endingrCrrrr1ts$ "z BaseDatabaseSchemaEditor.executecCs|jj|Sr)r%ops quote_name)r+rrrrrFz#BaseDatabaseSchemaEditor.quote_namec Cs"|j|jd}|d}g}|durdS|j}|o|| }|rA||}|durA|jjjr8|d||7}n |d7}||g7}|jrN|j sN|jjj rNd}|rZ|jjj sZ|d7}n|s`|d7}|j rh|d 7}n|j ro|d 7}|j pu|jj } | r|jjjr|j r|d |jjj| dd 7}||fS) z Take a field and return its column definition. The field must already have had set_attributes_from_name() called. r%typeNNNz DEFAULT %sTz NULLz NOT NULLz PRIMARY KEYz UNIQUE %s)inline) db_parametersr%null skip_defaulteffective_defaultr(requires_literal_defaultsprepare_defaultempty_strings_allowedr!interprets_empty_strings_as_nullsZimplied_column_nullunique db_tablespacer!Zsupports_tablespacesrEtablespace_sql) r+r rinclude_default db_paramsr6r7rN default_valueZ tablespacerrr column_sqls<      z#BaseDatabaseSchemaEditor.column_sqlcCsdS)z Some backends don't accept default values for certain columns types (i.e. MySQL longtext and longblob). Frr+rrrrrOsz%BaseDatabaseSchemaEditor.skip_defaultcCstd)zU Only used for backends which have requires_literal_defaults feature zsubclasses of BaseDatabaseSchemaEditor for backends which have requires_literal_defaults must provide a prepare_default() methodNotImplementedErrorr+valuerrrrRsz(BaseDatabaseSchemaEditor.prepare_defaultcCs|r |}|S|js#|jr#|jr#|dkrt}|St}|St|dds/t|ddrUt }|}|dkrA| }|S|dkrK| }|S|dkrSt }|Sd}|S)NZ BinaryFieldZauto_nowFZ auto_now_addZ DateFieldZ TimeFieldZ DateTimeField) has_default get_defaultrNblankrSget_internal_typebytesr;getattrrnowdatetimer )rdefaultZ internal_typerrr_effective_defaults.  z+BaseDatabaseSchemaEditor._effective_defaultcCs||||jS)z2Return a field's effective database default value.)Zget_db_prep_saverkr%r\rrrrPsz*BaseDatabaseSchemaEditor.effective_defaultcCst)aX Return a quoted version of the value so it's safe to use in an SQL string. This is not safe against injection from user code; it is intended only for use in making SQL scripts or preparing default values for particularly tricky backends (defaults are not user-defined, though, so this is safe). r]r_rrrrBsz$BaseDatabaseSchemaEditor.quote_valuecsBg}g}jjD]}|\}}|durq|jjd}|dr+|dj|7}|jjd}|r:|d|7}|||jr||j r||jj jj } |jj j |jj j} jrl|dj| | d7}njjjr|j|d|d|j|f|d vrjjjj |j} | rj| qjjD]} fd d | D} j| qfd d jjD}jjj d ddg||RDd}jjrjjjj}|r|d|7} ||pdj!jj"D]}|jj#jj$r%|jj#q dS)zr Create a table and any accompanying indexes or unique constraints for the given `model`. NrHcheck rK)to_table to_column_fk_%(to_table)s_%(to_column)sz%s %s)Z AutoFieldZ BigAutoFieldcg|] }j|jqSrr! get_fieldcolumnrrr rr &z9BaseDatabaseSchemaEditor.create_model..csg|]}|qSr)Zconstraint_sqlr constraintr r+rrrw(, css|]}|r|VqdSrrryrrrr,sz8BaseDatabaseSchemaEditor.create_model..)table definition)&r! local_fieldsr[rMr%sql_check_constraintZdb_type_suffixextend remote_field db_constraintr db_tablers field_namertsql_create_inline_fkrFr(supports_foreign_keysr-r?_create_fk_sqlrdrE autoinc_sqlZunique_together_create_unique_sql constraintssql_create_tablejoinrVrWr1_model_indexes_sqllocal_many_to_manythrough auto_created create_model)r+r Z column_sqlsr7rrZ extra_paramsrYZcol_type_suffixrnrorfieldscolumnsrr6rWrr{rrsf             z%BaseDatabaseSchemaEditor.create_modelcCs~|jjD]}|jjjjr||jjq||jd||jj it |j D]}t |t r<||jj r<|j |q(dS)z!Delete a model from the database.r~N)r!rrrr delete_modelr1sql_delete_tablerFrlistr- isinstancerZreferences_tableremove)r+r rr6rrrr=s   z%BaseDatabaseSchemaEditor.delete_modelcCs|j|||dddS)zAdd an index on a model.N)r7)r1 create_sqlr+r indexrrr add_indexMsz"BaseDatabaseSchemaEditor.add_indexcCs||||dS)zRemove an index from a model.N)r1 remove_sqlrrrr remove_indexQsz%BaseDatabaseSchemaEditor.remove_indexcC"|||}|r||dSdS)z"Add a check constraint to a model.N)rr1r+r rzr6rrradd_constraintU z'BaseDatabaseSchemaEditor.add_constraintcCr)z'Remove a check constraint from a model.N)rr1rrrrremove_constraint[rz*BaseDatabaseSchemaEditor.remove_constraintcszdd|D}dd|D}||D] }||ddi|jq||D]}fdd|D}|||q&dS) z Deal with a model changing its unique_together. The input unique_togethers must be doubly-nested, not the single-nested ["foo", "bar"] format. cSh|]}t|qSrr@rrrrr gzABaseDatabaseSchemaEditor.alter_unique_together..cSrrrrrrrrhrrUTcrqrrrrurvrrrwnrxzBBaseDatabaseSchemaEditor.alter_unique_together..N) difference_delete_composed_indexsql_delete_uniquer1r)r+r Zold_unique_togetherZnew_unique_togetheroldsnewsrrrrvralter_unique_togetherasz.BaseDatabaseSchemaEditor.alter_unique_togethercs~dd|D}dd|D}||D] }||ddi|jq||D]}fdd|D}||j|dd q&d S) z Deal with a model changing its index_together. The input index_togethers must be doubly-nested, not the single-nested ["foo", "bar"] format. cSrrrrrrrrwrz@BaseDatabaseSchemaEditor.alter_index_together..cSrrrrrrrrxrrTcg|]}j|qSrr!rsrurvrrrw~r|zABaseDatabaseSchemaEditor.alter_index_together.._idxsuffixN)rrsql_delete_indexr1_create_index_sql)r+r Zold_index_togetherZnew_index_togetherrrr field_namesrrvralter_index_togetherqsz-BaseDatabaseSchemaEditor.alter_index_togetherc sddjjD}ddjjD}fdd|D}|j|fd||Bi|}t|dkr?tdt|jjd |f|| ||d dS) NcSh|]}|jqSrrryrrrrzBBaseDatabaseSchemaEditor._delete_composed_index..cSrrrryrrrrrcrqrrrrurvrrrwrxzCBaseDatabaseSchemaEditor._delete_composed_index..excludez1Found wrong number (%s) of constraints for %s(%s)r}r) r!rindexes_constraint_nameslen ValueErrorrrr1_delete_constraint_sql) r+r rZconstraint_kwargsr6meta_constraint_namesmeta_index_namesrconstraint_namesrrvrrs" z/BaseDatabaseSchemaEditor._delete_composed_indexcCsn||ks|jjjr||krdS||j||||d|jD] }t|t r4| ||q'dS)z#Rename the table a model points to.N)Z old_tableZ new_table) r%r(Zignores_table_name_caselowerr1sql_rename_tablerFr-rrZrename_table_references)r+r Z old_db_tableZ new_db_tabler6rrralter_db_tables   z'BaseDatabaseSchemaEditor.alter_db_tablecCs2||j||jj||||ddS)z)Move a model's table between tablespaces.)r~Zold_tablespaceZnew_tablespaceN)r1sql_retablespace_tablerFr!r)r+r Zold_db_tablespaceZnew_db_tablespacerrralter_db_tablespaces  z,BaseDatabaseSchemaEditor.alter_db_tablespacecCsH|jr|jjjjr||jjS|j||dd\}}|dur dS|j|jd}|dr4|d|j |7}|j | |jj | |j |d}|||||sv||durv|j|d|dd\}}|j| |jj |d }||||j||||jr|jjjr|jr|j|||d |jjjr|jdSdS) z Create a field on a model. Usually involves adding a column, but may involve adding a table instead (for M2M fields). T)rXNrHrlrm)r~rtrdropr~changesrp)rrrr!rrr[rMr%rsql_create_columnrFrrtr1rOrP_alter_column_default_sqlsql_alter_columnr-r_field_indexes_sqlr(rrr?rconnection_persists_old_columnsclose)r+r rrr7rYr6 changes_sqlrrr add_fields6      z"BaseDatabaseSchemaEditor.add_fieldcCs|jr|jjjjr||jjS|j|jdddurdS|jr8|j||j gdd}|D] }| | ||q,|j | |jj| |j d}| ||jjjrX|jt|jD]}t|trs||jj|j rs|j|q]dS)z Remove a field from a model. Usually involves deleting a column, but for M2Ms may involve deleting a table. rHrINT foreign_key)r~rt)rrrr!rrrMr%rrtr1_delete_fk_sqlsql_delete_columnrFrr(rrrr-rrZreferences_columnr)r+r rfk_namesfk_namer6rrr remove_fields(      z%BaseDatabaseSchemaEditor.remove_fieldc Cs |j|jd}|d}|j|jd}|d}|dur|jdus(|dur0|jdur0td||f|durT|durT|jjrT|jjrT|jjjjrT|jjjjrT|||||S|durr|durr|jjrr|jjrr|jjjjsr|jjjjsrdS|dusz|durtd||f|||||||||dS)a' Allow a field's type, uniqueness, nullability, default, column, constraints, etc. to be modified. `old_field` is required to compute the necessary changes. If `strict` is True, raise errors if the old column does not match `old_field` precisely. rHrINzqCannot alter field %s into %s - they do not properly define db_type (are you using a badly-written custom field?)zCannot alter field %s into %s - they are not compatible types (you cannot alter to or from M2M fields, or add or remove through= on M2M fields)) rMr%rrrr!r_alter_many_to_many _alter_field) r+r rrstrict old_db_paramsold_type new_db_paramsnew_typerrr alter_fieldsP     z$BaseDatabaseSchemaEditor.alter_fieldc 'Cs6t} |jr>|jr>|j||jgdd} |r)t| dkr)tdt| |jj|jf| D]} | |jf| | || q+|j r|j rJ| ||rdd|jjD} |j||jgdd| d} |rut| dkrutd t| |jj|jf| D] }| |||qw|jr|jp|j o|j o||k}|rt||D]\}}|j|j|jjgdd}|D] } | | |j| qq|jr|j s|jr|j rd d|jjD}|j||jgdtj|d }|D] }| |||q|d |d kr3|d r3d d|jjD} |j||jgd| d} |r$t| dkr$tdt| |jj|jf| D] }| |||q&|j|jkr_| ||jj||||jD]}t|tr]||jj|j|jqJg}g}g}||kr~|||||\}}| ||!||"|}|"|}|j#o|j# o||ko|duo|$| }|r| |%||||j#|j#kr|&|||}|r| ||'o|j#o|j# }|s|rF|s||}|j(j)j*r|rt+t,|\}} d-|t.| gfg}|D]\}} | |j/|0|jj|d| q|rF| |j1|0|jj|0|jdd|g|D]\}} | |j/|0|jj|d| q/|rW|D] \}} | || qK|jre|jse|2|||3||rw| |4||jg|jr|j r|jr|j s| |5||gg}!|jr|jr||kr|!!t||| ||r| |6|||!!t|||!D]B\}"}|jj7|j(d}#|#d}$||j|"j|j|$\}}| |j/|0|jjj|dd|d|D] \}} | || qq|jr"| s|jr|js"|jr"| |8||d|rE|j9jj:D]}%t;|%|rC|%jjrC| |8|%j|%jdq*|d |d krk|d rk|j<|jj|jgdd}| |=|||d |r|j%|||dd\}&} |j/|0|jj|&d}| || |j(j)j>r|j(?dSdS)z3Perform a "physical" (non-ManyToMany) field update.Trrz.F)rUrrz7Found wrong number (%s) of unique constraints for %s.%scSrrr)rrrrrrVr)rtype_rrlcSrrrryrrrrdr)rlrz6Found wrong number (%s) of check constraints for %s.%sNr}r%s)r~rtrjrHrIrrpZ_fk_checkrr)@setrrrrtrrr!raddr1rrU_field_became_primary_keyr_delete_unique_sqlrr#Z related_modelrdb_indexrr r_delete_index_sql_delete_check_sql_rename_field_sqlr-rrZrename_column_references_alter_column_type_sqlr?rrPrNrOr_alter_column_null_sqlrar%r(Zsupports_combined_altersr@rrsumrrFsql_update_with_default_delete_primary_key_unique_should_be_addedrr_create_primary_key_sqlrMrr r"r_create_index_name_create_check_sqlrr)'r+r rrrrrrrZ fks_droppedrrrrconstraint_nameZdrop_foreign_keysZ_old_relZnew_relZ rel_fk_namesrZ index_names index_namer6actionsZ null_actionsZ post_actionsfragmentZ other_actionsZ old_default new_defaultZneeds_database_defaultZfour_way_default_alterationr7Zrels_to_updateZold_relZ rel_db_paramsZrel_typerelrrrrrsp                               z%BaseDatabaseSchemaEditor._alter_fieldcCsX|jjjr |dvr dS|j|jd}|jr|jn|j}|||j |ddgfS)z Hook to specialize column null alteration. Return a (sql, params) fragment to set a column to null or non-null as required by new_field, or None if no changes are required. )Z CharFieldZ TextFieldNrHrIrtrI) r%r(rTrdrMrNsql_alter_column_nullsql_alter_column_not_nullrFrt)r+r rrrr6rrrr s   z/BaseDatabaseSchemaEditor._alter_column_null_sqlc Cst||}d}|g}|rg}n |jjjr||}g}|j|jd}|r'|jn|j} | ||j |d|d|fS)z Hook to specialize column default alteration. Return a (sql, params) fragment to add or drop (depending on the drop argument) a default to new_field's column. rrHrI)rtrIrj) rPr%r(rQrRrMsql_alter_column_no_defaultsql_alter_column_defaultrFrt) r+r rrrrrjr7rr6rrrr#s"    z2BaseDatabaseSchemaEditor._alter_column_default_sqlcCs |j||j|dgfgfS)a Hook to specialize column type alteration for different backends, for cases when a creation type is different to an alteration type (e.g. SERIAL in PostgreSQL, PostGIS fields). Return a two-tuple of: an SQL fragment of (sql, params) to insert into an ALTER TABLE statement and a list of extra (sql, params) tuples to run once the field is altered. r)sql_alter_column_typerFrt)r+r rrrrrrrBs z/BaseDatabaseSchemaEditor._alter_column_type_sqlcCs|jjjj|jjjjkr||jj|jjjj|jjjj||jj|jjj||jjj|||jj|jjj||jjj|dS)z*Alter M2Ms to repoint their to= endpoints.N) rrr!rrrrsZm2m_reverse_field_nameZm2m_field_name)r+r rrrrrrrWs z,BaseDatabaseSchemaEditor._alter_many_to_manyr:c Cst|\}}dt|g|Rddi|f}|jjpd}d|d||f}t||kr/|St||dkr?|d|d}|t|d d }d|d|d|d||f}|d dksg|d rod |dd }|S)z Generate a unique name for an index/unique constraint. The name is divided into 3 parts: the table name, the column names, and a unique digest and suffix. z%s%slengthz%s_%s_%s_NrrzD%s)r rr%rEZmax_name_lengthrrisdigit) r+Z table_name column_namesrr Zhash_suffix_part max_lengthrZ other_lengthrrrrls"   z+BaseDatabaseSchemaEditor._create_index_namecCsX|durt|dkr|djr|dj}n|jjr|jj}|dur*d|jj|SdS)Nrrrmr:)rrVr!r%rErW)r+r rrVrrr_get_index_tablespace_sqls z2BaseDatabaseSchemaEditor._get_index_tablespace_sql)rrusingrV col_suffixesr6 opclasses conditionc sj|||d} dd|D} |pj} |jj}fdd}t| t|jt|| ||||| || | | r=d| dSddS) z Return the SQL statement to create the index for one or several fields. `sql` can be specified if the syntax differs from the standard (GIS indexes, ...). )rVcSsg|]}|jqSr)rtrurrrrwrz>BaseDatabaseSchemaEditor._create_index_sql..cs"dur j|i|Sr)rrFargskwargsrr+rrcreate_index_names zEBaseDatabaseSchemaEditor._create_index_sql..create_index_name WHERE r:)r~rrrr8r) rsql_create_indexr!rrrrFr_index_columns)r+r rrrrrVrr6rrrWrrr~rrrrrs     z*BaseDatabaseSchemaEditor._create_index_sqlcCs"t|jt|jj|j||dSN)r~r)rrrr!rrFr+r rrrrrs z*BaseDatabaseSchemaEditor._delete_index_sqlcCst|||j|dS)N)r)rrF)r+r~rrrrrrrsz'BaseDatabaseSchemaEditor._index_columnscsjjr jjs jjrgSg}jjD] }|||qjjD]}fdd|D}||j |ddq$jj D] }|| |q?|S)z Return a list of all index SQL statements (field indexes, index_together, Meta.indexes) for the specified model. crrrrurvrrrwr|z?BaseDatabaseSchemaEditor._model_indexes_sql..rr) r!ZmanagedproxyZswappedrrrZindex_togetherr?rrr)r+r outputrrrrrrvrrs   z+BaseDatabaseSchemaEditor._model_indexes_sqlcCs(g}|||r||||g|S)zT Return a list of all index SQL statements for the specified field. )_field_should_be_indexedr?r)r+r rr!rrrrs z+BaseDatabaseSchemaEditor._field_indexes_sqlcCs|jo|j Sr)rrUr+r rrrrr"rGz1BaseDatabaseSchemaEditor._field_should_be_indexedcCs|j o|jSrrr+rrrrrrrGz2BaseDatabaseSchemaEditor._field_became_primary_keycCs"|j r|jp|jo|j o|jSr)rUrr%rrrrsz0BaseDatabaseSchemaEditor._unique_should_be_addedcCs*|j||||j||j|dS)N)r~Z old_columnZ new_columnrI)sql_rename_columnrFrt)r+r~rrrrrrrs   z*BaseDatabaseSchemaEditor._rename_field_sqlc sfdd}t|jjj}t|jj|jgt|jjjjd|jjg||}t |jj|jgj}t|jjjjj}t |jjjj|jjgj} j j } t j||||| | dS)Ncj|i|SrrFrrr0rrcreate_fk_namez?BaseDatabaseSchemaEditor._create_fk_sql..create_fk_namer)r~rrtrnro deferrable)rr!rrFrrtr Z target_fieldr rr%rEZdeferrable_sqlr sql_create_fk) r+r rrr)r~rrtrnror+rr0rrs.  z'BaseDatabaseSchemaEditor._create_fk_sqlcC||j||Sr)r sql_delete_fkrrrrrz'BaseDatabaseSchemaEditor._delete_fk_sqlcCs\|r|j||||d}|r|j|dS|jddt|j|i}|j|||dS)N)rrrr}rrz)rr-r?sql_unique_constraintrrArFsql_constraint)r+r rrrr6rzrrr _unique_sqls z$BaseDatabaseSchemaEditor._unique_sqlcsfdd}t|jjj}|durt|jj|d|}n|}t||j}|r=jjjr;t j |||d|dSdSt j |||dS)Ncr'rr(rr0rrcreate_unique_namer*zGBaseDatabaseSchemaEditor._create_unique_sql..create_unique_name_uniqr)r~rrrr~rr) rr!rrFrrr%r(supports_partial_indexesrsql_create_unique_indexsql_create_unique)r+r rrrr4r~rr0rrs.  z+BaseDatabaseSchemaEditor._create_unique_sqlcCs2|r|jjjr||j||SdS||j||Sr)r%r(r7rrr)r+r rrrrrr1sz+BaseDatabaseSchemaEditor._delete_unique_sqlcCs |j|||jd|idS)Nrlr0)r2rFr)r+rrlrrr _check_sql9s z#BaseDatabaseSchemaEditor._check_sqlcCs$t|jt|jj|j|||dS)N)r~rrl)rsql_create_checkrr!rrF)r+r rrlrrrr?s z*BaseDatabaseSchemaEditor._create_check_sqlcCr-r)rsql_delete_checkrrrrrGr/z*BaseDatabaseSchemaEditor._delete_check_sqlcCs t|t|jj|j||dSr)rrr!rrF)r+templater rrrrrJs z/BaseDatabaseSchemaEditor._delete_constraint_sqlc s|dur fdd|D}j} jj| |jj} Wdn1s'wYg} | D]Y\} }|dus@||dkr|durK|d|krKq2|durV|d|krVq2|dura|d|kraq2|durl|d|krlq2|duru|d suq2|dur|d |krq2| r| | vr| | q2| S) z@Return all constraint names matching the columns and conditions.Ncsg|] }jj|qSr)r% introspectionZidentifier_converter)rrr0rrrwVs z>BaseDatabaseSchemaEditor._constraint_names..rrUrrrlrrI)r%rCr>Zget_constraintsr!ritemsr?)r+r rrUrrrrlrrrCrresultrZinfodictrr0rrQs4    z*BaseDatabaseSchemaEditor._constraint_namescCsV|j|dd}|rt|dkrtdt||jjf|D] }||||qdS)NTr$rz0Found wrong number (%s) of PK constraints for %s)rrrr!rr1_delete_primary_key_sql)r+r rrrrrrrosz,BaseDatabaseSchemaEditor._delete_primary_keyc CsJt|jt|jj|j||j|jj|jgddt|jj|jg|jdS)NZ_pkrr6) r sql_create_pkrr!rrFrrtrr#rrrrysz0BaseDatabaseSchemaEditor._create_primary_key_sqlcCr-r)r sql_delete_pkrrrrrAr/z0BaseDatabaseSchemaEditor._delete_primary_key_sqlcCs*|j||d|d}||dS)N,)Z procedure param_types)sql_delete_procedurerFrr1)r+Zprocedure_namerEr6rrrremove_procedures z)BaseDatabaseSchemaEditor.remove_procedure)FT)r)F)r:rrJ)NNNNNNNN)[__name__ __module__ __qualname____doc__rrrrrrrrrrrrr&rr1rZsql_delete_constraintr2r;r<r9rr,rr.rr8rrBrCrFr,r/r2r1rFr[rOrR staticmethodrkrPrBrrrrrrrrrrrrrrrrrrrrrrrrrrr"rrrrrr3rrr:rrrrrrrArGrrrrr$(s    0  F* * u            r$)loggingrZ!django.db.backends.ddl_referencesrrrrrZdjango.db.backends.utilsrr Zdjango.db.modelsr Zdjango.db.transactionr r Z django.utilsr getLoggerr<rr#r$rrrrs