repository

Documentation

Index

• Constants
• func Connect(dsnURI string)
• func ForceDB(db string) error
• func GetConnection() (*sql.DB, error)
• func MigrateDB(db string) error
• func RevertDB(db string) error
• type AppUser
• type CreateNewsEntryParams
• type CreateRetailerParams
• type CreateUserParams
• type DBTX
• type News
• type Queries
  • func GetRepository() *Queries
  • func New(db DBTX) *Queries
  • func (q *Queries) CreateNewsEntry(ctx context.Context, arg CreateNewsEntryParams) error
  • func (q *Queries) CreateRetailer(ctx context.Context, arg CreateRetailerParams) error
  • func (q *Queries) CreateUser(ctx context.Context, arg CreateUserParams) error
  • func (q *Queries) DeleteNewsEntry(ctx context.Context, id int64) error
  • func (q *Queries) DeleteRetailer(ctx context.Context, id int64) error
  • func (q *Queries) DeleteUser(ctx context.Context, userName string) error
  • func (q *Queries) GetNewsEntry(ctx context.Context, id int64) (News, error)
  • func (q *Queries) GetUser(ctx context.Context, userName string) (AppUser, error)
  • func (q *Queries) ListActiveNews(ctx context.Context) ([]News, error)
  • func (q *Queries) ListActiveRetailers(ctx context.Context) ([]Retailer, error)
  • func (q *Queries) ListNews(ctx context.Context) ([]News, error)
  • func (q *Queries) ListRetailers(ctx context.Context) ([]Retailer, error)
  • func (q *Queries) ListUsers(ctx context.Context) ([]AppUser, error)
  • func (q *Queries) UpdateNewsEntry(ctx context.Context, arg UpdateNewsEntryParams) error
  • func (q *Queries) UpdateRetailer(ctx context.Context, arg UpdateRetailerParams) error
  • func (q *Queries) UpdateUser(ctx context.Context, arg UpdateUserParams) error
  • func (q *Queries) WithTx(tx *sql.Tx) *Queries
• type Retailer
• type UpdateNewsEntryParams
• type UpdateRetailerParams
• type UpdateUserParams

Constants

const Version uint = 1

Functions

func Connect

func Connect(dsnURI string)

func ForceDB

func ForceDB(db string) error

func GetConnection

func GetConnection() (*sql.DB, error)

func MigrateDB

func MigrateDB(db string) error

func RevertDB

func RevertDB(db string) error

Types

type AppUser

type AppUser struct {
	UserName string  `db:"user_name" json:"userName"`
	UserPass *string `db:"user_pass" json:"userPass"`
	Realname *string `db:"realname" json:"realname"`
	Email    *string `db:"email" json:"email"`
}

type CreateNewsEntryParams

type CreateNewsEntryParams struct {
	NewsTitle   string     `db:"news_title" json:"newsTitle"`
	NewsText    string     `db:"news_text" json:"newsText"`
	NewsDate    *time.Time `db:"news_date" json:"newsDate"`
	NewsPublish *time.Time `db:"news_publish" json:"newsPublish"`
	Display     int64      `db:"display" json:"display"`
}

type CreateRetailerParams

type CreateRetailerParams struct {
	Shopname string `db:"shopname" json:"shopname"`
	Url      string `db:"url" json:"url"`
	Country  string `db:"country" json:"country"`
	Display  int64  `db:"display" json:"display"`
}

type CreateUserParams

type CreateUserParams struct {
	UserName string  `db:"user_name" json:"userName"`
	UserPass *string `db:"user_pass" json:"userPass"`
}

type DBTX

type DBTX interface {
	ExecContext(context.Context, string, ...interface{}) (sql.Result, error)
	PrepareContext(context.Context, string) (*sql.Stmt, error)
	QueryContext(context.Context, string, ...interface{}) (*sql.Rows, error)
	QueryRowContext(context.Context, string, ...interface{}) *sql.Row
}

type News

type News struct {
	ID          int64      `db:"id" json:"id"`
	NewsTitle   string     `db:"news_title" json:"newsTitle"`
	NewsText    string     `db:"news_text" json:"newsText"`
	NewsDate    *time.Time `db:"news_date" json:"newsDate"`
	NewsPublish *time.Time `db:"news_publish" json:"newsPublish"`
	Display     int64      `db:"display" json:"display"`
}

type Queries

type Queries struct {
	// contains filtered or unexported fields
}

func GetRepository

func GetRepository() *Queries

func New

func New(db DBTX) *Queries

func (*Queries) CreateNewsEntry

func (q *Queries) CreateNewsEntry(ctx context.Context, arg CreateNewsEntryParams) error

func (*Queries) CreateRetailer

func (q *Queries) CreateRetailer(ctx context.Context, arg CreateRetailerParams) error

func (*Queries) CreateUser

func (q *Queries) CreateUser(ctx context.Context, arg CreateUserParams) error

func (*Queries) DeleteNewsEntry

func (q *Queries) DeleteNewsEntry(ctx context.Context, id int64) error

func (*Queries) DeleteRetailer

func (q *Queries) DeleteRetailer(ctx context.Context, id int64) error

func (*Queries) DeleteUser

func (q *Queries) DeleteUser(ctx context.Context, userName string) error

func (*Queries) GetNewsEntry

func (q *Queries) GetNewsEntry(ctx context.Context, id int64) (News, error)

func (*Queries) GetUser

func (q *Queries) GetUser(ctx context.Context, userName string) (AppUser, error)

func (*Queries) ListActiveNews

func (q *Queries) ListActiveNews(ctx context.Context) ([]News, error)

func (*Queries) ListActiveRetailers

func (q *Queries) ListActiveRetailers(ctx context.Context) ([]Retailer, error)

func (*Queries) ListNews

func (q *Queries) ListNews(ctx context.Context) ([]News, error)

func (*Queries) ListRetailers

func (q *Queries) ListRetailers(ctx context.Context) ([]Retailer, error)

func (*Queries) ListUsers

func (q *Queries) ListUsers(ctx context.Context) ([]AppUser, error)

func (*Queries) UpdateNewsEntry

func (q *Queries) UpdateNewsEntry(ctx context.Context, arg UpdateNewsEntryParams) error

func (*Queries) UpdateRetailer

func (q *Queries) UpdateRetailer(ctx context.Context, arg UpdateRetailerParams) error

func (*Queries) UpdateUser

func (q *Queries) UpdateUser(ctx context.Context, arg UpdateUserParams) error

func (*Queries) WithTx

func (q *Queries) WithTx(tx *sql.Tx) *Queries

type Retailer

type Retailer struct {
	ID       int64  `db:"id" json:"id"`
	Shopname string `db:"shopname" json:"shopname"`
	Url      string `db:"url" json:"url"`
	Country  string `db:"country" json:"country"`
	Display  int64  `db:"display" json:"display"`
}

type UpdateNewsEntryParams

type UpdateNewsEntryParams struct {
	NewsTitle   string     `db:"news_title" json:"newsTitle"`
	NewsText    string     `db:"news_text" json:"newsText"`
	NewsDate    *time.Time `db:"news_date" json:"newsDate"`
	NewsPublish *time.Time `db:"news_publish" json:"newsPublish"`
	Display     int64      `db:"display" json:"display"`
	ID          int64      `db:"id" json:"id"`
}

type UpdateRetailerParams

type UpdateRetailerParams struct {
	Shopname string `db:"shopname" json:"shopname"`
	Url      string `db:"url" json:"url"`
	Country  string `db:"country" json:"country"`
	Display  int64  `db:"display" json:"display"`
	ID       int64  `db:"id" json:"id"`
}

type UpdateUserParams

type UpdateUserParams struct {
	UserPass *string `db:"user_pass" json:"userPass"`
	UserName string  `db:"user_name" json:"userName"`
}