sqlite

package

v0.5.0 Latest Latest Go to latest Published: Mar 29, 2024 License: MIT Imports: 7 Imported by: 0

Details

Valid go.mod file

The Go module system was introduced in Go 1.11 and is the official dependency management solution for Go.
Redistributable license

Redistributable licenses place minimal restrictions on how software can be used, modified, and redistributed.
Tagged version

Modules with tagged versions give importers more predictable builds.
Stable version

When a project reaches major version v1 it is considered stable.
Learn more about best practices

Repository

github.com/wansing/shiftpad

Links

Open Source Insights

Documentation ¶

Overview ¶

Package sqlite stores pads and shifts in a SQLite database. Times are stored as unix timestamps, so we can easily compare them.

Shift statements ensure that the shift belongs to the pad by requiring both pad id and shift id. Taker statements however must be called with verified taker ids only (this currently affects addTakerWithID only).

Index ¶

Variables
type DB
- func OpenDB(dbpath string) (*DB, error)

Constants ¶

This section is empty.

Variables ¶

View Source

var ErrUnauthorized = errors.New("unauthorized")

Functions ¶

This section is empty.

Types ¶

type DB ¶

type DB struct {
	SQLDB *sql.DB
	// contains filtered or unexported fields
}

func OpenDB ¶

func OpenDB(dbpath string) (*DB, error)

func (*DB) AddPad ¶

func (db *DB) AddPad(pad shiftpad.Pad) error

func (*DB) AddShift ¶

func (db *DB) AddShift(pad *shiftpad.Pad, shift shiftpad.Shift) error

func (*DB) ApproveTake ¶ added in v0.5.0

func (db *DB) ApproveTake(shift *shiftpad.Shift, take shiftpad.Take) error

func (*DB) DeletePad ¶

func (db *DB) DeletePad(pad shiftpad.Pad) error

func (*DB) DeletePads ¶

func (db *DB) DeletePads(cutoff string) error

func (*DB) DeleteShift ¶

func (db *DB) DeleteShift(pad *shiftpad.Pad, shift *shiftpad.Shift) error

func (*DB) GetPad ¶

func (db *DB) GetPad(id string) (*shiftpad.Pad, error)

func (*DB) GetShift ¶

func (db *DB) GetShift(pad *shiftpad.Pad, id int) (*shiftpad.Shift, error)

func (*DB) GetShifts ¶

func (db *DB) GetShifts(pad *shiftpad.Pad, from, to int64) ([]shiftpad.Shift, error)

func (*DB) GetShiftsByEvent ¶

func (db *DB) GetShiftsByEvent(pad *shiftpad.Pad, eventUID string) ([]shiftpad.Shift, error)

func (*DB) GetTakers ¶ added in v0.4.0

func (db *DB) GetTakers(shift int) ([]shiftpad.Take, error)

func (*DB) TakeShift ¶

func (db *DB) TakeShift(pad *shiftpad.Pad, shift *shiftpad.Shift, take shiftpad.Take) error

func (*DB) UpdatePad ¶

func (db *DB) UpdatePad(pad *shiftpad.Pad) error

func (*DB) UpdatePadLastUpdated ¶

func (db *DB) UpdatePadLastUpdated(pad *shiftpad.Pad, lastUpdated string) error

func (*DB) UpdateShift ¶

func (db *DB) UpdateShift(pad *shiftpad.Pad, shift *shiftpad.Shift) error

Source Files ¶

View all Source files

sqlite.go

?	: This menu
/	: Search site
f or F	: Jump to
y or Y	: Canonical URL