use strict;
use warnings;
-use Test::More tests => 9;
+use Test::More tests => 16;
use Data::Dump qw(dump);
use lib 'lib';
}), 'ping';
diag dump($r);
+ok my $r = $o->insert('job',{
+_table => 'cpe_Davolink',
+ip => '127.0.0.1',
+username => 'nobody',
+h => {
+ foo => 1,
+ bar => 2,
+}
+}), 'ping';
+
+ok( my $r = $o->redis->get( 'table.cpe_Davolink.nobody' ), 'redis' );
+ok( my $j = $o->d_json($r), 'd_json' );
+isa_ok( $j->{h}, 'HASH', 'hstore' );
+diag dump($j);
+
ok my $r = $o->sql('job', "select username,rtt from ping limit 2"), 'sql';
diag dump($r);
ok exists $r->{error}, 'error';
diag dump($r);
-ok my $r = $o->sql('job', "select * from cpe_Davolink limit 1"), 'cpe_Davolink';
-ok( $r->{hash_col}, 'hash_col' );
-isa_ok $r->{rows}->[0]->[ $r->{hash_col} ], 'HASH', 'hstore column';
-diag dump $r;
+foreach my $cpe_table ( qw(cpe_Davolink cpe_EasyGateway) ) {
+
+ diag $cpe_table;
+ ok my $r = $o->sql('job', "select * from $cpe_table limit 1"), $cpe_table;
+ ok( $r->{hash_col}, 'hash_col' );
+ isa_ok $r->{rows}->[0]->[ $r->{hash_col} ], 'HASH', 'hstore column';
+ diag "$cpe_table ",dump $r;
+
+}