Ken Youens-Clark [Tue, 3 Jun 2003 22:12:54 +0000]
Added more tests.
Ken Youens-Clark [Tue, 3 Jun 2003 22:11:55 +0000]
Changed grammar to bring it more inline with the official MySQL YACC
grammar, added better support for FK references.
Allen Day [Mon, 26 May 2003 22:29:48 +0000]
added width and height options for graphviz out. no docs
Darren Chamberlain [Mon, 12 May 2003 15:47:23 +0000]
Slightly more paranoid version of parse_list_arg -- check length as well as definedness.
Darren Chamberlain [Mon, 12 May 2003 15:39:28 +0000]
Trim whitespace from arrayref elements as well as array elements; see <Pine.LNX.4.50.
0305121004300.32235-100000@oakhill.homeip.net>.
Ken Youens-Clark [Mon, 12 May 2003 15:00:34 +0000]
Addressed a few style issues to make it like the other producers (use
"header_comment," indentation style [4 spaces, no tabs]). Added Sam's
name as AUTHOR and to copyright.
Ken Youens-Clark [Mon, 12 May 2003 14:59:15 +0000]
Cosmetic change in POD.
Ken Youens-Clark [Mon, 12 May 2003 14:50:50 +0000]
Added Sybase producer to MANIFEST.
Ken Youens-Clark [Mon, 12 May 2003 14:49:39 +0000]
Change to avoid warning of "use of unitialized value."
Ken Youens-Clark [Mon, 12 May 2003 14:48:43 +0000]
Since "true" is the default for trimming and scanning fields for the xSV
parser, changed the args to turn them off.
Sam Angiuoli [Mon, 12 May 2003 14:29:51 +0000]
added Sybase producer
code was derived from existing producer for postgres
functional with RELEASE-0_01, updates to work with current API are coming
Allen Day [Sun, 11 May 2003 04:04:17 +0000]
some fixes to fk method name generation. failed to add nice m-to-m mapping method b/c
data structure is to FUBAR to extract the info i need.
Ken Youens-Clark [Fri, 9 May 2003 19:51:28 +0000]
Don't pass schema, let others call for it.
Ken Youens-Clark [Fri, 9 May 2003 19:51:04 +0000]
Modified to call translator to get schema rather than passing.
Ken Youens-Clark [Fri, 9 May 2003 17:15:30 +0000]
Lots of changes to fix merge.
Ken Youens-Clark [Fri, 9 May 2003 17:12:46 +0000]
Lots of changes to reflect library mods.
Ken Youens-Clark [Fri, 9 May 2003 17:12:15 +0000]
Use "parse_list_args," added "fields" method, changed validation, break
ref to table in DESTROY.
Ken Youens-Clark [Fri, 9 May 2003 17:11:00 +0000]
Use "parse_list_arg," put field order into field object, added "order"
method for table, break all references to fields, constraints and
indices in DESTROY.
Ken Youens-Clark [Fri, 9 May 2003 17:09:43 +0000]
Use "parse_list_args," added "options" (still vague on this), set a default
for "type" of "normal," break ref to table in DESTROY.
Ken Youens-Clark [Fri, 9 May 2003 17:08:14 +0000]
Added use of "parse_list_arg," changed "nullable" method to "is_nullable"
so it would be like "is_auto_increment" and "is_primary_key," added "order"
method, added DESTROY.
Ken Youens-Clark [Fri, 9 May 2003 17:06:46 +0000]
Playing with constants.
Ken Youens-Clark [Fri, 9 May 2003 17:06:11 +0000]
Added "match_type," use "parse_list_arg," added DESTROY.
Ken Youens-Clark [Fri, 9 May 2003 17:04:39 +0000]
Removed warning.
Ken Youens-Clark [Fri, 9 May 2003 17:03:43 +0000]
Added passing of schema arg.
Ken Youens-Clark [Fri, 9 May 2003 16:55:07 +0000]
Playing around with new schema object.
Ken Youens-Clark [Fri, 9 May 2003 16:54:03 +0000]
Added oft-used "parse_list_arg" sub for Schema classes.
Ken Youens-Clark [Fri, 9 May 2003 16:53:21 +0000]
Made "order" a property of the table and view objects, use a Schwatzian
transform in sorting, added DESTROY to break circular links among objects.
Ken Youens-Clark [Fri, 9 May 2003 16:51:47 +0000]
Passing schema object now as third argument.
Ken Youens-Clark [Fri, 9 May 2003 16:49:41 +0000]
*** empty log message ***
Ken Youens-Clark [Wed, 7 May 2003 20:42:34 +0000]
Minor fixes to primary_key method.
Ken Youens-Clark [Wed, 7 May 2003 20:39:23 +0000]
Added Text::RecordParser 0.02 pre-req.
Ken Youens-Clark [Wed, 7 May 2003 20:37:33 +0000]
Updated tests to match new code.
Ken Youens-Clark [Wed, 7 May 2003 20:36:59 +0000]
Updated to use Text::RecordParser and added scanning of fields, more
functionality.
Ken Youens-Clark [Wed, 7 May 2003 20:36:15 +0000]
Added mods to pass parser_args for xSV parser.
Darren Chamberlain [Tue, 6 May 2003 12:47:54 +0000]
Updated README via perldoc -t lib/SQL/Translator.pm
Darren Chamberlain [Tue, 6 May 2003 12:47:27 +0000]
Uses XML::Writer instead of aggregate() and a global.
Uses sqlfairy namespace (without a DTD yet, sorry).
Darren Chamberlain [Tue, 6 May 2003 12:45:49 +0000]
Updated XML test.
Darren Chamberlain [Tue, 6 May 2003 12:44:54 +0000]
Doc changes (use C<> instead of B<>)
Darren Chamberlain [Tue, 6 May 2003 12:44:10 +0000]
Added Schema and some more dependencies
Ken Youens-Clark [Mon, 5 May 2003 04:33:49 +0000]
More changes to keep up with code.
Ken Youens-Clark [Mon, 5 May 2003 04:33:22 +0000]
Too many changes.
Ken Youens-Clark [Mon, 5 May 2003 04:32:39 +0000]
Too many changes to mention.
Ken Youens-Clark [Sat, 3 May 2003 15:42:59 +0000]
Fixed error 'Use of uninitialized value in pattern match (m//) at blib/lib/SQL/Translator/Schema/Field.pm line 144.'
Ken Youens-Clark [Sat, 3 May 2003 15:40:51 +0000]
Changed to use Test::More, cleaned up syntax. Still pretty useless.
Ken Youens-Clark [Sat, 3 May 2003 15:40:18 +0000]
"size" of a field needs to be an arrayref as it could be two numbers (e.g.,
for a float "10,2").
Ken Youens-Clark [Sat, 3 May 2003 15:21:12 +0000]
Fixed error 'Use of uninitialized value in repeat (x) at blib/lib/SQL/Translator/Producer/XML.pm line 110.'
Ken Youens-Clark [Sat, 3 May 2003 15:17:23 +0000]
Fixed error 'Use of uninitialized value in string eq at blib/lib/SQL/Translator/Producer/MySQL.pm line 164.'
Ken Youens-Clark [Sat, 3 May 2003 15:16:19 +0000]
Fixed error '"my" variable $wb_count masks earlier declaration in same scope at blib/lib/SQL/Translator/Parser/Excel.pm line 68.'
Ken Youens-Clark [Sat, 3 May 2003 15:11:44 +0000]
For some reason, "t.pl" was still in there.
Ken Youens-Clark [Sat, 3 May 2003 15:02:15 +0000]
Fixed an error in default value regex that disallowed a value like "00:18:00".
Ken Youens-Clark [Sat, 3 May 2003 04:15:56 +0000]
Added the requirement of Parse::RecDescent 1.94 or later, added
"auto-graph.pl" to the EXE_FILES.
Ken Youens-Clark [Sat, 3 May 2003 04:12:00 +0000]
Adding a new PG parser test.
Ken Youens-Clark [Sat, 3 May 2003 04:11:37 +0000]
Trying to add tests as I write methods, so lots of new stuff to mirror
development of the Schema::* classes.
Ken Youens-Clark [Sat, 3 May 2003 04:09:50 +0000]
Using some of the rules from the PG grammar to make mine better, cleaned
up the handling of datatypes (esp WRT auto-inc), only placing PK defs as
table constraints (not an index), getting ready to parse views.
Ken Youens-Clark [Sat, 3 May 2003 04:07:38 +0000]
Not much to say ... just trying to get this working.
Ken Youens-Clark [Sat, 3 May 2003 04:07:09 +0000]
More changes to getting the schema to a working state.
Ken Youens-Clark [Thu, 1 May 2003 04:25:00 +0000]
Adding new objects for handing schema data. Not being used while I work
out the tests and the general idea.
Ken Youens-Clark [Thu, 1 May 2003 04:23:11 +0000]
Adding new schema test, commiting fixes to MySQL parser test.
Ken Youens-Clark [Wed, 30 Apr 2003 21:58:40 +0000]
Fixed error that was preventing MySQL parser from working with
Parse::RecDescent 1.94 (needed a "1;" at the end of the create rule);
also made changes to %item hash elements with repeat modifiers to
match what they're now called in Parse::RecDescent 1.94; these changes
now make the parser incompatible with earlier versions of P::RD!
Allen Day [Fri, 25 Apr 2003 23:08:01 +0000]
low hanging fruit, please read the diff below
Darren Chamberlain [Fri, 25 Apr 2003 11:48:12 +0000]
Test file for header_comment function from SQL::Translator::Utils.
Darren Chamberlain [Fri, 25 Apr 2003 11:47:25 +0000]
Added refactored comment producing using header_comment.
Added 'omit_empty_tags' option to XML producer. Also added some
documentation.
Made SQLite producer produce actual auto incremented fields (using the
INTEGER PRIMARY KEY hack) if the field is an auto-incremented one. This
modifies slightly how indexes are produced.
Also modified how mk_name is called in the SQLite producer; SQLite
doesn't accept index names that begin with numbers.
Darren Chamberlain [Fri, 25 Apr 2003 11:44:20 +0000]
Added header_comment function; see docs for details.
Allen Day [Thu, 24 Apr 2003 22:15:28 +0000]
adding a pg src file example
Allen Day [Thu, 24 Apr 2003 22:03:52 +0000]
adding graphviz dep
Ken Youens-Clark [Thu, 24 Apr 2003 21:40:12 +0000]
Added new files.
Ken Youens-Clark [Thu, 24 Apr 2003 20:02:31 +0000]
Added defaults to arguments.
Ken Youens-Clark [Thu, 24 Apr 2003 19:58:39 +0000]
Adding new CGI script front-end for GraphViz and Diagram producers.
Ken Youens-Clark [Thu, 24 Apr 2003 19:40:52 +0000]
Fixed bug (illegal div by 0) if "no_columns" wasn't numeric, also fixed
return of production if not writing to a file.
Ken Youens-Clark [Thu, 24 Apr 2003 16:36:49 +0000]
Adding new ER diagramming producer.
Ken Youens-Clark [Thu, 24 Apr 2003 16:33:23 +0000]
Moved most of the code into a new "Diagram" producer.
Ken Youens-Clark [Thu, 24 Apr 2003 16:15:58 +0000]
Cosmetic changes to keep the coding style consistent.
Ken Youens-Clark [Thu, 24 Apr 2003 16:15:13 +0000]
Adding new GraphViz producer.
Ken Youens-Clark [Thu, 24 Apr 2003 16:14:54 +0000]
Minor cosmetic changes.
Ken Youens-Clark [Thu, 24 Apr 2003 16:14:07 +0000]
Moved all the real code into a module so this script now just uses the new
GraphViz producer.
Allen Day [Sat, 19 Apr 2003 23:44:06 +0000]
cosmetic changes to autogenerated code.
Allen Day [Sat, 19 Apr 2003 23:32:34 +0000]
adding capability to give 'filename' constructor arg an arrayref.
Allen Day [Sat, 19 Apr 2003 22:58:12 +0000]
asdf
Ken Youens-Clark [Sat, 19 Apr 2003 01:32:27 +0000]
Fixed error for: "Use of uninitialized value in string eq at
/usr/local/apache/lib/perl/SQL/Translator/Producer/ClassDBI.pm line 98."
Also fixed some indentation problems in POD.
Allen Day [Fri, 18 Apr 2003 23:45:52 +0000]
adding ClassDBI producer.
Allen Day [Fri, 18 Apr 2003 20:43:05 +0000]
adding recognition of key type "key" for table indices.
Darren Chamberlain [Fri, 18 Apr 2003 14:25:58 +0000]
Forgot to add this yesterday.
Allen Day [Thu, 17 Apr 2003 23:16:29 +0000]
adding callbacks to Translator.pm to allow mangling of PK/FK/table names/package names (CDBI specific)
for producer classes.
Allen Day [Thu, 17 Apr 2003 19:42:33 +0000]
workaround to get auto_increment working from PG "serial" datatype. i didn't do this right, someone fix it :|
also added a fix to MySQL producer to not put () enclosed attributes if values don't exist. ie, don't put int() if there is
not a length defined for int.
Darren Chamberlain [Thu, 17 Apr 2003 13:42:48 +0000]
Attempt to be more robust.lib/SQL/Translator/Validator.pm
Darren Chamberlain [Thu, 17 Apr 2003 13:41:36 +0000]
Added normalize_name function, which normalizes names. Primarily needed by the Excel parser.
Darren Chamberlain [Thu, 17 Apr 2003 13:40:47 +0000]
Let's check before we assume this is a ref, eh?
Ken Youens-Clark [Mon, 14 Apr 2003 19:20:26 +0000]
Fixes to help with Oracle data types, also fixes with table constraints.
Ken Youens-Clark [Thu, 10 Apr 2003 22:53:11 +0000]
Added Oracle parser to MANIFEST.
Ken Youens-Clark [Thu, 10 Apr 2003 03:09:47 +0000]
Small fix.
Ken Youens-Clark [Thu, 10 Apr 2003 03:09:28 +0000]
Hey, new Oracle parser!
Darren Chamberlain [Tue, 8 Apr 2003 12:59:26 +0000]
Updated README to reflect changes to SQL/Translator.pm POD.
Darren Chamberlain [Tue, 8 Apr 2003 12:57:28 +0000]
Moving tests to Test::More
Darren Chamberlain [Tue, 8 Apr 2003 12:56:17 +0000]
Added Spreadsheet::ParseExcel
Darren Chamberlain [Tue, 8 Apr 2003 12:55:51 +0000]
Added missing stuff. Remember folks, anything not in MANIFEST will not be part of a distribution!
Darren Chamberlain [Tue, 8 Apr 2003 12:55:09 +0000]
Added stub test.
Darren Chamberlain [Mon, 7 Apr 2003 16:31:55 +0000]
And again, with the globals. Yeesh.
Darren Chamberlain [Mon, 7 Apr 2003 16:27:30 +0000]
Why make these globals?
Darren Chamberlain [Mon, 7 Apr 2003 16:18:15 +0000]
Hey, this could never have worked as advertised. *blush*.
Mikey Melillo [Mon, 7 Apr 2003 15:41:08 +0000]
added a text spreadsheet, hopefully in the right directory and such