First page Back Continue Last page Overview Graphics

Importing Our Data

my $MEMORY_DBH;
if ( CACHING_ENABLED ) {
$MEMORY_DBH =
DBI->connect('dbi:AnyData:(RaiseError=>1)');
my $dbh_pg = get_pairnic_dbh();
foreach my $table ( TABLE_A, TABLE_B) {
my $query = sprintf( “select * from %s”, $table );
$MEMORY_DBH->func( $table, 'DBI', $dbh_pg,
{sql=>$query}, 'ad_import' );
}
}

Notes:

Here is the code that was used to import the data from our PostgreSQL server into DBD::AnyData.