sql

Oct 31, 2024

Changes in this version

type Sqlite

+ func New(dbpath string) Sqlite

Apr 2, 2023

Changes in this version

+ func Find(db *Sqlite, table string, condition string) (obj T, err error)

+ func FindAll(db *Sqlite, table string, condition string) ([]*T, error)

+ func Query(db *Sqlite, q string) (obj T, err error)

+ func QueryAll(db *Sqlite, q string) ([]*T, error)

type Sqlite

+ func (db *Sqlite) PickFor(table string, n uint, objptr interface{}, f func() error) error

Dec 2, 2022

Changes in this version

+ var DriverName = "sqlite3"

Oct 7, 2022

Changes in this version

type Sqlite

+ func (db *Sqlite) CanQuery(q string) bool

+ func (db *Sqlite) Query(q string, objptr interface{}) error

+ func (db *Sqlite) QueryFor(q string, objptr interface{}, f func() error) error

Sep 21, 2022

Changes in this version

+ var ErrNilDB = errors.New("sqlite: db is not initialized")

+ var ErrNullResult = errors.New("sqlite: null result")

Jun 10, 2022

Changes in this version

type Sqlite

+ func (db *Sqlite) Drop(table string) error

Feb 8, 2022

Changes in this version

+ type Sqlite struct

+ DB *sql.DB

+ DBPath string

+ func (db *Sqlite) CanFind(table string, condition string) bool

+ func (db *Sqlite) Close() (err error)

+ func (db *Sqlite) Count(table string) (num int, err error)

+ func (db *Sqlite) Create(table string, objptr interface{}) (err error)

+ func (db *Sqlite) Del(table string, condition string) error

+ func (db *Sqlite) Find(table string, objptr interface{}, condition string) error

+ func (db *Sqlite) FindFor(table string, objptr interface{}, condition string, f func() error) error

+ func (db *Sqlite) Insert(table string, objptr interface{}) error

+ func (db *Sqlite) InsertUnique(table string, objptr interface{}) error

+ func (db *Sqlite) ListTables() (s []string, err error)

+ func (db *Sqlite) Open() (err error)

+ func (db *Sqlite) Pick(table string, objptr interface{}) error

+ func (db *Sqlite) Truncate(table string) error