tsql

Jul 21, 2025

Changes in this version

+ var ALL = all

+ func SELECT(table Table, fields ...SQLer) *_Select

+ type Create struct

+ Fields []_createFields

+ Table Table

+ func CREATE(table Table, fields ..._createFields) *Create

+ func (c *Create) SQL() string

+ func (c *Create) String() string

+ type Delete struct

+ Table Table

+ func DELETE(table Table) *Delete

+ func (c *Delete) SQL() string

+ func (c *Delete) String() string

+ func (s *Delete) WHERE(where SQLer) *Delete

+ type Dollar int

+ func (d Dollar) SQL() string

+ func (d Dollar) ValueToSQL(pos int) string

+ type Field struct

+ Description string

+ IsAutoIncrement bool

+ IsPrimaryKey bool

+ MaxLength int

+ Name string

+ Nullable bool

+ References *tableField[V]

+ Value V

+ func (c *Field[V]) GetTarget() any

+ func (c Field[V]) InnerJoin(joinField *tableField[V]) Join

+ func (c Field[V]) InnerJoinAlias(joinField *tableField[V], alias string) Join

+ func (c Field[V]) OuterJoin(joinField *tableField[V]) Join

+ func (c Field[V]) OuterJoinAlias(joinField *tableField[V], alias string) Join

+ func (f Field[V]) CreationSQL() string

+ 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 (f Field[V]) Of(table Table) *tableField[V]

+ func (f Field[V]) SQL() string

+ func (f Field[V]) Set(value V) Field[V]

+ func (f Field[V]) Type() string

+ func (f Field[V]) ValueToSQL(pos int) string

+ type Insert struct

+ func INSERT(table Table, fields ..._insertFields) *Insert

+ func (c *Insert) SQL() string

+ func (c *Insert) String() string

+ type Join struct

+ type SQL string

+ func AND(wheres ...SQLer) SQL

+ func OR(wheres ...SQLer) SQL

+ func (s SQL) SQL() string

+ type SQLer interface

+ SQL func() string

+ type Table struct

+ Name string

+ func (t Table) SQL() string

+ type Update struct

+ Fields []_insertFields

+ Table Table

+ func UPDATE(table Table, fields ..._insertFields) *Update

+ func (c *Update) SQL() string

+ func (c *Update) String() string

+ func (s *Update) WHERE(where SQLer) *Update