database

Documentation

Index

• type CachedResponse
• type DB
  • func New(dsn string, automigrate bool) (*DB, error)
  • func (db *DB) GetAllUsers() ([]*UserDisplay, error)
  • func (db *DB) GetCachedResponse(url string) (*CachedResponse, error)
  • func (db *DB) GetUser(id int) (*User, error)
  • func (db *DB) GetUserByEmail(email string) (*User, error)
  • func (db *DB) InsertCachedResponse(url string, payload []byte) (int, error)
  • func (db *DB) InsertUser(email, hashedPassword string) (int, error)
  • func (db *DB) UpdateUserHashedPassword(id int, hashedPassword string) error
• type User
• type UserDisplay

Types

type CachedResponse

type CachedResponse struct {
	ID      int    `db:"id" json:"id"`
	URL     string `db:"url" json:"url"`
	Payload []byte `db:"payload" json:"payload"`
}

type DB

type DB struct {
	*sqlx.DB
}

func New

func New(dsn string, automigrate bool) (*DB, error)

func (*DB) GetAllUsers

func (db *DB) GetAllUsers() ([]*UserDisplay, error)

func (*DB) GetCachedResponse

func (db *DB) GetCachedResponse(url string) (*CachedResponse, error)

func (*DB) GetUser

func (db *DB) GetUser(id int) (*User, error)

func (*DB) GetUserByEmail

func (db *DB) GetUserByEmail(email string) (*User, error)

func (*DB) InsertCachedResponse

func (db *DB) InsertCachedResponse(url string, payload []byte) (int, error)

func (*DB) InsertUser

func (db *DB) InsertUser(email, hashedPassword string) (int, error)

func (*DB) UpdateUserHashedPassword

func (db *DB) UpdateUserHashedPassword(id int, hashedPassword string) error

type User

type User struct {
	ID             int       `db:"id"`
	Created        time.Time `db:"created"`
	Email          string    `db:"email"`
	HashedPassword string    `db:"hashed_password"`
}

type UserDisplay

type UserDisplay struct {
	ID      int       `db:"id"`
	Created time.Time `db:"created"`
	Email   string    `db:"email"`
}