languages

Documentation

Index

• Constants
• type Config
  • func (c Config) Default() *Config
• type Repository

Constants

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

const QueryGetDetail = `
SELECT name 
FROM languages 
WHERE id=$1;`

const QueryInsert = `
INSERT INTO 
	languages(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 a language
	Insert(context.Context, *models.Language) error

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

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