a Ebj@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|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_fieldrr^/home/ja/django-apps/lartica_env/lib/python3.9/site-packages/django/db/backends/base/schema.py_is_relevant_relations rcCs|jjdddddS)NFT)forwardreverseZinclude_hiddenZinclude_parents)_metaZ _get_fieldsmodelrrr_all_related_fields%s rc#sbtfddtjDfddtjD}|D]&\}}||fVt|j|jEdHq6dS)Nc3s|]}t|r|VqdSNr.0obj) old_fieldrr 2s z+_related_non_m2m_objects..c3s|]}t|r|VqdSrrr ) new_fieldrrr$7s )ziprr_related_non_m2m_objects remote_field)r#r%Zrelated_fieldsold_relnew_relr)r%r#rr'.s    r'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+d-d.Z,dd/d0Z-d1d2Z.d3d4Z/d5d6Z0d7d8Z1e2d9d:Z3d;d<Z4d=d>Z5d?d@Z6dAdBZ7dCdDZ8dEdFZ9dGdHZ:dIdJZ;dKdLZdQdRZ?dSdTZ@dUdVZAdWdXZBddYdZZCdd[d\ZDd]d^ZEdd_d`ZFdadbZGdcddZHdedfZIddhdiZJddjdkZKdldmZLdndoZMdddgdgdd&dd&ddddp dqdrZNddsdtZOdudvZPdwdxZQdydzZRd{d|ZSd}d~ZTddZUddZVddZWddZXddZYddZZddZ[dddZ\dddZ]dddZ^ddZ_ddZ`ddZaddZbdddZcdddZdddZeddZfddZgdddZhdS)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__s z!BaseDatabaseSchemaEditor.__init__cCs(g|_|jr$t|jj|_|j|Sr) deferred_sqlr1rr,alias __enter__r2rrrr6s  z"BaseDatabaseSchemaEditor.__enter__cCs8|dur|jD]}||q|jr4|j|||dSr)r4executer1r__exit__)r2exc_type exc_value tracebacksqlrrrr9s   z!BaseDatabaseSchemaEditor.__exit__rcCs|js |jjr |jjjs tdt|}tjd||||dd|jr| drXdnd}|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))paramsr=)extra;N)r-r,Zin_atomic_blockr/r0rstrloggerdebugrstripendswithr.appendtuplemap quote_valuecursorr8)r2r=r>endingrKrrrr8s, z BaseDatabaseSchemaEditor.executecCs|jj|Sr)r,ops quote_name)r2rrrrrNsz#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|qSrr get_fieldr!rrrr z6BaseDatabaseSchemaEditor.table_sql..Nr,check z %s)to_table to_column_fk_%(to_table)s_%(to_column)sz%s %s)Z AutoFieldZ BigAutoFieldZSmallAutoFieldcsg|]}|qSr)Zconstraint_sqlr! constraintrr2rrrRs, css|]}|r|VqdSrrrZrrrr$sz5BaseDatabaseSchemaEditor.table_sql..)table definition) rZunique_togetherr4rG_create_unique_sql local_fields column_sql db_parametersr,sql_check_constraintZdb_type_suffixextendr( db_constraintrdb_tablerP field_namecolumnsql_create_inline_fkrNr/supports_foreign_keys_create_fk_sqlget_internal_typerM autoinc_sql constraintssql_create_tablejoin db_tablespacetablespace_sql)r2r field_namesfieldsZ column_sqlsr>rr_Z extra_params db_paramsZcol_type_suffixrWrXrnror=rsrr\r table_sqlsz               z"BaseDatabaseSchemaEditor.table_sqlc cs(|Vt|dd}|r"||V|j}|oF|| oF|oD|| }|r||}|durd||} |jjj r| | |Vn| V| ||j r|j s|jjjrd}|sdVn|jjjsdV|j rdVn |jrdV|jp|jj} | r$|jjjr$|jr$|jjj| ddVdS) N db_collationzDEFAULT TzNOT NULLZNULLz PRIMARY KEYZUNIQUE)inline)getattr _collate_sqlnull skip_defaultskip_default_on_altereffective_default_column_default_sqlr,r/requires_literal_defaultsprepare_defaultrGempty_strings_allowedr!interprets_empty_strings_as_nullsZimplied_column_nulluniquerrrZsupports_tablespacesrMrs) r2column_db_typer>rrinclude_default collationr| default_valueZcolumn_defaultZ tablespacerrr_iter_column_sqlsR        z)BaseDatabaseSchemaEditor._iter_column_sqlc CsB|j|jd}|d}|dur"dSg}d|||||||fS)z Return the column definition for a field. The field must already have had set_attributes_from_name() called. rTtypeN)NNrV)rcr,rqr)r2rrrrvrr>rrrrbLs z#BaseDatabaseSchemaEditor.column_sqlcCsdS)z Some backends don't accept default values for certain columns types (i.e. MySQL longtext and longblob). Frr2rrrrr}bsz%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. Frrrrrr~isz.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() methodNNotImplementedErrorr2valuerrrrpsz(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. %srrrrrrysz,BaseDatabaseSchemaEditor._column_default_sqlcCs|r|}n|js<|jr<|jr<|dkr6d}qd}nbt|ddsTt|ddr|}|dkrnt}qt }|dkr| }q|d kr| }nd}|S) NZ BinaryFieldrSrAZauto_nowFZ auto_now_addZ DateTimeFieldZ DateFieldZ TimeField) has_default get_defaultr|blankrrmrzrnowrdatetime)rdefaultZ internal_typerrr_effective_defaults"     z+BaseDatabaseSchemaEditor._effective_defaultcCs||||jS)z2Return a field's effective database default value.)Zget_db_prep_saverr,rrrrrsz*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). NrrrrrrJsz$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) rwr8r4re_model_indexes_sqlrlocal_many_to_manyr(through auto_created create_model)r2rr=r>rrrrrs   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.r^N)rrr(rr delete_modelr8sql_delete_tablerNrglistr4 isinstancerZreferences_tableremove)r2rrr=rrrrs  z%BaseDatabaseSchemaEditor.delete_modelcCs.|jr|jjjsdS|j|||dddS)zAdd an index on a model.Nr>)contains_expressionsr,r/supports_expression_indexesr8 create_sqlr2rindexrrr add_indexs z"BaseDatabaseSchemaEditor.add_indexcCs*|jr|jjjsdS||||dS)zRemove an index from a model.N)rr,r/rr8 remove_sqlrrrr remove_indexs z%BaseDatabaseSchemaEditor.remove_indexcCs"|||}|r|j|dddS)zAdd a constraint to a model.Nr)rr8r2rr[r=rrradd_constraints z'BaseDatabaseSchemaEditor.add_constraintcCs|||}|r||dS)z!Remove a constraint from a model.N)rr8rrrrremove_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|qSrrHr!rurrr rSzABaseDatabaseSchemaEditor.alter_unique_together..cSsh|] }t|qSrrrrrrrrSrTcsg|]}j|qSrrOrQrrrrRrSzBBaseDatabaseSchemaEditor.alter_unique_together..N) difference_delete_composed_indexsql_delete_uniquer8r`)r2rZold_unique_togetherZnew_unique_togetheroldsnewsrurtrrralter_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|qSrrrrrrr rSz@BaseDatabaseSchemaEditor.alter_index_together..cSsh|] }t|qSrrrrrrr rSTF)rrcsg|]}j|qSrrOrQrrrrRrSzABaseDatabaseSchemaEditor.alter_index_together.._idxrusuffixN)rrsql_delete_indexr8_create_index_sql)r2rZold_index_togetherZnew_index_togetherrrrurtrrralter_index_togethersz-BaseDatabaseSchemaEditor.alter_index_togetherc sddjjD}ddjjD}fdd|D}|j|fd||Bi|}t|dkr~tdt|jjd |f|| ||d dS) NcSsh|] }|jqSrrrZrrrrszBBaseDatabaseSchemaEditor._delete_composed_index..cSsh|] }|jqSrrrZrrrrrScsg|]}j|jqSr)rrPrirQrrrrRrSzCBaseDatabaseSchemaEditor._delete_composed_index..excludez1Found wrong number (%s) of constraints for %s(%s)r]r) rroindexes_constraint_nameslen ValueErrorrgrqr8_delete_constraint_sql) r2rruZconstraint_kwargsr=meta_constraint_namesmeta_index_namescolumnsconstraint_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_caselowerr8sql_rename_tablerNr4rrZrename_table_references)r2rZ old_db_tableZ new_db_tabler=rrralter_db_table0s   z'BaseDatabaseSchemaEditor.alter_db_tablecCs2||j||jj||||ddS)z)Move a model's table between tablespaces.)r^Zold_tablespaceZnew_tablespaceN)r8sql_retablespace_tablerNrrg)r2rZold_db_tablespaceZnew_db_tablespacerrralter_db_tablespaceCs 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)rNrTrUrVrYz%s.rA)r namespacerirWrX deferrable)r^rir_dropr^changes)%rr(rrrrrbrcr,rdr/rkrfsql_create_column_inline_fkrrgrPrhrir _fk_constraint_namerNrMdeferrable_sqlr4rGrlsql_create_columnr8r~r_alter_column_default_sqlsql_alter_columnre_field_indexes_sqlconnection_persists_old_columnsclose) r2rrr_r>rvZconstraint_suffixrWrXr_r= changes_sqlrrr add_fieldNsn               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. rTrNT foreign_key)r^ri)rr(rrrrrcr,rrir8_delete_fk_sqlsql_delete_columnrNrgr/rrrr4rrZreferences_columnr)r2rrfk_namesfk_namer=rrr remove_fields(      z%BaseDatabaseSchemaEditor.remove_fieldc Cs6|||sdS|j|jd}|d}|j|jd}|d}|durN|jdus`|durr|jdurrtd||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. NrTrzqCannot 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_alteredrcr,r(rrrr_alter_many_to_many _alter_field) r2rr#r%strict old_db_paramsold_type new_db_paramsnew_typerrr alter_fieldst       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| durd}|$|*||||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||g|jrl|jr|jr|js| |j8||gdg}#|r|#&t|||||r| |9|||#&t|||#D]\}$}|jj:|jd}%|%d}&|%|j|$j|j|&\}}| |j2|3|jj j |dd|d|D]\}}"| ||"qJq|jjjr|jr| s|jr|js|jr| |;||d|r|#D],\}'}(|(jjr| |;|(j|(jdq|d |d kr0|d r0|j<|j j |jgdd}| |=|||d |rr|j*|||dd\})}"|j2|3|j j |)d}| ||"|jjj>r|j?dS)z3Perform a "physical" (non-ManyToMany) field update.Trrz.F)rrrz7Found wrong number (%s) of unique constraints for %s.%scSsh|] }|jqSrr)r!rrrrrUrS)rtype_rrUcSsh|] }|jqSrrrZrrrrfs)rUrz6Found wrong number (%s) of check constraints for %s.%srxNr]rr)r^rirrurTrrrYZ_fk_checkrr)@setr,r/rkr(rfrrirrrrgaddr8rr_field_became_primary_keyro_delete_unique_sqlrr'Z related_modelrdb_indexrr r_delete_index_sql_delete_check_sql_rename_field_sqlr4rrZrename_column_referencesrz_alter_column_collation_sqlrG_alter_column_type_sqlrer|rr~r_alter_column_null_sqlrZsupports_combined_altersrHr&rqsumrrNsql_update_with_default_delete_primary_key_unique_should_be_addedr`r_create_primary_key_sqlrcrl_create_index_name_create_check_sqlrr)*r2rr#r%rrrrrZ fks_droppedrrrrconstraint_nameZdrop_foreign_keysZ_old_relr*Z rel_fk_namesrZ index_names index_namer=actionsZ null_actionsZ post_actionsZ old_collation new_collationfragmentZ other_actionsZneeds_database_defaultZ old_default new_defaultZfour_way_default_alterationr>Zrels_to_updater)Z rel_db_paramsZrel_typerrelrrrrrs                                        z%BaseDatabaseSchemaEditor._alter_fieldcCsV|jjjr|jrdS|j|jd}|jr.|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. NrTrrir) r,r/rrrcr|sql_alter_column_nullsql_alter_column_not_nullrNri)r2rr#r%rr=rrrr?s" 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. rTr)rirr) rrr,r/rrrcr| sql_alter_column_no_default_nullsql_alter_column_no_defaultsql_alter_column_defaultrNri) r2rr#r%rr rr>rr=rrrr\s,     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_typerNri)r2rr#r%rrrrrs  z/BaseDatabaseSchemaEditor._alter_column_type_sqlcCs0|j||j||r"d||nddgfS)NrVrA)rirr)sql_alter_column_collaterNrir{)r2rr%rr rrrrs 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) r(rrrgrrrPZm2m_reverse_field_nameZm2m_field_name)r2rr#r%rrrrrs.       z,BaseDatabaseSchemaEditor._alter_many_to_manyrAc 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 r r,rMZmax_name_lengthrqrisdigit) r2Z table_name column_namesrrZhash_suffix_part max_lengthr Z other_lengthrrrrs(   z+BaseDatabaseSchemaEditor._create_index_namecCsX|dur:t|dkr*|djr*|dj}n|jjr:|jj}|durTd|jj|SdS)NrrrVrA)rrrrr,rMrs)r2rrurrrrr_get_index_tablespace_sqls z2BaseDatabaseSchemaEditor._get_index_tablespace_sqlcCs|r d|SdS)Nz WHERE rAr)r2 conditionrrr_index_condition_sqlsz-BaseDatabaseSchemaEditor._index_condition_sqlcCs,|r|jjjsdStdt|jj||jdS)NrAz INCLUDE (%(columns)s))r)r,r/supports_covering_indexesrrrrgrN)r2rrrrr_index_include_sqls z+BaseDatabaseSchemaEditor._index_include_sql) rurrusingrr col_suffixesr= opclassesr!include 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, ...). FZ alias_colsrT)rrcSsg|] }|jqSrrirQrrrrRrSz>BaseDatabaseSchemaEditor._create_index_sql..cs"durj|i|Sr)rrNargskwargsrr2rrcreate_index_nameszEBaseDatabaseSchemaEditor._create_index_sql..create_index_name)r^rr%rr?r!r()r get_compilerr,r sql_create_indexrrgrrrNr_index_columnsrrJr"r$)r2rrurrr%rrr&r=r'r!r(r)compilerrsrr2r^r0rr/rrs0     z*BaseDatabaseSchemaEditor._create_index_sqlcCs&t|p |jt|jj|j||dSN)r^r)rrrrrgrN)r2rrr=rrrr2s z*BaseDatabaseSchemaEditor._delete_index_sqlcCst|||j|dS)N)r&)rrN)r2r^rr&r'rrrr39sz'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|qSrrOrQrrrrRHrSz?BaseDatabaseSchemaEditor._model_indexes_sql..rr)rZmanagedproxyZswappedrarerZindex_togetherrGrrrr,r/rr)r2routputrrtrurrrrr<s   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_indexedrGr)r2rrr7rrrrSs z+BaseDatabaseSchemaEditor._field_indexes_sqlc Csv|\}}}}|\}}}} gd} | D]} || d| | dq,||j||jkpt|||f||| fkS)N) rZ db_columneditableZerror_messages help_textZlimit_choices_toZ on_deleteZ related_nameZrelated_query_nameZ validatorsZ verbose_name)Z deconstructpoprNri) r2r#r%rold_pathZold_argsZ old_kwargsnew_pathnew_argsZ new_kwargsZnon_database_attrsattrrrrr\s z1BaseDatabaseSchemaEditor._field_should_be_alteredcCs|jo |j Sr)rrr2rrrrrr8xsz1BaseDatabaseSchemaEditor._field_should_be_indexedcCs|j o |jSrrr2r#r%rrrr{sz2BaseDatabaseSchemaEditor._field_became_primary_keycCs"|j r|jp |jo |j o |jSr)rrrBrrrr~sz0BaseDatabaseSchemaEditor._unique_should_be_addedcCs*|j||||j||j|dS)N)r^Z old_columnZ new_columnr)sql_rename_columnrNri)r2r^r#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)r^rrirWrXr)rrrgrNrrri target_fieldrr,rMrr sql_create_fk) r2rrrr^rrirWrXrrrrrls&  z'BaseDatabaseSchemaEditor._create_fk_sqlcs<fdd}t|jj|jgt|jjjjd|jjg||S)Ncsj|i|SrrNrr,r7rrcreate_fk_nameszDBaseDatabaseSchemaEditor._fk_constraint_name..create_fk_namer)rrrgrir rDr)r2rrrrGrr7rrs z,BaseDatabaseSchemaEditor._fk_constraint_namecCs||j||Sr)r sql_delete_fkr2rrrrrrsz'BaseDatabaseSchemaEditor._delete_fk_sqlcCs,|dur dS|tjkrdS|tjkr(dSdS)NrAz DEFERRABLE INITIALLY DEFERREDz DEFERRABLE INITIALLY IMMEDIATE)r ZDEFERREDZ IMMEDIATE)r2rrrr_deferrable_constraint_sqls   z3BaseDatabaseSchemaEditor._deferrable_constraint_sqlc s|rjjjsdS|s"|s"|s"|rNj|||||||d} | rJj| dSjdfdd|D|d} j || dS)N)rr!r(r'r)r]csg|]}|jqSr)rNrirQr7rrrRrSz8BaseDatabaseSchemaEditor._unique_sql..)rrrr[) r,r/&supports_deferrable_unique_constraintsr`r4rGsql_unique_constraintrqrJsql_constraintrN) r2rrurr!rr(r'r)r=r[rr7r _unique_sqls4   z$BaseDatabaseSchemaEditor._unique_sqlc  s|rjjjr8|rjjjr8|r*jjjr8|r<jjjs.create_unique_nameFr*rTcSsg|] }|jqSrr+rQrrrrRrSz?BaseDatabaseSchemaEditor._create_unique_sql.._uniqr)r&r')r^rrr!rr()r,r/rLsupports_partial_indexesr#rr r1rrgrrNsql_create_unique_indexsql_create_uniquer3rrJrrr"rJr$)r2rrurr!rr(r'r)rPr4r^rr=rr7rr`sV       z+BaseDatabaseSchemaEditor._create_unique_sqlc Csh|r|jjjr8|r|jjjr8|r*|jjjr8|r<|jjjsBaseDatabaseSchemaEditor._constraint_names..rrrrrUrr)r,rKrYZget_constraintsrrgitemsrG)r2rrrrrrrUrrrKroresultrZinfodictrr7rrLs4   " z*BaseDatabaseSchemaEditor._constraint_namescCsV|j|dd}|r6t|dkr6tdt||jjf|D]}||||q:dS)NTrArz0Found wrong number (%s) of PK constraints for %s)rrrrrgr8_delete_primary_key_sql)r2rrrrrrrrusz,BaseDatabaseSchemaEditor._delete_primary_keyc CsJt|jt|jj|j||j|jj|jgddt|jj|jg|jdS)NZ_pkr)r^rr) r sql_create_pkrrrgrNrrirr@rrrrsz0BaseDatabaseSchemaEditor._create_primary_key_sqlcCs||j||Sr)r sql_delete_pkrIrrrr\sz0BaseDatabaseSchemaEditor._delete_primary_key_sqlcCsd||S)NzCOLLATE )rN)r2rrrrr{sz%BaseDatabaseSchemaEditor._collate_sqlcCs*|j||d|d}||dS)N,)Z procedure param_types)sql_delete_procedurerNrqr8)r2Zprocedure_namer`r=rrrremove_procedures z)BaseDatabaseSchemaEditor.remove_procedure)FT)r)F)F)F)F)rA)N)N)NNNNN)NNNNNN)NNNNN)NNNNNNNN)F)r)i__name__ __module__ __qualname____doc__rprrrrrrrrrrrrrrCrrMrdZsql_delete_constraintrNrVrWrTrrErjrrHr2rSrr]r^rar3r6r9r8rNrwrrbr}r~rr staticmethodrrrJrrrrrrrrrrrrrrrrrrrrrr r"r$rrr3rrrr8rrrrlrrrJrOr`rrUrrrrrrr\r{rbrrrrr+Es&  Q6       H I K &    6     , <   )  r+)loggingrZ!django.db.backends.ddl_referencesrrrrrrZdjango.db.backends.utilsr r Zdjango.db.modelsr r Zdjango.db.models.sqlr Zdjango.db.transactionrrZ django.utilsr getLoggerrCrrr'r+rrrrs