sqlc

Documentation

Index

• type Article
• type Author
• type DBTX
• type InsertArticlesParams
• type InsertAuthorsParams
• type Queries
  • func New(db DBTX) *Queries
  • func (q *Queries) FindAuthorByID(ctx context.Context, id int64) (Author, error)
  • func (q *Queries) FindAuthorsByName(ctx context.Context, name string) ([]Author, error)
  • func (q *Queries) InsertArticles(ctx context.Context, arg []InsertArticlesParams) (int64, error)
  • func (q *Queries) InsertAuthors(ctx context.Context, arg []InsertAuthorsParams) (int64, error)
  • func (q *Queries) RecentArticles(ctx context.Context, limit int32) ([]Article, error)
  • func (q *Queries) WithTx(tx pgx.Tx) *Queries

Types

type Article

type Article struct {
	ID          int64
	Title       string
	Body        string
	PublishedAt pgtype.Timestamptz
}

type Author

type Author struct {
	ID   int64
	Name string
}

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
	CopyFrom(ctx context.Context, tableName pgx.Identifier, columnNames []string, rowSrc pgx.CopyFromSource) (int64, error)
}

type InsertArticlesParams

type InsertArticlesParams struct {
	ID          int64
	Title       string
	Body        string
	PublishedAt pgtype.Timestamptz
}

type InsertAuthorsParams

type InsertAuthorsParams struct {
	ID   int64
	Name string
}

type Queries

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

func New

func New(db DBTX) *Queries

func (*Queries) FindAuthorByID

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

func (*Queries) FindAuthorsByName

func (q *Queries) FindAuthorsByName(ctx context.Context, name string) ([]Author, error)

func (*Queries) InsertArticles

func (q *Queries) InsertArticles(ctx context.Context, arg []InsertArticlesParams) (int64, error)

func (*Queries) InsertAuthors

func (q *Queries) InsertAuthors(ctx context.Context, arg []InsertAuthorsParams) (int64, error)

func (*Queries) RecentArticles

func (q *Queries) RecentArticles(ctx context.Context, limit int32) ([]Article, error)

func (*Queries) WithTx

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