Ñò
ˆ„[Jc  @ s1 d Z d d k Z d d k Z d d k Z d d k Z d d k Z d d k Z d d k Z d d k l Z l
Z
l Z l Z d d k l
Z
l Z l Z l Z l Z l Z d d k l Z l Z l Z l Z l Z d d k l Z l Z d d k l Z d d k l Z! e" d d
d d d
d d d d d d d d d d d d d d d d d d d d! d" d# d$ d% d& d' d( d) d* d+ d, d- d. d/ d0 d1 d2 d3 d4 d5 d6 d7 d8 d9 d: d; d< d= d> d? d@ dA dB dC dD dE dF dG dH dI dJ dK dL dM dN dO dP dQ dR dS dT dU dV dW dX dY dZ d[ d\ d] d^ d_ d` da db dc dd de df dg dh di dj dk dl dm dn do dp dq dr ds dt du dv dw dx dy dz d{ d| d} d~ d d€ d d‚ dƒ d„ d… d† d‡ dˆ d‰ dŠ d‹ dŒ d dŽ d d d‘ d’ d“ d” d• d– d— d˜ d™ dš d› dœ d dž dŸ d d¡ d¢ d£ d¤ d¥ d¦ d§ d¨ d© dª d« d¬ d d® d¯ d° d± d² d³ d´ dµ d¶ d· d¸ d¹ dº d» d¼ g´ ƒ Z# d½ e$ f d¾ „ ƒ YZ% d¿ e i& f dÀ „ ƒ YZ' dÁ e i( f d „ ƒ YZ) dà e) f dÄ „ ƒ YZ* dÅ e i f dÆ „ ƒ YZ+ dÇ e+ f dÈ „ ƒ YZ, dÉ e+ f dÊ „ ƒ YZ- dË e+ f dÌ „ ƒ YZ. dÍ e$ f dÎ „ ƒ YZ/ dÏ e/ e i0 f dÐ „ ƒ YZ1 dÑ e i2 f dÒ „ ƒ YZ3 dÓ e i4 f dÔ „ ƒ YZ5 dÕ e/ e i6 f dÖ „ ƒ YZ7 d× e/ e i6 f dØ „ ƒ YZ8 dÙ e/ e i6 f dÚ „ ƒ YZ9 dÛ e/ e3 f dÜ „ ƒ YZ: dÝ e5 f dÞ „ ƒ YZ; dß e1 f dà „ ƒ YZ< dá e% e i= f dâ „ ƒ YZ> dã e% e i? f dä „ ƒ YZ@ då e% e i f dæ „ ƒ YZA dç e% e iB f dè „ ƒ YZC dé e% e iD f dê „ ƒ YZE dë e% e iF f dì „ ƒ YZG dí e iH f dî „ ƒ YZI dï eI f dð „ ƒ YZJ dñ eI f dò „ ƒ YZK dó eI f dô „ ƒ YZL dõ e iM f dö „ ƒ YZN d÷ e iO f dø „ ƒ YZP dù e i6 f dú „ ƒ YZQ dû eQ f dü „ ƒ YZR dý e i6 f dþ „ ƒ YZS dÿ e i6 f d „ ƒ YZT e ƒ ZU e
deU e de dc dƒe de dc dƒe de dc dƒd˜ dƒZV e
d eU e d
e dc d ƒe d e dc d
ƒe de dc dƒe de dc dƒd˜ dƒZW e
deU e d e dc d
ƒe de dc dƒe de dc dƒe de dc dƒe de dc dƒe de dc dƒe de dc d ƒe d e dc d ƒe d e dc d ƒe d!e dc d"ƒe d#e dc d$ƒd˜ dƒ
ZX e
d%eU e d e dc d
ƒe de dc dƒe d&e dc d'ƒe d(e dc d)ƒd˜ dƒZY e
d*eU e d e dc d
ƒe de dc dƒe de dc dƒe d&e dc d'ƒd˜ dƒZZ e
d+eU e d e dc d
ƒe de dc dƒe de dc dƒe d&e dc d'ƒe de dc dƒd˜ dƒZ[ e
d,eU e d-e dc d.ƒe d/e dc d0ƒe d&e dc d'ƒe d1e dc d2ƒe d3e dc d4ƒe d5e dc d6ƒe d7e dc d8ƒe d9e dc d:ƒe d;e dc d<ƒd˜ dƒ Z\ d=„ Z] d>„ Z^ d?e i_ f d@„ ƒ YZ` dAe` f dB„ ƒ YZa dCe ib f dD„ ƒ YZc dEec f dF„ ƒ YZd dGec f dH„ ƒ YZe dIec f dJ„ ƒ YZf h ed dK6ee dL6ef dM6Zg dNe ih f dO„ ƒ YZi dPe ij f dQ„ ƒ YZk dRe il f dS„ ƒ YZm dTe in f dU„ ƒ YZo ec Zp ei ep _q ek ep _r em ep _s eo ep _t d S(V sp Support for the Microsoft SQL Server database.
Driver
------
The MSSQL dialect will work with three different available drivers:
* *pyodbc* - http://pyodbc.sourceforge.net/. This is the recommeded
driver.
* *pymssql* - http://pymssql.sourceforge.net/
* *adodbapi* - http://adodbapi.sourceforge.net/
Drivers are loaded in the order listed above based on availability.
If you need to load a specific driver pass ``module_name`` when
creating the engine::
engine = create_engine('mssql://dsn', module_name='pymssql')
``module_name`` currently accepts: ``pyodbc``, ``pymssql``, and
``adodbapi``.
Currently the pyodbc driver offers the greatest level of
compatibility.
Connecting
----------
Connecting with create_engine() uses the standard URL approach of
``mssql://user:pass@host/dbname[?key=value&key=value...]``.
If the database name is present, the tokens are converted to a
connection string with the specified values. If the database is not
present, then the host token is taken directly as the DSN name.
Examples of pyodbc connection string URLs:
* *mssql://mydsn* - connects using the specified DSN named ``mydsn``.
The connection string that is created will appear like::
dsn=mydsn;TrustedConnection=Yes
* *mssql://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://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://user:pass@host/db* - connects using a connection string
dynamically created that would appear like::
DRIVER={SQL Server};Server=host;Database=db;UID=user;PWD=pass
* *mssql://user:pass@host:123/db* - connects using a connection
string that is dynamically created, which also includes the port
information using the comma syntax. If your connection string
requires the port information to be passed as a ``port`` keyword
see the next example. This will create the following connection
string::
DRIVER={SQL Server};Server=host,123;Database=db;UID=user;PWD=pass
* *mssql://user:pass@host/db?port=123* - connects using a connection
string that is dynamically created 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
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:///?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'
Additional arguments which may be specified either as query string
arguments on the URL, or as keyword argument to
:func:`~sqlalchemy.create_engine()` are:
* *auto_identity_insert* - enables support for IDENTITY inserts by
automatically turning IDENTITY INSERT ON and OFF as required.
Defaults to ``True``.
* *query_timeout* - allows you to override the default query timeout.
Defaults to ``None``. This is only supported on pymssql.
* *text_as_varchar* - if enabled this will treat all TEXT column
types as their equivalent VARCHAR(max) type. This is often used if
you need to compare a VARCHAR to a TEXT field, which is not
supported directly on MSSQL. Defaults to ``False``.
* *use_scope_identity* - allows you to specify that SCOPE_IDENTITY
should be used in place of the non-scoped version @@IDENTITY.
Defaults to ``False``. On pymssql this defaults to ``True``, and on
pyodbc this defaults to ``True`` if the version of pyodbc being
used supports it.
* *has_window_funcs* - indicates whether or not window functions
(LIMIT and OFFSET) are supported on the version of MSSQL being
used. If you're running MSSQL 2005 or later turn this on to get
OFFSET support. Defaults to ``False``.
* *max_identifier_length* - allows you to se the maximum length of
identfiers supported by the database. Defaults to 128. For pymssql
the default is 30.
* *schema_name* - use to set the schema name. Defaults to ``dbo``.
Auto Increment Behavior
-----------------------
``IDENTITY`` columns are supported by using SQLAlchemy
``schema.Sequence()`` objects. In other words::
Table('test', mss_engine,
Column('id', Integer,
Sequence('blah',100,10), primary_key=True),
Column('name', String(20))
).create()
would yield::
CREATE TABLE test (
id INTEGER NOT NULL IDENTITY(100,10) PRIMARY KEY,
name VARCHAR(20) NULL,
)
Note that the ``start`` and ``increment`` values for sequences are
optional and will default to 1,1.
* Support for ``SET IDENTITY_INSERT ON`` mode (automagic on / off for
``INSERT`` s)
* Support for auto-fetching of ``@@IDENTITY/@@SCOPE_IDENTITY()`` on
``INSERT``
Collation Support
-----------------
MSSQL specific string types support a collation parameter that
creates a column-level specific collation for the column. The
collation parameter accepts a Windows Collation Name or a SQL
Collation Name. Supported types are MSChar, MSNChar, MSString,
MSNVarchar, MSText, and MSNText. For example::
Column('login', String(32, collation='Latin1_General_CI_AS'))
will yield::
login VARCHAR(32) COLLATE Latin1_General_CI_AS NULL
LIMIT/OFFSET Support
--------------------
MSSQL has no support for the LIMIT or OFFSET keysowrds. LIMIT is
supported directly through the ``TOP`` Transact SQL keyword::
select.limit
will yield::
SELECT TOP n
If the ``has_window_funcs`` flag is set then LIMIT with OFFSET
support is available through the ``ROW_NUMBER OVER`` construct. This
construct requires an ``ORDER BY`` to be specified as well and is
only available on MSSQL 2005 and later.
Nullability
-----------
MSSQL has support for three levels of column nullability. The default
nullability allows nulls and is explicit in the CREATE TABLE
construct::
name VARCHAR(20) NULL
If ``nullable=None`` is specified then no specification is made. In
other words the database's configured default is used. This will
render::
name VARCHAR(20)
If ``nullable`` is ``True`` or ``False`` then the column will be
``NULL` or ``NOT NULL`` respectively.
Date / Time Handling
--------------------
For MSSQL versions that support the ``DATE`` and ``TIME`` types
(MSSQL 2008+) the data type is used. For versions that do not
support the ``DATE`` and ``TIME`` types a ``DATETIME`` type is used
instead and the MSSQL dialect handles converting the results
properly. This means ``Date()`` and ``Time()`` are fully supported
on all versions of MSSQL. If you do not desire this behavior then
do not use the ``Date()`` or ``Time()`` types.
Compatibility Levels
--------------------
MSSQL supports the notion of setting compatibility levels at the
database level. This allows, for instance, to run a database that
is compatibile with SQL2000 while running on a SQL2005 database
server. ``server_version_info`` will always retrun the database
server version information (in this case SQL2005) and not the
compatibiility level information. Because of this, if running under
a backwards compatibility mode SQAlchemy may attempt to use T-SQL
statements that are unable to be parsed by the database server.
Known Issues
------------
* No support for more than one ``IDENTITY`` column per table
* pymssql has problems with binary and unicode data that this module
does **not** work around
iÿÿÿÿN( t sqlt schemat exct util( t Tablet MetaDatat Columnt
ForeignKeyt Stringt Integer( t selectt compilert
expressiont operatorst functions( t defaultt base( t types( t Decimalt addt allt altert andt anyt ast asct
authorizationt backupt begint betweent breakt browset bulkt byt cascadet caset checkt
checkpointt closet clusteredt coalescet collatet columnt committ computet
constraintt containst
containstablet continuet convertt createt crosst currentt current_datet current_timet current_timestampt current_usert cursort databaset dbcct
deallocatet declareR t deletet denyt desct diskt distinctt distributedt doublet dropt dumpt elset endt errlvlt escapet exceptt exect executet existst exitt externalt fetcht filet
fillfactort fort foreignt freetextt
freetexttablet fromt fullt functiont gotot grantt groupt havingt holdlockt identityt identity_insertt identitycolt ift int indext innert insertt intersectt intot ist joint keyt killt leftt liket linenot loadt merget nationalt nocheckt nonclusteredt nott nullt nullift oft offt offsetst ont opent opendatasourcet openqueryt
openrowsett openxmlt optiont ort ordert outert overt percentt pivott plant precisiont primaryt printt proct proceduret publict raiserrort readt readtextt reconfiguret
referencest replicationt restoret restrictt returnt revertt revoket rightt rollbackt rowcountt
rowguidcolt rulet saveR t
securityauditR
t session_usert sett setusert shutdownt somet
statisticst system_usert tablet tablesamplet textsizet thent tot topt trant transactiont triggert truncatet tsequalt uniont uniquet unpivott updatet
updatetextt uset usert valuest varyingt viewt waitfort whent wheret whilet witht writetextt _StringTypec B s5 e Z d Z d d „ Z d „ Z d „ Z d „ Z RS( s Base for MSSQL string types.c K s | i d | ƒ | _ d S( NR) ( t gett collation( t selfRÆ t kwargs( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyt __init__ s c C s` | i o d | i } n d } d i g } | | f D] } | d j o | | q8 q8 ~ ƒ S( sX Extend a string-type declaration with standard SQL
COLLATE annotations.
s
COLLATE %st N( RÆ t NoneRk ( RÇ t specRÆ t _[1]t c( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyt _extend" s
c C sÏ t i | i ƒ d d } | i t i t i ƒ d d ƒ h } xE | D]= } t | | ƒ } | d j o | t j o | | | /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyt __repr__/ s ! c sb | i p
| i oF | i d j o
| i ‰ n
| i ‰ ˆ p d S‡ f d † } | Sd Sd S( Nc s[ t | t t i f ƒ p: ˆ d j o t i d | ƒ | St i d | ƒ ‚ n | Sd S( Nt warns5 Unicode type received non-unicode bind param value %r( t
isinstancet unicodet sqltypest NoneTypeR RÝ R t InvalidRequestError( t value( t assert_unicode( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyt processF s
( t convert_unicodeRä RË ( RÇ t dialectRå ( ( Rä s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyt bind_processor< s
N( RÖ t
__module__t __doc__RË RÉ RÏ RÜ Rè ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRÄ s
t MSNumericc B s# e Z d „ Z d „ Z d „ Z RS( c C s) | i o d „ } | Sd „ } | Sd S( Nc S s& | d j o t t | ƒ ƒ S| Sd S( N( RË t _python_Decimalt str( Rã ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRå X s
c S s
t | ƒ S( N( t float( Rã ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRå _ s ( t asdecimal( RÇ Rç Rå ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyt result_processorV s
c C s
d „ } | S( Nc S s] | d j o | St | t i ƒ o0| i ƒ d j ol d | d j o d p d d t | i ƒ ƒ d d i g } | i D] } | t | ƒ q} ~ ƒ f } nd t | ƒ j os d | d j o d p d d i g } | i D] } | t | ƒ qå ~ ƒ d | i ƒ t | i ƒ d f } n't | i ƒ d | i ƒ j o¤ d | d j o d p d d i g } | i D] } | t | ƒ qx~ d | i ƒ d !ƒ d i g } | i D] } | t | ƒ q¹~ | i ƒ d ƒ f } nc d
| d j o d p d d i g } | i D] } | t | ƒ q ~ d | i ƒ d !ƒ f } | S| Sd S( Ni s %s0.%s%st -t t 0i t Es %s%s%ss %s%s.%ss %s%s(
RË RÞ t decimalR t adjustedt absRk t _intRí t len( Rã RÍ t nintt resultt _[2]t st _[3]t _[4]t _[5]( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRå d s.
;0) AIH( ( RÇ Rç Rå ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRè c s "c C s5 | i d j o d Sd h | i d 6| i d 6Sd S( Nt NUMERICs! NUMERIC(%(precision)s, %(scale)s)RŠ t scale( RŠ RË R ( RÇ ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyt get_col_specˆ s ( RÖ Ré Rð Rè R ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRë U s
%t MSFloatc B s e Z d „ Z RS( c C s+ | i d j o d Sd h | i d 6Sd S( Nt FLOATs FLOAT(%(precision)s)RŠ ( RŠ RË ( RÇ ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyR s ( RÖ Ré R ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyR s t MSRealc B s) e Z d Z d „ Z d „ Z d „ Z RS( s A type for ``real`` numbers.c C s t t | ƒ i d d ƒ d S( s$
Construct a Real.
RŠ i N( t superR RÉ ( RÇ ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRÉ š s c C s | ƒ S( N( ( RÇ t impltype( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyt adapt¡ s c C s d S( Nt REAL( ( RÇ ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyR ¤ s ( RÖ Ré Rê RÉ R R ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyR — s t MSIntegerc B s e Z d „ Z RS( c C s d S( Nt INTEGER( ( RÇ ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyR © s ( RÖ Ré R ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyR ¨ s t MSBigIntegerc B s e Z d „ Z RS( c C s d S( Nt BIGINT( ( RÇ ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyR ® s ( RÖ Ré R ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyR
s t
MSTinyIntegerc B s e Z d „ Z RS( c C s d S( Nt TINYINT( ( RÇ ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyR ³ s ( RÖ Ré R ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyR ² s t MSSmallIntegerc B s e Z d „ Z RS( c C s d S( Nt SMALLINT( ( RÇ ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyR ¸ s ( RÖ Ré R ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyR · s t
_DateTimeTypec B s e Z d Z d „ Z RS( s Base for MSSQL datetime types.c C s
d „ } | S( Nc S s7 t | ƒ t i j o t i | i | i | i ƒ S| S( N( t typet datetimet datet yeart montht day( Rã ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRå Â s ( ( RÇ Rç Rå ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRè ¿ s ( RÖ Ré Rê Rè ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyR ¼ s t
MSDateTimec B s e Z d „ Z RS( c C s d S( Nt DATETIME( ( RÇ ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyR Ê s ( RÖ Ré R ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyR É s t MSDatec B s e Z d „ Z RS( c C s d S( Nt DATE( ( RÇ ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyR Ï s ( RÖ Ré R ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyR Î s t MSTimec B s e Z d d „ Z d „ Z RS( c K s | | _ t t | ƒ i ƒ d S( N( RŠ R R RÉ ( RÇ RŠ RÈ ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRÉ Ô s c C s | i o d | i Sd Sd S( Ns TIME(%s)t TIME( RŠ ( RÇ ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyR Ø s
N( RÖ Ré RË RÉ R ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyR Ó s t MSSmallDateTimec B s e Z d „ Z RS( c C s d S( Nt
SMALLDATETIME( ( RÇ ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyR à s ( RÖ Ré R ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyR ß s t MSDateTime2c B s e Z d d „ Z d „ Z RS( c K s
| | _ d S( N( RŠ ( RÇ RŠ RÈ ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRÉ å s c C s | i o d | i Sd Sd S( Ns
DATETIME2(%s)t DATETIME2( RŠ ( RÇ ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyR è s
N( RÖ Ré RË RÉ R ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyR" ä s t MSDateTimeOffsetc B s e Z d d „ Z d „ Z RS( c K s
| | _ d S( N( RŠ ( RÇ RŠ RÈ ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRÉ ð s c C s | i o d | i Sd Sd S( Ns DATETIMEOFFSET(%s)t DATETIMEOFFSET( RŠ ( RÇ ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyR ó s
N( RÖ Ré RË RÉ R ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyR$ ï s t MSDateTimeAsDatec B s e Z d Z d „ Z d „ Z RS( sý This is an implementation of the Date type for versions of MSSQL that
do not support that specific type. In order to make it work a ``DATETIME``
column specification is used and the results get converted back to just
the date portion.
c C s d S( NR ( ( RÇ ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyR s c C s
d „ } | S( Nc S s% t | ƒ t i j o | i ƒ S| S( N( R R R ( Rã ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRå s ( ( RÇ Rç Rå ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRð s ( RÖ Ré Rê R Rð ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyR& ú s t MSDateTimeAsTimec B s> e Z d Z e i d d d ƒ Z d „ Z d „ Z d „ Z RS( sý This is an implementation of the Time type for versions of MSSQL that
do not support that specific type. In order to make it work a ``DATETIME``
column specification is used and the results get converted back to just
the time portion.
il i c C s d S( NR ( ( RÇ ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyR s c s ‡ f d † } | S( Nc sn t | ƒ t i j o" t i i ˆ i | i ƒ ƒ } n3 t | ƒ t i j o t i i ˆ i | ƒ } n | S( N( R R t combinet _MSDateTimeAsTime__zero_datet time( Rã ( RÇ ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRå s
" ( ( RÇ Rç Rå ( ( RÇ s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRè s c C s
d „ } | S( Nc S sO t | ƒ t i j o | i ƒ St | ƒ t i j o t i d d d ƒ S| S( Ni ( R R R* R ( Rã ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRå & s
( ( RÇ Rç Rå ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRð % s ( RÖ Ré Rê R R R) R Rè Rð ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyR' s
t MSDateTime_adodbapic B s e Z d „ Z RS( c C s
d „ } | S( Nc S s7 t | ƒ t i j o t i | i | i | i ƒ S| S( N( R R R R R R ( Rã ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRå 1 s ( ( RÇ Rç Rå ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRð 0 s ( RÖ Ré Rð ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyR+ / s t MSTextc B s e Z d Z d „ Z d „ Z RS( s@ MSSQL TEXT type, for variable-length text up to 2^31 characters.c O sK t i | | t i i | d d | i d t ƒ d | i d d ƒ ƒd S( s´ Construct a TEXT.
:param collation: Optional, a column-level collation for this string
value. Accepts a Windows Collation Name or a SQL Collation Name.
Ræ Rä N( RÄ RÉ Rà t TextRË RÅ RÔ ( RÇ t argsRÈ ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRÉ = s c C s, | i i o | i d ƒ S| i d ƒ Sd S( Ns VARCHAR(max)t TEXT( Rç t text_as_varcharRÏ ( RÇ ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyR I s
( RÖ Ré Rê RÉ R ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyR, : s t MSNTextc B s e Z d Z d „ Z d „ Z RS( sM MSSQL NTEXT type, for variable-length unicode text up to 2^30
characters.c O sK t i | | t i i | d d | i d t ƒ d | i d d ƒ ƒd S( sµ Construct a NTEXT.
:param collation: Optional, a column-level collation for this string
value. Accepts a Windows Collation Name or a SQL Collation Name.
Ræ Rä RÝ N( RÄ RÉ Rà t UnicodeTextRË RÅ t True( RÇ R. RÈ ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRÉ T s c C s, | i i o | i d ƒ S| i d ƒ Sd S( Ns
NVARCHAR(max)t NTEXT( Rç R0 RÏ ( RÇ ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyR ` s
( RÖ Ré Rê RÉ R ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyR1 P s t MSStringc B s) e Z d Z d e d d „ Z d „ Z RS( s` MSSQL VARCHAR type, for variable-length non-Unicode data with a maximum
of 8,000 characters.c K s6 t i | | t i i | d | d | d | ƒd S( sY Construct a VARCHAR.
:param length: Optinal, maximum data length, in characters.
:param convert_unicode: defaults to False. If True, convert
``unicode`` data sent to the database to a ``str``
bytestring, and convert bytestrings coming back from the
database into ``unicode``.
Bytestrings are encoded using the dialect's
:attr:`~sqlalchemy.engine.base.Dialect.encoding`, which
defaults to `utf-8`.
If False, may be overridden by
:attr:`sqlalchemy.engine.base.Dialect.convert_unicode`.
:param assert_unicode:
If None (the default), no assertion will take place unless
overridden by :attr:`sqlalchemy.engine.base.Dialect.assert_unicode`.
If 'warn', will issue a runtime warning if a ``str``
instance is used as a bind value.
If true, will raise an :exc:`sqlalchemy.exc.InvalidRequestError`.
:param collation: Optional, a column-level collation for this string
value. Accepts a Windows Collation Name or a SQL Collation Name.
t lengthRæ Rä N( RÄ RÉ Rà R ( RÇ R6 Ræ Rä RÈ ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRÉ k s c C s0 | i o | i d | i ƒ S| i d ƒ Sd S( Ns VARCHAR(%s)t VARCHAR( R6 RÏ ( RÇ ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyR s
N( RÖ Ré Rê RË RÔ RÉ R ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyR5 g s $t
MSNVarcharc B s, e Z d Z d d „ Z d „ Z d „ Z RS( s\ MSSQL NVARCHAR type.
For variable-length unicode character data up to 4,000 characters.c
K sN t i | | t i i | d | d | i d t ƒ d | i d d ƒ ƒd S( sþ Construct a NVARCHAR.
:param length: Optional, Maximum data length, in characters.
:param collation: Optional, a column-level collation for this string
value. Accepts a Windows Collation Name or a SQL Collation Name.
R6 Ræ Rä RÝ N( RÄ RÉ Rà t UnicodeRÅ R3 ( RÇ R6 RÈ ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRÉ › s c C s+ | d | i d | i d | i d | i ƒ S( NR6 Ræ Rä RÆ ( R6 Ræ Rä RÆ ( RÇ R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyR © s c C s7 | i o | i d h | i d 6ƒ S| i d ƒ Sd S( Ns NVARCHAR(%(length)s)R6 t NVARCHAR( R6 RÏ ( RÇ ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyR ¯ s
N( RÖ Ré Rê RË RÉ R R ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyR8 – s t MSCharc B s) e Z d Z d e d d „ Z d „ Z RS( sZ MSSQL CHAR type, for fixed-length non-Unicode data with a maximum
of 8,000 characters.c K s6 t i | | t i i | d | d | d | ƒd S( sV Construct a CHAR.
:param length: Optinal, maximum data length, in characters.
:param convert_unicode: defaults to False. If True, convert
``unicode`` data sent to the database to a ``str``
bytestring, and convert bytestrings coming back from the
database into ``unicode``.
Bytestrings are encoded using the dialect's
:attr:`~sqlalchemy.engine.base.Dialect.encoding`, which
defaults to `utf-8`.
If False, may be overridden by
:attr:`sqlalchemy.engine.base.Dialect.convert_unicode`.
:param assert_unicode:
If None (the default), no assertion will take place unless
overridden by :attr:`sqlalchemy.engine.base.Dialect.assert_unicode`.
If 'warn', will issue a runtime warning if a ``str``
instance is used as a bind value.
If true, will raise an :exc:`sqlalchemy.exc.InvalidRequestError`.
:param collation: Optional, a column-level collation for this string
value. Accepts a Windows Collation Name or a SQL Collation Name.
R6 Ræ Rä N( RÄ RÉ Rà t CHAR( RÇ R6 Ræ Rä RÈ ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRÉ º s c C s0 | i o | i d | i ƒ S| i d ƒ Sd S( Ns CHAR(%s)R< ( R6 RÏ ( RÇ ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyR Þ s
N( RÖ Ré Rê RË RÔ RÉ R ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyR; ¶ s $t MSNCharc B s# e Z d Z d d „ Z d „ Z RS( sV MSSQL NCHAR type.
For fixed-length unicode character data up to 4,000 characters.c
K sN t i | | t i i | d | d | i d t ƒ d | i d d ƒ ƒd S( sü Construct an NCHAR.
:param length: Optional, Maximum data length, in characters.
:param collation: Optional, a column-level collation for this string
value. Accepts a Windows Collation Name or a SQL Collation Name.
R6 Ræ Rä RÝ N( RÄ RÉ Rà t NCHARRÅ R3 ( RÇ R6 RÈ ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRÉ ê s c C s7 | i o | i d h | i d 6ƒ S| i d ƒ Sd S( Ns NCHAR(%(length)s)R6 R> ( R6 RÏ ( RÇ ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyR ø s
N( RÖ Ré Rê RË RÉ R ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyR= å s t MSGenericBinaryc B s e Z d Z d „ Z RS( s
The Binary type assumes that a Binary specification without a length
is an unbound Binary type whereas one with a length specification results
in a fixed length Binary type.
If you want standard MSSQL ``BINARY`` behavior use the ``MSBinary`` type.
c C s | i o d | i Sd Sd S( Ns
BINARY(%s)t IMAGE( R6 ( RÇ ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyR s
( RÖ Ré Rê R ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyR? ÿ s t MSBinaryc B s e Z d „ Z RS( c C s | i o d | i Sd Sd S( Ns
BINARY(%s)t BINARY( R6 ( RÇ ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyR s
( RÖ Ré R ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRA s t MSVarBinaryc B s e Z d „ Z RS( c C s | i o d | i Sd Sd S( Ns
VARBINARY(%s)t VARBINARY( R6 ( RÇ ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyR s
( RÖ Ré R ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRC s t MSImagec B s e Z d „ Z RS( c C s d S( NR@ ( ( RÇ ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyR s ( RÖ Ré R ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRE s t MSBooleanc B s# e Z d „ Z d „ Z d „ Z RS( c C s d S( Nt BIT( ( RÇ ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyR % s c C s
d „ } | S( Nc S s$ | d j o d S| o t p t S( N( RË R3 RÔ ( Rã ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRå ) s
( ( RÇ Rç Rå ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRð ( s c C s
d „ } | S( Nc S sL | t j o d S| t j o d S| d j o d S| o t p t Sd S( Ni i ( R3 RÔ RË ( Rã ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRå 0 s
( ( RÇ Rç Rå ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRè / s ( RÖ Ré R Rð Rè ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRF $ s t MSTimeStampc B s e Z d „ Z RS( c C s d S( Nt TIMESTAMP( ( RÇ ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyR = s ( RÖ Ré R ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRH < s t MSMoneyc B s e Z d „ Z RS( c C s d S( Nt MONEY( ( RÇ ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyR B s ( RÖ Ré R ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRJ A s t MSSmallMoneyc B s e Z d „ Z RS( c C s d S( Nt
SMALLMONEY( ( RÇ ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyR G s ( RÖ Ré R ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRL F s t MSUniqueIdentifierc B s e Z d „ Z RS( c C s d S( Nt UNIQUEIDENTIFIER( ( RÇ ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyR L s ( RÖ Ré R ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRN K s t MSVariantc B s e Z d „ Z RS( c C s d S( Nt SQL_VARIANT( ( RÇ ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyR Q s ( RÖ Ré R ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRP P s t SCHEMATAt CATALOG_NAMEt catalog_namet SCHEMA_NAMEt schema_namet SCHEMA_OWNERt schema_ownert INFORMATION_SCHEMAt TABLESt
TABLE_CATALOGt
table_catalogt TABLE_SCHEMAt table_schemat
TABLE_NAMEt
table_namet
TABLE_TYPEt
table_typet COLUMNSt COLUMN_NAMEt column_namet IS_NULLABLEt is_nullablet DATA_TYPEt data_typet ORDINAL_POSITIONt ordinal_positiont CHARACTER_MAXIMUM_LENGTHt character_maximum_lengtht NUMERIC_PRECISIONt numeric_precisiont
NUMERIC_SCALEt
numeric_scalet COLUMN_DEFAULTt column_defaultt COLLATION_NAMEt collation_namet TABLE_CONSTRAINTSt CONSTRAINT_NAMEt constraint_namet CONSTRAINT_TYPEt constraint_typet CONSTRAINT_COLUMN_USAGEt KEY_COLUMN_USAGEt REFERENTIAL_CONSTRAINTSt CONSTRAINT_CATALOGt constraint_catalogt CONSTRAINT_SCHEMAt constraint_schemat UNIQUE_CONSTRAINT_CATLOGt unique_constraint_catalogt UNIQUE_CONSTRAINT_SCHEMAt unique_constraint_schemat UNIQUE_CONSTRAINT_NAMEt unique_constraint_namet MATCH_OPTIONt match_optiont UPDATE_RULEt update_rulet DELETE_RULEt delete_rulec C se | i o[ | i oQ t | i t i ƒ o; | i o0 | i d j p t | i t i
ƒ o
| i i S( N( t primary_keyt
autoincrementRÞ R Rà R t foreign_keysR RË R t Sequencet optional( R* ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyt _has_implicit_sequence“ s
c C sf t | d ƒ pO d | _ xC | i D]4 } t | d t ƒ p
t | ƒ o | | _ Pq# q# Wn | i S( Nt _ms_has_sequencet sequence( t hasattrRË R” RÎ RÓ RÔ R“ ( t tblR* ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyt _table_sequence_columnŸ s
t MSSQLExecutionContextc B s/ e Z e Z e Z d „ Z d „ Z d „ Z RS( c C s¹ | i i o¨ | i i i } t | ƒ } t | ƒ | _ | i i o* | i o | i i
| i d j | _ n
t
| _ | i o0 | i i d | i i i | i i i ƒ ƒ qµ n d S( s# Activate IDENTITY_INSERT if needed.i s SET IDENTITY_INSERT %s ONN( t compiledt isinsertt statementR© R˜ t boolt HASIDENTRç t auto_identity_insertR” Rl t compiled_parameterst IINSERTRÔ R9 RM t identifier_preparert format_table( RÇ R— t
seq_column( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyt pre_exec¬ s
c C sL | i o> y0 | i i d | i i i | i i i ƒ ƒ WqH qH Xn d S( Ns SET IDENTITY_INSERT %s OFF( R¡ R9 RM Rç R¢ R£ Rš Rœ R© ( RÇ t e( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyt handle_dbapi_exception¼ s
0c C só | i i o¨ | i o | i o“ | i oˆ | i p | i d d j oe | i i o | i i
d ƒ n | i i
d ƒ | i i ƒ } t | d ƒ g | i d | _ qµ n | i o0 | i i
d | i i
i | i i i ƒ ƒ n d S( s# Disable IDENTITY_INSERT if enabled.i s$ SELECT scope_identity() AS lastrowids SELECT @@identity AS lastrowidi s SET IDENTITY_INSERT %s OFFN( Rš R› t executemanyRž R¡ t _last_inserted_idsRË Rç t use_scope_identityR9 RM t fetchonet intR¢ R£ Rœ R© ( RÇ t row( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyt post_execà s -
)
( RÖ Ré RÔ R¡ Rž R¥ R§ R® ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyR™ ¨ s
t MSSQLExecutionContext_pyodbcc B s e Z d „ Z d „ Z RS( c C so t t | ƒ i ƒ | i i oK | i oA | i o6 t | i ƒ d j o | i i
o | i d 7_ n d S( sH where appropriate, issue "select scope_identity()" in the same statementi s ; select scope_identity()N( R R¯ R¥ Rš R› Rž R¡ Rù t
parametersRç Rª Rœ ( RÇ ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyR¥ Ô s "#c C sµ | i o” | i o‰ | i i o| | i oq d d k } xH t o@ y | i i ƒ } PWq< | i j
o } | i i
ƒ q< Xq< Wt | d ƒ g | _ n t
t | ƒ i ƒ d S( Niÿÿÿÿi ( Rž R¡ Rç Rª R¨ t pyodbcR3 R9 R« t Errort nextsetR¬ R© R R¯ R® ( RÇ R± R R¦ ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyR® Û s - ( RÖ Ré R¥ R® ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyR¯ Ó s t MSSQLDialectc B so e Z d Z e Z e Z e Z e Z e Z
e Z e Z d Z
d Z h e e i 6e e i 6e e i 6e e i 6e e i 6e e i 6e e i 6e e i 6e e i! 6e" e i# 6e$ e i% 6e& e i' 6e( e i) 6e* e i+ 6e, e i- 6e. e i/ 6Z0 h e d 6e1 d 6e d 6e2 d 6e d 6e d 6e* d 6e, d
6e& d 6e( d 6e d
6e d 6e d 6e d 6e3 d 6e4 d 6e d 6e d 6e5 d 6e6 d 6e7 d 6e$ d 6e d 6e8 d 6e. d 6e9 d 6e: d 6e; d 6e< d 6Z= d „ Z> e d0 e e e d0 d d! „ Z@ eA d0 d" „ ƒ ZB eC iD d1 ƒ d$ „ ƒ ZE d% „ ZF d& „ ZG d' „ ZH d( „ ZI d) „ ZJ eC iD d2 ƒ d, „ ƒ ZK d- „ ZL d0 d. „ ZM d/ „ ZN RS(3 t mssqli€ t dboR¬ t bigintt smallintt tinyintt varchart nvarchart chart nchart textt ntextRõ t numericRî R t datetime2t datetimeoffsetR R* t
smalldatetimet binaryt varbinaryt bitt realt imaget timestampt moneyt
smallmoneyt uniqueidentifiert sql_variantc O sw | t j o t t | ƒ i | | | Ž S| i d d ƒ } | o t i | i ƒ } | | St i | | | Ž Sd S( Nt dbapi( R´ R t __new__RÅ RË t dialect_mappingRÖ t object( t clsR. RÈ RÎ Rç ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRÏ ) s
c K s• t | ƒ | _ t | p d ƒ | _ | | _ t | ƒ | _ t | ƒ | _ t | ƒ | _ t | p d ƒ p | i | _ t t
| ƒ i | d S( Ni ( R RŸ R¬ t
query_timeoutRV R0 Rª t has_window_funcst max_identifier_lengthR R´ RÉ ( RÇ RŸ RÓ R0 Rª RÔ RÕ RV t opts( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRÉ 4 s c C sœ | oE y t | } | i ƒ SWq˜ t j
o t i d | ƒ ‚ q˜ XnM xI t t t g D], } y | i ƒ SWq\ t j
o } q\ Xq\ Wt d ƒ ‚ d S( NsL Unsupported MSSQL module '%s' requested (must be adodbpi, pymssql or pyodbc)sP No DBAPI module detected for MSSQL - please install pyodbc, pymssql, or adodbapi( RÐ t import_dbapit KeyErrorR Râ t MSSQLDialect_pyodbct MSSQLDialect_pymssqlt MSSQLDialect_adodbapit ImportError( RÒ t module_namet dialect_clsR¦ ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRÎ E s
t server_version_infoc C s | i i | i ƒ S( s’ A tuple of the database server version.
Formats the remote server version as a tuple of version values,
e.g. ``(9, 0, 1399)``. If there are strings in the version number
they will be in the tuple too, so don't count on these all being
``int`` values.
This is a fast check that does not require a round trip. It is also
cached per-Connection.
( Rç t _server_version_infot
connection( RÇ Rá ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRß V s c C s
t ƒ ‚ d S( s0 Return a tuple of the database's version number.N( t NotImplementedError( RÇ t dbapi_con( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRà d s c C s | i d d ƒ } | i | i ƒ d | j o" t t | i d ƒ ƒ ƒ | _ n d | j o t | i d ƒ ƒ | _ n d | j o" t t | i d ƒ ƒ ƒ | _ n d | j o" t t | i d ƒ ƒ ƒ | _ n d | j o" t t | i d ƒ ƒ ƒ | _
n | i | | i ƒ S( Nt usernameRº RŸ RÓ R0 Rª RÔ ( t translate_connect_argsR· t queryR R¬ t popRŸ RÓ R0 Rª RÔ t make_connect_string( RÇ t urlRÖ ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyt create_connect_argsh s
"
"
"
"c C s< t i | | i ƒ } t | t t f ƒ o
| | _ n | S( N( Rà t
adapt_typet colspecsRÞ R, R1 Rç ( RÇ t typeobjt newobj( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyt type_descriptorw s
c C s/ t i d ƒ | i d ƒ | i d | ƒ d S( NsE Savepoint support in mssql is experimental and may lead to data loss.s$ IF @@TRANCOUNT = 0 BEGIN TRANSACTIONs SAVE TRANSACTION %s( R RÝ RM ( RÇ Rá t name( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyt do_savepoint~ s
c C s d S( N( ( RÇ Rá Rð ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyt do_release_savepointƒ s Rç t default_schema_namec C sz d } | i t i | ƒ ƒ } | d j oH d } y4 | i t i | ƒ d | ƒ} | d j o | SWqs qs Xn | i S( Ns SELECT user_name() as user_name;sœ
SELECT default_schema_name FROM
sys.database_principals
WHERE name = :user_name
AND type = 'S'
t user_name( t scalarR R¾ RË RV ( RÇ Rá Ræ Rô Ró ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyt get_default_schema_name† s
c C sP t t i i g t i i | j ƒ } g } | i | ƒ D] } | | d q8 ~ S( Ni ( R
t tablesRÎ R` R^ RM ( RÇ Rá R Rý RÍ R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyt table_names› s $c C sŽ | p
| i | ƒ } t i t g | o+ t i t i i | j t i i | j ƒ p t i i | j ƒ } | i | ƒ } | i ƒ } | d j S( N( Rö R R
t columnst and_RÎ R` R^ RM R« RË ( RÇ Rá t tablenameR t current_schemaRý RÎ R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyt has_table s + c , sJ | i d j o
| i ‰ n | i | ƒ ‰ t i t g ˆ o. t i t i i | i j t i i
ˆ j ƒ p t i i | i j d t i i g ƒ} | i | ƒ } t
} xDt o<| i ƒ } | d j o Pn t } | t i i | t i i | t i i d j | t i i | t i i | t i i | t i i | t i i f \ } } }
} } }
} } | o | | j o q¬ n | i i | d ƒ } h } | t t t t t t t t! t" i# f j oa | | d <| o | | d g t i | i i? | i i? j | i i | i j | i i
| i p ˆ j ƒ ƒ } | i | ƒ } x[ | D]S } d | | i i> i j o3 | d | i j o | i@ iA | i | d ƒ q q Wt i | i i | i i
| i i | i i | i i? | i iB | i iC | i iD g t i | i i | i j | i i
| i p ˆ j | i i? | i i? j | i i? | i iE j | i i | i i j ƒ d | i i? | i i g ƒ} | i | ƒ iF ƒ } ‡ f d † } d g g } } } x_| D]W} | \ }! }" }# }$ }% }& }' }( |" ˆ j o. | i o# t iG |# | iH d t d | ƒn& t iG |# | iH d |" d t d | ƒ|% | j ox | oY | iI t iJ | g }) | D]% \ } }* } |) | | | |* | ƒ q6~) | d t ƒƒ n |% g g } } } n |! | j o | i* |! ƒ n |" |# |$ f | j o | i* |" |# |$ f ƒ q„q„W| o` | oY | iI t iJ | g }+ | D]% \ } }* } |+ | | | |* | ƒ q~+ | d t ƒƒ n d S( Nt order_byt YESR6 RÆ iÿÿÿÿR RŠ s* Did not recognize type '%s' of column '%s't nullableR s2 sp_columns @table_name = '%s', @table_owner = '%s'i i R` t _identityi s# select ident_seed(?), ident_incr(?)i t Ct Rt PRIMARYc sF | ˆ j o | i o d i | | g ƒ Sd i | | | g ƒ Sd S( Nt .( R Rk ( R© t rschemat rtblt rcol( Rü ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyt
_gen_fkref! s t autoloadt
autoload_withR t link_to_name(K R RË Rö R R
Rù Rú RÎ R` Rð R^ Rk RM RÔ R3 R« Re Ri Rg Rm Ro Rq Rs Ru t
ischema_namesRÅ R5 R; R8 R= R, R1 RA RC Rà t BinaryRç t
issubclasst NumericR RÝ t NULLTYPEt appendt
DefaultClauseR¾ t
append_columnR R t NoSuchTableErrort endswithR R‘ R• R& t fullnameR¬ t startt incrementt ref_constraintst constraintst key_constraintst aliasRz Rx RŽ R R‰ R‹ R R‡ t fetchallR t metadatat append_constraintt ForeignKeyConstraint(, RÇ Rá R© t include_columnsRý RÎ t found_tableR Rð R R t charlent numericprect numericscaleR RÆ t coltypeRÈ t colargsR9 t ict col_namet type_namet RRt TCR R t rowsR t fknmt scolst rcolst rt scolR R R t rfknmt fkmatcht fkuprulet fkdelruleRÍ t tRü ( ( Rü s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyt reflecttable sÞ
.
++
-
#-
6" .#' #%
Y
N( Rµ s server_version_info( s dialects default_schema_name(O RÖ Ré Rð R3 t supports_default_valuesRÔ t supports_empty_insertRŸ R™ t execution_ctx_clsR0 Rª RÔ RÕ RV R8 Rà R9 R R R t SmallintegerRë R R t FloatR t DateTimeR t DateR t TimeR5 R R? R RF t BooleanR, R- R1 R2 R; R< R= R> RH RI Rì R
R R" R$ R RA RC RE RJ RL RN RP R
RÏ RË RÉ t classmethodRÎ R t connection_memoizeRß Rà Rê Rï Rñ Rò Rö Rø Rý R9 ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyR´ ê s”
RÚ c B sP e Z e Z d Z e d „ ƒ Z d „ Z d „ Z d „ Z d „ Z
d „ Z RS( i c C sW d d k } d „ | _ y( t t t | i i d ƒ ƒ ƒ | _ Wn d | _ n X| S( Niÿÿÿÿc S s
t | ƒ S( ( Rí ( t st( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyt G s R i ( i i i ( t pymssqlR t tuplet mapR¬ t __version__t splitt version_info( RÒ t module( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyR× B s (
c K s± t t | ƒ i | t | _ | i o& t i d ƒ | i d d ƒ | _ n t
i i ƒ | _ t
i
i ƒ | _
t | i
d /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRÉ N s
c C sn t t | ƒ i | ƒ } t | d ƒ oB | i i d j o | i | d d /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRê ^ s c C sW | i d ƒ o= d i | i d d ƒ d t | d ƒ g ƒ | d <| d =n g | g S( Nt portRò t hostt :( RÅ Rk Rí ( RÇ t keysRæ ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRè g s 2 c C s& t | | i i ƒ o d t | ƒ j S( Ns Error 10054( RÞ RÎ t
DatabaseErrorRí ( RÇ R¦ ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyt
is_disconnectn s c C s d S( N( ( RÇ Rá ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyt do_beginq s ( RÖ Ré RÔ t supports_sane_rowcountRÕ RC R× RÉ Rê Rè RY RZ ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRÚ > s RÙ c B se e Z e Z e Z e i d j Z e Z e Z
d d „ Z e d „ ƒ Z
d „ Z d „ Z d „ Z RS( iÿÿ s latin-1c K sÄ t t | ƒ i | | | _ | i d j ob t i i ƒ | _ t i i ƒ | _ t | i d /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRÉ } s
c C s d d k } | S( Niÿÿÿÿ( R± ( RÒ RM ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyR× ‘ s c
C s d | j o t | i d ƒ ƒ | _ n d | j o t i | i d ƒ ƒ g } n¡d | j p d | j o
d | j } | o0 d | i d d ƒ p | i d d ƒ g } nƒ d } d | j o* d | j o d t | i d ƒ ƒ } n d
| i d d ƒ d
| i d d ƒ | f d | i d d ƒ g } | i d d ƒ } | o2 | i d | ƒ | i d | i d d ƒ ƒ n | i d ƒ d | j o | i d | i d ƒ ƒ n | i g } | i ƒ D] \ } } | d | | f qÎ~ ƒ d i | ƒ g h g S( NRÕ t odbc_connectt dsnRU R: s dsn=%sRò RT s ,%ds DRIVER={%s}t drivers
SQL Servers Server=%s%ss Database=%sRº s UID=%ss PWD=%st passwords TrustedConnection=Yest odbc_autotranslates AutoTranslate=%ss %s=%st ;(
R¬ Rç RÕ t urllibt unquote_plusRË R RÒ t iteritemsRk (
RÇ RW Ræ t
connectorst dsn_connectionRT Rº RÍ RÛ t v( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRè – s,
&0 !
>c C si t | | i i ƒ o$ d t | ƒ j p d t | ƒ j St | | i i ƒ o d t | ƒ j St Sd S( Ns( The cursor's connection has been closed.s# Attempt to use a closed connection.s [08S01]( RÞ RÎ t ProgrammingErrorRí R² RÔ ( RÇ R¦ ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRY » s
$c C s‚ g } t i d ƒ } x` | i | i | i i ƒ ƒ D]@ } y | i t | ƒ ƒ Wq4 t j
o | i | ƒ q4 Xq4 Wt | ƒ S( s2 Convert a pyodbc SQL_DBMS_VER string into a tuple.s [.\-](
t ret compileRK t getinfoRÎ t SQL_DBMS_VERR R¬ t
ValueErrorRH ( RÇ Rã t versionR2 t n( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRà Ä s ( RÖ Ré RÔ R[ t supports_sane_multi_rowcountt syst
maxunicodet supports_unicodet supports_unicode_statementsR¯ R< RÉ RC R× Rè RY Rà ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRÙ u s % RÛ c B s e Z e Z e Z e i d j Z e Z e d „ ƒ Z
e i i
ƒ Z e e e i /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyR× Õ s R c C sâ d g } d | j o- | i d | i d ƒ | i d ƒ f ƒ n | i d | i d ƒ ƒ | i d | i d ƒ ƒ | i d ƒ } | o2 | i d | ƒ | i d
| i d d ƒ ƒ n | i d
ƒ d i | ƒ g h g S( Ns Provider=SQLOLEDBRT s Data Source=%s, %sRU s Data Source=%ss Initial Catalog=%sR: Rº s
User Id=%ss Password=%sRa Rò s Integrated Security=SSPIRc ( R RÅ Rk ( RÇ RW Ræ Rg Rº ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRè à s
-!
c C s) t | | i i i ƒ o d t | ƒ j S( Ns 'connection failure'( RÞ RÎ Rw RX Rí ( RÇ R¦ ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRY ï s ( RÖ Ré R3 R[ Rr Rs Rt Ru Rv RC R× R´ Rì RP R+ Rà R? R
Rè RY ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRÛ Ï s
RG R± Rw t
MSSQLCompilerc B sM e Z e i i ƒ Z e i h d e i 6d „ e i 6ƒ e i
i i ƒ Z e i h d e i
6d e i 6d „ d 6d „ e i 6ƒ e i
i i ƒ Z e i h d d 6d d
6d d 6d
d 6ƒ d „ Z d „ Z d „ Z d „ Z d „ Z e d „ Z d „ Z d „ Z d „ Z d d „ Z d „ Z d „ Z d „ Z d „ Z d „ Z! RS( t +c C s d | | f S( s CONTAINS (%s, %s)( ( t xt y( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRF þ s t CURRENT_TIMESTAMPs GETDATE()c C s d | S( s LEN(%s)( ( Rz ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRF s R6 c C s d | S( s LEN(%s)( ( Rz ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRF s t dayofyeart doyt weekdayt dowt millisecondt millisecondst microsecondt microsecondsc O s& t t | ƒ i | | Ž h | _ d S( N( R Rx RÉ t tablealiases( RÇ R. RÈ ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRÉ s c C s“ | i p
| i ol | i o d p d } | i oF | i p | d | i f 7} q{ | i i p t i d ƒ ‚ q{ n | St i i | | ƒ S( s- MS-SQL puts TOP, it's version of LIMIT here s DISTINCT Rò s TOP %s s+ MSSQL does not support LIMIT with an offset(
t _distinctt _limitt _offsetRç RÔ R Râ R t DefaultCompilert get_select_precolumns( RÇ R
Rý ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRŠ s
c C s d S( NRò ( ( RÇ R
( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyt limit_clause% s c K sO | i i o(t | d d ƒ o| i o
| i | i ƒ } | p t i d ƒ ‚ n | i } | i } t
| _ | i t
i d | ƒ i d ƒ ƒ i d ƒ i ƒ } t
i g } | i D]! } | i d j o | | qº qº ~ ƒ } | i d | ƒ | d j o | i d | | ƒ n | i | d t
| St i i | | | Sd S( s Look for ``LIMIT`` and OFFSET in a select statement, and if
so tries to wrap it in a subquery with ``row_number()`` criterion.
t _mssql_visits0 MSSQL requires an order_by when using an offset.s ROW_NUMBER() OVER (ORDER BY %s)t mssql_rns mssql_rn>%ds mssql_rn<=%dt iswrapperN( Rç RÔ RÓ RË Rˆ Rå t _order_by_clauseR Râ R‡ R3 RŒ R* R t literal_columnt labelRþ R R
RÎ Rl t append_whereclauseR R‰ t visit_select( RÇ R
RÈ t orderbyRˆ R‡ RÍ RÎ t limitselect( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyR“ ) s + 4A
c C sT t | d d ƒ d j o3 | | i j o | i ƒ | i | /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyt _schema_aliased_tableA s
c K sq | o t t | ƒ i | | S| i | ƒ } | d j o | i | d t | St t | ƒ i | | Sd S( Nt
mssql_aliased( R Rx t visit_tableR– RË Rå R3 ( RÇ R© R— RÈ R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyR˜ I s
c K s3 | | i | i /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRš T s
c C s5 | i i | i | i ƒ } d | | i | i ƒ f S( Ns DATEPART("%s", %s)( t extract_mapRÅ t fieldRå t expr( RÇ t extractRœ ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyt
visit_extractZ s c C s d | i i | ƒ S( Ns ROLLBACK TRANSACTION %s( t preparert format_savepoint( RÇ t savepoint_stmt( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyt visit_rollback_to_savepoint^ s c K sÝ | i d j o | i o | i p
| i ƒ o‹ | i | i ƒ } | d j oh t i | | ƒ } | d j o) | i | f | i f | | i i
ƒ /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRª a s #
)$c K s| t | i t i ƒ oS | i t i j o@ t | i t i ƒ o) | i t i | i | i | i ƒ | S| i t i j p | i t i j oÐ t | i t i
ƒ o t | i i t i ƒ p[ t | i t i
ƒ o t | i i t i ƒ p, t | i t i ƒ p t | i t i ƒ oF | i t i j o d p d } | i t i | i | i | ƒ | St
t | ƒ i | | Sd S( s] Move bind parameters to the right-hand side of an operator, where
possible.
t INs NOT INN( RÞ Rn R t _BindParamClauset operatort eqR› Rå t _BinaryExpressiont net
_FromGroupingt elementt
_ScalarSelectR Rx t visit_binary( RÇ RÄ RÈ t op( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRµ p s ))&//, &c
C sÄ t } | i oE g } | i i ƒ D]$ } t | t i ƒ o | | q$ q$ ~ } n | oNt | _ | i | ƒ } | i } d i
d g g } | i D] } | | i | ƒ q— ~ ƒ } | o9 | i
i o+ | i
i o t i d | i
i ƒ ‚ qÀ| o) | i
i o | d | i | i ƒ f S| d | i | i ƒ d i
g }
| D] } |
| i | d ƒ qR~
ƒ d i
g } | D] } | | d q†~ ƒ f Sn t t | ƒ i | ƒ Sd S( NRÊ t INSERTs? The version of %s you are using does not support empty inserts.s INTO %s DEFAULT VALUESs INTO %s (%s) SELECT %ss , i i ( RÔ R° R» RÞ R t SelectR3 R› t _get_colparamsR Rk t _prefixesRå Rç R: R; R t CompileErrorRð R£ R© t
format_columnR Rx t visit_insert(
RÇ t insert_stmtt
insert_selectRÍ t pt colparamsR Rü Rz Rg Rþ RÎ Rÿ ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyR½ s*
E 1$
'5c C sA t | t i ƒ o | i d ƒ St t | ƒ i | | | ƒ Sd S( N( RÞ R t FunctionR‘ RË R Rx t label_select_column( RÇ R
R* t asfrom( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRà œ s c C s d S( NRò ( ( RÇ R
( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyt for_update_clause¢ s c C sB | i | i ƒ } | o! | i ƒ p
| i o d | Sd Sd S( Ns
ORDER BY Rò ( Rå R R§ R‡ ( RÇ R
Rþ ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyt order_by_clause¦ s N(" RÖ Ré R t OPERATORSRP R
R· t
sql_operatorst concat_opt match_opR‰ R t
sql_functionst nowR5 t char_lengthR› RÉ RŠ R‹ R“ R– RÔ R˜ Rš RŸ R£ RË Rª Rµ R½ RÃ RÅ RÆ ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRx ú s@
t MSSQLSchemaGeneratorc B s e Z d „ Z RS( c K s= | i i | ƒ d | i i | i ƒ i ƒ } | i d j o1 | i p
| i o | d 7} qp | d 7} n | i p t
i d ƒ ‚ n t | i ƒ } | | j ob t
| d d ƒ } | o% | i p d | i p d } } n
d \ } } | d | | f 7} n/ | i | ƒ } | d j o | d | 7} n | S(
NRÊ s NOT NULLs NULLs; mssql requires Table-bound columns in order to generate DDLR• i s IDENTITY(%s,%s)s DEFAULT ( i i ( R R¼ R t dialect_implRç R R RË RŽ R© R Râ R˜ RÓ R R t get_column_default_string( RÇ R* RÈ t colspect seq_colR• R R R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyt get_column_specification± s$ /
%
( RÖ Ré RÓ ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRÎ ° s t MSSQLSchemaDropperc B s e Z d „ Z RS( c C sX | i d | i i | i i ƒ | i i | i | i t ƒ | i ƒ f ƒ | i ƒ d S( Ns
DROP INDEX %s.%s( R R t quote_identifierR© Rð t quotet _validate_identifierRÔ RM ( RÇ Re ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyt visit_indexÏ s ,( RÖ Ré RØ ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRÔ Î s t MSSQLIdentifierPreparerc B s, e Z e Z d „ Z d „ Z e d „ Z RS( c C s& t t | ƒ i | d d d d ƒd S( Nt
initial_quotet [t final_quotet ]( R RÙ RÉ ( RÇ Rç ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRÉ Ú s c C s | S( N( ( RÇ Rã ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyt _escape_identifierÝ s c C sC d i g } | i d ƒ D] } | | i | | ƒ q ~ ƒ } | S( s' Prepare a quoted table and schema name.R ( Rk RK RÖ ( RÇ R t forceRÍ Rz Rû ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyt quote_schemaá s ?( RÖ Ré t RESERVED_WORDSt reserved_wordsRÉ RÞ R3 Rà ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyRÙ × s (u Rê R Rõ RÐ R® Rk Rs Rd t
sqlalchemyR R R R R R R R R R t sqlalchemy.sqlR
R R R
RÈ R RË t sqlalchemy.engineR R R Rà R Rì R£ Rá RÑ RÄ R Rë R> R R R R
R R R R? R R@ R RA R t
TypeEngineR R" R$ R& R' R+ R- R, R2 R1 R5 R9 R8 R< R; R> R= R R? RA RC RE RB RF RI RH RJ RL RN RP t ischemat schemataR÷ Rù R t column_constraintsR R R“ R˜ t DefaultExecutionContextR™ R¯ t DefaultDialectR´ RÚ RÙ RÛ RÐ R‰ Rx t SchemaGeneratorRÎ t
SchemaDropperRÔ t IdentifierPreparerRÙ Rç t statement_compilert schemageneratort
schemadropperR ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/mssql.pyt ñ s& T".( 9:
/ / +ÿ U7Z$
¶