21 years agoFixed up POD, allow for other ways to specify db.
Ken Youens-Clark [Tue, 26 Aug 2003 03:55:33 +0000]
Fixed up POD, allow for other ways to specify db.

21 years agoMoved POD around, added all options for all parsers and non-graphical
Ken Youens-Clark [Tue, 26 Aug 2003 03:54:59 +0000]
Moved POD around, added all options for all parsers and non-graphical
producers.

21 years agoMoving files around, removing ".pl" suffixes, now all start with "sqlt."
Ken Youens-Clark [Tue, 26 Aug 2003 02:29:12 +0000]
Moving files around, removing ".pl" suffixes, now all start with "sqlt."

21 years agoNo real changes.
Ken Youens-Clark [Sun, 24 Aug 2003 15:12:25 +0000]
No real changes.

21 years agoFixing docs.
Ken Youens-Clark [Fri, 22 Aug 2003 22:51:51 +0000]
Fixing docs.

21 years agoCorrected the docs a bit (no more data structure to pass around!), but
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.

21 years agoOK, I guess it's not necessary to explicitly add "META.yml" to the MANIFEST
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.

21 years agoAdded "META.yml" as newest version of ExtUtils::MakeMaker will add this
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."

21 years agoOne day we'll make this the 0.03 release.
Ken Youens-Clark [Fri, 22 Aug 2003 22:26:41 +0000]
One day we'll make this the 0.03 release.

21 years agoGot rid of "SqlfXML."
Ken Youens-Clark [Fri, 22 Aug 2003 22:22:19 +0000]
Got rid of "SqlfXML."

21 years agoChanges to quit using "SqlfXML."
Ken Youens-Clark [Fri, 22 Aug 2003 22:21:52 +0000]
Changes to quit using "SqlfXML."

21 years agoAdding XML and XML-SQLFairy producers.
Ken Youens-Clark [Fri, 22 Aug 2003 22:13:35 +0000]
Adding XML and XML-SQLFairy producers.

21 years agoChanged the way "_list" works to use File::Find so it can go deeper to find
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.

21 years agoCosmetic changes.
Ken Youens-Clark [Fri, 22 Aug 2003 19:11:09 +0000]
Cosmetic changes.

21 years agoAdding old SqlfXML producer as XML/SQLFairy.
Ken Youens-Clark [Fri, 22 Aug 2003 18:01:50 +0000]
Adding old SqlfXML producer as XML/SQLFairy.

21 years agoMoving to XML/SQLFairy.pm.
Ken Youens-Clark [Fri, 22 Aug 2003 17:55:22 +0000]
Moving to XML/SQLFairy.pm.

21 years agoSmall change.
Ken Youens-Clark [Thu, 21 Aug 2003 20:27:39 +0000]
Small change.

21 years agoFixed problem with "deep recursion."
Ken Youens-Clark [Thu, 21 Aug 2003 20:27:04 +0000]
Fixed problem with "deep recursion."

21 years agoAdded link to CPAN ratings.
Ken Youens-Clark [Thu, 21 Aug 2003 18:13:30 +0000]
Added link to CPAN ratings.

21 years agoExpanded on AUTHORS, added dumping of Schema object if debugging, added
Ken Youens-Clark [Thu, 21 Aug 2003 18:12:56 +0000]
Expanded on AUTHORS, added dumping of Schema object if debugging, added
some POD.

21 years agoSome special logic to better handle check constraints (which don't have
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."

21 years agoSome special logic to handle check constraints.
Ken Youens-Clark [Thu, 21 Aug 2003 18:10:47 +0000]
Some special logic to handle check constraints.

21 years agoNow with check constraints!
Ken Youens-Clark [Thu, 21 Aug 2003 18:10:14 +0000]
Now with check constraints!

21 years agoWasn't adding check constraints! Fixed.
Ken Youens-Clark [Thu, 21 Aug 2003 18:09:50 +0000]
Wasn't adding check constraints!  Fixed.

21 years agoSome cosmetic changes, some stuff dealing with check constraints, make
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.

21 years agoAdded test for check constraint.
Ken Youens-Clark [Thu, 21 Aug 2003 18:07:12 +0000]
Added test for check constraint.

21 years agoAdded tests for check constraint.
Ken Youens-Clark [Thu, 21 Aug 2003 18:05:47 +0000]
Added tests for check constraint.

21 years agoChanged default layout.
Ken Youens-Clark [Thu, 21 Aug 2003 02:52:40 +0000]
Changed default layout.

21 years agoChagned default.
Ken Youens-Clark [Thu, 21 Aug 2003 02:48:04 +0000]
Chagned default.

21 years agoSome POD changes.
Ken Youens-Clark [Thu, 21 Aug 2003 02:47:43 +0000]
Some POD changes.

21 years agoChanged default layout type.
Ken Youens-Clark [Thu, 21 Aug 2003 02:47:22 +0000]
Changed default layout type.

21 years agoAdded Ying.
Ken Youens-Clark [Thu, 21 Aug 2003 02:46:48 +0000]
Added Ying.

21 years agoChanged to use XML::SQLFairy.
Ken Youens-Clark [Thu, 21 Aug 2003 02:45:51 +0000]
Changed to use XML::SQLFairy.

21 years agoModified to use XML::SQLFairy, changed field size to match MySQL parser.
Ken Youens-Clark [Thu, 21 Aug 2003 02:43:20 +0000]
Modified to use XML::SQLFairy, changed field size to match MySQL parser.

21 years agoGot rid of "our."
Ken Youens-Clark [Thu, 21 Aug 2003 02:39:21 +0000]
Got rid of "our."

21 years agoChanged field size.
Ken Youens-Clark [Thu, 21 Aug 2003 02:38:45 +0000]
Changed field size.

21 years agoGot rid of "our," changed field sizes.
Ken Youens-Clark [Thu, 21 Aug 2003 02:38:34 +0000]
Got rid of "our," changed field sizes.

21 years agoChanged the default sizes to be the width of the field, not the byte size.
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.

21 years agoIncreased field sizes to match what PG parser is storing now.
Ken Youens-Clark [Thu, 21 Aug 2003 02:26:19 +0000]
Increased field sizes to match what PG parser is storing now.

21 years agoMoved XML producer.
Ken Youens-Clark [Thu, 21 Aug 2003 02:22:48 +0000]
Moved XML producer.

21 years agoCorrections.
Ken Youens-Clark [Thu, 21 Aug 2003 01:06:52 +0000]
Corrections.

21 years agoAdding it back and making it an alias to XML::SQLFairy.
Ken Youens-Clark [Thu, 21 Aug 2003 00:48:01 +0000]
Adding it back and making it an alias to XML::SQLFairy.

21 years agoMoved to "XML/SQLFairy.pm."
Ken Youens-Clark [Thu, 21 Aug 2003 00:46:31 +0000]
Moved to "XML/SQLFairy.pm."

21 years agoAdding former "SqlfXML.pm" as "XML/SQLFairy.pm."
Ken Youens-Clark [Thu, 21 Aug 2003 00:45:43 +0000]
Adding former "SqlfXML.pm" as "XML/SQLFairy.pm."

21 years agoFixed POD.
Ken Youens-Clark [Thu, 21 Aug 2003 00:29:57 +0000]
Fixed POD.

21 years agoAdded a little to POD, some other simple changes to make more like other
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.

21 years agoFixed up POD, some other cosmetics changes, removed "use warnings" to make
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.

21 years agoBug fixes prompted by Gail Binkley:
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.

21 years agoRemoved "use warnings" to make 5.00503-friendly.
Ken Youens-Clark [Wed, 20 Aug 2003 22:50:30 +0000]
Removed "use warnings" to make 5.00503-friendly.

21 years agoCreated a separate rule for "text" datatype and set the "size" to "64,000";
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.

21 years agoStarted trying to think of all the changes for 0.03.
Ken Youens-Clark [Wed, 20 Aug 2003 22:48:25 +0000]
Started trying to think of all the changes for 0.03.

21 years agoAdded "template" option for TTSchema produce, added docs for "pretty" and
Ken Youens-Clark [Wed, 20 Aug 2003 22:26:52 +0000]
Added "template" option for TTSchema produce, added docs for "pretty" and
"template."

21 years agoAdded small transform to turn "XML-SQLFairy" into "XML::SQLFairy" so that
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.

21 years agoAdded boilerplate header, some cosmetic/POD changes.
Ken Youens-Clark [Wed, 20 Aug 2003 21:26:02 +0000]
Added boilerplate header, some cosmetic/POD changes.

21 years agoChanged test to match what's returned for the size of a "text" field.
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.

21 years agoChanged test to match what "comments" now returns.
Ken Youens-Clark [Wed, 20 Aug 2003 20:51:49 +0000]
Changed test to match what "comments" now returns.

21 years agoAdded test to make sure that serial field has 1 for "is_auto_increment."
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."

21 years agoFixed bug where the "is_auto_increment" flag wasn't being set for serial
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.

21 years agoMaking sure that all vars are initialized to get rid of silly warnings.
Ken Youens-Clark [Wed, 20 Aug 2003 17:14:27 +0000]
Making sure that all vars are initialized to get rid of silly warnings.

21 years agoAll cosmetic changes while I was looking to find "uninitialized values,"
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.

21 years agoSome minor bug fixen, additions.
Ken Youens-Clark [Wed, 20 Aug 2003 16:08:38 +0000]
Some minor bug fixen, additions.

21 years agoSome changes to "comments" method.
Ken Youens-Clark [Wed, 20 Aug 2003 16:08:13 +0000]
Some changes to "comments" method.

21 years agoWorking changes I made to 1.31 back in: Many cosmetic changes to make
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).

21 years agoForgot to add my new test, and made the use of CGI vs. CGI::Pretty more consistent.
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.

21 years agoUpdated MANIFEST.
Darren Chamberlain [Wed, 20 Aug 2003 13:50:47 +0000]
Updated MANIFEST.
Updated tests.
Added 'pretty' option to HTML producer.
Compacted format_*_name methods.

21 years agoAdded test number.
Ken Youens-Clark [Tue, 19 Aug 2003 21:10:39 +0000]
Added test number.

21 years agoAdded Sybase parser back in.
Ken Youens-Clark [Tue, 19 Aug 2003 21:06:13 +0000]
Added Sybase parser back in.

21 years agoMostly functional.
Ken Youens-Clark [Tue, 19 Aug 2003 21:05:47 +0000]
Mostly functional.

21 years agoAlmost functional.
Ken Youens-Clark [Tue, 19 Aug 2003 21:04:29 +0000]
Almost functional.

21 years agoAdded code to catch table comments (simply assumes that all comments before
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.

21 years agoAdded code to print out table comments.
Ken Youens-Clark [Tue, 19 Aug 2003 15:43:52 +0000]
Added code to print out table comments.

21 years agoChanged "tinytext" to convert to "varchar2," undef field size when the
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.

21 years agoAdded setting of field size for *text fields. Did I get them right?
Ken Youens-Clark [Tue, 19 Aug 2003 14:41:05 +0000]
Added setting of field size for *text fields.  Did I get them right?

21 years agoFixed pod oopsie
Darren Chamberlain [Mon, 18 Aug 2003 20:35:06 +0000]
Fixed pod oopsie

21 years agoReplacing contents with Paul's output from dbschema.pl 2.4.2.
Ken Youens-Clark [Mon, 18 Aug 2003 20:03:53 +0000]
Replacing contents with Paul's output from dbschema.pl 2.4.2.

21 years agoAdding Sybase parser test.
Ken Youens-Clark [Mon, 18 Aug 2003 18:04:00 +0000]
Adding Sybase parser test.

21 years agoAdding some Sybase schema to parse, though it's from a pretty old version
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.

21 years agoAdded Paul and Jason, more e-mail addresses.
Ken Youens-Clark [Mon, 18 Aug 2003 17:04:06 +0000]
Added Paul and Jason, more e-mail addresses.

21 years agoPODified smelto's email address.
Darren Chamberlain [Mon, 18 Aug 2003 16:53:16 +0000]
PODified smelto's email address.

21 years agoTypo alert!
Darren Chamberlain [Mon, 18 Aug 2003 16:52:56 +0000]
Typo alert!

21 years agoAdded some email addresses.
Darren Chamberlain [Mon, 18 Aug 2003 16:52:22 +0000]
Added some email addresses.

21 years agoUpdate of README.
Ken Youens-Clark [Mon, 18 Aug 2003 16:33:06 +0000]
Update of README.

21 years agoRemoved Sybase parser from MANIFEST, update TODO.
Ken Youens-Clark [Mon, 18 Aug 2003 16:25:19 +0000]
Removed Sybase parser from MANIFEST, update TODO.

21 years agoAdding AUTHORS file per suggestion from Darren.
Ken Youens-Clark [Mon, 18 Aug 2003 16:22:07 +0000]
Adding AUTHORS file per suggestion from Darren.

21 years agoBreaking a long line.
Ken Youens-Clark [Mon, 18 Aug 2003 15:46:22 +0000]
Breaking a long line.

21 years agoMinor cosmetic changes.
Ken Youens-Clark [Mon, 18 Aug 2003 15:43:15 +0000]
Minor cosmetic changes.

21 years agoUse of "map," emit warning when changing PK from CLOB to VARCHAR2.
Ken Youens-Clark [Mon, 18 Aug 2003 15:41:53 +0000]
Use of "map," emit warning when changing PK from CLOB to VARCHAR2.

21 years agoFixed ORA-02329 and ORA-00907 errors.
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

21 years agoAdded FIXED as DEC per http://www.mysql.com/doc/en/Column_types.html
Ross Smith II [Sun, 17 Aug 2003 07:44:06 +0000]
Added FIXED as DEC per mysql.com/doc/en/Column_types.html

21 years agoAdded DOUBLE PRECISION. Parser::MySQL chokes on this
Ross Smith II [Sun, 17 Aug 2003 01:41:48 +0000]
Added DOUBLE PRECISION. Parser::MySQL chokes on this

21 years agoAdded quotes around ENUM values in CONSTRAINT for Oracle & Sybase.
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.

21 years agoLots of Postgres fixes:
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.
'

21 years agoAdded test file that includes all (well, it will) of the DDL for Postgres
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

21 years agoAdded test file that includes all (well, most) of the DDL for MySQL
Ross Smith II [Sun, 17 Aug 2003 00:42:08 +0000]
Added test file that includes all (well, most) of the DDL for MySQL

21 years agoWe need to quote the enum field values
Ross Smith II [Sat, 16 Aug 2003 20:12:09 +0000]
We need to quote the enum field values

21 years agozerofill has translated as 1
Ross Smith II [Sat, 16 Aug 2003 20:11:39 +0000]
zerofill has translated as 1

21 years agoStops Use of uninitialized value in numeric gt (>) at /usr/local/share/perl/5.6.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

21 years agoFixed ENUMs (They were coming over as ENUM(n)).
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).

21 years agoApplied CPAN patch #3247: Missing ora_data_type dec(imal)
Ross Smith II [Sat, 16 Aug 2003 13:42:35 +0000]
Applied CPAN patch #3247: Missing ora_data_type dec(imal)

21 years agoApplied CPAN patch #3235 MANIFEST: missing some files [patch]
Ross Smith II [Sat, 16 Aug 2003 13:34:43 +0000]
Applied CPAN patch #3235 MANIFEST: missing some files [patch]