Johannes Plunien [Sat, 1 Nov 2008 20:39:56 +0000]
triggers may NOT end with a semicolon
Johannes Plunien [Sat, 1 Nov 2008 20:39:12 +0000]
updated Changes
Johannes Plunien [Sat, 1 Nov 2008 20:38:40 +0000]
using unreserved table name for FK alter statements in oracle producer
Johannes Plunien [Sat, 1 Nov 2008 20:38:13 +0000]
add semicolon to CREATE TRIGGER after END which i have removed before accidentally
Johannes Plunien [Sat, 1 Nov 2008 20:37:56 +0000]
ensure to not exceed max allowed size for oracle data types
Johannes Plunien [Sat, 1 Nov 2008 20:37:37 +0000]
using unreserved table name for drop statements in oracle producer
Johannes Plunien [Sat, 1 Nov 2008 20:37:20 +0000]
delayed adding semicolon in oracle producer
Jess Robinson [Wed, 22 Oct 2008 21:19:45 +0000]
Patch from jgoulah for mysqls UNION (merge engine) option
Jess Robinson [Tue, 21 Oct 2008 13:09:31 +0000]
Patch from rbo to support multiple database events per trigger
Jess Robinson [Tue, 21 Oct 2008 12:45:43 +0000]
Default sqlite_version so we dont get uninitialised errors when calling from ::Diff
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
Jess Robinson [Fri, 17 Oct 2008 21:00:22 +0000]
Missed file from default-value-improvements commit
Jess Robinson [Thu, 9 Oct 2008 22:27:41 +0000]
Now supporting scalar refs as default values! (rjbs)
Jess Robinson [Thu, 9 Oct 2008 19:08:29 +0000]
lukes' patch: drop if exists under sqlite 3.3+
Jess Robinson [Thu, 9 Oct 2008 18:49:40 +0000]
Skip on newer Spreadsheet::ParseExcel
Add new oracle bits to MANIFEST
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
Jess Robinson [Wed, 17 Sep 2008 13:29:09 +0000]
Pg views and sqlite views, patch from wreis
Jess Robinson [Fri, 29 Aug 2008 08:39:35 +0000]
Update mysql producer test to saner field names, Peter R.
Jess Robinson [Thu, 28 Aug 2008 22:08:32 +0000]
Updated authors/Changes
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.
Jess Robinson [Thu, 28 Aug 2008 21:39:41 +0000]
Add target_db to diff test as it was producing warnings..
Jess Robinson [Tue, 26 Aug 2008 22:28:49 +0000]
Added patch from wreis, view support for pg producer
Jess Robinson [Tue, 26 Aug 2008 21:46:44 +0000]
Added patch from groditi to support views in sqlite
Ash Berlin [Tue, 19 Aug 2008 15:37:13 +0000]
Only create views for mysql on v5 and up
Ash Berlin [Tue, 19 Aug 2008 15:18:33 +0000]
svk-commitdCGXq.tmp
Jess Robinson [Tue, 19 Aug 2008 15:14:43 +0000]
Add views to mysql producer, thanks groditi
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.
Jess Robinson [Tue, 1 Jul 2008 12:26:34 +0000]
Added patch from groditi adding SET type support to the mysql producer
Jess Robinson [Thu, 12 Jun 2008 12:15:32 +0000]
Patch from ribasushi: Correctly graph self-referential constraints
Jess Robinson [Tue, 10 Jun 2008 15:34:02 +0000]
Make Schema::Graph only load if "as_graph" is called on a Schema object
Jess Robinson [Tue, 3 Jun 2008 20:26:30 +0000]
Applied patch from Ryan to uniqify index names sanely for the mysql producer
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
Ben Faga [Mon, 28 Apr 2008 14:01:24 +0000]
Support uppercase foreign key target-columns. Sent in by Daniel Boehringer
Daniel Ruoso [Wed, 23 Apr 2008 14:49:34 +0000]
Implemented add_field, only the field is added, nothing more for now.
Daniel Ruoso [Wed, 23 Apr 2008 14:49:13 +0000]
Adding tests for Oracle->add_field
Daniel Ruoso [Mon, 21 Apr 2008 12:09:44 +0000]
Small fix in delay_constraints (missing ;).
Daniel Ruoso [Mon, 14 Apr 2008 17:29:23 +0000]
Fix ORA-01442: column to be modified to NOT NULL is already NOT NULL
Daniel Ruoso [Mon, 14 Apr 2008 17:07:21 +0000]
Including new test and test data into MANIFEST
Daniel Ruoso [Mon, 14 Apr 2008 17:07:09 +0000]
alter_field implemented. alter_field test Pass.
Daniel Ruoso [Mon, 14 Apr 2008 17:06:41 +0000]
Test for oracle alter_field
Daniel Ruoso [Mon, 14 Apr 2008 14:06:10 +0000]
Declares the new tests in the MANIFEST, remove useless warnings
Daniel Ruoso [Mon, 14 Apr 2008 14:05:49 +0000]
Define a name for pk constraint when delay_constraints is on
Daniel Ruoso [Mon, 14 Apr 2008 14:05:13 +0000]
Document delay_constraints producer_args option
Daniel Ruoso [Mon, 14 Apr 2008 14:04:44 +0000]
producer_args->{delay_constraints} can be used to add primary keys later
Daniel Ruoso [Mon, 14 Apr 2008 14:04:08 +0000]
Fix weird bug, caused by a double evaluation in ternary if
Daniel Ruoso [Mon, 14 Apr 2008 14:03:47 +0000]
implements options in oracle indexes
Daniel Ruoso [Mon, 14 Apr 2008 14:02:59 +0000]
waiting for patch to be applied
Ash Berlin [Tue, 1 Apr 2008 14:09:33 +0000]
Fix suprious diff on cols with charsets/collates (MySQL)
Jess Robinson [Wed, 26 Mar 2008 20:55:10 +0000]
Add support for proper boolean fields in the mysql producer, as of v4.x
Ash Berlin [Mon, 17 Mar 2008 21:44:48 +0000]
Fix false-diffing due to order of table options
Jess Robinson [Wed, 5 Mar 2008 10:14:53 +0000]
Updated change file
Jess Robinson [Wed, 5 Mar 2008 10:14:22 +0000]
Added support for proper enums under pg (as of 8.3), with pg version check, and deferrable constraints
Patch from Debolaz
Ash Berlin [Mon, 3 Mar 2008 19:00:25 +0000]
Allow quote and other option to be passed to the producers.
Jess Robinson [Mon, 3 Mar 2008 13:06:49 +0000]
0.09000 not 0.0900 (cpan gets confused if numbers go downwards)
Ash Berlin [Tue, 26 Feb 2008 12:10:20 +0000]
Remove breakpoint
Jess Robinson [Mon, 25 Feb 2008 13:01:10 +0000]
Update changes with latest release date
Jess Robinson [Mon, 25 Feb 2008 12:54:53 +0000]
Add DBI dep (oops)
Update versions for 0.0900
Ash Berlin [Wed, 6 Feb 2008 15:17:18 +0000]
Fix drop indexes for uniq constraints
Ash Berlin [Wed, 6 Feb 2008 13:22:27 +0000]
Allow DEFAULT CHARACTER SET without '=' (as produced by mysqldump)
Ash Berlin [Wed, 6 Feb 2008 13:07:14 +0000]
Add support for COLLATE table option to MySQL parser
Jess Robinson [Wed, 6 Feb 2008 13:06:22 +0000]
Update changes/version for 0.0899_02
Jess Robinson [Fri, 1 Feb 2008 23:39:07 +0000]
Oops, fix tests for fixed syntax
Jess Robinson [Fri, 1 Feb 2008 23:28:20 +0000]
Fix syntax for index dropping in sqlite producer
Ash Berlin [Thu, 31 Jan 2008 11:37:09 +0000]
Document significance of preproces_schema method
Ash Berlin [Wed, 30 Jan 2008 11:04:40 +0000]
Fix warning messages
Jess Robinson [Tue, 29 Jan 2008 13:41:23 +0000]
Update oracle producer, patch from plu.
Update postgres producer, patch from wreis
Ash Berlin [Mon, 28 Jan 2008 19:27:01 +0000]
Merging back Diff refactor
Branch for diff refactoring
r11566@proteus (orig r1319): ashberlin | 2007-11-27 13:34:56 +0000
MAss diff changes imported from Ash's local diff-refactor branch
r12366@proteus (orig r1320): ashberlin | 2007-12-13 17:53:49 +0000
Some work on sanely normalizing fields
r12369@proteus (orig r1321): ashberlin | 2007-12-16 22:24:00 +0000
Some SQL_TYPE mapping stuff
r12748@proteus (orig r1324): ashberlin | 2007-12-20 16:54:56 +0000
Fix some more normalization problems
r12749@proteus (orig r1325): ashberlin | 2007-12-20 17:23:44 +0000
Remove breakpoints
r12798@proteus (orig r1327): ashberlin | 2007-12-21 10:02:30 +0000
Fix test
r13120@proteus (orig r1328): ashberlin | 2008-01-10 13:55:19 +0000
Correct constraint names in preprocess for MySQL producer
r13152@proteus (orig r1329): ashberlin | 2008-01-10 15:12:57 +0000
Move more normalization changes to preprocess_schema
r13244@proteus (orig r1331): ashberlin | 2008-01-12 13:47:18 +0000
Fix after typo in merge
r13297@proteus (orig r1332): ashberlin | 2008-01-15 23:34:54 +0000
Add renamed_from to tables.
r13309@proteus (orig r1333): ashberlin | 2008-01-16 22:44:29 +0000
Start transactions in a portable manner
r13310@proteus (orig r1334): ashberlin | 2008-01-16 23:47:59 +0000
Work round MySQL/InnoDB bug http://bugs.mysql.com/bug.php?id=13741
r13311@proteus (orig r1335): ashberlin | 2008-01-16 23:50:00 +0000
Fix BEGIN in sqlite diff test
r13677@proteus (orig r1336): ashberlin | 2008-01-21 16:22:51 +0000
Better tests (and fix bug) in batch alter with renamed tables + constraints
Ash Berlin [Mon, 21 Jan 2008 16:22:51 +0000]
Better tests (and fix bug) in batch alter with renamed tables + constraints
Ash Berlin [Wed, 16 Jan 2008 23:50:00 +0000]
Fix BEGIN in sqlite diff test
Ash Berlin [Wed, 16 Jan 2008 23:47:59 +0000]
Work round MySQL/InnoDB bug bugs.mysql.com/bug.php?id=13741
Ash Berlin [Wed, 16 Jan 2008 22:44:29 +0000]
Start transactions in a portable manner
Ash Berlin [Tue, 15 Jan 2008 23:34:54 +0000]
Add renamed_from to tables.
Ash Berlin [Sat, 12 Jan 2008 13:47:18 +0000]
Fix after typo in merge
Ash Berlin [Sat, 12 Jan 2008 13:42:42 +0000]
Added an 'alter sequence' line to the parser grammer which will simply skip over an alter sequence statement.
Added a select section to the parser. This is to handle function calls that
may affect the tables during creation.
Added the setval function. Unfortunately, nothing is being done with this
because the parser doesn't seem to handle sequences.
Skipping all COPY commands because they are not needed for schema creation.
Added a line each for revoking and granting permissions for a schema. This
doesn't actually do anything with that information.
Applied patch submitted by Nathan Gray
Removes periods in an index/constraint name caused by schema.tablename being appended to the name.
Strips a schema from the table name during index/constraint creation because a schema-qualified table name is not allowed.
r12687@metis (orig r1322): mwz444 | 2007-12-18 16:20:28 +0000
r12747@metis (orig r1323): mwz444 | 2007-12-20 15:48:09 +0000
r12797@metis (orig r1326): mwz444 | 2007-12-20 20:07:22 +0000
Ash Berlin [Thu, 10 Jan 2008 15:12:57 +0000]
Move more normalization changes to preprocess_schema
Ash Berlin [Thu, 10 Jan 2008 13:55:19 +0000]
Correct constraint names in preprocess for MySQL producer
Ash Berlin [Fri, 21 Dec 2007 10:02:30 +0000]
Fix test
Ben Faga [Thu, 20 Dec 2007 20:07:22 +0000]
Applied patch submitted by Nathan Gray
Removes periods in an index/constraint name caused by schema.tablename being appended to the name.
Strips a schema from the table name during index/constraint creation because a schema-qualified table name is not allowed.
Ash Berlin [Thu, 20 Dec 2007 17:23:44 +0000]
Remove breakpoints
Ash Berlin [Thu, 20 Dec 2007 16:54:56 +0000]
Fix some more normalization problems
Ben Faga [Thu, 20 Dec 2007 15:48:09 +0000]
Added a select section to the parser. This is to handle function calls that
may affect the tables during creation.
Added the setval function. Unfortunately, nothing is being done with this
because the parser doesn't seem to handle sequences.
Skipping all COPY commands because they are not needed for schema creation.
Added a line each for revoking and granting permissions for a schema. This
doesn't actually do anything with that information.
Ben Faga [Tue, 18 Dec 2007 16:20:28 +0000]
Added an 'alter sequence' line to the parser grammer which will simply skip over an alter sequence statement.
Ash Berlin [Sun, 16 Dec 2007 22:24:00 +0000]
Some SQL_TYPE mapping stuff
Ash Berlin [Thu, 13 Dec 2007 17:53:49 +0000]
Some work on sanely normalizing fields
Ash Berlin [Tue, 27 Nov 2007 13:34:56 +0000]
MAss diff changes imported from Ash's local diff-refactor branch
Ash Berlin [Tue, 27 Nov 2007 11:21:30 +0000]
Branch for diff refactoring
Ben Faga [Mon, 19 Nov 2007 21:24:01 +0000]
Added fixes submitted by Peter Rabbitson:
Fix POD incorrectly referring to argument show_sizes as show_col_sizes
Fix POD formatting errors (=item instead of ==item)
Fix and improve handling of the skip_fields argument (silence warning)
Ben Faga [Tue, 13 Nov 2007 19:25:04 +0000]
Allows schema-qualified table names.
Fix suggested by Ken Clark.
Ben Faga [Sat, 10 Nov 2007 03:36:43 +0000]
Changed the name of unnamed foreign key constraints to TABLENAME_fk.
Ben Faga [Fri, 9 Nov 2007 20:50:17 +0000]
Fixed a problem where the deferrable definition required to have a "not".
Jess Robinson [Wed, 24 Oct 2007 10:59:25 +0000]
Only run test if Graph::Directed installed
Jess Robinson [Wed, 24 Oct 2007 10:58:35 +0000]
0.0899_01 diffing fixes
Jess Robinson [Wed, 26 Sep 2007 13:20:09 +0000]
Ignore all TT test while TT is broken
Jess Robinson [Wed, 26 Sep 2007 12:36:39 +0000]
Fix to not test while TT is broken
Ben Faga [Mon, 4 Jun 2007 04:01:14 +0000]
Committing patches sent by Florian Helmberger. Here are his remarks:
Here are two patches for a few bugs in the PostgreSQL parser and producer.
The patch for lib/SQL/Translator/Parser/DBI/PostgreSQL.pm fixes a simple
typo which resulted in the complete absence of the field types and
corrects the way is_nullable is set so the producer now correctly flags
NOT NULL fields.
The patch for lib/SQL/Translator/Producer/PostgreSQL.pm adds missing
newlines to the last line of the 'Table:' and 'Comments:' headers. Also
it fixes an 'use of uninizialised value' warning in 359.
Before the patch the output for command
sqlt --from DBI --dsn dbi:Pg:dbname=testdb --to PostgreSQL \
--db-user postgres
looked like:
====
--
-- Table: mailaliases
--CREATE TABLE "mailaliases" (
"aliasname" (204),
"aliasto" (204),
"domain" (132),
"id" ,
"isdefault" ,
"datecreate" ,
Constraint "foo" UNIQUE ("isdefault")
);
====
After the patch it looks like:
====
--
-- Table: mailaliases
--
CREATE TABLE "mailaliases" (
"aliasname" character varying(204),
"aliasto" character varying(204),
"domain" character varying(132),
"id" int4 NOT NULL,
"isdefault" int4,
"datecreate" text,
Constraint "foo" UNIQUE ("isdefault")
);
====
Ben Faga [Mon, 7 May 2007 20:58:56 +0000]
Applied Hilmar's patches.
Chris Hilton [Thu, 12 Apr 2007 15:14:59 +0000]
Ignore views and procedures with no text (weeds out exatraneous results from SQL Server 2005)
Chris Hilton [Wed, 21 Mar 2007 15:21:31 +0000]
Added command-line option for MySQL parser version arg
Chris Hilton [Wed, 21 Mar 2007 15:20:50 +0000]
Added options for ignoring the differences in SQL for views and procedures
Chris Hilton [Mon, 19 Mar 2007 22:32:31 +0000]
Added cursory parsing of views and procedures