i0\ddlmZddlmZddlmZGddeZeZdS)) base_impl)errors) BaseMetaClassc2eZdZdZddZedefdZejdefdZede fdZ e jde fd Z ede fd Z e jde fd Z ede fd Z e jde fd Z edefdZejdefdZedefdZejdefdZede fdZejde fdZede fdZejde fdZede fdZejde fdZede fdZejde fdZede fdZejde fdZede fdZejde fdZdS)Defaultsz A singleton Defaults object contains attributes to adjust default behaviors of python-oracledb. It is accessed using the :data:`defaults` attribute of the imported module. returnNc(tj|_dSN)rDEFAULTS_implselfs a/var/www/html/Pagina-Ingenieria-Requisitos/venv/lib/python3.11/site-packages/oracledb/defaults.py__init__zDefaults.__init__,s' c|jjS)a This read-write attribute specifies the default arraysize to use when cursors are created. It is an attribute for tuning the performance of fetching rows from Oracle Database. It does not affect data insertion. This value is the default for :attr:`Cursor.arraysize` and :attr:`AsyncCursor.arraysize`. This attribute has an initial value of *100*. r arraysizer s rrzDefaults.arraysize/sz##rvaluec||j_dSr rrrs rrzDefaults.arraysize?s$ rc|jjS)a  This read-write attribute specifies the directory in which the optional configuration file ``tnsnames.ora`` will be read in python-oracledb Thin mode. It is also used in Thick mode if :attr:`Defaults.thick_mode_dsn_passthrough` is *False*. At time of ``import oracledb`` the value of ``oracledb.defaults.config_dir`` will be set to (first one wins): - the value of ``$TNS_ADMIN``, if ``TNS_ADMIN`` is set. - ``$ORACLE_HOME/network/admin``, if ``$ORACLE_HOME`` is set. Otherwise, ``oracledb.defaults.config_dir`` will not be set. At completion of a call to :meth:`oracledb.init_oracle_client()` in python-oracledb Thick mode, the value of ``config_dir`` may get changed. r config_dirr s rrzDefaults.config_dirCs*z$$rc||j_dSr rrs rrzDefaults.config_dirZ % rc|jjS)a This read-write attribute specifies whether queries that contain LOBs should return LOB objects or their contents instead. When the value of this attribute is *True*, then queries to LOB columns return LOB locators. When the value of this attribute is *False*, then CLOBs and NCLOBs are fetched as strings, and BLOBs are fetched as bytes. If LOBs are larger than 1 GB, then this attribute should be set to *True* and the LOBs should be streamed. The value of ``oracledb.defaults.fetch_lobs`` does not affect LOBs returned as OUT binds. The value of ``fetch_lobs`` can be overridden at statement execution by passing an equivalent parameter. An output type handler such as the one previously required in the obsolete cx_Oracle driver can alternatively be used to adjust the returned type. If a type handler exists and returns a variable (that is, `cursor.var(...)`), then that return variable is used. If the type handler returns *None*, then the value of ``oracledb.defaults.fetch_lobs`` is used. This attribute has an initial value of *True*. r fetch_lobsr s rrzDefaults.fetch_lobs^s6z$$rc||j_dSr rrs rrzDefaults.fetch_lobs{rrc|jjS)a This read-write attribute specifies whether queries that contain numbers should be fetched as Python decimal.Decimal objects or floating point numbers. This can help avoid issues with converting numbers from Oracle Database's decimal format to Python's binary format. The value of ``fetch_decimals`` can be overridden at statement execution by passing an equivalent parameter. An output type handler such as previously required in the obsolete cx_Oracle driver can alternatively be used to adjust the returned type. If a type handler exists and returns a variable (that is, ``cursor.var(...)``), then that return variable is used. If the type handler returns *None*, then the value of ``oracledb.defaults.fetch_decimals`` is used to determine whether to return ``decimal.Decimal`` values. This attribute has an initial value of *False*. r fetch_decimalsr s rr#zDefaults.fetch_decimalss*z((rc||j_dSr r"rs rr#zDefaults.fetch_decimalss$) !!!rc|jjS)a This read-write attribute specifies the default number of rows to prefetch when cursors are executed. This is an attribute for tuning the performance of fetching rows from Oracle Database. It does not affect data insertion. This value is the default for :attr:`Cursor.prefetchrows` and :attr:`AsyncCursor.prefetchrows`. This attribute is ignored when using :meth:`Connection.fetch_df_all()` or :meth:`Connection.fetch_df_batches()` since these methods always set the internal prefetch size to their relevant ``arraysize`` or ``size`` parameter value. This attribute has an initial value of *2*. r prefetchrowsr s rr'zDefaults.prefetchrowss&z&&rc||j_dSr r&rs rr'zDefaults.prefetchrowss"' rc|jjS)a This read-write attribute specifies the default size of the statement cache. This is an attribute for tuning statement execution performance when a statement is executed more than once. This value is the default for :attr:`Connection.stmtcachesize`, :attr:`ConnectionPool.stmtcachesize`, :attr:`AsyncConnection.stmtcachesize`, and :attr:`AsyncConnectionPool.stmtcachesize`. This attribute has an initial value of *20*. r stmtcachesizer s rr+zDefaults.stmtcachesizes z''rc||j_dSr r*rs rr+zDefaults.stmtcachesizes#(    rc|jjS)a This read-write attribute is a string recorded by Oracle Database as the program from which the connection originates. This is the value used in the PROGRAM column of the V$SESSION view. This attribute has an initial value that is populated by `sys.executable `__. This attribute is only used in python-oracledb Thin mode. )r programr s rr.zDefaults.programsz!!rctj||kr tjtjd||j_dS)Nr.name)rsanitizer _raise_errERR_INVALID_NETWORK_NAMEr r.rs rr.zDefaults.programA  e $ $ - -  f=I N N N N" rc|jjS)a This read-write attribute is a string recorded by Oracle Database as the name of machine from which the connection originates. This is the value used in the MACHINE column of the V$SESSION view. This attribute takes the host name where the application is running as its initial value. This attribute is only used in python-oracledb Thin mode. )r machiner s rr7zDefaults.machinesz!!rctj||kr tjtjd||j_dS)Nr7r0)rr2rr3r4r r7rs rr7zDefaults.machiner5rc|jjS)aF This read-write attribute specifies the terminal identifier from which the connection originates. This is the value used in the TERMINAL column of the V$SESSION view. This attribute has an initial value of "unknown". This attribute is only used in python-oracledb Thin mode. r terminalr s rr;zDefaults.terminalsz""rc||j_dSr r:rs rr;zDefaults.terminals# rc|jjS)at This read-write attribute is a string recorded by Oracle Database as the operating system user who originated the connection. This is the value used in the OSUSER column of the V$SESSION view. This attribute takes the login name of the user as its initial value. This attribute is only used in python-oracledb Thin mode. )r osuserr s rr>zDefaults.osusersz  rctj||kr tjtjd||j_dS)Nr>r0)rr2rr3r4r r>rs rr>zDefaults.osusersA  e $ $ - -  f=H M M M M! rc|jjS)a  This read-write attribute is a string recorded by Oracle Database as the name of the driver which originated the connection. This is the value used in the CLIENT_DRIVER column of the V$SESSION_CONNECT_INFO view. This attribute has an initial value of *None*. It is used as required in python-oracledb Thick and Thin mode. In python-oracledb Thick mode, this attribute is used if the ``driver_name`` parameter is not specified in :meth:`oracledb.init_oracle_client()`. In Thin mode, this attribute is used if the ``driver_name`` parameter is not specified in :meth:`oracledb.connect()`, :meth:`oracledb.connect_async()`, :meth:`oracledb.create_pool()`, or :meth:`oracledb.create_pool_async()`. If the value of this attribute is *None*, the value set when connecting in python-oracledb Thick mode is like "python-oracledb thk : " and in Thin mode is like "python-oracledb thn : ". r driver_namer s rrBzDefaults.driver_names,z%%rc||j_dSr rArs rrBzDefaults.driver_name.s!& rc|jjS)a This read-write attribute determines whether connection strings passed as the ``dsn`` parameter to :meth:`oracledb.connect()`, :meth:`oracledb.create_pool()`, :meth:`oracledb.connect_async()`, and :meth:`oracledb.create_pool_async()` in python-oracledb Thick mode will be parsed by Oracle Client libraries or by python-oracledb itself. The value of ``thick_mode_dsn_passthrough`` is ignored in python-oracledb Thin mode, which always parses all connect strings (including reading a tnsnames.ora file, if required). This attribute has an initial value of *True*. r thick_mode_dsn_passthroughr s rrFz#Defaults.thick_mode_dsn_passthrough2s z44rc||j_dSr rErs rrFz#Defaults.thick_mode_dsn_passthroughDs05 ---r)rN)__name__ __module__ __qualname____doc__rpropertyintrsetterstrrboolrr#r'r+r.r7r;r>rBrFrrrr%s (((( $3 $ $ $X $%s%%%%%C%%%X%,&&&&&%D%%%X%8&&&&&))))X),*D****'c'''X'((#(((((s(((X(")3)))) " " " "X " ^#S###^#  " " " "X " ^#S###^#  ## # # #X #_$c$$$_$ ! ! ! !X ! ]"C"""]" &S&&&X&.'''''5D555X5" &6666'&666rr) metaclassN)rrbaserrdefaultsrQrrrVs@a6a6a6a6a6a6a6a6a6H 8::r