Chris Hilton [Mon, 19 Mar 2007 17:15:54 +0000]
Added mysql-parser-version command-line option
Chris Hilton [Mon, 19 Mar 2007 17:15:24 +0000]
Added cursory parsing of view, functions, and procedures (oh why!)
Added pre-processing for /*! comments from mysqldump
Added mysql_parser_version parser arg for enabling parsing not-before-version comments from mysqldump
Chris Hilton [Mon, 19 Mar 2007 17:11:02 +0000]
Removed unused rules procedure_body and view_body
Chris Hilton [Mon, 19 Mar 2007 17:10:25 +0000]
Small change to ordering of view and procedure diffs
Chris Hilton [Wed, 14 Mar 2007 20:23:30 +0000]
Added diff comparison of views and procedures
Chris Hilton [Wed, 14 Mar 2007 20:22:58 +0000]
Hacks for comparing sql attribute in equals() to ignore unimportant differences
Chris Hilton [Wed, 14 Mar 2007 20:20:09 +0000]
Removed mistakenly checked in debug code
Chris Hilton [Wed, 14 Mar 2007 17:03:52 +0000]
Added cursory parsing of procedures, functions, and views (oh my!)
Chris Hilton [Wed, 14 Mar 2007 16:56:33 +0000]
Added GO to output after views and procedures
Chris Hilton [Thu, 8 Mar 2007 23:11:20 +0000]
Helps to actually pass the output-db option
Chris Hilton [Tue, 6 Mar 2007 23:52:42 +0000]
Added output_db option
Removed Oracle SYS_ constraints hacks
Chris Hilton [Tue, 6 Mar 2007 23:50:23 +0000]
Made fields check in equals() ignore ordering
Chris Hilton [Tue, 6 Mar 2007 23:49:42 +0000]
Added output-db option
Chris Hilton [Tue, 6 Mar 2007 21:09:32 +0000]
Corrected index parsing on Oracle so every index is not a unique constraint
Chris Hilton [Mon, 5 Mar 2007 20:02:34 +0000]
Skip constraint and index comparison shortcuts when ignoring the relevant names
Chris Hilton [Mon, 5 Mar 2007 20:01:27 +0000]
Don't test is_valid in equals()
Chris Hilton [Thu, 1 Mar 2007 22:16:00 +0000]
Added options to sqlt-diff to ignore index and/or constraint name differences
Chris Hilton [Tue, 27 Feb 2007 20:45:30 +0000]
Changed Constraint.equals() to ignore ordering of fields and reference fields
Chris Hilton [Mon, 19 Feb 2007 23:35:27 +0000]
Tweak previous comment parsing tweak for multiple lines
Chris Hilton [Mon, 19 Feb 2007 20:15:13 +0000]
Slight change to comment parsing to allow asterisks in comments
Chris Hilton [Mon, 15 Jan 2007 19:18:45 +0000]
Added linefeeds so beginning of create view/procedure statements don't end up commented out
Jess Robinson [Thu, 7 Dec 2006 13:43:24 +0000]
Fix bug in YAML test
Jess Robinson [Mon, 27 Nov 2006 19:28:04 +0000]
Patched mysql producer to name constraints sanely
Jess Robinson [Tue, 21 Nov 2006 00:01:17 +0000]
Update changes, oops
Jess Robinson [Mon, 20 Nov 2006 23:56:14 +0000]
Cascade drop pg tables to overcome key constraints when dropping
Ben Faga [Fri, 10 Nov 2006 21:58:14 +0000]
Updated version number and Change log for recent patches.
Ben Faga [Fri, 10 Nov 2006 21:43:15 +0000]
Added a semicolon at the end of the create trigger definition because SQLite seems to require it.
Modified the test data to reflect this need.
Ben Faga [Fri, 10 Nov 2006 21:21:52 +0000]
Applied patch sent in by Daniel Westermann-Clark on Oct 11 2006.
His message:
Attached is a patch to modify the Producer::DB2 to output foreign key
definitions as ALTER TABLE statements after the CREATE TABLE
statements (to avoid dependency issues). The patch also removes
single quotes for numeric default values in Producer::DB2, which
caused problems here on my v7 instance.
To add tests for the foreign key output, I added a table to the
schema.xml file. This required updating some of the other tests, and
exposed a few other minor issues in the test suite relating to foreign
key output.
Jess Robinson [Fri, 10 Nov 2006 11:23:10 +0000]
Update TODO file
Jess Robinson [Thu, 9 Nov 2006 18:23:01 +0000]
Upped version to _03
Jess Robinson [Thu, 9 Nov 2006 18:22:22 +0000]
Fixed tests for mysql producer changes
Jess Robinson [Thu, 9 Nov 2006 18:19:05 +0000]
Make the DROP commands a separate item in arrary context (mysql producer)
Jess Robinson [Thu, 9 Nov 2006 18:16:24 +0000]
Add default timestamp support to Postgres producer
Chris Hilton [Mon, 30 Oct 2006 19:41:48 +0000]
Added comment to diff output if target database is not one of the few, the proud
Chris Hilton [Mon, 16 Oct 2006 15:24:12 +0000]
Fixed passing references to GetOptions
Chris Hilton [Tue, 10 Oct 2006 19:05:55 +0000]
Added test for delimiter functionality and multiple comments on a line
Chris Hilton [Tue, 10 Oct 2006 19:04:54 +0000]
Added MySQL 5.0 DELIMITER functionality
Chris Hilton [Tue, 10 Oct 2006 19:04:10 +0000]
Remove row requirement for returning indices
Chris Hilton [Tue, 10 Oct 2006 16:34:53 +0000]
Get SQLT version dynamically
Jess Robinson [Fri, 22 Sep 2006 20:49:57 +0000]
Remove strange manifest entry
Jess Robinson [Tue, 19 Sep 2006 20:55:12 +0000]
Make TTSchema work with TT 2.15, somehow
Jess Robinson [Sat, 26 Aug 2006 11:37:18 +0000]
Also collect function objects. Thanks Gordon!
Jess Robinson [Sat, 26 Aug 2006 11:35:31 +0000]
Fix typo, no_comments arg wasnt getting passed. Thanks Penguin!
Jess Robinson [Sat, 26 Aug 2006 11:34:49 +0000]
Support Pg timestamp type followed by an optional size, which denotes the type of timestamp
Jess Robinson [Sat, 26 Aug 2006 11:30:31 +0000]
Default auto-inc fields to start at one, and increase by one
Jess Robinson [Sat, 26 Aug 2006 11:29:32 +0000]
Fixed up tests to accommodate new DB2 producer changes and sqlite tests to not test for comments.
Jess Robinson [Wed, 9 Aug 2006 13:06:21 +0000]
Add quoting support to the mysql producer, thanks ash!
Jess Robinson [Fri, 4 Aug 2006 21:38:21 +0000]
Add timestamp tests, make postgres produce timestamp(0) if asked
Jess Robinson [Mon, 24 Jul 2006 07:00:25 +0000]
Build files for 0.08_01
Jess Robinson [Sun, 23 Jul 2006 14:18:44 +0000]
Changes for 0.08_01
Jess Robinson [Sun, 23 Jul 2006 14:14:56 +0000]
Move Template into reccommends for now
Jess Robinson [Sun, 23 Jul 2006 14:03:52 +0000]
Splitting of MySQL, Postgres and SQLite producers into sub methods
Added "alter_*" methods to MySQL and Postgres producers
Jess Robinson [Sun, 23 Jul 2006 13:57:42 +0000]
Lots of Pg Producer tests, some other fixes
Jess Robinson [Sun, 16 Jul 2006 13:57:49 +0000]
Improvements to MySQL producers foreign key and comment handling
Jess Robinson [Tue, 11 Jul 2006 21:53:26 +0000]
Fix mysql_table_type .. (where did this go, or why was it not there?)
Ken Youens-Clark [Thu, 29 Jun 2006 19:24:14 +0000]
Fixed handling of NULLs.
Ben Faga [Thu, 22 Jun 2006 19:06:35 +0000]
Fixed a problem with the trigger_steps where it used to expect a string when it was getting an array.
Jess Robinson [Fri, 9 Jun 2006 13:58:03 +0000]
Add test to prove insert statements with quoted semi-colons can still be skipped
Jess Robinson [Fri, 9 Jun 2006 13:56:58 +0000]
Allow skipped insert statements and trigger bodies to contain quoted semi-colons
Jess Robinson [Thu, 8 Jun 2006 21:02:20 +0000]
SQLite and YAML tests broken, fixed
Also made SQLite parser actually used the parsed table naem
Jess Robinson [Wed, 7 Jun 2006 16:43:41 +0000]
Typo fixing
Jess Robinson [Wed, 7 Jun 2006 16:39:09 +0000]
Add tests for new alter_field, add_field, drop_field methods
Jess Robinson [Wed, 7 Jun 2006 16:37:33 +0000]
Update Trigger to insist on a valid table for on_table
on_table now stores a known table obj in the table() attribute, which can also be used directly
Updated tests to match
Jess Robinson [Wed, 7 Jun 2006 16:32:11 +0000]
Produce either a list of statements or a string
Split produce() into multiple methods
Add alter_field, add_field, drop_field for use with Diff
Jess Robinson [Wed, 7 Jun 2006 16:28:59 +0000]
Document producer methods
Jess Robinson [Wed, 7 Jun 2006 16:08:45 +0000]
Recognise & skip DROP statements when parsing
Recognise CURRENT_TIMESTAMP (SQLite v3+)
Jess Robinson [Wed, 7 Jun 2006 16:04:12 +0000]
Added quote-field-names, quote-table-names options
Jess Robinson [Wed, 7 Jun 2006 16:02:54 +0000]
Producers can now return individual statements as s list, if wantarray set
DB2 implements this, produces each individual statement on demand as well
Also implements alter_field, add_field etc for use by Diff
Added quote-field-names, quote-table-names params
Jess Robinson [Wed, 24 May 2006 22:06:56 +0000]
More DB2 producing
Jess Robinson [Wed, 24 May 2006 22:01:21 +0000]
DB2 producer tests
Chris Hilton [Wed, 24 May 2006 18:41:35 +0000]
Ignore Oracle system constraints on source DB schema, also
Chris Hilton [Wed, 24 May 2006 18:10:30 +0000]
Modified parse() to instantiate a separate RecDescent parser like other Parsers do
Chris Hilton [Wed, 24 May 2006 18:09:27 +0000]
Added tests to catch Oracle problem with parser being reused
Chris Hilton [Wed, 24 May 2006 18:08:41 +0000]
Removed conflict markers
Jess Robinson [Wed, 24 May 2006 14:45:21 +0000]
Use DB2 Parser
Jess Robinson [Sat, 20 May 2006 09:02:47 +0000]
Initial devision of sqlt-diff: Most of the functionality into a module
Ken Youens-Clark [Sat, 13 May 2006 01:25:44 +0000]
Added use of graph.
Ken Youens-Clark [Sat, 13 May 2006 01:21:21 +0000]
Commiting.
Chris Hilton [Fri, 5 May 2006 16:42:17 +0000]
Fixed up ON DELETE parsing for FKs
Chris Hilton [Fri, 5 May 2006 16:41:26 +0000]
Added ON DELETE and ON UPDATE clauses to FK output
Chris Hilton [Thu, 4 May 2006 20:47:07 +0000]
Added 'default null' parsing
Chris Hilton [Thu, 4 May 2006 20:46:45 +0000]
Fix field default value output bug I introduced
Chris Hilton [Thu, 4 May 2006 20:45:58 +0000]
Minor refactor to avoid uninitialized value warning
Chris Hilton [Wed, 3 May 2006 21:46:06 +0000]
Fixed preservation of function call as field in function-based indices
Chris Hilton [Wed, 3 May 2006 21:25:07 +0000]
Parser changes to accomodate function-based indexes and optional size modifier for data type
Ken Youens-Clark [Wed, 12 Apr 2006 14:11:09 +0000]
Removed SIGNATURE.
Ken Youens-Clark [Wed, 12 Apr 2006 14:10:28 +0000]
Removing.
Mark Addison [Fri, 7 Apr 2006 10:00:21 +0000]
Globals filter now copies extra
Chris Mungall [Tue, 21 Mar 2006 20:07:21 +0000]
new: makes tables in latex format
Ben Faga [Tue, 21 Mar 2006 18:39:28 +0000]
Applying the patch submitted with this bug report
https://rt.cpan.org/Public/Bug/Display.html?id=18096 by Nigel Metheringham.
Fixes a bug where it wouldn't parse create statements that included "timestamp without time zone".
Ken Youens-Clark [Thu, 16 Mar 2006 19:24:43 +0000]
Added tests for "unique" and "key" qualifiers to field definitions.
Ken Youens-Clark [Thu, 16 Mar 2006 19:24:02 +0000]
Added grammar for handling "unique" and "key" qualifiers to field definition.
Mark Addison [Fri, 10 Mar 2006 15:04:12 +0000]
Added constraint copy to Globals filter. (Seem to be getting lots of warnings from YAML now...)
Mark Addison [Fri, 10 Mar 2006 14:55:19 +0000]
Fixed warning for tables with no order attrib
Earl Cahill [Thu, 9 Mar 2006 20:18:05 +0000]
-O::Is, accidentally committed some debug, thanks to Darren Chamberlain [dlc@sevenroot.org] for pointing it out
Earl Cahill [Thu, 9 Mar 2006 19:25:47 +0000]
adding in Oracle driver support and making the DRIVER keys alphabetical :)
Earl Cahill [Thu, 9 Mar 2006 19:24:32 +0000]
initial adds for the oracle dbi parser and a simple test to make sure the use works
Mark Addison [Mon, 6 Mar 2006 17:46:57 +0000]
Added Globals filter.
Mark Addison [Mon, 6 Mar 2006 13:55:08 +0000]
Removed un-used stuff left from CutNPaste of t/36-filters.t
Mark Addison [Mon, 6 Mar 2006 13:08:43 +0000]
Backed out M::B ConfigData based installed templates and moved DiaUml
producer to using evil hack of templates in INC.