Version 23 (modified by 4 years ago) (diff) | ,
---|
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.
Usage
Use the SQLTable macro:
{{{ #!SQLTable SELECT count(id) as "Number of Tickets" FROM ticket }}}
The result will be a table.
You can also use wiki markup in the table:
{{{ #!SQLTable SELECT '[milestone:' || name || ' ' || name || ']' as name, due, completed, description FROM milestone }}}
Use the SQLScalar macro:
{{{ #!SQLScalar SELECT count(id) as "Number of Tickets" FROM ticket }}}
The result will be a single number.
Installation
- Install globally with:
sudo easy_install https://trac-hacks.org/svn/wikitablemacro/trunk
- Enable the plugin by updating TracIni file (..../trac.ini) as follows:
[components] wikitable.* = enabled
- Restart web server on command line:
$ sudo /etc/init.d/apache2 restart
Bugs/Feature Requests
Existing bugs and feature requests for WikiTableMacro are here.
If you have any issues, create a new ticket.
Source & Download
You can check out WikiTableMacro from here using Subversion, or browse the source with Trac.
Download the zipped source from [download:wikitablemacro here].
Recent Changes
- 16994 by rjollos on 2017-11-20 00:43:24
-
WikiTableMacro 0.3: Release version 0.3
Fixes #13336.
- 16993 by rjollos on 2017-11-20 00:41:44
-
WikiTableMacro 0.3dev: Conform to PEP8
Refs #13336.
- 14734 by rjollos on 2015-06-22 22:53:59
-
0.3dev: Partial revert of [14524]. Refs #11708.
Reverts to
format_to_html
but adds CSS to shrink the cell margins.
(more)