j\<ddlmZddlmZddlmZddlmZddlmZ ddl m Z edej dzZed e j d zZGd d eZ d S)) namedtuple)models)BaseDatabaseIntrospection) FieldInfo) TableInfo)oracledbr) is_autofieldis_jsoncommentr)r ceZdZdZejdejdejdejdej dej dej dej dej dejdejd ejdi Zfd Zd Zd Zd ZddZdZdZdZxZS)DatabaseIntrospection DateField FloatField BinaryField CharField TextField DurationField DecimalField DateTimeFieldcL|tjkrY|dd\}}|dkr=|dkr |jrdndSd|cxkrdkr nn |jrdS|dkrd S|jrd Sd S|d krd Sn|tjkr |jrdSt ||S)Nr BigAutoFieldBigIntegerFieldrSmallAutoField BooleanField AutoField IntegerFieldir JSONField)rNUMBERr NCLOBr superget_field_type)self data_type description precisionscale __class__s t/var/www/finuniver-perm.ru/html/student/venv/lib/python3.11/site-packages/django/db/backends/oracle/introspection.pyr%z$DatabaseIntrospection.get_field_type"s  ' '*1Q3/ Iuzzr>>'3/. &&&&Q&&&&&;+C&++!^^)> -*&;)>$#| (. ( ([-@ (;ww%%i===cn|dfd|DS)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|g|]8}t|d|d|d9S)rr)ridentifier_converter.0rowr&s r, z8DatabaseIntrospection.get_table_list..QsO    d//A77QQ H H   r-executefetchall)r&cursors` r,get_table_listz$DatabaseIntrospection.get_table_list;sS    (    ((    r-c |d|||g|}|r|dnd}|d||gd|D}|xjdz c_|d|jj||jg}|jD]}|d}||\} } } } } }|iz}| t| ||d| |d|d pd|d pdg|d d | | | | |R|S) 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) ra 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) c hi|]/\}}}}}}}|||r|dkr|nd||||f0S)NULLN)rstrip)r3columndefault collation display_sizer r r s r, z?DatabaseIntrospection.get_table_description..st    $+K60A0A   t    r-rz,SELECT * FROM {} WHERE ROWNUM < 2 AND {} > 0rrN) r7fetchoner8cache_bust_counterformat connectionops quote_namer(appendrr1)r&r9 table_namer4default_table_collation field_mapr(descnamerCrArBr r r s r,get_table_descriptionz+DatabaseIntrospection.get_table_descriptionVs  &Z 0)   ,oo,/"7#a&&R$ J%j 1M' ' ' P  """#   & 1$ : A A#..z::D. sf   ; NN  % %j 1 1)).99)).994   r-)upperr7r8r&r9rNs` r, get_relationsz#DatabaseIntrospection.get_relationssp  %%''  (L     ?Eoo>O>O     r-cr|d|gfd|DS)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 cFg|]}|dS)rr_r2s r,r5zADatabaseIntrospection.get_primary_key_columns..&s+OOOc))#a&11OOOr-r6rds` r,get_primary_key_columnsz-DatabaseIntrospection.get_primary_key_columnssL L   POOOV__=N=NOOOOr-c i}|d|g|D]<\}}}}}||}|d||d||d||<=|d|g|D]=\}}} } ||}dd| | fdd|dd||<>|d|g|D]]\}} }}} ||}d|d kddd | d krd n| |d| dd ||<^|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_keyunique foreign_keycheckindexa 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)rlrmrnrorprka 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 rmTnormalidx)rlrmrnrorptyperkorders)r7r8r1split) r&r9rN constraints constraintrkpkrmro other_table other_columntype_rts r,get_constraintsz%DatabaseIntrospection.get_constraints(s   6L9   <7=oo6G6G   2JVU22:>>J"==--! # ''K # #  (L+   .?Eoo>O>O   :Jl22:>>J$ +\:"==-- ''K # #  &L)   ,;A//:K:K   6Jvw22:>>J$ H,#!&(!2!2"==-- ,,s++ ' 'K # #r-)rV)__name__ __module__ __qualname__rHr DB_TYPE_DATEDB_TYPE_BINARY_DOUBLE DB_TYPE_BLOB DB_TYPE_CHAR DB_TYPE_CLOBDB_TYPE_INTERVAL_DS DB_TYPE_NCHAR DB_TYPE_NCLOBDB_TYPE_NVARCHARDB_TYPE_NUMBERDB_TYPE_TIMESTAMPDB_TYPE_VARCHARdata_types_reverser%r:rSr1r\rerhr| __classcell__)r+s@r,r r s% {& }{{$o  !;"O + >>>>>2   6||||""""H   2PPP&tttttttr-r N) collectionsr django.dbr%django.db.backends.base.introspectionrr BaseFieldInfor BaseTableInfo&django.db.backends.oracle.oracledb_anyr_fieldsr rVr-r,rs""""""KKKKKKLLLLLLLLLLLL;;;;;; J&)OO    J{M$9L$H I I MMMMM5MMMMMr-