DBSchema

Documentation

Index

• func DBConnection() *sql.DB
• func GetModelAlias(modelName string) string
• func Tables() map[string][]string
• func WriteFormModel(grids []models.VBSchema)
• func WriteGridDataCaller(forms []models.VBSchema, moduleName string)
• func WriteGridModel(grids []models.VBSchema)
• func WriteModelCaller(forms []models.VBSchema, moduleName string)
• func WriteModelValidation(vb SCHEMA, ID uint64)
• func WriteValidationCaller(forms []models.VBSchema, moduleName string)
• func WriteValidationMessageCaller(forms []models.VBSchema, moduleName string)
• type FormItem
• type Formula
• type SCHEMA
• type SCHEMAGRID
• type TableMeta
  • func TableMetas(tableName string) []TableMeta
• type VBSCHEMA
  • func GenerateSchema() VBSCHEMA
  • func GetDBSchema() VBSCHEMA

Functions

func DBConnection

func DBConnection() *sql.DB

func GetModelAlias

func GetModelAlias(modelName string) string

func Tables

func Tables() map[string][]string

func WriteFormModel

func WriteFormModel(grids []models.VBSchema)

FROM

func WriteGridDataCaller

func WriteGridDataCaller(forms []models.VBSchema, moduleName string)

func WriteGridModel

func WriteGridModel(grids []models.VBSchema)

GRID

func WriteModelCaller

func WriteModelCaller(forms []models.VBSchema, moduleName string)

func WriteModelValidation

func WriteModelValidation(vb SCHEMA, ID uint64)

func WriteValidationCaller

func WriteValidationCaller(forms []models.VBSchema, moduleName string)

func WriteValidationMessageCaller

func WriteValidationMessageCaller(forms []models.VBSchema, moduleName string)

Types

type FormItem

type FormItem struct {
	Model       string      `json:"model"`
	Title       string      `json:"title"`
	DbType      string      `json:"dbType"`
	Table       string      `json:"table,omitempty"`
	Key         string      `json:"key"`
	Extra       string      `json:"extra,omitempty"`
	ID          string      `json:"id"`
	Type        string      `json:"type"`
	Identity    string      `json:"identity"`
	Label       string      `json:"label"`
	PlaceHolder string      `json:"placeHolder"`
	Hidden      bool        `json:"hidden"`
	Disabled    bool        `json:"disabled"`
	Default     interface{} `json:"default"`
	Prefix      string      `json:"prefix"`
	Ifshowhide  string      `json:"ifshowhide"`
	Rules       []struct {
		Type string `json:"type"`
		Msg  string `json:"msg"`
	} `json:"rules"`
	HasTranslation bool   `json:"hasTranslation"`
	HasUserID      bool   `json:"hasUserId"`
	HasEquation    bool   `json:"hasEquation"`
	Equations      string `json:"equations"`
	IsGridSearch   bool   `json:"isGridSearch"`
	GridSearch     struct {
		Grid     interface{} `json:"grid"`
		Key      interface{} `json:"key"`
		Labels   interface{} `json:"labels"`
		Multiple bool        `json:"multiple"`
	} `json:"gridSearch"`
	IsFkey   bool `json:"isFkey"`
	Relation struct {
		Table              interface{}   `json:"table"`
		Key                interface{}   `json:"key"`
		Fields             []interface{} `json:"fields"`
		FilterWithUser     []interface{} `json:"filterWithUser"`
		SortField          interface{}   `json:"sortField"`
		SortOrder          string        `json:"sortOrder"`
		Multiple           bool          `json:"multiple"`
		Filter             string        `json:"filter"`
		ParentFieldOfForm  string        `json:"parentFieldOfForm"`
		ParentFieldOfTable string        `json:"parentFieldOfTable"`
	} `json:"relation,omitempty"`
	Span struct {
		Xs int `json:"xs"`
		Sm int `json:"sm"`
		Md int `json:"md"`
		Lg int `json:"lg"`
	} `json:"span"`
	Trigger        string `json:"trigger"`
	TriggerTimeout int    `json:"triggerTimeout"`
	File           struct {
		IsMultiple bool   `json:"isMultiple"`
		Count      int    `json:"count"`
		MaxSize    int    `json:"maxSize"`
		Type       string `json:"type"`
	} `json:"file,omitempty"`
	Options          []interface{} `json:"options"`
	PasswordOption   interface{}   `json:"passwordOption"`
	GeographicOption interface{}   `json:"GeographicOption"`
	EditorType       interface{}   `json:"editorType"`
	SchemaID         string        `json:"schemaID,omitempty"`

	//subForm data
	Name            string     `json:"name"`
	SubType         string     `json:"subtype"`
	Parent          string     `json:"parent"`
	FormId          uint64     `json:"formId"`
	FormType        string     `json:"formType"`
	MinHeight       string     `json:"min_height"`
	DisableDelete   bool       `json:"disableDelete"`
	DisableCreate   bool       `json:"disableCreate"`
	ShowRowNumber   bool       `json:"showRowNumber"`
	UseTableType    bool       `json:"useTableType"`
	TableTypeColumn string     `json:"tableTypeColumn"`
	TableTypeValue  string     `json:"tableTypeValue"`
	Schema          []FormItem `json:"schema"`
}

type Formula

type Formula struct {
	Targets []struct {
		Field string `json:"field"`
		Prop  string `json:"prop"`
	} `json:"targets"`
	Template string `json:"template"`
	Form     string `json:"form"`
	Model    string `json:"model"`
}

type SCHEMA

type SCHEMA struct {
	Model         string      `json:"model"`
	Identity      string      `json:"identity"`
	Timestamp     bool        `json:"timestamp"`
	LabelPosition string      `json:"labelPosition"`
	LabelWidth    interface{} `json:"labelWidth"`
	Width         string      `json:"width"`
	Padding       int         `json:"padding"`
	Schema        []FormItem  `json:"schema"`
	UI            interface{} `json:"ui"`
	Formula       []Formula   `json:"formula"`
	Triggers      struct {
		Namespace string `json:"namespace"`
		Insert    struct {
			Before string `json:"before"`
			After  string `json:"after"`
		} `json:"insert"`
		Update struct {
			Before string `json:"before"`
			After  string `json:"after"`
		} `json:"update"`
	} `json:"triggers"`
	SortField string `json:"sortField"`
	SordOrder string `json:"sordOrder"`
}

type SCHEMAGRID

type SCHEMAGRID struct {
	Model          string   `json:"model"`
	IsView         bool     `json:"isView"`
	Identity       string   `json:"identity"`
	Actions        []string `json:"actions"`
	ActionPosition int      `json:"actionPosition"`
	IsContextMenu  bool     `json:"isContextMenu"`
	StaticWidth    bool     `json:"staticWidth"`
	FullWidth      bool     `json:"fullWidth"`
	HasCheckbox    bool     `json:"hasCheckbox"`
	IsClient       bool     `json:"isClient"`
	Width          int      `json:"width"`
	Sort           string   `json:"sort"`
	SortOrder      string   `json:"sortOrder"`
	SoftDelete     bool     `json:"softDelete"`
	Paging         int      `json:"paging"`
	Template       int      `json:"template"`
	Schema         []struct {
		Model       string `json:"model"`
		Title       string `json:"title"`
		DbType      string `json:"dbType"`
		Table       string `json:"table"`
		Key         string `json:"key"`
		Extra       string `json:"extra"`
		Label       string `json:"label"`
		GridType    string `json:"gridType"`
		Width       int    `json:"width"`
		Hide        bool   `json:"hide"`
		Sortable    bool   `json:"sortable"`
		Printable   bool   `json:"printable"`
		Pinned      bool   `json:"pinned"`
		PinPosition string `json:"pinPosition"`
		Link        string `json:"link"`
		LinkTarget  string `json:"linkTarget"`
		Relation    struct {
			Table              interface{}   `json:"table"`
			Key                interface{}   `json:"key"`
			Fields             []interface{} `json:"fields"`
			SortField          interface{}   `json:"sortField"`
			SortOrder          string        `json:"sortOrder"`
			Multiple           bool          `json:"multiple"`
			Filter             string        `json:"filter"`
			ParentFieldOfForm  string        `json:"parentFieldOfForm"`
			ParentFieldOfTable string        `json:"parentFieldOfTable"`
		} `json:"relation"`
		Filterable bool `json:"filterable"`
		Filter     struct {
			Type             string      `json:"type"`
			Param            interface{} `json:"param"`
			ParamCompareType string      `json:"paramCompareType"`
			Default          interface{} `json:"default"`
			Relation         struct {
				Table     interface{}   `json:"table"`
				Key       interface{}   `json:"key"`
				Fields    []interface{} `json:"fields"`
				SortField interface{}   `json:"sortField"`
				SortOrder string        `json:"sortOrder"`
			} `json:"relation"`
		} `json:"filter"`
		Editable struct {
			Status       bool   `json:"status"`
			Type         string `json:"type"`
			ShouldUpdate bool   `json:"shouldUpdate"`
			ShouldPost   bool   `json:"shouldPost"`
		} `json:"editable"`
		Searchable     bool          `json:"searchable"`
		HasTranslation bool          `json:"hasTranslation"`
		Options        []interface{} `json:"options"`
	} `json:"schema"`
	Filter                    []interface{}       `json:"filter"`
	Formula                   []interface{}       `json:"formula"`
	Condition                 string              `json:"condition"`
	ColumnAggregations        []map[string]string `json:"columnAggregations"`
	ColumnAggregationsFormula []interface{}       `json:"columnAggregationsFormula"`
	Header                    struct {
		Render    bool          `json:"render"`
		Preview   bool          `json:"preview"`
		Structure []interface{} `json:"structure"`
	} `json:"header"`
	Triggers struct {
		Namespace    string `json:"namespace"`
		BeforeFetch  string `json:"beforeFetch"`
		AfterFetch   string `json:"afterFetch"`
		BeforeDelete string `json:"beforeDelete"`
		AfterDelete  string `json:"afterDelete"`
		BeforePrint  string `json:"beforePrint"`
	} `json:"triggers"`
	Theme                string      `json:"theme"`
	FullText             bool        `json:"fullText"`
	EditableAction       interface{} `json:"editableAction"`
	EditFullRow          bool        `json:"editFullRow"`
	EditableShouldSubmit bool        `json:"editableShouldSubmit"`
	SingleClickEdit      bool        `json:"singleClickEdit"`
	FlashChanges         bool        `json:"flashChanges"`
	ColMenu              bool        `json:"colMenu"`
	ColFilterButton      bool        `json:"colFilterButton"`
	ShowGrid             bool        `json:"showGrid"`
	SordOrder            string      `json:"sordOrder"`
	MainTable            string      `json:"mainTable"`
	IsPivot              bool        `json:"isPivot"`
	IsPrint              bool        `json:"isPrint"`
	PrintSize            string      `json:"printSize"`
	IsExcel              bool        `json:"isExcel"`
	IsRefresh            bool        `json:"isRefresh"`
	IsNumbered           bool        `json:"isNumbered"`
}

type TableMeta

type TableMeta struct {
	Model  string `json:"model"`
	Title  string `json:"title"`
	DbType string `json:"dbType"`
	Table  string `json:"table"`
	Key    string `json:"key"`
	Extra  string `json:"extra"`
}

func TableMetas

func TableMetas(tableName string) []TableMeta

type VBSCHEMA

type VBSCHEMA struct {
	TableList []string               `json:"tableList"`
	ViewList  []string               `json:"viewList"`
	TableMeta map[string][]TableMeta `json:"tableMeta"`
}

func GenerateSchema

func GenerateSchema() VBSCHEMA

func GetDBSchema

func GetDBSchema() VBSCHEMA