autohosterdb

Documentation

Index

• type Account
  • func GetAccounts(ctx context.Context, db *pgxpool.Pool) ([]*Account, error)
• type Announcement
  • func AddAnnouncement(ctx context.Context, db *pgxpool.Pool) ([]*Announcement, error)
  • func GetAnnouncements(ctx context.Context, db *pgxpool.Pool) ([]*Announcement, error)
  • func GetLastAnnouncements(ctx context.Context, db *pgxpool.Pool, n int) ([]*Announcement, error)
• type Identity
  • func GetIdentities(ctx context.Context, db *pgxpool.Pool) ([]*Identity, error)
  • func GetUserIdentities(ctx context.Context, db *pgxpool.Pool, userID int) ([]*Identity, error)

Types

type Account

type Account struct {
	ID               int
	Username         string
	Email            string
	AccountCreated   time.Time
	LastSeen         time.Time
	Terminated       bool
	EmailConfirmed   *time.Time
	AllowHostRequest bool
	BypasssISPBan    bool `db:"bypass_ispban"`
	DisplayName      *string
	LastReport       time.Time
	LastRequest      time.Time
}

func GetAccounts

func GetAccounts(ctx context.Context, db *pgxpool.Pool) ([]*Account, error)

type Announcement

type Announcement struct {
	ID         int
	Title      string
	Content    template.HTML
	WhenPosted time.Time
	Color      string
}

func AddAnnouncement

func AddAnnouncement(ctx context.Context, db *pgxpool.Pool) ([]*Announcement, error)

func GetAnnouncements

func GetAnnouncements(ctx context.Context, db *pgxpool.Pool) ([]*Announcement, error)

func GetLastAnnouncements

func GetLastAnnouncements(ctx context.Context, db *pgxpool.Pool, n int) ([]*Announcement, error)

type Identity

type Identity struct {
	ID      int
	Name    string
	Pkey    []byte
	Hash    string
	Account int
}

func GetIdentities

func GetIdentities(ctx context.Context, db *pgxpool.Pool) ([]*Identity, error)

func GetUserIdentities

func GetUserIdentities(ctx context.Context, db *pgxpool.Pool, userID int) ([]*Identity, error)