3
W­E^—Ù  ã               @   sœ   d dl Z d dlmZ d dlmZmZ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 jdƒZd	d
„ Zdd„ Zdd„ ZG dd„ dƒZdS )é    N)Údatetime)ÚColumnsÚForeignKeyNameÚ	IndexNameÚ	StatementÚTable)Únames_digestÚsplit_identifier)ÚIndex)Ú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k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   ú@/tmp/pip-build-78s3knkw/Django/django/db/backends/base/schema.pyÚ_is_relevant_relation   s    r   c             C   s   | j jdddd�S )NFT)ZforwardÚreverseZinclude_hidden)Ú_metaZ_get_fields)Úmodelr   r   r   Ú_all_related_fields   s    r   c                s2   t ‡fdd„tˆjƒD ƒ‡ fdd„tˆ jƒD ƒƒS )Nc             3   s   | ]}t |ˆ ƒr|V  qd S )N)r   )Ú.0Úobj)Ú	old_fieldr   r   ú	<genexpr>'   s    z+_related_non_m2m_objects.<locals>.<genexpr>c             3   s   | ]}t |ˆ ƒr|V  qd S )N)r   )r   r   )Ú	new_fieldr   r   r   (   s    )Úzipr   r   )r   r   r   )r   r   r   Ú_related_non_m2m_objects#   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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!eZ"dZ#d•dd „Z$d!d"„ Z%d#d$„ Z&f fd%d&„Z'd'd(„ Z(d)d*„ Z)d–d+d,„Z*d-d.„ Z+d/d0„ Z,d1d2„ Z-e.d3d4„ ƒZ/d5d6„ Z0d7d8„ Z1d9d:„ Z2d;d<„ Z3d=d>„ Z4d?d@„ Z5dAdB„ Z6dCdD„ Z7dEdF„ Z8dGdH„ Z9dIdJ„ Z:dKdL„ Z;dMdN„ Z<dOdP„ Z=dQdR„ Z>d—dSdT„Z?d˜dUdV„Z@dWdX„ ZAd™dYdZ„ZBd[d\„ ZCd]d^„ ZDdšd`da„ZEd›dbdc„ZFdd_d_df df dddœdedf„ZGdœdgdh„ZHdidj„ ZIdkdl„ ZJdmdn„ ZKdodp„ ZLdqdr„ ZMdsdt„ ZNdudv„ ZOdwdx„ ZPdydz„ ZQd{d|„ ZRd�d}d~„ZSdždd€„ZTdŸd�d‚„ZUdƒd„„ ZVd…d†„ ZWd‡dˆ„ ZXd‰dŠ„ ZYd d‹dŒ„ZZd¡d�dŽ„Z[d�d�„ Z\d‘d’„ Z]f fd“d”„Z^d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)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UNIQUE (%(columns)s)z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)zBALTER 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)sNzFCREATE INDEX %(name)s ON %(table)s (%(columns)s)%(extra)s%(condition)szDCREATE UNIQUE INDEX %(name)s ON %(table)s (%(columns)s)%(condition)szDROP INDEX %(name)szGALTER TABLE %(table)s ADD CONSTRAINT %(name)s PRIMARY KEY (%(columns)s)zDROP PROCEDURE %(procedure)sFTc             C   s,   || _ || _| jrg | _| j jjo$|| _d S )N)Ú
connectionÚcollect_sqlÚcollected_sqlÚfeaturesÚcan_rollback_ddlÚatomic_migration)Úselfr!   r"   r   r   r   r   Ú__init__`   s
    z!BaseDatabaseSchemaEditor.__init__c             C   s(   g | _ | jr$t| jjƒ| _| jjƒ  | S )N)Údeferred_sqlr&   r   r!   ÚaliasÚ	__enter__)r'   r   r   r   r+   i   s
    
z"BaseDatabaseSchemaEditor.__enter__c             C   s<   |d kr"x| j D ]}| j|ƒ qW | jr8| jj|||ƒ d S )N)r)   Úexecuter&   r   Ú__exit__)r'   Úexc_typeÚ	exc_valueÚ	tracebackÚsqlr   r   r   r-   p   s
    z!BaseDatabaseSchemaEditor.__exit__c          
   C   s¾   | j  r$| jjr$| jjj r$tdƒ‚t|ƒ}tjd||||dœd� | j r˜|j	dƒrXdnd}|dk	r†| j
j|tt| j|ƒƒ | ƒ qº| j
j|| ƒ n"| jjƒ �}|j||ƒ W dQ R X 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))Úparamsr1   )Úextraú;Ú N)r"   r!   Zin_atomic_blockr$   r%   r   ÚstrÚloggerÚdebugÚendswithr#   ÚappendÚtupleÚmapÚquote_valueÚcursorr,   )r'   r1   r2   Zendingr>   r   r   r   r,   y   s    "z BaseDatabaseSchemaEditor.executec             C   s   | j jj|ƒS )N)r!   ÚopsÚ
quote_name)r'   r   r   r   r   r@   �   s    z#BaseDatabaseSchemaEditor.quote_namec                s  x6ˆ j jD ]*}‡ fdd„|D ƒ}ˆjjˆjˆ |ƒƒ q
W g }g }�xHˆ j jD �]:}ˆjˆ |ƒ\}}|dkrlqL|jˆjd�}	|	d r”|dˆj	|	  7 }|j
ˆjd�}
|
r²|d|
 7 }|j|ƒ |joÆ|j�r<|jjj j}|jjj j|jjƒj}ˆj�r|dˆjˆj|ƒˆj|ƒdœ  7 }n"ˆjjj�r<ˆjjˆjˆ |d	ƒƒ |jd
ˆj|jƒ|f ƒ |jƒ dkrLˆjjjˆ j j|jƒ}|rLˆjj|ƒ qLW ‡ ‡fdd„ˆ j jD ƒ}ˆjˆjˆ j jƒdjdd„ ||˜D ƒƒdœ }ˆ j j�r ˆjjjˆ j jƒ}|�r |d| 7 }||fS )z-Take a model and return its table definition.c                s   g | ]}ˆ j j|ƒj‘qS r   )r   Ú	get_fieldÚcolumn)r   r   )r   r   r   ú
<listcomp>˜   s    z6BaseDatabaseSchemaEditor.table_sql.<locals>.<listcomp>N)r!   Úcheckú z %s)Úto_tableÚ	to_columnz_fk_%(to_table)s_%(to_column)sz%s %sÚ	AutoFieldÚBigAutoFieldÚSmallAutoFieldc                s   g | ]}|j ˆ ˆƒ‘qS r   )Zconstraint_sql)r   Ú
constraint)r   r'   r   r   rC   Á   s    z, c             s   s   | ]}|r|V  qd S )Nr   )r   rK   r   r   r   r   Ä   s    z5BaseDatabaseSchemaEditor.table_sql.<locals>.<genexpr>)ÚtableÚ
definition)rH   rI   rJ   ) r   Zunique_togetherr)   r:   Ú_create_unique_sqlÚlocal_fieldsÚ
column_sqlÚdb_parametersr!   Úsql_check_constraintZdb_type_suffixÚextendÚremote_fieldÚdb_constraintr   Údb_tablerA   Ú
field_namerB   Úsql_create_inline_fkr@   r$   Úsupports_foreign_keysÚ_create_fk_sqlÚget_internal_typer?   Úautoinc_sqlÚconstraintsÚsql_create_tableÚjoinÚdb_tablespaceÚtablespace_sql)r'   r   ÚfieldsÚcolumnsZcolumn_sqlsr2   r   rM   Zextra_paramsÚ	db_paramsZcol_type_suffixrF   rG   r\   r]   r1   ra   r   )r   r'   r   Ú	table_sql“   sR    



z"BaseDatabaseSchemaEditor.table_sqlc             C   s<  |j | jd�}|d }g }|dkr&dS |j}|o:| j|ƒ }|r�| j|ƒ}d| j|ƒ }	|dk	r�| jjjr~||	| j|ƒ 7 }n||	7 }||g7 }|j	r¬|j
 r¬| jjjr¬d}|rÆ| jjj rÆ|d7 }n|sÒ|d7 }|j
râ|d7 }n|jrð|d	7 }|j� pþ|jj}
|
�r4| jjj�r4|j�r4|d
| jjj|
dd� 7 }||fS )z‹
        Take a field and return its column definition.
        The field must already have had set_attributes_from_name() called.
        )r!   ÚtypeNz	 DEFAULT Tz NULLz	 NOT NULLz PRIMARY KEYz UNIQUEz %s)Úinline)NN)rQ   r!   ÚnullÚskip_defaultÚeffective_defaultÚ_column_default_sqlr$   Úrequires_literal_defaultsÚprepare_defaultÚempty_strings_allowedr   Ú!interprets_empty_strings_as_nullsZimplied_column_nullÚuniquer`   r   Zsupports_tablespacesr?   ra   )r'   r   r   Úinclude_defaultrd   r1   r2   rh   Údefault_valueZcolumn_defaultZ
tablespacer   r   r   rP   Î   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   )r'   r   r   r   r   ri   ÿ   s    z%BaseDatabaseSchemaEditor.skip_defaultc             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)r'   Úvaluer   r   r   rm     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.
        z%sr   )r'   r   r   r   r   rk     s    z,BaseDatabaseSchemaEditor._column_default_sqlc             C   s¨   | j ƒ r| jƒ }n’| j rB| jrB| jrB| jƒ dkr:tƒ }q¤tƒ }nbt| ddƒsZt| ddƒr t	j
ƒ }| jƒ }|dkr||jƒ }q¤|dkrŽ|jƒ }q¤|dkr¤tj
ƒ }nd }|S )NZBinaryFieldZauto_nowFZauto_now_addZ	DateFieldZ	TimeFieldZDateTimeField)Úhas_defaultÚget_defaultrh   Zblankrn   r[   Úbytesr6   Úgetattrr   ÚnowÚdateÚtimer   )r   ÚdefaultZinternal_typer   r   r   Ú_effective_default  s"    



z+BaseDatabaseSchemaEditor._effective_defaultc             C   s   |j | j|ƒ| jƒS )z2Return a field's effective database default value.)Zget_db_prep_saver}   r!   )r'   r   r   r   r   rj   -  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).
        N)rs   )r'   rt   r   r   r   r=   1  s    z$BaseDatabaseSchemaEditor.quote_valuec             C   s`   | j |ƒ\}}| j||pdƒ | jj| j|ƒƒ x*|jjD ]}|jjjj	r:| j
|jjƒ q:W dS )zr
        Create a table and any accompanying indexes or unique constraints for
        the given `model`.
        N)re   r,   r)   rS   Ú_model_indexes_sqlr   Úlocal_many_to_manyrT   ÚthroughÚauto_createdÚcreate_model)r'   r   r1   r2   r   r   r   r   r‚   =  s    z%BaseDatabaseSchemaEditor.create_modelc             C   s†   x*|j jD ]}|jjj jr
| j|jjƒ q
W | j| jd| j|j j	ƒi ƒ x6t
| jƒD ](}t|tƒrV|j|j j	ƒrV| jj|ƒ qVW dS )z!Delete a model from the database.rL   N)r   r   rT   r€   r�   Údelete_modelr,   Úsql_delete_tabler@   rV   Úlistr)   Ú
isinstancer   Zreferences_tableÚremove)r'   r   r   r1   r   r   r   rƒ   N  s    z%BaseDatabaseSchemaEditor.delete_modelc             C   s   | j |j|| ƒdd� dS )zAdd an index on a model.N)r2   )r,   Ú
create_sql)r'   r   Úindexr   r   r   Ú	add_index^  s    z"BaseDatabaseSchemaEditor.add_indexc             C   s   | j |j|| ƒƒ dS )zRemove an index from a model.N)r,   Ú
remove_sql)r'   r   r‰   r   r   r   Úremove_indexb  s    z%BaseDatabaseSchemaEditor.remove_indexc             C   s   |j || ƒ}|r| j|ƒ dS )zAdd a constraint to a model.N)rˆ   r,   )r'   r   rK   r1   r   r   r   Úadd_constraintf  s    z'BaseDatabaseSchemaEditor.add_constraintc             C   s   |j || ƒ}|r| j|ƒ dS )z!Remove a constraint from a model.N)r‹   r,   )r'   r   rK   r1   r   r   r   Úremove_constraintl  s    z*BaseDatabaseSchemaEditor.remove_constraintc                s‚   dd„ |D ƒ}dd„ |D ƒ}x(|j |ƒD ]}| jˆ |ddi| jƒ q(W x6|j |ƒD ](}‡ fdd„|D ƒ}| j| jˆ |ƒƒ qRW d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   )r;   )r   rb   r   r   r   ú	<setcomp>x  s    zABaseDatabaseSchemaEditor.alter_unique_together.<locals>.<setcomp>c             S   s   h | ]}t |ƒ’qS r   )r;   )r   rb   r   r   r   r�   y  s    rp   Tc                s   g | ]}ˆ j j|ƒj‘qS r   )r   rA   rB   )r   r   )r   r   r   rC     s    zBBaseDatabaseSchemaEditor.alter_unique_together.<locals>.<listcomp>N)Ú
differenceÚ_delete_composed_indexÚsql_delete_uniquer,   rN   )r'   r   Zold_unique_togetherZnew_unique_togetherÚoldsÚnewsrb   rc   r   )r   r   Úalter_unique_togetherr  s    z.BaseDatabaseSchemaEditor.alter_unique_togetherc                s†   dd„ |D ƒ}dd„ |D ƒ}x(|j |ƒD ]}| jˆ |ddi| jƒ q(W x:|j |ƒD ],}‡ fdd„|D ƒ}| j| jˆ |dd	�ƒ qRW d
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   rb   r   r   r   r�   ˆ  s    z@BaseDatabaseSchemaEditor.alter_index_together.<locals>.<setcomp>c             S   s   h | ]}t |ƒ’qS r   )r;   )r   rb   r   r   r   r�   ‰  s    r‰   Tc                s   g | ]}ˆ j j|ƒ‘qS r   )r   rA   )r   r   )r   r   r   rC   �  s    zABaseDatabaseSchemaEditor.alter_index_together.<locals>.<listcomp>Ú_idx)ÚsuffixN)r�   r‘   Úsql_delete_indexr,   Ú_create_index_sql)r'   r   Zold_index_togetherZnew_index_togetherr“   r”   rb   Úfield_namesr   )r   r   Úalter_index_together‚  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|—Ž}t|ƒdkr~tdt|ƒˆ j jd	j|ƒf ƒ‚| j| j	|ˆ |d
 ƒƒ d S )Nc             S   s   h | ]
}|j ’qS r   )r   )r   rK   r   r   r   r�   “  s    zBBaseDatabaseSchemaEditor._delete_composed_index.<locals>.<setcomp>c             S   s   h | ]
}|j ’qS r   )r   )r   rK   r   r   r   r�   ”  s    c                s   g | ]}ˆ j j|ƒj‘qS r   )r   rA   rB   )r   r   )r   r   r   rC   •  s    zCBaseDatabaseSchemaEditor._delete_composed_index.<locals>.<listcomp>Úexcludeé   z1Found wrong number (%s) of constraints for %s(%s)z, r   )
r   r]   ÚindexesÚ_constraint_namesÚlenÚ
ValueErrorrV   r_   r,   Ú_delete_constraint_sql)	r'   r   rb   Zconstraint_kwargsr1   Úmeta_constraint_namesÚmeta_index_namesrc   Úconstraint_namesr   )r   r   r‘   ’  s    z/BaseDatabaseSchemaEditor._delete_composed_indexc             C   sr   ||ks"| j jjr&|jƒ |jƒ kr&dS | j| j| j|ƒ| j|ƒdœ ƒ x$| jD ]}t|t	ƒrP|j
||ƒ qPW dS )z#Rename the table a model points to.N)Z	old_tableZ	new_table)r!   r$   Zignores_table_name_caseÚlowerr,   Úsql_rename_tabler@   r)   r†   r   Zrename_table_references)r'   r   Zold_db_tableZnew_db_tabler1   r   r   r   Úalter_db_table¢  s    

z'BaseDatabaseSchemaEditor.alter_db_tablec             C   s2   | j | j| j|jjƒ| j|ƒ| j|ƒdœ ƒ dS )z)Move a model's table between tablespaces.)rL   Zold_tablespaceZnew_tablespaceN)r,   Úsql_retablespace_tabler@   r   rV   )r'   r   Zold_db_tablespaceZnew_db_tablespacer   r   r   Úalter_db_tablespace±  s    z,BaseDatabaseSchemaEditor.alter_db_tablespacec          	   C   sÀ  |j r |jjjjr | j|jjƒS | j||dd�\}}|dkr@dS |j| jd�}|d rh|d| j	|  7 }|jo|| jj
jo||j�rd}| jrò|jjjj}|jjjj|jjƒj}|d| j| j|||ƒ| j|jƒ| j|ƒ| j|ƒ| jjjƒ dœ  7 }n| jj| j|||ƒƒ | j| j|jjƒ| j|jƒ|d	œ }	| j|	|ƒ | j|ƒ �r’| j|ƒdk	�r’| j|d|dd
�\}
}| j| j|jjƒ|
dœ }	| j|	|ƒ | jj | j!||ƒƒ | jj
j"�r¼| j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)rq   N)r!   rD   rE   z_fk_%(to_table)s_%(to_column)s)r   rB   rF   rG   Ú
deferrable)rL   rB   rM   )Údrop)rL   Úchanges)$r   rT   r€   r   r�   r‚   rP   rQ   r!   rR   r$   rY   rU   Úsql_create_column_inline_fkr   rV   rA   rW   rB   Ú_fk_constraint_namer@   r?   Údeferrable_sqlr)   r:   rZ   Úsql_create_columnr,   ri   rj   Ú_alter_column_default_sqlÚsql_alter_columnrS   Ú_field_indexes_sqlÚconnection_persists_old_columnsÚclose)r'   r   r   rM   r2   rd   Zconstraint_suffixrF   rG   r1   Úchanges_sqlr   r   r   Ú	add_field¹  sD    



z"BaseDatabaseSchemaEditor.add_fieldc             C   sô   |j r |jjjjr | j|jjƒS |j| jd�d dkr:dS |jrt| j||j	gdd�}x|D ]}| j
| j||ƒƒ qZW | j| j|jjƒ| j|j	ƒdœ }| j
|ƒ | jjjr´| jjƒ  x:t| jƒD ],}t|tƒrÀ|j|jj|j	ƒrÀ| jj|ƒ qÀW dS )z…
        Remove a field from a model. Usually involves deleting a column,
        but for M2Ms may involve deleting a table.
        )r!   rf   NT)Úforeign_key)rL   rB   )r   rT   r€   r   r�   rƒ   rQ   r!   rŸ   rB   r,   Ú_delete_fk_sqlÚsql_delete_columnr@   rV   r$   rµ   r¶   r…   r)   r†   r   Zreferences_columnr‡   )r'   r   r   Úfk_namesÚfk_namer1   r   r   r   Úremove_fieldð  s"    



z%BaseDatabaseSchemaEditor.remove_fieldc       	   	   C   s(  |j | jd�}|d }|j | jd�}|d }|dkr>|jdksP|dkrb|jdkrbtd||f ƒ‚nª|dkrª|dkrª|jjrª|jjrª|jjjjrª|jjjjrª| j||||ƒS |dkrê|dkrê|jjrê|jjrê|jjjj rê|jjjj rêdS |dkpø|dk�rtd||f ƒ‚| j||||||||ƒ 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.
        )r!   rf   NzqCannot 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))	rQ   r!   rT   r¡   r€   r   r�   Ú_alter_many_to_manyÚ_alter_field)	r'   r   r   r   ÚstrictÚold_db_paramsÚold_typeÚnew_db_paramsÚnew_typer   r   r   Úalter_field  s2    	z$BaseDatabaseSchemaEditor.alter_fieldc	       '      C   s|  t ƒ }	|jr€|jr€| j||jgdd�}
|rRt|
ƒdkrRtdt|
ƒ|jj|jf ƒ‚x,|
D ]$}|	j	|jfƒ | j
| j||ƒƒ qXW |jo˜|j sœ| j||ƒ�rdd„ |jjD ƒ}| j||jgdd|d�}|ròt|ƒdkròtd	t|ƒ|jj|jf ƒ‚x|D ]}| j
| j||ƒƒ qøW |j�r"|j�s2|j�o8|j�o8||k}|�r–xTt||ƒD ]F\}}| j|j|jjgdd�}x"|D ]}| j
| j|j|ƒƒ �qrW �qLW |j�r|j �r|j �sº|j�rd
d„ |jjD ƒ}| j||jgdtj|d�}x |D ]}| j
| j||ƒƒ �qìW |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 ƒ‚x |D ]}| j
| j||ƒƒ �q‚W |j|jk�rú| j
| j|jj|||ƒƒ x2| jD ](}t|tƒ�rÎ|j|jj|j|jƒ �qÎW g }g }g }||k�r8| j||||ƒ\}}|j |ƒ |j!|ƒ | j"|ƒ}| j"|ƒ}|j#�o||j# �o|||k�o||dk	�o|| j$|ƒ }|�r˜|j | j%|||ƒƒ |j#|j#k�rÄ| j&|||ƒ}|�rÄ|j |ƒ |j'ƒ �oÜ|j#�oÜ|j# }|�sê|�rÐ|�sø|| }| j(j)j*�r0|�r0t+t,|Ž ƒ\}} dj-|ƒt.| g ƒfg}x4|D ],\}} | j
| j/| j0|jjƒ|dœ | ƒ �q6W |�rÐ| j
| j1| j0|jjƒ| j0|jƒddœ |gƒ x4|D ],\}} | j
| j/| j0|jjƒ|dœ | ƒ �q W |�röx|D ]\}} | j
|| ƒ �qÜW |j�r|j �r| j2||ƒ | j3||ƒ�r8| j
| j4||jgƒƒ |j �sJ|j�rp|j�rp|j �rp| j
| j5||gƒƒ g }!|�rŠ|!j!t||ƒƒ | j||ƒ�rº| j
| j6||ƒƒ |!j!t||ƒƒ x�|!D ]ˆ\}"}|jj7| j(d�}#|#d }$| j|j|"j|j|$ƒ\}}| j
| j/| j0|jjjƒ|d dœ |d ƒ x|D ]\}} | j
|| ƒ �q,W �qÀW |j�rŠ|	�sn|j �sn|j �rŠ|j�rŠ| j
| j8||dƒƒ |�rÔxB|j9jj:D ]4}%t;|%|ƒ�rœ|%jj�rœ| j
| j8|%j|%jdƒƒ �qœW |d |d k�r |d �r | j<|jj|jgdd�}| j
| j=|||d ƒƒ |�rb| j%|||dd�\}&} | j/| j0|jjƒ|&dœ }| j
|| ƒ | j(j)j>�rx| j(j?ƒ  dS )z3Perform a "physical" (non-ManyToMany) field update.T)r¹   r�   z<Found wrong number (%s) of foreign key constraints for %s.%sc             S   s   h | ]
}|j ’qS r   )r   )r   rK   r   r   r   r�   J  s    z8BaseDatabaseSchemaEditor._alter_field.<locals>.<setcomp>F)rp   r   rœ   z7Found wrong number (%s) of unique constraints for %s.%sc             S   s   h | ]
}|j ’qS r   )r   )r   r‰   r   r   r   r�   t  s    )r‰   Útype_rœ   rD   c             S   s   h | ]
}|j ’qS r   )r   )r   rK   r   r   r   r�   ‚  s    )rD   rœ   z6Found wrong number (%s) of check constraints for %s.%sNz, )rL   r­   z%s)rL   rB   r|   )r!   rf   r   z_fk_%(to_table)s_%(to_column)sZ_fkÚ_check)r—   )r¬   )@ÚsetrT   rU   rŸ   rB   r    r¡   r   rV   Úaddr,   rº   rp   Ú_field_became_primary_keyr]   Ú_delete_unique_sqlr   r   Zrelated_modelr   Údb_indexrž   r
   r—   Ú_delete_index_sqlÚ_delete_check_sqlÚ_rename_field_sqlr)   r†   r   Zrename_column_referencesÚ_alter_column_type_sqlr:   rS   rj   rh   ri   r²   Ú_alter_column_null_sqlru   r!   r$   Zsupports_combined_altersr;   r   r_   Úsumr³   r@   Úsql_update_with_defaultÚ_delete_primary_keyÚ_unique_should_be_addedrN   r™   Ú_create_primary_key_sqlrQ   rZ   r   Zrelated_objectsr   Ú_create_index_nameÚ_create_check_sqlrµ   r¶   )'r'   r   r   r   rÃ   rÅ   rÂ   rÄ   rÁ   Zfks_droppedr¼   r½   r£   r¥   Úconstraint_nameZdrop_foreign_keysZ_old_relZnew_relZrel_fk_namesr¤   Zindex_namesÚ
index_namer1   ÚactionsZnull_actionsZpost_actionsÚfragmentZother_actionsZold_defaultÚnew_defaultZneeds_database_defaultZfour_way_default_alterationr2   Zrels_to_updateZold_relZrel_db_paramsZrel_typeÚrelr·   r   r   r   rÀ   7  s*   


 $














$

z%BaseDatabaseSchemaEditor._alter_fieldc             C   s\   | j jjr|jƒ dkrdS |j| j d�}|jr4| jn| j}|| 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.
        Ú	CharFieldÚ	TextFieldN)r!   rf   )rB   rf   )rà   rá   )
r!   r$   ro   r[   rQ   rh   Úsql_alter_column_nullÚsql_alter_column_not_nullr@   rB   )r'   r   r   r   rÄ   r1   r   r   r   rÒ   +  s    

z/BaseDatabaseSchemaEditor._alter_column_null_sqlc       
      C   sz   | j |ƒ}| j|ƒ}|g}|r$g }n| jjjr<| j|ƒ}g }|j| jd�}|rT| jn| j}	|	| 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.
        )r!   rf   )rB   rf   r|   )rj   rk   r!   r$   rl   rm   rQ   Úsql_alter_column_no_defaultÚsql_alter_column_defaultr@   rB   )
r'   r   r   r   r¬   rÞ   r|   r2   rÄ   r1   r   r   r   r²   A  s    




z2BaseDatabaseSchemaEditor._alter_column_default_sqlc             C   s    | j | j|jƒ|dœ g fg 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.
        )rB   rf   )Úsql_alter_column_typer@   rB   )r'   r   r   r   rÅ   r   r   r   rÑ   `  s
    
z/BaseDatabaseSchemaEditor._alter_column_type_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 j|j jjj|jƒ ƒ|j jjj|jƒ ƒƒ dS )z*Alter M2Ms to repoint their to= endpoints.N)	rT   r€   r   rV   r¨   rÆ   rA   Zm2m_reverse_field_nameZm2m_field_name)r'   r   r   r   rÁ   r   r   r   r¿   u  s    z,BaseDatabaseSchemaEditor._alter_many_to_manyr5   c       	      C   sà   t |ƒ\}}dt|f|žddiŽ|f }| jjjƒ p6d}d|dj|ƒ|f }t|ƒ|kr\|S t|ƒ|d kr||d|d … }|t|ƒ d	 d
 }d|d|… dj|ƒd|… |f }|d dksÌ|d jƒ 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_%sÚ_é   Né   r�   r   zD%séÿÿÿÿ)r	   r   r!   r?   Zmax_name_lengthr_   r    Úisdigit)	r'   Z
table_nameÚcolumn_namesr—   rê   Zhash_suffix_partÚ
max_lengthrÛ   Zother_lengthr   r   r   rØ   Š  s     
z+BaseDatabaseSchemaEditor._create_index_namec             C   sX   |d kr:t |ƒdkr*|d jr*|d j}n|jjr:|jj}|d k	rTd| jjj|ƒ S dS )Nr�   r   rE   r5   )r    r`   r   r!   r?   ra   )r'   r   rb   r`   r   r   r   Ú_get_index_tablespace_sql§  s    z2BaseDatabaseSchemaEditor._get_index_tablespace_sql)r   r—   Úusingr`   Úcol_suffixesr1   Ú	opclassesÚ	conditionc         
      s~   ˆj |||d�}dd„ |D ƒ}|p&ˆj}|jj}‡ ‡fdd„}t|t|ˆjƒt||||ƒ|ˆj||||	ƒ||
rvd|
 ndd�S )	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, ...).
        )r`   c             S   s   g | ]
}|j ‘qS r   )rB   )r   r   r   r   r   rC   º  s    z>BaseDatabaseSchemaEditor._create_index_sql.<locals>.<listcomp>c                 s   ˆ d krˆj | |Ž‰ ˆjˆ ƒS )N)rØ   r@   )ÚargsÚkwargs)r   r'   r   r   Úcreate_index_name¾  s    zEBaseDatabaseSchemaEditor._create_index_sql.<locals>.create_index_namez WHERE r5   )rL   r   rò   rc   r3   rõ   )	rñ   Úsql_create_indexr   rV   r   r   r@   r   Ú_index_columns)r'   r   rb   r   r—   rò   r`   ró   r1   rô   rõ   ra   rc   rù   rL   rø   r   )r   r'   r   r™   ±  s    

z*BaseDatabaseSchemaEditor._create_index_sqlc             C   s&   t |p
| jt|jj| jƒ| j|ƒd�S )N)rL   r   )r   r˜   r   r   rV   r@   )r'   r   r   r1   r   r   r   rÎ   Î  s    z*BaseDatabaseSchemaEditor._delete_index_sqlc             C   s   t ||| j|d�S )N)ró   )r   r@   )r'   rL   rc   ró   rô   r   r   r   rú   Õ  s    z'BaseDatabaseSchemaEditor._index_columnsc                s¨   ˆ j j sˆ j jsˆ j jrg S g }x"ˆ j jD ]}|j| jˆ |ƒƒ q,W x8ˆ j jD ],}‡ fdd„|D ƒ}|j| j	ˆ |dd�ƒ qPW x"ˆ j j
D ]}|j|jˆ | ƒƒ qŠW |S )zŠ
        Return a list of all index SQL statements (field indexes,
        index_together, Meta.indexes) for the specified model.
        c                s   g | ]}ˆ j j|ƒ‘qS r   )r   rA   )r   r   )r   r   r   rC   ä  s    z?BaseDatabaseSchemaEditor._model_indexes_sql.<locals>.<listcomp>r–   )r—   )r   ZmanagedÚproxyZswappedrO   rS   r´   Zindex_togetherr:   r™   rž   rˆ   )r'   r   Úoutputr   rš   rb   r‰   r   )r   r   r~   Ø  s    z+BaseDatabaseSchemaEditor._model_indexes_sqlc             C   s(   g }| j ||ƒr$|j| j||gƒƒ |S )zT
        Return a list of all index SQL statements for the specified field.
        )Ú_field_should_be_indexedr:   r™   )r'   r   r   rü   r   r   r   r´   ë  s    z+BaseDatabaseSchemaEditor._field_indexes_sqlc             C   s   |j o|j S )N)rÍ   rp   )r'   r   r   r   r   r   rý   ô  s    z1BaseDatabaseSchemaEditor._field_should_be_indexedc             C   s   |j  o|j S )N)r   )r'   r   r   r   r   r   rË   ÷  s    z2BaseDatabaseSchemaEditor._field_became_primary_keyc             C   s"   |j  r|j p |jo |j o |j S )N)rp   r   )r'   r   r   r   r   r   rÖ   ú  s    z0BaseDatabaseSchemaEditor._unique_should_be_addedc             C   s*   | j | j|ƒ| j|jƒ| j|jƒ|dœ S )N)rL   Z
old_columnZ
new_columnrf   )Úsql_rename_columnr@   rB   )r'   rL   r   r   rÅ   r   r   r   rÐ   ÿ  s
    

z*BaseDatabaseSchemaEditor._rename_field_sqlc       
   	   C   sˆ   t |j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
jƒ }	t| j||||||	d�S )N)rL   r   rB   rF   rG   r«   )r   r   rV   r@   r¯   r   rB   Útarget_fieldr   r!   r?   r°   r   Úsql_create_fk)
r'   r   r   r—   rL   r   rB   rF   rG   r«   r   r   r   rZ     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 ˆ j| |ŽƒS )N)r@   rØ   )rö   r÷   )r'   r   r   Úcreate_fk_name  s    zDBaseDatabaseSchemaEditor._fk_constraint_name.<locals>.create_fk_namer�   )r   r   rV   rB   r	   rÿ   r   )r'   r   r   r—   r  r   )r'   r   r¯     s    z,BaseDatabaseSchemaEditor._fk_constraint_namec             C   s   | j | j||ƒS )N)r¢   Úsql_delete_fk)r'   r   r   r   r   r   rº   %  s    z'BaseDatabaseSchemaEditor._delete_fk_sqlc             C   s\   |r*| j ||||d�}|r&| jj|ƒ d S | jddjt| j|ƒƒi }| j| j|ƒ|dœ S )N)r   rõ   rc   z, )r   rK   )rN   r)   r:   Úsql_unique_constraintr_   r<   r@   Úsql_constraint)r'   r   rb   r   rõ   r1   rK   r   r   r   Ú_unique_sql(  s    z$BaseDatabaseSchemaEditor._unique_sqlc                s�   ‡ fdd„}t |jjˆ jƒ}|d kr8t|jj|d|ƒ}n
ˆ j|ƒ}t||ˆ jƒ}|rzˆ jjjrvt	ˆ j
|||d| d�S d S t	ˆ j|||d�S d S )Nc                 s   ˆ j ˆ j| |ŽƒS )N)r@   rØ   )rö   r÷   )r'   r   r   Úcreate_unique_name9  s    zGBaseDatabaseSchemaEditor._create_unique_sql.<locals>.create_unique_nameZ_uniqz WHERE )rL   r   rc   rõ   )rL   r   rc   )r   r   rV   r@   r   r   r!   r$   Úsupports_partial_indexesr   Úsql_create_unique_indexÚsql_create_unique)r'   r   rc   r   rõ   r  rL   r   )r'   r   rN   8  s    
&z+BaseDatabaseSchemaEditor._create_unique_sqlc             C   s2   |r"| j jjr| j| j||ƒS d S | j| j||ƒS )N)r!   r$   r  r¢   r˜   r’   )r'   r   r   rõ   r   r   r   rÌ   R  s    z+BaseDatabaseSchemaEditor._delete_unique_sqlc             C   s    | j | j|ƒ| jd|i dœ S )NrD   )r   rK   )r  r@   rR   )r'   r   rD   r   r   r   Ú
_check_sqlZ  s    z#BaseDatabaseSchemaEditor._check_sqlc             C   s$   t | jt|jj| jƒ| j|ƒ|d�S )N)rL   r   rD   )r   Úsql_create_checkr   r   rV   r@   )r'   r   r   rD   r   r   r   rÙ   `  s
    z*BaseDatabaseSchemaEditor._create_check_sqlc             C   s   | j | j||ƒS )N)r¢   Úsql_delete_check)r'   r   r   r   r   r   rÏ   h  s    z*BaseDatabaseSchemaEditor._delete_check_sqlc             C   s    t |t|jj| jƒ| j|ƒd�S )N)rL   r   )r   r   r   rV   r@   )r'   Útemplater   r   r   r   r   r¢   k  s    z/BaseDatabaseSchemaEditor._delete_constraint_sqlc
                s  |dk	r‡ fdd„|D ƒ}ˆ j jƒ �}
ˆ j jj|
|jjƒ}W dQ R X g }xÂ|jƒ D ]¶\}}|dksn||d krR|dk	r„|d |kr„qR|dk	rš|d |kršqR|dk	r°|d |kr°qR|dk	rÆ|d |krÆqR|dk	rÚ|d	  rÚqR|dk	rð|d
 |krðqR|	 pü||	krR|j|ƒ qRW |S )z@Return all constraint names matching the columns and conditions.Nc                s   g | ]}ˆ j jj|ƒ‘qS r   )r!   ÚintrospectionZidentifier_converter)r   r   )r'   r   r   rC   x  s   z>BaseDatabaseSchemaEditor._constraint_names.<locals>.<listcomp>rc   rp   r   r‰   rD   r¹   rf   )r!   r>   r  Zget_constraintsr   rV   Úitemsr:   )r'   r   rï   rp   r   r‰   r¹   rD   rÇ   rœ   r>   r]   Úresultr   Zinfodictr   )r'   r   rŸ   r  s.    
z*BaseDatabaseSchemaEditor._constraint_namesc             C   sZ   | j |dd�}|r6t|ƒdkr6tdt|ƒ|jjf ƒ‚x|D ]}| j| j||ƒƒ q<W d S )NT)r   r�   z0Found wrong number (%s) of PK constraints for %s)rŸ   r    r¡   r   rV   r,   Ú_delete_primary_key_sql)r'   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|jgdd�ƒt|jj|jg| jƒd�S )NZ_pk)r—   )rL   r   rc   )	r   Úsql_create_pkr   r   rV   r@   rØ   rB   r   )r'   r   r   r   r   r   r×   š  s    z0BaseDatabaseSchemaEditor._create_primary_key_sqlc             C   s   | j | j||ƒS )N)r¢   Úsql_delete_pk)r'   r   r   r   r   r   r  ¤  s    z0BaseDatabaseSchemaEditor._delete_primary_key_sqlc             C   s*   | j | j|ƒdj|ƒdœ }| j|ƒ d S )Nú,)Z	procedureÚparam_types)Úsql_delete_procedurer@   r_   r,   )r'   Zprocedure_namer  r1   r   r   r   Úremove_procedure§  s    z)BaseDatabaseSchemaEditor.remove_procedure)FT)F)F)F)F)r5   )N)N)N)NN)N)NNNNNNNN)F)_Ú__name__Ú
__module__Ú__qualname__Ú__doc__r^   r§   r©   r„   r±   r³   ræ   râ   rã   rå   rä   r»   rþ   rÔ   r  rR   Zsql_delete_constraintr  r  r  r	  r’   r   rX   r®   r  rù   r  r˜   r  r  r  r(   r+   r-   r,   r@   re   rP   ri   rm   rk   Ústaticmethodr}   rj   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Ö   rÐ   rZ   r¯   rº   r  rN   rÌ   r
  rÙ   rÏ   r¢   rŸ   rÕ   r×   r  r  r   r   r   r   r    ,   sÀ   
		;
1	7
*
 t




	


  



r    )Úloggingr   Z!django.db.backends.ddl_referencesr   r   r   r   r   Zdjango.db.backends.utilsr   r	   Zdjango.db.modelsr
   Zdjango.db.transactionr   r   Zdjango.utilsr   Ú	getLoggerr7   r   r   r   r    r   r   r   r   Ú<module>   s   
	