3 [@sddlZddlZddlmZddlmZmZmZmZmZddl m Z ddl m Z ddl mZmZddlmZddlmZejd Zd d Zd d ZGdddZdS)N)datetime)ColumnsForeignKeyName IndexName StatementTable)split_identifier)Index)TransactionManagementErroratomic)timezone) force_byteszdjango.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_fieldrrB/tmp/pip-install-j7i95hgp/django/django/db/backends/base/schema.py_is_relevant_relations rcs2tfddjjjDfddjjjDS)Nc3s|]}t|r|VqdS)N)r).0obj) old_fieldrr %sz+_related_non_m2m_objects..c3s|]}t|r|VqdS)N)r)rr) new_fieldrrr&s)zipmodel_metarelated_objects)rrr)rrr_related_non_m2m_objects!src@seZdZdZdZdZdZdZdZdZ dZ d Z d Z d Z d Zd ZdZdZdZdZdZdZdZdZdZdZdZdZdZdZdsddZddZdd Z ffd!d"Z!d#d$Z"e#d%d&Z$dtd'd(Z%d)d*Z&d+d,Z'd-d.Z(d/d0Z)d1d2Z*d3d4Z+d5d6Z,d7d8Z-d9d:Z.d;d<Z/d=d>Z0d?d@Z1dAdBZ2dCdDZ3dEdFZ4dudGdHZ5dvdIdJZ6dKdLZ7dwdMdNZ8dOdPZ9dQdRZ:dxdTdUZ;dydVdWZd]d^Z?d_d`Z@dadbZAdcddZBdedfZCdgdhZDdidjZEdkdlZFdzdmdnZGd{dodpZHffdqdrZIdS)|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 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?ALTER TABLE %(table)s ADD CONSTRAINT %(name)s CHECK (%(check)s)z.ALTER TABLE %(table)s DROP CONSTRAINT %(name)szBALTER TABLE %(table)s ADD CONSTRAINT %(name)s UNIQUE (%(columns)s)z|ALTER TABLE %(table)s ADD CONSTRAINT %(name)s FOREIGN KEY (%(column)s) REFERENCES %(to_table)s (%(to_column)s)%(deferrable)sNz9CREATE INDEX %(name)s ON %(table)s (%(columns)s)%(extra)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!r rrr__init__Ws z!BaseDatabaseSchemaEditor.__init__cCs(g|_|jr$t|jj|_|jj|S)N) deferred_sqlr%r r alias __enter__)r&rrrr*`s  z"BaseDatabaseSchemaEditor.__enter__cCs<|dkr"x|jD]}|j|qW|jr8|jj|||dS)N)r(executer%r __exit__)r&exc_type exc_value tracebacksqlrrrr,gs  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))paramsr0)extra;N)r!r Zin_atomic_blockr#r$r strloggerdebugendswithr"appendtuplemap quote_valuecursorr+)r&r0r1Zendingr=rrrr+ps" z BaseDatabaseSchemaEditor.executecCs|jjj|S)N)r ops quote_name)r&rrrrr?sz#BaseDatabaseSchemaEditor.quote_namecGs4tj}x|D]}|jt|qW|jddS)zw Generate a 32-bit digest of a set of arguments that can be used to shorten identifying names. N)hashlibmd5updater hexdigest)clsargshargrrr_digests z BaseDatabaseSchemaEditor._digestc Cs,|j|jd}|d}g}|dkr&d S|j}|o:|j| }|r|j|}|dk r|jjjrp|d|j|7}n|d7}||g7}|jr|j r|jjj rd}|r|jjj r|d7}n |s|d7}|j r|d7}n|j r|d 7}|j p|jj } | r$|jjjr$|j r$|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 typeNz DEFAULT %sTz NULLz NOT NULLz PRIMARY KEYz UNIQUEz %s)inline)NN) db_parametersr null skip_defaulteffective_defaultr#requires_literal_defaultsprepare_defaultempty_strings_allowedr!interprets_empty_strings_as_nullsZimplied_column_nullunique db_tablespacerZsupports_tablespacesr>tablespace_sql) r&rrinclude_default db_paramsr0r1rM default_valueZ tablespacerrr column_sqls:      z#BaseDatabaseSchemaEditor.column_sqlcCsdS)z Some backends don't accept default values for certain columns types (i.e. MySQL longtext and longblob). Fr)r&rrrrrNsz%BaseDatabaseSchemaEditor.skip_defaultcCs 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&valuerrrrQsz(BaseDatabaseSchemaEditor.prepare_defaultcCs|jr|j}n|j rB|jrB|jrB|jdkr:t}qt}n\t|ddsZt|ddrt j }|j}|dkrz|j }q|dkr|j }q|dkrt j }nd}t|r|}|j||jS) z2Return a field's effective database default value.Z BinaryFieldZauto_nowFZ auto_now_addZ DateFieldZ TimeFieldZ DateTimeFieldN) has_default get_defaultrMZblankrRget_internal_typebytesr5getattrrnowdatetimer callableZget_db_prep_saver )r&rdefaultZ internal_typerrrrOs&  z*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<sz$BaseDatabaseSchemaEditor.quote_valuecs,g}g}x@jjD]2}|j|\}}|dkr4q|j|jd}|drZ|d|d7}|j|jd}|rx|d|7}|j||jr|jr|jj jj } |jj jj |jj j } |jr|d|j|j| |j| d7}n |jjjr|jj|j|d|jd |j|j |f|jdkr|jjjjj |j } | r|jj| qWx8jjD],} fd d | D} |jj|j| qVW|j|jjj dj|d}jjr|jjjjj}|r|d|7}|j||pd|jj|jx.jj D]"}|jj!jj"r|j#|jj!qWdS)zr Create a table and any accompanying indexes or unique constraints for the given `model`. N)r checkz CHECK (%s)z %s )to_table to_columnz_fk_%(to_table)s_%(to_column)sz%s %s AutoField BigAutoFieldcsg|]}jj|jqSr)r get_fieldcolumn)rr)rrr ,sz9BaseDatabaseSchemaEditor.create_model..z, )table definition)rkrl)$r local_fieldsrZrLr Zdb_type_suffixextend remote_field db_constraintrdb_tablerm field_namernsql_create_inline_fkr?r#supports_foreign_keysr(r9_create_fk_sqlr_r> autoinc_sqlZunique_together_create_unique_sqlsql_create_tablejoinrUrVr+_model_indexes_sqllocal_many_to_manythrough auto_created create_model)r&rZ column_sqlsr1rrqZ extra_paramsrXZcol_type_suffixrirjr{fieldscolumnsr0rVr)rrrsX           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)rrrtrr delete_modelr+sql_delete_tabler?rvlistr( isinstancerZreferences_tableremove)r&rrr0rrrrBs z%BaseDatabaseSchemaEditor.delete_modelcCs|j|j||dS)zAdd an index on a model.N)r+ create_sql)r&rindexrrr add_indexRsz"BaseDatabaseSchemaEditor.add_indexcCs|j|j||dS)zRemove an index from a model.N)r+Z remove_sql)r&rrrrr remove_indexVsz%BaseDatabaseSchemaEditor.remove_indexcsdd|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:)rrrrr `szABaseDatabaseSchemaEditor.alter_unique_together..cSsh|] }t|qSr)r:)rrrrrrasrTTcsg|]}jj|jqSr)rrmrn)rr)rrrrogszBBaseDatabaseSchemaEditor.alter_unique_together..N) difference_delete_composed_indexsql_delete_uniquer+r|)r&rZold_unique_togetherZnew_unique_togetheroldsnewsrrr)rralter_unique_togetherZsz.BaseDatabaseSchemaEditor.alter_unique_togethercsdd|D}dd|D}x(|j|D]}|j|ddi|jq(Wx:|j|D],}fdd|D}|j|j|dd qRWd 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:)rrrrrrpsz@BaseDatabaseSchemaEditor.alter_index_together..cSsh|] }t|qSr)r:)rrrrrrqsrTcsg|]}jj|qSr)rrm)rr)rrrrowszABaseDatabaseSchemaEditor.alter_index_together.._idx)suffixN)rrsql_delete_indexr+_create_index_sql)r&rZold_index_togetherZnew_index_togetherrrr field_namesr)rralter_index_togetherjsz-BaseDatabaseSchemaEditor.alter_index_togethercsjfdd|D}|j|f|}t|dkrNtdt|jjdj|f|j|j||ddS)Ncsg|]}jj|jqSr)rrmrn)rr)rrrro{szCBaseDatabaseSchemaEditor._delete_composed_index..z1Found wrong number (%s) of constraints for %s(%s)z, r)_constraint_nameslen ValueErrorrrvr~r+_delete_constraint_sql)r&rrZconstraint_kwargsr0rconstraint_namesr)rrrzs 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_tabler?r(rrZrename_table_references)r&rZ old_db_tableZ new_db_tabler0rrralter_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_tabler?rrv)r&rZold_db_tablespaceZnew_db_tablespacerrralter_db_tablespaces z,BaseDatabaseSchemaEditor.alter_db_tablespacecCsL|jr |jjjjr |j|jjS|j||dd\}}|dkr@dS|j|jd}|drf|d|d7}|j |j |jj |j |j |d}|j |||j| r|j|dk r|j|d|dd\}}|j|j |jj |d }|j |||jj|j|||jr2|jjjr2|jr2|jj|j||d |jjjrH|jjdS) z Create a field on a model. Usually involves adding a column, but may involve adding a table instead (for M2M fields). T)rWN)r rgz CHECK (%s))rprnrq)drop)rpchangesz_fk_%(to_table)s_%(to_column)s)rrtrrrrrZrLr sql_create_columnr?rvrnr+rNrO_alter_column_default_sqlsql_alter_columnr(rs_field_indexes_sqlr#ryrur9rzconnection_persists_old_columnsclose)r&rrrqr1rXr0 changes_sqlrrr add_fields0        z"BaseDatabaseSchemaEditor.add_fieldcCs|jr |jjjjr |j|jjS|j|jdddkr:dS|jrx|j||j gdd}x"|D]}|j |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)rprn)rrtrrrrrLr rrnr+r sql_delete_fksql_delete_columnr?rvr#rrrr(rrZreferences_columnr)r&rrfk_namesfk_namer0rrr remove_fields"     z%BaseDatabaseSchemaEditor.remove_fieldc Cs(|j|jd}|d}|j|jd}|d}|dkr>|jdksP|dkrb|jdkrbtd||fn|dkr|dkr|jjr|jjr|jjjjr|jjjjr|j||||S|dkr|dkr|jjr|jjr|jjjj r|jjjj rdS|dkp|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. )r rJNzqCannot 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)) rLr rtrrrr_alter_many_to_many _alter_field) r&rrrstrict old_db_paramsold_type new_db_paramsnew_typerrr alter_fields2    z$BaseDatabaseSchemaEditor.alter_fieldc & Cst} |jr|jr|j||jgdd} |rRt| dkrRtdt| |jj|jfx0| D](} | j |jf|j |j |j || qXW|j o|j s|j||r|j||jgddd} |rt| dkrtdt| |jj|jfx"| D]} |j |j |j|| qW|jr|js&|j o,|j o,||k}|rxXt||D]J\}}|j|j|jjgdd}x&|D]} |j |j |j |j| qfWq@W|jr |j r |j s|j r dd |jjD}|j||jgdtjd }x.|D]&}||kr|j |j |j||qW|d |d kr|d r|j||jgdd } |rlt| dkrltd t| |jj|jfx$| D]} |j |j |j|| qrW|j|jkr|j |j|jj|||x2|jD](}t|tr|j|jj|j|jqWg}g}g}||kr,|j||||\}}|j ||j!||j"|}|j"|}|j#op|j# op||kop|dk op|j$| }|r|j |j%||||j#|j#kr|j&|||}|r|j ||j'o|j#o|j# }|s|r|s||}|j(j)j*r$|r$t+t,|\}}dj-|t.|gfg}x4|D],\}}|j |j/|j0|jj|d|q*W|r|j |j1|j0|jj|j0|jdd|gx4|D],\}}|j |j/|j0|jj|d|qW|rx|D]\}}|j ||qW|jr|j r|j2|||j3||r,|j |j4||jg|j s>|j rd|jrd|j rd|j |j5||gg} |jr|jr||kr| j!t|||j||r|j |j6|j0|jj|j0|j7|jj|jgdd|j0|jd| j!t||x| D]\}!}|jj8|j(d}"|"d}#|j|j|!j|j|#\}}|j |j/|j0|jjj|dd|dx|D]\}}|j ||qfWqW|jr| s|j s|j r|jr|j |j9||d|rxB|j:jj;D]4}$t<|$|r|$jjr|j |j9|$j|$jdqW|d |d krt|d rt|j |j=|j0|jj|j0|j7|jj|jgdd|j0|j|d d|r|j%|||dd\}%}|j/|j0|jj|%d}|j |||j(j)j>r|j(j?dS)z3Perform a "physical" (non-ManyToMany) field update.T)rrz.)rtype_rg)rgz6Found wrong number (%s) of check constraints for %s.%sNz, )rprz%s)rprnrfZ_pk)r)rprr)r rJrz_fk_%(to_table)s_%(to_column)sZ_fk_check)rprrnrg)r)@setrtrurrnrrrrvaddr+rrrT_field_became_primary_keyrrrZ related_modelrdb_indexindexesr rrsql_delete_check_rename_field_sqlr(rrZrename_column_references_alter_column_type_sqlr9rsrOrMrNr_alter_column_null_sqlr]r r#Zsupports_combined_altersr:rr~sumrr?sql_update_with_default_delete_primary_key_unique_should_be_addedr|r sql_create_pk_create_index_namerLrzrrrsql_create_checkrr)&r&rrrrrrrrZ fks_droppedrrrconstraint_nameZdrop_foreign_keysZ_old_relZnew_relZ rel_fk_namesZmeta_index_namesZ index_names index_namer0actionsZ null_actionsZ post_actionsfragmentZ other_actionsZ old_default new_defaultZneeds_database_defaultZfour_way_default_alterationr1Zrels_to_updateZold_relZ rel_db_paramsZrel_typerelrrrrr s0      $ $                          $         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)rnrJ)rr) r r#rSr_rLrMsql_alter_column_nullsql_alter_column_not_nullr?rn)r&rrrrr0rrrrs    z/BaseDatabaseSchemaEditor._alter_column_null_sqlc Cst|j|}d}|g}|rg}n|jjjr6|j|}g}|j|jd}|rN|jn|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. z%s)r rJ)rnrJrf) rOr r#rPrQrLsql_alter_column_no_defaultsql_alter_column_defaultr?rn) r&rrrrrrfr1rr0rrrrs    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. )rnrJ)sql_alter_column_typer?rn)r&rrrrrrrr<s  z/BaseDatabaseSchemaEditor._alter_column_type_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) rtrrrvrrrmZm2m_reverse_field_nameZm2m_field_name)r&rrrrrrrrQsz,BaseDatabaseSchemaEditor._alter_many_to_manyr4c Cst|\}}d|j|f||f}|jjjp2d}d|dj||f}t||krX|St||dkrx|d|d}|t|dd}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%sz%s_%s_%s_NrrzD%s)rrIr r>Zmax_name_lengthr~risdigit) r&Z table_name column_namesrrZhash_suffix_part max_lengthrZ other_lengthrrrrfs    z+BaseDatabaseSchemaEditor._create_index_namecCsX|dkr:t|dkr*|djr*|dj}n|jjr:|jj}|dk rTd|jjj|SdS)Nrrrhr4)rrUrr r>rV)r&rrrUrrr_get_index_tablespace_sqls z2BaseDatabaseSchemaEditor._get_index_tablespace_sql)rrusingrU col_suffixesr0c srj|||d} dd|D} |p&j} |jj} fdd} t| t| jt| | || |t| | j|d| dS)z Return the SQL statement to create the index for one or several fields. `sql` can be specified if the syntax differs from the standard (GIS indexes, ...). )rUcSsg|] }|jqSr)rn)rrrrrrosz>BaseDatabaseSchemaEditor._create_index_sql..csdkrj||jS)N)rr?)rFkwargs)rr&rrcreate_index_names zEBaseDatabaseSchemaEditor._create_index_sql..create_index_name)r)rprrrr2) rsql_create_indexrrvrrr?rr)r&rrrrrrUrr0rVrrrprr)rr&rrs   z*BaseDatabaseSchemaEditor._create_index_sqlcsjj sjjsjjrgSg}x"jjD]}|j|j|q,Wx8jjD],}fdd|D}|j|j |ddqPWx"jj D]}|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)rrm)rr)rrrrosz?BaseDatabaseSchemaEditor._model_indexes_sql..r)r) rZmanagedproxyZswappedrrrsrZindex_togetherr9rrr)r&routputrrrrr)rrrsz+BaseDatabaseSchemaEditor._model_indexes_sqlcCs(g}|j||r$|j|j||g|S)zT Return a list of all index SQL statements for the specified field. )_field_should_be_indexedr9r)r&rrrrrrrs z+BaseDatabaseSchemaEditor._field_indexes_sqlcCs|jo |j S)N)rrT)r&rrrrrrsz1BaseDatabaseSchemaEditor._field_should_be_indexedcCs|j o |jS)N)r)r&rrrrrrsz2BaseDatabaseSchemaEditor._field_became_primary_keycCs"|j r|jp |jo |j o |jS)N)rTr)r&rrrrrrsz0BaseDatabaseSchemaEditor._unique_should_be_addedcCs*|j|j||j|j|j|j|dS)N)rpZ old_columnZ new_columnrJ)sql_rename_columnr?rn)r&rprrrrrrrs   z*BaseDatabaseSchemaEditor._rename_field_sqlc s|jj}|j}t|jjjj\}}|jj}fdd} tjt|j t ||g||g|| t ||gj t|jjjjj t |jjjj|gj j j jdS)Ncsjj||S)N)r?r)rFr)r&rrcreate_fk_namesz?BaseDatabaseSchemaEditor._create_fk_sql..create_fk_name)rprrnrirjZ deferrable)rrvrnrZ target_fieldrr sql_create_fkrr?rrr r>Zdeferrable_sql) r&rrrZ from_tableZ from_columnrrirjrr)r&rrzs  z'BaseDatabaseSchemaEditor._create_fk_sqlcsBfdd}|jj}tjt|jt||d|t||jdS)Ncsjj||S)N)r?r)rFr)r&rrcreate_unique_nameszGBaseDatabaseSchemaEditor._create_unique_sql..create_unique_nameZ_uniq)rprr)rrvrsql_create_uniquerr?rr)r&rrrrpr)r&rr|s   z+BaseDatabaseSchemaEditor._create_unique_sqlcCs||j|jj|j|dS)N)rpr)r?rrv)r&templaterrrrrrs z/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| j| qRW| S) z@Return all constraint names matching the columns and conditions.Ncsg|]}jjj|qSr)r introspectionZcolumn_name_converter)rr)r&rrrosz>BaseDatabaseSchemaEditor._constraint_names..rrTrrrgrrJ)r r=rZget_constraintsrrvitemsr9)r&rrrTrrrrgrr= constraintsresultrZinfodictr)r&rrs,  z*BaseDatabaseSchemaEditor._constraint_namescCs^|j|dd}|r6t|dkr6tdt||jjfx"|D]}|j|j|j||qs