Version 22 (modified by 8 years ago) (diff) | ,
---|
Contents
Execute an SQL Query from within Trac
Notice: This plugin is unmaintained and available for adoption.
Notice: This plugin is deprecated in favor of SqlAlchemyQueryMacro.
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
This macro requires the pymills library and it 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 your trac.ini
file:
[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:
[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 foo }}}
or:
[[SQL(SELECT * FROM foo)]]
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: