U Ha@sddlZddlmZddlmZmZmZmZmZmZddl m Z m Z ddl m Z mZddlmZddlmZmZddlmZed Zd d Zd d ZddZGdddZdS)N)datetime)Columns ExpressionsForeignKeyName IndexName StatementTable) names_digestsplit_identifier) DeferrableIndex)Query)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-3jxiddxt/django/db/backends/base/schema.py_is_relevant_relations rcCs|jjddddS)NFT)ZforwardreverseZinclude_hidden)_metaZ _get_fieldsmodelrrr_all_related_fields srcs2tfddtjDfddtjDS)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 ZeZd ZdZdZdZdZdZdZdZdZeZdZeZdZdZdZeZdZ dZ!dZ"dZ#eZ$dZ%dd d!Z&d"d#Z'd$d%Z(dd'd(Z)d)d*Z*d+d,Z+dd-d.Z,d/d0Z-d1d2Z.d3d4Z/d5d6Z0e1d7d8Z2d9d:Z3d;d<Z4d=d>Z5d?d@Z6dAdBZ7dCdDZ8dEdFZ9dGdHZ:dIdJZ;dKdLZdQdRZ?dSdTZ@dUdVZAddWdXZBddYdZZCd[d\ZDdd]d^ZEd_d`ZFdadbZGdcddZHddfdgZIddhdiZJdjdkZKdldmZLdddededd&dd&ddddn dodpZMddqdrZNdsdtZOdudvZPdwdxZQdydzZRd{d|ZSd}d~ZTddZUddZVddZWddZXddZYddZZdddZ[dddZ\dddZ]ddZ^ddZ_ddZ`ddZadddZbdddZcddZdddZeddZfdddZgdS)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 DEFAULTz2ALTER COLUMN %(column)s TYPE %(type)s%(collation)sz4ALTER 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)sNzQCREATE INDEX %(name)s ON %(table)s (%(columns)s)%(include)s%(extra)s%(condition)szOCREATE UNIQUE INDEX %(name)s ON %(table)s (%(columns)s)%(include)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)rrrr__init__cs z!BaseDatabaseSchemaEditor.__init__cCs(g|_|jr$t|jj|_|j|Sr) deferred_sqlr-rr(alias __enter__r.rrrr2ls  z"BaseDatabaseSchemaEditor.__enter__cCs8|dkr|jD]}||q|jr4|j|||dSr)r0executer-r__exit__)r.exc_type exc_value tracebacksqlrrrr5ss   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))paramsr9)extra;N)r)r(Zin_atomic_blockr+r,rstrloggerdebugendswithr*appendtuplemap quote_valuecursorr4)r.r9r:ZendingrFrrrr4|s" z BaseDatabaseSchemaEditor.executecCs|jj|Sr)r(ops quote_name)r.rrrrrHsz#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_fieldcolumnr rrrr 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.rrrMs, css|]}|r|VqdSrrrUrrrr#sz5BaseDatabaseSchemaEditor.table_sql..)table definition) rZunique_togetherr0rB_create_unique_sql local_fields column_sql db_parametersr(sql_check_constraintZdb_type_suffixextend remote_field db_constraintrdb_tablerJ field_namerKsql_create_inline_fkrHr+supports_foreign_keys_create_fk_sqlget_internal_typerG autoinc_sql constraintssql_create_tablejoin db_tablespacetablespace_sql)r.rfieldscolumnsZ column_sqlsr:rrZZ extra_params db_paramsZcol_type_suffixrRrSrirjr9rnrrWr table_sqlsX          z"BaseDatabaseSchemaEditor.table_sqlc Csj|j|jd}|d}g}|dkr&dSt|dd}|rD|||7}|j}|oh|| oh|of|| }|r||} d||} | dk r|jj j r|| | | 7}n|| 7}|| g7}|j r|j s|jj jrd}|r|jj js|d7}n |s|d 7}|j r|d 7}n|jr|d 7}|jp,|jj} | rb|jj jrb|jrb|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. rNtypeN)NN db_collationz DEFAULT Tz NULLz NOT NULLz PRIMARY KEYz UNIQUErQ)inline)r^r(getattr _collate_sqlnull skip_defaultskip_default_on_altereffective_default_column_default_sqlr+requires_literal_defaultsprepare_defaultempty_strings_allowedr!interprets_empty_strings_as_nullsZimplied_column_nulluniquermrZsupports_tablespacesrGrn) r.rrinclude_defaultrqr9r: collationrx default_valueZcolumn_defaultZ tablespacerrrr]sL        z#BaseDatabaseSchemaEditor.column_sqlcCsdS)z Some backends don't accept default values for certain columns types (i.e. MySQL longtext and longblob). Frr.rrrrry sz%BaseDatabaseSchemaEditor.skip_defaultcCsdS)z Some backends don't accept default values for certain columns types (i.e. MySQL longtext and longblob) in the ALTER COLUMN statement. Frrrrrrzsz.BaseDatabaseSchemaEditor.skip_default_on_altercCs 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.valuerrrr~sz(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. %srrrrrr|$sz,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_defaultrxblankrrhrvrnowdatetimer)rdefaultZ internal_typerrr_effective_default+s"     z+BaseDatabaseSchemaEditor._effective_defaultcCs||||jS)z2Return a field's effective database default value.)Zget_db_prep_saverr(rrrrr{Bsz*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). NrrrrrrEFsz$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) rrr4r0r`_model_indexes_sqlrlocal_many_to_manyrathrough auto_created create_model)r.rr9r:rrrrrRs   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.rYN)rrrarr delete_modelr4sql_delete_tablerHrclistr0 isinstancerZreferences_tableremove)r.rrr9rrrrcs   z%BaseDatabaseSchemaEditor.delete_modelcCs.|jr|jjjsdS|j|||dddS)zAdd an index on a model.Nr:)contains_expressionsr(r+supports_expression_indexesr4 create_sqlr.rindexrrr add_indexss z"BaseDatabaseSchemaEditor.add_indexcCs*|jr|jjjsdS||||dS)zRemove an index from a model.N)rr(r+rr4 remove_sqlrrrr remove_index~s z%BaseDatabaseSchemaEditor.remove_indexcCs"|||}|r|j|dddS)zAdd a constraint to a model.Nr)rr4r.rrVr9rrradd_constraints z'BaseDatabaseSchemaEditor.add_constraintcCs|||}|r||dS)z!Remove a constraint from a model.N)rr4rrrrremove_constraints 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|qSrrCr rorrr szABaseDatabaseSchemaEditor.alter_unique_together..cSsh|] }t|qSrrrrrrrsrTcsg|]}j|jqSrrIrLrrrrMszBBaseDatabaseSchemaEditor.alter_unique_together..N) difference_delete_composed_indexsql_delete_uniquer4r[)r.rZold_unique_togetherZnew_unique_togetheroldsnewsrorprrralter_unique_togethersz.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)rrcsg|]}j|qSrrrJrLrrrrMszABaseDatabaseSchemaEditor.alter_index_together.._idxrosuffixN)rrsql_delete_indexr4_create_index_sql)r.rZold_index_togetherZnew_index_togetherrrro field_namesrrralter_index_togethersz-BaseDatabaseSchemaEditor.alter_index_togetherc sddjjD}ddjjD}fdd|D}|j|fd||Bi|}t|dkr~tdt|jjd |f|| ||d dS) NcSsh|] }|jqSrrrUrrrrszBBaseDatabaseSchemaEditor._delete_composed_index..cSsh|] }|jqSrrrUrrrrscsg|]}j|jqSrrIrLrrrrMszCBaseDatabaseSchemaEditor._delete_composed_index..excludez1Found wrong number (%s) of constraints for %s(%s)rXr) rrjindexes_constraint_nameslen ValueErrorrcrlr4_delete_constraint_sql) r.rroZconstraint_kwargsr9meta_constraint_namesmeta_index_namesrpconstraint_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_caselowerr4sql_rename_tablerHr0rrZrename_table_references)r.rZ old_db_tableZ new_db_tabler9rrralter_db_tables   z'BaseDatabaseSchemaEditor.alter_db_tablecCs2||j||jj||||ddS)z)Move a model's table between tablespaces.)rYZold_tablespaceZnew_tablespaceN)r4sql_retablespace_tablerHrrc)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)rNrNrOrPrTz%s.r=)r namespacerKrRrS deferrable)rYrKrZdroprYchanges)%rrarrrrr]r^r(r_r+rfrbsql_create_column_inline_fkrrcrJrdrKr _fk_constraint_namerHrGdeferrable_sqlr0rBrgsql_create_columnr4rzr{_alter_column_default_sqlsql_alter_columnr`_field_indexes_sqlconnection_persists_old_columnsclose) r.rrrZr:rqZconstraint_suffixrRrSr_r9 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. rNrsNT foreign_key)rYrK)rrarrrrr^r(rrKr4_delete_fk_sqlsql_delete_columnrHrcr+rrrr0rrZreferences_columnr)r.rrfk_namesfk_namer9rrr remove_fields$     z%BaseDatabaseSchemaEditor.remove_fieldc Cs6|||sdS|j|jd}|d}|j|jd}|d}|dkrN|jdks`|dkrr|jdkrrtd||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. NrNrszqCannot 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)) _field_should_be_alteredr^r(rarrrr_alter_many_to_many _alter_field) r.rr"r$strict old_db_paramsold_type new_db_paramsnew_typerrr alter_field8s^     z$BaseDatabaseSchemaEditor.alter_fieldc )Cst} |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}t"|dd}t"|dd}||kr:|#||||}|$|n2||krl|%||||\}}|$||&|d}|j'r|j's|(|}|(|} |)|s|| kr| dk rd}|$|*||||j'|j'kr|+|||}|r|$||,o|j'o|j' }!|s|r|!s,||}|jjj-rd|rdt.t/|\}}"d0|t1|"gfg}|D],\}}"| |j2|3|j j |d|"qh|!r| |j4|3|j j |3|jdd| g|D],\}}"| |j2|3|j j |d|"q|r|D]\}}"| ||"q|jr:|js:|5|||6||r^| |7||jg|jrn|jr|jr|js| |j8||gdg}#|r|#&t|||||r| |9|||#&t|||#D]\}$}|jj:|jd}%|%d}&|%|j|$j|j|&\}}| |j2|3|jj j |dd|d|D]\}}"| ||"qLq|jjjr|jr| s|jr|js|jr| |;||d|r|j|'|r|'jjr| |;|'j|'jdq|d |d kr@|d r@|j?|j j |jgdd}| |@|||d |r|j*|||dd\}(}"|j2|3|j j |(d}| ||"|jjjAr|jBdS)z3Perform a "physical" (non-ManyToMany) field update.Trrz.F)rrrz7Found wrong number (%s) of unique constraints for %s.%scSsh|] }|jqSrr)r rrrrrs)rtype_rrOcSsh|] }|jqSrrrUrrrrs)rOrz6Found wrong number (%s) of check constraints for %s.%srtNrXrr)rYrKrrorNrsrrTZ_fk_checkrr)Csetr(r+rfrarbrrKrrrrcaddr4rr_field_became_primary_keyrj_delete_unique_sqlrr&Z related_modelrdb_indexrr r_delete_index_sql_delete_check_sql_rename_field_sqlr0rrZrename_column_referencesrv_alter_column_collation_sqlrB_alter_column_type_sqlr`rxr{rzr_alter_column_null_sqlrZsupports_combined_altersrCr%rlsumrrHsql_update_with_default_delete_primary_key_unique_should_be_addedr[r_create_primary_key_sqlr^rgrZrelated_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_namer9actionsZ null_actionsZ post_actionsZ old_collation new_collationfragmentZ other_actionsZneeds_database_defaultZ old_default new_defaultZfour_way_default_alterationr:Zrels_to_updateZold_relZ rel_db_paramsZrel_typerelrrrrrcs                               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 TextFieldNrNrsrKrs) r(r+rrhr^rxsql_alter_column_nullsql_alter_column_not_nullrHrK)r.rr"r$rr9rrrrbs   z/BaseDatabaseSchemaEditor._alter_column_null_sqlc Cs||}||}|g}|r$g}n|jjjr<||}g}|j|jd}|rd|jr\|j} qj|j } n|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. rNrs)rKrsr) r{r|r(r+r}r~r^rx sql_alter_column_no_default_nullsql_alter_column_no_defaultsql_alter_column_defaultrHrK) r.rr"r$rrrr:rr9rrrrxs*     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_typerHrK)r.rr"r$rrrrrs  z/BaseDatabaseSchemaEditor._alter_column_type_sqlcCs,|j||j||r||nddgfS)Nr=)rKrsr)sql_alter_column_collaterHrKrw)r.rr$rrrrrrs z4BaseDatabaseSchemaEditor._alter_column_collation_sqlcCs|jjjj|jjjjkr:||jj|jjjj|jjjj||jj|jjj||jjj|||jj|jjj||jjj|dS)z*Alter M2Ms to repoint their to= endpoints.N) rarrrcrrrJZm2m_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 r r(rGZmax_name_lengthrlrisdigit) 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)NrrrPr=)rrmrr(rGrn)r.rrormrrr_get_index_tablespace_sqls z2BaseDatabaseSchemaEditor._get_index_tablespace_sqlcCs|r d|SdS)Nz WHERE r=r)r. conditionrrr_index_condition_sqlsz-BaseDatabaseSchemaEditor._index_condition_sqlcCs,|r|jjjsdStdt|jj||jdS)Nr=z INCLUDE (%(columns)s))rp)r(r+supports_covering_indexesrrrrcrH)r.rrprrr_index_include_sqls z+BaseDatabaseSchemaEditor._index_include_sql) rorrusingrm col_suffixesr9 opclassesrinclude expressionsc  s|pg}| pg} t|ddjjd} j|||d}dd|D}|pLj}|jj}fdd}t|t|j t ||||||r |||| nt || | j || || d S) z Return the SQL statement to create the index for one or several fields or expressions. `sql` can be specified if the syntax differs from the standard (GIS indexes, ...). F)Z alias_colsrN)rmcSsg|] }|jqSr)rKrLrrrrMsz>BaseDatabaseSchemaEditor._create_index_sql..csdkrj||Sr)rrHargskwargsrr.rrcreate_index_names zEBaseDatabaseSchemaEditor._create_index_sql..create_index_name)rYrr rpr;rr#)r Z get_compilerr(rsql_create_indexrrcrrrHr_index_columnsrrErr)r.rrorrr rmr!r9r"rr#r$compilerrnrpr*rYr)rr(rrs,     z*BaseDatabaseSchemaEditor._create_index_sqlcCs&t|p |jt|jj|j||dSN)rYr)rrrrrcrH)r.rrr9rrrr,s z*BaseDatabaseSchemaEditor._delete_index_sqlcCst|||j|dS)N)r!)rrH)r.rYrpr!r"rrrr+3sz'BaseDatabaseSchemaEditor._index_columnscsjjrjjsjjrgSg}jjD]}|||q(jjD],}fdd|D}||j |ddqHjj D]&}|j r|j j jr~|||q~|S)z Return a list of all index SQL statements (field indexes, index_together, Meta.indexes) for the specified model. csg|]}j|qSrrrLrrrrMBsz?BaseDatabaseSchemaEditor._model_indexes_sql..rr)rZmanagedproxyZswappedr\r`rZindex_togetherrBrrrr(r+rr)r.routputrrrorrrrr6s   z+BaseDatabaseSchemaEditor._model_indexes_sqlcCs*g}|||r&||j||gd|S)zT Return a list of all index SQL statements for the specified field. r)_field_should_be_indexedrBr)r.rrr/rrrrMs z+BaseDatabaseSchemaEditor._field_indexes_sqlc Cs|\}}}}|\}}}} ddddddddd d d g } | D]} || d| | dq>||j||jkp|||f||| fkS) NrZ db_columneditableZerror_messages help_textZlimit_choices_toZ on_deleteZ related_nameZrelated_query_nameZ validatorsZ verbose_name)Z deconstructpoprHrK) r.r"r$rold_pathZold_argsZ old_kwargsnew_pathnew_argsZ new_kwargsZnon_database_attrsattrrrrrVs( z1BaseDatabaseSchemaEditor._field_should_be_alteredcCs|jo |j Sr)rrr.rrrrrr0ssz1BaseDatabaseSchemaEditor._field_should_be_indexedcCs|j o |jSrrr.r"r$rrrrvsz2BaseDatabaseSchemaEditor._field_became_primary_keycCs"|j r|jp |jo |j o |jSr)rrr:rrrrysz0BaseDatabaseSchemaEditor._unique_should_be_addedcCs*|j||||j||j|dS)N)rYZ old_columnZ new_columnrs)sql_rename_columnrHrK)r.rYr"r$rrrrr~s   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)rYrrKrRrSr)rrrcrHrrrK target_fieldrr(rGrr sql_create_fk) r.rrrrYrrKrRrSrrrrrgs z'BaseDatabaseSchemaEditor._create_fk_sqlcs<fdd}t|jj|jgt|jjjjd|jjg||S)Ncsj||SrrHrr%r3rrcreate_fk_nameszDBaseDatabaseSchemaEditor._fk_constraint_name..create_fk_namer)rrrcrKr r<r)r.rrrr?rr3rrs z,BaseDatabaseSchemaEditor._fk_constraint_namecCs||j||Sr)r sql_delete_fkr.rrrrrrsz'BaseDatabaseSchemaEditor._delete_fk_sqlcCs,|dkr dS|tjkrdS|tjkr(dSdS)Nr=z DEFERRABLE INITIALLY DEFERREDz DEFERRABLE INITIALLY IMMEDIATE)r ZDEFERREDZ IMMEDIATE)r.rrrr_deferrable_constraint_sqls   z3BaseDatabaseSchemaEditor._deferrable_constraint_sqlc Cs|r|jjjsdS|s|s|rH|j||||||d}|rD|j|dS|jdt|j || |d} |j | || dS)N)rrr#r"rX)rprrrV) r(r+&supports_deferrable_unique_constraintsr[r0rBsql_unique_constraintrlrDrHrBsql_constraint) r.rrorrrr#r"r9rVrrr _unique_sqls2  z$BaseDatabaseSchemaEditor._unique_sqlc s|rjjjr*|rjjjr*|r.jjjs.dSfdd}t|jjj} |dkrft |jj|d|}n |}j | |d|d}|s|s|rj } nj } t | | ||||||dS)Ncsj||Srr>r%r3rrcreate_unique_nameszGBaseDatabaseSchemaEditor._create_unique_sql..create_unique_name_uniqr)r!r")rYrrprrr#)r(r+rDsupports_partial_indexesrrrrcrHrr+sql_create_unique_indexsql_create_uniquerrrBr) r.rrprrrr#r"rHrYr9rr3rr[s>    z+BaseDatabaseSchemaEditor._create_unique_sqlcCsV|r|jjjr*|r|jjjr*|r.|jjjs.dS|s:|s:|rB|j}n|j}||||Sr)r(r+rDrJrrrr)r.rrrrr#r"r9rrrrs" z+BaseDatabaseSchemaEditor._delete_unique_sqlcCs |j|||jd|idS)NrOrC)rFrHr_)r.rrOrrr _check_sqls z#BaseDatabaseSchemaEditor._check_sqlcCs$t|jt|jj|j|||dS)N)rYrrO)rsql_create_checkrrrcrH)r.rrrOrrrr s z*BaseDatabaseSchemaEditor._create_check_sqlcCs||j||Sr)rsql_delete_checkrArrrrsz*BaseDatabaseSchemaEditor._delete_check_sqlcCs t|t|jj|j||dSr-)rrrrcrH)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)r rr3rrrM$sz>BaseDatabaseSchemaEditor._constraint_names..rprrrrOrrs)r(rFrQZget_constraintsrrcitemsrB)r.rrrrrrrOrrrFrjresultrZinfodictrr3rrs0    z*BaseDatabaseSchemaEditor._constraint_namescCsV|j|dd}|r6t|dkr6tdt||jjf|D]}||||q:dS)NTr9rz0Found wrong number (%s) of PK constraints for %s)rrrrrcr4_delete_primary_key_sql)r.rrrrrrrr=sz,BaseDatabaseSchemaEditor._delete_primary_keyc CsJt|jt|jj|j||j|jj|jgddt|jj|jg|jdS)NZ_pkr)rYrrp) r sql_create_pkrrrcrHrrKrr8rrrrGsz0BaseDatabaseSchemaEditor._create_primary_key_sqlcCs||j||Sr)r sql_delete_pkrArrrrTQsz0BaseDatabaseSchemaEditor._delete_primary_key_sqlcCsd||S)Nz COLLATE )rH)r.rrrrrwTsz%BaseDatabaseSchemaEditor._collate_sqlcCs*|j||d|d}||dS)N,)Z procedure param_types)sql_delete_procedurerHrlr4)r.Zprocedure_namerXr9rrrremove_procedureWs z)BaseDatabaseSchemaEditor.remove_procedure)FT)r)F)F)F)F)r=)N)N)NNNN)NNNNN)NNNN)NNNNNNNN)F)r)h__name__ __module__ __qualname____doc__rkrrrrrrr r rrr rrr;rrEr_Zsql_delete_constraintrFrNrOrLrr=rerr@r*rKrrUrVrYr/r2r5r4rHrrr]ryrzr~r| staticmethodrr{rErrrrrrrrrrrrrrrrrrrrrrrrrrr+rrrr0rrrrgrrrBrGr[rrMrrrrrrrTrwrZrrrrr'-s   ; <     9 ,  %    '     ! &    r')loggingrZ!django.db.backends.ddl_referencesrrrrrrZdjango.db.backends.utilsr r Zdjango.db.modelsr r Zdjango.db.models.sqlr Zdjango.db.transactionrrZ django.utilsr getLoggerr?rrr&r'rrrrs