
    gr<                         d dl mZ d dlmZ d dlmZ d dlmZ d dlmZ	 d dl
mZ  edej                  dz         Z ed	e	j                  d
z         Z G d de      Zy)    )
namedtuple)models)BaseDatabaseIntrospection)	FieldInfo)	TableInfo)oracledbr   )is_autofieldis_jsoncommentr   )r   c                   r    e Zd ZdZej
                  dej                  dej                  dej                  dej                  dej                  dej                  dej                  dej                  dej                  dej                  d	ej                   diZ fd
Zd Zd Zd ZddZd Zd Zd Z xZS )DatabaseIntrospection   	DateField
FloatFieldBinaryField	CharField	TextFieldDurationFieldDecimalFieldDateTimeFieldc                 8   |t         j                  k(  rW|dd \  }}|dk(  rD|dkD  r|j                  rdS dS d|cxk  rdk  rn n|j                  ry|dk(  ry	|j                  ry
y|dk(  r!y|t         j                  k(  r|j                  ryt
        |   ||      S )N      r      BigAutoFieldBigIntegerFieldr   SmallAutoFieldBooleanField	AutoFieldIntegerFieldir   	JSONField)r   NUMBERr	   NCLOBr
   superget_field_type)self	data_typedescription	precisionscale	__class__s        /var/www/python.vincentserveurtest.ovh/public_html/venv/lib/python3.12/site-packages/django/db/backends/oracle/introspection.pyr%   z$DatabaseIntrospection.get_field_type"   s    '*1Q/Iuzr> '33 ' /
 &Q&;+C+C+!^) --&)$#(..([-@-@w%i==    c           	          |j                  d       |j                         D cg c]'  }t        | j                  |d         |d   |d         ) c}S c c}w )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
        r   r      )executefetchallr   identifier_converter)r&   cursorrows      r,   get_table_listz$DatabaseIntrospection.get_table_list;   sa    	
0 (
( d//A7QQH(
 	
 
s   ,Ac                    |j                  d|||g       |j                         }|r|d   nd}|j                  d||g       |j                         D 	
ci c]*  \  }}}}}	}
}|||r|dk7  r|j                         nd||	|
|f, }}
}	}}}}}| xj                  dz  c_        |j                  dj                  | j                  j                  j                  |      | j                               g }|j                  D ]h  }|d   }||   \  }}}}	}
}|i z  }|j                  t        | j                  |      |d   ||d	   |d
   xs d|d   xs dg|dd |||	|
|        j |S c c}}
}	}}}}w )zi
        Return a description of the table with the DB-API cursor.description
        interface.
        a  
            SELECT user_tables.default_collation
            FROM user_tables
            WHERE
                user_tables.table_name = UPPER(%s) AND
                NOT EXISTS (
                    SELECT 1
                    FROM user_mviews
                    WHERE user_mviews.mview_name = user_tables.table_name
                )
            UNION ALL
            SELECT user_views.default_collation
            FROM user_views
            WHERE user_views.view_name = UPPER(%s)
            UNION ALL
            SELECT user_mviews.default_collation
            FROM user_mviews
            WHERE user_mviews.mview_name = UPPER(%s)
            r    a  
            SELECT
                user_tab_cols.column_name,
                user_tab_cols.data_default,
                CASE
                    WHEN user_tab_cols.collation = %s
                    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_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)
            NULLNr   z,SELECT * FROM {} WHERE ROWNUM < 2 AND {} > 0   r      r   )r0   fetchoner1   rstripcache_bust_counterformat
connectionops
quote_namer(   appendr   r2   )r&   r3   
table_namer4   default_table_collationcolumndefault	collationdisplay_sizer	   r
   r   	field_mapr(   descnames                   r,   get_table_descriptionz+DatabaseIntrospection.get_table_descriptionX   s	    	& Z0)	
, oo,/#a&R$J %j1M'	
r "#
 
" # $+60A t   ## 	 
& 	1$:AA##..z:D<S<S	

 &&D7D $BJD--d3G GGLqGLq !"X   !   '6 k
 
s   /E0c                 "    |j                         S )z7Identifier comparison is case insensitive under Oracle.)lower)r&   rK   s     r,   r2   z*DatabaseIntrospection.identifier_converter   s    zz|r-   c                 *   |j                  d|g       |j                         }|r:| j                  |d         | j                  |      | j                  |d         dgS |D ].  }t        |t        j
                        s||j                  dgc S  g 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   )rK   tablerE   )rP   rE   )r0   r;   r2   
isinstancer   r   rE   )r&   r3   rC   table_fieldsr4   fs         r,   get_sequencesz#DatabaseIntrospection.get_sequences   s     L!	
& oo !55c!f=!66zB"77A?  A!V--.",ABB  	r-   c           
         |j                         }|j                  d|g       |j                         D ci c]8  \  }}}| j                  |      | j                  |      | j                  |      f: c}}}S c c}}}w )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.position)upperr0   r1   r2   )r&   r3   rC   
field_namerel_table_namerel_field_names         r,   get_relationsz#DatabaseIntrospection.get_relations   s    
  %%'
( L		
  ?Eoo>O

 ?P:
NN	 %%j1)).9)).94  ?P
 	
 
s   =A:c                     |j                  d|g       |j                         D cg c]  }| j                  |d          c}S c c}w )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
            r   )r0   r1   r2   )r&   r3   rC   r4   s       r,   get_primary_key_columnsz-DatabaseIntrospection.get_primary_key_columns  sM     L	
  >D__=NO=Nc))#a&1=NOOOs   Ac                 ^   i }|j                  d|g       |j                         D ]4  \  }}}}}| j                  |      }|j                  d      ||d||d||<   6 |j                  d|g       |j                         D ]5  \  }}}	}
| j                  |      }dd|	|
fdd|j                  d      d||<   7 |j                  d|g       |j                         D ]O  \  }}}}}| j                  |      }d|d	k(  ddd
|dk(  rdn||j                  d      |j                  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)r`   ra   rb   rc   rd   r_   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
            ra   Tnormalidx)r`   ra   rb   rc   rd   typer_   orders)r0   r1   r2   split)r&   r3   rC   constraints
constraintr_   pkra   rc   other_tableother_columntype_rh   s                r,   get_constraintsz%DatabaseIntrospection.get_constraints*  s   
 6 L9	
< 7=oo6G2JVU22:>J"==-! #'K
# 7H 	( L+	
. ?Eoo>O:Jl22:>J$ +\:"==-'K
# ?P 	& L)	
, ;A//:K6Jvw22:>J$ H,#!&(!2"==- ,,s+	'K
# ;L r-   ) )__name__
__module____qualname__r=   r   DB_TYPE_DATEDB_TYPE_BINARY_DOUBLEDB_TYPE_BLOBDB_TYPE_CHARDB_TYPE_CLOBDB_TYPE_INTERVAL_DSDB_TYPE_NCHARDB_TYPE_NCLOBDB_TYPE_NVARCHARDB_TYPE_NUMBERDB_TYPE_TIMESTAMPDB_TYPE_VARCHARdata_types_reverser%   r5   rL   r2   rT   rZ   r\   rp   __classcell__)r+   s   @r,   r   r      s     	{&&}{{$$o!!;""O  +>2
:||"H
2P&tr-   r   N)collectionsr   	django.dbr   %django.db.backends.base.introspectionr   r   BaseFieldInfor   BaseTableInfo&django.db.backends.oracle.oracledb_anyr   _fieldsr   rq   r-   r,   <module>r      sZ    "  K L L ;&&)OO	 {M$9$9L$HI	O5 Or-   