orm

Documentation

Index

• type Check
• type Column
• type DeleteQBuilder
  • func DeleteQuery(db *sql.DB, debug bool) *DeleteQBuilder
  • func (q *DeleteQBuilder) Build() Res
  • func (q *DeleteQBuilder) Delete(input string) *DeleteQBuilder
  • func (q *DeleteQBuilder) Where(inputs ...interface{}) *DeleteQBuilder
• type Dictio
• type FKeys
• type InsertQBuilder
  • func InsertQuery(db *sql.DB, debug bool) *InsertQBuilder
  • func (q *InsertQBuilder) Build() Res
  • func (q *InsertQBuilder) Columns(inputs ...string) *InsertQBuilder
  • func (q *InsertQBuilder) Insert(input string) *InsertQBuilder
  • func (q *InsertQBuilder) Values(inputs ...interface{}) *InsertQBuilder
• type OptionsRes
• type Res
  • func ManageErr(res *Res, debug bool, err error, query string) *Res
• type SelectQBuilder
  • func SelectQuery(db *sql.DB, debug bool) *SelectQBuilder
  • func (q *SelectQBuilder) Build() Res
  • func (q *SelectQBuilder) Count() *SelectQBuilder
  • func (q *SelectQBuilder) From(inputs ...string) *SelectQBuilder
  • func (q *SelectQBuilder) Limit(limit int64) *SelectQBuilder
  • func (q *SelectQBuilder) Offset(offset int64) *SelectQBuilder
  • func (q *SelectQBuilder) Order(order [][2]string) *SelectQBuilder
  • func (q *SelectQBuilder) Select(fields ...string) *SelectQBuilder
  • func (q *SelectQBuilder) Where(inputs ...interface{}) *SelectQBuilder
• type Table
• type UpdateQBuilder
  • func UpdateQuery(db *sql.DB, debug bool) *UpdateQBuilder
  • func (q *UpdateQBuilder) Build() Res
  • func (q *UpdateQBuilder) Set(inputs ...interface{}) *UpdateQBuilder
  • func (q *UpdateQBuilder) SetRaw(inputs ...string) *UpdateQBuilder
  • func (q *UpdateQBuilder) Update(input string) *UpdateQBuilder
  • func (q *UpdateQBuilder) Where(inputs ...interface{}) *UpdateQBuilder

Types

type Check

type Check struct {
	Func string   `json:"func"`
	Pars []string `json:"pars"`
}

type Column

type Column struct {
	Type      string
	Length    string
	NotNull   bool
	UcDefault string
	Default   string
	MinLength string
	MaxLength string
	// Checks        []orm.Check
	Checks        []Check
	UI_Widget     string
	UI_WsUrl      string
	UI_WsCallback string
}

type DeleteQBuilder

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

func DeleteQuery

func DeleteQuery(db *sql.DB, debug bool) *DeleteQBuilder

Crea e ritorna un nuovo DeleteQBuilder

func (*DeleteQBuilder) Build

func (q *DeleteQBuilder) Build() Res

Build costruisce la query finale e la esegue.

func (*DeleteQBuilder) Delete

func (q *DeleteQBuilder) Delete(input string) *DeleteQBuilder

DELETE

func (*DeleteQBuilder) Where

func (q *DeleteQBuilder) Where(inputs ...interface{}) *DeleteQBuilder

WHERE

type Dictio

type Dictio struct {
	EntTitle string                         `json:"EntTitle"`
	Title    map[string]string              `json:"Title"`
	Msg      map[string]string              `json:"Msg"`
	Info     map[string]string              `json:"Info"`
	Opts     map[string][]map[string]string `json:"Opts"`
}

type FKeys

type FKeys struct {
	ToTable  string
	ToColumn string
	ToRefs   []string
}

type InsertQBuilder

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

func InsertQuery

func InsertQuery(db *sql.DB, debug bool) *InsertQBuilder

Crea e ritorna un nuovo InsertQBuilder

func (*InsertQBuilder) Build

func (q *InsertQBuilder) Build() Res

Build costruisce la query finale e la esegue.

func (*InsertQBuilder) Columns

func (q *InsertQBuilder) Columns(inputs ...string) *InsertQBuilder

COLUMNS

func (*InsertQBuilder) Insert

func (q *InsertQBuilder) Insert(input string) *InsertQBuilder

INSERT

func (*InsertQBuilder) Values

func (q *InsertQBuilder) Values(inputs ...interface{}) *InsertQBuilder

VALUES

type OptionsRes

type OptionsRes struct {
	Err  bool
	Msg  string
	Data []map[string]string
}

type Res

type Res struct {
	Err  bool
	Msg  string
	Data []map[string]interface{}
}

func ManageErr

func ManageErr(res *Res, debug bool, err error, query string) *Res

type SelectQBuilder

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

func SelectQuery

func SelectQuery(db *sql.DB, debug bool) *SelectQBuilder

Crea e ritorna un nuovo SelectQBuilder

func (*SelectQBuilder) Build

func (q *SelectQBuilder) Build() Res

Build costruisce la query finale e la esegue.

func (*SelectQBuilder) Count

func (q *SelectQBuilder) Count() *SelectQBuilder

COUNT

func (*SelectQBuilder) From

func (q *SelectQBuilder) From(inputs ...string) *SelectQBuilder

FROM

func (*SelectQBuilder) Limit

func (q *SelectQBuilder) Limit(limit int64) *SelectQBuilder

LIMIT

func (*SelectQBuilder) Offset

func (q *SelectQBuilder) Offset(offset int64) *SelectQBuilder

OFFSET

func (*SelectQBuilder) Order

func (q *SelectQBuilder) Order(order [][2]string) *SelectQBuilder

ORDER

func (*SelectQBuilder) Select

func (q *SelectQBuilder) Select(fields ...string) *SelectQBuilder

SELECT

func (*SelectQBuilder) Where

func (q *SelectQBuilder) Where(inputs ...interface{}) *SelectQBuilder

WHERE

type Table

type Table struct {
	Name             string
	Primary          []string
	Uniques          [][]string
	ColumnsInUniques []string
	FKeys            map[string]FKeys
	Indexes          [][]string
	ColumnsOrder     []string
	Columns          map[string]Column
}

type UpdateQBuilder

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

func UpdateQuery

func UpdateQuery(db *sql.DB, debug bool) *UpdateQBuilder

Crea e ritorna un nuovo UpdateQBuilder

func (*UpdateQBuilder) Build

func (q *UpdateQBuilder) Build() Res

Build costruisce la query finale e la esegue.

func (*UpdateQBuilder) Set

func (q *UpdateQBuilder) Set(inputs ...interface{}) *UpdateQBuilder

SET

func (*UpdateQBuilder) SetRaw

func (q *UpdateQBuilder) SetRaw(inputs ...string) *UpdateQBuilder

SET_RAW

func (*UpdateQBuilder) Update

func (q *UpdateQBuilder) Update(input string) *UpdateQBuilder

UPDATE

func (*UpdateQBuilder) Where

func (q *UpdateQBuilder) Where(inputs ...interface{}) *UpdateQBuilder

WHERE