Test::Diff_DBI Module to compare SQL result sets
Provides an easy method for detailed (or summarized) source vs target comparison SQL. The source and target can be on any two databases as long as DBI connection is possible. Results sets are batched using the DBI fetchall_arrayref routine's batching feature. This both avoids memory problems and ensures diff output results are shown and test run terminated as soon as differences are discovered.
This is useful for automated detailed functional testing of large volume data integration/migration applications. The actual comparison is done by the Test::Differences module.
The module can be accompanied by a CLI driver utility script to supply command line arguments for eg run-time database changes and single entity comparisons
Is this OK? Or should a sample driver script just be included in the documentation?
Assumes the DBI database connection info is stored in environment variables of the form:
__DIFFDBI__DB__DSN __DIFFDBI__DB__USER __DIFFDBI__DB__PASSWORD
where DB is going to be replaced with the DB key in the test case .yml file.
Strings of the form
[< SOME_TEXT >]
are replaced with their values in the TAGS.yml file. This supports re-usable SQL, to embed for example a subselect returning the current business period, thereby making test cases time-invariant
SQL can be divided into distinct SELECT statements separated by semi-colons to enable the use of intermediate temp tables. The last SQL statement is expected to provide the source result set that will be compared to the target.
No::OrgNr A Perl module for validating Norwegian organizations' ID numbers
This is a small module, containing a single function "orgnr_ok".
All feedback are welcome, as this is my first CPAN module.
Should the No:: namespace be used for modules related to Norwegian? We already have the related modules No::KontoNr and No::PersonNr.
IO::File_Functions A perl module for File I/O, Locking and Other Operations
A perl module for File I/O, Locking and Other Operations. Includes the followiing functions..
@EXPORT = qw(file_errors &file_appended &file_new &file_open &file_open_rw &file_close &file_slurp &file_write); @EXPORT_OK = qw(&file_lock &file_unlock &file_append &file2hash &hash2file);
Image::Libpuzzle XS interface to the libpuzzle image signature library
It's my first XS module. Please don't be gentle. I created it because there is a PHP interface for libpuzzle but not, surprisingly, a Perl one.
This XS module provdes access to the most common functionality provided by Libpuzzle, http://www.pureftpd.org/project/libpuzzle.
It also includes some pure Perl helper methods users of Libpuzzle might find helpful when creating applications based on it.
Image::Libpuzzle now on CPAN with a very low version number.
Sys::Stats Multi-platform, pure perl, system statistics gathering.
As the saying goes : "If it's not monitored, it doesn't exist."
At $dayjob, I have to make sure that several servers work properly. Even if it's mostly Linux boxes, I would categorized this as a heterogeneous environment : various Linux distributions, and for each various versions, some with a compiler tool suite, some without, some with root access, some without.
And I have to make sure that all of them run smoothly.
There are many modules on CPAN already to achieve this task, but they either focus on one type of statistics (load average, or disk usage, or network traffic), or require some exotic compiled libraries, or are just too complicated for my taste.
Hence, this module : I tried to gather the statistics that I need the most, group them under one dead simple API regardless of the system underneath, and push it on Github.
I plan to add more systems (Mac OSX would be a nice addition), and add a few more stats.
Flexnet::lmutil Convenient OO-interface for Flexnet license server utility lmutil
Flexnet::lmutil is a small wrapper around the Flexnet license server utility lmutil, currently implementing the sub-functions lmstat and lmremove. The module parses the output of lmstat and returns an easy-to-use data structure. This makes it easy to work further with lmstat output for e.g. web pages, monitoring plugins etc.
Locale-India Code for state and union territory identification in the India and vice versa.
This module is used for state and union territory identification in the India and vice versa. It uses ISO 3166-2 defined codes for identifying the principal subdivisions (e.g., provinces or states) of all countries coded in ISO 3166-1.
AnyEvent::Hbase Async HBase thrift API
Internally it's wrapper around Hbase thrift library. API is the same, so you can easily migrate without breaking compatibility and use async calls only where you need it. Original generated Hbase thrift modules is included in this package too.