Execute an SQL Query from within Trac

Notice: This plugin is unmaintained and available for adoption.

Description

This plugin allows you to execute an SQL Query against a configured database displaying a formatted table of results from within Trac.

See also:

• SqlAlchemyQueryMacro: a plugin that supersedes SqlQuery.
• WikiTableMacro: 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.

Installation

To install the macro:

$ pip install TracSqlQueryMacro

To enable in your trac.ini file:

[components]
sqlquery.* = enabled

Configuration

Configuration is only needed for the 0.11 branch of the plugin.

To configure this plugin, you must tell SQLQuery what database to connect to.

In trac.ini or via the WebAdmin menu:

[sqlquery]
uri = mysql://user:password@hostname/database

You can also use Oracle or SQLite:

[sqlquery]
uri = oracle://user:password@tns

or:

[sqlquery]
uri = sqlite:///path/to/db

Example

This macro can be used in one of two ways:

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

or:

[[SQL(SELECT * FROM component)]]

Recent Changes

18071 by rjollos on 2021-03-16 22:34:36

TracSqlQueryMacro 0.3dev: Remove pymills dependency

Patch by Jun Omae.

Fixes #12023.

17555 by rjollos on 2019-11-15 15:28:06

TracSqlQueryMacro 0.2: Fix incorrectly chained methods

Refs #13646.

17554 by rjollos on 2019-11-14 12:17:52

TracSqlQueryMacro 0.2: Use Trac's database API when querying Trac database

Refs #13646.

(more)

Author/Contributors

Author: JamesMills
Maintainer: none (needsadoption)
Contributors: