17 years agoAdded mysql-parser-version command-line option
Chris Hilton [Mon, 19 Mar 2007 17:15:54 +0000]
Added mysql-parser-version command-line option

17 years agoAdded cursory parsing of view, functions, and procedures (oh why!)
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

17 years agoRemoved unused rules procedure_body and view_body
Chris Hilton [Mon, 19 Mar 2007 17:11:02 +0000]
Removed unused rules procedure_body and view_body

17 years agoSmall change to ordering of view and procedure diffs
Chris Hilton [Mon, 19 Mar 2007 17:10:25 +0000]
Small change to ordering of view and procedure diffs

17 years agoAdded diff comparison of views and procedures
Chris Hilton [Wed, 14 Mar 2007 20:23:30 +0000]
Added diff comparison of views and procedures

17 years agoHacks for comparing sql attribute in equals() to ignore unimportant differences
Chris Hilton [Wed, 14 Mar 2007 20:22:58 +0000]
Hacks for comparing sql attribute in equals() to ignore unimportant differences

17 years agoRemoved mistakenly checked in debug code
Chris Hilton [Wed, 14 Mar 2007 20:20:09 +0000]
Removed mistakenly checked in debug code

17 years agoAdded cursory parsing of procedures, functions, and views (oh my!)
Chris Hilton [Wed, 14 Mar 2007 17:03:52 +0000]
Added cursory parsing of procedures, functions, and views (oh my!)

17 years agoAdded GO to output after views and procedures
Chris Hilton [Wed, 14 Mar 2007 16:56:33 +0000]
Added GO to output after views and procedures

17 years agoHelps to actually pass the output-db option
Chris Hilton [Thu, 8 Mar 2007 23:11:20 +0000]
Helps to actually pass the output-db option

17 years agoAdded output_db option
Chris Hilton [Tue, 6 Mar 2007 23:52:42 +0000]
Added output_db option
Removed Oracle SYS_ constraints hacks

17 years agoMade fields check in equals() ignore ordering
Chris Hilton [Tue, 6 Mar 2007 23:50:23 +0000]
Made fields check in equals() ignore ordering

17 years agoAdded output-db option
Chris Hilton [Tue, 6 Mar 2007 23:49:42 +0000]
Added output-db option

17 years agoCorrected index parsing on Oracle so every index is not a unique constraint
Chris Hilton [Tue, 6 Mar 2007 21:09:32 +0000]
Corrected index parsing on Oracle so every index is not a unique constraint

17 years agoSkip constraint and index comparison shortcuts when ignoring the relevant names
Chris Hilton [Mon, 5 Mar 2007 20:02:34 +0000]
Skip constraint and index comparison shortcuts when ignoring the relevant names

17 years agoDon't test is_valid in equals()
Chris Hilton [Mon, 5 Mar 2007 20:01:27 +0000]
Don't test is_valid in equals()

17 years agoAdded options to sqlt-diff to ignore index and/or constraint name differences
Chris Hilton [Thu, 1 Mar 2007 22:16:00 +0000]
Added options to sqlt-diff to ignore index and/or constraint name differences

17 years agoChanged Constraint.equals() to ignore ordering of fields and reference fields
Chris Hilton [Tue, 27 Feb 2007 20:45:30 +0000]
Changed Constraint.equals() to ignore ordering of fields and reference fields

17 years agoTweak previous comment parsing tweak for multiple lines
Chris Hilton [Mon, 19 Feb 2007 23:35:27 +0000]
Tweak previous comment parsing tweak for multiple lines

17 years agoSlight change to comment parsing to allow asterisks in comments
Chris Hilton [Mon, 19 Feb 2007 20:15:13 +0000]
Slight change to comment parsing to allow asterisks in comments

17 years agoAdded linefeeds so beginning of create view/procedure statements don't end up comment...
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

17 years agoFix bug in YAML test
Jess Robinson [Thu, 7 Dec 2006 13:43:24 +0000]
Fix bug in YAML test

18 years agoPatched mysql producer to name constraints sanely
Jess Robinson [Mon, 27 Nov 2006 19:28:04 +0000]
Patched mysql producer to name constraints sanely

18 years agoUpdate changes, oops
Jess Robinson [Tue, 21 Nov 2006 00:01:17 +0000]
Update changes, oops

18 years agoCascade drop pg tables to overcome key constraints when dropping
Jess Robinson [Mon, 20 Nov 2006 23:56:14 +0000]
Cascade drop pg tables to overcome key constraints when dropping

18 years agoUpdated version number and Change log for recent patches.
Ben Faga [Fri, 10 Nov 2006 21:58:14 +0000]
Updated version number and Change log for recent patches.

18 years agoAdded a semicolon at the end of the create trigger definition because SQLite seems...
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.

18 years agoApplied patch sent in by Daniel Westermann-Clark on Oct 11 2006.
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.

18 years agoUpdate TODO file
Jess Robinson [Fri, 10 Nov 2006 11:23:10 +0000]
Update TODO file

18 years agoUpped version to _03
Jess Robinson [Thu, 9 Nov 2006 18:23:01 +0000]
Upped version to _03

18 years agoFixed tests for mysql producer changes
Jess Robinson [Thu, 9 Nov 2006 18:22:22 +0000]
Fixed tests for mysql producer changes

18 years agoMake the DROP commands a separate item in arrary context (mysql producer)
Jess Robinson [Thu, 9 Nov 2006 18:19:05 +0000]
Make the DROP commands a separate item in arrary context (mysql producer)

18 years agoAdd default timestamp support to Postgres producer
Jess Robinson [Thu, 9 Nov 2006 18:16:24 +0000]
Add default timestamp support to Postgres producer

18 years agoAdded comment to diff output if target database is not one of the few, the proud
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

18 years agoFixed passing references to GetOptions
Chris Hilton [Mon, 16 Oct 2006 15:24:12 +0000]
Fixed passing references to GetOptions

18 years agoAdded test for delimiter functionality and multiple comments on a line
Chris Hilton [Tue, 10 Oct 2006 19:05:55 +0000]
Added test for delimiter functionality and multiple comments on a line

18 years agoAdded MySQL 5.0 DELIMITER functionality
Chris Hilton [Tue, 10 Oct 2006 19:04:54 +0000]
Added MySQL 5.0 DELIMITER functionality

18 years agoRemove row requirement for returning indices
Chris Hilton [Tue, 10 Oct 2006 19:04:10 +0000]
Remove row requirement for returning indices

18 years agoGet SQLT version dynamically
Chris Hilton [Tue, 10 Oct 2006 16:34:53 +0000]
Get SQLT version dynamically

18 years agoRemove strange manifest entry
Jess Robinson [Fri, 22 Sep 2006 20:49:57 +0000]
Remove strange manifest entry

18 years agoMake TTSchema work with TT 2.15, somehow
Jess Robinson [Tue, 19 Sep 2006 20:55:12 +0000]
Make TTSchema work with TT 2.15, somehow

18 years agoAlso collect function objects. Thanks Gordon!
Jess Robinson [Sat, 26 Aug 2006 11:37:18 +0000]
Also collect function objects. Thanks Gordon!

18 years agoFix typo, no_comments arg wasnt getting passed. Thanks Penguin!
Jess Robinson [Sat, 26 Aug 2006 11:35:31 +0000]
Fix typo, no_comments arg wasnt getting passed. Thanks Penguin!

18 years agoSupport Pg timestamp type followed by an optional size, which denotes the type of...
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

18 years agoDefault auto-inc fields to start at one, and increase by one
Jess Robinson [Sat, 26 Aug 2006 11:30:31 +0000]
Default auto-inc fields to start at one, and increase by one

18 years agoFixed up tests to accommodate new DB2 producer changes and sqlite tests to not test...
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.

18 years agoAdd quoting support to the mysql producer, thanks ash!
Jess Robinson [Wed, 9 Aug 2006 13:06:21 +0000]
Add quoting support to the mysql producer, thanks ash!

18 years agoAdd timestamp tests, make postgres produce timestamp(0) if asked
Jess Robinson [Fri, 4 Aug 2006 21:38:21 +0000]
Add timestamp tests, make postgres produce timestamp(0) if asked

18 years agoBuild files for 0.08_01
Jess Robinson [Mon, 24 Jul 2006 07:00:25 +0000]
Build files for 0.08_01

18 years agoChanges for 0.08_01
Jess Robinson [Sun, 23 Jul 2006 14:18:44 +0000]
Changes for 0.08_01

18 years agoMove Template into reccommends for now
Jess Robinson [Sun, 23 Jul 2006 14:14:56 +0000]
Move Template into reccommends for now

18 years agoSplitting of MySQL, Postgres and SQLite producers into sub methods
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

18 years agoLots of Pg Producer tests, some other fixes
Jess Robinson [Sun, 23 Jul 2006 13:57:42 +0000]
Lots of Pg Producer tests, some other fixes

18 years agoImprovements to MySQL producers foreign key and comment handling
Jess Robinson [Sun, 16 Jul 2006 13:57:49 +0000]
Improvements to MySQL producers foreign key and comment handling

18 years agoFix mysql_table_type .. (where did this go, or why was it not there?)
Jess Robinson [Tue, 11 Jul 2006 21:53:26 +0000]
Fix mysql_table_type .. (where did this go, or why was it not there?)

18 years agoFixed handling of NULLs.
Ken Youens-Clark [Thu, 29 Jun 2006 19:24:14 +0000]
Fixed handling of NULLs.

18 years agoFixed a problem with the trigger_steps where it used to expect a string when it was...
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.

18 years agoAdd test to prove insert statements with quoted semi-colons can still be skipped
Jess Robinson [Fri, 9 Jun 2006 13:58:03 +0000]
Add test to prove insert statements with quoted semi-colons can still be skipped

18 years agoAllow skipped insert statements and trigger bodies to contain quoted semi-colons
Jess Robinson [Fri, 9 Jun 2006 13:56:58 +0000]
Allow skipped insert statements and trigger bodies to contain quoted semi-colons

18 years agoSQLite and YAML tests broken, fixed
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

18 years agoTypo fixing
Jess Robinson [Wed, 7 Jun 2006 16:43:41 +0000]
Typo fixing

18 years agoAdd tests for new alter_field, add_field, drop_field methods
Jess Robinson [Wed, 7 Jun 2006 16:39:09 +0000]
Add tests for new alter_field, add_field, drop_field methods

18 years agoUpdate Trigger to insist on a valid table for on_table
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

18 years agoProduce either a list of statements or a string
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

18 years agoDocument producer methods
Jess Robinson [Wed, 7 Jun 2006 16:28:59 +0000]
Document producer methods

18 years agoRecognise & skip DROP statements when parsing
Jess Robinson [Wed, 7 Jun 2006 16:08:45 +0000]
Recognise & skip DROP statements when parsing
Recognise CURRENT_TIMESTAMP (SQLite v3+)

18 years agoAdded quote-field-names, quote-table-names options
Jess Robinson [Wed, 7 Jun 2006 16:04:12 +0000]
Added quote-field-names, quote-table-names options

18 years agoProducers can now return individual statements as s list, if wantarray set
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

18 years agoMore DB2 producing
Jess Robinson [Wed, 24 May 2006 22:06:56 +0000]
More DB2 producing

18 years agoDB2 producer tests
Jess Robinson [Wed, 24 May 2006 22:01:21 +0000]
DB2 producer tests

18 years agoIgnore Oracle system constraints on source DB schema, also
Chris Hilton [Wed, 24 May 2006 18:41:35 +0000]
Ignore Oracle system constraints on source DB schema, also

18 years agoModified parse() to instantiate a separate RecDescent parser like other Parsers do
Chris Hilton [Wed, 24 May 2006 18:10:30 +0000]
Modified parse() to instantiate a separate RecDescent parser like other Parsers do

18 years agoAdded tests to catch Oracle problem with parser being reused
Chris Hilton [Wed, 24 May 2006 18:09:27 +0000]
Added tests to catch Oracle problem with parser being reused

18 years agoRemoved conflict markers
Chris Hilton [Wed, 24 May 2006 18:08:41 +0000]
Removed conflict markers

18 years agoUse DB2 Parser
Jess Robinson [Wed, 24 May 2006 14:45:21 +0000]
Use DB2 Parser

18 years agoInitial devision of sqlt-diff: Most of the functionality into a module
Jess Robinson [Sat, 20 May 2006 09:02:47 +0000]
Initial devision of sqlt-diff: Most of the functionality into a module

18 years agoAdded use of graph.
Ken Youens-Clark [Sat, 13 May 2006 01:25:44 +0000]
Added use of graph.

18 years agoCommiting.
Ken Youens-Clark [Sat, 13 May 2006 01:21:21 +0000]
Commiting.

18 years agoFixed up ON DELETE parsing for FKs
Chris Hilton [Fri, 5 May 2006 16:42:17 +0000]
Fixed up ON DELETE parsing for FKs

18 years agoAdded ON DELETE and ON UPDATE clauses to FK output
Chris Hilton [Fri, 5 May 2006 16:41:26 +0000]
Added ON DELETE and ON UPDATE clauses to FK output

18 years agoAdded 'default null' parsing
Chris Hilton [Thu, 4 May 2006 20:47:07 +0000]
Added 'default null' parsing

18 years agoFix field default value output bug I introduced
Chris Hilton [Thu, 4 May 2006 20:46:45 +0000]
Fix field default value output bug I introduced

18 years agoMinor refactor to avoid uninitialized value warning
Chris Hilton [Thu, 4 May 2006 20:45:58 +0000]
Minor refactor to avoid uninitialized value warning

18 years agoFixed preservation of function call as field in function-based indices
Chris Hilton [Wed, 3 May 2006 21:46:06 +0000]
Fixed preservation of function call as field in function-based indices

18 years agoParser changes to accomodate function-based indexes and optional size modifier for...
Chris Hilton [Wed, 3 May 2006 21:25:07 +0000]
Parser changes to accomodate function-based indexes and optional size modifier for data type

18 years agoRemoved SIGNATURE.
Ken Youens-Clark [Wed, 12 Apr 2006 14:11:09 +0000]
Removed SIGNATURE.

18 years agoRemoving.
Ken Youens-Clark [Wed, 12 Apr 2006 14:10:28 +0000]
Removing.

18 years agoGlobals filter now copies extra
Mark Addison [Fri, 7 Apr 2006 10:00:21 +0000]
Globals filter now copies extra

18 years agonew: makes tables in latex format
Chris Mungall [Tue, 21 Mar 2006 20:07:21 +0000]
new: makes tables in latex format

18 years agoApplying the patch submitted with this bug report
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".

18 years agoAdded tests for "unique" and "key" qualifiers to field definitions.
Ken Youens-Clark [Thu, 16 Mar 2006 19:24:43 +0000]
Added tests for "unique" and "key" qualifiers to field definitions.

18 years agoAdded grammar for handling "unique" and "key" qualifiers to field definition.
Ken Youens-Clark [Thu, 16 Mar 2006 19:24:02 +0000]
Added grammar for handling "unique" and "key" qualifiers to field definition.

18 years agoAdded constraint copy to Globals filter. (Seem to be getting lots of warnings from...
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...)

18 years agoFixed warning for tables with no order attrib
Mark Addison [Fri, 10 Mar 2006 14:55:19 +0000]
Fixed warning for tables with no order attrib

18 years ago-O::Is, accidentally committed some debug, thanks to Darren Chamberlain [dlc@sevenroo...
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

18 years agoadding in Oracle driver support and making the DRIVER keys alphabetical :)
Earl Cahill [Thu, 9 Mar 2006 19:25:47 +0000]
adding in Oracle driver support and making the DRIVER keys alphabetical :)

18 years agoinitial adds for the oracle dbi parser and a simple test to make sure the use works
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

18 years agoAdded Globals filter.
Mark Addison [Mon, 6 Mar 2006 17:46:57 +0000]
Added Globals filter.

18 years agoRemoved un-used stuff left from CutNPaste of t/36-filters.t
Mark Addison [Mon, 6 Mar 2006 13:55:08 +0000]
Removed un-used stuff left from CutNPaste of t/36-filters.t

18 years agoBacked out M::B ConfigData based installed templates and moved DiaUml
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.