A thin abstraction over SQLite, to work with tables from vals. All methods async.

new SQLiteTable("myTable")
  .create({
    id: "unique primary key",
    title: "text",
    body: "text",
    created: "integer",
  })

Start an instance of SQLiteTable.

Create this table in your VT SQLite storage. scheme is a JSON with column names as keys, and definitions as values (see above for example). Run this only once per table.

Drop this table from your VT SQLite storage.

Add a new row to your table. rowData is a JSON with column names as keys, and row values as values.

table.insertRow({
  id: 1234,
  title: 'Post title',
  body: 'Post body',
  created: 12345678
})

Return the first row matching the provided condition. condition is a JSON of column-value equalities that the desired row must match.

table.getRow({
  id: 1234,
  title: 'Post title'
})

Same, except returns all matching rows.

Returns a count of all rows in the table that match the condition.

Deletes all rows in the table that match the condition.

Modifies all rows in the table that match the condition. rowData is a JSON of key-value pairs to change; it does not affect any columns not mentioned.

table.updateRow(
  {id: 1234},
  {title: 'New title! The existing body text is not mentioned here so it is unaffected'}
)

Migrated from folder: sqlite/SQLiteTable