ankane/blazer

"Preview table" doesn't seem to work with sqlite

dgmora opened this issue · 2 comments

dgmora commented

Hello, I was trying blazer with sqlite3 and it seems the statement to fetch the tables doesn't work. As a consequence preview table here is empty:

Image

It seems the statement used isn't valid for sqlite. From what I've seen, this one works:

SELECT name FROM sqlite_master where type = 'table'

There are also no schemas in sqlite, and for the result to work you have to do result.rows.map(&:first).sort instead of &:second. I'm wondering, was this working before?

ankane commented

Hi @dgmora, thanks for reporting. Fixed in the commit above.

dgmora commented

Thanks for the quick follow up, works great!

  • 👍1