21 years agosome fixes to fk method name generation. failed to add nice m-to-m mapping method b/c
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.

21 years agoDon't pass schema, let others call for it.
Ken Youens-Clark [Fri, 9 May 2003 19:51:28 +0000]
Don't pass schema, let others call for it.

21 years agoModified to call translator to get schema rather than passing.
Ken Youens-Clark [Fri, 9 May 2003 19:51:04 +0000]
Modified to call translator to get schema rather than passing.

21 years agoLots of changes to fix merge.
Ken Youens-Clark [Fri, 9 May 2003 17:15:30 +0000]
Lots of changes to fix merge.

21 years agoLots of changes to reflect library mods.
Ken Youens-Clark [Fri, 9 May 2003 17:12:46 +0000]
Lots of changes to reflect library mods.

21 years agoUse "parse_list_args," added "fields" method, changed validation, break
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.

21 years agoUse "parse_list_arg," put field order into field object, added "order"
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.

21 years agoUse "parse_list_args," added "options" (still vague on this), set a default
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.

21 years agoAdded use of "parse_list_arg," changed "nullable" method to "is_nullable"
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.

21 years agoPlaying with constants.
Ken Youens-Clark [Fri, 9 May 2003 17:06:46 +0000]
Playing with constants.

21 years agoAdded "match_type," use "parse_list_arg," added DESTROY.
Ken Youens-Clark [Fri, 9 May 2003 17:06:11 +0000]
Added "match_type," use "parse_list_arg," added DESTROY.

21 years agoRemoved warning.
Ken Youens-Clark [Fri, 9 May 2003 17:04:39 +0000]
Removed warning.

21 years agoAdded passing of schema arg.
Ken Youens-Clark [Fri, 9 May 2003 17:03:43 +0000]
Added passing of schema arg.

21 years agoPlaying around with new schema object.
Ken Youens-Clark [Fri, 9 May 2003 16:55:07 +0000]
Playing around with new schema object.

21 years agoAdded oft-used "parse_list_arg" sub for Schema classes.
Ken Youens-Clark [Fri, 9 May 2003 16:54:03 +0000]
Added oft-used "parse_list_arg" sub for Schema classes.

21 years agoMade "order" a property of the table and view objects, use a Schwatzian
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.

21 years agoPassing schema object now as third argument.
Ken Youens-Clark [Fri, 9 May 2003 16:51:47 +0000]
Passing schema object now as third argument.

21 years ago*** empty log message ***
Ken Youens-Clark [Fri, 9 May 2003 16:49:41 +0000]
*** empty log message ***

21 years agoMinor fixes to primary_key method.
Ken Youens-Clark [Wed, 7 May 2003 20:42:34 +0000]
Minor fixes to primary_key method.

21 years agoAdded Text::RecordParser 0.02 pre-req.
Ken Youens-Clark [Wed, 7 May 2003 20:39:23 +0000]
Added Text::RecordParser 0.02 pre-req.

21 years agoUpdated tests to match new code.
Ken Youens-Clark [Wed, 7 May 2003 20:37:33 +0000]
Updated tests to match new code.

21 years agoUpdated to use Text::RecordParser and added scanning of fields, more
Ken Youens-Clark [Wed, 7 May 2003 20:36:59 +0000]
Updated to use Text::RecordParser and added scanning of fields, more
functionality.

21 years agoAdded mods to pass parser_args for xSV parser.
Ken Youens-Clark [Wed, 7 May 2003 20:36:15 +0000]
Added mods to pass parser_args for xSV parser.

21 years agoUpdated README via perldoc -t lib/SQL/Translator.pm
Darren Chamberlain [Tue, 6 May 2003 12:47:54 +0000]
Updated README via perldoc -t lib/SQL/Translator.pm

21 years agoUses XML::Writer instead of aggregate() and a global.
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).

21 years agoUpdated XML test.
Darren Chamberlain [Tue, 6 May 2003 12:45:49 +0000]
Updated XML test.

21 years agoDoc changes (use C<> instead of B<>)
Darren Chamberlain [Tue, 6 May 2003 12:44:54 +0000]
Doc changes (use C<> instead of B<>)

21 years agoAdded Schema and some more dependencies
Darren Chamberlain [Tue, 6 May 2003 12:44:10 +0000]
Added Schema and some more dependencies

21 years agoMore changes to keep up with code.
Ken Youens-Clark [Mon, 5 May 2003 04:33:49 +0000]
More changes to keep up with code.

21 years agoToo many changes.
Ken Youens-Clark [Mon, 5 May 2003 04:33:22 +0000]
Too many changes.

21 years agoToo many changes to mention.
Ken Youens-Clark [Mon, 5 May 2003 04:32:39 +0000]
Too many changes to mention.

21 years agoFixed error 'Use of uninitialized value in pattern match (m//) at blib/lib/SQL/Transl...
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.'

21 years agoChanged to use Test::More, cleaned up syntax. Still pretty useless.
Ken Youens-Clark [Sat, 3 May 2003 15:40:51 +0000]
Changed to use Test::More, cleaned up syntax.  Still pretty useless.

21 years ago"size" of a field needs to be an arrayref as it could be two numbers (e.g.,
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").

21 years agoFixed error 'Use of uninitialized value in repeat (x) at blib/lib/SQL/Translator...
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.'

21 years agoFixed error 'Use of uninitialized value in string eq at blib/lib/SQL/Translator/Produ...
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.'

21 years agoFixed error '"my" variable $wb_count masks earlier declaration in same scope at blib...
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.'

21 years agoFor some reason, "t.pl" was still in there.
Ken Youens-Clark [Sat, 3 May 2003 15:11:44 +0000]
For some reason, "t.pl" was still in there.

21 years agoFixed an error in default value regex that disallowed a value like "00:18:00".
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".

21 years agoAdded the requirement of Parse::RecDescent 1.94 or later, added
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.

21 years agoAdding a new PG parser test.
Ken Youens-Clark [Sat, 3 May 2003 04:12:00 +0000]
Adding a new PG parser test.

21 years agoTrying to add tests as I write methods, so lots of new stuff to mirror
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.

21 years agoUsing some of the rules from the PG grammar to make mine better, cleaned
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.

21 years agoNot much to say ... just trying to get this working.
Ken Youens-Clark [Sat, 3 May 2003 04:07:38 +0000]
Not much to say ... just trying to get this working.

21 years agoMore changes to getting the schema to a working state.
Ken Youens-Clark [Sat, 3 May 2003 04:07:09 +0000]
More changes to getting the schema to a working state.

21 years agoAdding new objects for handing schema data. Not being used while I work
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.

21 years agoAdding new schema test, commiting fixes to MySQL parser test.
Ken Youens-Clark [Thu, 1 May 2003 04:23:11 +0000]
Adding new schema test, commiting fixes to MySQL parser test.

21 years agoFixed error that was preventing MySQL parser from working with
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!

21 years agolow hanging fruit, please read the diff below
Allen Day [Fri, 25 Apr 2003 23:08:01 +0000]
low hanging fruit, please read the diff below

21 years agoTest file for header_comment function from SQL::Translator::Utils.
Darren Chamberlain [Fri, 25 Apr 2003 11:48:12 +0000]
Test file for header_comment function from SQL::Translator::Utils.

21 years agoAdded refactored comment producing using header_comment.
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.

21 years agoAdded header_comment function; see docs for details.
Darren Chamberlain [Fri, 25 Apr 2003 11:44:20 +0000]
Added header_comment function; see docs for details.

21 years agoadding a pg src file example
Allen Day [Thu, 24 Apr 2003 22:15:28 +0000]
adding a pg src file example

21 years agoadding graphviz dep
Allen Day [Thu, 24 Apr 2003 22:03:52 +0000]
adding graphviz dep

21 years agoAdded new files.
Ken Youens-Clark [Thu, 24 Apr 2003 21:40:12 +0000]
Added new files.

21 years agoAdded defaults to arguments.
Ken Youens-Clark [Thu, 24 Apr 2003 20:02:31 +0000]
Added defaults to arguments.

21 years agoAdding new CGI script front-end for GraphViz and Diagram producers.
Ken Youens-Clark [Thu, 24 Apr 2003 19:58:39 +0000]
Adding new CGI script front-end for GraphViz and Diagram producers.

21 years agoFixed bug (illegal div by 0) if "no_columns" wasn't numeric, also fixed
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.

21 years agoAdding new ER diagramming producer.
Ken Youens-Clark [Thu, 24 Apr 2003 16:36:49 +0000]
Adding new ER diagramming producer.

21 years agoMoved most of the code into a new "Diagram" producer.
Ken Youens-Clark [Thu, 24 Apr 2003 16:33:23 +0000]
Moved most of the code into a new "Diagram" producer.

21 years agoCosmetic changes to keep the coding style consistent.
Ken Youens-Clark [Thu, 24 Apr 2003 16:15:58 +0000]
Cosmetic changes to keep the coding style consistent.

21 years agoAdding new GraphViz producer.
Ken Youens-Clark [Thu, 24 Apr 2003 16:15:13 +0000]
Adding new GraphViz producer.

21 years agoMinor cosmetic changes.
Ken Youens-Clark [Thu, 24 Apr 2003 16:14:54 +0000]
Minor cosmetic changes.

21 years agoMoved all the real code into a module so this script now just uses the new
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.

21 years agocosmetic changes to autogenerated code.
Allen Day [Sat, 19 Apr 2003 23:44:06 +0000]
cosmetic changes to autogenerated code.

21 years agoadding capability to give 'filename' constructor arg an arrayref.
Allen Day [Sat, 19 Apr 2003 23:32:34 +0000]
adding capability to give 'filename' constructor arg an arrayref.

21 years agoasdf
Allen Day [Sat, 19 Apr 2003 22:58:12 +0000]
asdf

21 years agoFixed error for: "Use of uninitialized value in string eq at
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.

21 years agoadding ClassDBI producer.
Allen Day [Fri, 18 Apr 2003 23:45:52 +0000]
adding ClassDBI producer.

21 years agoadding recognition of key type "key" for table indices.
Allen Day [Fri, 18 Apr 2003 20:43:05 +0000]
adding recognition of key type "key" for table indices.

21 years agoForgot to add this yesterday.
Darren Chamberlain [Fri, 18 Apr 2003 14:25:58 +0000]
Forgot to add this yesterday.

21 years agoadding callbacks to Translator.pm to allow mangling of PK/FK/table names/package...
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.

21 years agoworkaround to get auto_increment working from PG "serial" datatype. i didn't do...
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.

21 years agoAttempt to be more robust.lib/SQL/Translator/Validator.pm
Darren Chamberlain [Thu, 17 Apr 2003 13:42:48 +0000]
Attempt to be more robust.lib/SQL/Translator/Validator.pm

21 years agoAdded normalize_name function, which normalizes names. Primarily needed by the Excel...
Darren Chamberlain [Thu, 17 Apr 2003 13:41:36 +0000]
Added normalize_name function, which normalizes names.  Primarily needed by the Excel parser.

21 years agoLet's check before we assume this is a ref, eh?
Darren Chamberlain [Thu, 17 Apr 2003 13:40:47 +0000]
Let's check before we assume this is a ref, eh?

21 years agoFixes to help with Oracle data types, also fixes with table constraints.
Ken Youens-Clark [Mon, 14 Apr 2003 19:20:26 +0000]
Fixes to help with Oracle data types, also fixes with table constraints.

21 years agoAdded Oracle parser to MANIFEST.
Ken Youens-Clark [Thu, 10 Apr 2003 22:53:11 +0000]
Added Oracle parser to MANIFEST.

21 years agoSmall fix.
Ken Youens-Clark [Thu, 10 Apr 2003 03:09:47 +0000]
Small fix.

21 years agoHey, new Oracle parser!
Ken Youens-Clark [Thu, 10 Apr 2003 03:09:28 +0000]
Hey, new Oracle parser!

21 years agoUpdated README to reflect changes to SQL/Translator.pm POD.
Darren Chamberlain [Tue, 8 Apr 2003 12:59:26 +0000]
Updated README to reflect changes to SQL/Translator.pm POD.

21 years agoMoving tests to Test::More
Darren Chamberlain [Tue, 8 Apr 2003 12:57:28 +0000]
Moving tests to Test::More

21 years agoAdded Spreadsheet::ParseExcel
Darren Chamberlain [Tue, 8 Apr 2003 12:56:17 +0000]
Added Spreadsheet::ParseExcel

21 years agoAdded missing stuff. Remember folks, anything not in MANIFEST will not be part of...
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!

21 years agoAdded stub test.
Darren Chamberlain [Tue, 8 Apr 2003 12:55:09 +0000]
Added stub test.

21 years agoAnd again, with the globals. Yeesh.
Darren Chamberlain [Mon, 7 Apr 2003 16:31:55 +0000]
And again, with the globals. Yeesh.

21 years agoWhy make these globals?
Darren Chamberlain [Mon, 7 Apr 2003 16:27:30 +0000]
Why make these globals?

21 years agoHey, this could never have worked as advertised. *blush*.
Darren Chamberlain [Mon, 7 Apr 2003 16:18:15 +0000]
Hey, this could never have worked as advertised. *blush*.

21 years agoadded a text spreadsheet, hopefully in the right directory and such
Mikey Melillo [Mon, 7 Apr 2003 15:41:08 +0000]
added a text spreadsheet, hopefully in the right directory and such

21 years agoSome syntax fixes, package name was wrong, added Mikey's name to AUTHORS.
Ken Youens-Clark [Sun, 6 Apr 2003 19:08:49 +0000]
Some syntax fixes, package name was wrong, added Mikey's name to AUTHORS.
This parser is still broken.  The data structure I see coming back from
Spreadsheet::ParseExcel is not the same that is being examined by the code.

21 years agoInit Check in. This follows closely along the lines of xSV.pm but its cooler
Mikey Melillo [Sun, 6 Apr 2003 14:29:52 +0000]
Init Check in. This follows closely along the lines of xSV.pm but its cooler
because I used map. Hsan't been tested yet becuase I won't have access to
suitable testing area til monday. Oh BTW, the map doesn't work syntactially.
Someone want to tell me whats wrong with that line?

21 years agoAdding "auto-graph.pl" to automatically create graphs (via GraphViz) from
Ken Youens-Clark [Thu, 3 Apr 2003 19:30:48 +0000]
Adding "auto-graph.pl" to automatically create graphs (via GraphViz) from
schema definitions.

21 years agoShortened "natural-join-fk-only" option to "natural-join-fk,"
Ken Youens-Clark [Thu, 3 Apr 2003 19:29:08 +0000]
Shortened "natural-join-fk-only" option to "natural-join-fk,"
accepting args to "image-type" now, added wider left margin (+10
pixels), added pre-processing of fields to find if the ones that acts
as FKs in other tables in order to support the "show-fk-only" option,
added debug option and warn statements to aid coding, added ability to
make connecting lines directed when established with proper FOREIGN
KEY/REFERENCES statements, added some colors.

21 years agoAdded grammar for "REFERENCES" (foreign keys).
Ken Youens-Clark [Wed, 2 Apr 2003 01:46:36 +0000]
Added grammar for "REFERENCES" (foreign keys).

21 years agoGot foreign key references basically working now.
Ken Youens-Clark [Wed, 2 Apr 2003 01:46:16 +0000]
Got foreign key references basically working now.

21 years agoAdded options for natual joins only, made code work with proper FK
Ken Youens-Clark [Wed, 2 Apr 2003 01:45:45 +0000]
Added options for natual joins only, made code work with proper FK
references.

21 years agoAdded color option.
Ken Youens-Clark [Tue, 1 Apr 2003 18:08:02 +0000]
Added color option.

21 years agoAdded mark for unique constraint and legend to explain extra markings.
Ken Youens-Clark [Tue, 1 Apr 2003 17:06:22 +0000]
Added mark for unique constraint and legend to explain extra markings.

21 years agoAdded font options, made default font size 'small' instead of 'tiny.'
Ken Youens-Clark [Tue, 1 Apr 2003 16:43:34 +0000]
Added font options, made default font size 'small' instead of 'tiny.'

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