Modify

Opened 11 years ago

Closed 9 years ago

#1455 closed enhancement (fixed)

Include SQL query in wiki pages

Reported by: Mango Cat Owned by: anonymous
Priority: normal Component: Request-a-Hack
Severity: major Keywords: SQL wiki include
Cc: Trac Release: 0.10

Description

I would like the ability to generate tables within my wiki pages which are populated by SQL query results. I have several pages that "speak" about the same database, but each would like its own "view" of the data, and of course to be centrally maintained and automatically updated when the central database changes.

Attachments (1)

sqlqueryplugin.tar.gz (3.6 KB) - added by anonymous 10 years ago.
SqlQueryPlugin

Download all attachments as: .zip

Change History (5)

comment:1 Changed 10 years ago by burati@…

Component: Request-a-HackRevtreePlugin
Owner: changed from anybody to Emmanuel Blot

I vote for it! An important feature to trac!

comment:2 Changed 10 years ago by anonymous

Component: RevtreePluginRequest-a-Hack
Owner: changed from Emmanuel Blot to anonymous

Changed 10 years ago by anonymous

Attachment: sqlqueryplugin.tar.gz added

SqlQueryPlugin

comment:3 Changed 10 years ago by anonymous

Hi all,

I've attached a simple plugin I wrote that we use at work to perform SQL Queries against a configured database. This makes use of my pymills library (install it from pypi). Feel free to use/modify this to suit your needs.

If anyone is interested, I'll make a more complete hack for this.

--JamesMills

comment:4 Changed 9 years ago by Martin Scharrer

Resolution: fixed
Status: newclosed

Got implemented by JamesMills as SqlQueryMacro.

Modify Ticket

Change Properties
Set your email in Preferences
Action
as closed The owner will remain anonymous.
The resolution will be deleted.

Add Comment


E-mail address and name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.