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 :)
Ken Youens-Clark [Thu, 7 Aug 2003 18:15:51 +0000]
Fixing bugs as reported by S. Quinney in RT ticket.
Mark Addison [Thu, 7 Aug 2003 16:53:40 +0000]
Fixed bug with emit_empty_tags. It now works and we get more explict values for things instead of lots of empty sets of tags ie <foo>0</foo> not <foo></foo>.
Mark Addison [Thu, 7 Aug 2003 15:27:54 +0000]
D'oh! Fixed comment typo that chaged the meaning of the comment.
Mark Addison [Thu, 7 Aug 2003 15:03:31 +0000]
Changed term single tags to empty tags to mean <foo/> like tags, it being the correct term :)
Mark Addison [Thu, 7 Aug 2003 14:49:24 +0000]
Added BUG notes and test about single tags e.g. <foo/>
Mark Addison [Thu, 7 Aug 2003 14:19:33 +0000]
Added TTSchema producer.
Allen Day [Thu, 7 Aug 2003 03:51:48 +0000]
no longer using set_up_table method. it incurs an overhead penalty by making
it possible to define the class with less code. why bother doing this when we
are autogenerating code anyway?
we now also do lazy-loading on FK fields so that vivification of an object does
not pay the penalty to vivify has-a objects (ie FK objects) until they are
explicitly asked for.
bottom line: performance increase overally. huge performance increase for
heavily linked tables.
Mark Addison [Wed, 6 Aug 2003 22:08:16 +0000]
Fixed default value bug in Parser::SqlfXML.
Ken Youens-Clark [Wed, 6 Aug 2003 17:48:38 +0000]
Changed to use new "SqlfXML" producer.
Ken Youens-Clark [Wed, 6 Aug 2003 17:46:21 +0000]
Added dependencies from new XML modules.
Mark Addison [Wed, 6 Aug 2003 17:14:09 +0000]
Moved Producer::XML to Producer::SqlfXML.
Added Parser::XML to parse the XML from Producer::SqlfXML.
Ken Youens-Clark [Mon, 4 Aug 2003 21:04:04 +0000]
FK defs were leaving out the field name.
Ken Youens-Clark [Mon, 4 Aug 2003 20:55:45 +0000]
Allow more producers than just the two graphical.
Ken Youens-Clark [Mon, 4 Aug 2003 18:44:10 +0000]
Reversed arrowheads.
Ken Youens-Clark [Mon, 4 Aug 2003 18:41:45 +0000]
Reversed the arrowheads.
Ken Youens-Clark [Mon, 4 Aug 2003 15:20:21 +0000]
Added line to disable checking of FKs on import of tables.
Ken Youens-Clark [Mon, 4 Aug 2003 15:19:08 +0000]
New MySQL 4 syntax allows field names to be in backticks (and this is the
default format of the latest "mysqldump").
Ken Youens-Clark [Mon, 4 Aug 2003 15:16:13 +0000]
Applying (spirit of) patch from RT making keyword "table" optional in
GRANT and REVOKE commands.
Darren Chamberlain [Thu, 31 Jul 2003 20:51:34 +0000]
Oops, haven't added these yet.
Darren Chamberlain [Thu, 31 Jul 2003 20:49:42 +0000]
.cvsignore
Darren Chamberlain [Thu, 31 Jul 2003 20:48:23 +0000]
Some simple cleanups.
Ken Youens-Clark [Fri, 25 Jul 2003 21:50:49 +0000]
Added "character set" as field qualifier as this is part of MySQL 4 output.
Ken Youens-Clark [Fri, 18 Jul 2003 22:56:41 +0000]
Added options for specifying image map.
Ken Youens-Clark [Fri, 18 Jul 2003 22:56:12 +0000]
Allow embedded comments a la the PG parser, store the comments; also strip
comments of comments chars and trailing whitespace.
Ken Youens-Clark [Fri, 18 Jul 2003 22:55:18 +0000]
Print out field comments using Oracle "comment on field" syntax.
Ken Youens-Clark [Fri, 18 Jul 2003 22:54:41 +0000]
Added a "table" section at the top to click right to a particular table.
Ken Youens-Clark [Fri, 18 Jul 2003 22:54:17 +0000]
Added options to make an image map.
Ken Youens-Clark [Fri, 11 Jul 2003 15:22:45 +0000]
Made "pg_data_type" rules case-insensitive per a patch from Richard
Clamp <richardc@unixbeard.net>.
Allen Day [Wed, 9 Jul 2003 17:48:12 +0000]
aliasing ugly tablename_fieldname ref methods where possible (ie create them
for 1-M relationships between tables where the M end table does not allow a
M-1 traversal to another table, thus giving a M-M relationship)