db

Documentation

Index

• Variables
• func Migrate(databaseURL string) error
• type DBTX
• type Page
• type Queries
  • func New(db DBTX) *Queries
  • func (q *Queries) GetPageBySlug(ctx context.Context, slug string) (Page, error)
  • func (q *Queries) SavePage(ctx context.Context, arg SavePageParams) error
  • func (q *Queries) WithTx(tx pgx.Tx) *Queries
• type SavePageParams

Variables

var Migrations embed.FS

Functions

func Migrate

func Migrate(databaseURL string) error

Types

type DBTX

type DBTX interface {
	Exec(context.Context, string, ...interface{}) (pgconn.CommandTag, error)
	Query(context.Context, string, ...interface{}) (pgx.Rows, error)
	QueryRow(context.Context, string, ...interface{}) pgx.Row
}

type Page

type Page struct {
	PageID    int32              `json:"page_id"`
	Title     string             `json:"title"`
	Slug      string             `json:"slug"`
	Content   string             `json:"content"`
	CreatedAt pgtype.Timestamptz `json:"created_at"`
	UpdatedAt pgtype.Timestamptz `json:"updated_at"`
}

type Queries

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

func New

func New(db DBTX) *Queries

func (*Queries) GetPageBySlug

func (q *Queries) GetPageBySlug(ctx context.Context, slug string) (Page, error)

func (*Queries) SavePage

func (q *Queries) SavePage(ctx context.Context, arg SavePageParams) error

func (*Queries) WithTx

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

type SavePageParams

type SavePageParams struct {
	Slug    string `json:"slug"`
	Title   string `json:"title"`
	Content string `json:"content"`
}