note

Documentation

Overview

Package note provides access to the note table in the MySQL database.

Index

• func ByUserIDCount(db Connection, userID string) (int, error)
• func Create(db Connection, name string, userID string) (sql.Result, error)
• func DeleteHard(db Connection, ID string, userID string) (sql.Result, error)
• func DeleteSoft(db Connection, ID string, userID string) (sql.Result, error)
• func Update(db Connection, name string, ID string, userID string) (sql.Result, error)
• type Connection
• type Item
  • func ByID(db Connection, ID string, userID string) (Item, bool, error)
  • func ByUserID(db Connection, userID string) ([]Item, bool, error)
  • func ByUserIDPaginate(db Connection, userID string, max int, page int) ([]Item, bool, error)

Functions

func ByUserIDCount

func ByUserIDCount(db Connection, userID string) (int, error)

ByUserIDCount counts the number of items for a user.

func Create

func Create(db Connection, name string, userID string) (sql.Result, error)

Create adds an item.

func DeleteHard

func DeleteHard(db Connection, ID string, userID string) (sql.Result, error)

DeleteHard removes an item.

func DeleteSoft

func DeleteSoft(db Connection, ID string, userID string) (sql.Result, error)

DeleteSoft marks an item as removed.

func Update

func Update(db Connection, name string, ID string, userID string) (sql.Result, error)

Update makes changes to an existing item.

Types

type Connection

type Connection interface {
	Exec(query string, args ...interface{}) (sql.Result, error)
	Get(dest interface{}, query string, args ...interface{}) error
	Select(dest interface{}, query string, args ...interface{}) error
}

Connection is an interface for making queries.

type Item

type Item struct {
	ID        uint32         `db:"id"`
	Name      string         `db:"name"`
	UserID    uint32         `db:"user_id"`
	CreatedAt mysql.NullTime `db:"created_at"`
	UpdatedAt mysql.NullTime `db:"updated_at"`
	DeletedAt mysql.NullTime `db:"deleted_at"`
}

Item defines the model.

func ByID

func ByID(db Connection, ID string, userID string) (Item, bool, error)

ByID gets an item by ID.

func ByUserID

func ByUserID(db Connection, userID string) ([]Item, bool, error)

ByUserID gets all items for a user.

func ByUserIDPaginate

func ByUserIDPaginate(db Connection, userID string, max int, page int) ([]Item, bool, error)

ByUserIDPaginate gets items for a user based on page and max variables.