Changes between Version 15 and Version 16 of SqlQueryMacro


Ignore:
Timestamp:
Feb 12, 2013 4:17:37 AM (20 months 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:'''