TODO

• strongly typed nodes
• brackets normalization
• non-recursive AST traverse

Install

go get github.com/Delisa-sama/stmt-builder@latest

Usage

package main

import (
	"fmt"
	"time"

	"github.com/Delisa-sama/stmt-builder/operators"
	"github.com/Delisa-sama/stmt-builder/placeholders"
	"github.com/Delisa-sama/stmt-builder/sort"
	"github.com/Delisa-sama/stmt-builder/statement"
	"github.com/Delisa-sama/stmt-builder/translators/sql"
	"github.com/Delisa-sama/stmt-builder/values"
)

func exampleStmt() {
	// ((id = 10 AND status = 'active') OR deleted_at IS NOT NULL)
	s := statement.New("id", operators.EQ(values.Bool(true))).
		And(statement.New("status", operators.EQ(values.String("active")))).
		Or(statement.New("deleted_at", operators.NE(values.Null())))

	translator := sql.NewTranslator(
		sql.WithPlaceholder(placeholders.NewDollarPlaceholder()),
	)
	fmt.Println(translator.Translate(s))
	fmt.Println(translator.GetArgs(s))

	// ((id = 10 AND (status = 'active' OR deleted_at IS NOT NULL)) OR status IN ('status1','status2'))
	s = statement.New("id", operators.EQ(values.Int(10))).
		And(
			statement.New("status", operators.EQ(values.String("active"))).
				Or(statement.New("deleted_at", operators.NE(values.Null()))),
		).Or(
		statement.New("status", operators.In(values.Strings("status1"))),
	)
	translator = sql.NewTranslator()
	fmt.Println(translator.Translate(s))
	translator = sql.NewTranslator(
		sql.WithPlaceholder(placeholders.NewDollarPlaceholder()),
	)
	fmt.Println(translator.Translate(s))

	// ((id = 10 AND created_at > '2022-05-27T13:49:32+03:00') OR !(status IN ('status1','status2')))
	s = statement.New("id", operators.EQ(values.Int64(10))).
		And(
			statement.New("created_at", operators.GT(values.Time(time.Now()))).Or(
				statement.Not(statement.New("status", operators.In(values.Strings("status1", "status2"))))),
		)
	translator = sql.NewTranslator()
	fmt.Println(translator.Translate(s))
	translator = sql.NewTranslator(
		sql.WithPlaceholder(placeholders.NewDollarPlaceholder()),
	)
	fmt.Println(translator.Translate(s))
	fmt.Println(translator.GetArgs(s))

	//
	s = statement.Empty()
	translator = sql.NewTranslator()
	fmt.Println(translator.Translate(s))

	s = statement.Empty().And(statement.New("id", operators.EQ(values.Int(10))))
	translator = sql.NewTranslator()
	// id = 10
	fmt.Println(translator.Translate(s))

	// NOT IN
	// type NOT IN ("archive", "block")
	s = statement.New("type", operators.NotIn(values.Strings("archive", "block"))).
		Sort(sort.By("id"), sort.DESCDirection)

	translator = sql.NewTranslator(
		sql.WithPlaceholder(placeholders.NewDollarPlaceholder()),
	)
	// type NOT IN ($1,$2)
	fmt.Println(translator.Translate(s))
	// [archive block]
	fmt.Println(translator.GetArgs(s))
}

func main() {
	exampleStmt()
}