sql

Documentation

Overview

Package sql helps to create SQL squirrel filters using the TSL package.

Example

Example for the tsl package.

// Set a TSL input string.
input := "name = 'joe' and city != 'rome'"

// Parse input string into a TSL tree.
tree, _ := tsl.ParseTSL(input)

// Set filter
filter, _ := Walk(tree)

// Convert TSL tree into SQL string using squirrel sql builder.
sql, args, _ := sq.Select("name, city, state").
	From("users").
	Where(filter).
	ToSql()

fmt.Printf("SQL : %s\n", sql)
fmt.Printf("Args: %v\n", args)

Output:

SQL : SELECT name, city, state FROM users WHERE (name = ? AND city <> ?)
Args: [joe rome]

Index

• func Walk(n tsl.Node) (s sq.Sqlizer, err error)

Examples

• Package

Functions

func Walk

func Walk(n tsl.Node) (s sq.Sqlizer, err error)

Walk travel the TSL tree to create squirrel SQL select operators.

Users can call the Walk method inside a squirrel Where to add the query.

filter, _ := sql.Walk(tree)
sql, args, _ := sq.Select("name, city, state").
  From("users").
  Where(filter).
  ToSql()

Squirrel: https://github.com/Masterminds/squirrel