users

Documentation

Overview

Package users demonstrates how to extend sqlcredo with custom SQL queries. It provides a complete example of a user repository that includes standard CRUD operations and a custom query method for counting users based on whether they have a last name.

Index

• Constants
• type Article
• type ArticlesRepo
  • func NewArticlesRepo(db *sql.DB, driver string, debugFunc sc.DebugFunc) *ArticlesRepo
  • func (r *ArticlesRepo) DeleteByUserID(ctx context.Context, userID Identity) (sql.Result, error)
  • func (r *ArticlesRepo) GetByUserID(ctx context.Context, userID Identity) ([]Article, error)
  • func (r *ArticlesRepo) WithTxx(txExec sc.SQLExecutor) *ArticlesRepo
• type CountByLastNameExistsCategory
• type Identity
• type Repo
  • func NewRepo(db *sql.DB, driver string, debugFunc sc.DebugFunc) *Repo
  • func (r *Repo) Articles() *ArticlesRepo
  • func (r *Repo) CountByLastNameExists(ctx context.Context) (map[string]int, error)
  • func (r *Repo) CreateWithArticle(ctx context.Context, user *User, article *Article) error
  • func (r *Repo) DeleteWithArticles(ctx context.Context, id Identity) error
  • func (r *Repo) GetWithArticles(ctx context.Context, dest *User, id Identity) error
  • func (r *Repo) WithTxx(txExec sc.SQLExecutor) *Repo
• type User
  • func (u *User) String() string

Constants

const (
	TableName = "users"
	IDColumn  = "id"
)

const CountByLastNameExistsQuery = `` /* 191-byte string literal not displayed */

Types

type Article

type Article struct {
	ID        Identity  `db:"id"`
	Title     string    `db:"title"`
	CreatedAt time.Time `db:"created_at"`
	UserID    Identity  `db:"user_id"`
}

type ArticlesRepo

type ArticlesRepo struct {
	sc.SQLCredo[Article, Identity]
}

func NewArticlesRepo

func NewArticlesRepo(db *sql.DB, driver string, debugFunc sc.DebugFunc) *ArticlesRepo

func (*ArticlesRepo) DeleteByUserID

func (r *ArticlesRepo) DeleteByUserID(ctx context.Context, userID Identity) (sql.Result, error)

func (*ArticlesRepo) GetByUserID

func (r *ArticlesRepo) GetByUserID(ctx context.Context, userID Identity) ([]Article, error)

func (*ArticlesRepo) WithTxx

func (r *ArticlesRepo) WithTxx(txExec sc.SQLExecutor) *ArticlesRepo

type CountByLastNameExistsCategory

type CountByLastNameExistsCategory struct {
	Name  string `db:"category"`
	Count int    `db:"cnt"`
}

type Identity

type Identity string

type Repo

type Repo struct {
	sc.SQLCredo[User, Identity]
	// contains filtered or unexported fields
}

func NewRepo

func NewRepo(db *sql.DB, driver string, debugFunc sc.DebugFunc) *Repo

func (*Repo) Articles

func (r *Repo) Articles() *ArticlesRepo

func (*Repo) CountByLastNameExists

func (r *Repo) CountByLastNameExists(ctx context.Context) (map[string]int, error)

func (*Repo) CreateWithArticle

func (r *Repo) CreateWithArticle(ctx context.Context, user *User, article *Article) error

func (*Repo) DeleteWithArticles

func (r *Repo) DeleteWithArticles(ctx context.Context, id Identity) error

func (*Repo) GetWithArticles

func (r *Repo) GetWithArticles(ctx context.Context, dest *User, id Identity) error

func (*Repo) WithTxx

func (r *Repo) WithTxx(txExec sc.SQLExecutor) *Repo

type User

type User struct {
	ID        Identity  `db:"id"`
	FirstName string    `db:"first_name"`
	LastName  *string   `db:"last_name"`
	BirthDate time.Time `db:"birth_date"`
	Articles  []Article `db:"-"`
}

func (*User) String

func (u *User) String() string