a xd@sddlZddlmZddlmZmZmZmZmZddlm Z m Z ddl m Z m Z ddlmZmZddlmZedZd d Zd d Zd dZGdddZdS)N)datetime)ColumnsForeignKeyName IndexName StatementTable) names_digestsplit_identifier) DeferrableIndex)TransactionManagementErroratomic)timezonezdjango.db.backends.schemacCs2|j}|jrdS|jr&|jdgkr&dS|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/html/Ranjet/env/lib/python3.9/site-packages/django/db/backends/base/schema.py_is_relevant_relations rcCs|jjddddS)NFT)ZforwardreverseZinclude_hidden)_metaZ _get_fieldsmodelrrr_all_related_fieldssrcs2tfddtjDfddtjDS)Nc3s|]}t|r|VqdSNr.0obj) old_fieldrr 'z+_related_non_m2m_objects..c3s|]}t|r|VqdSrrr) new_fieldrrr!(r")ziprr)r r#r)r#r r_related_non_m2m_objects#sr%c @seZdZdZdZdZdZdZdZdZ dZ d Z d Z d Z d Zd ZdZdZdZdZdZdZdZeZdZeZdZdZdZeZdZdZdZ dZ!eZ"dZ#ddd Z$d!d"Z%d#d$Z&dd&d'Z'd(d)Z(d*d+Z)dd,d-Z*d.d/Z+d0d1Z,d2d3Z-e.d4d5Z/d6d7Z0d8d9Z1d:d;Z2dd?Z4d@dAZ5dBdCZ6dDdEZ7dFdGZ8dHdIZ9dJdKZ:dLdMZ;dNdOZddTdUZ?ddVdWZ@dXdYZAddZd[ZBd\d]ZCd^d_ZDddadbZEddcddZFdedfZGdd`d`dd%dd%ddgdhdiZHddjdkZIdldmZJdndoZKdpdqZLdrdsZMdtduZNdvdwZOdxdyZPdzd{ZQd|d}ZRd~dZSddZTdddZUdddZVdddZWddZXddZYddZZddZ[dddZ\dddZ]ddZ^ddZ_dddZ`dS)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 NULLz"UNIQUE (%(columns)s)%(deferrable)szCHECK (%(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)zPALTER TABLE %(table)s ADD CONSTRAINT %(name)s UNIQUE (%(columns)s)%(deferrable)sz|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,||_||_|jrg|_|jjjo$||_dSr) connection collect_sql collected_sqlfeaturescan_rollback_ddlatomic_migration)selfr'r(r rrr__init__`s z!BaseDatabaseSchemaEditor.__init__cCs(g|_|jr$t|jj|_|j|Sr) deferred_sqlr,r r'alias __enter__r-rrrr1is  z"BaseDatabaseSchemaEditor.__enter__cCs8|dur|jD]}||q|jr4|j|||dSr)r/executer,r __exit__)r-exc_type exc_value tracebacksqlrrrr4ps   z!BaseDatabaseSchemaEditor.__exit__rcCs|js |jjr |jjjs tdt|}tjd||||dd|jr| drTdnd}|dur|j |t t |j||q|j ||n6|j}|||Wdn1s0YdS)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))paramsr8)extra;N)r(r'Zin_atomic_blockr*r+r strloggerdebugendswithr)appendtuplemap quote_valuecursorr3)r-r8r9ZendingrErrrr3ys" z BaseDatabaseSchemaEditor.executecCs|jj|Sr)r'ops quote_name)r-rrrrrGsz#BaseDatabaseSchemaEditor.quote_namecsjjD]*}fdd|D}j|qg}g}jjD]<}|\}}|durdqD|jjd} | dr|dj | 7}|j jd} | r|d| 7}| ||j r6|j r6|j jjj} |j jj|j jj} jr|dj| | d7}n"jjjr6j|d |d |j|f|d vrDjjjj|j} | rDj | qDfd djjD}jjjd ddg||RDd}jjrjjjj}|r|d|7}||fS)z-Take a model and return its table definition.csg|]}j|jqSrr get_fieldcolumnrrrrr r"z6BaseDatabaseSchemaEditor.table_sql..Nr'check  %s)to_table to_column_fk_%(to_table)s_%(to_column)sz%s %s)Z AutoFieldZ BigAutoFieldZSmallAutoFieldcsg|]}|qSr)Zconstraint_sqlr constraintrr-rrrLr", css|]}|r|VqdSrrrTrrrr!r"z5BaseDatabaseSchemaEditor.table_sql..)table definition) rZunique_togetherr/rA_create_unique_sql local_fields column_sql db_parametersr'sql_check_constraintZdb_type_suffixextend remote_field db_constraintrdb_tablerI field_namerJsql_create_inline_fkrGr*supports_foreign_keys_create_fk_sqlget_internal_typerF autoinc_sql constraintssql_create_tablejoin db_tablespacetablespace_sql)r-rfieldscolumnsZ column_sqlsr9rrYZ extra_params db_paramsZcol_type_suffixrQrRrhrir8rmrrVr table_sqlsX          z"BaseDatabaseSchemaEditor.table_sqlc Cs6|j|jd}|d}g}|dur&dS|j}|o:|| }|r||}d||} |dur|jjjr~|| ||7}n|| 7}||g7}|j r|j s|jjj rd}|r|jjj s|d7}n |s|d7}|j r|d 7}n|j r|d 7}|jp|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. rMtypeN)NNz DEFAULT Tz NULLz NOT NULLz PRIMARY KEYz UNIQUErP)inline)r]r'null skip_defaulteffective_default_column_default_sqlr*requires_literal_defaultsprepare_defaultempty_strings_allowedr!interprets_empty_strings_as_nullsZimplied_column_nulluniquerlrZsupports_tablespacesrFrm) r-rrinclude_defaultrpr8r9rt default_valueZcolumn_defaultZ tablespacerrrr\s>      z#BaseDatabaseSchemaEditor.column_sqlcCsdS)z Some backends don't accept default values for certain columns types (i.e. MySQL longtext and longblob). Frr-rrrrrusz%BaseDatabaseSchemaEditor.skip_defaultcCs tddS)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() methodNNotImplementedErrorr-valuerrrrysz(BaseDatabaseSchemaEditor.prepare_defaultcCsdS)z Return the SQL to use in a DEFAULT clause. The resulting string should contain a '%s' placeholder for a default value. %srrrrrrwsz,BaseDatabaseSchemaEditor._column_default_sqlcCs|r|}n|js<|jr<|jr<|dkr6d}qd}nbt|ddsTt|ddrt}|}|dkrv| }q|dkr| }q|d krt }nd}|S) NZ BinaryFieldr"r<Zauto_nowFZ auto_now_addZ DateFieldZ TimeFieldZ DateTimeField) has_default get_defaultrtZblankrzrggetattrrnowdatetimer)rdefaultZ internal_typerrr_effective_defaults"     z+BaseDatabaseSchemaEditor._effective_defaultcCs||||jS)z2Return a field's effective database default value.)Zget_db_prep_saverr'rrrrrv-sz*BaseDatabaseSchemaEditor.effective_defaultcCs tdS)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). NrrrrrrD1sz$BaseDatabaseSchemaEditor.quote_valuecCs\||\}}|||pd|j|||jjD]}|jjjj r8| |jjq8dS)zr Create a table and any accompanying indexes or unique constraints for the given `model`. N) rqr3r/r__model_indexes_sqlrlocal_many_to_manyr`through auto_created create_model)r-rr8r9rrrrr=s   z%BaseDatabaseSchemaEditor.create_modelcCs~|jjD]}|jjjjr||jjq||jd||jj it |j D](}t |t rP||jj rP|j |qPdS)z!Delete a model from the database.rXN)rrr`rr delete_modelr3sql_delete_tablerGrblistr/ isinstancerZreferences_tableremove)r-rrr8rrrrNs  z%BaseDatabaseSchemaEditor.delete_modelcCs|j|||dddS)zAdd an index on a model.N)r9)r3 create_sqlr-rindexrrr add_index^sz"BaseDatabaseSchemaEditor.add_indexcCs||||dS)zRemove an index from a model.N)r3 remove_sqlrrrr remove_indexbsz%BaseDatabaseSchemaEditor.remove_indexcCs|||}|r||dS)zAdd a constraint to a model.N)rr3r-rrUr8rrradd_constraintfs z'BaseDatabaseSchemaEditor.add_constraintcCs|||}|r||dS)z!Remove a constraint from a model.N)rr3rrrrremove_constraintls z*BaseDatabaseSchemaEditor.remove_constraintcszdd|D}dd|D}||D]}||ddi|jq&||D](}fdd|D}|||qLdS) z Deal with a model changing its unique_together. The input unique_togethers must be doubly-nested, not the single-nested ["foo", "bar"] format. cSsh|] }t|qSrrBrrnrrr xr"zABaseDatabaseSchemaEditor.alter_unique_together..cSsh|] }t|qSrrrrrrryr"r|Tcsg|]}j|jqSrrHrKrrrrLr"zBBaseDatabaseSchemaEditor.alter_unique_together..N) difference_delete_composed_indexsql_delete_uniquer3rZ)r-rZold_unique_togetherZnew_unique_togetheroldsnewsrnrorrralter_unique_togetherrsz.BaseDatabaseSchemaEditor.alter_unique_togethercsdd|D}dd|D}||D]}||ddd|jq&||D],}fdd|D}||j|d d qNd 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. cSsh|] }t|qSrrrrrrrr"z@BaseDatabaseSchemaEditor.alter_index_together..cSsh|] }t|qSrrrrrrrr"TF)rr|csg|]}j|qSrrrIrKrrrrLr"zABaseDatabaseSchemaEditor.alter_index_together.._idxsuffixN)rrsql_delete_indexr3_create_index_sql)r-rZold_index_togetherZnew_index_togetherrrrn field_namesrrralter_index_togethersz-BaseDatabaseSchemaEditor.alter_index_togetherc sddjjD}ddjjD}fdd|D}|j|fd||Bi|}t|dkr~tdt|jjd |f|| ||d dS) NcSsh|] }|jqSrrrTrrrrr"zBBaseDatabaseSchemaEditor._delete_composed_index..cSsh|] }|jqSrrrTrrrrr"csg|]}j|jqSrrHrKrrrrLr"zCBaseDatabaseSchemaEditor._delete_composed_index..excludez1Found wrong number (%s) of constraints for %s(%s)rWr) rriindexes_constraint_nameslen ValueErrorrbrkr3_delete_constraint_sql) r-rrnZconstraint_kwargsr8meta_constraint_namesmeta_index_namesroconstraint_namesrrrrs" z/BaseDatabaseSchemaEditor._delete_composed_indexcCsn||ks"|jjjr&||kr&dS||j||||d|jD]}t|t rN| ||qNdS)z#Rename the table a model points to.N)Z old_tableZ new_table) r'r*Zignores_table_name_caselowerr3sql_rename_tablerGr/rrZrename_table_references)r-rZ old_db_tableZ new_db_tabler8rrralter_db_tables   z'BaseDatabaseSchemaEditor.alter_db_tablecCs2||j||jj||||ddS)z)Move a model's table between tablespaces.)rXZold_tablespaceZnew_tablespaceN)r3sql_retablespace_tablerGrrb)r-rZold_db_tablespaceZnew_db_tablespacerrralter_db_tablespaces  z,BaseDatabaseSchemaEditor.alter_db_tablespacec Cs|jr |jjjjr ||jjS|j||dd\}}|dur@dS|j|jd}|drh|d|j |7}|jr2|jj j r2|j r2d}|j r|jjjj}|jjj|jjj}t|jj\} } |d|j ||||| rd|| nd ||j|||||jjd 7}n|j|||||j||jj||j|d } || |||s||dur|j|d|dd \} }|j ||jj| d } || ||j!|"|||jj j#r|j$dS)z Create a field on a model. Usually involves adding a column, but may involve adding a table instead (for M2M fields). T)r}NrMrNrOrSz%s.r<)r namespacerJrQrR deferrable)rXrJrYdroprXchanges)%rr`rrrrr\r]r'r^r*rerasql_create_column_inline_fkrrbrIrcrJr _fk_constraint_namerGrFdeferrable_sqlr/rArfsql_create_columnr3rurv_alter_column_default_sqlsql_alter_columnr__field_indexes_sqlconnection_persists_old_columnsclose) r-rrrYr9rpZconstraint_suffixrQrRr_r8 changes_sqlrrr add_fieldsN           z"BaseDatabaseSchemaEditor.add_fieldcCs|jr |jjjjr ||jjS|j|jdddur:dS|jrp|j||j gdd}|D]}| | ||qX|j | |jj| |j d}| ||jjjr|jt|jD],}t|tr||jj|j r|j|qdS)z Remove a field from a model. Usually involves deleting a column, but for M2Ms may involve deleting a table. rMrrNT foreign_key)rXrJ)rr`rrrrr]r'rrJr3_delete_fk_sqlsql_delete_columnrGrbr*rrrr/rrZreferences_columnr)r-rrfk_namesfk_namer8rrr remove_fields$     z%BaseDatabaseSchemaEditor.remove_fieldc Cs$|j|jd}|d}|j|jd}|d}|dur>|jdusP|durb|jdurbtd||fn|dur|dur|jjr|jjr|jjjjr|jjjjr|||||S|dur|dur|jjr|jjr|jjjjs|jjjjsdS|dus|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. rMrrNzqCannot 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)) r]r'r`rrrr_alter_many_to_many _alter_field) r-rr r#strict old_db_paramsold_type new_db_paramsnew_typerrr alter_fieldsV     z$BaseDatabaseSchemaEditor.alter_fieldc 'Cs\t} |jjjr|jr|jr|j||jgdd} |r\t| dkr\t dt| |j j |jf| D]$} | |jf| ||| q`|jr|jr|||rdd|j jD} |j||jgdd| d} |rt| dkrt d t| |j j |jf| D]}| |||q|jjjoF|jr0|js@|joF|joF||k}|rt||D]B\}}|j|j|jjgdd}|D]} | ||j| q|qX|jr|js|jr|jrd d|j jD}|j||jgdtj|d }|D]}| |||q|d |d kr|d rd d|j jD} |j||jgd| d} |rzt| dkrzt dt| |j j |jf| D]}| |||q~|j|jkr| ||j j ||||jD](}t|t r|!|j j |j|jqg}g}g}||kr.|"||||\}}|#||$|d}|j%r|j%s|&|}|&|}|'|s||kr|durd}|#|(||||j%|j%kr|)|||}|r|#||*o|j%o|j% }|s|r|s||}|jjj+r&|r&t,t-|\}} d.|t/| gfg}|D],\}} | |j0|1|j j |d| q*|r| |j2|1|j j |1|jdd|g|D],\}} | |j0|1|j j |d| q|r|D]\}} | || q|jr|js|3|||4||r | |5||jg|jr0|jrT|jrT|jsT| |6||gg}!|rn|!$t|||||r| |7|||!$t|||!D]\}"}|jj8|jd}#|#d}$|"|j|"j|j|$\}}| |j0|1|jj j |dd|d|D]\}} | || q q|jjjrn|jrn| sR|jrR|jsn|jrn| |9||d|r|j:j j;D]4}%t<|%|r~|%jjr~| |9|%j|%jdq~|d |d kr|d r|j=|j j |jgdd}| |>|||d |rB|j(|||dd\}&} |j0|1|j j |&d}| || |jjj?rX|j@dS)z3Perform a "physical" (non-ManyToMany) field update.Trrz.F)r|rrz7Found wrong number (%s) of unique constraints for %s.%scSsh|] }|jqSrr)rrrrrrr")rtype_rrNcSsh|] }|jqSrrrTrrrrr")rNrz6Found wrong number (%s) of check constraints for %s.%sNrWrr)rXrJrrMrrrrSZ_fk_checkrr)Asetr'r*rer`rarrJrrrrbaddr3rr|_field_became_primary_keyri_delete_unique_sqlrr%Z related_modelrdb_indexrr r_delete_index_sql_delete_check_sql_rename_field_sqlr/rrZrename_column_references_alter_column_type_sqlrAr_rtrvrur_alter_column_null_sqlrZsupports_combined_altersrBr$rksumrrGsql_update_with_default_delete_primary_key_unique_should_be_addedrZr_create_primary_key_sqlr]rfrZrelated_objectsr_create_index_name_create_check_sqlrr)'r-rr r#rrrrrZ fks_droppedrrrrconstraint_nameZdrop_foreign_keysZ_old_relZnew_relZ rel_fk_namesrZ index_names index_namer8actionsZ null_actionsZ post_actionsfragmentZ other_actionsZneeds_database_defaultZ old_default new_defaultZfour_way_default_alterationr9Zrels_to_updateZold_relZ rel_db_paramsZrel_typerelrrrrr>sp                             z%BaseDatabaseSchemaEditor._alter_fieldcCs\|jjjr|dvrdS|j|jd}|jr4|jn|j}|||j |ddgfSdS)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 TextFieldNrMrrrJrr) r'r*r{rgr]rtsql_alter_column_nullsql_alter_column_not_nullrGrJ)r-rr r#rr8rrrr6s   z/BaseDatabaseSchemaEditor._alter_column_null_sqlc Csz||}||}|g}|r$g}n|jjjr<||}g}|j|jd}|rT|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. rMrr)rJrrr) rvrwr'r*rxryr]sql_alter_column_no_defaultsql_alter_column_defaultrGrJ) r-rr r#rrrr9rr8rrrrLs"     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_typerGrJ)r-rr r#rrrrrks  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) r`rrrbrrrIZm2m_reverse_field_nameZm2m_field_name)r-rr r#rrrrrs z,BaseDatabaseSchemaEditor._alter_many_to_manyr<c Cst|\}}dt|g|Rddi|f}|jjp8d}d|d||f}t||kr^|St||dkr~|d|d}|t|d d }d|d|d|d||f}|d dks|d rd |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_%srNrrzD%s)r rr'rFZmax_name_lengthrkrisdigit) r-Z table_name column_namesrrZhash_suffix_part max_lengthrZ other_lengthrrrrs"   z+BaseDatabaseSchemaEditor._create_index_namecCsX|dur:t|dkr*|djr*|dj}n|jjr:|jj}|durTd|jj|SdS)NrrrOr<)rrlrr'rFrm)r-rrnrlrrr_get_index_tablespace_sqls z2BaseDatabaseSchemaEditor._get_index_tablespace_sqlcCs|r d|SdS)Nz WHERE r<r)r- conditionrrr_index_condition_sqlsz-BaseDatabaseSchemaEditor._index_condition_sql)rrusingrl col_suffixesr8 opclassesr c sxj|||d} dd|D} |p&j} |jj}fdd}t| t|jt|| ||||| || |  | dS)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, ...). )rlcSsg|] }|jqSr)rJrKrrrrLr"z>BaseDatabaseSchemaEditor._create_index_sql..cs"durj|i|Sr)rrGargskwargsrr-rrcreate_index_nameszEBaseDatabaseSchemaEditor._create_index_sql..create_index_name)rXrr ror:r ) r sql_create_indexrrbrrrGr_index_columnsr )r-rrnrrr rlrr8rr rmrorrXrrrrrs   z*BaseDatabaseSchemaEditor._create_index_sqlcCs&t|p |jt|jj|j||dSN)rXr)rrrrrbrG)r-rrr8rrrrs z*BaseDatabaseSchemaEditor._delete_index_sqlcCst|||j|dS)N)r)rrG)r-rXrorrrrrrsz'BaseDatabaseSchemaEditor._index_columnscsjjrjjsjjrgSg}jjD]}|||q(jjD],}fdd|D}||j |ddqHjj D]}|| |q~|S)z Return a list of all index SQL statements (field indexes, index_together, Meta.indexes) for the specified model. csg|]}j|qSrrrKrrrrLr"z?BaseDatabaseSchemaEditor._model_indexes_sql..rr) rZmanagedproxyZswappedr[r_rZindex_togetherrArrr)r-routputrrrnrrrrrs   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_indexedrAr)r-rrrrrrrs z+BaseDatabaseSchemaEditor._field_indexes_sqlcCs|jo |j Sr)rr|r-rrrrrrsz1BaseDatabaseSchemaEditor._field_should_be_indexedcCs|j o |jSrrr-r r#rrrrsz2BaseDatabaseSchemaEditor._field_became_primary_keycCs"|j r|jp |jo |j o |jSr)r|rrrrrr sz0BaseDatabaseSchemaEditor._unique_should_be_addedcCs*|j||||j||j|dS)N)rXZ old_columnZ new_columnrr)sql_rename_columnrGrJ)r-rXr r#rrrrrs   z*BaseDatabaseSchemaEditor._rename_field_sqlc Cst|jj|j}||||}t|jj|jg|j}t|jjjj|j}t|jjjj|jjg|j}|j j } t |j |||||| dS)N)rXrrJrQrRr)rrrbrGrrrJ target_fieldrr'rFrr sql_create_fk) r-rrrrXrrJrQrRrrrrrfs z'BaseDatabaseSchemaEditor._create_fk_sqlcs<fdd}t|jj|jgt|jjjjd|jjg||S)Ncsj|i|SrrGrrr2rrcreate_fk_name)szDBaseDatabaseSchemaEditor._fk_constraint_name..create_fk_namer)rrrbrJr rr)r-rrrr"rr2rr(s z,BaseDatabaseSchemaEditor._fk_constraint_namecCs||j||Sr)r sql_delete_fkr-rrrrrr5sz'BaseDatabaseSchemaEditor._delete_fk_sqlcCs,|dur dS|tjkrdS|tjkr(dSdS)Nr<z DEFERRABLE INITIALLY DEFERREDz DEFERRABLE INITIALLY IMMEDIATE)r ZDEFERREDZ IMMEDIATE)r-rrrr_deferrable_constraint_sql8s   z3BaseDatabaseSchemaEditor._deferrable_constraint_sqlcCsv|r|jjjsdS|r<|j||||d}|r8|j|dS|jdt|j || |d}|j | ||dS)N)rr rW)rorrrU) r'r*&supports_deferrable_unique_constraintsrZr/rAsql_unique_constraintrkrCrGr%sql_constraint)r-rrnrr rr8rUrrr _unique_sql@s$ z$BaseDatabaseSchemaEditor._unique_sqlc s|rjjjsdSfdd}t|jjj}|durJt|jj|d|}n |}t||j}|r|jjj stdSj }nj }t |||| ||dS)Ncsj|i|Srr!rr2rrcreate_unique_name]szGBaseDatabaseSchemaEditor._create_unique_sql..create_unique_name_uniq)rXrror r)r'r*r'rrrbrGrrsupports_partial_indexessql_create_unique_indexsql_create_uniquerr r%) r-rrorr rr+rXr8rr2rrZVs0   z+BaseDatabaseSchemaEditor._create_unique_sqlcCsD|r|jjjsdS|r4|jjjr0||j||SdS||j||Sr)r'r*r'r-rrr)r-rrr rrrrrusz+BaseDatabaseSchemaEditor._delete_unique_sqlcCs |j|||jd|idS)NrNr&)r)rGr^)r-rrNrrr _check_sqls z#BaseDatabaseSchemaEditor._check_sqlcCs$t|jt|jj|j|||dS)N)rXrrN)rsql_create_checkrrrbrG)r-rrrNrrrrs z*BaseDatabaseSchemaEditor._create_check_sqlcCs||j||Sr)rsql_delete_checkr$rrrrsz*BaseDatabaseSchemaEditor._delete_check_sqlcCs t|t|jj|j||dSr)rrrrbrG)r-templaterrrrrrs z/BaseDatabaseSchemaEditor._delete_constraint_sqlc s"|durfdd|D}j$} jj| |jj} Wdn1sN0Yg} | D]\} }|dus||dkrd|dur|d|krqd|dur|d|krqd|dur|d|krqd|dur|d|krqd|dur|d sqd|dur|d |krqd| r| | vrd| | qd| S) z@Return all constraint names matching the columns and conditions.Ncsg|]}jj|qSr)r' introspectionZidentifier_converter)rrr2rrrLsz>BaseDatabaseSchemaEditor._constraint_names..ror|rrrNrrr)r'rEr4Zget_constraintsrrbitemsrA)r-rrr|rrrrNrrrEriresultrZinfodictrr2rrs0  2 z*BaseDatabaseSchemaEditor._constraint_namescCsV|j|dd}|r6t|dkr6tdt||jjf|D]}||||q:dS)NTrrz0Found wrong number (%s) of PK constraints for %s)rrrrrbr3_delete_primary_key_sql)r-rrrrrrrrsz,BaseDatabaseSchemaEditor._delete_primary_keyc CsJt|jt|jj|j||j|jj|jgddt|jj|jg|jdS)NZ_pkr)rXrro) r sql_create_pkrrrbrGrrJrrrrrrsz0BaseDatabaseSchemaEditor._create_primary_key_sqlcCs||j||Sr)r sql_delete_pkr$rrrr7sz0BaseDatabaseSchemaEditor._delete_primary_key_sqlcCs*|j||d|d}||dS)N,)Z procedure param_types)sql_delete_procedurerGrkr3)r-Zprocedure_namer;r8rrrremove_procedures z)BaseDatabaseSchemaEditor.remove_procedure)FT)r)F)F)F)F)r<)N)N)NN)NNN)NN)NNNNNNNN)F)r)a__name__ __module__ __qualname____doc__rjrrrrrrrrrrrrrr(r^Zsql_delete_constraintr)r1r2r/rr rdrr#rr.rr8r9r<r.r1r4r3rGrqr\ruryrw staticmethodrrvrDrrrrrrrrrrrrrrrrrrrrr r rrrrrrrrrrfrrr%r*rZrr0rrrrrrr7r=rrrrr&,s  ; 1   9 * y             r&)loggingrZ!django.db.backends.ddl_referencesrrrrrZdjango.db.backends.utilsrr Zdjango.db.modelsr r Zdjango.db.transactionr r Z django.utilsr getLoggerr>rrr%r&rrrrs