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
/home/cpanrun/build/5.6.1/bin/perl -Iblib/arch -Iblib/lib -I/home/cpanrun/build/5.6.1/lib/5.6.1/i686-linux-thread-multi -I/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
/home/cpanrun/build/5.6.1/bin/perl -I/home/cpanrun/build/5.6.1/lib/5.6.1/i686-linux-thread-multi -I/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 /home/cpanrun/build/5.6.1/bin/perl -Iblib/arch -Iblib/lib -I/home/cpanrun/build/5.6.1/lib/5.6.1/i686-linux-thread-multi -I/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: /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: dbish32373.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,959499,8,1178075559,8522,1178075559,17919,4096,1021,4096,2057,'.',1178075572,1021
5,1350302,8,1178075565,18714,1178075565,17919,4096,1021,4096,2057,'..',1178075572,1021
1,959500,8,1178075559,1828,1035774529,33261,4096,1021,687,2057,'batch.t',1178075569,1021
1,959501,8,1178075559,18873,1035774529,33261,4096,1021,1044,2057,'core.t',1178075569,1021
1,959502,16,1178075559,18802,1035864543,33261,4096,1021,6828,2057,'func.t',1178075570,1021
1,959505,8,1178075559,12810,1039823183,33261,4096,1021,2856,2057,'shell.t',1178075571,1021
1,962084,8,1178075559,14132,1039823183,33261,4096,1021,1562,2057,'spool.t',1039823183,1021
1,962085,32,1178075559,19136,1038334172,33261,4096,1021,14681,2057,'sqlminus.t',1038334172,1021
1,962086,16,1178075559,1012,1035774529,33261,4096,1021,4960,2057,'timing.t',1035774529,1021
[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,959499,8,1178075559,8522,1178075559,17919,4096,1021,4096,2057,'.',1178075572,1021
5,1350302,8,1178075565,18714,1178075565,17919,4096,1021,4096,2057,'..',1178075572,1021
1,959500,8,1178075559,1828,1035774529,33261,4096,1021,687,2057,'batch.t',1178075569,1021
1,959501,8,1178075559,18873,1035774529,33261,4096,1021,1044,2057,'core.t',1178075569,1021
1,959502,16,1178075559,18802,1035864543,33261,4096,1021,6828,2057,'func.t',1178075570,1021
1,959505,8,1178075559,12810,1039823183,33261,4096,1021,2856,2057,'shell.t',1178075571,1021
1,962084,8,1178075559,14132,1039823183,33261,4096,1021,1562,2057,'spool.t',1039823183,1021
1,962085,32,1178075559,19136,1038334172,33261,4096,1021,14681,2057,'sqlminus.t',1038334172,1021
1,962086,16,1178075559,1012,1035774529,33261,4096,1021,4960,2057,'timing.t',1035774529,1021
[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,959499,8,1178075559,8522,1178075559,17919,4096,1021,4096,2057,'.',1178075572,1021
5,1350302,8,1178075565,18714,1178075565,17919,4096,1021,4096,2057,'..',1178075572,1021
1,959500,8,1178075559,1828,1035774529,33261,4096,1021,687,2057,'batch.t',1178075569,1021
1,959501,8,1178075559,18873,1035774529,33261,4096,1021,1044,2057,'core.t',1178075569,1021
1,959502,16,1178075559,18802,1035864543,33261,4096,1021,6828,2057,'func.t',1178075570,1021
1,959505,8,1178075559,12810,1039823183,33261,4096,1021,2856,2057,'shell.t',1178075571,1021
1,962084,8,1178075559,14132,1039823183,33261,4096,1021,1562,2057,'spool.t',1039823183,1021
1,962085,32,1178075559,19136,1038334172,33261,4096,1021,14681,2057,'sqlminus.t',1038334172,1021
1,962086,16,1178075559,1012,1035774529,33261,4096,1021,4960,2057,'timing.t',1035774529,1021
[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,959499,8,1178075559,8522,1178075559,17919,4096,1021,4096,2057,'.',1178075572,1021
5,1350302,8,1178075572,18714,1178075572,17919,4096,1021,4096,2057,'..',1178075572,1021
1,959500,8,1178075559,1828,1035774529,33261,4096,1021,687,2057,'batch.t',1178075569,1021
1,959501,8,1178075559,18873,1035774529,33261,4096,1021,1044,2057,'core.t',1178075569,1021
1,959502,16,1178075559,18802,1035864543,33261,4096,1021,6828,2057,'func.t',1178075570,1021
1,959505,8,1178075559,12810,1039823183,33261,4096,1021,2856,2057,'shell.t',1178075571,1021
1,962084,8,1178075559,14132,1039823183,33261,4096,1021,1562,2057,'spool.t',1039823183,1021
1,962085,32,1178075559,19136,1038334172,33261,4096,1021,14681,2057,'sqlminus.t',1038334172,1021
1,962086,16,1178075559,1012,1035774529,33261,4096,1021,4960,2057,'timing.t',1035774529,1021
[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,959499,8,1178075559,8522,1178075559,17919,4096,1021,4096,2057,'.',1178075572,1021
5,1350302,8,1178075572,18714,1178075572,17919,4096,1021,4096,2057,'..',1178075572,1021
1,959500,8,1178075559,1828,1035774529,33261,4096,1021,687,2057,'batch.t',1178075569,1021
1,959501,8,1178075559,18873,1035774529,33261,4096,1021,1044,2057,'core.t',1178075569,1021
1,959502,16,1178075559,18802,1035864543,33261,4096,1021,6828,2057,'func.t',1178075570,1021
1,959505,8,1178075559,12810,1039823183,33261,4096,1021,2856,2057,'shell.t',1178075571,1021
1,962084,8,1178075559,14132,1039823183,33261,4096,1021,1562,2057,'spool.t',1039823183,1021
1,962085,32,1178075559,19136,1038334172,33261,4096,1021,14681,2057,'sqlminus.t',1038334172,1021
1,962086,16,1178075559,1012,1035774529,33261,4096,1021,4960,2057,'timing.t',1035774529,1021
[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| 959499| 8|1178075559| 8522|1178075559|17919| 4096|1021| 4096|2057|. |1178075572|1021|
+-----+-------+------+----------+-----+----------+-----+-------+----+-----+----+----------+----------+----+
| 5|1350302| 8|1178075572|18714|1178075572|17919| 4096|1021| 4096|2057|.. |1178075572|1021|
+-----+-------+------+----------+-----+----------+-----+-------+----+-----+----+----------+----------+----+
| 1| 959500| 8|1178075559| 1828|1035774529|33261| 4096|1021| 687|2057|batch.t |1178075569|1021|
+-----+-------+------+----------+-----+----------+-----+-------+----+-----+----+----------+----------+----+
| 1| 959501| 8|1178075559|18873|1035774529|33261| 4096|1021| 1044|2057|core.t |1178075569|1021|
+-----+-------+------+----------+-----+----------+-----+-------+----+-----+----+----------+----------+----+
| 1| 959502| 16|1178075559|18802|1035864543|33261| 4096|1021| 6828|2057|func.t |1178075570|1021|
+-----+-------+------+----------+-----+----------+-----+-------+----+-----+----+----------+----------+----+
| 1| 959505| 8|1178075559|12810|1039823183|33261| 4096|1021| 2856|2057|shell.t |1178075571|1021|
+-----+-------+------+----------+-----+----------+-----+-------+----+-----+----+----------+----------+----+
| 1| 962084| 8|1178075559|14132|1039823183|33261| 4096|1021| 1562|2057|spool.t |1039823183|1021|
+-----+-------+------+----------+-----+----------+-----+-------+----+-----+----+----------+----------+----+
| 1| 962085| 32|1178075559|19136|1038334172|33261| 4096|1021|14681|2057|sqlminus.t|1038334172|1021|
+-----+-------+------+----------+-----+----------+-----+-------+----+-----+----+----------+----------+----+
| 1| 962086| 16|1178075559| 1012|1035774529|33261| 4096|1021| 4960|2057|timing.t |1035774529|1021|
+-----+-------+------+----------+-----+----------+-----+-------+----+-----+----+----------+----------+----+
[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 959499 8 1178075559 8522 1178075559 17919 4096 1021 4096 2057 . 1178075572 1021
5 1350302 8 1178075572 18714 1178075572 17919 4096 1021 4096 2057 .. 1178075572 1021
1 959500 8 1178075559 1828 1035774529 33261 4096 1021 687 2057 batch.t 1178075569 1021
1 959501 8 1178075559 18873 1035774529 33261 4096 1021 1044 2057 core.t 1178075569 1021
1 959502 16 1178075559 18802 1035864543 33261 4096 1021 6828 2057 func.t 1178075570 1021
1 959505 8 1178075559 12810 1039823183 33261 4096 1021 2856 2057 shell.t 1178075571 1021
1 962084 8 1178075559 14132 1039823183 33261 4096 1021 1562 2057 spool.t 1039823183 1021
1 962085 32 1178075559 19136 1038334172 33261 4096 1021 14681 2057 sqlminus.t 1038334172 1021
1 962086 16 1178075559 1012 1035774529 33261 4096 1021 4960 2057 timing.t 1035774529 1021
[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 | 959499 | 8 | 1178075559 | 8522 | 1178075559 | 17919 | 4096 | 1021 | 4096 | 2057 | . | 1178075572 | 1021 |
5 | 1350302 | 8 | 1178075572 | 18714 | 1178075572 | 17919 | 4096 | 1021 | 4096 | 2057 | .. | 1178075572 | 1021 |
1 | 959500 | 8 | 1178075559 | 1828 | 1035774529 | 33261 | 4096 | 1021 | 687 | 2057 | batch.t | 1178075569 | 1021 |
1 | 959501 | 8 | 1178075559 | 18873 | 1035774529 | 33261 | 4096 | 1021 | 1044 | 2057 | core.t | 1178075569 | 1021 |
1 | 959502 | 16 | 1178075559 | 18802 | 1035864543 | 33261 | 4096 | 1021 | 6828 | 2057 | func.t | 1178075570 | 1021 |
1 | 959505 | 8 | 1178075559 | 12810 | 1039823183 | 33261 | 4096 | 1021 | 2856 | 2057 | shell.t | 1178075571 | 1021 |
1 | 962084 | 8 | 1178075559 | 14132 | 1039823183 | 33261 | 4096 | 1021 | 1562 | 2057 | spool.t | 1039823183 | 1021 |
1 | 962085 | 32 | 1178075559 | 19136 | 1038334172 | 33261 | 4096 | 1021 | 14681 | 2057 | sqlminus.t | 1038334172 | 1021 |
1 | 962086 | 16 | 1178075559 | 1012 | 1035774529 | 33261 | 4096 | 1021 | 4960 | 2057 | timing.t | 1035774529 | 1021 |
[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,959499,8,1178075559,8522,1178075559,17919,4096,1021,4096,2057,.,1178075572,1021
5,1350302,8,1178075572,18714,1178075572,17919,4096,1021,4096,2057,..,1178075572,1021
1,959500,8,1178075559,1828,1035774529,33261,4096,1021,687,2057,batch.t,1178075569,1021
1,959501,8,1178075559,18873,1035774529,33261,4096,1021,1044,2057,core.t,1178075569,1021
1,959502,16,1178075559,18802,1035864543,33261,4096,1021,6828,2057,func.t,1178075570,1021
1,959505,8,1178075559,12810,1039823183,33261,4096,1021,2856,2057,shell.t,1178075571,1021
1,962084,8,1178075559,14132,1039823183,33261,4096,1021,1562,2057,spool.t,1039823183,1021
1,962085,32,1178075559,19136,1038334172,33261,4096,1021,14681,2057,sqlminus.t,1038334172,1021
1,962086,16,1178075559,1012,1035774529,33261,4096,1021,4960,2057,timing.t,1035774529,1021
[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,959499,8,1178075559,8522,1178075559,17919,4096,1021,4096,2057,'.',1178075572,1021
5,1350302,8,1178075572,18714,1178075572,17919,4096,1021,4096,2057,'..',1178075572,1021
1,959500,8,1178075559,1828,1035774529,33261,4096,1021,687,2057,'batch.t',1178075569,1021
1,959501,8,1178075559,18873,1035774529,33261,4096,1021,1044,2057,'core.t',1178075569,1021
1,959502,16,1178075559,18802,1035864543,33261,4096,1021,6828,2057,'func.t',1178075570,1021
1,959505,8,1178075559,12810,1039823183,33261,4096,1021,2856,2057,'shell.t',1178075571,1021
1,962084,8,1178075559,14132,1039823183,33261,4096,1021,1562,2057,'spool.t',1039823183,1021
1,962085,32,1178075559,19136,1038334172,33261,4096,1021,14681,2057,'sqlminus.t',1038334172,1021
1,962086,16,1178075559,1012,1035774529,33261,4096,1021,4960,2057,'timing.t',1035774529,1021
[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,959499,8,1178075559,8522,1178075559,17919,4096,1021,4096,2057,'.',1178075572,1021
5,1350302,8,1178075572,18714,1178075572,17919,4096,1021,4096,2057,'..',1178075572,1021
1,959500,8,1178075559,1828,1035774529,33261,4096,1021,687,2057,'batch.t',1178075569,1021
1,959501,8,1178075559,18873,1035774529,33261,4096,1021,1044,2057,'core.t',1178075569,1021
1,959502,16,1178075559,18802,1035864543,33261,4096,1021,6828,2057,'func.t',1178075570,1021
1,959505,8,1178075559,12810,1039823183,33261,4096,1021,2856,2057,'shell.t',1178075571,1021
1,962084,8,1178075559,14132,1039823183,33261,4096,1021,1562,2057,'spool.t',1039823183,1021
1,962085,32,1178075559,19136,1038334172,33261,4096,1021,14681,2057,'sqlminus.t',1038334172,1021
1,962086,16,1178075559,1012,1035774529,33261,4096,1021,4960,2057,'timing.t',1035774529,1021
[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,959499,8,1178075559,8522,1178075559,17919,4096,1021,4096,2057,'.',1178075572,1021
5,1350302,8,1178075572,18714,1178075572,17919,4096,1021,4096,2057,'..',1178075572,1021
1,959500,8,1178075559,1828,1035774529,33261,4096,1021,687,2057,'batch.t',1178075569,1021
1,959501,8,1178075559,18873,1035774529,33261,4096,1021,1044,2057,'core.t',1178075569,1021
1,959502,16,1178075559,18802,1035864543,33261,4096,1021,6828,2057,'func.t',1178075570,1021
1,959505,8,1178075559,12810,1039823183,33261,4096,1021,2856,2057,'shell.t',1178075571,1021
1,962084,8,1178075559,14132,1039823183,33261,4096,1021,1562,2057,'spool.t',1039823183,1021
1,962085,32,1178075559,19136,1038334172,33261,4096,1021,14681,2057,'sqlminus.t',1038334172,1021
1,962086,16,1178075559,1012,1035774529,33261,4096,1021,4960,2057,'timing.t',1035774529,1021
[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 /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,959499,8,1178075559,8522
5,1350302,8,1178075572,18714
1,959500,8,1178075559,1828
1,959501,8,1178075559,18873
1,959502,16,1178075559,18802
1,959505,8,1178075559,12810
1,962084,8,1178075559,14132
1,962085,32,1178075559,19136
1,962086,16,1178075559,1012
[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,959499,8,1178075559,8522
5,1350302,8,1178075573,18714
1,959500,8,1178075559,1828
1,959501,8,1178075559,18873
1,959502,16,1178075559,18802
1,959505,8,1178075559,12810
1,962084,8,1178075559,14132
1,962085,32,1178075559,19136
1,962086,16,1178075559,1012
[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 /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 959499 8 1178075559 8522
5 1350302 8 1178075573 18714
1 959500 8 1178075559 1828
1 959501 8 1178075559 18873
1 959502 16 1178075559 18802
1 959505 8 1178075559 12810
1 962084 8 1178075559 14132
1 962085 32 1178075559 19136
1 962086 16 1178075559 1012
Page Number: 0
[9 rows of 5 fields returned]
Elapsed: 0 wallclock secs ( 0.07 usr + 0.00 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 959499 8 8522
5 1350302 8 1871
1 959500 8 1828
1 959501 8 1887
1 959502 16 1880
1 959505 8 1281
1 962084 8 1413
1 962085 32 1913
1 962086 16 1012
Page Number: 0
[9 rows of 5 fields returned]
Elapsed: 0 wallclock secs ( 0.05 usr + 0.00 sys = 0.05 CPU) @ 20.00/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 959499 8 1178075559 8522
5 1350302 8 1178075573 18714
1 959500 8 1178075559 1828
1 959501 8 1178075559 18873
1 959502 16 1178075559 18802
1 959505 8 1178075559 12810
1 962084 8 1178075559 14132
1 962085 32 1178075559 19136
1 962086 16 1178075559 1012
Page Number: 0
[9 rows of 5 fields returned]
Elapsed: 0 wallclock secs ( 0.07 usr + 0.00 sys = 0.07 CPU) @ 14.29/s (n=1)
ok 24
format cleared
ok 25
ok 26
ok 27
ctime
----------
1178075559
1178075573
1178075559
1178075559
1178075559
1178075559
1178075559
1178075559
1178075559
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 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
----------
1178075559
1178075573
1178075559
1178075559
1178075559
1178075559
1178075559
1178075559
1178075559
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 32
ok 33
ctime
----------
1178075559
1178075573
1178075559
1178075559
1178075559
1178075559
1178075559
1178075559
1178075559
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
----------
1178075559
1178075573
1178075559
1178075559
1178075559
1178075559
1178075559
1178075559
1178075559
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
1178075559
1178075573
1178075559
1178075559
1178075559
1178075559
1178075559
1178075559
1178075559
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
----------
1178075559
1178075573
1178075559
1178075559
1178075559
1178075559
1178075559
1178075559
1178075559
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 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-
1178075559
1178075573
1178075559
1178075559
1178075559
1178075559
1178075559
1178075559
1178075559
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
----------
1178075559
1178075573
1178075559
1178075559
1178075559
1178075559
1178075559
1178075559
1178075559
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
----------
1178075559
1178075573
1178075559
1178075559
1178075559
1178075559
1178075559
1178075559
1178075559
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 -
--------------------
1178075559
1178075573
1178075559
1178075559
1178075559
1178075559
1178075559
1178075559
1178075559
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 56
command: underline
underline: null
ok 57 - Turn underline off
ok 58
Underline test off
1178075559
1178075573
1178075559
1178075559
1178075559
1178075559
1178075559
1178075559
1178075559
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-
1178075559
1178075573
1178075559
1178075559
1178075559
1178075559
1178075559
1178075559
1178075559
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
--------------------
1178075559
1178075573
1178075559
1178075559
1178075559
1178075559
1178075559
1178075559
1178075559
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 82
ctime
column_format a20
format <<<<<<<<<<<<<<<<<<<<
heading Justify left
justify l
length 20
on 1
type char
ok 83
ok 84
Justify right
--------------------
1178075559
1178075573
1178075559
1178075559
1178075559
1178075559
1178075559
1178075559
1178075559
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
--------------------
1178075559
1178075573
1178075559
1178075559
1178075559
1178075559
1178075559
1178075559
1178075559
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 88
ctime
column_format a20
format ^^^^^^^^^^^^^^^^^^^^
heading Justify center
justify c
length 20
on 1
type char
ok 89
ok 90
Justify off
--------------------
1178075559
1178075573
1178075559
1178075559
1178075559
1178075559
1178075559
1178075559
1178075559
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 /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'
[9 rows of 1 fields returned]
Elapsed: 0 0 0 0 0 1 none
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.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
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)
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 sys + 0 cusr 0 csys = 0 CPU)
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, 10 wallclock secs ( 9.42 cusr + 0.46 csys = 9.88 CPU)
Installing /home/cpanrun/build/5.6.1/lib/site_perl/5.6.1/DBI/Shell.pm
Installing /home/cpanrun/build/5.6.1/lib/site_perl/5.6.1/DBI/Format.pm
Installing /home/cpanrun/build/5.6.1/lib/site_perl/5.6.1/DBI/Format/SQLMinus.pm
Installing /home/cpanrun/build/5.6.1/lib/site_perl/5.6.1/DBI/Shell/FindSqlFile.pm
Installing /home/cpanrun/build/5.6.1/lib/site_perl/5.6.1/DBI/Shell/SQLMinus.pm
Installing /home/cpanrun/build/5.6.1/lib/site_perl/5.6.1/DBI/Shell/Completion.pm
Installing /home/cpanrun/build/5.6.1/lib/site_perl/5.6.1/DBI/Shell/Timing.pm
Installing /home/cpanrun/build/5.6.1/lib/site_perl/5.6.1/DBI/Shell/Spool.pm
Installing /home/cpanrun/build/5.6.1/man/man1/dbish.1
Installing /home/cpanrun/build/5.6.1/man/man3/DBI::Shell.3
Installing /home/cpanrun/build/5.6.1/man/man3/DBI::Format.3
Installing /home/cpanrun/build/5.6.1/man/man3/DBI::Format::SQLMinus.3
Installing /home/cpanrun/build/5.6.1/bin/dbish
Appending installation info to /home/cpanrun/build/5.6.1/lib/5.6.1/i686-linux-thread-multi/perllocal.pod