Wiki Navigation

Execute an SQL Query

Execute an SQL Query against a configured database displaying a formatted table of results.

See als WikiTableMacro for a simpler implementation, which does not allow to define a datasource.

Existing bugs and feature requests for SqlQueryMacro are here.

If you have any issues, create a new ticket.

Download the zipped source from here.

You can check out SqlQueryMacro from here using Subversion, or browse the source with Trac.

This macro can be used in one of two ways:

{{{
#!SQL
SELECT * FROM foo
}}}

[[SQL(SELECT * FROm foo)]]

This macro requires the pymills library and makes use of it's db and table modules. Please install pymills first.

easy_install pymills

To install the macro:

easy_install TracSqlQueryMacro

To enable:

[components]
sqlquery.* = enabled

To configure this plugin, you must tell sqlquery what database to connect to:

In trac.ini (or via the Web Admin):

[sqlquery]
uri = mysql://user:password@hostname/database

You can also use oracle or sqlite:

uri = oracle://user:password@tns:/
or
uri = sqlite:///path/to/db

Please give your feedback (anything that shouldn't be a ticket) here

[3263] by JamesMills on 02/22/08 09:52:27

Alpha

[3262] by JamesMills on 02/22/08 00:34:13

Author: JamesMills
Contributors: