From: Dave Rolsky <autarch@ur...> - 2004-06-09 23:01:50
0.83 June 9, 2003
- I got fed up with the instability of CVS on Sourceforge, and am now
using a Subversion repository I host myself. See "source" page on
http://www.alzabo.org for details.
- All SQL-generating methods for the Alzabo::Runtime::Schema and
Alzabo::Runtime::Table classes now accept a "quote_identifiers"
parameter, which allows you to turn this on for a single query.
- Improved handling of MySQL's "default defaults" when reverse
engineering or comparing two schemas, so that the code doesn't
generate ALTER TABLE statements that don't do anything.
- Make many Params::Validate specs into constants, which may improve
speed a bit, and may affect memory usage under mod_perl. This is
probably a useless micro-optimization, though.
- Make sure generated SQL for Postgres schema diffs does not include
dropping & adding the same FK constraint more than once.
- Reverse engineering works with Postgres 7.4. Thanks to Josh Jore
for this big patch. Hopefully this won't break anything for Postgres
- The Alzabo::Column->is_time_interval method was misspelled, and so
did not work at all. Patch from Josh Jore.
- With Postgres 7.4, the DBI tables method always includes system
tables, so we have to filter these out in the
Alzabo::Driver::PostgreSQL->tables method. Patch from Josh Jore.
- Make the is_date & is_datetime method consistent across various
databases. For Postgres, is_date was only returning true for the DATE
type, not TIMESTAMP.
- Make is_datetime return true for Postgres' TIMESTAMPTZ column
- Turning on SQL debugging could cause Alzabo to alter bound values
that were null to the string "NULL" before performing a query.
- If a table name was changed and an index, column, or foreign key
dropped from that table, then the generated "diff" SQL could refer to
the old table name in the various DROP statements that were generated.
- Workaround a bug in MySQL that reports a "Sub_part" of 1 for
- The changes introduced in 0.71 to track table and column renames
could cause bogus SQL to be generated if something was renamed, the
schema was instantiated, and then the schema was compared to an
existing live database which also had the same renaming done to it.
- If you tried to create a relationship between two tables where one
of the tables had a varchar or char column as part of its PK, and you
let Alzabo create the foreign key column in the other table, then
Alzabo would try to set the length of the varchar/char column to
undef, which would cause an exception to be thrown.
House Absolute Consulting
From: Scott Lanning <lannings@wh...> - 2004-06-10 12:04:15
On Wed, 9 Jun 2004, Dave Rolsky wrote:
> - I got fed up with the instability of CVS on Sourceforge, and am now
> using a Subversion repository I host myself. See "source" page on
> http://www.alzabo.org for details.
Speaking of this, is the procedure for building from
a Subversion checkout available somewhere? For example,
I think you have to do something to create the META.yml file
(./Build distmeta, I'd guess), as well as other things.
For me, 0.83 still fails tests:
Failed Test Stat Wstat Total Fail Failed List of Failed
t/04-rev_engineer.t 1 256 2 1 50.00% 2
t/17-insert-handle.t 2 512 25 50 200.00% 1-25
t/98-schema_diff.t 1 256 13 1 7.69% 13
Failed 3/17 test scripts, 82.35% okay. 27/930 subtests failed, 97.10% okay.
How does it fail 50 out of 25 tests? :)
A little bug report on the webpage: http://alzabo.org/source.mhtml
The link to svn doesn't work (gives an Internal Server Error).
I eventually figured out that it should be (I think)