chrisclark/django-sql-explorer

Easily share data across your company via SQL queries. From Grove Collab.

django-sql-explorer's Issues

Document admin features

Can't download CSV report with ?params={}

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.

PyPI Release

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

Make URLs more robust

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

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

Show query execution time

Relative URLs can get wonky after downloading a file

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

floatthead is now on cdnjs

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

SQL error messages aren't shown on the playground

DB schema fields for non-model tables are not pulled into schema help

Many-to-many relation tables are not surfaced

Downlaod CSV and parameterised queries

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?

Link from report admin to nice front end detail page

validate_reports management command

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

Created date

Paginate the query preview

Page title on Query index page has an extra '-' in it

Option for re-running query without saving

Maybe a playground mode?

Preview of reports (11 row default)

don't save report if sql doesn't run

Versioning of queries

Ability to download en masse and delete from report listing

Documentation & screenshots

Add keyboard shortcut for executing queries

Inclusion of % (in a LIKE clause) throws AttributeError

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.

Automatically track query creator

Granular permissions

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.

Documentation to-dos

• Document dependencies more thoroughly
• Document settings

Downloading CSV from playground doesn't work

Tests for staff-only access

Refactor permission stuff so it doesn't add attributes to the user class

Admin only protection for report list view

Show schema reference embedded in the query builder

UI to change # of preview rows

Create a settings parameter for which DB connection to use

A way of killing runaway sql queries

Hard timeout at 10s? Make it configurable.

Move floatthead to the local codebase so it isn't pulling from github

Show SQL line numbers

Last downloaded at date

Python 3 compatibility

missing opening html tag in base template

wanted to let you know

Changing # of rows displayed in the playground doesn't work

Ability to parameterize queries

Pre-populated "created by" is no longer working for new queries

Also make sure it works for queries created from the playground

"You have unsaved changes" message

Submitting queries with no params puts a ?params={} into the query string

This should not happen.

Index page w/ downloading

Build out proper navigation on templates

Playground, create new, listing

Fix screenshot urls in readme

Schema helpers in the UI

Show SQL errors when stuff goes wrong

Create new report from playground