On Jul 2, 2012, at 11:15 AM, Guillaume Lerouge wrote: > There is also this plugin: > > http://xwikisql.gradsoft.ua/docs/XWikiSqlPluginGuide.html > > But I'm not sure whether it still works.
Note that I didn't mention it voluntarily because it's using deprecated technology so I don't think it's a good idea to use it. However it could be nice for someone to create a SQL Script Service and package it as an extension. It's really simple to do. Thanks -Vincent > > Guillaume > > On Mon, Jul 2, 2012 at 7:55 AM, Vincent Massol <[email protected]> wrote: > >> Hi Matt, >> >> On Jul 2, 2012, at 1:30 AM, Matt Lamoureux wrote: >> >>> Hi all, >>> I'm just starting to use Xwiki, having been the admin for my company's >>> JSPwiki installation for a few years now. In that one, we had a very >>> useful part of the wiki which was an online database schema for our >>> databases. You see a list of the tables, which you can click on and see >>> the list of fields in that table, which you can click on and see the >>> information regarding that field. Our method was to take a DDL and run >> it >>> through a script which parsed it out into files that JSPwiki could read. >>> This way, we could take updated DDL's, run those through the script, and >>> keep updating the table list and table info pages, while leaving the >> field >>> named pages untouched. >>> Assuming I have described that correctly, does anyone have any >> solutions >>> that would be similar to this in Xwiki? Something that doesn't involve >>> manually updating the table list and table info pages? >> >> That would be great. The info we have at >> http://platform.xwiki.org/xwiki/bin/view/DevGuide/DatabaseSchema is a bit >> too static indeed. >> >>> I was thinking we >>> could modify the script to spit out something that we could the import >> into >>> Xwiki, but I'm not sure if that is the best approach. I was hoping there >>> was a plugin that let you connect to a database and run real-time queries >>> and then us a macro to wiki-fy the results, but I didn't find anything >> like >>> that. >> >> Here's an example: >> http://extensions.xwiki.org/xwiki/bin/view/Extension/Execute+SQL >> >> Thanks >> -Vincent _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
