note

package
v0.0.0-...-f200a5c Latest Latest
Warning

This package is not in the latest version of its module.

Go to latest
Published: Jul 17, 2017 License: MIT Imports: 3 Imported by: 7

Documentation

Overview

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

Index

Constants

This section is empty.

Variables

This section is empty.

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.

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL