3
W­E^$  ã               @   s@   d dl 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)ÚBaseDatabaseSchemaEditor)ÚIndexColumns)Ústrip_quotesc            
       sÊ   e Zd ZdZdZdZdZdZdZdZ	dZ
d	Zd
ZdZdd„ Z‡ fdd„Zdd„ Zdd„ Z‡ fdd„Zd&‡ fdd„	Z‡ fdd„Zd'dd„Zd(dd„Zd)‡ fd d!„	Zdd"d"df df ddd#œ	‡ fd$d%„
Z‡  ZS )*ÚDatabaseSchemaEditorzCREATE SEQUENCE %(sequence)sz,DROP SEQUENCE IF EXISTS %(sequence)s CASCADEz=SELECT setval('%(sequence)s', MAX(%(column)s)) FROM %(table)sz9ALTER SEQUENCE %(sequence)s OWNED BY %(table)s.%(column)szOCREATE INDEX %(name)s ON %(table)s%(using)s (%(columns)s)%(extra)s%(condition)sz\CREATE INDEX CONCURRENTLY %(name)s ON %(table)s%(using)s (%(columns)s)%(extra)s%(condition)szDROP INDEX IF EXISTS %(name)sz*DROP INDEX CONCURRENTLY IF EXISTS %(name)szlCONSTRAINT %(name)s REFERENCES %(to_table)s(%(to_column)s)%(deferrable)s; SET CONSTRAINTS %(name)s IMMEDIATEzRSET CONSTRAINTS %(name)s IMMEDIATE; ALTER TABLE %(table)s DROP CONSTRAINT %(name)sz,DROP FUNCTION %(procedure)s(%(param_types)s)c             C   s*   t |tƒr|jddƒ}tjj|ƒjƒ jƒ S )Nú%z%%)Ú
isinstanceÚstrÚreplaceÚpsycopg2Ú
extensionsZadaptZ	getquotedÚdecode)ÚselfÚvalue© r   úF/tmp/pip-build-78s3knkw/Django/django/db/backends/postgresql/schema.pyÚquote_value"   s    
z DatabaseSchemaEditor.quote_valuec                s0   t ƒ j||ƒ}| j||ƒ}|d k	r,|j|ƒ |S )N)ÚsuperÚ_field_indexes_sqlÚ_create_like_index_sqlÚappend)r   ÚmodelÚfieldÚoutputÚlike_index_statement)Ú	__class__r   r   r   (   s
    
z'DatabaseSchemaEditor._field_indexes_sqlc             C   s.   |j r|j| jƒS | jjj|jƒ |j| jƒƒS )N)Zis_relationZrel_db_typeÚ
connectionZ
data_typesÚgetZget_internal_typeÚdb_type)r   r   r   r   r   Ú_field_data_type/   s
    z%DatabaseSchemaEditor._field_data_typec             C   sr   |j | jd�}|dk	rn|js"|jrnd|kr.dS |jdƒrN| j||gddgd�S |jdƒrn| j||gdd	gd�S dS )
z£
        Return the statement to create an index with varchar operator pattern
        when the column type is 'varchar' or 'text', otherwise return None.
        )r   Nú[ÚvarcharÚ_likeZvarchar_pattern_ops)ÚsuffixÚ	opclassesÚtextZtext_pattern_ops)r   r   Údb_indexÚuniqueÚ
startswithÚ_create_index_sql)r   r   r   r   r   r   r   r   7   s    

z+DatabaseSchemaEditor._create_like_index_sqlc       	   
      sL  d| _ | j|ƒ| j|ƒkr(|  j d7  _ t|jjƒ}ddddœ}|jƒ |k�r6t|jƒ}d||f }| j | j|ƒ||jƒ  dœ g f| jd	| j|ƒi g f| j	d	| j|ƒi g f| j
| j|ƒ| j| j|ƒd
| j|ƒ dœ dœ g f| j| j|ƒ| j|ƒ| j|ƒdœ g f| j| j|ƒ| j|ƒ| j|ƒdœ g fgfS tƒ j||||ƒS d S )Nz%ALTER COLUMN %(column)s TYPE %(type)sz USING %(column)s::%(type)sZbigintÚintegerZsmallint)Z	bigserialÚserialZsmallserialz	%s_%s_seq)ÚcolumnÚtypeÚsequenceznextval('%s'))r+   Údefault)ÚtableZchanges)r/   r+   r-   )Zsql_alter_column_typer   r   Ú_metaÚdb_tableÚlowerr+   Ú
quote_nameÚsql_delete_sequenceÚsql_create_sequenceZsql_alter_columnZsql_alter_column_defaultÚsql_set_sequence_maxÚsql_set_sequence_ownerr   Ú_alter_column_type_sql)	r   r   Ú	old_fieldÚ	new_fieldÚnew_typer/   Zserial_fields_mapr+   Zsequence_name)r   r   r   r8   M   sF    

z+DatabaseSchemaEditor._alter_column_type_sqlFc	          	      s  |j s|jrx|jdƒr"|jdƒ sN|jdƒr8|jdƒ sN|jdƒrx|jdƒ rx| j|jj|jgdd�}	| j| j||	ƒƒ t	ƒ j
||||||||ƒ |j pœ|j r¦|j s´|j rÒ|jrÒ| j||ƒ}
|
d k	rÒ| j|
ƒ |joä|j pâ|j �r| j|jj|jgdd�}| j| j||ƒƒ d S )Nr    r$   Zcitextr!   )r"   )r%   r&   r'   Z_create_index_namer0   r1   r+   ÚexecuteÚ_delete_index_sqlr   Ú_alter_fieldr   )r   r   r9   r:   Zold_typer;   Zold_db_paramsZnew_db_paramsÚstrictZ
index_namer   Zindex_to_remove)r   r   r   r>   Œ   s"    
z!DatabaseSchemaEditor._alter_fieldc                s*   |rt ||| j||d�S tƒ j||||ƒS )N)Úcol_suffixesr#   )r   r3   r   Ú_index_columns)r   r/   Úcolumnsr@   r#   )r   r   r   rA   ¨   s    z#DatabaseSchemaEditor._index_columnsc             C   s   | j |j|| |d�d d� d S )N)Úconcurrently)Úparams)r<   Z
create_sql)r   r   ÚindexrC   r   r   r   Ú	add_index­   s    zDatabaseSchemaEditor.add_indexc             C   s   | j |j|| |d�ƒ d S )N)rC   )r<   Z
remove_sql)r   r   rE   rC   r   r   r   Úremove_index°   s    z!DatabaseSchemaEditor.remove_indexNc                s    |r
| j n| j}tƒ j|||ƒS )N)Úsql_delete_index_concurrentlyÚsql_delete_indexr   r=   )r   r   ÚnameÚsqlrC   )r   r   r   r=   ³   s    z&DatabaseSchemaEditor._delete_index_sqlÚ )	rJ   r"   ÚusingÚdb_tablespacer@   rK   r#   Ú	conditionrC   c   	            s0   |s
| j n| j}tƒ j|||||||||	|
d�
S )N)rJ   r"   rM   rN   r@   rK   r#   rO   )Úsql_create_indexÚsql_create_index_concurrentlyr   r(   )r   r   ÚfieldsrJ   r"   rM   rN   r@   rK   r#   rO   rC   )r   r   r   r(   ·   s    z&DatabaseSchemaEditor._create_index_sql)F)F)F)NF)Ú__name__Ú
__module__Ú__qualname__r5   r4   r6   r7   rP   rQ   rI   rH   Zsql_create_column_inline_fkZsql_delete_fkZsql_delete_procedurer   r   r   r   r8   r>   rA   rF   rG   r=   r(   Ú__classcell__r   r   )r   r   r      s0   @

r   )r
   Zdjango.db.backends.base.schemar   Z!django.db.backends.ddl_referencesr   Zdjango.db.backends.utilsr   r   r   r   r   r   Ú<module>   s   