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

18 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()

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

18 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

18 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

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

18 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

18 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

18 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

18 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

18 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

18 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

18 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

18 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.

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

18 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.

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

18 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.

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

18 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.

18 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.

18 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.

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

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

18 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.

18 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.

18 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.

18 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.

18 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.

18 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.

18 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.

18 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.

18 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.

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

18 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.

19 years agoMade extra interface more context sensative.
Mark Addison [Thu, 13 Jan 2005 09:44:15 +0000]
Made extra interface more context sensative.

19 years agoFixed test name
Mark Addison [Thu, 13 Jan 2005 09:02:15 +0000]
Fixed test name

19 years agoreplaced by TT producer
Allen Day [Tue, 21 Dec 2004 01:47:34 +0000]
replaced by TT producer

19 years agoRemoved (annoying) warning when order attributes are not used.
Mark Addison [Tue, 21 Dec 2004 01:29:23 +0000]
Removed (annoying) warning when order attributes are not used.

19 years agolocalised setting of %Data::Dumper::Maxdepth (and Indent), to stop it polluting
Mark Addison [Tue, 21 Dec 2004 01:28:39 +0000]
localised setting of %Data::Dumper::Maxdepth (and Indent), to stop it polluting
the rest of perl and breaking Module::Build!

19 years agoAccepted changes from Eric Just.
Ken Youens-Clark [Mon, 20 Dec 2004 17:18:42 +0000]
Accepted changes from Eric Just.

19 years agoTests moved from 13graph.t.
Ken Youens-Clark [Mon, 20 Dec 2004 16:36:40 +0000]
Tests moved from 13graph.t.

19 years agoMoved graph tests out.
Ken Youens-Clark [Mon, 20 Dec 2004 16:36:22 +0000]
Moved graph tests out.

19 years agoRe-added proper error trapping and reporting when trying to set the parser,
Mark Addison [Mon, 13 Dec 2004 16:32:07 +0000]
Re-added proper error trapping and reporting when trying to set the parser,
producer or a filter to un unknown module/sub (accidently removed by filter
work).

19 years agoAdded schema filters
Mark Addison [Sun, 12 Dec 2004 18:38:11 +0000]
Added schema filters

19 years agoClean up
Mark Addison [Sun, 12 Dec 2004 18:34:43 +0000]
Clean up

19 years agoDrop functions
Jess Robinson [Sat, 27 Nov 2004 16:33:33 +0000]
Drop functions

19 years agoAdded TTSchema changes.
Mark Addison [Fri, 26 Nov 2004 00:41:56 +0000]
Added TTSchema changes.

19 years agoAdded tt-conf option
Mark Addison [Fri, 26 Nov 2004 00:34:09 +0000]
Added tt-conf option

19 years agoTemplate config is now passed using tt_conf producer arg. Deprecated passing
Mark Addison [Fri, 26 Nov 2004 00:28:06 +0000]
Template config is now passed using tt_conf producer arg. Deprecated passing
it in the producer_args directly.

19 years agoAdded tt-vars to pass variables to templates.
Mark Addison [Thu, 25 Nov 2004 23:15:23 +0000]
Added tt-vars to pass variables to templates.

19 years agoDeprecated ttargs producer arg in favour of tt_vars
Mark Addison [Thu, 25 Nov 2004 23:10:59 +0000]
Deprecated ttargs producer arg in favour of tt_vars

19 years agoApplied Dave Howorth's MySQL parser patches
Mark Addison [Thu, 25 Nov 2004 22:32:48 +0000]
Applied Dave Howorth's MySQL parser patches
- ignore INSERT statements
- permit ALTER TABLE ADD FOREIGN KEY
- allow trailing comma on last field in CREATE statements
- collect the database name

19 years agoDB2.pm the first
Jess Robinson [Sat, 20 Nov 2004 15:47:39 +0000]
DB2.pm the first

19 years agoDB2 P::RD grammar
Jess Robinson [Sat, 20 Nov 2004 15:45:21 +0000]
DB2 P::RD grammar

19 years agoRe-added ttvars. Added docs and test for ttvars.
Mark Addison [Tue, 16 Nov 2004 21:06:35 +0000]
Re-added ttvars. Added docs and test for ttvars.

19 years agoI needed to be able to pass in additional information to the templates (beyond the...
Brian O'Connor [Tue, 16 Nov 2004 09:15:36 +0000]
I needed to be able to pass in additional information to the templates (beyond the schema object)
processed by this producer. Before it only passed one argument through to the template but now I pass
all items in the template args hash.

19 years agoFactored _load_sub() out of _tool(). Ground work for adding filters.
Mark Addison [Tue, 9 Nov 2004 05:27:45 +0000]
Factored _load_sub() out of _tool(). Ground work for adding filters.

19 years agoRefactored producer() and parser() to use a sub, _tool(), implimenting their
Mark Addison [Tue, 9 Nov 2004 02:09:52 +0000]
Refactored producer() and parser() to use a sub, _tool(), implimenting their
shared functionality, in much the same way producer_args() and
parser_args() use _args().

load() now also supports checking a path of base packages. Ground work for adding
a producer and parser paths feature, to make it easier to load them from
different namespaces.

19 years agoAdded extra and Schema::Object stuff
Mark Addison [Fri, 5 Nov 2004 16:41:09 +0000]
Added extra and Schema::Object stuff

19 years agoAdded writing of extra data for all objects to XML producer.
Mark Addison [Fri, 5 Nov 2004 16:37:01 +0000]
Added writing of extra data for all objects to XML producer.

19 years agoAll Schema objects now have an extra attribute. Added parsing support (and
Mark Addison [Fri, 5 Nov 2004 15:03:11 +0000]
All Schema objects now have an extra attribute. Added parsing support (and
tests) for this to the SQLF XML parser.

19 years agoAdded _attributes class data to SQL::Translator::Schema::Object for sub classes
Mark Addison [Fri, 5 Nov 2004 13:19:31 +0000]
Added _attributes class data to SQL::Translator::Schema::Object for sub classes
to declare their attributes with and an init method to initialize the class from
this data.

19 years agoAdded diagnostics on fail.
Mark Addison [Fri, 5 Nov 2004 13:16:49 +0000]
Added diagnostics on fail.

19 years agoAdded SQL::Translator::Schema::Object, a base class for all the Schema
Mark Addison [Thu, 4 Nov 2004 16:29:56 +0000]
Added SQL::Translator::Schema::Object, a base class for all the Schema
objects and made them all use it.

19 years agoFixing the error "Can't use an undefined value as a HASH reference at
Ken Youens-Clark [Tue, 26 Oct 2004 00:00:41 +0000]
Fixing the error "Can't use an undefined value as a HASH reference at
/Users/kclark/Work/sqlf/sqlfairy/lib/SQL/Translator/Producer/TTSchema.pm
line 123."

19 years agothrows error if a comment is placed on a non-existent column
Chris Mungall [Sat, 23 Oct 2004 20:18:44 +0000]
throws error if a comment is placed on a non-existent column

19 years agofixed parsing of Pg COMMENT ON ... syntax
Chris Mungall [Sat, 23 Oct 2004 19:58:32 +0000]
fixed parsing of Pg COMMENT ON ... syntax

previously only recognised comments on TABLE and COLUMN
also would not recognise comment_phrases split over multiple lines

now accept all comment types; however, it does not add information
to the datamodel except for TABLE and COLUMN

accepts comments split over multiple lines

will barf if comment includes escaped singlequote ''

test 08 extended to deal with parsing comments gracefully
(does not check contents of datamodel however)

19 years agoProducer::Turnkey obsolete. now rely on TTSchema parser (see concommitant
Allen Day [Fri, 15 Oct 2004 03:52:51 +0000]
Producer::Turnkey obsolete.  now rely on TTSchema parser (see concommitant
turnkey commit).

modified TTschema to accept 'ttargs' in addition to already present 'ttfile'
so arbitrary template args can be interpolated.

added Schema::Graph unit test (!).  minimal.

introduced Log::Log4perl dependency.

modified Schema to have translator() slot to hold parent ref.  needed to
get at producer_args(), parser_args(), and _format_name() from Graph.pm

19 years agopatch for parser/producer args courtesy of darren (w/ embellishments by me)
Allen Day [Fri, 15 Oct 2004 02:23:30 +0000]
patch for parser/producer args courtesy of darren (w/ embellishments by me)

19 years agosome refactoring. moving to being able to call $schema->as_graph to do
Allen Day [Wed, 13 Oct 2004 23:14:06 +0000]
some refactoring.  moving to being able to call $schema->as_graph to do
an OM translation.

19 years agolc the template files... flipflop
Allen Day [Wed, 13 Oct 2004 22:31:59 +0000]
lc the template files... flipflop

19 years agoalmost working. there is a package name mangling problem where the
Allen Day [Wed, 13 Oct 2004 22:24:49 +0000]
almost working.  there is a package name mangling problem where the
upcasing doesn't happen properly... i think it's the lack of callback
calling in the right places, or an erroneous callback.

19 years agoFixed POD.
Ken Youens-Clark [Fri, 24 Sep 2004 14:06:46 +0000]
Fixed POD.

19 years agoFixed syntax error.
Ken Youens-Clark [Thu, 23 Sep 2004 15:08:03 +0000]
Fixed syntax error.

19 years agoModifications to the Turnkey producer to support file split in the Turnkey install...
Brian O'Connor [Wed, 22 Sep 2004 23:46:53 +0000]
Modifications to the Turnkey producer to support file split in the Turnkey install process

19 years agoOK, I really got it this time.
Ken Youens-Clark [Mon, 20 Sep 2004 20:48:19 +0000]
OK, I really got it this time.

19 years agoThat last commit wasn't very thought-out.
Ken Youens-Clark [Mon, 20 Sep 2004 20:32:18 +0000]
That last commit wasn't very thought-out.

19 years agoThe default too often was "tinyint," changed to only make it that when
Ken Youens-Clark [Mon, 20 Sep 2004 20:22:47 +0000]
The default too often was "tinyint," changed to only make it that when
necessary and default non-float number fields to "int."