21 years agoApplying (spirit of) patch from RT making keyword "table" optional in
Ken Youens-Clark [Mon, 4 Aug 2003 15:16:13 +0000]
Applying (spirit of) patch from RT making keyword "table" optional in
GRANT and REVOKE commands.

21 years agoOops, haven't added these yet.
Darren Chamberlain [Thu, 31 Jul 2003 20:51:34 +0000]
Oops, haven't added these yet.

21 years ago.cvsignore
Darren Chamberlain [Thu, 31 Jul 2003 20:49:42 +0000]
.cvsignore

21 years agoSome simple cleanups.
Darren Chamberlain [Thu, 31 Jul 2003 20:48:23 +0000]
Some simple cleanups.

21 years agoAdded "character set" as field qualifier as this is part of MySQL 4 output.
Ken Youens-Clark [Fri, 25 Jul 2003 21:50:49 +0000]
Added "character set" as field qualifier as this is part of MySQL 4 output.

21 years agoAdded options for specifying image map.
Ken Youens-Clark [Fri, 18 Jul 2003 22:56:41 +0000]
Added options for specifying image map.

21 years agoAllow embedded comments a la the PG parser, store the comments; also strip
Ken Youens-Clark [Fri, 18 Jul 2003 22:56:12 +0000]
Allow embedded comments a la the PG parser, store the comments; also strip
comments of comments chars and trailing whitespace.

21 years agoPrint out field comments using Oracle "comment on field" syntax.
Ken Youens-Clark [Fri, 18 Jul 2003 22:55:18 +0000]
Print out field comments using Oracle "comment on field" syntax.

21 years agoAdded a "table" section at the top to click right to a particular table.
Ken Youens-Clark [Fri, 18 Jul 2003 22:54:41 +0000]
Added a "table" section at the top to click right to a particular table.

21 years agoAdded options to make an image map.
Ken Youens-Clark [Fri, 18 Jul 2003 22:54:17 +0000]
Added options to make an image map.

21 years agoMade "pg_data_type" rules case-insensitive per a patch from Richard
Ken Youens-Clark [Fri, 11 Jul 2003 15:22:45 +0000]
Made "pg_data_type" rules case-insensitive per a patch from Richard
Clamp <richardc@unixbeard.net>.

21 years agoaliasing ugly tablename_fieldname ref methods where possible (ie create them
Allen Day [Wed, 9 Jul 2003 17:48:12 +0000]
aliasing ugly tablename_fieldname ref methods where possible (ie create them
for 1-M relationships between tables where the M end table does not allow a
M-1 traversal to another table, thus giving a M-M relationship)

21 years agocommenting shortcoming
Allen Day [Wed, 9 Jul 2003 06:09:56 +0000]
commenting shortcoming

21 years agohad to fix up the format_pk_method (somehow it got broken, hmm...).
Allen Day [Wed, 9 Jul 2003 05:59:24 +0000]
had to fix up the format_pk_method (somehow it got broken, hmm...).

also, i do (or almost do) have linktable autodetection working again.
i also began to add conditions that handle link tables which import FKs
multiple times from a single table.  this is not yet bug free.  will post
to list what i'm talking about here...

21 years agoStrip field size qualifiers from index fields as SQLite doesn't like.
Ken Youens-Clark [Wed, 2 Jul 2003 18:18:44 +0000]
Strip field size qualifiers from index fields as SQLite doesn't like.

21 years agoFixed VERSION to be CPAN-friendly.
Ken Youens-Clark [Fri, 27 Jun 2003 16:47:40 +0000]
Fixed VERSION to be CPAN-friendly.

21 years agoFixed VERSION.
Ken Youens-Clark [Fri, 27 Jun 2003 16:30:35 +0000]
Fixed VERSION.

21 years agoReversed earlier change to VERSION after Darren scolded me.
Ken Youens-Clark [Fri, 27 Jun 2003 16:28:21 +0000]
Reversed earlier change to VERSION after Darren scolded me.

21 years agoEfforts to re-enable Allen's many-to-many linktable code. I have no idea
Ken Youens-Clark [Fri, 27 Jun 2003 02:59:25 +0000]
Efforts to re-enable Allen's many-to-many linktable code.  I have no idea
if it works properly!

21 years agoI've tried to address Allen's concerns about naming of FKs, but still haven't
Ken Youens-Clark [Fri, 27 Jun 2003 02:28:11 +0000]
I've tried to address Allen's concerns about naming of FKs, but still haven't
touched the "linktable" code yet.

21 years agoMinor change.
Ken Youens-Clark [Fri, 27 Jun 2003 01:58:44 +0000]
Minor change.

21 years agoAdded "use Class::Base;" declaration to go with use base statement.
Darren Chamberlain [Thu, 26 Jun 2003 14:29:47 +0000]
Added "use Class::Base;" declaration to go with use base statement.

21 years agoRemoved redeclaration of "$parser_type," fixed bug in DSN, removed "s" on
Ken Youens-Clark [Wed, 25 Jun 2003 19:47:10 +0000]
Removed redeclaration of "$parser_type," fixed bug in DSN, removed "s" on
"has_many" field name.

21 years agoAdded "()" to character class of "default_val" rule to allow "now()" to
Ken Youens-Clark [Wed, 25 Jun 2003 19:25:38 +0000]
Added "()" to character class of "default_val" rule to allow "now()" to
be accepted.

21 years agoFixed a bug-fix of mine that was contingent on my checking in another module.
Ken Youens-Clark [Wed, 25 Jun 2003 19:17:06 +0000]
Fixed a bug-fix of mine that was contingent on my checking in another module.

21 years agoAttempting clean up something.
Ken Youens-Clark [Wed, 25 Jun 2003 19:15:19 +0000]
Attempting clean up something.

21 years agofixes for base DBI package setting db vendor based on $translator->parser_type().
Allen Day [Wed, 25 Jun 2003 19:10:17 +0000]
fixes for base DBI package setting db vendor based on $translator->parser_type().

added 's' for has_many() autogen relationships

repaired format_pk_name() weirdness that was being caused by ken's introduced bug

21 years agoAllow translation from parsers other than MySQL, Pg, and Oracle and just
Ken Youens-Clark [Wed, 25 Jun 2003 18:47:45 +0000]
Allow translation from parsers other than MySQL, Pg, and Oracle and just
set up table more manually than using the "set_up_table" method; no reason
to accept "$data" at beginning as it's not being sent anymore; no
longer using "$USER" or "$PASS" as they were only used once; removed
Class::DBI::Join as Michael Schwern (the module maintainer and Author
Emeritus of Class::DBI) says that Class::DBI handles this fine now
that this extra module will be leaving CPAN soon;  only create PK
accessor method if a callback was installed for it;  use
"$table->primary_key" to get PK rather than running through the
constraints to find it;  delay creation of output for each table until
after we've gone through everything so we can better set up the
"has_a" and "has_many" relationships;  intuit "has_many" as the
reverse of "has_a";  cleaned up "link tables" section, but commented
out as I'm not sure if my addition of "has_many" code might not do the
same thing.

21 years agoadding strict and quotes for barewords
Allen Day [Wed, 25 Jun 2003 02:04:33 +0000]
adding strict and quotes for barewords

21 years agoAdded more description; allow options for db user/pass/dsn, skipping certain
Ken Youens-Clark [Tue, 24 Jun 2003 21:00:24 +0000]
Added more description; allow options for db user/pass/dsn, skipping certain
tables; better handling of script args; added header comment to generated
script; also added use of Getopt::Long so it can accept "skip," "truncate,"
and "help" args (and be a real, grown-up script on its own).

21 years agoChanged "hasa" to "has_a."
Ken Youens-Clark [Tue, 24 Jun 2003 03:50:43 +0000]
Changed "hasa" to "has_a."

21 years agoAdding dumper creator.
Ken Youens-Clark [Tue, 24 Jun 2003 03:24:02 +0000]
Adding dumper creator.

21 years agoAllow data types which haven't been listed in translation table to pass
Ken Youens-Clark [Mon, 23 Jun 2003 21:47:30 +0000]
Allow data types which haven't been listed in translation table to pass
through unchanged.

21 years agoFixed grammar for REVOKE and GRANT (missing word "table").
Ken Youens-Clark [Mon, 23 Jun 2003 21:44:32 +0000]
Fixed grammar for REVOKE and GRANT (missing word "table").

21 years agofk references in many-to-many mappings need to refer to table column names
Allen Day [Thu, 19 Jun 2003 23:29:07 +0000]
fk references in many-to-many mappings need to refer to table column names
explicitly, rather than aliases to those column names in the class::dbi
layer.

-allen

21 years agoThe $DEFAULT_SUB was still looking at $_[1], and not $_[0]->schema
Darren Chamberlain [Thu, 19 Jun 2003 20:44:26 +0000]
The $DEFAULT_SUB was still looking at $_[1], and not $_[0]->schema

21 years agoAdded single quotes around the "use base 'foo';" line.
Ken Youens-Clark [Thu, 19 Jun 2003 01:18:07 +0000]
Added single quotes around the "use base 'foo';" line.

21 years agoFixed VERSION.
Ken Youens-Clark [Wed, 18 Jun 2003 23:15:11 +0000]
Fixed VERSION.

21 years agoFixed VERSION string.
Ken Youens-Clark [Wed, 18 Jun 2003 23:14:31 +0000]
Fixed VERSION string.

21 years agoFixed VERSION strings.
Ken Youens-Clark [Wed, 18 Jun 2003 23:14:00 +0000]
Fixed VERSION strings.

21 years agoAdded more TODO items.
Ken Youens-Clark [Wed, 18 Jun 2003 21:50:30 +0000]
Added more TODO items.

21 years agoThe grammar bothered me. v0.02
Ken Youens-Clark [Wed, 18 Jun 2003 17:16:25 +0000]
The grammar bothered me.

21 years agoTrying to get everything "on message."
Ken Youens-Clark [Wed, 18 Jun 2003 17:15:38 +0000]
Trying to get everything "on message."

21 years agoCleaning up the project description.
Ken Youens-Clark [Wed, 18 Jun 2003 16:32:56 +0000]
Cleaning up the project description.

21 years agoAdded SEE ALSO to send people to SF site.
Ken Youens-Clark [Tue, 17 Jun 2003 20:16:25 +0000]
Added SEE ALSO to send people to SF site.

21 years agoDecided against using cvs2cl.pl as it's way too verbose, using a simpler
Ken Youens-Clark [Tue, 17 Jun 2003 20:10:29 +0000]
Decided against using cvs2cl.pl as it's way too verbose, using a simpler
summary of the main changes b/w versions.

21 years agoInitial import of Jason Williams' SQL Fairy logo.
Darren Chamberlain [Tue, 17 Jun 2003 17:36:08 +0000]
Initial import of Jason Williams' SQL Fairy logo.

21 years agoUpdated README.
Ken Youens-Clark [Tue, 17 Jun 2003 16:29:59 +0000]
Updated README.

21 years agoNothing really changed.
Ken Youens-Clark [Tue, 17 Jun 2003 03:03:10 +0000]
Nothing really changed.

21 years agoAdded INSERT and UPDATE placeholders to get parser to not barf on those.
Ken Youens-Clark [Tue, 17 Jun 2003 02:12:23 +0000]
Added INSERT and UPDATE placeholders to get parser to not barf on those.

21 years agoFixed MANIFEST to match change in filename.
Ken Youens-Clark [Mon, 16 Jun 2003 22:08:00 +0000]
Fixed MANIFEST to match change in filename.

21 years agoRenamed 09auto-dia.t to 09sqlt-diagram.t to match the move in script filenames
Ken Youens-Clark [Mon, 16 Jun 2003 22:06:41 +0000]
Renamed 09auto-dia.t to 09sqlt-diagram.t to match the move in script filenames

21 years agoRegenerated Chagnes using cvs2cl.pl
Ken Youens-Clark [Mon, 16 Jun 2003 22:02:20 +0000]
Regenerated Chagnes using cvs2cl.pl

21 years agoCreated a more generic README for the project.
Ken Youens-Clark [Mon, 16 Jun 2003 22:01:38 +0000]
Created a more generic README for the project.

21 years agoI was going to move the "format_*_name" methods to the ClassDBI producer,
Ken Youens-Clark [Mon, 16 Jun 2003 20:58:10 +0000]
I was going to move the "format_*_name" methods to the ClassDBI producer,
but I just couldn't see the best way to do it.  Besides, I can't necessarily
decide what I don't like about them being in this class.  Is there any way
any other producer could/would ever use them?  Also made aesthetic changes
to POD.

21 years agoAll the copyright notices say how the user should have received a copy of
Ken Youens-Clark [Mon, 16 Jun 2003 18:56:06 +0000]
All the copyright notices say how the user should have received a copy of
the license, but we never make the effort to include it, so I have.

21 years agoAdded LICENSE.
Ken Youens-Clark [Mon, 16 Jun 2003 18:55:32 +0000]
Added LICENSE.

21 years agoAdded some ideas for 0.03.
Ken Youens-Clark [Mon, 16 Jun 2003 18:45:51 +0000]
Added some ideas for 0.03.

21 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.

21 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.

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

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

21 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

21 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

21 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

21 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.

21 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.

21 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.

21 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.