SQL - UUID() as field default

[vivoices]

I am creating an app with the latest Fabrik downloaded from GitHub today (June 18th 2013).

One field, VARCHAR (38) needs to be set to a default value by the MySQL function UUID() at row creation.

How is this done in Fabrik?

It works fine with a trigger:

CREATE TRIGGER
    `trigger_name`
BEFORE INSERT ON
    `table_name`
FOR EACH ROW
BEGIN
    SET NEW.`uid` = UUID();
END

but I would rather use a solution that stays inside Fabrik because it will be easier to maintain later on.


Thanks

 

[troester]

I just had to do it.
set field's default eval=yes, in the default area put

$db = JFactory::getDbo();
$db->setQuery('SELECT UUID( )');
$u = $db->loadResult();
return $u;

 

[vivoices]

Thanks Tr?ster,
it's always helpful to get a few hints when starting to implement a new "framework".