DBI-Shell
view release on metacpan or search on metacpan
ok (exists $ENV{DBISH_CONFIG}, "Testing CSV plugin for dbish. Configuration file dbish_config." );
$sh = DBI::Shell->new(qw(dbi:ExampleP:));
ok(defined $sh, "Create statement handler" );
ok( ! $sh->do_connect( qw(dbi:ExampleP:)), "Connecting to source" );
ok( $sh->do_format( q{csv} ), "Change format to csv" );
# nlink,ino,blocks,ctime,rdev,mtime,mode,blksize,gid,size,dev,name,atime,uid
ok( ! $sh->do_load( $LOAD_SQL ));
ok( ! $sh->do_go );
ok( $sh->do_option( "sep=^" ));
ok( ! $sh->do_go );
ok( $sh->do_option( "sep=|" ));
ok( ! $sh->do_go );
t/sqlminus.t view on Meta::CPAN
ok (exists $ENV{DBISH_CONFIG}, "Testing SQLMinus plugin for dbish. Configuration file dbish_config." );
$sh = DBI::Shell->new(qw(dbi:ExampleP:));
ok(defined $sh, "Create statement handler" );
ok( ! $sh->do_connect( qw(dbi:ExampleP:)), "Connecting to source" );
ok( $sh->do_format( q{sqlm} ), "Change format to sqlminus" );
# nlink,ino,blocks,ctime,rdev,mtime,mode,blksize,gid,size,dev,name,atime,uid
# List of all format defined columns.
ok( ! $sh->do_column(), "List columns defined with formats" );
ok( $sh->do_column(q{fred}), "Show column format for fred" );
ok( $sh->do_column(q{nlink}), "Show column format for nlink" );
ok( $sh->do_column(q{clear}), "Clear all column formats" );
ok( ! $sh->do_column(qw{nlink format a20}) );
( run in 0.918 second using v1.01-cache-2.11-cpan-5735350b133 )