+ SReturn a list of table and view names in the current database.z SELECT table_name, table_type, table_comment FROM information_schema.tables WHERE table_schema = DATABASE() z BASE TABLEtVIEWv)executefetchallrget)r*cursorrows&& r.get_table_list$DatabaseIntrospection.get_table_listPsk ( ( c!f|S&#>BB3q6JCPQF S(   s>A%c  /pVPP'd_VPPP'd9VP RV.4VP 4Uu0uF qD^,kK ppVP RV.4VP 4pV'd V^,MRpVP RWR.4VP 4Uu/uFqf^,\V!bK ppVP RVPPPV4,4Rp.p VPEFpWv^,,p T P\.VR,OV!V P4;'g V^,NV!V P4;'g V^,NV!V P4;'g V^,NV!V P4;'g V^,NV^,NV P NV P"NV P$NV P&NV^,V9NV P(NV P*N5!4EK! V #uupiuupi)zR Return a description of the table with the DB-API cursor.description interface." av SELECT c.constraint_name AS column_name FROM information_schema.check_constraints AS c WHERE c.table_name = %s AND LOWER(c.check_clause) = 'json_valid(`' + LOWER(c.constraint_name) + '`)' AND c.constraint_schema = DATABASE() z SELECT table_collation FROM information_schema.tables WHERE table_schema = DATABASE() AND table_name = %s ad SELECT column_name, data_type, character_maximum_length, numeric_precision, numeric_scale, extra, column_default, CASE WHEN collation_name = %s THEN NULL ELSE collation_name END AS collation_name, CASE WHEN column_type LIKE '%% unsigned' THEN 1 ELSE 0 END AS is_unsigned, column_comment FROM information_schema.columns WHERE table_name = %s AND table_schema = DATABASE() zSELECT * FROM %s LIMIT 1c$Ve \V4#T#N)int)is&r.to_int;DatabaseIntrospection.get_table_description..to_ints]3q6 1 1r0:NN) connectionmysql_is_mariadbfeaturescan_introspect_json_fieldr5r6fetchonerops quote_namer+appendrmax_lennum_prec num_scalecolumn_default collationr r r r) r*r8 table_namejson_constraintsr9default_column_collationline field_inforBfieldsinfos &&& r.get_table_description+DatabaseIntrospection.get_table_description_sb  OO , , ,((BBB NN  39//2CD2C3A2C D  L oo-03q6b    & 2# &>*55d1g  G ''NNJJ$$G//LLNN '& G ELNs *I$I)c~VPW4F'pRVP9gKRVRVP/.u# .#)rtablecolumn)rYr name)r*r8rR table_fieldsrVs&&&& r. get_sequences#DatabaseIntrospection.get_sequencessC44VHJ:#3#33 *h HIII r0c  VPRV.4VP4UUUUu/uF#wr4rVW4WPPPV43bK% upppp#uuppppi)z Return a dictionary of { field_name: (field_name_other_table, other_table, db_on_delete) } representing all foreign keys in the given table. a SELECT kcu.column_name, kcu.referenced_column_name, kcu.referenced_table_name, rc.delete_rule FROM information_schema.key_column_usage kcu JOIN information_schema.referential_constraints rc ON rc.constraint_name = kcu.constraint_name AND rc.constraint_schema = kcu.constraint_schema WHERE kcu.table_name = %s AND kcu.table_schema = DATABASE() AND kcu.referenced_table_schema = DATABASE() AND kcu.referenced_table_name IS NOT NULL AND kcu.referenced_column_name IS NOT NULL )r5r6on_delete_typesr7)r*r8rR field_name other_field other_table on_deletes&&& r. get_relations#DatabaseIntrospection.get_relationssj  $L' .DJ??CT CT?  k3G3G3K3KI3VW WCT   s)A c VPRV.4VP4pV'g!VPPP#V^,#)zn Retrieve the storage engine for a given table. Return the default storage engine if the table doesn't exist. z SELECT engine FROM information_schema.tables WHERE table_name = %s AND table_schema = DATABASE() )r5rIrErG_mysql_storage_engine)r*r8rRresults&&& r.get_storage_engine(DatabaseIntrospection.get_storage_enginesM  L "??++AA Aayr0c\4p\P!V4^,pRVP44pVFpVP\P P 8XgK.VPPPVP4VP8XgKnVP^RV9gKVPVP^R4K V#)rc3L"TFqP'dKVxK R#5ir?) is_whitespace).0tokens& r. BDatabaseIntrospection._parse_constraint_columns..sT%8E@S@S%%%8s$ $) r sqlparseparseflattenttypetokensNamerErJrKvalueadd)r* check_clausecolumns check_columns statementr{rss&&& r._parse_constraint_columns/DatabaseIntrospection._parse_constraint_columnss" NN<03 TY%6%6%8TE x333OO''225;;?5;;NKK"%0!!%++a"34 r0c /pRpVPWB.4VP4FwrVrxp WS9d[R\4RV R8HRV R9RRRRR V'dWx3MR /W5&VPPP 'd .W5,R &W5,R,P V4K VPPP'd^p VPW4U u0uFqPkK p p VPP'dR p MR p VPW.4VP4FIwr^VPW4p\V4V08XdV ^, p RV ,pRVRRRRRRRRR R /W5&KK VPRVPPPV4,4VP4Uu.uFpVR,V^ ,3,NK upEF wpppppppVV9dOR\4RRRV'*RRR R /VV&VPPP 'd .VV,R &RVV,R&VR8Xd\P MVP#4VV,R&VV,R,P V4VPPP 'gKVV,R ,P%VR8XdRMR4EK VP'4Fp\)VR,4VR&K V#uup iuupi)z] Retrieve any constraints or keys (unique, pk, fk, check, index) across one or more columns. a SELECT kc.`constraint_name`, kc.`column_name`, kc.`referenced_table_name`, kc.`referenced_column_name`, c.`constraint_type` FROM information_schema.key_column_usage AS kc, information_schema.table_constraints AS c WHERE kc.table_schema = DATABASE() AND ( kc.referenced_table_schema = DATABASE() OR kc.referenced_table_schema IS NULL ) AND c.table_schema = kc.table_schema AND c.constraint_name = kc.constraint_name AND c.constraint_type != 'CHECK' AND kc.table_name = %s ORDER BY kc.`ordinal_position` r primary_key PRIMARY KEYuniqueindexFcheck foreign_keyNordersa SELECT c.constraint_name, c.check_clause FROM information_schema.check_constraints AS c WHERE c.constraint_schema = DATABASE() AND c.table_name = %s a3 SELECT cc.constraint_name, cc.check_clause FROM information_schema.check_constraints AS cc, information_schema.table_constraints AS tc WHERE cc.constraint_schema = DATABASE() AND tc.table_schema = cc.constraint_schema AND cc.constraint_name = tc.constraint_name AND tc.constraint_type = 'CHECK' AND tc.table_name = %s z__unnamed_constraint_%s__TzSHOW INDEX FROM %s:NNBTREEtypeDDESCASC>UNIQUEr)r5r6r rErGsupports_index_column_orderingr~ can_introspect_check_constraintsrYr^rFrsetrJrKrsuffixlowerrLvalueslist)r*r8rR constraints name_query constraintr] ref_table ref_columnkindunnamed_constraints_indexrXr type_queryrconstraint_columnsxr\ non_uniquercolseqordertype_s&&& r.get_constraints%DatabaseIntrospection.get_constraintss:   & z<0?E?P ;J t,z|!4=#8d&??UU!jI#:d + '??++JJJ8:K+H5  #I . 2 26 :@Q ?? # # D D D() %&*&@&@&T&Td &T ///    NN:| 4,2OO,=( %)%C%C &" )*zl:-2-!&  4??#6#6#A#A*#M M '-oo&7G &7AbEQrUH  &7G BE:uffeUK'z|!5*nU!4 & E"??++JJJ35K&x0*.K w ' % 0 ekkm  v &  y ) - -f 5''FFFE"8,33eslFPUV'G *&,,.J$(I)>$?Jy !/M^G s +M!M)r)&__name__ __module__ __qualname____firstlineno__rBLOBCHARDECIMAL NEWDECIMALDATEDATETIMEDOUBLEFLOATINT24JSONLONGLONGLONGSHORTSTRINGTIME TIMESTAMPTINY TINY_BLOB MEDIUM_BLOB LONG_BLOB VAR_STRINGdata_types_reverser(r:rYr`rhrmrr__static_attributes____classdictcell__ __classcell__)r- __classdict__s@@r.rrs N ~    _  < , .   . - ;  o!" #$ k k{+00  [z  D( qqr0r) collectionsrrwMySQLdb.constantsr%django.db.backends.base.introspectionrr BaseFieldInfor BaseTableInfodjango.db.modelsrdjango.utils.datastructuresr _fieldsrrrr0r.rs"(KLL"2              $  {$Gm&;&;$GY$G H X5Xr0