File manager - Edit - /usr/local/CyberCP/lib/python3.10/site-packages/django/db/backends/mysql/__pycache__/introspection.cpython-310.pyc
Back
o �hC7 � @ s� d dl mZ d dlZd dlmZ d dlmZ d dlmZ d dlm Z d dl m Z d dl mZ ed ejd �Zed d �Zed e jd �Z G dd� de�ZdS )� )� namedtupleN)� FIELD_TYPE)�BaseDatabaseIntrospection)� FieldInfo)� TableInfo)�Index)� OrderedSetr )�extra� is_unsigned�has_json_constraint�comment�InfoLinez`col_name data_type max_len num_prec num_scale extra column_default collation is_unsigned commentr )r c 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!� 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__� �Y/usr/local/CyberCP/lib/python3.10/site-packages/django/db/backends/mysql/introspection.pyr" 1 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.z� SELECT table_name, table_type, table_comment FROM information_schema.tables WHERE table_schema = DATABASE() c S s0 g | ]}t |d ddd��|d �|d ��qS )r �t�v)z BASE TABLE�VIEW� � )r �get��.0�rowr) r) r* � <listcomp>S s "��z8DatabaseIntrospection.get_table_list.<locals>.<listcomp>��execute�fetchall)r# �cursorr) r) r* �get_table_listG s � �z$DatabaseIntrospection.get_table_listc C sT 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 ]S} || d } |� t g | d d� �|| j �pn| d �|| j �pw| d �|| j �p�| d �|| j�p�| d �| d �| j�| j�| j�| j�| d |v �| j�R � � qT|S )zj Return a description of the table with the DB-API cursor.description interface." av 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) r1 r) r) r* � <setcomp>p 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 � ad 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, column_comment FROM information_schema.columns WHERE table_name = %s AND table_schema = DATABASE() c S s i | ] }|d t |� �qS r: )r )r2 �liner) r) r* � <dictcomp>� 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_intNr/ � � � � )� connection�mysql_is_mariadb�features�can_introspect_json_fieldr6 r7 �fetchone�ops� quote_namer% �appendr �max_len�num_prec� num_scale�column_default� collationr r r ) r# r8 � table_name�json_constraintsr3 �default_column_collation� field_inforB �fieldsr= �infor) r) r* �get_table_descriptionX sp �� � � �� �������� � � � ��z+DatabaseIntrospection.get_table_descriptionr) c C s2 | � ||�D ]}d|jv r||jd�g S qg S )Nr )�table�column)rZ r �name)r# r8 rT � table_fieldsrW r) r) r* � get_sequences� s �z#DatabaseIntrospection.get_sequencesc C s |� d|g� dd� |�� D �S )z� Return a dictionary of {field_name: (field_name_other_table, other_table)} representing all foreign keys in the given table. aM SELECT column_name, referenced_column_name, referenced_table_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 c S s i | ] \}}}|||f�qS r) r) )r2 � field_name� other_field� other_tabler) r) r* r> � s ��z7DatabaseIntrospection.get_relations.<locals>.<dictcomp>r5 )r# r8 rT r) r) r* � get_relations� s � �z#DatabaseIntrospection.get_relationsc 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. z� SELECT engine FROM information_schema.tables WHERE table_name = %s AND table_schema = DATABASE() r )r6 rK rG rI �_mysql_storage_engine)r# r8 rT �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)r2 �tokenr) r) r* � <genexpr>� s � zBDatabaseIntrospection._parse_constraint_columns.<locals>.<genexpr>r. ���) r �sqlparse�parse�flatten�ttype�tokens�NamerG rL rM �value�add)r# � check_clause�columns� check_columns� statementro rh r) r) r* �_parse_constraint_columns� s �z/DatabaseIntrospection._parse_constraint_columnsc C s i }d}|� ||g� |�� D ]5\}}}}} ||vr;t� | dk| dv dd|r*||fndd�||< | jjjr;g || d< || d �|� q| jjjr�d } d d � | �||�D �} | jj r^d } nd } |� | |g� |�� D ]$\}} | � | | �}t |�|hkr�| d7 } d| }|dddddd�||< qk|� d| jj � |� � dd� |�� D �D ]V\}}}}}}}||vr�t� d| ddd�||< | jjjr�g || d< d|| d< |dkr�tjn|�� || d< || d �|� | jjjr�|| d �|dkr�dnd� q�|�� D ] }t|d �|d< �q |S )zu Retrieve any constraints or keys (unique, pk, fk, check, index) across one or more columns. ai SELECT kc.`constraint_name`, kc.`column_name`, kc.`referenced_table_name`, kc.`referenced_column_name`, c.`constraint_type` FROM information_schema.key_column_usage AS kc, information_schema.table_constraints AS c WHERE kc.table_schema = DATABASE() AND c.table_schema = kc.table_schema AND c.constraint_name = kc.constraint_name AND c.constraint_type != 'CHECK' AND kc.table_name = %s ORDER BY kc.`ordinal_position` � PRIMARY KEY> �UNIQUErx FN)rt � primary_key�unique�index�check� foreign_key�ordersrt r c S s h | ]}|j �qS r) )r] )r2 rY r) r) r* r; 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__TzSHOW INDEX FROM %sc S s" g | ] }|d d� |d f �qS )NrF � r) )r2 �xr) r) r* r4 F s �z9DatabaseIntrospection.get_constraints.<locals>.<listcomp>)rt rz r{ r} r~ r| �BTREE�type�D�DESC�ASC)r6 r7 r rG rI � supports_index_column_orderingrr � can_introspect_check_constraintsrZ rH rw �setrL rM r �suffix�lowerrN �values�list)r# r8 rT � constraints� name_query� constraintr\ � ref_table� ref_column�kind�unnamed_constraints_indexrt � type_queryrs �constraint_columnsr[ � 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" r9 rZ r_ rc rf rw r� � __classcell__r) r) r' r* r sb �������� � � � � ������ [ r )� collectionsr rk �MySQLdb.constantsr �%django.db.backends.base.introspectionr r � BaseFieldInfor � BaseTableInfo�django.db.modelsr �django.utils.datastructuresr �_fieldsr r r) r) r) r* �<module> s$ ��
| ver. 1.4 |
Github
|
.
| PHP 8.2.28 | Generation time: 0.02 |
proxy
|
phpinfo
|
Settings