#!/usr/bin/perl

use strict;
use warnings;
use Test::More;

BEGIN { use_ok ("DBI"); }
do "t/lib.pl";

my @tbl_def = (
    [ "id",   "INTEGER",  4, 0 ],
    [ "name", "CHAR",    64, 0 ],
    );

my $dir = DbDir () || "output";

ok (my $dbh = DBI->connect ("dbi:CSV:", "", "", {
	f_dir	=> $dir,
	}),					"connect");

ok (my $tbl = FindNewTable ($dbh),		"find new test table");
like (my $def = TableDefinition ($tbl, @tbl_def),
    qr{^create table $tbl}i,			"table definition");
ok ($dbh->do ($def),				"create table");

if (my $usr = eval { getpwuid $< }) {
    $usr = qq{"$usr"};
    is_deeply ([ $dbh->tables () ],
	       [ qq{$usr.$tbl}   ],		"tables");
    }
else {
    is_deeply ([ $dbh->tables () ],
	       [ qq{$tbl}        ],		"tables");
    }

ok ($dbh->disconnect,				"disconnect");
undef $dbh;

ok ($dbh = DBI->connect ("dbi:CSV:", "", "", {
    f_schema	=> undef,
    f_dir	=> $dir,
    }),						"connect (f_schema => undef)");
is_deeply ([ $dbh->tables () ], [ $tbl ],	"tables");

ok ($dbh->do ("drop table $tbl"),		"drop table");

ok ($dbh->disconnect,				"disconnect");
undef $dbh;

ok (rmdir $dir,					"no files left");

done_testing ();