Overview

The Form macro displays forms based on database records. The records can be edited or deleted. New records can be inserted. The macro also supports sub forms, filters and table views. Currently connections to SQLite, ODBC, MySQL and Oracle DB connections are supported. Of course any database source accessible by ODBC is supported. Even connections to SQLite attachments are supported.

Usage

A form is defined by it's design which is build by moin markup and it's attributes which are specified on a dictionary page.

Form design

<<Form(Start)>>
|| Name       || <<Form(Text, Recipes/FormsDict..Name, 30)>>     ||
|| Category   || <<Form(Text, .Category, 30)>>                   ||
|| Servings   || <<Form(Text, .Servings, 4)>>                    ||
|| Energy     || <<Form(Text, .Energy, 4)>> Cal.                 ||
|| Time       || <<Form(Text, .Time, 4)>> minutes                ||
|| Difficulty || <<Form(Text, .Difficulty, 4)>>                  ||
|| Procedure  || <<Form(Textarea, .Procedure, 50, 8)>>           ||
||<-2><<Form(Hidden, .Id)>><<Form(Buttons)>><<Form(Navigation)>> ||
<<Form(End)>>

Form and connection attributes

= Database Connection =
 .type:: `sqlite`
 .file:: `attachment:Recipes.db`

= Form =
 .select:: `select * from Recipes order by Name`
 .update:: `update Recipes set Name=?, Category=?, Servings=?, Energy=?, Time=?, Difficulty=?, Procedure=? where Id=?`
 .update_parameters:: `.Name, .Category, .Servings, .Energy, .Time, .Difficulty, .Procedure, .Id`

 .insert:: `insert into Recipes(Name, Category, Servings, Energy, Time, Difficulty, Procedure) values(?, ?, ?, ?, ?, ?, ?)`
 .insert_parameters:: `.Name, .Category, .Servings, .Energy, .Time, .Difficulty, .Procedure`

 .delete:: `delete from Recipes where Id=?`
 .delete_parameters:: `.Id`

This example displays the following editable form:

For a quick introduction on using the Form macro, see /Help/Tutorial. For a detailed explanation see /Help/Reference.

Setup

Requirements

The Form macro is compatible with Moin 1.6/1.7/1.8/1.9 (RudolfReuter).

For SQLite connections

With Python 2.5 no additional components are needed. With Python 2.4 however you have to make some adjustments. These are described in /Bugs/IndexUndefined (currently only in german language).

For ODBC connections

Install pyodbc library (http://code.google.com/p/pyodbc/)

For MySQL connections

Install MySql for Python (http://sourceforge.net/projects/mysql-python)

For Oracle connections

The prerequisites for Oracle database connections should be the same as for the MacroMarket/SQL macro. I'm not able to verify this.

There is however a change to this: The ORACLE_HOME environment path is not set by the macro code any more. It should be set in your operating system.

Download

Review the /ReleaseNotes. Download the current version (Form-0.8alpha.py).
For moin 1.7/1.8 you need (Form-0.9alpha.py) and Python Version >=2.5 (2008-12-25 RudolfReuter).
For moin1.8/1.9 (Linux) you need (Form-0.11alpha.py) (2010-01-29 RudolfReuter)
For moin 1.9.7 you need (Form-0.12alpha.py) from TestTest. (2014-06-12 RudolfReuter)

Install

Rename the file toForm.py and copy it to your /data/plugin/macro directory.

Configure

The following configuration options can be set in the wikiconfig.py:

Development

Feedback

Please use the sub pages /Bugs to report bugs, /Questions to post questions and /FeatureRequests to post feature requests. Other feedback can be posted here.

• Hello Wolfgang: Let me say a simple WOW
  That's what i'm lookin' for since some years, unable to programming it by myself.
  And: Thank you ...

  • -- KlausHeinisch 2008-02-04 11:40:00

• I could not use the Form macro with MoinMoin 1.8rc1. The GUI editor (in text mode) keeps messing up the code.

  • -- GurkPeter 2008-10-07 13:23:00

• I have tested the Form macro ver.0.9 in MoinMoin 1.8.1, and seen no obvious problem with the Textmode editor.

  • -- RudolfReuter 2008-12-25 14:02:20

• I have tested the Form macro ver.0.12alpha in MoinMoin 1.9.7, and Thanks to user TestTest, it works again, see the live example.

  • -- RudolfReuter 2014-06-12 10:41:58