{ "info": { "author": "Laurent Bachelier", "author_email": "laurent@bachelier.name", "bugtrack_url": null, "classifiers": [ "License :: OSI Approved :: MIT License", "Programming Language :: Python :: 2", "Programming Language :: Python :: 3" ], "description": "=========\ngreptable\n=========\n\n\nDescription\n-----------\n\n``greptable`` generates a plain-text list of your servers, databases and tables,\nso that you can easily find where the fuck that table is, with your favorite\nsearch tools, like ``grep``.\n\nThis is especially useful if you are dealing with many servers and databases.\n\n\nRequirements\n------------\n\n``greptable`` works on both Python 2 and Python 3.\n\nThe only dependency is ``SQLAlchemy``, and it should support the same databases.\n\n\nUsage\n-----\n\nFor global options run ``greptable -h``.\n\nAll commands need a configuration file; see the *Configuration* section below.\n\nListing tables\n~~~~~~~~~~~~~~\n\nTo list the tables, run ``greptable dump``.\n\nYou can change the configuration file path with the ``-c``\n(also known as ``--config``).\nBy default, it uses ``~/.config/greptable.conf`` if it exists,\notherwise ``greptable.conf`` from the current directory.\n\nThe tables are listed to the standard output by default.\nThe ``-o`` (also known as ``--output``) option can dump in a file instead.\n\nExample: ``greptable -c greptable.conf dump -o tables.txt``\n\nFor full help on options run ``greptable dump -h``.\n\nOpening tables\n~~~~~~~~~~~~~~\n\n``greptable`` lets you open a table or schema in your favorite admin interface,\nbuilt from a configured URL template.\n\nThis is thought for phpMyAdmin, but should work with other tools, even\nnon-web (if not, please provide examples or patches).\n\nUsing it is as simple as running ``greptable open`` followed\nby the selected output of a ``greptable dump``.\nYou can even do ``greptable open $(greptable dump|grep mytable)``.\n\nThe URL will be opened by ``xdg-open``. If it's not opening the wanted\nbrowser, you should set the ``BROWSER`` environment variable.\n\nIf you only want to show the URL, and not open it automatically, use the\n``-s`` (also known as ``--show``) option.\n\nConfiguration\n-------------\n\nThe configuration is a standard INI file.\nSection headers are `SQLAlchemy URLs `_.\n\nFor example::\n\n [mysql://user:password@server1]\n [sqlite:///db.sqlite]\n\n``greptable`` will try to prettify server URLs, but you can also force a name.\n\nFor example::\n\n [mysql://user:password@server1]\n [sqlite:///db.sqlite]\n name = db\n\nFor the ``open`` subcommand, you can provide both a ``openschema`` and ``opentable``\noption. If the ``openschema`` option is not provided, ``opentable`` will be used,\nwith the table parameter being an empty string.\n\nThe variable substitution uses the Python ``format()`` syntax.\n\nFor example::\n\n [mysql://user:password@server1]\n opentable = https://penguincorp.com/pma/index.php?server=0&db={schema}&table={table}\n\n [mysql://user:password@server2]\n opentable = https://penguincorp.com/pma/index.php?server=1&db={schema}&table={table}\n\n [otherdb://user:password@server]\n name = srv0\n openschema = https://penguincorp.com/otherdb/{server}/tables/{schema}\n opentable = https://penguincorp.com/otherdb/{server}/showtable/{schema}/{table}\n\n\nDevelopment\n-----------\n\nContributions can be sent in the form of git patches, to laurent@bachelier.name.", "description_content_type": null, "docs_url": null, "download_url": "UNKNOWN", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "http://git.p.engu.in/laurentb/greptable/", "keywords": null, "license": "UNKNOWN", "maintainer": null, "maintainer_email": null, "name": "greptable", "package_url": "https://pypi.org/project/greptable/", "platform": "UNKNOWN", "project_url": "https://pypi.org/project/greptable/", "project_urls": { "Download": "UNKNOWN", "Homepage": "http://git.p.engu.in/laurentb/greptable/" }, "release_url": "https://pypi.org/project/greptable/1.1.0/", "requires_dist": null, "requires_python": null, "summary": "List tables of SQL databases for easy schema greps", "version": "1.1.0" }, "last_serial": 1154981, "releases": { "1.0.0": [ { "comment_text": "", "digests": { "md5": "c0698dda49ce2d352a2bb5aede8490c7", "sha256": "79861801d521d42caf7ca96ed6af575fefff157f004a9e59e5ad18d152ec527d" }, "downloads": -1, "filename": "greptable-1.0.0.tar.gz", "has_sig": false, "md5_digest": "c0698dda49ce2d352a2bb5aede8490c7", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4395, "upload_time": "2014-07-08T22:19:31", "url": "https://files.pythonhosted.org/packages/f8/c7/92f364e8550a2ed27b6e55611d9f2cf68f2132dbf6bf99924b94a1794e5c/greptable-1.0.0.tar.gz" } ], "1.1.0": [ { "comment_text": "", "digests": { "md5": "a9ddd879bbc0d231d144a8ba28e1c733", "sha256": "5b6ba553e8ace3cbd5f934667566073fe81990da57bbc5d40cf3854a13c72567" }, "downloads": -1, "filename": "greptable-1.1.0.tar.gz", "has_sig": false, "md5_digest": "a9ddd879bbc0d231d144a8ba28e1c733", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5948, "upload_time": "2014-07-11T17:05:31", "url": "https://files.pythonhosted.org/packages/22/19/efc36c2f689b52a63c0e7044d90ee20f05df098c600211ea65073280cd25/greptable-1.1.0.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "a9ddd879bbc0d231d144a8ba28e1c733", "sha256": "5b6ba553e8ace3cbd5f934667566073fe81990da57bbc5d40cf3854a13c72567" }, "downloads": -1, "filename": "greptable-1.1.0.tar.gz", "has_sig": false, "md5_digest": "a9ddd879bbc0d231d144a8ba28e1c733", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5948, "upload_time": "2014-07-11T17:05:31", "url": "https://files.pythonhosted.org/packages/22/19/efc36c2f689b52a63c0e7044d90ee20f05df098c600211ea65073280cd25/greptable-1.1.0.tar.gz" } ] }