db

Documentation

Index

• type Account
• type AccountSession
• type Database
  • func NewDatabase(password string) *Database
  • func (db Database) BeginTransaction() *sqlx.Tx
  • func (db Database) CommitTransaction(tx *sqlx.Tx) error
  • func (db Database) CreateAccount(tx *sqlx.Tx, username string, email string, password string) error
  • func (db Database) CreateAccountSession(tx *sqlx.Tx, key string, account Account) error
  • func (db Database) CreateEmailConfirmation(tx *sqlx.Tx, key string, account Account) error
  • func (db Database) DeleteAccountSession(tx *sqlx.Tx, key string) error
  • func (db Database) DeleteEmailConfirmation(tx *sqlx.Tx, account Account) error
  • func (db Database) GetAccount(id int64) (Account, error)
  • func (db Database) GetAccountByEmail(email string) (Account, error)
  • func (db Database) GetAccountByUsername(username string) (Account, error)
  • func (db Database) GetAccountSession(key string) (AccountSession, error)
  • func (db Database) GetEmailConfirmation(key string) (EmailConfirmation, error)
  • func (db Database) GetSystemConfig() SystemConfig
  • func (db Database) UpdateAccountEmailConfirmed(tx *sqlx.Tx, account Account) error
• type EmailConfirmation
• type SystemConfig

Types

type Account

type Account struct {
	Id             int64
	CreatedAt      time.Time `db:"created_at"`
	Username       string
	EmailAddress   string `db:"email_address"`
	Password       string
	EmailConfirmed bool `db:"email_confirmed"`
}

type AccountSession

type AccountSession struct {
	Key        string
	AccountId  int64     `db:"account_id"`
	LoginTime  time.Time `db:"login_time"`
	LastSeenAt time.Time `db:"last_seen_at"`
}

type Database

type Database struct {
	// contains filtered or unexported fields
}

func NewDatabase

func NewDatabase(password string) *Database

func (Database) BeginTransaction

func (db Database) BeginTransaction() *sqlx.Tx

func (Database) CommitTransaction

func (db Database) CommitTransaction(tx *sqlx.Tx) error

func (Database) CreateAccount

func (db Database) CreateAccount(tx *sqlx.Tx, username string, email string, password string) error

func (Database) CreateAccountSession

func (db Database) CreateAccountSession(tx *sqlx.Tx, key string, account Account) error

func (Database) CreateEmailConfirmation

func (db Database) CreateEmailConfirmation(tx *sqlx.Tx, key string, account Account) error

func (Database) DeleteAccountSession

func (db Database) DeleteAccountSession(tx *sqlx.Tx, key string) error

func (Database) DeleteEmailConfirmation

func (db Database) DeleteEmailConfirmation(tx *sqlx.Tx, account Account) error

func (Database) GetAccount

func (db Database) GetAccount(id int64) (Account, error)

func (Database) GetAccountByEmail

func (db Database) GetAccountByEmail(email string) (Account, error)

func (Database) GetAccountByUsername

func (db Database) GetAccountByUsername(username string) (Account, error)

func (Database) GetAccountSession

func (db Database) GetAccountSession(key string) (AccountSession, error)

func (Database) GetEmailConfirmation

func (db Database) GetEmailConfirmation(key string) (EmailConfirmation, error)

func (Database) GetSystemConfig

func (db Database) GetSystemConfig() SystemConfig

func (Database) UpdateAccountEmailConfirmed

func (db Database) UpdateAccountEmailConfirmed(tx *sqlx.Tx, account Account) error

type EmailConfirmation

type EmailConfirmation struct {
	Key       string
	AccountId int64     `db:"account_id"`
	CreatedAt time.Time `db:"created_at"`
}

type SystemConfig

type SystemConfig struct {
	Id         int
	CreatedAt  time.Time `db:"created_at"`
	ModifiedAt time.Time `db:"modified_at"`
}