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.
Ken Youens-Clark [Mon, 18 Aug 2003 16:33:06 +0000]
Update of README.
Ken Youens-Clark [Mon, 18 Aug 2003 16:25:19 +0000]
Removed Sybase parser from MANIFEST, update TODO.
Ken Youens-Clark [Mon, 18 Aug 2003 16:22:07 +0000]
Adding AUTHORS file per suggestion from Darren.
Ken Youens-Clark [Mon, 18 Aug 2003 15:46:22 +0000]
Breaking a long line.
Ken Youens-Clark [Mon, 18 Aug 2003 15:43:15 +0000]
Minor cosmetic changes.
Ken Youens-Clark [Mon, 18 Aug 2003 15:41:53 +0000]
Use of "map," emit warning when changing PK from CLOB to VARCHAR2.
Ross Smith II [Sun, 17 Aug 2003 07:51:33 +0000]
Fixed ORA-02329 and ORA-00907 errors.
LONG is depreciated per http://www.ss64.com/orasyntax/datatypes.html so I switched all
BLOBs to BLOB, and TEXTs to CLOB.
If it's really supposed to be BLOB => CLOB and TEXT => LONG, then please change it back,
but maybe add a comment as to why, so the next newbie doesn't make the same mistake.
I'm still getting:
ORA-02327: cannot create index on expression with datatype LOB
There are two ways to fix this:
Change field type to VARCHAR2(4000).
Remove CREATE INDEX.
I'll wait for a consensus before preceding.
This is also true for multifield PRIMARY KEYs:
ORA-02329: column of datatype LOB cannot be unique or a primary key
Ross Smith II [Sun, 17 Aug 2003 07:44:06 +0000]
Added FIXED as DEC per mysql.com/doc/en/Column_types.html
Ross Smith II [Sun, 17 Aug 2003 01:41:48 +0000]
Added DOUBLE PRECISION. Parser::MySQL chokes on this
Ross Smith II [Sun, 17 Aug 2003 01:11:54 +0000]
Added quotes around ENUM values in CONSTRAINT for Oracle & Sybase.
This change is untested as I do not have access to these right now.
Ross Smith II [Sun, 17 Aug 2003 00:46:23 +0000]
Lots of Postgres fixes:
All the basic types (int,real,string,date,blob,text) and variants (aliases) now work.
Quotes appear around field names in indexes and constraints.
Creates unique index names now.
'
Ross Smith II [Sun, 17 Aug 2003 00:42:57 +0000]
Added test file that includes all (well, it will) of the DDL for Postgres
Ross Smith II [Sun, 17 Aug 2003 00:42:08 +0000]
Added test file that includes all (well, most) of the DDL for MySQL
Ross Smith II [Sat, 16 Aug 2003 20:12:09 +0000]
We need to quote the enum field values
Ross Smith II [Sat, 16 Aug 2003 20:11:39 +0000]
zerofill has translated as 1
Ross Smith II [Sat, 16 Aug 2003 20:10:39 +0000]
Stops Use of uninitialized value in numeric gt (>) at /usr/local/share/perl/5.6.1/SQL/Translator/Parser/MySQL.pm line 594
Ross Smith II [Sat, 16 Aug 2003 15:56:58 +0000]
Fixed ENUMs (They were coming over as ENUM(n)).
Changed NORMAL indexes to INDEX (NORMAL is not valid MySQL).
Ross Smith II [Sat, 16 Aug 2003 13:42:35 +0000]
Applied CPAN patch #3247: Missing ora_data_type dec(imal)