X!@s^ddlmZddlmZedddgZeddZGdd d eZd S) ) namedtuple)six TableInfonametype FieldInfozAname type_code display_size internal_size precision scale null_okc@seZdZdZiZddZddZddZdd Zd d d d Z ddZ d dddZ ddZ ddZ ddZddZddZddZd S)BaseDatabaseIntrospectionzN This class encapsulates all backend-specific introspection utilities cCs ||_dS)N) connection)selfr r S/home/ubuntu/projects/ifolica/build/django/django/db/backends/base/introspection.py__init__sz"BaseDatabaseIntrospection.__init__cCs |j|S)aHook for a database backend to use the cursor description to match a Django field type to a database column. For Oracle, the column data_type on its own is insufficient to distinguish between a FloatField and IntegerField, for example.)data_types_reverse)r Z data_type descriptionr r r get_field_typesz(BaseDatabaseIntrospection.get_field_typecCs|S)zApply a conversion to the name for the purposes of comparison. The default table name converter is for case sensitive comparison. r )r rr r r table_name_convertersz.BaseDatabaseIntrospection.table_name_convertercCs |j|S)z Apply a conversion to the column name for the purposes of comparison. Uses table_name_converter() by default. )r)r rr r r column_name_converter$sz/BaseDatabaseIntrospection.column_name_converterNFc sPfdd}|dkrFjj}||SWdQXn||S)a Returns a list of names of all tables that exist in the database. The returned table list is sorted by Python's default sorting. We do NOT use database's ORDER BY here to avoid subtle differences in sorting order between databases. cs&tfddj|DS)Nc3s-|]#}s|jdkr|jVqdS)tN)rr).0Zti) include_viewsr r 4szKBaseDatabaseIntrospection.table_names..get_names..)sortedget_table_list)cursor)rr r r get_names3sz8BaseDatabaseIntrospection.table_names..get_namesN)r r)r rrrr )rr r table_names,s  z%BaseDatabaseIntrospection.table_namescCstddS)z Returns an unsorted list of TableInfo named tuples of all tables and views that exist in the database. zMsubclasses of BaseDatabaseIntrospection may require a get_table_list() methodN)NotImplementedError)r rr r r r;sz(BaseDatabaseIntrospection.get_table_listTcsddlm}ddlm}t}x||jD]n}xe|j|jjD]K}|j j smqUn|j |j j |j dd|j jDqUWq6Wt|}|rjd|fdd|D}n|S) z Returns a list of all table names that have associated Django models and are in INSTALLED_APPS. If only_existing is True, the resulting list will only include the tables that actually exist in the database. r)apps)routercss-|]#}|jjjjr|jVqdS)N) remote_fieldthrough_metamanaged m2m_db_table)rfr r r rSsz?BaseDatabaseIntrospection.django_table_names..rcs+g|]!}j|kr|qSr )r)rr)existing_tablesr r r Zs z@BaseDatabaseIntrospection.django_table_names..) django.appsr django.dbrsetget_app_configsget_migratable_modelsr aliasr!r"adddb_tableupdatelocal_many_to_manylistr)r Z only_existingrrrtables app_configmodelr )r%r r django_table_namesBs   "  z,BaseDatabaseIntrospection.django_table_namescsddlm}ddlm}g}x3|jD]%}|j|j|jjq3Wt t j fdd|DS)zLReturns a set of all models represented by the provided list of table names.r)r)rcs1h|]'}j|jjkr|qSr )rr!r.)rm)r r2r r is z=BaseDatabaseIntrospection.installed_models..) r'rr(rr*extendr+r r,r1mapr)r r2rrZ all_modelsr3r )r r2r installed_models`s#z*BaseDatabaseIntrospection.installed_modelscCs,ddlm}ddlm}m}g}x|jD]}x|j||jjD]}|j j spqXn|j j rqXnxN|j j D]@}t ||jr|ji|j jd6|jd6PqqWxJ|j jD]<}|jjdkr|ji|jd6dd6qqWqXWq9W|S)zPReturns a list of information about all DB sequences for all models in all apps.r)r)modelsrtablecolumnN)r'rr(r;rr*r+r r,r!r"ZswappedZ local_fields isinstanceZ AutoFieldappendr.r=r0rr r#)r rr;r sequence_listr3r4r$r r r r@ms"  $0z'BaseDatabaseIntrospection.sequence_listcCstddS)z Backends can override this to return a list of (column_name, referenced_table_name, referenced_column_name) for all key columns in given table. zNsubclasses of BaseDatabaseIntrospection may require a get_key_columns() methodN)r)r r table_namer r r get_key_columnssz)BaseDatabaseIntrospection.get_key_columnscCs@x9tj|j||D]}|ddr|dSqWdS)zQ Returns the name of the primary key column for the given table. Z primary_keyrN)r iteritems get_indexes)r rrAr=r r r get_primary_key_columns" z0BaseDatabaseIntrospection.get_primary_key_columncCstddS)aX Returns a dictionary of indexed fieldname -> infodict for the given table, where each infodict is in the format: {'primary_key': boolean representing whether it's the primary key, 'unique': boolean representing whether it's a unique index} Only single-column indexes are introspected. zJsubclasses of BaseDatabaseIntrospection may require a get_indexes() methodN)r)r rrAr r r rEs z%BaseDatabaseIntrospection.get_indexescCstddS)a Retrieves any constraints or keys (unique, pk, fk, check, index) across one or more columns. Returns a dict mapping constraint names to their attributes, where attributes is a dict with keys: * columns: List of columns this covers * primary_key: True if primary key, False otherwise * unique: True if this is a unique constraint, False otherwise * foreign_key: (table, column) of target, or None * check: True if check constraint, False otherwise * index: True if index, False otherwise. Some backends may return special constraint names that don't exist if they don't name constraints of a certain type (e.g. SQLite) zNsubclasses of BaseDatabaseIntrospection may require a get_constraints() methodN)r)r rrAr r r get_constraintssz)BaseDatabaseIntrospection.get_constraints)__name__ __module__ __qualname____doc__rr rrrrrr5r:r@rBrFrErGr r r r r s         rN) collectionsrZ django.utilsrrrobjectrr r r r s