Saving plasmid map jpegs in database

[ypandit]

View from #89

[ypandit]

• From sample code found online, a complete image can be loaded into the database as follows;
• pg_type => PG_BYTEA is used.

use DBD::Pg qw(:pg_types);
open( IMAGE, $filepath );
binmode(IMAGE);
my $buf;
my $data;
while ( read( IMAGE, $buf, 10000 ) ) { $data .= $buf; }
close(IMAGE);

$self->schema->storage->dbh_do(
    sub {
        my ( $storage, $dbh ) = @_;
        my $sth
            = $dbh->prepare(
            "INSERT INTO stockprop (stock_id, type_id, value) VALUES ( ?,?,? ) "
            ) or die "PREPARE FAILED";

        $sth->bind_param( 3, undef, { pg_type => PG_BYTEA } );
        $sth->execute(
            $stock_rs->stock_id,
            $self->find_or_create_cvterm(
                'plasmid map', 'dicty_stockcenter'
            ),
            $data
        ) or die "EXECUTE FAILED";
        $sth->finish;
    }
);

• However, writing back to a *.jpg from this data did not generate an image file

Ref: 7a7a4e3 #L145