3 g@sddlZddlmZddlmZmZmZmZmZmZddl m Z m Z ddl m Z mZddlmZddlmZmZddlmZejd Zd d Zd d ZddZGdddZdS)N)datetime)Columns ExpressionsForeignKeyName IndexName StatementTable) names_digestsplit_identifier) DeferrableIndex)Query)TransactionManagementErroratomic)timezonezdjango.db.backends.schemacCs2|j}|jrdS|jr&|jdgkr&dS|j|jkS)zz When altering the given field, must constraints on its model from the given relation be temporarily dropped? FNT)field many_to_many primary_keyZ to_fieldsname)ZrelationZ altered_fieldrr\/var/www/tester-filtro-web/env/lib/python3.6/site-packages/django/db/backends/base/schema.py_is_relevant_relations rcCs|jjddddS)NFT)ZforwardreverseZinclude_hidden)_metaZ _get_fields)modelrrr_all_related_fields srcs2tfddtjDfddtjDS)Nc3s|]}t|r|VqdS)N)r).0obj) old_fieldrr (sz+_related_non_m2m_objects..c3s|]}t|r|VqdS)N)r)rr) new_fieldrrr)s)ziprr)rr r)r rr_related_non_m2m_objects$sr"c @seZdZdZdZdZdZdZdZdZ dZ d Z d Z d Z d ZeZd ZdZdZdZdZdZdZdZdZeZdZeZdZdZdZeZdZ dZ!dZ"dZ#eZ$dZ%dd d!Z&d"d#Z'd$d%Z(ffd&d'Z)d(d)Z*d*d+Z+dd,d-Z,d.d/Z-d0d1Z.d2d3Z/d4d5Z0e1d6d7Z2d8d9Z3d:d;Z4dd?Z6d@dAZ7dBdCZ8dDdEZ9dFdGZ:dHdIZ;dJdKZdPdQZ?dRdSZ@dTdUZAddVdWZBddXdYZCdZd[ZDdd\d]ZEd^d_ZFd`daZGdbdcZHddedfZIddgdhZJdidjZKdkdlZLdddddddfdfddddm dndoZMddpdqZNdrdsZOdtduZPdvdwZQdxdyZRdzd{ZSd|d}ZTd~dZUddZVddZWddZXddZYddZZdddZ[dddZ\dddZ]ddZ^ddZ_ddZ`ddZadddZbdddZcddZdddZeddZfffddZgdS)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$||_dS)N) connection collect_sql collected_sqlfeaturescan_rollback_ddlatomic_migration)selfr$r%rrrr__init__cs z!BaseDatabaseSchemaEditor.__init__cCs(g|_|jr$t|jj|_|jj|S)N) deferred_sqlr)rr$alias __enter__)r*rrrr.ls  z"BaseDatabaseSchemaEditor.__enter__cCs<|dkr"x|jD]}|j|qW|jr8|jj|||dS)N)r,executer)r__exit__)r*exc_type exc_value tracebacksqlrrrr0ss  z!BaseDatabaseSchemaEditor.__exit__c Cs|j r$|jjr$|jjj r$tdt|}tjd||||dd|jr|j drXdnd}|dk r|j j |t t |j||q|j j ||n"|jj}|j||WdQRXdS)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))paramsr4)extra;N)r%r$Zin_atomic_blockr'r(rstrloggerdebugendswithr&appendtuplemap quote_valuecursorr/)r*r4r5endingrArrrr/|s" z BaseDatabaseSchemaEditor.executecCs|jjj|S)N)r$ops quote_name)r*rrrrrDsz#BaseDatabaseSchemaEditor.quote_namecsx6jjD]*}fdd|D}jjj|q Wg}g}xHjjD]:}j|\}}|dkrlqL|jjd} | dr|dj | 7}|j jd} | r|d| 7}|j ||j o|j r<|j jjj} |j jjj|j jj} jr|djj| j| d7}n"jjjr<jjj|d |jd j|j|f|jdkrLjjjjj|j} | rLjj | qLWfddjjD}jjjjdjdd||Dd}jjrjjjjj}|r|d|7}||fS)z-Take a model and return its table definition.csg|]}jj|jqSr)r get_fieldcolumn)rr)rrr sz6BaseDatabaseSchemaEditor.table_sql..N)r$check z %s)to_table to_columnz_fk_%(to_table)s_%(to_column)sz%s %s AutoField BigAutoFieldSmallAutoFieldcsg|]}|jqSr)Zconstraint_sql)r constraint)rr*rrrGsz, css|]}|r|VqdS)Nr)rrOrrrrsz5BaseDatabaseSchemaEditor.table_sql..)table definition)rLrMrN) rZunique_togetherr,r=_create_unique_sql local_fields column_sql db_parametersr$sql_check_constraintZdb_type_suffixextend remote_field db_constraintrdb_tablerE field_namerFsql_create_inline_fkrDr'supports_foreign_keys_create_fk_sqlget_internal_typerC autoinc_sql constraintssql_create_tablejoin db_tablespacetablespace_sql)r*rfieldscolumnsZ column_sqlsr5rrQZ extra_params db_paramsZcol_type_suffixrJrKr`rar4rer)rr*r table_sqlsR          z"BaseDatabaseSchemaEditor.table_sqlc Csp|j|jd}|d}g}|dkr&d St|dd}|rD||j|7}|j}|oh|j| oh|of|j| }|r|j|} d|j|} | dk r|jj j r|| |j | 7}n|| 7}|| g7}|j r|j r|jj jrd}|r|jj j r|d7}n|s|d7}|j r|d 7}n|jr$|d 7}|jp2|jj} | rh|jj jrh|jrh|d |jjj| dd 7}||fS)z Take a field and return its column definition. The field must already have had set_attributes_from_name() called. )r$typeN db_collationz DEFAULT Tz NULLz NOT NULLz PRIMARY KEYz UNIQUEz %s)inline)NN)rUr$getattr _collate_sqlnull skip_defaultskip_default_on_altereffective_default_column_default_sqlr'requires_literal_defaultsprepare_defaultempty_strings_allowedr!interprets_empty_strings_as_nullsZimplied_column_nulluniquerdrZsupports_tablespacesrCre) r*rrinclude_defaultrhr4r5 collationro default_valueZcolumn_defaultZ tablespacerrrrTsF        z#BaseDatabaseSchemaEditor.column_sqlcCsdS)z Some backends don't accept default values for certain columns types (i.e. MySQL longtext and longblob). Fr)r*rrrrrp sz%BaseDatabaseSchemaEditor.skip_defaultcCsdS)z Some backends don't accept default values for certain columns types (i.e. MySQL longtext and longblob) in the ALTER COLUMN statement. Fr)r*rrrrrqsz.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() methodN)NotImplementedError)r*valuerrrrusz(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. z%sr)r*rrrrrs$sz,BaseDatabaseSchemaEditor._column_default_sqlcCs|jr|j}n|j r>|jr>|jr>|jdkr8d}qd}nbt|ddsVt|ddrtj}|j}|dkrx|j }q|dkr|j }q|d krt j}nd}|S) NZ BinaryFieldr8Zauto_nowFZ auto_now_addZ DateFieldZ TimeFieldZ DateTimeField) has_default get_defaultroblankrvr_rmrnowdatetimer)rdefaultZ internal_typerrr_effective_default+s"     z+BaseDatabaseSchemaEditor._effective_defaultcCs|j|j||jS)z2Return a field's effective database default value.)Zget_db_prep_saverr$)r*rrrrrrBsz*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). N)r|)r*r}rrrr@Fsz$BaseDatabaseSchemaEditor.quote_valuecCs`|j|\}}|j||pd|jj|j|x*|jjD]}|jjjj r:|j |jjq:WdS)zr Create a table and any accompanying indexes or unique constraints for the given `model`. N) rir/r,rW_model_indexes_sqlrlocal_many_to_manyrXthrough auto_created create_model)r*rr4r5rrrrrRs  z%BaseDatabaseSchemaEditor.create_modelcCsx*|jjD]}|jjjjr |j|jjq W|j|jd|j|jj ix6t |j D](}t |t rV|j|jj rV|j j|qVWdS)z!Delete a model from the database.rPN)rrrXrr delete_modelr/sql_delete_tablerDrZlistr, isinstancerZreferences_tableremove)r*rrr4rrrrcs z%BaseDatabaseSchemaEditor.delete_modelcCs0|jr|jjj rdS|j|j||dddS)zAdd an index on a model.N)r5)contains_expressionsr$r'supports_expression_indexesr/ create_sql)r*rindexrrr add_indexss z"BaseDatabaseSchemaEditor.add_indexcCs,|jr|jjj rdS|j|j||dS)zRemove an index from a model.N)rr$r'rr/ remove_sql)r*rrrrr remove_index~s z%BaseDatabaseSchemaEditor.remove_indexcCs"|j||}|r|j|dddS)zAdd a constraint to a model.N)r5)rr/)r*rrOr4rrradd_constraints z'BaseDatabaseSchemaEditor.add_constraintcCs|j||}|r|j|dS)z!Remove a constraint from a model.N)rr/)r*rrOr4rrrremove_constraints z*BaseDatabaseSchemaEditor.remove_constraintcsdd|D}dd|D}x(|j|D]}|j|ddi|jq(Wx6|j|D](}fdd|D}|j|j|qRWdS) 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|qSr)r>)rrfrrr szABaseDatabaseSchemaEditor.alter_unique_together..cSsh|] }t|qSr)r>)rrfrrrrsrxTcsg|]}jj|jqSr)rrErF)rr)rrrrGszBBaseDatabaseSchemaEditor.alter_unique_together..N) difference_delete_composed_indexsql_delete_uniquer/rR)r*rZold_unique_togetherZnew_unique_togetheroldsnewsrfrgr)rralter_unique_togethersz.BaseDatabaseSchemaEditor.alter_unique_togethercsdd|D}dd|D}x*|j|D]}|j|ddd|jq(Wx:|j|D],}fdd|D}|j|j|d d qTWd 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|qSr)r>)rrfrrrrsz@BaseDatabaseSchemaEditor.alter_index_together..cSsh|] }t|qSr)r>)rrfrrrrsTF)rrxcsg|]}jj|qSr)rrE)rr)rrrrGszABaseDatabaseSchemaEditor.alter_index_together.._idx)rfsuffixN)rrsql_delete_indexr/_create_index_sql)r*rZold_index_togetherZnew_index_togetherrrrf field_namesr)rralter_index_togethers z-BaseDatabaseSchemaEditor.alter_index_togetherc sddjjD}ddjjD}fdd|D}|j|fd||Bi|}t|dkr~tdt|jjd j|f|j|j ||d dS) NcSsh|] }|jqSr)r)rrOrrrrszBBaseDatabaseSchemaEditor._delete_composed_index..cSsh|] }|jqSr)r)rrOrrrrscsg|]}jj|jqSr)rrErF)rr)rrrrGszCBaseDatabaseSchemaEditor._delete_composed_index..excludez1Found wrong number (%s) of constraints for %s(%s)z, r) rraindexes_constraint_nameslen ValueErrorrZrcr/_delete_constraint_sql) r*rrfZconstraint_kwargsr4meta_constraint_namesmeta_index_namesrgconstraint_namesr)rrrs z/BaseDatabaseSchemaEditor._delete_composed_indexcCsr||ks"|jjjr&|j|jkr&dS|j|j|j||j|dx$|jD]}t|t rP|j ||qPWdS)z#Rename the table a model points to.N)Z old_tableZ new_table) r$r'Zignores_table_name_caselowerr/sql_rename_tablerDr,rrZrename_table_references)r*rZ old_db_tableZ new_db_tabler4rrralter_db_tables   z'BaseDatabaseSchemaEditor.alter_db_tablecCs2|j|j|j|jj|j||j|ddS)z)Move a model's table between tablespaces.)rPZold_tablespaceZnew_tablespaceN)r/sql_retablespace_tablerDrrZ)r*rZold_db_tablespaceZnew_db_tablespacerrralter_db_tablespaces z,BaseDatabaseSchemaEditor.alter_db_tablespacec Cs|jr |jjjjr |j|jjS|j||dd\}}|dkr@dS|j|jd}|drh|d|j |7}|jo||jj j o||j r.d}|j r|jjjj}|jjjj|jjj}t|jj\} } |d|j |j|||| rd|j| nd |j|j|j||j||jjjd 7}n|jj|j||||j|j|jj|j|j|d } |j| ||j| r|j|dk r|j|d|dd \} }|j |j|jj| d } |j| ||jj!|j"|||jj j#r|jj$dS)z Create a field on a model. Usually involves adding a column, but may involve adding a table instead (for M2M fields). T)ryN)r$rHrIz_fk_%(to_table)s_%(to_column)sz%s.r8)r namespacerFrJrK deferrable)rPrFrQ)drop)rPchanges)%rrXrrrrrTrUr$rVr'r]rYsql_create_column_inline_fkrrZrEr[rFr _fk_constraint_namerDrCdeferrable_sqlr,r=r^sql_create_columnr/rqrr_alter_column_default_sqlsql_alter_columnrW_field_indexes_sqlconnection_persists_old_columnsclose) r*rrrQr5rhZconstraint_suffixrJrKr_r4 changes_sqlrrr add_fieldsH           z"BaseDatabaseSchemaEditor.add_fieldcCs|jr |jjjjr |j|jjS|j|jdddkr:dS|jrt|j||j gdd}x|D]}|j |j ||qZW|j |j |jj|j |j d}|j ||jjjr|jjx:t|jD],}t|tr|j|jj|j r|jj|qWdS)z Remove a field from a model. Usually involves deleting a column, but for M2Ms may involve deleting a table. )r$rjNT) foreign_key)rPrF)rrXrrrrrUr$rrFr/_delete_fk_sqlsql_delete_columnrDrZr'rrrr,rrZreferences_columnr)r*rrfk_namesfk_namer4rrr remove_fields"     z%BaseDatabaseSchemaEditor.remove_fieldc Cs<|j||sdS|j|jd}|d}|j|jd}|d}|dkrN|jdks`|dkrr|jdkrrtd||fn|dkr|dkr|jjr|jjr|jjjjr|jjjjr|j||||S|dko|dko|jjo|jjo|jjjj o|jjjj rdS|dks|dkr td||f|j ||||||||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. N)r$rjzqCannot 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_alteredrUr$rXrrrr_alter_many_to_many _alter_field) r*rrr strict old_db_paramsold_type new_db_paramsnew_typerrr alter_field8s6    z$BaseDatabaseSchemaEditor.alter_fieldc )Cst} |jjjr|jr|jr|j||jgdd} |r\t| dkr\t dt| |j j |jfx,| D]$} | j |jf|j |j|| qbW|jo|j s|j||rdd|j jD} |j||jgdd| d} |rt| dkrt d t| |j j |jfx | D]}|j |j||qW|jjjoP|jr:|jsJ|joP|joP||k}|rxTt||D]F\}}|j|j|jjgdd}x"|D]} |j |j|j| qWqdW|jr |j r |j s|jr d d|j jD}|j||jgdtj|d }x |D]}|j |j||qW|d |d kr|d rd d|j jD} |j||jgd| d} |rt| dkrt dt| |j j |jfx | D]}|j |j||qW|j|jkr|j |j|j j |||x2|jD](}t|t r|j!|j j |j|jqWg}g}g}t"|dd}t"|dd}||kr\|j#||||}|j$|n2||kr|j%||||\}}|j$||j&|d}|j'r|j' r|j(|}|j(|} |j)| r|| kr| dk rd}|j$|j*||||j'|j'kr|j+|||}|r|j$||j,o6|j'o6|j' }!|sD|r*|!sR||}|jjj-r|rt.t/|\}}"dj0|t1|"gfg}x4|D],\}}"|j |j2|j3|j j |d|"qW|!r*|j |j4|j3|j j |j3|jdd| gx4|D],\}}"|j |j2|j3|j j |d|"qW|rPx|D]\}}"|j ||"q6W|jrn|j rn|j5|||j6||r|j |j7||jg|j s|jr|jr|j r|j |j8||gdg}#|r|#j&t|||j||r|j |j9|||#j&t||x|#D]\}$}|jj:|jd}%|%d}&|j%|j|$j|j|&\}}|j |j2|j3|jj j |dd|dx|D]\}}"|j ||"qWqW|jjjr|jr| s|j s|j r|jr|j |j;||d|r|'|r|'jjr|j |j;|'j|'jdqW|d |d kr|d r|j?|j j |jgdd}|j |j@|||d |r|j*|||dd\}(}"|j2|j3|j j |(d}|j ||"|jjjAr|jjBdS)z3Perform a "physical" (non-ManyToMany) field update.T)rrz.F)rxrrz7Found wrong number (%s) of unique constraints for %s.%scSsh|] }|jqSr)r)rrrrrrs)rtype_rrHcSsh|] }|jqSr)r)rrOrrrrs)rHrz6Found wrong number (%s) of check constraints for %s.%srkNz, )rPrz%s)rPrFr)rf)r$rjrz_fk_%(to_table)s_%(to_column)sZ_fk_check)r)r)Csetr$r'r]rXrYrrFrrrrZaddr/rrx_field_became_primary_keyra_delete_unique_sqlrr"Z related_modelrdb_indexrr r_delete_index_sql_delete_check_sql_rename_field_sqlr,rrZrename_column_referencesrm_alter_column_collation_sqlr=_alter_column_type_sqlrWrorrrqr_alter_column_null_sqlrZsupports_combined_altersr>r!rcsumrrDsql_update_with_default_delete_primary_key_unique_should_be_addedrRr_create_primary_key_sqlrUr^rZrelated_objectsr_create_index_name_create_check_sqlrr))r*rrr rrrrrZ fks_droppedrrrrconstraint_nameZdrop_foreign_keysZ_old_relZnew_relZ rel_fk_namesrZ index_names index_namer4actionsZ null_actionsZ post_actionsZ old_collation new_collationfragmentZ other_actionsZneeds_database_defaultZ old_default new_defaultZfour_way_default_alterationr5Zrels_to_updateZold_relZ rel_db_paramsZrel_typerelrrrrrcs:         $                            $      z%BaseDatabaseSchemaEditor._alter_fieldcCs\|jjjr|jdkrdS|j|jd}|jr4|jn|j}||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. CharField TextFieldN)r$rj)rFrj)rr) r$r'rwr_rUrosql_alter_column_nullsql_alter_column_not_nullrDrF)r*rrr rr4rrrrbs    z/BaseDatabaseSchemaEditor._alter_column_null_sqlc Cs|j|}|j|}|g}|r$g}n|jjjr<|j|}g}|j|jd}|rd|jr\|j} qj|j } n|j } | |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$rj)rFrjr) rrrsr$r'rtrurUro sql_alter_column_no_default_nullsql_alter_column_no_defaultsql_alter_column_defaultrDrF) r*rrr rrrr5rr4rrrrxs&     z2BaseDatabaseSchemaEditor._alter_column_default_sqlcCs |j|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. )rFrj)sql_alter_column_typerDrF)r*rrr rrrrrs  z/BaseDatabaseSchemaEditor._alter_column_type_sqlcCs,|j|j|j||r|j|nddgfS)Nr8)rFrjrz)sql_alter_column_collaterDrFrn)r*rr rrrrrrs  z4BaseDatabaseSchemaEditor._alter_column_collation_sqlcCs|jjjj|jjjjkr:|j|jj|jjjj|jjjj|j|jj|jjjj|j|jjjj|j|j|jj|jjjj|j|jjjj|jdS)z*Alter M2Ms to repoint their to= endpoints.N) rXrrrZrrrEZm2m_reverse_field_nameZm2m_field_name)r*rrr rrrrrsz,BaseDatabaseSchemaEditor._alter_many_to_manyr8c Cst|\}}dt|f|ddi|f}|jjjp6d}d|dj||f}t||kr\|St||dkr||d|d}|t|d d }d|d|dj|d||f}|d dks|d jrd |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$rCZmax_name_lengthrcrisdigit) r*Z table_name column_namesrrZhash_suffix_part max_lengthrZ other_lengthrrrrs    z+BaseDatabaseSchemaEditor._create_index_namecCsX|dkr:t|dkr*|djr*|dj}n|jjr:|jj}|dk rTd|jjj|SdS)NrrrIr8)rrdrr$rCre)r*rrfrdrrr_get_index_tablespace_sqls z2BaseDatabaseSchemaEditor._get_index_tablespace_sqlcCs|r d|SdS)Nz WHERE r8r)r* conditionrrr_index_condition_sqlsz-BaseDatabaseSchemaEditor._index_condition_sqlcCs0| s|jjj rdStdt|jj||jdS)Nr8z INCLUDE (%(columns)s))rg)r$r'supports_covering_indexesrrrrZrD)r*rrgrrr_index_include_sqls z+BaseDatabaseSchemaEditor._index_include_sql) rfrrusingrd col_suffixesr4 opclassesrinclude expressionsc  s|pg}| pg} t|ddjjd} j|||d}dd|D}|pLj}|jj}fdd}t|t|j t ||||||rj |||| nt || | j |j| j|| d S) z Return the SQL statement to create the index for one or several fields or expressions. `sql` can be specified if the syntax differs from the standard (GIS indexes, ...). F)Z alias_cols)r$)rdcSsg|] }|jqSr)rF)rrrrrrGsz>BaseDatabaseSchemaEditor._create_index_sql..csdkrj||jS)N)rrD)argskwargs)rr*rrcreate_index_names zEBaseDatabaseSchemaEditor._create_index_sql..create_index_name)rPrrrgr6rr )r Z get_compilerr$rsql_create_indexrrZrrrDr_index_columnsrr@rr)r*rrfrrrrdrr4r rr r compilerrergrrPrr)rr*rrs&     z*BaseDatabaseSchemaEditor._create_index_sqlcCs&t|p |jt|jj|j|j|dS)N)rPr)rrrrrZrD)r*rrr4rrrr,sz*BaseDatabaseSchemaEditor._delete_index_sqlcCst|||j|dS)N)r)rrD)r*rPrgrr rrrr3sz'BaseDatabaseSchemaEditor._index_columnscsjj sjjsjjrgSg}x"jjD]}|j|j|q,Wx8jjD],}fdd|D}|j|j |ddqPWx4jj D](}|j s|j j jr|j|j|qW|S)z Return a list of all index SQL statements (field indexes, index_together, Meta.indexes) for the specified model. csg|]}jj|qSr)rrE)rr)rrrrGBsz?BaseDatabaseSchemaEditor._model_indexes_sql..r)rfr)rZmanagedproxyZswappedrSrWrZindex_togetherr=rrrr$r'rr)r*routputrrrfrr)rrr6s z+BaseDatabaseSchemaEditor._model_indexes_sqlcCs*g}|j||r&|j|j||gd|S)zT Return a list of all index SQL statements for the specified field. )rf)_field_should_be_indexedr=r)r*rrrrrrrMs z+BaseDatabaseSchemaEditor._field_indexes_sqlc Cs|j\}}}}|j\}}}} ddddddddd d d g } x$| D]} |j| d| j| dq@W|j|j|j|jkp|||f||| fkS) NrZ db_columneditableZerror_messages help_textZlimit_choices_toZ on_deleteZ related_nameZrelated_query_nameZ validatorsZ verbose_name)Z deconstructpoprDrF) r*rr rold_pathZold_argsZ old_kwargsnew_pathZnew_argsZ new_kwargsZnon_database_attrsattrrrrrVs$  z1BaseDatabaseSchemaEditor._field_should_be_alteredcCs|jo |j S)N)rrx)r*rrrrrrssz1BaseDatabaseSchemaEditor._field_should_be_indexedcCs|j o |jS)N)r)r*rr rrrrvsz2BaseDatabaseSchemaEditor._field_became_primary_keycCs"|j r|jp |jo |j o |jS)N)rxr)r*rr rrrrysz0BaseDatabaseSchemaEditor._unique_should_be_addedcCs*|j|j||j|j|j|j|dS)N)rPZ old_columnZ new_columnrj)sql_rename_columnrDrF)r*rPrr rrrrr~s   z*BaseDatabaseSchemaEditor._rename_field_sqlc Cst|jj|j}|j|||}t|jj|jg|j}t|jjjj|j}t|jjjj|jjg|j}|j j j } t |j |||||| dS)N)rPrrFrJrKr)rrrZrDrrrF target_fieldrr$rCrr sql_create_fk) r*rrrrPrrFrJrKrrrrr^s z'BaseDatabaseSchemaEditor._create_fk_sqlcs<fdd}t|jj|jgt|jjjjd|jjg||S)Ncsjj||S)N)rDr)r r )r*rrcreate_fk_nameszDBaseDatabaseSchemaEditor._fk_constraint_name..create_fk_namer)rrrZrFr rr)r*rrrrr)r*rrs z,BaseDatabaseSchemaEditor._fk_constraint_namecCs|j|j||S)N)r sql_delete_fk)r*rrrrrrsz'BaseDatabaseSchemaEditor._delete_fk_sqlcCs,|dkr dS|tjkrdS|tjkr(dSdS)Nr8z DEFERRABLE INITIALLY DEFERREDz DEFERRABLE INITIALLY IMMEDIATE)r ZDEFERREDZ IMMEDIATE)r*rrrr_deferrable_constraint_sqls   z3BaseDatabaseSchemaEditor._deferrable_constraint_sqlc Cs|r|jjj rdS|s |s |rJ|j||||||d}|rF|jj|dS|jdjt|j ||j |d} |j |j || dS)N)rrr r z, )rgr)rrO) r$r'&supports_deferrable_unique_constraintsrRr,r=sql_unique_constraintrcr?rDr sql_constraint) r*rrfrrrr r r4rOrrr _unique_sqls(   z$BaseDatabaseSchemaEditor._unique_sqlc s|rjjj s0|r jjj s0|r4jjj r4dSfdd}t|jjj} |dkrlt |jj|d|}n j|}j | |f|d}|s|s|rj } nj } t | | ||j|j|j||dS)Ncsjj||S)N)rDr)r r )r*rrcreate_unique_nameszGBaseDatabaseSchemaEditor._create_unique_sql..create_unique_nameZ_uniq)rr )rPrrgrrr )r$r'r!supports_partial_indexesrrrrZrDrrsql_create_unique_indexsql_create_uniquerrr r) r*rrgrrrr r r%rPr4r)r*rrRs,    z+BaseDatabaseSchemaEditor._create_unique_sqlcCs\|r|jjj s0|r |jjj s0|r4|jjj r4dS|s@|s@|rH|j}n|j}|j|||S)N)r$r'r!r&rrrr)r*rrrrr r r4rrrrs  z+BaseDatabaseSchemaEditor._delete_unique_sqlcCs |j|j||jd|idS)NrH)rrO)r#rDrV)r*rrHrrr _check_sqlsz#BaseDatabaseSchemaEditor._check_sqlcCs$t|jt|jj|j|j||dS)N)rPrrH)rsql_create_checkrrrZrD)r*rrrHrrrr s z*BaseDatabaseSchemaEditor._create_check_sqlcCs|j|j||S)N)rsql_delete_check)r*rrrrrrsz*BaseDatabaseSchemaEditor._delete_check_sqlcCs t|t|jj|j|j|dS)N)rPr)rrrrZrD)r*templaterrrrrrsz/BaseDatabaseSchemaEditor._delete_constraint_sqlc  s|dk rfdd|D}jj} jjj| |jj} WdQRXg} x| jD]\} }|dksn||dkrR|dk r|d|krqR|dk r|d|krqR|dk r|d|krqR|dk r|d|krqR|dk r|d  rqR|dk r|d |krqR| p| | krR| j| qRW| S) z@Return all constraint names matching the columns and conditions.Ncsg|]}jjj|qSr)r$ introspectionZidentifier_converter)rr)r*rrrG%sz>BaseDatabaseSchemaEditor._constraint_names..rgrxrrrHrrj)r$rAr-Zget_constraintsrrZitemsr=)r*rrrxrrrrHrrrAraresultrZinfodictr)r*rrs.  z*BaseDatabaseSchemaEditor._constraint_namescCsZ|j|dd}|r6t|dkr6tdt||jjfx|D]}|j|j||qs