Gtk2::Ex::Datasheet::DBI 2.0 review

License: LGPL (GNU Lesser General Public License) File size: 0K Developer: Daniel Kasak

0

Gtk2::Ex::Datasheet::DBI is a Perl module that is used in conjunction with Gtk2::Perl to give data-aware "datasheet" functionality.

The programmer creates a GUI with Gtk2-Perl (and possibly Gtk2-GladeXML), and then creates a Gtk2::Ex::Datasheet::DBI object, which then "binds" a DBI data source to the datasheet, managing querying, navigating records, applying updates to the database, and error handling.

What's New in This Release:
Overhaul SQL clause handling - now all SQL-related stuff is in the 'sql' hash
Added support for placeholders in where clause
Added detection of primary key from column_info() ( MySQL & SQL Server only at present )
Added destroy method, which destroys all signal handlers we've created, then destroys itself ( not working yet )
Renamed $model_setup->{table} to $model_setup->{from} in dynamic models
Added legacy mode to support 1.x requests
Process dynamic models out of order when querying - no need to queue them for later
Added method revert(), which is a synonym of undo()
Added graceful handling of failure of $dbh->column_info ( warn to console what's happened )
Warn to console if $dbh->column_info fails AND we don't have a primary_key definition
Only ask to apply changes if not read_only
Addded missing schema request to self
harmless anyway because we only support automatic renderer selection for MySQL currently
Updated documentation & cleaned up POD somewhat