sqlc

package
v1.28.27 Latest Latest
Warning

This package is not in the latest version of its module.

 Go to latest Published: Apr 27, 2025 License: MIT Imports: 9 Imported by: 0

Documentation

Overview

QB - query builder QC - query clause QT - query templater UT - update templater C - clause SQO - select query object UQO - update query object

QB - query builder QC - query clause QT - query templater UT - update templater C - clause SQO - select query object UQO - update query object

Index

Constants

View Source 
const Ping = `-- name: Ping :one
SELECT 1
`

Variables

View Source 
var (
	ErrUpdateAdminAccountIsNil  = errors.New("AdminAccount update struct is nil")
	ErrUpdateAdminAccountIsZero = errors.New("AdminAccount update struct is zero")
)
View Source 
var (
	ErrUpdateFeedIsNil  = errors.New("Feed update struct is nil")
	ErrUpdateFeedIsZero = errors.New("Feed update struct is zero")
)
View Source 
var (
	ErrUpdateFeedbackIsNil  = errors.New("Feedback update struct is nil")
	ErrUpdateFeedbackIsZero = errors.New("Feedback update struct is zero")
)
View Source 
var (
	ErrUpdateSupportMessageIsNil  = errors.New("SupportMessage update struct is nil")
	ErrUpdateSupportMessageIsZero = errors.New("SupportMessage update struct is zero")
)
View Source 
var (
	ErrUpdateSupportRequestIsNil  = errors.New("SupportRequest update struct is nil")
	ErrUpdateSupportRequestIsZero = errors.New("SupportRequest update struct is zero")
)

Functions

func NewAdminAccountQueryBuilder 

func NewAdminAccountQueryBuilder() *adminAccountQueryBuilder

func NewFeedQueryBuilder 

func NewFeedQueryBuilder() *feedQueryBuilder

func NewFeedbackQueryBuilder 

func NewFeedbackQueryBuilder() *feedbackQueryBuilder

func NewSupportMessageQueryBuilder 

func NewSupportMessageQueryBuilder() *supportMessageQueryBuilder

func NewSupportRequestQueryBuilder 

func NewSupportRequestQueryBuilder() *supportRequestQueryBuilder

Types

type AdminAccount 

type AdminAccount struct {
	CreatedAt    pgtype.Timestamptz `db:"created_at"`
	ID           string             `db:"id"`
	Login        string             `db:"login"`
	PasswordHash string             `db:"password_hash"`
	UpdatedAt    pgtype.Timestamptz `db:"updated_at"`
}

type AdminAccountOrm 

type AdminAccountOrm struct {
	B *adminAccountQueryBuilder
	// contains filtered or unexported fields
}

func NewAdminAccountOrm 

func NewAdminAccountOrm(db ORMDB) *AdminAccountOrm

func (*AdminAccountOrm) Delete 

func (m *AdminAccountOrm) Delete(ctx context.Context, id string) (int64, error)

func (*AdminAccountOrm) DeleteRet 

func (m *AdminAccountOrm) DeleteRet(ctx context.Context, id string) (*AdminAccount, error)

func (*AdminAccountOrm) Find 

func (m *AdminAccountOrm) Find(ctx context.Context, id string) (*AdminAccount, error)

func (*AdminAccountOrm) Insert 

func (m *AdminAccountOrm) Insert(ctx context.Context, create *AdminAccount) (int64, error)

func (*AdminAccountOrm) InsertMany 

func (m *AdminAccountOrm) InsertMany(ctx context.Context, create []*AdminAccount) (int64, error)

func (*AdminAccountOrm) InsertRet 

func (m *AdminAccountOrm) InsertRet(ctx context.Context, create *AdminAccount) (*AdminAccount, error)

func (*AdminAccountOrm) Query 

func (m *AdminAccountOrm) Query(ctx context.Context, q ormQuery) ([]*AdminAccount, error)

func (*AdminAccountOrm) QueryRow 

func (m *AdminAccountOrm) QueryRow(ctx context.Context, q ormQuery) (*AdminAccount, error)

func (*AdminAccountOrm) Update 

func (m *AdminAccountOrm) Update(ctx context.Context, id string, update *AdminAccountUpdate) (int64, error)

func (*AdminAccountOrm) UpdateRet 

func (m *AdminAccountOrm) UpdateRet(ctx context.Context, id string, update *AdminAccountUpdate) (*AdminAccount, error)

func (*AdminAccountOrm) Upsert 

func (m *AdminAccountOrm) Upsert(ctx context.Context, create *AdminAccount) (int64, error)

func (*AdminAccountOrm) UpsertRet 

func (m *AdminAccountOrm) UpsertRet(ctx context.Context, create *AdminAccount) (*AdminAccount, error)

type AdminAccountUpdate 

type AdminAccountUpdate struct {
	CreatedAt    omit.Val[pgtype.Timestamptz]
	Login        omit.Val[string]
	PasswordHash omit.Val[string]
	UpdatedAt    omit.Val[pgtype.Timestamptz]
}

func (*AdminAccountUpdate) ToSetter 

func (u *AdminAccountUpdate) ToSetter() []OrmUpdateSetter[MustAdminAccountFieldAlias]

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 Feed 

type Feed struct {
	ID        string             `db:"id"`
	CreatedAt pgtype.Timestamptz `db:"created_at"`
	Text      string             `db:"text"`
	UpdatedAt pgtype.Timestamptz `db:"updated_at"`
}

type FeedOrm 

type FeedOrm struct {
	B *feedQueryBuilder
	// contains filtered or unexported fields
}

func NewFeedOrm 

func NewFeedOrm(db ORMDB) *FeedOrm

func (*FeedOrm) Delete 

func (m *FeedOrm) Delete(ctx context.Context, id string) (int64, error)

func (*FeedOrm) DeleteRet 

func (m *FeedOrm) DeleteRet(ctx context.Context, id string) (*Feed, error)

func (*FeedOrm) Find 

func (m *FeedOrm) Find(ctx context.Context, id string) (*Feed, error)

func (*FeedOrm) Insert 

func (m *FeedOrm) Insert(ctx context.Context, create *Feed) (int64, error)

func (*FeedOrm) InsertMany 

func (m *FeedOrm) InsertMany(ctx context.Context, create []*Feed) (int64, error)

func (*FeedOrm) InsertRet 

func (m *FeedOrm) InsertRet(ctx context.Context, create *Feed) (*Feed, error)

func (*FeedOrm) Query 

func (m *FeedOrm) Query(ctx context.Context, q ormQuery) ([]*Feed, error)

func (*FeedOrm) QueryRow 

func (m *FeedOrm) QueryRow(ctx context.Context, q ormQuery) (*Feed, error)

func (*FeedOrm) Update 

func (m *FeedOrm) Update(ctx context.Context, id string, update *FeedUpdate) (int64, error)

func (*FeedOrm) UpdateRet 

func (m *FeedOrm) UpdateRet(ctx context.Context, id string, update *FeedUpdate) (*Feed, error)

func (*FeedOrm) Upsert 

func (m *FeedOrm) Upsert(ctx context.Context, create *Feed) (int64, error)

func (*FeedOrm) UpsertRet 

func (m *FeedOrm) UpsertRet(ctx context.Context, create *Feed) (*Feed, error)

type FeedUpdate 

type FeedUpdate struct {
	CreatedAt omit.Val[pgtype.Timestamptz]
	Text      omit.Val[string]
	UpdatedAt omit.Val[pgtype.Timestamptz]
}

func (*FeedUpdate) ToSetter 

func (u *FeedUpdate) ToSetter() []OrmUpdateSetter[MustFeedFieldAlias]

type Feedback 

type Feedback struct {
	ID        string             `db:"id"`
	AccountID string             `db:"account_id"`
	CreatedAt pgtype.Timestamptz `db:"created_at"`
	Rate      int32              `db:"rate"`
	Text      []string           `db:"text"`
	UpdatedAt pgtype.Timestamptz `db:"updated_at"`
}

type FeedbackOrm 

type FeedbackOrm struct {
	B *feedbackQueryBuilder
	// contains filtered or unexported fields
}

func NewFeedbackOrm 

func NewFeedbackOrm(db ORMDB) *FeedbackOrm

func (*FeedbackOrm) Delete 

func (m *FeedbackOrm) Delete(ctx context.Context, id string) (int64, error)

func (*FeedbackOrm) DeleteRet 

func (m *FeedbackOrm) DeleteRet(ctx context.Context, id string) (*Feedback, error)

func (*FeedbackOrm) Find 

func (m *FeedbackOrm) Find(ctx context.Context, id string) (*Feedback, error)

func (*FeedbackOrm) Insert 

func (m *FeedbackOrm) Insert(ctx context.Context, create *Feedback) (int64, error)

func (*FeedbackOrm) InsertMany 

func (m *FeedbackOrm) InsertMany(ctx context.Context, create []*Feedback) (int64, error)

func (*FeedbackOrm) InsertRet 

func (m *FeedbackOrm) InsertRet(ctx context.Context, create *Feedback) (*Feedback, error)

func (*FeedbackOrm) Query 

func (m *FeedbackOrm) Query(ctx context.Context, q ormQuery) ([]*Feedback, error)

func (*FeedbackOrm) QueryRow 

func (m *FeedbackOrm) QueryRow(ctx context.Context, q ormQuery) (*Feedback, error)

func (*FeedbackOrm) Update 

func (m *FeedbackOrm) Update(ctx context.Context, id string, update *FeedbackUpdate) (int64, error)

func (*FeedbackOrm) UpdateRet 

func (m *FeedbackOrm) UpdateRet(ctx context.Context, id string, update *FeedbackUpdate) (*Feedback, error)

func (*FeedbackOrm) Upsert 

func (m *FeedbackOrm) Upsert(ctx context.Context, create *Feedback) (int64, error)

func (*FeedbackOrm) UpsertRet 

func (m *FeedbackOrm) UpsertRet(ctx context.Context, create *Feedback) (*Feedback, error)

type FeedbackUpdate 

type FeedbackUpdate struct {
	AccountID omit.Val[string]
	CreatedAt omit.Val[pgtype.Timestamptz]
	Rate      omit.Val[int32]
	Text      omit.Val[[]string]
	UpdatedAt omit.Val[pgtype.Timestamptz]
}

func (*FeedbackUpdate) ToSetter 

func (u *FeedbackUpdate) ToSetter() []OrmUpdateSetter[MustFeedbackFieldAlias]

type MustAdminAccountFieldAlias 

type MustAdminAccountFieldAlias interface {
	MustAdminAccountFieldAlias()
	// contains filtered or unexported methods
}

type MustFeedFieldAlias 

type MustFeedFieldAlias interface {
	MustFeedFieldAlias()
	// contains filtered or unexported methods
}

type MustFeedbackFieldAlias 

type MustFeedbackFieldAlias interface {
	MustFeedbackFieldAlias()
	// contains filtered or unexported methods
}

type MustSupportMessageFieldAlias 

type MustSupportMessageFieldAlias interface {
	MustSupportMessageFieldAlias()
	// contains filtered or unexported methods
}

type MustSupportRequestFieldAlias 

type MustSupportRequestFieldAlias interface {
	MustSupportRequestFieldAlias()
	// contains filtered or unexported methods
}

type ORMDB 

type ORMDB 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 Orm 

type Orm struct {
	AdminAccount   *AdminAccountOrm
	Feed           *FeedOrm
	Feedback       *FeedbackOrm
	SupportMessage *SupportMessageOrm
	SupportRequest *SupportRequestOrm

	Where *ormAllWhere
}

func NewOrm 

func NewOrm(db ORMDB) *Orm

type OrmInsertSetter 

type OrmInsertSetter[T ormFieldAlias] interface {
	// contains filtered or unexported methods
}

type OrmQueryClause 

type OrmQueryClause[T ormFieldAlias] interface {
	// contains filtered or unexported methods
}

type OrmUpdateSetter 

type OrmUpdateSetter[T ormFieldAlias] interface {
	// contains filtered or unexported methods
}

type Querier 

type Querier interface {
	Ping(ctx context.Context) (int32, error)
}

type Queries 

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

func New 

func New(db DBTX) *Queries

func (*Queries) Ping 

func (q *Queries) Ping(ctx context.Context) (int32, error)

func (*Queries) WithTx 

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

type SupportMessage 

type SupportMessage struct {
	ID         string             `db:"id"`
	AuthorType int32              `db:"author_type"`
	CreatedAt  pgtype.Timestamptz `db:"created_at"`
	Text       string             `db:"text"`
	UpdatedAt  pgtype.Timestamptz `db:"updated_at"`
	RequestID  string             `db:"request_id"`
}

type SupportMessageOrm 

type SupportMessageOrm struct {
	B *supportMessageQueryBuilder
	// contains filtered or unexported fields
}

func NewSupportMessageOrm 

func NewSupportMessageOrm(db ORMDB) *SupportMessageOrm

func (*SupportMessageOrm) Delete 

func (m *SupportMessageOrm) Delete(ctx context.Context, id string) (int64, error)

func (*SupportMessageOrm) DeleteRet 

func (m *SupportMessageOrm) DeleteRet(ctx context.Context, id string) (*SupportMessage, error)

func (*SupportMessageOrm) Find 

func (m *SupportMessageOrm) Find(ctx context.Context, id string) (*SupportMessage, error)

func (*SupportMessageOrm) Insert 

func (m *SupportMessageOrm) Insert(ctx context.Context, create *SupportMessage) (int64, error)

func (*SupportMessageOrm) InsertMany 

func (m *SupportMessageOrm) InsertMany(ctx context.Context, create []*SupportMessage) (int64, error)

func (*SupportMessageOrm) InsertRet 

func (m *SupportMessageOrm) InsertRet(ctx context.Context, create *SupportMessage) (*SupportMessage, error)

func (*SupportMessageOrm) Query 

func (m *SupportMessageOrm) Query(ctx context.Context, q ormQuery) ([]*SupportMessage, error)

func (*SupportMessageOrm) QueryRow 

func (m *SupportMessageOrm) QueryRow(ctx context.Context, q ormQuery) (*SupportMessage, error)

func (*SupportMessageOrm) Update 

func (m *SupportMessageOrm) Update(ctx context.Context, id string, update *SupportMessageUpdate) (int64, error)

func (*SupportMessageOrm) UpdateRet 

func (m *SupportMessageOrm) UpdateRet(ctx context.Context, id string, update *SupportMessageUpdate) (*SupportMessage, error)

func (*SupportMessageOrm) Upsert 

func (m *SupportMessageOrm) Upsert(ctx context.Context, create *SupportMessage) (int64, error)

func (*SupportMessageOrm) UpsertRet 

func (m *SupportMessageOrm) UpsertRet(ctx context.Context, create *SupportMessage) (*SupportMessage, error)

type SupportMessageUpdate 

type SupportMessageUpdate struct {
	AuthorType omit.Val[int32]
	CreatedAt  omit.Val[pgtype.Timestamptz]
	Text       omit.Val[string]
	UpdatedAt  omit.Val[pgtype.Timestamptz]
	RequestID  omit.Val[string]
}

func (*SupportMessageUpdate) ToSetter 

func (u *SupportMessageUpdate) ToSetter() []OrmUpdateSetter[MustSupportMessageFieldAlias]

type SupportRequest 

type SupportRequest struct {
	ID        string             `db:"id"`
	AccountID string             `db:"account_id"`
	ClosedBy  int32              `db:"closed_by"`
	CreatedAt pgtype.Timestamptz `db:"created_at"`
	Subject   string             `db:"subject"`
	UpdatedAt pgtype.Timestamptz `db:"updated_at"`
	ClosedAt  pgtype.Timestamptz `db:"closed_at"`
}

type SupportRequestOrm 

type SupportRequestOrm struct {
	B *supportRequestQueryBuilder
	// contains filtered or unexported fields
}

func NewSupportRequestOrm 

func NewSupportRequestOrm(db ORMDB) *SupportRequestOrm

func (*SupportRequestOrm) Delete 

func (m *SupportRequestOrm) Delete(ctx context.Context, id string) (int64, error)

func (*SupportRequestOrm) DeleteRet 

func (m *SupportRequestOrm) DeleteRet(ctx context.Context, id string) (*SupportRequest, error)

func (*SupportRequestOrm) Find 

func (m *SupportRequestOrm) Find(ctx context.Context, id string) (*SupportRequest, error)

func (*SupportRequestOrm) Insert 

func (m *SupportRequestOrm) Insert(ctx context.Context, create *SupportRequest) (int64, error)

func (*SupportRequestOrm) InsertMany 

func (m *SupportRequestOrm) InsertMany(ctx context.Context, create []*SupportRequest) (int64, error)

func (*SupportRequestOrm) InsertRet 

func (m *SupportRequestOrm) InsertRet(ctx context.Context, create *SupportRequest) (*SupportRequest, error)

func (*SupportRequestOrm) Query 

func (m *SupportRequestOrm) Query(ctx context.Context, q ormQuery) ([]*SupportRequest, error)

func (*SupportRequestOrm) QueryRow 

func (m *SupportRequestOrm) QueryRow(ctx context.Context, q ormQuery) (*SupportRequest, error)

func (*SupportRequestOrm) Update 

func (m *SupportRequestOrm) Update(ctx context.Context, id string, update *SupportRequestUpdate) (int64, error)

func (*SupportRequestOrm) UpdateRet 

func (m *SupportRequestOrm) UpdateRet(ctx context.Context, id string, update *SupportRequestUpdate) (*SupportRequest, error)

func (*SupportRequestOrm) Upsert 

func (m *SupportRequestOrm) Upsert(ctx context.Context, create *SupportRequest) (int64, error)

func (*SupportRequestOrm) UpsertRet 

func (m *SupportRequestOrm) UpsertRet(ctx context.Context, create *SupportRequest) (*SupportRequest, error)

type SupportRequestUpdate 

type SupportRequestUpdate struct {
	AccountID omit.Val[string]
	ClosedBy  omit.Val[int32]
	CreatedAt omit.Val[pgtype.Timestamptz]
	Subject   omit.Val[string]
	UpdatedAt omit.Val[pgtype.Timestamptz]
	ClosedAt  omit.Val[pgtype.Timestamptz]
}

func (*SupportRequestUpdate) ToSetter 

func (u *SupportRequestUpdate) ToSetter() []OrmUpdateSetter[MustSupportRequestFieldAlias]

Source Files

View all Source files

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL
go.dev uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Learn more.