Changes for version 0.11017 - 2013-10-30
- Apply quotes to fix tables that are reserved words, DBI::SQLServer (Jonathan C. Otsuka)
- Add DECIMAL_DIGITS to field size for scale info, DBI::SQLServer (Jonathan C. Otsuka)
- De-linkify XML namespace in docs (RT#81838)
- Allow both single and double quotes for values in MySQL parser
- Fix diff for altering two things per column - add ; at the end
- Call all diff methods in list context (it can be merged later)
- Fix Pg diff issue with drop constraint on primary keys
- SQLite support for SET NULL, SET DEFAULT and NO ACTION in FK clauses
- Clean up properly after Parser::DBI::PostgreSQL tests
- Fix typos in error messages
- Add SQL_TINYINT and SQL_BIGINT to the type map in SQL::Translator::Schema::Field
- Add JSON parser and producer (Jon Jensen)
- Clean up TTSchema doc some (Gavin Shelley)
- Fix AUTOINCREMENT in SQLite (Rafael Porres Molina)
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 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 DB2
"parser" for DBI handles
parser for DBD::DB2
parser for DBD::mysql
parser for DBD::Oracle
parser for DBD::Pg
parser for SQL Server through DBD::ODBC
parser for DBD::SQLite
parser for DBD::Sybase
parser for Excel
Parse a JSON representation of a schema
parser for MySQL
parser for Oracle
parser for PostgreSQL
parser for SQL Server
parser for SQLite
parser for Schema objects serialized with the Storable module
parser for Sybase
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
DB2 SQL producer
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
constants module
SQL::Translator constraint object
SQL::Translator field object
SQL::Translator index object
Base class for SQL::Translator schema objects
SQL::Translator procedure object
compare objects
"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