o lfd@sddlZddlZddlmZddlmZddlmZmZmZm Z m Z m Z ddl m Z mZmZddlmZmZddlmZddlmZmZdd lmZed Zd d Zd dZddZGdddZdS)N)datetime)settings)Columns ExpressionsForeignKeyName IndexName StatementTable) names_digestsplit_identifier truncate_name) 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_key to_fieldsname)relation altered_fieldrrb/var/www/ticemtrilhas/avaliacao_env/lib/python3.10/site-packages/django/db/backends/base/schema.py_is_relevant_relations  rcCs"t|jjdddddtddS)NFT)forwardreverseinclude_hiddeninclude_parentsr)key)sorted_meta _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_fieldrrr1=r2)zipr)r(_related_non_m2m_objects remote_field)r0r3related_fieldsold_relnew_relr)r3r0rr54s     r5c @sLeZdZdZdZdZdZdZdZdZ 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:Z3e4d;d<Z5d=d>Z6d?d@Z7dAdBZ8dCdDZ9dEdFZ:dGdHZ;dIdJZdOdPZ?dQdRZ@dSdTZAdUdVZBdWdXZCdYdZZDd[d\ZEd]d^ZFdd_d`ZG ddadbZHdcddZIddedfZJdgdhZKdidjZLdkdlZMdmdnZNddpdqZOddrdsZPdtduZQdvdwZRdddododd(dd(ddddx dydzZSdd{d|ZTd}d~ZUddZVddZWddZXdddZYddZZddZ[ddZ\ddZ]ddZ^ddZ_ddZ`ddZa     dddZb      dddZcdddZd     dddZeddZfddZgddZhddZi        dddZjdddZkddZlddZmdddZndddZodS)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)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)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)selfr;r<rrrr__init__s z!BaseDatabaseSchemaEditor.__init__cCs(g|_|jrt|jj|_|j|Sr+) deferred_sqlr@rr;alias __enter__rArrrrEs  z"BaseDatabaseSchemaEditor.__enter__cCs<|dur|jD]}||q|jr|j|||dSdSr+)rCexecuter@r__exit__)rAexc_type exc_value tracebacksqlrrrrHs   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))paramsrL)extra;N)r<r;in_atomic_blockr>r?rstrloggerdebugrstripendswithr=appendtuplemap quote_valuecursorrG)rArLrMendingr[rrrrGs. "z BaseDatabaseSchemaEditor.executecCs|jj|Sr+)r;ops quote_name)rArrrrr^z#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..Nr;check z %s)to_table to_column_fk_%(to_table)s_%(to_column)sz%s %s) AutoField BigAutoFieldSmallAutoFieldcsg|]}|qSr)constraint_sqlr. constraintr(rArrrd s , css|] }|rt|VqdSr+)rRrprrrr1s z5BaseDatabaseSchemaEditor.table_sql..)table definition) r#unique_togetherrCrW_create_unique_sql local_fields column_sql db_parametersr;sql_check_constraintdb_type_suffixextendr6 db_constraintr(db_tablerb field_namecolumnsql_create_inline_fkr^r>supports_foreign_keys_create_fk_sqlget_internal_typer] autoinc_sql constraintssql_create_tablejoin db_tablespacetablespace_sql)rAr( field_namesfields column_sqlsrMrru extra_params db_paramscol_type_suffixrirjrrrLrrrrr table_sqls                 z"BaseDatabaseSchemaEditor.table_sqlc csL|V|d}r||V|jjjr |jr ||jV|j}|o2|| o2|o1| | }|r[| |} | dur[d| |} |jjj rS| | | Vn| V|| |jrh|jsh|jjjrhd}|sndVn|jjjsvdV|jr}dVn|jrdV|jp|jj} | r|jjjr|jr|jjj| ddVdSdSdSdS) N collationzDEFAULT TzNOT NULLNULLz PRIMARY KEYUNIQUE)inline)get _collate_sqlr;r>supports_comments_inline db_comment _comment_sqlnull skip_defaultskip_default_on_altereffective_default_column_default_sqlrequires_literal_defaultsprepare_defaultrWempty_strings_allowedr!interprets_empty_strings_as_nullsimplied_column_nulluniquerr#supports_tablespacesr]r) rAcolumn_db_typerMr(rfield_db_paramsinclude_defaultrr default_valuecolumn_default tablespacerrr_iter_column_sql!sX       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. rftypeNNNrh)rzr;rr)rAr(rrrrrMrrrryZs" z#BaseDatabaseSchemaEditor.column_sqlcCdS)z Some backends don't accept default values for certain columns types (i.e. MySQL longtext and longblob). FrrArrrrruz%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. Frrrrrr|rz.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() methodNotImplementedErrorrAvaluerrrrsz(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_sqlcCs|r |}|S|js!|jr!|jr!|dkrd}|Sd}|St|dds-t|ddrS|}|dkr;t}|St }|dkrI| }|S|d krQ| }|Sd}|S) N BinaryFieldrPauto_nowF auto_now_add DateTimeField DateField TimeField) has_default get_defaultrblankrrgetattrrnowrdatetime)rdefault internal_typerrr_effective_defaults.   z+BaseDatabaseSchemaEditor._effective_defaultcCs||||jS)z2Return a field's effective database default value.)get_db_prep_saverr;rrrrrsz*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). rrrrrrZsz$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`. Nrfr)rrGr;r>supports_commentsr#db_table_commentalter_db_table_commentrrxrrz_alter_column_comment_sqlrCr}_model_indexes_sqllocal_many_to_manyr6through auto_created create_model)rAr(rLrMrr 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.rtN)r#rr6rr delete_modelrGsql_delete_tabler^rlistrC isinstancerreferences_tableremove)rAr(rrLrrrrs"   z%BaseDatabaseSchemaEditor.delete_modelcCs.|jr |jjjs dS|j|||dddS)zAdd an index on a model.NrM)contains_expressionsr;r>supports_expression_indexesrG create_sqlrAr(indexrrr add_indexs z"BaseDatabaseSchemaEditor.add_indexcCs*|jr |jjjs dS||||dS)zRemove an index from a model.N)rr;r>rrG remove_sqlrrrr remove_indexs z%BaseDatabaseSchemaEditor.remove_indexcCsF|jjjr|j|||j|jdddS||||||dS)Nr)r;r>can_rename_indexrG_rename_index_sqlrrr)rAr( old_index new_indexrrr rename_indexs  z%BaseDatabaseSchemaEditor.rename_indexcCs&|||}|r|j|dddSdS)zAdd a constraint to a model.Nr)rrGrAr(rqrLrrradd_constraints z'BaseDatabaseSchemaEditor.add_constraintcCs"|||}|r||dSdS)z!Remove a constraint from a model.N)rrGrrrrremove_constraints 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|qSrrXr.rrrr &zABaseDatabaseSchemaEditor.alter_unique_together..cSrrrrrrrr'rTF)rrcr`rrarcr'rrrd2rezBBaseDatabaseSchemaEditor.alter_unique_together..N) difference_delete_composed_indexsql_delete_uniquerGrw)rAr(old_unique_togethernew_unique_togetheroldsnewsrrrr'ralter_unique_together sz.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)rrcr`rrarcr'rrrdGrezABaseDatabaseSchemaEditor.alter_index_together.._idxrsuffixN)rrsql_delete_indexrG_create_index_sql)rAr(old_index_togethernew_index_togetherrrrrrr'ralter_index_together5sz-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|]}|jqSrrrprrrrKzBBaseDatabaseSchemaEditor._delete_composed_index..cSrrrrprrrrNcsg|] }j|jqSr)r#rbrrcr'rrrdOszCBaseDatabaseSchemaEditor._delete_composed_index..excluderTFquotez1Found wrong number (%s) of constraints for %s(%s)rsr)r#rindexes_constraint_namesrr;r>*allows_multiple_constraints_on_same_fieldsrR_unique_constraint_namerlen ValueErrorrrG_delete_constraint_sql) rAr(rconstraint_kwargsrLmeta_constraint_namesmeta_index_namescolumnsconstraint_names default_namerr'rrJsB 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) old_table new_table) r;r>ignores_table_name_caselowerrGsql_rename_tabler^rCrrrename_table_references)rAr( old_db_table new_db_tablerLrrralter_db_tablels"   z'BaseDatabaseSchemaEditor.alter_db_tablecCsF|jr|jjjr!||j||jj||pdddSdSdS)NrP)rtcomment) sql_alter_table_commentr;r>rrGr^r#rrZ)rAr(old_db_table_commentnew_db_table_commentrrrrs  z/BaseDatabaseSchemaEditor.alter_db_table_commentcCs2||j||jj||||ddS)z)Move a model's table between tablespaces.)rtold_tablespacenew_tablespaceN)rGsql_retablespace_tabler^r#r)rAr(old_db_tablespacenew_db_tablespacerrralter_db_tablespaces z,BaseDatabaseSchemaEditor.alter_db_tablespacec Cs@|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 } || |||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)rNrfrhrgrkz%s.rP)r namespacerrirj deferrable)rtrrudroprtchangesr)*rr6rr#rrryr|r;rzr{r>rr~sql_create_column_inline_fkr(rrbrrr _fk_constraint_namer^r]deferrable_sqlrCrWrsql_create_columnrGrr_alter_column_default_sqlsql_alter_columnrrrrr}_field_indexes_sqlconnection_persists_old_columnsclose)rAr(rrurMrrconstraint_suffixrirjr)_rL 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. rfrNT foreign_key)rtr)rr6rr#rrrzr;r rrG_delete_fk_sqlsql_delete_columnr^rr>r6r7rrCrrreferences_columnr)rAr(rfk_namesfk_namerLrrr remove_fields,       z%BaseDatabaseSchemaEditor.remove_fieldc Cs0|||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| ||||||||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. NrfrzqCannot 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_alteredrzr;r6rrr#r_alter_many_to_many _alter_field) rAr(r0r3strict old_db_paramsold_type new_db_paramsnew_typerrr alter_field sf      z$BaseDatabaseSchemaEditor.alter_fieldc / Cst} |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|d|dkrX|drXdd|j jD} |j||jgd| d} |rIt | dkrIt dt | |j j |jf| D] }||||qK|j|jkr|||j j ||||j D]}t!|t"r|#|j j |j|jqog}g}g}|j$|jd}|j$|jd}||ks||ks||ks|jjj%r|j&|j&kr|'||||||\}}|(||)|d } |j*r|j*s|+|}!|+|}"|,|s|!|"kr|"durd} |(|-||||j*|j*kr|.|||}|r|(||/o|j*o|j* }#|s#|r|#s*||7}|jjj0rF|rFt1t2|\}}$d3|t4|$gfg}|D]\}}$||j5|6|j j |d|$qH|#r||j7|6|j j |6|jdd|"g|D]\}}$||j5|6|j j |d|$q{|r|D] \}}$|||$q|jr|js|8|||9||r||:||g|jr|jr|jr|js||j;||gdg}%|r|%)t|||||r||<|||%)t|||%D]V\}&}|jj=|jd}'|'d}(|'d })|&jj=|jd}*|*d }+|'|j|&j|j|(|+|)\}}||j5|6|jj j |dd|d|D] \}}$|||$qMq|jjjr~|jr~| sp|jrp|js~|jr~||>||d|r|%D]\},}-|-jjr||>|-j|-jdq|d|dkr|dr|j?|j j |jgdd}||@|||d| r|j-|||dd \}.}$|j5|6|j j |.d}|||$|jjjAr|jBdSdS)!z3Perform a "physical" (non-ManyToMany) field update.r)ignoreTr<rz.F)rrrz7Found wrong number (%s) of unique constraints for %s.%srcSrrr)r.rrrrrr)rtype_rrgcSrrrrprrrrr)rgrz6Found wrong number (%s) of check constraints for %s.%srfNrsr-r)rtrrrrrrk_fk_checkrr+)Csetr;r>rr6r~rDr rr rr#raddrGr>r_field_became_primary_keyr_delete_unique_sqlrrr5 related_modelrdb_indexr rr_delete_index_sql_delete_check_sql_rename_field_sqlrCrrrename_column_referencesr|rr_alter_column_type_sqlrWr}rrrr3_alter_column_null_sqlrsupports_combined_altersrXr4rsumr4r^sql_update_with_default_delete_primary_key_unique_should_be_addedrwr_create_primary_key_sqlrzr_create_index_name_create_check_sqlr6r7)/rAr(r0r3rIrKrHrJrG fks_droppedrArBrrconstraint_name old_collation new_collationdrop_foreign_keys_old_relr9 rel_fk_namesr index_names index_namerLactions null_actions post_actionsold_type_suffixnew_type_suffixfragment other_actionsneeds_database_default old_default new_defaultfour_way_default_alterationrMrels_to_updater8 rel_db_paramsrel_type rel_collationold_rel_db_paramsold_rel_collationr9relr:rrrrFJs,                                              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. Nrfr)rr) r;r>rrrzrsql_alter_column_nullsql_alter_column_not_nullr^r)rAr(r0r3rJrLrrrr^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. rfr)rrr) rrr;r>rrrzr sql_alter_column_no_default_nullsql_alter_column_no_defaultsql_alter_column_defaultr^r) rAr(r0r3r,ryrrMrJrLrrrr3s,     z2BaseDatabaseSchemaEditor._alter_column_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 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. rhrP)rrrr)rr#rr;r>rrrrrWrsql_alter_column_typer^r) rAr(r0r3rKrirjrv collate_sql comment_sqlrLrMrrrr]s6        z/BaseDatabaseSchemaEditor._alter_column_type_sqlcCs.|j||jj||j||dgfS)N)rtrr)sql_alter_column_commentr^r#rrr)rAr(r3rKnew_db_commentrrrrs  z2BaseDatabaseSchemaEditor._alter_column_comment_sqlcCs||pdS)NrP)rZ)rArrrrr r_z%BaseDatabaseSchemaEditor._comment_sqlcCs|jjjj|jjjjkr||jj|jjjj|jjjj||jj|jjj||jjj|||jj|jjj||jjj|dS)z*Alter M2Ms to repoint their to= endpoints.N) r6rr#rrrLrbm2m_reverse_field_namem2m_field_name)rAr(r0r3rGrrrrE#s,       z,BaseDatabaseSchemaEditor._alter_many_to_manyrPc 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_%sr9NrrzD%s)r r r;r]max_name_lengthrr isdigit) rA table_name column_namesrr9hash_suffix_part max_lengthro other_lengthrrrreCs(   z+BaseDatabaseSchemaEditor._create_index_namecCsf|dur$t|dkr|djr|dj}ntjrtj}n|jjr$|jj}|dur1d|jj|SdS)NrrrhrP)r rrDEFAULT_INDEX_TABLESPACEr#r;r]r)rAr(rrrrr_get_index_tablespace_sqlcs z2BaseDatabaseSchemaEditor._get_index_tablespace_sqlcCs|rd|SdS)Nz WHERE rPr)rA conditionrrr_index_condition_sqlosz-BaseDatabaseSchemaEditor._index_condition_sqlcCs,|r|jjjs dStdt|jj||jdS)NrPz INCLUDE (%(columns)s))r)r;r>supports_covering_indexesrrr#rr^)rAr(rrrr_index_include_sqlts z+BaseDatabaseSchemaEditor._index_include_sql) rrrusingr col_suffixesrL opclassesrinclude 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, ...). F alias_colsrf)rcSg|]}|jqSrrrcrrrrdrz>BaseDatabaseSchemaEditor._create_index_sql..cs"dur j|i|Sr+)rer^argskwargsrrArrcreate_index_names zEBaseDatabaseSchemaEditor._create_index_sql..create_index_name)rtrrrrNrr)r get_compilerr;rsql_create_indexr#rrr r^r_index_columnsrrZrr)rAr(rrrrrrrLrrrrcompilerrrrrtrrrrr|s0     z*BaseDatabaseSchemaEditor._create_index_sqlcCs&t|p|jt|jj|j||dSN)rtr)rrr r#rr^)rAr(rrLrrrrYs z*BaseDatabaseSchemaEditor._delete_index_sqlcCs*t|jt|jj|j||||dS)N)rtold_namenew_name)rsql_rename_indexr r#rr^)rAr(rrrrrrs z*BaseDatabaseSchemaEditor._rename_index_sqlcCst|||j|dS)N)r)rr^)rArtrrrrrrrsz'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. cr`rrarcr'rrrdrez?BaseDatabaseSchemaEditor._model_indexes_sql..rr)r#managedproxyswappedrxr}r5index_togetherrWrr rr;r>rr)rAr(outputrrrrrr'rrs    z+BaseDatabaseSchemaEditor._model_indexes_sqlcCs*g}|||r||j||gd|S)zT Return a list of all index SQL statements for the specified field. rO)_field_should_be_indexedrWr)rAr(rrrrrr5s z+BaseDatabaseSchemaEditor._field_indexes_sqlc Cs|pt}|\}}}}|\}}} } ||jD]} || dq||jD]} | | dq*||j||jkpH|||f|| | fkSr+)rS deconstructunion non_db_attrspopr^r) rAr0r3rMr9old_pathold_args old_kwargsnew_pathnew_args new_kwargsattrrrrrDs z1BaseDatabaseSchemaEditor._field_should_be_alteredcCs|jo|j Sr+)rXrrAr(rrrrrr_z1BaseDatabaseSchemaEditor._field_should_be_indexedcCs|j o|jSr+rrAr0r3rrrrUr_z2BaseDatabaseSchemaEditor._field_became_primary_keycCs|j o |jo |j p |jSr+)rrrrrrrcs  z0BaseDatabaseSchemaEditor._unique_should_be_addedcCs*|j||||j||j|dS)N)rt old_column new_columnr)sql_rename_columnr^r)rArtr0r3rKrrrr[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)rtrrrirjr*)r r#rr^r0rr target_fieldr(r;r]r1r sql_create_fk) rAr(rrrtrrrirjr*rrrr s&  z'BaseDatabaseSchemaEditor._create_fk_sqlcs<fdd}t|jj|jgt|jjjjd|jjg||S)Ncj|i|Sr+r^rerrFrrcreate_fk_name zDBaseDatabaseSchemaEditor._fk_constraint_name..create_fk_namer)rr#rrr rr()rAr(rrrrrFrr0s z,BaseDatabaseSchemaEditor._fk_constraint_namecC||j||Sr+)r sql_delete_fkrAr(rrrrr>,z'BaseDatabaseSchemaEditor._delete_fk_sqlcCs,|durdS|tjkr dS|tjkrdSdS)NrPz DEFERRABLE INITIALLY DEFERREDz DEFERRABLE INITIALLY IMMEDIATE)r DEFERRED IMMEDIATE)rAr*rrr_deferrable_constraint_sql/s  z3BaseDatabaseSchemaEditor._deferrable_constraint_sqlc s|r jjjs dS|s|s|s|r'j|||||||d} | r%j| dSjdfdd|D|d} j || dS)N)rrrrrrscsg|]}|jqSr)r^rrcrFrrrdWrez8BaseDatabaseSchemaEditor._unique_sql..)rr*rrq) r;r>&supports_deferrable_unique_constraintsrwrCrWsql_unique_constraintrrsql_constraintr^) rAr(rrrr*rrrrLrqrrFr _unique_sql7s4  z$BaseDatabaseSchemaEditor._unique_sqlc Cs|r|jjjr|r|jjjr|r|jjjr|r|jjjsdSt|ddj|jd} |jj } dd|D} |durA|j | | dd}n| |}|sN|sN|sN|rR|j } n|j } | ra|j| | d|d } nt| || |j} t| t| |j || |||||||d S) NFrrfcSrrrrcrrrrd{rz?BaseDatabaseSchemaEditor._create_unique_sql..Trr)rr)rtrrrr*r)r;r>rsupports_partial_indexesrrrrr#rr r^sql_create_unique_indexsql_create_uniquerrrZrr rrr) rAr(rrrr*rrrrrtrrLrrrrw_sT     z+BaseDatabaseSchemaEditor._create_unique_sqlcs&|r fdd}nj}t||d|S)Ncrr+rrrFrrcreate_unique_namerzLBaseDatabaseSchemaEditor._unique_constraint_name..create_unique_name_uniq)rer)rArtrrrrrFrr sz0BaseDatabaseSchemaEditor._unique_constraint_namec Csh|r|jjjr|r|jjjr|r|jjjr|r|jjjsdS|s&|s&|s&|r*|j}n|j}||||Sr+) r;r>rrrrrrr) rAr(rrr*rrrrLrrrrVs*  z+BaseDatabaseSchemaEditor._delete_unique_sqlcCs |j|||jd|idS)Nrgr)rr^r{)rArrgrrr _check_sqls z#BaseDatabaseSchemaEditor._check_sqlcCs$t|jt|jj|j|||dS)N)rtrrg)rsql_create_checkr r#rr^)rAr(rrgrrrrfs z*BaseDatabaseSchemaEditor._create_check_sqlcCs|jjjsdS||j||Sr+)r;r> supports_table_check_constraintsrsql_delete_checkrrrrrZs z*BaseDatabaseSchemaEditor._delete_check_sqlcCs t|t|jj|j||dSr)rr r#rr^)rAtemplater(rrrrrs 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)r;r>truncates_names introspectionidentifier_converterr r]r)r.rrFrrrds  z>BaseDatabaseSchemaEditor._constraint_names..rrrrrgr=r)r;r[rget_constraintsr#ritemsrW)rAr(rrrrr=rgrNrr[rresultrinfodictrrFrr s8    z*BaseDatabaseSchemaEditor._constraint_namescCsV|j|dd}|rt|dkrtdt||jjf|D] }||||qdS)NTrrz0Found wrong number (%s) of PK constraints for %s)r r rr#rrG_delete_primary_key_sql)rAr(rGrrhrrrrbsz,BaseDatabaseSchemaEditor._delete_primary_keyc CsJt|jt|jj|j||j|jj|jgddt|jj|jg|jdS)N_pkrR)rtrr) r sql_create_pkr r#rr^rerrrrrrrdsz0BaseDatabaseSchemaEditor._create_primary_key_sqlcCrr+)r sql_delete_pkrrrrrrz0BaseDatabaseSchemaEditor._delete_primary_key_sqlcCs|r d||SdS)NzCOLLATE rP)r^)rArrirrrrrrz%BaseDatabaseSchemaEditor._collate_sqlcCs*|j||d|d}||dS)N,) procedure param_types)sql_delete_procedurer^rrG)rAprocedure_namerrLrrrremove_procedure!s z)BaseDatabaseSchemaEditor.remove_procedure)FT)r)F)rPr+)NNNNN)NNNNNN)T)NNNNNNNNr)p__name__ __module__ __qualname____doc__rrr%rr2r4rrrrrrr?rrarr{sql_delete_constraintrrrrrrrr/rrrrrrrrr rrBrErHrGr^rrryrrrr staticmethodrrrZrrrrrrrrrrrrr(r;rCrLrFr^r3r]rrrErerrrrrYrrrr5rDrrUrcr[rr0r>rrrwr rVrrfrZrr rbrdrrrrrrrr:Ks6   S 9   $   "  V I \ &.     6    , 5   -  r:) loggingr%r django.confr!django.db.backends.ddl_referencesrrrrrr django.db.backends.utilsr r r django.db.modelsr rdjango.db.models.sqlrdjango.db.transactionrr django.utilsr getLoggerrSrr)r5r:rrrrs