B [g4@sddlZddlmZddlZejdkrEsz8DatabaseIntrospection.get_table_list..cSsg|] }|dqS)rr)rrrrrrIsN)executedjangoVERSIONfetchall)rcursorrrrget_table_list@s    z$DatabaseIntrospection.get_table_listc stdd|d|gtfdd|D}|d|jj|dd}g}x|jD]}t|d }| t |f|d d |||j p|d |||j p|d |||j p|d f|df||jfq^W|S)zx Returns a description of the table, with the DB-API cursor.description interface." InfoLinez3col_name data_type max_len num_prec num_scale extraz SELECT column_name, data_type, character_maximum_length, numeric_precision, numeric_scale, extra FROM information_schema.columns WHERE table_name = %s AND table_schema = DATABASE()c3s|]}|d|fVqdS)rNr)rline)r#rr bsz>DatabaseIntrospection.get_table_description..zSELECT * FROM %s LIMIT 1cSs|dk rt|S|S)N)int)irrrgsz=DatabaseIntrospection.get_table_description..rrr)rrdictr connectionops quote_namerr appendrmax_lenZnum_precZ num_scaler )rr! table_nameZ field_infoZto_intfieldsr$Zcol_namer)r#rget_table_descriptionLs$    pz+DatabaseIntrospection.get_table_descriptioncs|d|gt||d|gtdd|D|d|jj|tjdkrxfdd|j DSfd d|j DSd S) zw Returns a description of the table, with the DB-API cursor.description interface. zSELECT column_name, character_maximum_length FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = %s AND table_schema = DATABASE() AND character_maximum_length IS NOT NULLzSELECT column_name, numeric_precision, numeric_scale FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = %s AND table_schema = DATABASE() AND data_type='decimal'css0|](}|dtdd|ddDfVqdS)rcSsg|] }t|qSr)r&)rnrrrrszIDatabaseIntrospection.get_table_description...rN)tuple)rr$rrrr%sz>DatabaseIntrospection.get_table_description..zSELECT * FROM {0} LIMIT 1)rrc sbg|]Z}tt|df|dd|d|df|d|dd|dfqS)rrr)r*r)rr r)rr$) length_map numeric_maprrrsz?DatabaseIntrospection.get_table_description..cs:g|]2}|dd|d|df|ddqS)Nr)rr*)r)rr$)r7rrrsN) rr,r formatr-r.r/rrr)rr!r2r)r7r8rr4ys      cCstddt|||DS)zu Returns a dictionary of {field_name: field_index} for the given table. Indexes are 0-based. css|]\}}|d|fVqdS)rNr)rr'drrrr%sz7DatabaseIntrospection._name_to_index..)r, enumerater4)rr!r2rrr_name_to_indexs z$DatabaseIntrospection._name_to_indexc Cs|||}i}tjdkr>x|D]\}}}||f||<q W|S|||}x6|D].\}}}||||} ||} | |f|| <qPW|SdS)z Returns a dictionary of {field_index: (field_index_other_table, other_table)} representing all relationships to the given table. Indexes are 0-based. )rrN)get_key_columnsrrr<) rr!r2 constraintsZ relationsZ my_fieldnameZ other_tableZ other_fieldZ my_field_dictZother_field_indexZmy_field_indexrrr get_relationss    z#DatabaseIntrospection.get_relationscCs$g}|d|g|||S)z Returns a list of (column_name, referenced_table_name, referenced_column_name) for all key columns in given table. zSELECT column_name, referenced_table_name, referenced_column_name FROM information_schema.key_column_usage WHERE table_name = %s AND table_schema = DATABASE() AND referenced_table_name IS NOT NULL AND referenced_column_name IS NOT NULL)rextendr )rr!r2Z key_columnsrrrr=s z%DatabaseIntrospection.get_key_columnscCs|d|jj|t|}t}x&|D]}|ddkr2||dq2Wi}xl|D]d}|d|krpq^|d|krddd||d<|ddkrd ||dd <|ds^d ||dd <q^W|S) NzSHOW INDEX FROM {0}r)rr*F) primary_keyuniqueZPRIMARYTrBrC) rr9r-r.r/listr setadd)rr!r2ZrowsZmulticol_indexesrindexesrrr get_indexess$       z!DatabaseIntrospection.get_indexescCs2x,|||D]}|ddr|dSqWdS)zP Returns the name of the primary key column for the given table rrBrN)rHitems)rr!r2columnrrrget_primary_key_columns  z,DatabaseIntrospection.get_primary_key_columncCs,|d|g|}|s$|jjjS|dS)z Retrieves the storage engine for a given table. Returns the default storage engine if the table doesn't exist. zBSELECT engine FROM information_schema.tables WHERE table_name = %sr)rZfetchoner-featuresZmysql_storage_engine)rr!r2resultrrrget_storage_engines z(DatabaseIntrospection.get_storage_enginecCsi}d}|||jjd|gxX|D]L\}}}}||krdtdddd|rV||fndfd||<||d|q*Wd} || |jjd|gxR|D]F\}} | dkrd ||d <d ||d <q| d krd ||d <qW|d |jj|xfd d|DD]P\} } } }}| |krFtddd ddd|| <d || d<|| d|qWx"| D]}t |d|d<qtW|S)zv Retrieves any constraints or keys (unique, pk, fk, check, index) across one or more columns. zSELECT kc.`constraint_name`, kc.`column_name`, kc.`referenced_table_name`, kc.`referenced_column_name` FROM information_schema.key_column_usage AS kc WHERE kc.table_schema = %s AND kc.table_name = %sNAMEFN)columnsrBrCindexcheckZ foreign_keyrPz SELECT c.constraint_name, c.constraint_type FROM information_schema.table_constraints AS c WHERE c.table_schema = %s AND c.table_name = %s z primary keyTrBrCzSHOW INDEX FROM %scSsg|]}|ddqS)Nr+r)rxrrrr2sz9DatabaseIntrospection.get_constraints..rQ) rr-Z settings_dictr r rFlowerr.r/valuesrD)rr!r2r>Z name_query constraintrJZ ref_tableZ ref_columnZ type_querykindtableZ non_uniquerQZcolseqrrrget_constraintssL       z%DatabaseIntrospection.get_constraints)%__name__ __module__ __qualname__r ZBLOBZDECIMALZ NEWDECIMALZDATEZDATETIMEDOUBLEFLOATZINT24LONGZLONGLONGSHORTrrSTRINGZTIME TIMESTAMPZTINYZ TINY_BLOBZ MEDIUM_BLOBZ LONG_BLOBZ VAR_STRINGZdata_types_reverserr"r4r<r?r=rHrKrNrY __classcell__rr)rrrs@    -) r)re collectionsrrrZ%django.db.backends.base.introspectionrrrZdjango.db.backendsZdjango.utils.encodingr Zdjango.utils.datastructuresr Zmysql.connector.constantsr compileZforeign_key_re_fieldsrrrrrs