The SQLForm asset allows you to dynamically create data input and storage functionality in your site. All data is put in a table of your choice in a database of your choice. An arbitrary form element can be tied to each field and input forms can be built in diffrent ways to ensure optimal adaptability to your needs.
The SQLForm features creation of new tables, import of existing tables and re-importing previously imported tables. Fields can be linked to other fields in other tables in serveral ways, making it possible to dynamically resolve id's to values using joins, add constraints to inputted data or connect different SQLForms together.
User input can also be checked against regular expressions and manual constraints that are definable by you. In addition it's possible to add an autoincrement flag and macros to fields, among other functionality.
All inputted data is versioned and a two level (delete/purge) trash is build in. Three privilege layers are available to split access to different actions.
Requirements:
Installation instructions:
Unpack the file in the docs directory of your webgui installation:
cd <webgui-root>/docs
tar xzf SQLForm-1.0.2.tar.gz
Then follow the instructions in the install.txt file.
WARNING:
If you import a table into the SQLForm, it will drop its keys and add
columns containing meta information to that table. This is not clear
from the docs! Do not import tables with a critical key structure or
which cannot have columns added.
Changelog:
1.0.4
1.0.3