3
W­E^-  ã               @   sz   d dl mZ d dlZd dlmZ d dlmZmZm	Z	 d dl
mZ d dlmZ edejd ƒZed
dƒZG dd„ deƒZdS )é    )Ú
namedtupleN)Ú
FIELD_TYPE)ÚBaseDatabaseIntrospectionÚ	FieldInfoÚ	TableInfo)ÚIndex)Ú
OrderedSetr   ÚextraÚis_unsignedÚInfoLinezNcol_name data_type max_len num_prec num_scale extra column_default is_unsignedc            (       sÜ   e Zd Zejdejdejdejdejdej	dej
dejdejdejdejdejd	ejdejd
ejdejdejdejdejdejdiZ‡ fdd„Zdd„ Zdd„ Zf fdd„Zdd„ Zdd„ Zdd„ Zdd„ Z dd„ Z!‡  Z"S )ÚDatabaseIntrospectionZ	TextFieldZ	CharFieldZDecimalFieldZ	DateFieldZDateTimeFieldZ
FloatFieldÚIntegerFieldÚBigIntegerFieldÚSmallIntegerFieldZ	TimeFieldc                s^   t ƒ j||ƒ}d|jkr<|dkr$dS |dkr0dS |dkr<dS |jrZ|dkrNdS |dkrZd	S |S )
NÚauto_incrementr   Z	AutoFieldr   ZBigAutoFieldr   ZSmallAutoFieldZPositiveIntegerFieldZPositiveSmallIntegerField)ÚsuperÚget_field_typer	   r
   )ÚselfZ	data_typeÚdescriptionZ
field_type)Ú	__class__© úH/tmp/pip-build-78s3knkw/Django/django/db/backends/mysql/introspection.pyr   (   s    
z$DatabaseIntrospection.get_field_typec             C   s   |j dƒ dd„ |jƒ D ƒS )z>Return a list of table and view names in the current database.zSHOW FULL TABLESc             S   s*   g | ]"}t |d  dddœj|d ƒƒ‘qS )r   ÚtÚv)z
BASE TABLEZVIEWé   )r   Úget)Ú.0Úrowr   r   r   ú
<listcomp>;   s   z8DatabaseIntrospection.get_table_list.<locals>.<listcomp>)ÚexecuteÚfetchall)r   Úcursorr   r   r   Úget_table_list8   s    
z$DatabaseIntrospection.get_table_listc             C   sÀ   |j d|gƒ dd„ |jƒ D ƒ}|j d| jjj|ƒ ƒ dd„ }g }xv|jD ]l}||d  }|jt|dd	… ||jƒp||d	 ||j	ƒpŒ|d
 ||j
ƒpœ|d |d |j|j|jfžŽ ƒ qLW |S )zj
        Return a description of the table with the DB-API cursor.description
        interface."
        aœ  
            SELECT
                column_name, data_type, character_maximum_length,
                numeric_precision, numeric_scale, extra, column_default,
                CASE
                    WHEN column_type LIKE '%% unsigned' THEN 1
                    ELSE 0
                END AS is_unsigned
            FROM information_schema.columns
            WHERE table_name = %s AND table_schema = DATABASE()c             S   s   i | ]}t |Ž |d  “qS )r   )r   )r   Úliner   r   r   ú
<dictcomp>R   s    z?DatabaseIntrospection.get_table_description.<locals>.<dictcomp>zSELECT * FROM %s LIMIT 1c             S   s   | d k	rt | ƒS | S )N)Úint)Úir   r   r   Úto_intV   s    z;DatabaseIntrospection.get_table_description.<locals>.to_intr   Né   é   é   é   )r   r    Ú
connectionÚopsÚ
quote_namer   Úappendr   Úmax_lenZnum_precZ	num_scaleZcolumn_defaultr	   r
   )r   r!   Ú
table_nameÚ
field_infor'   Úfieldsr#   Úinfor   r   r   Úget_table_description>   s$    
	

z+DatabaseIntrospection.get_table_descriptionc             C   s2   x,| j ||ƒD ]}d|jkr||jdœgS qW g S )Nr   )ÚtableÚcolumn)r5   r	   Úname)r   r!   r1   Ztable_fieldsr2   r   r   r   Úget_sequencesh   s    
z#DatabaseIntrospection.get_sequencesc             C   s4   | j ||ƒ}i }x|D ]\}}}||f||< qW |S )z—
        Return a dictionary of {field_name: (field_name_other_table, other_table)}
        representing all relationships to the given table.
        )Úget_key_columns)r   r!   r1   ÚconstraintsZ	relationsZmy_fieldnameZother_tableZother_fieldr   r   r   Úget_relationso   s
    z#DatabaseIntrospection.get_relationsc             C   s$   g }|j d|gƒ |j|jƒ ƒ |S )z�
        Return a list of (column_name, referenced_table_name, referenced_column_name)
        for all key columns in the given table.
        a@  
            SELECT column_name, referenced_table_name, referenced_column_name
            FROM information_schema.key_column_usage
            WHERE table_name = %s
                AND table_schema = DATABASE()
                AND referenced_table_name IS NOT NULL
                AND referenced_column_name IS NOT NULL)r   Úextendr    )r   r!   r1   Zkey_columnsr   r   r   r:   z   s
    
z%DatabaseIntrospection.get_key_columnsc             C   s,   |j d|gƒ |jƒ }|s$| jjjS |d S )z†
        Retrieve the storage engine for a given table. Return the default
        storage engine if the table doesn't exist.
        zBSELECT engine FROM information_schema.tables WHERE table_name = %sr   )r   Zfetchoner,   ÚfeaturesZ_mysql_storage_engine)r   r!   r1   Úresultr   r   r   Úget_storage_engineŠ   s    
z(DatabaseIntrospection.get_storage_enginec             C   s‚   t ƒ }tj|ƒd }dd„ |jƒ D ƒ}xV|D ]N}|jtjjkr,| jjj	|j
ƒ|j
kr,|j
dd… |kr,|j|j
dd… ƒ q,W |S )Nr   c             s   s   | ]}|j s|V  qd S )N)Zis_whitespace)r   Útokenr   r   r   ú	<genexpr>›   s    zBDatabaseIntrospection._parse_constraint_columns.<locals>.<genexpr>r   éÿÿÿÿrC   )r   ÚsqlparseÚparseÚflattenZttypeÚtokensÚNamer,   r-   r.   ÚvalueÚadd)r   Úcheck_clauseÚcolumnsZcheck_columnsZ	statementrG   rA   r   r   r   Ú_parse_constraint_columns˜   s    
z/DatabaseIntrospection._parse_constraint_columnsc             C   s>  i }d}|j ||gƒ xV|jƒ D ]J\}}}}||krXtƒ dddd|rL||fnddœ||< || d j|ƒ q W d}	|j |	|gƒ xR|jƒ D ]F\}}
|
jƒ dkr¸d|| d	< d|| d
< qŠ|
jƒ d
krŠd|| d
< qŠW | jjj�rvd}dd„ | j||ƒD ƒ}| jj	�r
d}	nd}	|j |	|gƒ xX|jƒ D ]L\}}| j
||ƒ}t|ƒ|hk�rZ|d7 }d| }|ddddddœ||< �q&W |j d| jjj|ƒ ƒ x†dd„ |jƒ D ƒD ]p\}}}}}}||k�rÒtƒ dddddœ||< d|| d< |dk�rîtjn|jƒ || d< || d j|ƒ �q¢W x"|jƒ D ]}t|d ƒ|d< �q W |S )zu
        Retrieve any constraints or keys (unique, pk, fk, check, index) across
        one or more columns.
        aX  
            SELECT kc.`constraint_name`, kc.`column_name`,
                kc.`referenced_table_name`, kc.`referenced_column_name`
            FROM information_schema.key_column_usage AS kc
            WHERE
                kc.table_schema = DATABASE() AND
                kc.table_name = %s
            ORDER BY kc.`ordinal_position`
        FN)rL   Úprimary_keyÚuniqueÚindexÚcheckÚforeign_keyrL   zà
            SELECT c.constraint_name, c.constraint_type
            FROM information_schema.table_constraints AS c
            WHERE
                c.table_schema = DATABASE() AND
                c.table_name = %s
        zprimary keyTrN   rO   r   c             S   s   h | ]
}|j ’qS r   )r8   )r   r4   r   r   r   ú	<setcomp>Ó   s    z8DatabaseIntrospection.get_constraints.<locals>.<setcomp>a  
                    SELECT c.constraint_name, c.check_clause
                    FROM information_schema.check_constraints AS c
                    WHERE
                        c.constraint_schema = DATABASE() AND
                        c.table_name = %s
                a3  
                    SELECT cc.constraint_name, cc.check_clause
                    FROM
                        information_schema.check_constraints AS cc,
                        information_schema.table_constraints AS tc
                    WHERE
                        cc.constraint_schema = DATABASE() AND
                        tc.table_schema = cc.constraint_schema AND
                        cc.constraint_name = tc.constraint_name AND
                        tc.constraint_type = 'CHECK' AND
                        tc.table_name = %s
                r   z__unnamed_constraint_%s__zSHOW INDEX FROM %sc             S   s"   g | ]}|d d… |d f ‘qS )Nr*   é
   r   )r   Úxr   r   r   r   ü   s    z9DatabaseIntrospection.get_constraints.<locals>.<listcomp>)rL   rN   rO   rQ   rR   rP   ZBTREEÚtype)r   r    r   rJ   Úlowerr,   r>   Z can_introspect_check_constraintsr5   Zmysql_is_mariadbrM   Úsetr-   r.   r   ÚsuffixÚvaluesÚlist)r   r!   r1   r;   Z
name_queryÚ
constraintr7   Z	ref_tableZ
ref_columnZ
type_queryÚkindZunnamed_constraints_indexrL   rK   Zconstraint_columnsr6   Z
non_uniquerP   ZcolseqÚtype_r   r   r   Úget_constraints¥   sh    

$
 z%DatabaseIntrospection.get_constraints)#Ú__name__Ú
__module__Ú__qualname__r   ZBLOBZCHARZDECIMALZ
NEWDECIMALZDATEZDATETIMEZDOUBLEÚFLOATZINT24ÚLONGZLONGLONGZSHORTÚSTRINGZTIMEZ	TIMESTAMPZTINYZ	TINY_BLOBZMEDIUM_BLOBZ	LONG_BLOBZ
VAR_STRINGZdata_types_reverser   r"   r5   r9   r<   r:   r@   rM   r_   Ú__classcell__r   r   )r   r   r      s:   
*r   )r	   r
   )Úcollectionsr   rD   ZMySQLdb.constantsr   Z%django.db.backends.base.introspectionr   r   ZBaseFieldInfor   Zdjango.db.models.indexesr   Zdjango.utils.datastructuresr   Ú_fieldsr   r   r   r   r   r   Ú<module>   s   
