o Fhr<@s|ddlmZddlmZddlmZddlmZddlmZ ddl m Z edej dZed e j d ZGd d d eZ d S)) namedtuple)models)BaseDatabaseIntrospection) FieldInfo) TableInfo)oracledbr) is_autofieldis_jsoncommentr)r cseZdZdZejdejdejdejdej dej dej dej dej dejdejd ejdi Zfd d Zd d ZddZddZdddZddZddZddZZS)DatabaseIntrospection DateField FloatField BinaryField CharField TextField DurationField DecimalField DateTimeFieldcs|tjkrA|dd\}}|dkr:|dkr|jrdSdSd|kr&dkr-nn|jr-dS|dkr3d S|jr8d Sd S|d kr@d Sn |tjkrK|jrKdSt||S)Nr BigAutoFieldBigIntegerFieldr SmallAutoField BooleanField AutoField IntegerFieldir JSONField)rNUMBERrNCLOBr superget_field_type)self data_type description precisionscale __class__`/var/www/html/loop/nvenv/lib/python3.10/site-packages/django/db/backends/oracle/introspection.pyr""s, z$DatabaseIntrospection.get_field_typecs |dfdd|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 cs*g|]}t|d|d|dqS)rr )ridentifier_converter.0rowr#r*r+ Ssz8DatabaseIntrospection.get_table_list..executefetchall)r#cursorr*r1r+get_table_list;s  z$DatabaseIntrospection.get_table_listc Cs |d|||g|}|r|dnd}|d||gdd|D}|jd7_|d|jj||jg}|jD]A}|d}||\} } } } } }|i;}| t | ||d| |d |d phd|d pmdg|d d | | | | |RqA|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 Ss@i|]\}}}}}}}|||r|dkr|nd||||fqS)NULLN)rstrip)r/columndefault collation display_sizerr r r*r*r+ s$ z?DatabaseIntrospection.get_table_description..r z,SELECT * FROM {} WHERE ROWNUM < 2 AND {} > 0rrN) r4fetchoner5cache_bust_counterformat connectionops quote_namer%appendrr-)r#r6 table_namer0default_table_collation field_mapr%descnamer>r<r=rr r r*r*r+get_table_descriptionXsl%(        z+DatabaseIntrospection.get_table_descriptioncCs|S)z7Identifier comparison is case insensitive under Oracle.)lower)r#rMr*r*r+r-sz*DatabaseIntrospection.identifier_converterr*cCsn|d|g|}|r!||d||||ddgS|D]}t|tjr4||jdgSq#gS)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) rr )rMtabler;)rPr;)r4rBr- isinstancerrr;)r#r6rI table_fieldsr0fr*r*r+ get_sequencess    z#DatabaseIntrospection.get_sequencescs,|}|d|gfdd|DS)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.positioncs.i|]\}}}|||fqSr*r-)r/ field_namerel_table_namerel_field_namer1r*r+r?sz7DatabaseIntrospection.get_relations..)upperr4r5r#r6rIr*r1r+ get_relationss z#DatabaseIntrospection.get_relationscs$|d|gfdd|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 csg|] }|dqS)rrUr.r1r*r+r2(szADatabaseIntrospection.get_primary_key_columns..r3rZr*r1r+get_primary_key_columnss  z-DatabaseIntrospection.get_primary_key_columnsc Csi}|d|g|D]\}}}}}||}|d||d||d||<q |d|g|D]\}}} } ||}dd| | fdd|dd||<q3|d|g|D]'\}} }}} ||}d|d kddd | d krsd n| |d| dd ||<qZ|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)r_r`rarbrcr^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 r`Tnormalidx)r_r`rarbrctyper^orders)r4r5r-split) r#r6rI constraints constraintr^pkr`rb other_table other_columntype_rgr*r*r+get_constraints*sV         z%DatabaseIntrospection.get_constraints)r*)__name__ __module__ __qualname__rCr 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"r7rNr-rTr[r\ro __classcell__r*r*r(r+r s. ~ $r N) collectionsr django.dbr%django.db.backends.base.introspectionrr BaseFieldInfor BaseTableInfo&django.db.backends.oracle.oracledb_anyr_fieldsr r*r*r*r+s