3 (h,@s<ddlZddlmZmZmZddlmZGdddeZdS)N)BaseDatabaseIntrospection FieldInfo TableInfo) force_textcseZdZejdejdejdejdejdej dej dej diZ yde ej <Wnek r^YnXyde ej<Wnek rYnXdZfd d Zd d Zd dZddZddZddZddZddZddZZS)DatabaseIntrospectionZ BinaryFieldZ TextFieldZ DateFieldZ CharFieldZ DecimalFieldZ DateTimeField FloatFieldcs^|tjkrL|dd\}}|dkr@|dkr.dS|dkr:dSdSn |d krLd Stt|j||S) Nr ZBigIntegerFieldrZ BooleanFieldZ IntegerFieldri) cx_OracleNUMBERsuperrget_field_type)selfZ data_type descriptionZ precisionZscale) __class__K/tmp/pip-install-q3hcpn_q/Django/django/db/backends/oracle/introspection.pyr"s z$DatabaseIntrospection.get_field_typecCs|jddd|jDS)zQ Returns a list of table and view names in the current database. zWSELECT TABLE_NAME, 't' FROM USER_TABLES UNION ALL SELECT VIEW_NAME, 'v' FROM USER_VIEWScSs"g|]}t|dj|dqS)rr)rlower).0rowrrr 8sz8DatabaseIntrospection.get_table_list..)executefetchall)rcursorrrrget_table_list2s z$DatabaseIntrospection.get_table_listcCsx|jd7_|jdj|jjj||jg}xB|jD]8}t|d}|i}|jt |j f|ddq8W|S)zQReturns a description of the table, with the DB-API cursor.description interface.rz,SELECT * FROM {} WHERE ROWNUM < 2 AND {} > 0rN) cache_bust_counterrformat connectionopsZ quote_namerrappendrr)rr table_namerdescnamerrrget_table_description:s    $z+DatabaseIntrospection.get_table_descriptioncCs|jS)z6Table name comparison is case insensitive under Oracle)r)rr%rrrtable_name_converterGsz*DatabaseIntrospection.table_name_convertercCsddt|j||DS)zu Returns a dictionary of {field_name: field_index} for the given table. Indexes are 0-based. cSsi|]\}}||dqS)rr)ridrrr Psz8DatabaseIntrospection._name_to_index..) enumerater&)rrr#rrr_name_to_indexKsz$DatabaseIntrospection._name_to_indexcCsT|j}|jd|gi}x4|jD](}|dj|djf||dj<q$W|S)z Returns a dictionary of {field_name: (field_name_other_table, other_table)} representing all relationships to the given table. a SELECT ta.column_name, tb.table_name, tb.column_name FROM user_constraints, USER_CONS_COLUMNS ca, USER_CONS_COLUMNS cb, user_tab_cols ta, user_tab_cols tb WHERE user_constraints.table_name = %s AND ta.table_name = user_constraints.table_name AND ta.column_name = ca.column_name AND ca.table_name = ta.table_name AND user_constraints.constraint_name = ca.constraint_name AND user_constraints.r_constraint_name = cb.constraint_name AND cb.table_name = tb.table_name AND cb.column_name = tb.column_name AND ca.position = cb.positionrr)upperrrr)rrr#Z relationsrrrr get_relationsRs (z#DatabaseIntrospection.get_relationscCs$|jd|jgdd|jDS)Na SELECT ccol.column_name, rcol.table_name AS referenced_table, rcol.column_name AS referenced_column FROM user_constraints c JOIN user_cons_columns ccol ON ccol.constraint_name = c.constraint_name JOIN user_cons_columns rcol ON rcol.constraint_name = c.r_constraint_name WHERE c.table_name = %s AND c.constraint_type = 'R'cSsg|]}tdd|DqS)css|]}|jVqdS)N)r)rcellrrr tszCDatabaseIntrospection.get_key_columns...)tuple)rrrrrrtsz9DatabaseIntrospection.get_key_columns..)rr.r)rrr#rrrget_key_columnsksz%DatabaseIntrospection.get_key_columnscCsNd}|j||gi}x2|jD]&}t|dt|dd||d<q W|S)NaZ SELECT LOWER(uic1.column_name) AS column_name, CASE user_constraints.constraint_type WHEN 'P' THEN 1 ELSE 0 END AS is_primary_key, CASE user_indexes.uniqueness WHEN 'UNIQUE' THEN 1 ELSE 0 END AS is_unique FROM user_constraints, user_indexes, user_ind_columns uic1 WHERE user_constraints.constraint_type (+) = 'P' AND user_constraints.index_name (+) = uic1.index_name AND user_indexes.uniqueness (+) = 'UNIQUE' AND user_indexes.index_name (+) = uic1.index_name AND uic1.table_name = UPPER(%s) AND uic1.column_position = 1 AND NOT EXISTS ( SELECT 1 FROM user_ind_columns uic2 WHERE uic2.index_name = uic1.index_name AND uic2.column_position = 2 ) rr-) primary_keyuniquer)rrbool)rrr#Zsqlindexesrrrr get_indexesws z!DatabaseIntrospection.get_indexesc Csji}|jd|gxJ|jD]>\}}}}}||krHg||d|dd||<||dj|qW|jd|gxD|jD]8\}}||krgdddddd||<||dj|qvW|jd|gxL|jD]@\}}} } ||krgdd| | fddd||<||dj|qW|jd |gxH|jD]<\}}||krNgdddddd||<||dj|q&W|S) zn Retrieves any constraints or keys (unique, pk, fk, check, index) across one or more columns. a SELECT user_constraints.constraint_name, LOWER(cols.column_name) AS column_name, CASE user_constraints.constraint_type WHEN 'P' THEN 1 ELSE 0 END AS is_primary_key, CASE user_indexes.uniqueness WHEN 'UNIQUE' 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 INNER JOIN user_indexes ON user_indexes.index_name = user_constraints.index_name LEFT OUTER JOIN user_cons_columns cols ON user_constraints.constraint_name = cols.constraint_name WHERE ( user_constraints.constraint_type = 'P' OR user_constraints.constraint_type = 'U' ) AND user_constraints.table_name = UPPER(%s) ORDER BY cols.position NT)columnsr4r5Z foreign_keycheckindexr9a SELECT cons.constraint_name, LOWER(cols.column_name) AS column_name FROM user_constraints cons LEFT OUTER JOIN user_cons_columns cols ON cons.constraint_name = cols.constraint_name WHERE cons.constraint_type = 'C' AND cons.table_name = UPPER(%s) ORDER BY cols.position Fa SELECT cons.constraint_name, LOWER(cols.column_name) AS column_name, LOWER(rcons.table_name), LOWER(rcols.column_name) FROM user_constraints cons INNER JOIN user_constraints rcons ON cons.r_constraint_name = rcons.constraint_name INNER JOIN user_cons_columns rcols ON rcols.constraint_name = rcons.constraint_name 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) ORDER BY cols.position a SELECT index_name, LOWER(column_name) FROM user_ind_columns cols WHERE table_name = UPPER(%s) AND NOT EXISTS ( SELECT 1 FROM user_constraints cons WHERE cols.index_name = cons.index_name ) ORDER BY cols.column_position )rrr") rrr# constraints constraintcolumnpkr5r:Z other_tableZ other_columnrrrget_constraintss\         z%DatabaseIntrospection.get_constraints)__name__ __module__ __qualname__r ZBLOBZCLOBZDATETIMEZ FIXED_CHARZNCLOBrSTRINGZ TIMESTAMPZdata_types_reverseZ NATIVE_FLOATAttributeErrorUNICODErrrr&r'r,r/r3r8r@ __classcell__rr)rrr s4    r)r Z%django.db.backends.base.introspectionrrrZdjango.utils.encodingrrrrrrs