db

package

v0.0.0-...-16335c8 Latest Latest Go to latest Published: Jul 24, 2017 License: MIT Imports: 7 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.

This section is empty.

func BeginTx() (*sql.Tx, error)

BeginTx returns a transaction

func Init(c *mysql.Config) (err error)

Init database connection

type User struct {
	ID         string
	Name       string
	Password   string
	IsAdmin    bool
	CreatedOn  time.Time
	ModifiedOn mysql.NullTime
}

User represents API user including admin and regular user

func (u *User) Create(tx *sql.Tx) error

Create User

func (u *User) Delete(tx *sql.Tx) error

Delete user from DB by user ID

func (u *User) Load(tx *sql.Tx, id string) error

Load user data by user ID

func (u *User) Scan(scanner interface {
	Scan(...interface{}) error
}) error

Scan raw database row to user

func (u *User) Update(tx *sql.Tx) error

Update user

type UserList []User

UserList type

func (l *UserList) FromRows(rows *sql.Rows) error

FromRows scanning rows into user list

func (l *UserList) Listup(tx *sql.Tx) error

Listup Users