Changes between Version 23 and Version 24 of SqlQueryMacro


Ignore:
Timestamp:
Nov 14, 2019, 12:08:03 PM (4 years ago)
Author:
Ryan J Ollos
Comment:

Update for Trac 1.0

Legend:

Unmodified
Added
Removed
Modified
  • SqlQueryMacro

    v23 v24  
    22
    33= Execute an SQL Query from within Trac
    4 
    5 {{{#!box warning
    6 **Notice:** This plugin is deprecated in favor of SqlAlchemyQueryMacro.
    7 }}}
    84
    95== Description
     
    3127== Installation
    3228
    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 {{{#!sh
    36 wget https://bitbucket.org/prologic/pymills/get/0d1424e1b0ab.zip
    37 unzip 0d1424e1b0ab.zip
    38 easy_install $PWD/prologic-pymills-0d1424e1b0ab
    39 }}}
    40 
    4129To install the macro:
    4230
    4331{{{#!sh
    44 easy_install TracSqlQueryMacro
     32$ pip install TracSqlQueryMacro
    4533}}}
    4634
     
    5341
    5442== Configuration
     43
     44Configuration is only needed for the 0.11 branch of the plugin.
    5545
    5646To configure this plugin, you must tell SQLQuery what database to connect to.
     
    8272
    8373{{{
    84 {{{
    85 #!SQL
    86 SELECT * FROM foo
     74{{{#!SQL
     75SELECT * FROM component
    8776}}}
    8877}}}
     
    9180
    9281{{{
    93 [[SQL(SELECT * FROM foo)]]
     82[[SQL(SELECT * FROM component)]]
    9483}}}
    9584