Struct GenerateSeriesTable 

pub struct GenerateSeriesTable;

Virtual table that generates a sequence of integers.

Usage: SELECT value FROM generate_series(1, 10) produces rows 1..=10. Optional third argument specifies step (default 1).

Trait Implementations

impl VirtualTable for GenerateSeriesTable

type Cursor = GenerateSeriesCursor

The cursor type for scanning this virtual table.

fn create(_cx: &Cx, _args: &[&str]) -> Result<Self>

Called for CREATE VIRTUAL TABLE.

fn connect(_cx: &Cx, _args: &[&str]) -> Result<Self>

Called for subsequent opens of an existing virtual table.

fn best_index(&self, info: &mut IndexInfo) -> Result<()>

Inform the query planner about available indexes and their costs.

fn open(&self) -> Result<Self::Cursor>

Open a new scan cursor.

fn disconnect(&mut self, _cx: &Cx) -> Result<(), FrankenError>

Drop a virtual table instance (opposite of connect).

fn destroy(&mut self, cx: &Cx) -> Result<(), FrankenError>

Called for DROP VIRTUAL TABLE — destroy backing storage.

fn update( &mut self, _cx: &Cx, _args: &[SqliteValue], ) -> Result<Option<i64>, FrankenError>

INSERT/UPDATE/DELETE on the virtual table.

fn begin(&mut self, _cx: &Cx) -> Result<(), FrankenError>

Begin a virtual table transaction.

fn sync_txn(&mut self, _cx: &Cx) -> Result<(), FrankenError>

Sync a virtual table transaction (phase 1 of 2PC).

fn commit(&mut self, _cx: &Cx) -> Result<(), FrankenError>

Commit a virtual table transaction.

fn rollback(&mut self, _cx: &Cx) -> Result<(), FrankenError>

Roll back a virtual table transaction.

fn rename(&mut self, _cx: &Cx, _new_name: &str) -> Result<(), FrankenError>

Rename the virtual table.

fn savepoint(&mut self, _cx: &Cx, _n: i32) -> Result<(), FrankenError>

Create a savepoint at level n.

fn release(&mut self, _cx: &Cx, _n: i32) -> Result<(), FrankenError>

Release savepoint at level n.

fn rollback_to(&mut self, _cx: &Cx, _n: i32) -> Result<(), FrankenError>

Roll back to savepoint at level n.