Changes between Version 10 and Version 11 of SqlAlchemyQueryMacro
- Timestamp:
- Feb 28, 2015, 11:00:18 PM (9 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
SqlAlchemyQueryMacro
v10 v11 23 23 You can check out SqlAlchemyQueryMacro from [http://trac-hacks.org/svn/sqlalchemyquerymacro here] using Subversion, or [source:sqlalchemyquerymacro browse the source] with Trac. 24 24 25 SqlAlchemyQueryMacro comes with sortable tables using http://www.kryogenix.org/code/browser/sorttable/25 SqlAlchemyQueryMacro comes with sortable tables using the [http://www.kryogenix.org/code/browser/sorttable/ sorttable] library. 26 26 27 27 == Example … … 47 47 his macro requires the python-sqlalchemy library and makes use of its db and table modules. Please install python-sqlalchemy first. 48 48 After getting the source you will have to edit {{{ install_sqlalchemyquery.bash }}} to your needs, you can change: 49 {{{ 49 {{{#!ini 50 50 TRAC_PATH_REPLACE="/path/to/your-trac-environment" # absolute path to your trac environment 51 51 TRAC_REPLACE="your_trac_environment" # name of your trac environment ( relative path without slashes ) … … 55 55 56 56 To install the macro: 57 {{{ 57 {{{#!sh 58 58 tar -zxvf SqlAlchemyQuery.tar.gz 59 59 cd SqlAlchemyQuery … … 65 65 or with svn: 66 66 67 {{{ 67 {{{#!sh 68 68 svn checkout http://trac-hacks.org/svn/sqlalchemyquerymacro 69 69 cd sqlalchemyquerymacro/1.0/ … … 74 74 75 75 To enable, in trac.ini: 76 {{{ 76 {{{#!ini 77 77 [components] 78 78 sqlalchemyquery.* = enabled … … 85 85 In trac.ini : 86 86 87 {{{ 87 {{{#!ini 88 88 [sqlalchemyquery] 89 89 uri = mysql://user:password@hostname/database 90 90 }}} 91 91 You can also use oracle or sqlite: 92 {{{ 92 {{{#!ini 93 93 uri = oracle://user:password@tns 94 }}} 94 95 or 96 {{{#!ini 95 97 uri = sqlite:///path/to/db 96 98 }}}