a Qh@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&|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_key to_fieldsname)relationZ altered_fieldrrW/var/www/sistema_ama/venv/lib/python3.9/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#sbtfddtjDfddtjD}|D]&\}}||fVt|j|jEdHq6dS)Nc3s|]}t|r|VqdSNr.0obj) old_fieldrr 8s z+_related_non_m2m_objects..c3s|]}t|r|VqdSr)r*r+) new_fieldrrr/=s )zipr(r'_related_non_m2m_objects remote_field)r.r0related_fieldsold_relnew_relr)r0r.rr24s    r2c @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:Z3e4d;d<Z5d=d>Z6d?d@Z7dAdBZ8dCdDZ9dEdFZ:dGdHZ;dIdJZdOdPZ?dQdRZ@dSdTZAdUdVZBdWdXZCdYdZZDd[d\ZEd]d^ZFdd_d`ZGddadbZHdcddZIddedfZJdgdhZKdidjZLdkdlZMdmdnZNddpdqZOddrdsZPdtduZQdvdwZRdddododd(dd(ddddx dydzZSdd{d|ZTd}d~ZUddZVddZWddZXdddZYddZZddZ[ddZ\ddZ]ddZ^ddZ_ddZ`ddZadddZbdddZcdddZddddZeddZfddZgddZhddZidddZjdddZkddZlddZmdddZndddZodS)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,||_||_|jrg|_|jjjo$||_dSr)) connection collect_sql collected_sqlfeaturescan_rollback_ddlatomic_migration)selfr8r9rrrr__init__s z!BaseDatabaseSchemaEditor.__init__cCs(g|_|jr$t|jj|_|j|Sr)) deferred_sqlr=rr8alias __enter__r>rrrrBs  z"BaseDatabaseSchemaEditor.__enter__cCs8|dur|jD]}||q|jr4|j|||dSr))r@executer=r__exit__)r>exc_type exc_value tracebacksqlrrrrEs   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))paramsrI)extra;N)r9r8in_atomic_blockr;r<rstrloggerdebugrstripendswithr:appendtuplemap quote_valuecursorrD)r>rIrJendingrXrrrrDs, z BaseDatabaseSchemaEditor.executecCs|jj|Sr))r8ops quote_name)r>rrrrr[sz#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,rr&rr z6BaseDatabaseSchemaEditor.table_sql..Nr8check z %s)to_table to_column_fk_%(to_table)s_%(to_column)sz%s %s) AutoField BigAutoFieldSmallAutoFieldcsg|]}|qSr)constraint_sqlr, constraintr'r>rrr_ s, css|]}|rt|VqdSr))rOrkrrrr/sz5BaseDatabaseSchemaEditor.table_sql..)table definition) r"unique_togetherr@rT_create_unique_sql local_fields column_sql db_parametersr8sql_check_constraintdb_type_suffixextendr3 db_constraintr'db_tabler] field_namecolumnsql_create_inline_fkr[r;supports_foreign_keys_create_fk_sqlget_internal_typerZ autoinc_sql constraintssql_create_tablejoin db_tablespacetablespace_sql)r>r' field_namesfieldsZ column_sqlsrJrrp extra_params db_paramscol_type_suffixrdrerrrIrrrmr table_sqlsz               z"BaseDatabaseSchemaEditor.table_sqlc csH|V|d}r ||V|jjjr>|jr>||jV|j}|ob|| ob|o`| | }|r| |} | durd| |} |jjj r| | | Vn| V|| |jr|js|jjjrd}|sdVn|jjjsdV|jrdVn|jrdV|jp|jj} | rD|jjjrD|jrD|jjj| ddVdS) N collationzDEFAULT TzNOT NULLNULLz PRIMARY KEYUNIQUE)inline)get _collate_sqlr8r;supports_comments_inline db_comment _comment_sqlnull skip_defaultskip_default_on_altereffective_default_column_default_sqlrequires_literal_defaultsprepare_defaultrTempty_strings_allowedr!interprets_empty_strings_as_nullsimplied_column_nulluniquerr"supports_tablespacesrZr) r>column_db_typerJr'rfield_db_paramsinclude_defaultrr default_valueZcolumn_default tablespacerrr_iter_column_sql!sT       z)BaseDatabaseSchemaEditor._iter_column_sqlc CsD|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. ratypeN)NNrc)rur8rr)r>r'rrrrrJrrrrtZs" z#BaseDatabaseSchemaEditor.column_sqlcCsdS)z Some backends don't accept default values for certain columns types (i.e. MySQL longtext and longblob). Frr>rrrrrusz%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|sz.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>valuerrrrsz(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. %srrrrrrsz,BaseDatabaseSchemaEditor._column_default_sqlcCs|r|}n|js<|jr<|jr<|dkr6d}qd}nbt|ddsTt|ddr|}|dkrnt}qt }|dkr| }q|d kr| }nd}|S) N BinaryFieldr`rMauto_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_saverr8rrrrrsz*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). NrrrrrrWsz$BaseDatabaseSchemaEditor.quote_valuecCs||\}}|||pd|jjjr|jjrB||d|jj|jjjs|jj D]8}|j rT|j |jd}|d}|j| ||||j qT|j |||jjD]}|jjjjr||jjqdS)zr Create a table and any accompanying indexes or unique constraints for the given `model`. Nrar)rrDr8r;supports_commentsr"db_table_commentalter_db_table_commentrrsrru_alter_column_comment_sqlr@rx_model_indexes_sqllocal_many_to_manyr3through auto_created create_model)r>r'rIrJrr field_typerrrrs*      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.roN)r"rr3rr delete_modelrDsql_delete_tabler[rzlistr@ isinstancerreferences_tableremove)r>r'rrIrrrrs  z%BaseDatabaseSchemaEditor.delete_modelcCs.|jr|jjjsdS|j|||dddS)zAdd an index on a model.NrJ)contains_expressionsr8r;supports_expression_indexesrD create_sqlr>r'indexrrr add_indexs z"BaseDatabaseSchemaEditor.add_indexcCs*|jr|jjjsdS||||dS)zRemove an index from a model.N)rr8r;rrD remove_sqlrrrr remove_indexs z%BaseDatabaseSchemaEditor.remove_indexcCsD|jjjr(|j|||j|jddn||||||dS)Nr)r8r;can_rename_indexrD_rename_index_sqlrrr)r>r' old_index new_indexrrr rename_indexs  z%BaseDatabaseSchemaEditor.rename_indexcCs"|||}|r|j|dddS)zAdd a constraint to a model.Nr)rrDr>r'rlrIrrradd_constraints z'BaseDatabaseSchemaEditor.add_constraintcCs|||}|r||dS)z!Remove a constraint from a model.N)rrDrrrrremove_constraints z*BaseDatabaseSchemaEditor.remove_constraintcs|dd|D}dd|D}||D]}||ddd|jq&||D](}fdd|D}|||qNd 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. cSsh|] }t|qSrrUr,rrrr &r`zABaseDatabaseSchemaEditor.alter_unique_together..cSsh|] }t|qSrrrrrrr'r`TF)rrcsg|]}j|qSrr\r^r&rrr_2r`zBBaseDatabaseSchemaEditor.alter_unique_together..N) difference_delete_composed_indexsql_delete_uniquerDrr)r>r'Zold_unique_togetherZnew_unique_togetheroldsnewsrrrr&ralter_unique_together sz.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;r`z@BaseDatabaseSchemaEditor.alter_index_together..cSsh|] }t|qSrrrrrrr<r`TF)rrcsg|]}j|qSrr\r^r&rrr_Gr`zABaseDatabaseSchemaEditor.alter_index_together.._idxrsuffixN)rrsql_delete_indexrD_create_index_sql)r>r'Zold_index_togetherZnew_index_togetherrrrrrr&ralter_index_together5sz-BaseDatabaseSchemaEditor.alter_index_togetherc sddjjD}ddjjD}fdd|D}|j|fd||Bi|}|ddur|r|jjjrt|j jj |d d } | |vr| g}t |d krt d t |jj d |f||||ddS)NcSsh|] }|jqSrrrkrrrrKszBBaseDatabaseSchemaEditor._delete_composed_index..cSsh|] }|jqSrrrkrrrrNr`csg|]}j|jqSr)r"r]r|r^r&rrr_Or`zCBaseDatabaseSchemaEditor._delete_composed_index..excluderTFquotez1Found wrong number (%s) of constraints for %s(%s)rnr)r"rindexes_constraint_namesrr8r;*allows_multiple_constraints_on_same_fieldsrO_unique_constraint_namerzlen ValueErrorrrD_delete_constraint_sql) r>r'rZconstraint_kwargsrImeta_constraint_namesmeta_index_namescolumnsconstraint_names default_namerr&rrJsD  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) r8r;ignores_table_name_caselowerrDsql_rename_tabler[r@rrZrename_table_references)r>r' old_db_table new_db_tablerIrrralter_db_tablels   z'BaseDatabaseSchemaEditor.alter_db_tablecCs.||j||jj||pdddS)NrM)rocomment)rDsql_alter_table_commentr[r"rzrW)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.)roZold_tablespaceZnew_tablespaceN)rDsql_retablespace_tabler[r"rz)r>r'Zold_db_tablespaceZnew_db_tablespacerrralter_db_tablespaces z,BaseDatabaseSchemaEditor.alter_db_tablespacec CsJ|jr |jjjjr ||jjS|j||dd\}}|dur@dS|j|jd}r`|d|7}|j |jd}|dr|d|j |7}|jrT|jj j rT|j rTd}|jr>|jjjj}|jjj|jjj} t|jj\} } |d|j||||| r d|| 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(rF|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)rNrarcrbrfz%s.rM)r namespacer|rdre deferrable)ror|rpdroprochangesr)*rr3rr"rrrtrwr8rurvr;r~rysql_create_column_inline_fkr'rzr]r{r|r _fk_constraint_namer[rZdeferrable_sqlr@rTrsql_create_columnrDrr_alter_column_default_sqlsql_alter_columnrrrrrx_field_indexes_sqlconnection_persists_old_columnsclose)r>r'rrprJrrZconstraint_suffixrdrer _rI changes_sqlrrrr add_fields                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. rarNT foreign_key)ror|)rr3rr"rrrur8rr|rD_delete_fk_sqlsql_delete_columnr[rzr;rrrr@rrZreferences_columnr)r>r'rfk_namesfk_namerIrrr 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. NrarzqCannot 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_alteredrur8r3rrr"r_alter_many_to_many _alter_field) r>r'r.r0strict old_db_paramsold_type new_db_paramsnew_typerrr alter_field st       z$BaseDatabaseSchemaEditor.alter_fieldc / Cst} |jjjr|jr|jr|j||dhdr|j||jgdd} |rnt | dkrnt dt | |j j |jf| D]$} | |jf|||| qr|jr,|jr|||r,dd|j jD} |j||jgdd | d } |rt | dkrt d t | |j j |jf| D]}||||q|d }|d }|jjjo||jr\|jsl|jo||jo|||kp|||k}|rt||D]B\}}|j|j|jjgdd}|D]} |||j| qq|jr<|js<|jr|jr|.|||}|r>|(||/oV|j*oV|j* }#|sd|rB|#sr||7}|jjj0r|rt1t2|\}}$d3|t4|$gfg}|D],\}}$||j5|6|j j |d|$q|#rB||j7|6|j j |6|jdd|"g|D],\}}$||j5|6|j j |d|$q|rd|D]\}}$|||$qL|jr|js|8|||9||r||:||g|jr|jr|jr|js||j;||gdg}%|r|%)t|||||r"||<|||%)t|||%D]\}&}|jj=|jd}'|'d}(|'d })|&jj=|jd}*|*d }+|'|j|&j|j|(|+|)\}}||j5|6|jj j |dd|d|D]\}}$|||$qq&|jjjr|jr| s|jr|js|jr||>||d|rR|%D],\},}-|-jjr$||>|-j|-jdq$|d|dkr|dr|j?|j j |jgdd}||@|||d| r|j-|||dd \}.}$|j5|6|j j |.d}|||$|jjjAr|jBdS)!z3Perform a "physical" (non-ManyToMany) field update.r)ignoreTrrz.F)rrrz7Found wrong number (%s) of unique constraints for %s.%srcSsh|] }|jqSrr)r,rrrrrr`)rtype_rrbcSsh|] }|jqSrrrkrrrrs)rbrz6Found wrong number (%s) of check constraints for %s.%sraNrnrr)ror|rrrrrfZ_fk_checkrr )Csetr8r;r~r3ryr$rr|rrr"rzaddrDrr_field_became_primary_keyr_delete_unique_sqlrrr2 related_modelrdb_indexrrr_delete_index_sql_delete_check_sql_rename_field_sqlr@rrZrename_column_referencesrwrr_alter_column_type_sqlrTrxrrrr_alter_column_null_sqlrsupports_combined_altersrUr1rsumrr[sql_update_with_default_delete_primary_key_unique_should_be_addedrrr_create_primary_key_sqlrur_create_index_name_create_check_sqlrr)/r>r'r.r0r)r+r(r*r'Z fks_droppedr!r"rrconstraint_name old_collation new_collationZdrop_foreign_keysZ_old_relr6Z rel_fk_namesrZ index_names index_namerIactionsZ null_actionsZ post_actionsZold_type_suffixZnew_type_suffixfragment other_actionsZneeds_database_defaultZ old_default new_defaultZfour_way_default_alterationrJZrels_to_updater5Z rel_db_paramsZrel_typeZ rel_collationZold_rel_db_paramsZold_rel_collationrrelrrrrr&Is.                                           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. Nrar)r|r) r8r;rrrursql_alter_column_nullsql_alter_column_not_nullr[r|)r>r'r.r0r*rIrrrr<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. rar)r|rr) rrr8r;rrrur sql_alter_column_no_default_nullsql_alter_column_no_defaultsql_alter_column_defaultr[r|) r>r'r.r0rrLrrJr*rIrrrrs,     z2BaseDatabaseSchemaEditor._alter_column_default_sqlc Csg}||||jj}r&d|}nd}d} |jjjr|js|j|jkrr|||||j\} } | rr| | | f|jr| |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. rcrM)r|rrr)rr"rzr8r;rrrrrTrsql_alter_column_typer[r|) r>r'r.r0r+rFrGrKZ collate_sqlZ comment_sqlrIrJrrrr;s6        z/BaseDatabaseSchemaEditor._alter_column_type_sqlcCs.|j||jj||j||dgfS)N)ror|r)sql_alter_column_commentr[r"rzr|r)r>r'r0r+Znew_db_commentrrrrs  z2BaseDatabaseSchemaEditor._alter_column_comment_sqlcCs||p dS)NrM)rW)r>rrrrrsz%BaseDatabaseSchemaEditor._comment_sqlcCs|jjjj|jjjjkr:||jj|jjjj|jjjj||jj|jjj||jjj|||jj|jjj||jjj|dS)z*Alter M2Ms to repoint their to= endpoints.N) r3rr"rzrr,r]m2m_reverse_field_namem2m_field_name)r>r'r.r0r'rrrr%"s.       z,BaseDatabaseSchemaEditor._alter_many_to_manyrMc 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 r8rZmax_name_lengthrrisdigit) r> table_name column_namesrrZhash_suffix_part max_lengthrHZ other_lengthrrrrCBs(   z+BaseDatabaseSchemaEditor._create_index_namecCsf|durHt|dkr*|djr*|dj}ntjr8tj}n|jjrH|jj}|durbd|jj|SdS)NrrrcrM)rrrDEFAULT_INDEX_TABLESPACEr"r8rZr)r>r'rrrrr_get_index_tablespace_sqlbs z2BaseDatabaseSchemaEditor._get_index_tablespace_sqlcCs|r d|SdS)Nz WHERE rMr)r> conditionrrr_index_condition_sqlnsz-BaseDatabaseSchemaEditor._index_condition_sqlcCs,|r|jjjsdStdt|jj||jdS)NrMz INCLUDE (%(columns)s))r)r8r;supports_covering_indexesrrr"rzr[)r>r'rrrr_index_include_sqlss z+BaseDatabaseSchemaEditor._index_include_sql) rrrusingr col_suffixesrI opclassesrdinclude 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 alias_colsra)rcSsg|] }|jqSrr|r^rrrr_r`z>BaseDatabaseSchemaEditor._create_index_sql..cs"durj|i|Sr))rCr[argskwargsrr>rrcreate_index_nameszEBaseDatabaseSchemaEditor._create_index_sql..create_index_name)rorrhrrKrdrk)r get_compilerr8rcsql_create_indexr"rzrr r[r_index_columnsrrWrerg)r>r'rrrrhrrirIrjrdrkrlcompilerrrrvrortrrsrr{s0     z*BaseDatabaseSchemaEditor._create_index_sqlcCs&t|p |jt|jj|j||dSN)ror)rrr r"rzr[)r>r'rrIrrrr8s z*BaseDatabaseSchemaEditor._delete_index_sqlcCs*t|jt|jj|j||||dS)N)roold_namenew_name)rsql_rename_indexr r"rzr[)r>r'rzr{rrrrs z*BaseDatabaseSchemaEditor._rename_index_sqlcCst|||j|dS)N)ri)rr[)r>rorrirjrrrrwsz'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|qSrr\r^r&rrr_r`z?BaseDatabaseSchemaEditor._model_indexes_sql..rr)r"managedproxyswappedrsrxrindex_togetherrTrrrr8r;rr)r>r'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. r/)_field_should_be_indexedrTr)r>r'rrrrrrs z+BaseDatabaseSchemaEditor._field_indexes_sqlc Cs|pt}|\}}}}|\}}} } ||jD]} || dq6||jD]} | | dqT||j||jkp|||f|| | fkSr))r2 deconstructunion non_db_attrspopr[r|) r>r.r0r-rZold_pathZold_argsZ old_kwargsnew_pathnew_argsZ new_kwargsattrrrrr$s z1BaseDatabaseSchemaEditor._field_should_be_alteredcCs|jo |j Sr))r7rr>r'rrrrrsz1BaseDatabaseSchemaEditor._field_should_be_indexedcCs|j o |jSr)rr>r.r0rrrr4sz2BaseDatabaseSchemaEditor._field_became_primary_keycCs|j o|jo|j p|jSr))rrrrrrrAs  z0BaseDatabaseSchemaEditor._unique_should_be_addedcCs*|j||||j||j|dS)N)roZ old_columnZ new_columnr)sql_rename_columnr[r|)r>ror.r0r+rrrr: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)rorr|rdrer )r r"rzr[rrr| target_fieldr'r8rZrr sql_create_fk) r>r'rrrorr|rdrer rrrr s&  z'BaseDatabaseSchemaEditor._create_fk_sqlcs<fdd}t|jj|jgt|jjjjd|jjg||S)Ncsj|i|Sr)r[rCrprCrrcreate_fk_nameszDBaseDatabaseSchemaEditor._fk_constraint_name..create_fk_namer)rr"rzr|r rr')r>r'rrrrrCrrs z,BaseDatabaseSchemaEditor._fk_constraint_namecCs||j||Sr))r sql_delete_fkr>r'rrrrr+sz'BaseDatabaseSchemaEditor._delete_fk_sqlcCs,|dur dS|tjkrdS|tjkr(dSdS)NrMz DEFERRABLE INITIALLY DEFERREDz DEFERRABLE INITIALLY IMMEDIATE)r DEFERRED IMMEDIATE)r>r rrr_deferrable_constraint_sql.s   z3BaseDatabaseSchemaEditor._deferrable_constraint_sqlc s|rjjjsdS|s"|s"|s"|rNj|||||||d} | rJj| dSjdfdd|D|d} j || dS)N)rrdrkrjrlrncsg|]}|jqSr)r[r|r^rCrrr_Vr`z8BaseDatabaseSchemaEditor._unique_sql..)rr rrl) r8r;&supports_deferrable_unique_constraintsrrr@rTsql_unique_constraintrrsql_constraintr[) r>r'rrrdr rkrjrlrIrlrrCr _unique_sql6s4   z$BaseDatabaseSchemaEditor._unique_sqlc Cs|r|jjjr8|r|jjjr8|r*|jjjr8|r<|jjjs.Trr)rirj)rorrrdr rk)r8r;rsupports_partial_indexesrfrrrur"rzrr[sql_create_unique_indexsql_create_uniquerwrrWrr rerrg) r>r'rrrdr rkrjrlrxrorrIrrrrr^sT      z+BaseDatabaseSchemaEditor._create_unique_sqlcs&|rfdd}nj}t||d|S)Ncsj|i|Sr)rrprCrrcreate_unique_nameszLBaseDatabaseSchemaEditor._unique_constraint_name..create_unique_name_uniq)rCr)r>rorrrrrCrrsz0BaseDatabaseSchemaEditor._unique_constraint_namec Csh|r|jjjr8|r|jjjr8|r*|jjjr8|r<|jjjsr'rrdr rkrjrlrIrrrr5s*  z+BaseDatabaseSchemaEditor._delete_unique_sqlcCs |j|||jd|idS)Nrbr)rr[rv)r>rrbrrr _check_sqls z#BaseDatabaseSchemaEditor._check_sqlcCs$t|jt|jj|j|||dS)N)rorrb)rsql_create_checkr r"rzr[)r>r'rrbrrrrDs z*BaseDatabaseSchemaEditor._create_check_sqlcCs|jjjsdS||j||Sr))r8r; supports_table_check_constraintsrsql_delete_checkrrrrr9s z*BaseDatabaseSchemaEditor._delete_check_sqlcCs t|t|jj|j||dSry)rr r"rzr[)r>templater'rrrrrs z/BaseDatabaseSchemaEditor._delete_constraint_sqlc s"|durfdd|D}j$} jj| |jj} Wdn1sN0Yg} | D]\} }|dus||dkrd|dur|d|krqd|dur|d|krqd|dur|d|krqd|dur|d|krqd|dur|d sqd|dur|d |krqd| r| | vrd| | qd| S) z@Return all constraint names matching the columns and conditions.Ncs@g|]8}jjjr.jjt|jjn jj|qSr)r8r;truncates_names introspectionidentifier_converterr rZr])r,rrCrrr_s  z>BaseDatabaseSchemaEditor._constraint_names..rrrrrbrr)r8rXrget_constraintsr"rzitemsrT)r>r'r`rrrrrbr.rrXrresultrZinfodictrrCrrs4   " z*BaseDatabaseSchemaEditor._constraint_namescCsV|j|dd}|r6t|dkr6tdt||jjf|D]}||||q:dS)NTrrz0Found wrong number (%s) of PK constraints for %s)rrrr"rzrD_delete_primary_key_sql)r>r'r'rrErrrr@sz,BaseDatabaseSchemaEditor._delete_primary_keyc CsJt|jt|jj|j||j|jj|jgddt|jj|jg|jdS)NZ_pkr1)rorr) r sql_create_pkr r"rzr[rCr|rrrrrrBsz0BaseDatabaseSchemaEditor._create_primary_key_sqlcCs||j||Sr))r sql_delete_pkrrrrrsz0BaseDatabaseSchemaEditor._delete_primary_key_sqlcCs|rd||SdS)NzCOLLATE rM)r[)r>rrFr_rrrrsz%BaseDatabaseSchemaEditor._collate_sqlcCs*|j||d|d}||dS)N,)Z procedure param_types)sql_delete_procedurer[rrD)r>Zprocedure_namerrIrrrremove_procedure s z)BaseDatabaseSchemaEditor.remove_procedure)FT)r)F)F)F)F)rM)N)N)N)NNNNN)NNNNNN)T)NNNNN)NNNNNNNN)F)NN)r)p__name__ __module__ __qualname____doc__rrr rrrrSrNrOrRrQrPr rr?rrvZsql_delete_constraintrrrrrrr}rrrvrr|rrrrrrTr?rBrErDr[rrrtrrrr staticmethodrrrWrrrrrrrrrrrrr rr#r,r&r<rr;rrr%rCrcrergrr8rrwrrr$rr4rAr:rrrrrrrrr5rrDr9rrr@rBrrrrrrrr7Ks4  S9    $   "  V I \ &.    6     , 5    -   r7) 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 getLoggerrPrr(r2r7rrrrs