Skip to content

rvrdata.adapters.rvrsqlite

Sql adapter for sqlite3 databases.

class RvrdataRvrsqlite

Sql adapter for rvrsql.

force_pass()

Fake successful action that does nothing (used for testing dry-runs).

execute()

Execute sql statement.

SQLite Execute Metrics

The following metrics are included in the step results:

  • rvrdata.dataflow.action.rvrsqlite.execute.action_count: Number of times the SQL execute function is called (int).
  • rvrdata.dataflow.action.rvrsqlite.execute.row_count: Number of rows returned by the SQL execute function (int).

One row is added to the metrics each time the action is run.

executemany()

Execute parametrized sql statement against given parameter sequences.

SQLite Executemany Metrics

The following metrics are included in the step results:

  • rvrdata.dataflow.action.rvrsqlite.executemany.action_count: Number of times the SQL executemany function is called (int).
  • rvrdata.dataflow.action.rvrsqlite.executemany.row_count: Number of rows returned by the SQL executemany function (int).

One row is added to the metrics each time the action is run.

executescript()

Execute sql script.

SQLite Execute Metrics

The following metrics are included in the step results:

  • rvrdata.dataflow.action.rvrsqlite.executescript.action_count: Number of times the SQL execute script function is called (int).
  • rvrdata.dataflow.action.rvrsqlite.executescript.row_count: Number of rows returned by the SQL execute script function (int).

One row is added to the metrics each time the action is run.

select()

Query and fetch results.

SQLite Select Metrics

The following metrics are included in the step results:

  • rvrdata.dataflow.action.rvrsqlite.select.action_count: Number of times the SQL select function is called (int).
  • rvrdata.dataflow.action.rvrsqlite.select.row_count: Number of rows returned by the SQL select (int).

One row is added to the metrics each time the action is run.