Top Level :: Database

Package Information: MDB2_Schema 0.7.0

Show All Changelogs
» Version » Information
0.8.2 2008-02-23     beta
0.8.1 2007-08-30     beta
0.8.0 2007-08-20     beta
0.7.2 2007-04-07     beta
0.7.1 2007-02-21     beta
0.7.0Download

Release date: 2006-10-21 21:23 UTC
Release state: beta

Changelog:

- Improved INSERT support, added UPDATE and DELETE statements
- XML syntax redesigned to cover DML addictions
- Creation of an explicit NULL (<null></null>)
- various fixes to the DTD, including DML addictions
- XSD schema definition created
- Tests also output php version
- New example parse.php lets you check how a XML schema is stored
- Updated schema.xml to demo the DML support
- Documentation reformulated, also covering new XML syntax
- Improved demo script example.php, which now includes more actions and options
- Writer is returning an error when fopen() fails
- Writer has now its own error code
- Variable "seq" became "sequence" and "seq_name" became "sequence_name" in the
Parser
- Moved validation code out of the Parser into a new separate class called
Validation
- Fixed index handling in the Parser
- Refactored error handling in the Parser
- Removed variable "init_field", that wasn't being used, from the Parser
- Parser simulates only one level of recurssion, which means no more than
function-expression or vice-versa
- Fixed warning due to not checking with isset() in the Parser
- Fixed warning due to not checking with isset() in the Schema
- Typo fix (related to Bug #9024)
- Fixed createDatabase() that was trying to use a non-existant database that
was about to be created
- Simplified API for compareTableFieldsDefinitions() and
compareTableIndexesDefinitions()
- Rewritten some docblocks
- Added fold markers where missing
- Removed @static from non static methods
- Fixed several PEAR CS issues
- Added code for field/identifier quoting
- Ensure all identifiers are passed to quoteIdentifier() (Bug #8429)

open todo items:
- Make MDB2_Schema loadable via MDB2_Driver_Common::loadModule() (Bug #8270)
- Add ability to define variables inside the schema (like a version number)
- Allow simple if statements that mean that anything enclosed is only executed
if it meets certain criterias based on that version number (or some other
variable). This would enable people to add DML statements that are only
executed when updating from a specific version.
- Add support for recursive tag parsing. Currently only expression<->function
is supported but not expression-expression or function-function, although
recursion is already supported by the initializeTable() method
- Parser should be replaced for XML serializer ?
- Modularize Writer code or remake it
- Add specific error codes for Validate class
- Add support for ORDER clauses on UPDATEs (to resolve the duplicate key
problem)
- Update description.schema.xml
- Document how to use the API
- Create unit test for comparedefinitions()
- Create unit test for initializetable()
- Create unit test to compare the expected array definition with what is parsed
- HTML entities aren't being parsed correctly
- Add optional support for scale in decimal fields
- Implement "WHERE column IS NULL"
- Add ability to parse a "contents-only" XML dump

Dependencies:
  • PHP Version: PHP 4.2.0 or newer
  • PEAR Package: PEAR Installer 1.0b1 or newer
  • PEAR Package: XML_Parser
  • PEAR Package: MDB2 2.2.0 or newer
  • PEAR Package: XML_DTD (optional)
0.6.0 2006-07-23     beta
0.5.0 2006-04-16     beta
0.4.3 2006-02-05     beta
0.4.2 2006-01-14     beta
0.4.1 2005-12-30     beta
0.4.0 2005-12-21     beta
0.3.0 2005-10-10     beta
0.2.0 2005-04-29     beta
0.1.0 2005-04-07     beta