database

Documentation

Index

• func AddSubmission(db *sql.DB, sub faapi.Submission, overwrite bool) (err error)
• func AddUser(db *sql.DB, username string) (err error)
• func FindUserValue(db *sql.DB, username string, column string, value string) (found bool, err error)
• func GetSubmission(db *sql.DB, id int) (sub faapi.Submission, err error)
• func GetUser(db *sql.DB, column string, username ...string) (data [][][]string, err error)
• func OpenDatabase(path string) (db *sql.DB, err error)
• func RemoveSubmission(db *sql.DB, id int) (err error)
• func UpdateInfo(db *sql.DB, field string, value string) (err error)
• func UpdateInfoTotals(db *sql.DB) (err error)
• func UpdateUserAdd(db *sql.DB, username string, column string, value string) (err error)
• func UserURL(usrIn string) (userOut string)

Functions

func AddSubmission

func AddSubmission(db *sql.DB, sub faapi.Submission, overwrite bool) (err error)

AddSubmission add submission to database

func AddUser

func AddUser(db *sql.DB, username string) (err error)

AddUser adds a user to the database

func FindUserValue

func FindUserValue(db *sql.DB, username string, column string, value string) (found bool, err error)

FindUserValue finds a value in a user column

func GetSubmission

func GetSubmission(db *sql.DB, id int) (sub faapi.Submission, err error)

GetSubmission returns a submission as a faapi.Submission struct (if found)

func GetUser

func GetUser(db *sql.DB, column string, username ...string) (data [][][]string, err error)

GetUser returns a slice of column values for any number of users

func OpenDatabase

func OpenDatabase(path string) (db *sql.DB, err error)

OpenDatabase opens the database in path, if present

func RemoveSubmission

func RemoveSubmission(db *sql.DB, id int) (err error)

RemoveSubmission removes a submission given its ID

func UpdateInfo

func UpdateInfo(db *sql.DB, field string, value string) (err error)

UpdateInfo updates a field in the INFOS table

func UpdateInfoTotals

func UpdateInfoTotals(db *sql.DB) (err error)

UpdateInfoTotals updates the totals in the INFOS tables: USRN, SUBN

func UpdateUserAdd

func UpdateUserAdd(db *sql.DB, username string, column string, value string) (err error)

UpdateUserAdd writes content to a user's column

func UserURL

func UserURL(usrIn string) (userOut string)

UserURL changes the username to the URL version