Darren Chamberlain [Thu, 31 Jul 2003 20:49:42 +0000]
.cvsignore
Darren Chamberlain [Thu, 31 Jul 2003 20:48:23 +0000]
Some simple cleanups.
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.
Ken Youens-Clark [Fri, 18 Jul 2003 22:56:41 +0000]
Added options for specifying image map.
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.
Ken Youens-Clark [Fri, 18 Jul 2003 22:55:18 +0000]
Print out field comments using Oracle "comment on field" syntax.
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.
Ken Youens-Clark [Fri, 18 Jul 2003 22:54:17 +0000]
Added options to make an image map.
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>.
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)
Allen Day [Wed, 9 Jul 2003 06:09:56 +0000]
commenting shortcoming
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...
Ken Youens-Clark [Wed, 2 Jul 2003 18:18:44 +0000]
Strip field size qualifiers from index fields as SQLite doesn't like.
Ken Youens-Clark [Fri, 27 Jun 2003 16:47:40 +0000]
Fixed VERSION to be CPAN-friendly.
Ken Youens-Clark [Fri, 27 Jun 2003 16:30:35 +0000]
Fixed VERSION.
Ken Youens-Clark [Fri, 27 Jun 2003 16:28:21 +0000]
Reversed earlier change to VERSION after Darren scolded me.
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!
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.
Ken Youens-Clark [Fri, 27 Jun 2003 01:58:44 +0000]
Minor change.
Darren Chamberlain [Thu, 26 Jun 2003 14:29:47 +0000]
Added "use Class::Base;" declaration to go with use base statement.
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.
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.
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.
Ken Youens-Clark [Wed, 25 Jun 2003 19:15:19 +0000]
Attempting clean up something.
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
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.
Allen Day [Wed, 25 Jun 2003 02:04:33 +0000]
adding strict and quotes for barewords
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).
Ken Youens-Clark [Tue, 24 Jun 2003 03:50:43 +0000]
Changed "hasa" to "has_a."
Ken Youens-Clark [Tue, 24 Jun 2003 03:24:02 +0000]
Adding dumper creator.
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.
Ken Youens-Clark [Mon, 23 Jun 2003 21:44:32 +0000]
Fixed grammar for REVOKE and GRANT (missing word "table").
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
Darren Chamberlain [Thu, 19 Jun 2003 20:44:26 +0000]
The $DEFAULT_SUB was still looking at $_[1], and not $_[0]->schema
Ken Youens-Clark [Thu, 19 Jun 2003 01:18:07 +0000]
Added single quotes around the "use base 'foo';" line.
Ken Youens-Clark [Wed, 18 Jun 2003 23:15:11 +0000]
Fixed VERSION.
Ken Youens-Clark [Wed, 18 Jun 2003 23:14:31 +0000]
Fixed VERSION string.
Ken Youens-Clark [Wed, 18 Jun 2003 23:14:00 +0000]
Fixed VERSION strings.
Ken Youens-Clark [Wed, 18 Jun 2003 21:50:30 +0000]
Added more TODO items.
Ken Youens-Clark [Wed, 18 Jun 2003 17:16:25 +0000]
The grammar bothered me.
Ken Youens-Clark [Wed, 18 Jun 2003 17:15:38 +0000]
Trying to get everything "on message."
Ken Youens-Clark [Wed, 18 Jun 2003 16:32:56 +0000]
Cleaning up the project description.
Ken Youens-Clark [Tue, 17 Jun 2003 20:16:25 +0000]
Added SEE ALSO to send people to SF site.
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.
Darren Chamberlain [Tue, 17 Jun 2003 17:36:08 +0000]
Initial import of Jason Williams' SQL Fairy logo.
Ken Youens-Clark [Tue, 17 Jun 2003 16:29:59 +0000]
Updated README.
Ken Youens-Clark [Tue, 17 Jun 2003 03:03:10 +0000]
Nothing really changed.
Ken Youens-Clark [Tue, 17 Jun 2003 02:12:23 +0000]
Added INSERT and UPDATE placeholders to get parser to not barf on those.
Ken Youens-Clark [Mon, 16 Jun 2003 22:08:00 +0000]
Fixed MANIFEST to match change in filename.
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
Ken Youens-Clark [Mon, 16 Jun 2003 22:02:20 +0000]
Regenerated Chagnes using cvs2cl.pl
Ken Youens-Clark [Mon, 16 Jun 2003 22:01:38 +0000]
Created a more generic README for the project.
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.
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.
Ken Youens-Clark [Mon, 16 Jun 2003 18:55:32 +0000]
Added LICENSE.
Ken Youens-Clark [Mon, 16 Jun 2003 18:45:51 +0000]
Added some ideas for 0.03.
Ken Youens-Clark [Mon, 16 Jun 2003 18:30:24 +0000]
Fixed EXE_FILES filenames, decided to removed CGI script.
Ken Youens-Clark [Mon, 16 Jun 2003 18:26:59 +0000]
Removed this file as it uses the Validator which has been removed.
Ken Youens-Clark [Mon, 16 Jun 2003 18:25:59 +0000]
Fixed script name in POD.
Ken Youens-Clark [Mon, 16 Jun 2003 18:25:36 +0000]
Fixed script name in docs.
Ken Youens-Clark [Mon, 16 Jun 2003 18:24:21 +0000]
Renamed auto-viv.cgi to sql_translator.cgi
Ken Youens-Clark [Mon, 16 Jun 2003 18:23:08 +0000]
Renamed auto-graph.pl to sqlt-graph.pl
Ken Youens-Clark [Mon, 16 Jun 2003 18:22:17 +0000]
Renamed auto-dia.pl to sqlt-diagram.pl
Ken Youens-Clark [Mon, 16 Jun 2003 18:17:59 +0000]
Removed Validator class as validation is now in the Schema object.
Ken Youens-Clark [Mon, 16 Jun 2003 18:16:25 +0000]
Removed some things that don't actually work.
Ken Youens-Clark [Mon, 16 Jun 2003 18:15:42 +0000]
Changed getting of version from main module, added exe file.
Ken Youens-Clark [Mon, 16 Jun 2003 18:13:59 +0000]
Altered POD description.
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.
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.
Ken Youens-Clark [Wed, 11 Jun 2003 04:14:18 +0000]
Updated TODO.
Ken Youens-Clark [Wed, 11 Jun 2003 04:03:08 +0000]
Added HTML and POD producers.
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.
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.
Ken Youens-Clark [Wed, 11 Jun 2003 03:58:53 +0000]
Added validation code.
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.
Ken Youens-Clark [Wed, 11 Jun 2003 03:12:22 +0000]
Added "is_valid" tests.
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.
Ken Youens-Clark [Tue, 10 Jun 2003 03:49:49 +0000]
Adding new HTML producer.
Ken Youens-Clark [Tue, 10 Jun 2003 03:49:35 +0000]
Minor changes.
Allen Day [Mon, 9 Jun 2003 05:46:45 +0000]
move over bacon
Allen Day [Mon, 9 Jun 2003 05:38:11 +0000]
it was buggy
Ken Youens-Clark [Mon, 9 Jun 2003 05:37:04 +0000]
A POD producer.
Ken Youens-Clark [Mon, 9 Jun 2003 04:54:15 +0000]
Changed to use schema API.
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.
Ken Youens-Clark [Mon, 9 Jun 2003 04:40:08 +0000]
Some bug fixen.
Ken Youens-Clark [Mon, 9 Jun 2003 04:18:23 +0000]
Added "make_natural_joins."
Ken Youens-Clark [Mon, 9 Jun 2003 04:11:57 +0000]
Added "is_unique" method to determine if a field has a UNIQUE index.
Allen Day [Mon, 9 Jun 2003 03:38:38 +0000]
supposedly hasa()is deprecated in favor of has_a().
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.
Ken Youens-Clark [Mon, 9 Jun 2003 02:41:31 +0000]
Added rule to catch a default value given just as "null."
Ken Youens-Clark [Mon, 9 Jun 2003 02:19:41 +0000]
Removed debugging warning.
Ken Youens-Clark [Mon, 9 Jun 2003 02:16:25 +0000]
Minor change to affect context.
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.
Ken Youens-Clark [Mon, 9 Jun 2003 02:10:59 +0000]
Small changes to comments and size methods.
Ken Youens-Clark [Mon, 9 Jun 2003 02:10:10 +0000]
Small change to comment.
Ken Youens-Clark [Mon, 9 Jun 2003 02:03:15 +0000]
Removed "Raw" producer.
Ken Youens-Clark [Mon, 9 Jun 2003 02:02:48 +0000]
Removing "Raw" producer as it's unnecessary now.
Ken Youens-Clark [Mon, 9 Jun 2003 02:01:23 +0000]
Some cosmetic changes, changed to use schema API.
Ken Youens-Clark [Mon, 9 Jun 2003 02:00:41 +0000]
Expanded "translate" hash, changed to use schema API.
Ken Youens-Clark [Mon, 9 Jun 2003 02:00:01 +0000]
General cleanup, changed to use schema API.