pgsql

package
v0.0.23 Latest Latest
Warning

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

 Go to latest Published: Jul 22, 2025 License: MIT Imports: 8 Imported by: 3

Documentation

Index

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 Default 

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

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 Unique 

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

Types

type Dollar 

type Dollar int

func (Dollar) NameSQL added in v0.0.13 

func (d Dollar) NameSQL() string

func (Dollar) ValueToSQL 

func (d Dollar) ValueToSQL(pos int) string

type FIELD 

type FIELD[V any] struct {
	value.Var[V]
	// contains filtered or unexported fields
}

func NewField added in v0.0.11 

func NewField[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]) Description 

func (f FIELD[V]) Description() 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]) IsMe added in v0.0.14 

func (f FIELD[V]) IsMe() where

func (FIELD[V]) IsNULL added in v0.0.22 

func (f FIELD[V]) IsNULL() where

func (FIELD[V]) IsNot 

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

func (FIELD[V]) IsNotMe added in v0.0.14 

func (f FIELD[V]) IsNotMe() where

func (FIELD[V]) IsNotNULL added in v0.0.22 

func (f FIELD[V]) IsNotNULL() where

func (FIELD[V]) IsPrimaryKey 

func (f FIELD[V]) IsPrimaryKey() bool

func (FIELD[V]) Name 

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

func (FIELD[V]) NameSQL added in v0.0.11 

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

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]) Reference 

func (f FIELD[V]) Reference() Field

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]) Table 

func (f FIELD[V]) Table() *TABLE

func (FIELD[V]) Type 

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

func (FIELD[V]) Value added in v0.0.11 

func (f FIELD[V]) Value() value.Value

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 Field 

type Field interface {
	Name() string
	CreationSQL() string
	Table() *TABLE
	Reference() Field
	IsPrimaryKey() bool
	Description() string
	Type() Type
	ValueToSQL(pos int) string
	NameSQL() string
	SQLer
}

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

	Fields []Field
	// contains filtered or unexported fields
}

func (*TABLE) AddPrimaryKey added in v0.0.19 

func (t *TABLE) AddPrimaryKey(f ...Field) *TABLE

func (*TABLE) AddUnique added in v0.0.12 

func (t *TABLE) AddUnique(f ...Field) *TABLE

func (TABLE) CREATE added in v0.0.11 

func (t TABLE) CREATE() *_Create

func (TABLE) DELETE added in v0.0.11 

func (t TABLE) DELETE() *_Delete

func (TABLE) DROP added in v0.0.15 

func (t TABLE) DROP(cascade, ifexists bool) *_Drop

func (TABLE) INSERT added in v0.0.11 

func (t TABLE) INSERT(fields ..._insertFields) *_Insert

func (*TABLE) New 

func (t *TABLE) New()

func (TABLE) SELECT added in v0.0.11 

func (t TABLE) SELECT(fields ...SQLer) *_Select

func (TABLE) SQL 

func (t TABLE) SQL() string

func (*TABLE) SetName 

func (t *TABLE) SetName(name string)

func (TABLE) UPDATE added in v0.0.11 

func (t TABLE) UPDATE(fields ..._insertFields) *_Update

type Type 

type Type interface {
	SQLer
	IsNullAble() bool
	IsUnique() bool
}

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

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.