sqlite

Documentation

Index

• Constants
• Variables
• func NewAccountStorage(conn *sql.DB) entities.AuthenticationStore
• func NewNullString(s string) sql.NullString

Constants

const (
	TableAccount                 = "auth_accounts"
	TableSession                 = "auth_sessions"
	TableGroup                   = "auth_groups"
	TableAccountGroupAssociation = "auth_accounts_groups_associations"
	TablePasswordResetToken      = "auth_password_reset_tokens"
)

Variables

var (
	Q_InsertAccountQuery   = ""
	Q_GetAccountByID       = ""
	Q_GetAccountByEmail    = ""
	Q_GetAccountByUsername = ""
	Q_UpdateAccountByID    = ""
	Q_DeleteAccountByID    = ""
	Q_GetAccountList       = ""
	Q_GetTotalAccountCount = ""
)

Account

var (
	Q_InsertSession         = ""
	Q_GetSessionByID        = ""
	Q_InvalidateSession     = ""
	Q_GetAccountBySessionID = ""
)

Session

var (
	Q_InsertGroup  = ""
	Q_UpdateGroup  = ""
	Q_DeleteGroup  = ""
	Q_GetGroupByID = ""

	Q_InsertAccountGroupAssociation = ""
	Q_GetGroupsByAccountID          = ""
	Q_CheckAccountGroupAssociation  = ""
	Q_DeleteAccountGroupAssociation = ""
)

Group

var (
	Q_InsertPasswordResetToken       = ""
	Q_GetPasswordResetToken          = ""
	Q_GetAccountByPasswordResetToken = ""
	Q_InvalidateResetToken           = ""
)

PasswordResetToken

Functions

func NewAccountStorage

func NewAccountStorage(conn *sql.DB) entities.AuthenticationStore

func NewNullString

func NewNullString(s string) sql.NullString