repository

Documentation

Index

• Constants
• type Repository
  • func New(lg *zap.Logger, rdbms rdbms.RDBMS) Repository

Constants

const QueryCreateUser = `INSERT INTO users(first_name, last_name, email, password) VALUES($1, $2, $3, $4) RETURNING id;`

const QueryDeleteUser = "DELETE FROM users WHERE id=$1;"

const QueryFindUserByEmail = `
	SELECT id, first_name, last_name, password, created_at
	FROM users
	WHERE email=$1;`

const QueryFindUserByEmailAndPassword = "SELECT id, first_name, last_name, created_at FROM users WHERE email=$1 AND password=$2;"

const QueryFindUserById = "SELECT first_name, last_name, email, password, created_at FROM users WHERE id=$1;"

const QueryUpdateUser = "UPDATE users SET first_name=?, last_name=?, password=? WHERE id=$1;"

Types

type Repository

type Repository interface {
	MigrateUp(context.Context) error

	MigrateDown(context.Context) error

	CreateUser(ctx context.Context, user *models.User) error

	FindUserById(ctx context.Context, id uint64) (*models.User, error)

	FindUserByEmail(ctx context.Context, email string) (*models.User, error)

	FindUserByEmailAndPassword(ctx context.Context, email, password string) (*models.User, error)

	// UpdateUser will only updates the first_name and last_name or password
	UpdateUser(ctx context.Context, user *models.User) error

	DeleteUser(ctx context.Context, user *models.User) error
}

func New

func New(lg *zap.Logger, rdbms rdbms.RDBMS) Repository