SQL::Translator::Filter::DefaultExtra − Set default extra data values for schema objects.
use
SQL::Translator;
my $sqlt = SQL::Translator−>new(
from => 'MySQL',
to => 'MySQL',
filters => [
DefaultExtra => {
# XXX − These should really be ordered
# Default widget for fields to basic text edit.
'field.widget' => 'text',
# idea:
'field(data_type=BIT).widget' => 'yesno',
# Default label (human formated name) for fields and tables
'field.label' => '=ucfirst($name)',
'table.label' => '=ucfirst($name)',
},
],
) || die "SQLFairy error :
".SQL::Translator−>error;
my $sql = $sqlt−>translate || die "SQLFairy
error : ".$sqlt−>error;
Maybe I’m trying to do too much in one go. Args set a match and then an update, if you want to set lots of things, use lots of filters!
perl(1), SQL::Translator