wiki:SqlAlchemyQueryMacro

Version 7 (modified by fvdberg, 9 years ago) (diff)

--

Execute an SQL query

Description

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

Bugs/Feature Requests

Existing bugs and feature requests for SqlAlchemyQueryMacro are here.

If you have any issues, create a new ticket.

Download

Download the zipped source from here.

Source

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

SqlAlchemyQueryMacro comes with sortable tables using http://www.kryogenix.org/code/browser/sorttable/

Installation

General instructions on installing Trac plugins can be found on the TracPlugins page.

his macro requires the python-sqlalchemy ​library and makes use of its db and table modules. Please install python-sqlalchemy first. After getting the source you will have to edit install_sqlalchemyquery.bash to your needs, you can change:

TRAC_PATH_REPLACE="/path/to/your-trac-environment" #absolute path to your trac environment
MAX_ROW_COUNT_REPLACE="1000"                       # maximum numbers of rows for the query result to display
TABLE_BORDER_REPLACE="border=\"1\""                # set the border with of the table 

To install the macro:

 tar -zxvf SqlAlchemyQuery.tar.gz
 cd SqlAlchemyQuery
--- edit install_sqlalchemyquery.bash ---
./install_sqlalchemyquery.bash

or with svn:

svn checkout http://trac-hacks.org/svn/sqlalchemyquerymacro
cd sqlalchemyquerymacro/1.0/
--- edit install_sqlalchemyquery.bash ---
./install_sqlalchemyquery.bash

To enable, in trac.ini:

[components]
sqlalchemyquery.* = enabled

Configure

To configure this plugin, you must tell sqlquery what database to connect to:

In trac.ini :

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

You can also use oracle or sqlite:

uri = oracle://user:password@tns
or
uri = sqlite:///path/to/db

Recent Changes

16394 by rjollos on 2017-03-25 09:20:58
Remove eggs
14472 by fvdberg on 2015-03-01 12:19:24
added license file
14469 by fvdberg on 2015-02-27 21:24:23
bugfix: use relative path for sorttable.js (2)
(more)

Author/Contributors

Author: fvdberg
Maintainer: fvdberg
Contributors: