wiki:WikiTableMacro

Version 15 (modified by Ryan J Ollos, 5 years ago) (diff)

The known issue was fixed in [12456].

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.

Use the SQLScalar macro:

    {{{
    #!SQLScalar
        SELECT count(id) as 'Number of Tickets'
        FROM ticket
    }}}

The result will be a single number.

Installation

  1. Install globally with:
      sudo easy_install https://trac-hacks.org/svn/wikitablemacro/0.11/
    
  2. Enable the plugin by updating TracIni file (..../trac.ini) as follows:
      [components]
      wikitable.* = enabled
    
  3. 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)

Author/Contributors

Author: optilude
Maintainer: rjollos
Contributors:


Some Patches

I added below to render_macro to provide a rudimentary sort of variable function.

    def render_macro(self, req, name, content):
+        c = content.split("|;|")
+        content = c[0]
+        if len(c) > 1 :
+                for i in c[1:] :
+                        v = i.split("=")
+                        if len(v) > 1 :
+                                k = v[0]
+                                v = v[1]
+                                content = content.replace(k,v)

i.e. you can do something like this

    {{{
    #!SQLTable
        SELECT "a", count($id) as 'Number of Tickets' 
        FROM ticket
        UNION
        SELECT "b", count($id) as 'Number of Tickets' 
        FROM ticket|;|$id=id
    }}}

Useful when you have the same id that you don't want to keep on retyping over.