o `Zh7@sddlZddlZddlmZddlmZddlmZmZmZm Z m Z m Z ddl m Z mZmZddlmZmZmZddlmZddlmZmZdd lmZed Zd d Zd dZddZGdddZ dS)N)datetime)settings)Columns ExpressionsForeignKeyName IndexName StatementTable) names_digestsplit_identifier truncate_name) NOT_PROVIDED DeferrableIndex)Query)TransactionManagementErroratomic)timezonezdjango.db.backends.schemacCs2|j}|jrdS|jr|jdgkrdS|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_fieldrrU/var/www/html/lang_env/lib/python3.10/site-packages/django/db/backends/base/schema.py_is_relevant_relations  rcCs"t|jjdddddtddS)NFT)forwardreverseZinclude_hiddenZinclude_parentsr)key)sorted_metaZ _get_fieldsoperator attrgettermodelrrr_all_related_fields'sr$c#sdtfddtjDfddtjD}|D]\}}||fVt|j|jEdHqdS)Nc3|] }t|r|VqdSNr.0obj) old_fieldrr 8 z+_related_non_m2m_objects..c3r%r&r'r() new_fieldrrr,=r-)zipr$r#_related_non_m2m_objects remote_field)r+r.Zrelated_fieldsold_relnew_relr)r.r+rr04s     r0c @seZdZdZdZdZdZdZdZdZ dZ d Z d Z d Z d ZeZd ZdZdZdZdZdZdZdZeZdZeZdZdZdZeZdZdZ dZ!dZ"dZ#eZ$dZ%dZ&dZ'dd"d#Z(d$d%Z)d&d'Z*dd)d*Z+d+d,Z,d-d.Z-d/d0Z.dd1d2Z/d3d4Z0d5d6Z1d7d8Z2d9d:Z3d;d<Z4d=d>Z5e6d?d@Z7dAdBZ8dCdDZ9dEdFZ:dGdHZ;dIdJZdOdPZ?dQdRZ@dSdTZAdUdVZBdWdXZCdYdZZDd[d\ZEd]d^ZFd_d`ZGdadbZHddcddZIdedfZJ ddgdhZKdidjZLddkdlZM ddmdnZNdodpZOdqdrZPdsdtZQdudvZRddxdyZSddzd{ZTd|d}ZUd~dZVdddwdwdd(dd(dddd ddZWdddZXddZYddZZddZ[ddZ\dddZ]ddZ^ddZ_ddZ`ddZaddZbddZcddZdddZeddZf     dddZg      dddZh       dddZidddZj      dddZkddZlddZmddZnddZo        dddZpdddZqddZrddZsdddZtdddZudS)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)sz2ALTER COLUMN %(column)s TYPE %(type)s%(collation)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)zbALTER TABLE %(table)s ADD CONSTRAINT %(name)s UNIQUE%(nulls_distinct)s (%(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)szaCREATE UNIQUE INDEX %(name)s ON %(table)s (%(columns)s)%(include)s%(condition)s%(nulls_distinct)sz/ALTER INDEX %(old_name)s RENAME TO %(new_name)szDROP INDEX %(name)szGALTER TABLE %(table)s ADD CONSTRAINT %(name)s PRIMARY KEY (%(columns)s)zDROP PROCEDURE %(procedure)sz)COMMENT ON TABLE %(table)s IS %(comment)sz5COMMENT ON COLUMN %(table)s.%(column)s IS %(comment)sFTcCs,||_||_|jr g|_|jjjo||_dSr&) connection collect_sql collected_sqlfeaturescan_rollback_ddlatomic_migration)selfr5r6rrrr__init__s z!BaseDatabaseSchemaEditor.__init__cCs(g|_|jrt|jj|_|j|Sr&) deferred_sqlr:rr5alias __enter__r;rrrr?s  z"BaseDatabaseSchemaEditor.__enter__cCs<|dur|jD]}||q|jr|j|||dSdSr&)r=executer:r__exit__)r;exc_type exc_value tracebacksqlrrrrBs   z!BaseDatabaseSchemaEditor.__exit__rcCs|js|jjr|jjjstdt|}tjd||||dd|jrN| dr,dnd}|durD|j |t t|j||dS|j ||dS|j}|||WddS1sewYdS)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))paramsrF)extra;N)r6r5Zin_atomic_blockr8r9rstrloggerdebugrstripendswithr7appendtuplemap quote_valuecursorrA)r;rFrGendingrTrrrrAs. "z BaseDatabaseSchemaEditor.executecCs|jj|Sr&)r5ops quote_name)r;rrrrrWz#BaseDatabaseSchemaEditor.quote_namecsjjD]}fdd|D}j|qg}g}jjD]}|\}}|dur1q"|jjd} | drE|dj | 7}|j jd} | rT|d| 7}| ||j r|j r|j jjj} |j jj|j jj} jr|dj| | d7}njjjrj|d |d |j|f|d vrjjjj|j} | rj | q"fd djjD}jjjd ddg||RDd}jjrjjjj}|r|d|7}||fS)z-Take a model and return its table definition.cg|]}j|qSrr get_fieldr)rr"rr z6BaseDatabaseSchemaEditor.table_sql..Nr5check z %s)to_table to_column_fk_%(to_table)s_%(to_column)sz%s %s)Z AutoFieldZ BigAutoFieldZSmallAutoFieldcsg|]}|qSr)Zconstraint_sqlr) constraintr#r;rrr] s , css|] }|rt|VqdSr&)rKrerrrr,s z5BaseDatabaseSchemaEditor.table_sql..)table definition) rZunique_togetherr=rP_create_unique_sql local_fields column_sql db_parametersr5sql_check_constraintdb_type_suffixextendr1 db_constraintr#db_tabler[ field_namecolumnsql_create_inline_fkrWr8supports_foreign_keys_create_fk_sqlget_internal_typerV autoinc_sql constraintssql_create_tablejoin db_tablespacetablespace_sql)r;r# field_namesfieldsZ column_sqlsrGrrjZ extra_params db_paramscol_type_suffixrbrcrzr{rFrrrgr table_sqls                 z"BaseDatabaseSchemaEditor.table_sqlccs|V|d}r||V|jjjr |jr ||jV|j}|jt ur<| |\} } d| V| | d}|oK| | oK|oJ| | }|rt||} | durtd||} |jjjrl| || Vn| V|| |jr|js|jjjrd}|jr||Vn|sdVn|jjjsdV|jrdVn|jrdV|jp|jj} | r|jjjr|jr|jjj| dd VdSdSdSdS) N collationzDEFAULT FTzNOT NULLZNULLz PRIMARY KEYZUNIQUE)inline)get _collate_sqlr5r8supports_comments_inline db_comment _comment_sqlnull db_defaultr db_default_sqlrq skip_defaultskip_default_on_altereffective_default_column_default_sqlrequires_literal_defaultsprepare_defaultrPempty_strings_allowedr!interprets_empty_strings_as_nulls generated_column_generated_sqlZimplied_column_nulluniquer~rZsupports_tablespacesrVr)r;column_db_typerGr#rfield_db_paramsinclude_defaultrr default_sqlZdefault_params default_valueZcolumn_defaultZ tablespacerrr_iter_column_sql!sf          z)BaseDatabaseSchemaEditor._iter_column_sqlc CsD|j|jd}|d}|durdSg}d||||||||fS)z Return the column definition for a field. The field must already have had set_attributes_from_name() called. r_typeNNNra)rnr5r}r)r;r#rrrrrGrrrrmbs" z#BaseDatabaseSchemaEditor.column_sqlcCdS)z Some backends don't accept default values for certain columns types (i.e. MySQL longtext and longblob). Frr;rrrrr}z%BaseDatabaseSchemaEditor.skip_defaultcCr)z Some backends don't accept default values for certain columns types (i.e. MySQL longtext and longblob) in the ALTER COLUMN statement. Frrrrrrrz.BaseDatabaseSchemaEditor.skip_default_on_altercCstd)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() methodNotImplementedErrorr;valuerrrrsz(BaseDatabaseSchemaEditor.prepare_defaultcCr)z Return the SQL to use in a DEFAULT clause. The resulting string should contain a '%s' placeholder for a default value. %srrrrrrrz,BaseDatabaseSchemaEditor._column_default_sqlcs~ddlm}t|j|rdnd}t|jd}|jjd}||j\}}jj j r9|t fdd|D;}g}|||fS) z;Return the sql and params for the field's database default.r)Valuerz(%s)r"r_c3|]}|VqdSr&)rr)pr@rrr,z:BaseDatabaseSchemaEditor.db_default_sql..) Zdjango.db.models.expressionsr isinstancerrr# get_compilerr5compiler8rrQ)r;rrrFquerycompilerrrGrr@rrs    z'BaseDatabaseSchemaEditor.db_default_sqlcsL|j\}}|jr dnd}|r|tfdd|D}d|d|S)z3Return the SQL to use in a GENERATED ALWAYS clause.ZSTOREDZVIRTUALc3rr&rSrr@rrr,rzABaseDatabaseSchemaEditor._column_generated_sql..zGENERATED ALWAYS AS (z) ) generated_sqlr5 db_persistrQ)r;rZexpression_sqlrGZpersistency_sqlrr@rrs z.BaseDatabaseSchemaEditor._column_generated_sqlcCs|r |}|S|jrd}|S|js(|jr(|jr(|dkr$d}|Sd}|St|dds4t|ddrZ|}|dkrBt }|St }|dkrP| }|S|d krX| }|Sd}|S) NZ BinaryFieldrJZauto_nowFZ auto_now_addZ DateTimeFieldZ DateFieldZ TimeField) has_default get_defaultrrblankrrygetattrrnowrdatetime)rdefaultZ internal_typerrr_effective_defaults4   z+BaseDatabaseSchemaEditor._effective_defaultcCs||||jS)z2Return a field's effective database default value.)Zget_db_prep_saverr5rrrrrsz*BaseDatabaseSchemaEditor.effective_defaultcCst)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). rrrrrrSsz$BaseDatabaseSchemaEditor.quote_valuecCs||\}}|||p d|jjjrG|jjr!||d|jj|jjjsG|jj D]}|j rF|j |jd}|d}|j| ||||j q*|j |||jjD]}|jjjjrc||jjqTdS)zr Create a table and any accompanying indexes or unique constraints for the given `model`. Nr_r)rrAr5r8supports_commentsrZdb_table_commentalter_db_table_commentrrlrrn_alter_column_comment_sqlr=rq_model_indexes_sqllocal_many_to_manyr1through auto_created create_model)r;r#rFrGrr field_typerrrrs0      z%BaseDatabaseSchemaEditor.create_modelcCs~|jjD]}|jjjjr||jjq||jd||jj it |j D]}t |t r<||jj r<|j |q(dS)z!Delete a model from the database.riN)rrr1rr delete_modelrAsql_delete_tablerWrslistr=rrZreferences_tableremove)r;r#rrFrrrrs"   z%BaseDatabaseSchemaEditor.delete_modelcCs.|jr |jjjs dS|j|||dddS)zAdd an index on a model.NrG)contains_expressionsr5r8supports_expression_indexesrA create_sqlr;r#indexrrr add_indexs z"BaseDatabaseSchemaEditor.add_indexcCs*|jr |jjjs dS||||dS)zRemove an index from a model.N)rr5r8rrA remove_sqlrrrr remove_index!s z%BaseDatabaseSchemaEditor.remove_indexcCsF|jjjr|j|||j|jdddS||||||dS)Nr)r5r8Zcan_rename_indexrA_rename_index_sqlrrr)r;r#Z old_indexZ new_indexrrr rename_index*s  z%BaseDatabaseSchemaEditor.rename_indexcCs&|||}|r|j|dddSdS)zAdd a constraint to a model.Nr)rrAr;r#rfrFrrradd_constraint4s z'BaseDatabaseSchemaEditor.add_constraintcCs"|||}|r||dSdS)z!Remove a constraint from a model.N)rrArrrrremove_constraint<s z*BaseDatabaseSchemaEditor.remove_constraintcs|dd|D}dd|D}||D]}||ddd|jq||D]}fdd|D}|||q'd S) z Deal with a model changing its unique_together. The input unique_togethers must be doubly-nested, not the single-nested ["foo", "bar"] format. cSh|]}t|qSrrQr)rrrr HzABaseDatabaseSchemaEditor.alter_unique_together..cSrrrrrrrrIrTF)rrcrYrrZr\r"rrr]Tr^zBBaseDatabaseSchemaEditor.alter_unique_together..N) difference_delete_composed_indexsql_delete_uniquerArk)r;r#Zold_unique_togetherZnew_unique_togetheroldsnewsrrrr"ralter_unique_togetherBsz.BaseDatabaseSchemaEditor.alter_unique_togethercsdd|D}dd|D}||D]}||ddd|jq||D]}fdd|D}||j|d d q'd 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. cSrrrrrrrr]rz@BaseDatabaseSchemaEditor.alter_index_together..cSrrrrrrrr^rTF)rrcrYrrZr\r"rrr]ir^zABaseDatabaseSchemaEditor.alter_index_together.._idxrsuffixN)rrsql_delete_indexrA_create_index_sql)r;r#Zold_index_togetherZnew_index_togetherrrrrrr"ralter_index_togetherWsz-BaseDatabaseSchemaEditor.alter_index_togetherc sddjjD}ddjjD}fdd|D}|j|fd||Bi|}|ddurJ|rJ|jjjrJt|j jj |d d } | |vrJ| g}t |d kr`t d t |jj d |f||||ddS)NcSh|]}|jqSrrrerrrrmzBBaseDatabaseSchemaEditor._delete_composed_index..cSrrrrerrrrpcsg|] }j|jqSr)rr[rur\r"rrr]qszCBaseDatabaseSchemaEditor._delete_composed_index..excluderTFquotez1Found wrong number (%s) of constraints for %s(%s)rhr)rr{indexes_constraint_namesrr5r8Z*allows_multiple_constraints_on_same_fieldsrK_unique_constraint_namerslen ValueErrorr}rA_delete_constraint_sql) r;r#rZconstraint_kwargsrFmeta_constraint_namesmeta_index_namescolumnsconstraint_names default_namerr"rrlsB z/BaseDatabaseSchemaEditor._delete_composed_indexcCsn||ks|jjjr||krdS||j||||d|jD] }t|t r4| ||q'dS)z#Rename the table a model points to.N)Z old_tableZ new_table) r5r8Zignores_table_name_caselowerrAsql_rename_tablerWr=rrZrename_table_references)r;r#Z old_db_tableZ new_db_tablerFrrralter_db_tables"   z'BaseDatabaseSchemaEditor.alter_db_tablecCsF|jr|jjjr!||j||jj||pdddSdSdS)NrJ)ricomment) sql_alter_table_commentr5r8rrArWrrsrS)r;r#Zold_db_table_commentZnew_db_table_commentrrrrs  z/BaseDatabaseSchemaEditor.alter_db_table_commentcCs2||j||jj||||ddS)z)Move a model's table between tablespaces.)riZold_tablespaceZnew_tablespaceN)rAsql_retablespace_tablerWrrs)r;r#Zold_db_tablespaceZnew_db_tablespacerrralter_db_tablespaces z,BaseDatabaseSchemaEditor.alter_db_tablespacec CsJ|jr|jjjjr||jjS|j||dd\}}|dur dS|j|jd}r0|d|7}|j |jd}|drD|d|j |7}|jr|jj j r|j rd}|jr|jjjj}|jjj|jjj} t|jj\} } |d|j||||| rd|| nd ||j|||| |jjd 7}n |j|||||j||jj||j|d } || ||jtur| |s|!|dur|j"|d|dd \} }|j#||jj| d } || ||j$r |jj j%r |jj j&s |d}|j|'||||j$|j(|)|||jj j*r#|j+dSdS)z Create a field on a model. Usually involves adding a column, but may involve adding a table instead (for M2M fields). T)rNr_rar`rdz%s.rJ)r namespacerurbrc deferrable)rirurjdroprichangesr),rr1rrrrrmrpr5rnror8rwrrsql_create_column_inline_fkr#rsr[rtrur _fk_constraint_namerWrVdeferrable_sqlr=rPrxsql_create_columnrArr rr_alter_column_default_sqlsql_alter_columnrrrrrq_field_indexes_sqlconnection_persists_old_columnsclose)r;r#rrjrGrrZconstraint_suffixrbrcr_rF changes_sqlrrrr add_fields               z"BaseDatabaseSchemaEditor.add_fieldcCs|jr|jjjjr||jjS|j|jdddurdS|jr8|j||j gdd}|D] }| | ||q,|j | |jj| |j d}| ||jjjrX|jt|jD]}t|trs||jj|j rs|j|q]dS)z Remove a field from a model. Usually involves deleting a column, but for M2Ms may involve deleting a table. r_rNT foreign_key)riru)rr1rrrrrnr5rrurA_delete_fk_sqlsql_delete_columnrWrsr8rrrr=rrZreferences_columnr)r;r#rfk_namesfk_namerFrrr remove_field s,       z%BaseDatabaseSchemaEditor.remove_fieldc Csv|||sdS|j|jd}|d}|j|jd}|d}|dur'|jdus0|dur8|jdur8td||f|dur\|dur\|jjr\|jjr\|jjjjr\|jjjjr\|||||S|durz|durz|jjrz|jjrz|jjjjsz|jjjjszdS|dus|durtd||f|j |j ks|j r|j |j ks| |j| |jkrtd|d| ||||||||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. Nr_rzqCannot 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)z7Modifying GeneratedFields is not supported - the field z6 must be removed and re-added with the new definition.) _field_should_be_alteredrnr5r1rrrr_alter_many_to_manyrrr _alter_field) r;r#r+r.strict old_db_paramsold_type new_db_paramsnew_typerrr alter_field,sz           z$BaseDatabaseSchemaEditor.alter_fieldcCsD|jj}||j}d|d<z |||WSty!YdSw)NZ__column_name__ru)r5Zdata_type_check_constraintsZdb_type_parametersryKeyError)r;rrZcheck_constraintsdatarrr_field_db_checkxs  z(BaseDatabaseSchemaEditor._field_db_checkc 2 Cs|t} |jjjrL|jrL|jrL|j||dhdrL|j||jgdd} |r7t | dkr7t dt | |j j |jf| D]} | |jf|||| q9|jr|jrX|||rdd|j jD} |j||jgdd | d } |rt | dkrt d t | |j j |jf| D] }||||q|d }|d }|jjjo|jr|jp|jo|jo||kp||k}|rt||D]\}}|j|j|jjgdd}|D] } |||j| qq|jr|js|jr|jrd d|j jD}|j||jgdtj|d}|D] }||||q|||}|||}||kr^|r^dd|j jD} |j||jgd| d} |rOt | dkrOt dt | |j j |jf| D] }||||qQ|j|jkr|| |j j ||||j!D]}t"|t#r|$|j j |j|jqug}g}g}|j%|jd}|j%|jd}||ks||ks||ks|jjj&r|j'|j'kr|(||||||\} }!|)| |*|!|j+t,ur|j+t,us|j+|j+kr|)|-|||n|j+t,ur|)|j-|||ddd }"|j.r6|j.s6|j+t,ur6|/|}#|/|}$|0|s6|#|$kr6|$dur6d}"|)|1||||j.|j.krL|2|||} | rL|)| |3pU|j+t,uo^|j.o^|j. }%|se|r|%sl||7}|jjj4r|rt5t6|\}}&d7|t8|&gfg}|D]\}}&||j9|:|j j |d|&q|%r|j+t,urd}'|$g}&n|;|\}'}&||j<|:|j j |:|j|'d|&|D]\}}&||j9|:|j j |d|&q|r|D] \}}&|||&q|jr|js|=|||>||r||?||g|jr|jr1|jr1|js1||j@||gdg}(|r>|(*t|||||rV||A|||(*t|||(D]V\})}|jjB|jd}*|*d}+|*d },|)jjB|jd}-|-d }.|(|j|)j|j|+|.|,\} }!||j9|:|jj j | dd| d|!D] \}}&|||&qqX|jjjr|jr| s|jr|js|jr||C||d|r|(D]\}/}0|0jjr||C|0j|0jdq||kr|r|jD|j j |jgdd}||E|||d |"r/|j1|||dd\}1}&|j9|:|j j |1d}|||&|jjjFr<|jGdSdS)!z3Perform a "physical" (non-ManyToMany) field update.r)ignoreTrrz.F)rrrz7Found wrong number (%s) of unique constraints for %s.%srcSrrr)r)rrrrrr)rtype_rcSrrrrerrrrr)r`rz6Found wrong number (%s) of check constraints for %s.%sr_r Nrhr r)rirurrrrrdZ_fk_checkrr`)Hsetr5r8rwr1rrr rrurrrrsaddrArr_field_became_primary_keyr{_delete_unique_sqlrrr0Z related_modelrdb_indexrrr_delete_index_sqlr+_delete_check_sql_rename_field_sqlr=rrZrename_column_referencesrprr_alter_column_type_sqlrPrqrr "_alter_column_database_default_sqlrrrr_alter_column_null_sqlrZsupports_combined_altersrQr/r}sumrrWrsql_update_with_default_delete_primary_key_unique_should_be_addedrkr_create_primary_key_sqlrnrx_create_index_name_create_check_sqlrr)2r;r#r+r.r%r'r$r&r#Z fks_droppedrrrrconstraint_name old_collation new_collationZdrop_foreign_keysZ_old_relr3Z rel_fk_namesrZ index_names index_nameZ old_db_checkZ new_db_checkrFactionsZ null_actionsZ post_actionsZold_type_suffixZnew_type_suffixfragment other_actionsZneeds_database_defaultZ old_default new_defaultZfour_way_default_alterationrGrZrels_to_updater2Z rel_db_paramsZrel_typeZ rel_collationZold_rel_db_paramsZold_rel_collationrrelrrrrr"s\                                                      z%BaseDatabaseSchemaEditor._alter_fieldcCsR|jjjr |jr dS|j|jd}|jr|jn|j}|||j |ddgfS)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. Nr_r)rur) r5r8rrrnrsql_alter_column_nullsql_alter_column_not_nullrWru)r;r#r+r.r&rFrrrr;s" z/BaseDatabaseSchemaEditor._alter_column_null_sqlc Cs||}||}|g}|rg}n |jjjr||}g}|j|jd}|r2|jr.|j} n|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. r_rrurr) rrr5r8rrrnr sql_alter_column_no_default_nullsql_alter_column_no_defaultsql_alter_column_defaultrWru) r;r#r+r.r rJrrGr&rFrrrrs,     z2BaseDatabaseSchemaEditor._alter_column_default_sqlc CsV|r |j}d}g}n |j}||\}}|j|jd}|||j|d|d|fS)z Hook to specialize column database default alteration. Return a (sql, params) fragment to add or drop (depending on the drop argument) a default to new_field's column. rJr_rrN)rPrQrrnr5rWru) r;r#r+r.r rFrrGr&rrrr::s  z;BaseDatabaseSchemaEditor._alter_column_database_default_sqlc Csg}||||jj}rd|}nd}d} |jjjrB|jsB|j|jkr9|||||j\} } | r9| | | f|jrB| |j} |j | |j ||| dgf|fS)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 2-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. rarJ)rurrr)rrrsr5r8rrrrrPrsql_alter_column_typerWru) r;r#r+r.r'rDrErIZ collate_sqlZ comment_sqlrFrGrrrr9Vs6        z/BaseDatabaseSchemaEditor._alter_column_type_sqlcCs.|j||jj||j||dgfS)N)rirur)sql_alter_column_commentrWrrsrur)r;r#r.r'Znew_db_commentrrrrs  z2BaseDatabaseSchemaEditor._alter_column_comment_sqlcCs||pdS)NrJr)r;rrrrrrXz%BaseDatabaseSchemaEditor._comment_sqlcCs|jjjj|jjjjkr||jj|jjjj|jjjj||jj|jjj||jjj|||jj|jjj||jjj|dS)z*Alter M2Ms to repoint their to= endpoints.N) r1rrrsrr(r[Zm2m_reverse_field_nameZm2m_field_name)r;r#r+r.r#rrrr!s,       z,BaseDatabaseSchemaEditor._alter_many_to_manyrJc Cst|\}}dt|g|Rddi|f}|jjpd}d|d||f}t||kr/|St||dkr?|d|d}|t|d d }d|d|d|d||f}|d dksg|d rod |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 r5rVmax_name_lengthr}risdigit) r; table_name column_namesrrZhash_suffix_part max_lengthrFZ other_lengthrrrrAs(   z+BaseDatabaseSchemaEditor._create_index_namecCsf|dur$t|dkr|djr|dj}ntjrtj}n|jjr$|jj}|dur1d|jj|SdS)NrrrarJ)rr~rZDEFAULT_INDEX_TABLESPACErr5rVr)r;r#rr~rrr_get_index_tablespace_sqls z2BaseDatabaseSchemaEditor._get_index_tablespace_sqlcCs|rd|SdS)Nz WHERE rJr)r; conditionrrr_index_condition_sqlsz-BaseDatabaseSchemaEditor._index_condition_sqlcCs,|r|jjjs dStdt|jj||jdS)NrJz INCLUDE (%(columns)s))r)r5r8supports_covering_indexesrrrrsrW)r;r#rrrr_index_include_sqls z+BaseDatabaseSchemaEditor._index_include_sql) rrrusingr~ col_suffixesrF opclassesr`include expressionsc  s|pg}| pg} t|ddjjd} j|||d}dd|D}|p&j}|jj}fdd}t|t|j t ||||||rJ |||| 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_colsr_)r~cSg|]}|jqSrrur\rrrr]rz>BaseDatabaseSchemaEditor._create_index_sql..cs"dur j|i|Sr&)rArWargskwargsrr;rrcreate_index_name s zEBaseDatabaseSchemaEditor._create_index_sql..create_index_name)rirrdrrHr`rg)rrr5r_sql_create_indexrrsrr rWr_index_columnsrrSrarc)r;r#rrrrdr~rerFrfr`rgrhrrrrqrirprrorrs0     z*BaseDatabaseSchemaEditor._create_index_sqlcCs&t|p|jt|jj|j||dSN)rir)rrr rrsrW)r;r#rrFrrrr6!s z*BaseDatabaseSchemaEditor._delete_index_sqlcCs*t|jt|jj|j||||dS)N)riold_namenew_name)rsql_rename_indexr rrsrW)r;r#rtrurrrr(s z*BaseDatabaseSchemaEditor._rename_index_sqlcCst|||j|dS)N)re)rrW)r;rirrerfrrrrr0sz'BaseDatabaseSchemaEditor._index_columnscsjjr jjs jjrgSg}jjD] }|||qjjD]}fdd|D}||j |ddq$jj D]}|j rI|j j jrR|||q?|S)z Return a list of all index SQL statements (field indexes, index_together, Meta.indexes) for the specified model. crYrrZr\r"rrr]@r^z?BaseDatabaseSchemaEditor._model_indexes_sql..rr)rZmanagedproxyZswappedrlrqrZindex_togetherrPrrrr5r8rr)r;r#outputrrrrrr"rr3s    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_indexedrPr)r;r#rrxrrrrKs z+BaseDatabaseSchemaEditor._field_indexes_sqlc Cs|js|jsdS|p t}|\}}}}|\}}} } ||jD]} || dq#||jD]} | | dq2|js\|jr\|jr\|jjj j |jjj j kr\|dd| dd| |j | |j kpq|||f|| | fkS)NFto) Zconcreter1Z deconstructunionZ non_db_attrspoprr1r#rrsrWru) r;r+r.r,rold_pathZold_argsZ old_kwargsnew_pathnew_argsZ new_kwargsattrrrrr Ts2      z1BaseDatabaseSchemaEditor._field_should_be_alteredcCs|jo|j Sr&)r5rr;r#rrrrryqrXz1BaseDatabaseSchemaEditor._field_should_be_indexedcCs|j o|jSr&rr;r+r.rrrr3trXz2BaseDatabaseSchemaEditor._field_became_primary_keycCs|j o |jo |j p |jSr&)rrrrrrr?ws  z0BaseDatabaseSchemaEditor._unique_should_be_addedcCs*|j||||j||j|dS)N)riZ old_columnZ new_columnr)sql_rename_columnrWru)r;rir+r.r'rrrr8~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)rirrurbrcr)r rrsrWrrru target_fieldr#r5rVrr sql_create_fk) r;r#rrrirrurbrcrrrrrxs&  z'BaseDatabaseSchemaEditor._create_fk_sqlcs<fdd}t|jj|jgt|jjjjd|jjg||S)Ncj|i|Sr&rWrArlr@rrcreate_fk_namezDBaseDatabaseSchemaEditor._fk_constraint_name..create_fk_namer)rrrsrur rr#)r;r#rrrrr@rrs z,BaseDatabaseSchemaEditor._fk_constraint_namecC||j||Sr&)r sql_delete_fkr;r#rrrrrz'BaseDatabaseSchemaEditor._delete_fk_sqlcCs,|durdS|tjkr dS|tjkrdSdS)NrJz DEFERRABLE INITIALLY DEFERREDz DEFERRABLE INITIALLY IMMEDIATE)rZDEFERREDZ IMMEDIATE)r;rrrr_deferrable_constraint_sqls  z3BaseDatabaseSchemaEditor._deferrable_constraint_sqlcCs|durdS|dur dSdS)NFz NULLS NOT DISTINCTTz NULLS DISTINCTrJr)r;nulls_distinctrrr _unique_index_nulls_distinct_sqls z9BaseDatabaseSchemaEditor._unique_index_nulls_distinct_sqlcCsR| s|jjjo(| p|jjjo(| p|jjjo(| p|jjjo(|dup(|jjjSr&)r5r8Zsupports_partial_indexesZ&supports_deferrable_unique_constraintsrbrZ*supports_nulls_distinct_unique_constraints)r;r`rrgrhrrrr_unique_supporteds  z*BaseDatabaseSchemaEditor._unique_supportedc sj||||| ds dS|s|s|s|s| dur/j|||||||| d} | r-j| dSjdfdd|D|d} j|| dS)Nr`rrgrhr)rr`rgrfrhrrhcsg|]}|jqSr)rWrur\r@rrr]r^z8BaseDatabaseSchemaEditor._unique_sql..)rrrrf) rrkr=rPsql_unique_constraintr}rsql_constraintrW) r;r#rrr`rrgrfrhrrFrfrr@r _unique_sqlsL  z$BaseDatabaseSchemaEditor._unique_sqlc  Cs|j||||| ds dSt|ddj|jd} |jj} dd|D} |dur/|j| | dd}n||}|s<|s<|s<|r@|j} n|j } | rO|j | | d |d } nt | || |j } t | t| |j|| ||||||||| d S) NrFrir_cSrjrrkr\rrrr]rz?BaseDatabaseSchemaEditor._create_unique_sql..Trr)rerf)rirrr`rrgr)rrrr5rrsrrWsql_create_unique_indexsql_create_uniquerrrrSrr rarrcr)r;r#rrr`rrgrfrhrrrirrFrrrrksD     z+BaseDatabaseSchemaEditor._create_unique_sqlcs&|r fdd}nj}t||d|S)Ncrr&rrlr@rrcreate_unique_name<rzLBaseDatabaseSchemaEditor._unique_constraint_name..create_unique_name_uniq)rAr)r;rirrrrr@rr9sz0BaseDatabaseSchemaEditor._unique_constraint_namec CsD|j|||||ds dS|s|s|s|r|j} n|j} || ||S)Nr)rrrr) r;r#rr`rrgrfrhrrFrrrr4Ds z+BaseDatabaseSchemaEditor._delete_unique_sqlcCs |j|||jd|idS)Nr`r)rrWro)r;rr`rrr _check_sql]s z#BaseDatabaseSchemaEditor._check_sqlcCs2|jjjsdSt|jt|jj|j|||dS)N)rirr`) r5r8 supports_table_check_constraintsrsql_create_checkr rrsrW)r;r#rr`rrrrBcs z*BaseDatabaseSchemaEditor._create_check_sqlcCs|jjjsdS||j||Sr&)r5r8rrsql_delete_checkrrrrr7ms z*BaseDatabaseSchemaEditor._delete_check_sqlcCs t|t|jj|j||dSrs)rr rrsrW)r;templater#rrrrrrs z/BaseDatabaseSchemaEditor._delete_constraint_sqlc s|dur fdd|D}j} jj| |jj} Wdn1s'wYg} | D]Y\} }|dus@||dkr|durK|d|krKq2|durV|d|krVq2|dura|d|kraq2|durl|d|krlq2|duru|d suq2|dur|d |krq2| r| | vr| | q2| S) z@Return all constraint names matching the columns and conditions.Ncs@g|]}jjjrjjt|jjnjj|qSr)r5r8Ztruncates_names introspectionZidentifier_converterr rVrZ)r)rr@rrr]s  z>BaseDatabaseSchemaEditor._constraint_names..rrrrr`rr)r5rTrZget_constraintsrrsitemsrP)r;r#r]rrrrr`r-rrTr{resultrZinfodictrr@rrys8    z*BaseDatabaseSchemaEditor._constraint_namescCsV|j|dd}|rt|dkrtdt||jjf|D] }||||qdS)NTrrz0Found wrong number (%s) of PK constraints for %s)rrrrrsrA_delete_primary_key_sql)r;r#r#rrCrrrr>sz,BaseDatabaseSchemaEditor._delete_primary_keyc CsJt|jt|jj|j||j|jj|jgddt|jj|jg|jdS)NZ_pkr0)rirr) r sql_create_pkr rrsrWrArurrrrrr@sz0BaseDatabaseSchemaEditor._create_primary_key_sqlcCrr&)r sql_delete_pkrrrrrrz0BaseDatabaseSchemaEditor._delete_primary_key_sqlcCs|r d||SdS)NzCOLLATE rJ)rW)r;rrDr\rrrrrz%BaseDatabaseSchemaEditor._collate_sqlcCs*|j||d|d}||dS)N,)Z procedure param_types)sql_delete_procedurerWr}rA)r;Zprocedure_namerrFrrrremove_procedures z)BaseDatabaseSchemaEditor.remove_procedure)FT)r)F)rJr&)NNNNN)NNNNNN)NNNNNNN)T)NNNNNNNNr)v__name__ __module__ __qualname____doc__r|rrrrrrRrLrMrQrPrOrrr=rroZsql_delete_constraintrrrrrrrvr rrqrrvrrrrrrSr<r?rBrArWrrrmrrrrrr staticmethodrrrSrrrrrrrrrrrrrrrr(r+r"r;rr:r9rrr!rAr_rarcrr6rrrrrr ryr3r?r8rxrrrrrrrkrr4rrBr7rrr>r@rrrrrrrr4KsT   S A   $   "  V L v ' .     6     8 3    -  r4)!loggingr rZ django.confrZ!django.db.backends.ddl_referencesrrrrrr Zdjango.db.backends.utilsr r r Zdjango.db.modelsr rrZdjango.db.models.sqlrZdjango.db.transactionrrZ django.utilsr getLoggerrLrr$r0r4rrrrs