Checking if your kit is complete...
Looks good
Writing Makefile for DBI::Shell
cp lib/DBI/Shell.pm blib/lib/DBI/Shell.pm
cp lib/DBI/Shell/FindSqlFile.pm blib/lib/DBI/Shell/FindSqlFile.pm
cp lib/DBI/Shell/SQLMinus.pm blib/lib/DBI/Shell/SQLMinus.pm
cp lib/DBI/Shell/Completion.pm blib/lib/DBI/Shell/Completion.pm
cp lib/DBI/Format.pm blib/lib/DBI/Format.pm
cp lib/DBI/Shell/Timing.pm blib/lib/DBI/Shell/Timing.pm
cp lib/DBI/Shell/Spool.pm blib/lib/DBI/Shell/Spool.pm
cp lib/DBI/Format/SQLMinus.pm blib/lib/DBI/Format/SQLMinus.pm
/export/home/cpanrun/build/5.6.1/bin/perl -Iblib/arch -Iblib/lib -I/export/home/cpanrun/build/5.6.1/lib/5.6.1/sun4-solaris-thread-multi -I/export/home/cpanrun/build/5.6.1/lib/5.6.1 dbish.PL dbish
Extracted dbish from dbish.PL with variable substitutions.
cp dbish blib/script/dbish
/export/home/cpanrun/build/5.6.1/bin/perl -I/export/home/cpanrun/build/5.6.1/lib/5.6.1/sun4-solaris-thread-multi -I/export/home/cpanrun/build/5.6.1/lib/5.6.1 -MExtUtils::MakeMaker -e "MY->fixin(shift)" blib/script/dbish
Manifying blib/man3/DBI::Shell.3
Manifying blib/man3/DBI::Format.3
Manifying blib/man1/dbish.1
Manifying blib/man3/DBI::Format::SQLMinus.3
PERL_DL_NONLAZY=1 /export/home/cpanrun/build/5.6.1/bin/perl -Iblib/arch -Iblib/lib -I/export/home/cpanrun/build/5.6.1/lib/5.6.1/sun4-solaris-thread-multi -I/export/home/cpanrun/build/5.6.1/lib/5.6.1 -e 'use Test::Harness qw(&runtests $verbose); $verbose=1; runtests @ARGV;' t/*.t
t/batch.............1..1
ok 1
ok
t/core..............1..9
ok 1 - use DBI::Shell;
DBI::Shell 11.93 using DBI 1.48 in batch mode
ok 2 - Create Std handler
Connecting to 'dbi:ExampleP:' as ''...
ok 3 - Connect to dbi:ExampleP:
Disconnecting from dbi:ExampleP:.
ok 4 - Disconnect from dbi:ExampleP:
ok 5 - Creating second handler
DBI::Shell 11.93 using DBI 1.48 in batch mode
ok 6 - Connect second dbi:ExampleP:
Connecting to 'dbi:ExampleP:' as ''...
ok 7 - Connect again.
Disconnecting from dbi:ExampleP:.
Connecting to 'dbi:ExampleP:' as ''...
ok 8 - Connect again.
Disconnecting from dbi:ExampleP:.
ok 9 - Disconnect second dbi:ExampleP:
ok
t/func..............1..0 # Skip Function tests not completed
skipped: Function tests not completed
t/shell.............1..51
ok 1 - use DBI::Shell;
DBI::Shell 11.93 using DBI 1.48 in batch mode
ok 2 - Create new handler
Connecting to 'dbi:ExampleP:' as ''...
ok 3 - Connect to source
Available drivers:
DBM
ExampleP
File
Proxy
Sponge
ok 4 - Do drivers
TABLE_CAT,TABLE_SCHEM,TABLE_NAME,TABLE_TYPE,REMARKS
'.',undef,'.','TABLE',undef
'.',undef,'..','TABLE',undef
'.',undef,'lib','TABLE',undef
'.',undef,'t','TABLE',undef
'.',undef,'blib','TABLE',undef
[5 rows of 5 fields returned]
ok 5 - Do table_info
TYPE_NAME,DATA_TYPE,COLUMN_SIZE,LITERAL_PREFIX,LITERAL_SUFFIX,CREATE_PARAMS,NULLABLE,CASE_SENSITIVE,SEARCHABLE,UNSIGNED_ATTRIBUTE,FIXED_PREC_SCALE,AUTO_UNIQUE_VALUE,LOCAL_TYPE_NAME,MINIMUM_SCALE,MAXIMUM_SCALE
'VARCHAR',12,1024,'\'','\'',undef,0,1,1,0,0,0,undef,0,0
'INTEGER',4,10,'','',undef,0,0,1,0,0,0,undef,0,0
[2 rows of 15 fields returned]
ok 6 - Do type_info
ok 7 - Do clear
ok 8 - Recall results history
ok 9 - Recall command history
ok 10 - Recall history
ok 11 - Help ...
batch: 1
chistory_size: 50
command_prefix: [/;]
command_prefix_end: ;
command_prefix_line: /
debug: 0
desc_format: partbox
desc_show_columns: COLUMN_NAME,DATA_TYPE,TYPE_NAME,COLUMN_SIZE,PK,NULLABLE,COLUMN_DEF,IS_NULLABLE,REMARKS
desc_show_long: 1
desc_show_remarks: 1
editor: vi
format: neat
home_dir: /export/home/cpanrun
init_autocommit: 1
init_trace: 0
prompt: dbi:ExampleP:
rhistory_head: 5
rhistory_size: 50
rhistory_tail: 5
seperator: ,
sqlpath: .
tmp_dir: undef
tmp_file: dbish16647.sql
user_level: 1
ok 12 - Options ...
ok 13 - Have test file?
Current statement buffer:
select * from t
ok 14 - Loading test file testsql.sql
nlink,ino,blocks,ctime,rdev,mtime,mode,blksize,gid,size,dev,name,atime,uid
2,790338,2,1178084388,0,1178084388,16895,8192,1,512,8388616,'.',1178084415,102
5,571047,2,1178084396,0,1178084396,16895,8192,1,512,8388616,'..',1178084415,102
1,790354,2,1178084388,0,1035774529,33261,8192,1,687,8388616,'batch.t',1178084407,102
1,790355,4,1178084388,0,1035774529,33261,8192,1,1044,8388616,'core.t',1178084409,102
1,790356,14,1178084388,0,1035864543,33261,8192,1,6828,8388616,'func.t',1178084412,102
1,790357,6,1178084388,0,1039823183,33261,8192,1,2856,8388616,'shell.t',1178084413,102
1,790358,4,1178084388,0,1039823183,33261,8192,1,1562,8388616,'spool.t',1039823183,102
1,790359,30,1178084388,0,1038334172,33261,8192,1,14681,8388616,'sqlminus.t',1038334172,102
1,790360,10,1178084388,0,1035774529,33261,8192,1,4960,8388616,'timing.t',1035774529,102
[9 rows of 14 fields returned]
ok 15 - Execute current buffer
select * from t
ok 16 - Get last command executed
nlink,ino,blocks,ctime,rdev,mtime,mode,blksize,gid,size,dev,name,atime,uid
2,790338,2,1178084388,0,1178084388,16895,8192,1,512,8388616,'.',1178084415,102
5,571047,2,1178084396,0,1178084396,16895,8192,1,512,8388616,'..',1178084415,102
1,790354,2,1178084388,0,1035774529,33261,8192,1,687,8388616,'batch.t',1178084407,102
1,790355,4,1178084388,0,1035774529,33261,8192,1,1044,8388616,'core.t',1178084409,102
1,790356,14,1178084388,0,1035864543,33261,8192,1,6828,8388616,'func.t',1178084412,102
1,790357,6,1178084388,0,1039823183,33261,8192,1,2856,8388616,'shell.t',1178084413,102
1,790358,4,1178084388,0,1039823183,33261,8192,1,1562,8388616,'spool.t',1039823183,102
1,790359,30,1178084388,0,1038334172,33261,8192,1,14681,8388616,'sqlminus.t',1038334172,102
1,790360,10,1178084388,0,1035774529,33261,8192,1,4960,8388616,'timing.t',1035774529,102
[9 rows of 14 fields returned]
ok 17 - Execute current buffer
select * from t
ok 18 - Get first command executed
nlink,ino,blocks,ctime,rdev,mtime,mode,blksize,gid,size,dev,name,atime,uid
2,790338,2,1178084388,0,1178084388,16895,8192,1,512,8388616,'.',1178084415,102
5,571047,2,1178084396,0,1178084396,16895,8192,1,512,8388616,'..',1178084415,102
1,790354,2,1178084388,0,1035774529,33261,8192,1,687,8388616,'batch.t',1178084407,102
1,790355,4,1178084388,0,1035774529,33261,8192,1,1044,8388616,'core.t',1178084409,102
1,790356,14,1178084388,0,1035864543,33261,8192,1,6828,8388616,'func.t',1178084412,102
1,790357,6,1178084388,0,1039823183,33261,8192,1,2856,8388616,'shell.t',1178084413,102
1,790358,4,1178084388,0,1039823183,33261,8192,1,1562,8388616,'spool.t',1039823183,102
1,790359,30,1178084388,0,1038334172,33261,8192,1,14681,8388616,'sqlminus.t',1038334172,102
1,790360,10,1178084388,0,1035774529,33261,8192,1,4960,8388616,'timing.t',1035774529,102
[9 rows of 14 fields returned]
ok 19 - Execute current buffer
Current statement buffer:
ok 20 - Save current buffer to file testsql.tmp
ok 21 - Does testsql.tmp exists?
ok 22 - Configuration file defined in environment
Disconnecting from dbi:ExampleP:.
Connecting to 'dbi:ExampleP:' as ''...
ok 23 - Connect to source
Current statement buffer:
select * from t
ok 24 - Load current buffer from testsql.sql
nlink,ino,blocks,ctime,rdev,mtime,mode,blksize,gid,size,dev,name,atime,uid
2,790338,2,1178084388,0,1178084388,16895,8192,1,512,8388616,'.',1178084415,102
5,571047,2,1178084415,0,1178084415,16895,8192,1,512,8388616,'..',1178084415,102
1,790354,2,1178084388,0,1035774529,33261,8192,1,687,8388616,'batch.t',1178084407,102
1,790355,4,1178084388,0,1035774529,33261,8192,1,1044,8388616,'core.t',1178084409,102
1,790356,14,1178084388,0,1035864543,33261,8192,1,6828,8388616,'func.t',1178084412,102
1,790357,6,1178084388,0,1039823183,33261,8192,1,2856,8388616,'shell.t',1178084413,102
1,790358,4,1178084388,0,1039823183,33261,8192,1,1562,8388616,'spool.t',1039823183,102
1,790359,30,1178084388,0,1038334172,33261,8192,1,14681,8388616,'sqlminus.t',1038334172,102
1,790360,10,1178084388,0,1035774529,33261,8192,1,4960,8388616,'timing.t',1035774529,102
[9 rows of 14 fields returned]
ok 25 - Execute current buffer
ok 26 - Do commit
ok 27 - Do rollback
ok 28 - Set format to neat
select * from t
ok 29 - Last executed command
nlink,ino,blocks,ctime,rdev,mtime,mode,blksize,gid,size,dev,name,atime,uid
2,790338,2,1178084388,0,1178084388,16895,8192,1,512,8388616,'.',1178084415,102
5,571047,2,1178084415,0,1178084415,16895,8192,1,512,8388616,'..',1178084415,102
1,790354,2,1178084388,0,1035774529,33261,8192,1,687,8388616,'batch.t',1178084407,102
1,790355,4,1178084388,0,1035774529,33261,8192,1,1044,8388616,'core.t',1178084409,102
1,790356,14,1178084388,0,1035864543,33261,8192,1,6828,8388616,'func.t',1178084412,102
1,790357,6,1178084388,0,1039823183,33261,8192,1,2856,8388616,'shell.t',1178084413,102
1,790358,4,1178084388,0,1039823183,33261,8192,1,1562,8388616,'spool.t',1039823183,102
1,790359,30,1178084388,0,1038334172,33261,8192,1,14681,8388616,'sqlminus.t',1038334172,102
1,790360,10,1178084388,0,1035774529,33261,8192,1,4960,8388616,'timing.t',1035774529,102
[9 rows of 14 fields returned]
ok 30 - Execute current buffer
ok 31 - Set format to box
select * from t
ok 32 - Last executed command
+-----+------+------+----------+----+----------+-----+-------+---+-----+-------+----------+----------+---+
|nlink|ino |blocks|ctime |rdev|mtime |mode |blksize|gid|size |dev |name |atime |uid|
+-----+------+------+----------+----+----------+-----+-------+---+-----+-------+----------+----------+---+
| 2|790338| 2|1178084388| 0|1178084388|16895| 8192| 1| 512|8388616|. |1178084415|102|
+-----+------+------+----------+----+----------+-----+-------+---+-----+-------+----------+----------+---+
| 5|571047| 2|1178084415| 0|1178084415|16895| 8192| 1| 512|8388616|.. |1178084415|102|
+-----+------+------+----------+----+----------+-----+-------+---+-----+-------+----------+----------+---+
| 1|790354| 2|1178084388| 0|1035774529|33261| 8192| 1| 687|8388616|batch.t |1178084407|102|
+-----+------+------+----------+----+----------+-----+-------+---+-----+-------+----------+----------+---+
| 1|790355| 4|1178084388| 0|1035774529|33261| 8192| 1| 1044|8388616|core.t |1178084409|102|
+-----+------+------+----------+----+----------+-----+-------+---+-----+-------+----------+----------+---+
| 1|790356| 14|1178084388| 0|1035864543|33261| 8192| 1| 6828|8388616|func.t |1178084412|102|
+-----+------+------+----------+----+----------+-----+-------+---+-----+-------+----------+----------+---+
| 1|790357| 6|1178084388| 0|1039823183|33261| 8192| 1| 2856|8388616|shell.t |1178084413|102|
+-----+------+------+----------+----+----------+-----+-------+---+-----+-------+----------+----------+---+
| 1|790358| 4|1178084388| 0|1039823183|33261| 8192| 1| 1562|8388616|spool.t |1039823183|102|
+-----+------+------+----------+----+----------+-----+-------+---+-----+-------+----------+----------+---+
| 1|790359| 30|1178084388| 0|1038334172|33261| 8192| 1|14681|8388616|sqlminus.t|1038334172|102|
+-----+------+------+----------+----+----------+-----+-------+---+-----+-------+----------+----------+---+
| 1|790360| 10|1178084388| 0|1035774529|33261| 8192| 1| 4960|8388616|timing.t |1035774529|102|
+-----+------+------+----------+----+----------+-----+-------+---+-----+-------+----------+----------+---+
[9 rows of 14 fields returned]
ok 33 - Execute current buffer
ok 34 - Set format to string
select * from t
ok 35 - Last executed command
nlink ino blocks ctime rdev mtime mode blksize gid size dev name atime uid
2 790338 2 1178084388 0 1178084388 16895 8192 1 512 8388616 . 1178084415 102
5 571047 2 1178084415 0 1178084415 16895 8192 1 512 8388616 .. 1178084415 102
1 790354 2 1178084388 0 1035774529 33261 8192 1 687 8388616 batch.t 1178084407 102
1 790355 4 1178084388 0 1035774529 33261 8192 1 1044 8388616 core.t 1178084409 102
1 790356 14 1178084388 0 1035864543 33261 8192 1 6828 8388616 func.t 1178084412 102
1 790357 6 1178084388 0 1039823183 33261 8192 1 2856 8388616 shell.t 1178084413 102
1 790358 4 1178084388 0 1039823183 33261 8192 1 1562 8388616 spool.t 1039823183 102
1 790359 30 1178084388 0 1038334172 33261 8192 1 14681 8388616 sqlminus.t 1038334172 102
1 790360 10 1178084388 0 1035774529 33261 8192 1 4960 8388616 timing.t 1035774529 102
[9 rows of 14 fields returned]
ok 36 - Execute current buffer
ok 37 - Set format to html
select * from t
ok 38 - Last executed command
nlink | ino | blocks | ctime | rdev | mtime | mode | blksize | gid | size | dev | name | atime | uid |
2 | 790338 | 2 | 1178084388 | 0 | 1178084388 | 16895 | 8192 | 1 | 512 | 8388616 | . | 1178084416 | 102 |
5 | 571047 | 2 | 1178084415 | 0 | 1178084415 | 16895 | 8192 | 1 | 512 | 8388616 | .. | 1178084415 | 102 |
1 | 790354 | 2 | 1178084388 | 0 | 1035774529 | 33261 | 8192 | 1 | 687 | 8388616 | batch.t | 1178084407 | 102 |
1 | 790355 | 4 | 1178084388 | 0 | 1035774529 | 33261 | 8192 | 1 | 1044 | 8388616 | core.t | 1178084409 | 102 |
1 | 790356 | 14 | 1178084388 | 0 | 1035864543 | 33261 | 8192 | 1 | 6828 | 8388616 | func.t | 1178084412 | 102 |
1 | 790357 | 6 | 1178084388 | 0 | 1039823183 | 33261 | 8192 | 1 | 2856 | 8388616 | shell.t | 1178084413 | 102 |
1 | 790358 | 4 | 1178084388 | 0 | 1039823183 | 33261 | 8192 | 1 | 1562 | 8388616 | spool.t | 1039823183 | 102 |
1 | 790359 | 30 | 1178084388 | 0 | 1038334172 | 33261 | 8192 | 1 | 14681 | 8388616 | sqlminus.t | 1038334172 | 102 |
1 | 790360 | 10 | 1178084388 | 0 | 1035774529 | 33261 | 8192 | 1 | 4960 | 8388616 | timing.t | 1035774529 | 102 |
[9 rows of 14 fields returned]
ok 39 - Execute current buffer
ok 40 - Set format to raw
select * from t
ok 41 - Last executed command
nlink,ino,blocks,ctime,rdev,mtime,mode,blksize,gid,size,dev,name,atime,uid
2,790338,2,1178084388,0,1178084388,16895,8192,1,512,8388616,.,1178084416,102
5,571047,2,1178084415,0,1178084415,16895,8192,1,512,8388616,..,1178084415,102
1,790354,2,1178084388,0,1035774529,33261,8192,1,687,8388616,batch.t,1178084407,102
1,790355,4,1178084388,0,1035774529,33261,8192,1,1044,8388616,core.t,1178084409,102
1,790356,14,1178084388,0,1035864543,33261,8192,1,6828,8388616,func.t,1178084412,102
1,790357,6,1178084388,0,1039823183,33261,8192,1,2856,8388616,shell.t,1178084413,102
1,790358,4,1178084388,0,1039823183,33261,8192,1,1562,8388616,spool.t,1039823183,102
1,790359,30,1178084388,0,1038334172,33261,8192,1,14681,8388616,sqlminus.t,1038334172,102
1,790360,10,1178084388,0,1035774529,33261,8192,1,4960,8388616,timing.t,1035774529,102
[9 rows of 14 fields returned]
ok 42 - Execute current buffer
ok 43 - Set format to neat
select * from t
ok 44 - Last executed command
nlink,ino,blocks,ctime,rdev,mtime,mode,blksize,gid,size,dev,name,atime,uid
2,790338,2,1178084388,0,1178084388,16895,8192,1,512,8388616,'.',1178084416,102
5,571047,2,1178084415,0,1178084415,16895,8192,1,512,8388616,'..',1178084415,102
1,790354,2,1178084388,0,1035774529,33261,8192,1,687,8388616,'batch.t',1178084407,102
1,790355,4,1178084388,0,1035774529,33261,8192,1,1044,8388616,'core.t',1178084409,102
1,790356,14,1178084388,0,1035864543,33261,8192,1,6828,8388616,'func.t',1178084412,102
1,790357,6,1178084388,0,1039823183,33261,8192,1,2856,8388616,'shell.t',1178084413,102
1,790358,4,1178084388,0,1039823183,33261,8192,1,1562,8388616,'spool.t',1039823183,102
1,790359,30,1178084388,0,1038334172,33261,8192,1,14681,8388616,'sqlminus.t',1038334172,102
1,790360,10,1178084388,0,1035774529,33261,8192,1,4960,8388616,'timing.t',1035774529,102
[9 rows of 14 fields returned]
ok 45 - Execute current buffer
ok 46 - Set format to neat
Negative number -1:
Changed number 9:
select * from t
ok 47 - Get with -1 command
nlink,ino,blocks,ctime,rdev,mtime,mode,blksize,gid,size,dev,name,atime,uid
2,790338,2,1178084388,0,1178084388,16895,8192,1,512,8388616,'.',1178084416,102
5,571047,2,1178084415,0,1178084415,16895,8192,1,512,8388616,'..',1178084415,102
1,790354,2,1178084388,0,1035774529,33261,8192,1,687,8388616,'batch.t',1178084407,102
1,790355,4,1178084388,0,1035774529,33261,8192,1,1044,8388616,'core.t',1178084409,102
1,790356,14,1178084388,0,1035864543,33261,8192,1,6828,8388616,'func.t',1178084412,102
1,790357,6,1178084388,0,1039823183,33261,8192,1,2856,8388616,'shell.t',1178084413,102
1,790358,4,1178084388,0,1039823183,33261,8192,1,1562,8388616,'spool.t',1039823183,102
1,790359,30,1178084388,0,1038334172,33261,8192,1,14681,8388616,'sqlminus.t',1038334172,102
1,790360,10,1178084388,0,1035774529,33261,8192,1,4960,8388616,'timing.t',1035774529,102
[9 rows of 14 fields returned]
ok 48 - Execute current buffer
Negative number -2:
Changed number 9:
select * from t
ok 49 - Get with -2 command
nlink,ino,blocks,ctime,rdev,mtime,mode,blksize,gid,size,dev,name,atime,uid
2,790338,2,1178084388,0,1178084388,16895,8192,1,512,8388616,'.',1178084416,102
5,571047,2,1178084415,0,1178084415,16895,8192,1,512,8388616,'..',1178084415,102
1,790354,2,1178084388,0,1035774529,33261,8192,1,687,8388616,'batch.t',1178084407,102
1,790355,4,1178084388,0,1035774529,33261,8192,1,1044,8388616,'core.t',1178084409,102
1,790356,14,1178084388,0,1035864543,33261,8192,1,6828,8388616,'func.t',1178084412,102
1,790357,6,1178084388,0,1039823183,33261,8192,1,2856,8388616,'shell.t',1178084413,102
1,790358,4,1178084388,0,1039823183,33261,8192,1,1562,8388616,'spool.t',1039823183,102
1,790359,30,1178084388,0,1038334172,33261,8192,1,14681,8388616,'sqlminus.t',1038334172,102
1,790360,10,1178084388,0,1035774529,33261,8192,1,4960,8388616,'timing.t',1035774529,102
[9 rows of 14 fields returned]
ok 50 - Execute current buffer
Disconnecting from dbi:ExampleP:.
ok 51 - Disconnect
ok
t/spool.............1..14
ok 1 - use DBI::Shell;
ok 2 - Testing Spool plugin for dbish. Configuration file dbish_config.
DBI::Shell 11.93 using DBI 1.48 in batch mode
commandline history written to /export/home/cpanrun/.dbish_history
ok 3 - Create statement handler
Connecting to 'dbi:ExampleP:' as ''...
ok 4 - Connecting to source
Current statement buffer:
select
nlink,ino,blocks,ctime,rdev
from t
ok 5
nlink,ino,blocks,ctime,rdev
2,790338,2,1178084388,0
5,571047,2,1178084415,0
1,790354,2,1178084388,0
1,790355,4,1178084388,0
1,790356,14,1178084388,0
1,790357,6,1178084388,0
1,790358,4,1178084388,0
1,790359,30,1178084388,0
1,790360,10,1178084388,0
[9 rows of 5 fields returned]
Elapsed: 0 wallclock secs ( 0.01 usr + 0.00 sys = 0.01 CPU) @ 100.00/s (n=1)
ok 6
spooling testspool.tmp
ok 7 - Spooling testspool.tmp
spooling output to file: testspool.tmp
ok 8 - Spooling to testspool.tmp
select
nlink,ino,blocks,ctime,rdev
from t
ok 9 - Get command
nlink,ino,blocks,ctime,rdev
2,790338,2,1178084388,0
5,571047,2,1178084418,0
1,790354,2,1178084388,0
1,790355,4,1178084388,0
1,790356,14,1178084388,0
1,790357,6,1178084388,0
1,790358,4,1178084388,0
1,790359,30,1178084388,0
1,790360,10,1178084388,0
[9 rows of 5 fields returned]
Elapsed: 0 wallclock secs ( 0.01 usr + 0.00 sys = 0.01 CPU) @ 100.00/s (n=1)
ok 10 - Execute current buffer
ok 11 - Spool off
not spooling
ok 12 - Spool is off
ok 13 - Created Spool file
Disconnecting from dbi:ExampleP:.
ok 14 - Disconnect
ok
t/sqlminus..........1..109
ok 1 - use DBI::Shell;
ok 2 - require Text::Reform;
ok 3 - Testing SQLMinus plugin for dbish. Configuration file dbish_config.
DBI::Shell 11.93 using DBI 1.48 in batch mode
commandline history written to /export/home/cpanrun/.dbish_history
ok 4 - Create statement handler
Connecting to 'dbi:ExampleP:' as ''...
ok 5 - Connecting to source
ok 6 - Change format to sqlminus
ok 7 - List columns defined with formats
fred: no column format defined.
ok 8 - Show column format for fred
nlink: no column format defined.
ok 9 - Show column format for nlink
format cleared
ok 10 - Clear all column formats
ok 11
ok 12
ok 13
ok 14
blocks
column_format a20
format <<<<<<<<<<<<<<<<<<<<
length 20
on 1
type char
ctime
column_format a20
format <<<<<<<<<<<<<<<<<<<<
length 20
on 1
type char
ino
column_format a20
format <<<<<<<<<<<<<<<<<<<<
length 20
on 1
type char
nlink
column_format a20
format <<<<<<<<<<<<<<<<<<<<
length 20
on 1
type char
ok 15
Current statement buffer:
select
nlink,ino,blocks,ctime,rdev
from t
ok 16
nlink ino blocks ctime rdev
-------------------- -------------------- -------------------- -------------------- ----------
2 790338 2 1178084388 0
5 571047 2 1178084418 0
1 790354 2 1178084388 0
1 790355 4 1178084388 0
1 790356 14 1178084388 0
1 790357 6 1178084388 0
1 790358 4 1178084388 0
1 790359 30 1178084388 0
1 790360 10 1178084388 0
Page Number: 0
[9 rows of 5 fields returned]
Elapsed: 0 wallclock secs ( 0.06 usr + 0.01 sys = 0.07 CPU) @ 14.29/s (n=1)
ok 17
ok 18
blocks
column_format a20
format <<<<<<<<<<<<<<<<<<<<
length 20
on 1
type char
ctime
column_format a20
format <<<<<<<<<<<<<<<<<<<<
length 20
noprint 1
on 1
type char
ino
column_format a20
format <<<<<<<<<<<<<<<<<<<<
length 20
on 1
type char
nlink
column_format a20
format <<<<<<<<<<<<<<<<<<<<
length 20
on 1
type char
ok 19
Current statement buffer:
select
nlink,ino,blocks,ctime,rdev
from t
ok 20
nlink ino blocks rdev
-------------------- -------------------- -------------------- ----
2 790338 2 0
5 571047 2 0
1 790354 2 0
1 790355 4 0
1 790356 14 0
1 790357 6 0
1 790358 4 0
1 790359 30 0
1 790360 10 0
Page Number: 0
[9 rows of 5 fields returned]
Elapsed: 1 wallclock secs ( 0.06 usr + 0.00 sys = 0.06 CPU) @ 16.67/s (n=1)
ok 21
ok 22
Current statement buffer:
select
nlink,ino,blocks,ctime,rdev
from t
ok 23
nlink ino blocks ctime rdev
-------------------- -------------------- -------------------- -------------------- ----------
2 790338 2 1178084388 0
5 571047 2 1178084418 0
1 790354 2 1178084388 0
1 790355 4 1178084388 0
1 790356 14 1178084388 0
1 790357 6 1178084388 0
1 790358 4 1178084388 0
1 790359 30 1178084388 0
1 790360 10 1178084388 0
Page Number: 0
[9 rows of 5 fields returned]
Elapsed: 0 wallclock secs ( 0.08 usr + 0.00 sys = 0.08 CPU) @ 12.50/s (n=1)
ok 24
format cleared
ok 25
ok 26
ok 27
ctime
----------
1178084388
1178084418
1178084388
1178084388
1178084388
1178084388
1178084388
1178084388
1178084388
Page Number: 0
[9 rows of 1 fields returned]
Elapsed: 0 wallclock secs ( 0.03 usr + 0.00 sys = 0.03 CPU) @ 33.33/s (n=1)
ok 28
ok 29
Page Number: 0
[9 rows of 1 fields returned]
Elapsed: 0 wallclock secs ( 0.02 usr + 0.00 sys = 0.02 CPU) @ 50.00/s (n=1)
ok 30
ok 31
ctime
----------
1178084388
1178084418
1178084388
1178084388
1178084388
1178084388
1178084388
1178084388
1178084388
Page Number: 0
[9 rows of 1 fields returned]
Elapsed: 0 wallclock secs ( 0.04 usr + 0.00 sys = 0.04 CPU) @ 25.00/s (n=1)
ok 32
ok 33
ctime
----------
1178084388
1178084418
1178084388
1178084388
1178084388
1178084388
1178084388
1178084388
1178084388
Page Number: 0
[9 rows of 1 fields returned]
Elapsed: 0 wallclock secs ( 0.03 usr + 0.00 sys = 0.03 CPU) @ 33.33/s (n=1)
ok 34
format cleared
ok 35
ok 36
ctime
----------
1178084388
1178084418
1178084388
1178084388
1178084388
1178084388
1178084388
1178084388
1178084388
Page Number: 0
[9 rows of 1 fields returned]
Elapsed: 0 wallclock secs ( 0.03 usr + 0.00 sys = 0.03 CPU) @ 33.33/s (n=1)
ok 37
command: heading
heading: undef
ok 38
command: underline
underline: null
ok 39 - turn underline off
ctime
1178084388
1178084418
1178084388
1178084388
1178084388
1178084388
1178084388
1178084388
1178084388
Page Number: 0
[9 rows of 1 fields returned]
Elapsed: 0 wallclock secs ( 0.03 usr + 0.00 sys = 0.03 CPU) @ 33.33/s (n=1)
ok 40
command: underline
underline: -
ok 41
ctime
----------
1178084388
1178084418
1178084388
1178084388
1178084388
1178084388
1178084388
1178084388
1178084388
Page Number: 0
[9 rows of 1 fields returned]
Elapsed: 0 wallclock secs ( 0.02 usr + 0.01 sys = 0.03 CPU) @ 33.33/s (n=1)
ok 42
command: underline
underline: undef
ok 43
command: heading
heading: on
ok 44
ok 45
ctime
column_format a10
format <<<<<<<<<<
heading This is my heading
length 10
on 1
type char
ok 46
This is my
undefunde-
1178084388
1178084418
1178084388
1178084388
1178084388
1178084388
1178084388
1178084388
1178084388
Page Number: 0
[9 rows of 1 fields returned]
Elapsed: 0 wallclock secs ( 0.03 usr + 0.00 sys = 0.03 CPU) @ 33.33/s (n=1)
ok 47
command: underline
underline: -
ok 48
ok 49
New
----------
1178084388
1178084418
1178084388
1178084388
1178084388
1178084388
1178084388
1178084388
1178084388
Page Number: 0
[9 rows of 1 fields returned]
Elapsed: 0 wallclock secs ( 0.03 usr + 0.00 sys = 0.03 CPU) @ 33.33/s (n=1)
ok 50
column ctime format:
column_format a10
format <<<<<<<<<<
heading New Heading
length 10
on 1
type char
ok 51
format cleared
ok 52
ctime
----------
1178084388
1178084418
1178084388
1178084388
1178084388
1178084388
1178084388
1178084388
1178084388
Page Number: 0
[9 rows of 1 fields returned]
Elapsed: 0 wallclock secs ( 0.03 usr + 0.00 sys = 0.03 CPU) @ 33.33/s (n=1)
ok 53
command: underline
underline: -
ok 54
ok 55
Underline test -
--------------------
1178084388
1178084418
1178084388
1178084388
1178084388
1178084388
1178084388
1178084388
1178084388
Page Number: 0
[9 rows of 1 fields returned]
Elapsed: 1 wallclock secs ( 0.04 usr + 0.00 sys = 0.04 CPU) @ 25.00/s (n=1)
ok 56
command: underline
underline: null
ok 57 - Turn underline off
ok 58
Underline test off
1178084388
1178084418
1178084388
1178084388
1178084388
1178084388
1178084388
1178084388
1178084388
Page Number: 0
[9 rows of 1 fields returned]
Elapsed: 0 wallclock secs ( 0.03 usr + 0.00 sys = 0.03 CPU) @ 33.33/s (n=1)
ok 59
command: underline
underline: on
ok 60
ok 61
Underline test on
ononononononononono-
1178084388
1178084418
1178084388
1178084388
1178084388
1178084388
1178084388
1178084388
1178084388
Page Number: 0
[9 rows of 1 fields returned]
Elapsed: 0 wallclock secs ( 0.03 usr + 0.00 sys = 0.03 CPU) @ 33.33/s (n=1)
ok 62
ok 63
ok 64
ok 65
ok 66
ok 67
ok 68
invalid justification o
ok 69
invalid justification on
ok 70
invalid justification yuck
ok 71
ok 72
invalid justification irhgt
ok 73
ok 74
ok 75
ctime
column_format a20
format >>>>>>>>>>>>>>>>>>>>
heading Justify test j r
justify r
length 20
on 1
type char
ok 76
format cleared
ok 77
command: underline
underline: -
ok 78
command: heading
heading: null
ok 79 - Turn heading off
command: heading
heading: on
ok 80
ok 81
Justify left
--------------------
1178084388
1178084418
1178084388
1178084388
1178084388
1178084388
1178084388
1178084388
1178084388
Page Number: 0
[9 rows of 1 fields returned]
Elapsed: 0 wallclock secs ( 0.01 usr + 0.01 sys = 0.02 CPU) @ 50.00/s (n=1)
ok 82
ctime
column_format a20
format <<<<<<<<<<<<<<<<<<<<
heading Justify left
justify l
length 20
on 1
type char
ok 83
ok 84
Justify right
--------------------
1178084388
1178084418
1178084388
1178084388
1178084388
1178084388
1178084388
1178084388
1178084388
Page Number: 0
[9 rows of 1 fields returned]
Elapsed: 0 wallclock secs ( 0.03 usr + 0.00 sys = 0.03 CPU) @ 33.33/s (n=1)
ok 85
ctime
column_format a20
format >>>>>>>>>>>>>>>>>>>>
heading Justify right
justify r
length 20
on 1
type char
ok 86
ok 87
Justify center
--------------------
1178084388
1178084418
1178084388
1178084388
1178084388
1178084388
1178084388
1178084388
1178084388
Page Number: 0
[9 rows of 1 fields returned]
Elapsed: 0 wallclock secs ( 0.02 usr + 0.01 sys = 0.03 CPU) @ 33.33/s (n=1)
ok 88
ctime
column_format a20
format ^^^^^^^^^^^^^^^^^^^^
heading Justify center
justify c
length 20
on 1
type char
ok 89
ok 90
Justify off
--------------------
1178084388
1178084418
1178084388
1178084388
1178084388
1178084388
1178084388
1178084388
1178084388
Page Number: 0
[9 rows of 1 fields returned]
Elapsed: 0 wallclock secs ( 0.03 usr + 0.00 sys = 0.03 CPU) @ 33.33/s (n=1)
ok 91
ctime
column_format a20
format <<<<<<<<<<<<<<<<<<<<
heading Justify off
length 20
on 1
type char
ok 92
ctime
column_format a20
format <<<<<<<<<<<<<<<<<<<<
heading Justify off
length 20
on 1
type char
ok 93
format cleared
ok 94
command: null
null: 'stuff'
ok 95 - Null value text tests
command: null
null: 'null
ok 96
command: null
null: ""
ok 97
command: null
null: &localtime()
ok 98
command: null
null: null
ok 99 - set null off
command: pagesize
pagesize: null
ok 100 - pagesize off
command: pagesize
pagesize: 10
ok 101 - set pagesize 10
command: pagesize
pagesize: 10
ok 102 - is pagesize 10
command: limit
limit: null
ok 103 - row limit undef
command: limit
limit: 100
ok 104 - set row limit 100
command: limit
limit: 100
ok 105 - row limit is 100
command: limit
limit: null
ok 106 - row limit is off
DBD::ExampleP::db prepare failed: Unknown field names: yuck_error.
Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU)
ok 107
last dbi error : 1
last dbi error string : Unknown field names: yuck_error
last dbi error state : S1000
ok 108
Disconnecting from dbi:ExampleP:.
ok 109 - Disconnect from source.
ok
t/timing............1..77
ok 1 - use DBI::Shell;
DBI::Shell 11.93 using DBI 1.48 in batch mode
commandline history written to /export/home/cpanrun/.dbish_history
ok 2 - Create shell instance
Connecting to 'dbi:ExampleP:' as ''...
ok 3 - Connecting to dbi:ExampleP:
Current statement buffer:
select name from t where name = 'timing.t'
ok 4 - Loading test file: testtiming.sql
name
'.'
'..'
'batch.t'
'core.t'
'func.t'
'shell.t'
'spool.t'
'sqlminus.t'
'timing.t'
[9 rows of 1 fields returned]
Elapsed: 0 wallclock secs ( 0.01 usr + 0.00 sys = 0.01 CPU) @ 100.00/s (n=1)
ok 5 - Execute loaded statement
ok 6 - Change output format to neat
timing: off
ok 7 - Turn timing OFF
timing: off
ok 8 - Timing is OFF
select name from t where name = 'timing.t'
ok 9 - Get the last statement executed
name
'.'
'..'
'batch.t'
'core.t'
'func.t'
'shell.t'
'spool.t'
'sqlminus.t'
'timing.t'
[9 rows of 1 fields returned]
ok 10 - Execute statement in buffer
timing: on
ok 11 - Turn timing ON
timing: on
ok 12 - Timing is ON
select name from t where name = 'timing.t'
ok 13 - Get the last statement executed
name
'.'
'..'
'batch.t'
'core.t'
'func.t'
'shell.t'
'spool.t'
'sqlminus.t'
'timing.t'
[9 rows of 1 fields returned]
Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU)
ok 14 - Execute statement in buffer
timing: on
ok 15 - Display timing status
select name from t where name = 'timing.t'
ok 16 - Get the last statement executed
name
'.'
'..'
'batch.t'
'core.t'
'func.t'
'shell.t'
'spool.t'
'sqlminus.t'
'timing.t'
[9 rows of 1 fields returned]
Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU)
ok 17 - Execute statement in buffer
/option timing_timing=1
ok 18 - Check options: timing_timing
ok 19 - Check options: timing_timing=1
ok 20 - Check options: timing_timing=0
timing: off
ok 21 - Timing is OFF
ok 22 - Check options: timing_timing=1
timing: on
ok 23 - Timing is ON
timing: off
ok 24 - Turn timing OFF
timing: off
ok 25 - Test timing is OFF
timing: on
ok 26 - Turn timing ON
timing: on
ok 27 - Test timing is ON
timing: off
ok 28 - Turn timing stop
timing: off
ok 29 - Test timing is OFF
timing: on
ok 30 - Turn timing start
timing: on
ok 31 - Test timing is ON
timing: off
ok 32 - Turn timing end
timing: off
ok 33 - Test timing is OFF
timing: on
ok 34 - Turn timing begin
timing: on
ok 35 - Test timing is ON
/option timing_style=auto
ok 36 - Current timing style options: timing_style
ok 37 - Current timing style options: timing_style=bad
select name from t where name = 'timing.t'
ok 38 - Get the last statement executed
name
'.'
'..'
'batch.t'
'core.t'
'func.t'
'shell.t'
'spool.t'
'sqlminus.t'
'timing.t'
[9 rows of 1 fields returned]
Elapsed: 0 0 0 0 0 1 bad
ok 39 - Execute statement in buffer
ok 40 - Current timing style options: timing_style=auto
select name from t where name = 'timing.t'
ok 41 - Get the last statement executed
name
'.'
'..'
'batch.t'
'core.t'
'func.t'
'shell.t'
'spool.t'
'sqlminus.t'
'timing.t'
[9 rows of 1 fields returned]
Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU)
ok 42 - Execute statement in buffer
ok 43 - Current timing style options: timing_style=noc
select name from t where name = 'timing.t'
ok 44 - Get the last statement executed
name
'.'
'..'
'batch.t'
'core.t'
'func.t'
'shell.t'
'spool.t'
'sqlminus.t'
'timing.t'
[9 rows of 1 fields returned]
Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU)
ok 45 - Execute statement in buffer
ok 46 - Current timing style options: timing_style=nop
select name from t where name = 'timing.t'
ok 47 - Get the last statement executed
name
'.'
'..'
'batch.t'
'core.t'
'func.t'
'shell.t'
'spool.t'
'sqlminus.t'
'timing.t'
[9 rows of 1 fields returned]
Elapsed: 0 wallclock secs ( 0.00 cusr + 0.00 csys = 0.00 CPU)
ok 48 - Execute statement in buffer
ok 49 - Current timing style options: timing_style=none
select name from t where name = 'timing.t'
ok 50 - Get the last statement executed
name
'.'
'..'
'batch.t'
'core.t'
'func.t'
'shell.t'
'spool.t'
'sqlminus.t'
'timing.t'
Elapsed: 0 0 0 0 0 1 none
[9 rows of 1 fields returned]
ok 51 - Execute statement in buffer
ok 52 - Current timing style options: timing_style=all
select name from t where name = 'timing.t'
ok 53 - Get the last statement executed
name
'.'
'..'
'batch.t'
'core.t'
'func.t'
'shell.t'
'spool.t'
'sqlminus.t'
'timing.t'
[9 rows of 1 fields returned]
Elapsed: 0 wallclock secs ( 0.00 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
ok 54 - Execute statement in buffer
/option timing_format=5.2f
ok 55 - Current timing format options: timing_format
ok 56 - Current timing style options: timing_style=5.2f
select name from t where name = 'timing.t'
ok 57 - Get the last statement executed
name
'.'
'..'
'batch.t'
'core.t'
'func.t'
'shell.t'
'spool.t'
'sqlminus.t'
'timing.t'
[9 rows of 1 fields returned]
Elapsed: 0 wallclock secs ( 0.00 usr 0.01 sys + 0.00 cusr 0.00 csys = 0.01 CPU) @ 100.00/s (n=1)
ok 58 - Execute statement in buffer
ok 59 - Current timing style options: timing_style=5.5f
select name from t where name = 'timing.t'
ok 60 - Get the last statement executed
name
'.'
'..'
'batch.t'
'core.t'
'func.t'
'shell.t'
'spool.t'
'sqlminus.t'
'timing.t'
[9 rows of 1 fields returned]
Elapsed: 0 wallclock secs (0.00000 usr 0.00000 sys + 0.00000 cusr 0.00000 csys = 0.00000 CPU)
ok 61 - Execute statement in buffer
ok 62 - Current timing style options: timing_style=5d
select name from t where name = 'timing.t'
ok 63 - Get the last statement executed
name
'.'
'..'
'batch.t'
'core.t'
'func.t'
'shell.t'
'spool.t'
'sqlminus.t'
'timing.t'
[9 rows of 1 fields returned]
Elapsed: 0 wallclock secs ( 0 usr 0 sys + 0 cusr 0 csys = 0 CPU) @ 99/s (n=1)
ok 64 - Execute statement in buffer
ok 65 - Current timing style options: timing_style=1s
select name from t where name = 'timing.t'
ok 66 - Get the last statement executed
name
'.'
'..'
'batch.t'
'core.t'
'func.t'
'shell.t'
'spool.t'
'sqlminus.t'
'timing.t'
[9 rows of 1 fields returned]
Elapsed: 0 wallclock secs (0 usr 0.01 sys + 0 cusr 0 csys = 0.01 CPU) @ 99.9999999999999/s (n=1)
ok 67 - Execute statement in buffer
ok 68 - Resetting current timing_format=5.2f
/option timing_prefix=Elapsed:
ok 69 - Current timing prefix options: timing_prefix, Default
ok 70 - Current timing prefix options: timing_prefix="Timing: "
ok 71 - Current timing prefix options: timing_prefix=\"Timing: \"
ok 72 - Current timing prefix options: timing_prefix="Timing: "
ok 73 - Current timing prefix options: timing_prefix=Timing:
ok 74 - Current timing prefix options: timing_prefix=Timing:
ok 75 - Current timing prefix options: timing_prefix='undef'
/option timing_prefix='undef'
ok 76 - Current timing prefix options: timing_prefix, undefined
Disconnecting from dbi:ExampleP:.
ok 77 - Disconnect from source.
ok
All tests successful, 1 test skipped.
Files=7, Tests=261, 22 wallclock secs ( 9.85 cusr + 1.60 csys = 11.45 CPU)
Installing /export/home/cpanrun/build/5.6.1/lib/site_perl/5.6.1/DBI/Shell.pm
Installing /export/home/cpanrun/build/5.6.1/lib/site_perl/5.6.1/DBI/Format.pm
Installing /export/home/cpanrun/build/5.6.1/lib/site_perl/5.6.1/DBI/Format/SQLMinus.pm
Installing /export/home/cpanrun/build/5.6.1/lib/site_perl/5.6.1/DBI/Shell/FindSqlFile.pm
Installing /export/home/cpanrun/build/5.6.1/lib/site_perl/5.6.1/DBI/Shell/SQLMinus.pm
Installing /export/home/cpanrun/build/5.6.1/lib/site_perl/5.6.1/DBI/Shell/Completion.pm
Installing /export/home/cpanrun/build/5.6.1/lib/site_perl/5.6.1/DBI/Shell/Timing.pm
Installing /export/home/cpanrun/build/5.6.1/lib/site_perl/5.6.1/DBI/Shell/Spool.pm
Installing /export/home/cpanrun/build/5.6.1/man/man1/dbish.1
Installing /export/home/cpanrun/build/5.6.1/man/man3/DBI::Shell.3
Installing /export/home/cpanrun/build/5.6.1/man/man3/DBI::Format.3
Installing /export/home/cpanrun/build/5.6.1/man/man3/DBI::Format::SQLMinus.3
Installing /export/home/cpanrun/build/5.6.1/bin/dbish
Appending installation info to /export/home/cpanrun/build/5.6.1/lib/5.6.1/sun4-solaris-thread-multi/perllocal.pod