5 use Test::More tests => 17;
6 use Data::Dump qw(dump);
10 use_ok 'APKPM::Store';
12 ok my $o = APKPM::Store->new, 'new';
14 ok my $sql = $o->_create_index('dslam', '2012_04_20'), '_create_index';
17 ok my $r = $o->insert('job',{
22 timestamp => '2011-12-05 01:01:01',
26 ok $r = $o->insert('job',{
27 _table => 'cpe_Davolink',
34 start => '2011-12-05 01:01:01',
37 ok( $r = $o->redis->get( 'table.cpe_Davolink.nobody' ), 'redis' );
38 ok( my $j = $o->d_json($r), 'd_json' );
39 isa_ok( $j->{h}, 'HASH', 'hstore' );
42 ok $r = $o->sql('job', "select username,rtt from ping limit 2"), 'sql';
45 ok $r = $o->sql('job', "select xx from fake"), 'sql with error';
46 ok exists $r->{error}, 'error';
49 foreach my $cpe_table ( qw(cpe_Davolink cpe_EasyGateway) ) {
52 ok $r = $o->sql('job', "select * from $cpe_table limit 1"), $cpe_table;
53 ok( $r->{hash_col}, 'hash_col' );
54 isa_ok $r->{rows}->[0]->[ $r->{hash_col} ], 'HASH', 'hstore column';
55 diag "$cpe_table ",dump $r;