Contents
SQL Table in Wiki Page
Description
This is a simple macro that enables you to place tables resulting from SQL queries into a wiki page.
It is similar to, but simpler than, SqlQueryMacro. The main differences are that it has fewer dependencies and always queries the Trac database, rather than letting you set up a separate data connection.
Bugs/Feature Requests
Existing bugs and feature requests for WikiTableMacro are here.
If you have any issues, create a new ticket.
Download
Download the zipped source from here.
Source
You can check out WikiTableMacro from here using Subversion, or browse the source with Trac.
Example
Use the SQLTable macro:
{{{
#!SQLTable
SELECT count(id) as 'Number of Tickets'
FROM ticket
}}}
The result will be a table.
Use the SQLScalar macro:
{{{
#!SQLScalar
SELECT count(id) as 'Number of Tickets'
FROM ticket
}}}
The result will be a single number.
Recent Changes
[7526] by rjollos on 02/09/10 08:39:04
Add repository URL to setup.py. Fixes #6462
[7523] by rjollos on 02/09/10 08:08:16
Add new maintainer to setup.py. Fixes #6594.
[4687] by optilude on 10/31/08 18:34:21
Add support for scalars
[4671] by optilude on 10/30/08 14:46:33
Good bye world
