Version 5 (modified by 10 years ago) (diff) | ,
---|
Execute an SQL Query
Table of Contents
Description
Execute an SQL Query against a configured database displaying a formatter table of results.
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)]]
Install
This macro requires the pymills library and makes use of it's db and table modules. Please install pymills first.
easy_install pymills
To install the macro:
easy_install TracSqlQueryMacro
To enable:
[components] sqlquery.* = enabled
Configure
To configure this plugin, you must tell sqlquery what database to connect to:
In trac.ini
(or via the Web Admin):
[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
- 14239 by rjollos on 2014-11-04 12:21:22
-
Import of
Connection
fails, at least in the most recent version of pymills. Refs #12023.
Patch by paresh138@….
- 14238 by rjollos on 2014-11-04 12:21:18
-
Added
pymills
to installation requirements.
- 14237 by rjollos on 2014-11-04 12:21:15
-
Removed unused
ITemplateProvider
implementation.
(more)
Author/Contributors
Author: JamesMills
Contributors: