
    Hwgd                        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 j4                  d
      Zd Zd Zd Z G d d      Zy)    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                     | j                   }|j                  ry|j                  r|j                  dgk(  ry|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_key	to_fieldsname)relationaltered_fieldr   s      U/var/www/horilla/myenv/lib/python3.12/site-packages/django/db/backends/base/schema.py_is_relevant_relationr      sG    
 NNE  U__%>00    c                 |    t        | j                  j                  dddd      t        j                  d            S )NFT)forwardreverseinclude_hiddeninclude_parentsr   )key)sorted_meta_get_fieldsoperator
attrgetter)models    r   _all_related_fieldsr+   '   sB    !	 	  	
 ' r   c              #      K   t         fdt         j                        D        fdt        j                        D              }|D ]3  \  }}||f t        |j                  |j                        E d {    5 y 7 w)Nc              3   :   K   | ]  }t        |      r|  y wNr   ).0obj	old_fields     r   	<genexpr>z+_related_non_m2m_objects.<locals>.<genexpr>8   #      	
$S)4 	
   c              3   :   K   | ]  }t        |      r|  y wr.   r/   )r0   r1   	new_fields     r   r3   z+_related_non_m2m_objects.<locals>.<genexpr>=   r4   r5   )zipr+   r*   _related_non_m2m_objectsremote_field)r2   r7   related_fieldsold_relnew_rels   ``   r   r9   r9   4   s      	
*9??;	

	
*9??;	
N + 
w+    
 	
 	

	
s   A6B:B;Bc                      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'djd Z(d! Z)d" Z*dkd$Z+d% Z,d& Z-d' Z.dld(Z/d) Z0d* Z1d+ Z2d, Z3e4d-        Z5d. Z6d/ Z7d0 Z8d1 Z9d2 Z:d3 Z;d4 Z<d5 Z=d6 Z>d7 Z?d8 Z@d9 ZAd: ZBd; ZCd< ZDd= ZEd> ZFdld?ZG	 dld@ZHdA ZIdldBZJdC ZKdD ZLdE ZMdF ZNdmdHZOdndIZPdJ ZQdK ZRdddGdGdd#dd#ddddLdMZSdndNZTdO ZUdP ZVdQ ZWdR ZXdndSZYdT ZZdU Z[dV Z\dW Z]dX Z^dY Z_dZ Z`d[ Za	 	 	 	 	 dod\Zb	 	 	 	 	 	 dpd]Zcdqd^Zd	 	 	 	 	 dod_Zed` Zfda Zgdb Zhdc Zi	 	 	 	 	 	 	 	 drddZjdldeZkdf Zldg ZmdsdhZndkdiZoy)t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)sc                     || _         || _        | j                  rg | _        | j                   j                  j                  xr || _        y r.   )
connectioncollect_sqlcollected_sqlfeaturescan_rollback_ddlatomic_migration)selfrA   rB   r   s       r   __init__z!BaseDatabaseSchemaEditor.__init__   s?    $&!#D $ 8 8 I I Tfr   c                     g | _         | j                  r>t        | j                  j                        | _        | j                  j                          | S r.   )deferred_sqlrF   r   rA   alias	__enter__)rG   s    r   rL   z"BaseDatabaseSchemaEditor.__enter__   s>       !6!67DKKK!!#r   c                     |"| j                   D ]  }| j                  |        | j                  r| j                  j	                  |||       y y r.   )rJ   executerF   r   __exit__)rG   exc_type	exc_value	tracebacksqls        r   rO   z!BaseDatabaseSchemaEditor.__exit__   sM    (( "S!"  KK  9i@ !r    c           	         | j                   sA| j                  j                  r+| j                  j                  j                  st        d      t        |      }t        j                  d||||d       | j                   r|j                         j                  d      rdnd}|?| j                  j                  |t        t        | j                  |            z  |z          y| j                  j                  ||z          y| j                  j!                         5 }|j#                  ||       ddd       y# 1 sw Y   yxY w)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))paramsrS   )extra; N)rB   rA   in_atomic_blockrD   rE   r   strloggerdebugrstripendswithrC   appendtuplemapquote_valuecursorrN   )rG   rS   rV   endingrd   s        r   rN   z BaseDatabaseSchemaEditor.execute   s   
   //OO,,==,? 
 #hsFVC2P 	 	
 ::<005R3F!""))5T%5%5v!>??6I ""))#,7'') ,VsF+, , ,s   D::Ec                 L    | j                   j                  j                  |      S r.   )rA   ops
quote_name)rG   r   s     r   rh   z#BaseDatabaseSchemaEditor.quote_name   s    ""--d33r   c                    |j                   j                  D ]U  }|D cg c]  }|j                   j                  |       }}| j                  j	                  | j                  ||             W g }g }|j                   j                  D ]N  }| j                  ||      \  }}||j                  | j                        }	|	d   r|d| j                  |	z  z   z  }|j                  | j                        }
|
r|d|
z  z  }|j                  |       |j                  r|j                  r|j                  j                  j                   j                   }|j                  j                  j                   j                  |j                  j"                        j$                  }| j&                  r7|d| j&                  | j)                  |      | j)                  |      dz  z   z  }nL| j                  j*                  j,                  r,| j                  j	                  | j/                  ||d             |j	                  | j)                  |j$                        d|       |j1                         dv s| j                  j2                  j5                  |j                   j                   |j$                        }|s4| j                  j                  |       Q |j                   j6                  D cg c]  }|j9                  ||        }}| j:                  | j)                  |j                   j                         dj=                  d	 g ||D              d
z  }|j                   j>                  rC| j                  j2                  jA                  |j                   j>                        }|r|d|z   z  }||fS c c}w c c}w )z-Take a model and return its table definition.rA   check z %s)to_table	to_column_fk_%(to_table)s_%(to_column)s)	AutoFieldBigAutoFieldSmallAutoField, c              3   6   K   | ]  }|rt        |        y wr.   )r[   )r0   
constraints     r   r3   z5BaseDatabaseSchemaEditor.table_sql.<locals>.<genexpr>  s      $ J$s   )table
definition)!r&   unique_together	get_fieldrJ   r`   _create_unique_sqllocal_fields
column_sqldb_parametersrA   sql_check_constraintdb_type_suffixextendr:   db_constraintr*   db_table
field_namecolumnsql_create_inline_fkrh   rD   supports_foreign_keys_create_fk_sqlget_internal_typerg   autoinc_sqlconstraintsconstraint_sqlsql_create_tablejoindb_tablespacetablespace_sql)rG   r*   field_namesr   fieldscolumn_sqlsrV   rw   extra_params	db_paramscol_type_suffixrm   rn   r   ru   r   rS   r   s                     r   	table_sqlz"BaseDatabaseSchemaEditor.table_sql   ss    !;;66 	MK@KLuekk++E2LFL$$T%<%<UF%KL	M [[-- 2	:E'+ue'D$J!++t+GI!cD$=$=	$III
#22doo2NOeo55
MM,'!!e&9&9 --3399BB!..44::DD&&11&  ,,#(A(A$(OOH$=%)__Y%?E ) # J __--CC%%,,++!5*J  OOELL1 &&( - 
 #oo11==KK((%,, %%,,[9e2	:j $kk55
 %%eT2
 
 ##__U[[%9%9:)) $">K">+">$ '
 
 ;;$$!__00??))N s^++F{U Mp
s   "N;3O c              #   X  K   | |j                  d      x}r| j                  |       | j                  j                  j                  r)|j
                  r| j                  |j
                         |j                  }|xr* | j                  |       xr |xr | j                  |       }|rs| j                  |      }	|	`d| j                  |      z   }
| j                  j                  j                  r|
| j                  |	      z   n|
 |j                  |	       |j                  r.|j                   s"| j                  j                  j"                  rd}|sd n$| j                  j                  j$                  sd |j                   rd n|j&                  rd |j(                  xs |j*                  j(                  }|rX| j                  j                  j,                  r7|j&                  r*| j                  j.                  j1                  |d       y y y y w)	N	collationzDEFAULT TzNOT NULLNULLzPRIMARY KEYUNIQUE)inline)get_collate_sqlrA   rD   supports_comments_inline
db_comment_comment_sqlnullskip_defaultskip_default_on_altereffective_default_column_default_sqlrequires_literal_defaultsprepare_defaultr`   empty_strings_allowedr   !interprets_empty_strings_as_nullsimplied_column_nulluniquer   r&   supports_tablespacesrg   r   )rG   column_db_typerV   r*   r   field_db_paramsinclude_defaultr   r   default_valuecolumn_default
tablespaces               r   _iter_column_sqlz)BaseDatabaseSchemaEditor._iter_column_sql!  s     '++K8898##I..??##<<AQAQ##E$4$455zz  =%%e,,= ;$44U;< 	  2259M(!+d.F.Fu.M!M??++EE )4+?+?+NNN((MM-0 ''%%((JJD))==L\\N((EEKK,E,E
((==//%%44Z4MM  > s   H(H*c           
          |j                  | j                        }|d   }|yg }dj                  | j                  ||||||            |fS )z
        Return the column definition for a field. The field must already have
        had set_attributes_from_name() called.
        rj   typeNNrl   )r}   rA   r   r   )rG   r*   r   r   r   r   rV   s          r   r|   z#BaseDatabaseSchemaEditor.column_sqlZ  sn      ---I(0!HH%%"##
 
 	
r   c                      y)z
        Some backends don't accept default values for certain columns types
        (i.e. MySQL longtext and longblob).
        FrT   rG   r   s     r   r   z%BaseDatabaseSchemaEditor.skip_defaultu      
 r   c                      y)z
        Some backends don't accept default values for certain columns types
        (i.e. MySQL longtext and longblob) in the ALTER COLUMN statement.
        FrT   r   s     r   r   z.BaseDatabaseSchemaEditor.skip_default_on_alter|  r   r   c                     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rG   values     r   r   z(BaseDatabaseSchemaEditor.prepare_default  s     "P
 	
r   c                      y)z
        Return the SQL to use in a DEFAULT clause. The resulting string should
        contain a '%s' placeholder for a default value.
        %srT   r   s     r   r   z,BaseDatabaseSchemaEditor._column_default_sql  s    
 r   c                    | j                         r| j                         }|S | j                  s3| j                  r'| j                  r| j                         dk(  rd}|S d}|S t        | dd      st        | dd      rm| j                         }|dk(  rt        j                         }|S t        j                         }|dk(  r|j                         }|S |d	k(  r|j                         }|S d }|S )
NBinaryFieldr   rY   auto_nowFauto_now_addDateTimeField	DateField	TimeField)has_defaultget_defaultr   blankr   r   getattrr   nowr   datetime)r   defaultinternal_types      r   _effective_defaultz+BaseDatabaseSchemaEditor._effective_default  s     '')G$ # 0K0K&&(M9    UJ.'%QV2W!335M/",,.  #,,. K/%llnG
 	 #k1%llnG  Gr   c                 X    |j                  | j                  |      | j                        S )z2Return a field's effective database default value.)get_db_prep_saver   rA   r   s     r   r   z*BaseDatabaseSchemaEditor.effective_default  s$    %%d&=&=e&DdooVVr   c                     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   s     r   rc   z$BaseDatabaseSchemaEditor.quote_value  s     "##r   c           	      d   | j                  |      \  }}| j                  ||xs d       | j                  j                  j                  r|j
                  j                  r'| j                  |d|j
                  j                         | j                  j                  j                  st|j
                  j                  D ][  }|j                  s|j                  | j                        }|d   } | j                  | j                  ||||j                          ] | j                  j                  | j                  |             |j
                  j                   D ]R  }|j"                  j$                  j
                  j&                  s.| j)                  |j"                  j$                         T y)zr
        Create a table and any accompanying indexes or unique constraints for
        the given `model`.
        Nrj   r   )r   rN   rA   rD   supports_commentsr&   db_table_commentalter_db_table_commentr   r{   r   r}   _alter_column_comment_sqlrJ   r   _model_indexes_sqllocal_many_to_manyr:   throughauto_createdcreate_model)rG   r*   rS   rV   r   r   
field_types          r   r   z%BaseDatabaseSchemaEditor.create_model  s_   
 nnU+V 	S&.D)??##55{{++++E49U9UV??++DD"[[55 
E''*/*=*='+ +> + &5V%<
$!;; %uj%:J:J
 	  !8!8!?@ [[33 	>E!!))//<<!!%"4"4"<"<=	>r   c                 8   |j                   j                  D ]R  }|j                  j                  j                   j                  s.| j                  |j                  j                         T | j                  | j                  d| j                  |j                   j                        iz         t        | j                        D ]T  }t        |t              s|j                  |j                   j                        s:| j                  j                  |       V y)z!Delete a model from the database.rv   N)r&   r   r:   r   r   delete_modelrN   sql_delete_tablerh   r   listrJ   
isinstancer	   references_tableremove)rG   r*   r   rS   s       r   r   z%BaseDatabaseSchemaEditor.delete_model  s     [[33 	>E!!))//<<!!%"4"4"<"<=	>
 	!!)=)=>	
 ))* 	.C#y)c.B.B$$/ !!((-		.r   c                     |j                   r!| j                  j                  j                  sy| j	                  |j                  ||       d       y)zAdd an index on a model.NrV   )contains_expressionsrA   rD   supports_expression_indexesrN   
create_sqlrG   r*   indexs      r   	add_indexz"BaseDatabaseSchemaEditor.add_index  sB     &&OO,,HH 	U%%eT24@r   c                     |j                   r!| j                  j                  j                  sy| j	                  |j                  ||              y)zRemove an index from a model.N)r   rA   rD   r   rN   
remove_sqlr   s      r   remove_indexz%BaseDatabaseSchemaEditor.remove_index  s<     &&OO,,HHU%%eT23r   c                     | j                   j                  j                  r9| j                  | j	                  ||j
                  |j
                        d        y | j                  ||       | j                  ||       y )Nr   )rA   rD   can_rename_indexrN   _rename_index_sqlr   r   r   )rG   r*   	old_index	new_indexs       r   rename_indexz%BaseDatabaseSchemaEditor.rename_index  sc    ??##44LL&&uinninnM  
 eY/NN5),r   c                 T    |j                  ||       }|r| j                  |d       yy)zAdd a constraint to a model.Nr   )r   rN   rG   r*   ru   rS   s       r   add_constraintz'BaseDatabaseSchemaEditor.add_constraint  s.    ##E40 LLTL* r   c                 P    |j                  ||       }|r| j                  |       yy)z!Remove a constraint from a model.N)r   rN   r   s       r   remove_constraintz*BaseDatabaseSchemaEditor.remove_constraint  s(    ##E40LL r   c                    |D ch c]  }t        |       }}|D ch c]  }t        |       }}|j                  |      D ]#  }| j                  ||ddd| j                         % |j                  |      D ]K  }|D cg c]  }|j                  j                  |       }}| j                  | j                  ||             M yc c}w c c}w c c}w )z
        Deal with a model changing its unique_together. The input
        unique_togethers must be doubly-nested, not the single-nested
        ["foo", "bar"] format.
        TF)r   r   N)ra   
difference_delete_composed_indexsql_delete_uniquer&   ry   rN   rz   )	rG   r*   old_unique_togethernew_unique_togetherr   oldsnewsr   r   s	            r   alter_unique_togetherz.BaseDatabaseSchemaEditor.alter_unique_together   s     -@@&f@@,?@&f@@ood+ 	F''6&&		  ??40 	AK@KLuekk++E2LFLLL00?@	A A@ Ms   CC "Cc                    |D ch c]  }t        |       }}|D ch c]  }t        |       }}|j                  |      D ]#  }| j                  ||ddd| j                         % |j                  |      D ]M  }|D cg c]  }|j                  j                  |       }}| j                  | j                  ||d             O yc c}w c c}w c c}w )z
        Deal with a model changing its index_together. The input
        index_togethers must be doubly-nested, not the single-nested
        ["foo", "bar"] format.
        TF)r   r   _idxr   suffixN)ra   r   r   sql_delete_indexr&   ry   rN   _create_index_sql)	rG   r*   old_index_togethernew_index_togetherr   r  r  r   r   s	            r   alter_index_togetherz-BaseDatabaseSchemaEditor.alter_index_together5  s     -??&f??,>?&f??ood+ 	F''%0%%		  ??40 	VK@KLuekk++E2LFLLL//fV/TU	V @? Ms   C
C "Cc           
      .   |j                   j                  D ch c]  }|j                   }}|j                   j                  D ch c]  }|j                   }}|D cg c]'  }|j                   j	                  |      j
                  ) }	} | j                  ||	fd||z  i|}
|j                  d      du rZ|
rX| j                  j                  j                  r8t        | j                  |j                   j                  |	d            }||
v r|g}
t        |
      dk7  rAt        dt        |
      d|j                   j                  d	d
j!                  |	      d      | j#                  | j%                  |||
d                y c c}w c c}w c c}w )Nexcluder   TFquote   Found wrong number (z) of constraints for (rs   )r   )r&   r   r   indexesry   r   _constraint_namesr   rA   rD   *allows_multiple_constraints_on_same_fieldsr[   _unique_constraint_namer   len
ValueErrorr   rN   _delete_constraint_sql)rG   r*   r   constraint_kwargsrS   ru   meta_constraint_namesmeta_index_namesr   columnsconstraint_namesdefault_names               r   r   z/BaseDatabaseSchemaEditor._delete_composed_indexJ  s   .3kk.E.E!
 *JOO!
 !
 ?Dkk>Q>QR
JOORRDJK55;;((/66KK1411
 *,<<
  	
 !!(+t3 ((SS ,,U[[-A-A7RW,XL //$0>  A% ()KK((IIg&	  	T00e=Ma=PQR?!
 SKs   FF,Fc                 x   ||k(  sA| j                   j                  j                  r"|j                         |j                         k(  ry| j	                  | j
                  | j                  |      | j                  |      dz         | j                  D ]%  }t        |t              s|j                  ||       ' y)z#Rename the table a model points to.N)	old_table	new_table)rA   rD   ignores_table_name_caselowerrN   sql_rename_tablerh   rJ   r   r	   rename_table_references)rG   r*   old_db_tablenew_db_tablerS   s        r   alter_db_tablez'BaseDatabaseSchemaEditor.alter_db_tablel  s    <'OO$$<<""$(:(:(<<!!!__\:!__\:	
 $$ 	HC#y)++L,G	Hr   c                    | j                   ry| j                  j                  j                  rX| j	                  | j                   | j                  |j                  j                        | j                  |xs d      dz         y y y )NrY   )rv   comment)	sql_alter_table_commentrA   rD   r   rN   rh   r&   r   rc   )rG   r*   old_db_table_commentnew_db_table_comments       r   r   z/BaseDatabaseSchemaEditor.alter_db_table_comment  so    ''DOO,D,D,V,VLL,,!__U[[-A-AB#//0D0JK -W'r   c                     | j                  | j                  | j                  |j                  j                        | j                  |      | j                  |      dz         y)z)Move a model's table between tablespaces.)rv   old_tablespacenew_tablespaceN)rN   sql_retablespace_tablerh   r&   r   )rG   r*   old_db_tablespacenew_db_tablespaces       r   alter_db_tablespacez,BaseDatabaseSchemaEditor.alter_db_tablespace  sQ    '')=)=>"&//2C"D"&//2C"D	
r   c           
         |j                   rO|j                  j                  j                  j                  r%| j                  |j                  j                        S | j                  ||d      \  }}|y|j                  | j                        x}r|d| z  }|j                  | j                        }|d   r|d| j                  |z  z   z  }|j                  r| j                  j                  j                  r~|j                  rqd}| j                  r6|j                  j                  j                  j                   }|j                  j                  j                  j#                  |j                  j$                        j&                  }	t)        |j                  j                         \  }
}|d| j                  | j+                  |||      |
rd| j-                  |
      z  nd	| j-                  |j&                        | j-                  |      | j-                  |	      | j                  j.                  j1                         d
z  z   z  }n,| j2                  j5                  | j7                  |||             | j8                  | j-                  |j                  j                         | j-                  |j&                        |dz  }| j;                  ||       | j=                  |      sp| j?                  |      _| jA                  |d|d      \  }}| jB                  | j-                  |j                  j                         |dz  }| j;                  ||       |jD                  rp| j                  j                  jF                  rP| j                  j                  jH                  s0|d   } | j:                  | jK                  ||||jD                          | j2                  jM                  | jO                  ||             | j                  j                  jP                  r| j                  jS                          yy)z
        Create a field on a model. Usually involves adding a column, but may
        involve adding a table instead (for M2M fields).
        T)r   Nrj   rl   rk   ro   z%s.rY   )r   	namespacer   rm   rn   
deferrable)rv   r   rw   droprv   changesr   )*r   r:   r   r&   r   r   r|   r   rA   r}   r~   rD   r   r   sql_create_column_inline_fkr*   r   ry   r   r   r   _fk_constraint_namerh   rg   deferrable_sqlrJ   r`   r   sql_create_columnrN   r   r   _alter_column_default_sqlsql_alter_columnr   r   r   r   r   _field_indexes_sqlconnection_persists_old_columnsclose)rG   r*   r   rw   rV   r   r   constraint_suffixrm   rn   r<  _rS   changes_sqlr   s                  r   	add_fieldz"BaseDatabaseSchemaEditor.add_field  s    %"4"4"<"<"B"B"O"O$$U%7%7%?%?@@!__UE4_P
F#22doo2NN?NAo.//J''4??'C	W# 9 9I EEEJ((>>## @// --3399BB!..44::DD&&11&   00D0DE	1cD$D$D 44UECTU  "')C!C"ooell; $ 9!%!;"&//"5"5"D"D"F	H 	% 	 	
 !!((''u6GH $$__U[[%9%9:ooell3$(
 

 	S&! **51&&u-9"&"@"@tU #A #K '')=)=>&+ C LLf% ((::OO,,EE"6*JDLL//5*e.>.> 	  !8!8!FG??##CCOO!!# Dr   c                    |j                   rO|j                  j                  j                  j                  r%| j                  |j                  j                        S |j                  | j                        d   y|j                  rG| j                  ||j                  gd      }|D ]#  }| j                  | j                  ||             % | j                  | j                  |j                  j                        | j                  |j                        dz  }| j                  |       | j                  j                  j                   r| j                  j#                          t%        | j&                        D ]_  }t)        |t*              s|j-                  |j                  j                  |j                        sE| j&                  j/                  |       a y)z
        Remove a field from a model. Usually involves deleting a column,
        but for M2Ms may involve deleting a table.
        rj   r   NTforeign_key)rv   r   )r   r:   r   r&   r   r   r}   rA   r  r   rN   _delete_fk_sqlsql_delete_columnrh   r   rD   rI  rJ  r   rJ   r   r	   references_columnr   )rG   r*   r   fk_namesfk_namerS   s         r   remove_fieldz%BaseDatabaseSchemaEditor.remove_field  s}    %"4"4"<"<"B"B"O"O$$U%7%7%?%?@@$//:6BJ--eell^QU-VH# BT00@AB $$__U[[%9%9:ooell3(
 
 	S??##CCOO!!#))* 	.C#y)c.C.C$$ell/ !!((-		.r   c           
         | j                  ||      sy|j                  | j                        }|d   }|j                  | j                        }|d   }||j                  ||j                  t	        d|d|d      |||j                  j
                  r~|j                  j
                  rh|j                  j
                  j                  j                  r>|j                  j
                  j                  j                  r| j                  ||||      S |||j                  j
                  rk|j                  j
                  rU|j                  j
                  j                  j                  s+|j                  j
                  j                  j                  sy||t	        d|d|d      | j                  ||||||||       y)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.
        Nrj   r   zCannot alter field z into zT - they do not properly define db_type (are you using a badly-written custom field?)zr - they are not compatible types (you cannot alter to or from M2M fields, or add or remove through= on M2M fields))
_field_should_be_alteredr}   rA   r:   r  r   r&   r   _alter_many_to_many_alter_field)	rG   r*   r2   r7   strictold_db_paramsold_typenew_db_paramsnew_types	            r   alter_fieldz$BaseDatabaseSchemaEditor.alter_field
  s    ,,Y	B!//4??/K (!//4??/K (!7!7!?!7!7!? i)   &&..**22**2288EE**2288EE ++E9iPP &&..**22!..66<<II!..66<<II !1 .7	C  			
r   c	           	         t               }	| j                  j                  j                  r|j                  r|j
                  r| j                  ||dh      r| j                  ||j                  gd      }
|rIt        |
      dk7  r;t        dt        |
      d|j                  j                  d|j                        |
D ]?  }|	j                  |j                  f       | j                  | j                  ||             A |j                   r|j                   r| j#                  ||      r|j                  j$                  D ch c]  }|j&                   }}| j                  ||j                  gdd	|
      }|rIt        |      dk7  r;t        dt        |      d|j                  j                  d|j                        |D ]#  }| j                  | j)                  ||             % |j+                  d      }|j+                  d      }| j                  j                  j                  xrD |j,                  xr |j,                  xs |j                   xr |j                   xr ||k7  xs ||k7  }|ryt/        ||      D ]j  \  }}| j                  |j0                  |j2                  j                  gd      }|D ]-  }| j                  | j                  |j0                  |             / l |j4                  r|j                   s|j4                  r|j                   r|j                  j6                  D ch c]  }|j&                   }}| j                  ||j                  gdt8        j:                  |      }|D ]#  }| j                  | j=                  ||             % |d   |d   k7  r|d   r|j                  j$                  D ch c]  }|j&                   }}| j                  ||j                  gd|      }|rIt        |      dk7  r;t        dt        |      d|j                  j                  d|j                        |D ]#  }| j                  | j?                  ||             % |j                  |j                  k7  r| j                  | jA                  |j                  j                  |||             | jB                  D ]N  }tE        |tF              s|jI                  |j                  j                  |j                  |j                         P g }g }g }|jK                  | j                        }|jK                  | j                        }||k7  sC||k7  s>||k7  s9| j                  j                  jL                  rT|jN                  |jN                  k7  r;| jQ                  ||||||      \  } }!|jS                  |        |jU                  |!       d	}"|jV                  rj|jV                  s^| jY                  |      }#| jY                  |      }$| j[                  |      s+|#|$k7  r&|$$d}"|jS                  | j]                  |||             |jV                  |jV                  k7  r&| j_                  |||      } | r|jS                  |        |ja                         xr |jV                  xr |jV                   }%|s|r[|%s||z  }| j                  j                  jb                  r4|r2te        tg        |       \  }}&dji                  |      tk        |&g       fg}|D ]J  \  }}&| j                  | jl                  | jo                  |j                  j                        |dz  |&       L |%r| j                  | jp                  | jo                  |j                  j                        | jo                  |j                        ddz  $g       |D ]J  \  }}&| j                  | jl                  | jo                  |j                  j                        |dz  |&       L |r|D ]  \  }}&| j                  ||&        |j,                  r|j,                  s| js                  ||       | ju                  ||      r"| j                  | jw                  ||g             |j4                  r|j                   r;|j4                  r/|j                   s#| j                  | jy                  ||g             g }'|r|'jU                  t/        ||             | j#                  ||      r<| j                  | j{                  ||             |'jU                  t/        ||             |'D ]!  \  }(}|j2                  j}                  | j                        })|)d   }*|)j+                  d      }+|(j2                  j}                  | j                        },|,j+                  d      }-| jQ                  |j0                  |(j2                  |j2                  |*|-|+      \  } }!| j                  | jl                  | jo                  |j0                  j                  j                        | d   dz  | d          |!D ]  \  }}&| j                  ||&        $ | j                  j                  j                  rT|j                  rH|	s|j                  r|j
                  s.|j
                  r"| j                  | j                  ||d             |rW|'D ]R  \  }.}/|/j2                  j
                  s| j                  | j                  |/j0                  |/j2                  d             T |d   |d   k7  r]|d   rX| j                  |j                  j                  |j                  gd      }| j                  | j                  |||d                |"r_| j]                  |||d      \  }0}&| jl                  | jo                  |j                  j                        |0dz  }| j                  ||&       | j                  j                  j                  r| j                  j                          yyc c}w c c}w c c}w )z3Perform a "physical" (non-ManyToMany) field update.r   )ignoreTrP  r  r  z!) of foreign key constraints for .F)r   r   r  z) of unique constraints for r   )r   type_r  rk   )rk   r  z) of check constraints for rj   Nrs   r@  r   )rv   r   r   r   r   r   ro   _fk_checkr
  r>  )DsetrA   rD   r   r:   r   rY  r  r   r  r  r&   r   addrN   rR  r   _field_became_primary_keyr   r   _delete_unique_sqlr   r   r9   related_modelr   db_indexr  r   r
  _delete_index_sql_delete_check_sql_rename_field_sqlrJ   r   r	   rename_column_referencesr   r   r   _alter_column_type_sqlr`   r   r   r   r   rF  _alter_column_null_sqlr   supports_combined_altersra   r8   r   sumrG  rh   sql_update_with_default_delete_primary_key_unique_should_be_addedrz   r  _create_primary_key_sqlr}   r   _create_index_name_create_check_sqlrI  rJ  )1rG   r*   r2   r7   r^  r`  r]  r_  r\  fks_droppedrU  rV  ru   r   r#  constraint_nameold_collationnew_collationdrop_foreign_keys_old_relr=   rel_fk_namesr   r!  index_names
index_namerS   actionsnull_actionspost_actionsold_type_suffixnew_type_suffixfragmentother_actionsneeds_database_defaultold_defaultnew_defaultfour_way_default_alterationrV   rels_to_updater<   rel_db_paramsrel_typerel_collationold_rel_db_paramsold_rel_collationrL  relrM  s1                                                    r   r[  z%BaseDatabaseSchemaEditor._alter_fieldJ  s    eOO$$::&&''--$~ .  --	(()t . H #h-1,  H,,!((	  $ B!1!1 34T00@AB   D$B$B9i$X 38++2I2I%$.
%! %  $55!!"!-  6   #./14  ,-,,!((	  $4 NT44UOLMN &))+6%))+6OO$$:: M&&@9+@+@ ;$$9)9)9M
 h&KM],J 	  &>i%S V!'#55))GMM,@,@+At  6    , VGLL!4!4W5J5JG!TUV	V" $$''9+;+; 9>8K8KLu

LL 00!!"ll( 1 K * H
 T33E:FG	H !]7%;;g@V27++2I2I%$.
%! %  $55!!"-	  6   #./14  ,-,,!((	  $4 MT33E?KLM y///LL&&KK(()Y (( c9-00,,i.>.>	@P@P #22doo2N#22doo2N  /1-((::((I,@,@@ '+&A&Ay)X}m'#Hm NN8$. "'>>)..00;K00;K..y9;.+)-&225)YO >>Y^^+225)YOH##H-&/&;&;&= '
NN19>>1 	$ l. <'''@@W#CM2V IIcNCO<=& V))!%1E1E!F#&
  +00!%1E1E!F"&//)2B2B"C#' !M $0 KCLL--%)__U[[5I5I%J'*
  + *VS&)*   )>)>$$UF3''	9=LL00DE ##y'7'7""$$LL//yk/JK !!":9i"PQ)))Y?LL55eYGH!!":9i"PQ . 	*GW#MM774??7SM$V,H)--k:M ' ; ;t ; W 1 5 5k B&*&A&A%%!'#Hm LL%%!__W-B-B-H-H-Q-QR'{
   - *VS&)*-	*4 OO$$::&&9#9#9AXAX''LL##E96VW ( 399**LL++C,=,=syy%P !]7%;;g@V"55$$y'7'7&8 6 O LL&&uo}W?UV
 ""&"@"@y)$ #A #K '')=)=>&+ C LLf%??##CCOO!!# DW	%t  M"%s   q<q$q)c                 (   | j                   j                  j                  r|j                  ry|j	                  | j                         }|j
                  r| j                  n| j                  }|| j                  |j                        |d   dz  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.
        Nrj   r   )r   r   )
rA   rD   r   r   r}   r   sql_alter_column_nullsql_alter_column_not_nullrh   r   )rG   r*   r2   r7   r_  rS   s         r   ru  z/BaseDatabaseSchemaEditor._alter_column_null_sql  s     OO$$FF// %33t3OM >> **33  "ooi.>.>?)&1
  r   c                    | j                  |      }| j                  |      }|g}|rg }n3| j                  j                  j                  r| j                  |      }g }|j                  | j                        }|r&|j                  r| j                  }	n| j                  }	n| j                  }	|	| j                  |j                        |d   |dz  |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.
        rj   r   )r   r   r   )r   r   rA   rD   r   r   r}   r    sql_alter_column_no_default_nullsql_alter_column_no_defaultsql_alter_column_defaultrh   r   )
rG   r*   r2   r7   r?  r  r   rV   r_  rS   s
             r   rF  z2BaseDatabaseSchemaEditor._alter_column_default_sql  s     ,,Y7**95F__%%?? **;7GF!//4??/K~~;;66//C//)*:*:;%f-" 
 	
r   c                    g }| j                  |||j                  j                        x}rd| }nd}d}	| j                  j                  j
                  r|j                  sv|j                  |j                  k7  r6| j                  ||||j                        \  }
}|
r|j                  |
|f       |j                  r| j                  |j                        }	| j                  | j                  |j                        |||	dz  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.
        rl   rY   )r   r   r   r0  )r   r&   r   rA   rD   r   r   r   r   r`   r   sql_alter_column_typerh   r   )rG   r*   r2   r7   r`  r  r  r  collate_sqlcomment_sqlrS   rV   s               r   rt  z/BaseDatabaseSchemaEditor._alter_column_type_sql  s    ++=%++*>*>
 
; 
 k]+KK??##55i>T>T##y';';; #<<9h	0D0DV !((#v7##"//	0D0DE **"ooi.>.>?$!,*	 	 
 	
r   c                     | j                   | j                  |j                  j                        | j                  |j                        | j                  |      dz  g fS )N)rv   r   r0  )sql_alter_column_commentrh   r&   r   r   r   )rG   r*   r7   r`  new_db_comments        r   r   z2BaseDatabaseSchemaEditor._alter_column_comment_sql  sZ    )))=)=>//)*:*:;,,^< 
 	
r   c                 ,    | j                  |xs d      S )NrY   )rc   )rG   r0  s     r   r   z%BaseDatabaseSchemaEditor._comment_sql   s    2..r   c                    |j                   j                  j                  j                  |j                   j                  j                  j                  k7  rw| 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                                      y)z*Alter M2Ms to repoint their to= endpoints.N)	r:   r   r&   r   r.  ra  ry   m2m_reverse_field_namem2m_field_name)rG   r*   r2   r7   r\  s        r   rZ  z,BaseDatabaseSchemaEditor._alter_many_to_many#  s    ""**0099%%--33<<= &&..&&..44==&&..44== 	""** ""**00::002 ""**00::002	
 	""**""**00::9;S;S;UV""**00::9;S;S;UV		
r   rY   c                    t        |      \  }}t        |g|ddi|}| j                  j                  j	                         xs d}|ddj                  |      d|}t        |      |k  r|S t        |      |dz  kD  r|d|dz   }|t        |      z
  dz  dz
  }|d| ddj                  |      d| d|}|d	   dk(  s|d	   j                         rd
|dd z  }|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.
        length      rL     N   r  r   zD%s)r   r   rA   rg   max_name_lengthr   r  isdigit)	rG   
table_namecolumn_namesr
  rL  hash_suffix_part
max_lengthr  other_lengths	            r   r|  z+BaseDatabaseSchemaEditor._create_index_nameC  s    )4:=l=1=
 __((88:Ac
#-sxx/EGWX
z?j( :>1/0A*/B"S)9%::q@1D}%HH\"=L1

 a=C:a=#8#8#:CR0Jr   c                 P   |zt        |      dk(  r|d   j                  r|d   j                  }nMt        j                  rt        j                  }n,|j                  j                  r|j                  j                  }|(d| j
                  j                  j                  |      z   S y)Nr  r   rl   rY   )r  r   r   DEFAULT_INDEX_TABLESPACEr&   rA   rg   r   )rG   r*   r   r   s       r   _get_index_tablespace_sqlz2BaseDatabaseSchemaEditor._get_index_tablespace_sqlc  s     6{aF1I$;$; &q	 7 722 ( A A** % 9 9$,,;;MJJJr   c                     |rd|z   S y)Nz WHERE rY   rT   )rG   	conditions     r   _index_condition_sqlz-BaseDatabaseSchemaEditor._index_condition_sqlo  s    y((r   c                     |r | j                   j                  j                  syt        dt	        |j
                  j                  || j                              S )NrY   z INCLUDE (%(columns)s))r"  )rA   rD   supports_covering_indexesr	   r   r&   r   rh   )rG   r*   r"  s      r   _index_include_sqlz+BaseDatabaseSchemaEditor._index_include_sqlt  sD    doo66PP$EKK00'4??K
 	
r   )r   r   r
  usingr   col_suffixesrS   	opclassesr  includeexpressionsc                $    |xs g }|xs g }t        |d      j                   j                        } j                  |||      }|D cg c]  }|j                   }}|xs  j
                  }|j                  j                  } fd}t        |t        | j                        t        ||||      ||r j                  ||||	      nt        ||| j                        | j                  |
       j!                  ||            S c c}w )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
alias_colsrj   )r   c                  N     j                   | i |j                        S r.   )r|  rh   )argskwargsr   rG   s     r   create_index_namezEBaseDatabaseSchemaEditor._create_index_sql.<locals>.create_index_name  s.    |.t..????4((r   )rv   r   r  r"  rW   r  r  )r   get_compilerrA   r  r   sql_create_indexr&   r   r	   r
   rh   r   _index_columnsr   rc   r  r  )rG   r*   r   r   r
  r  r   r  rS   r  r  r  r  compilerr   r   r"  r  rv   r  s   `  `                r   r  z*BaseDatabaseSchemaEditor._create_index_sql|  s   * 2!'R51>> ? 
 776 8 
 .44E5<<447$"7"7$$	) t/5'63DE  ##E7L)L Xt?O?OP //	:++E7;
 	
 5s   Dc                     t        |xs | j                  t        |j                  j                  | j
                        | j                  |            S N)rv   r   )r	   r  r
   r&   r   rh   )rG   r*   r   rS   s       r   rp  z*BaseDatabaseSchemaEditor._delete_index_sql  sA    (4((,,doo>&
 	
r   c                     t        | j                  t        |j                  j                  | j
                        | j                  |      | j                  |            S )N)rv   old_namenew_name)r	   sql_rename_indexr
   r&   r   rh   )rG   r*   r  r  s       r   r   z*BaseDatabaseSchemaEditor._rename_index_sql  sH    !!,,doo>__X.__X.	
 	
r   c                 4    t        ||| j                  |      S )N)r  )r   rh   )rG   rv   r"  r  r  s        r   r  z'BaseDatabaseSchemaEditor._index_columns  s    ugt\RRr   c                    |j                   j                  r,|j                   j                  s|j                   j                  rg S g }|j                   j                  D ]#  }|j                  | j                  ||             % |j                   j                  D ]M  }|D cg c]  }|j                   j                  |       }}|j                  | j                  ||d             O |j                   j                  D ]P  }|j                  r!| j                  j                  j                  s0|j                  |j!                  ||              R |S c c}w )z
        Return a list of all index SQL statements (field indexes,
        index_together, Meta.indexes) for the specified model.
        r  r	  )r&   managedproxyswappedr{   r   rH  index_togetherry   r`   r  r  r   rA   rD   r   r   )rG   r*   outputr   r   r   r   s          r   r   z+BaseDatabaseSchemaEditor._model_indexes_sql  s!   
 {{""ekk&7&75;;;N;NI[[-- 	AEMM$11%?@	A !;;55 	WK@KLuekk++E2LFLMM$00vf0UV	W [[(( 	=E..??++GGe..ud;<	=  Ms    "Ec                 t    g }| j                  ||      r#|j                  | j                  ||g             |S )zT
        Return a list of all index SQL statements for the specified field.
        rf  )_field_should_be_indexedr`   r  )rG   r*   r   r  s       r   rH  z+BaseDatabaseSchemaEditor._field_indexes_sql  s<     ((6MM$00w0GHr   c                    |xs
 t               }|j                         \  }}}}|j                         \  }}}	}
|j                  |j                        D ]  }|j	                  |d         |j                  |j                        D ]  }|
j	                  |d         | j                  |j                        | j                  |j                        k7  xs |||f||	|
fk7  S r.   )rj  deconstructunionnon_db_attrspoprh   r   )rG   r2   r7   rc  rL  old_pathold_args
old_kwargsnew_pathnew_args
new_kwargsattrs               r   rY  z1BaseDatabaseSchemaEditor._field_should_be_altered  s    35,5,A,A,C)8Xz,5,A,A,C)8Xz LL!7!78 	'DNN4&	'LL!7!78 	'DNN4&	'y//0DOO5
 
 R*-(Hj1QQ	Rr   c                 8    |j                   xr |j                   S r.   )ro  r   rG   r*   r   s      r   r  z1BaseDatabaseSchemaEditor._field_should_be_indexed  s    ~~2ell"22r   c                 8    |j                    xr |j                   S r.   r   rG   r2   r7   s      r   rl  z2BaseDatabaseSchemaEditor._field_became_primary_key  s    (((BY-B-BBr   c                 r    |j                    xr) |j                  xr |j                   xs |j                   S r.   )r   r   r  s      r   rz  z0BaseDatabaseSchemaEditor._unique_should_be_added  s?    %%% @  @%%%>)>)>	
r   c                     | j                   | j                  |      | j                  |j                        | j                  |j                        |dz  S )N)rv   
old_column
new_columnr   )sql_rename_columnrh   r   )rG   rv   r2   r7   r`  s        r   rr  z*BaseDatabaseSchemaEditor._rename_field_sql  sM    %%__U+//)*:*:;//)*:*:;	)
 
 	
r   c           	         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                  ||||||	      S )N)rv   r   r   rm   rn   r=  )r
   r&   r   rh   rC  r   r   target_fieldr*   rA   rg   rD  r	   sql_create_fk)
rG   r*   r   r
  rv   r   r   rm   rn   r=  s
             r   r   z'BaseDatabaseSchemaEditor._create_fk_sql
  s    ekk**DOO<''uf=--~tO++1177@@$//R$$**33&&'OO
	
 __((779
!
 	
r   c                       fd}t        |j                  j                  |j                  gt	        |j
                  j                  j                  j                        d   |j
                  j                  g||      S )Nc                  F    j                   j                  | i |      S r.   rh   r|  r  r  rG   s     r   create_fk_namezDBaseDatabaseSchemaEditor._fk_constraint_name.<locals>.create_fk_name   s%    ??#:4#:#:D#KF#KLLr   r  )r   r&   r   r   r   r  r*   )rG   r*   r   r
  r  s   `    r   rC  z,BaseDatabaseSchemaEditor._fk_constraint_name  sk    	M KK  \\NU//55;;DDEaH&&'
 	
r   c                 <    | j                  | j                  ||      S r.   )r  sql_delete_fkrG   r*   r   s      r   rR  z'BaseDatabaseSchemaEditor._delete_fk_sql,      **4+=+=udKKr   c                 Z    |y|t         j                  k(  ry|t         j                  k(  ryy )NrY   z DEFERRABLE INITIALLY DEFERREDz DEFERRABLE INITIALLY IMMEDIATE)r   DEFERRED	IMMEDIATE)rG   r=  s     r   _deferrable_constraint_sqlz3BaseDatabaseSchemaEditor._deferrable_constraint_sql/  s2    ,,,3---4 .r   c	           	         |r!| j                   j                  j                  sy |s|s|s|r6| j                  |||||||      }	|	r| j                  j                  |	       y | j                  dj                  |D 
cg c]  }
| j                  |
j                         c}
      | j                  |      dz  }| j                  | j                  |      |dz  S c c}
w )N)r   r  r  r  r  rs   )r"  r=  r   ru   )rA   rD   &supports_deferrable_unique_constraintsrz   rJ   r`   sql_unique_constraintr   rh   r   r  sql_constraint)rG   r*   r   r   r  r=  r  r  r  rS   r   ru   s               r   _unique_sqlz$BaseDatabaseSchemaEditor._unique_sql7  s     OO,,SS9 ))##' * C !!((-//yyV!TE$//%,,"?!TU99*E3
 

 ""OOD)$&
 
 	
 "Us   <"C
c	                 d   |r | j                   j                  j                  rf|r | j                   j                  j                  rD|r | j                   j                  j                  r"|r!| j                   j                  j
                  sy t        |d      j                  | j                         }	|j                  j                  }
|D cg c]  }|j                   }}|| j                  |
|d      }n| j                  |      }|s|s|s|r| j                  }n| j                  }|r| j                  |
|d|      }nt!        |
||	| j"                        }t%        |t'        |
| j                        ||| j)                  |      | j+                  |      | j-                  ||            S c c}w )	NFr  rj   Tr  rT   )r  r  )rv   r   r"  r  r=  r  )rA   rD   r	  supports_partial_indexesr  r   r   r  r&   r   r   r  rh   sql_create_unique_indexsql_create_uniquer  r   rc   r	   r
   r  r  r  )rG   r*   r   r   r  r=  r  r  r  r  rv   r   r"  rS   s                 r   rz   z+BaseDatabaseSchemaEditor._create_unique_sql_  s    00WW$//":":"S"S 8 8 R RDOO$<$<$X$X 51>> ? 
 $$-34E5<<44<//wd/KD??4(D9..C((C))wR9 * G "%h@P@PQGt///	:66zB++E7;
 	
 5s   F-c                 H     |r fd}n j                   }t        ||d|      S )Nc                  F    j                   j                  | i |      S r.   r  r  s     r   create_unique_namezLBaseDatabaseSchemaEditor._unique_constraint_name.<locals>.create_unique_name  s%    '>t'>'>'O'OPPr   _uniq)r|  r   )rG   rv   r"  r  r  s   `    r   r  z0BaseDatabaseSchemaEditor._unique_constraint_name  s,    Q "&!8!82DEEr   c                 |   |r | j                   j                  j                  rf|r | j                   j                  j                  rD|r | j                   j                  j                  r"|r!| j                   j                  j
                  sy |s|s|s|r| j                  }n| j                  }| j                  |||      S r.   )	rA   rD   r	  r  r  r   r  r  r  )	rG   r*   r   r  r=  r  r  r  rS   s	            r   rm  z+BaseDatabaseSchemaEditor._delete_unique_sql  s     00WW$//":":"S"S 8 8 R RDOO$<$<$X$X 9''C((C**3t<<r   c                 b    | j                   | j                  |      | j                  d|iz  dz  S )Nrk   r  )r  rh   r~   )rG   r   rk   s      r   
_check_sqlz#BaseDatabaseSchemaEditor._check_sql  s9    ""OOD)33w6FF&
 
 	
r   c                     t        | j                  t        |j                  j                  | j
                        | j                  |      |      S )N)rv   r   rk   )r	   sql_create_checkr
   r&   r   rh   )rG   r*   r   rk   s       r   r}  z*BaseDatabaseSchemaEditor._create_check_sql  s?    !!,,doo>&	
 	
r   c                 ~    | j                   j                  j                  sy | j                  | j                  ||      S r.   )rA   rD    supports_table_check_constraintsr  sql_delete_checkr  s      r   rq  z*BaseDatabaseSchemaEditor._delete_check_sql  s3    ''HH**4+@+@%NNr   c                     t        |t        |j                  j                  | j                        | j	                  |            S r  )r	   r
   r&   r   rh   )rG   templater*   r   s       r   r  z/BaseDatabaseSchemaEditor._delete_constraint_sql  s6    ,,doo>&
 	
r   c
           
      $   ||D 
cg c]  }
| j                   j                  j                  rQ| j                   j                  j	                  t        |
| j                   j                  j                                     n$| j                   j                  j	                  |
       }}
| j                   j                         5 }| j                   j                  j                  ||j                  j                        }ddd       g }j                         D ]g  \  }
}|	||d   k(  s|	|d   |k7  r|	|d   |k7  r'|	|d   |k7  r2|	|d   |k7  r=||d   sE|	|d   |k7  rP|	r|
|	vsW|j                  |
       i |S c c}
w # 1 sw Y   xY w)	z@Return all constraint names matching the columns and conditions.Nr"  r   r   r   rk   rQ  r   )rA   rD   truncates_namesintrospectionidentifier_converterr   rg   r  rd   get_constraintsr&   r   itemsr`   )rG   r*   r  r   r   r   rQ  rk   re  r  r   rd   r   resultinfodicts                  r   r  z*BaseDatabaseSchemaEditor._constraint_names  s    # )  ??++;; --BB!$(;(;(K(K(MN __22GGM	NL  __##% 	//77GG,,K	 )//1 	(ND(#|x	7J'J%(8*<*F*x/F+/U$'):e)C$'):e)C*8M3J$&)9U)B$g"5MM$'	(  ;	 	s   BF ;FFc                     | j                  |d      }|r<t        |      dk7  r.t        dt        |      d|j                  j                        |D ]#  }| j                  | j                  ||             % y )NTr  r  r  z) of PK constraints for )r  r  r  r&   r   rN   _delete_primary_key_sql)rG   r*   r\  r#  r  s        r   ry  z,BaseDatabaseSchemaEditor._delete_primary_key  s~    11%T1Jc*+q0 ()KK((   0 	OOLL55e_MN	Or   c                 l   t        | j                  t        |j                  j                  | j
                        | j                  | j                  |j                  j                  |j                  gd            t        |j                  j                  |j                  g| j
                              S )N_pkri  )rv   r   r"  )	r	   sql_create_pkr
   r&   r   rh   r|  r   r   r  s      r   r{  z0BaseDatabaseSchemaEditor._create_primary_key_sql  s    ,,doo>''KK((5<<. ( 
 EKK005<<.$//R	
 		
r   c                 <    | j                  | j                  ||      S r.   )r  sql_delete_pkr  s      r   r(  z0BaseDatabaseSchemaEditor._delete_primary_key_sql  r  r   c                 2    |rd| j                  |      z   S dS )NzCOLLATE rY   )rh   )rG   r   r  r  s       r   r   z%BaseDatabaseSchemaEditor._collate_sql  s    :CzDOOI66KKr   c                     | j                   | j                  |      dj                  |      dz  }| j                  |       y )N,)	procedureparam_types)sql_delete_procedurerh   r   rN   )rG   procedure_namer2  rS   s       r   remove_procedurez)BaseDatabaseSchemaEditor.remove_procedure!  s=    ''888K0+
 
 	Sr   )FT)rT   )F)rY   r.   )NNNNN)NNNNNN)T)NNNNNNNNr   )p__name__
__module____qualname____doc__r   r*  r7  r   rE  rG  r  r  r  r  r  r  rS  r  rx  r
  r~   sql_delete_constraintr  r  r  r  r  r  r   rB  r   r  r  r  r  r+  r-  r3  r1  r  rH   rL   rO   rN   rh   r   r   r|   r   r   r   r   staticmethodr   r   rc   r   r   r   r   r   r   r   r  r  r   r.  r   r:  rN  rW  ra  r[  ru  rF  rt  r   r   rZ  r|  r  r  r  r  rp  r   r  r   rH  rY  r  rl  rz  rr  r   rC  rR  r  r  rz   r  rm  r  r}  rq  r  r  ry  r{  r(  r   r5  rT   r   r   r?   r?   K   s    AJV5T:PC FP"H'B$NN  	Q  A.L9NX,	-  .	@   "&)M	9 
	0  I, 	R  *M9IVUA,>4Of7Nr
6
  .W$">H.*	A4-+A*V* SDH&	
T$l.@>
R X$t
:$
L,
\	
/
@@


 4
l

S.R"3C


*
L5 &
X 3
j	F =8

O

 +ZO

LLr   r?   ) loggingr(   r   django.confr   !django.db.backends.ddl_referencesr   r   r   r   r	   r
   django.db.backends.utilsr   r   r   django.db.modelsr   r   django.db.models.sqlr   django.db.transactionr   r   django.utilsr   	getLoggerr\   r   r+   r9   r?   rT   r   r   <module>rE     s^          S R . & D !			6	71 

.[ [r   