Changelog

1.3.5 (2008-12-19)

Ported getFieldsThroughGetters(), setFieldsThroughSetters(), and test cases from A.S. branch.
Updated copyright information.

Fixed bug 297308: “hasKeyId returns wrong value.”
Added ability to set SQL select options on As_SelectQuery objects (e.g. SQL_CALC_FOUND_ROWS, SQL_NO_CACHE).
Added SQL needed to create test database and user in tests/database_config.inc.php.

Added As_Database::getUniqueQueryLog().
Added CoughDatabaseFactory::getUniqueDatabases().
Added CoughObject::isFieldModified(). Don’t access the modifiedFields array directly anymore; use isFieldModified() instead.
Changed CoughObject::setFieldsIfDifferent() so that it only sets fields that actually belong to the object (by checking fieldDefinitions and derivedFieldDefinitions first).
Changed Autoloader so that saving of newly found classes is postponed until the script ends. This keeps it from writing to the disk inefficiently on the first page view or anytime a number of new classes have been introduced.
Added Autoloader unit test cases.

Fixed launchpad bug #262475. Test cases added.
Changed: As_Query throws an Exception when quoting is needed but no DB object was passed during __construct.
Added helper method CoughObject::buildSelectQuery(), see phpDoc block.

Added: Can now specify client_flags parameter when using the “as” database adapter (default). See http://php.net/mysql_connect
Added: PHP5 strict compatibility
Added: Support for VIEWs (and any other table without a primary key).
Added: As_DatabaseResult::getRows() (returns all rows found as an array of arrays).
Added: CoughDatabaseFactory::getDatabase() now supports an optional second parameter of a database name to select before returning the object.
Added: Unit test cases are now included in the download (remove the “tests” directory if you want to save space, ~400K).
Changed: Calling CoughDatabaseFactory::getDatabase('db_alias') with an invalid alias now throws a verbose exception instead of returning null.
Changed: Re-ordered CoughObject’s attributes so that data shows up before definitions. Readability of print_r() output and similar functions is thus improved.

Changed the code generator: Generated SQL now uses the static methods getDbName() and getTableName() so that the static $dbName and $tableName member variables can be overridden in concrete classes without also having to override all the generated getLoadSql() and load*_Collection() functions.
Added support for environment specific database names. See the installation instructions in the CoughPHP handbook.

Added “Debugging Queries” documentation.
Added: When logging queries, the database that each query is run on is also logged.
Added As_Database::getError() to the database object.
Cleaned up phpdocs in CoughCollection.

Fixed As_Database::insertMultiple() – it did not work, but isn’t used internally by Cough anyway.
Enhanced CoughObject::getFieldAliases() so that the table name to SELECT from can be specified; this is needed when aliasing the tables in the FROM clause.
Changed As_Query so that it throws an Exception when there is no database object (instead of hitting a PHP Fatal Error).

Changed the code generator: completely overhauled with re-usable components and advanced configuration possibilities.
Changed the way objects are constructed: now use only static/factory methods to construct objects (This allows the appropriate sub-class to be constructed).
Added ability to use any database abstraction layer (DAL), such as PDO.
Bug fixes.

First public release after a year in production use on enterprise e-commerce websites and on our own personal projects.