list

Documentation

Index

• func DeleteList(dbc *sqlx.DB, id int) error
• func UpdateList(dbc *sqlx.DB, r List) error
• type List
  • func CreateList(dbc *sqlx.DB, r List) (List, error)
  • func SelectList(dbc *sqlx.DB, id int) (List, error)
  • func SelectLists(dbc *sqlx.DB) ([]List, error)

Functions

func DeleteList

func DeleteList(dbc *sqlx.DB, id int) error

DeleteList deletes a row in the list table based off of list_id.

func UpdateList

func UpdateList(dbc *sqlx.DB, r List) error

UpdateList updates a row in the list table based off of a list_id. The only field able to be updated is the name field.

Types

type List

type List struct {
	ID       int       `json:"id" db:"list_id"`
	Name     string    `json:"name" db:"name"`
	Created  time.Time `json:"created" db:"created"`
	Modified time.Time `json:"modified" db:"modified"`
}

List is a type that contains the proper struct tags for both a JSON and Postgres representation of a list.

func CreateList

func CreateList(dbc *sqlx.DB, r List) (List, error)

CreateList inserts a new row into the list table.

func SelectList

func SelectList(dbc *sqlx.DB, id int) (List, error)

SelectList selects a single row from the list table based off of a given list_id.

func SelectLists

func SelectLists(dbc *sqlx.DB) ([]List, error)

SelectLists selects all rows from the list table.