jdb

package
v1.0.5 Latest Latest
Warning

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

 Go to latest Published: Feb 8, 2025 License: MIT Imports: 18 Imported by: 0

Documentation

Index

Constants

View Source 
const (
	INDEX         = "index"
	SOURCE        = "source"
	PROJECT       = "project"
	CREATED_AT    = "created_at"
	UPDATED_AT    = "update_at"
	STATUS        = "status"
	KEY           = "id"
	SYSID         = "jdbid"
	CREATED_TO    = "created_to"
	UPDATED_TO    = "updated_to"
	FULLTEXT      = "fulltext"
	HISTORY_INDEX = "history_index"
)
View Source 
const (
	MSG_DRIVER_NOT_FOUND         = "Driver not found (%s)"
	MSG_DRIVER_NOT_DEFINED       = "Driver not defined"
	MSS_PARAM_REQUIRED           = "Parámetro requerido (%s)"
	MSG_DATABASE_NOT_FOUND       = "Database not found"
	MSG_DATABASE_IS_REQUIRED     = "Database is required"
	MSG_QUERY_FAILED             = "Query failed: %s\nSQL: %s"
	MSG_MODEL_NOT_FOUND          = "Model not found (%s)"
	MSG_QUERY_EMPTY              = "Query is empty"
	MSG_QUERY_FROM_REQUIRED      = "Query 'from' is required"
	MSG_SYSTEMKEYFIELD_NOT_FOUND = "SystemKeyField not found"
	MSG_NOT_DATA                 = "No data"
	MSG_NOT_INSERT_DATA          = "No insert data"
	MSG_NOT_UPDATE_DATA          = "No update data"
	MSG_NOT_DELETE_DATA          = "No delete data"
	MSG_KEY_NOT_FOUND            = "Key not found"
	MSG_HISTORY_NOT_DEFINED      = "History not defined"
	MSG_HISTORY_NOT_FOUND        = "History not found"
	MSG_UNDO_NOT_DEFINED         = "Undo record not defined"
)

Variables

View Source 
var (
	Postgres = "postgres"
	Josefine = "josefine"
)
View Source 
var JDBS []*DB = []*DB{}

Functions

func Commands 

func Commands(command et.Json) (et.Items, error)

* * Commands * @param command et.Json * @return et.Items, error *

func EventDeleteDefault added in v1.0.5 

func EventDeleteDefault(model *Model, before et.Json, after et.Json) error

func EventHistoryDefault added in v1.0.5 

func EventHistoryDefault(model *Model, before et.Json, after et.Json) error

func EventInsertDefault added in v1.0.5 

func EventInsertDefault(model *Model, before et.Json, after et.Json) error

func EventUpdateDefault added in v1.0.5 

func EventUpdateDefault(model *Model, before et.Json, after et.Json) error

func Name 

func Name(name string) string

func NewVmj added in v1.0.5 

func NewVmj(model *Model) *goja.Runtime

func Query 

func Query(query et.Json) (et.Items, error)

* * Query * @param query et.Json * @return et.Items, error *

func Register 

func Register(name string, driver func() Driver)

* * SetDriver *

func RowsToItem 

func RowsToItem(rows *sql.Rows) et.Item

* * RowsToItem return a item from a sql rows * @param rows *sql.Rows * @return et.Item *

func RowsToItems 

func RowsToItems(rows *sql.Rows) et.Items

* * RowsToItems return a items from a sql rows * @param rows *sql.Rows * @return et.Items *

func SQLDDL 

func SQLDDL(sql string, args ...any) string

* * SQLDDL return a sql string with the args * @param sql string * @param args ...any * @return string *

func SQLParse 

func SQLParse(sql string, args ...any) string

* * SQLParse return a sql string with the args * @param sql string * @param args ...any * @return string *

func SQLQuote 

func SQLQuote(sql string) string

* * SQLQuote return a sql cuote string * @param sql string * @return string *

func SourceToItem 

func SourceToItem(source string, rows *sql.Rows) et.Item

* * SourceToItem return a item from a sql rows and source field * @param source string * @param rows *sql.Rows * @return et.Items *

func SourceToItems added in v1.0.5 

func SourceToItems(source string, rows *sql.Rows) et.Items

* * SourceToItems return a items from a sql rows and source field * @param source string * @param rows *sql.Rows * @return et.Items *

func TableName added in v1.0.3 

func TableName(schema, name string) string

func UpsertDictionary added in v1.0.5 

func UpsertDictionary(w http.ResponseWriter, r *http.Request)

* * UpsertDictionary * @param w http.ResponseWriter * @param r *http.Request *

Types

type Adapter added in v1.0.3 

type Adapter interface{}

type Agregation 

type Agregation struct {
	Agregation string
	// contains filtered or unexported fields
}

type Column 

type Column struct {
	Model         *Model        `json:"-"`
	Name          string        `json:"name"`
	Field         string        `json:"field"`
	Description   string        `json:"description"`
	Table         string        `json:"table"`
	TypeColumn    TypeColumn    `json:"type_column"`
	TypeData      TypeData      `json:"type_data"`
	Default       interface{}   `json:"default"`
	Max           float64       `json:"max"`
	Min           float64       `json:"min"`
	Hidden        bool          `json:"hidden"`
	FullText      []string      `json:"columns"`
	Detail        *Detail       `json:"detail"`
	FuncGenerated FuncGenerated `json:"-"`
	Limit         int           `json:"limit"`
	Language      string        `json:"language"`
	Values        []interface{} `json:"values"`
}

func (*Column) DefaultQuote 

func (s *Column) DefaultQuote() interface{}

* * DefaultQuote * @return interface{} *

func (*Column) DefaultValue 

func (s *Column) DefaultValue() interface{}

* * DefaultValue * @return interface{} *

func (*Column) Describe 

func (s *Column) Describe() et.Json

* * Describe * @return et.Json *

func (*Column) Fk added in v1.0.5 

func (s *Column) Fk() string

* * Fk * @return string *

func (*Column) GetField 

func (s *Column) GetField() *Field

* * GetField * @return *Field *

type ColumnField 

type ColumnField string
var (
	IndexField     ColumnField = INDEX
	SourceField    ColumnField = SOURCE
	ProjectField   ColumnField = PROJECT
	CreatedAtField ColumnField = CREATED_AT
	UpdatedAtField ColumnField = UPDATED_AT
	StateField     ColumnField = STATUS
	KeyField       ColumnField = KEY
	SystemKeyField ColumnField = SYSID
	CreatedToField ColumnField = CREATED_TO
	UpdatedToField ColumnField = UPDATED_TO
	FullTextField  ColumnField = FULLTEXT
)

func (ColumnField) TypeData 

func (s ColumnField) TypeData() TypeData

type Command 

type Command struct {
	*QlFilter
	Db         *DB
	TypeSelect TypeSelect `json:"type_select"`
	From       *QlFrom
	Command    TypeCommand
	Origin     []et.Json
	Values     []*Value
	Undo       *UndoRecord
	Sql        string
	Source     string
	Result     et.Items
}

func NewCommand 

func NewCommand(model *Model, data []et.Json, command TypeCommand) *Command

* * NewCommand * @param model *Model * @param data []et.Json * @param command TypeCommand * @return *Command *

func (*Command) And 

func (s *Command) And(val interface{}) *QlFilter

* * And * @param val interface{} * @return *QlFilter *

func (*Command) Data 

func (s *Command) Data(fields ...string) *Ql

* * Data * @param fields ...string * @return *Ql *

func (*Command) Debug 

func (s *Command) Debug() *Command

* * Debug * @return *Command *

func (*Command) Describe 

func (s *Command) Describe() et.Json

* * Describe * @return et.Json *

func (*Command) Exec 

func (s *Command) Exec() (et.Items, error)

* * Exec * @return et.Items, error *

func (*Command) GetReturn added in v1.0.5 

func (s *Command) GetReturn(name string) *QlSelect

* * GetReturn * @param name string * @return *QlSelect *

func (*Command) One 

func (s *Command) One() (et.Item, error)

* * One * @return et.Item, error *

func (*Command) Or 

func (s *Command) Or(val interface{}) *QlFilter

* * And * @param field string * @return *QlFilter *

func (*Command) Select added in v1.0.5 

func (s *Command) Select(fields ...string) *Ql

* * Select * @param fields ...string * @return *Ql *

func (*Command) Where 

func (s *Command) Where(val interface{}) *Command

* * Where * @param field string * @return *Command *

type Concat added in v1.0.3 

type Concat map[string]interface{}

func Concatenate added in v1.0.3 

func Concatenate(args ...any) Concat

type Connector 

type Connector int
const (
	NoC Connector = iota
	And
	Or
)

func (Connector) Str 

func (s Connector) Str() string

type Context added in v1.0.5 

type Context struct {
	Ok      bool        `json:"ok"`
	Message Message     `json:"message"`
	Data    interface{} `json:"data"`
}

func NewContext added in v1.0.5 

func NewContext(data interface{}) *Context

* * NewContext * @param data interface{} * @return *Context *

type DB 

type DB struct {
	CreatedAt   time.Time          `json:"created_date"`
	UpdateAt    time.Time          `json:"update_date"`
	Id          string             `json:"id"`
	Name        string             `json:"name"`
	Description string             `json:"description"`
	Schemas     map[string]*Schema `json:"schemas"`
	UseCore     bool               `json:"use_core"`
	Node        int64              `json:"node"`
	// contains filtered or unexported fields
}

func ConnectTo 

func ConnectTo(params et.Json) (*DB, error)

func Load 

func Load() (*DB, error)

func NewDatabase 

func NewDatabase(name, driver string) (*DB, error)

* * NewDatabase * @param driver string * @return *DB *

func (*DB) ChangePassword 

func (s *DB) ChangePassword(username, password, confirmation string) error

* * ChangePassword * @return error *

func (*DB) Command 

func (s *DB) Command(command *Command) (et.Items, error)

* * Command * @param command *Command * @return et.Item, error *

func (*DB) Conected 

func (s *DB) Conected(params et.Json) error

* * Conected * @return bool *

func (*DB) Count 

func (s *DB) Count(ql *Ql) (int, error)

* * Count * @param ql *Ql * @return int, error *

func (*DB) CreateCore added in v1.0.4 

func (s *DB) CreateCore() error

* * CreateCore * @return error *

func (*DB) CreateSchema added in v1.0.3 

func (s *DB) CreateSchema(name string) error

* * CreateSchema * @param name string * @return error *

func (*DB) CreateUser 

func (s *DB) CreateUser(username, password, confirmation string) error

* * CreateUser * @return error *

func (*DB) CurrentSerie 

func (s *DB) CurrentSerie(tag string) int64

* * CurrentSerie * @param tag string * @return int64 *

func (*DB) Data added in v1.0.5 

func (s *DB) Data(source, sql string, params ...any) (et.Items, error)

* * Data * @param source string * @param sql string * @param params ...any * @return et.Item, error *

func (*DB) DeleteKey added in v1.0.5 

func (s *DB) DeleteKey(key string) error

* * DeleteKey * @param key string * @return error *

func (*DB) DeleteUser 

func (s *DB) DeleteUser(username string) error

* * DeleteUser * @return error *

func (*DB) Describe 

func (s *DB) Describe() et.Json

* * Describe * @return et.Json *

func (*DB) Disconected 

func (s *DB) Disconected() error

* * Disconected * @return error *

func (*DB) DropModel 

func (s *DB) DropModel(model *Model) error

* * DropModel * @param model *Model *

func (*DB) DropSchema 

func (s *DB) DropSchema(name string) error

* * DropSchema * @param name string * @return error *

func (*DB) Exec added in v1.0.3 

func (s *DB) Exec(sql string, params ...any) error

* * Exec * @param sql string * @param params ...any * @return error *

func (*DB) FindKeys added in v1.0.5 

func (s *DB) FindKeys(search string, page, rows int) (et.List, error)

* * FindKeys * @param search string * @param page int * @param rows int * @return et.List, error *

func (*DB) GetKey added in v1.0.5 

func (s *DB) GetKey(key string) (et.KeyValue, error)

* * GetKey * @param key string * @return et.KeyValue, error *

func (*DB) GetSerie 

func (s *DB) GetSerie(tag string) int64

* * GetSerie * @return int64 *

func (*DB) GrantPrivileges 

func (s *DB) GrantPrivileges(username, dbName string) error

* * GrantPrivileges * @return error *

func (*DB) LoadByTable added in v1.0.5 

func (s *DB) LoadByTable(model *Model) error

* * LoadByTable * @param model *Model * @return error *

func (*DB) LoadModel 

func (s *DB) LoadModel(model *Model) error

* * LoadModel * @param model *Model * @return error *

func (*DB) NextCode added in v1.0.3 

func (s *DB) NextCode(tag, format string) string

* * NextCode * @param tag string * @param format string "%08v" "PREFIX-%08v-SUFFIX" * @return string *

func (*DB) Query 

func (s *DB) Query(sql string, params ...any) (et.Items, error)

* * Query * @param sql string * @param params ...any * @return et.Items, error *

func (*DB) Select 

func (s *DB) Select(ql *Ql) (et.Items, error)

* * Select * @param ql *Ql * @return et.Items, error *

func (*DB) SetKey added in v1.0.5 

func (s *DB) SetKey(key string, value []byte) error

* * SetKey * @param key string * @param value value []byte * @return error *

func (*DB) SetMain 

func (s *DB) SetMain(params et.Json) error

* * SetMain * @param params et.Json * @return error *

func (*DB) SetSerie 

func (s *DB) SetSerie(tag string, val int) int64

* * SetSerie * @return int64 *

type Detail added in v1.0.3 

type Detail struct {
	*Model
	Fkn string `json:"fkn"`
}

type Dictionary added in v1.0.3 

type Dictionary struct {
	Column       *Column
	Key          string
	Value        interface{}
	Columns      []*Column
	Dictionaries map[string][]*Dictionary
}

func NewDictionary added in v1.0.3 

func NewDictionary(model *Model, key string, value interface{}) *Dictionary

* * NewDictionary * @param key string * @param value interface{} * @return *Dictionary *

func (*Dictionary) DefineAtribute added in v1.0.3 

func (s *Dictionary) DefineAtribute(name string, typeData TypeData, def interface{}) *Column

* * DefineAtribute * @param name string * @param typeData TypeData * @param def interface{} * @return *Model *

func (*Dictionary) DefineDictionary added in v1.0.5 

func (s *Dictionary) DefineDictionary(key, value string) *Dictionary

* * DefineDictionary * @param name string * @param key string * @param value interface{} * @return *Dictionary *

func (*Dictionary) DefineList added in v1.0.5 

func (s *Dictionary) DefineList(name string, typeData TypeData, values []interface{}, def interface{}) *Column

* * DefineList * @param name string * @param typeData TypeData * @param def interface{} * @return *Model *

func (*Dictionary) Describe added in v1.0.5 

func (s *Dictionary) Describe() et.Json

* * Describe * @return et.Json *

type Driver 

type Driver interface {
	Name() string
	Connect(params et.Json) error
	Disconnect() error
	SetMain(params et.Json) error
	// Database
	CreateDatabase(name string) error
	DropDatabase(name string) error
	// Core
	CreateCore() error
	// User
	GrantPrivileges(username, dbName string) error
	CreateUser(username, password, confirmation string) error
	ChangePassword(username, password, confirmation string) error
	DeleteUser(username string) error
	// Schema
	CreateSchema(name string) error
	DropSchema(name string) error
	// Model
	LoadModel(model *Model) error
	LoadByTable(model *Model) error
	DropModel(model *Model) error
	// Query
	Exec(sql string, params ...any) error
	Query(sql string, params ...any) (et.Items, error)
	Data(source, sql string, params ...any) (et.Items, error)
	Select(ql *Ql) (et.Items, error)
	Count(ql *Ql) (int, error)
	// Command
	Command(command *Command) (et.Items, error)
	// Series
	GetSerie(tag string) int64
	NextCode(tag, prefix string) string
	SetSerie(tag string, val int) int64
	CurrentSerie(tag string) int64
	// Key Value
	SetKey(key string, value []byte) error
	GetKey(key string) (et.KeyValue, error)
	DeleteKey(key string) error
	FindKeys(search string, page, rows int) (et.List, error)
}

type Event 

type Event func(model *Model, before et.Json, after et.Json) error

type Field 

type Field struct {
	Owner      interface{}
	Column     *Column
	Schema     string
	Table      string
	As         string
	Field      string
	Name       string
	Atrib      string
	Agregation TypeAgregation
	Alias      string
	Value      interface{}
}

func GetField added in v1.0.5 

func GetField(name string, isCreated bool) *Field

* * GetField * @param name string, isCreated bool * @return *Field *

func (*Field) AsField added in v1.0.5 

func (s *Field) AsField() string

* * AsField * @return string *

func (*Field) Caption added in v1.0.5 

func (s *Field) Caption() string

* * Caption * @return string *

func (*Field) Define added in v1.0.5 

func (s *Field) Define() et.Json

func (*Field) TableField added in v1.0.5 

func (s *Field) TableField() string

* * TableField * @return string *

func (*Field) TableName added in v1.0.5 

func (s *Field) TableName() string

* * TableName * @return string *

type FilterTo added in v1.0.5 

type FilterTo interface {
	And(val interface{}) *QlFilter
	Or(val interface{}) *QlFilter
	Select(fields ...string) *Ql
	Data(fields ...string) *Ql
	Exec() (et.Items, error)
	One() (et.Item, error)
}

type Flow added in v1.0.5 

type Flow struct {
	Id          string `json:"id"`
	Name        string `json:"name"`
	Description string `json:"description"`
	Steps       []*Step
}

func NewFlow added in v1.0.5 

func NewFlow(name, description string) *Flow

* * NewFlow * @param name string * @param description string * @return *Flow *

func (*Flow) Run added in v1.0.5 

func (s *Flow) Run(status chan *Context)

type FullText 

type FullText []*Field

type FuncGenerated added in v1.0.5 

type FuncGenerated func(col *Column, data *et.Json)

type Function added in v0.0.1 

type Function struct {
	Id           string
	Name         string
	Description  string
	TypeFunction TypeFunction
	Definition   string
}

func NewFunction added in v1.0.3 

func NewFunction(name string, tp TypeFunction) *Function

* * NewFunction * @param name string * @param tp TypeFunction * @return *Function *

func (*Function) Exec added in v1.0.5 

func (s *Function) Exec(params et.Json) et.Json

* * Exec * @param params et.Json * @return et.Json *

type HandlerListener added in v1.0.4 

type HandlerListener func(res et.Json)

type Index 

type Index struct {
	Column *Column
	Sorted bool
}

func NewIndex added in v1.0.3 

func NewIndex(col *Column, sorted bool) *Index

* * NewIndex * @param col *Column * @param sorted bool * @return *Index *

type Message added in v1.0.5 

type Message struct {
	Code    int    `json:"code"`
	Message string `json:"message"`
}

type Model 

type Model struct {
	Db             *DB                      `json:"-"`
	Schema         *Schema                  `json:"-"`
	CreatedAt      time.Time                `json:"created_date"`
	UpdateAt       time.Time                `json:"update_date"`
	Name           string                   `json:"name"`
	Table          string                   `json:"table"`
	Description    string                   `json:"description"`
	Columns        []*Column                `json:"columns"`
	Indices        map[string]*Index        `json:"indices"`
	Uniques        map[string]*Index        `json:"uniques"`
	Keys           map[string]*Column       `json:"keys"`
	ForeignKeys    map[string]*Reference    `json:"foreign_keys"`
	References     []*Reference             `json:"references"`
	Relations      []*Relation              `json:"relations"`
	Dictionaries   map[string][]*Dictionary `json:"dictionaries"`
	ColRequired    map[string]bool          `json:"col_required"`
	CreatedAtField *Column                  `json:"created_at_field"`
	UpdatedAtField *Column                  `json:"updated_at_field"`
	KeyField       *Column                  `json:"key_field"`
	Source         string                   `json:"source"`
	SourceField    *Column                  `json:"source_field"`
	SystemKeyField *Column                  `json:"system_key_field"`
	StateField     *Column                  `json:"state_field"`
	IndexField     *Column                  `json:"index_field"`
	FullTextField  *Column                  `json:"full_text_field"`
	EventsInsert   []Event                  `json:"-"`
	EventsUpdate   []Event                  `json:"-"`
	EventsDelete   []Event                  `json:"-"`
	Details        map[string]*Detail       `json:"-"`
	Functions      map[string]*Function     `json:"-"`
	Integrity      bool                     `json:"integrity"`
	Log            int64                    `json:"log"`
	History        *Model                   `json:"-"`
	HistoryLimit   int64                    `json:"history_limit"`
	Vmj            *goja.Runtime            `json:"-"`
	Version        int                      `json:"version"`
	Show           bool                     `json:"-"`
}

func GetModel 

func GetModel(name string, isCreated bool) *Model

* * GetModel * @param name string * @param isCreated bool * @return *Model *

func NewModel 

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

* * NewModel * @param schema *Schema * @param name string * @return *Model *

func (*Model) Bulk 

func (s *Model) Bulk(data []et.Json) *Command

* * Bulk * @param data []et.Json * @return *Command *

func (*Model) Command added in v1.0.5 

func (s *Model) Command(params et.Json) (et.Items, error)

* * Command * @param params et.Json * @return et.Items, error *

func (*Model) Debug 

func (s *Model) Debug() *Model

* * Debug * @return *Model *

func (*Model) DefineAtribute 

func (s *Model) DefineAtribute(name string, typeData TypeData) *Column

* * DefineAtribute * @param name string * @param typeData TypeData * @param def interface{} * @return *Model *

func (*Model) DefineColumn 

func (s *Model) DefineColumn(name string, typeData TypeData) *Column

* * DefineColumn * @param name string * @param typeData TypeData * @param def interface{} * @return *Model *

func (*Model) DefineCreatedAtField 

func (s *Model) DefineCreatedAtField() *Column

* * DefineCreatedAtField * @return *Column *

func (*Model) DefineDetail 

func (s *Model) DefineDetail(name, fkn string, version int) *Model

* * DefineDetail * @param name string * @param fkn string * @param version int * @param detail Detail * @return *Model *

func (*Model) DefineDictionary added in v1.0.3 

func (s *Model) DefineDictionary(key, value string) *Dictionary

* * DefineDictionary * @param name string * @param key string * @param value interface{} * @return *Dictionary *

func (*Model) DefineEvent 

func (s *Model) DefineEvent(tp TypeEvent, event Event)

* * DefineEvent * @param tp TypeEvent * @param event Event * @return *Model *

func (*Model) DefineFullText 

func (s *Model) DefineFullText(language string, fields []string) *Column

* * DefineFullText * @param fields []string * @return language string * @return *Column *

func (*Model) DefineFunction added in v1.0.3 

func (s *Model) DefineFunction(name string, tp TypeFunction, definition string) *Function

* * DefineFunction * @param name string * @param function string * @return *Model *

func (*Model) DefineGenerated 

func (s *Model) DefineGenerated(name string, f FuncGenerated)

* * DefineGenerate * @param name string * @param function string * @return *Model *

func (*Model) DefineHidden 

func (s *Model) DefineHidden(colums ...string) *Model

* * DefineHidden * @param colums ...string * @return *Model *

func (*Model) DefineHistory 

func (s *Model) DefineHistory(n int64, fkn string, version int) error

* * DefineHistory * @param n int * @param fkn string * @param version int * @return error *

func (*Model) DefineIdxColumn added in v1.0.5 

func (s *Model) DefineIdxColumn(name string, typeData TypeData, idx int) *Column

* * DefineIdxColumn * @param name string * @param typeData TypeData * @param idx int * @param def interface{} * @return *Model *

func (*Model) DefineIndex 

func (s *Model) DefineIndex(sort bool, colums ...string) *Model

* * DefineIndex * @param colums ...*Column * @return *Model *

func (*Model) DefineIndexField 

func (s *Model) DefineIndexField() *Column

* * DefineIndexField * @return *Column *

func (*Model) DefineKey added in v1.0.3 

func (s *Model) DefineKey(colums ...string) *Model

* * DefineKey * @param colums ...*Column * @return *Model *

func (*Model) DefineKeyField added in v1.0.5 

func (s *Model) DefineKeyField() *Column

* * DefineKeyField * @return *Column *

func (*Model) DefineLog added in v1.0.5 

func (s *Model) DefineLog(n int64)

* * DefineLog * @param n int64 *

func (*Model) DefineManyToOne added in v1.0.5 

func (s *Model) DefineManyToOne(to *Model, fkn string) *Model

* * DefineManyToOne * @param to *Model * @param fkn string * @return *Model *

func (*Model) DefineOneToMany added in v1.0.5 

func (s *Model) DefineOneToMany(to *Model, fkn string) *Model

* * DefineOneToMany * @param to *Model * @param fkn string * @return *Model *

func (*Model) DefinePrimaryKey 

func (s *Model) DefinePrimaryKey(name string) *Column

* * DefinePrimaryKey * @param name string * @return *Column *

func (*Model) DefineProjectField 

func (s *Model) DefineProjectField() *Column

* * DefineProjectField * @return *Column *

func (*Model) DefineRelation 

func (s *Model) DefineRelation(name string, fkn, tag string)

* * DefineRelation * @param name string * @param fkn string * @param tag string *

func (*Model) DefineRequired 

func (s *Model) DefineRequired(requireds ...string) *Model

* * DefineRequired * @param requireds ...string * @return *Model *

func (*Model) DefineRollup 

func (s *Model) DefineRollup(name string, fkn, tag string)

* * DefineRollup * @param name string * @param fkn string * @param tag string *

func (*Model) DefineSourceField 

func (s *Model) DefineSourceField(name string) *Column

* * DefineSourceField * @return *Column *

func (*Model) DefineStateField added in v1.0.5 

func (s *Model) DefineStateField() *Column

* * DefineStateField * @return *Column *

func (*Model) DefineSystemKeyField 

func (s *Model) DefineSystemKeyField() *Column

* * DefineSystemKeyField * @return *Column *

func (*Model) DefineUnique 

func (s *Model) DefineUnique(colums ...string) *Model

* * DefineUnique * @param colums ...*Column * @return *Model *

func (*Model) DefineUpdatedAtField 

func (s *Model) DefineUpdatedAtField() *Column

* * DefineUpdatedAtField * @return *Column *

func (*Model) Delete 

func (s *Model) Delete() *Command

* * Delete * @return *Command *

func (*Model) Describe 

func (s *Model) Describe() et.Json

* * Describe * @return et.Json *

func (*Model) Drop 

func (s *Model) Drop()

* * Drop *

func (*Model) FullText added in v1.0.3 

func (s *Model) FullText(fields ...string) FullText

func (*Model) GenId 

func (s *Model) GenId(id string) string

* * GenId * @param id string * @return string *

func (*Model) GenKey added in v1.0.5 

func (s *Model) GenKey(id string) string

* * GenKey * @param id string * @return string *

func (*Model) GetColumn added in v1.0.3 

func (s *Model) GetColumn(name string) *Column

* * GetColumn * @param name string * @return *Column *

func (*Model) GetColumns added in v1.0.3 

func (s *Model) GetColumns(names ...string) []*Column

* * GetColumns * @param name string * @return *Column *

func (*Model) GetField added in v1.0.5 

func (s *Model) GetField(name string, isCreated bool) *Field

* * GetField * @param name string, isCreated bool * @return *Field *

func (*Model) GetKeys added in v1.0.5 

func (s *Model) GetKeys() []*Column

* * GetKeys * @return []*Column *

func (*Model) GetSerie 

func (s *Model) GetSerie() int64

* * GetSerie * @return int *

func (*Model) Init 

func (s *Model) Init() error

* * Init * @return error *

func (*Model) Insert 

func (s *Model) Insert(data et.Json) *Command

* * Insert * @param data []et.Json * @return *Command *

func (*Model) Load added in v1.0.5 

func (s *Model) Load(data []byte) error

* * Deserialize * @param data []byte * @return error *

func (*Model) LoadByTable added in v1.0.5 

func (s *Model) LoadByTable() error

* * LoadByTable * @return error *

func (*Model) Low added in v1.0.5 

func (s *Model) Low() string

* * Low * @return string *

func (*Model) MakeCollection added in v1.0.5 

func (s *Model) MakeCollection() *Model

* * MakeCollection * @return *Model *

func (*Model) New 

func (s *Model) New(data et.Json) et.Json

* * New * @param data et.Json * @return et.Json *

func (*Model) Object added in v1.0.5 

func (s *Model) Object(id string) *dt.Object

* * Object * @param id string * @return *dt.Object *

func (*Model) ObjectUp added in v1.0.5 

func (s *Model) ObjectUp(id string, item et.Item) *dt.Object

* * ObjectUp * @param id string * @return *dt.Object *

func (*Model) OnListener added in v1.0.4 

func (s *Model) OnListener(channels []string, listener HandlerListener)

func (*Model) Serialized added in v1.0.5 

func (s *Model) Serialized() ([]byte, error)

* * Serialized * @return []byte, error *

func (*Model) SetField added in v1.0.5 

func (s *Model) SetField(name string, isCreated bool) *Field

* * SetField * @param name string * @return *Field *

func (*Model) Undo 

func (s *Model) Undo(key string, index int64) *Command

* * Undo * @param key string * @param index int64 * @return *Command *

func (*Model) Up added in v1.0.5 

func (s *Model) Up() string

* * Up * @return string *

func (*Model) Update 

func (s *Model) Update(data et.Json) *Command

* * Update * @param data []et.Json * @return *Command *

func (*Model) Where 

func (s *Model) Where(val interface{}) *Ql

* * Where * @param val interface{} * @return *Ql *

type Operator 

type Operator int
const (
	NoP Operator = iota
	Equal
	Neg
	In
	Like
	More
	Less
	MoreEq
	LessEq
	Between
	IsNull
	NotNull
	Search
)

func (Operator) Str 

func (s Operator) Str() string

type Ql 

type Ql struct {
	*QlFilter
	Db         *DB              `json:"-"`
	TypeSelect TypeSelect       `json:"type_select"`
	Froms      []*QlFrom        `json:"froms"`
	Selects    []*QlSelect      `json:"selects"`
	Joins      []*QlJoin        `json:"joins"`
	Groups     []*QlSelect      `json:"group_bys"`
	Havings    *QlHaving        `json:"havings"`
	Orders     []*QlOrder       `json:"orders"`
	Details    []*QlSelect      `json:"details"`
	Generateds []*FuncGenerated `json:"generateds"`
	Sheet      int              `json:"sheet"`
	Offset     int              `json:"offset"`
	Limit      int              `json:"limit"`
	Sql        string           `json:"sql"`
	Source     string           `json:"source"`
	Result     et.Items         `json:"result"`
	// contains filtered or unexported fields
}

func From 

func From(m *Model) *Ql

func (*Ql) All 

func (s *Ql) All() (et.Items, error)

* * All * @return et.Items, error *

func (*Ql) And 

func (s *Ql) And(val interface{}) *QlFilter

* * And * @param val interface{} * @return *QlFilter *

func (*Ql) Avg 

func (s *Ql) Avg(field string) *Ql

* * Avg * @param field string * @return *Ql *

func (*Ql) Count 

func (s *Ql) Count(field string) *Ql

* * Count * @param field string * @return *Ql *

func (*Ql) Data 

func (s *Ql) Data(fields ...string) *Ql

* * Data * @param fields ...string * @return *Ql *

func (*Ql) Debug 

func (s *Ql) Debug() *Ql

* * Debug * @return *Ql *

func (*Ql) Describe 

func (s *Ql) Describe() et.Json

func (*Ql) Exec added in v1.0.5 

func (s *Ql) Exec() (et.Items, error)

* * Exec * @return et.Items, error *

func (*Ql) First 

func (s *Ql) First(n int) (et.Items, error)

* * First * @param n int * @return et.Items, error *

func (*Ql) FullJoin 

func (s *Ql) FullJoin(m *Model) *QlJoin

* * FullJoin * @param m *Model * @return *Ql *

func (*Ql) GetAgregation added in v1.0.5 

func (s *Ql) GetAgregation(name string) *Field

* * GetAgregation * @params name string * @return *Field *

func (*Ql) GetDetails added in v1.0.5 

func (s *Ql) GetDetails(data et.Json) et.Json

* * GetDetails * @return et.Json *

func (*Ql) GetField added in v1.0.5 

func (s *Ql) GetField(name string, isCreated bool) *Field

* * GetField * @param name string, isCreated bool * @return *Field *

func (*Ql) GetSelect added in v1.0.5 

func (s *Ql) GetSelect(name string) *QlSelect

* * GetSelect * @param name string * @return *QlSelect *

func (*Ql) GroupBy 

func (s *Ql) GroupBy(fields ...string) *Ql

* * GroupBy * @param fields ...string * @return *Ql *

func (*Ql) Having 

func (s *Ql) Having(field string) *QlHaving

* * Having * @param field string * @return *QlWhere *

func (*Ql) Join 

func (s *Ql) Join(m *Model) *QlJoin

* * QlJoin * @param m *Model * @return *Ql *

func (*Ql) Last 

func (s *Ql) Last(n int) (et.Items, error)

* * Last * @param n int * @return et.Items, error *

func (*Ql) LeftJoin 

func (s *Ql) LeftJoin(m *Model) *QlJoin

* * LeftJoin * @param m *Model * @return *Ql *

func (*Ql) List 

func (s *Ql) List(page, rows int) (et.List, error)

* * List * @param page int * @param rows int * @return et.List, error *

func (*Ql) Max 

func (s *Ql) Max(field string) *Ql

* * Max * @param field string * @return *Ql *

func (*Ql) Min 

func (s *Ql) Min(field string) *Ql

* * Min * @param field string * @return *Ql *

func (*Ql) One 

func (s *Ql) One() (et.Item, error)

* * One * @return et.Item, error *

func (*Ql) Or 

func (s *Ql) Or(val interface{}) *QlFilter

* * And * @param val interface{} * @return *QlFilter *

func (*Ql) OrderBy 

func (s *Ql) OrderBy(sorted bool, columns ...string) *Ql

* * OrderBy * @param sorted bool * @param columns ...string * @return *Ql *

func (*Ql) OrderByAsc 

func (s *Ql) OrderByAsc(columns ...string) *Ql

* * OrderByAsc * @param columns ...any * @return *Ql *

func (*Ql) OrderByDesc 

func (s *Ql) OrderByDesc(columns ...string) *Ql

* * OrderByDesc * @param columns ...any * @return *Ql *

func (*Ql) Page 

func (s *Ql) Page(val int) *Ql

* * Offset * @param offset int * @return *Ql *

func (*Ql) Query 

func (s *Ql) Query(params et.Json) (et.Items, error)

* * Query * @param params []string * @return Ql *

func (*Ql) RightJoin 

func (s *Ql) RightJoin(m *Model) *QlJoin

* * RightJoin * @param m *Model * @return *Ql *

func (*Ql) Rows 

func (s *Ql) Rows(val int) (et.Items, error)

* * Limit * @param limit int * @return *Ql *

func (*Ql) Select 

func (s *Ql) Select(fields ...string) *Ql

* * Select * @param fields ...string * @return *Ql *

func (*Ql) Sum 

func (s *Ql) Sum(field string) *Ql

* * Sum * @param field string * @return *Ql *

func (*Ql) Where 

func (s *Ql) Where(val interface{}) *Ql

* * Where * @param val interface{} * @return *QlFilter *

type QlFilter added in v1.0.5 

type QlFilter struct {
	Wheres []*QlWhere
	Show   bool
	// contains filtered or unexported fields
}

func (*QlFilter) AddValue added in v1.0.5 

func (s *QlFilter) AddValue(val interface{}) FilterTo

* * AddValue * @param val interface{} * @return *QlFilter *

func (*QlFilter) All added in v1.0.5 

func (s *QlFilter) All() (et.Items, error)

* * All * @return et.Items, error *

func (*QlFilter) Between added in v1.0.5 

func (s *QlFilter) Between(val interface{}) FilterTo

* * Between * @param val1, val2 interface{} * @return FilterTo *

func (*QlFilter) Eq added in v1.0.5 

func (s *QlFilter) Eq(val interface{}) FilterTo

* * Eq * @param val interface{} * @return FilterTo *

func (*QlFilter) First added in v1.0.5 

func (s *QlFilter) First(n int) (et.Items, error)

* * First * @param n int * @return et.Items, error *

func (*QlFilter) In added in v1.0.5 

func (s *QlFilter) In(val ...any) FilterTo

* * In * @param val ...any * @return FilterTo *

func (*QlFilter) IsNull added in v1.0.5 

func (s *QlFilter) IsNull() *QlFilter

* * IsNull * @return *QlFilter *

func (*QlFilter) Last added in v1.0.5 

func (s *QlFilter) Last(n int) (et.Items, error)

* * Last * @param n int * @return et.Items, error *

func (*QlFilter) Less added in v1.0.5 

func (s *QlFilter) Less(val interface{}) FilterTo

* * Less * @param val interface{} * @return FilterTo *

func (*QlFilter) LessEq added in v1.0.5 

func (s *QlFilter) LessEq(val interface{}) FilterTo

* * LessEq * @param val interface{} * @return FilterTo *

func (*QlFilter) Like added in v1.0.5 

func (s *QlFilter) Like(val interface{}) FilterTo

* * Like * @param val interface{} * @return FilterTo *

func (*QlFilter) List added in v1.0.5 

func (s *QlFilter) List(page, rows int) (et.List, error)

* * List * @param page, rows int * @return et.List, error *

func (*QlFilter) More added in v1.0.5 

func (s *QlFilter) More(val interface{}) FilterTo

* * More * @param val interface{} * @return FilterTo *

func (*QlFilter) MoreEq added in v1.0.5 

func (s *QlFilter) MoreEq(val interface{}) FilterTo

* * MoreEq * @param val interface{} * @return FilterTo *

func (*QlFilter) Neg added in v1.0.5 

func (s *QlFilter) Neg(val interface{}) FilterTo

* * Neg * @param val interface{} * @return FilterTo *

func (*QlFilter) NotNull added in v1.0.5 

func (s *QlFilter) NotNull() *QlFilter

* * NotNull * @return *QlFilter *

func (*QlFilter) One added in v1.0.5 

func (s *QlFilter) One() (et.Item, error)

* * One * @return et.Item, error *

func (*QlFilter) Page added in v1.0.5 

func (s *QlFilter) Page(val int) *Ql

* * Page * @param val int * @return *Ql *

func (*QlFilter) Query added in v1.0.5 

func (s *QlFilter) Query(params et.Json) (et.Items, error)

* * Query * @param params et.Json * @return (et.Items, error) *

func (*QlFilter) Rows added in v1.0.5 

func (s *QlFilter) Rows(val int) (et.Items, error)

* * Rows * @param val int * @return et.Items, error *

func (*QlFilter) Search added in v1.0.5 

func (s *QlFilter) Search(language string, val interface{}) FilterTo

* * Search * @param val interface{} * @return FilterTo *

type QlFrom 

type QlFrom struct {
	*Model
	As      string
	Selects []*QlSelect
}

func (*QlFrom) GetField added in v1.0.5 

func (s *QlFrom) GetField(name string, isCreated bool) *Field

* * GetField * @param name string, isCreated bool * @return *Field *

func (*QlFrom) SetSelectByColumns added in v1.0.5 

func (s *QlFrom) SetSelectByColumns(selects, details *[]*QlSelect)

* * SetSelectByColumns * @param selects []*QlSelect, details []*QlSelect *

func (*QlFrom) SetSelectBySelects added in v1.0.5 

func (s *QlFrom) SetSelectBySelects(selects, details *[]*QlSelect)

* * SetSelectBySelects * @param selects []*QlSelect, details []*QlSelect *

type QlHaving 

type QlHaving struct {
	*QlFilter
	Ql *Ql
}

func (*QlHaving) And 

func (s *QlHaving) And(val interface{}) *QlFilter

* * And * @param field string * @return *QlFilter *

func (*QlHaving) Data 

func (s *QlHaving) Data(fields ...string) *Ql

* * Data * @param fields ...string * @return *Ql *

func (*QlHaving) Exec added in v1.0.5 

func (s *QlHaving) Exec() (et.Items, error)

* * Exec * @return et.Items, error *

func (*QlHaving) One added in v1.0.5 

func (s *QlHaving) One() (et.Item, error)

* * One * @return et.Item, error *

func (*QlHaving) Or 

func (s *QlHaving) Or(val interface{}) *QlFilter

* * Or * @param field string * @return *QlFilter *

func (*QlHaving) Select 

func (s *QlHaving) Select(fields ...string) *Ql

* * Select * @param fields ...string * @return *Ql *

type QlJoin 

type QlJoin struct {
	*QlFilter
	Ql       *Ql
	TypeJoin TypeJoin
	From     *QlFrom
}

func (*QlJoin) And 

func (s *QlJoin) And(val interface{}) *QlFilter

* * And * @param field string * @return *QlFilter *

func (*QlJoin) Data 

func (s *QlJoin) Data(fields ...string) *Ql

* * Data * @param fields ...string * @return *Ql *

func (*QlJoin) Exec added in v1.0.5 

func (s *QlJoin) Exec() (et.Items, error)

* * Exec * @return et.Items, error *

func (*QlJoin) On 

func (s *QlJoin) On(field string) *QlFilter

* * On * @param name string * @return *Ql *

func (*QlJoin) One added in v1.0.5 

func (s *QlJoin) One() (et.Item, error)

* * One * @return et.Item, error *

func (*QlJoin) Or 

func (s *QlJoin) Or(val interface{}) *QlFilter

* * Or * @param field string * @return *QlFilter *

func (*QlJoin) Select 

func (s *QlJoin) Select(fields ...string) *Ql

* * Select * @param fields ...string * @return *Ql *

type QlOrder 

type QlOrder struct {
	Field  *Field
	Sorted bool
}

type QlSelect added in v1.0.5 

type QlSelect struct {
	From  *QlFrom
	Field *Field
}

func NewQlSelect added in v1.0.5 

func NewQlSelect(from *QlFrom, field *Field) *QlSelect

* * NewQlSelect * @param from *QlFrom * @param name string * @return *QlSelect *

func (*QlSelect) GetField added in v1.0.5 

func (s *QlSelect) GetField(name string, isCreated bool) *Field

* * GetField * @param name string, isCreated bool * @return *Field *

func (*QlSelect) TypeColumn added in v1.0.5 

func (s *QlSelect) TypeColumn() TypeColumn

* * TypeColumn * @return TypeColumn *

type QlWhere 

type QlWhere struct {
	Conector Connector
	Key      interface{}
	Operator Operator
	Values   []interface{}
	Language string
}

func NewQlWhere 

func NewQlWhere(key interface{}) *QlWhere

* * NewQlWhere * @params key interface{} * @return QlWhere *

func (*QlWhere) GetKey added in v1.0.5 

func (s *QlWhere) GetKey() string

* * GetKey * @return string *

func (*QlWhere) GetValue added in v1.0.5 

func (s *QlWhere) GetValue(val interface{}) string

* * getValue * @param val interface{} * @return string *

func (*QlWhere) String added in v1.0.5 

func (s *QlWhere) String() string

* * String * @return string *

type RID added in v1.0.5 

type RID struct {
	Id     string `json:"id"`
	Schema string `json:"schema"`
	Table  string `json:"table"`
	Model  string `json:"model"`
}

func GetRID added in v1.0.5 

func GetRID(id string) *RID

type Reference added in v1.0.5 

type Reference struct {
	Key             *Column
	TypeRelation    TypeRelation
	To              *Column
	OnDeleteCascade bool
	OnUpdateCascade bool
}

func NewReference added in v1.0.5 

func NewReference(key *Column, tp TypeRelation, to *Column) *Reference

type Relation 

type Relation struct {
	Type   TypeColumn
	Column *Column
	To     *Column
}

type Schema 

type Schema struct {
	Db          *DB               `json:"-"`
	CreatedAt   time.Time         `json:"created_date"`
	UpdateAt    time.Time         `json:"update_date"`
	Name        string            `json:"name"`
	Description string            `json:"description"`
	Models      map[string]*Model `json:"models"`
}

func GetShema 

func GetShema(name string, isCreate bool) *Schema

* * GetShema * @param name string * @param isCreate bool * @return *Schema *

func NewSchema 

func NewSchema(db *DB, name string) (*Schema, error)

func (*Schema) Describe 

func (s *Schema) Describe() et.Json

* * Describe * @return et.Json *

func (*Schema) Init added in v1.0.3 

func (s *Schema) Init() error

* * Init * @return error *

func (*Schema) Low added in v1.0.5 

func (s *Schema) Low() string

* * Low * @return string *

func (*Schema) Up added in v1.0.5 

func (s *Schema) Up() string

* * Up * @return string *

type Step added in v1.0.5 

type Step struct {
	Flow        *Flow
	Id          string `json:"id"`
	Name        string `json:"name"`
	Description string `json:"description"`

	Execute  func(chan *Context) *Context
	Rollback func()
	// contains filtered or unexported fields
}

func NewStep added in v1.0.5 

func NewStep(name, description string, execute func(chan *Context) *Context, rollback func()) *Step

* * NewStep * @param name string, description string, execute func(chan *Context) *Context, rollback func() * @return *Step *

type TypeAgregation 

type TypeAgregation int
const (
	Nag TypeAgregation = iota
	AgregationSum
	AgregationCount
	AgregationAvg
	AgregationMin
	AgregationMax
)

type TypeColumn 

type TypeColumn int
const (
	TpColumn TypeColumn = iota
	TpAtribute
	TpDetail
	TpGenerated
	TpRelation
	TpRollup
)

type TypeCommand 

type TypeCommand int
const (
	Insert TypeCommand = iota
	Update
	Delete
	Bulk
	Undo
)

type TypeData 

type TypeData int
const (
	TypeDataText TypeData = iota
	TypeDataMemo
	TypeDataShortText
	TypeDataKey
	TypeDataState
	TypeDataInt
	TypeDataNumber
	TypeDataPrecision
	TypeDataSerie
	TypeDataBool
	TypeDataTime
	TypeDataBytes
	// Special
	TypeDataObject
	TypeDataArray
	TypeDataGeometry
	TypeDataFullText
	TypeDataNone
	TypeListValues
)

func (TypeData) DefaultValue 

func (s TypeData) DefaultValue() interface{}

func (TypeData) Str 

func (s TypeData) Str() string

type TypeEvent 

type TypeEvent int
const (
	EventInsert TypeEvent = iota
	EventUpdate
	EventDelete
)

func (TypeEvent) Name 

func (s TypeEvent) Name() string

type TypeFunction added in v1.0.3 

type TypeFunction int
const (
	TpSqlFunction TypeFunction = iota
	TpJsFunction
	TpGoFunction
	TpPythonFunction
)

type TypeJoin 

type TypeJoin int
const (
	JoinInner TypeJoin = iota
	JoinLeft
	JoinRight
	JoinFull
)

func (TypeJoin) Str 

func (s TypeJoin) Str() string

type TypeRelation added in v1.0.3 

type TypeRelation int
const (
	RelationOneToOne TypeRelation = iota
	RelationOneToMany
	RelationManyToMany
	RelationManyToOne
)

type TypeSelect 

type TypeSelect int
const (
	Select TypeSelect = iota
	Data
)

type UndoRecord added in v1.0.5 

type UndoRecord struct {
	Key   string `json:"key"`
	Index int64  `json:"index"`
}

type Value added in v1.0.5 

type Value struct {
	Columns et.Json
	Atribs  et.Json
	Data    et.Json
}

func NewValue added in v1.0.5 

func NewValue() *Value

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.