sigildocs

(sigil web demo db)

(sigil web demo db) - Database schema and CRUD operations

Manages a SQLite database of vinyl records with create, read, update, delete, search, and pagination support.

Exports

init-dbprocedure

Initialize the database: create table and seed sample data.

list-recordsprocedure

List records with pagination and optional search. Returns list of alist rows.

count-recordsprocedure

Count records with optional search filter.

get-recordprocedure

Get a single record by id.

create-recordprocedure

Create a new record from form params alist. Returns the new id.

update-recordprocedure

Update a record by id from form params alist.

delete-recordprocedure

Delete a record by id.