dbo

package
v0.0.3 Latest Latest
Warning

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

 Go to latest Published: Feb 8, 2024 License: GPL-3.0 Imports: 9 Imported by: 0

Documentation

Index

Constants

View Source 
const (
	TablePreRegisteredUsers = "PreRegisteredUsers"
	TableUsers              = "Users"
	TablePreSessions        = "PreSessions"
	TableSessions           = "Sessions"
	TableIncidents          = "Incidents"
	TablePasswordChanges    = "PasswordChanges"
	TableEmailChanges       = "EmailChanges"
	TableLogEvents          = "LogEvents"
)
View Source 
const (
	DbPsid_CountUsersWithEmail                  = 0
	DbPsid_InsertPreRegisteredUser              = 1
	DbPsid_AttachVerificationCodeToPreRegUser   = 2
	DbPsid_CheckVerificationCodeForPreReg       = 3
	DbPsid_DeletePreRegUserIfNotApprovedByEmail = 4
	DbPsid_ApprovePreRegUserEmail               = 5
	DbPsid_SetPreRegUserData                    = 6
	DbPsid_ApprovePreRegUser                    = 7
	DbPsid_RegisterPreRegUserP1                 = 8
	DbPsid_RegisterPreRegUserP2                 = 9
	DbPsid_CountUsersWithName                   = 10
	DbPsid_ClearPreRegUsersTable                = 11
	DbPsid_CountUsersWithEmailAbleToLogIn       = 12
	DbPsid_DeleteAbandonedPreSessions           = 13
	DbPsid_CountSessionsByUserEmail             = 14
	DbPsid_CountPreSessionsByUserEmail          = 15
	DbPsid_GetUserLastBadLogInTimeByEmail       = 16
	DbPsid_CreatePreSession                     = 17
	DbPsid_GetUserIdByEmail                     = 18
	DbPsid_UpdateUserLastBadLogInTimeByEmail    = 19
	DbPsid_GetPreSessionByRequestId             = 20
	DbPsid_GetUserPasswordById                  = 21
	DbPsid_DeletePreSessionByRequestId          = 22
	DbPsid_SetPreSessionCaptchaFlag             = 23
	DbPsid_SetPreSessionPasswordFlag            = 24
	DbPsid_AttachVerificationCodeToPreSession   = 25
	DbPsid_UpdatePreSessionRequestId            = 26
	DbPsid_CheckVerificationCodeForLogIn        = 27
	DbPsid_SetPreSessionVerificationFlag        = 28
	DbPsid_CreateSession                        = 29
	DbPsid_ClearSessions                        = 30
	DbPsid_GetUserById                          = 31
	DbPsid_GetSessionByUserId                   = 32
	DbPsid_DeleteSession                        = 33
	DbPsid_SaveIncident                         = 34
	DbPsid_SaveIncidentWithoutUserIPA           = 35
	DbPsid_GetListOfLoggedUsers                 = 36
	DbPsid_CountSessionsByUserId                = 37
	DbPsid_GetUserRolesById                     = 38
	DbPsid_GetUserParametersById                = 39
	DbPsid_SetUserRoleAuthor                    = 40
	DbPsid_SetUserRoleWriter                    = 41
	DbPsid_SetUserRoleReader                    = 42
	DbPsid_SetUserRoleCanLogIn                  = 43
	DbPsid_DeleteSessionByUserId                = 44
	DbPsid_UpdateUserBanTime                    = 45
	DbPsid_SetPreRegUserEmailSendStatus         = 46
	DbPsid_SetPreSessionEmailSendStatus         = 47
	DbPsid_ClearPasswordChangesTable            = 48
	DbPsid_CountPasswordChangesByUserId         = 49
	DbPsid_UpdateUserLastBadActionTimeById      = 50
	DbPsid_GetUserLastBadActionTimeById         = 51
	DbPsid_CreatePasswordChangeRequest          = 52
	DbPsid_GetPasswordChangeByRequestId         = 53
	DbPsid_DeletePasswordChangeByRequestId      = 54
	DbPsid_CheckVerificationCodeForPwdChange    = 55
	DbPsid_SetPasswordChangeVFlags              = 56
	DbPsid_SetUserPassword                      = 57
	DbPsid_CountEmailChangesByUserId            = 58
	DbPsid_CreateEmailChangeRequest             = 59
	DbPsid_GetEmailChangeByRequestId            = 60
	DbPsid_DeleteEmailChangeByRequestId         = 61
	DbPsid_CheckVerificationCodesForEmailChange = 62
	DbPsid_SetEmailChangeVFlags                 = 63
	DbPsid_SetUserEmail                         = 64
	DbPsid_SaveLogEvent                         = 65
	DbPsid_ClearEmailChangesTable               = 66
)

Indices of prepared statements.

Variables

This section is empty.

Functions

This section is empty.

Types

type DatabaseObject 

type DatabaseObject struct {
	cdbo.DatabaseObject
	// contains filtered or unexported fields
}

func NewDatabaseObject 

func NewDatabaseObject(settings as.DbSettings, sp SystemParameters) (dbo *DatabaseObject)

func (*DatabaseObject) ApprovePreRegUser 

func (dbo *DatabaseObject) ApprovePreRegUser(email string) (err error)

func (*DatabaseObject) ApproveUserByEmail 

func (dbo *DatabaseObject) ApproveUserByEmail(email string) (err error)

func (*DatabaseObject) AttachVerificationCodeToPreRegUser 

func (dbo *DatabaseObject) AttachVerificationCodeToPreRegUser(email string, code string) (err error)

func (*DatabaseObject) AttachVerificationCodeToPreSession 

func (dbo *DatabaseObject) AttachVerificationCodeToPreSession(userId uint, requestId string, code string) (err error)

func (*DatabaseObject) CheckVerificationCodeForLogIn 

func (dbo *DatabaseObject) CheckVerificationCodeForLogIn(requestId string, code string) (ok bool, err error)

func (*DatabaseObject) CheckVerificationCodeForPreReg 

func (dbo *DatabaseObject) CheckVerificationCodeForPreReg(email, code string) (ok bool, err error)

func (*DatabaseObject) CheckVerificationCodeForPwdChange 

func (dbo *DatabaseObject) CheckVerificationCodeForPwdChange(requestId string, code string) (ok bool, err error)

func (*DatabaseObject) CheckVerificationCodesForEmailChange 

func (dbo *DatabaseObject) CheckVerificationCodesForEmailChange(requestId string, codeOld string, codeNew string) (ok bool, err error)

func (*DatabaseObject) CountEmailChangesByUserId 

func (dbo *DatabaseObject) CountEmailChangesByUserId(userId uint) (n int, err error)

func (*DatabaseObject) CountPasswordChangesByUserId 

func (dbo *DatabaseObject) CountPasswordChangesByUserId(userId uint) (n int, err error)

func (*DatabaseObject) CountPreSessionsByUserEmail 

func (dbo *DatabaseObject) CountPreSessionsByUserEmail(email string) (n int, err error)

func (*DatabaseObject) CountSessionsByUserEmail 

func (dbo *DatabaseObject) CountSessionsByUserEmail(email string) (n int, err error)

func (*DatabaseObject) CountSessionsByUserId 

func (dbo *DatabaseObject) CountSessionsByUserId(userId uint) (n int, err error)

func (*DatabaseObject) CountUsersWithEmail 

func (dbo *DatabaseObject) CountUsersWithEmail(email string) (n int, err error)

func (*DatabaseObject) CountUsersWithEmailAbleToLogIn 

func (dbo *DatabaseObject) CountUsersWithEmailAbleToLogIn(email string) (n int, err error)

func (*DatabaseObject) CountUsersWithName 

func (dbo *DatabaseObject) CountUsersWithName(name string) (n int, err error)

func (*DatabaseObject) CreateEmailChangeRequest 

func (dbo *DatabaseObject) CreateEmailChangeRequest(ecr *am.EmailChange) (err error)

func (*DatabaseObject) CreatePasswordChangeRequest 

func (dbo *DatabaseObject) CreatePasswordChangeRequest(pcr *am.PasswordChange) (err error)

func (*DatabaseObject) CreatePreSession 

func (dbo *DatabaseObject) CreatePreSession(userId uint, requestId string, userIPAB net.IP, pwdSalt []byte, isCaptchaRequired bool, captchaId sql.NullString) (err error)

func (*DatabaseObject) CreateSession 

func (dbo *DatabaseObject) CreateSession(userId uint, userIPAB net.IP) (lastInsertedId int64, err error)

func (*DatabaseObject) DeleteAbandonedPreSessions 

func (dbo *DatabaseObject) DeleteAbandonedPreSessions() (err error)

func (*DatabaseObject) DeleteEmailChangeByRequestId 

func (dbo *DatabaseObject) DeleteEmailChangeByRequestId(requestId string) (err error)

func (*DatabaseObject) DeletePasswordChangeByRequestId 

func (dbo *DatabaseObject) DeletePasswordChangeByRequestId(requestId string) (err error)

func (*DatabaseObject) DeletePreRegUserIfNotApprovedByEmail 

func (dbo *DatabaseObject) DeletePreRegUserIfNotApprovedByEmail(email string) (err error)

func (*DatabaseObject) DeletePreSessionByRequestId 

func (dbo *DatabaseObject) DeletePreSessionByRequestId(requestId string) (err error)

func (*DatabaseObject) DeleteSession 

func (dbo *DatabaseObject) DeleteSession(sessionId uint, userId uint, userIPAB net.IP) (err error)

func (*DatabaseObject) DeleteSessionByUserId 

func (dbo *DatabaseObject) DeleteSessionByUserId(userId uint) (err error)

func (*DatabaseObject) GetEmailChangeByRequestId 

func (dbo *DatabaseObject) GetEmailChangeByRequestId(requestId string) (ecr *am.EmailChange, err error)

func (*DatabaseObject) GetListOfLoggedUsers 

func (dbo *DatabaseObject) GetListOfLoggedUsers() (userIds []uint, err error)

func (*DatabaseObject) GetPasswordChangeByRequestId 

func (dbo *DatabaseObject) GetPasswordChangeByRequestId(requestId string) (pcr *am.PasswordChange, err error)

func (*DatabaseObject) GetPreSessionByRequestId 

func (dbo *DatabaseObject) GetPreSessionByRequestId(requestId string) (preSession *am.PreSession, err error)

func (*DatabaseObject) GetPreparedStatementByIndex 

func (dbo *DatabaseObject) GetPreparedStatementByIndex(i int) (ps *sql.Stmt)

func (*DatabaseObject) GetSessionByUserId 

func (dbo *DatabaseObject) GetSessionByUserId(userId uint) (session *am.Session, err error)

func (*DatabaseObject) GetUserById 

func (dbo *DatabaseObject) GetUserById(userId uint) (user *am.User, err error)

func (*DatabaseObject) GetUserIdByEmail 

func (dbo *DatabaseObject) GetUserIdByEmail(email string) (id uint, err error)

func (*DatabaseObject) GetUserLastBadActionTimeById 

func (dbo *DatabaseObject) GetUserLastBadActionTimeById(userId uint) (lastBadActionTime *time.Time, err error)

func (*DatabaseObject) GetUserLastBadLogInTimeByEmail 

func (dbo *DatabaseObject) GetUserLastBadLogInTimeByEmail(email string) (lastBadLogInTime *time.Time, err error)

func (*DatabaseObject) GetUserPasswordById 

func (dbo *DatabaseObject) GetUserPasswordById(userId uint) (password *[]byte, err error)

func (*DatabaseObject) GetUserRolesById 

func (dbo *DatabaseObject) GetUserRolesById(userId uint) (roles *cm.UserRoles, err error)

func (*DatabaseObject) Init 

func (dbo *DatabaseObject) Init() (err error)

Init connects to the database, initialises the tables and prepares SQL statements.

func (*DatabaseObject) InsertPreRegisteredUser 

func (dbo *DatabaseObject) InsertPreRegisteredUser(email string) (err error)

func (*DatabaseObject) RegisterPreRegUser 

func (dbo *DatabaseObject) RegisterPreRegUser(email string) (err error)

func (*DatabaseObject) SaveIncident 

func (dbo *DatabaseObject) SaveIncident(incidentType am.IncidentType, email string, userIPAB net.IP) (err error)

func (*DatabaseObject) SaveIncidentWithoutUserIPA 

func (dbo *DatabaseObject) SaveIncidentWithoutUserIPA(incidentType am.IncidentType, email string) (err error)

func (*DatabaseObject) SaveLogEvent 

func (dbo *DatabaseObject) SaveLogEvent(logEvent *am.LogEvent) (err error)

func (*DatabaseObject) SetEmailChangeVFlags 

func (dbo *DatabaseObject) SetEmailChangeVFlags(userId uint, requestId string, ecvf *am.EmailChangeVerificationFlags) (err error)

func (*DatabaseObject) SetPasswordChangeVFlags 

func (dbo *DatabaseObject) SetPasswordChangeVFlags(userId uint, requestId string, pcvf *am.PasswordChangeVerificationFlags) (err error)

func (*DatabaseObject) SetPreRegUserData 

func (dbo *DatabaseObject) SetPreRegUserData(email string, code string, name string, password []byte) (err error)

func (*DatabaseObject) SetPreRegUserEmailSendStatus 

func (dbo *DatabaseObject) SetPreRegUserEmailSendStatus(emailSendStatus bool, email string) (err error)

func (*DatabaseObject) SetPreSessionCaptchaFlags 

func (dbo *DatabaseObject) SetPreSessionCaptchaFlags(userId uint, requestId string, isVerifiedByCaptcha bool) (err error)

func (*DatabaseObject) SetPreSessionEmailSendStatus 

func (dbo *DatabaseObject) SetPreSessionEmailSendStatus(userId uint, requestId string, emailSendStatus bool) (err error)

func (*DatabaseObject) SetPreSessionPasswordFlag 

func (dbo *DatabaseObject) SetPreSessionPasswordFlag(userId uint, requestId string, isVerifiedByPassword bool) (err error)

func (*DatabaseObject) SetPreSessionVerificationFlag 

func (dbo *DatabaseObject) SetPreSessionVerificationFlag(userId uint, requestId string, isVerifiedByEmail bool) (err error)

func (*DatabaseObject) SetUserEmail 

func (dbo *DatabaseObject) SetUserEmail(userId uint, email string, newEmail string) (err error)

func (*DatabaseObject) SetUserPassword 

func (dbo *DatabaseObject) SetUserPassword(userId uint, email string, newPassword []byte) (err error)

func (*DatabaseObject) SetUserRoleAuthor 

func (dbo *DatabaseObject) SetUserRoleAuthor(userId uint, isRoleEnabled bool) (err error)

func (*DatabaseObject) SetUserRoleCanLogIn 

func (dbo *DatabaseObject) SetUserRoleCanLogIn(userId uint, isRoleEnabled bool) (err error)

func (*DatabaseObject) SetUserRoleReader 

func (dbo *DatabaseObject) SetUserRoleReader(userId uint, isRoleEnabled bool) (err error)

func (*DatabaseObject) SetUserRoleWriter 

func (dbo *DatabaseObject) SetUserRoleWriter(userId uint, isRoleEnabled bool) (err error)

func (*DatabaseObject) UpdatePreSessionRequestId 

func (dbo *DatabaseObject) UpdatePreSessionRequestId(userId uint, requestIdOld string, requestIdNew string) (err error)

func (*DatabaseObject) UpdateUserBanTime 

func (dbo *DatabaseObject) UpdateUserBanTime(userId uint) (err error)

func (*DatabaseObject) UpdateUserLastBadActionTimeById 

func (dbo *DatabaseObject) UpdateUserLastBadActionTimeById(userId uint) (err error)

func (*DatabaseObject) UpdateUserLastBadLogInTimeByEmail 

func (dbo *DatabaseObject) UpdateUserLastBadLogInTimeByEmail(email string) (err error)

func (*DatabaseObject) ViewUserParametersById 

func (dbo *DatabaseObject) ViewUserParametersById(userId uint) (userParameters *cm.UserParameters, err error)

type SystemParameters 

type SystemParameters struct {
	PreSessionExpirationTime uint
}

SystemParameters stores various system parameters not directly related to the database.

type TableNames 

type TableNames struct {
	PreRegisteredUsers string
	Users              string
	PreSessions        string
	Sessions           string
	Incidents          string
	PasswordChanges    string
	EmailChanges       string
	LogEvents          string
}

Source Files

View all Source files

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL
go.dev uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Learn more.