dao

Documentation

Index

• func WithDB(ctx context.Context, db DB) context.Context
• type DB
  • func GetDB(ctx context.Context) DB
• type Login
  • func NewLogin() *Login
  • func (l *Login) Create(ctx context.Context, login model.Login) (int64, error)
  • func (l *Login) DeleteByID(ctx context.Context, id int64) error
  • func (l *Login) GetByAccount(ctx context.Context, account string) (model.Login, error)
  • func (l *Login) GetByID(ctx context.Context, id int64) (model.Login, error)
  • func (l *Login) InitTable(ctx context.Context) error
• type Token
  • func NewToken() *Token
  • func (t *Token) Create(ctx context.Context, token model.Token) (int64, error)
  • func (t *Token) DeleteByID(ctx context.Context, tokenID, userID int64) error
  • func (t *Token) GetByAccount(ctx context.Context, account, password string) (model.Token, error)
  • func (t *Token) GetByID(ctx context.Context, tokenID, userID int64) (model.Token, error)
  • func (t *Token) GetByUserID(ctx context.Context, userID int64) ([]model.Token, error)
  • func (t *Token) InitTable(ctx context.Context) error
• type User
  • func NewUser() *User
  • func (c *User) Create(ctx context.Context, u model.User) (int64, error)
  • func (c *User) GetByID(ctx context.Context, id int64) (model.User, error)
  • func (c *User) InitTable(ctx context.Context) error
  • func (c *User) UpdateNickname(ctx context.Context, id int64, nickname string) error

Functions

func WithDB

func WithDB(ctx context.Context, db DB) context.Context

WithDB returns a new context with the given database connection.

Types

type DB

type DB interface {
	ExecContext(ctx context.Context, query string, args ...any) (sql.Result, error)
	QueryContext(ctx context.Context, query string, args ...any) (*sql.Rows, error)
	QueryRowContext(ctx context.Context, query string, args ...any) *sql.Row
}

func GetDB

func GetDB(ctx context.Context) DB

GetDB retrieves the database connection from the context.

type Login

type Login struct{}

func NewLogin

func NewLogin() *Login

func (*Login) Create

func (l *Login) Create(ctx context.Context, login model.Login) (int64, error)

func (*Login) DeleteByID

func (l *Login) DeleteByID(ctx context.Context, id int64) error

func (*Login) GetByAccount

func (l *Login) GetByAccount(ctx context.Context, account string) (model.Login, error)

func (*Login) GetByID

func (l *Login) GetByID(ctx context.Context, id int64) (model.Login, error)

func (*Login) InitTable

func (l *Login) InitTable(ctx context.Context) error

type Token

type Token struct{}

func NewToken

func NewToken() *Token

func (*Token) Create

func (t *Token) Create(ctx context.Context, token model.Token) (int64, error)

func (*Token) DeleteByID

func (t *Token) DeleteByID(ctx context.Context, tokenID, userID int64) error

func (*Token) GetByAccount

func (t *Token) GetByAccount(ctx context.Context, account, password string) (model.Token, error)

func (*Token) GetByID

func (t *Token) GetByID(ctx context.Context, tokenID, userID int64) (model.Token, error)

func (*Token) GetByUserID

func (t *Token) GetByUserID(ctx context.Context, userID int64) ([]model.Token, error)

func (*Token) InitTable

func (t *Token) InitTable(ctx context.Context) error

type User

type User struct{}

func NewUser

func NewUser() *User

func (*User) Create

func (c *User) Create(ctx context.Context, u model.User) (int64, error)

func (*User) GetByID

func (c *User) GetByID(ctx context.Context, id int64) (model.User, error)

func (*User) InitTable

func (c *User) InitTable(ctx context.Context) error

func (*User) UpdateNickname

func (c *User) UpdateNickname(ctx context.Context, id int64, nickname string) error