File manager - Edit - /usr/local/CyberCP/lib/python3.10/site-packages/django/db/backends/sqlite3/__pycache__/introspection.cpython-310.pyc
Back
o �h�C � @ s� d dl mZ d dlZd dlmZ d dlmZ d dlmZ d dlm Z d dl m Z d dl m Z ed ejd �Ze d �Zd d � ZG dd� d�ZG dd� de�ZdS )� )� namedtupleN)� DatabaseError)�BaseDatabaseIntrospection)� FieldInfo�� TableInfo)�Index)�_lazy_re_compiler )�pk�has_json_constraintz&^\s*(?:var)?char\s*\(\s*(\d+)\s*\)\s*$c C s t �| �}|r t|d �S dS )z6Extract the size number from a "varchar(11)" type name� N)� field_size_re�search�int)�name�m� r �[/usr/local/CyberCP/lib/python3.10/site-packages/django/db/backends/sqlite3/introspection.py�get_field_size s r c @ s� e Zd Zi dd�dd�dd�dd�dd�d d �d d �d d �dd�dd�dd�dd�dd�dd�dd�dd �d d �d d d!��Zd"d#� Zd$S )%�FlexibleFieldLookupDict�bool� BooleanField�boolean�smallint�SmallIntegerFieldzsmallint unsigned�PositiveSmallIntegerField� smallintegerr � IntegerField�integer�bigint�BigIntegerFieldzinteger unsigned�PositiveIntegerFieldzbigint unsigned�PositiveBigIntegerField�decimal� DecimalField�real� FloatField�text� TextField�char� CharField�varchar�blob� BinaryField�date� DateField� DateTimeField� TimeField)�datetime�timec C s" |� � �dd�d �� }| j| S )N�(r r )�lower�split�strip�base_data_types_reverse)�self�keyr r r � __getitem__6 s z#FlexibleFieldLookupDict.__getitem__N)�__name__� __module__� __qualname__r8 r; r r r r r sP �������� � � � � ������ r c st e Zd Ze� Z� fdd�Zdd� Zdd� Zddd �Zd d � Z d d � Z dd� Z dd� Z dd� Z dd� Zdd� Z� ZS )�DatabaseIntrospectionc s. t � �||�}|jr|dv rdS |jrdS |S )N> r r r � AutoField� JSONField)�super�get_field_typer r )r9 � data_type� description� field_type�� __class__r r rC > 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 name, type FROM sqlite_master WHERE type in ('table', 'view') AND NOT name='sqlite_sequence' ORDER BY namec S s" g | ] }t |d |d d ��qS )r r r )�.0�rowr r r � <listcomp>V s " z8DatabaseIntrospection.get_table_list.<locals>.<listcomp>)�execute�fetchall)r9 �cursorr r r �get_table_listL s �z$DatabaseIntrospection.get_table_listc s� |� d| jj�|� � |�� }|std|� d���| �||�� t� �| jjj rF|D ]}|d }d| }|� d||g�� � }|rE�� |� q*� �fdd�|D �S ) zi Return a description of the table with the DB-API cursor.description interface. �PRAGMA table_info(%s)zTable z does not exist (empty pragma).r z%%json_valid("%s")%%z� SELECT sql FROM sqlite_master WHERE type = 'table' AND name = %s AND sql LIKE %s c sH g | ] \}}}}}}t ||t|�d d d | |� �|�|dk|�v � �qS )Nr )r r �get)rI �cidr rD �notnull�defaultr �� collations� json_columnsr r rK v s ���z?DatabaseIntrospection.get_table_description.<locals>.<listcomp>) rL � connection�ops� quote_namerM r �_get_column_collations�set�features�can_introspect_json_field�fetchone�add)r9 rN � table_name� table_info�line�column�json_constraint_sqlr r rU r �get_table_descriptionX s0 � � � � �z+DatabaseIntrospection.get_table_descriptionr c C s | � ||�}||d�gS )N)�tablerd )�get_primary_key_column)r9 rN ra � table_fields�pk_colr r r � get_sequences� s z#DatabaseIntrospection.get_sequencesc C �* |� d| jj�|� � dd� |�� D �S )z� Return a dictionary of {column_name: (ref_column_name, ref_table_name)} representing all foreign keys in the given table. zPRAGMA foreign_key_list(%s)c S s" i | ] ^}}}}}}|||f�qS r r )rI �_�ref_table_name� column_name�ref_column_namer r r � <dictcomp>� s ��z7DatabaseIntrospection.get_relations.<locals>.<dictcomp>�rL rX rY rZ rM �r9 rN ra r r r � get_relations� s � �z#DatabaseIntrospection.get_relationsc C rl )NrP c S s g | ] �^}}}}|r|�qS r r )rI rm r r r r r rK � � zADatabaseIntrospection.get_primary_key_columns.<locals>.<listcomp>rr rs r r r �get_primary_key_columns� s �z-DatabaseIntrospection.get_primary_key_columnsc C s� d }d }d }d }d}g }d} g } d} |D �]!}|� tjjd�r$| d7 } n"|� tjjd�r8| d8 } | dk r7 �n n| dkrF|� tjjd�rF n�|d u rU|� tjjd�}|rUq|r�|d u rz|jtjjtjjfv rj|j}n|jtjjj j krz|jdd� }|� tjjd �r�d }| } n_|r�| | kr�|r�d}q|jtjjtjjfv r�|� |j� nB|jtjjj j kr�|� |jdd� � n.|d u r�|jtjjtjjfv r�|j}n|jtjjj j kr�|jdd� }|� tjjd �r�|g}|� tjjd �r�d } | } q| �r6| | kr�| r�d} q|jtjjtjjfv �r|j|v �r| � |j� q|jtjjj j k�r6|jdd� |v �r6| � |jdd� � q|�rCd |dd ddd �nd }| �rQd | ddd dd �nd }||||fS )NFr r4 r �)�,� CONSTRAINT����UNIQUET�CHECK)�unique�columns� primary_key� foreign_key�check�index)r� r~ r r} r� r� ) �match�sqlparse�tokens� Punctuation�Keyword�ttype�Name�value�Literal�String�Symbol�append)r9 r� r~ �token�is_constraint_definition� field_name�constraint_namer} �unique_columnsr� � check_columns� braces_deep�unique_braces_deep�check_braces_deep�unique_constraint�check_constraintr r r �&_parse_column_or_constraint_definition� s� ��� �� �� ��� � z<DatabaseIntrospection._parse_column_or_constraint_definitionc C s� t �|�d }i }d}dd� |�� D �}|D ] }|�t jjd�r" nq | �||�\}} } } | rA|r7| ||< n |d7 }| |d| < | rT|rJ| ||< n |d7 }| |d| < | �t jjd�r_ |S q$) Nr c s s � | ]}|j s|V qd S �N)� is_whitespace)rI r� r r r � <genexpr> s � zADatabaseIntrospection._parse_table_constraints.<locals>.<genexpr>r4 Tr z__unnamed_constraint_%s__rw )r� �parse�flattenr� r� r� r� ) r9 �sqlr~ � statement� constraints�unnamed_constrains_indexr� r� r� r} r� � end_tokenr r r �_parse_table_constraints sF � � �� ���z.DatabaseIntrospection._parse_table_constraintsc C s� i }z|� d| jj�|�f ��� d }W n ty Y nw dd� | �||�D �}|�| �||�� |� d| jj�|� � |� � D ]m}|dd� \}}} |� d| jj�|� � |�� p_d \} | sdqC|� d | jj�|� � |� � D ] \} } } ||vr�g d t | �dd d d �||< || d � | � qt|| d r�t j || d< | �| �}|dur�||| d< qC| �||�}|r�|d d dd d d �|d< t| �||��� �}|�dd� |D �� |S )zu Retrieve any constraints or keys (unique, pk, fk, check, index) across one or more columns. z<SELECT sql FROM sqlite_master WHERE type='table' and name=%sr c S s h | ]}|j �qS r )r �rI �infor r r � <setcomp>@ s �z8DatabaseIntrospection.get_constraints.<locals>.<setcomp>zPRAGMA index_list(%s)N� z<SELECT sql FROM sqlite_master WHERE type='index' AND name=%sr� zPRAGMA index_info(%s)FT�r~ r r} r� r� r� r~ r� �type�orders� __primary__c S s8 i | ]\}\}\}}d |� �|gdd||fddd��qS )�fk_Fr� r )rI r� ro rp rn r r r rq � s ���z9DatabaseIntrospection.get_constraints.<locals>.<dictcomp>)rL rX rY rZ r_ � TypeErrorrf �updater� rM r r� r �suffix�_get_index_columns_ordersrv � enumeratert �items)r9 rN ra r� � table_schemar~ rJ �numberr� r} r� � index_rank� column_rankrd r� � pk_columns� relationsr r r �get_constraints0 s� ��� � �� ��� � � � �� z%DatabaseIntrospection.get_constraintsc C sP t �|�d }|D ] }t|t jj�r%t|��d��d�}dd� |D � S q d S )Nr �()�, c S s g | ] }|� d �r d nd�qS )�DESC�ASC)�endswithr� r r r rK � ru zCDatabaseIntrospection._get_index_columns_orders.<locals>.<listcomp>)r� r� � isinstancer� � Parenthesis�strr7 r6 )r9 r� r� r� r~ r r r r� � s �z/DatabaseIntrospection._get_index_columns_ordersc C s� |� d|g��� }|s i S |d }tt�|�d d ��d��d�}i }|D ],}|dd � �� }|d �d�} t|�D ]\} } | dkrK|| d } nq;d } | || < q&|S ) Nzn SELECT sql FROM sqlite_master WHERE type = 'table' AND name = %s r rz r� r� r �"�COLLATE)rL r_ r� r� r� r7 r6 r� ) r9 rN ra rJ r� r~ rV rd r� ro r� r� � collationr r r r[ � s, ��" � z,DatabaseIntrospection._get_column_collations)r )r< r= r> r �data_types_reverserC rO rf rk rt rv r� r� r� r� r[ � __classcell__r r rG r r? ; s /d'ar? )� collectionsr r� � django.dbr �%django.db.backends.base.introspectionr r � BaseFieldInfor �django.db.modelsr �django.utils.regex_helperr �_fieldsr r r r? r r r r �<module> s �
| ver. 1.4 |
Github
|
.
| PHP 8.2.28 | Generation time: 0.02 |
proxy
|
phpinfo
|
Settings