3 v^@sddlZddlmZddlmZmZmZmZmZddlm Z m Z ddl m Z ddl mZmZddlmZejdZd d Zd d Zd dZGdddZdS)N)datetime)ColumnsForeignKeyName IndexName StatementTable) names_digestsplit_identifier)Index)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_key to_fieldsname)relationZ altered_fieldrrB/usr/lib/python3.6/site-packages/django/db/backends/base/schema.py_is_relevant_relations rcCs|jjddddS)NFT)forwardreverseinclude_hidden)_meta _get_fields)modelrrr_all_related_fieldssrcs2tfddtjDfddtjDS)Nc3s|]}t|r|VqdS)N)r).0obj) old_fieldrr 'sz+_related_non_m2m_objects..c3s|]}t|r|VqdS)N)r)rr) 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&ffd%d&Z'd'd(Z(d)d*Z)dd+d,Z*d-d.Z+d/d0Z,d1d2Z-e.d3d4Z/d5d6Z0d7d8Z1d9d:Z2d;d<Z3d=d>Z4d?d@Z5dAdBZ6dCdDZ7dEdFZ8dGdHZ9dIdJZ:dKdLZ;dMdNZddSdTZ?ddUdVZ@dWdXZAddYdZZBd[d\ZCd]d^ZDdd`daZEddbdcZFdd_d_dfdfddddedfZGddgdhZHdidjZIdkdlZJdmdnZKdodpZLdqdrZMdsdtZNdudvZOdwdxZPdydzZQd{d|ZRdd}d~ZSdddZTdddZUddZVddZWddZXddZYdddZZdddZ[ddZ\ddZ]ffddZ^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 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,||_||_|jrg|_|jjjo$||_dS)N) connection collect_sql collected_sqlfeaturescan_rollback_ddlatomic_migration)selfr&r'r rrr__init__`s z!BaseDatabaseSchemaEditor.__init__cCs(g|_|jr$t|jj|_|jj|S)N) deferred_sqlr+r r&alias __enter__)r,rrrr0is  z"BaseDatabaseSchemaEditor.__enter__cCs<|dkr"x|jD]}|j|qW|jr8|jj|||dS)N)r.executer+r __exit__)r,exc_type exc_value tracebacksqlrrrr2ps  z!BaseDatabaseSchemaEditor.__exit__c Cs|j r$|jjr$|jjj r$tdt|}tjd||||dd|jr|j drXdnd}|dk r|j j |t t |j||q|j j ||n"|jj}|j||WdQRXdS)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&in_atomic_blockr)r*r strloggerdebugendswithr(appendtuplemap quote_valuecursorr1)r,r6r7endingrDrrrr1ys" z BaseDatabaseSchemaEditor.executecCs|jjj|S)N)r&ops quote_name)r,rrrrrGsz#BaseDatabaseSchemaEditor.quote_namecsx6jjD]*}fdd|D}jjj|q Wg}g}xHjjD]:}j|\}}|dkrlqL|jjd} | dr|dj | 7}|j jd} | r|d| 7}|j ||j o|j r<|j jjj} |j jjj|j jj} jr|djj| j| d7}n"jjjr<jjj|d |jd j|j|f|jdkrLjjjjj|j} | rLjj | qLWfddjjD}jjjjdjdd||Dd}jjrjjjjj}|r|d|7}||fS)z-Take a model and return its table definition.csg|]}jj|jqSr)r get_fieldcolumn)rr)rrr sz6BaseDatabaseSchemaEditor.table_sql..N)r&check z %s)to_table to_columnz_fk_%(to_table)s_%(to_column)sz%s %s AutoField BigAutoFieldSmallAutoFieldcsg|]}|jqSr)constraint_sql)r constraint)rr,rrrJsz, css|]}|r|VqdS)Nr)rrSrrrr!sz5BaseDatabaseSchemaEditor.table_sql..)table definition)rOrPrQ) runique_togetherr.r@_create_unique_sql local_fields column_sql db_parametersr&sql_check_constraintdb_type_suffixextend remote_field db_constraintrdb_tablerH field_namerIsql_create_inline_fkrGr)supports_foreign_keys_create_fk_sqlget_internal_typerF autoinc_sql constraintssql_create_tablejoin db_tablespacetablespace_sql)r,rfieldscolumnsZ column_sqlsr7rrU extra_params db_paramsZcol_type_suffixrMrNrfrgr6rkr)rr,r table_sqlsR          z"BaseDatabaseSchemaEditor.table_sqlc Cs<|j|jd}|d}g}|dkr&d S|j}|o:|j| }|r|j|}d|j|} |dk r|jjjr~|| |j|7}n|| 7}||g7}|j r|j r|jjj rd}|r|jjj r|d7}n |s|d7}|j r|d7}n|j r|d 7}|jp|jj} | r4|jjjr4|j r4|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&typeNz DEFAULT Tz NULLz NOT NULLz PRIMARY KEYz UNIQUEz %s)inline)NN)rZr&null skip_defaulteffective_default_column_default_sqlr)requires_literal_defaultsprepare_defaultempty_strings_allowedr!interprets_empty_strings_as_nullsimplied_column_nulluniquerjrsupports_tablespacesrFrk) r,rrinclude_defaultror6r7rs default_valueZcolumn_default tablespacerrrrYs<      z#BaseDatabaseSchemaEditor.column_sqlcCsdS)z Some backends don't accept default values for certain columns types (i.e. MySQL longtext and longblob). Fr)r,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() methodN)NotImplementedError)r,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. z%sr)r,rrrrrvsz,BaseDatabaseSchemaEditor._column_default_sqlcCs|jr|j}n|j rB|jrB|jrB|jdkr:t}qt}nbt|ddsZt|ddrt j }|j}|dkr||j }q|dkr|j }q|dkrt j }nd}|S)N BinaryFieldauto_nowF auto_now_add DateField TimeField DateTimeField) has_default get_defaultrsblankryrebytesr<getattrrnowdatetimer )rdefault internal_typerrr_effective_defaults"     z+BaseDatabaseSchemaEditor._effective_defaultcCs|j|j||jS)z2Return a field's effective database default value.)get_db_prep_saverr&)r,rrrrru-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). N)r)r,rrrrrC1sz$BaseDatabaseSchemaEditor.quote_valuecCs`|j|\}}|j||pd|jj|j|x*|jjD]}|jjjj r:|j |jjq:WdS)zr Create a table and any accompanying indexes or unique constraints for the given `model`. N) rpr1r.r]_model_indexes_sqlrlocal_many_to_manyr^through auto_created create_model)r,rr6r7rrrrr=s  z%BaseDatabaseSchemaEditor.create_modelcCsx*|jjD]}|jjjjr |j|jjq W|j|jd|j|jj ix6t |j D](}t |t rV|j|jj rV|j j|qVWdS)z!Delete a model from the database.rTN)rrr^rr delete_modelr1sql_delete_tablerGr`listr. isinstancerreferences_tableremove)r,rrr6rrrrNs z%BaseDatabaseSchemaEditor.delete_modelcCs|j|j||dddS)zAdd an index on a model.N)r7)r1 create_sql)r,rindexrrr add_index^sz"BaseDatabaseSchemaEditor.add_indexcCs|j|j||dS)zRemove an index from a model.N)r1 remove_sql)r,rrrrr remove_indexbsz%BaseDatabaseSchemaEditor.remove_indexcCs|j||}|r|j|dS)zAdd a constraint to a model.N)rr1)r,rrSr6rrradd_constraintfs z'BaseDatabaseSchemaEditor.add_constraintcCs|j||}|r|j|dS)z!Remove a constraint from a model.N)rr1)r,rrSr6rrrremove_constraintls z*BaseDatabaseSchemaEditor.remove_constraintcsdd|D}dd|D}x(|j|D]}|j|ddi|jq(Wx6|j|D](}fdd|D}|j|j|qRWdS) 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|qSr)rA)rrlrrr xszABaseDatabaseSchemaEditor.alter_unique_together..cSsh|] }t|qSr)rA)rrlrrrrysr|Tcsg|]}jj|jqSr)rrHrI)rr)rrrrJszBBaseDatabaseSchemaEditor.alter_unique_together..N) difference_delete_composed_indexsql_delete_uniquer1rW)r,rZold_unique_togetherZnew_unique_togetheroldsnewsrlrmr)rralter_unique_togetherrsz.BaseDatabaseSchemaEditor.alter_unique_togethercsdd|D}dd|D}x(|j|D]}|j|ddi|jq(Wx:|j|D],}fdd|D}|j|j|dd qRWd 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|qSr)rA)rrlrrrrsz@BaseDatabaseSchemaEditor.alter_index_together..cSsh|] }t|qSr)rA)rrlrrrrsrTcsg|]}jj|qSr)rrH)rr)rrrrJszABaseDatabaseSchemaEditor.alter_index_together.._idx)suffixN)rrsql_delete_indexr1_create_index_sql)r,rZold_index_togetherZnew_index_togetherrrrl field_namesr)rralter_index_togethersz-BaseDatabaseSchemaEditor.alter_index_togetherc sddjjD}ddjjD}fdd|D}|j|fd||Bi|}t|dkr~tdt|jjd j|f|j|j ||d dS) NcSsh|] }|jqSr)r)rrSrrrrszBBaseDatabaseSchemaEditor._delete_composed_index..cSsh|] }|jqSr)r)rrSrrrrscsg|]}jj|jqSr)rrHrI)rr)rrrrJszCBaseDatabaseSchemaEditor._delete_composed_index..excludez1Found wrong number (%s) of constraints for %s(%s)z, r) rrgindexes_constraint_nameslen ValueErrorr`rir1_delete_constraint_sql) r,rrlZconstraint_kwargsr6meta_constraint_namesmeta_index_namesrmconstraint_namesr)rrrs z/BaseDatabaseSchemaEditor._delete_composed_indexcCsr||ks"|jjjr&|j|jkr&dS|j|j|j||j|dx$|jD]}t|t rP|j ||qPWdS)z#Rename the table a model points to.N)Z old_tableZ new_table) r&r)ignores_table_name_caselowerr1sql_rename_tablerGr.rrZrename_table_references)r,r old_db_table new_db_tabler6rrralter_db_tables   z'BaseDatabaseSchemaEditor.alter_db_tablecCs2|j|j|j|jj|j||j|ddS)z)Move a model's table between tablespaces.)rTZold_tablespaceZnew_tablespaceN)r1sql_retablespace_tablerGrr`)r,rZold_db_tablespaceZnew_db_tablespacerrralter_db_tablespaces z,BaseDatabaseSchemaEditor.alter_db_tablespacec Cs|jr |jjjjr |j|jjS|j||dd\}}|dkr@dS|j|jd}|drh|d|j |7}|jo||jj j o||j rd}|j r|jjjj}|jjjj|jjj}|d|j |j||||j|j|j||j||jjjd7}n|jj|j||||j|j|jj|j|j|d } |j| ||j| r|j|dk r|j|d|dd \} }|j|j|jj| d } |j| ||jj |j!|||jj j"r|jj#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~N)r&rKrLz_fk_%(to_table)s_%(to_column)s)rrIrMrN deferrable)rTrIrU)drop)rTchanges)$rr^rrrrrYrZr&r[r)rcr_sql_create_column_inline_fkrr`rHrarI_fk_constraint_namerGrFdeferrable_sqlr.r@rdsql_create_columnr1rtru_alter_column_default_sqlsql_alter_columnr]_field_indexes_sqlconnection_persists_old_columnsclose) r,rrrUr7roZconstraint_suffixrMrNr6 changes_sqlrrr add_fieldsD           z"BaseDatabaseSchemaEditor.add_fieldcCs|jr |jjjjr |j|jjS|j|jdddkr:dS|jrt|j||j gdd}x|D]}|j |j ||qZW|j |j |jj|j |j d}|j ||jjjr|jjx:t|jD],}t|tr|j|jj|j r|jj|qWdS)z Remove a field from a model. Usually involves deleting a column, but for M2Ms may involve deleting a table. )r&rqNT) foreign_key)rTrI)rr^rrrrrZr&rrIr1_delete_fk_sqlsql_delete_columnrGr`r)rrrr.rrZreferences_columnr)r,rrfk_namesfk_namer6rrr remove_fields"     z%BaseDatabaseSchemaEditor.remove_fieldc Cs(|j|jd}|d}|j|jd}|d}|dkr>|jdksP|dkrb|jdkrbtd||fn|dkr|dkr|jjr|jjr|jjjjr|jjjjr|j||||S|dkr|dkr|jjr|jjr|jjjj r|jjjj rdS|dkp|dkr td||f|j||||||||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. )r&rqNzqCannot 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)) rZr&r^rrrr_alter_many_to_many _alter_field) r,rr r"strict old_db_paramsold_type new_db_paramsnew_typerrr alter_fields2    z$BaseDatabaseSchemaEditor.alter_fieldc 'Cs|t} |jr|jr|j||jgdd} |rRt| dkrRtdt| |jj|jfx,| D]$} | j |jf|j |j || qXW|j o|j s|j ||rdd|jjD} |j||jgdd| d} |rt| dkrtd t| |jj|jfx| D]}|j |j||qW|jr"|js2|j o8|j o8||k}|rxTt||D]F\}}|j|j|jjgdd}x"|D]} |j |j |j| qrWqLW|jr|j r|j s|j rd d|jjD}|j||jgdtj|d }x |D]}|j |j||qW|d |d kr|d rd d|jjD} |j||jgd| d} |r|t| dkr|tdt| |jj|jfx | D]}|j |j||qW|j|jkr|j |j|jj|||x2|jD](}t|tr|j|jj|j|jqWg}g}g}||kr8|j||||\}}|j ||j!||j"|}|j"|}|j#o||j# o|||ko||dk o||j$| }|r|j |j%||||j#|j#kr|j&|||}|r|j ||j'o|j#o|j# }|s|r|s||}|j(j)j*r0|r0t+t,|\}} dj-|t.| gfg}x4|D],\}} |j |j/|j0|jj|d| q6W|r|j |j1|j0|jj|j0|jdd|gx4|D],\}} |j |j/|j0|jj|d| qW|rx|D]\}} |j || qW|jr|j r|j2|||j3||r8|j |j4||jg|j sJ|j rp|jrp|j rp|j |j5||gg}!|r|!j!t|||j ||r|j |j6|||!j!t||x|!D]\}"}|jj7|j(d}#|#d}$|j|j|"j|j|$\}}|j |j/|j0|jjj|dd|dx|D]\}} |j || q,WqW|jr| sn|j sn|j r|jr|j |j8||d|rxB|j9jj:D]4}%t;|%|r|%jjr|j |j8|%j|%jdqW|d |d kr |d r |j<|jj|jgdd}|j |j=|||d |rb|j%|||dd\}&} |j/|j0|jj|&d}|j || |j(j)j>rx|j(j?dS)z3Perform a "physical" (non-ManyToMany) field update.T)rrz.F)r|rrz7Found wrong number (%s) of unique constraints for %s.%scSsh|] }|jqSr)r)rrrrrrts)rtype_rrKcSsh|] }|jqSr)r)rrSrrrrs)rKrz6Found wrong number (%s) of check constraints for %s.%sNz, )rTrz%s)rTrIr)r&rqrz_fk_%(to_table)s_%(to_column)sZ_fk_check)r)r)@setr^r_rrIrrrr`addr1rr|_field_became_primary_keyrg_delete_unique_sqlrr$ related_modelrdb_indexrr r_delete_index_sql_delete_check_sql_rename_field_sqlr.rrZrename_column_references_alter_column_type_sqlr@r]rursrtr_alter_column_null_sqlrr&r)supports_combined_altersrAr#risumrrGsql_update_with_default_delete_primary_key_unique_should_be_addedrWr_create_primary_key_sqlrZrdrrelated_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_namer6actionsZ null_actionsZ post_actionsfragmentZ other_actionsZ old_default new_defaultZneeds_database_defaultZfour_way_default_alterationr7Zrels_to_updateZold_relZ rel_db_paramsZrel_typerelrrrrr7s*        $                          $      z%BaseDatabaseSchemaEditor._alter_fieldcCs\|jjjr|jdkrdS|j|jd}|jr4|jn|j}||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. CharField TextFieldN)r&rq)rIrq)rr) r&r)rzrerZrssql_alter_column_nullsql_alter_column_not_nullrGrI)r,rr r"rr6rrrr+s    z/BaseDatabaseSchemaEditor._alter_column_null_sqlc Csz|j|}|j|}|g}|r$g}n|jjjr<|j|}g}|j|jd}|rT|jn|j} | |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. )r&rq)rIrqr) rurvr&r)rwrxrZsql_alter_column_no_defaultsql_alter_column_defaultrGrI) r,rr r"rrrr7rr6rrrrAs     z2BaseDatabaseSchemaEditor._alter_column_default_sqlcCs |j|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. )rIrq)sql_alter_column_typerGrI)r,rr r"rrrrr`s  z/BaseDatabaseSchemaEditor._alter_column_type_sqlcCs|jjjj|jjjjkr:|j|jj|jjjj|jjjj|j|jj|jjjj|j|jjjj|j|j|jj|jjjj|j|jjjj|jdS)z*Alter M2Ms to repoint their to= endpoints.N) r^rrr`rrrHm2m_reverse_field_namem2m_field_name)r,rr r"rrrrrusz,BaseDatabaseSchemaEditor._alter_many_to_manyr:c Cst|\}}dt|f|ddi|f}|jjjp6d}d|dj||f}t||kr\|St||dkr||d|d}|t|d d }d|d|dj|d||f}|d dks|d jrd |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&rFmax_name_lengthririsdigit) r, table_name column_namesrr Zhash_suffix_part max_lengthrZ other_lengthrrrrs    z+BaseDatabaseSchemaEditor._create_index_namecCsX|dkr:t|dkr*|djr*|dj}n|jjr:|jj}|dk rTd|jjj|SdS)NrrrLr:)rrjrr&rFrk)r,rrlrjrrr_get_index_tablespace_sqls z2BaseDatabaseSchemaEditor._get_index_tablespace_sql)rrusingrj col_suffixesr6 opclasses conditionc s~j|||d} dd|D} |p&j} |jj}fdd}t| t|jt|| |||j|| || | | rvd| nddS) 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, ...). )rjcSsg|] }|jqSr)rI)rrrrrrJsz>BaseDatabaseSchemaEditor._create_index_sql..csdkrj||jS)N)rrG)argskwargs)rr,rrcreate_index_names zEBaseDatabaseSchemaEditor._create_index_sql..create_index_namez WHERE r:)rTrrrmr8r) rsql_create_indexrr`rrrGr_index_columns)r,rrlrrrrjrr6rrrkrmrrTrr)rr,rrs   z*BaseDatabaseSchemaEditor._create_index_sqlcCs&t|p |jt|jj|j|j|dS)N)rTr)rrrrr`rG)r,rrr6rrrrsz*BaseDatabaseSchemaEditor._delete_index_sqlcCst|||j|dS)N)r)rrG)r,rTrmrrrrrrsz'BaseDatabaseSchemaEditor._index_columnscsjj sjjsjjrgSg}x"jjD]}|j|j|q,Wx8jjD],}fdd|D}|j|j |ddqPWx"jj D]}|j|j |qW|S)z Return a list of all index SQL statements (field indexes, index_together, Meta.indexes) for the specified model. csg|]}jj|qSr)rrH)rr)rrrrJsz?BaseDatabaseSchemaEditor._model_indexes_sql..r)r) rmanagedproxyswappedrXr]rindex_togetherr@rrr)r,routputrrrlrr)rrrsz+BaseDatabaseSchemaEditor._model_indexes_sqlcCs(g}|j||r$|j|j||g|S)zT Return a list of all index SQL statements for the specified field. )_field_should_be_indexedr@r)r,rrr!rrrrs z+BaseDatabaseSchemaEditor._field_indexes_sqlcCs|jo |j S)N)rr|)r,rrrrrr"sz1BaseDatabaseSchemaEditor._field_should_be_indexedcCs|j o |jS)N)r)r,r r"rrrrsz2BaseDatabaseSchemaEditor._field_became_primary_keycCs"|j r|jp |jo |j o |jS)N)r|r)r,r r"rrrrsz0BaseDatabaseSchemaEditor._unique_should_be_addedcCs*|j|j||j|j|j|j|dS)N)rTZ old_columnZ new_columnrq)sql_rename_columnrGrI)r,rTr r"rrrrrs   z*BaseDatabaseSchemaEditor._rename_field_sqlc Cst|jj|j}|j|||}t|jj|jg|j}t|jjjj|j}t|jjjj|jjg|j}|j j j } t |j |||||| dS)N)rTrrIrMrNr)rrr`rGrrrI target_fieldrr&rFrr sql_create_fk) r,rrrrTrrIrMrNrrrrrds z'BaseDatabaseSchemaEditor._create_fk_sqlcs<fdd}t|jj|jgt|jjjjd|jjg||S)Ncsjj||S)N)rGr)rr)r,rrcreate_fk_nameszDBaseDatabaseSchemaEditor._fk_constraint_name..create_fk_namer)rrr`rIr r$r)r,rrrr&r)r,rrs z,BaseDatabaseSchemaEditor._fk_constraint_namecCs|j|j||S)N)r sql_delete_fk)r,rrrrrr%sz'BaseDatabaseSchemaEditor._delete_fk_sqlcCs\|r*|j||||d}|r&|jj|dS|jddjt|j|i}|j|j||dS)N)rrrmz, )rrS)rWr.r@sql_unique_constraintrirBrGsql_constraint)r,rrlrrr6rSrrr _unique_sql(s z$BaseDatabaseSchemaEditor._unique_sqlcsfdd}t|jjj}|dkr8t|jj|d|}n j|}t||j}|rzjjjrvt j |||d|dSdSt j |||dSdS)Ncsjj||S)N)rGr)rr)r,rrcreate_unique_name9szGBaseDatabaseSchemaEditor._create_unique_sql..create_unique_nameZ_uniqz WHERE )rTrrmr)rTrrm) rrr`rGrrr&r)supports_partial_indexesrsql_create_unique_indexsql_create_unique)r,rrmrrr+rTr)r,rrW8s  &z+BaseDatabaseSchemaEditor._create_unique_sqlcCs2|r"|jjjr|j|j||SdS|j|j||S)N)r&r)r,rrr)r,rrrrrrrRsz+BaseDatabaseSchemaEditor._delete_unique_sqlcCs |j|j||jd|idS)NrK)rrS)r)rGr[)r,rrKrrr _check_sqlZsz#BaseDatabaseSchemaEditor._check_sqlcCs$t|jt|jj|j|j||dS)N)rTrrK)rsql_create_checkrrr`rG)r,rrrKrrrr`s z*BaseDatabaseSchemaEditor._create_check_sqlcCs|j|j||S)N)rsql_delete_check)r,rrrrrrhsz*BaseDatabaseSchemaEditor._delete_check_sqlcCs t|t|jj|j|j|dS)N)rTr)rrrr`rG)r,templaterrrrrrksz/BaseDatabaseSchemaEditor._delete_constraint_sqlc  s|dk rfdd|D}jj} jjj| |jj} WdQRXg} x| jD]\} }|dksn||dkrR|dk r|d|krqR|dk r|d|krqR|dk r|d|krqR|dk r|d|krqR|dk r|d  rqR|dk r|d |krqR| p| | krR| j| qRW| S) z@Return all constraint names matching the columns and conditions.Ncsg|]}jjj|qSr)r& introspectionidentifier_converter)rr)r,rrrJxsz>BaseDatabaseSchemaEditor._constraint_names..rmr|rrrKrrq)r&rDr3get_constraintsrr`itemsr@)r,rrr|rrrrKrrrDrgresultrZinfodictr)r,rrrs.  z*BaseDatabaseSchemaEditor._constraint_namescCsZ|j|dd}|r6t|dkr6tdt||jjfx|D]}|j|j||qrrrrr%,s  ; 1   7 * t            r%)loggingr!django.db.backends.ddl_referencesrrrrrdjango.db.backends.utilsrr django.db.modelsr django.db.transactionr r django.utilsr getLoggerr=rrr$r%rrrrs