Enum Statement

Source

pub enum Statement {
Show 24 variants    Empty,
    Select(SelectId),
    Insert(Box<Insert>),
    Update(Box<Update>),
    Delete(Box<Delete>),
    CreateTable {
        temporary: bool,
        if_not_exists: bool,
        database: Option<NameId>,
        name: NameId,
        body: CreateTableBody,
    },
    CreateIndex {
        unique: bool,
        if_not_exists: bool,
        database: Option<NameId>,
        name: NameId,
        table: NameId,
        using: Option<NameId>,
        columns: Vec<IndexedColumn>,
        settings: Vec<Vec<u8>>,
        filter: Option<ExprId>,
    },
    CreateView {
        temporary: bool,
        if_not_exists: bool,
        database: Option<NameId>,
        name: NameId,
        columns: Vec<NameId>,
        select: SelectId,
    },
    CreateTrigger {
        temporary: bool,
        if_not_exists: bool,
        database: Option<NameId>,
        name: NameId,
        time: Option<TriggerTime>,
        event: TriggerEvent,
        table: NameId,
        table_database: Option<NameId>,
        for_each_row: bool,
        when: Option<ExprId>,
        body: Vec<Statement>,
    },
    CreateVirtualTable {
        if_not_exists: bool,
        database: Option<NameId>,
        name: NameId,
        module: NameId,
        arguments: Vec<Vec<u8>>,
    },
    Drop {
        kind: ObjectKind,
        if_exists: bool,
        database: Option<NameId>,
        name: NameId,
    },
    AlterTable {
        database: Option<NameId>,
        table: NameId,
        action: AlterAction,
    },
    Begin {
        behaviour: Option<TransactionBehaviour>,
    },
    Commit,
    Rollback {
        savepoint: Option<NameId>,
    },
    Savepoint(NameId),
    Release(NameId),
    Pragma {
        database: Option<NameId>,
        name: NameId,
        value: PragmaValue,
    },
    Attach {
        file: ExprId,
        schema: ExprId,
        key: Option<ExprId>,
    },
    Detach {
        schema: ExprId,
    },
    Vacuum {
        database: Option<NameId>,
        into: Option<ExprId>,
    },
    Analyze {
        database: Option<NameId>,
        name: Option<NameId>,
    },
    Reindex {
        database: Option<NameId>,
        name: Option<NameId>,
    },
    Explain {
        query_plan: bool,
        inner: Box<Statement>,
    },
}

Expand description

A parsed statement.

Variants§

§

Empty

An empty statement, which SQLite compiles to nothing.

§

Select(SelectId)

SELECT or VALUES.

§

Insert(Box<Insert>)

INSERT or REPLACE.

§

Update(Box<Update>)

UPDATE.

§

Delete(Box<Delete>)

DELETE.

§

CreateTable

CREATE TABLE.

Fields

§temporary: bool

Whether TEMP was written.

§if_not_exists: bool

Whether IF NOT EXISTS was written.

§database: Option<NameId>

The schema qualifier.

§name: NameId

The table name.

§body: CreateTableBody

The body.

§

CreateIndex

CREATE INDEX.

Fields

§unique: bool

Whether UNIQUE was written.

§if_not_exists: bool

Whether IF NOT EXISTS was written.

§database: Option<NameId>

The schema qualifier.

§name: NameId

The index name.

§table: NameId

The table it indexes.

§using: Option<NameId>

The module named by USING, when one was.

SQLite has no USING on CREATE INDEX; PostgreSQL does, and it is how pgvector spells USING hnsw. This engine borrows the spelling for the same purpose: an index whose structure is not a b-tree. A plain CREATE INDEX leaves it None and nothing downstream changes.

§columns: Vec<IndexedColumn>

The key columns.

§settings: Vec<Vec<u8>>

The storage parameters WITH ( ... ) named, as written.

m = 16, ef_construction = 64 and the rest: raw name = value slices, in the order they were written, for the structure named by using to read. Empty for a plain CREATE INDEX, which has no structure to read them.

§filter: Option<ExprId>

The partial-index predicate.

§