dbo

package
v0.0.44 Latest Latest
Warning

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

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

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
	DbPsid_CountAllUsers                          = 67
	DbPsid_GetListOfAllUsers                      = 68
	DbPsid_CountRegistrationsReadyForApproval     = 69
	DbPsid_GetListOfRegistrationsReadyForApproval = 70
	DbPsid_RejectRegistrationRequest              = 71
	DbPsid_GetUserNameById                        = 72
)

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) CountAllUsers added in v0.0.16 

func (dbo *DatabaseObject) CountAllUsers() (n int, 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) CountRegistrationsReadyForApproval added in v0.0.21 

func (dbo *DatabaseObject) CountRegistrationsReadyForApproval() (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) GetListOfAllUsers added in v0.0.16 

func (dbo *DatabaseObject) GetListOfAllUsers(pageNumber uint, pageSize uint) (userIds []uint, err error)

func (*DatabaseObject) GetListOfLoggedUsers 

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

func (*DatabaseObject) GetListOfRegistrationsReadyForApproval added in v0.0.21 

func (dbo *DatabaseObject) GetListOfRegistrationsReadyForApproval(pageNumber uint, pageSize uint) (rrfas []am.RegistrationReadyForApproval, 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) GetUserNameById added in v0.0.38 

func (dbo *DatabaseObject) GetUserNameById(userId uint) (userName *string, 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) RejectRegistrationRequest added in v0.0.22 

func (dbo *DatabaseObject) RejectRegistrationRequest(id uint) (err error)

func (*DatabaseObject) SaveIncident 

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

func (*DatabaseObject) SaveIncidentWithoutUserIPA 

func (dbo *DatabaseObject) SaveIncidentWithoutUserIPA(module cm.Module, incidentType cm.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.