o
    Ti                    @   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   ^/var/www/html/evchargy.com/venv/lib/python3.10/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                 #   sd    t fddtjD  fddt jD }|D ]\}}||fV  t|j|jE d H  qd S )Nc                 3       | ]
}t | r|V  qd S Nr   .0obj)	old_fieldr   r   	<genexpr>8       
z+_related_non_m2m_objects.<locals>.<genexpr>c                 3   r$   r%   r&   r'   )	new_fieldr   r   r+   =   r,   )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                   @   sL  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'dd"d#Z(d$d% Z)d&d' Z*dd)d*Z+d+d, Z,d-d. Z-d/d0 Z.dd1d2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^ ZFdd_d`ZG	 ddadbZHdcdd ZIddedfZJdgdh ZKdidj ZLdkdl ZMdmdn ZNddpdqZOddrdsZPdtdu ZQdvdw ZRdddododd(dd(ddddxdydzZSdd{d|ZTd}d~ ZUdd ZVdd ZWdd ZXdddZYdd ZZdd Z[dd Z\dd Z]dd Z^dd Z_dd Z`dd Za					dddZb						dddZcdddZd					dddZedd Zfdd Zgdd Zhdd Zi								dddZjdddZkdd Zldd ZmdddZnddd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)selfr4   r5   r   r   r   r   __init__   s
   z!BaseDatabaseSchemaEditor.__init__c                 C   s(   g | _ | jrt| jj| _| j  | S r%   )deferred_sqlr9   r   r4   alias	__enter__r:   r   r   r   r>      s
   
z"BaseDatabaseSchemaEditor.__enter__c                 C   s<   |d u r| j D ]}| | q| jr| j||| d S d S r%   )r<   executer9   r   __exit__)r:   exc_type	exc_value	tracebacksqlr   r   r   rA      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 rN|	 
dr,dnd}|durD| j|tt| j| |  dS | j||  dS | j }||| W d   dS 1 sew   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))paramsrE   )extra; N)r5   r4   Zin_atomic_blockr7   r8   r   strloggerdebugrstripendswithr6   appendtuplemapquote_valuecursorr@   )r:   rE   rF   endingrS   r   r   r   r@      s.   "z BaseDatabaseSchemaEditor.executec                 C   s   | j j|S r%   )r4   ops
quote_name)r:   r   r   r   r   rV         z#BaseDatabaseSchemaEditor.quote_namec                    s   j jD ]} fdd|D }j | qg }g } j jD ]} |\}}|du r1q"|jjd}	|	d rE|dj	|	  7 }|j
jd}
|
rT|d|
 7 }|| |jr|jr|jjj j}|jjj |jjj}jr|dj||d  7 }njjjrj |d	 |d
|j|f  | dv rjj j j|j}|rj| q" 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                       g | ]} j |qS r   r   	get_fieldr(   r   r!   r   r   
<listcomp>       z6BaseDatabaseSchemaEditor.table_sql.<locals>.<listcomp>Nr4   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"   r:   r   r   r\     s    
, c                 s   s    | ]	}|rt |V  qd S r%   )rJ   rd   r   r   r   r+     s    
z5BaseDatabaseSchemaEditor.table_sql.<locals>.<genexpr>)table
definition) r   Zunique_togetherr<   rO   _create_unique_sqllocal_fields
column_sqldb_parametersr4   sql_check_constraintdb_type_suffixextendr0   db_constraintr"   db_tablerZ   
field_namecolumnsql_create_inline_fkrV   r7   supports_foreign_keys_create_fk_sqlget_internal_typerU   autoinc_sqlconstraintssql_create_tablejoindb_tablespacetablespace_sql)r:   r"   field_namesfieldsZcolumn_sqlsrF   r   ri   Zextra_params	db_paramscol_type_suffixra   rb   ry   rz   rE   r~   r   rf   r   	table_sql   s   



	

z"BaseDatabaseSchemaEditor.table_sqlc                 c   sL   |V  | d }r| |V  | jjjr |jr | |jV  |j}|o2| | o2|o1| 	| }|r[| 
|}	|	d ur[d| | }
| jjjrS|
| |	 V  n|
V  ||	 |jrh|jsh| jjjrhd}|sndV  n| jjjsvdV  |jr}dV  n|jrdV  |jp|jj}|r| jjjr|jr| jjj|ddV  d S d S d S d S )	N	collationzDEFAULT TzNOT NULLZNULLzPRIMARY KEYZUNIQUE)inline)get_collate_sqlr4   r7   supports_comments_inline
db_comment_comment_sqlnullskip_defaultskip_default_on_altereffective_default_column_default_sqlrequires_literal_defaultsprepare_defaultrO   empty_strings_allowedr   !interprets_empty_strings_as_nullsZimplied_column_nulluniquer}   r   Zsupports_tablespacesrU   r~   )r:   column_db_typerF   r"   r   field_db_paramsinclude_defaultr   r   default_valueZcolumn_defaultZ
tablespacer   r   r   _iter_column_sql!  sX   
	



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.
        r^   typeNNNr`   )rm   r4   r|   r   )r:   r"   r   r   r   r   rF   r   r   r   rl   Z  s"   z#BaseDatabaseSchemaEditor.column_sqlc                 C      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   r   u     z%BaseDatabaseSchemaEditor.skip_defaultc                 C   r   )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   |  r   z.BaseDatabaseSchemaEditor.skip_default_on_alterc                 C   s   t d)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() methodNotImplementedErrorr:   valuer   r   r   r     s   z(BaseDatabaseSchemaEditor.prepare_defaultc                 C   r   )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     r   z,BaseDatabaseSchemaEditor._column_default_sqlc                 C   s   |   r
|  }|S | js!| jr!| jr!|  dkrd}|S d}|S t| dds-t| ddrS|  }|dkr;t }|S t	 }|dkrI|
 }|S |d	krQ| }|S d }|S )
NZBinaryField    rI   Zauto_nowFZauto_now_addZDateTimeFieldZ	DateFieldZ	TimeField)has_defaultget_defaultr   blankr   rx   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   r4   r   r   r   r   r     s   z*BaseDatabaseSchemaEditor.effective_defaultc                 C   s   t  )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).
        r   r   r   r   r   rR     s   z$BaseDatabaseSchemaEditor.quote_valuec                 C   s   |  |\}}| ||pd | jjjrG|jjr!| |d|jj | jjjsG|jj	D ]}|j
rF|j| jd}|d }| j| ||||j
  q*| j| | |jjD ]}|jjjjrc| |jj qTdS )zr
        Create a table and any accompanying indexes or unique constraints for
        the given `model`.
        Nr^   r   )r   r@   r4   r7   supports_commentsr   Zdb_table_commentalter_db_table_commentr   rk   r   rm   _alter_column_comment_sqlr<   rp   _model_indexes_sqllocal_many_to_manyr0   throughauto_createdcreate_model)r:   r"   rE   rF   r   r   
field_typer   r   r   r     s0   


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r<||j j	r<| j| q(dS )z!Delete a model from the database.rh   N)r   r   r0   r   r   delete_modelr@   sql_delete_tablerV   rr   listr<   
isinstancer   Zreferences_tableremove)r:   r"   r   rE   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rF   )contains_expressionsr4   r7   supports_expression_indexesr@   
create_sqlr:   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   r4   r7   r   r@   
remove_sqlr   r   r   r   remove_index  s   z%BaseDatabaseSchemaEditor.remove_indexc                 C   sF   | j jjr| j| ||j|jd d d S | || | || d S )Nr   )r4   r7   Zcan_rename_indexr@   _rename_index_sqlr   r   r   )r:   r"   Z	old_indexZ	new_indexr   r   r   rename_index  s   

z%BaseDatabaseSchemaEditor.rename_indexc                 C   s&   | || }|r| j|dd dS dS )zAdd a constraint to a model.Nr   )r   r@   r:   r"   re   rE   r   r   r   add_constraint  s   z'BaseDatabaseSchemaEditor.add_constraintc                 C   s"   | || }|r| | dS 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 }| |  | q'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      h | ]}t |qS r   rP   r(   r   r   r   r   	<setcomp>&      zABaseDatabaseSchemaEditor.alter_unique_together.<locals>.<setcomp>c                 S   r   r   r   r   r   r   r   r   '  r   TF)r   r   c                    rX   r   rY   r[   r!   r   r   r\   2  r]   zBBaseDatabaseSchemaEditor.alter_unique_together.<locals>.<listcomp>N)
difference_delete_composed_indexsql_delete_uniquer@   rj   )r:   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
 q'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   r   r   r   r   r   r   r   r   ;  r   z@BaseDatabaseSchemaEditor.alter_index_together.<locals>.<setcomp>c                 S   r   r   r   r   r   r   r   r   <  r   TF)r   r   c                    rX   r   rY   r[   r!   r   r   r\   G  r]   zABaseDatabaseSchemaEditor.alter_index_together.<locals>.<listcomp>_idxr   suffixN)r   r   sql_delete_indexr@   _create_index_sql)r:   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 rJ|rJ| jjjrJt| j	 j j
|d	d
}	|	|v rJ|	g}t|dkr`tdt| j j
d|f | | | |d  d S )Nc                 S      h | ]}|j qS r   r   rd   r   r   r   r   K      zBBaseDatabaseSchemaEditor._delete_composed_index.<locals>.<setcomp>c                 S   r   r   r   rd   r   r   r   r   N      c                    s   g | ]	} j |jqS r   )r   rZ   rt   r[   r!   r   r   r\   O  s    zCBaseDatabaseSchemaEditor._delete_composed_index.<locals>.<listcomp>excluder   TFquote   z1Found wrong number (%s) of constraints for %s(%s)rg   r   )r   rz   indexes_constraint_namesr   r4   r7   Z*allows_multiple_constraints_on_same_fieldsrJ   _unique_constraint_namerr   len
ValueErrorr|   r@   _delete_constraint_sql)
r:   r"   r   Zconstraint_kwargsrE   meta_constraint_namesmeta_index_namescolumnsconstraint_namesdefault_namer   r!   r   r   J  sB   z/BaseDatabaseSchemaEditor._delete_composed_indexc                 C   sn   ||ks| j jjr| | krdS | | j| || |d  | jD ]}t|t	r4|
|| q'dS )z#Rename the table a model points to.N)Z	old_tableZ	new_table)r4   r7   Zignores_table_name_caselowerr@   sql_rename_tablerV   r<   r   r   Zrename_table_references)r:   r"   Zold_db_tableZnew_db_tablerE   r   r   r   alter_db_tablel  s"   

z'BaseDatabaseSchemaEditor.alter_db_tablec                 C   s.   |  | j| |jj| |pdd  d S )NrI   )rh   comment)r@   sql_alter_table_commentrV   r   rr   rR   )r:   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.)rh   Zold_tablespaceZnew_tablespaceN)r@   sql_retablespace_tablerV   r   rr   )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S | j||dd\}}|du r dS |j| jd }r0|d| 7 }|j	| jd}|d rD|d| j
|  7 }|jr| jjjr|jrd}| jr|jjjj}|jjj|jjj}	t|jj\}
}|d| j| ||||
rd| |
 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(r| j)  dS 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   Nr^   r`   r_   rc   z%s.rI   )r   	namespacert   ra   rb   
deferrable)rh   rt   ri   droprh   changesr   )*r   r0   r   r   r   r   rl   ro   r4   rm   rn   r7   rv   rq   sql_create_column_inline_fkr"   rr   rZ   rs   rt   r   _fk_constraint_namerV   rU   deferrable_sqlr<   rO   rw   sql_create_columnr@   r   r   _alter_column_default_sqlsql_alter_columnr   r   r   r   rp   _field_indexes_sqlconnection_persists_old_columnsclose)r:   r"   r   ri   rF   r   r   Zconstraint_suffixra   rb   r   _rE   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r8| j||j	gdd}|D ]}| 
| || q,| j| |jj| |j	d }| 
| | jjjrX| j  t| jD ]}t|trs||jj|j	rs| j| q]dS )z
        Remove a field from a model. Usually involves deleting a column,
        but for M2Ms may involve deleting a table.
        r^   r   NTforeign_key)rh   rt   )r   r0   r   r   r   r   rm   r4   r   rt   r@   _delete_fk_sqlsql_delete_columnrV   rr   r7   r  r  r   r<   r   r   Zreferences_columnr   )r:   r"   r   fk_namesfk_namerE   r   r   r   remove_field  s,   




z%BaseDatabaseSchemaEditor.remove_fieldc           	   
   C   s0  |  ||sdS |j| jd}|d }|j| jd}|d }|du r'|jdu s0|du r8|jdu r8td||f |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 rz|du rz|jjrz|jjrz|jjjjsz|jjjjszdS |du s|du rt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.
        Nr^   r   zqCannot alter field %s into %s - they do not properly define db_type (are you using a badly-written custom field?)zCannot alter field %s into %s - they are not compatible types (you cannot alter to or from M2M fields, or add or remove through= on M2M fields))
_field_should_be_alteredrm   r4   r0   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	  sf   



	z$BaseDatabaseSchemaEditor.alter_fieldc	           /   	   C   s  t  }	| jjjrL|jrL|jrL| j||dhdrL| j||jgdd}
|r7t	|
dkr7t
dt	|
|jj|jf |
D ]}|	|jf | | || q9|jr|jrX| ||rdd |jjD }| j||jgdd	|d
}|rt	|dkrt
dt	||jj|jf |D ]}| | || q|d}|d}| jjjo|jr|jp|jo|jo||kp||k}|rt||D ]\}}| j|j|jjgdd}|D ]}| | |j| qq|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rX|d rXdd |jjD }| j||jgd|d}|rIt	|dkrIt
dt	||jj|jf |D ]}| | || qK|j|jkr| | |jj||| | j D ]}t!|t"r|#|jj|j|j qog }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rd} |(| -||| |j*|j*kr| .|||}|r|(| |/ o|j*o|j* }#|s#|r|#s*||7 }| jjj0rF|rFt1t2| \}}$d3|t4|$g fg}|D ]\}}$| | j5| 6|jj|d |$ qH|#r| | j7| 6|jj| 6|jdd |"g |D ]\}}$| | j5| 6|jj|d |$ q{|r|D ]\}}$| ||$ q|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 ]V\}&}|jj=| jd}'|'d }(|'d})|&jj=| jd}*|*d}+| '|j|&j|j|(|+|)\}}| | j5| 6|jjj|d d |d  |D ]\}}$| ||$ qMq| jjjr~|jr~|	sp|jrp|js~|jr~| | >||d |r|%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 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   r   r   r   rd   r   r   r   r   u  r   z8BaseDatabaseSchemaEditor._alter_field.<locals>.<setcomp>F)r   r   r   z7Found wrong number (%s) of unique constraints for %s.%sr   c                 S   r   r   r   )r(   r   r   r   r   r     r   )r   type_r   r_   c                 S   r   r   r   rd   r   r   r   r     r   )r_   r   z6Found wrong number (%s) of check constraints for %s.%sr^   Nrg   r   r   )rh   rt   r   r   r   r   rc   Z_fk_checkr   r   )Csetr4   r7   rv   r0   rq   r  r   rt   r   r   r   rr   addr@   r	  r   _field_became_primary_keyrz   _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_referencesro   r   r   _alter_column_type_sqlrO   rp   r   r   r   r   _alter_column_null_sqlr   Zsupports_combined_altersrP   r.   r|   sumr   rV   sql_update_with_default_delete_primary_key_unique_should_be_addedrj   r   _create_primary_key_sqlrm   rw   _create_index_name_create_check_sqlr  r  )/r:   r"   r*   r-   r  r  r  r  r  Zfks_droppedr  r  r   r   constraint_nameold_collationnew_collationZdrop_foreign_keysZ_old_relr2   Zrel_fk_namesr   Zindex_names
index_namerE   actionsZnull_actionsZpost_actionsZold_type_suffixZnew_type_suffixfragmentother_actionsZneeds_database_defaultZold_defaultnew_defaultZfour_way_default_alterationrF   Zrels_to_updater1   Zrel_db_paramsZrel_typeZrel_collationZold_rel_db_paramsZold_rel_collationr  relr  r   r   r   r  I  s,  























z%BaseDatabaseSchemaEditor._alter_fieldc                 C   sR   | j jjr
|jr
dS |j| j d}|jr| jn| j}|| |j	|d d g f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.
        Nr^   r   )rt   r   )
r4   r7   r   r   rm   r   sql_alter_column_nullsql_alter_column_not_nullrV   rt   )r:   r"   r*   r-   r  rE   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}|r2|jr.| j}	n| 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.
        r^   r   )rt   r   r   )r   r   r4   r7   r   r   rm   r    sql_alter_column_no_default_nullsql_alter_column_no_defaultsql_alter_column_defaultrV   rt   )
r:   r"   r*   r-   r   r4  r   rF   r  rE   r   r   r   r     s,   




z2BaseDatabaseSchemaEditor._alter_column_default_sqlc                 C   s   g }|  |||jj }rd| }nd}d}	| jjjrB|jsB|j|jkr9| ||||j\}
}|
r9|	|
|f |jrB| 
|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`   rI   )rt   r   r   r   )r   r   rr   r4   r7   r   r   r   r   rO   r   sql_alter_column_typerV   rt   )r:   r"   r*   r-   r  r.  r/  r3  Zcollate_sqlZcomment_sqlrE   rF   r   r   r   r$    s6   



z/BaseDatabaseSchemaEditor._alter_column_type_sqlc                 C   s.   | j | |jj| |j| |d g fS )N)rh   rt   r   )sql_alter_column_commentrV   r   rr   rt   r   )r:   r"   r-   r  Znew_db_commentr   r   r   r     s   
z2BaseDatabaseSchemaEditor._alter_column_comment_sqlc                 C   s   |  |pdS )NrI   )rR   )r:   r   r   r   r   r     rW   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)	r0   r   r   rr   r   r  rZ   Zm2m_reverse_field_nameZm2m_field_name)r:   r"   r*   r-   r  r   r   r   r  "  s,   





z,BaseDatabaseSchemaEditor._alter_many_to_manyrI   c           	      C   s   t |\}}dt|g|R ddi|f }| jj pd}d|d||f }t||kr/|S t||d kr?|d|d  }|t| d	 d
 }d|d| d|d| |f }|d dksg|d  rod|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
   r4   rU   max_name_lengthr|   r   isdigit)	r:   
table_namecolumn_namesr   r  Zhash_suffix_part
max_lengthr0  Zother_lengthr   r   r   r+  B  s(   
z+BaseDatabaseSchemaEditor._create_index_namec                 C   sf   |d u r$t |dkr|d jr|d j}ntjrtj}n|jjr$|jj}|d ur1d| jj| S dS )Nr   r   r`   rI   )r   r}   r   ZDEFAULT_INDEX_TABLESPACEr   r4   rU   r~   )r:   r"   r   r}   r   r   r   _get_index_tablespace_sqlb  s   z2BaseDatabaseSchemaEditor._get_index_tablespace_sqlc                 C   s   |rd| S dS )Nz WHERE rI   r   )r:   	conditionr   r   r   _index_condition_sqln  s   z-BaseDatabaseSchemaEditor._index_condition_sqlc                 C   s,   |r| j jjs	dS tdt|jj|| jdS )NrI   z INCLUDE (%(columns)s))r   )r4   r7   supports_covering_indexesr   r   r   rr   rV   )r:   r"   r   r   r   r   _index_include_sqls  s   z+BaseDatabaseSchemaEditor._index_include_sql)r   r   r   usingr}   col_suffixesrE   	opclassesrI  includeexpressionsc                   s   |pg }|pg }t |ddjjd}j|||d}dd |D }|p&j}|jj} fdd}t|t|j	t
||||||rJ||||	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_colsr^   )r}   c                 S      g | ]}|j qS r   rt   r[   r   r   r   r\     r   z>BaseDatabaseSchemaEditor._create_index_sql.<locals>.<listcomp>c                     s"    d u rj | i |  S r%   )r+  rV   argskwargsr   r:   r   r   create_index_name  s   
zEBaseDatabaseSchemaEditor._create_index_sql.<locals>.create_index_name)rh   r   rM  r   rG   rI  rP  )r   get_compilerr4   rH  sql_create_indexr   rr   r   r	   rV   r   _index_columnsr   rR   rJ  rL  )r:   r"   r   r   r   rM  r}   rN  rE   rO  rI  rP  rQ  compilerr~   r   r[  rh   rY  r   rX  r   r   {  s0   


z*BaseDatabaseSchemaEditor._create_index_sqlc                 C   s&   t |p| jt|jj| j| |dS N)rh   r   )r   r   r	   r   rr   rV   )r:   r"   r   rE   r   r   r   r!    s
   z*BaseDatabaseSchemaEditor._delete_index_sqlc                 C   s*   t | jt|jj| j| || |dS )N)rh   old_namenew_name)r   sql_rename_indexr	   r   rr   rV   )r:   r"   r_  r`  r   r   r   r     s   z*BaseDatabaseSchemaEditor._rename_index_sqlc                 C   s   t ||| j|dS )N)rN  )r   rV   )r:   rh   r   rN  rO  r   r   r   r\    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 q$ j j
D ]}|jrI| jjjrR|| |  q?|S )z
        Return a list of all index SQL statements (field indexes,
        index_together, Meta.indexes) for the specified model.
        c                    rX   r   rY   r[   r!   r   r   r\     r]   z?BaseDatabaseSchemaEditor._model_indexes_sql.<locals>.<listcomp>r   r   )r   ZmanagedproxyZswappedrk   rp   r  Zindex_togetherrO   r   r   r   r4   r7   r   r   )r:   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_indexedrO   r   )r:   r"   r   rc  r   r   r   r    s   z+BaseDatabaseSchemaEditor._field_indexes_sqlc                 C   s   |pt  }| \}}}}| \}}}	}
||jD ]}||d  q||jD ]}|
|d  q*| |j| |jkpH|||f||	|
fkS r%   )r  ZdeconstructunionZnon_db_attrspoprV   rt   )r:   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   r:   r"   r   r   r   r   rd    rW   z1BaseDatabaseSchemaEditor._field_should_be_indexedc                 C   s   |j  o|j S r%   r   r:   r*   r-   r   r   r   r    rW   z2BaseDatabaseSchemaEditor._field_became_primary_keyc                 C   s   |j  o|jo|j p|j S r%   )r   r   rm  r   r   r   r)    s
   z0BaseDatabaseSchemaEditor._unique_should_be_addedc                 C   s*   | j | || |j| |j|d S )N)rh   Z
old_columnZ
new_columnr   )sql_rename_columnrV   rt   )r:   rh   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)rh   r   rt   ra   rb   r   )r	   r   rr   rV   r   r   rt   target_fieldr"   r4   rU   r   r   sql_create_fk)
r:   r"   r   r   rh   r   rt   ra   rb   r   r   r   r   rw   	  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                           j| i |S r%   rV   r+  rU  r?   r   r   create_fk_name     zDBaseDatabaseSchemaEditor._fk_constraint_name.<locals>.create_fk_namer   )r   r   rr   rt   r   ro  r"   )r:   r"   r   r   rs  r   r?   r   r     s   z,BaseDatabaseSchemaEditor._fk_constraint_namec                 C      |  | j||S r%   )r   sql_delete_fkr:   r"   r   r   r   r   r	  +     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 )NrI   z DEFERRABLE INITIALLY DEFERREDz DEFERRABLE INITIALLY IMMEDIATE)r   ZDEFERREDZ	IMMEDIATE)r:   r   r   r   r   _deferrable_constraint_sql.  s   

z3BaseDatabaseSchemaEditor._deferrable_constraint_sqlc	              	      s   |r	 j jjs	d S |s|s|s|r' j|||||||d}	|	r% j|	 d S  jd fdd|D  |d }
 j	 
||
d S )N)r   rI  rP  rO  rQ  rg   c                    s   g | ]}  |jqS r   )rV   rt   r[   r?   r   r   r\   V  r]   z8BaseDatabaseSchemaEditor._unique_sql.<locals>.<listcomp>)r   r   r   re   )r4   r7   &supports_deferrable_unique_constraintsrj   r<   rO   sql_unique_constraintr|   ry  sql_constraintrV   )r:   r"   r   r   rI  r   rP  rO  rQ  rE   re   r   r?   r   _unique_sql6  s4   	z$BaseDatabaseSchemaEditor._unique_sqlc	                 C   s  |r| j jjr|r| j jjr|r| j jjr|r| j jjsd S t|ddj| j d}	|jj	}
dd |D }|d u rA| j
|
|dd}n| |}|sN|sN|sN|rR| j}n| j}|ra| j|
|d|d	}nt|
||	| j}t|t|
| j||| || || ||d
S )NFrR  r^   c                 S   rS  r   rT  r[   r   r   r   r\   z  r   z?BaseDatabaseSchemaEditor._create_unique_sql.<locals>.<listcomp>Tr   r   )rN  rO  )rh   r   r   rI  r   rP  )r4   r7   r{  supports_partial_indexesrK  r   r   rZ  r   rr   r   rV   sql_create_unique_indexsql_create_uniquer\  r   rR   r   r	   rJ  ry  rL  )r:   r"   r   r   rI  r   rP  rO  rQ  r]  rh   r   rE   r   r   r   rj   ^  sT   


z+BaseDatabaseSchemaEditor._create_unique_sqlc                    s&   |r	 fdd}n j }t||d|S )Nc                     rq  r%   rr  rU  r?   r   r   create_unique_name  rt  zLBaseDatabaseSchemaEditor._unique_constraint_name.<locals>.create_unique_name_uniq)r+  r   )r:   rh   r   r   r  r   r?   r   r     s   z0BaseDatabaseSchemaEditor._unique_constraint_namec           	      C   sh   |r| j jjr|r| j jjr|r| j jjr|r| j jjsd S |s&|s&|s&|r*| j}n| j}| |||S r%   )	r4   r7   r{  r  rK  r   r   r   r   )	r:   r"   r   rI  r   rP  rO  rQ  rE   r   r   r   r    s*   z+BaseDatabaseSchemaEditor._delete_unique_sqlc                 C   s    | j | || jd|i d S )Nr_   rz  )r}  rV   rn   )r:   r   r_   r   r   r   
_check_sql  s   z#BaseDatabaseSchemaEditor._check_sqlc                 C   s$   t | jt|jj| j| ||dS )N)rh   r   r_   )r   sql_create_checkr	   r   rr   rV   )r:   r"   r   r_   r   r   r   r,    s   z*BaseDatabaseSchemaEditor._create_check_sqlc                 C   s   | j jjsd S | | j||S r%   )r4   r7   Z supports_table_check_constraintsr   sql_delete_checkrw  r   r   r   r"    s   
z*BaseDatabaseSchemaEditor._delete_check_sqlc                 C   s    t |t|jj| j| |dS r^  )r   r	   r   rr   rV   )r:   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 s'w   Y  g }| D ]Y\}}|du s@||d kr|durK|d |krKq2|durV|d |krVq2|dura|d |kraq2|durl|d |krlq2|duru|d	 suq2|dur|d
 |krq2|	r||	vr|| q2|S )z@Return all constraint names matching the columns and conditions.Nc                    s@   g | ]} j jjr j jt| j j n j j|qS r   )r4   r7   Ztruncates_namesintrospectionZidentifier_converterr   rU   rC  )r(   r   r?   r   r   r\     s    
z>BaseDatabaseSchemaEditor._constraint_names.<locals>.<listcomp>r   r   r   r   r_   r  r   )r4   rS   r  Zget_constraintsr   rr   itemsrO   )r:   r"   rF  r   r   r   r  r_   r  r   rS   rz   resultr   Zinfodictr   r?   r   r     s8   

z*BaseDatabaseSchemaEditor._constraint_namesc                 C   sV   | j |dd}|rt|dkrtdt||jjf |D ]}| | || qd S )NTrl  r   z0Found wrong number (%s) of PK constraints for %s)r   r   r   r   rr   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gddt|jj|jg| jdS )NZ_pkr  )rh   r   r   )	r   sql_create_pkr	   r   rr   rV   r+  rt   r   rk  r   r   r   r*    s   z0BaseDatabaseSchemaEditor._create_primary_key_sqlc                 C   ru  r%   )r   sql_delete_pkrw  r   r   r   r    rx  z0BaseDatabaseSchemaEditor._delete_primary_key_sqlc                 C   s   |r	d|  | S dS )NzCOLLATE rI   )rV   )r:   r   r.  rE  r   r   r   r     rt  z%BaseDatabaseSchemaEditor._collate_sqlc                 C   s*   | j | |d|d }| | d S )N,)Z	procedureparam_types)sql_delete_procedurerV   r|   r@   )r:   Zprocedure_namer  rE   r   r   r   remove_procedure   s
   z)BaseDatabaseSchemaEditor.remove_procedure)FT)r   )F)rI   r%   )NNNNN)NNNNNN)T)NNNNNNNNr   )p__name__
__module____qualname____doc__r{   r   r   r   r   r   r;  r6  r7  r:  r9  r8  r
  rn  r'  r|  rn   Zsql_delete_constraintr}  r  r  r  r   rp  ru   r   rv  r[  r  ra  r   r  r  r  r   r<  r;   r>   rA   r@   rV   r   r   rl   r   r   r   r   staticmethodr   r   rR   r   r   r   r   r   r   r   r   r   r   r   r   r   r  r  r  r  r%  r   r$  r   r   r  r+  rH  rJ  rL  r   r!  r   r\  r   r  r  rd  r  r)  r#  rw   r   r	  ry  r~  rj   r   r  r  r,  r"  r   r   r(  r*  r  r   r  r   r   r   r   r3   K   s6   
	
	S
9	
$	
"	V
 I
  \
&.
 
 
6
	
,

5



-
r3   ) 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   	getLoggerrK   r   r#   r/   r3   r   r   r   r   <module>   s     
