21 years ago:)
Mikey Melillo [Thu, 27 Mar 2003 19:07:00 +0000]
:)

21 years agoadded need for Excel Spreadsheet parser module
Mikey Melillo [Thu, 27 Mar 2003 18:03:50 +0000]
added need for Excel Spreadsheet parser module
which I will write in the near future per Darren's request

21 years ago- load now sets $ERROR on failure.
Darren Chamberlain [Wed, 12 Mar 2003 14:19:52 +0000]
- load now sets $ERROR on failure.

- list_parsers and list_producers are a little more robust, and look
in every directory in @INC.

21 years agoAdded SQLite producer and Utils.
Darren Chamberlain [Wed, 12 Mar 2003 14:17:35 +0000]
Added SQLite producer and Utils.

21 years agoAdded Utils package with debug method, shared between MySQL and SQLite producers.
Darren Chamberlain [Wed, 12 Mar 2003 14:17:11 +0000]
Added Utils package with debug method, shared between MySQL and SQLite producers.

21 years agoAdded code to kill field qualifiers in index field declarations.
Ken Youens-Clark [Fri, 7 Mar 2003 16:08:22 +0000]
Added code to kill field qualifiers in index field declarations.

21 years agoAdded SQLite producer, basic knock-off of MySQL producer, made some mods
Ken Youens-Clark [Tue, 4 Mar 2003 21:24:13 +0000]
Added SQLite producer, basic knock-off of MySQL producer, made some mods
to MySQL producer to add "DROP TABLE" statements, fixed POD a bit.

21 years agoSome minor mods to POD.
Ken Youens-Clark [Tue, 4 Mar 2003 21:20:17 +0000]
Some minor mods to POD.

21 years agoturning off debugging in t/08
Allen Day [Mon, 3 Mar 2003 20:52:57 +0000]
turning off debugging in t/08

21 years agoA README, which is required by CPAN. v0.01
Darren Chamberlain [Wed, 26 Feb 2003 13:12:40 +0000]
A README, which is required by CPAN.

21 years agoo Added bin/auto-dia.pl to scripts list
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.

21 years agoSome doc changes; added Allen to AUTHORS section
Darren Chamberlain [Wed, 26 Feb 2003 13:08:59 +0000]
Some doc changes; added Allen to AUTHORS section

21 years agoHandle "on [delete|update] action" differently
Ken Youens-Clark [Wed, 26 Feb 2003 05:17:49 +0000]
Handle "on [delete|update] action" differently

21 years agoAdded more rule (alter table) to be able handle Chado schema.
Ken Youens-Clark [Wed, 26 Feb 2003 05:17:21 +0000]
Added more rule (alter table) to be able handle Chado schema.

21 years agoDeleted "index" rules, allowed fore and aft comments in fields and
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.).

21 years agoAdded t/08postgres-to-mysql.t
Darren Chamberlain [Tue, 25 Feb 2003 21:42:56 +0000]
Added t/08postgres-to-mysql.t

21 years agoAdded production to field rule to handle embedded comments.
Ken Youens-Clark [Tue, 25 Feb 2003 21:25:14 +0000]
Added production to field rule to handle embedded comments.

21 years agoAdded some documentation to PG and MySQL; the "eofile" rule to MySQL.
Ken Youens-Clark [Tue, 25 Feb 2003 14:55:36 +0000]
Added some documentation to PG and MySQL; the "eofile" rule to MySQL.

21 years agoMods to handles FK references.
Ken Youens-Clark [Tue, 25 Feb 2003 05:02:06 +0000]
Mods to handles FK references.

21 years agoA working PG parser!
Ken Youens-Clark [Tue, 25 Feb 2003 05:01:35 +0000]
A working PG parser!

21 years agoi forget what i did, but i found more bugs. we need to be able to support 'varchar'
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

21 years agoBUG. the parser cannot handle 'precision' as a qualifier for 'double'. this also...
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.

21 years agoadded a serial->int auto_increment fix, a varchar->varchar(255) workaround.
Allen Day [Tue, 25 Feb 2003 01:01:30 +0000]
added a serial->int auto_increment fix, a varchar->varchar(255) workaround.

21 years agomoving files around per ky's request
Allen Day [Fri, 21 Feb 2003 19:35:17 +0000]
moving files around per ky's request

21 years agohere is the pgsql test script. NOTE: it will not work right now b/c i've
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
:-)

21 years agoAdded new files to MANIFEST.
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.

21 years agoan adaptor for postgres. this works, but i think my primary key and
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
);

21 years agoadded Class::Base preq
Allen Day [Fri, 21 Feb 2003 03:23:33 +0000]
added Class::Base preq

21 years agoLots o' bug fixes. Added "join-pk-only" option.
Ken Youens-Clark [Sat, 15 Feb 2003 23:38:35 +0000]
Lots o' bug fixes.  Added "join-pk-only" option.

21 years agoMade it better.
Ken Youens-Clark [Sat, 15 Feb 2003 02:31:23 +0000]
Made it better.

21 years agoAdded fulltext index.
Ken Youens-Clark [Sat, 15 Feb 2003 02:30:59 +0000]
Added fulltext index.

21 years agoAdded "auto-dia.pl" script for generating ER diagrams.
Ken Youens-Clark [Fri, 14 Feb 2003 20:29:12 +0000]
Added "auto-dia.pl" script for generating ER diagrams.

21 years agoDid you forget what year it is, Ken?
Darren Chamberlain [Wed, 29 Jan 2003 13:32:44 +0000]
Did you forget what year it is, Ken?

21 years agoMoved all POD to the end of the module, to make it easier
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.

21 years agoSet $DEBUG to 0 by default.
Darren Chamberlain [Wed, 29 Jan 2003 13:28:28 +0000]
Set $DEBUG to 0 by default.

21 years agoRemoved extra unused junk.
Darren Chamberlain [Wed, 29 Jan 2003 13:27:44 +0000]
Removed extra unused junk.

21 years agoAdded SQL::Translator::Producer::Raw to MANIFEST.
Darren Chamberlain [Wed, 29 Jan 2003 13:27:12 +0000]
Added SQL::Translator::Producer::Raw to MANIFEST.

21 years agoAdded "Raw" to be able to get to raw parser output.
Ken Youens-Clark [Wed, 29 Jan 2003 02:43:44 +0000]
Added "Raw" to be able to get to raw parser output.

21 years agoDocumentation fixes; added Chris' name to copyright notice; updated copyright year.
Darren Chamberlain [Mon, 27 Jan 2003 17:04:48 +0000]
Documentation fixes; added Chris' name to copyright notice; updated copyright year.

21 years agoFixed bug where it was truncating table name needlessly.
Ken Youens-Clark [Thu, 2 Jan 2003 17:47:59 +0000]
Fixed bug where it was truncating table name needlessly.

21 years agoFixed problem with truncating an identifier when it was exactly the
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."

21 years agoFixed a bug in Oracle producer that allowed for identifiers longer than the
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.

21 years agoMANIFEST.SKIP takes a regex, not a list. Some of the .pm files weren't in the MANIFESt.
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.

21 years agoMoved MANIFEST.skip to MANIFEST.SKIP
Darren Chamberlain [Tue, 3 Dec 2002 16:17:48 +0000]
Moved MANIFEST.skip to MANIFEST.SKIP

21 years agoMore generic clean macro
Darren Chamberlain [Tue, 3 Dec 2002 16:05:25 +0000]
More generic clean macro

22 years agoAdded a rule to MySQL parser to disregard "DROP...;" statements, filled out
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.

22 years agoAdded "show_warnings" and "add_drop_table" options to sql_translator.pl and
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.

22 years agoUpdated an example to make it happier.
Darren Chamberlain [Mon, 25 Nov 2002 14:49:44 +0000]
Updated an example to make it happier.

22 years agoAdded some comments (comments?)
Darren Chamberlain [Mon, 25 Nov 2002 14:48:34 +0000]
Added some comments (comments?)

22 years agoFixed spelling of "indices" in various files, finished adding all of Tim
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.

22 years agoRolled in Darren's new list_[producers|parsers], lots of cosmetic changes,
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.

22 years agoAdded list_parsers and list_producers methods, in response to <Pine.LNX.4.44.02112111...
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>

22 years agoAdded PostgreSQL producer.
Ken Youens-Clark [Wed, 20 Nov 2002 04:03:56 +0000]
Added PostgreSQL producer.

22 years agoFixed a lot of little things in modules, docs, etc. Bugs in sql_translator.pl.
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.

22 years ago*** empty log message ***
Chris Mungall [Fri, 11 Oct 2002 21:09:49 +0000]
*** empty log message ***

22 years agoChanged error_out usage to error
Darren Chamberlain [Tue, 23 Jul 2002 19:22:11 +0000]
Changed error_out usage to error

22 years agoSubclasses Class::Base. Removed error_out, error, in favor Class::Base::error.
Darren Chamberlain [Tue, 23 Jul 2002 19:21:16 +0000]
Subclasses Class::Base. Removed error_out, error, in favor Class::Base::error.

22 years agoShitload of changes. Still passes all tests, such as they are.
Darren Chamberlain [Mon, 8 Jul 2002 14:42:56 +0000]
Shitload of changes.  Still passes all tests, such as they are.

22 years agoFixed some typos, added some basic re-logicing (is that even a word?)
Darren Chamberlain [Tue, 11 Jun 2002 12:09:13 +0000]
Fixed some typos, added some basic re-logicing (is that even a word?)

22 years agoAdded generation of PRIMARY KEY and KEY clauses to CREATE statements.
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.

22 years agoAdded MySQL producer (still in a pretty alpha stage, only barely functional).
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.

22 years agoAdded support for producer_args and parser_args.
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).

22 years agoAdded CSV parser and a test.
Darren Chamberlain [Mon, 25 Mar 2002 14:27:23 +0000]
Added CSV parser and a test.

22 years agoAdded extra files to MANIFEST.skip. Updated MANIFEST.
Darren Chamberlain [Mon, 25 Mar 2002 14:26:57 +0000]
Added extra files to MANIFEST.skip.  Updated MANIFEST.

22 years agoAdded test structure.
Darren Chamberlain [Mon, 25 Mar 2002 14:26:25 +0000]
Added test structure.

22 years agoAdded 'order' to data structure description
Darren Chamberlain [Mon, 25 Mar 2002 14:25:58 +0000]
Added 'order' to data structure description

22 years agoAutomatically generated by cvs2cl.pl
Darren Chamberlain [Thu, 21 Mar 2002 18:55:28 +0000]
Automatically generated by cvs2cl.pl

22 years agoMerged changes from darren-1_0 tag into HEAD branch (hopefully!).
Darren Chamberlain [Thu, 21 Mar 2002 18:50:54 +0000]
Merged changes from darren-1_0 tag into HEAD branch (hopefully!).

22 years agoRemoved in anticipation of a merge.
Darren Chamberlain [Thu, 21 Mar 2002 18:48:36 +0000]
Removed in anticipation of a merge.

22 years agoTest changes
Darren Chamberlain [Thu, 21 Mar 2002 18:07:46 +0000]
Test changes

22 years agoAccidentally PREREQ_PM'ed XML::Writer instead fo XML::Dumper
Darren Chamberlain [Thu, 21 Mar 2002 17:52:18 +0000]
Accidentally PREREQ_PM'ed XML::Writer instead fo XML::Dumper

22 years agoRe-added
Darren Chamberlain [Thu, 21 Mar 2002 17:48:58 +0000]
Re-added

22 years agoUpdated filelist
Darren Chamberlain [Thu, 21 Mar 2002 15:54:34 +0000]
Updated filelist

22 years agoAdded some basic files, removed unused data file (the contents were moved into the...
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).

22 years agoRemoved comment lines (the parser chokes on these, I think).
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.

22 years agoRemoved warns and debugging, so this test will actually pass when run as part of...
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.

22 years agoTurned off SQL::Translator::DEBUG.
Darren Chamberlain [Thu, 21 Mar 2002 15:49:39 +0000]
Turned off SQL::Translator::DEBUG.

22 years agoBroke the 1 test out into 11 different tests, each one of which tests a specific...
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.

22 years agoChanged name of translate method to produce, to be consistant with Producer API....
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.

22 years agoModified POD to include a complex description of the format of the data structure...
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.

22 years agoAdded Pod::Usage as a prerequisite
Darren Chamberlain [Thu, 21 Mar 2002 15:45:42 +0000]
Added Pod::Usage as a prerequisite

22 years agoAutomatically generated by cvs2cl.pl
Darren Chamberlain [Wed, 20 Mar 2002 18:22:08 +0000]
Automatically generated by cvs2cl.pl

22 years agosyncmail test.
Darren Chamberlain [Wed, 20 Mar 2002 16:37:14 +0000]
syncmail test.

22 years agoThis was a synmail test.
Darren Chamberlain [Wed, 20 Mar 2002 16:31:21 +0000]
This was a synmail test.

22 years agoChanged some of the basic assumptions.
Darren Chamberlain [Tue, 19 Mar 2002 13:26:27 +0000]
Changed some of the basic assumptions.
Removed code to check filehandle reads.

22 years agoAutomatically generated by cvs2cl.pl
Darren Chamberlain [Mon, 18 Mar 2002 20:39:46 +0000]
Automatically generated by cvs2cl.pl

22 years agoChangelog file.
Darren Chamberlain [Mon, 18 Mar 2002 20:39:10 +0000]
Changelog file.

22 years agoUpdated docs, especially detailed internal API docs.
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.

22 years agoChanged many assumptions about the test.
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)

22 years agoAdded note of a bug
Darren Chamberlain [Mon, 18 Mar 2002 20:30:37 +0000]
Added note of a bug

22 years agoAdded files.
Darren Chamberlain [Fri, 15 Mar 2002 20:18:37 +0000]
Added files.

22 years agoAdded MANIFEST, MANIFEST.skip, and Makefile.PL
Darren Chamberlain [Fri, 15 Mar 2002 20:14:29 +0000]
Added MANIFEST, MANIFEST.skip, and Makefile.PL

22 years agoAdded copyright notices to top of files.
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.

22 years agoAdded test data in groovy hierarchical directories.
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.

22 years agoUpdated to work with my updated API.
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.

22 years agoAnother attempt to check in a branch.
Darren Chamberlain [Thu, 7 Mar 2002 14:14:48 +0000]
Another attempt to check in a branch.

22 years agoThis commit was manufactured by cvs2svn to create branch 'darren-1_0'.
CVS2SVN [Thu, 7 Mar 2002 14:11:41 +0000]
This commit was manufactured by cvs2svn to create branch 'darren-1_0'.

22 years agoReverted to a version 1.1, due to botched branch attempt.
Darren Chamberlain [Thu, 7 Mar 2002 14:11:40 +0000]
Reverted to a version 1.1, due to botched branch attempt.

22 years agoMany, many changes. Changed the basic assumptions about the module.
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).

22 years agoInitial checkin.
Ken Youens-Clark [Fri, 1 Mar 2002 02:26:25 +0000]
Initial checkin.