{ "info": { "author": "Brian Clapper", "author_email": "bmc@clapper.org", "bugtrack_url": null, "classifiers": [ "Environment :: Console", "Intended Audience :: Developers", "Intended Audience :: Science/Research", "Intended Audience :: System Administrators", "License :: OSI Approved :: BSD License", "Operating System :: OS Independent", "Programming Language :: SQL", "Topic :: Database :: Front-Ends", "Topic :: Utilities" ], "description": "*sqlcmd* is a SQL command line tool, similar in concept to tools like Oracle's\n`SQL*Plus`_, the PostgreSQL_ ``psql`` command, and MySQL_'s ``mysql`` tool.\n\n.. _SQL*Plus: http://www.oracle.com/technology/docs/tech/sql_plus/index.html\n.. _PostgreSQL: http://www.postgresql.org/\n.. _MySQL: http://www.mysql.org/\n\nSome features at a glance\n--------------------------\n\n- Connection parameters for individual databases are kept in a configuration\n file in your home directory.\n- Databases can be assigned multiple logical names.\n- *sqlcmd* has command history management, with `GNU Readline`_ support.\n History files are saved per database.\n- *sqlcmd* supports SQL, but also supports database metadata (getting a list\n of tables, querying the table's columns and their data types, listing the\n indexes and foreign keys for a table, etc.).\n- *sqlcmd* supports Unix shell-style variables.\n- *sqlcmd* command has a ``.set`` command that displays and controls *sqlcmd*\n settings.\n- *sqlcmd* provides a standard interface that works the same no matter what\n database you're using.\n- *sqlcmd* uses the enhanced database drivers in the `Grizzled API`_'s ``db``\n module. (Those drivers are, in turn, built on top of standard Python\n DB API drivers like ``psycopg2`` and ``MySQLdb``.)\n- *sqlcmd* is written entirely in `Python`_, which makes it very portable\n (though the database drivers are often written in C and may not be available\n on all platforms).\n\n.. _Grizzled API: http://www.clapper.org/software/python/grizzled/\n.. _GNU Readline: http://cnswww.cns.cwru.edu/php/chet/readline/rluserman.html\n.. _Python: http://www.python.org/\n\nIn short, *sqlcmd* is a SQL command tool that attempts to provide the same\ninterface for all supported databases and across all platforms.", "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/bmc/sqlcmd/", "keywords": null, "license": "BSD-style license", "maintainer": null, "maintainer_email": null, "name": "sqlcmd", "package_url": "https://pypi.org/project/sqlcmd/", "platform": "UNKNOWN", "project_url": "https://pypi.org/project/sqlcmd/", "project_urls": { "Download": "UNKNOWN", "Homepage": "https://github.com/bmc/sqlcmd/" }, "release_url": "https://pypi.org/project/sqlcmd/0.7.1/", "requires_dist": null, "requires_python": null, "summary": "A cross-platform, cross-database SQL command line tool", "version": "0.7.1" }, "last_serial": 800011, "releases": { "0.4.1": [], "0.4.2": [], "0.5": [], "0.6": [], "0.7": [], "0.7.1": [ { "comment_text": "", "digests": { "md5": "3927a5de63335d0b88a1dba658008b46", "sha256": "c58c620bba462f150718053873f751060ab2f782a90052c382821c3eb0c4fc7b" }, "downloads": -1, "filename": "sqlcmd-0.7.1.zip", "has_sig": false, "md5_digest": "3927a5de63335d0b88a1dba658008b46", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 60898, "upload_time": "2011-03-15T04:12:03", "url": "https://files.pythonhosted.org/packages/d7/60/0b59ad68e360a78ff80807cb57072fbb01a3139bc974477aa42790f690fe/sqlcmd-0.7.1.zip" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "3927a5de63335d0b88a1dba658008b46", "sha256": "c58c620bba462f150718053873f751060ab2f782a90052c382821c3eb0c4fc7b" }, "downloads": -1, "filename": "sqlcmd-0.7.1.zip", "has_sig": false, "md5_digest": "3927a5de63335d0b88a1dba658008b46", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 60898, "upload_time": "2011-03-15T04:12:03", "url": "https://files.pythonhosted.org/packages/d7/60/0b59ad68e360a78ff80807cb57072fbb01a3139bc974477aa42790f690fe/sqlcmd-0.7.1.zip" } ] }