database

Documentation

Index

• Variables
• func AddAdmin(db *sql.DB, ...) error
• func AddGroup(db *sql.DB, groupName string) error
• func AddUser(db *sql.DB, username, firstName, lastName, email, password, serviceName string) error
• func AddUserToGroup(db *sql.DB, username, groupName string, owner bool) error
• func DoesUserHaveAccess(db *sql.DB, username, serviceName string) (bool, error)
• func GetDriverOptions() string
• func GetGroupsOfService(db *sql.DB, serviceName string) (string, error)
• func GetGroupsOfUser(db *sql.DB, username string, ownGroups bool) (string, error)
• func GetServicesOfGroup(db *sql.DB, groupName string) (string, error)
• func GetServicesOfUser(db *sql.DB, username string, ownServices bool) (string, error)
• func GetSortedDrivers() []string
• func GetUsersOfGroup(db *sql.DB, groupName string) (string, error)
• func GetUsersOfService(db *sql.DB, serviceName string) (string, error)
• func GetdB(driverAsPipefishEnum, name, host string, port int, user, password string) (*sql.DB, error)
• func IsUserAdmin(db *sql.DB, username string) (bool, error)
• func IsUserGroupOwner(db *sql.DB, username, groupName string) error
• func IsUserInGroup(db *sql.DB, username, groupName string) (bool, error)
• func LetGroupUseService(db *sql.DB, groupName, serviceName string) error
• func LetUserOwnGroup(db *sql.DB, username, groupName string) error
• func UnAddUserToGroup(db *sql.DB, username, groupName string) error
• func UnLetGroupUseService(db *sql.DB, groupName, serviceName string) error
• func UnLetUserOwnGroup(db *sql.DB, username, groupName string) error
• func UpdateService(db *sql.DB, username, serviceName string) error
• func ValidateUser(db *sql.DB, username, password string) (string, error)
• type SQLDriver

Variables

var SqlDrivers = []string{"postgres", "firebirdsql", "mysql", "sqlserver", "mysql",
	"oracle", "postgres", "snowflake", "sqlite", "mysql"}

Matches with the enum above, e.g. COCKROACH_DB uses the postgres driver.

Functions

func AddAdmin

func AddAdmin(db *sql.DB, username, firstName, lastName, email, password, serviceName, dir string) error

func AddGroup

func AddGroup(db *sql.DB, groupName string) error

func AddUser

func AddUser(db *sql.DB, username, firstName, lastName, email, password, serviceName string) error

func AddUserToGroup

func AddUserToGroup(db *sql.DB, username, groupName string, owner bool) error

func DoesUserHaveAccess

func DoesUserHaveAccess(db *sql.DB, username, serviceName string) (bool, error)

func GetDriverOptions

func GetDriverOptions() string

func GetGroupsOfService

func GetGroupsOfService(db *sql.DB, serviceName string) (string, error)

func GetGroupsOfUser

func GetGroupsOfUser(db *sql.DB, username string, ownGroups bool) (string, error)

func GetServicesOfGroup

func GetServicesOfGroup(db *sql.DB, groupName string) (string, error)

func GetServicesOfUser

func GetServicesOfUser(db *sql.DB, username string, ownServices bool) (string, error)

func GetSortedDrivers

func GetSortedDrivers() []string

func GetUsersOfGroup

func GetUsersOfGroup(db *sql.DB, groupName string) (string, error)

func GetUsersOfService

func GetUsersOfService(db *sql.DB, serviceName string) (string, error)

func GetdB

func GetdB(driverAsPipefishEnum, name, host string, port int, user, password string) (*sql.DB, error)

func IsUserAdmin

func IsUserAdmin(db *sql.DB, username string) (bool, error)

func IsUserGroupOwner

func IsUserGroupOwner(db *sql.DB, username, groupName string) error

func IsUserInGroup

func IsUserInGroup(db *sql.DB, username, groupName string) (bool, error)

func LetGroupUseService

func LetGroupUseService(db *sql.DB, groupName, serviceName string) error

func LetUserOwnGroup

func LetUserOwnGroup(db *sql.DB, username, groupName string) error

func UnAddUserToGroup

func UnAddUserToGroup(db *sql.DB, username, groupName string) error

func UnLetGroupUseService

func UnLetGroupUseService(db *sql.DB, groupName, serviceName string) error

func UnLetUserOwnGroup

func UnLetUserOwnGroup(db *sql.DB, username, groupName string) error

func UpdateService

func UpdateService(db *sql.DB, username, serviceName string) error

func ValidateUser

func ValidateUser(db *sql.DB, username, password string) (string, error)

Types

type SQLDriver

type SQLDriver uint32

const (
	COCKROACHDB SQLDriver = iota
	FIREBIRD_SQL
	MARIADB
	MICROSOFT_SQL_SERVER
	MYSQL
	ORACLE
	POSTGRESQL
	SNOWFLAKE
	SQLITE
)