15 years agoDowngrade global version - highest version in 9002 on cpan is 1.58 - thus go with...
Peter Rabbitson [Fri, 13 Feb 2009 08:15:01 +0000]
Downgrade global version - highest version in 9002 on cpan is 1.58 - thus go with 1.59

15 years agoSchema::Graph - switch ugly use of Log4perl to an even uglier (but at least available...
Peter Rabbitson [Fri, 13 Feb 2009 07:41:51 +0000]
Schema::Graph - switch ugly use of Log4perl to an even uglier (but at least available) use of Class::Base for debug messages
Lose l4p dependency

15 years agoForgot to up one VERSION
Peter Rabbitson [Thu, 12 Feb 2009 08:51:31 +0000]
Forgot to up one VERSION

15 years agoRemove all expansion $XX tags (isolated commit, easily revertable)
Peter Rabbitson [Thu, 12 Feb 2009 01:35:44 +0000]
Remove all expansion $XX tags (isolated commit, easily revertable)

15 years agoCleanup part 2
Peter Rabbitson [Thu, 12 Feb 2009 01:33:21 +0000]
Cleanup part 2

15 years agoMinor test cleanup
Peter Rabbitson [Thu, 12 Feb 2009 01:32:39 +0000]
Minor test cleanup

15 years agoReduce $Id to its normal form
Peter Rabbitson [Thu, 12 Feb 2009 01:22:27 +0000]
Reduce $Id to its normal form

15 years agoForce everything to 1.99, hopefully will work
Peter Rabbitson [Thu, 12 Feb 2009 00:35:06 +0000]
Force everything to 1.99, hopefully will work

15 years agoActually there was an empty test for it as well :)
Peter Rabbitson [Thu, 12 Feb 2009 00:33:06 +0000]
Actually there was an empty test for it as well :)

15 years agoThis file is empty, tests seem fine... deleting
Peter Rabbitson [Thu, 12 Feb 2009 00:29:39 +0000]
This file is empty, tests seem fine... deleting

15 years agoStrip evil svn:keywords
Peter Rabbitson [Wed, 11 Feb 2009 23:38:14 +0000]
Strip evil svn:keywords

15 years agoAnother chunk of the GraphViz rewrite:
Peter Rabbitson [Tue, 10 Feb 2009 11:48:37 +0000]
Another chunk of the GraphViz rewrite:
- Remove internal VALID_OUTPUT check - determine whether valid by calling GraphViz directly
- Streamline the handling of the out_file parameter (now can be a string, a FH or undef

15 years agoUpdate autogenerated makefile
Peter Rabbitson [Mon, 9 Feb 2009 23:26:51 +0000]
Update autogenerated makefile

15 years agoTranslate bytea to BLOB in MySQL producer. This fixes a few tests of DBIC if you...
Johannes Plunien [Mon, 9 Feb 2009 12:25:32 +0000]
Translate bytea to BLOB in MySQL producer. This fixes a few tests of DBIC if you run the full test-suite against MySQL instead of SQLite

15 years agoRelease 0.09003
Peter Rabbitson [Sat, 7 Feb 2009 18:32:52 +0000]
Release 0.09003

15 years agoMove XMI stuff to branches/xmi since no one has worked on them and the tests have...
Ash Berlin [Sat, 7 Feb 2009 18:01:44 +0000]
Move XMI stuff to branches/xmi since no one has worked on them and the tests have failed for years, and they've been skipped from dists for an equally long time

15 years agoFix tests! historic/state_before_xmi_deletion_47b3b29f
Ash Berlin [Sat, 7 Feb 2009 17:50:03 +0000]
Fix tests!

15 years agosvk-commitTn2OH.tmp
Ash Berlin [Sat, 7 Feb 2009 15:53:56 +0000]
svk-commitTn2OH.tmp

15 years agoAdd sqlite roundtrip test (probably need to do the same for the rest of the parser...
Peter Rabbitson [Tue, 3 Feb 2009 14:16:27 +0000]
Add sqlite roundtrip test (probably need to do the same for the rest of the parser/producer combos, possibly using a known xml schema as a starting point)

15 years agoReverted VERSION so it was no longer dependent on $Revision$, the semantics of which...
Jonathan Yu [Thu, 29 Jan 2009 16:29:37 +0000]
Reverted VERSION so it was no longer dependent on $Revision$, the semantics of which are different under SVN

15 years agoChanged show_index_name to show_index_names to make it better match the other options
Jonathan Yu [Sat, 17 Jan 2009 17:08:06 +0000]
Changed show_index_name to show_index_names to make it better match the other options

15 years ago- Removed use of $Revision$ SVN keyword to generate VERSION variables; now sub-module...
Jonathan Yu [Sat, 17 Jan 2009 16:31:57 +0000]
- Removed use of $Revision$ SVN keyword to generate VERSION variables; now sub-modules are unversioned.

I'm not sure if this is the right thing to do, but svn doesn't provide version numbers like CVS used to. I think module versions, if necessary, should be adjusted manually.

15 years agoAdded a Module::Build::Compat 'passthrough' Makefile.PL
Jonathan Yu [Sat, 17 Jan 2009 16:29:20 +0000]
Added a Module::Build::Compat 'passthrough' Makefile.PL

15 years ago- Updated copyright, added myself to contributors list
Jonathan Yu [Sat, 17 Jan 2009 16:08:55 +0000]
- Updated copyright, added myself to contributors list

15 years ago- Merged some changes by myself, and also from ribasushi
Jonathan Yu [Sat, 17 Jan 2009 16:07:48 +0000]
- Merged some changes by myself, and also from ribasushi

15 years ago- Added myself to the SQL::Translator file as an author
Jonathan Yu [Sat, 17 Jan 2009 15:36:16 +0000]
- Added myself to the SQL::Translator file as an author

15 years ago- Added myself to the AUTHORS file
Jonathan Yu [Sat, 17 Jan 2009 15:35:25 +0000]
- Added myself to the AUTHORS file

15 years ago- Some minor cosmetic changes
Jonathan Yu [Sat, 17 Jan 2009 15:32:51 +0000]
- Some minor cosmetic changes
- Added meta_merge for META.yml data

15 years ago- Added some stuff to MANIFEST.SKIP
Jonathan Yu [Sat, 17 Jan 2009 15:10:56 +0000]
- Added some stuff to MANIFEST.SKIP
- Enabled svn:keyword's: Revision, Id, LastChangedBy

15 years ago- Fixed POD producer
Jonathan Yu [Wed, 14 Jan 2009 15:56:38 +0000]
- Fixed POD producer
Bug: constraints were not providing two newlines \n\n after each item; the =back command was not put on a different line, causing POD errors

15 years ago- Add support for 'extended' friendly ints (the nonstandard extensions provided by...
Jonathan Yu [Wed, 14 Jan 2009 15:41:55 +0000]
- Add support for 'extended' friendly ints (the nonstandard extensions provided by MySQL)

15 years ago- Fixes a bug where _apply_default_value is not found (due to it being part of SQL...
Jonathan Yu [Wed, 14 Jan 2009 15:00:41 +0000]
- Fixes a bug where _apply_default_value is not found (due to it being part of SQL::Translator::Producer); does this by simply making this PostgreSQL producer a subclass of the SQLT::Producer base.

15 years ago- Added a show_index_name parameter which determines whether index names should be...
Jonathan Yu [Sat, 10 Jan 2009 16:56:50 +0000]
- Added a show_index_name parameter which determines whether index names should be shown. If false, then the module will just print a list of tuples of indexed fields.
- Fixed a bug where unindexed tables would have an extra empty box

15 years agoSince Oracle understands a double precision floating point type, I added "double...
Jonathan Yu [Sat, 10 Jan 2009 02:49:06 +0000]
Since Oracle understands a double precision floating point type, I added "double" to the ora_data_type file.

Per: http://www.ss64.com/orasyntax/datatypes.html [refer to the NUMBER section; double is an alias of that]
Closes: Bug #2100879 - http://sourceforge.net/tracker2/?func=detail&aid=2100879&group_id=47619&atid=450052

15 years ago- Minor documentation changes. Namely, noted that the index types are stored internal...
Jonathan Yu [Fri, 9 Jan 2009 04:18:06 +0000]
- Minor documentation changes. Namely, noted that the index types are stored internally as uppercase; this is the only way to ensure the Producer modules still work properly.
- Cosmetic change to avoid bareword 'NORMAL' for index types - simply surrounded the return value with single quotes

15 years ago- Updated GraphViz producer module per the modifications discussed on the sqlfairy...
Jonathan Yu [Fri, 9 Jan 2009 04:16:38 +0000]
- Updated GraphViz producer module per the modifications discussed on the sqlfairy-developers mailing list (mail-archive.com/sqlfairy-developers@lists.sourceforge.net/msg00223.html)
- Cleaned up map{} code
- Added show_indexes and friendly_ints options.

TODO: the revision still needs to be updated. I'm using SVN, so it will have to be updated manually.

15 years agoSupport for temporary tables in Pg, from nachos
Jess Robinson [Mon, 29 Dec 2008 00:53:08 +0000]
Support for temporary tables in Pg, from nachos

15 years agoadded release-date to Changes
Johannes Plunien [Fri, 5 Dec 2008 13:20:00 +0000]
added release-date to Changes

15 years agoremoved semicolon from CREATE VIEW in oracle producer
Johannes Plunien [Fri, 5 Dec 2008 13:19:34 +0000]
removed semicolon from CREATE VIEW in oracle producer

15 years agofixed *old regex, added *tar.gz regex in MANIFEST.SKIP
Johannes Plunien [Fri, 5 Dec 2008 13:18:45 +0000]
fixed *old regex, added *tar.gz regex in MANIFEST.SKIP

15 years agofixed 51-xml-to-oracle.t
Johannes Plunien [Fri, 5 Dec 2008 13:18:27 +0000]
fixed 51-xml-to-oracle.t

15 years agoSince MANIFEST.SKIP is in svn, this file does not belong
Ash Berlin [Fri, 5 Dec 2008 12:37:59 +0000]
Since MANIFEST.SKIP is in svn, this file does not belong

15 years agoPgSQL diff patch from wries
Ash Berlin [Thu, 4 Dec 2008 16:45:46 +0000]
PgSQL diff patch from wries
(also fixed line lengths in Changes)

15 years agofix test expectations
Ricardo Signes [Tue, 2 Dec 2008 20:21:40 +0000]
fix test expectations

15 years agoproperly compare fields
Ricardo Signes [Tue, 2 Dec 2008 20:18:20 +0000]
properly compare fields

15 years agoreverting r1413 and r1414 in favor of passing a scalar ref to parser which the produc...
John Goulah [Tue, 2 Dec 2008 15:15:39 +0000]
reverting r1413 and r1414 in favor of passing a scalar ref to parser which the producer outputs correctly without quotes

15 years agoneeded to tighten up regex added in last commit
John Goulah [Mon, 1 Dec 2008 21:19:50 +0000]
needed to tighten up regex added in last commit

15 years agoadd param to _apply_default_value so that certain values can output without quotes
John Goulah [Mon, 1 Dec 2008 17:26:36 +0000]
add param to _apply_default_value so that certain values can output without quotes

16 years agoadded ignore_opts parser arg to ignore table options
John Goulah [Wed, 26 Nov 2008 17:50:10 +0000]
added ignore_opts parser arg to ignore table options

16 years agoSkip tests for buggy Spreadsheet::ParseExcel versions (rbo)
Johannes Plunien [Mon, 24 Nov 2008 15:08:18 +0000]
Skip tests for buggy Spreadsheet::ParseExcel versions (rbo)

16 years agoadd support for a skip option to the parser
John Goulah [Thu, 20 Nov 2008 22:52:46 +0000]
add support for a skip option to the parser

16 years agoadded notes about changed behaviour when calling oracle producer in array/scalar...
Johannes Plunien [Tue, 4 Nov 2008 09:22:56 +0000]
added notes about changed behaviour when calling oracle producer in array/scalar context

16 years agoMETA.yaml is generated at build time and does not beling in the repo
Ash Berlin [Sat, 1 Nov 2008 21:46:18 +0000]
META.yaml is generated at build time and does not beling in the repo

16 years agoRemoved source_db and target_db accessors from Diff (throwback to old version, only...
Ash Berlin [Sat, 1 Nov 2008 21:40:06 +0000]
Removed source_db and target_db accessors from Diff (throwback to old version, only output_db is used)

16 years agoIf wantarray is set we have to omit the last "/" in this statement so it can be execu...
Johannes Plunien [Sat, 1 Nov 2008 20:40:22 +0000]
If wantarray is set we have to omit the last "/" in this statement so it can be executed by DBI->do() directly.

16 years agotriggers may NOT end with a semicolon
Johannes Plunien [Sat, 1 Nov 2008 20:39:56 +0000]
triggers may NOT end with a semicolon

16 years agoupdated Changes
Johannes Plunien [Sat, 1 Nov 2008 20:39:12 +0000]
updated Changes

16 years agousing unreserved table name for FK alter statements in oracle producer
Johannes Plunien [Sat, 1 Nov 2008 20:38:40 +0000]
using unreserved table name for FK alter statements in oracle producer

16 years agoadd semicolon to CREATE TRIGGER after END which i have removed before accidentally
Johannes Plunien [Sat, 1 Nov 2008 20:38:13 +0000]
add semicolon to CREATE TRIGGER after END which i have removed before accidentally

16 years agoensure to not exceed max allowed size for oracle data types
Johannes Plunien [Sat, 1 Nov 2008 20:37:56 +0000]
ensure to not exceed max allowed size for oracle data types

16 years agousing unreserved table name for drop statements in oracle producer
Johannes Plunien [Sat, 1 Nov 2008 20:37:37 +0000]
using unreserved table name for drop statements in oracle producer

16 years agodelayed adding semicolon in oracle producer
Johannes Plunien [Sat, 1 Nov 2008 20:37:20 +0000]
delayed adding semicolon in oracle producer

16 years agoPatch from jgoulah for mysqls UNION (merge engine) option
Jess Robinson [Wed, 22 Oct 2008 21:19:45 +0000]
Patch from jgoulah for mysqls UNION (merge engine) option

16 years agoPatch from rbo to support multiple database events per trigger
Jess Robinson [Tue, 21 Oct 2008 13:09:31 +0000]
Patch from rbo to support multiple database events per trigger

16 years agoDefault sqlite_version so we dont get uninitialised errors when calling from ::Diff
Jess Robinson [Tue, 21 Oct 2008 12:45:43 +0000]
Default sqlite_version so we dont get uninitialised errors when calling from ::Diff

16 years agoPatches for/with jgoulah:
Jess Robinson [Mon, 20 Oct 2008 15:30:53 +0000]
Patches for/with jgoulah:
- make mysql parser match anything as a col/table name when quoted
- add support for spatial index parsing

16 years agoMissed file from default-value-improvements commit
Jess Robinson [Fri, 17 Oct 2008 21:00:22 +0000]
Missed file from default-value-improvements commit

16 years agoNow supporting scalar refs as default values! (rjbs)
Jess Robinson [Thu, 9 Oct 2008 22:27:41 +0000]
Now supporting scalar refs as default values! (rjbs)

16 years agolukes' patch: drop if exists under sqlite 3.3+
Jess Robinson [Thu, 9 Oct 2008 19:08:29 +0000]
lukes' patch: drop if exists under sqlite 3.3+

16 years agoSkip on newer Spreadsheet::ParseExcel
Jess Robinson [Thu, 9 Oct 2008 18:49:40 +0000]
Skip on newer Spreadsheet::ParseExcel
Add new oracle bits to MANIFEST

16 years agoBy royal decree, produced statements in list context shall not end in a semi-colon...
Jess Robinson [Wed, 8 Oct 2008 21:43:36 +0000]
By royal decree, produced statements in list context shall not end in a semi-colon, or any newlines! (They may contain newlines)
Also fixed SQLite index statements, which were missing vital newlines

16 years agoPg views and sqlite views, patch from wreis
Jess Robinson [Wed, 17 Sep 2008 13:29:09 +0000]
Pg views and sqlite views, patch from wreis

16 years agoUpdate mysql producer test to saner field names, Peter R.
Jess Robinson [Fri, 29 Aug 2008 08:39:35 +0000]
Update mysql producer test to saner field names, Peter R.

16 years agoUpdated authors/Changes
Jess Robinson [Thu, 28 Aug 2008 22:08:32 +0000]
Updated authors/Changes

16 years agoEnormous patch from Peter Rabbitson making mysql version parsing saner and adding...
Jess Robinson [Thu, 28 Aug 2008 21:41:28 +0000]
Enormous patch from Peter Rabbitson making mysql version parsing saner and adding tests for it.

16 years agoAdd target_db to diff test as it was producing warnings..
Jess Robinson [Thu, 28 Aug 2008 21:39:41 +0000]
Add target_db to diff test as it was producing warnings..

16 years agoAdded patch from wreis, view support for pg producer
Jess Robinson [Tue, 26 Aug 2008 22:28:49 +0000]
Added patch from wreis, view support for pg producer

16 years agoAdded patch from groditi to support views in sqlite
Jess Robinson [Tue, 26 Aug 2008 21:46:44 +0000]
Added patch from groditi to support views in sqlite

16 years agoOnly create views for mysql on v5 and up
Ash Berlin [Tue, 19 Aug 2008 15:37:13 +0000]
Only create views for mysql on v5 and up

16 years agosvk-commitdCGXq.tmp
Ash Berlin [Tue, 19 Aug 2008 15:18:33 +0000]
svk-commitdCGXq.tmp

16 years agoAdd views to mysql producer, thanks groditi
Jess Robinson [Tue, 19 Aug 2008 15:14:43 +0000]
Add views to mysql producer, thanks groditi

16 years agoApplied patches written by Nigel Metheringham. His notes follow.
Ben Faga [Mon, 28 Jul 2008 12:36:07 +0000]
Applied patches written by Nigel Metheringham.  His notes follow.
---

The postgres producer uses a hash as both a single level and a 2 level
symbol table for ensuring names are unique which causes some interesting
failures when a database has constraint names which match table names.

I've replaced the code with effectively the same code as the mysql
producer uses, massaged very slightly so as in the most cases to
produce the same name remapping as the old code but without the
extra explosions when it attempts to deref a scalar as a hash.

---

When a table has more than one index, all but the last CREATE INDEX
commands produced have a doubled semi-colon at the end of them.

This causes the parser for postgresql to explode :-)

One line bug fix appears to sort it.

16 years agoAdded patch from groditi adding SET type support to the mysql producer
Jess Robinson [Tue, 1 Jul 2008 12:26:34 +0000]
Added patch from groditi adding SET type support to the mysql producer

16 years agoPatch from ribasushi: Correctly graph self-referential constraints
Jess Robinson [Thu, 12 Jun 2008 12:15:32 +0000]
Patch from ribasushi: Correctly graph self-referential constraints

16 years agoMake Schema::Graph only load if "as_graph" is called on a Schema object
Jess Robinson [Tue, 10 Jun 2008 15:34:02 +0000]
Make Schema::Graph only load if "as_graph" is called on a Schema object

16 years agoApplied patch from Ryan to uniqify index names sanely for the mysql producer
Jess Robinson [Tue, 3 Jun 2008 20:26:30 +0000]
Applied patch from Ryan to uniqify index names sanely for the mysql producer

16 years agoMade change suggested by Daniel Böhringer to allow "ID" integer DEFAULT nextval(...
Ben Faga [Mon, 19 May 2008 20:57:14 +0000]
Made change suggested by Daniel Böhringer to allow "ID" integer DEFAULT nextval(('"AlleStudien_ID_seq"'::text)::regclass), to parse properly

16 years agoSupport uppercase foreign key target-columns. Sent in by Daniel Boehringer
Ben Faga [Mon, 28 Apr 2008 14:01:24 +0000]
Support uppercase foreign key target-columns.  Sent in by Daniel Boehringer

16 years agoImplemented add_field, only the field is added, nothing more for now.
Daniel Ruoso [Wed, 23 Apr 2008 14:49:34 +0000]
Implemented add_field, only the field is added, nothing more for now.

16 years agoAdding tests for Oracle->add_field
Daniel Ruoso [Wed, 23 Apr 2008 14:49:13 +0000]
Adding tests for Oracle->add_field

16 years agoSmall fix in delay_constraints (missing ;).
Daniel Ruoso [Mon, 21 Apr 2008 12:09:44 +0000]
Small fix in delay_constraints (missing ;).

16 years agoFix ORA-01442: column to be modified to NOT NULL is already NOT NULL
Daniel Ruoso [Mon, 14 Apr 2008 17:29:23 +0000]
Fix ORA-01442: column to be modified to NOT NULL is already NOT NULL

16 years agoIncluding new test and test data into MANIFEST
Daniel Ruoso [Mon, 14 Apr 2008 17:07:21 +0000]
Including new test and test data into MANIFEST

16 years agoalter_field implemented. alter_field test Pass.
Daniel Ruoso [Mon, 14 Apr 2008 17:07:09 +0000]
alter_field implemented. alter_field test Pass.

16 years agoTest for oracle alter_field
Daniel Ruoso [Mon, 14 Apr 2008 17:06:41 +0000]
Test for oracle alter_field

16 years agoDeclares the new tests in the MANIFEST, remove useless warnings
Daniel Ruoso [Mon, 14 Apr 2008 14:06:10 +0000]
Declares the new tests in the MANIFEST, remove useless warnings

16 years agoDefine a name for pk constraint when delay_constraints is on
Daniel Ruoso [Mon, 14 Apr 2008 14:05:49 +0000]
Define a name for pk constraint when delay_constraints is on

16 years agoDocument delay_constraints producer_args option
Daniel Ruoso [Mon, 14 Apr 2008 14:05:13 +0000]
Document delay_constraints producer_args option

16 years agoproducer_args->{delay_constraints} can be used to add primary keys later
Daniel Ruoso [Mon, 14 Apr 2008 14:04:44 +0000]
producer_args->{delay_constraints} can be used to add primary keys later

16 years agoFix weird bug, caused by a double evaluation in ternary if
Daniel Ruoso [Mon, 14 Apr 2008 14:04:08 +0000]
Fix weird bug, caused by a double evaluation in ternary if