20 years agoFixed per Tony Bowden to allow all integer fields (including LARGEINT,
Ken Youens-Clark [Tue, 16 Mar 2004 13:29:11 +0000]
Fixed per Tony Bowden to allow all integer fields (including LARGEINT,
MEDIUMINT, etc.) to be translated to "INTEGER PRIMARY KEY."

20 years agoFixed bug.
Ken Youens-Clark [Mon, 15 Mar 2004 22:47:23 +0000]
Fixed bug.

20 years agoOops!
Ken Youens-Clark [Fri, 12 Mar 2004 22:40:52 +0000]
Oops!

20 years agoRequiring latest version of XML::Writer where error was fixed.
Ken Youens-Clark [Fri, 12 Mar 2004 22:38:31 +0000]
Requiring latest version of XML::Writer where error was fixed.

20 years agoFixed a possible infinite loop problem where the primary key accessor calls itself...
Brian O'Connor [Fri, 12 Mar 2004 20:20:44 +0000]
Fixed a possible infinite loop problem where the primary key accessor calls itself in the Turnkey producer.

20 years agoFixed a problem for the Turnkey producer where the atomtemplate is not fully derefere...
Brian O'Connor [Fri, 12 Mar 2004 19:04:34 +0000]
Fixed a problem for the Turnkey producer where the atomtemplate is not fully dereferencing the hash containing the field data.

20 years agoSome editing to make "make test" happy.
Ken Youens-Clark [Fri, 12 Mar 2004 01:58:01 +0000]
Some editing to make "make test" happy.

20 years agoUsed code found http://www.mail-archive.com/perl-documentation@perl.org/msg00380...
Ken Youens-Clark [Fri, 12 Mar 2004 01:48:49 +0000]
Used code found mail-archive.com/perl-documentation@perl.org/msg00380.html to fix reading of STDERR (?).

20 years agoUpdated to match new YAML output.
Ken Youens-Clark [Fri, 12 Mar 2004 01:21:10 +0000]
Updated to match new YAML output.

20 years agoAdd test for closing file.
Ken Youens-Clark [Thu, 11 Mar 2004 19:29:53 +0000]
Add test for closing file.

20 years agoAdded tests for Dumper producer.
Ken Youens-Clark [Thu, 11 Mar 2004 19:14:19 +0000]
Added tests for Dumper producer.

20 years agoReadding, at kyc's request.
Darren Chamberlain [Thu, 11 Mar 2004 18:12:01 +0000]
Readding, at kyc's request.

20 years agoAdded "takelike" option.
Ken Youens-Clark [Thu, 11 Mar 2004 17:14:31 +0000]
Added "takelike" option.

20 years agoAdding test for Dumper producer.
Ken Youens-Clark [Thu, 11 Mar 2004 17:13:27 +0000]
Adding test for Dumper producer.

20 years agoMoving to test module not script.
Ken Youens-Clark [Thu, 11 Mar 2004 17:05:34 +0000]
Moving to test module not script.

20 years agoRemoved "sort" as it puts the tables in a different order than they appear in
Ken Youens-Clark [Wed, 10 Mar 2004 22:52:17 +0000]
Removed "sort" as it puts the tables in a different order than they appear in
the body.

20 years agoSome fixes.
Ken Youens-Clark [Tue, 9 Mar 2004 19:35:40 +0000]
Some fixes.

20 years agoChanging to use new Producer.
Ken Youens-Clark [Tue, 9 Mar 2004 19:33:20 +0000]
Changing to use new Producer.

20 years agoSerializing translator options.
Ken Youens-Clark [Tue, 9 Mar 2004 19:19:49 +0000]
Serializing translator options.

20 years agoGetting translator options.
Ken Youens-Clark [Tue, 9 Mar 2004 19:19:21 +0000]
Getting translator options.

20 years agoFixed indentation.
Ken Youens-Clark [Tue, 9 Mar 2004 19:15:31 +0000]
Fixed indentation.

20 years agoAdding a producer to replicate (and extend) what was being done in the
Ken Youens-Clark [Tue, 9 Mar 2004 19:14:42 +0000]
Adding a producer to replicate (and extend) what was being done in the
"sqlt-dumper" script -- creates a Perl script from a schema for dumping
a database.

20 years agoAdded options for new Dumper producer.
Ken Youens-Clark [Tue, 9 Mar 2004 19:11:30 +0000]
Added options for new Dumper producer.

20 years agono warnings for redefined methods
Allen Day [Tue, 9 Mar 2004 04:16:44 +0000]
no warnings for redefined methods

20 years agoFixed bug in script which didn't actually escape single ticks in string vals.
Ken Youens-Clark [Mon, 8 Mar 2004 21:03:18 +0000]
Fixed bug in script which didn't actually escape single ticks in string vals.

20 years agoAdded lib/Test/SQL/Translator.pm
Mark Addison [Fri, 5 Mar 2004 12:13:38 +0000]
Added lib/Test/SQL/Translator.pm

20 years agoRemoved unused Test::Exception
Mark Addison [Fri, 5 Mar 2004 12:12:33 +0000]
Removed unused Test::Exception

20 years agoRemoved 01test.t
Darren Chamberlain [Thu, 4 Mar 2004 14:45:08 +0000]
Removed 01test.t

20 years agoUpdate tests to use maybe_plan.
Darren Chamberlain [Thu, 4 Mar 2004 14:43:43 +0000]
Update tests to use maybe_plan.

20 years agoAdded maybe_plan function.
Darren Chamberlain [Thu, 4 Mar 2004 14:41:49 +0000]
Added maybe_plan function.

20 years agoWill someone just frickin' fix XML::Writer already?
Darren Chamberlain [Thu, 4 Mar 2004 14:39:46 +0000]
Will someone just frickin' fix XML::Writer already?

20 years agoPOD update.
Darren Chamberlain [Thu, 4 Mar 2004 14:39:15 +0000]
POD update.

20 years agoMake SIGN conditional based on MakeMaker version.
Darren Chamberlain [Thu, 4 Mar 2004 14:38:49 +0000]
Make SIGN conditional based on MakeMaker version.

20 years agoRequiring a recent version of Spreadsheet::ParseExcel as an earlier version
Ken Youens-Clark [Wed, 3 Mar 2004 17:44:49 +0000]
Requiring a recent version of Spreadsheet::ParseExcel as an earlier version
makes the test fail.

20 years agoUpdated with comment tests.
Ken Youens-Clark [Mon, 1 Mar 2004 17:41:20 +0000]
Updated with comment tests.

20 years agoModified comment rules.
Ken Youens-Clark [Mon, 1 Mar 2004 17:39:22 +0000]
Modified comment rules.

20 years agoAdded Todo
Mark Addison [Sun, 29 Feb 2004 20:32:39 +0000]
Added Todo

20 years agoFixed test count.
Mark Addison [Sun, 29 Feb 2004 20:29:16 +0000]
Fixed test count.

20 years agoNow uses Test::SQL::Translator
Mark Addison [Sun, 29 Feb 2004 20:11:53 +0000]
Now uses Test::SQL::Translator

20 years agoNow uses schema_ok
Mark Addison [Sun, 29 Feb 2004 20:11:19 +0000]
Now uses schema_ok

20 years agoAdded schema_ok. Some tweaks to the test output.
Mark Addison [Sun, 29 Feb 2004 20:10:35 +0000]
Added schema_ok. Some tweaks to the test output.

20 years agoUses Test::SQL::Translator.pm
Mark Addison [Sun, 29 Feb 2004 18:27:23 +0000]
Uses Test::SQL::Translator.pm

20 years agoTest::More Schema testing.
Mark Addison [Sun, 29 Feb 2004 18:26:53 +0000]
Test::More Schema testing.

20 years agoFixed so they test for empty list reference_fields and not the old undef return.
Mark Addison [Sun, 29 Feb 2004 16:07:34 +0000]
Fixed so they test for empty list reference_fields and not the old undef return.

20 years agoreference_fields now returns an empty list (or array ref) for constraints that
Mark Addison [Sun, 29 Feb 2004 16:05:31 +0000]
reference_fields now returns an empty list (or array ref) for constraints that
don't have reference fields e.g. UNIQUE. Was returning an undef before.

Doc tweaks.

20 years agoAdded blibdirs, which recent MakeMakers create.
Darren Chamberlain [Fri, 27 Feb 2004 21:03:46 +0000]
Added blibdirs, which recent MakeMakers create.

20 years agoApparently it's unnecessary for me to put the SIG in the MANIFEST as it's
Ken Youens-Clark [Fri, 27 Feb 2004 20:42:35 +0000]
Apparently it's unnecessary for me to put the SIG in the MANIFEST as it's
added automatically.

20 years agoAdding SIGNATURE file.
Ken Youens-Clark [Fri, 27 Feb 2004 20:40:03 +0000]
Adding SIGNATURE file.

20 years agoAdding SIGNATURE.
Ken Youens-Clark [Fri, 27 Feb 2004 20:39:36 +0000]
Adding SIGNATURE.

20 years agoAdded "SIGN" option.
Ken Youens-Clark [Fri, 27 Feb 2004 20:38:06 +0000]
Added "SIGN" option.

20 years agoFixed conflicts.
Ken Youens-Clark [Fri, 27 Feb 2004 19:05:45 +0000]
Fixed conflicts.

20 years agoUpdated with what I can think has changed.
Ken Youens-Clark [Fri, 27 Feb 2004 18:48:04 +0000]
Updated with what I can think has changed.

20 years agoSmall change to make installation easier.
Ken Youens-Clark [Fri, 27 Feb 2004 18:46:35 +0000]
Small change to make installation easier.

20 years agoThe manual isn't in a state to send out.
Ken Youens-Clark [Fri, 27 Feb 2004 18:44:30 +0000]
The manual isn't in a state to send out.

20 years agoNow installing sqlt-diff.
Ken Youens-Clark [Fri, 27 Feb 2004 18:38:07 +0000]
Now installing sqlt-diff.

20 years agoUpdated to match new output; also had to remove "close STDERR;" to get working.
Ken Youens-Clark [Fri, 27 Feb 2004 18:37:34 +0000]
Updated to match new output;  also had to remove "close STDERR;" to get working.

20 years agoSome bug fixes, better formatting when no field size is applicable.
Ken Youens-Clark [Fri, 27 Feb 2004 18:26:38 +0000]
Some bug fixes, better formatting when no field size is applicable.

20 years agoAdding another data file for sqlt-diff test.
Ken Youens-Clark [Fri, 27 Feb 2004 18:21:56 +0000]
Adding another data file for sqlt-diff test.

20 years agoChanged test to match output.
Ken Youens-Clark [Fri, 27 Feb 2004 18:05:05 +0000]
Changed test to match output.

20 years agoIntegrate Dave Cash's changes.
Darren Chamberlain [Fri, 20 Feb 2004 02:41:47 +0000]
Integrate Dave Cash's changes.

20 years agoJust the fairy.
Darren Chamberlain [Fri, 20 Feb 2004 00:36:07 +0000]
Just the fairy.

20 years agoRemove all those subroutine redefined warnings.
Darren Chamberlain [Fri, 20 Feb 2004 00:32:35 +0000]
Remove all those subroutine redefined warnings.

20 years agoMore TODOs
Darren Chamberlain [Thu, 19 Feb 2004 23:30:02 +0000]
More TODOs

20 years agoReverse order of the Changes file, so that recent Changes are at the top.
Darren Chamberlain [Thu, 19 Feb 2004 23:28:33 +0000]
Reverse order of the Changes file, so that recent Changes are at the top.

20 years agoadd file extension
Allen Day [Tue, 17 Feb 2004 08:40:18 +0000]
add file extension

20 years agoMisplaced semi.
Ken Youens-Clark [Wed, 11 Feb 2004 21:54:39 +0000]
Misplaced semi.

20 years agoUpped $VERSION to 0.05, created a "version" sub to easily get this.
Ken Youens-Clark [Wed, 11 Feb 2004 21:37:11 +0000]
Upped $VERSION to 0.05, created a "version" sub to easily get this.

20 years agoAdded rules (REM, prompt) to help parse output of DDL::Oracle; changed
Ken Youens-Clark [Wed, 11 Feb 2004 21:36:00 +0000]
Added rules (REM, prompt) to help parse output of DDL::Oracle; changed
top-level parse rule to return elements keys in hash rather than just the
tables;  separate how "CREATE INDEX" statements get added to the tables so that
one that references a table for which no "CREATE TABLE" statement exists
doesn't accidentally make the parser think there's a table (that has no fields,
etc.).

20 years agoApplied patch to pass new options to producer.
Ken Youens-Clark [Wed, 11 Feb 2004 21:32:25 +0000]
Applied patch to pass new options to producer.

20 years agoAdded some debugging comments.
Ken Youens-Clark [Wed, 11 Feb 2004 21:31:45 +0000]
Added some debugging comments.

20 years agoFixing up new options for showing data types, etc.
Ken Youens-Clark [Wed, 11 Feb 2004 21:31:03 +0000]
Fixing up new options for showing data types, etc.

20 years agoPushed field attributes to after datatype/size to make consistent with
Ken Youens-Clark [Wed, 11 Feb 2004 21:30:19 +0000]
Pushed field attributes to after datatype/size to make consistent with
GraphViz producer (also lined them up); changed watermark to use main
package version instead of producer version.

20 years agoMinor bug fixes ("top" and table links didn't work), added borders to tables,
Ken Youens-Clark [Wed, 11 Feb 2004 21:28:53 +0000]
Minor bug fixes ("top" and table links didn't work), added borders to tables,
added "constraints" table (for any but PK constraints).

20 years agotemplate files shall be lowercase
Allen Day [Tue, 10 Feb 2004 06:39:10 +0000]
template files shall be lowercase

20 years agoreturn hashref instead of hash
Allen Day [Tue, 10 Feb 2004 06:31:43 +0000]
return hashref instead of hash

20 years agoindividual tables now returned as a hash of separate tt2 templates, keyed
Allen Day [Tue, 10 Feb 2004 06:30:06 +0000]
individual tables now returned as a hash of separate tt2 templates, keyed
by table name.

20 years agoFixed copyrights.
Ken Youens-Clark [Mon, 9 Feb 2004 23:04:26 +0000]
Fixed copyrights.

20 years agoFixed copyrights.
Ken Youens-Clark [Mon, 9 Feb 2004 22:23:40 +0000]
Fixed copyrights.

20 years agoFixed copyrights.
Ken Youens-Clark [Mon, 9 Feb 2004 22:15:15 +0000]
Fixed copyrights.

20 years agoFixed copyright.
Ken Youens-Clark [Fri, 6 Feb 2004 17:51:26 +0000]
Fixed copyright.

20 years agoUpdated.
Ken Youens-Clark [Fri, 6 Feb 2004 17:50:03 +0000]
Updated.

20 years agoFixed copyrights.
Ken Youens-Clark [Fri, 6 Feb 2004 17:48:16 +0000]
Fixed copyrights.

20 years agoChanged copyright.
Ken Youens-Clark [Fri, 6 Feb 2004 17:45:53 +0000]
Changed copyright.

20 years agoAdded Dave Cash for his work on GraphViz producer.
Ken Youens-Clark [Fri, 6 Feb 2004 17:44:58 +0000]
Added Dave Cash for his work on GraphViz producer.

20 years agoUpdated.
Ken Youens-Clark [Fri, 6 Feb 2004 17:43:51 +0000]
Updated.

20 years agosqlt-diff is now functional enough to include.
Ken Youens-Clark [Fri, 6 Feb 2004 17:39:39 +0000]
sqlt-diff is now functional enough to include.

20 years agoChanged to print out schema mutation statements (CREATE/ALTER/DROP) instead
Ken Youens-Clark [Fri, 6 Feb 2004 17:38:56 +0000]
Changed to print out schema mutation statements (CREATE/ALTER/DROP) instead
of just English descriptions.  Also made it a one-way comparison (how to
change schema1 into schema2) rather than two-way comparison (just a description
of what's different between the two).

20 years agoAdded manual.
Ken Youens-Clark [Thu, 5 Feb 2004 15:57:34 +0000]
Added manual.

20 years agoBeing case-insensitive on datatype translations.
Ken Youens-Clark [Wed, 4 Feb 2004 21:09:54 +0000]
Being case-insensitive on datatype translations.

20 years agoAdded reference to manual, fixed copyright.
Ken Youens-Clark [Wed, 4 Feb 2004 17:51:00 +0000]
Added reference to manual, fixed copyright.

20 years agoOutline for manual.
Ken Youens-Clark [Wed, 4 Feb 2004 17:46:33 +0000]
Outline for manual.

20 years agoMore TODO items.
Darren Chamberlain [Wed, 4 Feb 2004 17:36:57 +0000]
More TODO items.

20 years agoRobustify the tests a little.
Darren Chamberlain [Wed, 4 Feb 2004 17:34:27 +0000]
Robustify the tests a little.

20 years agoFixed 'useless use of constant in void context' warning.
Darren Chamberlain [Wed, 4 Feb 2004 17:32:42 +0000]
Fixed 'useless use of constant in void context' warning.

20 years agoFixed test.
Ken Youens-Clark [Wed, 4 Feb 2004 17:27:06 +0000]
Fixed test.

20 years agoChanged index creation to better handle output of DDL::Oracle.
Ken Youens-Clark [Tue, 3 Feb 2004 22:09:56 +0000]
Changed index creation to better handle output of DDL::Oracle.

20 years agoStifle undefined variable warnings.
Darren Chamberlain [Tue, 3 Feb 2004 13:27:21 +0000]
Stifle undefined variable warnings.

20 years agoadded credit for dave cash
Allen Day [Mon, 2 Feb 2004 20:30:35 +0000]
added credit for dave cash

20 years agomerging patch from Dave Cash. description:
Allen Day [Mon, 2 Feb 2004 20:28:26 +0000]
merging patch from Dave Cash.  description:

The new options are all boolean.  If set to true, each does the
following:

show_datatypes
display the datatype immediately after each field name

show_sizes
display the size of the field if the field is a CHAR, VARCHAR or
VARCHAR2 field

show_constraints
display the primary key [PK], foreign key [FK] and unique [U]
constraints on each field after the name (and optionally the
datatype) of each field

20 years agoOrder of schema objects properties in XML changed to something more sensible
Mark Addison [Thu, 29 Jan 2004 21:49:19 +0000]
Order of schema objects properties in XML changed to something more sensible
for hand hacking of the xml files, instead of sort order.