db

package
v0.0.0-...-5d1f219 Latest Latest
Warning

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

 Go to latest Published: May 5, 2026 License: MIT Imports: 11 Imported by: 0

Documentation

Index

Constants

View Source 
const (
	ApplicantWriteRequest = `` /* 303-byte string literal not displayed */

	ApplicantReadRequest = `` /* 211-byte string literal not displayed */

	ApplicantReadRequestByID = `` /* 225-byte string literal not displayed */

	ApplicantUpdateRequest = `` /* 299-byte string literal not displayed */

	ApplicantReadRequestByTeamName = `` /* 232-byte string literal not displayed */

	AccountWriteRequest = `` /* 171-byte string literal not displayed */

	AccountReadRequest = `
		SELECT key, fullname, date_of_birth, role, id, password, username, email, phone_number, salt
		FROM konti`

	AccountReadRequestByUsername = `` /* 128-byte string literal not displayed */

	AccountReadRequestByFullname = `` /* 128-byte string literal not displayed */

	AccountReadRequestByDateOfBirth = `` /* 133-byte string literal not displayed */

	AccountReadRequestByKey = `
		SELECT key, fullname, date_of_birth, role, id, password, username, email, phone_number, salt
		FROM konti WHERE key = $1`

	AccountUpdateRequest = `` /* 169-byte string literal not displayed */

	AccountApplicationWriteRequest = `` /* 178-byte string literal not displayed */

	AccountApplicationReadRequest = `
		SELECT fullname, date_of_birth, role, password, username, email, phone_number, team_name, key
		FROM kontu_pieteikumi`

	AccountApplicationReadRequestByKey = `` /* 135-byte string literal not displayed */

	AccountApplicationDeleteRequestByKey = `
		DELETE FROM kontu_pieteikumi WHERE key = $1`

	AdminAccountWriteRequest = `
		INSERT INTO admini (
			username, password, salt, superadmin, key
		) VALUES (
			$1, $2, $3, $4, $5
		)`

	AdminAccountReadRequest = `
		SELECT username, password, salt, superadmin, key
		FROM admini`

	AdminAccountReadRequestByUsername = `
		SELECT username, password, salt, superadmin, key
		FROM admini WHERE username = $1`

	AdminAccountReadRequestByKey = `
		SELECT username, password, salt, superadmin, key
		FROM admini WHERE key = $1`

	AdminAccountUpdateRequest = `
		UPDATE admini SET
			username = $1, password = $2, salt = $3, superadmin = $4
		WHERE key = $5`

	TeamDataReadRequestByKey = `` /* 159-byte string literal not displayed */

	TeamDataUpdateRequest = `` /* 199-byte string literal not displayed */

	TeamMembersWriteRequest = `UPDATE komandas SET team_members = $1 WHERE key = $2`

	TeamDataWriteRequest = `` /* 192-byte string literal not displayed */

)

Variables

View Source 
var Pool *pgxpool.Pool

Functions

func DeleteAllAccountApplications 

func DeleteAllAccountApplications(ctx context.Context) error

func DeleteAllAccounts 

func DeleteAllAccounts(ctx context.Context) error

func DeleteAllAdmins 

func DeleteAllAdmins(ctx context.Context) error

func DeleteAllApplications 

func DeleteAllApplications(ctx context.Context) error

func DeleteSeedData 

func DeleteSeedData(ctx context.Context) error

func MigrateDown 

func MigrateDown(ctx context.Context, dbURL string) error

func MigrateUp 

func MigrateUp(ctx context.Context, dbURL string) error

func SeedTestData 

func SeedTestData(ctx context.Context) error

Types

type RealDB 

type RealDB struct{}

func (*RealDB) AssignAccountsToTeamDataByUsername 

func (DB *RealDB) AssignAccountsToTeamDataByUsername(ctx context.Context, teamKey string, accountUsernames []string) error

func (*RealDB) DeleteAccountApplicationByKey 

func (DB *RealDB) DeleteAccountApplicationByKey(ctx context.Context, key string) error

func (*RealDB) GetAccountApplicationByKey 

func (DB *RealDB) GetAccountApplicationByKey(ctx context.Context, key string) (*models.AccountApplication, error)

func (*RealDB) GetAccountApplications 

func (DB *RealDB) GetAccountApplications(ctx context.Context) ([]models.AccountApplication, error)

func (*RealDB) GetAccountByDateOfBirth 

func (DB *RealDB) GetAccountByDateOfBirth(ctx context.Context, dateOfBirth string) (*models.Account, error)

func (*RealDB) GetAccountByFullname 

func (DB *RealDB) GetAccountByFullname(ctx context.Context, fullname string) (*models.Account, error)

func (*RealDB) GetAccountByKey 

func (DB *RealDB) GetAccountByKey(ctx context.Context, key string) (*models.Account, error)

func (*RealDB) GetAccountByUsername 

func (DB *RealDB) GetAccountByUsername(ctx context.Context, username string) (*models.Account, error)

func (*RealDB) GetAccounts 

func (DB *RealDB) GetAccounts(ctx context.Context) ([]models.Account, error)

func (*RealDB) GetAccountsByKey 

func (DB *RealDB) GetAccountsByKey(ctx context.Context, key string) ([]models.Account, error)

func (*RealDB) GetAdminAccountByKey 

func (DB *RealDB) GetAdminAccountByKey(ctx context.Context, key string) (*models.AdminAccount, error)

func (*RealDB) GetAdminAccountByUsername 

func (DB *RealDB) GetAdminAccountByUsername(ctx context.Context, username string) (*models.AdminAccount, error)

func (*RealDB) GetAllAdmins 

func (DB *RealDB) GetAllAdmins(ctx context.Context) ([]models.AdminAccount, error)

func (*RealDB) GetAllApplications 

func (DB *RealDB) GetAllApplications(ctx context.Context) ([]models.RegistrationFormData, error)

func (*RealDB) GetApplicationByID 

func (DB *RealDB) GetApplicationByID(ctx context.Context, id string) (*models.RegistrationFormData, error)

func (*RealDB) GetApplicationByTeamName 

func (DB *RealDB) GetApplicationByTeamName(ctx context.Context, teamName string) (*models.RegistrationFormData, error)

func (*RealDB) GetTeamDataByKey 

func (DB *RealDB) GetTeamDataByKey(ctx context.Context, key string) (*models.TeamData, error)

func (*RealDB) RegisterNewAccount 

func (DB *RealDB) RegisterNewAccount(ctx context.Context, newAccount models.Account) error

func (*RealDB) RegisterNewAccountApplication 

func (DB *RealDB) RegisterNewAccountApplication(ctx context.Context, newAccountApplication models.AccountApplication) error

func (*RealDB) RegisterNewAdmin 

func (DB *RealDB) RegisterNewAdmin(ctx context.Context, newAccount models.AdminAccount) error

func (*RealDB) RegisterNewApplication 

func (DB *RealDB) RegisterNewApplication(ctx context.Context, newApplicant models.RegistrationFormData) error

func (*RealDB) RegisterTeamData 

func (DB *RealDB) RegisterTeamData(ctx context.Context, newTeamData models.TeamData) error

func (*RealDB) TestHealthiness 

func (DB *RealDB) TestHealthiness(ctx context.Context) error

func (*RealDB) UpdateAccount 

func (DB *RealDB) UpdateAccount(ctx context.Context, updatedAccount models.Account) error

func (*RealDB) UpdateAdminAccount 

func (DB *RealDB) UpdateAdminAccount(ctx context.Context, updatedAccount models.AdminAccount) error

func (*RealDB) UpdateApplication 

func (DB *RealDB) UpdateApplication(ctx context.Context, updatedApplicant models.RegistrationFormData) error

func (*RealDB) UpdateTeamDataByKey 

func (DB *RealDB) UpdateTeamDataByKey(ctx context.Context, key string, updatedData models.TeamData) error

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.