Add an ActiveData query runner

[klahnakoski]

I would like to use redash's powerful features with our ActiveData[1] instance. It accepts SQL, via RESTful request, so is just different enough to demand it has it's own query runner.

I made a query runner [2] and now I would like guidance to get it integrated into Mozilla's redash.

[1] https://wiki.mozilla.org/Auto-tools/Projects/ActiveData
[2] https://github.com/klahnakoski/ActiveData-redash-query-runner/blob/master/active_data.py

[rafrombrc]

From https://bugzilla.mozilla.org/show_bug.cgi?id=1364149

[alison985]

This is where I'm at: master...alison985:83_activedata_query_runner I have no idea why it won't save the Host URL field.

[klahnakoski]

Here is the original query runner: https://github.com/klahnakoski/ActiveData-redash-query-runner/blob/master/active_data.py

The __init__() method is commented out in your version. That may be the problem.

[klahnakoski]

...also this version demands a host_url property, but my version wanted a url property

[klahnakoski]

please change properties.host_url.default from http://127.0.0.1:5000 to https://activedata.allizom.org:80

       'properties': {
           'host_url': {
               'type': 'string',
               'title': 'Host URL',
               'default': 'http://127.0.0.1:5000' #,
               #'info': 'Do not end with a trailing slash.'
           },

[alison985]

Thanks @klahnakoski. I updated future references to host_url instead of url, uncommented init() (which was giving me problems earlier), and changed the host_url.default, but it still won't save the host_url field input. Tagging @robhudson.

[alison985]

Being discussed here: https://discuss.redash.io/t/adding-a-new-query-runner-i-have-a-data-source-field-that-wont-save/864/3