db

package

Go to main page

Versions in this module

v1

v1.0.2

Apr 24, 2024

v1.0.1

Apr 20, 2024

v1.0.0

Apr 18, 2024

Changes in this version

type AddOrganizationParams

+ Labquota sql.NullInt32

type AddProfileParams

+ Description string

+ Public bool

type AdminUser

+ LabQuota sql.NullInt32

+ Sid uuid.UUID

type CreateAdminUserParams

+ LabQuota sql.NullInt32

+ type DeleteProfileByNameParams struct

+ Orgname string

+ Profilename string

type GetAdminUserNoPwByUsernameRow

+ LabQuota sql.NullInt32

type GetAdminUsersRow

+ LabQuota sql.NullInt32

type Organization

+ LabQuota sql.NullInt32

type Profile

+ Description string

+ Public bool

type Queries

+ func (q *Queries) DeleteEventById(ctx context.Context, id int32) error

+ func (q *Queries) DeleteProfileById(ctx context.Context, profileid int32) error

+ func (q *Queries) DeleteProfileByName(ctx context.Context, arg DeleteProfileByNameParams) error

+ func (q *Queries) DeleteProfileChallenges(ctx context.Context, profileid int32) error

+ func (q *Queries) GetAdminUserBySid(ctx context.Context, sid string) (AdminUser, error)

+ func (q *Queries) GetAllPublicProfiles(ctx context.Context) ([]Profile, error)

+ func (q *Queries) GetNonSecretPublicProfiles(ctx context.Context) ([]Profile, error)

+ func (q *Queries) GetProfileById(ctx context.Context, id int32) (Profile, error)

+ func (q *Queries) UpdateAdminLabQuota(ctx context.Context, arg UpdateAdminLabQuotaParams) error

+ func (q *Queries) UpdateProfile(ctx context.Context, arg UpdateProfileParams) error

+ type UpdateAdminLabQuotaParams struct

+ Labquota sql.NullInt32

+ Username string

type UpdateOrganizationParams

+ Labquota sql.NullInt32

+ type UpdateProfileParams struct

+ Description string

+ ID int32

+ Orgname string

+ Profilename string

+ Public bool

+ Secret bool

v0

v0.1.0

Mar 16, 2023

Changes in this version

+ type AddEventParams struct

+ Createdby string

+ DynamicMax int32

+ DynamicMin int32

+ DynamicScoring bool

+ DynamicSolveThreshold int32

+ Exercises string

+ FinishExpected time.Time

+ FinishedAt sql.NullTime

+ Frontend string

+ MaxLabs int32

+ Name string

+ Organization string

+ PublicScoreboard bool

+ Secretkey string

+ StartedAt time.Time

+ Status int32

+ Tag string

+ Type int32

+ type AddOrganizationParams struct

+ Org string

+ Owneremail string

+ Ownerusername string

+ type AddProfileChallengeParams struct

+ Name string

+ Profileid int32

+ Tag string

+ type AddProfileParams struct

+ Orgname string

+ Profilename string

+ Secret bool

+ type AddSolveForTeamInEventParams struct

+ Eventid int32

+ Solvedat time.Time

+ Tag string

+ Teamid int32

+ type AddTeamParams struct

+ CreatedAt time.Time

+ Email string

+ EventID int32

+ LastAccess sql.NullTime

+ Password string

+ Tag string

+ Username string

+ type AdminUser struct

+ Email string

+ FullName string

+ ID int32

+ Organization string

+ Password string

+ Role string

+ Username string

+ type Agent struct

+ AuthKey string

+ ID int32

+ Name string

+ SignKey string

+ Statelock bool

+ Tls bool

+ Url string

+ Weight int32

+ type CheckIfProfileExistsParams struct

+ Orgname string

+ Profilename string

+ type CheckIfTeamExistsForEventParams struct

+ Eventid int32

+ Username string

+ type CheckIfUserExistsInOrgParams struct

+ Organization string

+ Username string

+ type CloseEventParams struct

+ Finishedat sql.NullTime

+ Newstatus int32

+ Newtag string

+ Oldtag string

+ type CreateAdminUserParams struct

+ Email string

+ FullName string

+ Organization string

+ Password string

+ Role string

+ Username string

+ type DBTX interface

+ ExecContext func(context.Context, string, ...interface{}) (sql.Result, error)

+ PrepareContext func(context.Context, string) (*sql.Stmt, error)

+ QueryContext func(context.Context, string, ...interface{}) (*sql.Rows, error)

+ QueryRowContext func(context.Context, string, ...interface{}) *sql.Row

+ type DbConfig struct

+ DbName string

+ EventRetention uint16

+ Host string

+ Password string

+ Port uint64

+ Username string

+ func (conf *DbConfig) InitConn() (*Queries, *gorm.DB, error)

+ type DeleteEventOlderThanParams struct

+ Closedstatus int32

+ Numberofdays interface{}

+ type DeleteProfileParams struct

+ Orgname string

+ Profilename string

+ type DeleteTeamParams struct

+ EventID int32

+ Tag string

+ type Event struct

+ Createdby string

+ DynamicMax int32

+ DynamicMin int32

+ DynamicScoring bool

+ DynamicSolveThreshold int32

+ Exercises string

+ FinishExpected time.Time

+ FinishedAt sql.NullTime

+ Frontend string

+ ID int32

+ MaxLabs int32

+ Name string

+ Organization string

+ PublicScoreboard bool

+ Secretkey string

+ StartedAt time.Time

+ Status int32

+ Tag string

+ Type int32

+ type Frontend struct

+ ID int32

+ Image string

+ Memorymb sql.NullInt32

+ Name string

+ type GetAdminUserNoPwByUsernameRow struct

+ Email string

+ FullName string

+ Organization string

+ Role string

+ Username string

+ type GetAdminUsersRow struct

+ Email string

+ FullName string

+ Organization string

+ Role string

+ Username string

+ type GetEventSolvesRow struct

+ SolvedAt time.Time

+ Tag string

+ Username string

+ type GetExercisesInProfileParams struct

+ Orgname string

+ Profileid int32

+ type GetExercisesInProfileRow struct

+ ID int32

+ Name string

+ Tag string

+ type GetOrgEventsByCreatedByParams struct

+ Createdby string

+ Organization string

+ type GetOrgEventsByStatusAndCreatedByParams struct

+ Createdby string

+ Organization string

+ Status int32

+ type GetOrgEventsByStatusParams struct

+ Organization string

+ Status int32

+ type GetProfileByNameAndOrgNameParams struct

+ Orgname string

+ Profilename string

+ type GetSolvesForEventRow struct

+ Date time.Time

+ Tag string

+ Username string

+ type GetTeamFromEventByUsernameNoPwParams struct

+ Eventid int32

+ Username string

+ type GetTeamFromEventByUsernameParams struct

+ Eventid int32

+ Username string

+ type InsertNewAgentParams struct

+ Authkey string

+ Name string

+ Signkey string

+ Tls bool

+ Url string

+ Weight int32

+ type Organization struct

+ ID int32

+ Name string

+ OwnerEmail string

+ OwnerUser string

+ type Profile struct

+ ID int32

+ Name string

+ Organization string

+ Secret bool

+ type ProfileChallenge struct

+ ID int32

+ Name string

+ ProfileID int32

+ Tag string

+ type Queries struct

+ func New(db DBTX) *Queries

+ func (q *Queries) AddEvent(ctx context.Context, arg AddEventParams) (int32, error)

+ func (q *Queries) AddOrganization(ctx context.Context, arg AddOrganizationParams) error

+ func (q *Queries) AddProfile(ctx context.Context, arg AddProfileParams) (int32, error)

+ func (q *Queries) AddProfileChallenge(ctx context.Context, arg AddProfileChallengeParams) error

+ func (q *Queries) AddSolveForTeamInEvent(ctx context.Context, arg AddSolveForTeamInEventParams) error

+ func (q *Queries) AddTeam(ctx context.Context, arg AddTeamParams) error

+ func (q *Queries) CheckIfAgentExists(ctx context.Context, agentname string) (bool, error)

+ func (q *Queries) CheckIfEventExist(ctx context.Context, tag string) (bool, error)

+ func (q *Queries) CheckIfOrgExists(ctx context.Context, orgname string) (bool, error)

+ func (q *Queries) CheckIfProfileExists(ctx context.Context, arg CheckIfProfileExistsParams) (bool, error)

+ func (q *Queries) CheckIfTeamExistsForEvent(ctx context.Context, arg CheckIfTeamExistsForEventParams) (bool, error)

+ func (q *Queries) CheckIfUserExists(ctx context.Context, username string) (bool, error)

+ func (q *Queries) CheckIfUserExistsInOrg(ctx context.Context, arg CheckIfUserExistsInOrgParams) (bool, error)

+ func (q *Queries) CheckIfUserOwnsOrg(ctx context.Context, ownerusername string) (bool, error)

+ func (q *Queries) CloseEvent(ctx context.Context, arg CloseEventParams) error

+ func (q *Queries) CreateAdminUser(ctx context.Context, arg CreateAdminUserParams) error

+ func (q *Queries) DeleteAdminUserByUsername(ctx context.Context, lower string) error

+ func (q *Queries) DeleteAgentByName(ctx context.Context, name string) error

+ func (q *Queries) DeleteEventByTag(ctx context.Context, tag string) error

+ func (q *Queries) DeleteEventOlderThan(ctx context.Context, arg DeleteEventOlderThanParams) error

+ func (q *Queries) DeleteOrganization(ctx context.Context, orgname string) error

+ func (q *Queries) DeleteProfile(ctx context.Context, arg DeleteProfileParams) error

+ func (q *Queries) DeleteTeam(ctx context.Context, arg DeleteTeamParams) error

+ func (q *Queries) GetAdminUserByUsername(ctx context.Context, username string) (AdminUser, error)

+ func (q *Queries) GetAdminUserNoPwByUsername(ctx context.Context, lower string) (GetAdminUserNoPwByUsernameRow, error)

+ func (q *Queries) GetAdminUsers(ctx context.Context, organization interface{}) ([]GetAdminUsersRow, error)

+ func (q *Queries) GetAgentByName(ctx context.Context, name string) (Agent, error)

+ func (q *Queries) GetAgents(ctx context.Context) ([]Agent, error)

+ func (q *Queries) GetAllEvents(ctx context.Context) ([]Event, error)

+ func (q *Queries) GetAllProfilesInOrg(ctx context.Context, orgname string) ([]Profile, error)

+ func (q *Queries) GetEventByTag(ctx context.Context, tag string) (Event, error)

+ func (q *Queries) GetEventSolves(ctx context.Context, eventID int32) ([]GetEventSolvesRow, error)

+ func (q *Queries) GetEventSolvesMap(ctx context.Context, eventId int32) (map[string][]GetSolvesForEventRow, error)

+ func (q *Queries) GetEventStatusByTag(ctx context.Context, tag string) ([]int32, error)

+ func (q *Queries) GetEventsByStatus(ctx context.Context, status int32) ([]Event, error)

+ func (q *Queries) GetEventsByUser(ctx context.Context, createdby string) ([]Event, error)

+ func (q *Queries) GetEventsExeptClosed(ctx context.Context) ([]Event, error)

+ func (q *Queries) GetExercisesInProfile(ctx context.Context, arg GetExercisesInProfileParams) ([]GetExercisesInProfileRow, error)

+ func (q *Queries) GetExpectedFinishDate(ctx context.Context, tag string) (time.Time, error)

+ func (q *Queries) GetNonSecretProfilesInOrg(ctx context.Context, orgname string) ([]Profile, error)

+ func (q *Queries) GetOrgByName(ctx context.Context, orgname string) (Organization, error)

+ func (q *Queries) GetOrgEvents(ctx context.Context, organization string) ([]Event, error)

+ func (q *Queries) GetOrgEventsByCreatedBy(ctx context.Context, arg GetOrgEventsByCreatedByParams) ([]Event, error)

+ func (q *Queries) GetOrgEventsByStatus(ctx context.Context, arg GetOrgEventsByStatusParams) ([]Event, error)

+ func (q *Queries) GetOrgEventsByStatusAndCreatedBy(ctx context.Context, arg GetOrgEventsByStatusAndCreatedByParams) ([]Event, error)

+ func (q *Queries) GetOrganizations(ctx context.Context) ([]Organization, error)

+ func (q *Queries) GetProfileByNameAndOrgName(ctx context.Context, arg GetProfileByNameAndOrgNameParams) (Profile, error)

+ func (q *Queries) GetProfiles(ctx context.Context) ([]Profile, error)

+ func (q *Queries) GetTeamCount(ctx context.Context, eventID int32) ([]int64, error)

+ func (q *Queries) GetTeamFromEventByUsername(ctx context.Context, arg GetTeamFromEventByUsernameParams) (Team, error)

+ func (q *Queries) GetTeamFromEventByUsernameNoPw(ctx context.Context, arg GetTeamFromEventByUsernameNoPwParams) (interface{}, error)

+ func (q *Queries) GetTeamSolvesMap(ctx context.Context, teamid int32) (map[string]bool, error)

+ func (q *Queries) GetTeamsForEvent(ctx context.Context, eventID int32) ([]Team, error)

+ func (q *Queries) InsertNewAgent(ctx context.Context, arg InsertNewAgentParams) error

+ func (q *Queries) UpdateAdminEmail(ctx context.Context, arg UpdateAdminEmailParams) error

+ func (q *Queries) UpdateAdminPassword(ctx context.Context, arg UpdateAdminPasswordParams) error

+ func (q *Queries) UpdateEventStatus(ctx context.Context, arg UpdateEventStatusParams) error

+ func (q *Queries) UpdateExercises(ctx context.Context, arg UpdateExercisesParams) error

+ func (q *Queries) UpdateOrganization(ctx context.Context, arg UpdateOrganizationParams) error

+ func (q *Queries) UpdateTeamPassword(ctx context.Context, arg UpdateTeamPasswordParams) error

+ func (q *Queries) WithTx(tx *sql.Tx) *Queries

+ type Solf struct

+ EventID int32

+ ID int32

+ SolvedAt time.Time

+ Tag string

+ TeamID int32

+ type Team struct

+ CreatedAt time.Time

+ Email string

+ EventID int32

+ ID int32

+ LastAccess sql.NullTime

+ Password string

+ Tag string

+ Username string

+ type UpdateAdminEmailParams struct

+ Email string

+ Username string

+ type UpdateAdminPasswordParams struct

+ Password string

+ Username string

+ type UpdateEventStatusParams struct

+ Status int32

+ Tag string

+ type UpdateExercisesParams struct

+ LastAccess sql.NullTime

+ Tag string

+ type UpdateOrganizationParams struct

+ Orgname string

+ Owneremail string

+ Ownerusername string

+ type UpdateTeamPasswordParams struct

+ EventID int32

+ Password string

+ Tag string

?	: This menu
/	: Search site
f or F	: Jump to
y or Y	: Canonical URL