HEX
Server: Apache
System: Linux pdx1-shared-a1-38 6.6.104-grsec-jammy+ #3 SMP Tue Sep 16 00:28:11 UTC 2025 x86_64
User: mmickelson (3396398)
PHP: 8.1.31
Disabled: NONE
$ pwd: /usr/lib/python3/dist-packages/django/db/backends/mysql/__pycache__/
Upload Files
File: //usr/lib/python3/dist-packages/django/db/backends/mysql/__pycache__/introspection.cpython-310.pyc
o

3�a�5�@szddlmZddlZddlmZddlmZmZm	Z	ddl
mZddlm
Z
edejd�Zed	d
�ZGdd�de�ZdS)
�)�
namedtupleN)�
FIELD_TYPE)�BaseDatabaseIntrospection�	FieldInfo�	TableInfo)�Index)�
OrderedSetr)�extra�is_unsigned�has_json_constraint�InfoLinezXcol_name data_type max_len num_prec num_scale extra column_default collation is_unsignedc	seZdZiejd�ejd�ejd�ejd�ejd�ej	d�ej
d�ejd�ejd�ej
d�ejd�ejd	�ejd
�ejd�ejd�ejd�ejd�ejdejdejdejdi�Z�fdd
�Zdd�Zdd�Zddd�Zdd�Zdd�Zdd�Z dd�Z!dd�Z"�Z#S) �DatabaseIntrospection�	TextField�	CharField�DecimalField�	DateField�
DateTimeField�
FloatField�IntegerField�	JSONField�BigIntegerField�SmallIntegerField�	TimeFieldcstt��||�}d|jvr|dkrdS|dkrdS|dkrdS|jr3|dkr'dS|dkr-d	S|dkr3d
S|jr8dS|S)N�auto_incrementr�	AutoFieldr�BigAutoFieldr�SmallAutoField�PositiveBigIntegerField�PositiveIntegerField�PositiveSmallIntegerFieldr)�super�get_field_typer	r
r)�self�	data_type�description�
field_type��	__class__��H/usr/lib/python3/dist-packages/django/db/backends/mysql/introspection.pyr!-s$
z$DatabaseIntrospection.get_field_typecCs|�d�dd�|��D�S)z>Return a list of table and view names in the current database.zSHOW FULL TABLEScSs*g|]}t|dddd��|d���qS)r�t�v)z
BASE TABLE�VIEW�)r�get��.0�rowr(r(r)�
<listcomp>Fs"�z8DatabaseIntrospection.get_table_list.<locals>.<listcomp>)�execute�fetchall)r"�cursorr(r(r)�get_table_listCs
�z$DatabaseIntrospection.get_table_listcCs<i}|jjr|jjjr|�d|g�dd�|��D�}|�d|g�|��}|r,|dnd}|�d||g�dd	�|��D�}|�d
|jj�|��dd�}g}|j	D]G}	||	d}
|�
tg|	d
d��||
j�pn|	d�||
j
�pw|	d�||
j�p�|	d�|	d�|
j�|
j�|
j�|
j�|	d|v�R��qT|S)zj
        Return a description of the table with the DB-API cursor.description
        interface."
        aZ
                SELECT c.constraint_name AS column_name
                FROM information_schema.check_constraints AS c
                WHERE
                    c.table_name = %s AND
                    LOWER(c.check_clause) = 'json_valid(`' + LOWER(c.constraint_name) + '`)' AND
                    c.constraint_schema = DATABASE()
            cSsh|]}|d�qS�rr(r/r(r(r)�	<setcomp>Zsz>DatabaseIntrospection.get_table_description.<locals>.<setcomp>z�
            SELECT  table_collation
            FROM    information_schema.tables
            WHERE   table_schema = DATABASE()
            AND     table_name = %s
        r�a@
            SELECT
                column_name, data_type, character_maximum_length,
                numeric_precision, numeric_scale, extra, column_default,
                CASE
                    WHEN collation_name = %s THEN NULL
                    ELSE collation_name
                END AS collation_name,
                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()
        cSsi|]	}|dt|��qSr7)r)r0�liner(r(r)�
<dictcomp>xsz?DatabaseIntrospection.get_table_description.<locals>.<dictcomp>zSELECT * FROM %s LIMIT 1cSs|durt|�S|S�N)�int)�ir(r(r)�to_int|sz;DatabaseIntrospection.get_table_description.<locals>.to_intN����)�
connection�mysql_is_mariadb�features�can_introspect_json_fieldr3r4�fetchone�ops�
quote_namer$�appendr�max_len�num_prec�	num_scale�column_default�	collationr	r
)r"r5�
table_name�json_constraintsr1�default_column_collation�
field_infor?�fieldsr:�infor(r(r)�get_table_descriptionIsT���

��������	�

�z+DatabaseIntrospection.get_table_descriptionr(cCs2|�||�D]}d|jvr||jd�gSqgS)Nr)�table�column)rWr	�name)r"r5rQ�table_fieldsrTr(r(r)�
get_sequences�s

�z#DatabaseIntrospection.get_sequencescCs0|�||�}i}|D]\}}}||f||<q
|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"r5rQ�constraints�	relations�my_fieldname�other_table�other_fieldr(r(r)�
get_relations�s
z#DatabaseIntrospection.get_relationscCs$g}|�d|g�|�|���|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)r3�extendr4)r"r5rQ�key_columnsr(r(r)r]�s�z%DatabaseIntrospection.get_key_columnscCs,|�d|g�|��}|s|jjjS|dS)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)r3rHrDrF�_mysql_storage_engine)r"r5rQ�resultr(r(r)�get_storage_engine�s�
z(DatabaseIntrospection.get_storage_enginecCs~t�}t�|�d}dd�|��D�}|D]'}|jtjjkr<|jj�	|j
�|j
kr<|j
dd�|vr<|�|j
dd��q|S)Nrcss�|]}|js|VqdSr<)�
is_whitespace)r0�tokenr(r(r)�	<genexpr>�s�zBDatabaseIntrospection._parse_constraint_columns.<locals>.<genexpr>r-���)r�sqlparse�parse�flatten�ttype�tokens�NamerDrIrJ�value�add)r"�check_clause�columns�
check_columns�	statementrqrjr(r(r)�_parse_constraint_columns�s�z/DatabaseIntrospection._parse_constraint_columnscCsxi}d}|�||g�|��D]0\}}}}||vr6t�dddd|r%||fndd�||<|jjjr6g||d<||d�|�qd}	|�|	|g�|��D]#\}}
|
��dkrdd	||d
<d	||d<qM|
��dkrpd	||d<qM|jjjr�d}d
d�|�	||�D�}|jj
r�d}	nd}	|�|	|g�|��D]$\}}
|�|
|�}t|�|hkr�|d7}d|}|dddd	dd�||<q�|�d|jj
�|��dd�|��D�D]X\}}}}}}}||vr�t�ddddd�||<|jjjr�g||d<d	||d<|dk�rtjn|��||d<||d�|�|jjj�r)||d�|dk�r&dnd�q�|��D]}t|d�|d<�q.|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)rv�primary_key�unique�index�check�foreign_key�ordersrvz�
            SELECT c.constraint_name, c.constraint_type
            FROM information_schema.table_constraints AS c
            WHERE
                c.table_schema = DATABASE() AND
                c.table_name = %s
        zprimary keyTrzr{rcSsh|]}|j�qSr()rZ)r0rVr(r(r)r8�sz8DatabaseIntrospection.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__zSHOW INDEX FROM %scSs"g|]
}|dd�|df�qS)NrC�
r()r0�xr(r(r)r2&s�z9DatabaseIntrospection.get_constraints.<locals>.<listcomp>)rvrzr{r}r~r|�BTREE�type�D�DESC�ASC)r3r4rrDrF�supports_index_column_orderingrt�lower� can_introspect_check_constraintsrWrEry�setrIrJr�suffixrK�values�list)r"r5rQr^�
name_query�
constraintrY�	ref_table�
ref_column�
type_query�kind�unnamed_constraints_indexrvru�constraint_columnsrX�
non_uniquer|�colseq�order�type_r(r(r)�get_constraints�s�	
�
�
�	�
�
  �z%DatabaseIntrospection.get_constraints)r()$�__name__�
__module__�__qualname__r�BLOB�CHAR�DECIMAL�
NEWDECIMAL�DATE�DATETIME�DOUBLE�FLOAT�INT24�JSON�LONG�LONGLONG�SHORT�STRING�TIME�	TIMESTAMP�TINY�	TINY_BLOB�MEDIUM_BLOB�	LONG_BLOB�
VAR_STRING�data_types_reverser!r6rWr\rcr]rhryr��
__classcell__r(r(r&r)r
sd��������	�
���
������
G
r
)�collectionsrrm�MySQLdb.constantsr�%django.db.backends.base.introspectionrr�
BaseFieldInfor�django.db.modelsr�django.utils.datastructuresr�_fieldsrr
r(r(r(r)�<module>s�
@ Telegram