?????????? ????????? - ??????????????? - /home/agenciai/.local/lib/python3.9/site-packages/mysql/connector/django/__pycache__/introspection.cpython-39.pyc
???????
a ��Jh�J � @ s� d Z ddlmZ ddlmZmZmZmZmZm Z m Z ddl Z ddl m Z ddlmZmZmZ ddlmZ ddlmZ dd lmZ er�dd lmZ ed ej d �Zed k r�edd�Z n edd�Z G dd� de�Z dS )zDatabase Introspection.� )� namedtuple)� TYPE_CHECKING�Any�Dict�List�Optional�Set�TupleN)�VERSION)�BaseDatabaseIntrospection� FieldInfo� TableInfo)�Index)� OrderedSet)� FieldType)� CursorWrapperr )�extra� is_unsigned�has_json_constraint�� � r �InfoLinezNcol_name data_type max_len num_prec num_scale extra column_default is_unsignedzXcol_name data_type max_len num_prec num_scale extra column_default collation is_unsignedc & s� e Zd ZdZejdejdejdejdej dej dej dej dej dejdejd ejd ejd ejdejdejdejdejdejd iZeeed �� fd d� Zde e d�dd�Z dee e d�dd�Z dee e!e ee"f f d�dd�Z#dee$e! d�dd�Z%d)dee&e e eef d�d d �Z'dee ee(eef f d�d d �Z)dee e(eeef d�d d!�Z*deed�d"d#�Z+e&e,e e-d$�d%d&�Z.dee ee&f d�d'd(�Z/� Z0S )*�DatabaseIntrospectionz5Encapsulate backend-specific introspection utilities.Z TextFieldZ DecimalFieldZ DateFieldZ DateTimeFieldZ FloatField� IntegerField�BigIntegerField�SmallIntegerFieldZ CharFieldZ TimeField)� data_type� description�returnc st t � �||�}d|jv r<|dkr$dS |dkr0dS |dkr<dS |jrf|dkrNdS |dkrZd S |dkrfd S |jrpd S |S ) N�auto_incrementr Z AutoFieldr Z BigAutoFieldr ZSmallAutoFieldZPositiveBigIntegerFieldZPositiveIntegerFieldZPositiveSmallIntegerFieldZ JSONField)�super�get_field_typer r r )�selfr r Z field_type�� __class__� �Y/home/agenciai/.local/lib/python3.9/site-packages/mysql/connector/django/introspection.pyr" l s$ z$DatabaseIntrospection.get_field_typer )�cursorr c 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 TABLEZVIEW� )r �get)�.0�rowr& r& r' � <listcomp>� s �z8DatabaseIntrospection.get_table_list.<locals>.<listcomp>)�execute�fetchall)r# r( r& r& r' �get_table_list� s �z$DatabaseIntrospection.get_table_list)r( � table_namer c C s� i }|� d|g� |�� }|r&|d nd}tdk rB|� d|g� n|� d||g� dd� |�� D �}|� d | jj�|�� d �� ttt d �d d �}g }|j D �]} || d } tdk �r6|� t g | dd� �|| j �p�| d �|| j�p�| d �|| j��p| d �| d �| j�| j�| j�| d |v �R � � q�|� t g | dd� �|| j ��p\| d �|| j��pp| d �|| j��p�| d �| d �| j�| j�| j�| j�| d |v �R � � q�|S )zj Return a description of the table with the DB-API cursor.description interface." z� SELECT table_collation FROM information_schema.tables WHERE table_schema = DATABASE() AND table_name = %s r � r 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() ax 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 )r )r )r- �liner& r& r' � <dictcomp>� � z?DatabaseIntrospection.get_table_description.<locals>.<dictcomp>zSELECT * FROM z LIMIT 1)�ir c S s | d urt | �S | S �N)�int)r8 r& r& r' �to_int� s z;DatabaseIntrospection.get_table_description.<locals>.to_intNr � � � )r0 �fetchone�DJANGO_VERSIONr1 � connection�ops� quote_namer r r: r �appendr �max_lenZnum_precZ num_scaleZcolumn_defaultr r Z collation) r# r( r3 Zjson_constraintsr. Zdefault_column_collation� field_infor; �fieldsr5 �infor& r& r' �get_table_description� s� � ��� �������� �� �������� � ��z+DatabaseIntrospection.get_table_descriptionc C s� |� d| jj�|�� �� t|�� �}t� }|D ] }|d dkr0|�|d � q0i }|D ]d}|d |v rjqX|d |vr�ddd�||d < |d dkr�d ||d d < |d sXd ||d d < qX|S ) zReturn indexes from table.�SHOW INDEX FROM r r+ r r< F)� primary_key�uniqueZPRIMARYTrK rL )r0 rA rB rC �listr1 �set�add)r# r( r3 �rowsZmulticol_indexesr. Zindexesr& r& r' � get_indexes� s" z!DatabaseIntrospection.get_indexesc C s2 | � ||��� D ] }|d d r|d S qdS )zP Returns the name of the primary key column for the given table r+ rK r N)rQ �items)r# r( r3 �columnr& r& r' �get_primary_key_column s z,DatabaseIntrospection.get_primary_key_columnr& )r( r3 � table_fieldsr c C s2 | � ||�D ] }d|jv r ||jd�g S q g S )Nr )�tablerS )rI r �name)r# r( r3 rU rF 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# r( r3 � constraintsZ relationsZ my_fieldnameZ other_tableZ 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)r0 �extendr1 )r# r( r3 Z key_columnsr& r& r' rY , 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 )r0 r? rA �featuresZ_mysql_storage_engine)r# r( r3 �resultr& r& r' �get_storage_engineA s � z(DatabaseIntrospection.get_storage_engine)� check_clause�columnsr c C s~ t � }t�|�d }dd� |�� D �}|D ]N}|jtjjkr*| jj� |j �|j kr*|j dd� |v r*|� |j dd� � q*|S )Nr c s s | ]}|j s|V qd S r9 )Z is_whitespace)r- �tokenr& r& r' � <genexpr>V r7 zBDatabaseIntrospection._parse_constraint_columns.<locals>.<genexpr>r+ ���) r �sqlparse�parse�flatten�ttype�tokens�NamerA rB rC �valuerO )r# r` ra Z check_columnsZ statementri rb r& r& r' �_parse_constraint_columnsQ s ���z/DatabaseIntrospection._parse_constraint_columnsc C s| i }d}|� ||g� |�� D ]`\}}}}||vrlt� dddd|rJ||fndd�||< | jjjrlg || d< || d �|� q d} |� | |g� |�� D ]F\}} | �� dkr�d || d < d || d < q�| �� d kr�d || d < q�| jjj�rtd } d d� | � ||�D �} d} |� | |g� |�� D ]P\}} | � | | �}t |�|hk�rZ| d7 } d| � d�}|dddd dd�||< �q"|� d| jj � |�� �� dd� |�� D �D ]�\}}}}}}}||v�r�t� ddddd�||< | jjj�r�g || d< d || d< |dk�rtjn|�� || d< || d �|� | jjj�r�|| d �|dk�rNdnd � �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)ra rK rL �index�check� foreign_keyZordersra 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 keyTrK rL r c S s h | ] }|j �qS r& )rW )r- rH r& r& r' � <setcomp>� s z8DatabaseIntrospection.get_constraints.<locals>.<setcomp>a 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_�__rJ c S s" g | ]}|d d� |d f �qS )Nr> � r& )r- �xr& r& r' r/ � s z9DatabaseIntrospection.get_constraints.<locals>.<listcomp>)ra rK rL rn ro rm ZBTREE�type�DZDESC�ASC)r0 r1 r rA r] Z supports_index_column_orderingrO �lowerZ can_introspect_check_constraintsrI rl rN rB rC r �suffixrD �valuesrM )r# r( r3 rZ Z name_query� constraintrS Z ref_tableZ ref_columnZ type_query�kindZunnamed_constraints_indexra r` Zconstraint_columns�_rm �order�type_r& r& r' �get_constraints` s� � � � � � � � $ z%DatabaseIntrospection.get_constraints)r& )1�__name__� __module__� __qualname__�__doc__r ZBLOBZDECIMALZ NEWDECIMALZDATEZDATETIMEZDOUBLE�FLOATZINT24�LONGZLONGLONGZSHORT�STRINGZTIME� TIMESTAMPZTINYZ TINY_BLOBZ MEDIUM_BLOBZ LONG_BLOBZ VAR_STRINGZdata_types_reverse�strr r" r r r2 rI r r: �boolrQ r rT r rX r r[ rY r_ r r rl r � __classcell__r& r& r$ r' r S sd � � g� � �� � � � �r ) r� � collectionsr �typingr r r r r r r re Zdjangor r@ Z%django.db.backends.base.introspectionr r Z BaseFieldInfor Zdjango.db.modelsr Zdjango.utils.datastructuresr Zmysql.connector.constantsr Zmysql.connector.django.baser �_fieldsr r r& r& r& r' �<module> s0 $ ���
| ver. 1.6 |
Github
|
.
| PHP 8.2.30 | ??????????? ?????????: 0 |
proxy
|
phpinfo
|
???????????