pgsql

package

v0.0.10 Latest Latest Go to latest Published: Jul 21, 2025 License: MIT Imports: 8 Imported by: 3

Details

Valid go.mod file
Redistributable license
Tagged version
Stable version
Learn more about best practices

Repository

gitlab.com/golang-utils/sql

Links

Open Source Insights

Documentation ¶

Index ¶

Constants
Variables
func CREATE(table TABLE, fields ..._createFields) *_Create
func DELETE(table TABLE) *_Delete
func INSERT(table TABLE, fields ..._insertFields) *_Insert
func NullAble[V any](ft Type[V]) nullAble[V]
func Numeric(precision, scale int) _Numeric
func SELECT(table TABLE, fields ...SQLer) *_Select
func UPDATE(table TABLE, fields ..._insertFields) *_Update
func Unique[V any](ft Type[V]) unique[V]
type Dollar
- func (d Dollar) SQL() string
- func (d Dollar) ValueToSQL(pos int) string
type FIELD
- func Field[V any](t TABLE, name string, tp Type[V]) FIELD[V]
- func (f FIELD[V]) As(name string) SQL
- func (f FIELD[V]) AsPrimaryKey() FIELD[V]
- func (f FIELD[V]) CreationSQL() string
- func (c *FIELD[V]) GetTarget() any
- func (c FIELD[V]) InnerJoin(joinField FIELD[V]) Join
- func (c FIELD[V]) InnerJoinAlias(joinField FIELD[V], alias string) Join
- func (f FIELD[V]) Is(value V) where
- func (f FIELD[V]) IsEqualOrGreaterThan(value V) where
- func (f FIELD[V]) IsEqualOrLessThan(value V) where
- func (f FIELD[V]) IsGreaterThan(value V) where
- func (f FIELD[V]) IsIn(value SQLer) where
- func (f FIELD[V]) IsLessThan(value V) where
- func (f FIELD[V]) IsNot(value V) where
- func (c FIELD[V]) OuterJoin(joinField FIELD[V]) Join
- func (c FIELD[V]) OuterJoinAlias(joinField FIELD[V], alias string) Join
- func (f FIELD[V]) SQL() string
- func (f *FIELD[V]) Set(val V) *FIELD[V]
- func (f *FIELD[V]) SetTarget(valTarget *V) *FIELD[V]
- func (f *FIELD[V]) SetWithName(val V)
- func (f FIELD[V]) ValueToSQL(pos int) string
- func (f FIELD[V]) WithDescription(descr string) FIELD[V]
- func (f FIELD[V]) WithReference(ref FIELD[V]) FIELD[V]
type Join
type SQL
- func AND(wheres ...SQLer) SQL
- func OR(wheres ...SQLer) SQL
- func (s SQL) SQL() string
type SQLer
type Scanner
type Seq
- func Each[V any](vl *V, sc Scanner, err error) Seq[V]
type TABLE
- func (t *TABLE) New()
- func (t TABLE) SQL() string
- func (t *TABLE) SetName(name string)
type Type
- func Default[V any](def string, tp Type[V]) Type[V]
type VarChar
- func (v VarChar) Escape(val string) string
- func (v VarChar) IsNullAble() bool
- func (v VarChar) IsUnique() bool
- func (v VarChar) SQL() string

Constants ¶

View Source

const TimestampFormat = "YYYY-MM-DD hh:mm:ss"

Variables ¶

View Source

var (
	Int         = _Int{}
	Bool        = _Bool{}
	Text        = _Text{}
	Float       = _Float{}
	Real        = _Real{}
	JSONB       = _JSONB{}
	Timestamp   = _Timestamp{}
	TimestampTZ = _TimestampTZ{}
	Date        = _Date{}
	SmallInt    = _SmallInt{}
	BigInt      = _BigInt{}
	UUID        = _UUID{}
)

View Source

var ALL = all{}

Functions ¶

func CREATE ¶

func CREATE(table TABLE, fields ..._createFields) *_Create

func DELETE ¶

func DELETE(table TABLE) *_Delete

func INSERT ¶

func INSERT(table TABLE, fields ..._insertFields) *_Insert

func NullAble ¶

func NullAble[V any](ft Type[V]) nullAble[V]

func Numeric ¶

func Numeric(precision, scale int) _Numeric

NUMERIC(precision, scale) decimal is the same as numeric

func SELECT ¶

func SELECT(table TABLE, fields ...SQLer) *_Select

func UPDATE ¶

func UPDATE(table TABLE, fields ..._insertFields) *_Update

func Unique ¶

func Unique[V any](ft Type[V]) unique[V]

Types ¶

type Dollar ¶

type Dollar int

func (Dollar) SQL ¶

func (d Dollar) SQL() string

func (Dollar) ValueToSQL ¶

func (d Dollar) ValueToSQL(pos int) string

type FIELD ¶

type FIELD[V any] struct {
	Name         string
	Table        TABLE
	Reference    *FIELD[V]
	IsPrimaryKey bool
	Description  string
	Type         Type[V]
	value.Var[V]
	Target *V
}

func Field ¶

func Field[V any](t TABLE, name string, tp Type[V]) FIELD[V]

func (FIELD[V]) As ¶

func (f FIELD[V]) As(name string) SQL

func (FIELD[V]) AsPrimaryKey ¶

func (f FIELD[V]) AsPrimaryKey() FIELD[V]

func (FIELD[V]) CreationSQL ¶

func (f FIELD[V]) CreationSQL() string

func (*FIELD[V]) GetTarget ¶

func (c *FIELD[V]) GetTarget() any

func (FIELD[V]) InnerJoin ¶

func (c FIELD[V]) InnerJoin(joinField FIELD[V]) Join

func (FIELD[V]) InnerJoinAlias ¶

func (c FIELD[V]) InnerJoinAlias(joinField FIELD[V], alias string) Join

func (FIELD[V]) Is ¶

func (f FIELD[V]) Is(value V) where

func (FIELD[V]) IsEqualOrGreaterThan ¶

func (f FIELD[V]) IsEqualOrGreaterThan(value V) where

func (FIELD[V]) IsEqualOrLessThan ¶

func (f FIELD[V]) IsEqualOrLessThan(value V) where

func (FIELD[V]) IsGreaterThan ¶

func (f FIELD[V]) IsGreaterThan(value V) where

func (FIELD[V]) IsIn ¶

func (f FIELD[V]) IsIn(value SQLer) where

func (FIELD[V]) IsLessThan ¶

func (f FIELD[V]) IsLessThan(value V) where

func (FIELD[V]) IsNot ¶

func (f FIELD[V]) IsNot(value V) where

func (FIELD[V]) OuterJoin ¶

func (c FIELD[V]) OuterJoin(joinField FIELD[V]) Join

func (FIELD[V]) OuterJoinAlias ¶

func (c FIELD[V]) OuterJoinAlias(joinField FIELD[V], alias string) Join

func (FIELD[V]) SQL ¶

func (f FIELD[V]) SQL() string

func (*FIELD[V]) Set ¶

func (f *FIELD[V]) Set(val V) *FIELD[V]

func (*FIELD[V]) SetTarget ¶

func (f *FIELD[V]) SetTarget(valTarget *V) *FIELD[V]

func (*FIELD[V]) SetWithName ¶

func (f *FIELD[V]) SetWithName(val V)

func (FIELD[V]) ValueToSQL ¶

func (f FIELD[V]) ValueToSQL(pos int) string

func (FIELD[V]) WithDescription ¶

func (f FIELD[V]) WithDescription(descr string) FIELD[V]

func (FIELD[V]) WithReference ¶

func (f FIELD[V]) WithReference(ref FIELD[V]) FIELD[V]

type Join ¶

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

type SQL ¶

type SQL string

func AND ¶

func AND(wheres ...SQLer) SQL

func OR ¶

func OR(wheres ...SQLer) SQL

func (SQL) SQL ¶

func (s SQL) SQL() string

type SQLer ¶

type SQLer interface {
	SQL() string
}

type Scanner ¶

type Scanner interface {
	Err() error
	Next() bool
}

type Seq ¶

type Seq[V any] interface {
	Each() iter.Seq[V]
	Err() error
}

func Each ¶

func Each[V any](vl *V, sc Scanner, err error) Seq[V]

type TABLE ¶

type TABLE struct {
	Name string
	// contains filtered or unexported fields
}

func (*TABLE) New ¶

func (t *TABLE) New()

func (TABLE) SQL ¶

func (t TABLE) SQL() string

func (*TABLE) SetName ¶

func (t *TABLE) SetName(name string)

type Type ¶

type Type[V any] interface {
	SQL() string
	Escape(val V) string
	IsNullAble() bool
	IsUnique() bool
}

func Default ¶

func Default[V any](def string, tp Type[V]) Type[V]

type VarChar ¶

type VarChar int

func (VarChar) Escape ¶

func (v VarChar) Escape(val string) string

func (VarChar) IsNullAble ¶

func (v VarChar) IsNullAble() bool

func (VarChar) IsUnique ¶

func (v VarChar) IsUnique() bool

func (VarChar) SQL ¶

func (v VarChar) SQL() string

Source Files ¶

View all Source files

?	: This menu
/	: Search site
f or F	: Jump to
y or Y	: Canonical URL