Execute an SQL Query

Description

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

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

Bugs/Feature Requests

Existing bugs and feature requests for SqlQueryMacro are here.

If you have any issues, create a new ticket.

Download

Download the zipped source from here.

Source

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

Example

This macro can be used in one of two ways:

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

or

[[SQL(SELECT * FROM foo)]]

Install

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

wget https://bitbucket.org/prologic/pymills/get/0d1424e1b0ab.zip
unzip 0d1424e1b0ab.zip
easy_install $PWD/prologic-pymills-0d1424e1b0ab

To install the macro:

easy_install TracSqlQueryMacro

To enable:

[components]
sqlquery.* = enabled

Configure

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

Feedback

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

Recent Changes

[8485] by rjollos on 08/28/10 05:55:46

There is no htdocs dir, so the ITemplateProvider method should return nothing. Fixes #2698.

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

Alpha

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

New hack SqlQueryMacro, created by JamesMills

Author/Contributors

Author: JamesMills
Maintainer: JamesMills
Contributors: