Re: [gnome-db] Boolean columns with gda/gnomedb and MySQL

[Rodrigo Moya <rodrigo gnome-db org>]

On Thu, 2005-07-21 at 09:23 +0200, Vivien Malerba wrote:
> On 7/21/05, Pablo Acosta-Serafini <pmacosta yahoo com> wrote:
> > I am coding a simple glade 2.6.8/gda 1.21/gnomedb
> > 1.2.1 application, using MySQL 4.1.11 as the
> > underlying database. I'd like to have a boolean
> > column, where a true value would be displayed with a
> > check mark (or something like that), and a false value
> > with nothing. I have created a TINYINT(1) column in
> > the database, but the problem that I'm having is that
> > the values are displayed as (presumably integers),
> > with 1s and 0s. My two questions are:
> > 
> > a) Is the check mark functionality (or similar) for
> > boolean columns implemented in gnomedb?
> 
> It is not in the 1.2.x versions of libgnomedb, but it is in the CVS
> version (versions 1.3.x) so I recommend you to use either the CVS
> version of version 1.3.4 which Rodrigo has released a few days ago.
> Note that you'll need to use the same versions for libgda and
> libgnomedb.
> 
> To see how data types are displayed, you can run the
> testing/test-handlers program.
> 
> > b) If so, what do I have to do to have the column
> > recognized as boolean?
> > 
> 
> The TINYINT data type is identified as a kind of integer so you'll
> always get the 0/1s. If you want the check marks, then there are two
> possibilities (provided of course you have switched to 1.3.4 or CVS
> version of libgda/libgnomedb):
> 
> 1) create a data dictionnary if you don't have one yet for the
> connection (it will be in ~/.libgda/DICT_<your DNS name>_default.xml
> and edit the beginning where data types are defined and change the
> GNOME_DB_DATATYPE tag's gdatype attribute to "boolean" for the tag
> corresponding to the TINYINT data type. The problem is that you'll
> lose that modification every time the dictionnary is re-generated or
> updated.
> 
> 2) add a plugin="InternalBoolean" as a new attribute to the
> GNOME_DB_FIELD tag corresponding to the TINYINT field definition in
> the GNOME_DB_TABLE tag for the table it belongs to.
> 
> 3) change the data type from TINYINT to BOOL
> 
> Tell me if it solves your problems,
> 
btw, we need to add support for the new widgets and their properties to
Glade.
-- 
Rodrigo Moya <rodrigo gnome-db org>