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.
Ken Youens-Clark [Mon, 9 Jun 2003 01:59:21 +0000]
Changed to use schema API.
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.
Ken Youens-Clark [Mon, 9 Jun 2003 01:56:51 +0000]
Changed to use schema objects.
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.
Ken Youens-Clark [Fri, 6 Jun 2003 22:52:46 +0000]
Added Oracle parser test.
Ken Youens-Clark [Fri, 6 Jun 2003 22:48:14 +0000]
General mods to make it like others.
Ken Youens-Clark [Fri, 6 Jun 2003 22:47:25 +0000]
Added "use strict;"
Ken Youens-Clark [Fri, 6 Jun 2003 22:46:27 +0000]
General clean up to make it more like the others.
Ken Youens-Clark [Fri, 6 Jun 2003 22:45:44 +0000]
General clean up to make it more like other tests.
Ken Youens-Clark [Fri, 6 Jun 2003 22:41:42 +0000]
Fixed test numbers.
Ken Youens-Clark [Fri, 6 Jun 2003 22:39:32 +0000]
Fixed test numbers, removed unnecessary code.
Ken Youens-Clark [Fri, 6 Jun 2003 22:37:25 +0000]
Added sorting of tables, other cosmetic changes.
Ken Youens-Clark [Fri, 6 Jun 2003 22:36:09 +0000]
Added comments method and parsing on init.
Ken Youens-Clark [Fri, 6 Jun 2003 22:35:44 +0000]
Added parsing of comments on init, added "comments" method.
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.
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.
Ken Youens-Clark [Fri, 6 Jun 2003 22:34:00 +0000]
Changed "FULLTEXT."
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.
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.
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.
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.
Ken Youens-Clark [Fri, 6 Jun 2003 22:24:45 +0000]
Added new Oracle parser test.
Ken Youens-Clark [Fri, 6 Jun 2003 22:24:26 +0000]
Added a lot more tests, now using the Schema object.
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.