NAME

Gtk2::Ex::DbLinker - Use sql or orm objects to build a gtk2 Gui

VERSION

version 0.01

INSTALLATION

To install this module type the following: perl Makefile.PL make make test make install

On windows use nmake or dmake instead of make.

DEPENDENCIES

The following modules are required in order to use Gtk2::Ex::Linker

        Test::Simple => 0.44,
        GLib => 1.240,
        Gtk2 => 1.240,
        Class::Interface => 1.01,
        DateTime::Format::Strptime => 1.5
        Carp => 1.17
        Gtk2::Ex::Dialogs => 0.11
        DBI => 1.631
        Log::Log4perl => 1.41
        Rose::DB::Object => 0.809

Install one of Rose::DB::Object or DBIx::Class if you want to use these orm to access your data. Rose::DB object is required to get example 2 working.

DESCRIPTION

This module automates the process of tying data from a database to widgets on a Glade-generated form. All that is required is that you name your widgets the same as the fields in your data source.

Steps for use:

• Create a DataManager object that contains the rows to display. Use DbiDataManager, RdbDataManager or DbcDataManager depending on how you access the database: sql commands and DBI, DBIx::Class or Rose::DB::Object

• Create a Gtk2::GladeXML object to construct the Gtk2 windows

• Create a Gtk2::Ex::DbLinker::Form object that links the data and the windows

• You would then typically connect the buttons to the methods below to handle common actions such as inserting, moving, deleting, etc.

EXAMPLES

The examples folder contains two example that use a sqlite database of three tables: countries (countryid, country, mainlangid), langues (langid, langue), speaks (langid, countryid).

• runexample1.pl runs at the command line, gives a form that uses DBI and sql commands to populate a drop box and a datasheet.

• runeexample2.pl gives a main form with a bottom navigation bar that display each record (a country and its main language) one by one. A subform display other(s) language(s) spoken in that country. Each language is displayed one by one and a second navigation bar is used to show these in turn. For each language, a list gives the others countries where this idiom is spoken. Items from this lists are also add/delete/changed with a third "navigation" bar.

AUTHOR

François Rappaz <rappazf@gmail.com>

COPYRIGHT

This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

The full text of the license can be found in the LICENSE file included with this module.