authors

Documentation

Index

• Constants
• type Config
  • func (c Config) Default() *Config
• type Repository
  • func New(logger *zap.Logger, config *Config, rdbms rdbms.RDBMS) Repository

Constants

const QueryGetAll = `
SELECT id, full_name
FROM authors 
WHERE 
	id > $1 AND
	name LIKE '%' || $2 || '%'
ORDER BY id
FETCH NEXT $3 ROWS ONLY;`

const QueryGetDetail = `
SELECT full_name
FROM authors 
WHERE id=$1;`

const QueryInsert = `
INSERT INTO 
	authors(full_name) 
	VALUES($1) 
RETURNING id;`

Types

type Config

type Config struct {
	CursorSecret string `koanf:"cursor_secret"`
	Limit        struct {
		Min int `koanf:"min"`
		Max int `koanf:"max"`
	} `koanf:"limit"`
}

func (Config) Default

func (c Config) Default() *Config

type Repository

type Repository interface {
	// insert an author
	Insert(context.Context, *models.Author) error

	// get author detail
	GetById(ctx context.Context, id uint64) (*models.Author, error)

	// search + pagination (no detail)
	GetAll(ctx context.Context, encryptedCursor, search string, limit int) ([]models.Author, string, error)
}

func New

func New(logger *zap.Logger, config *Config, rdbms rdbms.RDBMS) Repository