Changes between Version 15 and Version 16 of SqlQueryMacro


Ignore:
Timestamp:
Feb 12, 2013, 3:17:37 AM (11 years ago)
Author:
anonymous
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • SqlQueryMacro

    v15 v16  
    11[[PageOutline(2-5,Contents,pullout)]]
     2
    23= Execute an SQL Query =
    3 
    44== Description ==
    5 
    6 Execute an SQL Query against a configured database displaying a formatted table
    7 of results.
     5Execute an SQL Query against a configured database displaying a formatted table of results.
    86
    97See also WikiTableMacro for a simpler implementation, which does not allow to define a datasource.
    108
    11 == Bugs/Feature Requests ==
     9== Bugs/Feature Requests ==
     10Existing bugs and feature requests for SqlQueryMacro are  [report:9?COMPONENT=SqlQueryMacro here].
    1211
    13 Existing bugs and feature requests for SqlQueryMacro are
    14 [report:9?COMPONENT=SqlQueryMacro here].
    15 
    16 If you have any issues, create a
    17 [http://trac-hacks.org/newticket?component=SqlQueryMacro&owner=JamesMills new ticket].
     12If you have any issues, create a  [http://trac-hacks.org/newticket?component=SqlQueryMacro&owner=JamesMills new ticket].
    1813
    1914== Download ==
    20 
    2115Download the zipped source from [download:sqlquerymacro here].
    2216
    2317== Source ==
    24 
    2518You can check out SqlQueryMacro from [http://trac-hacks.org/svn/sqlquerymacro here] using Subversion, or [source:sqlquerymacro browse the source] with Trac.
    2619
    2720== Example ==
     21This macro can be used in one of two ways:
    2822
    29 This macro can be used in one of two ways:
    3023{{{
    3124{{{
    … …  
    3427}}}
    3528}}}
    36 
    3729or
    3830
    … …  
    4032[[SQL(SELECT * FROM foo)]]
    4133}}}
     34== Install ==
     35This macro requires the [https://bitbucket.org/prologic/pymills pymills] library and makes use of its '''db''' and '''table''' modules. Please install pymills first.
    4236
    43 == Install ==
     37{{{
     38#!sh
     39wget https://bitbucket.org/prologic/pymills/get/0d1424e1b0ab.zip
     40unzip 0d1424e1b0ab.zip
     41easy_install $PWD/prologic-pymills-0d1424e1b0ab
     42}}}
     43To install the macro:
    4444
    45 This macro requires the [http://trac.shortcircuit.net.au/ pymills] library and makes use of its '''db''' and '''table''' modules.
    46 Please install pymills first.
    47 {{{
    48 easy_install pymills
    49 }}}
    50 
    51 To install the macro:
    5245{{{
    5346easy_install TracSqlQueryMacro
    5447}}}
     48To enable:
    5549
    56 To enable:
    5750{{{
    5851#!ini
    … …  
    6053sqlquery.* = enabled
    6154}}}
    62 
    6355== Configure ==
    6456To configure this plugin, you must tell sqlquery what database to connect to:
    6557
    66 In {{{trac.ini}}} (''or via the Web Admin''):
     58In `trac.ini` (''or via the Web Admin''):
    6759
    6860{{{
    … …  
    7062uri = mysql://user:password@hostname/database
    7163}}}
     64You can also use oracle or sqlite:
    7265
    73 You can also use oracle or sqlite:
    7466{{{
    75 uri = oracle://user:password@tns:/
     67uri = oracle://user:password@tns
    7668or
    7769uri = sqlite:///path/to/db
    7870}}}
    79 
    8071== Feedback ==
    81 
    8272Please give your feedback (''anything that shouldn't be a ticket'') [wiki:SqlQueryMacro/Feedback here]
    8373
    8474== Recent Changes ==
    85 
    8675[[ChangeLog(sqlquerymacro, 3)]]
    8776
    8877== Author/Contributors ==
    89 
    90 '''Author:''' [wiki:JamesMills] [[BR]]
    91 '''Maintainer:''' [wiki:JamesMills] [[BR]]
    92 '''Contributors:'''
     78'''Author:''' JamesMills [[BR]] '''Maintainer:''' JamesMills [[BR]] '''Contributors:'''