Enum Stmt 

pub enum Stmt {
    Query {
        nql: String,
        project: Vec<Col>,
    },
    Insert {
        coll: String,
        rows: Vec<InsertRow>,
        returning: Vec<Col>,
    },
    Update {
        coll: String,
        set: Vec<(String, Value)>,
        nql: String,
        returning: Vec<Col>,
    },
    Delete {
        coll: String,
        nql: String,
        returning: Vec<Col>,
    },
    Canned {
        cols: Vec<String>,
        row: Vec<String>,
    },
    Ok(&'static str),
}

What a translated statement asks for.

The write variants exist because SQL’s write semantics and NEDB’s storage model line up almost exactly, which was not obvious until it was written down:

SQL	NEDB
INSERT	a put
UPDATE … WHERE	a NEW VERSION of each matching document
DELETE … WHERE	a tombstone

NEDB is append-only, so an UPDATE is already a versioned write and a DELETE is already a tombstone. Nothing is being bent to fit. The consequence is the thing worth selling: run the SQL you would run against Postgres, and the tamper-evident history falls out for free — the prior value is still readable with AS OF SYSTEM TIME.

Variants

Query

Run this NQL, then project these columns (empty = all).

Fields

nql: String

project: Vec<Col>

Insert

INSERT INTO coll (cols) VALUES (…), (…) [RETURNING …]

Fields

coll: String

rows: Vec<InsertRow>

returning: Vec<Col>

Update

UPDATE coll SET … [WHERE …] [RETURNING …] — a new version per match.

Fields

coll: String

set: Vec<(String, Value)>

nql: String

returning: Vec<Col>

Delete

DELETE FROM coll [WHERE …] [RETURNING …] — a tombstone per match.

Fields

coll: String

nql: String

returning: Vec<Col>

Canned

Answer from a fixed table — the handshake queries clients send on connect.

Fields

cols: Vec<String>

row: Vec<String>

Ok(&'static str)

Nothing to do (empty statement, or a SET the client does not need honoured).

Trait Implementations

impl Debug for Stmt

fn fmt(&self, f: &mut Formatter<'_>) -> Result<(), Error>

Formats the value using the given formatter.

impl PartialEq for Stmt

fn eq(&self, other: &Stmt) -> bool

Equality operator ==.

fn ne(&self, other: &Rhs) -> bool

Inequality operator !=.

impl StructuralPartialEq for Stmt