Version 2 (modified by 9 years ago) (diff) | ,
---|
Contents
Execute an SQL query
Description
Execute an SQL Query against a configured database displaying a formatted table of results.
Bugs/Feature Requests
Existing bugs and feature requests for SqlAlchemyQueryMacro are here.
If you have any issues, create a new ticket.
Download
Download the zipped source from here.
Source
You can check out SqlAlchemyQueryMacro from here using Subversion, or browse the source with Trac.
Installation
General instructions on installing Trac plugins can be found on the TracPlugins page.
his macro requires the python-sqlalchemy library and makes use of its db and table modules. Please install python-sqlalchemy first.
To install the macro:
tar -zxvf SqlAlchemyQuery.tar.gz cd SqlAlchemyQuery ./install_sqlalchemyquery.bash
To enable:
[components] sqlalchemyquery.* = enabled
Configure
To configure this plugin, you must tell sqlquery what database to connect to:
In trac.ini :
[sqlalchemyquery] uri = mysql://user:password@hostname/database
You can also use oracle or sqlite:
uri = oracle://user:password@tns or uri = sqlite:///path/to/db
Recent Changes