Changes between Version 18 and Version 19 of SqlQueryMacro


Ignore:
Timestamp:
Mar 7, 2015, 1:24:34 PM (9 years ago)
Author:
figaro
Comment:

Added superseded message, tagged with license

Legend:

Unmodified
Added
Removed
Modified
  • SqlQueryMacro

    v18 v19  
    11[[PageOutline(2-5,Contents,pullout)]]
    22
    3 = Execute an SQL Query =
    4 == Description ==
     3= Execute an SQL Query
     4== Description
     5
    56Execute an SQL Query against a configured database displaying a formatted table of results.
    67
    7 See also WikiTableMacro for a simpler implementation, which does not allow to define a datasource.
     8See also:
     9 * SqlAlchemyQueryMacro: a plugin that supersedes !SqlQuery.
     10 * WikiTableMacro: a simpler implementation, which does not allow to define a datasource.
    811
    9 == Bugs/Feature Requests ==
     12== Bugs/Feature Requests
     13
    1014Existing bugs and feature requests for SqlQueryMacro are  [report:9?COMPONENT=SqlQueryMacro here].
    1115
    1216If you have any issues, create a  [http://trac-hacks.org/newticket?component=SqlQueryMacro&owner=JamesMills new ticket].
    1317
    14 == Download ==
     18== Download
     19
    1520Download the zipped source from [download:sqlquerymacro here].
    1621
    17 == Source ==
     22== Source
     23
    1824You can check out SqlQueryMacro from [http://trac-hacks.org/svn/sqlquerymacro here] using Subversion, or [source:sqlquerymacro browse the source] with Trac.
    1925
    20 == Example ==
     26== Example
     27
    2128This macro can be used in one of two ways:
    2229
     
    2734}}}
    2835}}}
    29 or
     36
     37or:
    3038
    3139{{{
    3240[[SQL(SELECT * FROM foo)]]
    3341}}}
    34 == Install ==
     42
     43== Installation
     44
    3545This macro requires the [https://bitbucket.org/prologic/pymills pymills] library and makes use of its '''db''' and '''table''' modules. Please install pymills first.
    3646
     
    4151easy_install $PWD/prologic-pymills-0d1424e1b0ab
    4252}}}
     53
    4354To install the macro:
    4455
     
    4758easy_install TracSqlQueryMacro
    4859}}}
    49 To enable:
     60
     61To enable in `trac.ini`:
    5062
    5163{{{
     
    5466sqlquery.* = enabled
    5567}}}
    56 == Configure ==
     68
     69== Configuration
     70
    5771To configure this plugin, you must tell sqlquery what database to connect to:
    5872
    59 In `trac.ini` (''or via the Web Admin''):
     73In `trac.ini` or via the WebAdmin menu:
    6074
    6175{{{
     
    6478uri = mysql://user:password@hostname/database
    6579}}}
    66 You can also use oracle or sqlite:
     80
     81You can also use Oracle or SQLite:
    6782
    6883{{{
    6984#!ini
    7085uri = oracle://user:password@tns
    71 or
     86}}}
     87
     88or:
     89
     90{{{
     91#!ini
    7292uri = sqlite:///path/to/db
    7393}}}
    74 == Feedback ==
     94
     95== Feedback
     96
    7597Please give your feedback (''anything that shouldn't be a ticket'') [wiki:SqlQueryMacro/Feedback here]
    7698
    77 == Recent Changes ==
     99== Recent Changes
     100
    78101[[ChangeLog(sqlquerymacro, 3)]]
    79102
    80 == Author/Contributors ==
    81 '''Author:''' JamesMills [[BR]] '''Maintainer:''' JamesMills [[BR]] '''Contributors:'''
     103== Author/Contributors
     104
     105'''Author:''' JamesMills [[BR]]
     106'''Maintainer:''' [[Maintainer]] [[BR]]
     107'''Contributors:'''