[svn:p5ee] r9424 - p5ee/trunk/App-Repository

Author: spadkins
Date: Tue Apr 17 05:19:58 2007
New Revision: 9424

Modified:
   p5ee/trunk/App-Repository/CHANGES
   p5ee/trunk/App-Repository/MANIFEST
   p5ee/trunk/App-Repository/Makefile.PL
   p5ee/trunk/App-Repository/TODO

Log:
prepare for release 0.965

Modified: p5ee/trunk/App-Repository/CHANGES
==============================================================================
--- p5ee/trunk/App-Repository/CHANGES	(original)
+++ p5ee/trunk/App-Repository/CHANGES	Tue Apr 17 05:19:58 2007
@@ -3,12 +3,21 @@
 #########################################
 
 0.965
+ x can now configure multiple databases (App::Repository::DBI) from app.conf (xyz.dbhost, xyz.dbname, ... for rep "xyz")
+ x full redirection to other tables or other tables in other repositories is done
+ x added dbsocket as a parameter which App::Repository::DBI automatically picks up from app.conf
+ x added dbioptions to the list of things App::Repository::MySQL takes into account in building its dsn
+ x use $dbh->quote() to quote values instead of doing it half-way correctly
  x add App::Repository::summarize_rows() (with extended summaries, ros->get_summary(), ros->get_ext_summary())
  x add bin/dbget --totals and --subtotal_columns options
  x fix App::RepositoryObjectSet->set_params() to not clear cache if %$params are identical
  x fix App::RepositoryObjectDomain->get_object_set() to call $object_set->set_params() 
    instead of update_params() if a %$params subset has not been explicitly defined.
+ x added an implementation of insert_rows() for App::Repository::MySQL which uses multiple-row inserts
+ x worked on import_rows() to use insert_rows() if ($options->{import_method} eq "insert")
+ x enhance summarize_rows() to do extended summaries (count, distinct, min, max, average, mode, median, stddev)
  x add call_procedure() method
+ x finalized transaction support with begin_work(), commit(), rollback() (added t/DBI-transaction.t test case)
 
 0.964
  x add bin/dbget

Modified: p5ee/trunk/App-Repository/MANIFEST
==============================================================================
--- p5ee/trunk/App-Repository/MANIFEST	(original)
+++ p5ee/trunk/App-Repository/MANIFEST	Tue Apr 17 05:19:58 2007
@@ -15,10 +15,12 @@
 t/DBI-connect.t
 t/DBI-delete.t
 t/DBI-getset.t
+t/DBI-import.t
 t/DBI-insert.t
 t/DBI-metadata.t
 t/DBI-repobjects.t
 t/DBI-repobjectset.t
 t/DBI-select.t
 t/DBI-update.t
+t/files/DBI-import.01.dat
 META.yml                                 Module meta-data (added by MakeMaker)

Modified: p5ee/trunk/App-Repository/Makefile.PL
==============================================================================
--- p5ee/trunk/App-Repository/Makefile.PL	(original)
+++ p5ee/trunk/App-Repository/Makefile.PL	Tue Apr 17 05:19:58 2007
@@ -14,7 +14,7 @@
 %opts = (
     'NAME'        => 'App-Repository',
     'DISTNAME'    => 'App-Repository',
-    'VERSION'     => '0.964',
+    'VERSION'     => '0.965',
     'EXE_FILES'   => [ @programs ],
     'PREREQ_PM'   => {
                        'App::Options' => 0,  # core services

Modified: p5ee/trunk/App-Repository/TODO
==============================================================================
--- p5ee/trunk/App-Repository/TODO	(original)
+++ p5ee/trunk/App-Repository/TODO	Tue Apr 17 05:19:58 2007
@@ -11,13 +11,16 @@
  o get it to run against Oracle
  o create a metadata-producer utility
  o remove dependence on DBIx::Compat (remove from Makefile.PL)
+ o upgrade the metadata logic to use the latest DBI routines (rather than DBIx::Compat)
+ o add group_by and order_by to dbget
 
 Other stuff
+ o implement high(er) availability, load balancing, read/write database handles
  o caching rows by key
  o caching row-sets by set-key
  o DBI      - refactored/unified params/cols/values handling
             - arbitrarily complex where clauses
- o auto-history (audit trail)
+ o auto-history (audit trail) on a table
 
  o DBI    - auto-reconnect on all operations
  o DBI    - bind variables on all operations