B CVvgžôã@s°ddlZddlmZddlmZmZmZmZmZmZddl m Z m Z ddl m Z mZddlmZddlmZmZddlmZe d ¡Zd d „Zd d „Zdd„ZGdd„dƒZdS)éN)Údatetime)ÚColumnsÚ ExpressionsÚForeignKeyNameÚ IndexNameÚ StatementÚTable)Ú names_digestÚsplit_identifier)Ú DeferrableÚIndex)ÚQuery)ÚTransactionManagementErrorÚatomic)Ú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_fieldsÚname)ZrelationZ altered_fieldr©rúB/tmp/pip-install-o3oxmrkh/Django/django/db/backends/base/schema.pyÚ_is_relevant_relations rcCs|jjddddS)NFT)ZforwardÚreverseZinclude_hidden)Ú_metaZ _get_fields)ÚmodelrrrÚ_all_related_fields srcs2t‡fdd„tˆjƒDƒ‡fdd„tˆjƒDƒƒS)Nc3s|]}t|ˆƒr|VqdS)N)r)Ú.0Úobj)Ú 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 @sÜeZdZdZdZdZdZdZdZdZ dZ d Z d Z d Z d ZeZd ZdZdZdZdZdZdZdZdZeZdZeZdZdZdZeZdZ dZ!dZ"dZ#eZ$dZ%d¥d d!„Z&d"d#„Z'd$d%„Z(d¦d'd(„Z)d)d*„Z*d+d,„Z+d§d-d.„Z,d/d0„Z-d1d2„Z.d3d4„Z/d5d6„Z0e1d7d8„ƒZ2d9d:„Z3d;d<„Z4d=d>„Z5d?d@„Z6dAdB„Z7dCdD„Z8dEdF„Z9dGdH„Z:dIdJ„Z;dKdL„ZdQdR„Z?dSdT„Z@dUdV„ZAd¨dWdX„ZBd©dYdZ„ZCd[d\„ZDdªd]d^„ZEd_d`„ZFdadb„ZGdcdd„ZHd«dfdg„ZId¬dhdi„ZJdjdk„ZKdldm„ZLdddededd&dd&ddddnœ dodp„ZMd­dqdr„ZNdsdt„ZOdudv„ZPdwdx„ZQdydz„ZRd{d|„ZSd}d~„ZTdd€„ZUdd‚„ZVdƒd„„ZWd…d†„ZXd‡dˆ„ZYd‰dŠ„ZZd®d‹dŒ„Z[d¯ddŽ„Z\d°dd„Z]d‘d’„Z^d“d”„Z_d•d–„Z`d—d˜„Zad±d™dš„Zbd²d›dœ„Zcddž„ZddŸd „Zed¡d¢„Zfd³d£d¤„ZgdS)´Ú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_sqlÚfeaturesÚcan_rollback_ddlÚatomic_migration)Úselfr$r%rrrrÚ__init__cs z!BaseDatabaseSchemaEditor.__init__cCs(g|_|jr$t|jjƒ|_|j ¡|S)N)Ú deferred_sqlr)rr$ÚaliasÚ __enter__)r*rrrr.ls  z"BaseDatabaseSchemaEditor.__enter__cCs<|dkr"x|jD]}| |¡qW|jr8|j |||¡dS)N)r,Úexecuter)rÚ__exit__)r*Úexc_typeÚ exc_valueÚ tracebackÚsqlrrrr0ss  z!BaseDatabaseSchemaEditor.__exit__rc Csº|js |jjr |jjjs tdƒ‚t|ƒ}tjd||||dœd|jr”|  d¡rTdnd}|dk r‚|j   |t t |j|ƒƒ|¡q¶|j   ||¡n"|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(rÚstrÚloggerÚdebugÚendswithr&ÚappendÚtupleÚmapÚ quote_valueÚcursorr/)r*r4r5ZendingrArrrr/|s" z BaseDatabaseSchemaEditor.executecCs|jj |¡S)N)r$ÚopsÚ quote_name)r*rrrrrC“sz#BaseDatabaseSchemaEditor.quote_namecs x6ˆjjD]*}‡fdd„|Dƒ}ˆj ˆ ˆ|¡¡q Wg}g}xJˆjjD]<}ˆ ˆ|¡\}}|dkrlqL|jˆjd} | dr”|dˆj | 7}|j ˆjd} | r²|d| 7}|  |¡|j r>|j r>|j jjj} |j jj |j j¡j} ˆjr|dˆjˆ | ¡ˆ | ¡dœ7}n"ˆjjjr>ˆj ˆ ˆ|d ¡¡| d ˆ |j¡|f¡| ¡d krLˆjj ˆjj|j¡} | rLˆj  | ¡qLW‡‡fd d„ˆjjDƒ}ˆjˆ ˆjj¡d  dd„||˜Dƒ¡dœ}ˆjjrˆjj ˆjj¡}|r|d|7}||fS)z-Take a model and return its table definition.csg|]}ˆj |¡j‘qSr)rÚ get_fieldÚcolumn)rr)rrrú ›sz6BaseDatabaseSchemaEditor.table_sql..N)r$Úcheckú z %s)Úto_tableÚ to_columnz_fk_%(to_table)s_%(to_column)sz%s %s)Z AutoFieldZ BigAutoFieldZSmallAutoFieldcsg|]}| ˆˆ¡‘qSr)Zconstraint_sql)rÚ constraint)rr*rrrFÄsz, css|]}|r|VqdS)Nr)rrKrrrrÇsz5BaseDatabaseSchemaEditor.table_sql..)ÚtableÚ definition) rZunique_togetherr,r=Ú_create_unique_sqlÚ local_fieldsÚ column_sqlÚ db_parametersr$Úsql_check_constraintZdb_type_suffixÚextendÚ remote_fieldÚ db_constraintrÚdb_tablerDÚ field_namerEÚsql_create_inline_fkrCr'Úsupports_foreign_keysÚ_create_fk_sqlÚget_internal_typerBÚ autoinc_sqlÚ constraintsÚsql_create_tableÚjoinÚ db_tablespaceÚtablespace_sql)r*rÚfieldsÚcolumnsZ column_sqlsr5rrMZ extra_paramsÚ db_paramsZcol_type_suffixrIrJr\r]r4rar)rr*rÚ table_sql–sR          z"BaseDatabaseSchemaEditor.table_sqlc Csj|j|jd}|d}g}|dkr&dSt|ddƒ}|rD|| |¡7}|j}|oh| |¡ oh|of| |¡ }|r¾| |¡} d| |¡} | dk r¾|jj j r¬|| |  | ¡7}n|| 7}|| g7}|j rØ|j sØ|jj jrØd}|rð|jj jsð|d7}n |sü|d 7}|j r|d 7}n|jr|d 7}|jp,|jj} | rb|jj jrb|jrb|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)NNÚ db_collationz DEFAULT Tz NULLz NOT NULLz PRIMARY KEYz UNIQUEz %s)Úinline)rQr$ÚgetattrÚ _collate_sqlÚnullÚ skip_defaultÚskip_default_on_alterÚeffective_defaultÚ_column_default_sqlr'Úrequires_literal_defaultsÚprepare_defaultÚempty_strings_allowedrÚ!interprets_empty_strings_as_nullsZimplied_column_nullÚuniquer`rZsupports_tablespacesrBra) r*rrÚinclude_defaultrdr4r5Ú collationrkÚ default_valueZcolumn_defaultZ tablespacerrrrPÑsF         z#BaseDatabaseSchemaEditor.column_sqlcCsdS)z Some backends don't accept default values for certain columns types (i.e. MySQL longtext and longblob). Fr)r*rrrrrl 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*rrrrrmsz.BaseDatabaseSchemaEditor.skip_default_on_altercCs tdƒ‚dS)zU Only used for backends which have requires_literal_defaults feature z€subclasses of BaseDatabaseSchemaEditor for backends which have requires_literal_defaults must provide a prepare_default() methodN)ÚNotImplementedError)r*Úvaluerrrrqsz(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*rrrrro$sz,BaseDatabaseSchemaEditor._column_default_sqlcCs¢| ¡r| ¡}nŒ|js<|jr<|jr<| ¡dkr6d}qžd}nbt|ddƒsTt|ddƒršt ¡}| ¡}|dkrv|  ¡}qž|dkrˆ|  ¡}qž|d kržt  ¡}nd}|S) NZ BinaryFieldór8Zauto_nowFZ auto_now_addZ DateFieldZ TimeFieldZ DateTimeField) Ú has_defaultÚ get_defaultrkÚblankrrr[rirÚnowÚdateÚtimer)rÚdefaultZ internal_typerrrÚ_effective_default+s"     z+BaseDatabaseSchemaEditor._effective_defaultcCs| | |¡|j¡S)z2Return a field's effective database default value.)Zget_db_prep_saver‚r$)r*rrrrrnBsz*BaseDatabaseSchemaEditor.effective_defaultcCs tƒ‚dS)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)rx)r*ryrrrr@Fsz$BaseDatabaseSchemaEditor.quote_valuecCs`| |¡\}}| ||pd¡|j | |¡¡x*|jjD]}|jjjj r:|  |jj¡q:WdS)zr Create a table and any accompanying indexes or unique constraints for the given `model`. N) rer/r,rSÚ_model_indexes_sqlrÚlocal_many_to_manyrTÚthroughÚ auto_createdÚ create_model)r*rr4r5rrrrr‡Rs  z%BaseDatabaseSchemaEditor.create_modelcCs†x*|jjD]}|jjjjr | |jj¡q W| |jd| |jj ¡i¡x6t |j ƒD](}t |t ƒrV| |jj ¡rV|j  |¡qVWdS)z!Delete a model from the database.rLN)rr„rTr…r†Ú delete_modelr/Úsql_delete_tablerCrVÚlistr,Ú isinstancerZreferences_tableÚremove)r*rrr4rrrrˆcs z%BaseDatabaseSchemaEditor.delete_modelcCs.|jr|jjjsdS|j| ||¡dddS)zAdd an index on a model.N)r5)Úcontains_expressionsr$r'Úsupports_expression_indexesr/Ú create_sql)r*rÚindexrrrÚ add_indexss z"BaseDatabaseSchemaEditor.add_indexcCs*|jr|jjjsdS| | ||¡¡dS)zRemove an index from a model.N)rr$r'rŽr/Ú remove_sql)r*rrrrrÚ remove_index~s z%BaseDatabaseSchemaEditor.remove_indexcCs"| ||¡}|r|j|dddS)zAdd a constraint to a model.N)r5)rr/)r*rrKr4rrrÚadd_constraint‡s z'BaseDatabaseSchemaEditor.add_constraintcCs| ||¡}|r| |¡dS)z!Remove a constraint from a model.N)r’r/)r*rrKr4rrrÚremove_constraints z*BaseDatabaseSchemaEditor.remove_constraintcs‚dd„|Dƒ}dd„|Dƒ}x(| |¡D]}| ˆ|ddi|j¡q(Wx6| |¡D](}‡fdd„|Dƒ}| | ˆ|¡¡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>)rrbrrrú ›szABaseDatabaseSchemaEditor.alter_unique_together..cSsh|] }t|ƒ’qSr)r>)rrbrrrr–œsrtTcsg|]}ˆj |¡j‘qSr)rrDrE)rr)rrrrF¢szBBaseDatabaseSchemaEditor.alter_unique_together..N)Ú differenceÚ_delete_composed_indexÚsql_delete_uniquer/rN)r*rZold_unique_togetherZnew_unique_togetherÚoldsÚnewsrbrcr)rrÚalter_unique_together•sz.BaseDatabaseSchemaEditor.alter_unique_togethercsˆdd„|Dƒ}dd„|Dƒ}x*| |¡D]}| ˆ|dddœ|j¡q(Wx:| |¡D],}‡fdd„|Dƒ}| |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>)rrbrrrr–«sz@BaseDatabaseSchemaEditor.alter_index_together..cSsh|] }t|ƒ’qSr)r>)rrbrrrr–¬sTF)rrtcsg|]}ˆj |¡‘qSr)rrD)rr)rrrrF·szABaseDatabaseSchemaEditor.alter_index_together..Ú_idx)rbÚsuffixN)r—r˜Úsql_delete_indexr/Ú_create_index_sql)r*rZold_index_togetherZnew_index_togetherršr›rbÚ field_namesr)rrÚalter_index_together¥s z-BaseDatabaseSchemaEditor.alter_index_togetherc sšdd„ˆjjDƒ}dd„ˆjjDƒ}‡fdd„|Dƒ}|jˆ|fd||Bi|—Ž}t|ƒdkr~tdt|ƒˆjjd  |¡fƒ‚| |  |ˆ|d ¡¡dS) NcSsh|] }|j’qSr)r)rrKrrrr–»szBBaseDatabaseSchemaEditor._delete_composed_index..cSsh|] }|j’qSr)r)rrKrrrr–¼scsg|]}ˆj |¡j‘qSr)rrDrE)rr)rrrrF½szCBaseDatabaseSchemaEditor._delete_composed_index..Úexcludeéz1Found wrong number (%s) of constraints for %s(%s)z, r) rr]ÚindexesÚ_constraint_namesÚlenÚ ValueErrorrVr_r/Ú_delete_constraint_sql) r*rrbZconstraint_kwargsr4Úmeta_constraint_namesÚmeta_index_namesrcÚconstraint_namesr)rrr˜ºs z/BaseDatabaseSchemaEditor._delete_composed_indexcCsr||ks"|jjjr&| ¡| ¡kr&dS| |j| |¡| |¡dœ¡x$|jD]}t|t ƒrP|  ||¡qPWdS)z#Rename the table a model points to.N)Z old_tableZ new_table) r$r'Zignores_table_name_caseÚlowerr/Úsql_rename_tablerCr,r‹rZrename_table_references)r*rZ old_db_tableZ new_db_tabler4rrrÚalter_db_tableÊs   z'BaseDatabaseSchemaEditor.alter_db_tablecCs2| |j| |jj¡| |¡| |¡dœ¡dS)z)Move a model's table between tablespaces.)rLZold_tablespaceZnew_tablespaceN)r/Úsql_retablespace_tablerCrrV)r*rZold_db_tablespaceZnew_db_tablespacerrrÚalter_db_tablespaceÙs z,BaseDatabaseSchemaEditor.alter_db_tablespacec Csè|jr |jjjjr | |jj¡S|j||dd\}}|dkr@dS|j|jd}|drh|d|j |7}|jr2|jj j r2|j r2d}|j r|jjjj}|jjj |jj¡j}t|jjƒ\} } |d|j | |||¡| rèd| | ¡nd | |j¡| |¡| |¡|jj ¡d œ7}n|j | |||¡¡|j| |jj¡| |j¡|d œ} | | |¡| |¡sº| |¡dk rº|j|d|dd \} }|j | |jj¡| d œ} | | |¡|j !| "||¡¡|jj j#rä|j $¡dS)z Create a field on a model. Usually involves adding a column, but may involve adding a table instead (for M2M fields). T)ruN)r$rGrHz_fk_%(to_table)s_%(to_column)sz%s.r8)rÚ namespacerErIrJÚ deferrable)rLrErM)Údrop)rLÚchanges)%rrTr…rr†r‡rPrQr$rRr'rYrUÚsql_create_column_inline_fkrrVrDrWrEr Ú_fk_constraint_namerCrBÚdeferrable_sqlr,r=rZÚsql_create_columnr/rmrnÚ_alter_column_default_sqlÚsql_alter_columnrSÚ_field_indexes_sqlÚconnection_persists_old_columnsÚclose) r*rrrMr5rdZconstraint_suffixrIrJr²Ú_r4Ú changes_sqlrrrÚ add_fieldásH           z"BaseDatabaseSchemaEditor.add_fieldcCsô|jr |jjjjr | |jj¡S|j|jdddkr:dS|jrt|j||j gdd}x|D]}|  |  ||¡¡qZW|j |  |jj¡|  |j ¡dœ}|  |¡|jjjr´|j ¡x:t|jƒD],}t|tƒrÀ| |jj|j ¡rÀ|j |¡qÀWdS)z… Remove a field from a model. Usually involves deleting a column, but for M2Ms may involve deleting a table. )r$rfNT)Ú foreign_key)rLrE)rrTr…rr†rˆrQr$r¦rEr/Ú_delete_fk_sqlÚsql_delete_columnrCrVr'r½r¾rŠr,r‹rZreferences_columnrŒ)r*rrÚfk_namesÚfk_namer4rrrÚ remove_fields"     z%BaseDatabaseSchemaEditor.remove_fieldc Cs6| ||¡sdS|j|jd}|d}|j|jd}|d}|dkrN|jdks`|dkrr|jdkrrtd||fƒ‚n¨|dkrº|dkrº|jjrº|jjrº|jjjjrº|jjjjrº| ||||¡S|dkrö|dkrö|jjrö|jjrö|jjjjsö|jjjjsödS|dks |dkrtd||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. N)r$rfzqCannot 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_alteredrQr$rTr¨r…rr†Ú_alter_many_to_manyÚ _alter_field) r*rrr ÚstrictÚ old_db_paramsÚold_typeÚ new_db_paramsÚnew_typerrrÚ alter_field8s6      z$BaseDatabaseSchemaEditor.alter_fieldc )CsÒtƒ} |jjjrŠ|jrŠ|jrŠ|j||jgdd} |r\t| ƒdkr\t dt| ƒ|j j |jfƒ‚x,| D]$} |   |jf¡|  | || ¡¡qbW|jr|jr¦| ||¡rdd„|j jDƒ} |j||jgdd| d} |rüt| ƒdkrüt d t| ƒ|j j |jfƒ‚x | D]}|  | ||¡¡qW|jjjoP|jr:|jsJ|joP|joP||k}|r®xTt||ƒD]F\}}|j|j|jjgdd}x"|D]} |  | |j| ¡¡qŠWqdW|jr|js|jrÎ|jrd d„|j jDƒ}|j||jgdtj|d }x |D]}|  | ||¡¡qW|d |d kr²|d r²d d„|j jDƒ} |j||jgd| d} |rt| ƒdkrt dt| ƒ|j j |jfƒ‚x | D]}|  | ||¡¡q–W|j|jkr|  | |j j |||¡¡x2|jD](}t|t ƒrâ| !|j j |j|j¡qâWg}g}g}t"|ddƒ}t"|ddƒ}||krX| #||||¡}| $|¡n2||krŠ| %||||¡\}}| $|¡| &|¡d}|j'rê|j'sê| (|¡}| (|¡} | )|¡sê|| krê| dk rêd}| $| *|||¡¡|j'|j'kr| +|||¡}|r| $|¡| ,¡o.|j'o.|j' }!|s<|r"|!sJ||}|jjj-r‚|r‚t.t/|Žƒ\}}"d 0|¡t1|"gƒfg}x4|D],\}}"|  |j2| 3|j j ¡|dœ|"¡qˆW|!r"|  |j4| 3|j j ¡| 3|j¡ddœ| g¡x4|D],\}}"|  |j2| 3|j j ¡|dœ|"¡qòW|rHx|D]\}}"|  ||"¡q.W|jrd|jsd| 5||¡| 6||¡rˆ|  | 7||jg¡¡|jr˜|jr¾|jr¾|js¾|  |j8||gd¡g}#|rØ|# &t||ƒ¡| ||¡r|  | 9||¡¡|# &t||ƒ¡x|#D]ˆ\}$}|jj:|jd}%|%d}&| %|j|$j|j|&¡\}}|  |j2| 3|jj j ¡|ddœ|d¡x|D]\}}"|  ||"¡qzWqW|jjjrà|jrà| sÄ|jrÄ|jsà|jrà|  | ;||d¡¡|r*xB|j|'|ƒrò|'jjrò|  | ;|'j|'jd¡¡qòW|d |d krv|d rv|j?|j j |jgdd}|  | @|||d ¡¡|r¸|j*|||dd\}(}"|j2| 3|j j ¡|(dœ}|  ||"¡|jjjArÎ|j B¡dS)z3Perform a "physical" (non-ManyToMany) field update.T)rÂr¤z.F)rtrr£z7Found wrong number (%s) of unique constraints for %s.%scSsh|] }|j’qSr)r)rrrrrr–¤s)rÚtype_r£rGcSsh|] }|j’qSr)r)rrKrrrr–²s)rGr£z6Found wrong number (%s) of check constraints for %s.%srgNz, )rLrµz%s)rLrEr)rb)r$rfrz_fk_%(to_table)s_%(to_column)sZ_fkÚ_check)rž)r´)CÚsetr$r'rYrTrUr¦rEr§r¨rrVÚaddr/rÃrtÚ_field_became_primary_keyr]Ú_delete_unique_sqlrr"Z related_modelrÚdb_indexr¥r ržÚ_delete_index_sqlÚ_delete_check_sqlÚ_rename_field_sqlr,r‹rZrename_column_referencesriÚ_alter_column_collation_sqlr=Ú_alter_column_type_sqlrSrkrnrmrºÚ_alter_column_null_sqlr{Zsupports_combined_altersr>r!r_Úsumr»rCÚsql_update_with_defaultÚ_delete_primary_keyÚ_unique_should_be_addedrNr Ú_create_primary_key_sqlrQrZrZrelated_objectsrÚ_create_index_nameÚ_create_check_sqlr½r¾))r*rrr rÍrÏrÌrÎrËZ fks_droppedrÅrÆrªr¬Úconstraint_nameZdrop_foreign_keysZ_old_relZnew_relZ rel_fk_namesr«Z index_namesÚ index_namer4ÚactionsZ null_actionsZ post_actionsZ old_collationÚ new_collationÚfragmentZ other_actionsZneeds_database_defaultZ old_defaultÚ new_defaultZfour_way_default_alterationr5Zrels_to_updateZold_relZ rel_db_paramsZrel_typeÚrelrÀrrrrÊcs:                                            z%BaseDatabaseSchemaEditor._alter_fieldcCs\|jjjr| ¡dkrdS|j|jd}|jr4|jn|j}|| |j ¡|ddœgfSdS)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. )Z CharFieldZ TextFieldN)r$rf)rErf) r$r'rsr[rQrkÚsql_alter_column_nullÚsql_alter_column_not_nullrCrE)r*rrr rÎr4rrrrÝbs    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. )r$rf)rErfr) rnror$r'rprqrQrkÚ sql_alter_column_no_default_nullÚsql_alter_column_no_defaultÚsql_alter_column_defaultrCrE) r*rrr r´rêrr5rÎr4rrrrºxs&     z2BaseDatabaseSchemaEditor._alter_column_default_sqlcCs |j| |j¡|dœgfgfS)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. )rErf)Úsql_alter_column_typerCrE)r*rrr rÏrrrrÜs  z/BaseDatabaseSchemaEditor._alter_column_type_sqlcCs,|j| |j¡||r| |¡nddœgfS)Nr8)rErfrv)Úsql_alter_column_collaterCrErj)r*rr rÏrèrrrrÛ²s  z4BaseDatabaseSchemaEditor._alter_column_collation_sqlcCs¢|jjjj|jjjjkr:| |jj|jjjj|jjjj¡| |jj|jjj | ¡¡|jjj | ¡¡¡| |jj|jjj | ¡¡|jjj | ¡¡¡dS)z*Alter M2Ms to repoint their to= endpoints.N) rTr…rrVr¯rÐrDZm2m_reverse_field_nameZm2m_field_name)r*rrr rËrrrrɼsz,BaseDatabaseSchemaEditor._alter_many_to_manyr8c Csàt|ƒ\}}dt|f|žddiŽ|f}|jj ¡p6d}d|d |¡|f}t|ƒ|kr\|St|ƒ|dkr||d|d…}|t|ƒd d }d|d|…d |¡d|…|f}|d dksÌ|d  ¡rÜd |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%sÚlengthééÈz%s_%s_%sr¿éNér¤rzD%séÿÿÿÿ)r r r$rBZmax_name_lengthr_r§Úisdigit) r*Z table_nameÚ column_namesržr¿Zhash_suffix_partÚ max_lengthræZ other_lengthrrrrãÑs    z+BaseDatabaseSchemaEditor._create_index_namecCsX|dkr:t|ƒdkr*|djr*|dj}n|jjr:|jj}|dk rTd|jj |¡SdS)Nr¤rrHr8)r§r`rr$rBra)r*rrbr`rrrÚ_get_index_tablespace_sqlîs z2BaseDatabaseSchemaEditor._get_index_tablespace_sqlcCs|r d|SdS)Nz WHERE r8r)r*Ú conditionrrrÚ_index_condition_sqløsz-BaseDatabaseSchemaEditor._index_condition_sqlcCs,|r|jjjsdStdt|jj||jƒdS)Nr8z INCLUDE (%(columns)s))rc)r$r'Úsupports_covering_indexesrrrrVrC)r*rrcrrrÚ_index_include_sqlýs z+BaseDatabaseSchemaEditor._index_include_sql) rbrržÚusingr`Ú col_suffixesr4Ú opclassesrýÚincludeÚ expressionsc  s¼|pg}| pg} t|ddjˆjd} ˆj|||d}dd„|Dƒ}|pLˆj}|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)Z alias_cols)r$)r`cSsg|] }|j‘qSr)rE)rrrrrrFsz>BaseDatabaseSchemaEditor._create_index_sql..csˆdkrˆj||Ž‰ˆ ˆ¡S)N)rãrC)ÚargsÚkwargs)rr*rrÚcreate_index_names zEBaseDatabaseSchemaEditor._create_index_sql..create_index_name)rLrrrcr6rýr)r Z get_compilerr$rüÚsql_create_indexrrVrrrCrÚ_index_columnsrr@rþr)r*rrbrržrr`rr4rrýrrÚcompilerrarcr rLrr)rr*rr s&     z*BaseDatabaseSchemaEditor._create_index_sqlcCs&t|p |jt|jj|jƒ| |¡dS)N)rLr)rrŸrrrVrC)r*rrr4rrrrØ,sz*BaseDatabaseSchemaEditor._delete_index_sqlcCst|||j|dS)N)r)rrC)r*rLrcrrrrrr 3sz'BaseDatabaseSchemaEditor._index_columnscs¶ˆjjrˆjjsˆjjrgSg}x"ˆjjD]}| | ˆ|¡¡q*Wx8ˆjjD],}‡fdd„|Dƒ}| |j ˆ|dd¡qNWx2ˆjj D]&}|j rœ|j j jrˆ| | ˆ|¡¡qˆW|S)zŠ Return a list of all index SQL statements (field indexes, index_together, Meta.indexes) for the specified model. csg|]}ˆj |¡‘qSr)rrD)rr)rrrrFBsz?BaseDatabaseSchemaEditor._model_indexes_sql..r)rbrž)rZmanagedÚproxyZswappedrOrSr¼Zindex_togetherr=r r¥rr$r'rŽr)r*rÚoutputrr¡rbrr)rrrƒ6s z+BaseDatabaseSchemaEditor._model_indexes_sqlcCs*g}| ||¡r&| |j||gd¡|S)zT Return a list of all index SQL statements for the specified field. )rb)Ú_field_should_be_indexedr=r )r*rrr rrrr¼Ms z+BaseDatabaseSchemaEditor._field_indexes_sqlc CsŒ| ¡\}}}}| ¡\}}}} ddddddddd d d g } x$| D]} | | d¡|  | d¡q@W| |j¡| |j¡kpŠ|||f||| fkS) Nr}Z db_columnÚeditableZerror_messagesÚ help_textZlimit_choices_toZ on_deleteZ related_nameZrelated_query_nameZ validatorsZ verbose_name)Z deconstructÚpoprCrE) r*rr r¿Zold_pathZold_argsZ old_kwargsÚnew_pathZnew_argsZ new_kwargsZnon_database_attrsÚattrrrrrÈVs$  z1BaseDatabaseSchemaEditor._field_should_be_alteredcCs|jo |j S)N)r×rt)r*rrrrrrssz1BaseDatabaseSchemaEditor._field_should_be_indexedcCs|j o |jS)N)r)r*rr rrrrÕvsz2BaseDatabaseSchemaEditor._field_became_primary_keycCs"|j r|jp |jo |j o |jS)N)rtr)r*rr rrrráysz0BaseDatabaseSchemaEditor._unique_should_be_addedcCs*|j| |¡| |j¡| |j¡|dœS)N)rLZ old_columnZ new_columnrf)Úsql_rename_columnrCrE)r*rLrr rÏrrrrÚ~s   z*BaseDatabaseSchemaEditor._rename_field_sqlc Csˆt|jj|jƒ}| |||¡}t|jj|jg|jƒ}t|jjjj|jƒ}t|jjjj|jjg|jƒ}|j j   ¡} t |j |||||| dS)N)rLrrErIrJr³)rrrVrCr·rrEÚ target_fieldrr$rBr¸rÚ sql_create_fk) r*rrržrLrrErIrJr³rrrrZ†s z'BaseDatabaseSchemaEditor._create_fk_sqlcs<‡fdd„}t|jj|jgt|jjjjƒd|jjg||ƒS)Ncsˆ ˆj||Ž¡S)N)rCrã)rr)r*rrÚcreate_fk_name˜szDBaseDatabaseSchemaEditor._fk_constraint_name..create_fk_namer¤)rrrVrEr rr)r*rrržrr)r*rr·—s z,BaseDatabaseSchemaEditor._fk_constraint_namecCs| |j||¡S)N)r©Ú sql_delete_fk)r*rrrrrräsz'BaseDatabaseSchemaEditor._delete_fk_sqlcCs,|dkr dS|tjkrdS|tjkr(dSdS)Nr8z DEFERRABLE INITIALLY DEFERREDz DEFERRABLE INITIALLY IMMEDIATE)r ZDEFERREDZ IMMEDIATE)r*r³rrrÚ_deferrable_constraint_sql§s   z3BaseDatabaseSchemaEditor._deferrable_constraint_sqlc Cs‚|r|jjjsdS|s|s|rH|j||||||d}|rD|j |¡dS|jd t|j |ƒ¡|  |¡dœ} |j |  |¡| dœS)N)rrýrrz, )rcr³)rrK) r$r'Ú&supports_deferrable_unique_constraintsrNr,r=Úsql_unique_constraintr_r?rCrÚsql_constraint) r*rrbrrýr³rrr4rKrrrÚ _unique_sql¯s(   z$BaseDatabaseSchemaEditor._unique_sqlc sÆ|rˆjjjr*|rˆjjjr*|r.ˆjjjs.dS‡fdd„}t|jjˆjƒ} |dkrft |jj|d|ƒ}n ˆ |¡}ˆj | |d|d}|sŽ|sŽ|r–ˆj } nˆj } t | | ||ˆ |¡ˆ |¡ˆ ||¡dS)Ncsˆ ˆj||Ž¡S)N)rCrã)rr)r*rrÚcreate_unique_nameÝszGBaseDatabaseSchemaEditor._create_unique_sql..create_unique_nameÚ_uniqr)rr)rLrrcrýr³r)r$r'rÚsupports_partial_indexesrÿrrrVrCrr Úsql_create_unique_indexÚsql_create_uniquerrþrr) r*rrcrrýr³rrrrLr4r)r*rrNÏs,    z+BaseDatabaseSchemaEditor._create_unique_sqlcCsV|r|jjjr*|r|jjjr*|r.|jjjs.dS|s:|s:|rB|j}n|j}| |||¡S)N)r$r'rr rÿrŸr™r©)r*rrrýr³rrr4rrrrÖôs  z+BaseDatabaseSchemaEditor._delete_unique_sqlcCs |j| |¡|jd|idœS)NrG)rrK)rrCrR)r*rrGrrrÚ _check_sqlsz#BaseDatabaseSchemaEditor._check_sqlcCs$t|jt|jj|jƒ| |¡|dS)N)rLrrG)rÚsql_create_checkrrrVrC)r*rrrGrrrrä s z*BaseDatabaseSchemaEditor._create_check_sqlcCs| |j||¡S)N)r©Úsql_delete_check)r*rrrrrrÙsz*BaseDatabaseSchemaEditor._delete_check_sqlcCs t|t|jj|jƒ| |¡dS)N)rLr)rrrrVrC)r*Útemplaterrrrrr©sz/BaseDatabaseSchemaEditor._delete_constraint_sqlc  s |dk r‡fdd„|Dƒ}ˆj ¡} ˆjj | |jj¡} WdQRXg} x¾|  ¡D]²\} }|dksn||dkrR|dk r„|d|kr„qR|dk rš|d|kršqR|dk r°|d|kr°qR|dk rÆ|d|krÆqR|dk rØ|d sØqR|dk rî|d |krîqR| rú| | krR|  | ¡qRW| S) z@Return all constraint names matching the columns and conditions.Ncsg|]}ˆjj |¡‘qSr)r$Ú introspectionZidentifier_converter)rr)r*rrrF%sz>BaseDatabaseSchemaEditor._constraint_names..rcrtrrrGrÂrf)r$rAr'Zget_constraintsrrVÚitemsr=)r*rrúrtrrrÂrGrÑr£rAr]ÚresultrZinfodictr)r*rr¦s.   z*BaseDatabaseSchemaEditor._constraint_namescCsZ|j|dd}|r6t|ƒdkr6tdt|ƒ|jjfƒ‚x|D]}| | ||¡¡qs