Msql::RDBMS - Relational Database Management System for Msql
use Msql::RDBMS; $rdbms = new Msql::RDBMS; $rdbms->show;
This is a fully catalog driven database management system for Perl 5 and mini-SQL. You should use it in conjunction with the sqldef.pl script which will generate data definition language for your tables.
You must pass the name of a schema definition file to sqldef.pl (an example, schema.def, is included in the examples/ subdirectory of the distribution). See sqldef.pl.
You can call up the entire Relational Database Management System from your browser with a URL like this:
Where sample.cgi is a Perl script containing the three lines of code shown in SYNOPSIS.
You can get some debugging information, which consists of a CGI::dump, and an SQL statement, if relevant, by including debug=1 in the URL.
Generate forms for interactive data definition. Enforce referential integrity (cascade/block deletes). * Enforce uniqueness for label columns. * Add fancy display options that support automagic hyperlinking of URLs and email addresses.
* denotes feature present in the original PHP/FI version.
Brian Jepson <firstname.lastname@example.org>
Paul Sharpe <email@example.com>
You may distribute this under the same terms as Perl itself.
CGI::CGI, CGI::Carp, Msql
The error handling method will handle errors in two ways. The first is to pass it no values whatsoever; it will check the mini-SQL connection for errors, and register any error that is found with the list of errors for this form. The second way to use this is to pass in a user-defined error, which will be registered in the list of errors, but this will not check the mini-SQL connection for errors. This is a good method to invoke after any SQL call; it returns true if there was an error, and all errors will get displayed when you invoke display_page().
This method displays all of the errors in the list of errors. Each error is displayed in a threatening red color. This is normally called by display_page(), but if you want to annoy your users, you should call it as often as possible.