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+

18 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

19 years agoModified equals() to get scalar references to fields for comparison
Chris Hilton [Tue, 28 Jun 2005 22:56:22 +0000]
Modified equals() to get scalar references to fields for comparison

19 years agoModfied fields() to return empty array when there are no fields
Chris Hilton [Tue, 28 Jun 2005 22:55:19 +0000]
Modfied fields() to return empty array when there are no fields
Modified equals() to compare field names, not objects

19 years agoRemoved Data::Compare from requirements list
Chris Hilton [Tue, 28 Jun 2005 21:43:49 +0000]
Removed Data::Compare from requirements list

19 years agoModified _compare_objects() to use ref_compare from Class::MakeMethods::Utility:...
Chris Hilton [Tue, 28 Jun 2005 21:43:28 +0000]
Modified _compare_objects() to use ref_compare from Class::MakeMethods::Utility::Ref instead of Data::Compare. It seems more reliable and comes in a package we already require.

19 years agoChanged references to on_delete_do to on_delete and on_update_do to on_update. I...
Ben Faga [Tue, 28 Jun 2005 16:39:41 +0000]
Changed references to on_delete_do to on_delete and on_update_do to on_update.  I tried to keep it backwards compatible.

19 years agoA whole lot of changes, but major additions include adding diffs for table options...
Chris Hilton [Mon, 27 Jun 2005 22:09:42 +0000]
A whole lot of changes, but major additions include adding diffs for table options and constraints
Many smaller changes for various quirks of SQL Server and MySQL

19 years agoAdded additional tests for sqlt-diff
Chris Hilton [Mon, 27 Jun 2005 22:07:39 +0000]
Added additional tests for sqlt-diff

19 years agoAdded case insensitivity option to get_table()
Chris Hilton [Mon, 27 Jun 2005 22:02:50 +0000]
Added case insensitivity option to get_table()

19 years agoAdded equals function for equality testing
Chris Hilton [Mon, 27 Jun 2005 21:59:20 +0000]
Added equals function for equality testing

19 years agoAdded equals function for base equality testing
Chris Hilton [Mon, 27 Jun 2005 21:58:42 +0000]
Added equals function for base equality testing
Added _compare_objects function for inherited classes to utilize when testing equality

19 years agoAdded Data::Compare module to requirements list
Chris Hilton [Mon, 27 Jun 2005 20:53:00 +0000]
Added Data::Compare module to requirements list

19 years agoAdditional tests for new parser capabilities
Chris Hilton [Mon, 27 Jun 2005 20:47:28 +0000]
Additional tests for new parser capabilities

19 years agoAdded to fields that do not require size argument
Chris Hilton [Mon, 27 Jun 2005 20:44:06 +0000]
Added to fields that do not require size argument
Increased max identifier length to 128
Modified output text for views and procedures to remove carriage returns

19 years agoAdded character set, on update, and collate field qualifiers to field definition...
Chris Hilton [Mon, 27 Jun 2005 20:41:13 +0000]
Added character set, on update, and collate field qualifiers to field definition output
Added name to unique constraint output
Modified foreign key contraint output to put name in right place
Added table options to output

19 years agoAdded collate and 'on update current_timestamp' field qualifiers
Chris Hilton [Mon, 27 Jun 2005 20:36:42 +0000]
Added collate and 'on update current_timestamp' field qualifiers
Modified 'character set' detection to handle more acceptable variations

19 years agoAdded comments lines to test data forworking with new YAML Producer output
Chris Hilton [Mon, 27 Jun 2005 20:26:43 +0000]
Added comments lines to test data forworking with new YAML Producer output

19 years agoAdded mapping of ODBC connections to DBI-SQLServer parser
Chris Hilton [Mon, 27 Jun 2005 19:14:45 +0000]
Added mapping of ODBC connections to DBI-SQLServer parser

19 years agoA Parser for SQL Server, mostly copied from Sybase parser and geared toward working...
Chris Hilton [Mon, 27 Jun 2005 19:01:31 +0000]
A Parser for SQL Server, mostly copied from Sybase parser and geared toward working with SQLServer Producer output

19 years agoA DBI Parser for SQL Server, mostly copied from DBI/Sybase
Chris Hilton [Mon, 27 Jun 2005 19:00:19 +0000]
A DBI Parser for SQL Server, mostly copied from DBI/Sybase

19 years agoTesting CVS checkin, added two new developers.
Ken Youens-Clark [Mon, 27 Jun 2005 18:29:01 +0000]
Testing CVS checkin, added two new developers.

19 years agoAdded Ben, changed my name.
Ken Youens-Clark [Thu, 16 Jun 2005 16:03:58 +0000]
Added Ben, changed my name.

19 years agoPut field and table comments into proper MySQL syntax.
Ken Youens-Clark [Wed, 15 Jun 2005 18:05:07 +0000]
Put field and table comments into proper MySQL syntax.

19 years agoField comments weren't printing.
Ken Youens-Clark [Wed, 15 Jun 2005 18:00:31 +0000]
Field comments weren't printing.

19 years agoAdded "official" table and field comment rules.
Ken Youens-Clark [Wed, 15 Jun 2005 17:58:42 +0000]
Added "official" table and field comment rules.

19 years agoAdded tests for other comments.
Ken Youens-Clark [Wed, 15 Jun 2005 17:58:00 +0000]
Added tests for other comments.

19 years agoMade the changes suggested by Michael Slattery. Made the column size undef if the...
Ben Faga [Mon, 13 Jun 2005 18:23:10 +0000]
Made the changes suggested by Michael Slattery.  Made the column size undef if the data type is text of blob and made some other minor changes.

19 years agoCPAN is complaining about the version, so I made a trivial change to get
Ken Youens-Clark [Mon, 13 Jun 2005 16:02:15 +0000]
CPAN is complaining about the version, so I made a trivial change to get
it to increment.

19 years agoAdded the header to the change file.
Ben Faga [Sat, 11 Jun 2005 02:45:55 +0000]
Added the header to the change file.

19 years agoAdded META.yml to manifest
Ben Faga [Sat, 11 Jun 2005 02:36:59 +0000]
Added META.yml to manifest

19 years agoNew Manifest
Ben Faga [Sat, 11 Jun 2005 02:35:41 +0000]
New Manifest

19 years agoAdded a couple things to the manifest skip file.
Ben Faga [Sat, 11 Jun 2005 02:34:05 +0000]
Added a couple things to the manifest skip file.

19 years agoChanges to work with latest MySQL TIMESTAMP columns.
Ken Youens-Clark [Fri, 10 Jun 2005 18:12:37 +0000]
Changes to work with latest MySQL TIMESTAMP columns.

19 years agoTweaked filter interface to take args as a list.
Mark Addison [Thu, 9 Jun 2005 02:02:00 +0000]
Tweaked filter interface to take args as a list.

19 years agoWhile trying to create CDBI classes myself, I found some of the decisions
Ken Youens-Clark [Wed, 8 Jun 2005 15:33:59 +0000]
While trying to create CDBI classes myself, I found some of the decisions
of this module didn't seem to make sense to me or follow the CDBI docs, so
I made a lot of changes that just saner.  I hope they don't break anything.

19 years agoRemoved the @_ from the import statement, since @_ contains the path(s) to the module...
Ben Faga [Wed, 8 Jun 2005 15:32:51 +0000]
Removed the @_ from the import statement, since @_ contains the path(s) to the module and not subs to import.

19 years agoFixed small error that was causing a test to fail.
Ben Faga [Wed, 8 Jun 2005 15:31:06 +0000]
Fixed small error that was causing a test to fail.

19 years agoAdded test for mysql_table_type. Removed dodgey testing code so test works for everyo...
Mark Addison [Wed, 8 Jun 2005 14:48:07 +0000]
Added test for mysql_table_type. Removed dodgey testing code so test works for everyone else.

19 years agoAdded mysql extra attribs for charset and collation.
Mark Addison [Wed, 8 Jun 2005 14:44:08 +0000]
Added mysql extra attribs for charset and collation.

19 years agoParses extra attributes for tables. Tweaked debug output.
Mark Addison [Wed, 8 Jun 2005 11:30:15 +0000]
Parses extra attributes for tables. Tweaked debug output.

19 years agoSome cosmetic changes.
Ken Youens-Clark [Tue, 7 Jun 2005 16:55:41 +0000]
Some cosmetic changes.

19 years agoSome changes that should have been applied a while back.
Ken Youens-Clark [Tue, 7 Jun 2005 16:49:55 +0000]
Some changes that should have been applied a while back.

19 years agoMuffled a warning message, by changing '">...
Ben Faga [Tue, 31 May 2005 18:23:31 +0000]
Muffled a warning message, by changing '">&NULL"' (which I don't really understand) to '\*NULL' which is a nice pointer to the file handle opened in the line above.

19 years agoAdded Class::MakeMethods to the requirements.
Ben Faga [Thu, 26 May 2005 19:45:43 +0000]
Added Class::MakeMethods to the requirements.

19 years agoApplied Eric Just's changes to the Oracle producer. His comments follow:
Ben Faga [Wed, 25 May 2005 15:17:49 +0000]
Applied Eric Just's changes to the Oracle producer. His comments follow:

I have made a couple of more changes which you MIGHT want to incorporate into Oracle Producer so that the translation for CHADO works 'out of the box' .  I am attaching a new diff against the new version.

Change 1:
Change the field 'name' property to the unreserved name, that way whenever field-name is called the proper unreserved name is returned.

Change 2:
Using a CLOB in a unique key is illegal in Oracle.  Convert a column to a varchar(4000) if it is a CLOB and is part of a unique key, warn about this change.

Change 3:
Create the sequence name based on the unreserved name of the table.  Since the table gets created with the unreserved name, this keeps the sequence naming consistently based on the table name.

Change 4:
Similar to change 3 except for naming triggers.

Change 5:
remove line that didn't get removed from last merge.  (want to append name with number only after the string has been truncated to max_length -2)

19 years agoApllied Chris Hilton patch to remove subroutine redefinition
Mark Addison [Wed, 25 May 2005 12:38:58 +0000]
Apllied Chris Hilton patch to remove subroutine redefinition

19 years agoApplied Chris Hilton patch to remove 'Use of uninitialized value in addition' warnings
Mark Addison [Wed, 25 May 2005 12:38:03 +0000]
Applied Chris Hilton patch to remove 'Use of uninitialized value in addition' warnings

19 years agoFixed InnoDB table type errors (Chris Hilton patch)
Mark Addison [Wed, 25 May 2005 11:56:24 +0000]
Fixed InnoDB table type errors (Chris Hilton patch)

19 years agoApplied Chis Hilton patch to fix. (Test used non existant test file)
Mark Addison [Wed, 25 May 2005 11:51:59 +0000]
Applied Chis Hilton patch to fix. (Test used non existant test file)

19 years agoAdded explicit close on FILE and fixed spelling mistaked (from Chris Hilton patch
Mark Addison [Wed, 25 May 2005 11:37:58 +0000]
Added explicit close on FILE and fixed spelling mistaked (from Chris Hilton patch

19 years agoAdded Chris Hilton's patch so version number test is based on current version and...
Mark Addison [Wed, 25 May 2005 11:25:15 +0000]
Added Chris Hilton's patch so version number test is based on current version and not hardcoded.

19 years agoFixed broken comment in test (from Chris Hilton patch)
Mark Addison [Wed, 25 May 2005 11:14:22 +0000]
Fixed broken comment in test (from Chris Hilton patch)

19 years agoFixed error propogation when loading filters.
Mark Addison [Wed, 18 May 2005 22:34:10 +0000]
Fixed error propogation when loading filters.

19 years agoUpped version of Test::More req so we get upto date is_deeply().
Mark Addison [Wed, 18 May 2005 16:17:41 +0000]
Upped version of Test::More req so we get upto date is_deeply().

19 years agoAdded hack to remove the Graph stuff hack of adding a ref to the translator, to
Mark Addison [Wed, 18 May 2005 16:14:07 +0000]
Added hack to remove the Graph stuff hack of adding a ref to the translator, to
the schema. Also moved schema equality test to using Test::More::is_deeply
instead of Storable to get better diagnostics on failure.

19 years agoFixed. Broke due to changes in YAML.
Mark Addison [Wed, 18 May 2005 15:48:08 +0000]
Fixed. Broke due to changes in YAML.

19 years agoFixed YAML testi. Failed due to sqlfairy version increase and YAML not putting
Mark Addison [Wed, 18 May 2005 15:47:24 +0000]
Fixed YAML testi. Failed due to sqlfairy version increase and YAML not putting
the YAML version in the output anymore (seems to have been commented out of
YAML.pm some versions ago). Set YAML version in Build.pm so we know we get a
version that works.

19 years agofix to allow GraphViz to load -- someone who understands why this is needed please...
Allen Day [Fri, 13 May 2005 07:35:58 +0000]
fix to allow GraphViz to load -- someone who understands why this is needed please comment!

19 years ago*** empty log message ***
Allen Day [Wed, 13 Apr 2005 22:03:23 +0000]
*** empty log message ***

19 years agoincrementing for next release
Allen Day [Wed, 13 Apr 2005 20:34:20 +0000]
incrementing for next release

19 years agoMade the field definition rows alternate "even" and "odd" classes so
Ken Youens-Clark [Mon, 7 Feb 2005 22:09:32 +0000]
Made the field definition rows alternate "even" and "odd" classes so
you can use CSS to change colors.

19 years agoA SQLServer producer. (They made me do it! :(
Mark Addison [Thu, 13 Jan 2005 21:30:04 +0000]
A SQLServer producer. (They made me do it! :(

19 years agomysql_table_type extra data and InnoDB derivation fix.
Mark Addison [Thu, 13 Jan 2005 11:50:24 +0000]
mysql_table_type extra data and InnoDB derivation fix.