cpan SQL-Translator 0.09005

latest releases: 1.65, 1.64, 1.63...
14 years ago
  • Add parser support for MySQL default values with a single quote
  • Properly quote absolute table names in the MySQL producer
  • Added CREATE VIEW subrules for mysql parser (wreis)
  • Many fixes to code and tests for trigger's "database_events"
  • Added semi-colon for (DROP|CREATE) TYPE statements in the Pg producer (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

Don't miss a new SQL-Translator release

NewReleases is sending notifications on new releases.