SQL-Translator

Changes for version 1.63 - 2023-02-23

sqlt-diff: Change producer_args to sqlt_args for better self-documentation NOTE - using producer_args will now throw a deprecation warning
FEATURES
A lot of new functionality for the Oracle producer (thanks @hazardv)
Support DB commments in the following producers: PG, JSON, YAML. Also in the sqlite parser (thanks @djerius)
Support INCLUDE on indices for Pg (producer + parser)
Postgres producer now supports materialized views via $extra->{materialized}
FIXES
Postgres producer genrates correct constraint names for schema-namespaced tables
Postgres DBI parser now returns scalarref SQL instead of strings for defaults (thanks @nrdvana)
Postgres producer drops NOT NULL constraints more correctly (thanks @uehara-delta)
binaries now have their perl set by EUMM (thanks @toddr)

Documentation

SQL::Translator::Manual

sqlfairy user manual

sqlt

convert SQL schema using SQL::Translator

sqlt-diagram

Automatically create a diagram from a database schema

sqlt-diff

find the differences b/w two schemas

sqlt-diff

find the differences b/w two schemas

sqlt-dumper

create a dumper script from a schema

sqlt-graph

Automatically create a graph from a database schema

Modules

SQL::Translator

manipulate structured data definitions (SQL and more)

SQL::Translator::Diff

determine differences between two schemas

SQL::Translator::Filter::DefaultExtra

Set default extra data values for schema objects.

SQL::Translator::Filter::Globals

Add global fields and indices to all tables.

SQL::Translator::Filter::Names

Tweak the names of schema objects.

SQL::Translator::Generator::DDL::MySQL

A Moo based MySQL DDL generation engine.

SQL::Translator::Generator::DDL::PostgreSQL

A Moo based PostgreSQL DDL generation engine.

SQL::Translator::Generator::DDL::SQLServer

A Moo based MS SQL Server DDL generation engine.

SQL::Translator::Generator::DDL::SQLite

A Moo based SQLite DDL generation engine.

SQL::Translator::Generator::Role::DDL

Role implementing common parts of DDL generation.

SQL::Translator::Generator::Role::Quote

Role for dealing with identifier quoting.

SQL::Translator::Parser

describes how to write a parser

SQL::Translator::Parser::Access

parser for Access as produced by mdbtools

SQL::Translator::Parser::DB2

parser for DB2

SQL::Translator::Parser::DBI

"parser" for DBI handles

SQL::Translator::Parser::DBI::DB2

parser for DBD::DB2

SQL::Translator::Parser::DBI::MySQL

parser for DBD::mysql

SQL::Translator::Parser::DBI::Oracle

parser for DBD::Oracle

SQL::Translator::Parser::DBI::PostgreSQL

parser for DBD::Pg

SQL::Translator::Parser::DBI::SQLServer

parser for SQL Server through DBD::ODBC

SQL::Translator::Parser::DBI::SQLite

parser for DBD::SQLite

SQL::Translator::Parser::DBI::Sybase

parser for DBD::Sybase

SQL::Translator::Parser::Excel

parser for Excel

SQL::Translator::Parser::JSON

Parse a JSON representation of a schema

SQL::Translator::Parser::MySQL

parser for MySQL

SQL::Translator::Parser::Oracle

parser for Oracle

SQL::Translator::Parser::PostgreSQL

parser for PostgreSQL

SQL::Translator::Parser::SQLServer

parser for SQL Server

SQL::Translator::Parser::SQLite

parser for SQLite

SQL::Translator::Parser::Storable

parser for Schema objects serialized with the Storable module

SQL::Translator::Parser::Sybase

parser for Sybase

SQL::Translator::Parser::XML

Alias to XML::SQLFairy parser

SQL::Translator::Parser::XML::SQLFairy

parser for SQL::Translator's XML.

SQL::Translator::Parser::YAML

Parse a YAML representation of a schema

SQL::Translator::Parser::xSV

parser for arbitrarily delimited text files

SQL::Translator::Producer

describes how to write a producer

SQL::Translator::Producer::ClassDBI

create Class::DBI classes from schema

SQL::Translator::Producer::DB2

DB2 SQL producer

SQL::Translator::Producer::DiaUml

SQL::Translator::Producer::Diagram

ER diagram producer for SQL::Translator

SQL::Translator::Producer::Dumper

SQL Dumper producer for SQL::Translator

SQL::Translator::Producer::GraphViz

GraphViz producer for SQL::Translator

SQL::Translator::Producer::HTML

HTML producer for SQL::Translator

SQL::Translator::Producer::JSON

A JSON producer for SQL::Translator

SQL::Translator::Producer::Latex

SQL::Translator::Producer::MySQL

MySQL-specific producer for SQL::Translator

SQL::Translator::Producer::Oracle

Oracle SQL producer

SQL::Translator::Producer::POD

POD producer for SQL::Translator

SQL::Translator::Producer::PostgreSQL

PostgreSQL producer for SQL::Translator

SQL::Translator::Producer::SQLServer

MS SQLServer producer for SQL::Translator

SQL::Translator::Producer::SQLite

SQLite producer for SQL::Translator

SQL::Translator::Producer::Storable

serializes the SQL::Translator::Schema object via the Storable module

SQL::Translator::Producer::Sybase

Sybase producer for SQL::Translator

SQL::Translator::Producer::TT::Base

TT (Template Toolkit) based Producer base class.

SQL::Translator::Producer::TT::Table

SQL::Translator::Producer::TTSchema

SQL::Translator::Producer::XML

Alias to XML::SQLFairy producer

SQL::Translator::Producer::XML::SQLFairy

SQLFairy's default XML format

SQL::Translator::Producer::YAML

A YAML producer for SQL::Translator

SQL::Translator::Role::BuildArgs

Remove undefined constructor arguments

SQL::Translator::Role::Error

Error setter/getter for objects and classes

SQL::Translator::Role::ListAttr

context-sensitive list attributes

SQL::Translator::Schema

SQL::Translator schema object

SQL::Translator::Schema::Constants

constants module

SQL::Translator::Schema::Constraint

SQL::Translator constraint object

SQL::Translator::Schema::Field

SQL::Translator field object

SQL::Translator::Schema::Index

SQL::Translator index object

SQL::Translator::Schema::Object

Base class for SQL::Translator schema objects

SQL::Translator::Schema::Procedure

SQL::Translator procedure object

SQL::Translator::Schema::Role::Compare

compare objects

SQL::Translator::Schema::Role::Extra

"extra" attribute for schema classes

SQL::Translator::Schema::Table

SQL::Translator table object

SQL::Translator::Schema::Trigger

SQL::Translator trigger object

SQL::Translator::Schema::View

SQL::Translator view object

SQL::Translator::Types

Type checking functions

SQL::Translator::Utils

SQL::Translator Utility functions

Test::SQL::Translator

Test::More test functions for the Schema objects.

Provides

Parse::RecDescent::SQL::Translator::Parser::DB2::Grammar

in lib/SQL/Translator/Parser/DB2/Grammar.pm

SQL::Translator::Parser::DB2::Grammar

in lib/SQL/Translator/Parser/DB2/Grammar.pm

SQL::Translator::Role::Debug

in lib/SQL/Translator/Role/Debug.pm

SQL::Translator::Utils::Error

in lib/SQL/Translator/Utils.pm

Other files

To install SQL::Translator, copy and paste the appropriate command in to your terminal.

cpanm

cpanm SQL::Translator

CPAN shell

perl -MCPAN -e shell
install SQL::Translator

For more information on module installation, please visit the detailed CPAN module installation guide.

	Global
`s`	Focus search bar
`?`	Bring up this help dialog

	GitHub
`g` `p`	Go to pull requests
`g` `i`	go to github issues (only if github is preferred repository)

	POD
`g` `a`	Go to author
`g` `c`	Go to changes
`g` `i`	Go to issues
`g` `d`	Go to dist
`g` `r`	Go to repository/SCM
`g` `s`	Go to source
`g` `b`	Go to file browse

	Search terms
module: (e.g. module:Plugin)
distribution: (e.g. distribution:Dancer auth)
author: (e.g. author:SONGMU Redis)
version: (e.g. version:1.00)

Changes for version 1.63 - 2023-02-23

Documentation

Modules

Provides

Other files

Module Install Instructions