db

Documentation

Index

• Variables
• type Conn
  • func NewConn(dsn string) (*Conn, error)
  • func (c *Conn) CreateCredential(id int, cred *Credential) (int, error)
  • func (c *Conn) DeleteCredential(id, credID int) error
  • func (c *Conn) HasPictureIDs() ([]int, error)
  • func (c *Conn) ListAllCredentials() (map[int][]*Credential, error)
  • func (c *Conn) ListCredentials(id int) ([]*Credential, error)
  • func (c *Conn) ListDepartments() (map[int]string, error)
  • func (c *Conn) ReadPicture(id int) ([]byte, error)
  • func (c *Conn) UpdatePicture(id int, buf []byte) error
  • func (c *Conn) WithTx(fn func(tx *sql.Tx) error) error
• type Credential

Variables

var (
	ErrNotFound         = errors.New("not found")
	ErrCredentialExists = errors.New("credential exists")
)

Types

type Conn

type Conn struct {
	*sql.DB
}

func NewConn

func NewConn(dsn string) (*Conn, error)

func (*Conn) CreateCredential

func (c *Conn) CreateCredential(id int, cred *Credential) (int, error)

func (*Conn) DeleteCredential

func (c *Conn) DeleteCredential(id, credID int) error

func (*Conn) HasPictureIDs

func (c *Conn) HasPictureIDs() ([]int, error)

func (*Conn) ListAllCredentials

func (c *Conn) ListAllCredentials() (map[int][]*Credential, error)

func (*Conn) ListCredentials

func (c *Conn) ListCredentials(id int) ([]*Credential, error)

func (*Conn) ListDepartments

func (c *Conn) ListDepartments() (map[int]string, error)

func (*Conn) ReadPicture

func (c *Conn) ReadPicture(id int) ([]byte, error)

func (*Conn) UpdatePicture

func (c *Conn) UpdatePicture(id int, buf []byte) error

func (*Conn) WithTx

func (c *Conn) WithTx(fn func(tx *sql.Tx) error) error

type Credential

type Credential struct {
	ID       int
	Active   bool
	SiteCode int
	CardCode int
}