NAME

DBIx::Class::HTML::FormFu - Fill a HTML::FormFu form from the database and vice-versa

SYNOPSIS

# fill a form from the database

my $row = $schema->resultset('Foo')->find($id);
    
$row->fill_formfu_values( $form )

# populate the database from a submitted form

if ( $form->submitted && !$form->has_errors ) {
    
    my $row = $schema->resultset('Foo')->find({ id => $params->{id} });
    
    $row->populate_from_formfu( $form );
}

ATTRIBUTES

The fill_formfu_values and populate_from_formfu functions can both take an optional hasref argument to process the field names from form field name to database fieldname.

The hasref takes to arguments: prefix_col takes a string to add to the begining of the form field names. suffix_col takes a string to add to the end of the form field names.

Example

If you have the following form fields: private_street private_city private_email office_street office_city office_email

You most likely would like to save both datasets in same table: my $private = $user->new_related( 'data', { type => 'private' } ); $private->populate_from_formfu( $form, { prefix_col => 'private_' } ); my $office = $user->new_related( 'data', { type => 'office' } ); $office->populate_from_formfu( $form, { prefix_col => 'office_' } );

The table needs the following rows: id (not really needed) street city email type user_id

FREQUENTLY ASKED QUESTIONS (FAQ)

If I have another column in the database that is not present on the form? How do I add a value to the form to still use 'populate_from_formfu'?

Use $form->add_valid( name => 'value' );

Example: my $passwd = generate_passwd(); $form->add_valid( passwd => $passwd ); $resultset->populate_from_formfu( $form );

add_valid() works for fieldnames that don't exist in the form.

SUPPORT

Project Page:

http://code.google.com/p/html-formfu/

Mailing list:

http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/html-formfu

Mailing list archives:

http://lists.scsys.co.uk/pipermail/html-formfu/

BUGS

Please submit bugs / feature requests to http://code.google.com/p/html-formfu/issues/list (preferred) or http://rt.perl.org.

SUBVERSION REPOSITORY

The publicly viewable subversion code repository is at http://html-formfu.googlecode.com/svn/trunk/DBIx-Class-HTML-FormFu.

If you wish to contribute, you'll need a GMAIL email address. Then just ask on the mailing list for commit access.

If you wish to contribute but for some reason really don't want to sign up for a GMAIL account, please post patches to the mailing list (although you'll have to wait for someone to commit them).

If you have commit permissions, use the HTTPS repository url: https://html-formfu.googlecode.com/svn/trunk/DBIx-Class-HTML-FormFu

SEE ALSO

HTML::FormFu, DBIx::Class, Catalyst::Controller::HTML::FormFu

AUTHOR

Carl Franks

CONTRIBUTORS

Adam Herzog

Daisuke Maki

Mario Minati

COPYRIGHT AND LICENSE

Copyright (C) 2007 by Carl Franks

Based on the original source code of DBIx::Class::HTMLWidget, copyright Thomas Klausner.

This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself, either Perl version 5.8.8 or, at your option, any later version of Perl 5 you may have available.