table

type Document map[string]any

type Hook struct {
	BeforeInsert func(doc Document) error
	AfterInsert  func(id any, doc Document) error
	BeforeUpdate func(id any, update Document) error
	AfterUpdate  func(id any, update Document, base Document) error
	BeforeDelete func(id any) error
	AfterDelete  func(id any, doc Document) error

	Scripts *HookScripts `json:"scripts,omitempty"`
}

type HookScripts struct {
	BeforeInsert string `json:"before_insert,omitempty"`
	AfterInsert  string `json:"after_insert,omitempty"`
	BeforeUpdate string `json:"before_update,omitempty"`
	AfterUpdate  string `json:"after_update,omitempty"`
	BeforeDelete string `json:"before_delete,omitempty"`
	AfterDelete  string `json:"after_delete,omitempty"`
}

type Join struct {
	Table        string `json:"table,omitempty"`         //表名
	LocalField   string `json:"local_field,omitempty"`   //主表字段
	ForeignField string `json:"foreign_field,omitempty"` //附表字段（外键）
	Field        string `json:"field,omitempty"`         //取字段 TODO 可以改为数组
	As           string `json:"as,omitempty"`            //赋值
}

type ParamSearch struct {
	Skip   int            `form:"skip" json:"skip"`     //越过条数
	Limit  int            `form:"limit" json:"limit"`   //限制条数
	Sort   map[string]int `form:"sort" json:"sort"`     //排序 仅支持一个字段
	Filter map[string]any `form:"filter" json:"filter"` //条件
	Joins  []*Join        `form:"joins" json:"joins"`   //联合查询的字段
	Fields []string       `form:"fields" json:"fields"` //要查询的字段
}

type ReplyData[T any] struct {
	Data  T      `json:"data"`
	Error string `json:"error,omitempty"`
}

type ReplyList[T any] struct {
	Data  []T    `json:"data"`
	Total int64  `json:"total"`
	Error string `json:"error,omitempty"`
}

type Table struct {
	Name          string          `json:"name,omitempty"`
	Comment       string          `json:"comment,omitempty"`
	Columns       []*smart.Column `json:"columns,omitempty"`
	Joins         []*Join         `json:"joins,omitempty"`
	DisableInsert bool            `json:"disable_insert,omitempty"`
	DisableUpdate bool            `json:"disable_update,omitempty"`
	DisableDelete bool            `json:"disable_delete,omitempty"`

	//原生钩子
	Hook
	// contains filtered or unexported fields
}