Ken Youens-Clark [Wed, 27 Aug 2003 04:01:14 +0000]
Trying to expand to cover all args to parsers and producers; NEED HELP
GETTING THE MIME TYPES RIGHT!
Ken Youens-Clark [Wed, 27 Aug 2003 03:44:08 +0000]
The arg is called "output_type," not "image_type."
Ken Youens-Clark [Wed, 27 Aug 2003 02:28:21 +0000]
Added some Oracle datatypes so you can translate Oracle-to-Oracle; better
checking of default value and NULL values so as not to create a bogus
default; no need to make up a new index name if one is provided.
Ken Youens-Clark [Wed, 27 Aug 2003 02:26:16 +0000]
Added rule for "create index" and fine tuned "default_value" rule.
Ken Youens-Clark [Tue, 26 Aug 2003 21:50:17 +0000]
Added test for table comment as SQL comment.
Ken Youens-Clark [Tue, 26 Aug 2003 21:50:03 +0000]
Fixed bug in comment rule.
Ken Youens-Clark [Tue, 26 Aug 2003 21:45:40 +0000]
Fixed docs.
Ken Youens-Clark [Tue, 26 Aug 2003 21:45:23 +0000]
Fixed EXE_FILES filenames.
Ken Youens-Clark [Tue, 26 Aug 2003 21:41:21 +0000]
No longer calling script "sql_translator.pl."
Ken Youens-Clark [Tue, 26 Aug 2003 21:38:24 +0000]
Added drop table rule, saving of table comments.
Ken Youens-Clark [Tue, 26 Aug 2003 16:48:14 +0000]
Fixed script name.
Ken Youens-Clark [Tue, 26 Aug 2003 16:26:33 +0000]
Alias to XML::SQLFairy.
Ken Youens-Clark [Tue, 26 Aug 2003 16:25:34 +0000]
Used to be "sql_translator.cgi."
Ken Youens-Clark [Tue, 26 Aug 2003 16:22:35 +0000]
Updated with new bin file names.
Ken Youens-Clark [Tue, 26 Aug 2003 04:01:36 +0000]
Fixed drop table rule.
Ken Youens-Clark [Tue, 26 Aug 2003 03:59:46 +0000]
Added default of PAargs.
Ken Youens-Clark [Tue, 26 Aug 2003 03:59:15 +0000]
Added "title" arg.
Ken Youens-Clark [Tue, 26 Aug 2003 03:58:29 +0000]
Changes.
Ken Youens-Clark [Tue, 26 Aug 2003 03:56:43 +0000]
Adding new files.
Ken Youens-Clark [Tue, 26 Aug 2003 03:55:33 +0000]
Fixed up POD, allow for other ways to specify db.
Ken Youens-Clark [Tue, 26 Aug 2003 03:54:59 +0000]
Moved POD around, added all options for all parsers and non-graphical
producers.
Ken Youens-Clark [Tue, 26 Aug 2003 02:29:12 +0000]
Moving files around, removing ".pl" suffixes, now all start with "sqlt."
Ken Youens-Clark [Sun, 24 Aug 2003 15:12:25 +0000]
No real changes.
Ken Youens-Clark [Fri, 22 Aug 2003 22:51:51 +0000]
Fixing docs.
Ken Youens-Clark [Fri, 22 Aug 2003 22:48:20 +0000]
Corrected the docs a bit (no more data structure to pass around!), but
still need to expand a bit.
Ken Youens-Clark [Fri, 22 Aug 2003 22:38:57 +0000]
OK, I guess it's not necessary to explicitly add "META.yml" to the MANIFEST
as this happens automatically, too.
Ken Youens-Clark [Fri, 22 Aug 2003 22:30:50 +0000]
Added "META.yml" as newest version of ExtUtils::MakeMaker will add this
on "make dist."
Ken Youens-Clark [Fri, 22 Aug 2003 22:26:41 +0000]
One day we'll make this the 0.03 release.
Ken Youens-Clark [Fri, 22 Aug 2003 22:22:19 +0000]
Got rid of "SqlfXML."
Ken Youens-Clark [Fri, 22 Aug 2003 22:21:52 +0000]
Changes to quit using "SqlfXML."
Ken Youens-Clark [Fri, 22 Aug 2003 22:13:35 +0000]
Adding XML and XML-SQLFairy producers.
Ken Youens-Clark [Fri, 22 Aug 2003 20:35:18 +0000]
Changed the way "_list" works to use File::Find so it can go deeper to find
all the parsers and producers located in subdirectories.
Ken Youens-Clark [Fri, 22 Aug 2003 19:11:09 +0000]
Cosmetic changes.
Ken Youens-Clark [Fri, 22 Aug 2003 18:01:50 +0000]
Adding old SqlfXML producer as XML/SQLFairy.
Ken Youens-Clark [Fri, 22 Aug 2003 17:55:22 +0000]
Moving to XML/SQLFairy.pm.
Ken Youens-Clark [Thu, 21 Aug 2003 20:27:39 +0000]
Small change.
Ken Youens-Clark [Thu, 21 Aug 2003 20:27:04 +0000]
Fixed problem with "deep recursion."
Ken Youens-Clark [Thu, 21 Aug 2003 18:13:30 +0000]
Added link to CPAN ratings.
Ken Youens-Clark [Thu, 21 Aug 2003 18:12:56 +0000]
Expanded on AUTHORS, added dumping of Schema object if debugging, added
some POD.
Ken Youens-Clark [Thu, 21 Aug 2003 18:11:45 +0000]
Some special logic to better handle check constraints (which don't have
"fields"), also wasn't setting "expression" in "init," better returning of
"fields."
Ken Youens-Clark [Thu, 21 Aug 2003 18:10:47 +0000]
Some special logic to handle check constraints.
Ken Youens-Clark [Thu, 21 Aug 2003 18:10:14 +0000]
Now with check constraints!
Ken Youens-Clark [Thu, 21 Aug 2003 18:09:50 +0000]
Wasn't adding check constraints! Fixed.
Ken Youens-Clark [Thu, 21 Aug 2003 18:08:04 +0000]
Some cosmetic changes, some stuff dealing with check constraints, make
sure to differentiate b/w a constraint and an index.
Ken Youens-Clark [Thu, 21 Aug 2003 18:07:12 +0000]
Added test for check constraint.
Ken Youens-Clark [Thu, 21 Aug 2003 18:05:47 +0000]
Added tests for check constraint.
Ken Youens-Clark [Thu, 21 Aug 2003 02:52:40 +0000]
Changed default layout.
Ken Youens-Clark [Thu, 21 Aug 2003 02:48:04 +0000]
Chagned default.
Ken Youens-Clark [Thu, 21 Aug 2003 02:47:43 +0000]
Some POD changes.
Ken Youens-Clark [Thu, 21 Aug 2003 02:47:22 +0000]
Changed default layout type.
Ken Youens-Clark [Thu, 21 Aug 2003 02:46:48 +0000]
Added Ying.
Ken Youens-Clark [Thu, 21 Aug 2003 02:45:51 +0000]
Changed to use XML::SQLFairy.
Ken Youens-Clark [Thu, 21 Aug 2003 02:43:20 +0000]
Modified to use XML::SQLFairy, changed field size to match MySQL parser.
Ken Youens-Clark [Thu, 21 Aug 2003 02:39:21 +0000]
Got rid of "our."
Ken Youens-Clark [Thu, 21 Aug 2003 02:38:45 +0000]
Changed field size.
Ken Youens-Clark [Thu, 21 Aug 2003 02:38:34 +0000]
Got rid of "our," changed field sizes.
Ken Youens-Clark [Thu, 21 Aug 2003 02:28:38 +0000]
Changed the default sizes to be the width of the field, not the byte size.
Ken Youens-Clark [Thu, 21 Aug 2003 02:26:19 +0000]
Increased field sizes to match what PG parser is storing now.
Ken Youens-Clark [Thu, 21 Aug 2003 02:22:48 +0000]
Moved XML producer.
Ken Youens-Clark [Thu, 21 Aug 2003 01:06:52 +0000]
Corrections.
Ken Youens-Clark [Thu, 21 Aug 2003 00:48:01 +0000]
Adding it back and making it an alias to XML::SQLFairy.
Ken Youens-Clark [Thu, 21 Aug 2003 00:46:31 +0000]
Moved to "XML/SQLFairy.pm."
Ken Youens-Clark [Thu, 21 Aug 2003 00:45:43 +0000]
Adding former "SqlfXML.pm" as "XML/SQLFairy.pm."
Ken Youens-Clark [Thu, 21 Aug 2003 00:29:57 +0000]
Fixed POD.
Ken Youens-Clark [Wed, 20 Aug 2003 22:55:06 +0000]
Added a little to POD, some other simple changes to make more like other
modules.
Ken Youens-Clark [Wed, 20 Aug 2003 22:54:25 +0000]
Fixed up POD, some other cosmetics changes, removed "use warnings" to make
5.00503-friendly.
Ken Youens-Clark [Wed, 20 Aug 2003 22:53:26 +0000]
Bug fixes prompted by Gail Binkley:
- Make sure all constraints don't start with a number (pass "type" arg
to "mk_name" always now)
- Unreserve name of reference table in FK
- More testing of default value to see if a string is being used in
a number field, catch use of "current_timestamp," etc.
Ken Youens-Clark [Wed, 20 Aug 2003 22:50:30 +0000]
Removed "use warnings" to make 5.00503-friendly.
Ken Youens-Clark [Wed, 20 Aug 2003 22:49:52 +0000]
Created a separate rule for "text" datatype and set the "size" to "64,000";
fixed "set null" and "set default" by removing underscores.
Ken Youens-Clark [Wed, 20 Aug 2003 22:48:25 +0000]
Started trying to think of all the changes for 0.03.
Ken Youens-Clark [Wed, 20 Aug 2003 22:26:52 +0000]
Added "template" option for TTSchema produce, added docs for "pretty" and
"template."
Ken Youens-Clark [Wed, 20 Aug 2003 22:19:14 +0000]
Added small transform to turn "XML-SQLFairy" into "XML::SQLFairy" so that
we can create hierarchical namespaces for the parsers and producers and
not have them mixed up with other modules.
Ken Youens-Clark [Wed, 20 Aug 2003 21:26:02 +0000]
Added boilerplate header, some cosmetic/POD changes.
Ken Youens-Clark [Wed, 20 Aug 2003 20:53:48 +0000]
Changed test to match what's returned for the size of a "text" field.
Ken Youens-Clark [Wed, 20 Aug 2003 20:51:49 +0000]
Changed test to match what "comments" now returns.
Ken Youens-Clark [Wed, 20 Aug 2003 18:59:25 +0000]
Added test to make sure that serial field has 1 for "is_auto_increment."
Ken Youens-Clark [Wed, 20 Aug 2003 18:58:54 +0000]
Fixed bug where the "is_auto_increment" flag wasn't being set for serial
fields, other cosmetic changes.
Ken Youens-Clark [Wed, 20 Aug 2003 17:14:27 +0000]
Making sure that all vars are initialized to get rid of silly warnings.
Ken Youens-Clark [Wed, 20 Aug 2003 17:13:58 +0000]
All cosmetic changes while I was looking to find "uninitialized values,"
but these errors seem to be w/in the guts of XML::Writer and have nothing
to do with how it's being called.
Ken Youens-Clark [Wed, 20 Aug 2003 16:08:38 +0000]
Some minor bug fixen, additions.
Ken Youens-Clark [Wed, 20 Aug 2003 16:08:13 +0000]
Some changes to "comments" method.
Ken Youens-Clark [Wed, 20 Aug 2003 15:55:00 +0000]
Working changes I made to 1.31 back in: Many cosmetic changes to make
formatting more like the rest of the modules; added ability to set
"main_pkg_name" var with argument; important fix on setting
"_columns_primary" of package (reversing a couple conditions).
Darren Chamberlain [Wed, 20 Aug 2003 14:32:49 +0000]
Forgot to add my new test, and made the use of CGI vs. CGI::Pretty more consistent.
Darren Chamberlain [Wed, 20 Aug 2003 13:50:47 +0000]
Updated MANIFEST.
Updated tests.
Added 'pretty' option to HTML producer.
Compacted format_*_name methods.
Ken Youens-Clark [Tue, 19 Aug 2003 21:10:39 +0000]
Added test number.
Ken Youens-Clark [Tue, 19 Aug 2003 21:06:13 +0000]
Added Sybase parser back in.
Ken Youens-Clark [Tue, 19 Aug 2003 21:05:47 +0000]
Mostly functional.
Ken Youens-Clark [Tue, 19 Aug 2003 21:04:29 +0000]
Almost functional.
Ken Youens-Clark [Tue, 19 Aug 2003 15:46:09 +0000]
Added code to catch table comments (simply assumes that all comments before
"CREATE TABLE" but after other declarations belong the the next table); had
to create a separate (duplicated) rule for field comments; removed
long-commented-out code.
Ken Youens-Clark [Tue, 19 Aug 2003 15:43:52 +0000]
Added code to print out table comments.
Ken Youens-Clark [Tue, 19 Aug 2003 14:44:00 +0000]
Changed "tinytext" to convert to "varchar2," undef field size when the
datatype is "CLOB," print table comments.
Ken Youens-Clark [Tue, 19 Aug 2003 14:41:05 +0000]
Added setting of field size for *text fields. Did I get them right?
Darren Chamberlain [Mon, 18 Aug 2003 20:35:06 +0000]
Fixed pod oopsie
Ken Youens-Clark [Mon, 18 Aug 2003 20:03:53 +0000]
Replacing contents with Paul's output from dbschema.pl 2.4.2.
Ken Youens-Clark [Mon, 18 Aug 2003 18:04:00 +0000]
Adding Sybase parser test.
Ken Youens-Clark [Mon, 18 Aug 2003 17:59:01 +0000]
Adding some Sybase schema to parse, though it's from a pretty old version
of dbschema.pl. I'm hoping for something more up-to-date to come in soon.
Ken Youens-Clark [Mon, 18 Aug 2003 17:04:06 +0000]
Added Paul and Jason, more e-mail addresses.
Darren Chamberlain [Mon, 18 Aug 2003 16:53:16 +0000]
PODified smelto's email address.
Darren Chamberlain [Mon, 18 Aug 2003 16:52:56 +0000]
Typo alert!
Darren Chamberlain [Mon, 18 Aug 2003 16:52:22 +0000]
Added some email addresses.