3 ­©Þ[s%ã@s4ddlmZmZmZddlmZGdd„deƒZdS)é)ÚBaseDatabaseIntrospectionÚ FieldInfoÚ TableInfo)ÚIndexcs~eZdZdddddddddd d d d d d d d ddœZgZ‡fdd„Zdd„Zdd„Zffdd„Zdd„Z dd„Z dd„Z ‡Z S)ÚDatabaseIntrospectionZ BooleanFieldZ BinaryFieldÚBigIntegerFieldZSmallIntegerFieldÚ IntegerFieldZ TextFieldZ FloatFieldZGenericIPAddressFieldZ CharFieldZ DateFieldZ TimeFieldZ DateTimeFieldZ DecimalFieldZ UUIDField)ééééééi¼i½ieiii:i;iZi iòi¤i† cs:tƒj||ƒ}|jr6d|jkr6|dkr*dS|dkr6dS|S)NZnextvalrZ AutoFieldrZ BigAutoField)ÚsuperÚget_field_typeÚdefault)ÚselfZ data_typeÚ descriptionZ field_type)Ú __class__©úO/tmp/pip-install-j7i95hgp/django/django/db/backends/postgresql/introspection.pyr sz$DatabaseIntrospection.get_field_typecs |jdƒ‡fdd„|jƒDƒS)z>Return a list of table and view names in the current database.a= SELECT c.relname, c.relkind FROM pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind IN ('r', 'v') AND n.nspname NOT IN ('pg_catalog', 'pg_toast') AND pg_catalog.pg_table_is_visible(c.oid)cs8g|]0}|dˆjkrt|ddddœj|dƒƒ‘qS)rÚtÚv)Úrré)Úignored_tablesrÚget)Ú.0Úrow)rrrú 2sz8DatabaseIntrospection.get_table_list..)ÚexecuteÚfetchall)rÚcursorr)rrÚget_table_list)s z$DatabaseIntrospection.get_table_listcsL|jd|gƒdd„|jƒDƒ‰|jd|jjj|ƒƒ‡fdd„|jDƒS)zi Return a description of the table with the DB-API cursor.description interface. zŠ SELECT column_name, is_nullable, column_default FROM information_schema.columns WHERE table_name = %scSsi|]}|dd…|d“qS)rNrr)rÚlinerrrú Asz?DatabaseIntrospection.get_table_description..zSELECT * FROM %s LIMIT 1cs<g|]4}t|dd…ˆ|jddkˆ|jdfžŽ‘qS)réZYESr)rÚname)rr$)Ú field_maprrrDsz?DatabaseIntrospection.get_table_description..)r r!Ú connectionÚopsZ quote_namer)rr"Ú table_namer)r(rÚget_table_description6s   z+DatabaseIntrospection.get_table_descriptioncCsBg}|jd|gƒx*|jƒD]}|j|d||ddœƒqW|S)NaÈ SELECT s.relname as sequence_name, col.attname FROM pg_class s JOIN pg_namespace sn ON sn.oid = s.relnamespace JOIN pg_depend d ON d.refobjid = s.oid AND d.refclassid='pg_class'::regclass JOIN pg_attrdef ad ON ad.oid = d.objid AND d.classid = 'pg_attrdef'::regclass JOIN pg_attribute col ON col.attrelid = ad.adrelid AND col.attnum = ad.adnum JOIN pg_class tbl ON tbl.oid = ad.adrelid JOIN pg_namespace n ON n.oid = tbl.relnamespace WHERE s.relkind = 'S' AND d.deptype in ('a', 'n') AND n.nspname = 'public' AND tbl.relname = %s rr)r'ÚtableÚcolumn)r r!Úappend)rr"r+Z table_fieldsÚ sequencesrrrrÚ get_sequencesHs  z#DatabaseIntrospection.get_sequencescCs@|jd|gƒi}x(|jƒD]}|d|df||d<qW|S)z— Return a dictionary of {field_name: (field_name_other_table, other_table)} representing all relationships to the given table. aÑ SELECT c2.relname, a1.attname, a2.attname FROM pg_constraint con LEFT JOIN pg_class c1 ON con.conrelid = c1.oid LEFT JOIN pg_class c2 ON con.confrelid = c2.oid LEFT JOIN pg_attribute a1 ON c1.oid = a1.attrelid AND a1.attnum = con.conkey[1] LEFT JOIN pg_attribute a2 ON c2.oid = a2.attrelid AND a2.attnum = con.confkey[1] WHERE c1.relname = %s AND con.contype = 'f'érr)r r!)rr"r+Z relationsrrrrÚ get_relations\s  z#DatabaseIntrospection.get_relationscCs$g}|jd|gƒ|j|jƒƒ|S)Na  SELECT kcu.column_name, ccu.table_name AS referenced_table, ccu.column_name AS referenced_column FROM information_schema.constraint_column_usage ccu LEFT JOIN information_schema.key_column_usage kcu ON ccu.constraint_catalog = kcu.constraint_catalog AND ccu.constraint_schema = kcu.constraint_schema AND ccu.constraint_name = kcu.constraint_name LEFT JOIN information_schema.table_constraints tc ON ccu.constraint_catalog = tc.constraint_catalog AND ccu.constraint_schema = tc.constraint_schema AND ccu.constraint_name = tc.constraint_name WHERE kcu.table_name = %s AND tc.constraint_type = 'FOREIGN KEY')r Úextendr!)rr"r+Z key_columnsrrrÚget_key_columnsos  z%DatabaseIntrospection.get_key_columnsc Csòi}|jdd|gƒxX|jƒD]L\}}}}}||dk|dk|dkrRt|jddƒƒnd|d kd d|d œ||<qW|jd |gƒxp|jƒD]d\} }} } } } }}| |kr†|dgkr°|ng| dgkrÀ| ng| | dd d | dkrÚtjn| ||dœ || <q†W|S)z· Retrieve any constraints or keys (unique, pk, fk, check, index) across one or more columns. Also retrieve the definition of expression-based indexes. aq SELECT c.conname, array( SELECT attname FROM unnest(c.conkey) WITH ORDINALITY cols(colid, arridx) JOIN pg_attribute AS ca ON cols.colid = ca.attnum WHERE ca.attrelid = c.conrelid ORDER BY cols.arridx ), c.contype, (SELECT fkc.relname || '.' || fka.attname FROM pg_attribute AS fka JOIN pg_class AS fkc ON fka.attrelid = fkc.oid WHERE fka.attrelid = c.confrelid AND fka.attnum = c.confkey[1]), cl.reloptions FROM pg_constraint AS c JOIN pg_class AS cl ON c.conrelid = cl.oid JOIN pg_namespace AS ns ON cl.relnamespace = ns.oid WHERE ns.nspname = %s AND cl.relname = %s ÚpublicÚpÚuÚfÚ.rNÚcF)ÚcolumnsÚ primary_keyÚuniqueÚ foreign_keyÚcheckÚindexÚ definitionÚoptionsa| SELECT indexname, array_agg(attname ORDER BY arridx), indisunique, indisprimary, array_agg(ordering ORDER BY arridx), amname, exprdef, s2.attoptions FROM ( SELECT c2.relname as indexname, idx.*, attr.attname, am.amname, CASE WHEN idx.indexprs IS NOT NULL THEN pg_get_indexdef(idx.indexrelid) END AS exprdef, CASE am.amname WHEN 'btree' THEN CASE (option & 1) WHEN 1 THEN 'DESC' ELSE 'ASC' END END as ordering, c2.reloptions as attoptions FROM ( SELECT * FROM pg_index i, unnest(i.indkey, i.indoption) WITH ORDINALITY koi(key, option, arridx) ) idx LEFT JOIN pg_class c ON idx.indrelid = c.oid LEFT JOIN pg_class c2 ON idx.indexrelid = c2.oid LEFT JOIN pg_am am ON c2.relam = am.oid LEFT JOIN pg_attribute attr ON attr.attrelid = c.oid AND attr.attnum = idx.key WHERE c.relname = %s ) s2 GROUP BY indexname, indisunique, indisprimary, amname, exprdef, attoptions; TZbtree) r<Úordersr=r>r?r@rAÚtyperBrC)r7r8)r r!ÚtupleÚsplitrÚsuffix)rr"r+Ú constraintsÚ constraintr<ÚkindZ used_colsrCrAr>ZprimaryrDÚtype_rBrrrÚget_constraints€s6  z%DatabaseIntrospection.get_constraints) Ú__name__Ú __module__Ú __qualname__Zdata_types_reverserrr#r,r1r3r5rMÚ __classcell__rr)rrrs4   rN)Z%django.db.backends.base.introspectionrrrZdjango.db.models.indexesrrrrrrÚs