Version 15 (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. The macro uses SQLAlchemy, the Python SQL toolkit and Object Relational Mapper that gives application developers the full power and flexibility of SQL.
A previous version of this module is known as SqlQueryMacro.
See also: TracSqlAlchemyBridgeIntegration
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.
SqlAlchemyQueryMacro comes with sortable tables using the sorttable library, written in Javascript.
Example
This macro can be used in one of two ways:
{{{ #!SQL SELECT * FROM foo }}}
or:
[[SQL(SELECT * FROM foo)]]
Installation
General instructions on installing Trac plugins can be found on the TracPlugins page.
This macro requires the pypi:python-sqlalchemy library and makes use of its database and table modules. Please install python-sqlalchemy first.
After getting the source you will have to edit install_sqlalchemyquery.bash
to your needs, you can change:
TRAC_PATH_REPLACE="/path/to/your-trac-environment" # absolute path to your trac environment TRAC_REPLACE="your_trac_environment" # name of your trac environment ( relative path without slashes ) MAX_ROW_COUNT_REPLACE="1000" # maximum numbers of rows for the query result to display TABLE_BORDER_REPLACE="border=\"1\"" # set the border with of the table
To install the macro:
tar -zxvf SqlAlchemyQuery.tar.gz
cd SqlAlchemyQuery
--- edit install_sqlalchemyquery.bash ---
./install_sqlalchemyquery.bash
or with svn:
svn checkout http://trac-hacks.org/svn/sqlalchemyquerymacro
cd sqlalchemyquerymacro/1.0/
--- edit install_sqlalchemyquery.bash ---
./install_sqlalchemyquery.bash
To enable this plugin add the following to trac.ini
:
[components] sqlalchemyquery.* = enabled
Configuration
To configure this plugin, you must tell SqlAlchemy 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
Restart tracd after making these changes.
Recent Changes