
    hr<                         S SK Jr  S SKJr  S SKJr  S SKJr  S SKJr	  S SK
Jr  \" S\R                  S-   5      r\" S	\	R                  S
-   5      r " S S\5      rg)    )
namedtuple)models)BaseDatabaseIntrospection)	FieldInfo)	TableInfo)oracledbr   )is_autofieldis_jsoncommentr   )r   c                   ~  ^  \ rS rSrSr\R                  S\R                  S\R                  S\R                  S\R                  S\R                  S\R                  S\R                  S\R                  S\R                  S	\R                   S
\R"                  S0rU 4S jrS rS rS rSS jrS rS rS rSrU =r$ )DatabaseIntrospection      	DateField
FloatFieldBinaryField	CharField	TextFieldDurationFieldDecimalFieldDateTimeFieldc                 n  > U[         R                  :X  al  USS u  p4US:X  aW  US:  a  UR                  (       a  S$ S$ SUs=:  a  S:  a  O  OUR                  (       a  gUS:X  a  g	UR                  (       a  g
gUS:X  a  gO&U[         R                  :X  a  UR                  (       a  g[
        TU ]  X5      $ )N      r      BigAutoFieldBigIntegerFieldr   SmallAutoFieldBooleanField	AutoFieldIntegerFieldir   	JSONField)r   NUMBERr	   NCLOBr
   superget_field_type)self	data_typedescription	precisionscale	__class__s        Y/var/www/html/env/lib/python3.13/site-packages/django/db/backends/oracle/introspection.pyr&   $DatabaseIntrospection.get_field_type"   s    '*1Q/Izr> '33 ' /
 &Q&;+C+C+!^) --&)$# (..([-@-@w%i==    c           	          UR                  S5        UR                  5        Vs/ s H(  n[        U R                  US   5      US   US   5      PM*     sn$ s  snf )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_list$DatabaseIntrospection.get_table_list;   sa    	
0 (
( d//A7QQH(
 	
 
s   /Ac                 $   UR                  SX"U/5        UR                  5       nU(       a  US   OSnUR                  SXB/5        UR                  5        VVVVV	V
Vs0 s H1  u  nnnnn	n
nUUU(       a  US:w  a  UR                  5       OSUU	U
U4_M3     nn
n	nnnnnU =R                  S-  sl        UR                  SR                  U R                  R                  R                  U5      U R                  5      5        / nUR                   Hr  nUS   nX   u  nnnn	n
nU0 -  nUR                  [        U R                  U5      US   UUS	   US
   =(       d    SUS   =(       d    S/USS QUPUPU	PU
PUP76 5        Mt     U$ s  snn
n	nnnnf )zQ
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   )r2   fetchoner3   rstripcache_bust_counterformat
connectionops
quote_namer)   appendr   r4   )r'   r5   
table_namer6   default_table_collationcolumndefault	collationdisplay_sizer	   r
   r   	field_mapr)   descnames                   r-   get_table_description+DatabaseIntrospection.get_table_descriptionX   s    	& Z0)	
, oo,/#a&R$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   8Fc                 "    UR                  5       $ )z7Identifier comparison is case insensitive under Oracle.)lower)r'   rN   s     r-   r4   *DatabaseIntrospection.identifier_converter   s    zz|r/    c                 @   UR                  SU/5        UR                  5       nU(       a:  U R                  US   5      U R                  U5      U R                  US   5      S./$ U H3  n[        U[        R
                  5      (       d  M$  X%R                  S./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   )rN   tablerH   )rV   rH   )r2   r>   r4   
isinstancer   r    rH   )r'   r5   rF   table_fieldsr6   fs         r-   get_sequences#DatabaseIntrospection.get_sequences   s     L!	
& oo !55c!f=!66zB"77A?  A!V--..",ABB  	r/   c           
         UR                  5       nUR                  SU/5        UR                  5        VVVs0 s H8  u  p4nU R                  U5      U R                  U5      U R                  U5      4_M:     snnn$ s  snnnf )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)upperr2   r3   r4   )r'   r5   rF   
field_namerel_table_namerel_field_names         r-   get_relations#DatabaseIntrospection.get_relations   s    
  %%'
( L		
  ?Eoo>O

 ?P:
N	 %%j1)).9)).94  ?P
 	
 
s   ?A<c                     UR                  SU/5        UR                  5        Vs/ s H  o0R                  US   5      PM     sn$ s  snf )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   )r2   r3   r4   )r'   r5   rF   r6   s       r-   get_primary_key_columns-DatabaseIntrospection.get_primary_key_columns  sK     L	
  >D__=NO=Nc))#a&1=NOOOs   Ac                 X   0 nUR                  SU/5        UR                  5        H2  u  pEpgnU R                  U5      nUR                  S5      UUSUUS.X4'   M4     UR                  SU/5        UR                  5        H2  u  pEpU R                  U5      nSSX4SSUR                  S5      S.X4'   M4     UR                  SU/5        UR                  5        HN  u  pKpunU R                  U5      nSUS	:H  SSS
US:X  a  SOUUR                  S5      UR                  S5      S.X4'   MP     U$ )z]
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)ri   rj   rk   rl   rm   rh   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
            rj   Tnormalidx)ri   rj   rk   rl   rm   typerh   orders)r2   r3   r4   split)r'   r5   rF   constraints
constraintrh   pkrj   rl   other_tableother_columntype_rq   s                r-   get_constraints%DatabaseIntrospection.get_constraints*  sm   
 6 L9	
< 7=oo6G2JU22:>J"==-! #'K# 7H 	( L+	
. ?Eoo>O:J22:>J$ +:"==-'K# ?P 	& L)	
, ;A//:K6Jv22:>J$ H,#!&(!2"==- ,,s+	'K# ;L r/   )rT   )__name__
__module____qualname____firstlineno__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&   r7   rO   r4   rZ   ra   rd   ry   __static_attributes____classcell__)r,   s   @r-   r   r      s     	{&&}{{$$o!!;""O  +>2
:||"H
2P&t tr/   r   N)collectionsr   	django.dbr   %django.db.backends.base.introspectionr   r   BaseFieldInfor   BaseTableInfo&django.db.backends.oracle.oracledb_anyr   _fieldsr   rT   r/   r-   <module>r      sZ    "  K L L ;&&)OO	 {M$9$9L$HI	O5 Or/   