ÿØÿàJFIFÿþ ÿÛC       ÿÛC ÿÀÿÄÿÄ"#QrÿÄÿÄ&1!A"2qQaáÿÚ ?Øy,æ/3JæݹÈ߲؋5êXw²±ÉyˆR”¾I0ó2—PI¾IÌÚiMö¯–þrìN&"KgX:Šíµ•nTJnLK„…@!‰-ý ùúmë;ºgµŒ&ó±hw’¯Õ@”Ü— 9ñ-ë.²1<yà‚¹ïQÐU„ہ?.’¦èûbß±©Ö«Âw*VŒ) `$‰bØԟ’ëXÖ-ËTÜíGÚ3ð«g Ÿ§¯—Jx„–’U/ÂÅv_s(Hÿ@TñJÑãõçn­‚!ÈgfbÓc­:él[ðQe 9ÀPLbÃãCµm[5¿ç'ªjglå‡Ûí_§Úõl-;"PkÞÞÁQâ¼_Ñ^¢SŸx?"¸¦ùY騐ÒOÈ q’`~~ÚtËU¹CڒêV  I1Áß_ÿÙ 4]c@s'dZddlmZddlmZddlmZddlmZddlmZddlmZddlm Z d d l m Z d d l mZd efd YZdefdYZdefdYZdefdYZde fdYZdeefdYZeZdS(s> .. dialect:: mssql+mxodbc :name: mxODBC :dbapi: mxodbc :connectstring: mssql+mxodbc://:@ :url: http://www.egenix.com/ Execution Modes --------------- mxODBC features two styles of statement execution, using the ``cursor.execute()`` and ``cursor.executedirect()`` methods (the second being an extension to the DBAPI specification). The former makes use of a particular API call specific to the SQL Server Native Client ODBC driver known SQLDescribeParam, while the latter does not. mxODBC apparently only makes repeated use of a single prepared statement when SQLDescribeParam is used. The advantage to prepared statement reuse is one of performance. The disadvantage is that SQLDescribeParam has a limited set of scenarios in which bind parameters are understood, including that they cannot be placed within the argument lists of function calls, anywhere outside the FROM, or even within subqueries within the FROM clause - making the usage of bind parameters within SELECT statements impossible for all but the most simplistic statements. For this reason, the mxODBC dialect uses the "native" mode by default only for INSERT, UPDATE, and DELETE statements, and uses the escaped string mode for all other statements. This behavior can be controlled via :meth:`~sqlalchemy.sql.expression.Executable.execution_options` using the ``native_odbc_execute`` flag with a value of ``True`` or ``False``, where a value of ``True`` will unconditionally use native bind parameters and a value of ``False`` will unconditionally use string-escaped parameters. i(t_MSDate(t _MSDateTime(t_MSTime(t MSDialect(t VARBINARY(t_MSNumeric_pyodbc(tMSExecutionContext_pyodbci(ttypes(tMxODBCConnectort_MSNumeric_mxodbccBseZdZRS(s(Include pyodbc's numeric processor. (t__name__t __module__t__doc__(((sS/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/mssql/mxodbc.pyR 9st_MSDate_mxodbccBseZdZRS(cCs d}|S(NcSs.|dk r&d|j|j|jfSdSdS(Ns%s-%s-%s(tNonetyeartmonthtday(tvalue((sS/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/mssql/mxodbc.pytprocess@s ((tselftdialectR((sS/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/mssql/mxodbc.pytbind_processor?s (R R R(((sS/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/mssql/mxodbc.pyR >st_MSTime_mxodbccBseZdZRS(cCs d}|S(NcSs.|dk r&d|j|j|jfSdSdS(Ns%s:%s:%s(Rthourtminutetsecond(R((sS/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/mssql/mxodbc.pyRKs ((RRR((sS/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/mssql/mxodbc.pyRJs (R R R(((sS/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/mssql/mxodbc.pyRIst_VARBINARY_mxodbccBseZdZdZRS(s mxODBC Support for VARBINARY column types. This handles the special case for null VARBINARY values, which maps None values to the mx.ODBC.Manager.BinaryNull symbol. cs5jdkrdSjjfd}|S(Ncs$|dk r|SjjSdS(N(Rtdbapit BinaryNull(R(t DBAPIBinaryR(sS/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/mssql/mxodbc.pyRcs  (RRtBinary(RRR((RRsS/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/mssql/mxodbc.pyR]s  (R R R R(((sS/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/mssql/mxodbc.pyRTstMSExecutionContext_mxodbccBseZdZRS(s The pyodbc execution context is useful for enabling SELECT SCOPE_IDENTITY in cases where OUTPUT clause does not work (tables with insert triggers). (R R R (((sS/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/mssql/mxodbc.pyR mstMSDialect_mxodbccBs_eZeZeZieej6e ej 6e ej 6e ej6ee6eej6ZddZRS(cKs#tt|j|||_dS(N(tsuperR!t__init__tdescription_encoding(RR$tparams((sS/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/mssql/mxodbc.pyR#sN(R R R texecution_ctx_clstTruet_need_decimal_fixR tsqltypestNumericRtDateTimeR tDateRtTimeRRt LargeBinarytcolspecsRR#(((sS/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/mssql/mxodbc.pyR!ys     N(R tbaseRRRRRtpyodbcRRtRR)tconnectors.mxodbcRR R RRR R!R(((sS/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/mssql/mxodbc.pyt+s