Execute an SQL Query

Notice: This plugin is unmaintained and available for adoption.

Description

Execute an SQL Query against a configured database displaying a formatted table of results.

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 [download:sqlquerymacro here].

Source

You can check out SqlQueryMacro from ​here using Subversion, or browse the source​ with Trac.

Example

This macro can be used in one of two ways:

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

or:

[[SQL(SELECT * FROM foo)]]

Installation

This macro requires the ​pymills library and makes use of its db and table modules. Please install pymills first.

wget https://bitbucket.org/prologic/pymills/get/0d1424e1b0ab.zip
unzip 0d1424e1b0ab.zip
easy_install $PWD/prologic-pymills-0d1424e1b0ab

To install the macro:

easy_install TracSqlQueryMacro

To enable in trac.ini:

[components]
sqlquery.* = enabled

Configuration

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:

uri = oracle://user:password@tns

or:

uri = sqlite:///path/to/db

Feedback

Please give your feedback (anything that shouldn't be a ticket) here?

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: