database

Documentation

Index

• Variables
• func ApplyMigrations() error
• func CountAdmins() (int64, error)
• func CreateGroup(group *Group) error
• func CreateLink(link *Link) error
• func DeleteAdmin(id int) error
• func DeleteGroup(groupID int) error
• func DeleteLink(linkID int) error
• func EstablishDatabaseConnection(cfg *config.Config) error
• func UpdateGroup(id int, name string) error
• func UpdateLink(link *Link) error
• type Admin
  • func CreateAdmin(username string, password string) (*Admin, error)
  • func GetAdminIfPasswordMatches(username string, password string) (*Admin, error)
• type Group
  • func GetGroupsWithLinks() ([]Group, error)
• type Link
  • func GetLink(id int) (*Link, error)
  • func GetLinksFromGroup(groupID int) ([]Link, error)

Variables

var DB *sql.DB

var (
	ErrWrongNumberOfAffectedRows = errors.New("wrong number of affected rows")
)

Functions

func ApplyMigrations

func ApplyMigrations() error

func CountAdmins

func CountAdmins() (int64, error)

func CreateGroup

func CreateGroup(group *Group) error

Create a new group in the database. The function fills in the ID.

func CreateLink

func CreateLink(link *Link) error

Create a new link in the database. The function fills in the ID.

func DeleteAdmin

func DeleteAdmin(id int) error

func DeleteGroup

func DeleteGroup(groupID int) error

func DeleteLink

func DeleteLink(linkID int) error

func EstablishDatabaseConnection

func EstablishDatabaseConnection(cfg *config.Config) error

func UpdateGroup

func UpdateGroup(id int, name string) error

func UpdateLink

func UpdateLink(link *Link) error

Types

type Admin

type Admin struct {
	ID       int
	Username string
	Bcrypt   string
}

func CreateAdmin

func CreateAdmin(username string, password string) (*Admin, error)

func GetAdminIfPasswordMatches

func GetAdminIfPasswordMatches(username string, password string) (*Admin, error)

type Group

type Group struct {
	ID    int    `json:"id"`
	Name  string `json:"name"`
	Links []Link `json:"links"`
}

func GetGroupsWithLinks

func GetGroupsWithLinks() ([]Group, error)

type Link

type Link struct {
	ID      int     `json:"id"`
	Name    string  `json:"name"`
	Href    string  `json:"href"`
	GroupID int     `json:"-"`
	Icon    *string `json:"icon,omitempty"`
}

func GetLink

func GetLink(id int) (*Link, error)

func GetLinksFromGroup

func GetLinksFromGroup(groupID int) ([]Link, error)