#!/usr/bin/perl -w

use strict;

use Mojo::DB;
use DBM::Deep;

$| = 1;

my $dbh = get_dbh();
die "No filename argument provided" unless @ARGV;
my $file = shift @ARGV;

unlink $file;

# This is the magic. :-)
my $db = DBM::Deep->new( $file );

tie my %IDS, 'DBM::Deep', $file or die "$!";

my @keys = qw(employee_id firstname lastname title dept salary date_hired);

my $keys = join(', ', @keys);
my $query = "select $keys from employee_data";
my @values = @{$dbh->selectall_arrayref($query)};

for my $v (@values){
	my @vals = @$v; # one ID per array
	for (@vals){
		$_ = '-' unless $_;
	}
    $db->{$vals[0]} = {
        (map {
            $keys[$_] => $vals[$_];
        } 0 .. $#keys)
    };
}

##</code><code>##

#!/usr/bin/perl -w

use strict;
use DBM::Deep;

$| = 1;

die "No filename argument provided" unless @ARGV;
my $file = shift @ARGV;

tie my %IDS, 'DBM::Deep', $file or die "$!";

while (my($k, $v) = each %IDS){
	print "\n$k :\n";
	while (my ($k, $v) = each %{$v}){
		print "$k => $v\n";
	}
}