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?

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.

There is also this plugin: http://xwikisql.gradsoft.ua/docs/XWikiSqlPluginGuide.html But I'm not sure whether it still works.

Guillaume On Mon, Jul 2, 2012 at 7:55 AM, Vincent Massol <vincent(a)massol.net> 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

Hmm, ExecuteSQL looks like it will only work on the wiki database. I was looking for something similar to XwikSqlPlugin - where it could generate wiki pages from our application database schemas. Then I found things like SchemaSpy and SQLFairy. It would be sweet if there was a plugin built around either of those technologies, but maybe I will have time to play with that later. For now, if there is nothing readily available or easily adapted, I think we will just have to rely on manual updates…

However it could be nice for someone to create a SQL Script Service and package it as an extension.