README
¶
Postgres
Usage
Install
import (
_ "github.com/aacfactory/fns-contrib/databases/sql/dal/postgres"
)
SEQUENCE
create sequence
CREATE SEQUENCE IF NOT EXISTS "FNS"."POST_COMMENT_ID"
INCREMENT 1
START 1
MINVALUE 1
MAXVALUE 9223372036854775807
CACHE 1;
ALTER SEQUENCE "FNS"."POST_COMMENT_ID"
OWNER TO aacfactory;
use
dal.SequenceNextValue(ctx, `"FNS"."POST_COMMENT_ID"`)
Documentation
¶
Index ¶
- func ContainsJsonKey(column string, key string) *dal.Condition
- func ContainsJsonObject(column string, object string) *dal.Condition
- func ContainsJsonObjectOfArray(column string, object string) *dal.Condition
- func ContainsJsonObjectsOfArray(column string, all bool, elements ...interface{}) *dal.Condition
- type GenericQuery
- func (generic *GenericQuery) WeaveDeleteWithConditions(ctx context.Context, cond *dal.Conditions) (method dal.QueryMethod, query string, arguments []interface{}, err error)
- func (generic *GenericQuery) WeaveExecute(_ context.Context, model dal.Model) (method dal.QueryMethod, query string, arguments []interface{}, err error)
- func (generic *GenericQuery) WeaveQuery(ctx context.Context, cond *dal.Conditions, orders *dal.Orders, rng *dal.Range) (method dal.QueryMethod, query string, arguments []interface{}, err error)
- func (generic *GenericQuery) WeaveUpdateWithValues(ctx context.Context, values dal.Values, cond *dal.Conditions) (method dal.QueryMethod, query string, arguments []interface{}, err error)
- type GenericQueryModelField
- type QueryGenerator
- func (generator *QueryGenerator) Count(ctx context.Context, cond *dal.Conditions) (method dal.QueryMethod, query string, arguments []interface{}, err error)
- func (generator *QueryGenerator) Delete(ctx context.Context, model dal.Model) (method dal.QueryMethod, query string, arguments []interface{}, err error)
- func (generator *QueryGenerator) DeleteWithConditions(ctx context.Context, cond *dal.Conditions) (method dal.QueryMethod, query string, arguments []interface{}, err error)
- func (generator *QueryGenerator) Exist(ctx context.Context, cond *dal.Conditions) (method dal.QueryMethod, query string, arguments []interface{}, err error)
- func (generator *QueryGenerator) Insert(ctx context.Context, model dal.Model) (method dal.QueryMethod, query string, arguments []interface{}, err error)
- func (generator *QueryGenerator) InsertOrUpdate(ctx context.Context, model dal.Model) (method dal.QueryMethod, query string, arguments []interface{}, err error)
- func (generator *QueryGenerator) InsertWhenExist(ctx context.Context, model dal.Model, source string) (method dal.QueryMethod, query string, arguments []interface{}, err error)
- func (generator *QueryGenerator) InsertWhenNotExist(ctx context.Context, model dal.Model, source string) (method dal.QueryMethod, query string, arguments []interface{}, err error)
- func (generator *QueryGenerator) Select(ctx context.Context, cond *dal.Conditions, orders *dal.Orders, rng *dal.Range) (method dal.QueryMethod, query string, arguments []interface{}, err error)
- func (generator *QueryGenerator) Update(ctx context.Context, model dal.Model) (method dal.QueryMethod, query string, arguments []interface{}, err error)
- func (generator *QueryGenerator) UpdateWithValues(ctx context.Context, values dal.Values, cond *dal.Conditions) (method dal.QueryMethod, query string, arguments []interface{}, err error)
- type QueryGeneratorBuilder
Constants ¶
This section is empty.
Variables ¶
This section is empty.
Functions ¶
Types ¶
type GenericQuery ¶
type GenericQuery struct {
// contains filtered or unexported fields
}
func (*GenericQuery) WeaveDeleteWithConditions ¶ added in v1.0.6
func (generic *GenericQuery) WeaveDeleteWithConditions(ctx context.Context, cond *dal.Conditions) (method dal.QueryMethod, query string, arguments []interface{}, err error)
func (*GenericQuery) WeaveExecute ¶
func (generic *GenericQuery) WeaveExecute(_ context.Context, model dal.Model) (method dal.QueryMethod, query string, arguments []interface{}, err error)
func (*GenericQuery) WeaveQuery ¶
func (generic *GenericQuery) WeaveQuery(ctx context.Context, cond *dal.Conditions, orders *dal.Orders, rng *dal.Range) (method dal.QueryMethod, query string, arguments []interface{}, err error)
func (*GenericQuery) WeaveUpdateWithValues ¶ added in v1.0.6
func (generic *GenericQuery) WeaveUpdateWithValues(ctx context.Context, values dal.Values, cond *dal.Conditions) (method dal.QueryMethod, query string, arguments []interface{}, err error)
type GenericQueryModelField ¶
type GenericQueryModelField struct {
// contains filtered or unexported fields
}
func (*GenericQueryModelField) Value ¶
func (field *GenericQueryModelField) Value(modelValue reflect.Value) (v interface{})
type QueryGenerator ¶
type QueryGenerator struct {
// contains filtered or unexported fields
}
func (*QueryGenerator) Count ¶
func (generator *QueryGenerator) Count(ctx context.Context, cond *dal.Conditions) (method dal.QueryMethod, query string, arguments []interface{}, err error)
func (*QueryGenerator) Delete ¶
func (generator *QueryGenerator) Delete(ctx context.Context, model dal.Model) (method dal.QueryMethod, query string, arguments []interface{}, err error)
func (*QueryGenerator) DeleteWithConditions ¶ added in v1.0.6
func (generator *QueryGenerator) DeleteWithConditions(ctx context.Context, cond *dal.Conditions) (method dal.QueryMethod, query string, arguments []interface{}, err error)
func (*QueryGenerator) Exist ¶
func (generator *QueryGenerator) Exist(ctx context.Context, cond *dal.Conditions) (method dal.QueryMethod, query string, arguments []interface{}, err error)
func (*QueryGenerator) Insert ¶
func (generator *QueryGenerator) Insert(ctx context.Context, model dal.Model) (method dal.QueryMethod, query string, arguments []interface{}, err error)
func (*QueryGenerator) InsertOrUpdate ¶
func (generator *QueryGenerator) InsertOrUpdate(ctx context.Context, model dal.Model) (method dal.QueryMethod, query string, arguments []interface{}, err error)
func (*QueryGenerator) InsertWhenExist ¶
func (generator *QueryGenerator) InsertWhenExist(ctx context.Context, model dal.Model, source string) (method dal.QueryMethod, query string, arguments []interface{}, err error)
func (*QueryGenerator) InsertWhenNotExist ¶
func (generator *QueryGenerator) InsertWhenNotExist(ctx context.Context, model dal.Model, source string) (method dal.QueryMethod, query string, arguments []interface{}, err error)
func (*QueryGenerator) Select ¶ added in v1.0.6
func (generator *QueryGenerator) Select(ctx context.Context, cond *dal.Conditions, orders *dal.Orders, rng *dal.Range) (method dal.QueryMethod, query string, arguments []interface{}, err error)
func (*QueryGenerator) Update ¶
func (generator *QueryGenerator) Update(ctx context.Context, model dal.Model) (method dal.QueryMethod, query string, arguments []interface{}, err error)
func (*QueryGenerator) UpdateWithValues ¶ added in v1.0.6
func (generator *QueryGenerator) UpdateWithValues(ctx context.Context, values dal.Values, cond *dal.Conditions) (method dal.QueryMethod, query string, arguments []interface{}, err error)
type QueryGeneratorBuilder ¶
type QueryGeneratorBuilder struct {
}
func (*QueryGeneratorBuilder) Build ¶
func (builder *QueryGeneratorBuilder) Build(structure *dal.ModelStructure) (generator dal.QueryGenerator, err error)
Source Files
Click to show internal directories.
Click to hide internal directories.