20 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.

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

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

20 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.

20 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

20 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

20 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

20 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.

20 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.
'

20 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

20 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

20 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

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

20 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

20 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).

20 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)

20 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]

20 years agoApplied patch #780781: Missing binmode in Producer/GraphViz.pm.
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

20 years agoMySQL allows for length parameter on PRIMARY KEY field names
Ross Smith II [Sat, 16 Aug 2003 13:20:06 +0000]
MySQL allows for length parameter on PRIMARY KEY field names

20 years agoExpanded default value rule to allow a bare word like "current_timestamp,"
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.

20 years agoFixed bug in timestamp trigger syntax.
Ken Youens-Clark [Fri, 15 Aug 2003 16:26:44 +0000]
Fixed bug in timestamp trigger syntax.

20 years agoAdding a few rules so that "make clean" isn't necessary before "make manifest."
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."

20 years agoAdded "integer" conversion.
Ken Youens-Clark [Fri, 15 Aug 2003 16:16:05 +0000]
Added "integer" conversion.

20 years agoChanged default value rule slightly to allow the empty string.
Ken Youens-Clark [Fri, 15 Aug 2003 16:09:45 +0000]
Changed default value rule slightly to allow the empty string.

20 years agoAdded support for the attrib_values option of the XML producer.
Mark Addison [Fri, 15 Aug 2003 15:08:08 +0000]
Added support for the attrib_values option of the XML producer.

20 years agoAdded the new files
Darren Chamberlain [Fri, 15 Aug 2003 12:51:43 +0000]
Added the new files

20 years agoAddressed Ken's concerns -- versions remain .02f floats. Made Test::Differences...
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.

20 years agoAdding acceptance of a "title" arg.
Ken Youens-Clark [Thu, 14 Aug 2003 16:57:17 +0000]
Adding acceptance of a "title" arg.

20 years agoFixed bug where "layout" wasn't being passed to producer.
Ken Youens-Clark [Thu, 14 Aug 2003 16:52:38 +0000]
Fixed bug where "layout" wasn't being passed to producer.

20 years agoAdded attrib_values option.
Mark Addison [Thu, 14 Aug 2003 12:03:00 +0000]
Added attrib_values option.

20 years agoremoving changes related to primary/essential/other categorization of fields. this
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)

20 years agoAdded "reset" method, check for existing Schema before called parser again.
Ken Youens-Clark [Wed, 13 Aug 2003 18:41:05 +0000]
Added "reset" method, check for existing Schema before called parser again.

20 years agoMore cosmetic changes to make comments pretty, added ability to set
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.

20 years agoRan through perltidy, broke long lines, changed logic on setting of
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'}."

20 years agoAdded logic to ensure the PK fields are not nullable (thanks to S. Quinney).
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).

20 years agoFixed spelling error of "deferrable."
Ken Youens-Clark [Tue, 12 Aug 2003 22:02:33 +0000]
Fixed spelling error of "deferrable."

20 years agoChanges to make case-insensitive rules, 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.

20 years agoChanged to look at different constraints as NOT NULLs are now allowed as
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.

20 years agoAdded explicit version of 1.13 for XML::XPath as the parser doesn't seem to work...
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.

20 years agoAdded "set" rule, remove extra space after comment character.
Ken Youens-Clark [Fri, 8 Aug 2003 22:22:51 +0000]
Added "set" rule, remove extra space after comment character.

20 years agoAdded a test for Producer::SqlfXML.
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 :)

20 years agoFixing bugs as reported by S. Quinney in RT ticket.
Ken Youens-Clark [Thu, 7 Aug 2003 18:15:51 +0000]
Fixing bugs as reported by S. Quinney in RT ticket.

20 years agoFixed bug with emit_empty_tags. It now works and we get more explict values for thing...
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>.

20 years agoD'oh! Fixed comment typo that chaged the meaning of the comment.
Mark Addison [Thu, 7 Aug 2003 15:27:54 +0000]
D'oh! Fixed comment typo that chaged the meaning of the comment.

20 years agoChanged term single tags to empty tags to mean <foo/> like tags, it being the correct...
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 :)

20 years agoAdded BUG notes and test about single tags e.g. <foo/>
Mark Addison [Thu, 7 Aug 2003 14:49:24 +0000]
Added BUG notes and test about single tags e.g. <foo/>

20 years agoAdded TTSchema producer.
Mark Addison [Thu, 7 Aug 2003 14:19:33 +0000]
Added TTSchema producer.

20 years agono longer using set_up_table method. it incurs an overhead penalty by making
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.

20 years agoFixed default value bug in Parser::SqlfXML.
Mark Addison [Wed, 6 Aug 2003 22:08:16 +0000]
Fixed default value bug in Parser::SqlfXML.

20 years agoChanged to use new "SqlfXML" producer.
Ken Youens-Clark [Wed, 6 Aug 2003 17:48:38 +0000]
Changed to use new "SqlfXML" producer.

20 years agoAdded dependencies from new XML modules.
Ken Youens-Clark [Wed, 6 Aug 2003 17:46:21 +0000]
Added dependencies from new XML modules.

20 years agoMoved Producer::XML to Producer::SqlfXML.
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.

20 years agoFK defs were leaving out the field name.
Ken Youens-Clark [Mon, 4 Aug 2003 21:04:04 +0000]
FK defs were leaving out the field name.

20 years agoAllow more producers than just the two graphical.
Ken Youens-Clark [Mon, 4 Aug 2003 20:55:45 +0000]
Allow more producers than just the two graphical.

20 years agoReversed arrowheads.
Ken Youens-Clark [Mon, 4 Aug 2003 18:44:10 +0000]
Reversed arrowheads.

20 years agoReversed the arrowheads.
Ken Youens-Clark [Mon, 4 Aug 2003 18:41:45 +0000]
Reversed the arrowheads.

20 years agoAdded line to disable checking of FKs on import of tables.
Ken Youens-Clark [Mon, 4 Aug 2003 15:20:21 +0000]
Added line to disable checking of FKs on import of tables.

20 years agoNew MySQL 4 syntax allows field names to be in backticks (and this is the
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").

20 years agoApplying (spirit of) patch from RT making keyword "table" optional in
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.

20 years agoOops, haven't added these yet.
Darren Chamberlain [Thu, 31 Jul 2003 20:51:34 +0000]
Oops, haven't added these yet.

20 years ago.cvsignore
Darren Chamberlain [Thu, 31 Jul 2003 20:49:42 +0000]
.cvsignore

20 years agoSome simple cleanups.
Darren Chamberlain [Thu, 31 Jul 2003 20:48:23 +0000]
Some simple cleanups.

20 years agoAdded "character set" as field qualifier as this is part of MySQL 4 output.
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.

20 years agoAdded options for specifying image map.
Ken Youens-Clark [Fri, 18 Jul 2003 22:56:41 +0000]
Added options for specifying image map.

20 years agoAllow embedded comments a la the PG parser, store the comments; also strip
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.

20 years agoPrint out field comments using Oracle "comment on field" syntax.
Ken Youens-Clark [Fri, 18 Jul 2003 22:55:18 +0000]
Print out field comments using Oracle "comment on field" syntax.

20 years agoAdded a "table" section at the top to click right to a particular table.
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.

20 years agoAdded options to make an image map.
Ken Youens-Clark [Fri, 18 Jul 2003 22:54:17 +0000]
Added options to make an image map.

20 years agoMade "pg_data_type" rules case-insensitive per a patch from Richard
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>.

20 years agoaliasing ugly tablename_fieldname ref methods where possible (ie create them
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)

20 years agocommenting shortcoming
Allen Day [Wed, 9 Jul 2003 06:09:56 +0000]
commenting shortcoming

20 years agohad to fix up the format_pk_method (somehow it got broken, hmm...).
Allen Day [Wed, 9 Jul 2003 05:59:24 +0000]
had to fix up the format_pk_method (somehow it got broken, hmm...).

also, i do (or almost do) have linktable autodetection working again.
i also began to add conditions that handle link tables which import FKs
multiple times from a single table.  this is not yet bug free.  will post
to list what i'm talking about here...

20 years agoStrip field size qualifiers from index fields as SQLite doesn't like.
Ken Youens-Clark [Wed, 2 Jul 2003 18:18:44 +0000]
Strip field size qualifiers from index fields as SQLite doesn't like.

20 years agoFixed VERSION to be CPAN-friendly.
Ken Youens-Clark [Fri, 27 Jun 2003 16:47:40 +0000]
Fixed VERSION to be CPAN-friendly.

20 years agoFixed VERSION.
Ken Youens-Clark [Fri, 27 Jun 2003 16:30:35 +0000]
Fixed VERSION.

20 years agoReversed earlier change to VERSION after Darren scolded me.
Ken Youens-Clark [Fri, 27 Jun 2003 16:28:21 +0000]
Reversed earlier change to VERSION after Darren scolded me.

20 years agoEfforts to re-enable Allen's many-to-many linktable code. I have no idea
Ken Youens-Clark [Fri, 27 Jun 2003 02:59:25 +0000]
Efforts to re-enable Allen's many-to-many linktable code.  I have no idea
if it works properly!

20 years agoI've tried to address Allen's concerns about naming of FKs, but still haven't
Ken Youens-Clark [Fri, 27 Jun 2003 02:28:11 +0000]
I've tried to address Allen's concerns about naming of FKs, but still haven't
touched the "linktable" code yet.

20 years agoMinor change.
Ken Youens-Clark [Fri, 27 Jun 2003 01:58:44 +0000]
Minor change.

20 years agoAdded "use Class::Base;" declaration to go with use base statement.
Darren Chamberlain [Thu, 26 Jun 2003 14:29:47 +0000]
Added "use Class::Base;" declaration to go with use base statement.

20 years agoRemoved redeclaration of "$parser_type," fixed bug in DSN, removed "s" on
Ken Youens-Clark [Wed, 25 Jun 2003 19:47:10 +0000]
Removed redeclaration of "$parser_type," fixed bug in DSN, removed "s" on
"has_many" field name.

20 years agoAdded "()" to character class of "default_val" rule to allow "now()" to
Ken Youens-Clark [Wed, 25 Jun 2003 19:25:38 +0000]
Added "()" to character class of "default_val" rule to allow "now()" to
be accepted.

20 years agoFixed a bug-fix of mine that was contingent on my checking in another module.
Ken Youens-Clark [Wed, 25 Jun 2003 19:17:06 +0000]
Fixed a bug-fix of mine that was contingent on my checking in another module.

20 years agoAttempting clean up something.
Ken Youens-Clark [Wed, 25 Jun 2003 19:15:19 +0000]
Attempting clean up something.

20 years agofixes for base DBI package setting db vendor based on $translator->parser_type().
Allen Day [Wed, 25 Jun 2003 19:10:17 +0000]
fixes for base DBI package setting db vendor based on $translator->parser_type().

added 's' for has_many() autogen relationships

repaired format_pk_name() weirdness that was being caused by ken's introduced bug

20 years agoAllow translation from parsers other than MySQL, Pg, and Oracle and just
Ken Youens-Clark [Wed, 25 Jun 2003 18:47:45 +0000]
Allow translation from parsers other than MySQL, Pg, and Oracle and just
set up table more manually than using the "set_up_table" method; no reason
to accept "$data" at beginning as it's not being sent anymore; no
longer using "$USER" or "$PASS" as they were only used once; removed
Class::DBI::Join as Michael Schwern (the module maintainer and Author
Emeritus of Class::DBI) says that Class::DBI handles this fine now
that this extra module will be leaving CPAN soon;  only create PK
accessor method if a callback was installed for it;  use
"$table->primary_key" to get PK rather than running through the
constraints to find it;  delay creation of output for each table until
after we've gone through everything so we can better set up the
"has_a" and "has_many" relationships;  intuit "has_many" as the
reverse of "has_a";  cleaned up "link tables" section, but commented
out as I'm not sure if my addition of "has_many" code might not do the
same thing.

20 years agoadding strict and quotes for barewords
Allen Day [Wed, 25 Jun 2003 02:04:33 +0000]
adding strict and quotes for barewords

20 years agoAdded more description; allow options for db user/pass/dsn, skipping certain
Ken Youens-Clark [Tue, 24 Jun 2003 21:00:24 +0000]
Added more description; allow options for db user/pass/dsn, skipping certain
tables; better handling of script args; added header comment to generated
script; also added use of Getopt::Long so it can accept "skip," "truncate,"
and "help" args (and be a real, grown-up script on its own).

20 years agoChanged "hasa" to "has_a."
Ken Youens-Clark [Tue, 24 Jun 2003 03:50:43 +0000]
Changed "hasa" to "has_a."

20 years agoAdding dumper creator.
Ken Youens-Clark [Tue, 24 Jun 2003 03:24:02 +0000]
Adding dumper creator.

20 years agoAllow data types which haven't been listed in translation table to pass
Ken Youens-Clark [Mon, 23 Jun 2003 21:47:30 +0000]
Allow data types which haven't been listed in translation table to pass
through unchanged.

20 years agoFixed grammar for REVOKE and GRANT (missing word "table").
Ken Youens-Clark [Mon, 23 Jun 2003 21:44:32 +0000]
Fixed grammar for REVOKE and GRANT (missing word "table").

20 years agofk references in many-to-many mappings need to refer to table column names
Allen Day [Thu, 19 Jun 2003 23:29:07 +0000]
fk references in many-to-many mappings need to refer to table column names
explicitly, rather than aliases to those column names in the class::dbi
layer.

-allen

20 years agoThe $DEFAULT_SUB was still looking at $_[1], and not $_[0]->schema
Darren Chamberlain [Thu, 19 Jun 2003 20:44:26 +0000]
The $DEFAULT_SUB was still looking at $_[1], and not $_[0]->schema

20 years agoAdded single quotes around the "use base 'foo';" line.
Ken Youens-Clark [Thu, 19 Jun 2003 01:18:07 +0000]
Added single quotes around the "use base 'foo';" line.

20 years agoFixed VERSION.
Ken Youens-Clark [Wed, 18 Jun 2003 23:15:11 +0000]
Fixed VERSION.

20 years agoFixed VERSION string.
Ken Youens-Clark [Wed, 18 Jun 2003 23:14:31 +0000]
Fixed VERSION string.

20 years agoFixed VERSION strings.
Ken Youens-Clark [Wed, 18 Jun 2003 23:14:00 +0000]
Fixed VERSION strings.

20 years agoAdded more TODO items.
Ken Youens-Clark [Wed, 18 Jun 2003 21:50:30 +0000]
Added more TODO items.

20 years agoThe grammar bothered me. v0.02
Ken Youens-Clark [Wed, 18 Jun 2003 17:16:25 +0000]
The grammar bothered me.