o lf<@sddlmZddlZddlmZddlmZddlmZddlm Z ddl m Z edej d Zed e j d Z Gd d d eZdS)) namedtupleN)models)BaseDatabaseIntrospection) FieldInfo) TableInfo)cached_propertyr) is_autofieldis_jsoncommentr)r csfeZdZdZeddZfddZddZdd Zd d Z dd dZ ddZ ddZ ddZ ZS)DatabaseIntrospectioncCs|jjdkr,tjdtjdtjdtjdtjdtjdtj dtj dtj dtj dtj dtjd i Stjdtjdtjdtjdtjdtjdtjdtjdtjdtjdtjd tjdi S) N) BinaryField TextField DateField CharField DurationField FloatField DecimalField DateTimeField) connectioncx_oracle_version cx_OracleBLOBCLOBDATETIME FIXED_CHAR FIXED_NCHARINTERVAL NATIVE_FLOATNCHARNCLOBNUMBERSTRING TIMESTAMP 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_VARCHARselfr3k/var/www/ticemtrilhas/avaliacao_env/lib/python3.10/site-packages/django/db/backends/oracle/introspection.pydata_types_reverses6 z(DatabaseIntrospection.data_types_reversecs|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)rr"rr!r superget_field_type)r2 data_type description precisionscale __class__r3r4rA6s, 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.0rowr1r3r4 gsz8DatabaseIntrospection.get_table_list..executefetchall)r2cursorr3r1r4get_table_listOs  z$DatabaseIntrospection.get_table_listc Cs|d|gdd|D}|jd7_|d|jj||jg}|jD]A}|d}||\}}} } } } |i;}|t | ||d||d|dpRd|d pWdg|d d || | | | Rq+|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 Ss8i|]\}}}}}}}|||dkr|nd||||fqS)NULLNr3)rKcolumndefault collation display_sizerr r r3r3r4 s$ z?DatabaseIntrospection.get_table_description..r z,SELECT * FROM {} WHERE ROWNUM < 2 AND {} > 0rr6r7N) rOrPcache_bust_counterformatrops quote_namerCappendrrI) r2rQ table_name field_maprCdescnamerWrUrVrr r r3r3r4get_table_descriptionls`'*        z+DatabaseIntrospection.get_table_descriptioncCs|S)z7Identifier comparison is case insensitive under Oracle.)lower)r2rcr3r3r4rIsz*DatabaseIntrospection.identifier_converterr3cCsn|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 )rctablerT)rfrT)rOfetchonerI isinstancerr=rT)r2rQr` table_fieldsrLfr3r3r4 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|]\}}}|||fqSr3rI)rK field_namerel_table_namerel_field_namer1r3r4rX sz7DatabaseIntrospection.get_relations..)upperrOrPr2rQr`r3r1r4 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)rrlrJr1r3r4rM%szADatabaseIntrospection.get_primary_key_columns..rNrqr3r1r4get_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)rvrwrxryrzrua 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 rwTnormalidx)rvrwrxryrztyperuorders)rOrPrIsplit) r2rQr` constraints constraintrupkrwry other_table other_columntype_r~r3r3r4get_constraints'sV         z%DatabaseIntrospection.get_constraints)r3)__name__ __module__ __qualname__r[rr5rArRrdrIrkrrrsr __classcell__r3r3rFr4r s  g $r ) collectionsrr django.dbr%django.db.backends.base.introspectionrr BaseFieldInfor BaseTableInfodjango.utils.functionalr_fieldsr r3r3r3r4s