get table names: syntax error when blacklist or whitelist is used

volatiletech / sqlboiler-sqlite3

sqlite3 driver for sqlboiler

BSD 3-Clause "New" or "Revised" License

19 stars 16 forks source link

get table names: syntax error when blacklist or whitelist is used #1

Closed akoeb closed 6 years ago

akoeb commented 6 years ago

I get following error when I use sqlboiler v3 with this driver:

unable to get table names: near "and": syntax error
Error: unable to initialize tables: unable to fetch table data: driver (/home/user/gopath/bin/sqlboiler-sqlite3) exited non-zero: exit status 1

I was using following command line: $GOPATH/bin/sqlboiler sqlite3

with following sqlboiler.toml:

[sqlite3]
dbname = "database.db"
blacklist = ["goose_db_version"]

akoeb commented 6 years ago

The error is fixed if you remove the semicolon in line 121 of file driver/sqlite.go

aarondl commented 6 years ago

Thanks for the PR :) Closed via #2