3 7^@sddlZddlmZddlmZmZmZmZmZddlm Z m Z ddl m Z ddl mZmZddlmZejdZd d Zd d ZGd ddZdS)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_keyZ to_fieldsname)ZrelationZ altered_fieldrr@/tmp/pip-build-8app2_gc/Django/django/db/backends/base/schema.py_is_relevant_relations rcs2tfddjjjDfddjjjDS)Nc3s|]}t|r|VqdS)N)r).0obj) old_fieldrr #sz+_related_non_m2m_objects..c3s|]}t|r|VqdS)N)r)rr) new_fieldrrr$s)zipmodel_metarelated_objects)rrr)rrr_related_non_m2m_objectssrc @s|eZdZdZdZdZdZdZdZdZ dZ d Z d Z d Z d Zd ZdZdZdZdZdZdZdZeZdZeZdZdZeZdZdZdZdZ eZ!dZ"ddd Z#d!d"Z$d#d$Z%ffd%d&Z&d'd(Z'dd)d*Z(d+d,Z)d-d.Z*e+d/d0Z,d1d2Z-d3d4Z.d5d6Z/d7d8Z0d9d:Z1d;d<Z2d=d>Z3d?d@Z4dAdBZ5dCdDZ6dEdFZ7dGdHZ8dIdJZ9dKdLZ:dMdNZ;ddOdPZddUdVZ?dWdXZ@dYdZZAdd\d]ZBdd^d_ZCdd[d[dfdfdd`dadbZDdcddZEdedfZFdgdhZGdidjZHdkdlZIdmdnZJdodpZKdqdrZLdsdtZMdudvZNddwdxZOddydzZPdd{d|ZQd}d~ZRddZSddZTddZUdddZVdddZWddZXddZYffddZZdS)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&rrrr*ds  z"BaseDatabaseSchemaEditor.__enter__cCs<|dkr"x|jD]}|j|qW|jr8|jj|||dS)N)r(executer%r __exit__)r&exc_type exc_value tracebacksqlrrrr,ks  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))paramsr0)extra;N)r!r Zin_atomic_blockr#r$r strloggerdebugendswithr"appendtuplemap quote_valuecursorr+)r&r0r1Zendingr=rrrr+ts" z BaseDatabaseSchemaEditor.executecCs|jjj|S)N)r ops quote_name)r&rrrrr?sz#BaseDatabaseSchemaEditor.quote_namec Cs,|j|jd}|d}g}|dkr&d S|j}|o:|j| }|r|j|}|dk r|jjjrp|d|j|7}n|d7}||g7}|jr|j r|jjj rd}|r|jjj r|d7}n |s|d7}|j r|d7}n|j r|d 7}|j p|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 typeNz DEFAULT %sTz NULLz NOT NULLz PRIMARY KEYz UNIQUEz %s)inline)NN) db_parametersr null skip_defaulteffective_defaultr#requires_literal_defaultsprepare_defaultempty_strings_allowedr!interprets_empty_strings_as_nullsZimplied_column_nullunique db_tablespacerZsupports_tablespacesr>tablespace_sql) r&rrinclude_default db_paramsr0r1rC 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). Fr)r&rrrrrDsz%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&valuerrrrGsz(BaseDatabaseSchemaEditor.prepare_defaultcCs|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)NZ BinaryFieldZauto_nowFZ auto_now_addZ DateFieldZ TimeFieldZ DateTimeField) has_default get_defaultrCZblankrHget_internal_typebytesr5getattrrnowdatetimer )rdefaultZ internal_typerrr_effective_defaults"     z+BaseDatabaseSchemaEditor._effective_defaultcCs|j|j||jS)z2Return a field's effective database default value.)Zget_db_prep_saver\r )r&rrrrrEsz*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)rQ)r&rRrrrr<sz$BaseDatabaseSchemaEditor.quote_valuecsTg}g}xBjjD]4}j|\}}|dkr4q|jjd}|dr\|dj|7}|jjd}|rz|d|7}|j||jr|j r|jj jj } |jj jj |jj j} jr|djj| j| d7}n jjjrjjj|d|jdj|j|f|jdkrjjjjj |j} | rjj| qWx8jjD],} fd d | D} jjj| qXWfd d jjD}jjjj djdd||Dd}jjrjjjjj}|r|d|7}j ||p djjj!x.jj"D]"}|jj#jj$r*j%|jj#q*WdS)zr Create a table and any accompanying indexes or unique constraints for the given `model`. N)r check z %s)to_table to_columnz_fk_%(to_table)s_%(to_column)sz%s %s AutoField BigAutoFieldcsg|]}jj|jqSr)r get_fieldcolumn)rr)rrr &sz9BaseDatabaseSchemaEditor.create_model..csg|]}|jqSr)Zconstraint_sql)r constraint)rr&rrre(sz, css|]}|r|VqdS)Nr)rrfrrrr,sz8BaseDatabaseSchemaEditor.create_model..)table definition)rarb)&r local_fieldsrPrBr sql_check_constraintZdb_type_suffixextend remote_field db_constraintrdb_tablerc field_namerdsql_create_inline_fkr?r#supports_foreign_keysr(r9_create_fk_sqlrUr> autoinc_sqlZunique_together_create_unique_sql constraintssql_create_tablejoinrKrLr+_model_indexes_sqllocal_many_to_manythrough auto_created create_model)r&rZ column_sqlsr1rrhZ extra_paramsrNZcol_type_suffixr_r`rsfieldscolumnsrur0rLr)rr&rr|sZ           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.rgN)rryrlrzr{ delete_modelr+sql_delete_tabler?rnlistr( isinstancerZreferences_tableremove)r&rrr0rrrr=s z%BaseDatabaseSchemaEditor.delete_modelcCs|j|j||dddS)zAdd an index on a model.N)r1)r+ create_sql)r&rindexrrr add_indexMsz"BaseDatabaseSchemaEditor.add_indexcCs|j|j||dS)zRemove an index from a model.N)r+ remove_sql)r&rrrrr remove_indexQsz%BaseDatabaseSchemaEditor.remove_indexcCs|j||}|r|j|dS)z"Add a check constraint to a model.N)rr+)r&rrfr0rrradd_constraintUs z'BaseDatabaseSchemaEditor.add_constraintcCs|j||}|r|j|dS)z'Remove a check constraint from a model.N)rr+)r&rrfr0rrrremove_constraint[s 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)r:)rr}rrr gszABaseDatabaseSchemaEditor.alter_unique_together..cSsh|] }t|qSr)r:)rr}rrrrhsrJTcsg|]}jj|jqSr)rrcrd)rr)rrrrenszBBaseDatabaseSchemaEditor.alter_unique_together..N) difference_delete_composed_indexsql_delete_uniquer+rt)r&rZold_unique_togetherZnew_unique_togetheroldsnewsr}r~r)rralter_unique_togetherasz.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)r:)rr}rrrrwsz@BaseDatabaseSchemaEditor.alter_index_together..cSsh|] }t|qSr)r:)rr}rrrrxsrTcsg|]}jj|qSr)rrc)rr)rrrre~szABaseDatabaseSchemaEditor.alter_index_together.._idx)suffixN)rrsql_delete_indexr+_create_index_sql)r&rZold_index_togetherZnew_index_togetherrrr} field_namesr)rralter_index_togetherqsz-BaseDatabaseSchemaEditor.alter_index_togetherc sddjjD}ddjjD}fdd|D}|j|fd||Bi|}t|dkr~tdt|jjd j|f|j|j ||d dS) NcSsh|] }|jqSr)r)rrfrrrrszBBaseDatabaseSchemaEditor._delete_composed_index..cSsh|] }|jqSr)r)rrfrrrrscsg|]}jj|jqSr)rrcrd)rr)rrrreszCBaseDatabaseSchemaEditor._delete_composed_index..excludez1Found wrong number (%s) of constraints for %s(%s)z, r) rruindexes_constraint_nameslen ValueErrorrnrwr+_delete_constraint_sql) r&rr}Zconstraint_kwargsr0meta_constraint_namesmeta_index_namesr~constraint_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#Zignores_table_name_caselowerr+sql_rename_tabler?r(rrZrename_table_references)r&rZ old_db_tableZ new_db_tabler0rrralter_db_tables   z'BaseDatabaseSchemaEditor.alter_db_tablecCs2|j|j|j|jj|j||j|ddS)z)Move a model's table between tablespaces.)rgZold_tablespaceZnew_tablespaceN)r+sql_retablespace_tabler?rrn)r&rZold_db_tablespaceZnew_db_tablespacerrralter_db_tablespaces z,BaseDatabaseSchemaEditor.alter_db_tablespacecCsN|jr |jjjjr |j|jjS|j||dd\}}|dkr@dS|j|jd}|drh|d|j |7}|j |j |jj |j |j |d}|j|||j| r|j|dk r|j|d|dd\}}|j|j |jj |d }|j|||jj|j|||jr4|jjjr4|jr4|jj|j||d |jjjrJ|jjdS) z Create a field on a model. Usually involves adding a column, but may involve adding a table instead (for M2M fields). T)rMN)r r]r^)rgrdrh)drop)rgchangesz_fk_%(to_table)s_%(to_column)s)rrlrzrr{r|rPrBr rjsql_create_columnr?rnrdr+rDrE_alter_column_default_sqlsql_alter_columnr(rk_field_indexes_sqlr#rqrmr9rrconnection_persists_old_columnsclose)r&rrrhr1rNr0 changes_sqlrrr add_fields0        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 r@NT) foreign_key)rgrd)rrlrzrr{rrBr rrdr+_delete_fk_sqlsql_delete_columnr?rnr#rrrr(rrZreferences_columnr)r&rrfk_namesfk_namer0rrr 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 r@NzqCannot 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)) rBr rlrrzrr{_alter_many_to_many _alter_field) r&rrrstrict old_db_paramsold_type new_db_paramsnew_typerrr alter_fields2    z$BaseDatabaseSchemaEditor.alter_fieldc 'Cst} |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}!|jr|jr||kr|!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| s|j s|j r|jr|j |j8||d|rxB|j9jj:D]4}%t;|%|r|%jjr|j |j8|%j|%jdqW|d |d kr4|d r4|j<|jj|jgdd}|j |j=|||d |rv|j%|||dd\}&} |j/|j0|jj|&d}|j || |j(j)j>r|j(j?dS)z3Perform a "physical" (non-ManyToMany) field update.T)rrz.F)rJrrz7Found wrong number (%s) of unique constraints for %s.%scSsh|] }|jqSr)r)rrrrrrVs)rtype_rr]cSsh|] }|jqSr)r)rrfrrrrds)r]rz6Found wrong number (%s) of check constraints for %s.%sNz, )rgrz%s)rgrdr[)r r@rz_fk_%(to_table)s_%(to_column)sZ_fk_check)r)r)@setrlrmrrdrrrrnaddr+rrJ_field_became_primary_keyru_delete_unique_sqlrrZ related_modelrdb_indexrr r_delete_index_sql_delete_check_sql_rename_field_sqlr(rrZrename_column_references_alter_column_type_sqlr9rkrErCrDr_alter_column_null_sqlrSr r#Zsupports_combined_altersr:rrwsumrr?sql_update_with_default_delete_primary_key_unique_should_be_addedrtr_create_primary_key_sqlrBrrrrr_create_index_name_create_check_sqlrr)'r&rrrrrrrrZ fks_droppedrrrrconstraint_nameZdrop_foreign_keysZ_old_relZnew_relZ rel_fk_namesrZ index_names index_namer0actionsZ null_actionsZ post_actionsfragmentZ other_actionsZ old_default new_defaultZneeds_database_defaultZfour_way_default_alterationr1Zrels_to_updateZold_relZ rel_db_paramsZrel_typerelrrrrrs*        $                          $      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 r@)rdr@)rr) r r#rIrUrBrCsql_alter_column_nullsql_alter_column_not_nullr?rd)r&rrrrr0rrrr s    z/BaseDatabaseSchemaEditor._alter_column_null_sqlc Cst|j|}d}|g}|rg}n|jjjr6|j|}g}|j|jd}|rN|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. z%s)r r@)rdr@r[) rEr r#rFrGrBsql_alter_column_no_defaultsql_alter_column_defaultr?rd) r&rrrrrr[r1rr0rrrr#s    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. )rdr@)sql_alter_column_typer?rd)r&rrrrrrrrBs  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) rlrzrrnrrrcZm2m_reverse_field_nameZm2m_field_name)r&rrrrrrrrWsz,BaseDatabaseSchemaEditor._alter_many_to_manyr4c 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 r>Zmax_name_lengthrwrisdigit) r&Z table_name column_namesrrZhash_suffix_part max_lengthrZ other_lengthrrrrls    z+BaseDatabaseSchemaEditor._create_index_namecCsX|dkr:t|dkr*|djr*|dj}n|jjr:|jj}|dk rTd|jjj|SdS)Nrrr^r4)rrKrr r>rL)r&rr}rKrrr_get_index_tablespace_sqls z2BaseDatabaseSchemaEditor._get_index_tablespace_sql)rrusingrK col_suffixesr0 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, ...). )rKcSsg|] }|jqSr)rd)rrrrrresz>BaseDatabaseSchemaEditor._create_index_sql..csdkrj||jS)N)rr?)argskwargs)rr&rrcreate_index_names zEBaseDatabaseSchemaEditor._create_index_sql..create_index_namez WHERE r4)rgrrr~r2r) rsql_create_indexrrnrrr?r_index_columns)r&rr}rrrrKrr0rrrLr~rrgrr)rr&rrs   z*BaseDatabaseSchemaEditor._create_index_sqlcCs"t|jt|jj|j|j|dS)N)rgr)rrrrrnr?)r&rrrrrrsz*BaseDatabaseSchemaEditor._delete_index_sqlcCst|||j|dS)N)r)rr?)r&rgr~rrrrrrsz'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)rrc)rr)rrrresz?BaseDatabaseSchemaEditor._model_indexes_sql..r)r) rZmanagedproxyZswappedrirkrZindex_togetherr9rrr)r&routputrrr}rr)rrrxsz+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_indexedr9r)r&rrrrrrrs z+BaseDatabaseSchemaEditor._field_indexes_sqlcCs|jo |j S)N)rrJ)r&rrrrrrsz1BaseDatabaseSchemaEditor._field_should_be_indexedcCs|j o |jS)N)r)r&rrrrrrsz2BaseDatabaseSchemaEditor._field_became_primary_keycCs"|j r|jp |jo |j o |jS)N)rJr)r&rrrrrrsz0BaseDatabaseSchemaEditor._unique_should_be_addedcCs*|j|j||j|j|j|j|dS)N)rgZ old_columnZ new_columnr@)sql_rename_columnr?rd)r&rgrrrrrrrs   z*BaseDatabaseSchemaEditor._rename_field_sqlc sfdd}t|jjj}t|jj|jgt|jjjjd|jjg||}t |jj|jgj}t|jjjjj}t |jjjj|jjgj} j j j } t j||||| | dS)Ncsjj||S)N)r?r)rr)r&rrcreate_fk_namesz?BaseDatabaseSchemaEditor._create_fk_sql..create_fk_namer)rgrrdr_r` deferrable)rrrnr?rrdr Z target_fieldrrr r>Zdeferrable_sqlr sql_create_fk) r&rrrrrgrrdr_r`rr)r&rrrs*  z'BaseDatabaseSchemaEditor._create_fk_sqlcCs|j|j||S)N)r sql_delete_fk)r&rrrrrrsz'BaseDatabaseSchemaEditor._delete_fk_sqlcCs\|r*|j||||d}|r&|jj|dS|jddjt|j|i}|j|j||dS)N)rrr~z, )rrf)rtr(r9sql_unique_constraintrwr;r?sql_constraint)r&rr}rrr0rfrrr _unique_sqls z$BaseDatabaseSchemaEditor._unique_sqlcsfdd}t|jjj}|dkr8t|jj|d|}n j|}t||j}|rzjjjrvt j |||d|dSdSt j |||dSdS)Ncsjj||S)N)r?r)rr)r&rrcreate_unique_nameszGBaseDatabaseSchemaEditor._create_unique_sql..create_unique_nameZ_uniqz WHERE )rgrr~r)rgrr~) rrrnr?rrr r#supports_partial_indexesrsql_create_unique_indexsql_create_unique)r&rr~rrrrgr)r&rrts  &z+BaseDatabaseSchemaEditor._create_unique_sqlcCs2|r"|jjjr|j|j||SdS|j|j||S)N)r r#rrrr)r&rrrrrrr1sz+BaseDatabaseSchemaEditor._delete_unique_sqlcCs |j|j||jd|idS)Nr])rrf)rr?rj)r&rr]rrr _check_sql9sz#BaseDatabaseSchemaEditor._check_sqlcCs$t|jt|jj|j|j||dS)N)rgrr])rsql_create_checkrrrnr?)r&rrr]rrrr?s z*BaseDatabaseSchemaEditor._create_check_sqlcCs|j|j||S)N)rsql_delete_check)r&rrrrrrGsz*BaseDatabaseSchemaEditor._delete_check_sqlcCs t|t|jj|j|j|dS)N)rgr)rrrrnr?)r&templaterrrrrrJsz/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 introspectionZidentifier_converter)rr)r&rrreWsz>BaseDatabaseSchemaEditor._constraint_names..r~rJrrr]rr@)r r=rZget_constraintsrrnitemsr9)r&rrrJrrrr]rrr=ruresultrZinfodictr)r&rrQs.  z*BaseDatabaseSchemaEditor._constraint_namescCsZ|j|dd}|r6t|dkr6tdt||jjfx|D]}|j|j||qs