Dashboard
PHP:
8.2.30
OS:
Linux
User:
dh_nv8b2m
/
/
usr
/
lib
/
python3
/
dist-packages
/
django
/
db
/
backends
/
mysql
/
__pycache__
📤 Upload
📝 New File
📁 New Folder
Close
Editing: introspection.cpython-310.pyc
o 3�a�5 � @ sz d dl mZ d dlZd dlmZ d dlmZmZm Z d dl m Z d dl m Z edejd �Zed d �ZG d d � 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 s e Zd Zi ejd�ejd�ejd�ejd�ejd�ej d�ej d�ej d�ej d�ej d�ejd�ejd �ejd �ejd�ejd �ejd�ejd�ejdejdejdejdi�Z� fd d �Zdd� Zdd� Z d dd�Z dd� Z dd� Z dd� Z dd � Z!d d � Z"� Z#S ) �DatabaseIntrospection� TextField� CharField� DecimalField� DateField� DateTimeField� FloatField� IntegerField� JSONField�BigIntegerField�SmallIntegerField� TimeFieldc st t � �||�}d|jv r |dkrdS |dkrdS |dkr dS |jr3|dkr'dS |dkr-d S |dkr3d S |jr8d S |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_typec C s |� d� dd� |�� D �S )z>Return a list of table and view names in the current database.zSHOW FULL TABLESc S s* g | ]}t |d ddd��|d ���qS )r �t�v)z BASE TABLE�VIEW� )r �get��.0�rowr( r( r) � <listcomp>F s "�z8DatabaseIntrospection.get_table_list.<locals>.<listcomp>)�execute�fetchall)r" �cursorr( r( r) �get_table_listC s �z$DatabaseIntrospection.get_table_listc C s< i }| j jr| j jjr|�d|g� dd� |�� D �}|�d|g� |�� }|r,|d nd}|�d||g� dd � |�� D �}|�d | j j�|� � d d � }g }|j D ]G} || d } |� t g | 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() c S s h | ]}|d �qS �r r( r/ r( r( r) � <setcomp>Z s z>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() c S s i | ] }|d t |� �qS r7 )r )r0 �liner( r( r) � <dictcomp>x s z?DatabaseIntrospection.get_table_description.<locals>.<dictcomp>zSELECT * FROM %s LIMIT 1c S s | d urt | �S | S �N)�int)�ir( r( r) �to_int| s z;DatabaseIntrospection.get_table_description.<locals>.to_intN� � � � )� connection�mysql_is_mariadb�features�can_introspect_json_fieldr3 r4 �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_descriptionI sT ��� �������� � � z+DatabaseIntrospection.get_table_descriptionr( c C s2 | � ||�D ]}d|jv r||jd�g S qg S )Nr )�table�column)rW r �name)r" r5 rQ � table_fieldsrT r( r( r) � get_sequences� s �z#DatabaseIntrospection.get_sequencesc C s0 | � ||�}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" r5 rQ � constraints� relations� my_fieldname� other_table� other_fieldr( r( r) � get_relations� s z#DatabaseIntrospection.get_relationsc C s$ 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" r5 rQ � key_columnsr( r( r) r] � s �z%DatabaseIntrospection.get_key_columnsc C s, |� d|g� |�� }|s| jjjS |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 )r3 rH rD rF �_mysql_storage_engine)r" r5 rQ �resultr( r( r) �get_storage_engine� s � z(DatabaseIntrospection.get_storage_enginec C s~ t � }t�|�d }dd� |�� D �}|D ]'}|jtjjkr<| jj� |j �|j kr<|j dd� |v r<|� |j dd� � q|S )Nr c s s � | ]}|j s|V qd S r< )� is_whitespace)r0 �tokenr( r( r) � <genexpr>� s � zBDatabaseIntrospection._parse_constraint_columns.<locals>.<genexpr>r- ���) r �sqlparse�parse�flatten�ttype�tokens�NamerD rI rJ �value�add)r" � check_clause�columns� check_columns� statementrq rj r( r( r) �_parse_constraint_columns� s �z/DatabaseIntrospection._parse_constraint_columnsc C sx i }d}|� ||g� |�� D ]0\}}}}||vr6t� dddd|r%||fndd�||< | jjjr6g || d< || d �|� qd} |� | |g� |�� D ]#\}} | �� dkrdd || d < d || d < qM| �� d krpd || 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�ordersrv 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 keyTrz r{ r c S s h | ]}|j �qS r( )rZ )r0 rV r( r( r) r8 � 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__zSHOW INDEX FROM %sc S s" g | ] }|d d� |d f �qS )NrC � r( )r0 �xr( r( r) r2 & s �z9DatabaseIntrospection.get_constraints.<locals>.<listcomp>)rv rz r{ r} r~ r| �BTREE�type�D�DESC�ASC)r3 r4 r rD rF � supports_index_column_orderingrt �lower� can_introspect_check_constraintsrW rE ry �setrI rJ r �suffixrK �values�list)r" r5 rQ r^ � name_query� constraintrY � ref_table� ref_column� type_query�kind�unnamed_constraints_indexrv ru �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! r6 rW r\ rc r] rh ry r� � __classcell__r( r( r& r) r sd �������� � � � � ������ G r )� collectionsr rm �MySQLdb.constantsr �%django.db.backends.base.introspectionr r � BaseFieldInfor �django.db.modelsr �django.utils.datastructuresr �_fieldsr r r( r( r( r) �<module> s �
Save
Cancel