ó ®â0_c@s‚ddlmZddlZddlmZmZmZddlmZddl m Z ddl m Z defd„ƒYZ dS( iÿÿÿÿ(tunicode_literalsN(tBaseDatabaseIntrospectiont FieldInfot TableInfo(tIndex(tRemovedInDjango21Warning(t force_texttDatabaseIntrospectioncBs×eZidd6dd6dd6dd6dd 6d d 6d d 6d d6dd6dd6dd6dd6dd6dd6dd6dd6dd6dd6ZgZd Zd!„Zd"„Zd#„Zd$„Zd%„Z d&„Z d'„Z RS((u BooleanFieldiu BinaryFieldiuBigIntegerFieldiuSmallIntegerFieldiu IntegerFieldiu TextFieldiu FloatFieldi¼i½uGenericIPAddressFieldieu CharFieldiiu DateFieldi:u TimeFieldi;u DateTimeFieldiZi iòu DecimalFieldi¤u UUIDFieldi† u… SELECT attr.attname, idx.indkey, idx.indisunique, idx.indisprimary FROM pg_catalog.pg_class c, pg_catalog.pg_class c2, pg_catalog.pg_index idx, pg_catalog.pg_attribute attr WHERE c.oid = idx.indrelid AND idx.indexrelid = c2.oid AND attr.attrelid = c.oid AND attr.attnum = idx.indkey[0] AND c.relname = %scCsZtt|ƒj||ƒ}|jrVd|jkrV|dkrCdS|dkrVdSn|S(Nunextvalu IntegerFieldu AutoFielduBigIntegerFieldu BigAutoField(tsuperRtget_field_typetdefault(tselft data_typet descriptiont field_type((sM/tmp/pip-unpacked-wheel-BAJOf3/django/db/backends/postgresql/introspection.pyR 0s  cCse|jdƒg|jƒD]G}|d|jkrt|didd6dd6j|dƒƒ^qS(uQ Returns a list of table and view names in the current database. u= 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)iuturuvi(texecutetfetchalltignored_tablesRtget(R tcursortrow((sM/tmp/pip-unpacked-wheel-BAJOf3/django/db/backends/postgresql/introspection.pytget_table_list9s c Csµ|jd|gƒd„|jƒDƒ}|jd|jjj|ƒƒg|jD]^}tt|dƒf|dd!|t|dƒddk|t|dƒdfŒ^qSS(uQReturns a description of the table, with the DB-API cursor.description interface.uŠ SELECT column_name, is_nullable, column_default FROM information_schema.columns WHERE table_name = %scSs!i|]}|d|d“qS(ii((t.0tline((sM/tmp/pip-unpacked-wheel-BAJOf3/django/db/backends/postgresql/introspection.pys Ps uSELECT * FROM %s LIMIT 1iiiuYES(RRt connectiontopst quote_nameR RR(R Rt table_namet field_mapR((sM/tmp/pip-unpacked-wheel-BAJOf3/django/db/backends/postgresql/introspection.pytget_table_descriptionHs   cCsP|jd|gƒi}x0|jƒD]"}|d|df||ds