sqlite3_db

package

v0.14.0 Latest Latest Go to latest Published: Aug 3, 2025 License: BSD-3-Clause Imports: 5 Imported by: 18

Details

Package sqlite3_db contains common types and functions for storing data in a sqlite3 database.

This section is empty.

This section is empty.

func DateToString(t time.Time) string

DateToString converts a date to YYYYmmdd

func NewDoer(db *Db) db.Doer

func StringToDate(s string) (t time.Time, e error)

StringToDate converts a string of form YYYYmmdd to a time object in UTC time zone.

type Action func(tx *sql.Tx) error

Action represents some action against a sqlite3 database

type Db struct {
	// contains filtered or unexported fields
}

Db wraps a sqlite3 database connection. With Db, multiple goroutines can safely share the same connection. Db also provides transactional behavior.

func New(db *sql.DB) *Db

New creates a new Db.

func (d *Db) Close() error

Close closes the underlying sql.DB instance.

func (d *Db) Do(action Action) error

Do performs action within a transaction.

type Doer interface {
	Do(Action) error
}

Doer does an Action against a sqlite3 database

func NewSqlite3Doer(tx *sql.Tx) Doer

func ToDoer(db Doer, t db.Transaction) Doer

If t is not nil, converts t to a Doer. Otherwise returns db as the Doer.