postgresql

Documentation

Index

• type DeleteStmt
  • func NewDeleteStmt(db sqb.StatementExecutor) *DeleteStmt
  • func (s *DeleteStmt) Build() *DeleteStmt
  • func (s *DeleteStmt) Clean() *DeleteStmt
  • func (s *DeleteStmt) Copy() *DeleteStmt
  • func (s *DeleteStmt) ItIsCommand()
• type InsertStmt
  • func NewInsertStmt(db sqb.StatementExecutor) *InsertStmt
  • func (s *InsertStmt) Build() *InsertStmt
  • func (s *InsertStmt) Clean() *InsertStmt
  • func (s *InsertStmt) Copy() *InsertStmt
  • func (s *InsertStmt) Exec(sequence string) (any, error)
  • func (s *InsertStmt) ItIsCommand()
  • func (s *InsertStmt) MustExec(sequence string) any
• type SelectStmt
  • func NewSelectStmt(db sqb.StatementExecutor) *SelectStmt
  • func (s *SelectStmt) Batches(size, page int) func() ([]map[string]any, error)
  • func (s *SelectStmt) Build() *SelectStmt
  • func (s *SelectStmt) Clean() *SelectStmt
  • func (s *SelectStmt) Column(args ...string) ([]any, error)
  • func (s *SelectStmt) Copy() *SelectStmt
  • func (s *SelectStmt) Count(column string) (int64, error)
  • func (s *SelectStmt) CountWithNonConditionalClauses(column string) (int64, error)
  • func (s *SelectStmt) ItIsQuery()
  • func (s *SelectStmt) MustColumn(args ...string) []any
  • func (s *SelectStmt) MustCount(column string) int64
  • func (s *SelectStmt) MustCountWithNonConditionalClauses(column string) int64
  • func (s *SelectStmt) MustOne(args ...string) any
  • func (s *SelectStmt) One(args ...string) (any, error)
  • func (s *SelectStmt) Pages(size, page int) func() (map[string]any, error)
  • func (s *SelectStmt) Paginate(page, size int) *SelectStmt
• type UpdateStmt
  • func NewUpdateStmt(db sqb.StatementExecutor) *UpdateStmt
  • func (s *UpdateStmt) Build() *UpdateStmt
  • func (s *UpdateStmt) Clean() *UpdateStmt
  • func (s *UpdateStmt) Copy() *UpdateStmt
  • func (s *UpdateStmt) ItIsCommand()
• type ValuesStmt
  • func NewValuesStmt(db sqb.StatementExecutor) *ValuesStmt
  • func (s *ValuesStmt) Build() *ValuesStmt
  • func (s *ValuesStmt) Clean() *ValuesStmt
  • func (s *ValuesStmt) Copy() *ValuesStmt
  • func (s *ValuesStmt) ItIsQuery()
  • func (s *ValuesStmt) Paginate(page, size int) *ValuesStmt

Types

type DeleteStmt

type DeleteStmt struct {
	*execution.DataFetching[*DeleteStmt]
	*execution.StatementExecution[*DeleteStmt]
	*sql.BaseStatement[*DeleteStmt]
	*cls.WithClause[*DeleteStmt]
	*postgresql.DeleteClause[*DeleteStmt]
	*cls.UsingClause[*DeleteStmt]
	*cls.WhereClause[*DeleteStmt]
	*cls.ReturningClause[*DeleteStmt]
}

func NewDeleteStmt

func NewDeleteStmt(db sqb.StatementExecutor) *DeleteStmt

func (*DeleteStmt) Build

func (s *DeleteStmt) Build() *DeleteStmt

func (*DeleteStmt) Clean

func (s *DeleteStmt) Clean() *DeleteStmt

func (*DeleteStmt) Copy

func (s *DeleteStmt) Copy() *DeleteStmt

func (*DeleteStmt) ItIsCommand

func (s *DeleteStmt) ItIsCommand()

type InsertStmt

type InsertStmt struct {
	*execution.DataFetching[*InsertStmt]
	*sql.BaseStatement[*InsertStmt]
	*cls.WithClause[*InsertStmt]
	*postgresql.InsertClause[*InsertStmt]
	*cls.ColumnsClause[*InsertStmt]
	*postgresql.ValueListClause[*InsertStmt, *SelectStmt]
	*postgresql.ConflictClause[*InsertStmt]
	*cls.ReturningClause[*InsertStmt]
}

func NewInsertStmt

func NewInsertStmt(db sqb.StatementExecutor) *InsertStmt

func (*InsertStmt) Build

func (s *InsertStmt) Build() *InsertStmt

func (*InsertStmt) Clean

func (s *InsertStmt) Clean() *InsertStmt

func (*InsertStmt) Copy

func (s *InsertStmt) Copy() *InsertStmt

func (*InsertStmt) Exec

func (s *InsertStmt) Exec(sequence string) (any, error)

func (*InsertStmt) ItIsCommand

func (s *InsertStmt) ItIsCommand()

func (*InsertStmt) MustExec

func (s *InsertStmt) MustExec(sequence string) any

type SelectStmt

type SelectStmt struct {
	*execution.DataFetching[*SelectStmt]
	*sql.BaseStatement[*SelectStmt]
	*postgresql.UnionClause[*SelectStmt]
	*cls.WithClause[*SelectStmt]
	*cls.FromClause[*SelectStmt]
	*cls.SelectClause[*SelectStmt]
	*postgresql.JoinClause[*SelectStmt]
	*cls.WhereClause[*SelectStmt]
	*cls.GroupClause[*SelectStmt]
	*cls.HavingClause[*SelectStmt]
	*cls.OrderClause[*SelectStmt]
	*cls.LimitClause[*SelectStmt]
	*cls.OffsetClause[*SelectStmt]
	*postgresql.LockingClause[*SelectStmt]
}

func NewSelectStmt

func NewSelectStmt(db sqb.StatementExecutor) *SelectStmt

func (*SelectStmt) Batches

func (s *SelectStmt) Batches(size, page int) func() ([]map[string]any, error)

func (*SelectStmt) Build

func (s *SelectStmt) Build() *SelectStmt

func (*SelectStmt) Clean

func (s *SelectStmt) Clean() *SelectStmt

func (*SelectStmt) Column

func (s *SelectStmt) Column(args ...string) ([]any, error)

func (*SelectStmt) Copy

func (s *SelectStmt) Copy() *SelectStmt

func (*SelectStmt) Count

func (s *SelectStmt) Count(column string) (int64, error)

func (*SelectStmt) CountWithNonConditionalClauses

func (s *SelectStmt) CountWithNonConditionalClauses(column string) (int64, error)

func (*SelectStmt) ItIsQuery

func (s *SelectStmt) ItIsQuery()

func (*SelectStmt) MustColumn

func (s *SelectStmt) MustColumn(args ...string) []any

func (*SelectStmt) MustCount

func (s *SelectStmt) MustCount(column string) int64

func (*SelectStmt) MustCountWithNonConditionalClauses

func (s *SelectStmt) MustCountWithNonConditionalClauses(column string) int64

func (*SelectStmt) MustOne

func (s *SelectStmt) MustOne(args ...string) any

func (*SelectStmt) One

func (s *SelectStmt) One(args ...string) (any, error)

func (*SelectStmt) Pages

func (s *SelectStmt) Pages(size, page int) func() (map[string]any, error)

func (*SelectStmt) Paginate

func (s *SelectStmt) Paginate(page, size int) *SelectStmt

type UpdateStmt

type UpdateStmt struct {
	*execution.DataFetching[*UpdateStmt]
	*execution.StatementExecution[*UpdateStmt]
	*sql.BaseStatement[*UpdateStmt]
	*cls.WithClause[*UpdateStmt]
	*postgresql.UpdateClause[*UpdateStmt]
	*cls.AssignmentClause[*UpdateStmt]
	*cls.FromClause[*UpdateStmt]
	*cls.WhereClause[*UpdateStmt]
	*cls.ReturningClause[*UpdateStmt]
}

func NewUpdateStmt

func NewUpdateStmt(db sqb.StatementExecutor) *UpdateStmt

func (*UpdateStmt) Build

func (s *UpdateStmt) Build() *UpdateStmt

func (*UpdateStmt) Clean

func (s *UpdateStmt) Clean() *UpdateStmt

func (*UpdateStmt) Copy

func (s *UpdateStmt) Copy() *UpdateStmt

func (*UpdateStmt) ItIsCommand

func (s *UpdateStmt) ItIsCommand()

type ValuesStmt

type ValuesStmt struct {
	*execution.DataFetching[*ValuesStmt]
	*sql.BaseStatement[*ValuesStmt]
	*postgresql.UnionClause[*ValuesStmt]
	*cls.ValuesClause[*ValuesStmt]
	*cls.OrderClause[*ValuesStmt]
	*cls.LimitClause[*ValuesStmt]
	*cls.OffsetClause[*ValuesStmt]
}

func NewValuesStmt

func NewValuesStmt(db sqb.StatementExecutor) *ValuesStmt

func (*ValuesStmt) Build

func (s *ValuesStmt) Build() *ValuesStmt

func (*ValuesStmt) Clean

func (s *ValuesStmt) Clean() *ValuesStmt

func (*ValuesStmt) Copy

func (s *ValuesStmt) Copy() *ValuesStmt

func (*ValuesStmt) ItIsQuery

func (s *ValuesStmt) ItIsQuery()

func (*ValuesStmt) Paginate

func (s *ValuesStmt) Paginate(page, size int) *ValuesStmt