explorerhq / sql-explorer Goto Github PK

Hard timeout at 10s? Make it configurable.

When I try to access link:
http://host/explorer/1/download?params={'param':1}

It redirects me to edit query screen. I am expecting a CSV file to be downloaded.

Many-to-many relation tables are not surfaced

Currently the app expects the form to post to /report/

The form/template should be flexible enough to work with any routing scheme.

1. Download a query
2. Click on playground
3. Note URLs are getting weird

Also make sure it works for queries created from the playground

Maybe a playground mode?

wanted to let you know

• Document dependencies more thoroughly
• Document settings

Is there an easy way to split permissions for execution and manipulation of queries? I'd like to give my staff users the right to execute saved queries but only admins should be able to change and save queries.

Thanks.

This should not happen.

http://cdnjs.com/libraries/floatthead/

Including sql values like AND fieldname LIKE "%match%"

Throws: AttributeError. 'Cursor' object has no attribute '_last_executed'

If I python encode the percent signs, it works as expected.

AND fieldname LIKE "%%match%%"

It should be possible to enter the proper SQL syntax and have sql-explorer do the encoding needed.

Some way to validate that crucial reports don't break as schema changes are made to the underlying database.

Hey Chris,

do you plan to release an updated version on pypi anytime soon?
I don't really like to fetch my requirements from vcs repos :-)

Thanks, Jens

Playground, create new, listing

If I save and run a successful parametrised query. Download CSV does not download results of that successful query, instead I get an csv file with an error because the parameters are blank. I'm assuming that clicking 'Download CSV' is re-running a query rather than exporting the results of the successful run?