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

Changes for version 0.89

  • ENHANCEMENTS:
  • Improved schema diffs for Postgres, particularly in the area of comparing two columns. Now we attempt to determine if two columns are logically equivalent, even if they might have minor variations (INT vs INTEGER type name, 'f' versus 'false' for BOOLEAN default, etc.).
  • Added Alzabo::SQLMaker->distinct_requires_order_by_in_select for the benefit of Pg, which requires that anything in the ORDER BY clause show up in the SELECT when you SELECT DISTINCT. This change is experimental, and may go away in future versions.
  • Removed support for passing order_by and group_by as a hash reference. This was deprecated in 0.59.
  • BUG FIXES:
  • When reverse engineering a Postgres schema, Alzabo did not look for its own sequences to determine if a column should be marked as sequenced.
  • Defer FK creation until all other DDL has been executed. This ensures that the table to which we're referring will be available.
  • When recreating a table during a SQL diff, make this an exception so we don't do other column diff/add/drop operations on the same table.
  • Fixed a test failure in 07-methodmaker.t when testing with Postgres. This failure may not have showed up often because it came from a test that depended on the DBMS returning rows in a speific order by without specifying an ORDER BY.
  • When a Postgres table is renamed, its sequences are also renamed.

Documentation

Alzabo::Design
Documentation on Alzabo's design
Alzabo::FAQ
Frequently Asked Questions
Alzabo::Intro
Introductory information about Alzabo
Alzabo::MySQL
Alzabo and MySQL
Alzabo::PostgreSQL
Alzabo and PostgreSQL
Alzabo::QuickRef
A quick reference to methods in the Alzabo classes
edit_field_checkbox
edit_field_text_input
edit_field_textarea
fk_to_one_select
insert
insert_or_update
update

Modules

Alzabo
A data modelling tool and RDBMS-OO mapper
Alzabo::BackCompat
Convert old data structures
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::Debug
Creates constants used to turn on debugging
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::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::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::InsertHandle
A handle representing an insert
Alzabo::Runtime::JoinCursor
Cursor that returns arrays of Alzabo::Runtime::Row objects
Alzabo::Runtime::Row
Row objects
Alzabo::Runtime::RowCursor
Cursor that returns Alzabo::Runtime::Row objects
Alzabo::Runtime::RowState::Deleted
Row objects that have been deleted
Alzabo::Runtime::RowState::InCache
Cached row objects that represent actual database rows
Alzabo::Runtime::RowState::Live
Row objects representing rows in the database
Alzabo::Runtime::RowState::Potential
Row objects that are not in the database
Alzabo::Runtime::Schema
Schema objects
Alzabo::Runtime::Table
Table objects
Alzabo::Runtime::UniqueRowCache
Implements a row cache for Alzabo
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

Provides

Alzabo::Docs
in lib/Alzabo/MethodMaker.pm
Alzabo::DocumentationContainer
in lib/Alzabo/MethodMaker.pm
Alzabo::DriverStatement
in lib/Alzabo/Driver.pm
Alzabo::Exception
in lib/Alzabo/Exceptions.pm
Alzabo::Exception::Driver
in lib/Alzabo/Exceptions.pm
Alzabo::MethodDocs
in lib/Alzabo/MethodMaker.pm
Alzabo::SQLMaker::Function
in lib/Alzabo/SQLMaker.pm

Examples

Other files