{ "info": { "author": "hackliff", "author_email": "xavier.bruhiere@gmail.com", "bugtrack_url": null, "classifiers": [ "Intended Audience :: Developers", "License :: OSI Approved :: MIT License", "Operating System :: Unix", "Programming Language :: Python", "Programming Language :: Python :: 2.7", "Programming Language :: Python :: 3", "Programming Language :: Python :: 3.4", "Programming Language :: SQL", "Topic :: Database", "Topic :: Database :: Front-Ends", "Topic :: Software Development", "Topic :: Software Development :: Libraries :: Python Modules" ], "description": "# Data Cli\n\n> Productive no-sql data sources exploration with SQL, Pandas and\n> shortcuts\n\n| service | status |\n| --------------------- |:-------------:|\n| travis | [![Build Status](https://travis-ci.org/hackliff/mgocli.svg?branch=master)](https://travis-ci.org/hackliff/mgocli) |\n| quay.io/hackliff/drill | [![Docker Repository on Quay](https://quay.io/repository/hackliff/drill/status \"Docker Repository on Quay\")](https://quay.io/repository/hackliff/drill) |\n\n## Getting started\n\n`make container.build` will start and initialize [MongoDB](), [Drill]()\nand `datacli` with everything installed.\n\nIt is still possible to register external data sources :\n\n```Bash\n$ cp ./tools/drill/mongo-storage-plugin.json custom-storage.json\n$ $EDITOR custom-storage.json\n$ ./tools/drill/manage.sh storage ./custom-storage.json http://$(docker-machine ip default):8047\n{\n \"result\" : \"success\"\n}\n```\n\n## Usage\n\n### Mgocli\n\n```Bash\n$ ./datacli/__main__.py -H $(docker-machine ip default) appturbo\n[2016-07-06 06:38:24,564] datacli :: INFO - connected to Drillbit\n[ datacli::192.168.99.100::appturbo ] >>> SHOW DATABASES\n[2016-07-06 06:38:48,391] datacli :: INFO - sending query to drill\n[show databases]\n SCHEMA_NAME\n0 INFORMATION_SCHEMA\n1 cp.default\n2 dfs.default\n3 dfs.root\n4 dfs.tmp\n\n```\n\n### Drill Repl\n\n```sql\n$ # query data\n$ docker exec -it $(basename $PWD)_drill_1 /opt/apache-drill-1.7.0/bin/drill-localhost\n0: jdbc:drill:drillbit=localhost> SHOW DATABASES;\n+---------------------+\n| SCHEMA_NAME |\n+---------------------+\n| INFORMATION_SCHEMA |\n| cp.default |\n| dfs.default |\n| dfs.root |\n| dfs.tmp |\n| nosqltest.employee |\n| nosqltest.local |\n| nosqltest.test |\n| sys |\n+---------------------+\n9 rows selected (0.244 seconds)\n\n0: jdbc:drill:drillbit=localhost> SELECT * FROM nosqltest.test.zips\nLIMIT 3;\n+--------+----------+-------------------------+--------+--------+\n| _id | city | loc | pop | state |\n+--------+----------+-------------------------+--------+--------+\n| 01001 | AGAWAM | [-72.622739,42.070206] | 15338 | MA |\n| 01002 | CUSHMAN | [-72.51565,42.377017] | 36963 | MA |\n| 01005 | BARRE | [-72.108354,42.409698] | 4546 | MA |\n+--------+----------+-------------------------+--------+--------+\n3 rows selected (0.325 seconds)\n\n0: jdbc:drill:drillbit=localhost> !quit\n```", "description_content_type": null, "docs_url": null, "download_url": "UNKNOWN", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/hackliff/datacli", "keywords": "data,database,analysis,cli,tool", "license": "UNKNOWN", "maintainer": null, "maintainer_email": null, "name": "mgocli", "package_url": "https://pypi.org/project/mgocli/", "platform": "UNKNOWN", "project_url": "https://pypi.org/project/mgocli/", "project_urls": { "Download": "UNKNOWN", "Homepage": "https://github.com/hackliff/datacli" }, "release_url": "https://pypi.org/project/mgocli/0.1.3/", "requires_dist": null, "requires_python": null, "summary": "Productive no-sql data sources exploration with SQL, Pandas and shortcuts", "version": "0.1.3" }, "last_serial": 2207886, "releases": { "0.1.3": [] }, "urls": [] }