The Perl Toolchain Summit needs more sponsors. If your company depends on Perl, please support this very important event.
 / 
Alzabo-0.61
River stage one • 2 direct dependents • 3 total dependents
++

Changes for version 0.61

  • ENHANCEMENTS:
  • Improve documentation for new Alzabo::Create::Schema->sync_backend method and note its caveats.
  • It is now possible to use SQL functions as part of order_by clauses. For example:
    • my $cursor = $schema->select( select => [ COUNT('*'), $id_col ], tables => [ $foo_tab, $bar_tab ], group_by => $id_col, order_by => [ COUNT('*'), 'DESC' ] );
  • Allow a call to Alzabo::Runtime::Table->insert without a values parameter. This is potentially useful for tables where the primary key is sequenced and the other columns have defaults or are NULLable. Patch by Ilya Martynov.
  • BUG FIXES:
  • A call to the schema class's select or function methods that had both an order_by and group_by parameter would fail because it tried to process the order by clause before the group by clause.
  • When thawing potential row objects, Alzabo was trying to stick them into the cache, which may have worked before but not now, and should be avoided anyway.
  • The parent and children methods created by Alzabo::MethodMaker were incorrect (and unfortunately the tests of this feature were hosed too).
  • Add YEAR as exportable function from Alzabo::SQLMaker::MySQL.
  • Fix definition of WEEK and YEARWEEK functions exported from Alzabo::SQLMaker::MySQL to accept 1 or 2 parameters.
  • A bug in the caching code was throwing an exception when attempting to update objects that weren't expired. This only seemed to occur in conjuction with the prefetch functionality. The caching code has been simplified a bit and is hopefully now bug-free (I can dream, can't I?).
  • Make it possible to call Alzabo::Runtime::Schema->join with only one table in the tables parameter. This is useful if you are constructing your join at runtime and you don't know how many tables you'll end up with.
  • Where clauses that began with '(' were not working. Reported (with a test suite patch) by Ilya Martynov.
  • Where clauses that contained something like ( ')', 'and' (or 'or') ) were not working either.
  • This file incorrectly thanked TJ Mather for separating out Class::Factory::Util, but this was done by Terrence Brannon. Oops, brain fart.
  • Improve the recognition of more defaults that MySQL uses for column lengths and defaults, in order to improve reverse engineering.
  • Recognize defaults like 0 or '' for MySQL.
  • Fix Alzabo::Create::Schema->sync_backend method.

Documentation

Alzabo::FAQ
Frequently Asked Questions
Alzabo
Alzabo
Alzabo::QuickRef
A quick reference to methods in the Alzabo classes

Modules

Alzabo
A data modelling tool and RDBMS-OO mapper
Alzabo::ChangeTracker
Saves a set of changes as callbacks that can be backed out if needed
Alzabo::Column
Column objects
Alzabo::ColumnDefinition
Holds the type attribute for a column
Alzabo::Create
Loads all Alzabo::Create::* classes
Alzabo::Create::Column
Column objects for use in schema creation
Alzabo::Create::ColumnDefinition
Column definition object for schema creation
Alzabo::Create::ForeignKey
Foreign key objects for schema creation.
Alzabo::Create::Index
Index objects for schema creation
Alzabo::Create::Schema
Schema objects for schema creation
Alzabo::Create::Table
Table objects for schema creation
Alzabo::Driver
Alzabo base class for RDBMS drivers
Alzabo::Driver::MySQL
MySQL specific Alzabo driver subclass
Alzabo::Driver::PostgreSQL
PostgreSQL specific Alzabo driver subclass
Alzabo::Exceptions
Creates all exception subclasses used in Alzabo.
Alzabo::ForeignKey
Foreign key (relation) objects
Alzabo::Index
Index objects
Alzabo::MethodMaker
Auto-generate useful methods based on an existing schema
Alzabo::ObjectCache
A simple in-memory cache for row objects.
Alzabo::ObjectCache::Store::BerkeleyDB
Cache objects in a BerkeleyDB file
Alzabo::ObjectCache::Store::LRU
Make any storage module an LRU
Alzabo::ObjectCache::Store::Memory
Cache objects in memory
Alzabo::ObjectCache::Store::Null
Doesn't really store anything
Alzabo::ObjectCache::Store::RDBMS
Cache objects in an RDBMS backend
Alzabo::ObjectCache::Sync
Base class for syncing classes
Alzabo::ObjectCache::Sync::BerkeleyDB
Uses a DBM file to sync object caches
Alzabo::ObjectCache::Sync::DBM
Base class for syncing modules that use DBM files
Alzabo::ObjectCache::Sync::DB_File
Uses a Berkeley DB file to sync object caches
Alzabo::ObjectCache::Sync::IPC
Uses a IPC file to sync object caches
Alzabo::ObjectCache::Sync::Null
No inter-process cache syncing
Alzabo::ObjectCache::Sync::RDBMS
Uses an RDBM backend to sync object caches
Alzabo::ObjectCache::Sync::SDBM_File
Uses an SDBM file to sync object caches
Alzabo::RDBMSRules
Base class for Alzabo RDBMS rulesets
Alzabo::RDBMSRules::MySQL
MySQL specific database rules.
Alzabo::RDBMSRules::PostgreSQL
PostgreSQL specific database rules
Alzabo::Runtime
Loads all Alzabo::Runtime::* classes
Alzabo::Runtime::CachedRow
Cached row objects
Alzabo::Runtime::Column
Column objects
Alzabo::Runtime::ColumnDefinition
Column definition objects
Alzabo::Runtime::Cursor
Base class for Alzabo cursors
Alzabo::Runtime::ForeignKey
Foreign key objects
Alzabo::Runtime::Index
Index objects
Alzabo::Runtime::JoinCursor
Cursor that returns arrays of Alzabo::Runtime::Row objects
Alzabo::Runtime::OuterJoinCursor
Cursor that returns arrays of Alzabo::Runtime::Row objects or undef
Alzabo::Runtime::PotentialRow
Row objects that aren't yet in the database
Alzabo::Runtime::Row
Row objects
Alzabo::Runtime::RowCursor
Cursor that returns Alzabo::Runtime::Row objects
Alzabo::Runtime::Schema
Schema objects
Alzabo::Runtime::Table
Table objects
Alzabo::SQLMaker
Alzabo base class for RDBMS drivers
Alzabo::SQLMaker::MySQL
Alzabo SQL making class for MySQL
Alzabo::SQLMaker::PostgreSQL
Alzabo SQL making class for PostgreSQL
Alzabo::Schema
Schema objects
Alzabo::Table
Table objects
Alzabo::Config
Alzabo configuration information

Provides

Alzabo::DriverStatement
in lib/Alzabo/Driver.pm
Alzabo::Exception::Driver
in lib/Alzabo/Exceptions.pm
Alzabo::SQLMaker::Literal
in lib/Alzabo/SQLMaker.pm

Examples

Other files