use strict;
use warnings;
use Test::More;
use Hypatia;
use Hypatia::DBI::Test::SQLite;
use Scalar::Util qw(blessed);

BEGIN
{
    eval "require DBD::SQLite";
    if($@)
    {
	require Test::More;
	Test::More::plan(skip_all=>"DBD::SQLite is required to run these tests.")
    }
}

my $hdts=Hypatia::DBI::Test::SQLite->new({table=>"hypatia_test_pie"});
my $dbh=$hdts->dbh;

 my $hypatia=Hypatia->new({
    back_end=>"Chart::Clicker",
    graph_type=>"Pie",
    dbi=>{dbh=>$hdts->dbh,
	table=>"hypatia_test_pie"},
	columns=>{label=>"type",values=>"number"}
});
 
ok(blessed($hypatia) eq "Hypatia");
ok(blessed($hypatia->dbh) eq 'DBI::db');
ok($hypatia->dbh->{Active});

my $cc=$hypatia->chart;

ok(blessed($cc) eq 'Chart::Clicker');
 
 my $dataset = $cc->datasets->[0];
 ok(blessed($dataset) eq 'Chart::Clicker::Data::DataSet');

ok(@{$dataset->series} == 3);

my $dataseries=$dataset->series->[0];
my $keys=$dataseries->keys;
my $values=$dataseries->values;
my $name=$dataseries->name;

ok(@$keys == 2 and scalar(grep{$_ == 1 or $_ == 2}@$keys) == 2);
ok(@$values == 2 and scalar(grep{$_ == 0 or $_ == 2}@$values) == 2);
ok($name eq "some other thing");

$dataseries=$dataset->series->[1];
$keys=$dataseries->keys;
$values=$dataseries->values;
$name=$dataseries->name;

ok(@$keys == 2 and scalar(grep{$_ == 1 or $_ == 2}@$keys) == 2);
ok(@$values == 2 and scalar(grep{$_ == 0 or $_ == 1.48}@$values) == 2);
ok($name eq "some type");

$dataseries=$dataset->series->[2];
$keys=$dataseries->keys;
$values=$dataseries->values;
$name=$dataseries->name;

ok(@$keys == 2 and scalar(grep{$_ == 1 or $_ == 2}@$keys) == 2);
ok(@$values == 2 and scalar(grep{$_ == 0 or $_ == 1.78}@$values) == 2);
ok($name eq "yet another thing");


done_testing();