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 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)
  • func (db *DB) AddPad(pad shiftpad.Pad) error
  • func (db *DB) AddShift(pad *shiftpad.Pad, shift shiftpad.Shift) error
  • func (db *DB) DeletePad(pad shiftpad.Pad) error
  • func (db *DB) DeletePads(cutoff string) error
  • func (db *DB) DeleteShift(pad *shiftpad.Pad, 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(pad *shiftpad.Pad, 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(pad *shiftpad.Pad, 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) 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

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