Modify

Opened 7 years ago

Closed 6 years ago

#1455 closed enhancement (fixed)

Include SQL query in wiki pages

Reported by: mangocats@… Owned by:
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 7 years ago.
SqlQueryPlugin

Download all attachments as: .zip

Change History (5)

comment:1 Changed 7 years ago by burati@…

  • Component changed from Request-a-Hack to RevtreePlugin
  • Owner changed from anybody to eblot

I vote for it! An important feature to trac!

comment:2 Changed 7 years ago by anonymous

  • Component changed from RevtreePlugin to Request-a-Hack
  • Owner eblot deleted

Changed 7 years ago by anonymous

SqlQueryPlugin

comment:3 Changed 7 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 6 years ago by martin_s

  • Resolution set to fixed
  • Status changed from new to closed

Got implemented by JamesMills as SqlQueryMacro.

Add Comment

Modify Ticket

Action
as closed .
The resolution will be deleted. Next status will be 'reopened'.
Author


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

 
Note: See TracTickets for help on using tickets.