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.


> Guillaume
> On Mon, Jul 2, 2012 at 7:55 AM, Vincent Massol <vinc...@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
users mailing list

Reply via email to