ó H`¾Tc@sÕdZddlmZmZddlmZddlmZm Z ddl Z de fd „ƒYZ d e ej fd „ƒYZd e ejfd „ƒYZdefd„ƒYZdeefd„ƒYZeZdS(s .. dialect:: mssql+pyodbc :name: PyODBC :dbapi: pyodbc :connectstring: mssql+pyodbc://:@ :url: http://pypi.python.org/pypi/pyodbc/ Additional Connection Examples ------------------------------- Examples of pyodbc connection string URLs: * ``mssql+pyodbc://mydsn`` - connects using the specified DSN named ``mydsn``. The connection string that is created will appear like:: dsn=mydsn;Trusted_Connection=Yes * ``mssql+pyodbc://user:pass@mydsn`` - connects using the DSN named ``mydsn`` passing in the ``UID`` and ``PWD`` information. The connection string that is created will appear like:: dsn=mydsn;UID=user;PWD=pass * ``mssql+pyodbc://user:pass@mydsn/?LANGUAGE=us_english`` - connects using the DSN named ``mydsn`` passing in the ``UID`` and ``PWD`` information, plus the additional connection configuration option ``LANGUAGE``. The connection string that is created will appear like:: dsn=mydsn;UID=user;PWD=pass;LANGUAGE=us_english * ``mssql+pyodbc://user:pass@host/db`` - connects using a connection that would appear like:: DRIVER={SQL Server};Server=host;Database=db;UID=user;PWD=pass * ``mssql+pyodbc://user:pass@host:123/db`` - connects using a connection string which includes the port information using the comma syntax. This will create the following connection string:: DRIVER={SQL Server};Server=host,123;Database=db;UID=user;PWD=pass * ``mssql+pyodbc://user:pass@host/db?port=123`` - connects using a connection string that includes the port information as a separate ``port`` keyword. This will create the following connection string:: DRIVER={SQL Server};Server=host;Database=db;UID=user;PWD=pass;port=123 * ``mssql+pyodbc://user:pass@host/db?driver=MyDriver`` - connects using a connection string that includes a custom ODBC driver name. This will create the following connection string:: DRIVER={MyDriver};Server=host;Database=db;UID=user;PWD=pass If you require a connection string that is outside the options presented above, use the ``odbc_connect`` keyword to pass in a urlencoded connection string. What gets passed in will be urldecoded and passed directly. For example:: mssql+pyodbc:///?odbc_connect=dsn%3Dmydsn%3BDatabase%3Ddb would create the following connection string:: dsn=mydsn;Database=db Encoding your connection string can be easily accomplished through the python shell. For example:: >>> import urllib >>> urllib.quote_plus('dsn=mydsn;Database=db') 'dsn%3Dmydsn%3BDatabase%3Ddb' Unicode Binds ------------- The current state of PyODBC on a unix backend with FreeTDS and/or EasySoft is poor regarding unicode; different OS platforms and versions of UnixODBC versus IODBC versus FreeTDS/EasySoft versus PyODBC itself dramatically alter how strings are received. The PyODBC dialect attempts to use all the information it knows to determine whether or not a Python unicode literal can be passed directly to the PyODBC driver or not; while SQLAlchemy can encode these to bytestrings first, some users have reported that PyODBC mis-handles bytestrings for certain encodings and requires a Python unicode object, while the author has observed widespread cases where a Python unicode is completely misinterpreted by PyODBC, particularly when dealing with the information schema tables used in table reflection, and the value must first be encoded to a bytestring. It is for this reason that whether or not unicode literals for bound parameters be sent to PyODBC can be controlled using the ``supports_unicode_binds`` parameter to ``create_engine()``. When left at its default of ``None``, the PyODBC dialect will use its best guess as to whether or not the driver deals with unicode literals well. When ``False``, unicode literals will be encoded first, and when ``True`` unicode literals will be passed straight through. This is an interim flag that hopefully should not be needed when the unicode situation stabilizes for unix + PyODBC. .. versionadded:: 0.7.7 ``supports_unicode_binds`` parameter to ``create_engine()``\ . i(tMSExecutionContextt MSDialecti(tPyODBCConnector(ttypestutiliÿÿÿÿNt_ms_numeric_pyodbccBs)eZdZd„Zd„Zd„ZRS(s¡Turns Decimals with adjusted() < 0 or > 7 into strings. The routines here are needed for older pyodbc versions as well as current mxODBC versions. cs;ttˆƒj|ƒ‰|js%ˆS‡‡fd†}|S(Ncstˆjr\t|tjƒr\|jƒ}|dkr@ˆj|ƒS|dkr\ˆj|ƒSnˆrlˆ|ƒS|SdS(Nii(t asdecimalt isinstancetdecimaltDecimaltadjustedt_small_dec_to_stringt_large_dec_to_string(tvalueR (t super_processtself(sf/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mssql/pyodbc.pytprocessŠs      (tsuperRtbind_processort_need_decimal_fix(RtdialectR((RRsf/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mssql/pyodbc.pyR‚s   c Cscd|dkrdpddt|jƒƒddjg|jƒdD]}t|ƒ^qFƒfS(Ns%s0.%s%sit-tt0i(tabsR tjointas_tupletstr(RR tnint((sf/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mssql/pyodbc.pyR sc Cs„|jƒd}dt|ƒkr„d|dkr7dp:ddjg|D]}t|ƒ^qGƒd|jƒt|ƒdf}nüt|ƒd|jƒkr+d|dkrµdp¸ddjg|D]}t|ƒ^qÅd|jƒd!ƒdjg|D]}t|ƒ^qû|jƒdƒf}nUd |dkr@dpCddjg|D]}t|ƒ^qPd|jƒd!ƒf}|S( NitEs%s%s%siRRRs%s%s.%ss%s%s(RRRR tlen(RR t_inttstresult((sf/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mssql/pyodbc.pyR £s$%%077(t__name__t __module__t__doc__RR R (((sf/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mssql/pyodbc.pyRys  t_MSNumeric_pyodbccBseZRS((R"R#(((sf/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mssql/pyodbc.pyR%ºst_MSFloat_pyodbccBseZRS((R"R#(((sf/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mssql/pyodbc.pyR&¾stMSExecutionContext_pyodbccBs eZeZd„Zd„ZRS(cCsZtt|ƒjƒ|jrV|jjrVt|jdƒrVt|_ |j d7_ ndS(sºwhere appropriate, issue "select scope_identity()" in the same statement. Background on why "scope_identity()" is preferable to "@@identity": http://msdn.microsoft.com/en-us/library/ms190315.aspx Background on why we attempt to embed "scope_identity()" into the same statement as the INSERT: http://code.google.com/p/pyodbc/wiki/FAQs#How_do_I_retrieve_autogenerated/identity_values? is; select scope_identity()N( RR'tpre_exect_select_lastrowidRtuse_scope_identityRt parameterstTruet_embedded_scope_identityt statement(R((sf/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mssql/pyodbc.pyR(Ås    cCs‡|jrpxNtrYy|jjƒd}PWq |jjjk rU}|jjƒq Xq Wt|dƒ|_ nt t |ƒj ƒdS(Ni( R-R,tcursortfetchallRtdbapitErrortnextsettintt _lastrowidRR't post_exec(Rtrowte((sf/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mssql/pyodbc.pyR6Ýs  (R"R#tFalseR-R(R6(((sf/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mssql/pyodbc.pyR'Âs tMSDialect_pyodbccBsIeZeZdZejejie e j 6e e j 6ƒZdd„ZRS(s SQL ServercKsƒd|kr!|jdƒ|_ntt|ƒj||jo[|jo[t|jjdƒ|_|joy|j ƒdk|_ dS(Ntdescription_encodingR3iii(iii( tpopR;RR:t__init__R*R1thasattrtCursort_dbapi_versionR(RR;tparams((sf/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mssql/pyodbc.pyR=s    N(R"R#R'texecution_ctx_clstpyodbc_driver_nameRt update_copyRtcolspecsR%tsqltypestNumericR&tFloattNoneR=(((sf/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mssql/pyodbc.pyR:òs (R$tbaseRRtconnectors.pyodbcRRRRFRRtobjectRRGR%RHR&R'R:R(((sf/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mssql/pyodbc.pytqs A0