[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 l
Z
e a 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 i f d YZ 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 i! f d YZ" d e i# f d YZ$ d e i% f d YZ& 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! 6Z( h
d d 6d d 6d! d" 6d# d$ 6d% d& 6d' d( 6d) d* 6d+ d, 6d- d. 6d/ d0 6d1 d2 6d3 d4 6d5 d6 6Z) d7 Z* d8 e
i+ f d9 YZ, d: e
i- f d; YZ. e/ d< Z0 d= e i1 i2 f d> YZ3 d? e i1 i4 f d@ YZ5 dA e i1 i6 f dB YZ7 dC e i8 f dD YZ9 e: 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 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 d d ddddddddd d
d d d
dddddddddddddddd d d d d d!d"d#d$d%d&d'd(d)d*d+d,d-d.d/d0d1d2d3d4d5d6d7d8d9d:d;d<d=d>d?d@dAdBdCdDdEdFdGdHdIdJdKdLdMdNdOdPdQdRdSdTdUdVdWdXdYdZd[d\d]d^d_d`dadbdcdddedfg# Z; dge i1 i< f dh YZ= e. Z> e3 e> _? e5 e> _@ e7 e> _A e9 e> _B e= e> _C e, e> _D d S(i s
Firebird backend
================
This module implements the Firebird backend, thru the kinterbasdb_
DBAPI module.
Firebird dialects
-----------------
Firebird offers two distinct dialects_ (not to be confused with the
SA ``Dialect`` thing):
dialect 1
This is the old syntax and behaviour, inherited from Interbase pre-6.0.
dialect 3
This is the newer and supported syntax, introduced in Interbase 6.0.
From the user point of view, the biggest change is in date/time
handling: under dialect 1, there's a single kind of field, ``DATE``
with a synonim ``DATETIME``, that holds a `timestamp` value, that is a
date with hour, minute, second. Under dialect 3 there are three kinds,
a ``DATE`` that holds a date, a ``TIME`` that holds a *time of the
day* value and a ``TIMESTAMP``, equivalent to the old ``DATE``.
The problem is that the dialect of a Firebird database is a property
of the database itself [#]_ (that is, any single database has been
created with one dialect or the other: there is no way to change the
after creation). SQLAlchemy has a single instance of the class that
controls all the connections to a particular kind of database, so it
cannot easily differentiate between the two modes, and in particular
it **cannot** simultaneously talk with two distinct Firebird databases
with different dialects.
By default this module is biased toward dialect 3, but you can easily
tweak it to handle dialect 1 if needed::
from sqlalchemy import types as sqltypes
from sqlalchemy.databases.firebird import FBDate, colspecs, ischema_names
# Adjust the mapping of the timestamp kind
ischema_names['TIMESTAMP'] = FBDate
colspecs[sqltypes.DateTime] = FBDate,
Other aspects may be version-specific. You can use the ``server_version_info()`` method
on the ``FBDialect`` class to do whatever is needed::
from sqlalchemy.databases.firebird import FBCompiler
if engine.dialect.server_version_info(connection) < (2,0):
# Change the name of the function ``length`` to use the UDF version
# instead of ``char_length``
FBCompiler.LENGTH_FUNCTION_NAME = 'strlen'
Pooling connections
-------------------
The default strategy used by SQLAlchemy to pool the database connections
in particular cases may raise an ``OperationalError`` with a message
`"object XYZ is in use"`. This happens on Firebird when there are two
connections to the database, one is using, or has used, a particular table
and the other tries to drop or alter the same table. To garantee DDL
operations success Firebird recommend doing them as the single connected user.
In case your SA application effectively needs to do DDL operations while other
connections are active, the following setting may alleviate the problem::
from sqlalchemy import pool
from sqlalchemy.databases.firebird import dialect
# Force SA to use a single connection per thread
dialect.poolclass = pool.SingletonThreadPool
RETURNING support
-----------------
Firebird 2.0 supports returning a result set from inserts, and 2.1 extends
that to deletes and updates.
To use this pass the column/expression list to the ``firebird_returning``
parameter when creating the queries::
raises = tbl.update(empl.c.sales > 100, values=dict(salary=empl.c.salary * 1.1),
firebird_returning=[empl.c.id, empl.c.salary]).execute().fetchall()
.. [#] Well, that is not the whole story, as the client may still ask
a different (lower) dialect...
.. _dialects: http://mc-computing.com/Databases/Firebird/SQL_Dialect.html
.. _kinterbasdb: http://sourceforge.net/projects/kinterbasdb
iN( t exct schemat typest sqlt util( t baset defaultt FBNumericc B s) e Z d Z d Z d Z d Z RS( s- Handle ``NUMERIC(precision,scale)`` datatype.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 t NoneR
( t self( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyt get_col_specr s c C s d S( N( R ( R t dialect( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyt bind_processory s c C s | i o d Sd } | Sd S( Nc S s& t | t i o t | S| Sd S( N( t
isinstancet decimalt Decimalt float( t value( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyt process s ( t asdecimalR ( R R R ( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyt result_processor| s
( t __name__t
__module__t __doc__R
R R ( ( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyR o s t FBFloatc B s e Z d Z d Z RS( s% Handle ``FLOAT(precision)`` datatype.c C s% | i p d Sd h | i d 6Sd S( Nt FLOATs FLOAT(%(precision)s)R ( R ( R ( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyR
s
( R R R R
( ( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyR s t FBIntegerc B s e Z d Z d Z RS( s Handle ``INTEGER`` datatype.c C s d S( Nt INTEGER( ( R ( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyR
s ( R R R R
( ( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyR s t FBSmallIntegerc B s e Z d Z d Z RS( s Handle ``SMALLINT`` datatype.c C s d S( Nt SMALLINT( ( R ( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyR
s ( R R R R
( ( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyR s t
FBDateTimec B s e Z d Z d Z d Z RS( s Handle ``TIMESTAMP`` datatype.c C s d S( Nt TIMESTAMP( ( R ( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyR
s c C s
d } | S( Nc S sN | d j p t | t i o | St i d | i d | i d | i Sd S( Nt yeart montht day( R R t datetimeR# R$ R% ( R ( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyR s
( ( R R R ( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyR s ( R R R R
R ( ( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyR! s t FBDatec B s e Z d Z d Z RS( s Handle ``DATE`` datatype.c C s d S( Nt DATE( ( R ( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyR
s ( R R R R
( ( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyR' s t FBTimec B s e Z d Z d Z RS( s Handle ``TIME`` datatype.c C s d S( Nt TIME( ( R ( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyR
s ( R R R R
( ( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyR) s t FBTextc B s e Z d Z d Z RS( s9 Handle ``BLOB SUB_TYPE 1`` datatype (aka *textual* blob).c C s d S( Ns BLOB SUB_TYPE 1( ( R ( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyR
s ( R R R R
( ( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyR+ s t FBStringc B s e Z d Z d Z RS( s$ Handle ``VARCHAR(length)`` datatype.c C s% | i o d h | i d 6Sd Sd S( Ns VARCHAR(%(length)s)t lengths BLOB SUB_TYPE 1( R- ( R ( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyR
s
( R R R R
( ( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyR, s t FBCharc B s e Z d Z d Z RS( s! Handle ``CHAR(length)`` datatype.c C s% | i o d h | i d 6Sd Sd S( Ns CHAR(%(length)s)R- s BLOB SUB_TYPE 1( R- ( R ( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyR
s
( R R R R
( ( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyR. s t FBBinaryc B s e Z d Z d Z RS( s8 Handle ``BLOB SUB_TYPE 0`` datatype (aka *binary* blob).c C s d S( Ns BLOB SUB_TYPE 0( ( R ( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyR
s ( R R R R
( ( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyR/ s t FBBooleanc B s e Z d Z d Z RS( s1 Handle boolean values as a ``SMALLINT`` datatype.c C s d S( NR ( ( R ( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyR
s ( R R R R
( ( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyR0 s c C s t S( ( R ( t r( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyt s t SHORTc C s t S( ( R ( R1 ( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyR2 s t LONGc C s t S( ( R ( R1 ( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyR2 s t QUADc C s t S( ( R ( R1 ( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyR2 s R c C s t S( ( R' ( R1 ( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyR2 s R( c C s t S( ( R) ( R1 ( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyR2 s R* c C s t | d S( t flen( R, ( R1 ( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyR2 s t TEXTc C s t d | d d | d d S( R t fprecR
t fscalei( R ( R1 ( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyR2 s t INT64c C s t S( ( R ( R1 ( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyR2 s t DOUBLEc C s t S( ( R! ( R1 ( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyR2 s R" c C s t | d S( R6 ( R, ( R1 ( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyR2 s t VARYINGc C s t | d S( R6 ( R. ( R1 ( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyR2 s t CSTRINGc C s" | d d j o
t p t S( t stypei ( R+ R/ ( R1 ( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyR2 s t BLOBt firebird_returningt FBExecutionContextc B s e Z RS( ( R R ( ( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyRA
s t FBDialectc B s e Z d Z d Z e Z e Z d Z e Z e Z
d d d Z d Z e
e Z d Z d Z d Z d
Z d Z d Z d d
Z d Z d Z d Z d Z d Z d Z RS( s Firebird dialectt firebirdi i i c K s) t i i | | | | _ | | _ d S( N( R t DefaultDialectt __init__t type_convt concurrency_level( R RF RG t kwargs( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyRE s c C s d d k } | S( Ni( t kinterbasdb( t clsRI ( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyt dbapi s c C s | i d d } | i d o' d | d | d f | d <| d =n | i | i | i d | i } | i d | i } t o3 | i d j o# t
a | i i d | d | n g | f S( Nt usernamet usert ports %s/%st hostRF RG ( t translate_connect_argst gett updatet queryt popRF RG t _initialized_kbRK R t Truet init( R t urlt optsRF RG ( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyt create_connect_args" s c C s t i | t S( N( t sqltypest
adapt_typet colspecs( R t typeobj( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyt type_descriptor1 s c C s d d k l } | i i } | i } | d | } | p t d | n t g } | i d d d D] } | t | ql ~ S( s Get the version of the Firebird server used by a connection.
Returns a tuple of (`major`, `minor`, `build`), three integers
representing the version of the attached server.
i( t matchs0 \w+-V(\d+)\.(\d+)\.(\d+)\.(\d+) \w+ (\d+)\.(\d+)s, Could not determine version from string '%s'i i i ( t reR` t
connectiont server_versiont AssertionErrort tuplet groupt int( R Rb R` t fbconnt versiont mt _[1]t x( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyt server_version_info4 s c C se | o
| i } | d j o d S| i | j o% | i i | i o | i S| Sd S( s/ Convert the name to lowercase if it is possibleN( t rstripR t uppert identifier_preparert _requires_quotest lower( R t name( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyt _normalize_nameK s
- c C sR | d j o d S| i | j o% | i i | i o | i S| Sd S( s6 Revert a *normalized* name to its uppercase equivalentN( R Rr Rp Rq Ro ( R Rs ( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyt _denormalize_nameX s
- c C s; d } g } | i | D] } | | i | d q ~ S( sD Return a list of *normalized* table names omitting system relations.sk
SELECT r.rdb$relation_name
FROM rdb$relations r
WHERE r.rdb$system_flag=0
i ( t executeRt ( R Rb R t sRk t row( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyt table_namesb s c C sJ d } | i | | i | g } | i } | d j o t St Sd S( sA Return ``True`` if the given table exists, ignoring the `schema`.s
SELECT 1 FROM rdb$database
WHERE EXISTS (SELECT rdb$relation_name
FROM rdb$relations
WHERE rdb$relation_name=?)
N( Rv Ru t fetchoneR RV t False( R Rb t
table_nameR t tblqryt cRx ( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyt has_tablel s
c C sJ d } | i | | i | g } | i } | d j o t St Sd S( s9 Return ``True`` if the given sequence (generator) exists.s
SELECT 1 FROM rdb$database
WHERE EXISTS (SELECT rdb$generator_name
FROM rdb$generators
WHERE rdb$generator_name=?)
N( Rv Ru Rz R RV R{ ( R Rb t
sequence_namet genqryR~ Rx ( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyt has_sequence| s
c C si t | | i i o d t | j St | | i i o$ t | } d | j p
d | j St Sd S( Ns* Unable to complete network request to hosts Invalid connection states Invalid cursor state( R RK t OperationalErrort strt ProgrammingErrorR{ ( R t et msg( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyt
is_disconnect s
c C s d } d } d } d } | i | i } | i | d | g } g }
| i D] } |
| i | d qS ~
} | i | | g } t }
xt o| i } | d j o Pn t }
| i | d } | o | | j o q n | g } h } t i
| d i } | d j o. t i
d t | d | f t i } n
| | } | i | | | j | d s c K s[ | o= | i | i d t | d | i i | | i | i S| i | i | Sd S( Nt asfromt ( R t originalRV t preparert format_aliast
_anonymizeRs ( R t aliasR RH ( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyt visit_aliasA s =t substringc C s# | i o | i | i Sd Sd S( Nt ( t clausesR t clause_expr( R t func( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyt function_argspecK s
c C s d S( Ns FROM rdb$database( ( R ( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyt default_fromQ s c C s d | i i | S( Ns
gen_id(%s, 1)( R t format_sequence( R t seq( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyt visit_sequenceT s c C s` d } | i o | d | i 7} n | i o | d | i 7} n | i o | d 7} n | S( s Called when building a ``SELECT`` statement, position is just
before column list Firebird puts the limit and offset right
after the ``SELECT``...
R s FIRST %d s SKIP %d s DISTINCT ( t _limitt _offsett _distinct( R t selectt result( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyt get_select_precolumnsW s
c C s d S( s< Already taken care of in the `get_select_precolumns` method.R ( ( R R ( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyt limit_clausef s t char_lengthc C s2 | i d j o | i d St t | i | S( s Substitute the ``length`` function.
On newer FB there is a ``char_length`` function, while older
ones need the ``strlen`` UDF.
R- s %(expr)s( Rs t LENGTH_FUNCTION_NAMEt superR t function_string( R R ( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyR l s c C sg | i t } d } g } | | D] } | | i | d t q' ~ } | d d i | 7} | S( Nc s sM xF | D]> } t | t i i o x | i D] } | Vq- Wq | Vq Wd S( N( R R t
expressiont
Selectablet columns( t collistR~ t co( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyt flatten_columnlisty s
t within_columns_clauses RETURNING s , ( RH t RETURNING_KW_NAMER RV t join( R R t stmtt returning_colsR Rk R~ R ( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyt _append_returningw s
/c C sA t t | i | } t | i j o | i | | S| Sd S( N( R R t visit_updateR RH R ( R t update_stmtR ( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyR s c C sA t t | i | } t | i j o | i | | S| Sd S( N( R R t visit_insertR RH R ( R t insert_stmtR ( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyR s c C sA t t | i | } t | i j o | i | | S| Sd S( N( R R t visit_deleteR RH R ( R t delete_stmtR ( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyR s ( R R R R t compilert DefaultCompilert operatorst copyRR t modR{ R t functionsR R R R R R R R R R R R ( ( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyR 7 s$
t FBSchemaGeneratorc B s e Z d Z d Z d Z RS( s! Firebird syntactic idiosincrasiesc K s | i i | } | d | i i | i i 7} | i | } | d j o | d | 7} n | i p
| i o | d 7} n | S( NR s DEFAULT s NOT NULL(
R t
format_columnt typet dialect_implR R
t get_column_default_stringR R R ( R t columnRH t colspecR ( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyt get_column_specification s #
c C sW | i p | i i | i | i o+ | i d | i i | | i n d S( s; Generate a ``CREATE GENERATOR`` statement for the sequence.s CREATE GENERATOR %sN( t
checkfirstR R Rb Rs R R R Rv ( R R ( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyR s ( ( R R R R
R ( ( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyR s
t FBSchemaDropperc B s e Z d Z d Z RS( s! Firebird syntactic idiosincrasiesc C sV | i p | i i | i | i o+ | i d | i i | | i n d S( s9 Generate a ``DROP GENERATOR`` statement for the sequence.s DROP GENERATOR %sN( R R R Rb Rs R R R Rv ( R R ( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyR s ' ( R R R R ( ( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyR s t FBDefaultRunnerc B s e Z d Z d Z RS( s Firebird specific idiosincrasiesc C s | i d | i i i | S( s8 Get the next value from the sequence using ``gen_id()``.s& SELECT gen_id(%s, 1) FROM rdb$database( t execute_stringR Rp R ( R R ( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyR s ( R R R R ( ( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyR s t actiont activet addt admint aftert allt altert andt anyt ast asct ascendingt att autot autoddlt avgt basedt basenamet base_namet beforet begint betweent bigintt blobt blobeditt buffert byt cachet cascadet caset castt chart charactert character_lengthR t checkt check_point_lent check_point_lengtht closet collatet collationR R t committedt compiletimet computedt conditionalt connectt
constraintt
containingt continuet countt createt cstringt currentt current_connectiont current_datet current_rolet current_timet current_timestampt current_transactiont current_userR t databaset dateR% t db_keyt debugt decR t declareR t deletet desct
descendingt describet
descriptort
disconnectt displayt distinctt dot domaint doublet dropt echot editt elset endt entry_pointt escapet eventt exceptionRv t existst exitt externt externalt extractt fetcht filet filterR t fort foreignt foundt free_itt fromt fullt functiont gdscodet generatort gen_idt globalt gotot grantRf t
group_commit_t group_commit_waitt havingt helpt hourt ift immediatet int inactivet indext indicatorRW t innert inputt
input_typet insertRg t integert intot ist isolationt isqlR t keyt lc_messagest lc_typet leftR- t levt levelt liket logfilet log_buffer_sizet log_buf_sizet longt manualt maxt maximumt maximum_segmentt max_segmentt merget messaget mint minimumt minutet module_nameR$ t namest nationalt naturalt nchart not noautot nott nullt numerict num_log_bufferst num_log_bufst octet_lengtht oft ont onlyt opent optiont ort ordert outert outputt output_typet overflowt paget
pagelengtht pagest page_sizet parametert passwordt plant positiont
post_eventR t preparet primaryt
privilegest proceduret protectedt publict quitt raw_partitionss
rdb$db_keyt readt realt record_versiont recreatet
referencest releaset reservt reservingt restrictt retaint returnt returning_valuest returnst revoket rightt roleR t row_countt runtimet savepointR t secondt segmentR t sett shadowt sharedt shellt showt singulart sizet smallintt snapshott somet sortt sqlcodet sqlerrort
sqlwarningt stabilityt startingt startsR t statict
statisticst sub_typet sumt suspendR t
terminatort thent timet timestampt tot transactiont translatet translationt triggert trimR t uncommittedt uniont uniqueRR Ro RM t usingR t valuest varchart variablet varyingRi t viewt waitt wait_timet weekdayt whent whenevert wheret whilet witht workt writeR# t yeardayt FBIdentifierPreparerc B s e Z d Z e Z d Z RS( s) Install Firebird specific reserved words.c C s t t | i | d t d S( Nt omit_schema( R R RE RV ( R R ( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyRE s ( R R R t RESERVED_WORDSt reserved_wordsRE ( ( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyR s (E R R& R Ra t
sqlalchemyR R R R[ R R t sqlalchemy.engineR R R{ RU t NumericR t FloatR t IntegerR t SmallintegerR t DateTimeR! R' t TimeR) t TextR+ t StringR, t CHARR. t BinaryR/ t BooleanR0 t DateR] R R t DefaultExecutionContextRA RD RB R R R R R t SchemaGeneratorR t
SchemaDropperR t
DefaultRunnerR R R t IdentifierPreparerR R t statement_compilert schemageneratort
schemadroppert
defaultrunnerR t execution_ctx_cls( ( ( sA /usr/lib/python2.6/site-packages/sqlalchemy/databases/firebird.pyt c s $(
! d
!