• NAME
• SYNOPSIS
• DESCRIPTION
• METHODS
• _file_column_callback ($file,$ret,$target)
• AUTHOR
• LICENSE

NAME

DBIx::Class::InflateColumn::File - map files from the Database to the filesystem.

SYNOPSIS

In your the DBIx::Class manpage table class:

    __PACKAGE__->load_components( "PK::Auto", "InflateColumn::File", "Core" );
    
    # define your columns
    __PACKAGE__->add_columns(
        "id",
        {
            data_type         => "integer",
            is_auto_increment => 1,
            is_nullable       => 0,
            size              => 4,
        },
        "filename",
        {
            data_type           => "varchar",
            is_file_column      => 1,
            file_column_path    =>'/tmp/uploaded_files',
            # or for a Catalyst application 
            # file_column_path  => MyApp->path_to('root','static','files'),
            default_value       => undef,
            is_nullable         => 1,
            size                => 255,
        },
    );

In your the Catalyst::Controller manpage class:

FileColumn requires a hash that contains the IO::File manpage as handle and the file's name as name.

    my $entry = $c->model('MyAppDB::Articles')->create({ 
        subject => 'blah',
        filename => { 
            handle => $c->req->upload('myupload')->fh, 
            filename => $c->req->upload('myupload')->basename 
        },
        body => '....'
    });
    $c->stash->{entry}=$entry;

And Place the following in your TT template

    Article Subject: [% entry.subject %]
    Uploaded File: 
    <a href="/static/files/[% entry.id %]/[% entry.filename.filename %]">File</a>
    Body: [% entry.body %]

The file will be stored on the filesystem for later retrieval.  Calling delete
on your resultset will delete the file from the filesystem.  Retrevial of the
record automatically inflates the column back to the set hash with the
IO::File handle and filename.

DESCRIPTION

InflateColumn::File

METHODS

_file_column_callback ($file,$ret,$target)

method made to be overridden for callback purposes.

AUTHOR

Victor Igumnov

LICENSE

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