20 years agoFixed EXE_FILES filenames, decided to removed CGI script.
Ken Youens-Clark [Mon, 16 Jun 2003 18:30:24 +0000]
Fixed EXE_FILES filenames, decided to removed CGI script.

20 years agoRemoved this file as it uses the Validator which has been removed.
Ken Youens-Clark [Mon, 16 Jun 2003 18:26:59 +0000]
Removed this file as it uses the Validator which has been removed.

20 years agoFixed script name in POD.
Ken Youens-Clark [Mon, 16 Jun 2003 18:25:59 +0000]
Fixed script name in POD.

20 years agoFixed script name in docs.
Ken Youens-Clark [Mon, 16 Jun 2003 18:25:36 +0000]
Fixed script name in docs.

20 years agoRenamed auto-viv.cgi to sql_translator.cgi
Ken Youens-Clark [Mon, 16 Jun 2003 18:24:21 +0000]
Renamed auto-viv.cgi to sql_translator.cgi

20 years agoRenamed auto-graph.pl to sqlt-graph.pl
Ken Youens-Clark [Mon, 16 Jun 2003 18:23:08 +0000]
Renamed auto-graph.pl to sqlt-graph.pl

20 years agoRenamed auto-dia.pl to sqlt-diagram.pl
Ken Youens-Clark [Mon, 16 Jun 2003 18:22:17 +0000]
Renamed auto-dia.pl to sqlt-diagram.pl

20 years agoRemoved Validator class as validation is now in the Schema object.
Ken Youens-Clark [Mon, 16 Jun 2003 18:17:59 +0000]
Removed Validator class as validation is now in the Schema object.

20 years agoRemoved some things that don't actually work.
Ken Youens-Clark [Mon, 16 Jun 2003 18:16:25 +0000]
Removed some things that don't actually work.

20 years agoChanged getting of version from main module, added exe file.
Ken Youens-Clark [Mon, 16 Jun 2003 18:15:42 +0000]
Changed getting of version from main module, added exe file.

20 years agoAltered POD description.
Ken Youens-Clark [Mon, 16 Jun 2003 18:13:59 +0000]
Altered POD description.

21 years agoUpped the version in anticipation of making a new release soon, removed
Ken Youens-Clark [Wed, 11 Jun 2003 04:34:11 +0000]
Upped the version in anticipation of making a new release soon, removed
some unused code, added a better quote, updated POD, expanded the AUTHORS
list to include all module contributors, expanded on SEE ALSO list.

21 years agoRemoved fixed bugs, either need to verify other bugs exist (and fix) or
Ken Youens-Clark [Wed, 11 Jun 2003 04:15:42 +0000]
Removed fixed bugs, either need to verify other bugs exist (and fix) or
remove.

21 years agoUpdated TODO.
Ken Youens-Clark [Wed, 11 Jun 2003 04:14:18 +0000]
Updated TODO.

21 years agoAdded HTML and POD producers.
Ken Youens-Clark [Wed, 11 Jun 2003 04:03:08 +0000]
Added HTML and POD producers.

21 years agoModified producers to quite looking for the data structure to be sent as
Ken Youens-Clark [Wed, 11 Jun 2003 04:00:44 +0000]
Modified producers to quite looking for the data structure to be sent as
an argument with the translator object.

21 years agoModified all filed to quit returning the data structure, now only return "1"
Ken Youens-Clark [Wed, 11 Jun 2003 03:59:49 +0000]
Modified all filed to quit returning the data structure, now only return "1"
to show success.

21 years agoAdded validation code.
Ken Youens-Clark [Wed, 11 Jun 2003 03:58:53 +0000]
Added validation code.

21 years agoThese tests relied on now deprecated action that the raw data structure
Ken Youens-Clark [Wed, 11 Jun 2003 03:58:09 +0000]
These tests relied on now deprecated action that the raw data structure
was returned by the parser.  The tests were updated to use the schema object.

21 years agoAdded "is_valid" tests.
Ken Youens-Clark [Wed, 11 Jun 2003 03:12:22 +0000]
Added "is_valid" tests.

21 years agoMostly cosmetic changes (Allen -- no tabs, indent = 4 spaces!), got rid of
Ken Youens-Clark [Tue, 10 Jun 2003 15:06:04 +0000]
Mostly cosmetic changes (Allen -- no tabs, indent = 4 spaces!), got rid of
a map called in void context.

21 years agoAdding new HTML producer.
Ken Youens-Clark [Tue, 10 Jun 2003 03:49:49 +0000]
Adding new HTML producer.

21 years agoMinor changes.
Ken Youens-Clark [Tue, 10 Jun 2003 03:49:35 +0000]
Minor changes.

21 years agomove over bacon
Allen Day [Mon, 9 Jun 2003 05:46:45 +0000]
move over bacon

21 years agoit was buggy
Allen Day [Mon, 9 Jun 2003 05:38:11 +0000]
it was buggy

21 years agoA POD producer.
Ken Youens-Clark [Mon, 9 Jun 2003 05:37:04 +0000]
A POD producer.

21 years agoChanged to use schema API.
Ken Youens-Clark [Mon, 9 Jun 2003 04:54:15 +0000]
Changed to use schema API.

21 years agoChanged to use schema, refactored duplicated code (also in GraphViz) up
Ken Youens-Clark [Mon, 9 Jun 2003 04:40:50 +0000]
Changed to use schema, refactored duplicated code (also in GraphViz) up
into Schema API.

21 years agoSome bug fixen.
Ken Youens-Clark [Mon, 9 Jun 2003 04:40:08 +0000]
Some bug fixen.

21 years agoAdded "make_natural_joins."
Ken Youens-Clark [Mon, 9 Jun 2003 04:18:23 +0000]
Added "make_natural_joins."

21 years agoAdded "is_unique" method to determine if a field has a UNIQUE index.
Ken Youens-Clark [Mon, 9 Jun 2003 04:11:57 +0000]
Added "is_unique" method to determine if a field has a UNIQUE index.

21 years agosupposedly hasa()is deprecated in favor of has_a().
Allen Day [Mon, 9 Jun 2003 03:38:38 +0000]
supposedly hasa()is deprecated in favor of has_a().

21 years agolinktable traversal seems to be working! haven't tried the code yet, but it looks...
Allen Day [Mon, 9 Jun 2003 03:20:16 +0000]
linktable traversal seems to be working!  haven't tried the code yet, but it looks good.

21 years agoAdded rule to catch a default value given just as "null."
Ken Youens-Clark [Mon, 9 Jun 2003 02:41:31 +0000]
Added rule to catch a default value given just as "null."

21 years agoRemoved debugging warning.
Ken Youens-Clark [Mon, 9 Jun 2003 02:19:41 +0000]
Removed debugging warning.

21 years agoMinor change to affect context.
Ken Youens-Clark [Mon, 9 Jun 2003 02:16:25 +0000]
Minor change to affect context.

21 years agoAdded "alter" to be able to parse output of Oracle producer, other small changes.
Ken Youens-Clark [Mon, 9 Jun 2003 02:16:02 +0000]
Added "alter" to be able to parse output of Oracle producer, other small changes.

21 years agoSmall changes to comments and size methods.
Ken Youens-Clark [Mon, 9 Jun 2003 02:10:59 +0000]
Small changes to comments and size methods.

21 years agoSmall change to comment.
Ken Youens-Clark [Mon, 9 Jun 2003 02:10:10 +0000]
Small change to comment.

21 years agoRemoved "Raw" producer.
Ken Youens-Clark [Mon, 9 Jun 2003 02:03:15 +0000]
Removed "Raw" producer.

21 years agoRemoving "Raw" producer as it's unnecessary now.
Ken Youens-Clark [Mon, 9 Jun 2003 02:02:48 +0000]
Removing "Raw" producer as it's unnecessary now.

21 years agoSome cosmetic changes, changed to use schema API.
Ken Youens-Clark [Mon, 9 Jun 2003 02:01:23 +0000]
Some cosmetic changes, changed to use schema API.

21 years agoExpanded "translate" hash, changed to use schema API.
Ken Youens-Clark [Mon, 9 Jun 2003 02:00:41 +0000]
Expanded "translate" hash, changed to use schema API.

21 years agoGeneral cleanup, changed to use schema API.
Ken Youens-Clark [Mon, 9 Jun 2003 02:00:01 +0000]
General cleanup, changed to use schema API.

21 years agoChanged to use schema API.
Ken Youens-Clark [Mon, 9 Jun 2003 01:59:21 +0000]
Changed to use schema API.

21 years agoCleaned up "translate" hash a bit, changed to use schema objects now,
Ken Youens-Clark [Mon, 9 Jun 2003 01:58:23 +0000]
Cleaned up "translate" hash a bit, changed to use schema objects now,
some changed to sub's to get rid of some warnings.

21 years agoChanged to use schema objects.
Ken Youens-Clark [Mon, 9 Jun 2003 01:56:51 +0000]
Changed to use schema objects.

21 years agoRemoved unnecessary backslash-escapes of single quotes, reformatted spacing
Ken Youens-Clark [Mon, 9 Jun 2003 01:55:12 +0000]
Removed unnecessary backslash-escapes of single quotes, reformatted spacing
to match the style of the rest of the modules, using the schema API now,
removed "Chado" line, tried to make the "hasa"/FK stuff work nicely.

21 years agoAdded Oracle parser test.
Ken Youens-Clark [Fri, 6 Jun 2003 22:52:46 +0000]
Added Oracle parser test.

21 years agoGeneral mods to make it like others.
Ken Youens-Clark [Fri, 6 Jun 2003 22:48:14 +0000]
General mods to make it like others.

21 years agoAdded "use strict;"
Ken Youens-Clark [Fri, 6 Jun 2003 22:47:25 +0000]
Added "use strict;"

21 years agoGeneral clean up to make it more like the others.
Ken Youens-Clark [Fri, 6 Jun 2003 22:46:27 +0000]
General clean up to make it more like the others.

21 years agoGeneral clean up to make it more like other tests.
Ken Youens-Clark [Fri, 6 Jun 2003 22:45:44 +0000]
General clean up to make it more like other tests.

21 years agoFixed test numbers.
Ken Youens-Clark [Fri, 6 Jun 2003 22:41:42 +0000]
Fixed test numbers.

21 years agoFixed test numbers, removed unnecessary code.
Ken Youens-Clark [Fri, 6 Jun 2003 22:39:32 +0000]
Fixed test numbers, removed unnecessary code.

21 years agoAdded sorting of tables, other cosmetic changes.
Ken Youens-Clark [Fri, 6 Jun 2003 22:37:25 +0000]
Added sorting of tables, other cosmetic changes.

21 years agoAdded comments method and parsing on init.
Ken Youens-Clark [Fri, 6 Jun 2003 22:36:09 +0000]
Added comments method and parsing on init.

21 years agoAdded parsing of comments on init, added "comments" method.
Ken Youens-Clark [Fri, 6 Jun 2003 22:35:44 +0000]
Added parsing of comments on init, added "comments" method.

21 years agoChanged constant to a hash to avoid silly Perl errors about it being
Ken Youens-Clark [Fri, 6 Jun 2003 22:35:16 +0000]
Changed constant to a hash to avoid silly Perl errors about it being
redefined; other minor changes.

21 years agoChanged constant to a hash to avoid silly Perl errors about it being
Ken Youens-Clark [Fri, 6 Jun 2003 22:34:46 +0000]
Changed constant to a hash to avoid silly Perl errors about it being
redefined.

21 years agoChanged "FULLTEXT."
Ken Youens-Clark [Fri, 6 Jun 2003 22:34:00 +0000]
Changed "FULLTEXT."

21 years agoRemoved Sybase parser because it's complete broken. When this works, we can
Ken Youens-Clark [Fri, 6 Jun 2003 22:32:39 +0000]
Removed Sybase parser because it's complete broken.  When this works, we can
add it back.

21 years agoCleaned up code (mostly cosmetic), added normalization of column name,
Ken Youens-Clark [Fri, 6 Jun 2003 22:31:56 +0000]
Cleaned up code (mostly cosmetic), added normalization of column name,
use Schema objects, added a good quote.

21 years agoQuit putting PK defs as indices, cosmetic changes to grammar, remove quotes
Ken Youens-Clark [Fri, 6 Jun 2003 22:30:44 +0000]
Quit putting PK defs as indices, cosmetic changes to grammar, remove quotes
around comment values, quit pushing field constraints to table level,
return "varchar2" instead of "varchar" (keep it native), fixes to grammar to
bring it up to work with Parse::RecDescent 1.94, use of Schema objects,
added a good quote.

21 years agoAdded a better quote; quit putting FKs at field level (only at table); fixed
Ken Youens-Clark [Fri, 6 Jun 2003 22:27:46 +0000]
Added a better quote; quit putting FKs at field level (only at table); fixed
bug with field sizes (extra level of arrayref); got rid of "binary data"
data type (I swear this used to be legal), now only calling it "bytea";
some cosmetic changes to the grammar;  added use of Schema objects.

21 years agoAdded new Oracle parser test.
Ken Youens-Clark [Fri, 6 Jun 2003 22:24:45 +0000]
Added new Oracle parser test.

21 years agoAdded a lot more tests, now using the Schema object.
Ken Youens-Clark [Fri, 6 Jun 2003 22:24:26 +0000]
Added a lot more tests, now using the Schema object.

21 years agoChanged $table->primary_key not to return an error if there is no PK,
Ken Youens-Clark [Fri, 6 Jun 2003 22:23:54 +0000]
Changed $table->primary_key not to return an error if there is no PK,
added tests for "comments" on tables and fields.

21 years agoNow that the PG parser is using the Schema object, a previously uncaught
Ken Youens-Clark [Fri, 6 Jun 2003 22:22:20 +0000]
Now that the PG parser is using the Schema object, a previously uncaught
bug surfaced in that an index was created on a table (cvterm_synonym) that
isn't defined in the SQL, so that creates a problem.  Commented out the
line.

21 years agoThe test schema actually had incorrect syntax, so I fixed that; changed
Ken Youens-Clark [Fri, 6 Jun 2003 22:21:00 +0000]
The test schema actually had incorrect syntax, so I fixed that;  changed
tests to use Schema object; added a lot more.

21 years agoChanged tests to use Schema objects instead of data structure, added more
Ken Youens-Clark [Fri, 6 Jun 2003 00:13:57 +0000]
Changed tests to use Schema objects instead of data structure, added more
thorough tests.

21 years agoAdded tests for $field->extra.
Ken Youens-Clark [Fri, 6 Jun 2003 00:13:16 +0000]
Added tests for $field->extra.

21 years agoChanged tests to use the Schema objects instead of looking at the data
Ken Youens-Clark [Fri, 6 Jun 2003 00:12:45 +0000]
Changed tests to use the Schema objects instead of looking at the data
structure, added many more thorough tests, added parsing some more
complicated SQL.

21 years agoFixed up some POD.
Ken Youens-Clark [Fri, 6 Jun 2003 00:11:06 +0000]
Fixed up some POD.

21 years agoMoved some code around, fixed some POD, added checking of existing
Ken Youens-Clark [Fri, 6 Jun 2003 00:10:32 +0000]
Moved some code around, fixed some POD, added checking of existing
constraints when adding new ones (to prevent dups).

21 years agoAdded parsing of default value on init, added "extra" method for misc field
Ken Youens-Clark [Fri, 6 Jun 2003 00:09:25 +0000]
Added parsing of default value on init, added "extra" method for misc field
info, added methods to determine if a field is a foreign key and to get
the FK constraint.

21 years agoMoved some code around to fix ordering, convert "type" to match what's
Ken Youens-Clark [Fri, 6 Jun 2003 00:08:14 +0000]
Moved some code around to fix ordering, convert "type" to match what's
considered valid.

21 years agoMoved some code around to get methods in alphabetical order.
Ken Youens-Clark [Fri, 6 Jun 2003 00:06:49 +0000]
Moved some code around to get methods in alphabetical order.

21 years agoFixed parsing of field size for float values.
Ken Youens-Clark [Fri, 6 Jun 2003 00:05:44 +0000]
Fixed parsing of field size for float values.

21 years agoChanges to grammar to clean up, moved primary key defs and unique keys
Ken Youens-Clark [Fri, 6 Jun 2003 00:05:09 +0000]
Changes to grammar to clean up, moved primary key defs and unique keys
in data structure from "indices" to "constraints" where they belong,
added code to fill out schema objects with data structure.

21 years agoAdded better options for accepting height and width, changed default node
Ken Youens-Clark [Thu, 5 Jun 2003 01:57:48 +0000]
Added better options for accepting height and width, changed default node
shape to "record," added option to show the fields of the table.

21 years agoAdded options for height, width, and showing field names.
Ken Youens-Clark [Thu, 5 Jun 2003 01:51:29 +0000]
Added options for height, width, and showing field names.

21 years agoAdded ability to manipulate height, width, and whether to show the field
Ken Youens-Clark [Thu, 5 Jun 2003 01:43:35 +0000]
Added ability to manipulate height, width, and whether to show the field
names for GraphViz output.

21 years agoAdded rules to catch common (but useless) statements.
Ken Youens-Clark [Wed, 4 Jun 2003 22:04:53 +0000]
Added rules to catch common (but useless) statements.

21 years agoAdded a few more tests.
Ken Youens-Clark [Wed, 4 Jun 2003 15:35:22 +0000]
Added a few more tests.

21 years agoMore work on default field sizes for numerics.
Ken Youens-Clark [Tue, 3 Jun 2003 22:42:10 +0000]
More work on default field sizes for numerics.

21 years agoAdded default field sizes for numeric fields if not specified, removed
Ken Youens-Clark [Tue, 3 Jun 2003 22:38:18 +0000]
Added default field sizes for numeric fields if not specified, removed
unused rules.

21 years agoFixed bug with initialization.
Ken Youens-Clark [Tue, 3 Jun 2003 22:37:42 +0000]
Fixed bug with initialization.

21 years agoAdded more tests.
Ken Youens-Clark [Tue, 3 Jun 2003 22:12:54 +0000]
Added more tests.

21 years agoChanged grammar to bring it more inline with the official MySQL YACC
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.

21 years agoadded width and height options for graphviz out. no docs
Allen Day [Mon, 26 May 2003 22:29:48 +0000]
added width and height options for graphviz out.  no docs

21 years agoSlightly more paranoid version of parse_list_arg -- check length as well as definedness.
Darren Chamberlain [Mon, 12 May 2003 15:47:23 +0000]
Slightly more paranoid version of parse_list_arg -- check length as well as definedness.

21 years agoTrim whitespace from arrayref elements as well as array elements; see <Pine.LNX.4...
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>.

21 years agoAddressed a few style issues to make it like the other producers (use
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.

21 years agoCosmetic change in POD.
Ken Youens-Clark [Mon, 12 May 2003 14:59:15 +0000]
Cosmetic change in POD.

21 years agoAdded Sybase producer to MANIFEST.
Ken Youens-Clark [Mon, 12 May 2003 14:50:50 +0000]
Added Sybase producer to MANIFEST.

21 years agoChange to avoid warning of "use of unitialized value."
Ken Youens-Clark [Mon, 12 May 2003 14:49:39 +0000]
Change to avoid warning of "use of unitialized value."

21 years agoSince "true" is the default for trimming and scanning fields for the xSV
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.

21 years agoadded Sybase producer
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

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.