trovares_connector.OracleODBCDriver

trovares_connector.OracleODBCDriver#

class trovares_connector.OracleODBCDriver(connection_string: str, upper_case_names: bool = False, ansi_conversion: bool = True)[source]#
__init__(connection_string: str, upper_case_names: bool = False, ansi_conversion: bool = True)[source]#

Initializes the driver class.

Parameters:

  • connection_string (str) – Standard ODBC connection string used for connecting to Oracle. Example: ‘DSN={OracleODBC-19};Server=127.0.0.1;Port=1521;Uid=c##test;Pwd=test;DBQ=XE;’

  • upper_case_names (bool) – Convert table names to uppercase similar to unqouted names behavior in Oracle queries. By default false.

  • ansi_conversion (bool) – Convert Number(38,0) into int64s in xGT if true. Otherwise, they are stored as floats. This based on the ANSI int conversion Oracle does and reverses that. By default true.

Methods

__init__(connection_string[, ...])

Initializes the driver class.
__init__(connection_string: str, upper_case_names: bool = False, ansi_conversion: bool = True)[source]#

Initializes the driver class.

Parameters:

  • connection_string (str) – Standard ODBC connection string used for connecting to Oracle. Example: ‘DSN={OracleODBC-19};Server=127.0.0.1;Port=1521;Uid=c##test;Pwd=test;DBQ=XE;’

  • upper_case_names (bool) – Convert table names to uppercase similar to unqouted names behavior in Oracle queries. By default false.

  • ansi_conversion (bool) – Convert Number(38,0) into int64s in xGT if true. Otherwise, they are stored as floats. This based on the ANSI int conversion Oracle does and reverses that. By default true.

Contents