{ "info": { "author": "John Benediktsson", "author_email": "mrjbq7@gmail.com", "bugtrack_url": null, "classifiers": [], "description": "# TracSQL\n\nThe TracSQL project is a plugin for the [trac](https://trac.edgewall.org/)\nproject management tool.\n\nA \"SQL\" tab is added to the Trac project. Inside this tab, the plugin\nsupports interacting with the project database.\n\nSome features include:\n\n* Perform queries on the project database\n* View results as raw or formatted (and hyper-linked) output\n* Export result set in CSV\n* Browse the database schema (including table and index information)\n\nThis plugin supports Trac installations with **SQLite**, **MySQL**, and\n**PostgreSQL** database backends (although your raw queries may need to be\nwritten differently according to which SQL database is being used).\n\n\n## Installation\n\nThe TracSQL plugin can be installed using standard:\n\n```\n$ pip install tracsql\n```\n\nOr, grab the sources and build using:\n\n```\n$ python setup.py install\n```\n\n## Configuration\n\nIt is configured in the ``trac.ini`` file by enabling and configuring:\n\n```ini\n[components]\ntracsql.* = enabled\n```\n\nThe ``TRAC_ADMIN`` permission is used to control access to the query pages.\n\nBy default, the TracSQL plugin connects to the project database. To use an\nexternal database, set the ``database`` parameter in the ``tracsql`` section\nof the ``trac.ini`` file to a valid database connection string:\n\n```ini\n[tracsql]\ndatabase = sqlite:db/external.db\n```\n\n# Examples\n\nSome screensots, showing a few of the features:\n\n![SQL Query](https://github.com/trac-hacks/tracsql/raw/master/docs/sql-query.png)\n\n![SQL Schema](https://github.com/trac-hacks/tracsql/raw/master/docs/sql-schema.png)", "description_content_type": null, "docs_url": null, "download_url": "http://github.com/trac-hacks/tracsql/zipball/master#egg=TracSQL-0.3", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "http://github.com/trac-hacks/tracsql", "keywords": "", "license": "", "maintainer": "", "maintainer_email": "", "name": "TracSQL", "package_url": "https://pypi.org/project/TracSQL/", "platform": "", "project_url": "https://pypi.org/project/TracSQL/", "project_urls": { "Download": "http://github.com/trac-hacks/tracsql/zipball/master#egg=TracSQL-0.3", "Homepage": "http://github.com/trac-hacks/tracsql" }, "release_url": "https://pypi.org/project/TracSQL/0.3.1/", "requires_dist": null, "requires_python": "", "summary": "A Trac plugin for querying the project database", "version": "0.3.1" }, "last_serial": 2612170, "releases": { "0.2": [], "0.3": [ { "comment_text": "", "digests": { "md5": "2d09ce8fe378a72cd1b09bb7108e31ed", "sha256": "b02c2cc5c77d745500ff5efb2987a94a231bcc9923af0c13e367a207bef10364" }, "downloads": -1, "filename": "TracSQL-0.3-py2-none-any.whl", "has_sig": false, "md5_digest": "2d09ce8fe378a72cd1b09bb7108e31ed", "packagetype": "bdist_wheel", "python_version": "py2", "requires_python": null, "size": 41736, "upload_time": "2017-01-11T15:21:35", "url": "https://files.pythonhosted.org/packages/a6/ab/8ae1a3c4b8c123b3fad1c0da3700d65362cb344d1c7b04b5da0afce3baf7/TracSQL-0.3-py2-none-any.whl" }, { "comment_text": "", "digests": { "md5": "74196270b0ba8749319c32eeaf2f8ee0", "sha256": "8adf12bb654e00ab4a6a0bc9dba6e7244f09d3568c9644d61a7516b955685ffd" }, "downloads": -1, "filename": "TracSQL-0.3.tar.gz", "has_sig": false, "md5_digest": "74196270b0ba8749319c32eeaf2f8ee0", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 6283, "upload_time": "2017-01-11T15:21:37", "url": "https://files.pythonhosted.org/packages/22/68/2a3c91b32f40a3161d2085dfe57ea14fb540263ee2a6c60eded657a198cb/TracSQL-0.3.tar.gz" } ], "0.3.1": [ { "comment_text": "", "digests": { "md5": "d53b83ac2c3bef5530067a65c89c5a60", "sha256": "ab8950203a8ccd626d4ff6bae678b24f936378067dc9018d9abbf71abfc822e6" }, "downloads": -1, "filename": "TracSQL-0.3.1.tar.gz", "has_sig": false, "md5_digest": "d53b83ac2c3bef5530067a65c89c5a60", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 6916, "upload_time": "2017-02-01T17:41:13", "url": "https://files.pythonhosted.org/packages/f7/6a/7a0dff79e4dbe97e8447b1a7406b7cd5b5151ed16f5b47c81cabc7d82b18/TracSQL-0.3.1.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "d53b83ac2c3bef5530067a65c89c5a60", "sha256": "ab8950203a8ccd626d4ff6bae678b24f936378067dc9018d9abbf71abfc822e6" }, "downloads": -1, "filename": "TracSQL-0.3.1.tar.gz", "has_sig": false, "md5_digest": "d53b83ac2c3bef5530067a65c89c5a60", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 6916, "upload_time": "2017-02-01T17:41:13", "url": "https://files.pythonhosted.org/packages/f7/6a/7a0dff79e4dbe97e8447b1a7406b7cd5b5151ed16f5b47c81cabc7d82b18/TracSQL-0.3.1.tar.gz" } ] }