a
    Lcòfd ã                   @   sÈ   d dl Z d dlZd dlmZ d dlmZ d dlmZmZmZm	Z	m
Z
mZ d dlmZmZmZ d dlmZmZ d dlmZ d dlmZmZ d d	lmZ e  d
¡Zdd„ Zdd„ Zdd„ ZG dd„ dƒZdS )é    N)Údatetime)Úsettings)ÚColumnsÚExpressionsÚForeignKeyNameÚ	IndexNameÚ	StatementÚTable)Únames_digestÚsplit_identifierÚtruncate_name)Ú
DeferrableÚIndex)ÚQuery)ÚTransactionManagementErrorÚatomic)Útimezonezdjango.db.backends.schemac                 C   s2   | j }|jrdS |jr&|jdgkr&dS |j|jv S )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)ZrelationZaltered_fieldr   © r   ú[/home/httpd/docs/test/DocsMgr/lib/python3.9/site-packages/django/db/backends/base/schema.pyÚ_is_relevant_relation   s    r   c                 C   s"   t | jjddddd�t d¡d�S )NFT)ÚforwardÚreverseZinclude_hiddenZinclude_parentsr   )Úkey)ÚsortedÚ_metaZ_get_fieldsÚoperatorÚ
attrgetter©Úmodelr   r   r   Ú_all_related_fields'   s    üùr#   c                 #   sb   t ‡fdd„tˆjƒD ƒ‡ fdd„tˆ jƒD ƒƒ}|D ]&\}}||fV  t|j|jƒE d H  q6d S )Nc                 3   s   | ]}t |ˆ ƒr|V  qd S ©N©r   ©Ú.0Úobj)Ú	old_fieldr   r   Ú	<genexpr>8   s   
þz+_related_non_m2m_objects.<locals>.<genexpr>c                 3   s   | ]}t |ˆ ƒr|V  qd S r$   r%   r&   )Ú	new_fieldr   r   r*   =   s   
þ)Úzipr#   r"   Ú_related_non_m2m_objectsÚremote_field)r)   r+   Zrelated_fieldsÚold_relÚnew_relr   )r+   r)   r   r-   4   s    
þ
þú
þr-   c                   @   s  e Zd ZdZdZdZdZdZdZdZ	dZ
d	Zd
ZdZdZeZdZdZdZdZdZdZdZdZeZdZeZdZdZdZeZdZdZ dZ!dZ"dZ#eZ$dZ%dZ&dZ'd³d"d#„Z(d$d%„ Z)d&d'„ Z*d´d)d*„Z+d+d,„ Z,d-d.„ Z-d/d0„ Z.dµd1d2„Z/d3d4„ Z0d5d6„ Z1d7d8„ Z2d9d:„ Z3e4d;d<„ ƒZ5d=d>„ Z6d?d@„ Z7dAdB„ Z8dCdD„ Z9dEdF„ Z:dGdH„ Z;dIdJ„ Z<dKdL„ Z=dMdN„ Z>dOdP„ Z?dQdR„ Z@dSdT„ ZAdUdV„ ZBdWdX„ ZCdYdZ„ ZDd[d\„ ZEd]d^„ ZFd¶d_d`„ZGd·dadb„ZHdcdd„ ZId¸dedf„ZJdgdh„ ZKdidj„ ZLdkdl„ ZMdmdn„ ZNd¹dpdq„ZOdºdrds„ZPdtdu„ ZQdvdw„ ZRdddododd(dd(ddddxœdydz„ZSd»d{d|„ZTd}d~„ ZUdd€„ ZVd�d‚„ ZWdƒd„„ ZXd¼d…d†„ZYd‡dˆ„ ZZd‰dŠ„ Z[d‹dŒ„ Z\d�dŽ„ Z]d�d�„ Z^d‘d’„ Z_d“d”„ Z`d•d–„ Zad½d—d˜„Zbd¾d™dš„Zcd¿d›dœ„ZddÀd�dž„ZedŸd „ Zfd¡d¢„ Zgd£d¤„ Zhd¥d¦„ ZidÁd§d¨„ZjdÂd©dª„Zkd«d¬„ Zld­d®„ ZmdÃd¯d°„ZndÄd±d²„ZodS )ÅÚ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)szDROP 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)szCHECK (%(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)szDROP INDEX %(name)szGALTER TABLE %(table)s ADD CONSTRAINT %(name)s PRIMARY KEY (%(columns)s)zDROP PROCEDURE %(procedure)sz)COMMENT ON TABLE %(table)s IS %(comment)sz5COMMENT ON COLUMN %(table)s.%(column)s IS %(comment)sFTc                 C   s,   || _ || _| jrg | _| j jjo$|| _d S r$   )Ú
connectionÚcollect_sqlÚcollected_sqlÚfeaturesÚcan_rollback_ddlÚatomic_migration)Úselfr2   r3   r   r   r   r   Ú__init__“   s
    z!BaseDatabaseSchemaEditor.__init__c                 C   s(   g | _ | jr$t| jjƒ| _| j ¡  | S r$   )Údeferred_sqlr7   r   r2   ÚaliasÚ	__enter__©r8   r   r   r   r<   œ   s
    
z"BaseDatabaseSchemaEditor.__enter__c                 C   s8   |d u r| j D ]}|  |¡ q| jr4| j |||¡ d S r$   )r:   Úexecuter7   r   Ú__exit__)r8   Úexc_typeÚ	exc_valueÚ	tracebackÚsqlr   r   r   r?   £   s
    
z!BaseDatabaseSchemaEditor.__exit__r   c                 C   sÒ   | j s | jjr | jjjs tdƒ‚t|ƒ}tjd||||dœd� | j r˜| 	¡  
d¡rXdnd}|dur†| j |tt| j|ƒƒ | ¡ qÎ| j || ¡ n6| j ¡ �}| ||¡ W d  ƒ n1 sÄ0    Y  dS )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))ÚparamsrC   )Úextraú;Ú N)r3   r2   Zin_atomic_blockr5   r6   r   ÚstrÚloggerÚdebugÚrstripÚendswithr4   ÚappendÚtupleÚmapÚquote_valueÚcursorr>   )r8   rC   rD   ÚendingrQ   r   r   r   r>   ¬   s,    ÿþýÿÿÿz BaseDatabaseSchemaEditor.executec                 C   s   | j j |¡S r$   )r2   ÚopsÚ
quote_name)r8   r   r   r   r   rT   Ë   s    z#BaseDatabaseSchemaEditor.quote_namec                    s  ˆ j jD ]*}‡ fdd„|D ƒ}ˆj ˆ ˆ |¡¡ qg }g }ˆ j jD �]<}ˆ ˆ |¡\}}|du rdqD|jˆjd�}	|	d rŒ|dˆj	|	  7 }|j
ˆjd�}
|
rª|d|
 7 }| |¡ |j�r6|j�r6|jjj j}|jjj  |jj¡j}ˆj�r|dˆjˆ |¡ˆ |¡dœ  7 }n"ˆjjj�r6ˆj ˆ ˆ |d	¡¡ | d
ˆ |j¡|f ¡ | ¡ dv rDˆjj ˆ j j|j¡}|rDˆj |¡ qD‡ ‡fdd„ˆ j jD ƒ}ˆjˆ ˆ j j¡d dd„ g |¢|¢R D ƒ¡dœ }ˆ j j�rþˆjj ˆ j j¡}|�rþ|d| 7 }||fS )z-Take a model and return its table definition.c                    s   g | ]}ˆ j  |¡‘qS r   ©r   Ú	get_field©r'   r   r!   r   r   Ú
<listcomp>Ó   ó    z6BaseDatabaseSchemaEditor.table_sql.<locals>.<listcomp>N©r2   Úcheckú z %s)Úto_tableÚ	to_columnú_fk_%(to_table)s_%(to_column)sz%s %s)Z	AutoFieldZBigAutoFieldZSmallAutoFieldc                    s   g | ]}|  ˆ ˆ¡‘qS r   )Zconstraint_sql©r'   Ú
constraint©r"   r8   r   r   rX     s   ÿú, c                 s   s   | ]}|rt |ƒV  qd S r$   )rH   r`   r   r   r   r*     s   þz5BaseDatabaseSchemaEditor.table_sql.<locals>.<genexpr>)ÚtableÚ
definition) r   Zunique_togetherr:   rM   Ú_create_unique_sqlÚlocal_fieldsÚ
column_sqlÚdb_parametersr2   Úsql_check_constraintÚdb_type_suffixÚextendr.   Údb_constraintr"   Údb_tablerV   Ú
field_nameÚcolumnÚsql_create_inline_fkrT   r5   Úsupports_foreign_keysÚ_create_fk_sqlÚget_internal_typerS   Úautoinc_sqlÚconstraintsÚsql_create_tableÚjoinÚdb_tablespaceÚtablespace_sql)r8   r"   Úfield_namesÚfieldsZcolumn_sqlsrD   r   re   Zextra_paramsÚ	db_paramsÚcol_type_suffixr]   r^   ru   rv   rC   rz   r   rb   r   Ú	table_sqlÎ   sz    

ÿþÿÿ
þÿÿ	
ÿþ
þþ
ÿz"BaseDatabaseSchemaEditor.table_sqlc                 c   sH  |V  |  d¡ }r |  |¡V  | jjjr>|jr>|  |j¡V  |j}|ob|  |¡ ob|o`|  	|¡ }|r´|  
|¡}	|	d ur´d|  |¡ }
| jjjr¤|
|  |	¡ V  n|
V  | |	¡ |jrÎ|jsÎ| jjjrÎd}|sÚdV  n| jjjsêdV  |jrødV  n|j�rdV  |j�p|jj}|�rD| jjj�rD|j�rD| jjj|dd�V  d S )	NÚ	collationzDEFAULT TzNOT NULLZNULLzPRIMARY KEYZUNIQUE)Úinline)ÚgetÚ_collate_sqlr2   r5   Úsupports_comments_inlineÚ
db_commentÚ_comment_sqlÚnullÚskip_defaultÚskip_default_on_alterÚeffective_defaultÚ_column_default_sqlÚrequires_literal_defaultsÚprepare_defaultrM   Úempty_strings_allowedr   Ú!interprets_empty_strings_as_nullsZimplied_column_nullÚuniquery   r   Zsupports_tablespacesrS   rz   )r8   Úcolumn_db_typerD   r"   r   Úfield_db_paramsÚinclude_defaultr€   r‡   Údefault_valueZcolumn_defaultZ
tablespacer   r   r   Ú_iter_column_sql!  sT    
ÿù	


ÿþý
ÿþýz)BaseDatabaseSchemaEditor._iter_column_sqlc              
   C   sD   |j | jd�}|d }|du r"dS g }d |  ||||||¡¡|fS )z†
        Return the column definition for a field. The field must already have
        had set_attributes_from_name() called.
        rZ   ÚtypeN)NNr\   )ri   r2   rx   r•   )r8   r"   r   r“   r’   r‘   rD   r   r   r   rh   Z  s"    úþôz#BaseDatabaseSchemaEditor.column_sqlc                 C   s   dS )z�
        Some backends don't accept default values for certain columns types
        (i.e. MySQL longtext and longblob).
        Fr   ©r8   r   r   r   r   rˆ   u  s    z%BaseDatabaseSchemaEditor.skip_defaultc                 C   s   dS )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—   r   r   r   r‰   |  s    z.BaseDatabaseSchemaEditor.skip_default_on_alterc                 C   s   t dƒ‚dS )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©r8   Úvaluer   r   r   r�   ƒ  s    ÿz(BaseDatabaseSchemaEditor.prepare_defaultc                 C   s   dS )z�
        Return the SQL to use in a DEFAULT clause. The resulting string should
        contain a '%s' placeholder for a default value.
        ú%sr   r—   r   r   r   r‹   Œ  s    z,BaseDatabaseSchemaEditor._column_default_sqlc                 C   s¢   |   ¡ r|  ¡ }nŒ| js<| jr<| jr<|  ¡ dkr6d}qžd}nbt| ddƒsTt| ddƒrš|  ¡ }|dkrnt ¡ }qžt	 ¡ }|dkrˆ| 
¡ }qž|d	krž| ¡ }nd }|S )
NZBinaryFieldrY   rG   Zauto_nowFZauto_now_addZDateTimeFieldZ	DateFieldZ	TimeField)Úhas_defaultÚget_defaultr‡   ÚblankrŽ   rt   Úgetattrr   Únowr   ÚdateÚtime)r   ÚdefaultZinternal_typer   r   r   Ú_effective_default“  s"    



z+BaseDatabaseSchemaEditor._effective_defaultc                 C   s   |  |  |¡| j¡S )z2Return a field's effective database default value.)Zget_db_prep_saver¥   r2   r—   r   r   r   rŠ   «  s    z*BaseDatabaseSchemaEditor.effective_defaultc                 C   s
   t ƒ ‚dS )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).
        Nr˜   rš   r   r   r   rP   ¯  s    z$BaseDatabaseSchemaEditor.quote_valuec                 C   sÌ   |   |¡\}}|  ||pd¡ | jjjrŽ|jjrB|  |d|jj¡ | jjjsŽ|jj	D ]8}|j
rT|j| jd�}|d }| j|  ||||j
¡Ž  qT| j |  |¡¡ |jjD ]}|jjjjr¨|  |jj¡ q¨dS )zr
        Create a table and any accompanying indexes or unique constraints for
        the given `model`.
        NrZ   r–   )r   r>   r2   r5   Úsupports_commentsr   Zdb_table_commentÚalter_db_table_commentr„   rg   r…   ri   Ú_alter_column_comment_sqlr:   rl   Ú_model_indexes_sqlÚlocal_many_to_manyr.   ÚthroughÚauto_createdÚcreate_model)r8   r"   rC   rD   r   r’   Ú
field_typer   r   r   r­   »  s*    

ÿ
ÿÿz%BaseDatabaseSchemaEditor.create_modelc                 C   s~   |j jD ]}|jjj jr|  |jj¡ q|  | jd|  |j j	¡i ¡ t
| jƒD ](}t|tƒrP| |j j	¡rP| j |¡ qPdS )z!Delete a model from the database.rd   N)r   rª   r.   r«   r¬   Údelete_modelr>   Úsql_delete_tablerT   rn   Úlistr:   Ú
isinstancer   Zreferences_tableÚremove)r8   r"   r   rC   r   r   r   r¯   ß  s    ÿÿÿÿz%BaseDatabaseSchemaEditor.delete_modelc                 C   s.   |j r| jjjsdS | j| || ¡dd� dS )zAdd an index on a model.N©rD   )Úcontains_expressionsr2   r5   Úsupports_expression_indexesr>   Ú
create_sql©r8   r"   Úindexr   r   r   Ú	add_indexô  s    ÿþz"BaseDatabaseSchemaEditor.add_indexc                 C   s*   |j r| jjjsdS |  | || ¡¡ dS )zRemove an index from a model.N)rµ   r2   r5   r¶   r>   Ú
remove_sqlr¸   r   r   r   Úremove_indexÿ  s    ÿþz%BaseDatabaseSchemaEditor.remove_indexc                 C   sD   | j jjr(| j|  ||j|j¡d d� n|  ||¡ |  ||¡ d S )Nr´   )r2   r5   Zcan_rename_indexr>   Ú_rename_index_sqlr   r¼   rº   )r8   r"   Z	old_indexZ	new_indexr   r   r   Úrename_index  s    
þz%BaseDatabaseSchemaEditor.rename_indexc                 C   s"   |  || ¡}|r| j|dd� dS )zAdd a constraint to a model.Nr´   )r·   r>   ©r8   r"   ra   rC   r   r   r   Úadd_constraint  s    z'BaseDatabaseSchemaEditor.add_constraintc                 C   s   |  || ¡}|r|  |¡ dS )z!Remove a constraint from a model.N)r»   r>   r¿   r   r   r   Úremove_constraint  s    z*BaseDatabaseSchemaEditor.remove_constraintc                    s|   dd„ |D ƒ}dd„ |D ƒ}|  |¡D ]}|  ˆ |dddœ| j¡ q&|  |¡D ](}‡ fdd„|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.
        c                 S   s   h | ]}t |ƒ’qS r   ©rN   ©r'   r|   r   r   r   Ú	<setcomp>&  rY   zABaseDatabaseSchemaEditor.alter_unique_together.<locals>.<setcomp>c                 S   s   h | ]}t |ƒ’qS r   rÂ   rÃ   r   r   r   rÄ   '  rY   TF)r�   r   c                    s   g | ]}ˆ j  |¡‘qS r   rU   rW   r!   r   r   rX   2  rY   zBBaseDatabaseSchemaEditor.alter_unique_together.<locals>.<listcomp>N)Ú
differenceÚ_delete_composed_indexÚsql_delete_uniquer>   rf   )r8   r"   Zold_unique_togetherZnew_unique_togetherÚoldsÚnewsr|   r{   r   r!   r   Úalter_unique_together   s    üz.BaseDatabaseSchemaEditor.alter_unique_togetherc                    s€   dd„ |D ƒ}dd„ |D ƒ}|  |¡D ]}|  ˆ |dddœ| j¡ q&|  |¡D ],}‡ fdd„|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.
        c                 S   s   h | ]}t |ƒ’qS r   rÂ   rÃ   r   r   r   rÄ   ;  rY   z@BaseDatabaseSchemaEditor.alter_index_together.<locals>.<setcomp>c                 S   s   h | ]}t |ƒ’qS r   rÂ   rÃ   r   r   r   rÄ   <  rY   TF)r¹   r�   c                    s   g | ]}ˆ j  |¡‘qS r   rU   rW   r!   r   r   rX   G  rY   zABaseDatabaseSchemaEditor.alter_index_together.<locals>.<listcomp>Ú_idx©r|   ÚsuffixN)rÅ   rÆ   Úsql_delete_indexr>   Ú_create_index_sql)r8   r"   Zold_index_togetherZnew_index_togetherrÈ   rÉ   r|   r{   r   r!   r   Úalter_index_together5  s    üz-BaseDatabaseSchemaEditor.alter_index_togetherc           
         sÜ   dd„ ˆ j jD ƒ}dd„ ˆ j jD ƒ}‡ fdd„|D ƒ}| jˆ |fd||B i|¤Ž}| d¡du r”|r”| jjjr”t| j	ˆ j j
|d	d
�ƒ}	|	|v r”|	g}t|ƒdkrÀtdt|ƒˆ j j
d |¡f ƒ‚|  |  |ˆ |d ¡¡ d S )Nc                 S   s   h | ]
}|j ’qS r   ©r   r`   r   r   r   rÄ   K  s   zBBaseDatabaseSchemaEditor._delete_composed_index.<locals>.<setcomp>c                 S   s   h | ]
}|j ’qS r   rÑ   r`   r   r   r   rÄ   N  rY   c                    s   g | ]}ˆ j  |¡j‘qS r   )r   rV   rp   rW   r!   r   r   rX   O  rY   zCBaseDatabaseSchemaEditor._delete_composed_index.<locals>.<listcomp>Úexcluder�   TF©Úquoteé   z1Found wrong number (%s) of constraints for %s(%s)rc   r   )r   rv   ÚindexesÚ_constraint_namesr‚   r2   r5   Z*allows_multiple_constraints_on_same_fieldsrH   Ú_unique_constraint_namern   ÚlenÚ
ValueErrorrx   r>   Ú_delete_constraint_sql)
r8   r"   r|   Zconstraint_kwargsrC   Úmeta_constraint_namesÚmeta_index_namesÚcolumnsÚconstraint_namesÚdefault_namer   r!   r   rÆ   J  sD    ÿþýüÿþýÿýÿÿz/BaseDatabaseSchemaEditor._delete_composed_indexc                 C   sn   ||ks"| j jjr&| ¡ | ¡ kr&dS |  | j|  |¡|  |¡dœ ¡ | jD ]}t|t	ƒrN| 
||¡ qNdS )z#Rename the table a model points to.N)Z	old_tableZ	new_table)r2   r5   Zignores_table_name_caseÚlowerr>   Úsql_rename_tablerT   r:   r²   r   Zrename_table_references)r8   r"   Zold_db_tableZnew_db_tablerC   r   r   r   Úalter_db_tablel  s     ÿþþÿÿ

z'BaseDatabaseSchemaEditor.alter_db_tablec                 C   s>   | j r:| jjjr:|  | j |  |jj¡|  |p.d¡dœ ¡ d S )NrG   )rd   Úcomment)	Úsql_alter_table_commentr2   r5   r¦   r>   rT   r   rn   rP   )r8   r"   Zold_db_table_commentZnew_db_table_commentr   r   r   r§     s    þÿÿz/BaseDatabaseSchemaEditor.alter_db_table_commentc                 C   s2   |   | j|  |jj¡|  |¡|  |¡dœ ¡ dS )z)Move a model's table between tablespaces.)rd   Zold_tablespaceZnew_tablespaceN)r>   Úsql_retablespace_tablerT   r   rn   )r8   r"   Zold_db_tablespaceZnew_db_tablespacer   r   r   Úalter_db_tablespace‰  s    ýÿÿz,BaseDatabaseSchemaEditor.alter_db_tablespacec              
   C   sJ  |j r |jjjjr |  |jj¡S | j||dd�\}}|du r@dS |j| jd� }r`|d|› �7 }|j	| jd�}|d rˆ|d| j
|  7 }|j�rT| jjj�rT|j�rTd}| j�r>|jjjj}|jjj |jj¡j}	t|jjƒ\}
}|d| j|  |||¡|
�r
d|  |
¡ nd	|  |j¡|  |¡|  |	¡| jj ¡ d
œ  7 }n| j |  |||¡¡ | j|  |jj¡|  |j¡|dœ }|  ||¡ |  |¡�sÜ|  |¡du�rÜ| j |d|dd�\}}| j!|  |jj¡|dœ }|  ||¡ |j"�r| jjj#�r| jjj$�s|d }| j|  %||||j"¡Ž  | j &|  '||¡¡ | jjj(�rF| j )¡  dS )z�
        Create a field on a model. Usually involves adding a column, but may
        involve adding a table instead (for M2M fields).
        T)r“   NrZ   r\   r[   r_   z%s.rG   )r   Ú	namespacerp   r]   r^   Ú
deferrable)rd   rp   re   ©Údrop©rd   Úchangesr–   )*r   r.   r«   r   r¬   r­   rh   rk   r2   ri   rj   r5   rr   rm   Úsql_create_column_inline_fkr"   rn   rV   ro   rp   r   Ú_fk_constraint_namerT   rS   Údeferrable_sqlr:   rM   rs   Úsql_create_columnr>   r‰   rŠ   Ú_alter_column_default_sqlÚsql_alter_columnr…   r¦   r„   r¨   rl   Ú_field_indexes_sqlÚconnection_persists_old_columnsÚclose)r8   r"   r   re   rD   r~   r}   Zconstraint_suffixr]   r^   rè   Ú_rC   Úchanges_sqlr®   r   r   r   Ú	add_field”  sŠ    ÿþý
ÿÿ

øÿ
ýÿþÿ
þÿþý
ÿÿz"BaseDatabaseSchemaEditor.add_fieldc                 C   sì   |j r |jjjjr |  |jj¡S |j| jd�d du r:dS |jrp| j||j	gdd�}|D ]}|  
|  ||¡¡ qX| j|  |jj¡|  |j	¡dœ }|  
|¡ | jjjr°| j ¡  t| jƒD ],}t|tƒrº| |jj|j	¡rº| j |¡ qºdS )z…
        Remove a field from a model. Usually involves deleting a column,
        but for M2Ms may involve deleting a table.
        rZ   r–   NT©Úforeign_key)rd   rp   )r   r.   r«   r   r¬   r¯   ri   r2   r×   rp   r>   Ú_delete_fk_sqlÚsql_delete_columnrT   rn   r5   rõ   rö   r±   r:   r²   r   Zreferences_columnr³   )r8   r"   r   Úfk_namesÚfk_namerC   r   r   r   Úremove_fieldê  s(    
þ



ÿz%BaseDatabaseSchemaEditor.remove_fieldc           	   
   C   s6  |   ||¡sdS |j| jd�}|d }|j| jd�}|d }|du rN|jdu s`|du rr|jdu rrtd||f ƒ‚n¨|du rº|du rº|jjrº|jjrº|jjjjrº|jjjjrº|  ||||¡S |du rö|du rö|jjrö|jjrö|jjjjsö|jjjjsödS |du �s
|du �rtd||f ƒ‚|  	||||||||¡ dS )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.
        NrZ   r–   zqCannot alter field %s into %s - they do not properly define db_type (are you using a badly-written custom field?)z�Cannot 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_alteredri   r2   r.   rÚ   r«   r   r¬   Ú_alter_many_to_manyÚ_alter_field)	r8   r"   r)   r+   ÚstrictÚold_db_paramsÚold_typeÚnew_db_paramsÚnew_typer   r   r   Úalter_field
  st    ÿÿþÿÿþüû
ú
ù
ÿþüû
ú
ùþÿøz$BaseDatabaseSchemaEditor.alter_fieldc	           /   	   C   sú  t ƒ }	| jjjr˜|jr˜|jr˜| j||dhd�r˜| j||jgdd�}
|rnt	|
ƒdkrnt
dt	|
ƒ|jj|jf ƒ‚|
D ]$}|	 |jf¡ |  |  ||¡¡ qr|j�r,|jr´|  ||¡�r,dd„ |jjD ƒ}| j||jgdd	|d
�}|�rt	|ƒdk�rt
dt	|ƒ|jj|jf ƒ‚|D ]}|  |  ||¡¡ �q| d¡}| d¡}| jjj�o||j�r\|j�sl|j�o||j�o|||k�p|||k}|�rÒt||ƒD ]B\}}| j|j|jjgdd�}|D ]}|  |  |j|¡¡ �q²�qŽ|j�r<|j�s<|j�rò|j�r<dd„ |jjD ƒ}| j||jgdtj|d�}|D ]}|  |  ||¡¡ �q"|d |d k�rÎ|d �rÎdd„ |jjD ƒ}| j||jgd|d�}|�r°t	|ƒdk�r°t
dt	|ƒ|jj|jf ƒ‚|D ]}|  |  ||¡¡ �q´|j|jk�r&|  |  |jj|||¡¡ | j D ](}t!|t"ƒ�rü| #|jj|j|j¡ �qüg }g }g }|j$| jd�}|j$| jd�}||k�s†||k�s†||k�s†| jjj%�r²|j&|j&k�r²|  '||||||¡\}}| (|¡ | )|¡ d	} |j*�r|j*�s|  +|¡}!|  +|¡}"|  ,|¡�s|!|"k�r|"du�rd} | (|  -|||¡¡ |j*|j*k�r>|  .|||¡}|�r>| (|¡ | /¡ �oV|j*�oV|j* }#|�sd|�rB|#�sr||7 }| jjj0�rª|�rªt1t2|Ž ƒ\}}$d 3|¡t4|$g ƒfg}|D ],\}}$|  | j5|  6|jj¡|dœ |$¡ �q®|#�rB|  | j7|  6|jj¡|  6|j¡ddœ |"g¡ |D ],\}}$|  | j5|  6|jj¡|dœ |$¡ �q|�rd|D ]\}}$|  ||$¡ �qL|j�r€|j�s€|  8||¡ |  9||¡�r¢|  |  :||g¡¡ |j�r²|j�rØ|j�rØ|j�sØ|  | j;||gd�¡ g }%|�rò|% )t||ƒ¡ |  ||¡�r"|  |  <||¡¡ |% )t||ƒ¡ |%D ]¬\}&}|jj=| jd�}'|'d }(|' d¡})|&jj=| jd�}*|* d¡}+|  '|j|&j|j|(|+|)¡\}}|  | j5|  6|jjj¡|d dœ |d ¡ |D ]\}}$|  ||$¡ �q¸�q&| jjj�r|j�r|	�sþ|j�rþ|j�s|j�r|  |  >||d¡¡ |�rR|%D ],\},}-|-jj�r$|  |  >|-j|-jd¡¡ �q$|d |d k�rž|d �rž| j?|jj|jgdd�}|  |  @|||d ¡¡ | �rà| j-|||dd �\}.}$| j5|  6|jj¡|.dœ }|  ||$¡ | jjjA�rö| j B¡  dS )!z3Perform a "physical" (non-ManyToMany) field update.r…   )ÚignoreTrú   rÕ   z<Found wrong number (%s) of foreign key constraints for %s.%sc                 S   s   h | ]
}|j ’qS r   rÑ   r`   r   r   r   rÄ   v  s   z8BaseDatabaseSchemaEditor._alter_field.<locals>.<setcomp>F)r�   r   rÒ   z7Found wrong number (%s) of unique constraints for %s.%sr€   c                 S   s   h | ]
}|j ’qS r   rÑ   )r'   r¹   r   r   r   rÄ   °  rY   )r¹   Útype_rÒ   r[   c                 S   s   h | ]
}|j ’qS r   rÑ   r`   r   r   r   rÄ   Á  s   )r[   rÒ   z6Found wrong number (%s) of check constraints for %s.%srZ   Nrc   rì   rœ   )rd   rp   r¤   ©r|   r–   r   r_   Z_fkÚ_check©rÍ   rê   )CÚsetr2   r5   rr   r.   rm   r  r×   rp   rÙ   rÚ   r   rn   Úaddr>   rü   r�   Ú_field_became_primary_keyrv   Ú_delete_unique_sqlr‚   r   r-   Zrelated_modelr   Údb_indexrÖ   r   rÍ   Ú_delete_index_sqlÚ_delete_check_sqlÚ_rename_field_sqlr:   r²   r   Zrename_column_referencesrk   r¦   r…   Ú_alter_column_type_sqlrM   rl   r‡   rŠ   r‰   rò   Ú_alter_column_null_sqlr�   Zsupports_combined_altersrN   r,   rx   Úsumró   rT   Úsql_update_with_defaultÚ_delete_primary_keyÚ_unique_should_be_addedrf   rÏ   Ú_create_primary_key_sqlri   rs   Ú_create_index_nameÚ_create_check_sqlrõ   rö   )/r8   r"   r)   r+   r  r  r  r  r  Zfks_droppedrþ   rÿ   rÜ   rß   Úconstraint_nameÚold_collationÚnew_collationZdrop_foreign_keysZ_old_relr0   Zrel_fk_namesrÝ   Zindex_namesÚ
index_namerC   ÚactionsZnull_actionsZpost_actionsZold_type_suffixZnew_type_suffixÚfragmentÚother_actionsZneeds_database_defaultZold_defaultÚnew_defaultZfour_way_default_alterationrD   Zrels_to_updater/   Zrel_db_paramsZrel_typeZrel_collationZold_rel_db_paramsZold_rel_collationr÷   Úrelrø   r   r   r   r  J  s.   ÿþýýü

ÿýÿÿÿ
ÿÿûýÿÿ

ýúÿÿþýýûÿüýÿÿÿÿ
ÿÿþýû
ú	ÿ



ÿþýÿ

ÿþÿú
ýÿùþÿúÿÿþý

úþÿúÿþüüüúÿ
ÿÿÿÿ
þz%BaseDatabaseSchemaEditor._alter_fieldc                 C   sV   | j jjr|jrdS |j| j d�}|jr.| jn| j}||  |j	¡|d dœ g fS dS )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.
        NrZ   r–   )rp   r–   )
r2   r5   r�   rŽ   ri   r‡   Úsql_alter_column_nullÚsql_alter_column_not_nullrT   rp   )r8   r"   r)   r+   r  rC   r   r   r   r  ¤  s"    ÿþÿý
þÿúz/BaseDatabaseSchemaEditor._alter_column_null_sqlc           
      C   sŠ   |   |¡}|  |¡}|g}|r$g }n| jjjr<|  |¡}g }|j| jd�}|rd|jr\| j}	qj| j	}	n| j
}	|	|  |j¡|d |dœ |fS )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.
        rZ   r–   )rp   r–   r¤   )rŠ   r‹   r2   r5   rŒ   r�   ri   r‡   Ú sql_alter_column_no_default_nullÚsql_alter_column_no_defaultÚsql_alter_column_defaultrT   rp   )
r8   r"   r)   r+   rë   r'  r¤   rD   r  rC   r   r   r   rò   Á  s,    




ýÿùz2BaseDatabaseSchemaEditor._alter_column_default_sqlc                 C   s¨   g }|   |||jj¡ }r&d|› �}nd}d}	| jjjr„|js„|j|jkrr|  ||||j¡\}
}|
rr| 	|
|f¡ |jr„|  
|j¡}	| j|  |j¡|||	dœ g f|fS )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.
        r\   rG   )rp   r–   r€   rä   )rƒ   r   rn   r2   r5   r¦   r   r…   r¨   rM   r†   Úsql_alter_column_typerT   rp   )r8   r"   r)   r+   r  r!  r"  r&  Zcollate_sqlZcomment_sqlrC   rD   r   r   r   r  ç  s6    
ÿ
ÿ
üÿø
õz/BaseDatabaseSchemaEditor._alter_column_type_sqlc                 C   s.   | j |  |jj¡|  |j¡|  |¡dœ g fS )N)rd   rp   rä   )Úsql_alter_column_commentrT   r   rn   rp   r†   )r8   r"   r+   r  Znew_db_commentr   r   r   r¨     s    
ýÿùz2BaseDatabaseSchemaEditor._alter_column_comment_sqlc                 C   s   |   |p
d¡S )NrG   )rP   )r8   rä   r   r   r   r†      s    z%BaseDatabaseSchemaEditor._comment_sqlc                 C   s¢   |j jjj|j jjjkr:|  |j j|j jjj|j jjj¡ |  |j j|j jj | ¡ ¡|j jj | ¡ ¡¡ |  |j j|j jj | ¡ ¡|j jj | ¡ ¡¡ dS )z*Alter M2Ms to repoint their to= endpoints.N)	r.   r«   r   rn   rã   r	  rV   Zm2m_reverse_field_nameZm2m_field_name)r8   r"   r)   r+   r  r   r   r   r  #  s.    

ÿÿ

ý
ÿ
ÿøüz,BaseDatabaseSchemaEditor._alter_many_to_manyrG   c           	      C   sâ   t |ƒ\}}dt|g|¢R ddiŽ|f }| jj ¡ p8d}d|d |¡|f }t|ƒ|kr^|S t|ƒ|d kr~|d|d … }|t|ƒ d	 d
 }d|d|… d |¡d|… |f }|d dksÎ|d  ¡ rÞd|dd…  }|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Õ   r   zD%séÿÿÿÿ)r   r
   r2   rS   Úmax_name_lengthrx   rÙ   Úisdigit)	r8   Ú
table_nameÚcolumn_namesrÍ   r÷   Zhash_suffix_partÚ
max_lengthr#  Zother_lengthr   r   r   r  C  s(    þ
ýz+BaseDatabaseSchemaEditor._create_index_namec                 C   sf   |d u rHt |ƒdkr*|d jr*|d j}ntjr8tj}n|jjrH|jj}|d urbd| jj |¡ S dS )NrÕ   r   r\   rG   )rÙ   ry   r   ZDEFAULT_INDEX_TABLESPACEr   r2   rS   rz   )r8   r"   r|   ry   r   r   r   Ú_get_index_tablespace_sqlc  s    z2BaseDatabaseSchemaEditor._get_index_tablespace_sqlc                 C   s   |rd| S dS )Nz WHERE rG   r   )r8   Ú	conditionr   r   r   Ú_index_condition_sqlo  s    z-BaseDatabaseSchemaEditor._index_condition_sqlc                 C   s,   |r| j jjsdS tdt|jj|| jƒd�S )NrG   z INCLUDE (%(columns)s))rÞ   )r2   r5   Úsupports_covering_indexesr   r   r   rn   rT   )r8   r"   rÞ   r   r   r   Ú_index_include_sqlt  s    þz+BaseDatabaseSchemaEditor._index_include_sql)r|   r   rÍ   Úusingry   Úcol_suffixesrC   Ú	opclassesr<  ÚincludeÚexpressionsc                   s¼   |pg }|pg }t |dd�jˆjd�}ˆj|||d�}dd„ |D ƒ}|pLˆj}|jj}‡ ‡fdd„}t|t|ˆj	ƒt
||||ƒ||r”ˆ ||||	¡nt|||ˆ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_colsrZ   )ry   c                 S   s   g | ]
}|j ‘qS r   ©rp   rW   r   r   r   rX   ™  rY   z>BaseDatabaseSchemaEditor._create_index_sql.<locals>.<listcomp>c                     s"   ˆ d u rˆj | i |¤Ž‰ ˆ ˆ ¡S r$   )r  rT   ©ÚargsÚkwargs©r   r8   r   r   Úcreate_index_name�  s    zEBaseDatabaseSchemaEditor._create_index_sql.<locals>.create_index_name)rd   r   r@  rÞ   rE   r<  rC  )r   Úget_compilerr2   r;  Úsql_create_indexr   rn   r   r	   rT   r   Ú_index_columnsr   rP   r=  r?  )r8   r"   r|   r   rÍ   r@  ry   rA  rC   rB  r<  rC  rD  Úcompilerrz   rÞ   rM  rd   rK  r   rJ  r   rÏ   |  s0    ÿÿ

ÿ
ôz*BaseDatabaseSchemaEditor._create_index_sqlc                 C   s&   t |p
| jt|jj| jƒ|  |¡d�S ©N)rd   r   )r   rÎ   r	   r   rn   rT   )r8   r"   r   rC   r   r   r   r  ²  s
    ýz*BaseDatabaseSchemaEditor._delete_index_sqlc                 C   s*   t | jt|jj| jƒ|  |¡|  |¡d�S )N)rd   Úold_nameÚnew_name)r   Úsql_rename_indexr	   r   rn   rT   )r8   r"   rQ  rR  r   r   r   r½   ¹  s    üz*BaseDatabaseSchemaEditor._rename_index_sqlc                 C   s   t ||| j|d�S )N)rA  )r   rT   )r8   rd   rÞ   rA  rB  r   r   r   rN  Á  s    z'BaseDatabaseSchemaEditor._index_columnsc                    sª   ˆ j jrˆ j jsˆ j jrg S g }ˆ j jD ]}| |  ˆ |¡¡ q(ˆ j jD ],}‡ fdd„|D ƒ}| | j	ˆ |dd�¡ qHˆ j j
D ]&}|jr’| jjjr~| | ˆ | ¡¡ q~|S )zŠ
        Return a list of all index SQL statements (field indexes,
        index_together, Meta.indexes) for the specified model.
        c                    s   g | ]}ˆ j  |¡‘qS r   rU   rW   r!   r   r   rX   Ð  rY   z?BaseDatabaseSchemaEditor._model_indexes_sql.<locals>.<listcomp>rË   rÌ   )r   ZmanagedÚproxyZswappedrg   rl   rô   Zindex_togetherrM   rÏ   rÖ   rµ   r2   r5   r¶   r·   )r8   r"   Úoutputr   r{   r|   r¹   r   r!   r   r©   Ä  s    ÿþz+BaseDatabaseSchemaEditor._model_indexes_sqlc                 C   s*   g }|   ||¡r&| | j||gd�¡ |S )zT
        Return a list of all index SQL statements for the specified field.
        r  )Ú_field_should_be_indexedrM   rÏ   )r8   r"   r   rU  r   r   r   rô   Û  s    z+BaseDatabaseSchemaEditor._field_indexes_sqlc                 C   s’   |pt ƒ }| ¡ \}}}}| ¡ \}}}	}
| |j¡D ]}| |d ¡ q6| |j¡D ]}|
 |d ¡ qT|  |j¡|  |j¡kp�|||f||	|
fkS r$   )r  ZdeconstructÚunionZnon_db_attrsÚpoprT   rp   )r8   r)   r+   r
  r÷   Úold_pathZold_argsZ
old_kwargsÚnew_pathÚnew_argsZ
new_kwargsÚattrr   r   r   r  ä  s    
ÿþz1BaseDatabaseSchemaEditor._field_should_be_alteredc                 C   s   |j o|j S r$   )r  r�   ©r8   r"   r   r   r   r   rV  õ  s    z1BaseDatabaseSchemaEditor._field_should_be_indexedc                 C   s   |j  o|j S r$   ©r   ©r8   r)   r+   r   r   r   r  ø  s    z2BaseDatabaseSchemaEditor._field_became_primary_keyc                 C   s   |j  o|jo|j p|j S r$   )r   r�   r_  r   r   r   r  û  s
    ÿýz0BaseDatabaseSchemaEditor._unique_should_be_addedc                 C   s*   | j |  |¡|  |j¡|  |j¡|dœ S )N)rd   Z
old_columnZ
new_columnr–   )Úsql_rename_columnrT   rp   )r8   rd   r)   r+   r  r   r   r   r    s    

üz*BaseDatabaseSchemaEditor._rename_field_sqlc           
   	   C   sˆ   t |jj| jƒ}|  |||¡}t|jj|jg| jƒ}t |jjjj| jƒ}t|jjjj|jjg| jƒ}| j	j
 ¡ }	t| j||||||	d�S )N)rd   r   rp   r]   r^   ré   )r	   r   rn   rT   rï   r   rp   Útarget_fieldr"   r2   rS   rð   r   Úsql_create_fk)
r8   r"   r   rÍ   rd   r   rp   r]   r^   ré   r   r   r   rs   
  s&    
ýùz'BaseDatabaseSchemaEditor._create_fk_sqlc                    s<   ‡ fdd„}t |jj|jgt|jjjjƒd |jjg||ƒS )Nc                     s   ˆ   ˆ j| i |¤Ž¡S r$   ©rT   r  rG  r=   r   r   Úcreate_fk_name   s    zDBaseDatabaseSchemaEditor._fk_constraint_name.<locals>.create_fk_namerÕ   )r   r   rn   rp   r   ra  r"   )r8   r"   r   rÍ   rd  r   r=   r   rï     s    úz,BaseDatabaseSchemaEditor._fk_constraint_namec                 C   s   |   | j||¡S r$   )rÛ   Úsql_delete_fk©r8   r"   r   r   r   r   rü   ,  s    z'BaseDatabaseSchemaEditor._delete_fk_sqlc                 C   s,   |d u rdS |t jkrdS |t jkr(dS d S )NrG   z DEFERRABLE INITIALLY DEFERREDz DEFERRABLE INITIALLY IMMEDIATE)r   ZDEFERREDZ	IMMEDIATE)r8   ré   r   r   r   Ú_deferrable_constraint_sql/  s    

z3BaseDatabaseSchemaEditor._deferrable_constraint_sqlc	              	      sŽ   |rˆ j jjsd S |s"|s"|s"|rNˆ j|||||||d�}	|	rJˆ j |	¡ d S ˆ jd ‡ fdd„|D ƒ¡ˆ  |¡dœ }
ˆ j	ˆ  
|¡|
dœ S )N)r   r<  rC  rB  rD  rc   c                    s   g | ]}ˆ   |j¡‘qS r   )rT   rp   rW   r=   r   r   rX   W  rY   z8BaseDatabaseSchemaEditor._unique_sql.<locals>.<listcomp>)rÞ   ré   ©r   ra   )r2   r5   Ú&supports_deferrable_unique_constraintsrf   r:   rM   Úsql_unique_constraintrx   rg  Úsql_constraintrT   )r8   r"   r|   r   r<  ré   rC  rB  rD  rC   ra   r   r=   r   Ú_unique_sql7  s4    ÿþù	þþz$BaseDatabaseSchemaEditor._unique_sqlc	                 C   s  |r| j jjr8|r| j jjr8|r*| j jjr8|r<| j jjs<d S t|dd�j| j d�}	|jj	}
dd„ |D ƒ}|d u r‚| j
|
|dd�}n
|  |¡}|sœ|sœ|sœ|r¤| j}n| j}|rÂ| j|
|d|d	�}nt|
||	| jƒ}t|t|
| jƒ|||  |¡|  |¡|  ||¡d
�S )NFrE  rZ   c                 S   s   g | ]
}|j ‘qS r   rF  rW   r   r   r   rX   {  rY   z?BaseDatabaseSchemaEditor._create_unique_sql.<locals>.<listcomp>TrÓ   r   )rA  rB  )rd   r   rÞ   r<  ré   rC  )r2   r5   ri  Úsupports_partial_indexesr>  r¶   r   rL  r   rn   rØ   rT   Úsql_create_unique_indexÚsql_create_uniquerN  r   rP   r   r	   r=  rg  r?  )r8   r"   r|   r   r<  ré   rC  rB  rD  rO  rd   rÞ   rC   r   r   r   rf   _  sT    þýûûúúøøÿ
ÿ

ùz+BaseDatabaseSchemaEditor._create_unique_sqlc                    s&   |r‡ fdd„}nˆ j }t||d|ƒS )Nc                     s   ˆ   ˆ j| i |¤Ž¡S r$   rc  rG  r=   r   r   Úcreate_unique_name—  s    zLBaseDatabaseSchemaEditor._unique_constraint_name.<locals>.create_unique_nameÚ_uniq)r  r   )r8   rd   rÞ   rÔ   rp  r   r=   r   rØ   ”  s    z0BaseDatabaseSchemaEditor._unique_constraint_namec           	      C   sh   |r| j jjr8|r| j jjr8|r*| j jjr8|r<| j jjs<d S |sL|sL|sL|rT| j}n| j}|  |||¡S r$   )	r2   r5   ri  rm  r>  r¶   rÎ   rÇ   rÛ   )	r8   r"   r   r<  ré   rC  rB  rD  rC   r   r   r   r  Ÿ  s*    þýûûúúøøz+BaseDatabaseSchemaEditor._delete_unique_sqlc                 C   s    | j |  |¡| jd|i dœ S )Nr[   rh  )rk  rT   rj   )r8   r   r[   r   r   r   Ú
_check_sql»  s    þz#BaseDatabaseSchemaEditor._check_sqlc                 C   s$   t | jt|jj| jƒ|  |¡|d�S )N)rd   r   r[   )r   Úsql_create_checkr	   r   rn   rT   )r8   r"   r   r[   r   r   r   r  Á  s    üz*BaseDatabaseSchemaEditor._create_check_sqlc                 C   s   | j jjsd S |  | j||¡S r$   )r2   r5   Z supports_table_check_constraintsrÛ   Úsql_delete_checkrf  r   r   r   r  É  s    
z*BaseDatabaseSchemaEditor._delete_check_sqlc                 C   s    t |t|jj| jƒ|  |¡d�S rP  )r   r	   r   rn   rT   )r8   Útemplater"   r   r   r   r   rÛ   Î  s
    ýz/BaseDatabaseSchemaEditor._delete_constraint_sqlc
                    s"  |dur‡ fdd„|D ƒ}ˆ j  ¡ �$}
ˆ j j |
|jj¡}W d  ƒ n1 sN0    Y  g }| ¡ D ]¸\}}|du s€||d krd|dur–|d |kr–qd|dur¬|d |kr¬qd|durÂ|d |krÂqd|durØ|d |krØqd|durê|d	 sêqd|du�r|d
 |k�rqd|	�r||	vrd| |¡ qd|S )z@Return all constraint names matching the columns and conditions.Nc                    s@   g | ]8}ˆ j jjr.ˆ j j t|ˆ j j ¡ ƒ¡nˆ j j |¡‘qS r   )r2   r5   Ztruncates_namesÚintrospectionZidentifier_converterr   rS   r6  )r'   r   r=   r   r   rX   ã  s   þý
ÿz>BaseDatabaseSchemaEditor._constraint_names.<locals>.<listcomp>rÞ   r�   r   r¹   r[   rû   r–   )r2   rQ   rv  Zget_constraintsr   rn   ÚitemsrM   )r8   r"   r9  r�   r   r¹   rû   r[   r  rÒ   rQ   rv   Úresultr   Zinfodictr   r=   r   r×   Õ  s4    
úÿ"z*BaseDatabaseSchemaEditor._constraint_namesc                 C   sV   | j |dd�}|r6t|ƒdkr6tdt|ƒ|jjf ƒ‚|D ]}|  |  ||¡¡ q:d S )NTr^  rÕ   z0Found wrong number (%s) of PK constraints for %s)r×   rÙ   rÚ   r   rn   r>   Ú_delete_primary_key_sql)r8   r"   r  rß   r   r   r   r   r    s    þÿÿz,BaseDatabaseSchemaEditor._delete_primary_keyc              
   C   sJ   t | jt|jj| jƒ|  | j|jj|jgdd�¡t|jj|jg| jƒd�S )NZ_pkr  )rd   r   rÞ   )	r   Úsql_create_pkr	   r   rn   rT   r  rp   r   r]  r   r   r   r    s    ÿÿøz0BaseDatabaseSchemaEditor._create_primary_key_sqlc                 C   s   |   | j||¡S r$   )rÛ   Úsql_delete_pkrf  r   r   r   ry    s    z0BaseDatabaseSchemaEditor._delete_primary_key_sqlc                 C   s   |rd|   |¡ S dS )NzCOLLATE rG   )rT   )r8   r€   r!  r8  r   r   r   rƒ     s    z%BaseDatabaseSchemaEditor._collate_sqlc                 C   s*   | j |  |¡d |¡dœ }|  |¡ d S )Nú,)Z	procedureÚparam_types)Úsql_delete_procedurerT   rx   r>   )r8   Zprocedure_namer}  rC   r   r   r   Úremove_procedure!  s
    þz)BaseDatabaseSchemaEditor.remove_procedure)FT)r   )F)F)F)F)rG   )N)N)N)NNNNN)NNNNNN)T)NNNNN)NNNNNNNN)F)NN)r   )pÚ__name__Ú
__module__Ú__qualname__Ú__doc__rw   râ   ræ   r°   rñ   ró   r.  r)  r*  r-  r,  r+  rý   r`  r  rj  rj   Zsql_delete_constraintrk  rs  rt  ro  rÇ   rb  rq   rî   re  rM  rn  rS  rÎ   rz  r{  r~  rå   r/  r9   r<   r?   r>   rT   r   r•   rh   rˆ   r‰   r�   r‹   Ústaticmethodr¥   rŠ   rP   r­   r¯   rº   r¼   r¾   rÀ   rÁ   rÊ   rÐ   rÆ   rã   r§   rç   rù   r   r	  r  r  rò   r  r¨   r†   r  r  r;  r=  r?  rÏ   r  r½   rN  r©   rô   r  rV  r  r  r  rs   rï   rü   rg  rl  rf   rØ   r  rr  r  r  rÛ   r×   r  r  ry  rƒ   r  r   r   r   r   r1   K   s4  ÿÿÿÿÿÿÿ
		
S9
	
$	
"
V 
I ÷
  \
&. 
 
ò6
	
     ÷
,      ÷
5
     ø

        ö
-

r1   ) Úloggingr   r   Zdjango.confr   Z!django.db.backends.ddl_referencesr   r   r   r   r   r	   Zdjango.db.backends.utilsr
   r   r   Zdjango.db.modelsr   r   Zdjango.db.models.sqlr   Zdjango.db.transactionr   r   Zdjango.utilsr   Ú	getLoggerrI   r   r#   r-   r1   r   r   r   r   Ú<module>   s    
