linq

package
v0.0.29 Latest Latest
Warning

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

 Go to latest Published: Oct 6, 2023 License: MIT Imports: 8 Imported by: 0

Documentation

Index

Constants

View Source 
const ActDelete = 5
View Source 
const ActInsert = 4
View Source 
const ActSelect = 3
View Source 
const ActUpdate = 6
View Source 
const ActUpsert = 7
View Source 
const AfterDelete = 6
View Source 
const AfterInsert = 2
View Source 
const AfterUpdate = 4
View Source 
const BeforeDelete = 5
View Source 
const BeforeInsert = 1
View Source 
const BeforeUpdate = 3
View Source 
const TpAtrib = 1
View Source 
const TpClone = 5
View Source 
const TpColumn = 0
View Source 
const TpData = 2
View Source 
const TpDetail = 2
View Source 
const TpField = 6
View Source 
const TpFunction = 4
View Source 
const TpReference = 3
View Source 
const TpSelect = 1

Variables

This section is empty.

Functions

func Describe 

func Describe(db int, schema, model, filter string) Json

func FunctionDef added in v0.0.8 

func FunctionDef(linq *Linq, col *Column) string

func GetAs 

func GetAs(n int) string

func StrToColN 

func StrToColN(str string) []string

Types

type Col 

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

* * *

func (*Col) As 

func (c *Col) As() string

func (*Col) AsLow 

func (c *Col) AsLow() string

func (*Col) AsUp 

func (c *Col) AsUp() string

func (*Col) Cast 

func (c *Col) Cast(cast string) *Col

func (*Col) Low 

func (c *Col) Low() string

func (*Col) Up 

func (c *Col) Up() string

type Column 

type Column struct {
	Model  *Model
	Tp     int
	Column *Column

	Title       string
	Description string
	Type        string
	Default     any
	Atribs      []*Column
	Reference   *Reference
	Definition  interface{}
	Function    string
	Details     Details
	Indexed     bool
	Unique      bool
	Required    bool
	PrimaryKey  bool
	ForeignKey  bool
	Hidden      bool
	// contains filtered or unexported fields
}

func Concat 

func Concat(args ...any) *Column

func NewColumn 

func NewColumn(model *Model, name, description, _type string, _default any) *Column

func NewVirtualAtrib 

func NewVirtualAtrib(model *Model, name, description, _type string, _default any) *Column

func (*Column) As 

func (c *Column) As(linq *Linq) string

* * This function not use in Select *

func (*Column) Cast 

func (c *Column) Cast(cast string) *Column

func (*Column) DDL 

func (c *Column) DDL() string

* * DDL *

func (*Column) DDLIndex added in v0.0.27 

func (c *Column) DDLIndex() string

func (*Column) Def 

func (c *Column) Def(linq *Linq) string

* * This function use in Select *

func (*Column) Describe 

func (c *Column) Describe() Json

func (*Column) Eq 

func (c *Column) Eq(val any) *Where

* * *

func (*Column) From 

func (c *Column) From(from string) *Column

* * This function use in Select *

func (*Column) In 

func (c *Column) In(vals ...any) *Where

func (*Column) Less 

func (c *Column) Less(val any) *Where

func (*Column) LessEq 

func (c *Column) LessEq(val any) *Where

func (*Column) Like 

func (c *Column) Like(val any) *Where

func (*Column) Low 

func (c *Column) Low() string

func (*Column) More 

func (c *Column) More(val any) *Where

func (*Column) MoreEq 

func (c *Column) MoreEq(val any) *Where

func (*Column) Name 

func (c *Column) Name(name string) *Column

func (*Column) Neg 

func (c *Column) Neg(val any) *Where

func (*Column) Up 

func (c *Column) Up() string

* * *

type Details 

type Details func(col *Column, data *Json)

* * *

type FRom 

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

* * *

func (*FRom) As 

func (c *FRom) As() string

func (*FRom) Col 

func (c *FRom) Col(name string, cast ...string) *Col

func (*FRom) Column 

func (c *FRom) Column(name string, cast ...string) *Col

func (*FRom) NameAs 

func (c *FRom) NameAs() string

type Join 

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

* * *

type Linq 

type Linq struct {
	Tp  int
	Act int
	// contains filtered or unexported fields
}

* * *

func From 

func From(model *Model, as ...string) *Linq

* * *

func NewLinq 

func NewLinq(tp int, act int, model *Model, as ...string) *Linq

* * *

func (*Linq) And 

func (c *Linq) And(where *Where) *Linq

func (*Linq) As 

func (c *Linq) As(val any) string

func (*Linq) Col 

func (c *Linq) Col(val any) *Column

func (*Linq) Command 

func (c *Linq) Command() (Item, error)

* * Executors *

func (*Linq) Count 

func (c *Linq) Count() int

func (*Linq) Current 

func (c *Linq) Current() (Item, error)

* * *

func (*Linq) Debug 

func (c *Linq) Debug() *Linq

func (*Linq) Details 

func (c *Linq) Details(data *Json) *Json

func (*Linq) Find 

func (c *Linq) Find() (Items, error)

* * *

func (*Linq) First 

func (c *Linq) First() (Item, error)

func (*Linq) From 

func (c *Linq) From(model *Model, as ...string) *Linq

func (*Linq) GetAs 

func (c *Linq) GetAs() string

* * *

func (*Linq) GetCol 

func (c *Linq) GetCol(name string) *Column

func (*Linq) GetFrom 

func (c *Linq) GetFrom(col *Column) *FRom

func (*Linq) GroupBy 

func (c *Linq) GroupBy(cols ...any) *Linq

func (*Linq) Join 

func (c *Linq) Join(from, join *FRom, where *Where) *Linq

func (*Linq) LeftJoin 

func (c *Linq) LeftJoin(from, join *FRom, where *Where) *Linq

func (*Linq) Limit 

func (c *Linq) Limit(limit int) (Items, error)

func (*Linq) List 

func (c *Linq) List(page, rows int) (List, error)

func (*Linq) Or 

func (c *Linq) Or(where *Where) *Linq

func (*Linq) OrderBy 

func (c *Linq) OrderBy(col *Column, sorted bool) *Linq

func (*Linq) Page 

func (c *Linq) Page(page, rows int) (Items, error)

func (*Linq) PrepareDelete 

func (c *Linq) PrepareDelete(current Json)

func (*Linq) PrepareInsert 

func (c *Linq) PrepareInsert()

* * *

func (*Linq) PrepareUpdate 

func (c *Linq) PrepareUpdate(current Json) bool

func (*Linq) Query 

func (c *Linq) Query() (Items, error)

* * Query *

func (*Linq) QueryCount 

func (c *Linq) QueryCount() int

func (*Linq) QueryOne 

func (c *Linq) QueryOne() (Item, error)

func (*Linq) Returns 

func (c *Linq) Returns(cols ...any) *Linq

func (*Linq) RightJoin 

func (c *Linq) RightJoin(from, join *FRom, where *Where) *Linq

func (*Linq) SQL 

func (c *Linq) SQL() SQL

func (*Linq) Select 

func (c *Linq) Select(sel ...any) *Linq

func (*Linq) SetAs 

func (c *Linq) SetAs(model *Model, as string) string

func (*Linq) SetFromAs 

func (c *Linq) SetFromAs(from *FRom) *FRom

func (*Linq) Sql 

func (c *Linq) Sql() string

func (*Linq) SqlColumDef 

func (c *Linq) SqlColumDef(cols ...*Column) string

* * *

func (*Linq) SqlColums 

func (c *Linq) SqlColums(cols ...*Column) string

func (*Linq) SqlCount 

func (c *Linq) SqlCount() string

func (*Linq) SqlCurrent 

func (c *Linq) SqlCurrent() string

func (*Linq) SqlDelete 

func (c *Linq) SqlDelete() string

func (*Linq) SqlFrom 

func (c *Linq) SqlFrom() string

func (*Linq) SqlGroupBy 

func (c *Linq) SqlGroupBy() string

func (*Linq) SqlIndex 

func (c *Linq) SqlIndex() string

func (*Linq) SqlInsert 

func (c *Linq) SqlInsert() string

* * *

func (*Linq) SqlJoin 

func (c *Linq) SqlJoin() string

func (*Linq) SqlKey 

func (c *Linq) SqlKey() string

func (*Linq) SqlLimit 

func (c *Linq) SqlLimit(limit int) string

func (*Linq) SqlOffset 

func (c *Linq) SqlOffset(limit, offset int) string

func (*Linq) SqlOrderBy 

func (c *Linq) SqlOrderBy() string

func (*Linq) SqlReturn 

func (c *Linq) SqlReturn() string

func (*Linq) SqlSelect 

func (c *Linq) SqlSelect() string

* * *

func (*Linq) SqlUpdate 

func (c *Linq) SqlUpdate() string

func (*Linq) SqlWhere 

func (c *Linq) SqlWhere() string

func (*Linq) ToCols 

func (c *Linq) ToCols(sel ...any) []*Column

func (*Linq) Where 

func (c *Linq) Where(where *Where) *Linq

type Model 

type Model struct {
	Db                 int
	Database           *Db
	Name               string
	Description        string
	Schema             string
	Table              string
	Definition         []*Column
	PrimaryKeys        []string
	ForeignKey         []*Reference
	Index              []string
	SourceField        string
	DateMakeField      string
	DateUpdateField    string
	IndexField         string
	CodeField          string
	ProjectField       string
	StateField         string
	Ddl                string
	IntegrityAtrib     bool
	IntegrityReference bool
	UseState           bool
	UseSource          bool
	UseDateMake        bool
	UseDateUpdate      bool
	UseProject         bool
	UseIndex           bool
	UseRecycle         bool
	BeforeInsert       []Trigger
	AfterInsert        []Trigger
	BeforeUpdate       []Trigger
	AfterUpdate        []Trigger
	BeforeDelete       []Trigger
	AfterDelete        []Trigger
	AfterReferences    Rerences
	Version            int
}

func NewModel 

func NewModel(schema *Schema, table, description string, version int) *Model

* * *

func (*Model) All 

func (c *Model) All() []*Column

func (*Model) As 

func (c *Model) As(as string) *FRom

func (*Model) Atrib 

func (c *Model) Atrib(name string) *Column

func (*Model) AtribIdx 

func (c *Model) AtribIdx(name string) int

func (*Model) Avg added in v0.0.8 

func (c *Model) Avg(args ...any) *Column

func (*Model) Changue 

func (c *Model) Changue(current Json, linq *Linq) *Linq

func (*Model) Col 

func (c *Model) Col(name string) *Column

func (*Model) ColIdx 

func (c *Model) ColIdx(name string) int

func (*Model) Column 

func (c *Model) Column(name string) *Column

func (*Model) Concat 

func (c *Model) Concat(args ...any) *Column

* * *

func (*Model) Consolidate 

func (c *Model) Consolidate(linq *Linq) *Linq

* * *

func (*Model) Count added in v0.0.8 

func (c *Model) Count(args ...any) *Column

func (*Model) DDL 

func (c *Model) DDL() string

func (*Model) DDLMigration added in v0.0.29 

func (c *Model) DDLMigration() string

func (*Model) DefineAtrib 

func (c *Model) DefineAtrib(name, description, _type string, _default any) *Model

func (*Model) DefineColum 

func (c *Model) DefineColum(name, description, _type string, _default any) *Model

* * *

func (*Model) DefineField 

func (c *Model) DefineField(name, description string, _default any, definition string) *Model

func (*Model) DefineForeignKey 

func (c *Model) DefineForeignKey(thisKey string, otherKey *Column) *Model

func (*Model) DefineHidden 

func (c *Model) DefineHidden(hidden []string) *Model

func (*Model) DefineIndex 

func (c *Model) DefineIndex(index []string) *Model

func (*Model) DefinePrimaryKey 

func (c *Model) DefinePrimaryKey(keys []string) *Model

func (*Model) DefineReference 

func (c *Model) DefineReference(thisKey, name, otherKey string, column *Column) *Model

func (*Model) Delete 

func (c *Model) Delete() *Linq

func (*Model) Describe 

func (c *Model) Describe() Json

func (*Model) Details 

func (c *Model) Details(name, description string, _default any, details Details)

func (*Model) DropDDL 

func (c *Model) DropDDL() string

func (*Model) From 

func (c *Model) From() *Linq

* * *

func (*Model) Init added in v0.0.29 

func (c *Model) Init() error

* * DDL *

func (*Model) Insert 

func (c *Model) Insert(data Json) *Linq

func (*Model) Low 

func (c *Model) Low() string

func (*Model) Max added in v0.0.8 

func (c *Model) Max(args ...any) *Column

func (*Model) Min added in v0.0.8 

func (c *Model) Min(args ...any) *Column

func (*Model) Model 

func (c *Model) Model() Json

func (*Model) References 

func (c *Model) References(reference Rerences)

func (*Model) Select 

func (c *Model) Select(sel ...any) *Linq

func (*Model) Sum added in v0.0.8 

func (c *Model) Sum(args ...any) *Column

func (*Model) TitleIdx 

func (c *Model) TitleIdx(name string) int

func (*Model) Trigger 

func (c *Model) Trigger(event int, trigger Trigger)

* * *

func (*Model) Up 

func (c *Model) Up() string

* * *

func (*Model) Update 

func (c *Model) Update(data Json) *Linq

func (*Model) Upsert 

func (c *Model) Upsert(data Json) *Linq

type OrderBy 

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

* * *

type Reference 

type Reference struct {
	Fkey      string
	Name      string
	Key       string
	Reference *Column
}

func NewForeignKey 

func NewForeignKey(fKey string, reference *Column) *Reference

func (*Reference) DDL 

func (c *Reference) DDL() string

func (*Reference) Describe 

func (c *Reference) Describe() Json

type ReferenceValue 

type ReferenceValue struct {
	Schema string
	Table  string
	Key    any
	Op     int
}

* * *

type Rerences 

type Rerences func(references []*ReferenceValue)

type SQL 

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

* * *

type Schema 

type Schema struct {
	Db       int
	Database *Db
	// name            string
	Name            string
	Description     string
	SourceField     string
	DateMakeField   string
	DateUpdateField string
	IndexField      string
	CodeField       string
	ProjectField    string
	StateField      string
	Models          []*Model
}

func GetSchema 

func GetSchema(name string) *Schema

func NewSchema 

func NewSchema(db int, name string) *Schema

func (*Schema) DDL 

func (c *Schema) DDL() string

func (*Schema) Describe 

func (c *Schema) Describe() Json

* * *

func (*Schema) Init 

func (c *Schema) Init() error

func (*Schema) Model 

func (c *Schema) Model(name string) *Model

* * *

type Trigger 

type Trigger func(model *Model, old, new *Json, data Json)

type Where 

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

func NewWhere 

func NewWhere(val1 any, operator string, val2 any) *Where

func (*Where) Def 

func (c *Where) Def(val any) string

func (*Where) Define 

func (c *Where) Define(linq *Linq) *Where

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.