sqlparser - meant for querying csv files

Usage

package main import (	"fmt"	"log"	"github.com/marianogappa/sqlparser" ) func main() {	query, err := sqlparser.Parse("SELECT a, b, c FROM 'd' WHERE e = '1' AND f > '2'")	if err != nil {	log.Fatal(err)	}	fmt.Printf("%+#v", query) }

Example: SELECT works

query, err := sqlparser.Parse(`SELECT a FROM 'b'`) query.Query {	Type: Select	TableName: b	Conditions: []	Updates: map[]	Inserts: []	Fields: [a]	Aliases: map[] }

Example: SELECT works with lowercase

query, err := sqlparser.Parse(`select a fRoM 'b'`) query.Query {	Type: Select	TableName: b	Conditions: []	Updates: map[]	Inserts: []	Fields: [a]	Aliases: map[] }

Example: SELECT many fields works

query, err := sqlparser.Parse(`SELECT a, c, d FROM 'b'`) query.Query {	Type: Select	TableName: b	Conditions: []	Updates: map[]	Inserts: []	Fields: [a c d]	Aliases: map[] }

Example: SELECT with alias works

query, err := sqlparser.Parse(`SELECT a as z, b as y, c FROM 'b'`) query.Query {	Type: Select	TableName: b	Conditions: []	Updates: map[]	Inserts: []	Fields: [a b c]	Aliases: map[a:z b:y] }

Example: SELECT with WHERE with = works

query, err := sqlparser.Parse(`SELECT a, c, d FROM 'b' WHERE a = ''`) query.Query {	Type: Select	TableName: b	Conditions: [ { Operand1: a, Operand1IsField: true, Operator: Eq, Operand2: , Operand2IsField: false, }]	Updates: map[]	Inserts: []	Fields: [a c d]	Aliases: map[] }

Example: SELECT with WHERE with < works

query, err := sqlparser.Parse(`SELECT a, c, d FROM 'b' WHERE a < '1'`) query.Query {	Type: Select	TableName: b	Conditions: [ { Operand1: a, Operand1IsField: true, Operator: Lt, Operand2: 1, Operand2IsField: false, }]	Updates: map[]	Inserts: []	Fields: [a c d]	Aliases: map[] }

Example: SELECT with WHERE with <= works

query, err := sqlparser.Parse(`SELECT a, c, d FROM 'b' WHERE a <= '1'`) query.Query {	Type: Select	TableName: b	Conditions: [ { Operand1: a, Operand1IsField: true, Operator: Lte, Operand2: 1, Operand2IsField: false, }]	Updates: map[]	Inserts: []	Fields: [a c d]	Aliases: map[] }

Example: SELECT with WHERE with > works

query, err := sqlparser.Parse(`SELECT a, c, d FROM 'b' WHERE a > '1'`) query.Query {	Type: Select	TableName: b	Conditions: [ { Operand1: a, Operand1IsField: true, Operator: Gt, Operand2: 1, Operand2IsField: false, }]	Updates: map[]	Inserts: []	Fields: [a c d]	Aliases: map[] }

Example: SELECT with WHERE with >= works

query, err := sqlparser.Parse(`SELECT a, c, d FROM 'b' WHERE a >= '1'`) query.Query {	Type: Select	TableName: b	Conditions: [ { Operand1: a, Operand1IsField: true, Operator: Gte, Operand2: 1, Operand2IsField: false, }]	Updates: map[]	Inserts: []	Fields: [a c d]	Aliases: map[] }

Example: SELECT with WHERE with != works

query, err := sqlparser.Parse(`SELECT a, c, d FROM 'b' WHERE a != '1'`) query.Query {	Type: Select	TableName: b	Conditions: [ { Operand1: a, Operand1IsField: true, Operator: Ne, Operand2: 1, Operand2IsField: false, }]	Updates: map[]	Inserts: []	Fields: [a c d]	Aliases: map[] }

Example: SELECT with WHERE with != works (comparing field against another field)

query, err := sqlparser.Parse(`SELECT a, c, d FROM 'b' WHERE a != b`) query.Query {	Type: Select	TableName: b	Conditions: [ { Operand1: a, Operand1IsField: true, Operator: Ne, Operand2: b, Operand2IsField: true, }]	Updates: map[]	Inserts: []	Fields: [a c d]	Aliases: map[] }

Example: SELECT * works

query, err := sqlparser.Parse(`SELECT * FROM 'b'`) query.Query {	Type: Select	TableName: b	Conditions: []	Updates: map[]	Inserts: []	Fields: [*]	Aliases: map[] }

Example: SELECT a, * works

query, err := sqlparser.Parse(`SELECT a, * FROM 'b'`) query.Query {	Type: Select	TableName: b	Conditions: []	Updates: map[]	Inserts: []	Fields: [a *]	Aliases: map[] }

Example: SELECT with WHERE with two conditions using AND works

query, err := sqlparser.Parse(`SELECT a, c, d FROM 'b' WHERE a != '1' AND b = '2'`) query.Query {	Type: Select	TableName: b	Conditions: [ { Operand1: a, Operand1IsField: true, Operator: Ne, Operand2: 1, Operand2IsField: false, } { Operand1: b, Operand1IsField: true, Operator: Eq, Operand2: 2, Operand2IsField: false, }]	Updates: map[]	Inserts: []	Fields: [a c d]	Aliases: map[] }

Example: UPDATE works

query, err := sqlparser.Parse(`UPDATE 'a' SET b = 'hello' WHERE a = '1'`) query.Query {	Type: Update	TableName: a	Conditions: [ { Operand1: a, Operand1IsField: true, Operator: Eq, Operand2: 1, Operand2IsField: false, }]	Updates: map[b:hello]	Inserts: []	Fields: []	Aliases: map[] }

Example: UPDATE works with simple quote inside

query, err := sqlparser.Parse(`UPDATE 'a' SET b = 'hello\'world' WHERE a = '1'`) query.Query {	Type: Update	TableName: a	Conditions: [ { Operand1: a, Operand1IsField: true, Operator: Eq, Operand2: 1, Operand2IsField: false, }]	Updates: map[b:hello\'world]	Inserts: []	Fields: []	Aliases: map[] }

Example: UPDATE with multiple SETs works

query, err := sqlparser.Parse(`UPDATE 'a' SET b = 'hello', c = 'bye' WHERE a = '1'`) query.Query {	Type: Update	TableName: a	Conditions: [ { Operand1: a, Operand1IsField: true, Operator: Eq, Operand2: 1, Operand2IsField: false, }]	Updates: map[b:hello c:bye]	Inserts: []	Fields: []	Aliases: map[] }

Example: UPDATE with multiple SETs and multiple conditions works

query, err := sqlparser.Parse(`UPDATE 'a' SET b = 'hello', c = 'bye' WHERE a = '1' AND b = '789'`) query.Query {	Type: Update	TableName: a	Conditions: [ { Operand1: a, Operand1IsField: true, Operator: Eq, Operand2: 1, Operand2IsField: false, } { Operand1: b, Operand1IsField: true, Operator: Eq, Operand2: 789, Operand2IsField: false, }]	Updates: map[b:hello c:bye]	Inserts: []	Fields: []	Aliases: map[] }

Example: DELETE with WHERE works

query, err := sqlparser.Parse(`DELETE FROM 'a' WHERE b = '1'`) query.Query {	Type: Delete	TableName: a	Conditions: [ { Operand1: b, Operand1IsField: true, Operator: Eq, Operand2: 1, Operand2IsField: false, }]	Updates: map[]	Inserts: []	Fields: []	Aliases: map[] }

Example: INSERT works

query, err := sqlparser.Parse(`INSERT INTO 'a' (b) VALUES ('1')`) query.Query {	Type: Insert	TableName: a	Conditions: []	Updates: map[]	Inserts: [[1]]	Fields: [b]	Aliases: map[] }

Example: INSERT with multiple fields works

query, err := sqlparser.Parse(`INSERT INTO 'a' (b,c, d) VALUES ('1','2' , '3' )`) query.Query {	Type: Insert	TableName: a	Conditions: []	Updates: map[]	Inserts: [[1 2 3]]	Fields: [b c d]	Aliases: map[] }

Example: INSERT with multiple fields and multiple values works

query, err := sqlparser.Parse(`INSERT INTO 'a' (b,c, d) VALUES ('1','2' , '3' ),('4','5' ,'6' )`) query.Query {	Type: Insert	TableName: a	Conditions: []	Updates: map[]	Inserts: [[1 2 3] [4 5 6]]	Fields: [b c d]	Aliases: map[] }

Example: empty query fails

query, err := sqlparser.Parse(``) query type cannot be empty

Example: SELECT without FROM fails

query, err := sqlparser.Parse(`SELECT`) table name cannot be empty

Example: SELECT without fields fails

query, err := sqlparser.Parse(`SELECT FROM 'a'`) at SELECT: expected field to SELECT

Example: SELECT with comma and empty field fails

query, err := sqlparser.Parse(`SELECT b, FROM 'a'`) at SELECT: expected field to SELECT

Example: SELECT with empty WHERE fails

query, err := sqlparser.Parse(`SELECT a, c, d FROM 'b' WHERE`) at WHERE: empty WHERE clause

Example: SELECT with WHERE with only operand fails

query, err := sqlparser.Parse(`SELECT a, c, d FROM 'b' WHERE a`) at WHERE: condition without operator

Example: Empty UPDATE fails

query, err := sqlparser.Parse(`UPDATE`) table name cannot be empty

Example: Incomplete UPDATE with table name fails

query, err := sqlparser.Parse(`UPDATE 'a'`) at WHERE: WHERE clause is mandatory for UPDATE & DELETE

Example: Incomplete UPDATE with table name and SET fails

query, err := sqlparser.Parse(`UPDATE 'a' SET`) at WHERE: WHERE clause is mandatory for UPDATE & DELETE

Example: Incomplete UPDATE with table name, SET with a field but no value and WHERE fails

query, err := sqlparser.Parse(`UPDATE 'a' SET b WHERE`) at UPDATE: expected '='

Example: Incomplete UPDATE with table name, SET with a field and = but no value and WHERE fails

query, err := sqlparser.Parse(`UPDATE 'a' SET b = WHERE`) at UPDATE: expected quoted value

Example: Incomplete UPDATE due to no WHERE clause fails

query, err := sqlparser.Parse(`UPDATE 'a' SET b = 'hello' WHERE`) at WHERE: empty WHERE clause

Example: Incomplete UPDATE due incomplete WHERE clause fails

query, err := sqlparser.Parse(`UPDATE 'a' SET b = 'hello' WHERE a`) at WHERE: condition without operator

Example: Empty DELETE fails

query, err := sqlparser.Parse(`DELETE FROM`) table name cannot be empty

Example: DELETE without WHERE fails

query, err := sqlparser.Parse(`DELETE FROM 'a'`) at WHERE: WHERE clause is mandatory for UPDATE & DELETE

Example: DELETE with empty WHERE fails

query, err := sqlparser.Parse(`DELETE FROM 'a' WHERE`) at WHERE: empty WHERE clause

Example: DELETE with WHERE with field but no operator fails

query, err := sqlparser.Parse(`DELETE FROM 'a' WHERE b`) at WHERE: condition without operator

Example: Empty INSERT fails

query, err := sqlparser.Parse(`INSERT INTO`) table name cannot be empty

Example: INSERT with no rows to insert fails

query, err := sqlparser.Parse(`INSERT INTO 'a'`) at INSERT INTO: need at least one row to insert

Example: INSERT with incomplete value section fails

query, err := sqlparser.Parse(`INSERT INTO 'a' (`) at INSERT INTO: need at least one row to insert

Example: INSERT with incomplete value section fails #2

query, err := sqlparser.Parse(`INSERT INTO 'a' (b`) at INSERT INTO: need at least one row to insert

Example: INSERT with incomplete value section fails #3

query, err := sqlparser.Parse(`INSERT INTO 'a' (b)`) at INSERT INTO: need at least one row to insert

Example: INSERT with incomplete value section fails #4

query, err := sqlparser.Parse(`INSERT INTO 'a' (b) VALUES`) at INSERT INTO: need at least one row to insert

Example: INSERT with incomplete row fails

query, err := sqlparser.Parse(`INSERT INTO 'a' (b) VALUES (`) at INSERT INTO: value count doesn't match field count

Example: INSERT * fails

query, err := sqlparser.Parse(`INSERT INTO 'a' (*) VALUES ('1')`) at INSERT INTO: expected at least one field to insert

Name		Name	Last commit message	Last commit date
Latest commit History 27 Commits
query		query
.travis.yml		.travis.yml
LICENSE		LICENSE
README.md		README.md
README.template		README.template
go.mod		go.mod
go.sum		go.sum
sql.go		sql.go
sql_test.go		sql_test.go

Folders and files

Latest commit

History

Repository files navigation

sqlparser - meant for querying csv files

Usage

Example: SELECT works

Example: SELECT works with lowercase

Example: SELECT many fields works

Example: SELECT with alias works

Example: SELECT with WHERE with = works

Example: SELECT with WHERE with < works

Example: SELECT with WHERE with <= works

Example: SELECT with WHERE with > works

Example: SELECT with WHERE with >= works

Example: SELECT with WHERE with != works

Example: SELECT with WHERE with != works (comparing field against another field)

Example: SELECT * works

Example: SELECT a, * works

Example: SELECT with WHERE with two conditions using AND works

Example: UPDATE works

Example: UPDATE works with simple quote inside

Example: UPDATE with multiple SETs works

Example: UPDATE with multiple SETs and multiple conditions works

Example: DELETE with WHERE works

Example: INSERT works

Example: INSERT with multiple fields works

Example: INSERT with multiple fields and multiple values works

Example: empty query fails

Example: SELECT without FROM fails

Example: SELECT without fields fails

Example: SELECT with comma and empty field fails

Example: SELECT with empty WHERE fails

Example: SELECT with WHERE with only operand fails

Example: Empty UPDATE fails

Example: Incomplete UPDATE with table name fails

Example: Incomplete UPDATE with table name and SET fails

Example: Incomplete UPDATE with table name, SET with a field but no value and WHERE fails

Example: Incomplete UPDATE with table name, SET with a field and = but no value and WHERE fails

Example: Incomplete UPDATE due to no WHERE clause fails

Example: Incomplete UPDATE due incomplete WHERE clause fails

Example: Empty DELETE fails

Example: DELETE without WHERE fails

Example: DELETE with empty WHERE fails

Example: DELETE with WHERE with field but no operator fails

Example: Empty INSERT fails

Example: INSERT with no rows to insert fails

Example: INSERT with incomplete value section fails

Example: INSERT with incomplete value section fails #2

Example: INSERT with incomplete value section fails #3

Example: INSERT with incomplete value section fails #4

Example: INSERT with incomplete row fails

Example: INSERT * fails

About

Topics

Resources

License

Uh oh!

Stars

Watchers

Forks

Releases

Packages 0

Uh oh!

Uh oh!

Contributors

Uh oh!

Languages

Packages