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.

18 years agoUpdates.
Ken Youens-Clark [Wed, 22 Feb 2006 22:54:12 +0000]
Updates.

18 years agoChanged to build up schema from "show create table" statements and then
Ken Youens-Clark [Wed, 22 Feb 2006 22:52:51 +0000]
Changed to build up schema from "show create table" statements and then
pass to regular MySQL parser.

18 years agoChanged my name.
Ken Youens-Clark [Wed, 22 Feb 2006 17:03:57 +0000]
Changed my name.

18 years agoChanges to make more efficient use of memory with large tables.
Ken Youens-Clark [Thu, 16 Feb 2006 14:59:19 +0000]
Changes to make more efficient use of memory with large tables.

18 years agoMoved YAML to a build requirement.
Ken Youens-Clark [Tue, 31 Jan 2006 03:28:07 +0000]
Moved YAML to a build requirement.

18 years agoJust committing, but is it necessary? It will be regenerated by Build.PL.
Ken Youens-Clark [Tue, 31 Jan 2006 02:55:36 +0000]
Just committing, but is it necessary?  It will be regenerated by Build.PL.

18 years agoIntial code for Dia producer
Mark Addison [Fri, 20 Jan 2006 16:17:21 +0000]
Intial code for Dia producer

18 years agoBuild support for installing templates.
Mark Addison [Fri, 20 Jan 2006 15:04:55 +0000]
Build support for installing templates.

18 years agoFixed missing schema table comments
Mark Addison [Thu, 22 Dec 2005 12:13:22 +0000]
Fixed missing schema table comments

18 years agoExperimental filters
Mark Addison [Fri, 16 Dec 2005 10:25:00 +0000]
Experimental filters

18 years agoAdded mysql_character_set for 4.1+
Mark Addison [Fri, 16 Dec 2005 05:49:37 +0000]
Added mysql_character_set for 4.1+

19 years agoApplied changes submitted by Paul Makepeace <sourceforge.net@paulm.com>.
Ben Faga [Thu, 17 Nov 2005 21:55:41 +0000]
Applied changes submitted by Paul Makepeace <sourceforge.net@paulm.com>.

His notes:

I have added the --use-same-auth switch to provide the producers with the same DSN/user/password as the parser gets. Since these options sort of existed already for the Dumper producer so I renamed them to more generic --producer-X; now they all have them.

I also added a "--package My::Class::DBI" option for specifying the base class. One thing I wasn't quite sure on was that this base class is being stripped out - confused me at first but it seems to have been taken out in CVS v the version that's on CPAN -- maybe something in the works? Anyway, I put it back just for now as I needed it for my current project :-)

(Wasn't particularly excited by either of those switch names; feel free to come up with something better...)

E.g.,

perl -Mlib=blib/lib bin/sqlt --parser DBI –dsn   'dbi:mysql:dbname=X;host=127.0.0.1' --db-user X --db-password X --use-same-auth --producer ClassDBI –package 'My::Class::DBI'

19 years agorefining the parser, but it still doesn't do everything it should:
Scott Cain [Fri, 7 Oct 2005 16:26:41 +0000]
refining the parser, but it still doesn't do everything it should:

- the column order number doesn't make much sense to me--is that number global to the file, or supposed to be relative to the table?

- the data_type and size aren't getting set; perhaps I need to do a mapping of the text output of the query to internal variables?

- is_unique never gets set for any column (because I don't explicitly set it), but the unique indexes and the columns they are over are set correctly.  Is that a problem?  Also, is the is_unique flag only for the simple case for where the column by it self is unique or is it also used for compound unique indexes?

19 years agorevamped Pg DBI parser to query system tables. This still doesn't work
Scott Cain [Thu, 6 Oct 2005 20:33:07 +0000]
revamped Pg DBI parser to query system tables.  This still doesn't work
as far as I know, but it seems very close.  Perhaps more knowledgable
eye could take a look.

19 years agoproduce DB2 tables
Jess Robinson [Sun, 18 Sep 2005 20:06:31 +0000]
produce DB2 tables

19 years agoRemoved doap.rdf from MANIFEST, since I removed it from CVS a few days earlier.
Darren Chamberlain [Thu, 15 Sep 2005 17:37:31 +0000]
Removed doap.rdf from MANIFEST, since I removed it from CVS a few days earlier.

19 years agoMoved to htdocs module
Darren Chamberlain [Tue, 13 Sep 2005 18:49:31 +0000]
Moved to htdocs module

19 years agoOriginal artwor, courtesy of Jason Williams
Darren Chamberlain [Wed, 31 Aug 2005 15:42:57 +0000]
Original artwor, courtesy of Jason Williams

19 years agoAdding non-zero exit status if differences were found
Chris Hilton [Wed, 31 Aug 2005 15:42:17 +0000]
Adding non-zero exit status if differences were found

19 years agoVarious tweaks to produce Oracle diffs
Chris Hilton [Wed, 10 Aug 2005 16:57:06 +0000]
Various tweaks to produce Oracle diffs

19 years agoAdded some constraint tests
Chris Hilton [Wed, 10 Aug 2005 16:55:44 +0000]
Added some constraint tests
Removed YAML prereq, sqlt-diff doesn't use it anymore

19 years agoModified equals() to stringify field checks and use more case insensitivity when...
Chris Hilton [Wed, 10 Aug 2005 16:46:55 +0000]
Modified equals() to stringify field checks and use more case insensitivity when required

19 years agoModified equals() to include more case insensitivity when required
Chris Hilton [Wed, 10 Aug 2005 16:45:40 +0000]
Modified equals() to include more case insensitivity when required

19 years agoModified equals() to include case insensitive data type checking and removed is_uniqu...
Chris Hilton [Wed, 10 Aug 2005 16:44:17 +0000]
Modified equals() to include case insensitive data type checking and removed is_unique check (better caught by a constraint check)

19 years agoModified equals() to include type check, stringify field checks, and more case insens...
Chris Hilton [Wed, 10 Aug 2005 16:42:47 +0000]
Modified equals() to include type check, stringify field checks, and more case insensitivity when required

19 years agoUse the overload::StrVal method to check if references are the same instead of the...
Chris Hilton [Wed, 10 Aug 2005 16:34:47 +0000]
Use the overload::StrVal method to check if references are the same instead of the possibly overloaded stringify

19 years agoAdded negative sign possibility to default number values.
Chris Hilton [Wed, 10 Aug 2005 16:33:39 +0000]
Added negative sign possibility to default number values.
Modified constraints to not create a name if a name is already given.
Commented out PK name creation altogether (and would prefer to do it to all constraints, as well).
Made sure not to create UNIQUE constraints identical to the PRIMARY KEY; Oracle will create the unique constraint automatically when it creates the PK.

19 years agoModified "create anything else" rule to not include table and index creates so any...
Chris Hilton [Wed, 10 Aug 2005 15:17:48 +0000]
Modified "create anything else" rule to not include table and index creates so any syntax errors in those are properly caught
Added RUN rule
Re-enabled constraint states except that hideous monstrosity of a "using index" clause
Modified two word data types to return as two words so it comes out right from the Producer
Added float data type

19 years agoRemoving foreign key check from field equality; foreign key inequality is better...
Chris Hilton [Mon, 18 Jul 2005 20:16:02 +0000]
Removing foreign key check from field equality; foreign key inequality is better caught with the constraint check

19 years agoIt helps if you use the correct version of the case-insensitive field name you're...
Chris Hilton [Mon, 18 Jul 2005 16:32:52 +0000]
It helps if you use the correct version of the case-insensitive field name you're trying to return

19 years agoFixed case-insensitivity matching for SQL Server and field names
Chris Hilton [Fri, 15 Jul 2005 23:36:13 +0000]
Fixed case-insensitivity matching for SQL Server and field names

19 years agoRemoved auto_increment from a field's extra attribute; it's already saved in is_auto_...
Chris Hilton [Tue, 12 Jul 2005 16:05:35 +0000]
Removed auto_increment from a field's extra attribute; it's already saved in is_auto_increment and this prevents it unnecessarily showing up in the field's comment when producing MySQL

19 years agoRemoved '#' and '--' comments from being included in table comments; they aren't...
Chris Hilton [Mon, 11 Jul 2005 21:14:22 +0000]
Removed '#' and '--' comments from being included in table comments; they aren't part of the schema and hose the schema diffing

19 years agoRe-arranged to put null/not null before default value; looks and parses better
Chris Hilton [Mon, 11 Jul 2005 20:12:02 +0000]
Re-arranged to put null/not null before default value; looks and parses better

19 years agomissed a spot
Allen Day [Thu, 7 Jul 2005 22:37:19 +0000]
missed a spot

19 years agoRemoved the line that declared YAML to be the producer. This stopped the YAML warnin...
Ben Faga [Thu, 7 Jul 2005 21:30:42 +0000]
Removed the line that declared YAML to be the producer.  This stopped the YAML warnings from ./Build test and didn't seem to affect anything else.

19 years agobacking out non-callback package mangling
Allen Day [Thu, 7 Jul 2005 19:24:16 +0000]
backing out non-callback package mangling

19 years agoChanged the second "my $h" to just "$h" because it was throwing warnings.
Ben Faga [Thu, 7 Jul 2005 15:20:00 +0000]
Changed the second "my $h" to just "$h" because it was throwing warnings.

19 years agoIf a DSN is defined but no 'from' db type given, we infer the 'from' type is DBI
Chris Hilton [Wed, 6 Jul 2005 19:20:27 +0000]
If a DSN is defined but no 'from' db type given, we infer the 'from' type is DBI

19 years agochanges to allow subclass tables identical to superclass
Allen Day [Wed, 6 Jul 2005 05:37:32 +0000]
changes to allow subclass tables identical to superclass

19 years agoMade some changes suggested by Michael Slattery to fix table level comments. Also...
Ben Faga [Tue, 5 Jul 2005 16:20:43 +0000]
Made some changes suggested by Michael Slattery to fix table level comments.  Also added in field level comments.

His remarks follow:

Table level comments weren't populating.  The empty tag is generated in XML, but not populated.  $table->comments() doesn't have a get_comments method, so that explains my if/else around $meth

Right now it produces 'comment' data elements with no attributes in the 'comments' tag.  If this is a bad idea please let me know.

19 years agoFixed usage docs.
Ken Youens-Clark [Thu, 30 Jun 2005 01:04:24 +0000]
Fixed usage docs.

19 years agoThe short arg for "font-size" was colliding with the "f" for the parser.
Ken Youens-Clark [Thu, 30 Jun 2005 01:03:29 +0000]
The short arg for "font-size" was colliding with the "f" for the parser.

19 years agoModified test text to reflect that fields() now return empty strings instead of undef...
Chris Hilton [Wed, 29 Jun 2005 22:18:39 +0000]
Modified test text to reflect that fields() now return empty strings instead of undef when there are no fields

19 years agoMade sure defined scalar references are passed to _compare_objects(). Removed is_vali...
Chris Hilton [Wed, 29 Jun 2005 22:02:29 +0000]
Made sure defined scalar references are passed to _compare_objects(). Removed is_valid comparisons from equals().

19 years agoSlight adjustment to parsing of identity/auto-increment field qualifier
Chris Hilton [Tue, 28 Jun 2005 23:37:12 +0000]
Slight adjustment to parsing of identity/auto-increment field qualifier

19 years agoFixed bug to exhaustively search for equal constraints and indices
Chris Hilton [Tue, 28 Jun 2005 23:05:47 +0000]
Fixed bug to exhaustively search for equal constraints and indices
Modified how SQL Server drops a default value constraint on a field

19 years agoFixed bug in equals() to exhaustively search sets of indices and constraints
Chris Hilton [Tue, 28 Jun 2005 22:58:06 +0000]
Fixed bug in equals() to exhaustively search sets of indices and constraints