U ÂÏ a }ãæ@sÞdZddlZddlmZddlmZddlmZddlmZddlm Z ddlm Z dd l m Z dd l m Z dd lmZdd lmZdd lmZddlmZddlmZddlmZddlmZddlmZddlmZddlmZddlmZeddddddddddd d!d"d#d$d%d&d'd(d)d*d+d,d-d.d/d0d1d2d3d4d5d6d7d8d9d:d;dd?d@dAdBdCdDdEdFdGdHdIdJdKdLdMdNdOdPdQdRdSdTdUdVdWdXdYdZd[d\d]d^d_d`dadbdcdddedfdgdhdidjdkdldmdndodpdqdrdsdtdudvdwdxdydzd{d|d}d~dd€dd‚dƒd„d…d†d‡dˆd‰dŠd‹dŒddŽddd‘d’d“d”d•d–d—d˜d™dšd›dœddždŸd d¡d¢d£d¤d¥d¦d§d¨d©dªd«d¬d­d®d¯d°d±d²d³d´dµd¶d·d¸d¹dºd»d¼d½d¾d¿dÀdÁdÂdÃdÄdÅdÆdÇdÈdÉdÊdËdÌdÍdÎdÏdÐdÑdÒdÓdÔdÕdÖd×dØdÙdÚdÛdÜdÝdÞdßdàdádâ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åƒZGdûdü„düejƒZGdýdþ„dþeejƒZGdÿd„deejƒZGdd„dej ƒZ!ej e!iZ"eeeeeeeeeeeeedœ Z#Gdd„de j$ƒZ%Gdd„dej j&ƒZ'Gdd „d ej j(ƒZ)Gd d „d ej j*ƒZ+Gd d „d e j,ƒZ-Gdd„de j.ƒZ/dS(aá .. 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 `_ 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 éN)Úexc)Úsql)Útypes)Úutil)Údefault)Ú reflection)Úcompiler)Ú expression)ÚBIGINT)ÚBLOB)ÚDATE)ÚFLOAT)ÚINTEGER)ÚInteger)ÚNUMERIC)ÚSMALLINT)ÚTEXT)ÚTIME)Ú TIMESTAMPÚactiveÚaddZadminÚafterÚallZalterÚandÚanyÚasZascZ ascendingÚatÚautoÚavgZbeforeÚbeginZbetweenZbigintÚ bit_lengthZblobZbothZbyZcaseÚcastÚcharÚ characterZcharacter_lengthÚ char_lengthÚcheckÚcloseZcollateÚcolumnÚcommitZ committedZcomputedZ conditionalÚconnectÚ constraintZ containingÚcountÚcreateZcrossZcstringÚcurrentZcurrent_connectionZ current_dateZ current_roleÚ current_timeZcurrent_timestampZcurrent_transactionZ current_userÚcursorZdatabaseÚdateÚdayÚdecÚdecimalZdeclarerÚdeleteÚdescZ descendingZ disconnectZdistinctZdoÚdomainÚdoubleÚdropÚelseÚendZ entry_pointÚescapeÚ exceptionÚexecuteÚexistsÚexitZexternalÚextractÚfetchÚfileÚfilterÚfloatÚforZforeignÚfromÚfullÚfunctionZgdscodeÚ generatorZgen_idÚglobalZgrantÚgroupZhavingÚhourÚifÚinZinactiveÚindexÚinnerZ input_typeZ insensitiveÚinsertÚintÚintegerZintoÚisZ isolationÚjoinÚkeyÚleadingÚleftÚlengthÚlevelZlikeÚlongÚlowerZmanualÚmaxZmaximum_segmentÚmergeÚminÚminuteÚ module_nameÚmonthÚnamesZnationalZnaturalZncharÚnoÚnotÚnullÚnumericZ octet_lengthZofÚonÚonlyÚopenÚoptionÚorÚorderÚouterÚ output_typeZoverflowÚpageZpagesZ page_sizeZ parameterÚpasswordZplanÚpositionZ post_eventÚ precisionZprimaryZ privilegesZ procedureZ protectedz rdb$db_keyÚreadÚrealZrecord_versionZrecreateÚ recursiveZ referencesÚreleaseZreservZ reservingZretainZreturning_valuesZreturnsZrevokeÚrightÚrollbackÚrowsZ row_countZ savepointÚschemaÚsecondÚsegmentÚselectZ sensitiveÚsetZshadowZsharedZsingularÚsizeZsmallintZsnapshotZsomeÚsortZsqlcodeZ stabilityÚstartZstartingZstartsZ statisticsZsub_typeÚsumZsuspendÚtableZthenÚtimeÚ timestampÚtoZtrailingZ transactionZtriggerZtrimZ uncommittedÚunionÚuniqueÚupdateÚupperÚuserZusingÚvalueÚvaluesZvarcharÚvariableZvaryingÚviewÚwaitÚwhenÚwhereÚwhileÚwithZworkÚwriteÚyearcs"eZdZdZd‡fdd„ Z‡ZS)Ú _StringTypezBase for Firebird string types.Nc s||_tt|ƒjf|ŽdS©N)ÚcharsetÚsuperr˜Ú__init__)ÚselfršÚkw©Ú __class__©úbC:\Users\vtejo\AppData\Local\Temp\pip-unpacked-wheel-nyjtotrf\sqlalchemy\dialects\firebird\base.pyrœXsz_StringType.__init__)N)Ú__name__Ú __module__Ú __qualname__Ú__doc__rœÚ __classcell__r¡r¡rŸr¢r˜Usr˜cs&eZdZdZdZd‡fdd„ Z‡ZS)ÚVARCHARzFirebird VARCHAR typeNc stt|ƒjfd|i|—ŽdS©NrY)r›r¨rœ©rrYÚkwargsrŸr¡r¢rœbszVARCHAR.__init__)N©r£r¤r¥r¦Z__visit_name__rœr§r¡r¡rŸr¢r¨]sr¨cs&eZdZdZdZd‡fdd„ Z‡ZS)ÚCHARzFirebird CHAR typeNc stt|ƒjfd|i|—ŽdSr©)r›r­rœrªrŸr¡r¢rœksz CHAR.__init__)Nr¬r¡r¡rŸr¢r­fsr­c@seZdZdd„ZdS)Ú _FBDateTimecCs dd„}|S)NcSs*t|ƒtjkr"t |j|j|j¡S|SdSr™)ÚtypeÚdatetimer0r—rbr1)rr¡r¡r¢Úprocessqsz+_FBDateTime.bind_processor..processr¡)rÚdialectr±r¡r¡r¢Úbind_processorpsz_FBDateTime.bind_processorN)r£r¤r¥r³r¡r¡r¡r¢r®osr®) ÚSHORTÚLONGZQUADr r rrZINT64ÚDOUBLErÚVARYINGÚCSTRINGr csPeZdZdd„Zdd„Zdd„Zdd„Zd d „Z‡fd d „Z‡fd d„Z ‡Z S)ÚFBTypeCompilercKs|j|f|ŽSr™)Zvisit_SMALLINT©rÚtype_ržr¡r¡r¢Ú visit_boolean’szFBTypeCompiler.visit_booleancKs|j|f|ŽSr™)Zvisit_TIMESTAMPrºr¡r¡r¢Úvisit_datetime•szFBTypeCompiler.visit_datetimecKsdS)NzBLOB SUB_TYPE 1r¡rºr¡r¡r¢Ú visit_TEXT˜szFBTypeCompiler.visit_TEXTcKsdS)NzBLOB SUB_TYPE 0r¡rºr¡r¡r¢Ú visit_BLOB›szFBTypeCompiler.visit_BLOBcCs(t|ddƒ}|dkr|Sd||fSdS)Nršz%s CHARACTER SET %s)Úgetattr)rr»Úbasicršr¡r¡r¢Ú_extend_stringžs zFBTypeCompiler._extend_stringc s tt|ƒj|f|Ž}| ||¡Sr™)r›r¹Ú visit_CHARr©rr»ržrÁrŸr¡r¢rÃ¥szFBTypeCompiler.visit_CHARc s8|jst d|jj¡‚tt|ƒj|f|Ž}| ||¡S)Nz'VARCHAR requires a length on dialect %s) rYrÚ CompileErrorr²Únamer›r¹Ú visit_VARCHARrÂrÄrŸr¡r¢rÇ©s  ÿzFBTypeCompiler.visit_VARCHAR) r£r¤r¥r¼r½r¾r¿rÂrÃrÇr§r¡r¡rŸr¢r¹‘s r¹csŽeZdZdZdZdd„Zdd„Zdd„Zd d „Zd‡fd d „ Z dd„Z dd„Z e Z dd„Z dd„Zdd„Z‡fdd„Zdd„Zdd„Z‡ZS)Ú FBCompilerz Firebird specific idiosyncrasiesTcKsdS)NZCURRENT_TIMESTAMPr¡)rÚfnržr¡r¡r¢Úvisit_now_func½szFBCompiler.visit_now_funccKs$d|jj|f|Ž|jj|f|ŽfS)Nz%s STARTING WITH %s©rXZ_compiler_dispatchrx©rÚbinaryÚoperatorržr¡r¡r¢Úvisit_startswith_op_binaryÀsþz%FBCompiler.visit_startswith_op_binarycKs$d|jj|f|Ž|jj|f|ŽfS)Nz%s NOT STARTING WITH %srËrÌr¡r¡r¢Úvisit_not_startswith_op_binaryÆsþz)FBCompiler.visit_not_startswith_op_binarycKs$d|j|jf|Ž|j|jf|ŽfS)Nz mod(%s, %s))r±rXrxrÌr¡r¡r¢Úvisit_mod_binaryÌsþzFBCompiler.visit_mod_binaryFc sˆ|jjr$tt|ƒj|fd|i|—ŽS|rtt|jtjƒrD|  d|j¡pH|j}|j |j fd|i|—Žd|j   ||¡S|j |j f|ŽSdS)NÚasfromÚaliasú )r²Ú _version_twor›rÈÚ visit_aliasÚ isinstancerÆr Z_truncated_labelZ_truncated_identifierr±ÚelementÚpreparerZ format_alias)rrÓrÒr«Z alias_namerŸr¡r¢rÖÒs* ÿÿÿ ÿýÿ þÿzFBCompiler.visit_aliascKsd| |jjd¡}| |jjd¡}t|jjƒdkrT| |jjd¡}d|||fSd||fSdS)NréézSUBSTRING(%s FROM %s FOR %s)zSUBSTRING(%s FROM %s))r±ÚclausesÚlen)rÚfuncržÚsr‚rYr¡r¡r¢Úvisit_substring_funcès zFBCompiler.visit_substring_funccKs(|jjrd| |¡Sd| |¡SdS)Nr$Zstrlen)r²rÕÚfunction_argspec)rrHržr¡r¡r¢Úvisit_length_funcñszFBCompiler.visit_length_funccKs,|jdk r$t|jƒr$|j|jf|ŽSdSdS)NÚ)rÜrÝr±Z clause_expr)rrÞržr¡r¡r¢ráùszFBCompiler.function_argspeccCsdS)Nz FROM rdb$databaser¡©rr¡r¡r¢Ú default_fromszFBCompiler.default_fromcKsd|j |¡S)Nz gen_id(%s, 1))rÙÚformat_sequence)rÚseqržr¡r¡r¢Úvisit_sequenceszFBCompiler.visit_sequencec sdd}|jdk r&|d|j|jf|Ž7}|jdk rH|d|j|jf|Ž7}|tt|ƒj|f|Ž7}|S)zªCalled when building a ``SELECT`` statement, position is just before column list Firebird puts the limit and offset right after the ``SELECT``... rãNz FIRST %s zSKIP %s )Z _limit_clauser±Z_offset_clauser›rÈÚget_select_precolumns)rr~ržÚresultrŸr¡r¢ré s  z FBCompiler.get_select_precolumnscKsdS)zsÿz/FBCompiler.returning_clause..z RETURNING z, )r Z_select_iterablesrU)rrïZreturning_colsÚcolumnsr¡rîr¢Úreturning_clauses þzFBCompiler.returning_clause)F)r£r¤r¥r¦Zansi_bind_rulesrÊrÏrÐrÑrÖràrâZvisit_char_length_funcrárårèrérëròr§r¡r¡rŸr¢rȲs    rÈc@s(eZdZdZdd„Zdd„Zdd„ZdS) Ú FBDDLCompilerz!Firebird syntactic idiosyncrasiescCsX|jjdk rtdƒ‚|jjdk r(tdƒ‚|jjrBd|j |j¡Sd|j |j¡SdS)z;Generate a ``CREATE GENERATOR`` statement for the sequence.Nz,Firebird SEQUENCE doesn't support START WITHz.Firebird SEQUENCE doesn't support INCREMENT BYzCREATE SEQUENCE %szCREATE GENERATOR %s)rØr‚ÚNotImplementedErrorÚ incrementr²rÕrÙræ)rr,r¡r¡r¢Úvisit_create_sequence(s ÿ ÿÿÿz#FBDDLCompiler.visit_create_sequencecCs0|jjrd|j |j¡Sd|j |j¡SdS)z9Generate a ``DROP GENERATOR`` statement for the sequence.zDROP SEQUENCE %szDROP GENERATOR %sN)r²rÕrÙrærØ)rr8r¡r¡r¢Úvisit_drop_sequence?sÿÿz!FBDDLCompiler.visit_drop_sequencecCs,|jdk rt d¡‚d|jj|jdddS)Nz}Firebird computed columns do not support a persistence method setting; set the 'persisted' flag to None for Firebird support.zGENERATED ALWAYS AS (%s)FT)Z include_tableZ literal_binds)Z persistedrrÅZ sql_compilerr±Zsqltext)rÚ generatedr¡r¡r¢Úvisit_computed_columnKs ÿÿz#FBDDLCompiler.visit_computed_columnN)r£r¤r¥r¦rör÷rùr¡r¡r¡r¢ró%s rócs2eZdZdZeZej dg¡Z ‡fdd„Z ‡Z S)ÚFBIdentifierPreparerz)Install Firebird specific reserved words.Ú_cstt|ƒj|dddS)NT)Z omit_schema)r›rúrœ)rr²rŸr¡r¢rœ_szFBIdentifierPreparer.__init__) r£r¤r¥r¦ÚRESERVED_WORDSZreserved_wordsrZILLEGAL_INITIAL_CHARACTERSrˆZillegal_initial_charactersrœr§r¡r¡rŸr¢rúWs ÿrúc@seZdZdd„ZdS)ÚFBExecutionContextcCs| d|j |¡|¡S)z8Get the next value from the sequence using ``gen_id()``.z&SELECT gen_id(%s, 1) FROM rdb$database)Z_execute_scalarZidentifier_preparerræ)rrçr»r¡r¡r¢Ú fire_sequenceds  ÿýz FBExecutionContext.fire_sequenceN)r£r¤r¥rþr¡r¡r¡r¢rýcsrýcs eZdZdZdZdZdZdZdZdZ dZ dZ dZ dZ eZeZeZeZeZeZeZgZdZ‡fdd„Z‡fdd „Zdd d „Zd d d„Ze j!d!dd„ƒZ"e j!d"dd„ƒZ#e j!d#dd„ƒZ$e j!d$dd„ƒZ%e j!d%dd„ƒZ&e j!d&dd„ƒZ'e j!d'dd„ƒZ(e j!d(dd„ƒZ)‡Z*S))Ú FBDialectzFirebird dialectÚfirebirdTéFcs$tjdddtt|ƒj||ŽdS)Nz®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.z1.4)Úversion)rZwarn_deprecatedr›rÿrœ)rÚargsr«rŸr¡r¢rœs üzFBDialect.__init__cs~tt|ƒ |¡d|jkr$|jdkp6d|jko6|jdk|_|jsdt ¡|_tj|jd<tj tji|_ |jov|j   dd¡|_ dS)Nr)rÛZ interbase)érÚimplicit_returningT)r›rÿÚ initializeZserver_version_inforÕÚ ischema_namesÚcopyÚsqltypesr ÚDateTimeÚcolspecsÚ__dict__Úgetr)rÚ connectionrŸr¡r¢r™s þ û   ÿzFBDialect.initializeNcCs.| |¡d}| || |¡g¡}| ¡dk S)zIReturn ``True`` if the given table exists, ignoring the `schema`.z SELECT 1 AS has_table FROM rdb$database WHERE EXISTS (SELECT rdb$relation_name FROM rdb$relations WHERE rdb$relation_name=?) N)Z_ensure_has_table_connectionÚexec_driver_sqlÚdenormalize_nameÚfirst)rrÚ table_namer{Útblqryrír¡r¡r¢Ú has_table­s  ÿzFBDialect.has_tablecCs$d}| || |¡g¡}| ¡dk S)z9Return ``True`` if the given sequence (generator) exists.zÈ SELECT 1 AS has_sequence FROM rdb$database WHERE EXISTS (SELECT rdb$generator_name FROM rdb$generators WHERE rdb$generator_name=?) N©rrr)rrZ sequence_namer{Úgenqryrír¡r¡r¢Ú has_sequence½s  ÿzFBDialect.has_sequencec sd}‡fdd„| |¡DƒS)Nz¦ select rdb$relation_name from rdb$relations where rdb$view_blr is null and (rdb$system_flag is null or rdb$system_flag = 0); csg|]}ˆ |d¡‘qS©r©Únormalize_name©rìÚrowrär¡r¢rðßsÿz-FBDialect.get_table_names..©r©rrr{ržrßr¡rär¢Úget_table_namesËs þzFBDialect.get_table_namesc sd}‡fdd„| |¡DƒS)Nzª 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); csg|]}ˆ |d¡‘qSrrrrär¡r¢rðísÿz,FBDialect.get_view_names..rrr¡rär¢Úget_view_namesäs þzFBDialect.get_view_namescKs4d}| || |¡g¡}| ¡}|r,|dSdSdS)Nzt SELECT rdb$view_source AS view_source FROM rdb$relations WHERE rdb$relation_name=? Z view_sourcer)rrZ view_namer{ržÚqryÚrprr¡r¡r¢Úget_view_definitionòs ÿzFBDialect.get_view_definitionc  s>d}ˆ |¡}| |d|g¡}‡fdd„| ¡Dƒ}|ddœS)Nzí 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=? z PRIMARY KEYcsg|]}ˆ |d¡‘qS)Úfnamer)rìÚrrär¡r¢rðsz/FBDialect.get_pk_constraint..)Úconstrained_columnsrÆ)rrZfetchall) rrrr{ržZkeyqryÚ tablenameríZpkfieldsr¡rär¢Úget_pk_constraints  zFBDialect.get_pk_constraintc KsL| |¡}| |¡}d}| |||g¡ ¡} | dk rHt| | d¡dSdS)Naó 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 Z fgenerator)rÆ)rrrÚdictr) rrrZ column_namer{ržr'ZcolnamerZgenrr¡r¡r¢Úget_column_sequences   zFBDialect.get_column_sequencecKsd}| ||¡}|d}| |¡}| ||g¡} g} |  ¡} | dkrHqü| | d¡} | d} | d ¡}|j |¡}|dkr˜t  d|| f¡t j }nŠt |t ƒrÈ| ddkrÈt| d| dd d }nZ|d krÞ|| d ƒ}nD|d krôt| d ƒ}n.|dkr| ddkrtƒ}ntƒ}n|ƒ}d}| ddk r„| d ¡}|dd… ¡ ¡dksftd|ƒ‚|dd… ¡}|dkr„d}| |t| dƒ |ddœ}|  ¡| kr´d|d<t|ƒdkrð| |dkrð| ||| ¡}|dk rð||d<|  |¡q4| S)Naó 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$Zftypez*Did not recognize type '%s' of column '%s'ZfprecrZfscaleéÿÿÿÿ)rsZscale)r·r¸Zflenrr ÚstyperÚZfdefaultéÚDEFAULTzUnrecognized default value: %sÚNULLZ null_flagr)rÆr¯ZnullablerZ autoincrementTÚquoteÚsequence)r(rrZfetchonerÚrstriprr rÚwarnr ZNULLTYPEÚ issubclassrrrr Úlstripr‹ÚAssertionErrorÚstripÚboolr\rÝr*Úappend)rrrr{ržrZ pk_constraintZ pkey_colsr'ríÚcolsrrÆZ orig_colnameZcolspecZcoltypeZdefvalueZdefexprZcol_dZseq_dr¡r¡r¢Ú get_columns-sr    ÿÿ ÿ  ÿ  û  zFBDialect.get_columnsc Ksªd}| |¡}| |d|g¡}t dd„¡}|D]l} | | d¡} || } | dsl| | d<| | d¡| d<| d  | | d ¡¡| d  | | d ¡¡q0t| ¡ƒS) Na 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 z FOREIGN KEYcSsdgddgdœS)N)rÆr&Zreferred_schemaÚreferred_tableÚreferred_columnsr¡r¡r¡r¡r¢Ú¨s ûz,FBDialect.get_foreign_keys..ÚcnamerÆZ targetrnamer<r&r$r=Z targetfname)rrrÚ defaultdictrr9ÚlistrŽ) rrrr{ržZfkqryr'ríZfksrr?Zfkr¡r¡r¢Úget_foreign_keys‘s" ÿ  ÿzFBDialect.get_foreign_keysc KsŽd}| || |¡g¡}t t¡}|D]Z}||d} d| krh| |d¡| d<g| d<t|dƒ| d<| d | |d¡¡q&t|  ¡ƒS)Nap 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 Z index_namerÆZ column_namesZ unique_flagr‰Ú field_name) rrrr@r)rr8r9rArŽ) rrrr{ržr!ríZindexesrZindexrecr¡r¡r¢Ú get_indexes½s  ÿ   ÿzFBDialect.get_indexes)N)N)N)N)N)N)N)N)N)N)+r£r¤r¥r¦rÆZsupports_statement_cacheZmax_identifier_lengthZsupports_sequencesZsequences_optionalZsupports_default_valuesZpostfetch_lastrowidZsupports_native_booleanZrequires_name_normalizeZsupports_empty_insertrÈZstatement_compilerróZ ddl_compilerrúrÙr¹Z type_compilerrýZexecution_ctx_clsr rZconstruct_argumentsrÕrœrrrrÚcacherr r#r(r*r;rBrDr§r¡r¡rŸr¢rÿnsR       ÿ  c +rÿ)0r¦r°Z sqlalchemyrrrr rZsqlalchemy.enginerrZsqlalchemy.sqlrr Zsqlalchemy.typesr r r r rrrrrrrrrüÚStringr˜r¨r­r r®r rZGenericTypeCompilerr¹Z SQLCompilerrÈZ DDLCompilerróZIdentifierPreparerrúZDefaultExecutionContextrýZDefaultDialectrÿr¡r¡r¡r¢Ús.K                   €›ÿl   ó!s2