crud

package
v1.2.92 Latest Latest
Warning

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

 Go to latest Published: Jul 13, 2023 License: GPL-3.0 Imports: 28 Imported by: 1

Documentation

Index

Constants

View Source 
const (
	UserPrivelegiesGrant = "grant"
	UsersPrivilegiesEdit = "edit"
	ActionsPropertyName  = "actions"
)
View Source 
const PathVersion = "/api/v1"

Variables

View Source 
var (
	ParamsID = apis.InParam{
		Name: "id",
		Req:  false,
		Type: apis.NewTypeInParam(types.Int32),
	}
	ParamsLang = apis.InParam{
		Name: "lang",
		Desc: "need to get result on non-english",
		DefValue: apis.DefValueCalcFnc(func(ctx *fasthttp.RequestCtx) any {
			if cL := ctx.Request.Header.Peek("Accept-Language"); len(cL) > 0 {
				return gotools.BytesToString(cL)
			}
			return "en"
		}),
		Req:  true,
		Type: apis.NewTypeInParam(types.String),
	}
	ParamsGetFormActions = apis.InParam{
		Name: "is_get_form_actions",
		Desc: "need to get form actions in response",
		Req:  false,
		Type: apis.NewTypeInParam(types.Bool),
	}
	ParamsLimit = apis.InParam{
		Name:     "limit",
		Desc:     "max count of queries results",
		DefValue: 1000,
		Req:      true,
		Type:     apis.NewTypeInParam(types.Int),
	}
	ParamsOffset = apis.InParam{
		Name: "offset",
		Desc: "offset of queries results",
		Req:  false,
		Type: apis.NewTypeInParam(types.Int),
	}
	ParamsHTML = apis.InParam{
		Name: "html",
		Desc: "need for get result in html instead JSON",
		Req:  false,
		Type: apis.NewTypeInParam(types.Bool),
	}
	ParamsEmail = apis.InParam{
		Name: "email",
		Desc: "email for login",
		Req:  true,
		Type: apis.NewTypeInParam(types.String),
	}
	ParamsPassword = apis.InParam{
		Name: "key",
		Desc: "password or other key word (on future)",
		Req:  true,
		Type: apis.NewTypeInParam(types.String),
	}
	ParamsWhere = apis.InParam{
		Name: "where",
		Desc: "conditions for query ('where' clause)",
		Type: apis.NewTypeInParam(types.String),
	}
	ParamsOrderBy = apis.InParam{
		Name: "order_by",
		Desc: "conditions for sort queries data ('order by' clause)",
		Type: apis.NewTypeInParam(types.String),
	}
	ParamsSelect = apis.InParam{
		Name: "select[]",
		Desc: "list of columns for query ('select' clause)",
		Type: apis.NewSliceTypeInParam(types.String),
	}
	ParamsName = apis.InParam{
		Name:     "name",
		Desc:     "name of search table",
		DefValue: apis.ApisValues(apis.ChildRoutePath),
		Req:      true,
		Type:     apis.NewTypeInParam(types.String),
	}
	BasicParams = []apis.InParam{
		ParamsHTML,
		ParamsLang,
	}
)

Functions

func AddColumnAndValue added in v1.2.3 

func AddColumnAndValue(name string, table dbEngine.Table, arg interface{}, buf io.Writer, badParams map[string]string) (string, interface{})

func ArrayToStrings 

func ArrayToStrings(v *pgtype.ArrayType) ([]string, bool)

func BPCharArrayToStrings 

func BPCharArrayToStrings(src []pgtype.BPChar) []string

func BlobToURL 

func BlobToURL(tableName string, colName string, id int32) string

func CreateErrResult 

func CreateErrResult(err error) (any, error)

func DecodeDatetimeString 

func DecodeDatetimeString(ptr unsafe.Pointer, iter *jsoniter.Iterator)

func EncodeDateString added in v1.2.90 

func EncodeDateString(ptr unsafe.Pointer, stream *jsoniter.Stream)

func GetForeignName 

func GetForeignName(ctx *fasthttp.RequestCtx, DB *DB, col Column, val interface{}) interface{}

func GetForeignOptions 

func GetForeignOptions(ctx *fasthttp.RequestCtx, DB *dbEngine.DB, colDec *forms.ColumnDecor, id any)

func GetNameAccordingLang 

func GetNameAccordingLang(table Table, name string, lang interface{}) string

func GetNameOfTitleColumn 

func GetNameOfTitleColumn(table Table, lang interface{}) string

func Int4ArrToStrings 

func Int4ArrToStrings(src []pgtype.Int4) []int32

func Int8ArrToStrings 

func Int8ArrToStrings(src []pgtype.Int8) []int64

func IsEmptyDateString added in v1.2.90 

func IsEmptyDateString(ptr unsafe.Pointer) bool

func ReadByteA added in v1.2.14 

func ReadByteA(fHeaders []*multipart.FileHeader) ([]string, [][]byte, error)

func RenderAcceptedResult added in v1.2.3 

func RenderAcceptedResult(ctx *fasthttp.RequestCtx, colSel []string, buf *bytes.Buffer, route string) (any, error)

func RenderCreatedResult added in v1.1.10122 

func RenderCreatedResult(ctx *fasthttp.RequestCtx, id int64, buf *bytes.Buffer, colSel []string, url string) (any, error)

func RoutesFromDB 

func RoutesFromDB(ctx context.Context, routeTypes []DbRouteType, tables ...string) apis.ApiRoutes

func TableForm 

func TableForm(DB *DB, preRoute string, table Table, priColumns []string) apis.ApiRouteHandler

func TableInsert 

func TableInsert(preRoute string, table dbEngine.Table, params []string) apis.ApiRouteHandler

TableInsert insert data of params into table

func TableSelect 

func TableSelect(table dbEngine.Table, params []string) apis.ApiRouteHandler

func TableUpdate 

func TableUpdate(preRoute string, table dbEngine.Table, columns, priColumns []string) apis.ApiRouteHandler

TableUpdate

func TextArrayToStrings 

func TextArrayToStrings(src []pgtype.Text) []string

func TimeToString 

func TimeToString(v time.Time) string

func ToColDev 

func ToColDev(ctx *fasthttp.RequestCtx, DB *dbEngine.DB, patternList dbEngine.Table, col dbEngine.Column,
	value any) *forms.ColumnDecor

func ToStandartColumnValueType 

func ToStandartColumnValueType(tableName, colName string, id int32, values interface{}) interface{}

func UnknownArrayToStrings 

func UnknownArrayToStrings(src []interface{}) []string

func VarcharArrayToStrings 

func VarcharArrayToStrings(src []pgtype.Varchar) []string

Types

type DateRangeMarshal added in v1.2.21 

type DateRangeMarshal struct {
	*pgtype.Daterange
}

func (*DateRangeMarshal) GetValue added in v1.2.21 

func (d *DateRangeMarshal) GetValue() any

func (*DateRangeMarshal) NewValue added in v1.2.21 

func (d *DateRangeMarshal) NewValue() any

func (*DateRangeMarshal) Set added in v1.2.21 

func (d *DateRangeMarshal) Set(src any) error

func (*DateRangeMarshal) Value added in v1.2.21 

func (d *DateRangeMarshal) Value() (driver.Value, error)

type DateString added in v1.2.86 

type DateString time.Time

func (*DateString) Expect added in v1.2.88 

func (d *DateString) Expect() string

func (*DateString) Format added in v1.2.88 

func (d *DateString) Format() string

func (*DateString) GetValue added in v1.2.88 

func (d *DateString) GetValue() any

func (*DateString) MarshalJSON added in v1.2.89 

func (d *DateString) MarshalJSON() ([]byte, error)

func (*DateString) NewValue added in v1.2.88 

func (d *DateString) NewValue() any

func (*DateString) RequestType added in v1.2.88 

func (d *DateString) RequestType() string

func (*DateString) UnmarshalJSON added in v1.2.86 

func (d *DateString) UnmarshalJSON(src []byte) (err error)

type DateTimeString 

type DateTimeString time.Time

func (*DateTimeString) CheckParams 

func (d *DateTimeString) CheckParams(ctx *fasthttp.RequestCtx, badParams map[string]string) bool

func (*DateTimeString) Expect added in v1.2.22 

func (d *DateTimeString) Expect() string

func (*DateTimeString) Format added in v1.2.22 

func (d *DateTimeString) Format() string

func (*DateTimeString) GetValue added in v1.2.21 

func (d *DateTimeString) GetValue() any

func (*DateTimeString) MarshalJSON 

func (d *DateTimeString) MarshalJSON() ([]byte, error)

func (*DateTimeString) NewValue added in v1.2.21 

func (d *DateTimeString) NewValue() any

func (*DateTimeString) RequestType added in v1.2.22 

func (d *DateTimeString) RequestType() string

func (*DateTimeString) Scan 

func (d *DateTimeString) Scan(src any) error

func (*DateTimeString) UnmarshalJSON 

func (d *DateTimeString) UnmarshalJSON(src []byte) (err error)

type DbApiParams added in v1.2.3 

type DbApiParams struct {
	apis.InParam
	Col dbEngine.Column
}

func NewDbApiParams added in v1.2.3 

func NewDbApiParams(col dbEngine.Column) *DbApiParams

func (*DbApiParams) ConvertDbType added in v1.2.3 

func (p *DbApiParams) ConvertDbType(col dbEngine.Column)

type DbRouteType added in v1.2.2 

type DbRouteType int
const (
	DbRouteType_Insert DbRouteType = iota
	DbRouteType_Update
	DbRouteType_Select
)

type DtoField added in v1.2.21 

type DtoField map[string]any

func (*DtoField) CheckParams added in v1.2.21 

func (d *DtoField) CheckParams(ctx *fasthttp.RequestCtx, badParams map[string]string) bool

CheckParams implement CheckDTO interface, put each params into user value on context

func (*DtoField) Expect added in v1.2.22 

func (d *DtoField) Expect() string

func (*DtoField) Format added in v1.2.22 

func (d *DtoField) Format() string

func (*DtoField) GetValue added in v1.2.21 

func (d *DtoField) GetValue() any

func (*DtoField) NewValue added in v1.2.21 

func (d *DtoField) NewValue() any

func (*DtoField) RequestType added in v1.2.22 

func (d *DtoField) RequestType() string

type DtoFileField added in v1.2.25 

type DtoFileField []*multipart.FileHeader

func (*DtoFileField) CheckParams added in v1.2.25 

func (d *DtoFileField) CheckParams(ctx *fasthttp.RequestCtx, badParams map[string]string) bool

CheckParams implement CheckDTO interface, put each params into user value on context

func (*DtoFileField) Expect added in v1.2.25 

func (d *DtoFileField) Expect() string

func (*DtoFileField) Format added in v1.2.25 

func (d *DtoFileField) Format() string

func (*DtoFileField) GetValue added in v1.2.25 

func (d *DtoFileField) GetValue() interface{}

func (*DtoFileField) NewValue added in v1.2.25 

func (d *DtoFileField) NewValue() interface{}

func (*DtoFileField) RequestType added in v1.2.25 

func (d *DtoFileField) RequestType() string

type FormActions 

type FormActions struct {
	Typ string `json:"type"`
	Url string `json:"url"`
}

type InetMarshal added in v1.2.29 

type InetMarshal struct {
	*pgtype.Inet
}

func (*InetMarshal) GetValue added in v1.2.29 

func (i *InetMarshal) GetValue() any

func (*InetMarshal) NewValue added in v1.2.29 

func (i *InetMarshal) NewValue() any

func (*InetMarshal) Set added in v1.2.29 

func (i *InetMarshal) Set(src any) error

type IntervalMarshal added in v1.2.21 

type IntervalMarshal struct {
	*pgtype.Interval
}

func (*IntervalMarshal) GetValue added in v1.2.21 

func (i *IntervalMarshal) GetValue() any

func (*IntervalMarshal) NewValue added in v1.2.21 

func (i *IntervalMarshal) NewValue() any

func (*IntervalMarshal) Set added in v1.2.27 

func (i *IntervalMarshal) Set(src any) error

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.