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