3
W­E^ÀL  ã               @   s|   d dl Z d dlmZ d dlmZ d dlmZ d dlmZ d dl	m
Z
 d dlmZ d dlmZ d d	lmZ G d
d„ deƒZdS )é    N)ÚDecimal)ÚApps)ÚBaseDatabaseSchemaEditor)Ú	Statement)Ústrip_quotes)ÚUniqueConstraint)Úatomic)ÚNotSupportedErrorc                   s¼   e Zd ZdZdZdZdZdZ‡ fdd„Z‡ fdd	„Z	d
d„ Z
d$dd„Zd%‡ fdd„	Zd&‡ fdd„	Zd'dd„Zd(‡ fdd„	Zdd„ Zdd„ Zd)dd„Zdd„ Z‡ fd d!„Z‡ fd"d#„Z‡  ZS )*ÚDatabaseSchemaEditorzDROP TABLE %(table)sNzEREFERENCES %(to_table)s (%(to_column)s) DEFERRABLE INITIALLY DEFERREDz7CREATE UNIQUE INDEX %(name)s ON %(table)s (%(columns)s)zDROP INDEX %(name)sc                s   | j jƒ stdƒ‚tƒ jƒ S )NzüSQLite schema editor cannot be used while foreign key constraint checks are enabled. Make sure to disable them before entering a transaction.atomic() context because SQLite does not support disabling them in the middle of a multi-statement transaction.)Ú
connectionÚdisable_constraint_checkingr	   ÚsuperÚ	__enter__)Úself)Ú	__class__© úC/tmp/pip-build-78s3knkw/Django/django/db/backends/sqlite3/schema.pyr      s    
zDatabaseSchemaEditor.__enter__c                s(   | j jƒ  tƒ j|||ƒ | j jƒ  d S )N)r   Zcheck_constraintsr   Ú__exit__Úenable_constraint_checking)r   Úexc_typeÚ	exc_valueÚ	traceback)r   r   r   r   "   s    
zDatabaseSchemaEditor.__exit__c             C   sÈ   ydd l }|j|ƒ}W n( tk
r*   Y n |jk
r>   Y nX t|tƒrVtt|ƒƒS t|tt	tfƒrnt|ƒS t|tƒrˆd|j
ddƒ S |d kr”dS t|tttfƒr°d|jƒ  S td|t|ƒf ƒ‚d S )Nr   z'%s'ú'z''ZNULLzX'%s'z*Cannot quote parameter value %r of type %s)Úsqlite3ZadaptÚImportErrorZProgrammingErrorÚ
isinstanceÚboolÚstrÚintr   ÚfloatÚreplaceÚbytesÚ	bytearrayÚ
memoryviewÚhexÚ
ValueErrorÚtype)r   Úvaluer   r   r   r   Úquote_value'   s$    

z DatabaseSchemaEditor.quote_valueFc       
      C   sŽ   | j jƒ �z}xr| j jj|ƒD ]`}|r0|j|kr0q| j jj||jƒ}x8|jƒ D ],}|d \}}	||krL|dkst|	|krLdS qLW qW W dQ R X dS )a  
        Return whether or not the provided table name is referenced by another
        one. If `column_name` is specified, only references pointing to that
        column are considered. If `ignore_self` is True, self-referential
        constraints are ignored.
        Zforeign_keyNTF)r   ÚcursorZintrospectionZget_table_listÚnameZ_get_foreign_key_constraintsÚvalues)
r   Ú
table_nameZcolumn_nameÚignore_selfr)   Zother_tableÚconstraintsÚ
constraintZconstraint_tableZconstraint_columnr   r   r   Ú_is_referenced_by_fk_constraintC   s    z4DatabaseSchemaEditor._is_referenced_by_fk_constraintTc                sh   | j jj rT|rT| j|ƒrT| j jr.td| ƒ‚| j jƒ  tƒ j|||ƒ | j j	ƒ  ntƒ j|||ƒ d S )Nz°Renaming the %r table while in a transaction is not supported on SQLite < 3.26 because it would break referential integrity. Try adding `atomic = False` to the Migration class.)
r   ÚfeaturesÚ!supports_atomic_references_renamer0   Úin_atomic_blockr	   r   r   Úalter_db_tabler   )r   ÚmodelZold_db_tableZnew_db_tableÚdisable_constraints)r   r   r   r4   V   s    
z#DatabaseSchemaEditor.alter_db_tablec                sP  |j }|jj}|jƒ \}}|j |ko>| jjj o>| j||dd��r8| jjr^t	d|jj|f ƒ‚t
| jjƒ�¦ tƒ j||||d� | jjƒ �|}	|	jdƒjƒ d }
|	jdƒ d| }|jƒ d	 }|| }|| }|	jd
||fƒ |	jd|
d	  ƒ |	jdƒ |	jdƒ W d Q R X W d Q R X | jjƒ �}	|	jdƒ W d Q R X ntƒ j||||d� d S )NT)r-   z´Renaming the %r.%r column while in a transaction is not supported on SQLite < 3.26 because it would break referential integrity. Try adding `atomic = False` to the Migration class.)ÚstrictzPRAGMA schema_versionr   zPRAGMA writable_schema = 1z REFERENCES "%s" ("%%s") é   z3UPDATE sqlite_master SET sql = replace(sql, %s, %s)zPRAGMA schema_version = %dzPRAGMA writable_schema = 0zPRAGMA integrity_checkZVACUUM)r*   Ú_metaÚdb_tableZget_attname_columnr   r1   r2   r0   r3   r	   r   Úaliasr   Úalter_fieldr)   ÚexecuteZfetchone)r   r5   Ú	old_fieldÚ	new_fieldr7   Zold_field_namer,   Ú_Zold_column_namer)   Zschema_versionZreferences_templateZnew_column_nameÚsearchÚreplacement)r   r   r   r<   e   s4    


z DatabaseSchemaEditor.alter_fieldc                s^  ‡fdd„‰‡fdd„ˆj jD ƒ}‡fdd„ˆj jD ƒ}i ‰d}t|ddƒs`|ržt|d	 ddƒržx<t|jƒ ƒD ],\}}	|	jrnd|	_|	}|	jrn||= ||	j= qnW |rÐ|||j< |j	 rÐ|j
rÐˆjˆj|ƒƒ||j< |�rb|\}
}|j|
jdƒ |j|
jdƒ |||j< |
j�rD|j �rDd
ˆj|
jƒˆjˆj|ƒƒdœ }|||j< nˆj|
jƒ||j< |jˆ|
j< ˆ �rœ|ˆ j= |ˆ j= ˆ j	�rœˆ jjj j�rœˆjˆ jjƒS tƒ }‡fdd„ˆj jD ƒ}‡fdd„ˆj jD ƒ}ˆj j}ˆ �rî‡ fdd„|D ƒ}tˆj jƒ}tj|ƒ}ˆj jˆj j|||||dœ}tdf |ƒ}||d< ˆj|d< tˆj jˆj|ƒ tj|ƒ}ˆj jdt ˆj jƒ |||||dœ}tdf |ƒ}||d< ˆj|d< tdˆj j ˆj|ƒ}ˆj!|ƒ ˆj"dˆj|j jƒdj#‡fdd„|D ƒƒdj#|j$ƒ ƒˆjˆj jƒf ƒ ˆjˆdd� ˆj%||j jˆj jdd� xˆj&D ]}ˆj"|ƒ �q4W g ˆ_&|�rZd|_dS )a|  
        Shortcut to transform a model from old_model into new_model

        This follows the correct procedure to perform non-rename or column
        addition operations based on SQLite's documentation

        https://www.sqlite.org/lang_altertable.html#caution

        The essential steps are:
          1. Create a table with the updated definition called "new__app_model"
          2. Copy the data from the existing "app_model" table to the new table
          3. Drop the "app_model" table
          4. Rename the "new__app_model" table to "app_model"
          5. Restore any index of the previous "app_model" table.
        c                s   | j o| jjˆ kS )N)Zis_relationÚremote_fieldr5   )Úf)r5   r   r   Úis_self_referentialŸ   s    z?DatabaseSchemaEditor._remake_table.<locals>.is_self_referentialc                s$   i | ]}ˆ |ƒr|j ƒ n||j“qS r   )Úcloner*   )Ú.0rD   )rE   r   r   ú
<dictcomp>¢   s   z6DatabaseSchemaEditor._remake_table.<locals>.<dictcomp>c                s   i | ]}ˆ j |jƒ|j“qS r   )Ú
quote_nameÚcolumn)rG   rD   )r   r   r   rH   ¨   s    NÚprimary_keyFr8   zcoalesce(%(col)s, %(default)s))ÚcolÚdefaultc                s   g | ]}‡ fd d„|D ƒ‘qS )c                s   g | ]}ˆ j ||ƒ‘qS r   )Úget)rG   Ún)Úrename_mappingr   r   ú
<listcomp>Û   s    zADatabaseSchemaEditor._remake_table.<locals>.<listcomp>.<listcomp>r   )rG   Úunique)rP   r   r   rQ   Û   s   z6DatabaseSchemaEditor._remake_table.<locals>.<listcomp>c                s   g | ]}‡ fd d„|D ƒ‘qS )c                s   g | ]}ˆ j ||ƒ‘qS r   )rN   )rG   rO   )rP   r   r   rQ   â   s    zADatabaseSchemaEditor._remake_table.<locals>.<listcomp>.<listcomp>r   )rG   Úindex)rP   r   r   rQ   â   s   c                s   g | ]}ˆ j |jkr|‘qS r   )r*   Úfields)rG   rS   )Údelete_fieldr   r   rQ   é   s    )Ú	app_labelr:   Úunique_togetherÚindex_togetherÚindexesr.   ÚappsZMetaÚ
__module__znew__%szNew%sz%INSERT INTO %s (%s) SELECT %s FROM %sz, c             3   s   | ]}ˆ j |ƒV  qd S )N)rI   )rG   Úx)r   r   r   ú	<genexpr>  s    z5DatabaseSchemaEditor._remake_table.<locals>.<genexpr>)Úhandle_autom2m)r6   T)'r9   Zlocal_concrete_fieldsÚgetattrÚlistÚitemsrK   Úauto_createdrJ   r*   Úmany_to_manyZconcreter(   Zeffective_defaultÚpopÚnullrI   rC   ÚthroughÚdelete_modelr   rW   rX   rY   r.   ÚcopyÚdeepcopyrV   r:   r&   r[   Zobject_nameÚ	__bases__r   Úcreate_modelr=   Újoinr+   r4   Údeferred_sql)r   r5   Úcreate_fieldrU   r<   ÚbodyÚmappingZrestore_pk_fieldr*   Úfieldr>   r?   Zcase_sqlrZ   rW   rX   rY   r.   Z	body_copyZmeta_contentsÚmetaZ	new_modelÚsqlr   )rU   rE   r5   rP   r   r   Ú_remake_tableŒ   sª    










z"DatabaseSchemaEditor._remake_tablec                sl   |rt ƒ j|ƒ nV| j| jd| j|jjƒi ƒ x6t| jƒD ](}t	|t
ƒr<|j|jjƒr<| jj|ƒ q<W d S )NÚtable)r   rg   r=   Úsql_delete_tablerI   r9   r:   r`   rm   r   r   Zreferences_tableÚremove)r   r5   r^   rs   )r   r   r   rg   3  s    z!DatabaseSchemaEditor.delete_modelc             C   s2   |j r |jjjjr | j|jjƒS | j||d� dS )z�
        Create a field on a model. Usually involves adding a column, but may
        involve adding a table instead (for M2M fields).
        )rn   N)rc   rC   rf   r9   rb   rk   rt   )r   r5   rq   r   r   r   Ú	add_field@  s    zDatabaseSchemaEditor.add_fieldc             C   sN   |j r"|jjjjrJ| j|jjƒ n(|j| jd�d dkr<dS | j||d� dS )z…
        Remove a field from a model. Usually involves deleting a column,
        but for M2Ms may involve deleting a table.
        )r   r&   N)rU   )	rc   rC   rf   r9   rb   rg   Zdb_parametersr   rt   )r   r5   rq   r   r   r   Úremove_fieldJ  s    z!DatabaseSchemaEditor.remove_fieldc	       
      C   s²   | j jjrb|j|jkrb| j||ƒ| j||ƒkrb|jr:|jpD|joD|j rb| j| j|j	j
|||ƒƒS | j|||fd� |jr®|jr®||kr®x$|jj	jD ]}	|	js”| j|	jƒ q”W dS )z3Perform a "physical" (non-ManyToMany) field update.)r<   N)r   r1   Zcan_alter_table_rename_columnrJ   Z
column_sqlrC   Zdb_constraintr=   Z_rename_field_sqlr9   r:   rt   rK   r5   Zrelated_objectsrc   Zrelated_model)
r   r5   r>   r?   Zold_typeZnew_typeZold_db_paramsZnew_db_paramsr7   Úrelr   r   r   Ú_alter_field\  s    
z!DatabaseSchemaEditor._alter_fieldc             C   sÌ   |j jjj|j jjjkrR| j|j j|j jjj|jƒ ƒ|j jjj|jƒ ƒfd� dS | j|j jƒ | jd| j	|j jjjƒdj
d|jƒ |jƒ gƒdj
d|jƒ |jƒ gƒ| j	|j jjjƒf ƒ | j|j jƒ dS )z*Alter M2Ms to repoint their to= endpoints.)r<   Nz%INSERT INTO %s (%s) SELECT %s FROM %sz, Úid)rC   rf   r9   r:   rt   Ú	get_fieldZm2m_reverse_field_namerk   r=   rI   rl   Zm2m_column_nameZm2m_reverse_namerg   )r   r5   r>   r?   r7   r   r   r   Ú_alter_many_to_manyo  s&    

z(DatabaseSchemaEditor._alter_many_to_manyc                s.   t |tƒr |jr tƒ j||ƒ n
| j|ƒ d S )N)r   r   Ú	conditionr   Úadd_constraintrt   )r   r5   r/   )r   r   r   r€   ’  s    z#DatabaseSchemaEditor.add_constraintc                s.   t |tƒr |jr tƒ j||ƒ n
| j|ƒ d S )N)r   r   r   r   Úremove_constraintrt   )r   r5   r/   )r   r   r   r�   ˜  s    z&DatabaseSchemaEditor.remove_constraint)NF)T)F)NNN)T)F)Ú__name__r[   Ú__qualname__rv   Zsql_create_fkZsql_create_inline_fkZsql_create_uniqueZsql_delete_uniquer   r   r(   r0   r4   r<   rt   rg   rx   ry   r{   r~   r€   r�   Ú__classcell__r   r   )r   r   r
      s(   
'
 (

#r
   )rh   Údecimalr   Zdjango.apps.registryr   Zdjango.db.backends.base.schemar   Z!django.db.backends.ddl_referencesr   Zdjango.db.backends.utilsr   Zdjango.db.modelsr   Zdjango.db.transactionr   Zdjango.db.utilsr	   r
   r   r   r   r   Ú<module>   s   