database

Documentation

Index

• type CreateOrUpdateUserParams
• type CreatePostsParams
• type DBTX
• type GetPostDetailRow
• type ListPostsRow
• type Post
• type Queries
  • func New(db DBTX) *Queries
  • func (q *Queries) CreateOrUpdateUser(ctx context.Context, arg CreateOrUpdateUserParams) (User, error)
  • func (q *Queries) CreatePosts(ctx context.Context, arg CreatePostsParams) (Post, error)
  • func (q *Queries) GetPostDetail(ctx context.Context, id int64) (GetPostDetailRow, error)
  • func (q *Queries) ListPosts(ctx context.Context) ([]ListPostsRow, error)
  • func (q *Queries) WithTx(tx pgx.Tx) *Queries
• type User

Types

type CreateOrUpdateUserParams

type CreateOrUpdateUserParams struct {
	Sub  string
	Name string
}

type CreatePostsParams

type CreatePostsParams struct {
	Sub     string
	Title   string
	Content pgtype.Text
}

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 GetPostDetailRow

type GetPostDetailRow struct {
	ID      int64
	UserID  pgtype.Int8
	Name    string
	Title   string
	Content pgtype.Text
	Created pgtype.Timestamptz
}

type ListPostsRow

type ListPostsRow struct {
	ID      int64
	UserID  pgtype.Int8
	Name    string
	Title   string
	Created pgtype.Timestamptz
}

type Post

type Post struct {
	ID      int64
	UserID  pgtype.Int8
	Title   string
	Content pgtype.Text
	Created pgtype.Timestamptz
}

type Queries

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

func New

func New(db DBTX) *Queries

func (*Queries) CreateOrUpdateUser

func (q *Queries) CreateOrUpdateUser(ctx context.Context, arg CreateOrUpdateUserParams) (User, error)

func (*Queries) CreatePosts

func (q *Queries) CreatePosts(ctx context.Context, arg CreatePostsParams) (Post, error)

func (*Queries) GetPostDetail

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

func (*Queries) ListPosts

func (q *Queries) ListPosts(ctx context.Context) ([]ListPostsRow, error)

func (*Queries) WithTx

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

type User

type User struct {
	ID   int64
	Sub  string
	Name string
}