{ "info": { "author": "toritori0318", "author_email": "toritori0318@gmail.com", "bugtrack_url": null, "classifiers": [ "Development Status :: 3 - Alpha", "Intended Audience :: Developers", "License :: OSI Approved :: MIT License", "Programming Language :: Python :: 2", "Programming Language :: Python :: 2.6", "Programming Language :: Python :: 2.7", "Programming Language :: Python :: 3", "Programming Language :: Python :: 3.3", "Programming Language :: Python :: 3.4", "Programming Language :: Python :: 3.5", "Topic :: Software Development :: Build Tools" ], "description": "## Redash Dynamic Query\n\nA tool for executing dynamic query of redash.\n\n## Install\n\n```\npip install redash-dynamic-query\n```\n\n## SYNOPSIS\n\n```python\nfrom redash_dynamic_query import RedashDynamicQuery\n\nredash = RedashDynamicQuery(\n endpoint='http://myredash-host',\n apikey='secret_apikey',\n data_source_id=2, # Optional, default auto fill\n max_age=0, # Optional, default value is 0\n max_wait=60, # Optional, default value is 60\n)\n\nquery_id = 111\nbind = {\n 'start_date': '2017-01-01T00:00:00',\n 'end_date': '2017-01-01T23:59:59',\n}\nresult = redash.query(query_id, bind)\nprint(result['query_result']['data'])\n# {\n# 'rows': [\n# {'mydata': 'xxx'}\n# ],\n# 'columns': [\n# {\n# 'type': 'string',\n# 'friendly_name': 'mydata',\n# 'name': 'mydata'\n# }\n# ]\n# }\n```\n\n## CLI\n\n```\n% rdq\n```\n\n```\n% rdq --help\n\nusage: rdq [-h] [-d N] [-a N] [-w N] [-k APIKEY] [-e ENDPOINT] -q QUERY_ID\n [-p QUERY_PARAMETERS] [-f {csv,tsv,json,redash_csv}]\n\nProcess some integers.\n\noptional arguments:\n -h, --help show this help message and exit\n -d N, --data-source-id N\n an integer for the data_source_id\n -a N, --max-age N an integer for the max_age\n -w N, --max-wait N an integer for the max_wait(timeout)\n -k APIKEY, --apikey APIKEY\n required: redash apikey (can also be specified using\n REDASH_APIKEY environment variable)\n -e ENDPOINT, --endpoint ENDPOINT\n required: redash endpoint (can also be specified using\n REDASH_ENDPOINT environment variable)\n -q QUERY_ID, --query-id QUERY_ID\n required: redash query id\n -p QUERY_PARAMETERS, --query-parameters QUERY_PARAMETERS\n redash query parameters(eg. key1=val1,key2=val2)\n -f {csv,tsv,json,redash_csv}, --output-format {csv,tsv,json,redash_csv}\n redash output format\n```\n\n```\n# example\n% rdq -e http://myredash-host -k secret_apikey -q 111 -p start_date=2017-01-01T00:00:00,end_date=2017-01-01T23:59:59 -f csv\n```\n\n## LICENSE\n\nMIT", "description_content_type": "", "docs_url": null, "download_url": "", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/toritori0318/redash-dynamic-query", "keywords": "redash", "license": "MIT", "maintainer": "", "maintainer_email": "", "name": "redash-dynamic-query", "package_url": "https://pypi.org/project/redash-dynamic-query/", "platform": "", "project_url": "https://pypi.org/project/redash-dynamic-query/", "project_urls": { "Homepage": "https://github.com/toritori0318/redash-dynamic-query" }, "release_url": "https://pypi.org/project/redash-dynamic-query/1.0.4/", "requires_dist": null, "requires_python": "", "summary": "Redash Dynamic Query", "version": "1.0.4" }, "last_serial": 4447824, "releases": { "1.0.0": [ { "comment_text": "", "digests": { "md5": "51c7cb838abf3afe0dd6958135c805a5", "sha256": "4701af8872168950f02ae4bc890059f41e24c9c57a873efa07af76fd478871e7" }, "downloads": -1, "filename": "redash-dynamic-query-1.0.0.tar.gz", "has_sig": false, "md5_digest": "51c7cb838abf3afe0dd6958135c805a5", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3363, "upload_time": "2017-10-22T19:03:35", "url": "https://files.pythonhosted.org/packages/37/f5/116fb95454925831c0046ace2029da8b01ac19df63b7e4151f564bb9f8ca/redash-dynamic-query-1.0.0.tar.gz" } ], "1.0.1": [ { "comment_text": "", "digests": { "md5": "db903bc7d35dee1075906eea943ae85e", "sha256": "a505de635def0c28c798d1e6acd83acd178862c1d4d38512912cd2eb44b6c792" }, "downloads": -1, "filename": "redash-dynamic-query-1.0.1.tar.gz", "has_sig": false, "md5_digest": "db903bc7d35dee1075906eea943ae85e", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3412, "upload_time": "2017-11-12T18:21:19", "url": "https://files.pythonhosted.org/packages/d1/1a/fa3e59ef5e260cee33b25e36fef1f1ed30e1eaf0fa1049c5c18ffb8faf28/redash-dynamic-query-1.0.1.tar.gz" } ], "1.0.2": [ { "comment_text": "", "digests": { "md5": "7f07d159108ac2f5eae7a45c40807683", "sha256": "197eda583eb6d071853feb889efeafc823fdb76777324dfbd1eb45cc8b72968f" }, "downloads": -1, "filename": "redash-dynamic-query-1.0.2.tar.gz", "has_sig": false, "md5_digest": "7f07d159108ac2f5eae7a45c40807683", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3380, "upload_time": "2018-05-31T19:52:15", "url": "https://files.pythonhosted.org/packages/44/df/60adcf54b0be69e6cf20040d3356bf8836ba1c638ea1b6bfff0fbf60cedd/redash-dynamic-query-1.0.2.tar.gz" } ], "1.0.3": [ { "comment_text": "", "digests": { "md5": "b4cc83685b8848b70c660e876c14252d", "sha256": "d4419098c64494f1b2e966fee290bccb4bf3487f2128c53e8c38ac9f10f74c62" }, "downloads": -1, "filename": "redash-dynamic-query-1.0.3.tar.gz", "has_sig": false, "md5_digest": "b4cc83685b8848b70c660e876c14252d", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3434, "upload_time": "2018-11-03T16:44:56", "url": "https://files.pythonhosted.org/packages/98/17/351b0324f83a917cbcb107ebd529039efa23e3ad9703859cb38b8047aad8/redash-dynamic-query-1.0.3.tar.gz" } ], "1.0.4": [ { "comment_text": "", "digests": { "md5": "aeef5a184f18db32b49b2de4330383f7", "sha256": "d2756ad2f7fd21f33cbf8c751ec3fccaf9ad350a27b968cd56b3d1783650b5f9" }, "downloads": -1, "filename": "redash-dynamic-query-1.0.4.tar.gz", "has_sig": false, "md5_digest": "aeef5a184f18db32b49b2de4330383f7", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5218, "upload_time": "2018-11-03T17:07:39", "url": "https://files.pythonhosted.org/packages/c9/aa/8a7dc9ffaf83907957f10b6db9789bc7b1d811c58c200a6ac07e837ccc0e/redash-dynamic-query-1.0.4.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "aeef5a184f18db32b49b2de4330383f7", "sha256": "d2756ad2f7fd21f33cbf8c751ec3fccaf9ad350a27b968cd56b3d1783650b5f9" }, "downloads": -1, "filename": "redash-dynamic-query-1.0.4.tar.gz", "has_sig": false, "md5_digest": "aeef5a184f18db32b49b2de4330383f7", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5218, "upload_time": "2018-11-03T17:07:39", "url": "https://files.pythonhosted.org/packages/c9/aa/8a7dc9ffaf83907957f10b6db9789bc7b1d811c58c200a6ac07e837ccc0e/redash-dynamic-query-1.0.4.tar.gz" } ] }