9 years agoSwitch back to upstream travis-perl-helpers
Dagfinn Ilmari Mannsåker [Wed, 7 Jan 2015 13:26:14 +0000]
Switch back to upstream travis-perl-helpers

9 years agoFix multi-column indexes in Parser::DBI::PostgreSQL
Dagfinn Ilmari Mannsåker [Tue, 6 Jan 2015 19:04:50 +0000]
Fix multi-column indexes in Parser::DBI::PostgreSQL

9 years agoAdd Changes entry for 5.8.1 SQLite diffing fix
Dagfinn Ilmari Mannsåker [Tue, 6 Jan 2015 18:46:25 +0000]
Add Changes entry for 5.8.1 SQLite diffing fix

9 years agoFix SQLite diffing on perl 5.8.1
Dagfinn Ilmari Mannsåker [Tue, 6 Jan 2015 15:38:25 +0000]
Fix SQLite diffing on perl 5.8.1

Empty subs return their arguments in list context on 5.8.1, so stick
an empty expression in it.

9 years agoTranslate MS Access memo type to text in Producer::PostgreSQL
Dagfinn Ilmari Mannsåker [Wed, 10 Dec 2014 17:29:25 +0000]
Translate MS Access memo type to text in Producer::PostgreSQL

9 years agoFix clob type translation in Producer::PostgreSQL
Dagfinn Ilmari Mannsåker [Wed, 10 Dec 2014 17:28:59 +0000]
Fix clob type translation in Producer::PostgreSQL

- Match types to translate case-insensitively
- Convert clob to text, not bytea

9 years agoRemove redundant entries from Producer::PostrgeSQL's type mapping
Dagfinn Ilmari Mannsåker [Wed, 10 Dec 2014 17:27:44 +0000]
Remove redundant entries from Producer::PostrgeSQL's type mapping

9 years agoProvide default index names for SQLite
Andrew Gregory [Mon, 3 Nov 2014 18:19:42 +0000]
Provide default index names for SQLite

The allegedly default names were never used causing the first index
created without a name to fail and subsequent indices to be named 02,
03, 04...  This uses the table name with '_idx' appended as the default,
similar to the PostgreSQL producer.

9 years agoFix quoting of trigger name and table in Producer::PostgreSQL
Dagfinn Ilmari Mannsåker [Sun, 14 Dec 2014 19:57:38 +0000]
Fix quoting of trigger name and table in Producer::PostgreSQL

9 years agoUpdate the Free Software Foundation's address (RT#100531)
Dagfinn Ilmari Mannsåker [Mon, 24 Nov 2014 18:29:50 +0000]
Update the Free Software Foundation's address (RT#100531)

9 years agoRemove executable bit from Parser/JSON.pm (RT#100532)
Dagfinn Ilmari Mannsåker [Mon, 24 Nov 2014 18:18:50 +0000]
Remove executable bit from Parser/JSON.pm (RT#100532)

9 years agoFix erroneous PostgreSQL floating point type translations (RT#99725)
Nick Wellnhofer [Mon, 27 Oct 2014 13:26:21 +0000]
Fix erroneous PostgreSQL floating point type translations (RT#99725)

9 years agoCall close as a function rather than a method
Dagfinn Ilmari Mannsåker [Wed, 22 Oct 2014 15:44:41 +0000]
Call close as a function rather than a method

Hopefully fixes test failure on 5.10.0 on MSWin32

9 years agoMerge branch 'oracle-fixes'
Dagfinn Ilmari Mannsåker [Sat, 18 Oct 2014 14:49:54 +0000]
Merge branch 'oracle-fixes'

9 years agoNarrow the scope of Oracle roundtrip TODO
Dagfinn Ilmari Mannsåker [Sun, 21 Sep 2014 22:41:15 +0000]
Narrow the scope of Oracle roundtrip TODO

The parser can now understand the producer output, but doesn't turn the
triggers it generates back into is_auto_increment and timestamp fields.

9 years agoAdd support for triggers in Parser::Oracle
Dagfinn Ilmari Mannsåker [Sat, 20 Sep 2014 16:20:12 +0000]
Add support for triggers in Parser::Oracle

9 years agoHandle ALTER TABLE ... ADD CONSTRAINT in Parser::Oracle
Dagfinn Ilmari Mannsåker [Sat, 20 Sep 2014 16:07:09 +0000]
Handle ALTER TABLE ... ADD CONSTRAINT in Parser::Oracle

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

9 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

9 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

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

9 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

9 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

9 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

9 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

9 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

9 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

9 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

9 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

9 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

9 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

9 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

9 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.

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

9 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.

9 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.

9 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.

9 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

9 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.

9 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

9 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.

9 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

9 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

9 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

9 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.

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

9 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

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

9 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

9 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

9 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

9 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

9 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

9 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

9 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

9 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

9 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

9 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

9 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

9 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

9 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

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

9 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.

9 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

9 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

9 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

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

9 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

9 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

9 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

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

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

9 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

9 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

9 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

9 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

9 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

9 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

9 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

9 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.

9 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

9 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"

9 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'

9 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

9 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

9 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

9 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

9 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.

10 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.

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

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

10 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