Changes between Version 23 and Version 24 of SqlQueryMacro
- Timestamp:
- Nov 14, 2019, 12:08:03 PM (4 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
SqlQueryMacro
v23 v24 2 2 3 3 = Execute an SQL Query from within Trac 4 5 {{{#!box warning6 **Notice:** This plugin is deprecated in favor of SqlAlchemyQueryMacro.7 }}}8 4 9 5 == Description … … 31 27 == Installation 32 28 33 This macro requires the [https://bitbucket.org/prologic/pymills pymills] library and it makes use of its '''db''' and '''table''' modules. Please install pymills first.34 35 {{{#!sh36 wget https://bitbucket.org/prologic/pymills/get/0d1424e1b0ab.zip37 unzip 0d1424e1b0ab.zip38 easy_install $PWD/prologic-pymills-0d1424e1b0ab39 }}}40 41 29 To install the macro: 42 30 43 31 {{{#!sh 44 easy_install TracSqlQueryMacro32 $ pip install TracSqlQueryMacro 45 33 }}} 46 34 … … 53 41 54 42 == Configuration 43 44 Configuration is only needed for the 0.11 branch of the plugin. 55 45 56 46 To configure this plugin, you must tell SQLQuery what database to connect to. … … 82 72 83 73 {{{ 84 {{{ 85 #!SQL 86 SELECT * FROM foo 74 {{{#!SQL 75 SELECT * FROM component 87 76 }}} 88 77 }}} … … 91 80 92 81 {{{ 93 [[SQL(SELECT * FROM foo)]]82 [[SQL(SELECT * FROM component)]] 94 83 }}} 95 84