σ H`ΎTc@sΈdZddlmZmZddlmZddlmZddlmZddlm Z ddlm Z ddlm Z d d l m Z ejd „ƒZd efd „ƒYZdS(sγProvides an abstraction for obtaining database schema information. Usage Notes: Here are some general conventions when accessing the low level inspector methods such as get_table_names, get_columns, etc. 1. Inspector methods return lists of dicts in most cases for the following reasons: * They're both standard types that can be serialized. * Using a dict instead of a tuple allows easy expansion of attributes. * Using a list for the outer structure maintains order and is easy to work with (e.g. list comprehension [d['name'] for d in cols]). 2. Records that contain a name, such as the column name in a column record use the key 'name'. So for most return values, each record will have a 'name' attribute.. i(texctsql(tschema(tutil(t TypeEngine(t deprecated(t topological(t inspectioni(t ConnectablecOsͺ|jddƒ}|dkr1|||||ŽS|jtd„|Dƒƒtd„|jƒDƒƒf}|j|ƒ}|dkr¦|||||Ž}|||-scssA|]7\}}t|tjtjtfƒr||fVqdS(N(R RR t int_typestfloat(R tktv((sb/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/engine/reflection.pys .s (tgettNonet__name__ttupletitems(tfntselftcontargstkwR tkeytret((sb/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/engine/reflection.pytcache&s   t InspectorcBsμeZdZd„Zed„ƒZejeƒd„ƒZ e d„ƒZ d„Z ddd„Zdd„Zdd„Zdd „Zdd „Zed d ƒdd „ƒZdd„Zdd„Zdd„Zdd„Zdd„ZRS(smPerforms database schema inspection. The Inspector acts as a proxy to the reflection methods of the :class:`~sqlalchemy.engine.interfaces.Dialect`, providing a consistent interface as well as caching support for previously fetched metadata. A :class:`.Inspector` object is usually created via the :func:`.inspect` function:: from sqlalchemy import inspect, create_engine engine = create_engine('...') insp = inspect(engine) The inspection method above is equivalent to using the :meth:`.Inspector.from_engine` method, i.e.:: engine = create_engine('...') insp = Inspector.from_engine(engine) Where above, the :class:`~sqlalchemy.engine.interfaces.Dialect` may opt to return an :class:`.Inspector` subclass that provides additional methods specific to the dialect's target database. cCsn||_t|dƒr'|j|_n ||_|j|krR|jƒjƒn|jj|_i|_dS(sjInitialize a new :class:`.Inspector`. :param bind: a :class:`~sqlalchemy.engine.Connectable`, which is typically an instance of :class:`~sqlalchemy.engine.Engine` or :class:`~sqlalchemy.engine.Connection`. For a dialect-specific instance of :class:`.Inspector`, see :meth:`.Inspector.from_engine` tengineN(tbindthasattrR tconnecttclosetdialectR (RR!((sb/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/engine/reflection.pyt__init__Vs  cCs,t|jdƒr"|jj|ƒSt|ƒS(s‘Construct a new dialect-specific Inspector object from the given engine or connection. :param bind: a :class:`~sqlalchemy.engine.Connectable`, which is typically an instance of :class:`~sqlalchemy.engine.Engine` or :class:`~sqlalchemy.engine.Connection`. This method differs from direct a direct constructor call of :class:`.Inspector` in that the :class:`~sqlalchemy.engine.interfaces.Dialect` is given a chance to provide a dialect-specific :class:`.Inspector` instance, which may provide additional methods. See the example at :class:`.Inspector`. t inspector(R"R%R'R(tclsR!((sb/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/engine/reflection.pyt from_enginerscCs tj|ƒS(N(RR)(R!((sb/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/engine/reflection.pyt_insp‰scCs |jjS(sΟReturn the default schema name presented by the dialect for the current engine's database user. E.g. this is typically ``public`` for Postgresql and ``dbo`` for SQL Server. (R%tdefault_schema_name(R((sb/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/engine/reflection.pyR+s cCs2t|jdƒr.|jj|jd|jƒSgS(s!Return all schema names. tget_schema_namesR (R"R%R,R!R (R((sb/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/engine/reflection.pyR,˜s cCsΡt|jdƒr6|jj|j|d|jƒ}n|jj|ƒ}|dkrΝg}xU|D]M}xD|j||ƒD]0}||dkrz|j|d|fƒqzqzWqaWt t j ||ƒƒ}n|S(sVReturn all table names in referred to within a particular schema. The names are expected to be real tables only, not views. Views are instead returned using the :meth:`.Inspector.get_view_names` method. :param schema: Schema name. If ``schema`` is left at ``None``, the database's default schema is used, else the named schema is searched. If the database does not support named schemas, behavior is undefined if ``schema`` is not passed as ``None``. For special quoting, use :class:`.quoted_name`. :param order_by: Optional, may be the string "foreign_key" to sort the result on foreign key dependencies. .. versionchanged:: 0.8 the "foreign_key" sorting sorts tables in order of dependee to dependent; that is, in creation order, rather than in drop order. This is to maintain consistency with similar features such as :attr:`.MetaData.sorted_tables` and :func:`.util.sort_tables`. .. seealso:: :attr:`.MetaData.sorted_tables` tget_table_namesR t foreign_keytreferred_table( R"R%R-R!R R t table_namestget_foreign_keystappendtlistRtsort(RRtorder_byttnamesttuplesttnametfkey((sb/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/engine/reflection.pyR-‘s   "cKs;t|jdƒr7|jj|j||d|j|SiS(sΡReturn a dictionary of options specified when the table of the given name was created. This currently includes some options that apply to MySQL tables. :param table_name: string name of the table. For special quoting, use :class:`.quoted_name`. :param schema: string schema name; if omitted, uses the default schema of the database connection. For special quoting, use :class:`.quoted_name`. tget_table_optionsR (R"R%R:R!R (Rt table_nameRR((sb/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/engine/reflection.pyR:Μs   cCs|jj|j|d|jƒS(s±Return all view names in `schema`. :param schema: Optional, retrieve names from a non-default schema. For special quoting, use :class:`.quoted_name`. R (R%tget_view_namesR!R (RR((sb/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/engine/reflection.pyR<ΰscCs"|jj|j||d|jƒS(s±Return definition for `view_name`. :param schema: Optional, retrieve names from a non-default schema. For special quoting, use :class:`.quoted_name`. R (R%tget_view_definitionR!R (Rt view_nameR((sb/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/engine/reflection.pyR=λs cKse|jj|j||d|j|}x7|D]/}|d}t|tƒs.|ƒ|d»stnameR?c3s+|]!}|ˆkr|ˆ|fVqdS(N((R R(tcol_d(sb/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/engine/reflection.pys αstnullablet autoincrementtquotetinfoRtdefaultt _reflectedtsequenceitstartt incrementRDtreferred_schemaR/treferred_columnstautoloadRt autoload_witht.toptionst link_to_namet column_namestuniquetindexs5Omitting %s key for (%s), key covers omitted columns.s, s5%s key '%s' was not located in columns for table '%s'N(4R!R%RRKtdicttreflection_optionsR:RIt_validate_dialect_kwargsRtpy2kR tstrtdecodetencodingtFalseR@tTruetdispatchtcolumn_reflectRRR2t sa_schemat DefaultClauseRttexttSequenceRTRUtColumnRt primary_keyt append_columnRtNoSuchTableErrorREt_reloadR1tsett intersectiontTabletmetadatatjointappend_constrainttForeignKeyConstraintRGtissubsettwarntctKeyErrortIndex((RRJtinclude_columnstexclude_columnsR%RR;Rattbl_optst found_tabletcols_by_orig_namet orig_nameRKRCtcol_kwtcolargstseqRStcoltpk_constpktpk_colstfkeystfkey_dtconnameR}RDRVR/RWtrefspectcolumnR[tindexestindex_dtcolumnsR^tflavortidx_colstidx_col((RJRLsb/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/engine/reflection.pyt reflecttableœsβ                 (  3                   ' N((Rt __module__t__doc__R&t classmethodR)Rt _inspectsRR*tpropertyR+R,RR-R:R<R=R@RRFRER1RGRHR˜(((sb/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/engine/reflection.pyR;s$  +  (   #  N(RštRRRRkRt sql.type_apiRRRRtbaseRt decoratorRtobjectR(((sb/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/engine/reflection.pyts