3
7^)                 @   s4   d dl mZmZmZ d dlmZ G dd deZdS )    )BaseDatabaseIntrospection	FieldInfo	TableInfo)Indexc                   s   e Zd Zdddddddddd	d	d
ddddddddZg 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  ZS )DatabaseIntrospectionZBooleanFieldZBinaryFieldBigIntegerFieldZSmallIntegerFieldIntegerFieldZ	TextFieldZ
FloatFieldZGenericIPAddressFieldZ	CharFieldZ	DateFieldZ	TimeFieldZDateTimeFieldZDurationFieldZDecimalFieldZ	UUIDField)                  i  i  ie  i  i  i:  i;  iZ  i  i  i  i  i  c                s:   t  j||}|jr6d|jkr6|dkr*dS |dkr6dS |S )NZnextvalr   Z	AutoFieldr   ZBigAutoField)superget_field_typedefault)selfZ	data_typedescriptionZ
field_type)	__class__ M/tmp/pip-build-8app2_gc/Django/django/db/backends/postgresql/introspection.pyr   !   s    z$DatabaseIntrospection.get_field_typec                s4   |j dj jjjrdnd  fdd|j D S )z>Return a list of table and view names in the current database.a  
            SELECT c.relname,
            CASE WHEN {} THEN 'p' WHEN c.relkind IN ('m', 'v') THEN 'v' ELSE 't' END
            FROM pg_catalog.pg_class c
            LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
            WHERE c.relkind IN ('f', 'm', 'p', 'r', 'v')
                AND n.nspname NOT IN ('pg_catalog', 'pg_toast')
                AND pg_catalog.pg_table_is_visible(c.oid)
        zc.relispartitionFALSEc                s"   g | ]}|d   j krt| qS )r   )ignored_tablesr   ).0row)r   r   r   
<listcomp>5   s    z8DatabaseIntrospection.get_table_list.<locals>.<listcomp>)executeformat
connectionfeaturesZsupports_table_partitionsfetchall)r   cursorr   )r   r   get_table_list*   s    z$DatabaseIntrospection.get_table_listc                sL   |j d|g dd |j D  |j d| jjj|   fdd|jD S )zi
        Return a description of the table with the DB-API cursor.description
        interface.
        a  
            SELECT
                a.attname AS column_name,
                NOT (a.attnotnull OR (t.typtype = 'd' AND t.typnotnull)) AS is_nullable,
                pg_get_expr(ad.adbin, ad.adrelid) AS column_default
            FROM pg_attribute a
            LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum
            JOIN pg_type t ON a.atttypid = t.oid
            JOIN pg_class c ON a.attrelid = c.oid
            JOIN pg_namespace n ON c.relnamespace = n.oid
            WHERE c.relkind IN ('f', 'm', 'p', 'r', 'v')
                AND c.relname = %s
                AND n.nspname NOT IN ('pg_catalog', 'pg_toast')
                AND pg_catalog.pg_table_is_visible(c.oid)
        c             S   s   i | ]}|d d |d qS )   Nr   r   )r   liner   r   r   
<dictcomp>N   s    z?DatabaseIntrospection.get_table_description.<locals>.<dictcomp>zSELECT * FROM %s LIMIT 1c          	      s6   g | ].}t |j|j|j|j|j|jf |j  qS r   )r   nameZ	type_codeZdisplay_sizeZinternal_sizeZ	precisionZscale)r   r$   )	field_mapr   r   r   Q   s   	z?DatabaseIntrospection.get_table_description.<locals>.<listcomp>)r   r    r   opsZ
quote_namer   )r   r!   
table_namer   )r'   r   get_table_description7   s    

	z+DatabaseIntrospection.get_table_descriptionc                s$   |j d g  fdd|j D S )Na  
            SELECT s.relname as sequence_name, col.attname
            FROM pg_class s
                JOIN pg_namespace sn ON sn.oid = s.relnamespace
                JOIN pg_depend d ON d.refobjid = s.oid AND d.refclassid = 'pg_class'::regclass
                JOIN pg_attrdef ad ON ad.oid = d.objid AND d.classid = 'pg_attrdef'::regclass
                JOIN pg_attribute col ON col.attrelid = ad.adrelid AND col.attnum = ad.adnum
                JOIN pg_class tbl ON tbl.oid = ad.adrelid
                JOIN pg_namespace n ON n.oid = tbl.relnamespace
            WHERE s.relkind = 'S'
              AND d.deptype in ('a', 'n')
              AND n.nspname = 'public'
              AND tbl.relname = %s
        c                s    g | ]}|d   |d dqS )r   r#   )r&   tablecolumnr   )r   r   )r)   r   r   r   m   s   z7DatabaseIntrospection.get_sequences.<locals>.<listcomp>)r   r    )r   r!   r)   Ztable_fieldsr   )r)   r   get_sequences]   s    

z#DatabaseIntrospection.get_sequencesc             C   s    |j d|g dd |j D S )z
        Return a dictionary of {field_name: (field_name_other_table, other_table)}
        representing all relationships to the given table.
        a  
            SELECT c2.relname, a1.attname, a2.attname
            FROM pg_constraint con
            LEFT JOIN pg_class c1 ON con.conrelid = c1.oid
            LEFT JOIN pg_class c2 ON con.confrelid = c2.oid
            LEFT JOIN pg_attribute a1 ON c1.oid = a1.attrelid AND a1.attnum = con.conkey[1]
            LEFT JOIN pg_attribute a2 ON c2.oid = a2.attrelid AND a2.attnum = con.confkey[1]
            WHERE c1.relname = %s AND con.contype = 'f'
        c             S   s"   i | ]}|d  |d f|d qS )   r   r#   r   )r   r   r   r   r   r%      s    z7DatabaseIntrospection.get_relations.<locals>.<dictcomp>)r   r    )r   r!   r)   r   r   r   get_relationsq   s    
z#DatabaseIntrospection.get_relationsc             C   s   |j d|g |j S )Na  
            SELECT kcu.column_name, ccu.table_name AS referenced_table, ccu.column_name AS referenced_column
            FROM information_schema.constraint_column_usage ccu
            LEFT JOIN information_schema.key_column_usage kcu
                ON ccu.constraint_catalog = kcu.constraint_catalog
                    AND ccu.constraint_schema = kcu.constraint_schema
                    AND ccu.constraint_name = kcu.constraint_name
            LEFT JOIN information_schema.table_constraints tc
                ON ccu.constraint_catalog = tc.constraint_catalog
                    AND ccu.constraint_schema = tc.constraint_schema
                    AND ccu.constraint_name = tc.constraint_name
            WHERE kcu.table_name = %s AND tc.constraint_type = 'FOREIGN KEY'
        )r   r    )r   r!   r)   r   r   r   get_key_columns   s    
z%DatabaseIntrospection.get_key_columnsc             C   s
  i }|j dd|g xX|j D ]L\}}}}}||dk|dk|dkrRt|jddnd|d	kd
d|d||< qW |j d|g x|j D ]|\}	}}
}}}}}|	|kr|dko|	jd o|dk}|dgkr|ng |dgkr|ng ||
dd
d|rtjn|||d
||	< qW |S )z
        Retrieve any constraints or keys (unique, pk, fk, check, index) across
        one or more columns. Also retrieve the definition of expression-based
        indexes.
        aq  
            SELECT
                c.conname,
                array(
                    SELECT attname
                    FROM unnest(c.conkey) WITH ORDINALITY cols(colid, arridx)
                    JOIN pg_attribute AS ca ON cols.colid = ca.attnum
                    WHERE ca.attrelid = c.conrelid
                    ORDER BY cols.arridx
                ),
                c.contype,
                (SELECT fkc.relname || '.' || fka.attname
                FROM pg_attribute AS fka
                JOIN pg_class AS fkc ON fka.attrelid = fkc.oid
                WHERE fka.attrelid = c.confrelid AND fka.attnum = c.confkey[1]),
                cl.reloptions
            FROM pg_constraint AS c
            JOIN pg_class AS cl ON c.conrelid = cl.oid
            JOIN pg_namespace AS ns ON cl.relnamespace = ns.oid
            WHERE ns.nspname = %s AND cl.relname = %s
        publicpuf.r#   NcF)columnsprimary_keyuniqueforeign_keycheckindex
definitionoptionsa|  
            SELECT
                indexname, array_agg(attname ORDER BY arridx), indisunique, indisprimary,
                array_agg(ordering ORDER BY arridx), amname, exprdef, s2.attoptions
            FROM (
                SELECT
                    c2.relname as indexname, idx.*, attr.attname, am.amname,
                    CASE
                        WHEN idx.indexprs IS NOT NULL THEN
                            pg_get_indexdef(idx.indexrelid)
                    END AS exprdef,
                    CASE am.amname
                        WHEN 'btree' THEN
                            CASE (option & 1)
                                WHEN 1 THEN 'DESC' ELSE 'ASC'
                            END
                    END as ordering,
                    c2.reloptions as attoptions
                FROM (
                    SELECT *
                    FROM pg_index i, unnest(i.indkey, i.indoption) WITH ORDINALITY koi(key, option, arridx)
                ) idx
                LEFT JOIN pg_class c ON idx.indrelid = c.oid
                LEFT JOIN pg_class c2 ON idx.indexrelid = c2.oid
                LEFT JOIN pg_am am ON c2.relam = am.oid
                LEFT JOIN pg_attribute attr ON attr.attrelid = c.oid AND attr.attnum = idx.key
                WHERE c.relname = %s
            ) s2
            GROUP BY indexname, indisunique, indisprimary, amname, exprdef, attoptions;
        ZbtreeZ_btreeT)
r7   ordersr8   r9   r:   r;   r<   typer=   r>   )r2   r3   )r   r    tuplesplitendswithr   suffix)r   r!   r)   constraints
constraintr7   kindZ	used_colsr>   r<   r9   Zprimaryr?   type_r=   Zbasic_indexr   r   r   get_constraints   s8    
z%DatabaseIntrospection.get_constraints)__name__
__module____qualname__Zdata_types_reverser   r   r"   r*   r-   r/   r0   rI   __classcell__r   r   )r   r   r      s6   	&r   N)Z%django.db.backends.base.introspectionr   r   r   Zdjango.db.models.indexesr   r   r   r   r   r   <module>   s   