/
opt
/
alt
/
python27
/
lib64
/
python2.7
/
site-packages
/
sqlalchemy
/
dialects
/
firebird
/
up file
home
� 1��fc � @ s{ d Z d d l Z d d l m Z d d l m Z d d l m Z d d l m Z d d l m Z d d l m Z d d l m Z d d l m Z d d l m Z d d l m Z d d l m Z d d l m Z d d l m Z d d l m Z d d l m Z d d l m Z d d l m Z d d l m Z d d l m 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/ 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� 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 j f d� � � YZ d� e e j f d� � � YZ d� e e j f d � � YZ de j f d� � YZ! i e! e j 6Z" i e d6e d6e d6e d6e d6e d6e d 6e d 6e d 6e d 6e d 6e d6e d6Z# de j$ f d� � YZ% de j j& f d� � YZ' de j j( f d� � YZ) de j j* f d� � YZ+ de j, f d� � YZ- de j. f d� � YZ/ d S( s� .. dialect:: firebird :name: Firebird .. note:: The Firebird dialect within SQLAlchemy **is not currently supported**. It is not tested within continuous integration and is likely to have many issues and caveats not currently handled. Consider using the `external dialect <https://github.com/pauldex/sqlalchemy-firebird>`_ instead. .. deprecated:: 1.4 The internal Firebird dialect is deprecated and will be removed in a future version. Use the external dialect. 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(text("select * from table")) row = result.fetchone() return Where above, the ``CursorResult`` 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 ``CursorResult`` 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: https://mc-computing.com/Databases/Firebird/SQL_Dialect.html i����N( t exc( t sql( t types( t util( t default( t reflection( t compiler( t expression( t BIGINT( t BLOB( t DATE( t FLOAT( t INTEGER( t Integer( t NUMERIC( t SMALLINT( t TEXT( t TIME( t TIMESTAMPt activet addt admint aftert allt altert andt anyt ast asct ascendingt att autot avgt beforet begint betweent bigintt bit_lengtht blobt botht byt caset castt chart charactert character_lengtht char_lengtht checkt closet collatet columnt committ committedt computedt conditionalt connectt constraintt containingt countt createt crosst cstringt currentt current_connectiont current_datet current_rolet current_timet current_timestampt current_transactiont current_usert cursort databaset datet dayt dect decimalt declareR t deletet desct descendingt disconnectt distinctt dot domaint doublet dropt elset endt entry_pointt escapet exceptiont executet existst exitt externalt extractt fetcht filet filtert floatt fort foreignt fromt fullt functiont gdscodet generatort gen_idt globalt grantt groupt havingt hourt ift int inactivet indext innert input_typet insensitivet insertt intt integert intot ist isolationt joint keyt leadingt leftt lengtht levelt liket longt lowert manualt maxt maximum_segmentt merget mint minutet module_namet montht namest nationalt naturalt nchart not nott nullt numerict octet_lengtht oft ont onlyt opent optiont ort ordert outert output_typet overflowt paget pagest page_sizet parametert passwordt plant positiont post_eventt precisiont primaryt privilegest proceduret protecteds rdb$db_keyt readt realt record_versiont recreatet recursivet referencest releaset reservt reservingt retaint returning_valuest returnst revoket rightt rollbackt rowst row_countt savepointt schemat secondt segmentt selectt sensitivet sett shadowt sharedt singulart sizet smallintt snapshott somet sortt sqlcodet stabilityt startt startingt startst statisticst sub_typet sumt suspendt tablet thent timet timestampt tot trailingt transactiont triggert trimt uncommittedt uniont uniquet updatet uppert usert usingt valuet valuest varchart variablet varyingt viewt waitt whent wheret whilet witht workt writet yeart _StringTypec B s e Z d Z d d � Z RS( s Base for Firebird string types.c K s# | | _ t t | � j | � d S( N( t charsett superR� t __init__( t selfR� t kw( ( sT /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/firebird/base.pyR� X s N( t __name__t __module__t __doc__t NoneR� ( ( ( sT /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/firebird/base.pyR� U s t VARCHARc B s e Z d Z d Z d d � Z RS( s Firebird VARCHAR typeR c K s t t | � j d | | � d S( NR� ( R� R R� ( R� R� t kwargs( ( sT /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/firebird/base.pyR� b s N( R� R� R� t __visit_name__R� R� ( ( ( sT /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/firebird/base.pyR ] s t CHARc B s e Z d Z d Z d d � Z RS( s Firebird CHAR typeR c K s t t | � j d | | � d S( NR� ( R� R R� ( R� R� R ( ( sT /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/firebird/base.pyR� k s N( R� R� R� R R� R� ( ( ( sT /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/firebird/base.pyR f s t _FBDateTimec B s e Z d � Z RS( c C s d � } | S( Nc S s9 t | � t j k r1 t j | j | j | j � S| Sd S( N( t typet datetimeRH R� R� RI ( R� ( ( sT /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/firebird/base.pyt processq s ( ( R� t dialectR ( ( sT /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/firebird/base.pyt bind_processorp s ( R� R� R ( ( ( sT /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/firebird/base.pyR o s t SHORTt LONGt QUADR R R R t INT64t DOUBLER t VARYINGt CSTRINGR t FBTypeCompilerc B sG e Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z RS( c K s | j | | � S( N( t visit_SMALLINT( R� t type_R� ( ( sT /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/firebird/base.pyt visit_boolean� s c K s | j | | � S( N( t visit_TIMESTAMP( R� R R� ( ( sT /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/firebird/base.pyt visit_datetime� s c K s d S( Ns BLOB SUB_TYPE 1( ( R� R R� ( ( sT /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/firebird/base.pyt visit_TEXT� s c K s d S( Ns BLOB SUB_TYPE 0( ( R� R R� ( ( sT /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/firebird/base.pyt visit_BLOB� s c C s4 t | d d � } | d k r" | Sd | | f Sd S( NR� s %s CHARACTER SET %s( t getattrR� ( R� R t basicR� ( ( sT /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/firebird/base.pyt _extend_string� s c K s+ t t | � j | | � } | j | | � S( N( R� R t visit_CHARR ( R� R R� R ( ( sT /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/firebird/base.pyR � s c K sP | j s% t j d | j j � � n t t | � j | | � } | j | | � S( Ns' VARCHAR requires a length on dialect %s( R� R t CompileErrorR t nameR� R t visit_VARCHARR ( R� R R� R ( ( sT /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/firebird/base.pyR � s ( R� R� R R R R R R R ( ( ( sT /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/firebird/base.pyR � s t FBCompilerc B s� e Z d Z e Z d � Z d � Z d � Z d � Z e d � Z d � Z d � Z e Z d � Z d � Z d � Z d � Z d � Z d � Z RS( s Firebird specific idiosyncrasiesc K s d S( Nt CURRENT_TIMESTAMP( ( R� t fnR� ( ( sT /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/firebird/base.pyt visit_now_func� s c K s, d | j j | | � | j j | | � f S( Ns %s STARTING WITH %s( R� t _compiler_dispatchR� ( R� t binaryt operatorR� ( ( sT /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/firebird/base.pyt visit_startswith_op_binary� s c K s, d | j j | | � | j j | | � f S( Ns %s NOT STARTING WITH %s( R� R$ R� ( R� R% R& R� ( ( sT /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/firebird/base.pyt visit_not_startswith_op_binary� s c K s, d | j | j | � | j | j | � f S( Ns mod(%s, %s)( R R� R� ( R� R% R& R� ( ( sT /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/firebird/base.pyt visit_mod_binary� s c K s� | j j r+ t t | � j | d | | �S| r� t | j t j � r[ | j d | j � pa | j } | j | j d | | �d | j j | | � S| j | j | � Sd S( Nt asfromt aliast ( R t _version_twoR� R t visit_aliast isinstanceR R t _truncated_labelt _truncated_identifierR t elementt preparert format_alias( R� R+ R* R t alias_name( ( sT /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/firebird/base.pyR. � s 0c K s� | j | j j d � } | j | j j d � } t | j j � d k rt | j | j j d � } d | | | f Sd | | f Sd S( Ni i i s SUBSTRING(%s FROM %s FOR %s)s SUBSTRING(%s FROM %s)( R t clausest len( R� t funcR� t sR� R� ( ( sT /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/firebird/base.pyt visit_substring_func� s c K s2 | j j r d | j | � Sd | j | � Sd S( NR. t strlen( R R- t function_argspec( R� Rh R� ( ( sT /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/firebird/base.pyt visit_length_func� s c K s9 | j d k r1 t | j � r1 | j | j | � Sd Sd S( Nt ( R6 R� R7 R t clause_expr( R� R8 R� ( ( sT /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/firebird/base.pyR< � s c C s d S( Ns FROM rdb$database( ( R� ( ( sT /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/firebird/base.pyt default_from s c K s d | j j | � S( Ns gen_id(%s, 1)( R3 t format_sequence( R� t seqR� ( ( sT /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/firebird/base.pyt visit_sequence s c K s� d } | j d k r5 | d | j | j | � 7} n | j d k rd | d | j | j | � 7} n | t t | � j | | � 7} | 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 %s s SKIP %s N( t _limit_clauseR� R t _offset_clauseR� R t get_select_precolumns( R� R� R� t result( ( sT /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/firebird/base.pyRF s c K s d S( s< Already taken care of in the `get_select_precolumns` method.R> ( ( R� R� R� ( ( sT /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/firebird/base.pyt limit_clause s c C s? g t j | � D] } | j | | � ^ q } d d j | � S( Ns RETURNING s , ( R t _select_iterablest _label_returning_columnR~ ( R� t stmtt returning_colst ct columns( ( sT /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/firebird/base.pyt returning_clause s +( R� R� R� t Truet ansi_bind_rulesR# R' R( R) t FalseR. R: R= t visit_char_length_funcR< R@ RC RF RH RO ( ( ( sT /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/firebird/base.pyR � s t FBDDLCompilerc B s) e Z d Z d � Z d � Z d � Z RS( s! Firebird syntactic idiosyncrasiesc C s� | j j d k r! t d � � n | j j d k rB t d � � n | j j re d | j j | j � Sd | j j | j � Sd S( s; Generate a ``CREATE GENERATOR`` statement for the sequence.s, Firebird SEQUENCE doesn't support START WITHs. Firebird SEQUENCE doesn't support INCREMENT BYs CREATE SEQUENCE %ss CREATE GENERATOR %sN( R2 R� R� t NotImplementedErrort incrementR R- R3 RA ( R� R; ( ( sT /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/firebird/base.pyt visit_create_sequence( s c C s> | j j r# d | j j | j � Sd | j j | j � Sd S( s9 Generate a ``DROP GENERATOR`` statement for the sequence.s DROP SEQUENCE %ss DROP GENERATOR %sN( R R- R3 RA R2 ( R� RU ( ( sT /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/firebird/base.pyt visit_drop_sequence? s c C sD | j d k r! t j d � � n d | j j | j d t d t �S( Ns} Firebird computed columns do not support a persistence method setting; set the 'persisted' flag to None for Firebird support.s GENERATED ALWAYS AS (%s)t include_tablet literal_binds( t persistedR� R R t sql_compilerR t sqltextRR RP ( R� t generated( ( sT /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/firebird/base.pyt visit_computed_columnK s ( R� R� R� RW RX R_ ( ( ( sT /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/firebird/base.pyRT % s t FBIdentifierPreparerc B s2 e Z d Z e Z e j j d g � Z d � Z RS( s) Install Firebird specific reserved words.t _c C s t t | � j | d t �d S( Nt omit_schema( R� R` R� RP ( R� R ( ( sT /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/firebird/base.pyR� _ s ( R� R� R� t RESERVED_WORDSt reserved_wordsR t ILLEGAL_INITIAL_CHARACTERSR� t illegal_initial_charactersR� ( ( ( sT /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/firebird/base.pyR` W s t FBExecutionContextc B s e Z d � Z RS( c C s | j d | j j | � | � S( s8 Get the next value from the sequence using ``gen_id()``.s& SELECT gen_id(%s, 1) FROM rdb$database( t _execute_scalart identifier_preparerRA ( R� RB R ( ( sT /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/firebird/base.pyt fire_sequenced s ( R� R� Rj ( ( ( sT /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/firebird/base.pyRg c s t FBDialectc B sR e Z d Z d Z e Z d Z e Z e Z e Z e Z e Z e Z e Z e Z e Z e Z e Z e Z e Z e Z g Z e Z d � Z d � Z d d � Z d d � Z! e" j# d d � � Z$ e" j# d d � � Z% e" j# d d � � Z& e" j# d d � � Z' e" j# d d � � Z( e" j# d d � � Z) e" j# d d � � Z* e" j# d d � � Z+ RS( s Firebird dialectt firebirdi c O s0 t j d d d �t t | � j | | � d S( Ns� The firebird dialect is deprecated and will be removed in a future version. This dialect is superseded by the external dialect https://github.com/pauldex/sqlalchemy-firebird.t versions 1.4( R t warn_deprecatedR� Rk R� ( R� t argsR ( ( sT /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/firebird/base.pyR� � s c C s� t t | � j | � d | j k r4 | j d k pO d | j k oO | j d k | _ | j s� t j � | _ t j | j d <i t j t j 6| _ n | j o� | j j d t � | _ d S( NRl i t interbasei R t implicit_returning( i ( i ( R� Rk t initializet server_version_infoR- t ischema_namest copyt sqltypesR t DateTimet colspecst __dict__t getRP Rq ( R� t connection( ( sT /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/firebird/base.pyRr � s c C sA | j | � d } | j | | j | � g � } | j � d k S( sI Return ``True`` if the given table exists, ignoring the `schema`.s� SELECT 1 AS has_table FROM rdb$database WHERE EXISTS (SELECT rdb$relation_name FROM rdb$relations WHERE rdb$relation_name=?) N( t _ensure_has_table_connectiont exec_driver_sqlt denormalize_namet firstR� ( R� R{ t table_nameR� t tblqryRM ( ( sT /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/firebird/base.pyt has_table� s c C s4 d } | j | | j | � g � } | j � d k S( s9 Return ``True`` if the given sequence (generator) exists.s� SELECT 1 AS has_sequence FROM rdb$database WHERE EXISTS (SELECT rdb$generator_name FROM rdb$generators WHERE rdb$generator_name=?) N( R} R~ R R� ( R� R{ t sequence_nameR� t genqryRM ( ( sT /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/firebird/base.pyt has_sequence� s c K s3 d } g | j | � D] } | j | d � ^ q S( Ns� select rdb$relation_name from rdb$relations where rdb$view_blr is null and (rdb$system_flag is null or rdb$system_flag = 0); i ( R} t normalize_name( R� R{ R� R� R9 t row( ( sT /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/firebird/base.pyt get_table_names� s c K s3 d } g | j | � D] } | j | d � ^ q S( Ns� 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); i ( R} R� ( R� R{ R� R� R9 R� ( ( sT /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/firebird/base.pyt get_view_names� s c K sF d } | j | | j | � g � } | j � } | r> | d Sd Sd S( Nst SELECT rdb$view_source AS view_source FROM rdb$relations WHERE rdb$relation_name=? t view_source( R} R~ R R� ( R� R{ t view_nameR� R� t qryt rpR� ( ( sT /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/firebird/base.pyt get_view_definition� s c K sk d } | j | � } | j | d | g � } g | j � D] } | j | d � ^ q: } i | d 6d d 6S( Ns� 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=? s PRIMARY KEYt fnamet constrained_columnsR ( R~ R} t fetchallR� R� ( R� R{ R� R� R� t keyqryt tablenameRM t rt pkfields( ( sT /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/firebird/base.pyt get_pk_constraint s ,c K sl | j | � } | j | � } d } | j | | | g � j � } | d k rh t d | j | d � � Sd S( Ns� 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 R t fgenerator( R~ R} R R� t dictR� ( R� R{ R� t column_nameR� R� R� t colnameR� t genr( ( sT /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/firebird/base.pyt get_column_sequence s c K s� d } | j | | � } | d } | j | � } | j | | g � } g } xt r�| j � } | d k rq Pn | j | d � } | d } | d j � } | j j | � } | d k r� t j d | | f � t j } n� t | t � r"| d d k r"t d | d d | d d � } n{ | d! k rA| | d � } n\ | d k r`t | d � } n= | d k r�| d d k r�t � } q�t � } n | � } d } | d d k r| d j � } | d j � j � d k s�t d | � � | d j � } | d k rd } qn i | d 6| d 6t | d � d 6| d 6d d 6} | j � | k rjt | d <n t | � d k r�| | d k r�| j | | | � } | d k r�| | d <q�n | j | � qO W| S(" Ns� 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 R� R� t ftypes* Did not recognize type '%s' of column '%s't fpreci R� t scalet fscalei����R R t flenR R t stypei t fdefaulti t DEFAULTs Unrecognized default value: %st NULLR R t null_flagt nullableR R t autoincrementt quotet sequence( R R ( R� R~ R} RP t fetchoneR� R� t rstripRt Rz R t warnRv t NULLTYPEt issubclassR R R R t lstripR� t AssertionErrort stript boolR� R7 R� t append( R� R{ R� R� R� R� t pk_constraintt pkey_colsR� RM t colsR� R t orig_colnamet colspect coltypet defvaluet defexprt col_dt seq_d( ( sT /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/firebird/base.pyt get_columns- sj " c K s� d } | j | � } | j | d | g � } t j d � � } x� | D]� } | j | d � } | | } | d s� | | d <| j | d � | d <n | d j | j | d � � | d j | j | d � � qF Wt | j � � S( Ns 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 s FOREIGN KEYc S s' i d d 6g d 6d d 6d d 6g d 6S( NR R� t referred_schemat referred_tablet referred_columns( R� ( ( ( sT /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/firebird/base.pyt <lambda>� s t cnameR t targetrnameR� R� R� R� t targetfname( R~ R} R t defaultdictR� R� t listR� ( R� R{ R� R� R� t fkqryR� RM t fksR� R� t fk( ( sT /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/firebird/base.pyt get_foreign_keys� s c K s� d } | j | | j | � g � } t j t � } x~ | D]v } | | d } d | k r� | j | d � | d <g | d <t | d � | d <n | d j | j | d � � q: Wt | j � � S( Nsp 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 t index_nameR t column_namest unique_flagR� t field_name( R} R~ R R� R� R� R� R� R� R� ( R� R{ R� R� R� R� RM t indexesR� t indexrec( ( sT /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/firebird/base.pyt get_indexes� s N(, R� R� R� R RP t supports_statement_cachet max_identifier_lengtht supports_sequencesRR t sequences_optionalt supports_default_valuest postfetch_lastrowidt supports_native_booleant requires_name_normalizet supports_empty_insertR t statement_compilerRT t ddl_compilerR` R3 R t type_compilerRg t execution_ctx_clsRx Rt t construct_argumentsR- R� Rr R� R� R� R t cacheR� R� R� R� R� R� R� R� ( ( ( sT /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/firebird/base.pyRk n sP c+(0 R� R t sqlalchemyR R R Rv R t sqlalchemy.engineR R t sqlalchemy.sqlR R t sqlalchemy.typesR R R R R R R R R R R R� Rc t StringR� R R Rw R Rx Rt t GenericTypeCompilerR t SQLCompilerR t DDLCompilerRT t IdentifierPreparerR` t DefaultExecutionContextRg t DefaultDialectRk ( ( ( sT /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/firebird/base.pyt <module>Q s& ! s 2