database

Mar 14, 2024

Changes in this version

+ func GetEntitiesForUser(entity Entity, db *sql.DB, userID string) ([]int, error)

+ func RemoveEntityForUser(entity Entity, db *sql.DB, objectID string, userID string) (bool, error)

+ func SetEntityForUser(entity Entity, db *sql.DB, objectID string, userID string) (bool, error)

+ type Entity string

+ const Artist

+ const Event

+ const Festival

+ const Image

+ const Link

+ const Location

+ const Place

+ const Tag

Mar 6, 2024

Changes in this version

+ func GetEventsForUser(db *sql.DB, userID string) ([]int, error)

+ func GetImagesForUser(db *sql.DB, userID string) ([]int, error)

+ func GetLinksForUser(db *sql.DB, userID string) ([]int, error)

+ func GetPlacesForUser(db *sql.DB, userID string) ([]int, error)

+ func GetTagsForUser(db *sql.DB, userID string) ([]int, error)

+ func RemoveEventForUser(db *sql.DB, objectID string, userID string) (bool, error)

+ func RemoveImageForUser(db *sql.DB, objectID string, userID string) (bool, error)

+ func RemoveLinkForUser(db *sql.DB, objectID string, userID string) (bool, error)

+ func RemovePlaceForUser(db *sql.DB, objectID string, userID string) (bool, error)

+ func RemoveTagForUser(db *sql.DB, objectID string, userID string) (bool, error)

+ func SetEventForUser(db *sql.DB, objectID string, userID string) (bool, error)

+ func SetImageForUser(db *sql.DB, objectID string, userID string) (bool, error)

+ func SetLinkForUser(db *sql.DB, objectID string, userID string) (bool, error)

+ func SetPlaceForUser(db *sql.DB, objectID string, userID string) (bool, error)

+ func SetTagForUser(db *sql.DB, objectID string, userID string) (bool, error)

Mar 6, 2024

Changes in this version

+ func AddAPIKey(db *sql.DB, key token.APIKey) error

+ func AddServiceKey(db *sql.DB, key token.ServiceKey) error

+ func CreateUserWithEmailAndPasswordHash(db *sql.DB, email string, passwordhash string) (bool, error)

+ func GenerateAccessToken(user *token.User, db *sql.DB, auth *token.AuthService) (string, error)

+ func GetAllAPIKeys(db *sql.DB) ([]token.APIKey, error)

+ func GetAllServiceKeys(db *sql.DB) ([]token.ServiceKey, error)

+ func GetAllUsers(db *sql.DB) ([]*token.User, error)

+ func GetArtistsForUser(db *sql.DB, userID string) ([]int, error)

+ func GetFestivalsForUser(db *sql.DB, userID string) ([]int, error)

+ func GetLocationsForUser(db *sql.DB, userID string) ([]int, error)

+ func GetUserByEmail(db *sql.DB, email string) (*token.User, error)

+ func GetUserByID(db *sql.DB, userID string) (*token.User, error)

+ func RegenerateAccessToken(user *token.User, oldClaims *token.UserClaims, db *sql.DB, ...) (string, error)

+ func RemoveAPIKey(db *sql.DB, keyID string) error

+ func RemoveArtistForUser(db *sql.DB, arrtistID string, userID string) (bool, error)

+ func RemoveFestivalForUser(db *sql.DB, festivalID string, userID string) (bool, error)

+ func RemoveLocationForUser(db *sql.DB, locationID string, userID string) (bool, error)

+ func RemoveServiceKey(db *sql.DB, keyID string) error

+ func SetArtistForUser(db *sql.DB, artistID string, userID string) (bool, error)

+ func SetFestivalForUser(db *sql.DB, festivalID string, userID string) (bool, error)

+ func SetLocationForUser(db *sql.DB, locationID string, userID string) (bool, error)

+ func SetPasswordForUser(db *sql.DB, userID string, newpasswordhash string) (bool, error)

+ func SetRoleForUser(db *sql.DB, userID string, newUserRole int) (bool, error)

+ func UpdateAPIKey(db *sql.DB, key token.APIKey) error

+ func UpdateServiceKey(db *sql.DB, key token.ServiceKey) error

Jul 20, 2023

Changes in this version

+ func DBFields(object interface{}) (string, error)

+ func DBKeyValuePairs(object interface{}) (string, error)

+ func DBPlaceholder(object interface{}) (string, error)

+ func DBPlaceholderForIDs(ids []int) string

+ func DBValues(object interface{}) ([]interface{}, error)

+ func ExecuteQuery(db *sql.DB, query string, args []interface{}) (sql.Result, error)

+ func ExecuteRowQuery(db *sql.DB, query string, args []interface{}) (*sql.Rows, error)

+ func InterfaceInt(ints []int) []interface

+ func Select(db *sql.DB, table string, objectIDs []int) (*sql.Rows, error)