wiki:WikiTableMacro

Version 7 (modified by Ryan J Ollos, 13 years ago) (diff)

New tickets assigned to new maintainer

SQL Table in Wiki Page

Notice: This plugin is unmaintained and available for adoption.

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 [download:wikitablemacro 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

18458 by rjollos on 2021-12-14 15:55:25
WikiTableMacro 0.3dev: Make exception handling Py3 compatible

Refs #14101.

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.

(more)

Author/Contributors

Author: optilude
Maintainer: rjollos
Contributors: