sqlalchemy.dialects.oracle.cx_oracle.OracleExecutionContext_cx_oracle

class documentation

class OracleExecutionContext_cx_oracle(OracleExecutionContext):

View In Hierarchy

Undocumented

Method ​_generate​_cursor​_outputtype​_handler Undocumented
Method ​_generate​_out​_parameter​_vars Undocumented
Method ​_get​_cx​_oracle​_type​_handler Undocumented
Method create​_cursor Return a new cursor generated from this ExecutionContext's connection.
Method get​_out​_parameter​_values Return a sequence of OUT parameter values from a cursor.
Method post​_exec Called after the execution of a compiled statement.
Method pre​_exec Called before an execution of a compiled statement.
Instance Variable cursor​_fetch​_strategy Undocumented
Instance Variable include​_set​_input​_sizes Undocumented
Instance Variable out​_parameters Undocumented

Inherited from OracleExecutionContext:

Method fire​_sequence Undocumented

Inherited from DefaultExecutionContext (via OracleExecutionContext):

Method get​_current​_parameters Return a dictionary of parameters applied to the current row.
Method get​_lastrowid return self.cursor.lastrowid, or equivalent, after an INSERT.
Method get​_result​_processor Return a 'result processor' for a given type as present in cursor.description.
Method handle​_dbapi​_exception Receive a DBAPI exception which occurred upon execute, result fetch, etc.
Method lastrow​_has​_defaults Return True if the last INSERT or UPDATE row contained inlined or database-side defaults.
Method should​_autocommit​_text Parse the given textual statement and return True if it refers to a "committable" statement
Instance Variable current​_parameters A dictionary of parameters applied to the current row.
Class Method ​_init​_compiled Initialize execution context for a Compiled construct.
Class Method ​_init​_ddl Initialize execution context for a DDLElement construct.
Class Method ​_init​_default Initialize execution context for a ColumnDefault construct.
Class Method ​_init​_statement Initialize execution context for a string SQL statement.
Method ​_exec​_default Undocumented
Method ​_exec​_default​_clause​_element Undocumented
Method ​_execute​_scalar Execute a string statement on the current cursor, returning a scalar result.
Method ​_get​_cache​_stats Undocumented
Method ​_process​_executemany​_defaults Undocumented
Method ​_process​_executesingle​_defaults Undocumented
Method ​_set​_input​_sizes Given a cursor and ClauseParameters, call the appropriate style of setinputsizes() on the cursor, using DB-API types from the bind parameter's TypeEngine objects.
Method ​_setup​_dml​_or​_text​_result Undocumented
Method ​_setup​_ins​_pk​_from​_empty Undocumented
Method ​_setup​_ins​_pk​_from​_implicit​_returning Undocumented
Method ​_setup​_ins​_pk​_from​_lastrowid Undocumented
Method ​_setup​_out​_parameters Undocumented
Method ​_setup​_result​_proxy Undocumented
Method ​_use​_server​_side​_cursor Undocumented
Method create​_default​_cursor Undocumented
Method create​_server​_side​_cursor Undocumented
Method get​_insert​_default Undocumented
Method get​_update​_default Undocumented
Method supports​_sane​_multi​_rowcount Undocumented
Method supports​_sane​_rowcount Undocumented
Class Variable ​_translate​_colname Undocumented
Class Variable cache​_stats Undocumented
Class Variable exclude​_set​_input​_sizes Undocumented
Instance Variable ​_dbapi​_connection Undocumented
Instance Variable ​_expanded​_parameters Undocumented
Instance Variable ​_is​_explicit​_returning Undocumented
Instance Variable ​_is​_future​_result Undocumented
Instance Variable ​_is​_implicit​_returning Undocumented
Instance Variable ​_is​_server​_side Undocumented
Instance Variable ​_soft​_closed Undocumented
Instance Variable cache​_hit Undocumented
Instance Variable compiled Undocumented
Instance Variable compiled​_parameters Undocumented
Instance Variable cursor Undocumented
Instance Variable dialect Undocumented
Instance Variable executemany Undocumented
Instance Variable execution​_options Undocumented
Instance Variable extracted​_parameters Undocumented
Instance Variable invoked​_statement Undocumented
Instance Variable is​_crud Undocumented
Instance Variable is​_text Undocumented
Instance Variable isddl Undocumented
Instance Variable isdelete Undocumented
Instance Variable isinsert Undocumented
Instance Variable isupdate Undocumented
Instance Variable parameters Undocumented
Instance Variable result​_column​_struct Undocumented
Instance Variable returned​_default​_rows Undocumented
Instance Variable root​_connection Undocumented
Instance Variable statement Undocumented
Instance Variable unicode​_statement Undocumented
Property connection Undocumented
Property engine Undocumented
Property identifier​_preparer Undocumented
Property inserted​_primary​_key​_rows Undocumented
Property no​_parameters Undocumented
Property postfetch​_cols Undocumented
Property prefetch​_cols Undocumented
Property returning​_cols Undocumented
Property rowcount Undocumented
Property should​_autocommit Undocumented

Inherited from ExecutionContext (via OracleExecutionContext, DefaultExecutionContext):

Method get​_result​_cursor​_strategy Return a result cursor strategy for a given result object.
Method get​_rowcount Return the DBAPI cursor.rowcount value, or in some cases an interpreted value.
def _generate_cursor_outputtype_handler(self):

Undocumented

def _generate_out_parameter_vars(self):

Undocumented

def _get_cx_oracle_type_handler(self, impl):

Undocumented

def create_cursor(self):
overrides sqlalchemy.engine.default.DefaultExecutionContext.create_cursor

Return a new cursor generated from this ExecutionContext's connection.

Some dialects may wish to change the behavior of connection.cursor(), such as postgresql which may return a PG "server side" cursor.

def get_out_parameter_values(self, out_param_names):
overrides sqlalchemy.engine.default.DefaultExecutionContext.get_out_parameter_values

Return a sequence of OUT parameter values from a cursor.

For dialects that support OUT parameters, this method will be called when there is a .SQLCompiler object which has the .SQLCompiler.has_out_parameters flag set. This flag in turn will be set to True if the statement itself has .BindParameter objects that have the .isoutparam flag set which are consumed by the .SQLCompiler.visit_bindparam method. If the dialect compiler produces .BindParameter objects with .isoutparam set which are not handled by .SQLCompiler.visit_bindparam, it should set this flag explicitly.

The list of names that were rendered for each bound parameter is passed to the method. The method should then return a sequence of values corresponding to the list of parameter objects. Unlike in previous SQLAlchemy versions, the values can be the raw values from the DBAPI; the execution context will apply the appropriate type handler based on what's present in self.compiled.binds and update the values. The processed dictionary will then be made available via the .out_parameters collection on the result object. Note that SQLAlchemy 1.4 has multiple kinds of result object as part of the 2.0 transition.

New in version 1.4: - added .ExecutionContext.get_out_parameter_values, which is invoked automatically by the .DefaultExecutionContext when there are .BindParameter objects with the .isoutparam flag set. This replaces the practice of setting out parameters within the now-removed get_result_proxy() method.

See Also

.ExecutionContext.get_result_cursor_strategy

def post_exec(self):
overrides sqlalchemy.engine.default.DefaultExecutionContext.post_exec

Called after the execution of a compiled statement.

If a compiled statement was passed to this ExecutionContext, the last_insert_ids, last_inserted_params, etc. datamembers should be available after this method completes.

def pre_exec(self):
overrides sqlalchemy.engine.default.DefaultExecutionContext.pre_exec

Called before an execution of a compiled statement.

If a compiled statement was passed to this ExecutionContext, the statement and parameters datamembers must be initialized after this statement is complete.

cursor_fetch_strategy =

Undocumented

include_set_input_sizes =
overrides sqlalchemy.engine.default.DefaultExecutionContext.include_set_input_sizes

Undocumented

out_parameters: dict =

Undocumented