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.

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) TakeShift(pad *shiftpad.Pad, shift *shiftpad.Shift) 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) TakeShift

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