{ "info": { "author": "Vibhor Kumar", "author_email": "vibhor.aim@gmail.com", "bugtrack_url": null, "classifiers": [ "Intended Audience :: Developers", "License :: OSI Approved :: BSD License", "Operating System :: Unix", "Programming Language :: Python", "Programming Language :: Python :: 2", "Programming Language :: Python :: 2.7", "Programming Language :: Python :: 3", "Programming Language :: Python :: 3.4", "Programming Language :: Python :: 3.5", "Programming Language :: Python :: 3.6", "Programming Language :: Python :: 3.7", "Programming Language :: SQL", "Topic :: Database", "Topic :: Database :: Front-Ends", "Topic :: Software Development", "Topic :: Software Development :: Libraries :: Python Modules" ], "description": "# usql\n\n[![Build Status](https://travis-ci.org/dbcli/usql.svg?branch=master)](https://travis-ci.org/dbcli/usql)\n\nA command-line client for Uptycs that has auto-completion and syntax highlighting.\nThis tool is based on dbcli frame work. We have used Uptycs restcall in the tool\n\n## Installation\n\nIf you already know how to install python packages, then you can install it via pip:\n\nYou might need sudo on linux.\n\nif you want to install usql, using pip, you can use following command:\n```\n$ sudo pip install usql\n```\n\nif you want to install from source you can use following command:\n```\n$ git pull usql\n$ cd usql\n$ python setup.py install\n```\n\n\n## Usage\n\n $ usql --help\n\n Usage: usql -k [DATABASE]\n\n Examples:\n - usql -k mykeyfile [global|realtime|timemachine]\n\nA config file is automatically created at `~/.config/usql/config` at first launch. See the file itself for a description of all available options.\n\nFollowing are the options available through the tool\n\n```\n+-------------+----------------------------+------------------------------------------------------------+\n| Command | Shortcut | Description |\n+-------------+----------------------------+------------------------------------------------------------+\n| .databases | .databases | List databases. |\n| .open | .open | Change to a new database. |\n| .schema | .schema[+] [table] | The complete schema for the database or a single table |\n| .status | \\s | Show current settings. |\n| .tables | \\dt[+] [table] | List or describe tables. |\n| \\G | \\G | Display current query results vertically. |\n| \\e | \\e | Edit command with editor (uses $EDITOR). |\n| \\f | \\f [name [args..]] | List or execute favorite queries. |\n| \\fd | \\fd [name] | Delete a favorite query. |\n| \\fs | \\fs name query | Save a favorite query. |\n| \\once | \\o [-o] filename | Append next result to an output file (overwrite using -o). |\n| exit | \\q | Exit. |\n| help | \\? | Show this help. |\n| nopager | \\n | Disable pager, print to stdout. |\n| notee | notee | Stop writing results to an output file. |\n| pager | \\P [command] | Set PAGER. Print the query results via PAGER. |\n| prompt | \\R | Change prompt format. |\n| quit | \\q | Quit. |\n| rehash | \\# | Refresh auto-completions. |\n| source | \\. filename | Execute commands from file. |\n| system | system [command] | Execute a system shell commmand. |\n| tableformat | \\T | Change the table format used to output results. |\n| tee | tee [-o] filename | Append all results to an output file (overwrite using -o). |\n| watch | watch [seconds] [-c] query | Executes the query every [seconds] seconds (by default 5). |\n+-------------+----------------------------+------------------------------------------------------------+\n```\n\n\n", "description_content_type": "text/markdown", "docs_url": null, "download_url": "", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/Uptycs/usql", "keywords": "", "license": "BSD", "maintainer": "", "maintainer_email": "", "name": "usql", "package_url": "https://pypi.org/project/usql/", "platform": "", "project_url": "https://pypi.org/project/usql/", "project_urls": { "Homepage": "https://github.com/Uptycs/usql" }, "release_url": "https://pypi.org/project/usql/2.1.0/", "requires_dist": [ "click (>=4.1)", "Pygments (>=1.6)", "prompt-toolkit (>=2.0.0)", "sqlparse (>=0.2.2)", "configobj (>=5.0.5)", "cli-helpers[styles] (>=1.0.1)", "PyJWT (>=0.5.2)", "requests" ], "requires_python": "", "summary": "CLI for Uptycs platform with auto-completion and syntax highlighting.", "version": "2.1.0", "yanked": false, "yanked_reason": null }, "last_serial": 10500414, "releases": { "2.0.5": [ { "comment_text": "", "digests": { "md5": "1c4a6a4423a865608a472e8a1ffd70fc", "sha256": "0381bc0fc907e9f49e928141b691a767a9a569d9db9ee1794a1058e9218807ae" }, "downloads": -1, "filename": "usql-2.0.5-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "1c4a6a4423a865608a472e8a1ffd70fc", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 51024, "upload_time": "2019-10-14T13:05:00", "upload_time_iso_8601": "2019-10-14T13:05:00.090786Z", "url": "https://files.pythonhosted.org/packages/23/04/527c44e4fe42925f310830cc8ab909f2f97fc7c1e21181d15cb32740c811/usql-2.0.5-py2.py3-none-any.whl", "yanked": false, "yanked_reason": null } ], "2.0.6": [ { "comment_text": "", "digests": { "md5": "a169fb1b77a9584dc8700a674282f195", "sha256": "72e126b3f6adc272c10ddd89bcb9e3c38ed27e0164517c63a1fc0f5be9333d76" }, "downloads": -1, "filename": "usql-2.0.6-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "a169fb1b77a9584dc8700a674282f195", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 51294, "upload_time": "2019-10-16T11:02:28", "upload_time_iso_8601": "2019-10-16T11:02:28.272551Z", "url": "https://files.pythonhosted.org/packages/ae/02/c821507d9dcc9b8d95115847811839c90b879e2eda6cb6eaf3720cbcf71c/usql-2.0.6-py2.py3-none-any.whl", "yanked": false, "yanked_reason": null } ], "2.0.7": [ { "comment_text": "", "digests": { "md5": "50777fd351d18b579e52c3c33ea554eb", "sha256": "25a98201b1d453f29426a5f9dc3abeda7a44bc594ac084fd8ed89609181557cf" }, "downloads": -1, "filename": "usql-2.0.7-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "50777fd351d18b579e52c3c33ea554eb", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 51288, "upload_time": "2019-10-16T15:21:57", "upload_time_iso_8601": "2019-10-16T15:21:57.122782Z", "url": "https://files.pythonhosted.org/packages/29/5f/b3aa6d92dbb947435316b312932db3a901ec7583f3b781f06116c6c965a1/usql-2.0.7-py2.py3-none-any.whl", "yanked": false, "yanked_reason": null } ], "2.0.8": [ { "comment_text": "", "digests": { "md5": "dd8d840a03d8d707c2872005a3f20592", "sha256": "4532f384fd483e3513de80f6c7333d21f18faa6b6f387ee4b074e0cf94d9950b" }, "downloads": -1, "filename": "usql-2.0.8-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "dd8d840a03d8d707c2872005a3f20592", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 51291, "upload_time": "2019-10-16T15:57:20", "upload_time_iso_8601": "2019-10-16T15:57:20.526783Z", "url": "https://files.pythonhosted.org/packages/7d/ec/186fb5aa7178967f18e6efb52ef71246493a3af0c2612b8a403524ac5b42/usql-2.0.8-py2.py3-none-any.whl", "yanked": false, "yanked_reason": null } ], "2.0.9": [ { "comment_text": "", "digests": { "md5": "4d94bc488163ef1a58156f7ed0e33a63", "sha256": "acb0be46fdc46065f0806f31fa08519e57320963ea9c236dab620ab9ba7adc65" }, "downloads": -1, "filename": "usql-2.0.9-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "4d94bc488163ef1a58156f7ed0e33a63", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 51301, "upload_time": "2019-10-21T18:19:06", "upload_time_iso_8601": "2019-10-21T18:19:06.458874Z", "url": "https://files.pythonhosted.org/packages/84/30/8fe5a6e279c861b0e3bca95258f7f9f52d4aa0be8444cf147b59ebfffa54/usql-2.0.9-py2.py3-none-any.whl", "yanked": false, "yanked_reason": null } ], "2.1.0": [ { "comment_text": "", "digests": { "md5": "cf6dab0264e32efec62dfcfb1339b0ef", "sha256": "f1b7d340505eeaa606b2b41549d30f618718c88e46478408548b9ec57cdeea01" }, "downloads": -1, "filename": "usql-2.1.0-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "cf6dab0264e32efec62dfcfb1339b0ef", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 95796, "upload_time": "2019-12-10T19:44:00", "upload_time_iso_8601": "2019-12-10T19:44:00.148839Z", "url": "https://files.pythonhosted.org/packages/bf/da/37833e2fb7d48ea7a9c4eb27fc1bf1cf61393089a75e4540f5c5ec1131ac/usql-2.1.0-py2.py3-none-any.whl", "yanked": false, "yanked_reason": null } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "cf6dab0264e32efec62dfcfb1339b0ef", "sha256": "f1b7d340505eeaa606b2b41549d30f618718c88e46478408548b9ec57cdeea01" }, "downloads": -1, "filename": "usql-2.1.0-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "cf6dab0264e32efec62dfcfb1339b0ef", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 95796, "upload_time": "2019-12-10T19:44:00", "upload_time_iso_8601": "2019-12-10T19:44:00.148839Z", "url": "https://files.pythonhosted.org/packages/bf/da/37833e2fb7d48ea7a9c4eb27fc1bf1cf61393089a75e4540f5c5ec1131ac/usql-2.1.0-py2.py3-none-any.whl", "yanked": false, "yanked_reason": null } ], "vulnerabilities": [] }