[Jc @ s d Z d d k Z d d k Z d d k Z d d k l Z l Z l Z l Z l Z d d k
l Z d d k i
Z d d k i Z d d k l Z l Z d d k
l Z d e i f d YZ d e i f d
YZ d e i f d YZ d
e i f d YZ d e f d YZ d e e i f d YZ! d e e i" f d YZ# d e e i$ f d YZ% d e f d YZ& d e& e i' f d YZ( d e& e i) f d YZ* d e& e i+ f d YZ, d e i- f d YZ. d! e i/ f d" YZ0 h
e. e i- 6e0 e i/ 6e, e i+ 6e# e i" 6e! e i 6e e i 6e e i 6e, e i1 6e e i 6e e i 6e* e i) 6e( e i' 6e% e i$ 6Z2 h e. d# 6e0 d$ 6e0 d% 6e, d& 6e# d' 6e! d( 6e d) 6e d* 6e d+ 6e d, 6e d- 6e d. 6e d/ 6e( d0 6e% d1 6e! d2 6e* d3 6Z3 d4 e i4 f d5 YZ5 d6 e i6 f d7 YZ7 d8 Z8 d9 e i9 f d: YZ: d; e i; f d< YZ< d= e i= f d> YZ> e7 Z? e i@ e? _A e: e? _B e< e? _C e> e? _D e5 e? _E d S(? s Support for the SQLite database.
Driver
------
When using Python 2.5 and above, the built in ``sqlite3`` driver is
already installed and no additional installation is needed. Otherwise,
the ``pysqlite2`` driver needs to be present. This is the same driver as
``sqlite3``, just with a different name.
The ``pysqlite2`` driver will be loaded first, and if not found, ``sqlite3``
is loaded. This allows an explicitly installed pysqlite driver to take
precedence over the built in one. As with all dialects, a specific
DBAPI module may be provided to :func:`~sqlalchemy.create_engine()` to control
this explicitly::
from sqlite3 import dbapi2 as sqlite
e = create_engine('sqlite:///file.db', module=sqlite)
Full documentation on pysqlite is available at:
``_
Connect Strings
---------------
The file specification for the SQLite database is taken as the "database" portion of
the URL. Note that the format of a url is::
driver://user:pass@host/database
This means that the actual filename to be used starts with the characters to the
**right** of the third slash. So connecting to a relative filepath looks like::
# relative path
e = create_engine('sqlite:///path/to/database.db')
An absolute path, which is denoted by starting with a slash, means you need **four**
slashes::
# absolute path
e = create_engine('sqlite:////path/to/database.db')
To use a Windows path, regular drive specifications and backslashes can be used.
Double backslashes are probably needed::
# absolute path on Windows
e = create_engine('sqlite:///C:\\path\\to\\database.db')
The sqlite ``:memory:`` identifier is the default if no filepath is present. Specify
``sqlite://`` and nothing else::
# in-memory database
e = create_engine('sqlite://')
Threading Behavior
------------------
Pysqlite connections do not support being moved between threads, unless
the ``check_same_thread`` Pysqlite flag is set to ``False``. In addition,
when using an in-memory SQLite database, the full database exists only within
the scope of a single connection. It is reported that an in-memory
database does not support being shared between threads regardless of the
``check_same_thread`` flag - which means that a multithreaded
application **cannot** share data from a ``:memory:`` database across threads
unless access to the connection is limited to a single worker thread which communicates
through a queueing mechanism to concurrent threads.
To provide a default which accomodates SQLite's default threading capabilities
somewhat reasonably, the SQLite dialect will specify that the :class:`~sqlalchemy.pool.SingletonThreadPool`
be used by default. This pool maintains a single SQLite connection per thread
that is held open up to a count of five concurrent threads. When more than five threads
are used, a cleanup mechanism will dispose of excess unused connections.
Two optional pool implementations that may be appropriate for particular SQLite usage scenarios:
* the :class:`sqlalchemy.pool.StaticPool` might be appropriate for a multithreaded
application using an in-memory database, assuming the threading issues inherent in
pysqlite are somehow accomodated for. This pool holds persistently onto a single connection
which is never closed, and is returned for all requests.
* the :class:`sqlalchemy.pool.NullPool` might be appropriate for an application that
makes use of a file-based sqlite database. This pool disables any actual "pooling"
behavior, and simply opens and closes real connections corresonding to the :func:`connect()`
and :func:`close()` methods. SQLite can "connect" to a particular file with very high
efficiency, so this option may actually perform better without the extra overhead
of :class:`SingletonThreadPool`. NullPool will of course render a ``:memory:`` connection
useless since the database would be lost as soon as the connection is "returned" to the pool.
Date and Time Types
-------------------
SQLite does not have built-in DATE, TIME, or DATETIME types, and pysqlite does not provide
out of the box functionality for translating values between Python `datetime` objects
and a SQLite-supported format. SQLAlchemy's own :class:`~sqlalchemy.types.DateTime`
and related types provide date formatting and parsing functionality when SQlite is used.
The implementation classes are :class:`SLDateTime`, :class:`SLDate` and :class:`SLTime`.
These types represent dates and times as ISO formatted strings, which also nicely
support ordering. There's no reliance on typical "libc" internals for these functions
so historical dates are fully supported.
Unicode
-------
In contrast to SQLAlchemy's active handling of date and time types for pysqlite, pysqlite's
default behavior regarding Unicode is that all strings are returned as Python unicode objects
in all cases. So even if the :class:`~sqlalchemy.types.Unicode` type is
*not* used, you will still always receive unicode data back from a result set. It is
**strongly** recommended that you do use the :class:`~sqlalchemy.types.Unicode` type
to represent strings, since it will raise a warning if a non-unicode Python string is
passed from the user application. Mixing the usage of non-unicode objects with returned unicode objects can
quickly create confusion, particularly when using the ORM as internal data is not
always represented by an actual database result string.
iN( t sqlt schemat exct poolt
DefaultClause( t default( t compilert functions( t NoneTypet SLNumericc B s e Z d Z d Z RS( c s* | i o t p t f d } | S( Nc s | d j o | S| Sd S( N( t None( t value( t type_( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyt process s
( t asdecimalt strt float( t selft dialectR
( ( R s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyt bind_processor 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)t precisiont scale( R R
R ( R ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyt get_col_spec s ( t __name__t
__module__R R ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyR s t SLFloatc B s e Z d Z d Z RS( c s* | i o t p t f d } | S( Nc s | d j o | S| Sd S( N( R
( R ( R ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyR
s
( R R R ( R R R
( ( R s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyR s c C s d S( Nt FLOAT( ( R ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyR s ( R R R R ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyR s t SLIntegerc B s e Z d Z RS( c C s d S( Nt INTEGER( ( R ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyR s ( R R R ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyR s t SLSmallIntegerc B s e Z d Z RS( c C s d S( Nt SMALLINT( ( R ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyR s ( R R R ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyR s t
DateTimeMixinc B s e Z d Z d Z RS( c s f d } | S( Nc s t | t t i t i t i f p t d nH | d j o6 t g } D] } | t | | d qS ~ Sd Sd S( NsS SQLite Date, Time, and DateTime types only accept Python datetime objects as input.i ( t
isinstanceR t datetimet datet timet TypeErrorR
t tuplet getattr( R t _[1]t attr( t formatt elements( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyR
s
%
6( ( R R* R+ R
( ( R+ R* s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyt _bind_processor s c s f d } | S( Nc sW | d j oB g } i | i D] } | t | p d q* ~ Sd Sd S( Ni ( R
t matcht groupst int( R R( t x( t regexpt fn( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyR
s
B( ( R R2 R1 R
( ( R1 R2 s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyt _result_processor s ( R R R, R3 ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyR s
t
SLDateTimec B s8 e Z e Z d Z d Z e i d Z d Z RS( c C s d S( Nt TIMESTAMP( ( R ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyR s c C s/ | i o | i d d
S| i d d Sd S( Ns& %4.4d-%2.2d-%2.2d %2.2d:%2.2d:%2.2d.%st yeart montht dayt hourt minutet secondt microseconds( %4.4d-%2.2d-%2.2d %2.2d:%2.2d:%2.2d.%06d( R6 R7 R8 R9 R: R; R< ( R6 R7 R8 R9 R: R; R< ( t __legacy_microseconds__R, ( R R ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyR s
s4 (\d+)-(\d+)-(\d+)(?: (\d+):(\d+):(\d+)(?:\.(\d+))?)?c C s | i t i | i S( N( R3 R" t _reg( R R ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyt result_processor s (
R R t FalseR= R R t ret compileR> R? ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyR4 s
t SLDatec B s2 e Z d Z d Z e i d Z d Z RS( c C s d S( Nt DATE( ( R ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyR s c C s | i d d S( Ns %4.4d-%2.2d-%2.2dR6 R7 R8 ( s years months day( R, ( R R ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyR s s (\d+)-(\d+)-(\d+)c C s | i t i | i S( N( R3 R" R# R> ( R R ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyR? s ( R R R R RA RB R> R? ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyRC s t SLTimec B s8 e Z e Z d Z d Z e i d Z d Z RS( c C s d S( Nt TIME( ( R ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyR s c C s/ | i o | i d d S| i d d Sd S( Ns %2.2d:%2.2d:%2.2d.%sR9 R: R; R< s %2.2d:%2.2d:%2.2d.%06d( s hours minutes seconds microsecond( s hours minutes seconds microsecond( R= R, ( R R ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyR s
s (\d+):(\d+):(\d+)(?:\.(\d+))?c C s | i t i | i S( N( R3 R" R$ R> ( R R ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyR? s (
R R R@ R= R R RA RB R> R? ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyRE s
t SLUnicodeMixinc B s e Z d Z d Z RS( c sb | i p
| i oF | i d j o
| i n
| i p d S f d } | Sd Sd S( Nc sX t | t t 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( R! t unicodeR t utilRH R t InvalidRequestError( R ( t assert_unicode( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyR
s
( t convert_unicodeRL R
( R R R
( ( RL s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyR s
c C s d S( N( R
( R R ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyR? s ( R R R R? ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyRG s t SLTextc B s e Z d Z RS( c C s d S( Nt TEXT( ( R ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyR s ( R R R ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyRN s t SLStringc B s e Z d Z RS( c C s d | i o d | i p d S( Nt VARCHARs (%d)t ( t length( R ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyR s ( R R R ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyRP s t SLCharc B s e Z d Z RS( c C s d | i o d | i p d S( Nt CHARs (%d)RR ( RS ( R ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyR s ( R R R ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyRT s t SLBinaryc B s e Z d Z RS( c C s d S( Nt BLOB( ( R ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyR s ( R R R ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyRV s t SLBooleanc B s# e Z d Z d Z d Z RS( c C s d S( Nt BOOLEAN( ( R ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyR # s c C s
d } | S( Nc S s$ | d j o d S| o d p d S( Ni i ( R
( R ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyR
' s
( ( R R R
( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyR & s c C s
d } | S( Nc S s | d j o d S| d j S( Ni ( R
( R ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyR
. s
( ( R R R
( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyR? - s ( R R R R R? ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyRX " s RW t BOOLRY RU RD t DATETIMEt DECIMALR t INTR R t REALR RO RF R5 RQ t SQLiteExecutionContextc B s e Z d Z RS( c C sf | i i oU | i oJ t | i p | i d d j o! | i i g | i d | _ qb n d S( Ni i ( t compiledt isinsertt executemanyt lent _last_inserted_idsR
t cursort lastrowid( R ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyt post_execY s %( R R Rg ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyR_ X s t
SQLiteDialectc B s e Z d Z e Z e Z d Z e Z e Z d Z
d Z e e Z d Z
d Z d Z d Z d Z d d Z d
Z RS( t sqlitet qmarkc K s t i i | | d } | i d j o| | i i } | d
j o? t i d d i g } | D] } | t | q_ ~ n | i i
d j o
t | _ q n | i d j p | | i i
| d j | _ d S( Nc S s4 t g } | i d D] } | t | q ~ S( Nt .( R& t splitR/ ( t numR( R0 ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyt versh s i i t 3s The installed version of pysqlite2 (%s) is out-dated and will cause errors in some cases. Version 2.1.3 or greater is recommended.Rk i i s 3.2.3( i i Ro ( i i i ( R t DefaultDialectt __init__t dbapiR
t version_infoRJ RH t joinR t sqlite_version_infoR@ t supports_default_valuest sqlite_versiont
supports_cast( R t kwargsRn t
sqlite_verR( t subver( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyRq f s
6c C s` y d d k l } WnE t j
o9 } y d d k l } Wq\ t j
o
| q\ Xn X| S( Ni( t dbapi2( t pysqlite2R| t ImportErrort sqlite3( t clsRi t e( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyRr v s c C s
| i i S( N( Rr Ru ( R t
connection( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyt server_version_info s c C s | i p | i p | i p
| i o t i d | f n | i p d } | i i } t i
| d t t i
| d t t i
| d t
t i
| d t t i
| d t
| g | f S( Ns Invalid SQLite URL: %s
Valid SQLite URL forms are:
sqlite:///:memory: (or, sqlite://)
sqlite:///relative/path/to/file.db
sqlite:////absolute/path/to/file.dbs :memory:t timeoutt isolation_levelt detect_typest check_same_threadt cached_statements( t usernamet passwordt hostt portR t
ArgumentErrort databaset queryt copyRJ t coerce_kw_typeR R R/ t bool( R t urlt filenamet opts( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyt create_connect_args s (c C s t i | t S( N( t sqltypest
adapt_typet colspecs( R t typeobj( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyt type_descriptor s c C s& t | | i i o d t | j S( Ns$ Cannot operate on a closed database.( R! Rr t ProgrammingErrorR ( R R ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyt
is_disconnect s c C s | d j o< | i i | } d | } d | f } | i | } nK y d } | i | } Wn. t i j
o d } | i | } n Xg } | D] } | | d q ~ S( Ns %s.sqlite_masters4 SELECT name FROM %s WHERE type='table' ORDER BY names} SELECT name FROM (SELECT * FROM sqlite_master UNION ALL SELECT * FROM sqlite_temp_master) WHERE type='table' ORDER BY names? SELECT name FROM sqlite_master WHERE type='table' ORDER BY namei ( R
t identifier_preparert quote_identifiert executeR t
DBAPIError( R R R t qschemat mastert st rsR( t row( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyt table_names s
c C s | i i } | d j o d | | } n d } | | } t | i d | | f } | i } x | i d j o qm W| d j S( Ns
PRAGMA %s.s PRAGMA s %stable_info(%s)( R R R
t _pragma_cursorR t fetchone( R R t
table_nameR t quotet pragmat qtableRe R ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyt has_table s
c # C s( | i } | i d j o
d } n d | i | i } | i | t } t | i d | | f } t } xt o| i } | d j o Pn t } | d | d i
| d | d | d d j | d f \ }
} } }
} } t i d d
|
}
| o |
| j o qs n t i
d | } | o" | i d } | i d } n
d } d
} y t | } Wn3 t j
o' t i d
| |
f t i } n X| d j oC t i d | } | g } | D] } | t | q~ } n g } | o | i t t i |
n | i t i |
| d | d | | qs W| p t i | i n t | i d | | f } h } xct o[| i } | d j o Pn | d | d | d | d f \ } } } } t i d d
| } t i d d
| } t i d d
| } y | | } Wn) t j
o g g f } | | | $ s ( t closedt _fetchone_impl( Re ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyR " s
t SQLiteCompilerc B s e Z e i i i Z e i h d e i 6d e i 6 e i i
i Z
e
i h
d d 6d d 6d d 6d d 6d
d 6d d
6d d 6d d 6d d 6d d 6 d Z d Z d Z
d Z RS( t CURRENT_TIMESTAMPs length%(expr)ss %mR7 s %dR8 s %YR6 s %SR; s %HR9 s %jt doys %MR: s %st epochs %wt dows %Wt weekc K s8 | i i o t t | i | S| i | i Sd S( N( R Rx t superR t
visit_castR
t clause( R t castRy ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyR > s
c C sX y( d | i | i | i | i f SWn) t j
o t i d | i n Xd S( Ns# CAST(STRFTIME('%s', %s) AS INTEGER)s# %s is not a valid extract argument.( t extract_mapt fieldR
t exprR R R ( R t extract( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyt
visit_extractD s %c C s d } | i d j o | d t | i 7} n | i d j o9 | i d j o | d 7} n | d t | i 7} n | d 7} | S( NRR s
LIMIT s
LIMIT -1s OFFSET s OFFSET 0( t _limitR
R t _offset( R t selectR ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyt limit_clauseL s
c C s d S( NRR ( ( R R ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyt for_update_clauseX s ( R R R t DefaultCompilerR R t updatet
sql_functionst nowt char_lengthR R R R R ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyR ' s*
t SQLiteSchemaGeneratorc B s e Z d Z RS( c K sy | i i | d | i i | i i } | i | } | d j o | d | 7} n | i p | d 7} n | S( Nt s DEFAULT s NOT NULL( R t
format_columnt typet dialect_implR R t get_column_default_stringR
R ( R t columnRy t colspecR ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyt get_column_specification_ s /
( R R R ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyR ] s t SQLiteIdentifierPreparerc u B sy e 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& 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 gt Z dt Z RS(u t addt aftert allt altert analyzet andt ast asct attacht
autoincrementt beforet begint betweent byt cascadet caseR t checkt collateR t committ conflictt
constraintt createt crosst current_datet current_timet current_timestampR R t
deferrablet deferredt deletet desct detacht distinctt dropt eacht elset endt escapet exceptt exclusivet explaint falset failt fort foreignt fromt fullt globR t havingt ift ignoret immediatet int indext initiallyt innert insertt insteadt intersectt intot ist isnullRt t keyt leftt liket limitR- t naturalt nott notnullt nullt oft offsett ont ort ordert outert planR t primaryR t raiset
referencest reindext renamet replacet restrictt rightt rollbackR R t setR t tempt temporaryt thent tot transactiont triggert truet uniont uniqueR t usingt vacuumt valuest viewt virtualt whent wheret indexedc C s t t | i | d S( N( R R Rq ( R R ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyRq ~ s ( R R R_ t reserved_wordsRq ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyR i s& (F t __doc__R" RA R$ t
sqlalchemyR R R R R t sqlalchemy.engineR t sqlalchemy.typest typesR t sqlalchemy.utilRJ t sqlalchemy.sqlR R R R t NumericR t FloatR t IntegerR t SmallintegerR t objectR t DateTimeR4 t DateRC t TimeRE RG t TextRN t StringRP RU RT t BinaryRV t BooleanRX t NCHARR R t DefaultExecutionContextR_ Rp Rh R R R t SchemaGeneratorR t IdentifierPreparerR R t SingletonThreadPoolt poolclasst statement_compilert schemageneratorR t execution_ctx_cls( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sqlite.pyt x s $(
6