sqlb

func BuildInsert ¶

func BuildInsert(ctx context.Context, entity any, isAuditable bool) (string, []any, string)

build insert form => "INSERT INTO <tab_name> (field1, field2, fieldN) VALUES(?,?,?);" and return query + values

func BuildRead ¶

func BuildRead(ctx context.Context, entity any, filter map[string]any) (string, []any, string)

func BuildUpdate ¶

func BuildUpdate(ctx context.Context, entity any, isAuditable bool) (string, []any, string)

build update form => "UPDATE <tab_name> SET field1 = ?, field2 = ? WHERE fieldN = ?;" and return query + values