[Dbix-class] Announce SQL-Translator 0.0900

Jess Robinson castaway at desert-island.me.uk
Mon Feb 25 13:05:23 GMT 2008


This involves major changes to the way sqlt-diff and it's dependencies 
work. Many props to the DBIx::Class team for helping out with this.

All tests that we have/had continue to pass. However since not all 
functionality was completely covered by tests (i.e. some DB-specific 
diffing like Oracle/SQL-Server), these may now be broken.

If you find breakages or incompatibilities with previous versions, please 
provide tests so that we can fix them.

Jess

Changes since 0.08:

* Fix Pg produces idea of which field types need a size param
* Add support for COLLATE table option to MySQL parser
* Allow DEFAULT CHARACTER SET without '=' (as produced by mysqldump)

# -----------------------------------------------------------
# 0.0899_02 2008-01-29
# ----------------------------------------------------------

* Major refactoring of SQL::Translator::Diff again:
* Diff is no longer one huge monolithic function.
* Added more tests for diff
* When producing diffs for MySQL you will (by default) get single alter 
statements per table
* SQLite can also do remove columns (by creating a temp table as shown in 
http://sqlite.org/faq.html#q11
* Columns can be renamed if the new schema is from a form that can have 
metadata (which is pretty much anything but an SQL file.) It does this by 
looking at renamed_from in the $field->extra
* Updated Oracle and Postgres producers
* More tests!

# -----------------------------------------------------------
# 0.0899_01 2007-10-21
# ----------------------------------------------------------

* SQL::Translator::Diff now uses the ::Producer modules to create diffs
   This *will* break back-compatibility
   Use sqlt-diff-old for the previous one, and fix producers!

# -----------------------------------------------------------
# 0.08001 2007-09-26
# ----------------------------------------------------------

* Patched to ignore all TT versions >= 2.15 until TT is fixed :(





More information about the DBIx-Class mailing list