database

package
v0.0.0-...-4e7c794 Latest Latest
Warning

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

Go to latest
Published: Apr 13, 2019 License: EUPL-1.2 Imports: 13 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

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

Types

This section is empty.

Jump to

Keyboard shortcuts

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