OwlCyberSecurity - MANAGER
Edit File: introspection.cpython-39.pyc
a ���e�< � @ s� d dl mZ d dlZd dlmZ d dlmZ d dlmZ d dlm Z d dl m Z edej d �Zed e j d �Z G d d � d e�ZdS )� )� namedtupleN)�models)�BaseDatabaseIntrospection)� FieldInfo)� TableInfo)�cached_propertyr )� is_autofield�is_json�commentr )r c sf e Zd ZdZedd� �Z� fdd�Zdd� Zdd � Zd d � Z dd d�Z dd� Z dd� Z dd� Z � ZS )�DatabaseIntrospection� c C s� | j jdk rXtjdtjdtjdtjdtjdtjdtj dtj dtj dtj dtj dtjd i S tjdtjdtjdtjdtjdtjdtjdtjdtjdtjdtjd tjdi S d S ) N)� Z BinaryFieldZ TextFieldZ DateFieldZ CharFieldZ DurationField� FloatFieldZ DecimalFieldZ DateTimeField)� connectionZcx_oracle_version� cx_OracleZBLOBZCLOBZDATETIMEZ FIXED_CHARZ FIXED_NCHARZINTERVALZ NATIVE_FLOATZNCHAR�NCLOB�NUMBER�STRING� TIMESTAMPZ DB_TYPE_DATEZDB_TYPE_BINARY_DOUBLEZ DB_TYPE_BLOBZ DB_TYPE_CHARZ DB_TYPE_CLOBZDB_TYPE_INTERVAL_DSZ DB_TYPE_NCHARZ DB_TYPE_NCLOBZDB_TYPE_NVARCHARZDB_TYPE_NUMBERZDB_TYPE_TIMESTAMPZDB_TYPE_VARCHAR��self� r �h/home/gouroczh/virtualenv/pat/3.9/lib/python3.9/site-packages/django/db/backends/oracle/introspection.py�data_types_reverse s6 ��z(DatabaseIntrospection.data_types_reversec s� |t jkr�|dd� \}}|dkrv|dkr8|jr4dS dS d| k rLdk rZn n |jrZdS |dkrfd S |jrpd S d S q�|d kr�d S n|t jkr�|jr�dS t� �||�S )N� � r � Z BigAutoFieldZBigIntegerFieldr ZSmallAutoFieldZ BooleanField� AutoFieldZ IntegerFieldi����r Z JSONField)r r r r r �super�get_field_type)r Z data_type� description� precision�scale�� __class__r r r 6 s( �� z$DatabaseIntrospection.get_field_typec s |� d� � fdd�|�� D �S )z>Return a list of table and view names in the current database.a� SELECT user_tables.table_name, 't', user_tab_comments.comments FROM user_tables LEFT OUTER JOIN user_tab_comments ON user_tab_comments.table_name = user_tables.table_name WHERE NOT EXISTS ( SELECT 1 FROM user_mviews WHERE user_mviews.mview_name = user_tables.table_name ) UNION ALL SELECT view_name, 'v', NULL FROM user_views UNION ALL SELECT mview_name, 'v', NULL FROM user_mviews c s* g | ]"}t � �|d �|d |d ��qS )r r � )r �identifier_converter��.0�rowr r r � <listcomp>g s �z8DatabaseIntrospection.get_table_list.<locals>.<listcomp>��execute�fetchall)r �cursorr r r �get_table_listO s � �z$DatabaseIntrospection.get_table_listc C s� |� d|g� dd� |�� D �}| jd7 _|� d�| jj�|�| j�� g }|jD ]�}|d }|| \}}} } } } |i ; }|�t | � |�|d ||d |d p�d|d p�dg|d d � �|�| �| �| �| �R � � qV|S ) zi Return a description of the table with the DB-API cursor.description interface. aS SELECT user_tab_cols.column_name, user_tab_cols.data_default, CASE WHEN user_tab_cols.collation = user_tables.default_collation THEN NULL ELSE user_tab_cols.collation END collation, CASE WHEN user_tab_cols.char_used IS NULL THEN user_tab_cols.data_length ELSE user_tab_cols.char_length END as display_size, CASE WHEN user_tab_cols.identity_column = 'YES' THEN 1 ELSE 0 END as is_autofield, CASE WHEN EXISTS ( SELECT 1 FROM user_json_columns WHERE user_json_columns.table_name = user_tab_cols.table_name AND user_json_columns.column_name = user_tab_cols.column_name ) THEN 1 ELSE 0 END as is_json, user_col_comments.comments as col_comment FROM user_tab_cols LEFT OUTER JOIN user_tables ON user_tables.table_name = user_tab_cols.table_name LEFT OUTER JOIN user_col_comments ON user_col_comments.column_name = user_tab_cols.column_name AND user_col_comments.table_name = user_tab_cols.table_name WHERE user_tab_cols.table_name = UPPER(%s) c S s8 i | ]0\}}}}}}}|||d kr&|nd||||f�qS )ZNULLNr )r( �column�default� collation� display_sizer r r r r r � <dictcomp>� s ��z?DatabaseIntrospection.get_table_description.<locals>.<dictcomp>r z,SELECT * FROM {} WHERE ROWNUM < 2 AND {} > 0r � r � r N) r, r- �cache_bust_counter�formatr �opsZ quote_namer �appendr r& ) r r. � table_nameZ field_mapr �desc�namer3 r1 r2 r r r r r r �get_table_descriptionl s` '�*��� � � �� � � � ��z+DatabaseIntrospection.get_table_descriptionc C s |� � S )z7Identifier comparison is case insensitive under Oracle.)�lower)r r= r r r r& � s z*DatabaseIntrospection.identifier_converterr c C sn |� d|g� |�� }|rB| �|d �| �|�| �|d �d�gS |D ]"}t|tj�rF||jd�g S qFg S )Na� SELECT user_tab_identity_cols.sequence_name, user_tab_identity_cols.column_name FROM user_tab_identity_cols, user_constraints, user_cons_columns cols WHERE user_constraints.constraint_name = cols.constraint_name AND user_constraints.table_name = user_tab_identity_cols.table_name AND cols.column_name = user_tab_identity_cols.column_name AND user_constraints.constraint_type = 'P' AND user_tab_identity_cols.table_name = UPPER(%s) r r )r= �tabler0 )r@ r0 )r, Zfetchoner& � isinstancer r r0 )r r. r; Z table_fieldsr) �fr r r � get_sequences� s � �� z#DatabaseIntrospection.get_sequencesc s, |� � }|�d|g� � fdd�|�� D �S )z� Return a dictionary of {field_name: (field_name_other_table, other_table)} representing all foreign keys in the given table. ab SELECT ca.column_name, cb.table_name, cb.column_name FROM user_constraints, USER_CONS_COLUMNS ca, USER_CONS_COLUMNS cb WHERE user_constraints.table_name = %s AND user_constraints.constraint_name = ca.constraint_name AND user_constraints.r_constraint_name = cb.constraint_name AND ca.position = cb.positionc s. i | ]&\}}}� � |�� � |�� � |�f�qS r �r& )r( � field_nameZrel_table_nameZrel_field_namer r r r4 s ��z7DatabaseIntrospection.get_relations.<locals>.<dictcomp>)�upperr, r- �r r. r; r r r � get_relations� s � �z#DatabaseIntrospection.get_relationsc s$ |� d|g� � fdd�|�� D �S )Na� SELECT cols.column_name FROM user_constraints, user_cons_columns cols WHERE user_constraints.constraint_name = cols.constraint_name AND user_constraints.constraint_type = 'P' AND user_constraints.table_name = UPPER(%s) ORDER BY cols.position c s g | ]}� � |d ��qS )r rD r' r r r r* % � zADatabaseIntrospection.get_primary_key_columns.<locals>.<listcomp>r+ rG r r r �get_primary_key_columns s �z-DatabaseIntrospection.get_primary_key_columnsc C s i }|� d|g� |�� D ]4\}}}}}| �|�}|�d�||d||d�||< q|� d|g� |�� D ]6\}}} } | �|�}dd| | fdd|�d�d�||< qf|� d|g� |�� D ]N\}} }}} | �|�}d|d kddd | d kr�d n| |�d�| �d�d �||< q�|S )zu Retrieve any constraints or keys (unique, pk, fk, check, index) across one or more columns. aL SELECT user_constraints.constraint_name, LISTAGG(LOWER(cols.column_name), ',') WITHIN GROUP (ORDER BY cols.position), CASE user_constraints.constraint_type WHEN 'P' THEN 1 ELSE 0 END AS is_primary_key, CASE WHEN user_constraints.constraint_type IN ('P', 'U') THEN 1 ELSE 0 END AS is_unique, CASE user_constraints.constraint_type WHEN 'C' THEN 1 ELSE 0 END AS is_check_constraint FROM user_constraints LEFT OUTER JOIN user_cons_columns cols ON user_constraints.constraint_name = cols.constraint_name WHERE user_constraints.constraint_type = ANY('P', 'U', 'C') AND user_constraints.table_name = UPPER(%s) GROUP BY user_constraints.constraint_name, user_constraints.constraint_type �,N)�columns� primary_key�unique� foreign_key�check�indexa SELECT cons.constraint_name, LISTAGG(LOWER(cols.column_name), ',') WITHIN GROUP (ORDER BY cols.position), LOWER(rcols.table_name), LOWER(rcols.column_name) FROM user_constraints cons INNER JOIN user_cons_columns rcols ON rcols.constraint_name = cons.r_constraint_name AND rcols.position = 1 LEFT OUTER JOIN user_cons_columns cols ON cons.constraint_name = cols.constraint_name WHERE cons.constraint_type = 'R' AND cons.table_name = UPPER(%s) GROUP BY cons.constraint_name, rcols.table_name, rcols.column_name F)rM rN rO rP rQ rL a SELECT ind.index_name, LOWER(ind.index_type), LOWER(ind.uniqueness), LISTAGG(LOWER(cols.column_name), ',') WITHIN GROUP (ORDER BY cols.column_position), LISTAGG(cols.descend, ',') WITHIN GROUP (ORDER BY cols.column_position) FROM user_ind_columns cols, user_indexes ind WHERE cols.table_name = UPPER(%s) AND NOT EXISTS ( SELECT 1 FROM user_constraints cons WHERE ind.index_name = cons.index_name ) AND cols.index_name = ind.index_name GROUP BY ind.index_name, ind.index_type, ind.uniqueness rN T�normal�idx)rM rN rO rP rQ �typerL �orders)r, r- r& �split) r r. r; � constraints� constraintrL �pkrN rP Z other_tableZ other_column�type_rU r r r �get_constraints' sV � � � � � � z%DatabaseIntrospection.get_constraints)r )�__name__� __module__� __qualname__r7 r r r r/ r> r& rC rH rJ r[ � __classcell__r r r# r r s g $r )� collectionsr r Z django.dbr Z%django.db.backends.base.introspectionr r Z BaseFieldInfor Z BaseTableInfoZdjango.utils.functionalr �_fieldsr r r r r �<module> s �