12 years agoCall ->on_delete & ->on_update in SCALAR context not in LIST context
Robert Bohne [Tue, 19 Jul 2011 12:29:53 +0000]
Call ->on_delete & ->on_update in SCALAR context not in LIST context

12 years agoadded kaitlyn's patch for mysql->sqlite translation
Devin Austin [Tue, 7 Jun 2011 18:07:30 +0000]
added kaitlyn's patch for mysql->sqlite translation

12 years agobinmode STDOUT to not generate garbage in a UTF-8 environment (bug #71399)
Lukas Mai [Sun, 2 Oct 2011 12:07:57 +0000]
binmode STDOUT to not generate garbage in a UTF-8 environment (bug #71399)

12 years agoimage is returned, not written w/o out_file (bug #71398)
Lukas Mai [Sun, 2 Oct 2011 12:02:57 +0000]
image is returned, not written w/o out_file (bug #71398)

12 years agogitignoring
Peter Rabbitson [Sat, 24 Dec 2011 05:37:21 +0000]
gitignoring

12 years agoadded a working mechanism for naming foreign keys
Andreas 'ac0v' Specht [Wed, 6 Apr 2011 19:32:46 +0000]
added a working mechanism for naming foreign keys

12 years agofixed alter_drop_constraint for foreign keys and applying multiple changes via alter_...
Andreas 'ac0v' Specht [Wed, 6 Apr 2011 18:20:02 +0000]
fixed alter_drop_constraint for foreign keys and applying multiple changes via alter_field to a column in Postgres Producer

12 years agoget Postgres table and column descriptions
Cedric Carree [Tue, 22 Nov 2011 11:34:27 +0000]
get Postgres table and column descriptions

patch submitted by Andrew Pam

12 years agoFix index issue in Parser::DBI::PostgreSQL
Cedric Carree [Tue, 22 Nov 2011 10:15:10 +0000]
Fix index issue in Parser::DBI::PostgreSQL

pg_index.indkey does not necessaraly matches the id of the columns_name array. It happens when a column is dropped after the table was created.

12 years agoPatch to get correct SQL data types from Postgres
Cedric Carree [Tue, 22 Nov 2011 09:55:53 +0000]
Patch to get correct SQL data types from  Postgres

Patch submitted by Andrew Pam

12 years agoCreate unit test for ::Parser::DBI::PostgreSQL, fix parser namespace lookup
Cedric Carree [Thu, 17 Nov 2011 11:00:10 +0000]
Create unit test for ::Parser::DBI::PostgreSQL, fix parser namespace lookup

13 years agoRelease 0.11010 v0.11010
Amiri Barksdale at Home [Wed, 5 Oct 2011 15:40:55 +0000]
Release 0.11010

13 years agoAdd test for DROP VIEW IF EXISTS
Amiri Barksdale at Home [Wed, 5 Oct 2011 16:34:56 +0000]
Add test for DROP VIEW IF EXISTS

13 years agoFix CREATE VIEW syntax.
Amiri Barksdale at Home [Wed, 4 May 2011 18:58:59 +0000]
Fix CREATE VIEW syntax.

13 years agoAdd geiststeufel to the AUTHORs list v0.11009
Jess Robinson [Fri, 2 Sep 2011 12:23:33 +0000]
Add geiststeufel to the AUTHORs list

13 years agoUpdate to version 0.011009
Jess Robinson [Fri, 2 Sep 2011 12:18:16 +0000]
Update to version 0.011009

13 years agotest quoted for mysql
Vincent Bachelier [Fri, 2 Sep 2011 09:32:21 +0000]
test quoted for mysql

13 years agoquote properly all table name
Vincent Bachelier [Thu, 1 Sep 2011 15:30:26 +0000]
quote properly all table name

13 years agoadd quoted reference to check if the table name contain a full declaration, it quote...
Geistteufel [Wed, 31 Aug 2011 13:50:03 +0000]
add quoted reference to check if the table name contain a full declaration, it quote it properly

13 years agoquote reference_table
Geistteufel [Wed, 31 Aug 2011 13:39:33 +0000]
quote reference_table

13 years agoRelease 0.11008 v0.11008
Arthur Axel 'fREW' Schmidt [Wed, 4 May 2011 14:56:46 +0000]
Release 0.11008

13 years agoignore vim swap files
Arthur Axel 'fREW' Schmidt [Mon, 2 May 2011 23:26:24 +0000]
ignore vim swap files

13 years agorename Shim to ProducerUtils for accuracy
Arthur Axel 'fREW' Schmidt [Mon, 2 May 2011 23:25:03 +0000]
rename Shim to ProducerUtils for accuracy

13 years agoDo not depend on implicit hash ordering in YAML load
Peter Rabbitson [Mon, 25 Apr 2011 07:36:51 +0000]
Do not depend on implicit hash ordering in YAML load

13 years agoSimple change to make Postgres simple array types produce correctly
Colin Newell [Mon, 18 Apr 2011 14:11:59 +0000]
Simple change to make Postgres simple array types produce correctly

13 years agofix repo url
Arthur Axel 'fREW' Schmidt [Tue, 19 Apr 2011 16:51:59 +0000]
fix repo url

13 years agoPostGIS functions are case-sensitive
Florian Ragwitz [Tue, 5 Apr 2011 15:26:49 +0000]
PostGIS functions are case-sensitive

Use their proper names, not the lc()ed version.

13 years agoCreate and parse FK constraints in SQLite
Arthur Axel 'fREW' Schmidt [Mon, 28 Feb 2011 15:16:12 +0000]
Create and parse FK constraints in SQLite

13 years agoMake true unique constraints if needed in SQL Server
Arthur Axel 'fREW' Schmidt [Thu, 24 Feb 2011 21:30:55 +0000]
Make true unique constraints if needed in SQL Server

http://improvingsoftware.com/2010/03/26/creating-a-unique-constraint-that-ignores-nulls-in-sql-server/

13 years agoTurn off constraints before dropping tables in SQL Server
Arthur Axel 'fREW' Schmidt [Thu, 24 Feb 2011 21:49:45 +0000]
Turn off constraints before dropping tables in SQL Server

13 years agoQuote everything in SQL Server
Arthur Axel 'fREW' Schmidt [Thu, 24 Feb 2011 01:01:23 +0000]
Quote everything in SQL Server

13 years agoParse new SQL Server stuff
Peter Rabbitson [Fri, 25 Feb 2011 03:16:06 +0000]
Parse new SQL Server stuff

13 years agowhitespace changes
Arthur Axel 'fREW' Schmidt [Fri, 25 Feb 2011 16:13:30 +0000]
whitespace changes

13 years agotear out useless unreserve hash
Arthur Axel 'fREW' Schmidt [Thu, 24 Feb 2011 00:51:49 +0000]
tear out useless unreserve hash

13 years agoadd shim for non-lethal future development
Arthur Axel 'fREW' Schmidt [Thu, 24 Feb 2011 00:07:15 +0000]
add shim for non-lethal future development

13 years agoBetter diagnostics
Peter Rabbitson [Fri, 25 Feb 2011 03:15:32 +0000]
Better diagnostics

13 years agoFix RT#64728
Peter Rabbitson [Sun, 27 Feb 2011 16:11:52 +0000]
Fix RT#64728

13 years agoMake autoinc PKs show up in GraphViz
Peter Rabbitson [Sun, 27 Feb 2011 15:59:58 +0000]
Make autoinc PKs show up in GraphViz

13 years agoMake Pg producer consistent with the rest in terms of quoting
Moritz Onken [Wed, 2 Feb 2011 11:58:39 +0000]
Make Pg producer consistent with the rest in terms of quoting
and allowing functions in constraints and indices

13 years ago.gitignore
Peter Rabbitson [Wed, 2 Feb 2011 10:25:59 +0000]
.gitignore

13 years agoRevert last change becuase it broke a bunch of tests.
Darren Chamberlain [Tue, 11 Jan 2011 21:41:43 +0000]
Revert last change becuase it broke a bunch of tests.

13 years agoMerging patch from ddascalescu+perl@gmail.com, for https://rt.cpan.org/Ticket/Display...
Darren Chamberlain [Tue, 11 Jan 2011 16:56:22 +0000]
Merging patch from ddascalescu+perl@gmail.com, for https://rt.cpan.org/Ticket/Display.html?id=44769.  I've not tested it.

13 years agoRevert my previous changes (rev 1722 reverted back to rev 1721)
Jonathan Yu [Fri, 31 Dec 2010 23:32:55 +0000]
Revert my previous changes (rev 1722 reverted back to rev 1721)

13 years agoRemove copyright headers from individual scripts
Jonathan Yu [Fri, 31 Dec 2010 22:02:11 +0000]
Remove copyright headers from individual scripts
+ This information is now kept in the main SQL::Translator POD
+ Different files had copyright dates out-of-sync with each other due to excessive duplication
Remove AUTHORS file (information moved to SQL::Translator POD)
Fix Makefile.PL to correctly indicate the package is GPL-2 licensed
Update my e-mail address while we're at it

13 years agoCorrect postgis geography type insertion and linebreak fix for multiple geometry...
Peter Rabbitson [Wed, 15 Dec 2010 15:53:41 +0000]
Correct postgis geography type insertion and linebreak fix for multiple geometry/geography columns

13 years agoReleased 0.11007
Jess Robinson [Tue, 30 Nov 2010 22:35:12 +0000]
Released 0.11007

13 years agoFix MySQL producer attaching View definitions to a schema
Peter Rabbitson [Tue, 30 Nov 2010 11:54:20 +0000]
Fix MySQL producer attaching View definitions to a schema
in hash-key order (which sadly *appears* stable after 5.8.2)

13 years agoChanges from abraxxa
Peter Rabbitson [Tue, 30 Nov 2010 11:53:51 +0000]
Changes from abraxxa

13 years agotests for MySQL Producer triggers
Rafael Kitover [Tue, 30 Nov 2010 10:46:58 +0000]
tests for MySQL Producer triggers

13 years agoAdd support for triggers in the MySQL producer (RT#63452) ilmari++
Rafael Kitover [Tue, 30 Nov 2010 10:42:27 +0000]
Add support for triggers in the MySQL producer (RT#63452) ilmari++

13 years agoFix POD typo in SQL/Translator/Schema/Trigger.pm (RT#63451)
Rafael Kitover [Tue, 30 Nov 2010 10:39:15 +0000]
Fix POD typo in SQL/Translator/Schema/Trigger.pm (RT#63451)

14 years agoUse CASCADE when dropping a postgres enum type, to be consistent with table drops
Stephen Bennett [Sat, 20 Nov 2010 22:09:54 +0000]
Use CASCADE when dropping a postgres enum type, to be consistent with table drops

14 years agoFix sqlt options not matching documentation (RT#58318)
Peter Rabbitson [Wed, 17 Nov 2010 11:28:16 +0000]
Fix sqlt options not matching documentation (RT#58318)

14 years agotest + fix for Oracle multi-column constraint generation
Alexander Hartmaier [Sat, 13 Nov 2010 13:56:25 +0000]
test + fix for Oracle multi-column constraint generation

14 years agoSupport a custom_type_name hint for Pg enum creation
Peter Rabbitson [Wed, 10 Nov 2010 22:57:56 +0000]
Support a custom_type_name hint for Pg enum creation

14 years agoFix some legacy code to stop warning on newer perls
Peter Rabbitson [Wed, 10 Nov 2010 22:57:40 +0000]
Fix some legacy code to stop warning on newer perls

14 years agoAdd support for PostGIS Geometry and Geography data types
Peter Rabbitson [Wed, 10 Nov 2010 22:57:13 +0000]
Add support for PostGIS Geometry and Geography data types

14 years agoTurn the roundtrip source generation fail into a warning
Peter Rabbitson [Wed, 10 Nov 2010 22:56:54 +0000]
Turn the roundtrip source generation fail into a warning

14 years agoBump M::I dep to a version not abusing FindBin
Peter Rabbitson [Fri, 13 Aug 2010 10:35:51 +0000]
Bump M::I dep to a version not abusing FindBin

14 years agoEven though it is in the depchain due to YAML - just go ahead and declare it
Peter Rabbitson [Fri, 13 Aug 2010 10:35:38 +0000]
Even though it is in the depchain due to YAML - just go ahead and declare it

14 years agoRelease 0.11006
Peter Rabbitson [Thu, 3 Jun 2010 09:09:16 +0000]
Release 0.11006

14 years agoAwesome non-quoted numeric default patch by Stephen Clouse
Peter Rabbitson [Thu, 3 Jun 2010 09:09:02 +0000]
Awesome non-quoted numeric default patch by Stephen Clouse

14 years agoAdjust view production for stupid mysql
Peter Rabbitson [Thu, 3 Jun 2010 09:08:31 +0000]
Adjust view production for stupid mysql

14 years agoFix index quoting for mysql
Peter Rabbitson [Thu, 3 Jun 2010 09:08:14 +0000]
Fix index quoting for mysql

14 years agoMake 'default_value' behave like a real accessor
Peter Rabbitson [Wed, 2 Jun 2010 08:39:03 +0000]
Make 'default_value' behave like a real accessor

14 years agoChanges reformat
Peter Rabbitson [Wed, 2 Jun 2010 08:23:17 +0000]
Changes reformat

14 years agoupdate Changes
Rafael Kitover [Wed, 2 Jun 2010 02:21:20 +0000]
update Changes

14 years agopatch from abraxxa (Alexander Hartmaier) to truncate unique constraint names that...
Rafael Kitover [Wed, 2 Jun 2010 02:16:48 +0000]
patch from abraxxa (Alexander Hartmaier) to truncate unique constraint names that are too long

14 years agoFix SQLite producer create_view so it doesn't generate statements with semicolons.
Andrew Rodland [Wed, 2 Jun 2010 00:03:00 +0000]
Fix SQLite producer create_view so it doesn't generate statements with semicolons.

14 years agoChanges
Peter Rabbitson [Tue, 1 Jun 2010 23:37:08 +0000]
Changes

14 years agoremove unnecessary bit of code
Rafael Kitover [Tue, 1 Jun 2010 17:44:13 +0000]
remove unnecessary bit of code

14 years agonormalize SQLite and Postgres version numbers
Rafael Kitover [Tue, 1 Jun 2010 16:27:05 +0000]
normalize SQLite and Postgres version numbers

14 years agoGet SQLite to produce saner output
Peter Rabbitson [Sat, 6 Mar 2010 23:44:37 +0000]
Get SQLite to produce saner output

14 years agoMerge 'oracle_datatypes' into 'trunk'
Peter Rabbitson [Fri, 5 Mar 2010 10:23:33 +0000]
Merge 'oracle_datatypes' into 'trunk'

r1685@Thesaurus (orig r1684):  faxm0dem | 2010-02-25 10:13:29 +0100
I'm not to be trusted with the chainsaw

r1686@Thesaurus (orig r1685):  faxm0dem | 2010-02-25 13:38:04 +0100
add to changes
r1687@Thesaurus (orig r1686):  faxm0dem | 2010-02-25 14:18:30 +0100
float doesn't need to be forced to 126 either

14 years agofix a bunch of spelling errors, and add whatis entries (these are applying patches...
Jonathan Yu [Sat, 27 Feb 2010 00:28:31 +0000]
fix a bunch of spelling errors, and add whatis entries (these are applying patches from Debian)

14 years agofloat doesn't need to be forced to 126 either
Fabien Wernli [Thu, 25 Feb 2010 13:18:30 +0000]
float doesn't need to be forced to 126 either

14 years agoadd to changes
Fabien Wernli [Thu, 25 Feb 2010 12:38:04 +0000]
add to changes

14 years agoI'm not to be trusted with the chainsaw
Fabien Wernli [Thu, 25 Feb 2010 09:13:29 +0000]
I'm not to be trusted with the chainsaw

14 years agoForgot to add the test data file for r1676
Andrew Rodland [Wed, 24 Feb 2010 21:30:35 +0000]
Forgot to add the test data file for r1676

14 years agotext back to clob
Fabien Wernli [Wed, 24 Feb 2010 17:17:46 +0000]
text back to clob

14 years agotests
Fabien Wernli [Wed, 24 Feb 2010 15:26:37 +0000]
tests

14 years agofix committed
Fabien Wernli [Wed, 24 Feb 2010 15:14:32 +0000]
fix committed

14 years agodouble and float thou shall now be float
Fabien Wernli [Wed, 24 Feb 2010 14:48:18 +0000]
double and float thou shall now be float

14 years agoSQLite parser: handle named constraints, and don't choke on a comment
Andrew Rodland [Wed, 24 Feb 2010 11:42:47 +0000]
SQLite parser: handle named constraints, and don't choke on a comment
before a table constraint.

14 years agoRelease 0.11005
Peter Rabbitson [Wed, 24 Feb 2010 08:24:28 +0000]
Release 0.11005

14 years agoOracle fix primarily to have it not capitalize but quote instead
Peter Rabbitson [Wed, 24 Feb 2010 08:13:08 +0000]
Oracle fix primarily to have it not capitalize but quote instead

test I'm not committing to trunk instead
initial things don't look at this yet
text -> varchar2(4000) instead of clob, get rid of reserved keywords, import oracle_version from DBD::Oracle
missed some quotes and added tests to avoid that
missed some quotes and added tests to avoid that
Cleanup tabs/whitespace
Changes
Changes2
r1654@Thesaurus (orig r1653):  faxm0dem | 2010-02-10 14:01:28 +0100
r1655@Thesaurus (orig r1654):  faxm0dem | 2010-02-10 14:06:17 +0100
r1656@Thesaurus (orig r1655):  faxm0dem | 2010-02-10 14:07:08 +0100
r1658@Thesaurus (orig r1657):  faxm0dem | 2010-02-10 19:16:08 +0100
r1659@Thesaurus (orig r1658):  faxm0dem | 2010-02-11 12:53:59 +0100
r1660@Thesaurus (orig r1659):  faxm0dem | 2010-02-11 12:54:54 +0100
r1670@Thesaurus (orig r1669):  rabbit | 2010-02-23 12:14:25 +0100
r1672@Thesaurus (orig r1671):  rabbit | 2010-02-24 09:09:21 +0100
r1673@Thesaurus (orig r1672):  rabbit | 2010-02-24 09:12:36 +0100

14 years agoChanges2
Peter Rabbitson [Wed, 24 Feb 2010 08:12:32 +0000]
Changes2

14 years agoChanges
Peter Rabbitson [Wed, 24 Feb 2010 08:09:16 +0000]
Changes

14 years agoCleanup tabs/whitespace
Peter Rabbitson [Tue, 23 Feb 2010 11:14:20 +0000]
Cleanup tabs/whitespace

14 years agochanging SQL::Translator::Diff to use producer_args instead of producer_options
Peter Rabbitson [Tue, 23 Feb 2010 10:41:28 +0000]
changing SQL::Translator::Diff to use producer_args instead of producer_options

Use Carp instead of warn and fix noisy tests
Release 0.11004
Patch by Dan Horne (RT#49413)
Add primary key index type support to mysql grammar
Make PG-parser trace subject to debug (RT#52276)
Extend test a bit (the btree seems to be discarded atm)
Support commit; in loaded Pg DDL
Changes
r1657@Thesaurus (orig r1656):  acmoore | 2010-02-10 17:52:41 +0100
r1661@Thesaurus (orig r1660):  rabbit | 2010-02-14 10:22:53 +0100
r1662@Thesaurus (orig r1661):  rabbit | 2010-02-14 10:45:33 +0100
r1663@Thesaurus (orig r1662):  rabbit | 2010-02-14 10:54:24 +0100
r1664@Thesaurus (orig r1663):  rabbit | 2010-02-14 11:06:41 +0100
r1665@Thesaurus (orig r1664):  rabbit | 2010-02-14 11:13:51 +0100
r1666@Thesaurus (orig r1665):  rabbit | 2010-02-14 11:26:57 +0100
r1667@Thesaurus (orig r1666):  rabbit | 2010-02-14 11:29:13 +0100
r1668@Thesaurus (orig r1667):  rabbit | 2010-02-14 11:38:23 +0100

14 years agomissed some quotes and added tests to avoid that
Fabien Wernli [Thu, 11 Feb 2010 11:54:54 +0000]
missed some quotes and added tests to avoid that

14 years agomissed some quotes and added tests to avoid that
Fabien Wernli [Thu, 11 Feb 2010 11:53:59 +0000]
missed some quotes and added tests to avoid that

14 years agotext -> varchar2(4000) instead of clob, get rid of reserved keywords, import oracle_v...
Fabien Wernli [Wed, 10 Feb 2010 18:16:08 +0000]
text -> varchar2(4000) instead of clob, get rid of reserved keywords, import oracle_version from DBD::Oracle

14 years agoinitial things don't look at this yet
Fabien Wernli [Wed, 10 Feb 2010 13:07:08 +0000]
initial things don't look at this yet

14 years agotest I'm not committing to trunk instead
Fabien Wernli [Wed, 10 Feb 2010 13:06:17 +0000]
test I'm not committing to trunk instead

14 years agoadded myself to the list of authors
Alexander Hartmaier [Thu, 17 Dec 2009 21:20:50 +0000]
added myself to the list of authors

14 years agoFix Oracle producer creating numeric precision statements that the test case expects...
Alexander Hartmaier [Thu, 17 Dec 2009 21:12:29 +0000]
Fix Oracle producer creating numeric precision statements that the test case expects (no whitespace)
Add Oracle producer creating drop view statements like PG producer does

15 years agoWhen adding the edges, it's necessary to quote the table names exactly the
Ken Youens-Clark [Wed, 7 Oct 2009 21:47:17 +0000]
When adding the edges, it's necessary to quote the table names exactly the
same as when adding the nodes or else new nodes can be created.

15 years agoChanges
Peter Rabbitson [Sat, 3 Oct 2009 18:12:40 +0000]
Changes

15 years agoOracle/SQLite test adjustments to deal with new testdata field
Peter Rabbitson [Sat, 3 Oct 2009 18:11:03 +0000]
Oracle/SQLite test adjustments to deal with new testdata field