sqjdb

README

sqjdb

SQLite JSON Database using Zombiezen/ModernC's cgo-free port of SQLite.

Documentation

Index

• Variables
• func Bind(stmt *sqlite.Stmt, i int, v any) error
• type SQL
  • func ByID(id string) SQL
• type Table
  • func NewTable[T any](name string) Table[T]
  • func (t *Table[T]) All(conn *sqlite.Conn, sqls ...SQL) ([]*T, error)
  • func (t *Table[T]) Delete(conn *sqlite.Conn, sqls ...SQL) error
  • func (t *Table[T]) Insert(conn *sqlite.Conn, doc *T) (*T, error)
  • func (t *Table[T]) Migrate(conn *sqlite.Conn) error
  • func (t *Table[T]) One(conn *sqlite.Conn, sqls ...SQL) (*T, error)
  • func (t *Table[T]) Patch(conn *sqlite.Conn, doc *T, sqls ...SQL) error
  • func (t *Table[T]) Replace(conn *sqlite.Conn, doc *T, sqls ...SQL) error

Variables

var ErrNoRows = errors.New("sqjson: no rows in result set")

Functions

func Bind

func Bind(stmt *sqlite.Stmt, i int, v any) error

Types

type SQL

type SQL struct {
	Query string
	Args  []any
}

func ByID

func ByID(id string) SQL

type Table

type Table[T any] struct {
	Name string
	// contains filtered or unexported fields
}

func NewTable

func NewTable[T any](name string) Table[T]

func (*Table[T]) All

func (t *Table[T]) All(conn *sqlite.Conn, sqls ...SQL) ([]*T, error)

func (*Table[T]) Delete

func (t *Table[T]) Delete(conn *sqlite.Conn, sqls ...SQL) error

func (*Table[T]) Insert

func (t *Table[T]) Insert(conn *sqlite.Conn, doc *T) (*T, error)

func (*Table[T]) Migrate

func (t *Table[T]) Migrate(conn *sqlite.Conn) error

func (*Table[T]) One

func (t *Table[T]) One(conn *sqlite.Conn, sqls ...SQL) (*T, error)

func (*Table[T]) Patch

func (t *Table[T]) Patch(conn *sqlite.Conn, doc *T, sqls ...SQL) error

func (*Table[T]) Replace

func (t *Table[T]) Replace(conn *sqlite.Conn, doc *T, sqls ...SQL) error