10 years agoMerge branch 'quoting-fixes'
Dagfinn Ilmari Mannsåker [Sat, 18 Oct 2014 14:47:48 +0000]
Merge branch 'quoting-fixes'

10 years agoAdd Changes entry for quoting fixes
Dagfinn Ilmari Mannsåker [Mon, 22 Sep 2014 00:06:10 +0000]
Add Changes entry for quoting fixes

10 years agoQuote table names in 'SHOW CREATE TABLE' in Parser::DBI::MySQL
Dagfinn Ilmari Mannsåker [Thu, 24 Jul 2014 16:30:01 +0000]
Quote table names in 'SHOW CREATE TABLE' in Parser::DBI::MySQL

10 years agoTest quotes in field comments
Dagfinn Ilmari Mannsåker [Sun, 21 Sep 2014 23:52:35 +0000]
Test quotes in field comments

10 years agoTest round-tripping decimal default values
Dagfinn Ilmari Mannsåker [Sun, 21 Sep 2014 19:05:27 +0000]
Test round-tripping decimal default values

10 years agoTest round-tripping default values with quotes and backslashes
Dagfinn Ilmari Mannsåker [Sun, 21 Sep 2014 19:10:44 +0000]
Test round-tripping default values with quotes and backslashes

10 years agoEscape quotes in string values in producers
Dagfinn Ilmari Mannsåker [Tue, 1 Jul 2014 08:19:59 +0000]
Escape quotes in string values in producers

10 years agoTest table and field names with quote characters in them
Dagfinn Ilmari Mannsåker [Mon, 30 Jun 2014 17:58:45 +0000]
Test table and field names with quote characters in them

10 years agoEscape the closing quote character when quoting indentifiers
Dagfinn Ilmari Mannsåker [Sun, 29 Jun 2014 17:36:33 +0000]
Escape the closing quote character when quoting indentifiers

10 years agoFix handling of quoted identifiers and strings in Parser::Oracle
Dagfinn Ilmari Mannsåker [Mon, 30 Jun 2014 21:16:50 +0000]
Fix handling of quoted identifiers and strings in Parser::Oracle

10 years agoFix handling of quoted identifiers and strings in Parser::SQLServer
Dagfinn Ilmari Mannsåker [Mon, 30 Jun 2014 20:42:50 +0000]
Fix handling of quoted identifiers and strings in Parser::SQLServer

10 years agoFix handling of quoted identifiers and strings in Parser::PostgreSQL
Dagfinn Ilmari Mannsåker [Mon, 30 Jun 2014 17:54:20 +0000]
Fix handling of quoted identifiers and strings in Parser::PostgreSQL

10 years agoFix handling of quoted identifiers and strings in Parser::MySQL
Dagfinn Ilmari Mannsåker [Mon, 30 Jun 2014 16:01:11 +0000]
Fix handling of quoted identifiers and strings in Parser::MySQL

10 years agoFix handling of quoted identifiers and strings in Parser::SQLite
Dagfinn Ilmari Mannsåker [Mon, 30 Jun 2014 16:00:58 +0000]
Fix handling of quoted identifiers and strings in Parser::SQLite

10 years agoClean up option parsing and fix identifier quoting in Producer::MySQL
Dagfinn Ilmari Mannsåker [Mon, 30 Jun 2014 17:40:58 +0000]
Clean up option parsing and fix identifier quoting in Producer::MySQL

10 years agoClean up option parsing and identifier quoting in Producer::PostgreSQL
Dagfinn Ilmari Mannsåker [Sun, 29 Jun 2014 16:52:01 +0000]
Clean up option parsing and identifier quoting in Producer::PostgreSQL

Remove the unused quote_field_names and table_name options and use the
factored-out quote option parsing function.

10 years agoFactor out quote option handling
Dagfinn Ilmari Mannsåker [Mon, 30 Jun 2014 17:15:58 +0000]
Factor out quote option handling

10 years agoSwitch back to my travis helpers fork
Dagfinn Ilmari Mannsåker [Thu, 16 Oct 2014 10:48:16 +0000]
Switch back to my travis helpers fork

It should pick up the configure-deps itself now.

10 years agoInstall YAML and XML::LibXML in the perl used for testing too
Dagfinn Ilmari Mannsåker [Mon, 13 Oct 2014 16:57:08 +0000]
Install YAML and XML::LibXML in the perl used for testing too

The perl used for build-dist is not necessearily the same as the one
we're testing under.

10 years agoInstall YAML and XML::LibXML before build-dist
Dagfinn Ilmari Mannsåker [Mon, 13 Oct 2014 16:52:04 +0000]
Install YAML and XML::LibXML before build-dist

They are required when running Makefile.PL in author mode.

10 years agoSwitch back to upstream Travis helpers
Dagfinn Ilmari Mannsåker [Mon, 13 Oct 2014 15:06:05 +0000]
Switch back to upstream Travis helpers

10 years agoFix JSON and YAML tests if the defaults have been tweaked (RT#98824)
Dagfinn Ilmari Mannsåker [Tue, 7 Oct 2014 15:14:18 +0000]
Fix JSON and YAML tests if the defaults have been tweaked (RT#98824)

Some people tweak their JSON (or YAML) modules to format things
differently by default, so roundtrip the expected data through a
load/dump to make sure it's formatted thes same.

10 years agoUpdate help/support and contributing POD section
Dagfinn Ilmari Mannsåker [Mon, 6 Oct 2014 19:06:13 +0000]
Update help/support and contributing POD section

Mostly stolen from DBIx::Class

10 years agoAdd IRC metadata and update repository and bugtracker URLs
Dagfinn Ilmari Mannsåker [Mon, 6 Oct 2014 18:43:33 +0000]
Add IRC metadata and update repository and bugtracker URLs

Shadowgit is still the canonical repo, but advertise the github mirror
for ease of contribution.

10 years agoFix undef warnings from Text::ParseWords when running tests with -w
Dagfinn Ilmari Mannsåker [Thu, 25 Sep 2014 13:10:15 +0000]
Fix undef warnings from Text::ParseWords when running tests with -w

10 years agoFix broken POD links found by App::PodLinkChecker
Dagfinn Ilmari Mannsåker [Mon, 22 Sep 2014 16:46:39 +0000]
Fix broken POD links found by App::PodLinkChecker

10 years agoFix Oracle producer
Alexander Hartmaier [Tue, 16 Sep 2014 18:35:32 +0000]
Fix Oracle producer

generating an unnecessary / at the end in case there are no triggers

10 years agoSkip HTML tests if CGI is not installed (RT#98027)
Dagfinn Ilmari Mannsåker [Wed, 10 Sep 2014 10:29:48 +0000]
Skip HTML tests if CGI is not installed (RT#98027)

It's being evicted from core in 5.22.

10 years agorelease 0.11020 v0.11020
Dagfinn Ilmari Mannsåker [Tue, 2 Sep 2014 22:24:20 +0000]
release 0.11020

10 years agoFix test failure if Test::PostgreSQL is installed but not working
Dagfinn Ilmari Mannsåker [Tue, 2 Sep 2014 22:23:18 +0000]
Fix test failure if Test::PostgreSQL is installed but not working

10 years agorelease 0.11019 v0.11019
Dagfinn Ilmari Mannsåker [Tue, 2 Sep 2014 14:13:48 +0000]
release 0.11019

10 years ago[merge] Batch alter support for Pg and refactoring
Dagfinn Ilmari Mannsåker [Tue, 2 Sep 2014 13:57:20 +0000]
[merge] Batch alter support for Pg and refactoring

Fixes #44

10 years agoAdd Changes entry for Pg diff fix
Dagfinn Ilmari Mannsåker [Mon, 1 Sep 2014 16:23:59 +0000]
Add Changes entry for Pg diff fix

10 years agoFactor out calling of normal diff-production functions
Dagfinn Ilmari Mannsåker [Mon, 25 Aug 2014 09:52:24 +0000]
Factor out calling of normal diff-production functions

10 years agoFix argument documentation for preprocess_schema
Dagfinn Ilmari Mannsåker [Mon, 25 Aug 2014 13:59:08 +0000]
Fix argument documentation for preprocess_schema

10 years agoDocument producer_args in SQL::Translator::Diff
Dagfinn Ilmari Mannsåker [Mon, 25 Aug 2014 13:58:54 +0000]
Document producer_args in SQL::Translator::Diff

10 years agoFix POD syntax for PODed-out code
Dagfinn Ilmari Mannsåker [Mon, 25 Aug 2014 13:59:52 +0000]
Fix POD syntax for PODed-out code

10 years agoClean up Pg batch alter test
Dagfinn Ilmari Mannsåker [Mon, 25 Aug 2014 12:57:38 +0000]
Clean up Pg batch alter test

- Only use Test::PostgreSQL if DBICTEST_PG_DSN isn't set
- Use sqlt_test_ prefix for tables we create
- Drop the tables we created on exit
- Use lives_ok for the SQL we're testing

10 years agotest to demonstrate Pg diff failure with rename_table+rename_field
Peter Mottram [Sat, 23 Aug 2014 10:16:16 +0000]
test to demonstrate Pg diff failure with rename_table+rename_field

10 years agoinitial batch_alter_table for ::Producer::PostgreSQL
Peter Mottram [Fri, 22 Aug 2014 09:38:20 +0000]
initial batch_alter_table for ::Producer::PostgreSQL

10 years agoAdd Changes entry for numeric field default fix
Dagfinn Ilmari Mannsåker [Mon, 1 Sep 2014 17:34:41 +0000]
Add Changes entry for numeric field default fix

10 years agoAdd Changes entry for SQLite diff fix
Dagfinn Ilmari Mannsåker [Wed, 20 Aug 2014 14:27:34 +0000]
Add Changes entry for SQLite diff fix

10 years agofix Producer::SQLite::batch_alter_table rename field
Peter Mottram [Wed, 20 Aug 2014 14:00:22 +0000]
fix Producer::SQLite::batch_alter_table rename field

10 years agoPropagate switches when running perl in tests
Dagfinn Ilmari Mannsåker [Wed, 13 Aug 2014 00:12:13 +0000]
Propagate switches when running perl in tests

10 years agoActually install Devel::Cover
Dagfinn Ilmari Mannsåker [Tue, 12 Aug 2014 23:23:52 +0000]
Actually install Devel::Cover

10 years agoDie instead of warning if roundtrip regen fails
Dagfinn Ilmari Mannsåker [Tue, 12 Aug 2014 22:47:53 +0000]
Die instead of warning if roundtrip regen fails

This lets the Travis helpers' auto-prereq-installation work.

10 years agoUse my fork of the helpers, for debugging
Dagfinn Ilmari Mannsåker [Tue, 12 Aug 2014 21:09:28 +0000]
Use my fork of the helpers, for debugging

10 years agoSwitch to @haarg's perl-travis-helper, add 5.20 and blead
Dagfinn Ilmari Mannsåker [Tue, 12 Aug 2014 17:30:11 +0000]
Switch to @haarg's perl-travis-helper, add 5.20 and blead

10 years agoAdd more data_types for sql_types mapping
Wallace Reis [Tue, 29 Jul 2014 21:39:26 +0000]
Add more data_types for sql_types mapping

10 years agoExtend Field->equals() for numeric comparison
Wallace Reis [Tue, 29 Jul 2014 17:58:11 +0000]
Extend Field->equals() for numeric comparison

10 years agoAdd 'use warnings', test case-insensitive ->get_field
Dagfinn Ilmari Mannsåker [Sat, 26 Jul 2014 12:33:31 +0000]
Add 'use warnings', test case-insensitive ->get_field

10 years agoFix and extend link table tests
Dagfinn Ilmari Mannsåker [Sat, 26 Jul 2014 12:32:53 +0000]
Fix and extend link table tests

10 years agoUse a schema with FKs for diagram testing
Dagfinn Ilmari Mannsåker [Fri, 25 Jul 2014 15:07:39 +0000]
Use a schema with FKs for diagram testing

10 years agoIgnore Devel::Cover output
Dagfinn Ilmari Mannsåker [Fri, 25 Jul 2014 15:07:25 +0000]
Ignore Devel::Cover output

10 years agoInstall the libgd development package
Dagfinn Ilmari Mannsåker [Fri, 25 Jul 2014 14:38:23 +0000]
Install the libgd development package

10 years agoOutput the build log on cpanm failure
Dagfinn Ilmari Mannsåker [Fri, 25 Jul 2014 14:31:04 +0000]
Output the build log on cpanm failure

10 years agoInstall Graph::Directed and GD to test Producer::Diagram
Dagfinn Ilmari Mannsåker [Fri, 25 Jul 2014 14:19:34 +0000]
Install Graph::Directed and GD to test Producer::Diagram

10 years agoTest Schema::Table->is_trivial_link and ->is_data
Dagfinn Ilmari Mannsåker [Fri, 25 Jul 2014 12:47:51 +0000]
Test Schema::Table->is_trivial_link and ->is_data

10 years agoSwitch t/13schema.t to done_testing
Dagfinn Ilmari Mannsåker [Fri, 25 Jul 2014 12:27:00 +0000]
Switch t/13schema.t to done_testing

10 years agoSet all the env variables in one "env" entry
Dagfinn Ilmari Mannsåker [Fri, 25 Jul 2014 11:52:15 +0000]
Set all the env variables in one "env" entry

10 years agoTest Parser::DBI::PostgreSQL in Travis
Dagfinn Ilmari Mannsåker [Fri, 25 Jul 2014 11:39:20 +0000]
Test Parser::DBI::PostgreSQL in Travis

10 years agoInstall XML::Parser in Travis, it's used by t/05bgep-re.t
Dagfinn Ilmari Mannsåker [Fri, 25 Jul 2014 11:31:45 +0000]
Install XML::Parser in Travis, it's used by t/05bgep-re.t

10 years agoFix handling of views in MySQL DBI parser
Dagfinn Ilmari Mannsåker [Thu, 24 Jul 2014 16:34:54 +0000]
Fix handling of views in MySQL DBI parser

SHOW TABLES and SHOW CREATE TABLE return views too, and Parser::MySQL
handles them just fine, so just pass them on.

10 years agoAdd Changes entries for 6c77378 and 1fb4f40
Dagfinn Ilmari Mannsåker [Thu, 24 Jul 2014 15:33:52 +0000]
Add Changes entries for 6c77378 and 1fb4f40

10 years agoFix warning due uninitialized var
Wallace Reis [Tue, 22 Jul 2014 18:10:51 +0000]
Fix warning due uninitialized var

"Use of uninitialized value in concatenation"

10 years agoProduce DDL for MySQL table field with ref in 'ON UPDATE'
Wallace Reis [Wed, 23 Jul 2014 22:56:28 +0000]
Produce DDL for MySQL table field with ref in 'ON UPDATE'

10 years agoDon't install Text::RecordParser, it's broken
Dagfinn Ilmari Mannsåker [Mon, 30 Jun 2014 11:40:30 +0000]
Don't install Text::RecordParser, it's broken

10 years agoInstall optional test deps in Travis
Dagfinn Ilmari Mannsåker [Mon, 30 Jun 2014 11:29:50 +0000]
Install optional test deps in Travis

10 years agoInstall DBI as well in Travis
Dagfinn Ilmari Mannsåker [Mon, 30 Jun 2014 11:10:39 +0000]
Install DBI as well in Travis

10 years agoInstall author-mode configure reqs in Travis
Dagfinn Ilmari Mannsåker [Mon, 30 Jun 2014 10:34:05 +0000]
Install author-mode configure reqs in Travis

10 years agoStop Makefile.PL hanging at prompts under Travis
Dagfinn Ilmari Mannsåker [Mon, 30 Jun 2014 10:26:54 +0000]
Stop Makefile.PL hanging at prompts under Travis

10 years agofixup! Test against travis
Arthur Axel 'fREW' Schmidt [Wed, 7 May 2014 18:33:36 +0000]
fixup! Test against travis

10 years agoadd missing Changes
Arthur Axel 'fREW' Schmidt [Wed, 7 May 2014 18:33:14 +0000]
add missing Changes

10 years agoTest against travis
Arthur Axel 'fREW' Schmidt [Wed, 7 May 2014 18:14:02 +0000]
Test against travis

10 years agoFix DROP TABLE in SQL Server Producer
Arthur Axel 'fREW' Schmidt [Wed, 7 May 2014 16:55:44 +0000]
Fix DROP TABLE in SQL Server Producer

10 years agoAdd .mailmap entry for Ash Berlin
Dagfinn Ilmari Mannsåker [Wed, 12 Feb 2014 16:49:24 +0000]
Add .mailmap entry for Ash Berlin

10 years agoremove spurious warning from 6+ years ago.
Matt Phillips [Thu, 2 Jan 2014 22:40:20 +0000]
remove spurious warning from 6+ years ago.

10 years agoAdd Json and hstore types in the PostgreSQL parser
clodeindustrie [Fri, 13 Dec 2013 07:48:37 +0000]
Add Json and hstore types in the PostgreSQL parser

10 years agoFix Pg DBI parser test
Dagfinn Ilmari Mannsåker [Tue, 17 Dec 2013 21:03:00 +0000]
Fix Pg DBI parser test

Allow maybe_plan() to not declare a plan, and use skip_all() and
done_testing() in the test file.

11 years agoremove default Pg dsn
Arthur Axel 'fREW' Schmidt [Fri, 1 Nov 2013 16:27:47 +0000]
remove default Pg dsn

This can cause spurious failures if the default DSN could connect but didn't
have permissions for example.

11 years agoFix confusingly erroneous variable name
Dagfinn Ilmari Mannsåker [Mon, 7 Oct 2013 14:52:42 +0000]
Fix confusingly erroneous variable name

11 years agorelease 0.011018 🎃 v0.011018 v0.11018
Arthur Axel 'fREW' Schmidt [Thu, 31 Oct 2013 13:58:32 +0000]
release 0.011018 🎃

11 years agoRevert "Fixed autoincrement in primary keys for SQLite"
Arthur Axel 'fREW' Schmidt [Thu, 31 Oct 2013 13:27:12 +0000]
Revert "Fixed autoincrement in primary keys for SQLite"

This reverts commit 03b0fa258c8580135c282b0282b5c7dcb0865c14.

This turns out to break far more than I expected it would.  See discussion here:
https://github.com/dbsrgits/sql-translator/pull/26

11 years agorelease 0.11017 v0.011017 v0.11017
Arthur Axel 'fREW' Schmidt [Wed, 30 Oct 2013 17:59:20 +0000]
release 0.11017

11 years agoadd missing Changes
Arthur Axel 'fREW' Schmidt [Wed, 30 Oct 2013 17:57:07 +0000]
add missing Changes

11 years agoNormalize Changes file to CPAN::Changes::Spec
Brian Cassidy [Thu, 11 Oct 2012 12:09:19 +0000]
Normalize Changes file to CPAN::Changes::Spec

Sadly, this doesn't validate because of a missing release date for
version 0.08_03. It will be future compatible, though, when the release
date becomes an optional element.

11 years agoFixed autoincrement in primary keys for SQLite
rporres [Tue, 12 Feb 2013 09:05:56 +0000]
Fixed autoincrement in primary keys for SQLite

SQLite autoincrement feature behaves differently in primary keys
and non-primary keys.  SQLite generator must take into account
autoincrement in primary keys when generating schemas.

11 years agoTTSchema doc fixes
Gavin Shelley [Sun, 10 Mar 2013 21:13:54 +0000]
TTSchema doc fixes

11 years agoSuppress "Exiting subroutine via next"
Larry Leszczynski [Tue, 23 Apr 2013 19:41:21 +0000]
Suppress "Exiting subroutine via next"

11 years agoAdd JSON parser and producer modules
Jon Jensen [Fri, 26 Apr 2013 14:10:16 +0000]
Add JSON parser and producer modules

These are cloned and adapted from their YAML counterparts.

11 years agoAdd DECIMAL_DIGITS to SQLServer size field for scale info
Jonathan C. Otsuka [Wed, 10 Oct 2012 16:59:44 +0000]
Add DECIMAL_DIGITS to SQLServer size field for scale info

http://msdn.microsoft.com/en-us/library/aa258832(v=sql.80).aspx

11 years agoQuote table_name to fix tables using reserve words as their name
Jonathan C. Otsuka [Wed, 30 Oct 2013 00:29:55 +0000]
Quote table_name to fix tables using reserve words as their name

11 years agoAdd myself to AUTHORS
Dagfinn Ilmari Mannsåker [Mon, 30 Sep 2013 08:18:34 +0000]
Add myself to AUTHORS

11 years agoFix incorrect module names in conditional plan
Dagfinn Ilmari Mannsåker [Sun, 29 Sep 2013 20:10:59 +0000]
Fix incorrect module names in conditional plan

11 years agoChange my E-Mail address
Robert Bohne [Sun, 29 Sep 2013 19:12:37 +0000]
Change my E-Mail address

11 years agoAdd SQL_TINYINT and SQL_BIGINT to %SQL::Translator::Schema::Field::type_mapping
Songmu [Sat, 28 Sep 2013 14:10:58 +0000]
Add SQL_TINYINT and SQL_BIGINT to %SQL::Translator::Schema::Field::type_mapping

SQL_BIGINT was added in DBI 1.54, so bump the dependency.

11 years agoFix typo in synopsis
Dagfinn Ilmari Mannsåker [Sat, 14 Sep 2013 16:46:59 +0000]
Fix typo in synopsis

11 years agoAdd missing attribute name in header
Dagfinn Ilmari Mannsåker [Sat, 14 Sep 2013 16:44:33 +0000]
Add missing attribute name in header

11 years agoRemove documentation for field moved to role
Dagfinn Ilmari Mannsåker [Sat, 14 Sep 2013 16:43:59 +0000]
Remove documentation for field moved to role

11 years agoFix typo
Dagfinn Ilmari Mannsåker [Sat, 14 Sep 2013 16:41:58 +0000]
Fix typo