[X] The "/OldFiles" file could not be found or is not available. Please select another file.

Database and csv files comparison tool, with some additional features of nice formatting selects' results.


http://lreport.sourceforge.net





Separate each tag with a space.

Release Date:

2009-06-10

Topic:

Operating System:

License:

Translations:

Intended Audience:

User Interface:

Database Environment:

Programming Language:

Registered:

2004-07-01

Ratings and Reviews

Be the first to post a text review of LReport. Rate and review a project by clicking thumbs up or thumbs down in the right column.

Project Feed

  • Forum comment added

    pkaluski commented on the RE: commas or tabs forum thread

    posted by pkaluski 212 days ago

  • lreport_ppm Stable_0.24 file released: LRpt_stable_0_24_ppm.tar.gz

    **************************************************************** The LReport module is Copyright (c) 2004-2006 Piotr Kaluski. Poland. All rights reserved. You may distribute under the terms of either the GNU General Public License or the Artistic License, as specified in the Perl README file. **************************************************************** Stable_0.0.1 This is the very first release of LReport library. It is marked stable since it passes my unit tests. However, there are many, many things to be done to make the software usable for people not familiar with the code (i.e. everyone except me). To mention the most important todos (as of 03.09.2004): * No CPAN, no PPM package * No end user documentation * No use in production environment. * Probably works only on Windows But I am working on it. Please check lreport.sourceforge.net or www.piotrkaluski.com web sites from time to time to check what's going on. If despite this obstacles, you really want to try this software here are some hints: * After ungziping and untaring you can go to lib subdirectory and run test.pl. All tests (3) should pass * It does use some perl modules, which are not a part of standard perl installation. But all of them are available in ppm format. One warning, based on my personal experience: Active State's repository not always contains the most up to date modules. XML::Simple provided with perl 5.6.0 does not work for well with Test::Harness which is used by test suite. Take the most recent one from CPAN. As for other packages - just run the test and see what does perl complain about. Then download the missing modules. * It is not installing itself in standard place for perl packages. Therefore, in order to use LReport's classes in you scripts, you have to use "use lib" pragma to specify the location of LReport code. Stable_0.2 * Some cleanup * Moved packages names to LRpt namespace so they do not polute the main namespace. Stable_0.3 * Added test case for logging during comparing with expectations. * Fixed bugs related to comparing expected with actual output files Stable_0.4 * The core functionality is finaly implemented. It is tested (although not too thoroughly). I believe it has everything to handle most of real life cases. Stable_0.5 * DiffRpt operates on 2 Report objects instead of on one Report object and a bunch of selects. Stable_0.6 * Fixed some moderate problems: * Tables with not equal expected rows do not have right border. * Report object can't be created using report definition file and a key structure (not file) Stable_0.7 * Using RTF::Writer for creation of RTF documents * Made the module CPAN and ppm compatible. Stable_0.8 * Not using xml files for defining "where" keys. Stable_0.9 * Columns in reported unmatched rows are listed in the order of columns in the database. Stable_0.11 * Fixed bug "[1105088] Columns sorting does not work for unkeyed rows". * Improved columns coloring and underlining in reporting differences between actual data and expectations: * When reporting "not equal" rows, whenever possible, column coloring is retained. * When reporting unmatched rows columns are printed in the order in which they are in the database. Secondly columns coloring is retained (taken from the report layout definition file). Thirdly, when reporting unmatched rows, LReport is looking for the closest match. Fields, which make expectations not match to the closest match, are bolded, italics and doubly underlined. Stable_0.12 * Got rid of Config and DBSource modules. They are almost not used. Secondly, they are better respective modules available, which do the same. * Started working on POD documentation of pm files. Stable_0.13 * All modules have PODs so the ppm package contains documentation. It is far from being clear, though :-( Stable_0.14 * MAJOR MODULE's REDESIGN: * LReport operates mainly on csv files * Fine print reporting removed from perl code and moved to xslt scripts * Better documentation is in place. Stable_0.15 * MAJOR MODULE's REDESIGN continued: * LReport operates only on csv files * Chunking implemented * lcsvdump.pl and lks.pl are now good citizens and they input from standard input or from files given in command line (like diamond operator) Stable_0.16 * TUNNING: * Done some refactoring in order to improve performance. There is still some space for improvement. Collection::build_one_key should be better tuned, rows should be stored in lists rather then in hashes * Command line switches and environment variables * Handling of the most important command line switches and environment variables is implemented. * Still some minor configurability to be done * BUG fixes * 1544069 - Change sign make diff output look cluttered - --#> used now. * Features * 1544070 - Diff should not pick unecessary files - only files with proper extension are used * Note: Documentation needs some refinements to reflect changes Stable_0.17 * DOCUMENTATION * Added tutorial and updated documentation in general * Updated usage screens for lks, lcsvdiff, lcsvdmp, lrptxml. * Enforced sorting of input files * If files are not sorted or key is not unique, key in question is reported. Stable_0.18 * Added comparison of data taken directly from databases Stable_0.19 * Added handling of uncontrolled key columns. I use this name for columns which are populated automaticaly by database server (sequencial id column). In case we compare 2 databases, these columns may differ for rows which are logically equivalent. Stable_0.20 * Numeric columns of keys are now of unlimited length * XMLReport escapes all characters it should * Data retrieval loop changed in CSVDumper. It is now more easy to understand and works with new version of DBI and DBD::CSV Stable_0.21 * Collection objects use arrays instead of hashes. This change was supposed to improve performance. But no improvement has been observed ;) * Some bug fixes in expected-actual comparison Stable_0.22 * Tests run successfully on linux. Stable_0.23 * Expectations can be loaded from csv files * Fix for bug 1874454 "lcsveadiff.pl does not allow to specify single file" added (not tested too carefully though) Stable_0.24 * Separator in csv files is no longer hardcoded to tab * File information is stored in empty collections (used for comparison) with expectations

    posted 212 days ago

  • lreport Stable_0.24 file released: LRpt_stable_0_24.tar.gz

    **************************************************************** The LReport module is Copyright (c) 2004-2006 Piotr Kaluski. Poland. All rights reserved. You may distribute under the terms of either the GNU General Public License or the Artistic License, as specified in the Perl README file. **************************************************************** Stable_0.0.1 This is the very first release of LReport library. It is marked stable since it passes my unit tests. However, there are many, many things to be done to make the software usable for people not familiar with the code (i.e. everyone except me). To mention the most important todos (as of 03.09.2004): * No CPAN, no PPM package * No end user documentation * No use in production environment. * Probably works only on Windows But I am working on it. Please check lreport.sourceforge.net or www.piotrkaluski.com web sites from time to time to check what's going on. If despite this obstacles, you really want to try this software here are some hints: * After ungziping and untaring you can go to lib subdirectory and run test.pl. All tests (3) should pass * It does use some perl modules, which are not a part of standard perl installation. But all of them are available in ppm format. One warning, based on my personal experience: Active State's repository not always contains the most up to date modules. XML::Simple provided with perl 5.6.0 does not work for well with Test::Harness which is used by test suite. Take the most recent one from CPAN. As for other packages - just run the test and see what does perl complain about. Then download the missing modules. * It is not installing itself in standard place for perl packages. Therefore, in order to use LReport's classes in you scripts, you have to use "use lib" pragma to specify the location of LReport code. Stable_0.2 * Some cleanup * Moved packages names to LRpt namespace so they do not polute the main namespace. Stable_0.3 * Added test case for logging during comparing with expectations. * Fixed bugs related to comparing expected with actual output files Stable_0.4 * The core functionality is finaly implemented. It is tested (although not too thoroughly). I believe it has everything to handle most of real life cases. Stable_0.5 * DiffRpt operates on 2 Report objects instead of on one Report object and a bunch of selects. Stable_0.6 * Fixed some moderate problems: * Tables with not equal expected rows do not have right border. * Report object can't be created using report definition file and a key structure (not file) Stable_0.7 * Using RTF::Writer for creation of RTF documents * Made the module CPAN and ppm compatible. Stable_0.8 * Not using xml files for defining "where" keys. Stable_0.9 * Columns in reported unmatched rows are listed in the order of columns in the database. Stable_0.11 * Fixed bug "[1105088] Columns sorting does not work for unkeyed rows". * Improved columns coloring and underlining in reporting differences between actual data and expectations: * When reporting "not equal" rows, whenever possible, column coloring is retained. * When reporting unmatched rows columns are printed in the order in which they are in the database. Secondly columns coloring is retained (taken from the report layout definition file). Thirdly, when reporting unmatched rows, LReport is looking for the closest match. Fields, which make expectations not match to the closest match, are bolded, italics and doubly underlined. Stable_0.12 * Got rid of Config and DBSource modules. They are almost not used. Secondly, they are better respective modules available, which do the same. * Started working on POD documentation of pm files. Stable_0.13 * All modules have PODs so the ppm package contains documentation. It is far from being clear, though :-( Stable_0.14 * MAJOR MODULE's REDESIGN: * LReport operates mainly on csv files * Fine print reporting removed from perl code and moved to xslt scripts * Better documentation is in place. Stable_0.15 * MAJOR MODULE's REDESIGN continued: * LReport operates only on csv files * Chunking implemented * lcsvdump.pl and lks.pl are now good citizens and they input from standard input or from files given in command line (like diamond operator) Stable_0.16 * TUNNING: * Done some refactoring in order to improve performance. There is still some space for improvement. Collection::build_one_key should be better tuned, rows should be stored in lists rather then in hashes * Command line switches and environment variables * Handling of the most important command line switches and environment variables is implemented. * Still some minor configurability to be done * BUG fixes * 1544069 - Change sign make diff output look cluttered - --#> used now. * Features * 1544070 - Diff should not pick unecessary files - only files with proper extension are used * Note: Documentation needs some refinements to reflect changes Stable_0.17 * DOCUMENTATION * Added tutorial and updated documentation in general * Updated usage screens for lks, lcsvdiff, lcsvdmp, lrptxml. * Enforced sorting of input files * If files are not sorted or key is not unique, key in question is reported. Stable_0.18 * Added comparison of data taken directly from databases Stable_0.19 * Added handling of uncontrolled key columns. I use this name for columns which are populated automaticaly by database server (sequencial id column). In case we compare 2 databases, these columns may differ for rows which are logically equivalent. Stable_0.20 * Numeric columns of keys are now of unlimited length * XMLReport escapes all characters it should * Data retrieval loop changed in CSVDumper. It is now more easy to understand and works with new version of DBI and DBD::CSV Stable_0.21 * Collection objects use arrays instead of hashes. This change was supposed to improve performance. But no improvement has been observed ;) * Some bug fixes in expected-actual comparison Stable_0.22 * Tests run successfully on linux. Stable_0.23 * Expectations can be loaded from csv files * Fix for bug 1874454 "lcsveadiff.pl does not allow to specify single file" added (not tested too carefully though) Stable_0.24 * Separator in csv files is no longer hardcoded to tab * File information is stored in empty collections (used for comparison) with expectations

    posted 212 days ago

  • File released: /lreport_ppm/Stable_0.24/LRpt_stable_0_24_ppm.tar.gz

    posted 212 days ago

  • File released: /lreport/Stable_0.24/LRpt_stable_0_24.tar.gz

    posted 212 days ago

  • Code committed

    pkaluski committed patchset 136 of module LRpt to the LReport CVS repository, changing 3 files

    posted by pkaluski 212 days ago

  • Code committed

    pkaluski committed patchset 135 of module LRpt to the LReport CVS repository, changing 10 files

    posted by pkaluski 212 days ago

  • Forum comment added

    pkaluski commented on the RE: commas or tabs forum thread

    posted by pkaluski 212 days ago

  • Forum comment added

    pkaluski commented on the RE: tests all fail forum thread

    posted by pkaluski 212 days ago

  • Forum thread added

    alexmc created the commas or tabs forum thread

    posted by alexmc 212 days ago

Rate and Review

Be the first person to add a text review.

Would you recommend this project?






<

Related Projects

Thanks for your rating!

Would you also like to write a review?





Skip Review

Thanks for your review!

Get credit for your review by logging in via OpenID. Click your account provider:

No Thanks