+h:dZddlmZddlmZGddeZeZy)a .. dialect:: firebird+fdb :name: fdb :dbapi: pyodbc :connectstring: firebird+fdb://user:password@host:port/path/to/db[?key=value&key=value...] :url: https://pypi.org/project/fdb/ fdb is a kinterbasdb compatible DBAPI for Firebird. .. versionchanged:: 0.9 - The fdb dialect is now the default dialect under the ``firebird://`` URL space, as ``fdb`` is now the official Python driver for Firebird. Arguments ---------- The ``fdb`` dialect is based on the :mod:`sqlalchemy.dialects.firebird.kinterbasdb` dialect, however does not accept every argument that Kinterbasdb does. * ``enable_rowcount`` - True by default, setting this to False disables the usage of "cursor.rowcount" with the Kinterbasdb dialect, which SQLAlchemy ordinarily calls upon automatically after any UPDATE or DELETE statement. When disabled, SQLAlchemy's CursorResult will return -1 for result.rowcount. The rationale here is that Kinterbasdb requires a second round trip to the database when .rowcount is called - since SQLA's resultproxy automatically closes the cursor after a non-result-returning statement, rowcount must be called, if at all, before the result object is returned. Additionally, cursor.rowcount may not return correct results with older versions of Firebird, and setting this flag to False will also cause the SQLAlchemy ORM to ignore its usage. The behavior can also be controlled on a per-execution basis using the ``enable_rowcount`` option with :meth:`_engine.Connection.execution_options`:: conn = engine.connect().execution_options(enable_rowcount=True) r = conn.execute(stmt) print(r.rowcount) * ``retaining`` - False by default. Setting this to True will pass the ``retaining=True`` keyword argument to the ``.commit()`` and ``.rollback()`` methods of the DBAPI connection, which can improve performance in some situations, but apparently with significant caveats. Please read the fdb and/or kinterbasdb DBAPI documentation in order to understand the implications of this flag. .. versionchanged:: 0.9.0 - the ``retaining`` flag defaults to ``False``. In 0.8 it defaulted to ``True``. .. seealso:: https://pythonhosted.org/fdb/usage-guide.html#retaining-transactions - information on the "retaining" flag. )FBDialect_kinterbasdb)utilc@eZdZdZdfd ZedZdZdZxZ S) FBDialect_fdbTc 2tt| d||d|y)N)enable_rowcount retaining)superr__init__)selfr r kwargs __class__s S/var/www/html/venv/lib/python3.12/site-packages/sqlalchemy/dialects/firebird/fdb.pyr zFBDialect_fdb.__init__Gs$ mT+ +y DJ ctdS)Nfdb) __import__)clss rdbapizFBDialect_fdb.dbapiLs %  rc|jd}|jdr|dd|d|d<|d=|j|jt j |dt g|fS)Nuser)usernameporthost/ type_conv)translate_connect_argsgetupdatequeryrcoerce_kw_typeint)rurloptss rcreate_connect_argsz!FBDialect_fdb.create_connect_argsPsj))6): 88F &*6lDLADLV  CII D+s3Dzrcbd}|j}|j|}|j|S)zGet 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. g) connectiondb_info_parse_version_info)rr*isc_info_firebird_versionfbconnversions r_get_server_version_infoz&FBDialect_fdb._get_server_version_info[s5%(!&&..!:;''00r)TF) __name__ __module__ __qualname__supports_statement_cacher classmethodrr'r0 __classcell__)rs@rrrDs,# !! 1rrN)__doc__ kinterbasdbrrrdialectr rrr;s(6p/)1))1X r