Changes for version 0.11021_01 - 2015-10-29

  • Add support for monotonically increasing SQLite autoincs (GH#47)
  • Add support for CHECK constraint in SQLite producer (GH#57)
  • Add support for CHECK constraint in POD producer (GH#63)
  • Fix forgotten quoting in the MySQL DROP TABLE diff producer (GH#50)
  • Fix Pg grammar parsing of UUID, time, timetz columns (RT#100196, GH#52)
  • Add support for USING and WHERE on indexes in PostgreSQL producer and parser (RT#63814, GH#52)
  • Improve add_trigger consistency between producers (GH#48)
  • Declare dependencies in deterministic order (RT#102859)
  • Multiple speedups of naive internal debugging mechanism (GH#54)
  • Remove dependency on List::MoreUtils ( http://is.gd/lmu_cac_debacle )
  • Fix parsing of strings with leading whitespace for MySQL, Oracle, PostgreSQL, SQLServer and SQLite
  • Fix parsing of MySQL column comments (RT#83380)
  • Fix multi-line comments in YAML, JSON and PostgreSQL producers
  • Fix identifier quoting in PostgreSQL diff producer
  • Fix missing semicolons between PostGIS statements
  • Fix string and identifier quoting in PostGIS statements

Documentation

sqlfairy user manual
convert SQL schema using SQL::Translator
Automatically create a diagram from a database schema
find the differences b/w two schemas
find the differences b/w two schemas
create a dumper script from a schema
Automatically create a graph from a database schema

Modules

manipulate structured data definitions (SQL and more)
determine differences between two schemas
Set default extra data values for schema objects.
Add global fields and indices to all tables.
Tweak the names of schema objects.
A Moo based MySQL DDL generation engine.
A Moo based PostgreSQL DDL generation engine.
A Moo based MS SQL Server DDL generation engine.
A Moo based SQLite DDL generation engine.
Role implementing common parts of DDL generation.
Role for dealing with identifier quoting.
describes how to write a parser
parser for Access as produced by mdbtools
"parser" for DBI handles
parser for DBD::DB2
parser for DBD::mysql
parser for DBD::Oracle
parser for SQL Server through DBD::ODBC
parser for DBD::SQLite
parser for DBD::Sybase
Parse a JSON representation of a schema
parser for PostgreSQL
parser for SQL Server
parser for Schema objects serialized with the Storable module
Alias to XML::SQLFairy parser
parser for SQL::Translator's XML.
Parse a YAML representation of a schema
parser for arbitrarily delimited text files
describes how to write a producer
create Class::DBI classes from schema
ER diagram producer for SQL::Translator
SQL Dumper producer for SQL::Translator
GraphViz producer for SQL::Translator
HTML producer for SQL::Translator
A JSON producer for SQL::Translator
MySQL-specific producer for SQL::Translator
Oracle SQL producer
POD producer for SQL::Translator
PostgreSQL producer for SQL::Translator
MS SQLServer producer for SQL::Translator
SQLite producer for SQL::Translator
serializes the SQL::Translator::Schema object via the Storable module
Sybase producer for SQL::Translator
TT (Template Toolkit) based Producer base class.
Alias to XML::SQLFairy producer
SQLFairy's default XML format
A YAML producer for SQL::Translator
Remove undefined constructor arguments
Error setter/getter for objects and classes
context-sensitive list attributes
SQL::Translator schema object
SQL::Translator constraint object
SQL::Translator field object
SQL::Translator index object
Base class for SQL::Translator schema objects
SQL::Translator procedure object
"extra" attribute for schema classes
SQL::Translator table object
SQL::Translator trigger object
SQL::Translator view object
Type checking functions
SQL::Translator Utility functions
Test::More test functions for the Schema objects.

Provides

in lib/SQL/Translator/Parser/DB2/Grammar.pm
in lib/SQL/Translator/Parser/DB2/Grammar.pm
in lib/SQL/Translator/Role/Debug.pm
in lib/SQL/Translator/Utils.pm