The London Perl and Raku Workshop takes place on 26th Oct 2024. If your company depends on Perl, please consider sponsoring and/or attending.

NAME

Data::PrintUtils - A Collection of Pretty Print routines like Data::Dumper

VERSION

Version 0.03

SYNOPSIS

Provides a collection of pretty print routines

PURPOSE

This module is meant to provide some Data::Dumper like print routines tailored to DBI style tables and hashes along with some debug options

EXPORT

print_pid say_pid formatList formatOneLineHash formatHash formatTable pivotTable tableJoin $USE_PIDS $USE_TIME

SUBROUTINES/METHODS

A replacement for print that will optionally prepend the processID and the timestamp to a line

These two fields are turned off/on with the package variables:

    $Data::PrintUtils::USE_PIDS = 1 or 0;
    $Data::PrintUtils::USE_TIME = 1 or 0;
    

say_pid

A replacement for say that will optionally prepend the processID and the timestamp to a line

These two fields are turned off/on with the package variables:

    $Data::PrintUtils::USE_PIDS = 1 or 0;
    $Data::PrintUtils::USE_TIME = 1 or 0;
    

formatList

Formats a list as a single line of comma seperated values in '(' ')'

An optional hash may be passed as the first argument to configure the following: LIST_START => "(", # The String denoting the start of the list LIST_END => ")", # The String denoting the end of the list ELEMENT_SEPARATOR => ", ", # The String seperating elements of the list

Note that these means that the unadorned list may not start with a hash ref :(

formatOneLineHash

Formats a hash as a single line of => and comma separated values in '{' '}'

The hash to be printed is passed as a reference in the first parameter The rest of the arguments are parsed as options in Getopt::CommandLineExports format: PRIMARY_KEY_ORDER => undef, # ordering for the has keys (undef means undefined perl ordering) HASH_START => "{", # String denoting the start of the hash HASH_END => "}", # String denoting the end of the hash ELEMENT_SEPARATOR => ", ", # String seperating the key/value pairs of the hash KEY_VALUE_SEPARATOR => " => ",# String seperating the keys and the values of the hash UNDEF_VALUE => "undef", # String to print if the value of the hash is undefined or if the key does not exist, but does in the PRIMARY_KEY_ORDER NOTEXIST_VALUE => "notExist", # String to print if the key does not exist, but does in the PRIMARY_KEY_ORDER

formatHash

Formats a Hash with one level deep expansion Each key/value pair is a single line that may be justified right or left for prettiness

formatTable

Formats a table (given as an array of hash references (as returned from DBI) ) into a somewhat pleasant display. With the Columns argument, you can chose to only print a subset of the columns (and you can define the column ordering).

ROWS This is a reference to the table (which should be an array of hashes refs)
COLUMNS This is a list of columns (in order) to be displayed
UNDEF_VALUE This is a string value to be displayed whenever an item is "undefined"

pivotTable

pivots an attribute-value table (given as an array of hash references (as returned from DBI) ) into a new table with a row for each unique PIVOT_KEY and a column for each attribute

example: my @table = ( {COL1 => 1, Name => 'PID', VALUE => '1a', XTRA1 => '111'}, {COL1 => 1, Name => 'SID', VALUE => 's1', XTRA1 => '112'}, {COL1 => 1, Name => 'XV1', VALUE => 'YY', XTRA1 => '116'}, {COL1 => 1, Name => 'XV2', VALUE => 'XX', XTRA1 => '117'},

{COL1 => 2, Name => 'PID', VALUE => '2a', XTRA1 => '221'}, {COL1 => 2, Name => 'SID', VALUE => 's2', XTRA1 => '222'}, {COL1 => 2, Name => 'XV2', VALUE => 'XX2', XTRA1 => '224'}, ); my @newTable1 = pivotTable { ROWS => \@table, PIVOT_KEY => 'COL1', VALUE_HEADER_KEY=> 'Name', VALUE_KEY => 'VALUE'}; say formatTable { ROWS => \@newTable1, UNDEF_VALUE => 'NULL'} if @newTable1;

results in COL1 PID SID XV1 XV2 1 1a s1 YY XX 2 2a s2 NULL XX2

joinTable

creates a new table that is either the simple equijoin of the left and right table, or, if LEFT_JOIN_KEY_UNIQUE is set, then Joins the Right Table to the Left Table (all rows of the left table are included

AUTHOR

Robert Haxton, <robert.haxton at gmail.com>

BUGS

Please report any bugs or feature requests to bug-Data-printutils at rt.cpan.org, or through the web interface at http://rt.cpan.org/NoAuth/ReportBug.html?Queue=Data-PrintUtils. I will be notified, and then you'll automatically be notified of progress on your bug as I make changes.

SUPPORT

You can find documentation for this module with the perldoc command.

    perldoc Data::PrintUtils

You can also look for information at:

ACKNOWLEDGEMENTS

LICENSE AND COPYRIGHT

Copyright 2008-2011 Robert Haxton.

This program is free software; you can redistribute it and/or modify it under the terms of either: the GNU General Public License as published by the Free Software Foundation; or the Artistic License.

See http://dev.perl.org/licenses/ for more information.