Hi Kris, It depends on what you want. Using some SQL formatter or other 3rd party block parser you can get data from the database. But you'll end up setting up connections from 'within pages'. It's hard to limit for the current user since you'd have to write custom macros. So ACL is a bit tougher to set up.
To resolve this issue, I built a python script to read information from the database and push it into a template (maintained in the wiki, fetched using xmlrpc), and push the result back it into the wiki using xmlrpc. After an initial load (in my case, around 7k pages) I now only check for a few that might have changed. If so, a new version is added (Moin does this atomically. New pages are simply added and moin will notice pages not having changed and drop the useless update. This saves me from having to do that bookkeeping. Now I have round and about 7.5k pages that are 'maintained' automatically using this script, which runs every 21 minutes and new pages being edited. The template is maintained in the wiki (patching only the relatively new pages and not all 7.5k pages over again) and in the template I set the ACL's required. Hope this helps, Regards, Remco Boerma drenthecollege.nl -----Oorspronkelijk bericht----- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens R.Bauer Verzonden: zaterdag 26 april 2008 22:33 Aan: [email protected] Onderwerp: Re: [Moin-user] moinmoin and mysql KrisR schrieb: > Hi, > is there any way to put data from mysql database to wiki page? > I'd like to use moinmoin login to limit access to some tables. > > kris Hi kris may be the answer is totally wrong. Sorry for that But you can do setup restrictions to pages by using acls on the page see HelpOnAccessControlLists And there are some macros on the MacroMarket for sql access cheers Reimar ------------------------------------------------------------------------ - This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Don't miss this year's exciting event. There's still time to save $100. Use priority code J8TL2D2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/j avaone _______________________________________________ Moin-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/moin-user ------------------------------------------------------------------------- This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Don't miss this year's exciting event. There's still time to save $100. Use priority code J8TL2D2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone _______________________________________________ Moin-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/moin-user
