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)
Ross Smith II [Sat, 16 Aug 2003 13:34:43 +0000]
Applied CPAN patch #3235 MANIFEST: missing some files [patch]
Ross Smith II [Sat, 16 Aug 2003 13:23:07 +0000]
Applied patch #780781: Missing binmode in Producer/GraphViz.pm.
See http://sourceforge.net/tracker/index.php?func=detail&aid=780781&group_id=47619&atid=450051
Ross Smith II [Sat, 16 Aug 2003 13:20:06 +0000]
MySQL allows for length parameter on PRIMARY KEY field names
Ken Youens-Clark [Fri, 15 Aug 2003 22:29:16 +0000]
Expanded default value rule to allow a bare word like "current_timestamp,"
also make a more helpful error message when unable to add a table.
Ken Youens-Clark [Fri, 15 Aug 2003 16:26:44 +0000]
Fixed bug in timestamp trigger syntax.
Ken Youens-Clark [Fri, 15 Aug 2003 16:17:51 +0000]
Adding a few rules so that "make clean" isn't necessary before "make manifest."
Ken Youens-Clark [Fri, 15 Aug 2003 16:16:05 +0000]
Added "integer" conversion.
Ken Youens-Clark [Fri, 15 Aug 2003 16:09:45 +0000]
Changed default value rule slightly to allow the empty string.
Mark Addison [Fri, 15 Aug 2003 15:08:08 +0000]
Added support for the attrib_values option of the XML producer.
Darren Chamberlain [Fri, 15 Aug 2003 12:51:43 +0000]
Added the new files
Darren Chamberlain [Fri, 15 Aug 2003 12:51:32 +0000]
Addressed Ken's concerns -- versions remain .02f floats. Made Test::Differences mandatory, since tests fail without it.
Ken Youens-Clark [Thu, 14 Aug 2003 16:57:17 +0000]
Adding acceptance of a "title" arg.
Ken Youens-Clark [Thu, 14 Aug 2003 16:52:38 +0000]
Fixed bug where "layout" wasn't being passed to producer.
Mark Addison [Thu, 14 Aug 2003 12:03:00 +0000]
Added attrib_values option.
Allen Day [Thu, 14 Aug 2003 01:07:56 +0000]
removing changes related to primary/essential/other categorization of fields. this
will be submitted as a patch to class::dbi::pg::set_up_table (and other dbds if they
decide to follow suit)
Ken Youens-Clark [Wed, 13 Aug 2003 18:41:05 +0000]
Added "reset" method, check for existing Schema before called parser again.
Ken Youens-Clark [Wed, 13 Aug 2003 17:13:53 +0000]
More cosmetic changes to make comments pretty, added ability to set
"main_pkg_name" variable as an argument, remove "use Data::Dumper," catch
when a foreign key doesn't have a transform, added use of Text::Autoformat
to break up long lines when declaring "->columns," removed code commented
out after move to explicit column declarations.
Ken Youens-Clark [Tue, 12 Aug 2003 23:21:54 +0000]
Ran through perltidy, broke long lines, changed logic on setting of
"$pkg->{'_columns_primary'}."
Ken Youens-Clark [Tue, 12 Aug 2003 22:03:59 +0000]
Added logic to ensure the PK fields are not nullable (thanks to S. Quinney).
Ken Youens-Clark [Tue, 12 Aug 2003 22:02:33 +0000]
Fixed spelling error of "deferrable."
Ken Youens-Clark [Tue, 12 Aug 2003 22:00:28 +0000]
Changes to make case-insensitive rules, fixed spelling error of "deferrable,"
change to default value rule to be more flexible.
Ken Youens-Clark [Tue, 12 Aug 2003 21:59:10 +0000]
Changed to look at different constraints as NOT NULLs are now allowed as
table constraints.
Mark Addison [Tue, 12 Aug 2003 11:22:45 +0000]
Added explicit version of 1.13 for XML::XPath as the parser doesn't seem to work with older versions.
Ken Youens-Clark [Fri, 8 Aug 2003 22:22:51 +0000]
Added "set" rule, remove extra space after comment character.
Mark Addison [Fri, 8 Aug 2003 12:30:20 +0000]
Added a test for Producer::SqlfXML.
Refactored producer so that the XML for the attributes of the Schema::*
objects (::Field ::Table ::Index ::Constraint) is generated by the same
sub. Makes testing and tweaking easier :)