db

package

v1.2.0 Latest Latest Go to latest Published: Apr 13, 2023 License: MIT Imports: 5 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

This section is empty.

View Source

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

This section is empty.

type Conn struct {
	*sql.DB
}

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 struct {
	ID       int
	Active   bool
	SiteCode int
	CardCode int
}