U 8T_@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|jkS)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_fieldrrB/tmp/pip-unpacked-wheel-dv63caxw/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 's z+_related_non_m2m_objects..c3s|]}t|r|VqdSrrr) new_fieldrrr!(s )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,rrrr0is  z"BaseDatabaseSchemaEditor.__enter__cCs8|dkr|jD]}||q|jr4|j|||dSr)r.executer+r __exit__)r,exc_type exc_value tracebacksqlrrrr3ps   z!BaseDatabaseSchemaEditor.__exit__rc Cs|js |jjr |jjjs tdt|}tjd||||dd|jr| drTdnd}|dk r|j |t t |j||q|j ||n"|j}|||W5QRXdS)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))paramsr7)extra;N)r'r&Zin_atomic_blockr)r*r strloggerdebugendswithr(appendtuplemap quote_valuecursorr2)r,r7r8ZendingrDrrrr2ys" z BaseDatabaseSchemaEditor.executecCs|jj|Sr)r&ops quote_name)r,rrrrrFsz#BaseDatabaseSchemaEditor.quote_namecsjjD]*}fdd|D}j|qg}g}jjD]<}|\}}|dkrdqD|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 krDjjjj|j} | rDj | qDfd djjD}jjjd dd||Dd}jjrjjjj}|r|d|7}||fS)z-Take a model and return its table definition.csg|]}j|jqSrr get_fieldcolumnrrrrr sz6BaseDatabaseSchemaEditor.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,rrrKs, css|]}|r|VqdSrrrSrrrr!sz5BaseDatabaseSchemaEditor.table_sql..)table definition) rZunique_togetherr.r@_create_unique_sql local_fields column_sql db_parametersr&sql_check_constraintZdb_type_suffixextend remote_field db_constraintrdb_tablerH field_namerIsql_create_inline_fkrFr)supports_foreign_keys_create_fk_sqlget_internal_typerE autoinc_sql constraintssql_create_tablejoin db_tablespacetablespace_sql)r,rfieldscolumnsZ column_sqlsr8rrXZ extra_params db_paramsZcol_type_suffixrPrQrgrhr7rlrrUr table_sqlsX          z"BaseDatabaseSchemaEditor.table_sqlc Cs6|j|jd}|d}g}|dkr&dS|j}|o:|| }|r||}d||} |dk r|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. rLtypeN)NNz DEFAULT Tz NULLz NOT NULLz PRIMARY KEYz UNIQUErO)inline)r\r&null skip_defaulteffective_default_column_default_sqlr)requires_literal_defaultsprepare_defaultempty_strings_allowedr!interprets_empty_strings_as_nullsZimplied_column_nulluniquerkrZsupports_tablespacesrErl) r,rrinclude_defaultror7r8rs 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,rrrrrtsz%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,valuerrrrxsz(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. %srr~rrrrvsz,BaseDatabaseSchemaEditor._column_default_sqlcCs|r|}n|js<|jr<|jr<|dkr6d}qd}nbt|ddsTt|ddrt}|}|dkrv| }q|dkr| }q|d krt }nd}|S) NZ BinaryFieldr;Zauto_nowFZ auto_now_addZ DateFieldZ TimeFieldZ DateTimeField) has_default get_defaultrsZblankryrfgetattrrnowdatetimer)rdefaultZ internal_typerrr_effective_defaults"     z+BaseDatabaseSchemaEditor._effective_defaultcCs||||jS)z2Return a field's effective database default value.)Zget_db_prep_saverr&r~rrrru-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). NrrrrrrC1sz$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) rpr2r.r^_model_indexes_sqlrlocal_many_to_manyr_through auto_created create_model)r,rr7r8rrrrr=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.rWN)rrr_rr delete_modelr2sql_delete_tablerFralistr. isinstancerZreferences_tableremove)r,rrr7rrrrNs   z%BaseDatabaseSchemaEditor.delete_modelcCs|j|||dddS)zAdd an index on a model.N)r8)r2 create_sqlr,rindexrrr add_index^sz"BaseDatabaseSchemaEditor.add_indexcCs||||dS)zRemove an index from a model.N)r2 remove_sqlrrrr remove_indexbsz%BaseDatabaseSchemaEditor.remove_indexcCs|||}|r||dS)zAdd a constraint to a model.N)rr2r,rrTr7rrradd_constraintfs z'BaseDatabaseSchemaEditor.add_constraintcCs|||}|r||dS)z!Remove a constraint from a model.N)rr2rrrrremove_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|qSrrArrmrrr xszABaseDatabaseSchemaEditor.alter_unique_together..cSsh|] }t|qSrrrrrrrysr{Tcsg|]}j|jqSrrGrJrrrrKszBBaseDatabaseSchemaEditor.alter_unique_together..N) difference_delete_composed_indexsql_delete_uniquer2rY)r,rZold_unique_togetherZnew_unique_togetheroldsnewsrmrnrrralter_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|qSrrrrrrrsz@BaseDatabaseSchemaEditor.alter_index_together..cSsh|] }t|qSrrrrrrrsTF)rr{csg|]}j|qSrrrHrJrrrrKszABaseDatabaseSchemaEditor.alter_index_together.._idxsuffixN)rrsql_delete_indexr2_create_index_sql)r,rZold_index_togetherZnew_index_togetherrrrm field_namesrrralter_index_togethersz-BaseDatabaseSchemaEditor.alter_index_togetherc sddjjD}ddjjD}fdd|D}|j|fd||Bi|}t|dkr~tdt|jjd |f|| ||d dS) NcSsh|] }|jqSrrrSrrrrszBBaseDatabaseSchemaEditor._delete_composed_index..cSsh|] }|jqSrrrSrrrrscsg|]}j|jqSrrGrJrrrrKszCBaseDatabaseSchemaEditor._delete_composed_index..excludez1Found wrong number (%s) of constraints for %s(%s)rVr) rrhindexes_constraint_nameslen ValueErrorrarjr2_delete_constraint_sql) r,rrmZconstraint_kwargsr7meta_constraint_namesmeta_index_namesrnconstraint_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_caselowerr2sql_rename_tablerFr.rrZrename_table_references)r,rZ old_db_tableZ new_db_tabler7rrralter_db_tables   z'BaseDatabaseSchemaEditor.alter_db_tablecCs2||j||jj||||ddS)z)Move a model's table between tablespaces.)rWZold_tablespaceZnew_tablespaceN)r2sql_retablespace_tablerFrra)r,rZold_db_tablespaceZnew_db_tablespacerrralter_db_tablespaces  z,BaseDatabaseSchemaEditor.alter_db_tablespacec Cs|jr |jjjjr ||jjS|j||dd\}}|dkr@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||dk r|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|NrLrMrNrRz%s.r;)r namespacerIrPrQ deferrable)rWrIrXdroprWchanges)%rr_rrrrr[r\r&r]r)rdr`sql_create_column_inline_fkrrarHrbrIr _fk_constraint_namerFrEdeferrable_sqlr.r@resql_create_columnr2rtru_alter_column_default_sqlsql_alter_columnr^_field_indexes_sqlconnection_persists_old_columnsclose) r,rrrXr8roZconstraint_suffixrPrQr_r7 changes_sqlrrr add_fieldsN           z"BaseDatabaseSchemaEditor.add_fieldcCs|jr |jjjjr ||jjS|j|jdddkr: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. rLrqNT foreign_key)rWrI)rr_rrrrr\r&rrIr2_delete_fk_sqlsql_delete_columnrFrar)rrrr.rrZreferences_columnr)r,rrfk_namesfk_namer7rrr remove_fields$     z%BaseDatabaseSchemaEditor.remove_fieldc Cs$|j|jd}|d}|j|jd}|d}|dkr>|jdksP|dkrb|jdkrbtd||fn|dkr|dkr|jjr|jjr|jjjjr|jjjjr|||||S|dkr|dkr|jjr|jjr|jjjjs|jjjjsdS|dks|dkrtd||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. rLrqNzqCannot 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_fieldsZ     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|dk rd}|#|(||||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)rrrrrrs)rtype_rrMcSsh|] }|jqSrrrSrrrrs)rMrz6Found wrong number (%s) of check constraints for %s.%sNrVrr)rWrIrrLrqrrRZ_fk_checkrr)Asetr&r)rdr_r`rrIrrrraaddr2rr{_field_became_primary_keyrh_delete_unique_sqlrr$Z related_modelrdb_indexrr r_delete_index_sql_delete_check_sql_rename_field_sqlr.rrZrename_column_references_alter_column_type_sqlr@r^rsrurtr_alter_column_null_sqlrZsupports_combined_altersrAr#rjsumrrFsql_update_with_default_delete_primary_key_unique_should_be_addedrYr_create_primary_key_sqlr\rerZrelated_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_namer7actionsZ null_actionsZ post_actionsfragmentZ other_actionsZneeds_database_defaultZ old_default new_defaultZfour_way_default_alterationr8Zrels_to_updateZold_relZ rel_db_paramsZrel_typerelrrrrr>s                           z%BaseDatabaseSchemaEditor._alter_fieldcCs\|jjjr|dkrdS|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 TextFieldNrLrqrIrq) r&r)rzrfr\rssql_alter_column_nullsql_alter_column_not_nullrFrI)r,rr r"rr7rrrr6s   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. rLrq)rIrqr) rurvr&r)rwrxr\sql_alter_column_no_defaultsql_alter_column_defaultrFrI) r,rr r"rrrr8rr7rrrrLs"     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_typerFrI)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_rrrarrrHZm2m_reverse_field_nameZm2m_field_name)r,rr r"rrrrrs z,BaseDatabaseSchemaEditor._alter_many_to_manyr;c Cst|\}}dt|f|ddi|f}|jjp6d}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&rEZmax_name_lengthrjrisdigit) r,Z table_name column_namesrrZhash_suffix_part max_lengthrZ other_lengthrrrrs"   z+BaseDatabaseSchemaEditor._create_index_namecCsX|dkr:t|dkr*|djr*|dj}n|jjr:|jj}|dk rTd|jj|SdS)NrrrNr;)rrkrr&rErl)r,rrmrkrrr_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)rrusingrk col_suffixesr7 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, ...). )rkcSsg|] }|jqSr)rIrJrrrrKsz>BaseDatabaseSchemaEditor._create_index_sql..csdkrj||Sr)rrFargskwargsrr,rrcreate_index_names zEBaseDatabaseSchemaEditor._create_index_sql..create_index_name)rWrr rnr9r ) r sql_create_indexrrarrrFr_index_columnsr )r,rrmrrr rkrr7rr rlrnrrWrrrrrs   z*BaseDatabaseSchemaEditor._create_index_sqlcCs&t|p |jt|jj|j||dSN)rWr)rrrrrarF)r,rrr7rrrrs z*BaseDatabaseSchemaEditor._delete_index_sqlcCst|||j|dS)N)r)rrF)r,rWrnrrrrrrsz'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|qSrrrJrrrrKsz?BaseDatabaseSchemaEditor._model_indexes_sql..rr) rZmanagedproxyZswappedrZr^rZindex_togetherr@rrr)r,routputrrrmrrrrrs   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,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)rWZ old_columnZ new_columnrq)sql_rename_columnrFrI)r,rWr 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)rWrrIrPrQr)rrrarFrrrI target_fieldrr&rErr sql_create_fk) r,rrrrWrrIrPrQrrrrres z'BaseDatabaseSchemaEditor._create_fk_sqlcs<fdd}t|jj|jgt|jjjjd|jjg||S)Ncsj||SrrFrrr1rrcreate_fk_name)szDBaseDatabaseSchemaEditor._fk_constraint_name..create_fk_namer)rrrarIr rr)r,rrrr"rr1rr(s z,BaseDatabaseSchemaEditor._fk_constraint_namecCs||j||Sr)r sql_delete_fkr,rrrrrr5sz'BaseDatabaseSchemaEditor._delete_fk_sqlcCs,|dkr 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 rV)rnrrrT) r&r)&supports_deferrable_unique_constraintsrYr.r@sql_unique_constraintrjrBrFr%sql_constraint)r,rrmrr rr7rTrrr _unique_sql@s$ z$BaseDatabaseSchemaEditor._unique_sqlc s|rjjjsdSfdd}t|jjj}|dkrJt|jj|d|}n |}t||j}|r|jjj stdSj }nj }t |||| ||dS)Ncsj||Srr!rr1rrcreate_unique_name]szGBaseDatabaseSchemaEditor._create_unique_sql..create_unique_name_uniq)rWrrnr r)r&r)r'rrrarFrrsupports_partial_indexessql_create_unique_indexsql_create_uniquerr r%) r,rrnrr rr+rWr7rr1rrYVs0   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)NrMr&)r)rFr])r,rrMrrr _check_sqls z#BaseDatabaseSchemaEditor._check_sqlcCs$t|jt|jj|j|||dS)N)rWrrM)rsql_create_checkrrrarF)r,rrrMrrrrs z*BaseDatabaseSchemaEditor._create_check_sqlcCs||j||Sr)rsql_delete_checkr$rrrrsz*BaseDatabaseSchemaEditor._delete_check_sqlcCs t|t|jj|j||dSr)rrrrarF)r,templaterrrrrrs z/BaseDatabaseSchemaEditor._delete_constraint_sqlc  s|dk rfdd|D}j} jj| |jj} W5QRXg} | D]\} }|dksl||dkrP|dk r|d|krqP|dk r|d|krqP|dk r|d|krqP|dk r|d|krqP|dk r|d sqP|dk r|d |krqP| r| | krP| | qP| S) z@Return all constraint names matching the columns and conditions.Ncsg|]}jj|qSr)r& introspectionZidentifier_converter)rrr1rrrKsz>BaseDatabaseSchemaEditor._constraint_names..rnr{rrrMrrq)r&rDr4Zget_constraintsrraitemsr@)r,rrr{rrrrMrrrDrhresultrZinfodictrr1rrs0    z*BaseDatabaseSchemaEditor._constraint_namescCsV|j|dd}|r6t|dkr6tdt||jjf|D]}||||q:dS)NTrrz0Found wrong number (%s) of PK constraints for %s)rrrrrar2_delete_primary_key_sql)r,rrrrrrrrsz,BaseDatabaseSchemaEditor._delete_primary_keyc CsJt|jt|jj|j||j|jj|jgddt|jj|jg|jdS)NZ_pkr)rWrrn) r sql_create_pkrrrarFrrIrrrrrrsz0BaseDatabaseSchemaEditor._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_procedurerFrjr2)r,Zprocedure_namer;r7rrrremove_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__rirrrrrrrrrrrrrr(r]Zsql_delete_constraintr)r1r2r/rr rcrr#rr.rr8r9r<r-r0r3r2rFrpr[rtrxrv staticmethodrrurCrrrrrrrrrrrrrrrrrrrrr r rrrrrrrrrrerrr%r*rYrr0rrrrrrr7r=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