Module Expr Str Import alias ImportFrom alias identifier ImportFrom alias alias identifier alias alias ImportFrom alias ImportFrom alias alias alias ImportFrom alias ImportFrom alias alias alias alias alias alias alias alias alias alias alias Assign NameStore Call NameLoad ListLoad Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str ClassDef bases AttributeLoad NameLoad attr body Expr Str FunctionDef arguments args NameParam NameParam defaults NameLoad kwarg body Assign AttributeStore NameLoad attr NameLoad Expr Call AttributeLoad Call NameLoad NameLoad NameLoad attr NameLoad decorator_list decorator_list ClassDef bases NameLoad AttributeLoad NameLoad attr body Expr Str Assign NameStore Str FunctionDef arguments args NameParam NameParam defaults NameLoad kwarg body Expr Call AttributeLoad Call NameLoad NameLoad NameLoad attr keyword NameLoad NameLoad decorator_list decorator_list ClassDef bases NameLoad AttributeLoad NameLoad attr body Expr Str Assign NameStore Str FunctionDef arguments args NameParam NameParam defaults NameLoad kwarg body Expr Call AttributeLoad Call NameLoad NameLoad NameLoad attr keyword NameLoad NameLoad decorator_list decorator_list ClassDef bases AttributeLoad NameLoad attr body FunctionDef arguments args NameParam NameParam defaults body FunctionDef arguments args NameParam defaults body If CompareEq Call NameLoad NameLoad AttributeLoad NameLoad attr body Return Call AttributeLoad NameLoad attr AttributeLoad NameLoad attr AttributeLoad NameLoad attr AttributeLoad NameLoad attr orelse Return NameLoad decorator_list Return NameLoad decorator_list decorator_list Assign NameStore Dict AttributeLoad NameLoad attr NameLoad Assign NameStore Dict Str Str Str Str Str Str Str Str Str Str Str Str Str NameLoad NameLoad NameLoad NameLoad NameLoad NameLoad NameLoad NameLoad NameLoad NameLoad NameLoad NameLoad NameLoad ClassDef bases AttributeLoad NameLoad attr body FunctionDef arguments args NameParam NameParam defaults kwarg body Return Call AttributeLoad NameLoad attr NameLoad NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults kwarg body Return Call AttributeLoad NameLoad attr NameLoad NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults kwarg body Return Str decorator_list FunctionDef arguments args NameParam NameParam defaults kwarg body Return Str decorator_list FunctionDef arguments args NameParam NameParam NameParam defaults body Assign NameStore Call NameLoad NameLoad Str NameLoad If CompareIs NameLoad NameLoad body Return NameLoad orelse Return BinOpMod Str TupleLoad NameLoad NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults kwarg body Assign NameStore Call AttributeLoad Call NameLoad NameLoad NameLoad attr NameLoad NameLoad Return Call AttributeLoad NameLoad attr NameLoad NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults kwarg body If UnaryOpNot AttributeLoad NameLoad attr body Raise Call AttributeLoad NameLoad attr BinOpMod Str AttributeLoad AttributeLoad NameLoad attr attr Assign NameStore Call AttributeLoad Call NameLoad NameLoad NameLoad attr NameLoad NameLoad Return Call AttributeLoad NameLoad attr NameLoad NameLoad decorator_list decorator_list ClassDef bases AttributeLoad AttributeLoad NameLoad attr attr body Expr Str Assign NameStore NameLoad FunctionDef arguments args NameParam NameParam defaults kwarg body Return Str decorator_list FunctionDef arguments args NameParam NameParam NameParam defaults kwarg body Return BinOpMod Str TupleLoad Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad NameLoad Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad NameLoad decorator_list FunctionDef arguments args NameParam NameParam NameParam defaults kwarg body Return BinOpMod Str TupleLoad Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad NameLoad Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad NameLoad decorator_list FunctionDef arguments args NameParam NameParam NameParam defaults kwarg body Return BinOpMod Str TupleLoad Call AttributeLoad NameLoad attr AttributeLoad NameLoad attr NameLoad Call AttributeLoad NameLoad attr AttributeLoad NameLoad attr NameLoad decorator_list FunctionDef arguments args NameParam NameParam NameParam defaults NameLoad kwarg body If AttributeLoad AttributeLoad NameLoad attr attr body Return Call AttributeLoad Call NameLoad NameLoad NameLoad attr NameLoad keyword NameLoad NameLoad orelse If NameLoad body Assign NameStore BoolOpOr BoolOpAnd Call NameLoad AttributeLoad NameLoad attr AttributeLoad NameLoad attr Call AttributeLoad NameLoad attr Str AttributeLoad NameLoad attr AttributeLoad NameLoad attr Return BinOpAdd BinOpAdd Call AttributeLoad NameLoad attr AttributeLoad NameLoad attr keyword NameLoad NameLoad Str Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad NameLoad orelse Return Call AttributeLoad NameLoad attr AttributeLoad NameLoad attr NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults kwarg body Assign NameStore Call AttributeLoad NameLoad attr SubscriptLoad AttributeLoad AttributeLoad NameLoad attr attr Index Num Assign NameStore Call AttributeLoad NameLoad attr SubscriptLoad AttributeLoad AttributeLoad NameLoad attr attr Index Num If CompareGt Call NameLoad AttributeLoad AttributeLoad NameLoad attr attr Num body Assign NameStore Call AttributeLoad NameLoad attr SubscriptLoad AttributeLoad AttributeLoad NameLoad attr attr Index Num Return BinOpMod Str TupleLoad NameLoad NameLoad NameLoad orelse Return BinOpMod Str TupleLoad NameLoad NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults kwarg body If AttributeLoad AttributeLoad NameLoad attr attr body Return BinOpAdd Str Call AttributeLoad NameLoad attr NameLoad orelse Return BinOpAdd Str Call AttributeLoad NameLoad attr NameLoad decorator_list Assign NameStore NameLoad FunctionDef arguments args NameParam NameParam defaults kwarg body If BoolOpAnd CompareIsNot AttributeLoad NameLoad attr NameLoad Call NameLoad AttributeLoad NameLoad attr body Return Call AttributeLoad NameLoad attr AttributeLoad NameLoad attr NameLoad orelse Return Str decorator_list FunctionDef arguments args NameParam defaults body Return Str decorator_list FunctionDef arguments args NameParam NameParam defaults body Return BinOpMod Str Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults kwarg body Expr Str Assign NameStore Str If CompareIsNot AttributeLoad NameLoad attr NameLoad body AugAssignAdd NameStore BinOpMod Str Call AttributeLoad NameLoad attr AttributeLoad NameLoad attr NameLoad If CompareIsNot AttributeLoad NameLoad attr NameLoad body AugAssignAdd NameStore BinOpMod Str Call AttributeLoad NameLoad attr AttributeLoad NameLoad attr NameLoad If AttributeLoad NameLoad attr body AugAssignAdd NameStore Str Return NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults kwarg body Expr Str Return Str decorator_list FunctionDef arguments args NameParam NameParam NameParam defaults body Assign NameStore ListComp Call AttributeLoad NameLoad attr NameLoad NameLoad NameLoad NameLoad Dict comprehension NameStore Call AttributeLoad NameLoad attr NameLoad Return BinOpAdd Str Call AttributeLoad Str attr NameLoad decorator_list decorator_list ClassDef bases AttributeLoad AttributeLoad NameLoad attr attr body Expr Str FunctionDef arguments args NameParam NameParam defaults body Expr Str If CompareIsNot AttributeLoad AttributeLoad NameLoad attr attr NameLoad body Raise Call NameLoad Str If CompareIsNot AttributeLoad AttributeLoad NameLoad attr attr NameLoad body Raise Call NameLoad Str If AttributeLoad AttributeLoad NameLoad attr attr body Return BinOpMod Str Call AttributeLoad AttributeLoad NameLoad attr attr AttributeLoad NameLoad attr orelse Return BinOpMod Str Call AttributeLoad AttributeLoad NameLoad attr attr AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam NameParam defaults body Expr Str If AttributeLoad AttributeLoad NameLoad attr attr body Return BinOpMod Str Call AttributeLoad AttributeLoad NameLoad attr attr AttributeLoad NameLoad attr orelse Return BinOpMod Str Call AttributeLoad AttributeLoad NameLoad attr attr AttributeLoad NameLoad attr decorator_list decorator_list ClassDef bases AttributeLoad AttributeLoad NameLoad attr attr body Expr Str Assign NameStore NameLoad Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr ListLoad Str FunctionDef arguments args NameParam NameParam defaults body Expr Call AttributeLoad Call NameLoad NameLoad NameLoad attr NameLoad keyword NameLoad decorator_list decorator_list ClassDef bases AttributeLoad NameLoad attr body FunctionDef arguments args NameParam NameParam NameParam defaults body Expr Str Return Call AttributeLoad NameLoad attr BinOpMod Str Call AttributeLoad AttributeLoad AttributeLoad NameLoad attr attr attr NameLoad NameLoad decorator_list decorator_list ClassDef bases AttributeLoad NameLoad attr body Expr Str Assign NameStore Str Assign NameStore Num Assign NameStore NameLoad Assign NameStore NameLoad Assign NameStore NameLoad Assign NameStore NameLoad Assign NameStore NameLoad Assign NameStore NameLoad Assign NameStore NameLoad Assign NameStore NameLoad Assign NameStore NameLoad Assign NameStore NameLoad Assign NameStore NameLoad Assign NameStore NameLoad Assign NameStore NameLoad Assign NameStore NameLoad Assign NameStore ListLoad Assign NameStore NameLoad FunctionDef arguments args NameParam NameParam defaults body Expr Call AttributeLoad Call NameLoad NameLoad NameLoad attr NameLoad Assign AttributeStore NameLoad attr BoolOpOr BoolOpAnd CompareIn Str AttributeLoad NameLoad attr CompareGtE AttributeLoad NameLoad attr TupleLoad Num BoolOpAnd CompareIn Str AttributeLoad NameLoad attr CompareGtE AttributeLoad NameLoad attr TupleLoad Num If UnaryOpNot AttributeLoad NameLoad attr body Assign AttributeStore NameLoad attr Call AttributeLoad NameLoad attr Assign SubscriptStore AttributeLoad NameLoad attr Index Str AttributeLoad NameLoad attr Assign AttributeStore NameLoad attr Dict AttributeLoad NameLoad attr AttributeLoad NameLoad attr Assign AttributeStore NameLoad attr BoolOpAnd AttributeLoad NameLoad attr Call AttributeLoad AttributeLoad NameLoad attr attr Str NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults body Assign NameStore BoolOpAnd NameLoad Call AttributeLoad NameLoad attr If CompareIs NameLoad NameLoad body Return NameLoad orelse If BoolOpAnd CompareEq Call AttributeLoad NameLoad attr NameLoad UnaryOpNot Call AttributeLoad AttributeLoad NameLoad attr attr Call AttributeLoad NameLoad attr body Return Call AttributeLoad NameLoad attr orelse Return NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults body If CompareIs NameLoad NameLoad body Return NameLoad orelse If BoolOpAnd CompareEq Call AttributeLoad NameLoad attr NameLoad UnaryOpNot Call AttributeLoad AttributeLoad NameLoad attr attr Call AttributeLoad NameLoad attr body Return Call AttributeLoad NameLoad attr orelse Return NameLoad decorator_list FunctionDef arguments args NameParam NameParam NameParam NameParam defaults NameLoad body Expr Str Assign NameStore Str Assign NameStore Call AttributeLoad NameLoad attr NameLoad ListLoad Call AttributeLoad NameLoad attr NameLoad Return CompareIsNot Call AttributeLoad NameLoad attr NameLoad decorator_list FunctionDef arguments args NameParam NameParam NameParam NameParam defaults NameLoad body Expr Str Assign NameStore Str Assign NameStore Call AttributeLoad NameLoad attr NameLoad ListLoad Call AttributeLoad NameLoad attr NameLoad Return CompareIsNot Call AttributeLoad NameLoad attr NameLoad decorator_list FunctionDef arguments args NameParam NameParam NameParam defaults NameLoad kwarg body Assign NameStore Str Return ListComp Call AttributeLoad NameLoad attr SubscriptLoad NameLoad Index Num comprehension NameStore Call AttributeLoad NameLoad attr NameLoad decorator_list AttributeLoad NameLoad attr FunctionDef arguments args NameParam NameParam NameParam defaults NameLoad kwarg body Assign NameStore Str Return ListComp Call AttributeLoad NameLoad attr SubscriptLoad NameLoad Index Num comprehension NameStore Call AttributeLoad NameLoad attr NameLoad decorator_list AttributeLoad NameLoad attr FunctionDef arguments args NameParam NameParam NameParam NameParam defaults NameLoad kwarg body Assign NameStore Str Assign NameStore Call AttributeLoad NameLoad attr NameLoad ListLoad Call AttributeLoad NameLoad attr NameLoad Assign NameStore Call AttributeLoad NameLoad attr If NameLoad body Return SubscriptLoad NameLoad Index Str orelse Return NameLoad decorator_list AttributeLoad NameLoad attr FunctionDef arguments args NameParam NameParam NameParam NameParam defaults NameLoad kwarg body Assign NameStore Str Assign NameStore Call AttributeLoad NameLoad attr NameLoad Assign NameStore Call AttributeLoad NameLoad attr NameLoad ListLoad Str NameLoad Assign NameStore ListComp Call AttributeLoad NameLoad attr SubscriptLoad NameLoad Index Str comprehension NameStore Call AttributeLoad NameLoad attr Return Dict Str Str NameLoad NameLoad decorator_list AttributeLoad NameLoad attr FunctionDef arguments args NameParam NameParam NameParam NameParam NameParam defaults NameLoad kwarg body Assign NameStore Call AttributeLoad NameLoad attr NameLoad Assign NameStore Call AttributeLoad NameLoad attr NameLoad Assign NameStore Str Assign NameStore Call AttributeLoad Call AttributeLoad NameLoad attr NameLoad ListLoad NameLoad NameLoad attr If CompareIsNot NameLoad NameLoad body Return Call NameLoad keyword Call AttributeLoad NameLoad attr SubscriptLoad NameLoad Index Str decorator_list AttributeLoad NameLoad attr FunctionDef arguments args NameParam NameParam NameParam NameParam defaults NameLoad kwarg body Assign NameStore Str Assign NameStore Call AttributeLoad NameLoad attr NameLoad NameLoad Assign NameStore SubscriptLoad NameLoad Index Str Assign NameStore Call AttributeLoad NameLoad attr NameLoad Assign NameStore Call AttributeLoad NameLoad attr NameLoad ListLoad NameLoad Assign NameStore ListLoad While NameLoad body Assign NameStore Call AttributeLoad NameLoad attr If CompareIs NameLoad NameLoad body Break Assign NameStore Call AttributeLoad NameLoad attr SubscriptLoad NameLoad Index Str Assign NameStore SubscriptLoad NameLoad Index Str Assign NameStore Call AttributeLoad SubscriptLoad NameLoad Index Str attr Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad If CompareIs NameLoad NameLoad body Expr Call AttributeLoad NameLoad attr BinOpMod Str TupleLoad NameLoad NameLoad Assign NameStore AttributeLoad NameLoad attr orelse If BoolOpAnd Call NameLoad NameLoad NameLoad CompareNotEq SubscriptLoad NameLoad Index Str Num body Assign NameStore Call NameLoad keyword SubscriptLoad NameLoad Index Str keyword BinOpMult SubscriptLoad NameLoad Index Str Num orelse If CompareIn NameLoad TupleLoad Str Str body Assign NameStore Call NameLoad SubscriptLoad NameLoad Index Str orelse If CompareEq NameLoad Str body Assign NameStore Call NameLoad SubscriptLoad NameLoad Index Str orelse If CompareEq NameLoad Str body If CompareEq SubscriptLoad NameLoad Index Str Num body Assign NameStore Call NameLoad orelse Assign NameStore Call NameLoad orelse Assign NameStore Call NameLoad Assign NameStore NameLoad If CompareIsNot SubscriptLoad NameLoad Index Str NameLoad body Assign NameStore Call AttributeLoad SubscriptLoad NameLoad Index Str attr Assert CompareEq Call AttributeLoad Call AttributeLoad SubscriptLoad NameLoad Slice Num attr attr Str BinOpMod Str NameLoad Assign NameStore Call AttributeLoad SubscriptLoad NameLoad Slice Num attr If CompareEq NameLoad Str body Assign NameStore NameLoad Assign NameStore Dict Str Str Str Str Str NameLoad NameLoad UnaryOpNot Call NameLoad SubscriptLoad NameLoad Index Str NameLoad Str If CompareEq Call AttributeLoad NameLoad attr NameLoad body Assign SubscriptStore NameLoad Index Str NameLoad If BoolOpAnd CompareEq Call NameLoad NameLoad Num CompareEq NameLoad SubscriptLoad NameLoad Index Num body Assign NameStore Call AttributeLoad NameLoad attr NameLoad NameLoad NameLoad If CompareIsNot NameLoad NameLoad body Assign SubscriptStore NameLoad Index Str NameLoad Expr Call AttributeLoad NameLoad attr NameLoad Return NameLoad decorator_list AttributeLoad NameLoad attr FunctionDef arguments args NameParam NameParam NameParam NameParam defaults NameLoad kwarg body Assign NameStore Str Assign NameStore Call AttributeLoad NameLoad attr NameLoad Assign NameStore Call AttributeLoad NameLoad attr NameLoad ListLoad Str NameLoad Assign NameStore Call AttributeLoad NameLoad attr Lambda arguments args defaults Dict Str Str Str Str Str NameLoad ListLoad NameLoad NameLoad ListLoad For NameStore NameLoad body Assign NameStore Call AttributeLoad NameLoad attr SubscriptLoad NameLoad Index Str Assign NameStore SubscriptLoad NameLoad Index NameLoad If UnaryOpNot SubscriptLoad NameLoad Index Str body Assign SubscriptStore NameLoad Index Str NameLoad Assign SubscriptStore NameLoad Index Str Call AttributeLoad NameLoad attr SubscriptLoad NameLoad Index Str Expr Call AttributeLoad SubscriptLoad NameLoad Index Str attr Call AttributeLoad NameLoad attr SubscriptLoad NameLoad Index Str Expr Call AttributeLoad SubscriptLoad NameLoad Index Str attr Call AttributeLoad NameLoad attr SubscriptLoad NameLoad Index Str Return Call NameLoad Call AttributeLoad NameLoad attr decorator_list AttributeLoad NameLoad attr FunctionDef arguments args NameParam NameParam NameParam NameParam defaults NameLoad kwarg body Assign NameStore Str Assign NameStore Call AttributeLoad NameLoad attr NameLoad ListLoad Call AttributeLoad NameLoad attr NameLoad Assign NameStore Call AttributeLoad NameLoad attr NameLoad For NameStore NameLoad body Assign NameStore SubscriptLoad NameLoad Index SubscriptLoad NameLoad Index Str If CompareNotIn Str NameLoad body Assign SubscriptStore NameLoad Index Str Call AttributeLoad NameLoad attr SubscriptLoad NameLoad Index Str Assign SubscriptStore NameLoad Index Str ListLoad Assign SubscriptStore NameLoad Index Str Call NameLoad SubscriptLoad NameLoad Index Str Expr Call AttributeLoad SubscriptLoad NameLoad Index Str attr Call AttributeLoad NameLoad attr SubscriptLoad NameLoad Index Str Return Call NameLoad Call AttributeLoad NameLoad attr decorator_list AttributeLoad NameLoad attr decorator_list
N/A N/A 

.. dialect:: firebird
    :name: Firebird

Firebird Dialects
-----------------

Firebird offers two distinct dialects_ (not to be confused with a
SQLAlchemy ``Dialect``):

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.

The SQLAlchemy Firebird dialect detects these versions and
adjusts its representation of SQL accordingly.  However,
support for dialect 1 is not well tested and probably has
incompatibilities.

Locking Behavior
----------------

Firebird locks tables aggressively.  For this reason, a DROP TABLE may
hang until other transactions are released.  SQLAlchemy does its best
to release transactions as quickly as possible.  The most common cause
of hanging transactions is a non-fully consumed result set, i.e.::

    result = engine.execute("select * from table")
    row = result.fetchone()
    return

Where above, the ``ResultProxy`` has not been fully consumed.  The
connection will be returned to the pool and the transactional state
rolled back once the Python garbage collector reclaims the objects
which hold onto the connection, which often occurs asynchronously.
The above use case can be alleviated by calling ``first()`` on the
``ResultProxy`` which will fetch the first row and immediately close
all remaining cursor/connection resources.

RETURNING support
-----------------

Firebird 2.0 supports returning a result set from inserts, and 2.1
extends that to deletes and updates. This is generically exposed by
the SQLAlchemy ``returning()`` method, such as::

    # INSERT..RETURNING
    result = table.insert().returning(table.c.col1, table.c.col2).\
                   values(name='foo')
    print result.fetchall()

    # UPDATE..RETURNING
    raises = empl.update().returning(empl.c.id, empl.c.salary).\
                  where(empl.c.sales>100).\
                  values(dict(salary=empl.c.salary * 1.1))
    print raises.fetchall()


.. _dialects: http://mc-computing.com/Databases/Firebird/SQL_Dialect.html

 N/A datetime sqlalchemy schema sa_schema sqlalchemy exc types sqltypes sql util sqlalchemy.sql expression sqlalchemy.engine base default reflection sqlalchemy.sql compiler sqlalchemy.types BIGINT BLOB DATE FLOAT INTEGER NUMERIC SMALLINT TEXT TIME TIMESTAMP Integer N/A RESERVED_WORDS N/A set N/A active add admin after all alter and any as asc ascending at auto avg before begin between bigint bit_length blob both by case cast char character character_length char_length check close collate column commit committed computed conditional connect constraint containing count create cross cstring current current_connection current_date current_role current_time current_timestamp current_transaction current_user cursor database date day dec decimal declare default delete desc descending disconnect distinct do domain double drop else end entry_point escape exception execute exists exit external extract fetch file filter float for foreign from full function gdscode generator gen_id global grant group having hour if in inactive index inner input_type insensitive insert int integer into is isolation join key leading left length level like long lower manual max maximum_segment merge min minute module_name month names national natural nchar no not null numeric octet_length of on only open option or order outer output_type overflow page pages page_size parameter password plan position post_event precision primary privileges procedure protected rdb$db_key read real record_version recreate recursive references release reserv reserving retain returning_values returns revoke right rollback rows row_count savepoint schema second segment select sensitive set shadow shared singular size smallint snapshot some sort sqlcode stability start starting starts statistics sub_type sum suspend table then time timestamp to trailing transaction trigger trim uncommitted union unique update upper user using value values varchar variable varying view wait when where while with work write year _StringType N/A N/A sqltypes String N/A N/A Base for Firebird string types. __init__ N/A N/A self charset N/A None kw N/A N/A N/A self charset charset N/A N/A N/A N/A super _StringType self __init__ kw N/A N/A VARCHAR N/A _StringType N/A sqltypes VARCHAR N/A N/A Firebird VARCHAR type N/A __visit_name__ VARCHAR __init__ N/A N/A self length N/A None kwargs N/A N/A N/A N/A N/A super VARCHAR self __init__ length length kwargs N/A N/A CHAR N/A _StringType N/A sqltypes CHAR N/A N/A Firebird CHAR type N/A __visit_name__ CHAR __init__ N/A N/A self length N/A None kwargs N/A N/A N/A N/A N/A super CHAR self __init__ length length kwargs N/A N/A _FBDateTime N/A N/A sqltypes DateTime N/A bind_processor N/A N/A self dialect N/A N/A process N/A N/A value N/A N/A N/A N/A N/A type value N/A datetime date N/A N/A N/A N/A datetime datetime N/A value year N/A value month N/A value day N/A N/A value N/A N/A process N/A N/A N/A colspecs N/A N/A sqltypes DateTime _FBDateTime N/A ischema_names N/A SHORT LONG QUAD FLOAT DATE TIME TEXT INT64 DOUBLE TIMESTAMP VARYING CSTRING BLOB SMALLINT INTEGER FLOAT FLOAT DATE TIME TEXT BIGINT FLOAT TIMESTAMP VARCHAR CHAR BLOB FBTypeCompiler N/A N/A compiler GenericTypeCompiler N/A visit_boolean N/A N/A self type_ N/A kw N/A N/A N/A N/A self visit_SMALLINT type_ kw N/A visit_datetime N/A N/A self type_ N/A kw N/A N/A N/A N/A self visit_TIMESTAMP type_ kw N/A visit_TEXT N/A N/A self type_ N/A kw N/A N/A BLOB SUB_TYPE 1 N/A visit_BLOB N/A N/A self type_ N/A kw N/A N/A BLOB SUB_TYPE 0 N/A _extend_string N/A N/A self type_ basic N/A N/A N/A charset N/A getattr type_ charset None N/A N/A charset None N/A N/A basic N/A N/A N/A %s CHARACTER SET %s N/A basic charset N/A visit_CHAR N/A N/A self type_ N/A kw N/A N/A basic N/A N/A N/A super FBTypeCompiler self visit_CHAR type_ kw N/A N/A N/A self _extend_string type_ basic N/A visit_VARCHAR N/A N/A self type_ N/A kw N/A N/A N/A N/A type_ length N/A N/A N/A N/A exc CompileError N/A VARCHAR requires a length on dialect %s N/A N/A self dialect name N/A basic N/A N/A N/A super FBTypeCompiler self visit_VARCHAR type_ kw N/A N/A N/A self _extend_string type_ basic N/A N/A FBCompiler N/A N/A N/A sql compiler SQLCompiler N/A N/A Firebird specific idiosyncrasies N/A ansi_bind_rules True visit_now_func N/A N/A self fn N/A kw N/A N/A CURRENT_TIMESTAMP N/A visit_startswith_op_binary N/A N/A self binary operator N/A kw N/A N/A N/A %s STARTING WITH %s N/A N/A N/A N/A binary left _compiler_dispatch self kw N/A N/A N/A binary right _compiler_dispatch self kw N/A visit_notstartswith_op_binary N/A N/A self binary operator N/A kw N/A N/A N/A %s NOT STARTING WITH %s N/A N/A N/A N/A binary left _compiler_dispatch self kw N/A N/A N/A binary right _compiler_dispatch self kw N/A visit_mod_binary N/A N/A self binary operator N/A kw N/A N/A N/A mod(%s, %s) N/A N/A N/A self process N/A binary left kw N/A N/A self process N/A binary right kw N/A visit_alias N/A N/A self alias asfrom N/A False kwargs N/A N/A N/A N/A self dialect _version_two N/A N/A N/A N/A N/A super FBCompiler self visit_alias alias asfrom asfrom kwargs N/A N/A asfrom N/A N/A alias_name N/A N/A N/A isinstance N/A alias name N/A expression _truncated_label N/A N/A self _truncated_identifier alias N/A alias name N/A alias name N/A N/A N/A N/A N/A self process N/A alias original asfrom asfrom kwargs N/A N/A N/A self preparer format_alias alias alias_name N/A N/A N/A N/A self process N/A alias original kwargs N/A visit_substring_func N/A N/A self func N/A kw N/A N/A s N/A N/A self process N/A N/A N/A func clauses clauses N/A 0 N/A start N/A N/A self process N/A N/A N/A func clauses clauses N/A 1 N/A N/A N/A len N/A N/A func clauses clauses 2 N/A N/A length N/A N/A self process N/A N/A N/A func clauses clauses N/A 2 N/A N/A SUBSTRING(%s FROM %s FOR %s) N/A s start length N/A N/A N/A SUBSTRING(%s FROM %s) N/A s start N/A visit_length_func N/A N/A self function N/A kw N/A N/A N/A N/A self dialect _version_two N/A N/A N/A char_length N/A N/A self function_argspec function N/A N/A N/A strlen N/A N/A self function_argspec function N/A N/A visit_char_length_func visit_length_func function_argspec N/A N/A self func N/A kw N/A N/A N/A N/A N/A func clauses None N/A len N/A func clauses N/A N/A N/A N/A self process N/A func clause_expr kw N/A N/A N/A default_from N/A N/A self N/A N/A N/A  FROM rdb$database N/A visit_sequence N/A N/A self seq N/A N/A N/A N/A gen_id(%s, 1) N/A N/A N/A self preparer format_sequence seq N/A get_select_precolumns N/A N/A self select N/A kw N/A N/A Called when building a ``SELECT`` statement, position is just
        before column list Firebird puts the limit and offset right
        after the ``SELECT``...
         N/A result N/A N/A N/A select _limit_clause None N/A N/A result N/A FIRST %s  N/A N/A self process N/A select _limit_clause kw N/A N/A N/A select _offset_clause None N/A N/A result N/A SKIP %s  N/A N/A self process N/A select _offset_clause kw N/A N/A select _distinct N/A N/A result DISTINCT  N/A result N/A limit_clause N/A N/A self select N/A kw N/A N/A Already taken care of in the `get_select_precolumns` method. N/A N/A returning_clause N/A N/A self stmt returning_cols N/A N/A N/A columns N/A N/A N/A self _label_select_column None c True False N/A N/A c N/A N/A expression _select_iterables returning_cols N/A N/A RETURNING  N/A N/A ,  join columns N/A N/A FBDDLCompiler N/A N/A N/A sql compiler DDLCompiler N/A N/A Firebird syntactic idiosyncrasies visit_create_sequence N/A N/A self create N/A N/A N/A Generate a ``CREATE GENERATOR`` statement for the sequence. N/A N/A N/A N/A create element start None N/A N/A N/A NotImplemented Firebird SEQUENCE doesn't support START WITH N/A N/A N/A N/A create element increment None N/A N/A N/A NotImplemented Firebird SEQUENCE doesn't support INCREMENT BY N/A N/A N/A self dialect _version_two N/A N/A N/A CREATE SEQUENCE %s N/A N/A N/A self preparer format_sequence N/A create element N/A N/A N/A CREATE GENERATOR %s N/A N/A N/A self preparer format_sequence N/A create element N/A visit_drop_sequence N/A N/A self drop N/A N/A N/A Generate a ``DROP GENERATOR`` statement for the sequence. N/A N/A N/A self dialect _version_two N/A N/A N/A DROP SEQUENCE %s N/A N/A N/A self preparer format_sequence N/A drop element N/A N/A N/A DROP GENERATOR %s N/A N/A N/A self preparer format_sequence N/A drop element N/A N/A FBIdentifierPreparer N/A N/A N/A sql compiler IdentifierPreparer N/A N/A Install Firebird specific reserved words. N/A reserved_words RESERVED_WORDS N/A illegal_initial_characters N/A N/A N/A compiler ILLEGAL_INITIAL_CHARACTERS union N/A _ __init__ N/A N/A self dialect N/A N/A N/A N/A N/A N/A super FBIdentifierPreparer self __init__ dialect omit_schema True N/A N/A FBExecutionContext N/A N/A default DefaultExecutionContext N/A fire_sequence N/A N/A self seq type_ N/A N/A N/A Get the next value from the sequence using ``gen_id()``. N/A N/A N/A self _execute_scalar N/A SELECT gen_id(%s, 1) FROM rdb$database N/A N/A N/A N/A self dialect identifier_preparer format_sequence seq type_ N/A N/A FBDialect N/A N/A default DefaultDialect N/A N/A Firebird dialect N/A name firebird N/A max_identifier_length 31 N/A supports_sequences True N/A sequences_optional False N/A supports_default_values True N/A postfetch_lastrowid False N/A supports_native_boolean False N/A requires_name_normalize True N/A supports_empty_insert False N/A statement_compiler FBCompiler N/A ddl_compiler FBDDLCompiler N/A preparer FBIdentifierPreparer N/A type_compiler FBTypeCompiler N/A execution_ctx_cls FBExecutionContext N/A colspecs colspecs N/A ischema_names ischema_names N/A construct_arguments N/A N/A _version_two True initialize N/A N/A self connection N/A N/A N/A N/A N/A N/A super FBDialect self initialize connection N/A N/A self _version_two N/A N/A N/A firebird N/A self server_version_info N/A N/A self server_version_info N/A 2 N/A N/A interbase N/A self server_version_info N/A N/A self server_version_info N/A 6 N/A N/A N/A self _version_two N/A N/A N/A self ischema_names N/A N/A ischema_names copy N/A N/A N/A self ischema_names N/A TIMESTAMP N/A sqltypes DATE N/A N/A self colspecs N/A N/A sqltypes DateTime N/A sqltypes DATE N/A N/A self implicit_returning N/A N/A self _version_two N/A N/A N/A self __dict__ get implicit_returning True N/A normalize_name N/A N/A self name N/A N/A N/A name N/A name N/A N/A name rstrip N/A N/A name None N/A N/A None N/A N/A N/A N/A N/A N/A name upper name N/A N/A N/A N/A self identifier_preparer _requires_quotes N/A N/A name lower N/A N/A N/A N/A name lower N/A N/A name N/A denormalize_name N/A N/A self name N/A N/A N/A N/A name None N/A N/A None N/A N/A N/A N/A N/A N/A name lower name N/A N/A N/A N/A self identifier_preparer _requires_quotes N/A N/A name lower N/A N/A N/A N/A name upper N/A N/A name N/A has_table N/A N/A self connection table_name schema N/A None N/A N/A Return ``True`` if the given table exists, ignoring
        the `schema`. N/A tblqry 
        SELECT 1 AS has_table FROM rdb$database
        WHERE EXISTS (SELECT rdb$relation_name
                      FROM rdb$relations
                      WHERE rdb$relation_name=?)
         N/A c N/A N/A connection execute tblqry N/A N/A N/A self denormalize_name table_name N/A N/A N/A N/A c first None N/A has_sequence N/A N/A self connection sequence_name schema N/A None N/A N/A Return ``True`` if the given sequence (generator) exists. N/A genqry 
        SELECT 1 AS has_sequence FROM rdb$database
        WHERE EXISTS (SELECT rdb$generator_name
                      FROM rdb$generators
                      WHERE rdb$generator_name=?)
         N/A c N/A N/A connection execute genqry N/A N/A N/A self denormalize_name sequence_name N/A N/A N/A N/A c first None N/A get_table_names N/A N/A self connection schema N/A None kw N/A N/A s 
        select rdb$relation_name
        from rdb$relations
        where rdb$view_blr is null
        and (rdb$system_flag is null or rdb$system_flag = 0);
         N/A N/A N/A N/A self normalize_name N/A row N/A 0 N/A row N/A N/A connection execute s N/A N/A reflection cache get_view_names N/A N/A self connection schema N/A None kw N/A N/A s 
        select rdb$relation_name
        from rdb$relations
        where rdb$view_blr is not null
        and (rdb$system_flag is null or rdb$system_flag = 0);
         N/A N/A N/A N/A self normalize_name N/A row N/A 0 N/A row N/A N/A connection execute s N/A N/A reflection cache get_view_definition N/A N/A self connection view_name schema N/A None kw N/A N/A qry 
        SELECT rdb$view_source AS view_source
        FROM rdb$relations
        WHERE rdb$relation_name=?
         N/A rp N/A N/A connection execute qry N/A N/A N/A self denormalize_name view_name N/A row N/A N/A rp first N/A row N/A N/A N/A row N/A view_source N/A N/A None N/A N/A reflection cache get_pk_constraint N/A N/A self connection table_name schema N/A None kw N/A N/A keyqry 
        SELECT se.rdb$field_name AS fname
        FROM rdb$relation_constraints rc
             JOIN rdb$index_segments se ON rc.rdb$index_name=se.rdb$index_name
        WHERE rc.rdb$constraint_type=? AND rc.rdb$relation_name=?
         N/A tablename N/A N/A self denormalize_name table_name N/A c N/A N/A connection execute keyqry N/A PRIMARY KEY tablename N/A pkfields N/A N/A N/A self normalize_name N/A r N/A fname N/A r N/A N/A c fetchall N/A N/A constrained_columns name pkfields None N/A N/A reflection cache get_column_sequence N/A N/A self connection table_name column_name schema N/A None kw N/A N/A tablename N/A N/A self denormalize_name table_name N/A colname N/A N/A self denormalize_name column_name N/A genqry 
        SELECT trigdep.rdb$depended_on_name AS fgenerator
        FROM rdb$dependencies tabdep
             JOIN rdb$dependencies trigdep
                  ON tabdep.rdb$dependent_name=trigdep.rdb$dependent_name
                     AND trigdep.rdb$depended_on_type=14
                     AND trigdep.rdb$dependent_type=2
             JOIN rdb$triggers trig ON
                    trig.rdb$trigger_name=tabdep.rdb$dependent_name
        WHERE tabdep.rdb$depended_on_name=?
          AND tabdep.rdb$depended_on_type=0
          AND trig.rdb$trigger_type=1
          AND tabdep.rdb$field_name=?
          AND (SELECT count(*)
           FROM rdb$dependencies trigdep2
           WHERE trigdep2.rdb$dependent_name = trigdep.rdb$dependent_name) = 2
         N/A genr N/A N/A N/A N/A connection execute genqry N/A tablename colname first N/A N/A genr None N/A N/A N/A dict name N/A N/A self normalize_name N/A genr N/A fgenerator N/A N/A reflection cache get_columns N/A N/A self connection table_name schema N/A None kw N/A N/A tblqry 
        SELECT r.rdb$field_name AS fname,
                        r.rdb$null_flag AS null_flag,
                        t.rdb$type_name AS ftype,
                        f.rdb$field_sub_type AS stype,
                        f.rdb$field_length/
                            COALESCE(cs.rdb$bytes_per_character,1) AS flen,
                        f.rdb$field_precision AS fprec,
                        f.rdb$field_scale AS fscale,
                        COALESCE(r.rdb$default_source,
                                f.rdb$default_source) AS fdefault
        FROM rdb$relation_fields r
             JOIN rdb$fields f ON r.rdb$field_source=f.rdb$field_name
             JOIN rdb$types t
              ON t.rdb$type=f.rdb$field_type AND
                    t.rdb$field_name='RDB$FIELD_TYPE'
             LEFT JOIN rdb$character_sets cs ON
                    f.rdb$character_set_id=cs.rdb$character_set_id
        WHERE f.rdb$system_flag=0 AND r.rdb$relation_name=?
        ORDER BY r.rdb$field_position
         N/A pk_constraint N/A N/A self get_pk_constraint connection table_name N/A pkey_cols N/A pk_constraint N/A constrained_columns N/A tablename N/A N/A self denormalize_name table_name N/A c N/A N/A connection execute tblqry N/A tablename N/A cols N/A N/A True N/A N/A row N/A N/A c fetchone N/A N/A row None N/A N/A N/A name N/A N/A self normalize_name N/A row N/A fname N/A orig_colname N/A row N/A fname N/A colspec N/A N/A N/A row N/A ftype rstrip N/A coltype N/A N/A N/A self ischema_names get colspec N/A N/A coltype None N/A N/A N/A N/A util warn N/A Did not recognize type '%s' of column '%s' N/A colspec name N/A coltype N/A sqltypes NULLTYPE N/A N/A N/A N/A issubclass coltype Integer N/A N/A row N/A fprec 0 N/A N/A coltype N/A NUMERIC precision N/A row N/A fprec scale N/A N/A row N/A fscale -1 N/A N/A N/A colspec N/A VARYING CSTRING N/A N/A coltype N/A coltype N/A row N/A flen N/A N/A N/A colspec TEXT N/A N/A coltype N/A TEXT N/A row N/A flen N/A N/A N/A colspec BLOB N/A N/A N/A N/A row N/A stype 1 N/A N/A coltype N/A TEXT N/A N/A coltype N/A BLOB N/A N/A coltype N/A coltype N/A defvalue None N/A N/A N/A row N/A fdefault None N/A N/A defexpr N/A N/A N/A row N/A fdefault lstrip N/A N/A N/A N/A N/A N/A N/A defexpr N/A 8 rstrip upper DEFAULT N/A Unrecognized default value: %s defexpr N/A defvalue N/A N/A N/A defexpr N/A 8 strip N/A N/A defvalue NULL N/A N/A defvalue None N/A col_d N/A name type nullable default autoincrement name coltype N/A N/A bool N/A row N/A null_flag defvalue auto N/A N/A N/A N/A orig_colname lower orig_colname N/A N/A N/A col_d N/A quote True N/A N/A N/A N/A len pkey_cols 1 N/A name N/A pkey_cols N/A 0 N/A N/A seq_d N/A N/A self get_column_sequence connection tablename name N/A N/A seq_d None N/A N/A N/A col_d N/A sequence seq_d N/A N/A N/A cols append col_d N/A cols N/A N/A reflection cache get_foreign_keys N/A N/A self connection table_name schema N/A None kw N/A N/A fkqry 
        SELECT rc.rdb$constraint_name AS cname,
               cse.rdb$field_name AS fname,
               ix2.rdb$relation_name AS targetrname,
               se.rdb$field_name AS targetfname
        FROM rdb$relation_constraints rc
             JOIN rdb$indices ix1 ON ix1.rdb$index_name=rc.rdb$index_name
             JOIN rdb$indices ix2 ON ix2.rdb$index_name=ix1.rdb$foreign_key
             JOIN rdb$index_segments cse ON
                        cse.rdb$index_name=ix1.rdb$index_name
             JOIN rdb$index_segments se
                  ON se.rdb$index_name=ix2.rdb$index_name
                     AND se.rdb$field_position=cse.rdb$field_position
        WHERE rc.rdb$constraint_type=? AND rc.rdb$relation_name=?
        ORDER BY se.rdb$index_name, se.rdb$field_position
         N/A tablename N/A N/A self denormalize_name table_name N/A c N/A N/A connection execute fkqry N/A FOREIGN KEY tablename N/A fks N/A N/A util defaultdict N/A N/A N/A N/A N/A name constrained_columns referred_schema referred_table referred_columns None N/A None None N/A N/A row c N/A N/A cname N/A N/A self normalize_name N/A row N/A cname N/A fk N/A fks N/A cname N/A N/A N/A fk N/A name N/A N/A N/A fk N/A name cname N/A N/A fk N/A referred_table N/A N/A self normalize_name N/A row N/A targetrname N/A N/A N/A N/A fk N/A constrained_columns append N/A N/A self normalize_name N/A row N/A fname N/A N/A N/A N/A fk N/A referred_columns append N/A N/A self normalize_name N/A row N/A targetfname N/A N/A list N/A N/A fks values N/A N/A reflection cache get_indexes N/A N/A self connection table_name schema N/A None kw N/A N/A qry 
        SELECT ix.rdb$index_name AS index_name,
               ix.rdb$unique_flag AS unique_flag,
               ic.rdb$field_name AS field_name
        FROM rdb$indices ix
             JOIN rdb$index_segments ic
                  ON ix.rdb$index_name=ic.rdb$index_name
             LEFT OUTER JOIN rdb$relation_constraints
                  ON rdb$relation_constraints.rdb$index_name =
                        ic.rdb$index_name
        WHERE ix.rdb$relation_name=? AND ix.rdb$foreign_key IS NULL
          AND rdb$relation_constraints.rdb$constraint_type IS NULL
        ORDER BY index_name, ic.rdb$field_position
         N/A c N/A N/A connection execute qry N/A N/A N/A self denormalize_name table_name N/A indexes N/A N/A util defaultdict dict N/A row c N/A N/A indexrec N/A indexes N/A N/A row N/A index_name N/A N/A name indexrec N/A N/A N/A indexrec N/A name N/A N/A self normalize_name N/A row N/A index_name N/A N/A indexrec N/A column_names N/A N/A N/A indexrec N/A unique N/A bool N/A row N/A unique_flag N/A N/A N/A N/A indexrec N/A column_names append N/A N/A self normalize_name N/A row N/A field_name N/A N/A list N/A N/A indexes values N/A N/A reflection cache N/A