Allen Day [Mon, 3 Mar 2003 20:52:57 +0000]
turning off debugging in t/08
Darren Chamberlain [Wed, 26 Feb 2003 13:12:40 +0000]
A README, which is required by CPAN.
Darren Chamberlain [Wed, 26 Feb 2003 13:11:42 +0000]
o Added bin/auto-dia.pl to scripts list
o Added a test for auto-dia (which might be questionable).
o Added GD to module prerequisite list
o Changed VERSION number, in anticipation of an intial release.
Darren Chamberlain [Wed, 26 Feb 2003 13:08:59 +0000]
Some doc changes; added Allen to AUTHORS section
Ken Youens-Clark [Wed, 26 Feb 2003 05:17:49 +0000]
Handle "on [delete|update] action" differently
Ken Youens-Clark [Wed, 26 Feb 2003 05:17:21 +0000]
Added more rule (alter table) to be able handle Chado schema.
Ken Youens-Clark [Tue, 25 Feb 2003 21:58:46 +0000]
Deleted "index" rules, allowed fore and aft comments in fields and
table constraints (unique, PK, etc.).
Darren Chamberlain [Tue, 25 Feb 2003 21:42:56 +0000]
Added t/08postgres-to-mysql.t
Ken Youens-Clark [Tue, 25 Feb 2003 21:25:14 +0000]
Added production to field rule to handle embedded comments.
Ken Youens-Clark [Tue, 25 Feb 2003 14:55:36 +0000]
Added some documentation to PG and MySQL; the "eofile" rule to MySQL.
Ken Youens-Clark [Tue, 25 Feb 2003 05:02:06 +0000]
Mods to handles FK references.
Ken Youens-Clark [Tue, 25 Feb 2003 05:01:35 +0000]
A working PG parser!
Allen Day [Tue, 25 Feb 2003 03:24:56 +0000]
i forget what i did, but i found more bugs. we need to be able to support 'varchar'
as implying 'varchar(255)' for both field and index declarations. also 'double precision'
as a synonym for 'double'. also, mysql doesn't support boolean datatype, but postgres does,
so we need to find a way to deal with this.
that's all for now.
-ad
Allen Day [Tue, 25 Feb 2003 02:03:55 +0000]
BUG. the parser cannot handle 'precision' as a qualifier for 'double'. this also applies to the mysql parser.
Allen Day [Tue, 25 Feb 2003 01:01:30 +0000]
added a serial->int auto_increment fix, a varchar->varchar(255) workaround.
Allen Day [Fri, 21 Feb 2003 19:35:17 +0000]
moving files around per ky's request
Allen Day [Fri, 21 Feb 2003 17:56:49 +0000]
here is the pgsql test script. NOTE: it will not work right now b/c i've
just changed ::PostGreSQL to ::PostgreSQL, but haven't renamed the module
itself yet. will do so later this morning, unless someone beats me to it
:-)
Darren Chamberlain [Fri, 21 Feb 2003 15:19:04 +0000]
Added new files to MANIFEST.
Started updating tests to use Test::More, rather than the homegrown
print stuff I'd started with (bad darren!).
The load test uses SQL::Translator::load, to both exercise load() and
to perform the actual test (I've intentionally used load instead of
Test::More::use_ok).
Added more dependencies to Makefile.PL.
Sorted the dependencies in PREREQ_PM, and the file list in MANIFEST,
because I'm obsessive about those sorts of silly things.
Allen Day [Fri, 21 Feb 2003 08:42:29 +0000]
an adaptor for postgres. this works, but i think my primary key and
foreign key parses are hackish. they require the pk/fk clause
_right_after_ the field declaration, which i don't think is how postgres
requires it.
also i've found a bug in the mysql parser that is in the postgres parser
as well that doesn't allow comments in the middle of table create
statements. this will cause a failed parse:
create table x (
x int,
-- a comment
);
Allen Day [Fri, 21 Feb 2003 03:23:33 +0000]
added Class::Base preq
Ken Youens-Clark [Sat, 15 Feb 2003 23:38:35 +0000]
Lots o' bug fixes. Added "join-pk-only" option.
Ken Youens-Clark [Sat, 15 Feb 2003 02:31:23 +0000]
Made it better.
Ken Youens-Clark [Sat, 15 Feb 2003 02:30:59 +0000]
Added fulltext index.
Ken Youens-Clark [Fri, 14 Feb 2003 20:29:12 +0000]
Added "auto-dia.pl" script for generating ER diagrams.
Darren Chamberlain [Wed, 29 Jan 2003 13:32:44 +0000]
Did you forget what year it is, Ken?
Darren Chamberlain [Wed, 29 Jan 2003 13:29:49 +0000]
Moved all POD to the end of the module, to make it easier
to modify and find.
Added a bunch of inline documentation.
Refactored a few of the duplicated methods, such as producer_args
and parser_args.
Darren Chamberlain [Wed, 29 Jan 2003 13:28:28 +0000]
Set $DEBUG to 0 by default.
Darren Chamberlain [Wed, 29 Jan 2003 13:27:44 +0000]
Removed extra unused junk.
Darren Chamberlain [Wed, 29 Jan 2003 13:27:12 +0000]
Added SQL::Translator::Producer::Raw to MANIFEST.
Ken Youens-Clark [Wed, 29 Jan 2003 02:43:44 +0000]
Added "Raw" to be able to get to raw parser output.
Darren Chamberlain [Mon, 27 Jan 2003 17:04:48 +0000]
Documentation fixes; added Chris' name to copyright notice; updated copyright year.
Ken Youens-Clark [Thu, 2 Jan 2003 17:47:59 +0000]
Fixed bug where it was truncating table name needlessly.
Ken Youens-Clark [Wed, 11 Dec 2002 01:44:54 +0000]
Fixed problem with truncating an identifier when it was exactly the
$max_id_length and no "type" was supplied to "mk_name."
Ken Youens-Clark [Wed, 4 Dec 2002 01:53:51 +0000]
Fixed a bug in Oracle producer that allowed for identifiers longer than the
maximum allowed length, also there was a problem with not using the
unreserved table name. Added decent amount of functionality to PG producer.
Darren Chamberlain [Tue, 3 Dec 2002 16:20:08 +0000]
MANIFEST.SKIP takes a regex, not a list. Some of the .pm files weren't in the MANIFESt.
Darren Chamberlain [Tue, 3 Dec 2002 16:17:48 +0000]
Moved MANIFEST.skip to MANIFEST.SKIP
Darren Chamberlain [Tue, 3 Dec 2002 16:05:25 +0000]
More generic clean macro
Ken Youens-Clark [Thu, 28 Nov 2002 04:21:07 +0000]
Added a rule to MySQL parser to disregard "DROP...;" statements, filled out
XML producer to generate hand-crafted XML.
Ken Youens-Clark [Tue, 26 Nov 2002 03:59:58 +0000]
Added "show_warnings" and "add_drop_table" options to sql_translator.pl and
to SQL::Translator/Oracle producer. Fixed bug in Oracle producer that
duplicated identifiers. Adding a lot of Oracle producer's logic to new
PostgreSQL producer.
Darren Chamberlain [Mon, 25 Nov 2002 14:49:44 +0000]
Updated an example to make it happier.
Darren Chamberlain [Mon, 25 Nov 2002 14:48:34 +0000]
Added some comments (comments?)
Ken Youens-Clark [Sat, 23 Nov 2002 01:26:56 +0000]
Fixed spelling of "indices" in various files, finished adding all of Tim
Bunce's logic from his "mysql2ora" script, Oracle producer is now a bit
smarter, converting from MySQL to Oracle (or back to MySQL) should all
work really well now.
Ken Youens-Clark [Fri, 22 Nov 2002 03:03:40 +0000]
Rolled in Darren's new list_[producers|parsers], lots of cosmetic changes,
working in Tim Bunce's "mysql2ora" grammar and producer logic into
appropriate modules, making output of producers more consistent, added
table order to MySQL parser, using it in Oracle producer to maintain
original ordering.
Darren Chamberlain [Thu, 21 Nov 2002 17:45:17 +0000]
Added list_parsers and list_producers methods, in response to <Pine.LNX.4.44.
0211211124100.4042-100000@localhost.localdomain>
Ken Youens-Clark [Wed, 20 Nov 2002 04:03:56 +0000]
Added PostgreSQL producer.
Ken Youens-Clark [Wed, 20 Nov 2002 04:03:04 +0000]
Fixed a lot of little things in modules, docs, etc. Bugs in sql_translator.pl.
Chris Mungall [Fri, 11 Oct 2002 21:09:49 +0000]
*** empty log message ***
Darren Chamberlain [Tue, 23 Jul 2002 19:22:11 +0000]
Changed error_out usage to error
Darren Chamberlain [Tue, 23 Jul 2002 19:21:16 +0000]
Subclasses Class::Base. Removed error_out, error, in favor Class::Base::error.
Darren Chamberlain [Mon, 8 Jul 2002 14:42:56 +0000]
Shitload of changes. Still passes all tests, such as they are.
Darren Chamberlain [Tue, 11 Jun 2002 12:09:13 +0000]
Fixed some typos, added some basic re-logicing (is that even a word?)
Darren Chamberlain [Fri, 29 Mar 2002 13:08:19 +0000]
Added generation of PRIMARY KEY and KEY clauses to CREATE statements.
Reorganized where CR are put.
Darren Chamberlain [Wed, 27 Mar 2002 12:41:53 +0000]
Added MySQL producer (still in a pretty alpha stage, only barely functional).
Updated Validator.pm.
Added a few new bugs to BUGS.
Added file, filename, and data methods to Translator.pm.
Silly change to Makefile.PL that will most likely come out.
Darren Chamberlain [Tue, 26 Mar 2002 12:46:54 +0000]
Added support for producer_args and parser_args.
Added test for producer_args and parser_args.
Added t/07p_test.t to MANIFEST.
Added validator_test.pl to bin (though not to MANIFEST).
Darren Chamberlain [Mon, 25 Mar 2002 14:27:23 +0000]
Added CSV parser and a test.
Darren Chamberlain [Mon, 25 Mar 2002 14:26:57 +0000]
Added extra files to MANIFEST.skip. Updated MANIFEST.
Darren Chamberlain [Mon, 25 Mar 2002 14:26:25 +0000]
Added test structure.
Darren Chamberlain [Mon, 25 Mar 2002 14:25:58 +0000]
Added 'order' to data structure description
Darren Chamberlain [Thu, 21 Mar 2002 18:55:28 +0000]
Automatically generated by cvs2cl.pl
Darren Chamberlain [Thu, 21 Mar 2002 18:50:54 +0000]
Merged changes from darren-1_0 tag into HEAD branch (hopefully!).
Darren Chamberlain [Thu, 21 Mar 2002 18:48:36 +0000]
Removed in anticipation of a merge.
Darren Chamberlain [Thu, 21 Mar 2002 18:07:46 +0000]
Test changes
Darren Chamberlain [Thu, 21 Mar 2002 17:52:18 +0000]
Accidentally PREREQ_PM'ed XML::Writer instead fo XML::Dumper
Darren Chamberlain [Thu, 21 Mar 2002 17:48:58 +0000]
Re-added
Darren Chamberlain [Thu, 21 Mar 2002 15:54:34 +0000]
Updated filelist
Darren Chamberlain [Thu, 21 Mar 2002 15:53:21 +0000]
Added some basic files, removed unused data file (the contents were moved into the test that used the data).
Darren Chamberlain [Thu, 21 Mar 2002 15:52:03 +0000]
Removed comment lines (the parser chokes on these, I think).
Changed DEFAULT x NOT NULL lines to NOT NULL DEFAULT x, so overcompensate for a bug in the MySQL parser.
Removed references to FULLTEXT indexes, because the MySQL grammar doesn't know about them.
Darren Chamberlain [Thu, 21 Mar 2002 15:50:10 +0000]
Removed warns and debugging, so this test will actually pass when run as part of make test.
Darren Chamberlain [Thu, 21 Mar 2002 15:49:39 +0000]
Turned off SQL::Translator::DEBUG.
Darren Chamberlain [Thu, 21 Mar 2002 15:49:11 +0000]
Broke the 1 test out into 11 different tests, each one of which tests a specific part of the data structure returned by parse.
Darren Chamberlain [Thu, 21 Mar 2002 15:48:19 +0000]
Changed name of translate method to produce, to be consistant with Producer API. Added __END__ token. Updated $VERSION to be CPAN-compliant.
Darren Chamberlain [Thu, 21 Mar 2002 15:47:08 +0000]
Modified POD to include a complex description of the format of the data structure returned by parse.
Added myself to the AUTHORS section.
Darren Chamberlain [Thu, 21 Mar 2002 15:45:42 +0000]
Added Pod::Usage as a prerequisite
Darren Chamberlain [Wed, 20 Mar 2002 18:22:08 +0000]
Automatically generated by cvs2cl.pl
Darren Chamberlain [Wed, 20 Mar 2002 16:37:14 +0000]
syncmail test.
Darren Chamberlain [Wed, 20 Mar 2002 16:31:21 +0000]
This was a synmail test.
Darren Chamberlain [Tue, 19 Mar 2002 13:26:27 +0000]
Changed some of the basic assumptions.
Removed code to check filehandle reads.
Darren Chamberlain [Mon, 18 Mar 2002 20:39:46 +0000]
Automatically generated by cvs2cl.pl
Darren Chamberlain [Mon, 18 Mar 2002 20:39:10 +0000]
Changelog file.
Darren Chamberlain [Mon, 18 Mar 2002 20:35:51 +0000]
Updated docs, especially detailed internal API docs.
Updated default sub to return the data structure (and not the SQL::Translator instance). This became an issue once the subs were redefined to accept two args.
Removed the possibility to pass a filehandle (or something that can getlines) as an option to translate.
Added many levels of code folding markers.
Updated parser to use a named class::function style of defining a function to call, just like producer.
Darren Chamberlain [Mon, 18 Mar 2002 20:32:16 +0000]
Changed many assumptions about the test.
Uses the default parser and producer (which is a pass through)
Darren Chamberlain [Mon, 18 Mar 2002 20:30:37 +0000]
Added note of a bug
Darren Chamberlain [Fri, 15 Mar 2002 20:18:37 +0000]
Added files.
Darren Chamberlain [Fri, 15 Mar 2002 20:14:29 +0000]
Added MANIFEST, MANIFEST.skip, and Makefile.PL
Darren Chamberlain [Fri, 15 Mar 2002 20:13:46 +0000]
Added copyright notices to top of files.
Updated documentation to be accurate.
Updated parser and producer classes to work with the modified API defined by SQL::Translate.
SQL::Translator instances have data members named parser_type and producer_type that can be used to determine from whence the parser and producer subroutines come.
SQL::Translator will accept parsers and producers in the form Class::Name::function, just like mod_perl, in addition to Class::Name (with the implicit function name), Name (relative to SQL::Translator::{Parser,Producer}, and anonymous subroutines.
Darren Chamberlain [Fri, 15 Mar 2002 20:10:22 +0000]
Added test data in groovy hierarchical directories.
Added some basic tests, many of which don't do much yet.
Darren Chamberlain [Fri, 15 Mar 2002 20:09:38 +0000]
Updated to work with my updated API.
Added license to beginning.
Updated to be CPAN-compliant.
Darren Chamberlain [Thu, 7 Mar 2002 14:14:48 +0000]
Another attempt to check in a branch.
CVS2SVN [Thu, 7 Mar 2002 14:11:41 +0000]
This commit was manufactured by cvs2svn to create branch 'darren-1_0'.
Darren Chamberlain [Thu, 7 Mar 2002 14:11:40 +0000]
Reverted to a version 1.1, due to botched branch attempt.
Darren Chamberlain [Thu, 7 Mar 2002 14:06:20 +0000]
Many, many changes. Changed the basic assumptions about the module.
Parser and Producer packages no longer need to be object oriented, they merely need to implement a parse or translate function (respectively).
Ken Youens-Clark [Fri, 1 Mar 2002 02:26:25 +0000]
Initial checkin.