{ "info": { "author": "Chang-Hung Liang", "author_email": "eliang.cs@gmail.com", "bugtrack_url": null, "classifiers": [ "Development Status :: 3 - Alpha", "Intended Audience :: Developers", "License :: OSI Approved :: BSD License", "Operating System :: Unix", "Programming Language :: Python", "Programming Language :: Python :: 2.6", "Programming Language :: Python :: 2.7", "Programming Language :: SQL", "Topic :: Database", "Topic :: Database :: Front-Ends", "Topic :: Software Development", "Topic :: Software Development :: Libraries :: Python Modules" ], "description": "vcli: A REPL for Vertica\n========================\n\n|Build Status| |PyPI|\n\nA Vertica_ client that does auto-completion and syntax highlighting, based on\npgcli_.\n\n.. image:: screenshots/vcli.gif\n\n\nInstallation\n------------\n\nJust install it like a regular Python package::\n\n $ pip install vcli\n\nYou'll probably see some permission errors if you're installing it on the\nsystem-wide Python. If that's what you want to do, you need to ``sudo``::\n\n $ sudo pip install vcli\n\nTo upgrade vcli, do::\n\n $ pip install -U vcli\n\n\nUsage\n-----\n\nConnecting to a Database\n~~~~~~~~~~~~~~~~~~~~~~~~\n::\n\n $ vcli --help\n Usage: vcli [OPTIONS] [DATABASE]\n\n Options:\n -h, --host TEXT Database server host address [default: localhost]\n -p, --port INTEGER Database server port [default: 5433]\n -U, --user TEXT Database username [default: CURRENT_USER]\n -W, --prompt-password Prompt for password [default: False]\n -w, --password TEXT Database password [default: ]\n -v, --version Print version and exit\n --vclirc TEXT Location of .vclirc file [default: ~/.vclirc]\n --help Show this message and exit.\n\n**Examples**\n\nUse URL to connect::\n\n $ vcli vertica://dbadmin:pass@localhost:5433/mydb\n\nPrompt for password::\n\n $ vcli -h localhost -U dbadmin -W -p 5433 mydb\n\nDon't prompt for password::\n\n $ vcli -h localhost -U dbadmin -w pass -p 5433 mydb\n\nUse VERTICA_URL environment variable::\n\n $ VERTICA_URL=vertica://dbadmin:pass@localhost:5433/mydb vcli\n\n\nSpecial Commands\n~~~~~~~~~~~~~~~~\n::\n\n vcli_demo=> \\h\n +---------------------+--------------------------------------+\n | Command | Description |\n |---------------------+--------------------------------------|\n | \\# | Refresh auto-completions |\n | \\? | Show help |\n | \\a | Aligned or unaligned |\n | \\c[onnect] [DBNAME] | Connect to a new database |\n | \\d [PATTERN] | List or describe tables |\n | \\dS [PATTERN] | List system tables |\n | \\dT [PATTERN] | List data types |\n | \\df [PATTERN] | List functions |\n | \\dj [PATTERN] | List projections |\n | \\dn [PATTERN] | List schemas |\n | \\dp [PATTERN] | List access privileges |\n | \\ds [PATTERN] | List sequences |\n | \\dt [PATTERN] | List tables |\n | \\dtv [PATTERN] | List tables and views |\n | \\du [PATTERN] | List users |\n | \\dv [PATTERN] | List views |\n | \\e [FILE] | Edit the query with external editor |\n | \\h | Show help |\n | \\i FILE | Execute commands from file |\n | \\l | List databases |\n | \\n[+] [NAME] | List or execute named queries |\n | \\nd [NAME] | Delete a named query |\n | \\ns NAME QUERY | Save a named query |\n | \\o [FILE] | Output to file or stdout |\n | \\q | Quit vcli |\n | \\refresh | Refresh auto-completions |\n | \\t | Toggle header |\n | \\timing | Toggle timing of commands |\n | \\x | Toggle expanded output |\n | \\z [PATTERN] | List access privileges (same as \\dp) |\n +---------------------+--------------------------------------+\n\n\nThanks\n------\n\nThanks to pgcli_. Most of the hard work, especially the auto-completion part,\nwere already done well by the pgcli core team. vcli wouldn't be possible if it\nweren't for them.\n\n\n.. |Build Status| image:: https://api.travis-ci.org/dbcli/vcli.svg?branch=master\n :target: https://travis-ci.org/dbcli/vcli\n\n.. |PyPI| image:: https://img.shields.io/pypi/v/vcli.svg\n :target: https://pypi.python.org/pypi/vcli/\n :alt: Latest Version\n\n.. _pgcli: http://pgcli.com\n.. _Vertica: http://www.vertica.com/", "description_content_type": null, "docs_url": null, "download_url": "UNKNOWN", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "http://github.com/dbcli/vcli", "keywords": null, "license": "LICENSE.txt", "maintainer": null, "maintainer_email": null, "name": "vcli", "package_url": "https://pypi.org/project/vcli/", "platform": "UNKNOWN", "project_url": "https://pypi.org/project/vcli/", "project_urls": { "Download": "UNKNOWN", "Homepage": "http://github.com/dbcli/vcli" }, "release_url": "https://pypi.org/project/vcli/0.1.2/", "requires_dist": null, "requires_python": null, "summary": "Vertica CLI with auto-completion and syntax highlighting", "version": "0.1.2" }, "last_serial": 2454376, "releases": { "0.0.1": [ { "comment_text": "", "digests": { "md5": "411010f8f9685119c1c969a7fb81bb16", "sha256": "3d2259de571ba32cda8b5ce016ae5b97b3adc54f5985327d9a85472891ef3c7e" }, "downloads": -1, "filename": "vcli-0.0.1-py2-none-any.whl", "has_sig": false, "md5_digest": "411010f8f9685119c1c969a7fb81bb16", "packagetype": "bdist_wheel", "python_version": "2.7", "requires_python": null, "size": 58429, "upload_time": "2015-11-19T08:31:46", "url": "https://files.pythonhosted.org/packages/85/f9/98c09d134998dbd66380ab24303e57a939721cfe521ae1a6bc3e6c537ada/vcli-0.0.1-py2-none-any.whl" }, { "comment_text": "", "digests": { "md5": "b00feb04b84defef8d44f187685294ae", "sha256": "ef982e7c8e20802ab10b34141de7ffc24352d191794c0d9fe993f21a65a46b8b" }, "downloads": -1, "filename": "vcli-0.0.1.tar.gz", "has_sig": false, "md5_digest": "b00feb04b84defef8d44f187685294ae", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 50596, "upload_time": "2015-11-19T08:31:40", "url": "https://files.pythonhosted.org/packages/a6/5b/e2bc94fa5f7e9eccda1c1c4da1c7405f49615f038edf988fc2d00df43441/vcli-0.0.1.tar.gz" } ], "0.1.0": [ { "comment_text": "", "digests": { "md5": "2ef8d6c89a13291d654e96abea1cea45", "sha256": "6944e10d0c509793242ca629bde68e5895bed5e1dabb2d34d8388d34f2149cfb" }, "downloads": -1, "filename": "vcli-0.1.0-py2-none-any.whl", "has_sig": false, "md5_digest": "2ef8d6c89a13291d654e96abea1cea45", "packagetype": "bdist_wheel", "python_version": "2.7", "requires_python": null, "size": 59555, "upload_time": "2016-02-19T09:34:33", "url": "https://files.pythonhosted.org/packages/ae/3c/4888d4b052b243b4f1891499c9c95f5f8c892c67ec9c121c22d2720a82c5/vcli-0.1.0-py2-none-any.whl" }, { "comment_text": "", "digests": { "md5": "2a6a12137afaa1b3416ec9ba353c7151", "sha256": "1d04ad0bc484ab11d83db23c35091920503783d936ff9965eb80c6159b6842c0" }, "downloads": -1, "filename": "vcli-0.1.0.tar.gz", "has_sig": false, "md5_digest": "2a6a12137afaa1b3416ec9ba353c7151", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 51550, "upload_time": "2016-02-19T09:34:27", "url": "https://files.pythonhosted.org/packages/e5/b3/2761289ec10ac66bb58031decfb0f680e5c76334dc20b81f80e0e90addbc/vcli-0.1.0.tar.gz" } ], "0.1.1": [ { "comment_text": "", "digests": { "md5": "b1dd283ea159317f63fdb93c760e7941", "sha256": "636c443400f7909bd377c515a730c5f160140603435601d47e95f20d3f37b6d2" }, "downloads": -1, "filename": "vcli-0.1.1-py2-none-any.whl", "has_sig": false, "md5_digest": "b1dd283ea159317f63fdb93c760e7941", "packagetype": "bdist_wheel", "python_version": "2.7", "requires_python": null, "size": 60992, "upload_time": "2016-03-27T05:34:16", "url": "https://files.pythonhosted.org/packages/e7/13/ae979d9138ce0c8cb52d776a03b5b0a81f58bc6172056b860bacf07ec5d3/vcli-0.1.1-py2-none-any.whl" }, { "comment_text": "", "digests": { "md5": "2f61e22f08a5386d415c71e7585a228e", "sha256": "013f1391aba34e9c4acefc3e935401c10064d3e6e3bda9c0701acc44fbd87fb6" }, "downloads": -1, "filename": "vcli-0.1.1.tar.gz", "has_sig": false, "md5_digest": "2f61e22f08a5386d415c71e7585a228e", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 53065, "upload_time": "2016-03-27T05:34:01", "url": "https://files.pythonhosted.org/packages/3d/bc/46d1e76060ff3cf4c3836a0ce57254bdd03c8bf3870f162681b141bc11a0/vcli-0.1.1.tar.gz" } ], "0.1.2": [ { "comment_text": "", "digests": { "md5": "e6119932eade9759a809d6f19dbd9897", "sha256": "65bf8914152a88679bd62bb7a4928fe310a0251a72e23f6563d3d3e97706a54a" }, "downloads": -1, "filename": "vcli-0.1.2.tar.gz", "has_sig": false, "md5_digest": "e6119932eade9759a809d6f19dbd9897", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 53004, "upload_time": "2016-11-11T02:06:52", "url": "https://files.pythonhosted.org/packages/a7/0e/5d907cb5c2a010b15d659d02fd3a3ac396962f48d49707f2ff9f164e196e/vcli-0.1.2.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "e6119932eade9759a809d6f19dbd9897", "sha256": "65bf8914152a88679bd62bb7a4928fe310a0251a72e23f6563d3d3e97706a54a" }, "downloads": -1, "filename": "vcli-0.1.2.tar.gz", "has_sig": false, "md5_digest": "e6119932eade9759a809d6f19dbd9897", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 53004, "upload_time": "2016-11-11T02:06:52", "url": "https://files.pythonhosted.org/packages/a7/0e/5d907cb5c2a010b15d659d02fd3a3ac396962f48d49707f2ff9f164e196e/vcli-0.1.2.tar.gz" } ] }