Re: Retriving BerkeleyDB Data


more useful options
	PerlMonks

Re: Retriving BerkeleyDB Data

by roboticus (Chancellor)

on Aug 02, 2014 at 01:21 UTC ( [id://1095987]=note: print w/replies, xml )

Need Help??

in reply to Retriving BerkeleyDB Data

hawk2379:

It sounds like you'll just need to use the unpack function (perldoc -f unpack) to pull the byte string apart into the fields you want. I'd guess it would be something like:

my ($datetime, $open, $high, $low, $close, $volume, $interest) 
    = unpack "A14f5Q", $h{$key};
[download]

Note: Totally untested, but I think that if you play around with unpack you'll be able to pull it apart. (You'll want to check perldoc -f pack and perldoc perlpacktut as well.)

Update: changed variable names.

...roboticus

When your only tool is a hammer, all problems look like your thumb.

Comment on Re: Retriving BerkeleyDB Data Select or Download Code

Replies are listed 'Best First'.

Re^2: Retriving BerkeleyDB Data
by hawk2379 (Novice) on Aug 02, 2014 at 02:40 UTC

#!/usr/bin/perl
use BerkeleyDB; 
print "start\n";

 my $filename = '/home/user/Perl/AA';
    #unlink $filename ;
    my %h ;
   my $dbh = tie %h, 'BerkeleyDB::Btree',
                -Filename   => $filename,
                -Flags      => DB_CREATE
      or die "Cannot open $filename $! $BerkeleyDB::Error" ;

foreach $key (keys %h)
{
my ($open, $high, $low, $close, $volume, $interest) 
    = unpack "dddddl", $h{$key};
    print "$key: $open,$high,$low,$close,$volume,$interest\n";
   # print "$h{$key}\n";
}
untie %h;
print "end\n";
[download]

[reply]
[d/l]

In Section Seekers of Perl Wisdom