sqlite

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 must be called with shift ids that are confirmed to belong to our pad (e. g. from GetShift). Taker statements must be called with taker ids that are confirmed to belong to the selected shift.

Index

• Variables
• type DB
  • func OpenDB(dbpath string) (*DB, error)
  • func (db *DB) AddPad(pad shiftpad.Pad) error
  • func (db *DB) AddShift(pad *shiftpad.Pad, shift shiftpad.Shift) error
  • func (db *DB) ApproveTake(shift *shiftpad.Shift, take shiftpad.Take) error
  • func (db *DB) DeletePad(pad shiftpad.Pad) error
  • func (db *DB) DeletePads(cutoff string) error
  • func (db *DB) DeleteShift(shift *shiftpad.Shift) error
  • func (db *DB) GetPad(id string) (*shiftpad.Pad, error)
  • func (db *DB) GetShift(pad *shiftpad.Pad, id int) (*shiftpad.Shift, error)
  • func (db *DB) GetShifts(pad *shiftpad.Pad, from, to int64) ([]shiftpad.Shift, error)
  • func (db *DB) GetShiftsByEvent(pad *shiftpad.Pad, eventUID string) ([]shiftpad.Shift, error)
  • func (db *DB) GetTakers(shift int) ([]shiftpad.Take, error)
  • func (db *DB) TakeShift(shift *shiftpad.Shift, take shiftpad.Take) error
  • func (db *DB) UpdatePad(pad *shiftpad.Pad) error
  • func (db *DB) UpdatePadLastUpdated(pad *shiftpad.Pad, lastUpdated string) error
  • func (db *DB) UpdateShift(shift *shiftpad.Shift) error

Variables

var ErrUnauthorized = errors.New("unauthorized")

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

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(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

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

func (*DB) TakeShift

func (db *DB) TakeShift(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(shift *shiftpad.Shift) error