MySQL-Processor

Purpose

Manage datacontent with MoinMoinWiki-Engine and MySQL-Database.

Install

To run fine you need an MySQL-Database(-Demon) running. This database contains the tabledata which is requiered by this processor.

Example content of moindb

CREATE TABLE mointable(
        id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
        firstname CHAR(20) NOT NULL,
        name CHAR(20) NOT NULL,
        mail CHAR(40) NOT NULL,
        version char(10) NOT NULL,
        copyright char(40) NOT NULL,
        moinweb char(40) NOT NULL,
        PRIMARY KEY (id)
        );

INSERT INTO mointable VALUES (NULL,'Alexander','Fischer','mail@fischer-alexander.net','MySQL 1.0','Copyright Alexander Fischer','http://moinmoin.wikiwikiweb.de');

Which data for transfer is requiered ?

At first I recommend to activate the processor without any data. So you know what data this processor need.
Input:

Output:

How to manage this processor ?

Raw databasecontent

Input:

Output:

That takes what it should be, but it is not very nice. So I have some syntax for you to modify drawing.
You can make headlines, htmllink, wikilink, maillink or hide columns. For other requierments it is simple to modify this Pythoncode.

Modified databasecontent

Input:

Output:

That drawing of databasecontent is very nice and simple to manage.

Why processor and not macro?

I prefer programming this MySQL-Extension in reference to basis of the processor because in reference to basis of the macro is the analyzing of transfer attributes too complicated. I realized it first in macro but it was more complex and not usefull for normal user.

Discussion

This seems like a more powerful solution than my mysql macro I uploaded today to MacroMarket, but mine does have the advantage of being much simpler and easier to use if you have simple statements.

-- JohannesBerg 2004-10-05 20:07:04

Whoops, ok, I didn't read this page too thoroughly. Seems that my macro and this serve different purposes Especially WIKICOLUMN etc. sounds like a great idea!

-- JohannesBerg 2004-10-06 11:12:16