Path to this page:
Subject: CVS commit: pkgsrc/databases/p5-SQL-Translator
From: Jens Rehsack
Date: 2009-06-15 21:44:04
Message id: 20090615194404.9D8A5175D0@cvs.netbsd.org
Log Message:
pkgsrc changes:
- Updating package of p5 module SQL::Translator from 0.09004 to 0.09006
- Setting license to gnu-gpl-v2
- Adjusting dependencies according to Makefile.PL
Upstream changes:
# ----------------------------------------------------------
# 0.09006 2009-06-10
# ----------------------------------------------------------
* Multiple test and dependency adhustments to make smokers happy
* Fix YAML producer wrt extra attribute
* Added support for "time(stamp) (p) with time zone" for Pg producer (mo)
# ----------------------------------------------------------
# 0.09005 2009-06-08
# ----------------------------------------------------------
* Add parser support for MySQL default values with a single quote
* Properly quote absolute table names in the MySQL producer
* Added semi-colon for (DROP|CREATE) TYPE statements in the Pg producer (wreis)
* Added CREATE VIEW subrules for mysql parser (wreis)
* ALTER TABLE/ALTER COLUMN/DROP DEFAULT support in Pg producer (mo)
* XML parser support for multi-event triggers
* SQLite producer support for multi-event triggers
* XML parser switched from XML::XPath to XML::LibXML
* Pg producer ALTER TABLE/COLUMN and DROP DEFAULT support
* MySQL producer skips length attribute for columns which do not support that
attribute. Currently following column types are added to that list:
date time timestamp datetime year
* Switch to Module::Install (mandates minimum perl 5.005)
* Major cleanup of GraphViz proucer
* Massive amount of fixes to SQLite/Pg/Mysql/MSSQL parsers/producers
Fix most of the problems uncovered by the roundtrip test framework
Some highlights:
- Rewind exhausted globs before attempting a read
- Do not add xml comment header if no_comments is set
- table/field counts are held per schema object, not globally
- no more variable table and column names in SQLite and MSSQL
- VIEW support for Pg parser, also some cleanups
- The way we generate Pg create view statements was not standards compliant
(per RhodiumToad in #postgresql)
- Disable MSSQL view/procedure production - they never worked in the first place
- SQLite/MSSQL improvements:
- Support parsing of all DROP clauses
- Support parsing of field-level comments
- When producing do not append table names to constraint/index names
Files: