19 years agoAll Schema objects now have an extra attribute. Added parsing support (and
Mark Addison [Fri, 5 Nov 2004 15:03:11 +0000]
All Schema objects now have an extra attribute. Added parsing support (and
tests) for this to the SQLF XML parser.

19 years agoAdded _attributes class data to SQL::Translator::Schema::Object for sub classes
Mark Addison [Fri, 5 Nov 2004 13:19:31 +0000]
Added _attributes class data to SQL::Translator::Schema::Object for sub classes
to declare their attributes with and an init method to initialize the class from
this data.

19 years agoAdded diagnostics on fail.
Mark Addison [Fri, 5 Nov 2004 13:16:49 +0000]
Added diagnostics on fail.

19 years agoAdded SQL::Translator::Schema::Object, a base class for all the Schema
Mark Addison [Thu, 4 Nov 2004 16:29:56 +0000]
Added SQL::Translator::Schema::Object, a base class for all the Schema
objects and made them all use it.

19 years agoFixing the error "Can't use an undefined value as a HASH reference at
Ken Youens-Clark [Tue, 26 Oct 2004 00:00:41 +0000]
Fixing the error "Can't use an undefined value as a HASH reference at
/Users/kclark/Work/sqlf/sqlfairy/lib/SQL/Translator/Producer/TTSchema.pm
line 123."

19 years agothrows error if a comment is placed on a non-existent column
Chris Mungall [Sat, 23 Oct 2004 20:18:44 +0000]
throws error if a comment is placed on a non-existent column

19 years agofixed parsing of Pg COMMENT ON ... syntax
Chris Mungall [Sat, 23 Oct 2004 19:58:32 +0000]
fixed parsing of Pg COMMENT ON ... syntax

previously only recognised comments on TABLE and COLUMN
also would not recognise comment_phrases split over multiple lines

now accept all comment types; however, it does not add information
to the datamodel except for TABLE and COLUMN

accepts comments split over multiple lines

will barf if comment includes escaped singlequote ''

test 08 extended to deal with parsing comments gracefully
(does not check contents of datamodel however)

19 years agoProducer::Turnkey obsolete. now rely on TTSchema parser (see concommitant
Allen Day [Fri, 15 Oct 2004 03:52:51 +0000]
Producer::Turnkey obsolete.  now rely on TTSchema parser (see concommitant
turnkey commit).

modified TTschema to accept 'ttargs' in addition to already present 'ttfile'
so arbitrary template args can be interpolated.

added Schema::Graph unit test (!).  minimal.

introduced Log::Log4perl dependency.

modified Schema to have translator() slot to hold parent ref.  needed to
get at producer_args(), parser_args(), and _format_name() from Graph.pm

19 years agopatch for parser/producer args courtesy of darren (w/ embellishments by me)
Allen Day [Fri, 15 Oct 2004 02:23:30 +0000]
patch for parser/producer args courtesy of darren (w/ embellishments by me)

19 years agosome refactoring. moving to being able to call $schema->as_graph to do
Allen Day [Wed, 13 Oct 2004 23:14:06 +0000]
some refactoring.  moving to being able to call $schema->as_graph to do
an OM translation.

19 years agolc the template files... flipflop
Allen Day [Wed, 13 Oct 2004 22:31:59 +0000]
lc the template files... flipflop

19 years agoalmost working. there is a package name mangling problem where the
Allen Day [Wed, 13 Oct 2004 22:24:49 +0000]
almost working.  there is a package name mangling problem where the
upcasing doesn't happen properly... i think it's the lack of callback
calling in the right places, or an erroneous callback.

19 years agoFixed POD.
Ken Youens-Clark [Fri, 24 Sep 2004 14:06:46 +0000]
Fixed POD.

19 years agoFixed syntax error.
Ken Youens-Clark [Thu, 23 Sep 2004 15:08:03 +0000]
Fixed syntax error.

19 years agoModifications to the Turnkey producer to support file split in the Turnkey install...
Brian O'Connor [Wed, 22 Sep 2004 23:46:53 +0000]
Modifications to the Turnkey producer to support file split in the Turnkey install process

19 years agoOK, I really got it this time.
Ken Youens-Clark [Mon, 20 Sep 2004 20:48:19 +0000]
OK, I really got it this time.

19 years agoThat last commit wasn't very thought-out.
Ken Youens-Clark [Mon, 20 Sep 2004 20:32:18 +0000]
That last commit wasn't very thought-out.

19 years agoThe default too often was "tinyint," changed to only make it that when
Ken Youens-Clark [Mon, 20 Sep 2004 20:22:47 +0000]
The default too often was "tinyint," changed to only make it that when
necessary and default non-float number fields to "int."

19 years agoTrying to be smarter and stricter on translating FKs.
Ken Youens-Clark [Fri, 17 Sep 2004 21:54:43 +0000]
Trying to be smarter and stricter on translating FKs.

19 years agoMoved "interval" rule.
Ken Youens-Clark [Fri, 17 Sep 2004 21:53:35 +0000]
Moved "interval" rule.

19 years agoBug fix to keep FK constraints from being created twice, expanded a couple
Ken Youens-Clark [Fri, 17 Sep 2004 21:52:46 +0000]
Bug fix to keep FK constraints from being created twice, expanded a couple
of rules to handle screwy input.

19 years agoAdd Triggers
Jess Robinson [Wed, 15 Sep 2004 21:16:02 +0000]
Add Triggers

19 years agoNew column_info definition, correct nullable
Jess Robinson [Wed, 15 Sep 2004 21:13:43 +0000]
New column_info definition, correct nullable

19 years agoSome updates to tests to skip when required dependencies are missing.
Ken Youens-Clark [Mon, 13 Sep 2004 18:16:48 +0000]
Some updates to tests to skip when required dependencies are missing.

19 years agoAllow "gutter" to be set by producer arg (Markus Törnqvist). v0.06
Ken Youens-Clark [Mon, 30 Aug 2004 19:05:32 +0000]
Allow "gutter" to be set by producer arg (Markus Törnqvist).

19 years agoAllow "gutter" to be set by producer arg (Markus Törnqvis).
Ken Youens-Clark [Mon, 30 Aug 2004 19:04:59 +0000]
Allow "gutter" to be set by producer arg (Markus Törnqvis).

19 years agoFixed problems in POD.
Ken Youens-Clark [Mon, 30 Aug 2004 18:59:09 +0000]
Fixed problems in POD.

19 years agoApplying patches from Markus Törnqvis.
Ken Youens-Clark [Mon, 30 Aug 2004 18:54:58 +0000]
Applying patches from Markus Törnqvis.

19 years agoAdding Jess's DB2 DBI parser.
Ken Youens-Clark [Mon, 30 Aug 2004 18:51:00 +0000]
Adding Jess's DB2 DBI parser.

19 years agoDoc tweaks.
Mark Addison [Fri, 20 Aug 2004 11:01:48 +0000]
Doc tweaks.

19 years agoDoc tweaks
Mark Addison [Fri, 20 Aug 2004 00:58:35 +0000]
Doc tweaks

19 years agoDoc tweaks
Mark Addison [Thu, 19 Aug 2004 20:58:05 +0000]
Doc tweaks

19 years agoDoc tweaks
Mark Addison [Thu, 19 Aug 2004 20:41:32 +0000]
Doc tweaks

19 years agoDoc tweaks
Mark Addison [Thu, 19 Aug 2004 19:55:36 +0000]
Doc tweaks

19 years agoAdded collection tags for the Schemas objects (tables, views, etc)
Mark Addison [Thu, 19 Aug 2004 14:09:00 +0000]
Added collection tags for the Schemas objects (tables, views, etc)

19 years agoMove the list of methods to write as elements out into a global.
Mark Addison [Wed, 18 Aug 2004 20:27:58 +0000]
Move the list of methods to write as elements out into a global.

19 years agoDOAP for SQL::Translator
Darren Chamberlain [Fri, 13 Aug 2004 16:48:07 +0000]
DOAP for SQL::Translator

19 years agoXML test file changed
Mark Addison [Thu, 12 Aug 2004 16:43:23 +0000]
XML test file changed

19 years agoAdded "version" argument to show SQLT::VERSION.
Ken Youens-Clark [Thu, 12 Aug 2004 16:18:00 +0000]
Added "version" argument to show SQLT::VERSION.

19 years agoTake the defined field size if present.
Ken Youens-Clark [Wed, 11 Aug 2004 22:00:39 +0000]
Take the defined field size if present.

19 years agoCheck for >255 field size for all char fields (not just varchar); turn a
Ken Youens-Clark [Wed, 11 Aug 2004 21:55:34 +0000]
Check for >255 field size for all char fields (not just varchar); turn a
boolean field into an ENUM; make sure double/float fields have a precision
value (even if it's just "0").

19 years agoAdd indexes for FKs as necessary.
Ken Youens-Clark [Thu, 5 Aug 2004 21:13:03 +0000]
Add indexes for FKs as necessary.

19 years agoMake sure there's some size value for a character-based field.
Ken Youens-Clark [Thu, 5 Aug 2004 18:15:12 +0000]
Make sure there's some size value for a character-based field.

19 years agoRemoved some old code, make table type "InnoDB" if there's a FK constraint.
Ken Youens-Clark [Thu, 5 Aug 2004 15:41:46 +0000]
Removed some old code, make table type "InnoDB" if there's a FK constraint.

19 years agoChanges to the Turnkey producer to better support IE.
Brian O'Connor [Thu, 5 Aug 2004 02:05:46 +0000]
Changes to the Turnkey producer to better support IE.

19 years agoJust some cosmetic changes to the docs.
Ken Youens-Clark [Fri, 30 Jul 2004 22:04:25 +0000]
Just some cosmetic changes to the docs.

19 years agoRemoving commented-out code.
Ken Youens-Clark [Fri, 30 Jul 2004 21:56:18 +0000]
Removing commented-out code.

19 years agosp_columns on Sybase 12.5.2 (and, perhaps, earlier) needs to be passed nulls explicit...
Paul Harrington [Fri, 30 Jul 2004 16:13:52 +0000]
sp_columns on Sybase 12.5.2 (and, perhaps, earlier) needs to be passed nulls explicitly so pass in list of undefs to column_info

19 years agoFixed naming of file.
Ken Youens-Clark [Fri, 30 Jul 2004 15:34:16 +0000]
Fixed naming of file.

19 years agoUpdated.
Ken Youens-Clark [Fri, 30 Jul 2004 15:31:29 +0000]
Updated.

19 years agoChanging to use Build.PL/Module::Build.
Ken Youens-Clark [Fri, 30 Jul 2004 15:28:49 +0000]
Changing to use Build.PL/Module::Build.

19 years agoAdding new Module::Build-based build script.
Ken Youens-Clark [Fri, 30 Jul 2004 15:27:36 +0000]
Adding new Module::Build-based build script.

19 years agoCorrectly produces settings file for soap Turnkey components.
Brian O'Connor [Mon, 26 Jul 2004 20:49:34 +0000]
Correctly produces settings file for soap Turnkey components.

19 years agoFixed docs.
Ken Youens-Clark [Mon, 26 Jul 2004 13:55:51 +0000]
Fixed docs.

19 years agoFixed documentation in template.
Ken Youens-Clark [Fri, 23 Jul 2004 15:38:20 +0000]
Fixed documentation in template.

19 years agoUpdates to include special comments for Atom and Model classes to make
Brian O'Connor [Fri, 23 Jul 2004 01:11:23 +0000]
Updates to include special comments for Atom and Model classes to make
it easier to split these files as part of a Turnkey install.

19 years agoChanges to the Turnkey producer related to soap output, AutoDBI output, and comment...
Brian O'Connor [Wed, 21 Jul 2004 03:02:57 +0000]
Changes to the Turnkey producer related to soap output, AutoDBI output, and comment syntax.

19 years agoClass::MakeMethods prereq for Turnkey producer.
Allen Day [Tue, 20 Jul 2004 23:49:04 +0000]
Class::MakeMethods prereq for Turnkey producer.

19 years agoAdded 'date' to "string" types.
Ken Youens-Clark [Tue, 20 Jul 2004 17:44:43 +0000]
Added 'date' to "string" types.

19 years agoAdded "enum" to string types.
Ken Youens-Clark [Wed, 14 Jul 2004 19:37:41 +0000]
Added "enum" to string types.

19 years agoFixed break due to XML Parser now supporting field.extra
Mark Addison [Fri, 9 Jul 2004 00:51:35 +0000]
Fixed break due to XML Parser now supporting field.extra

19 years agoAdded parsing of field.extra
Mark Addison [Fri, 9 Jul 2004 00:50:47 +0000]
Added parsing of field.extra

19 years agoAllow extra to be set via constructor.
Mark Addison [Fri, 9 Jul 2004 00:46:28 +0000]
Allow extra to be set via constructor.

19 years agoAdded writing of field.extra
Mark Addison [Thu, 8 Jul 2004 23:39:38 +0000]
Added writing of field.extra

19 years agoUpdated with the new XML producer args.
Mark Addison [Thu, 8 Jul 2004 20:37:53 +0000]
Updated with the new XML producer args.

19 years agoAdded producer args to control indenting, newlines and namespace prefixing.
Mark Addison [Thu, 8 Jul 2004 20:37:26 +0000]
Added producer args to control indenting, newlines and namespace prefixing.

19 years agoAdded items about the change of XML format and additional TT based producers.
Mark Addison [Thu, 8 Jul 2004 19:52:27 +0000]
Added items about the change of XML format and additional TT based producers.

19 years agoAdded docs about the legacy format xml.
Mark Addison [Thu, 8 Jul 2004 19:34:29 +0000]
Added docs about the legacy format xml.

19 years ago*** empty log message ***
Mark Addison [Thu, 8 Jul 2004 19:33:46 +0000]
*** empty log message ***

19 years agoXML test src changed name.
Mark Addison [Thu, 8 Jul 2004 19:08:16 +0000]
XML test src changed name.

19 years agoUpdated to test the new, single format sqlf xml.
Mark Addison [Thu, 8 Jul 2004 19:07:30 +0000]
Updated to test the new, single format sqlf xml.

19 years agoUpdated to parse the new, single format sqlf xml and emit warnings when the old style...
Mark Addison [Thu, 8 Jul 2004 19:06:24 +0000]
Updated to parse the new, single format sqlf xml and emit warnings when the old style is used (but still parse it).

19 years agoUpdated to produce the new, single format sqlf xml.
Mark Addison [Thu, 8 Jul 2004 19:05:26 +0000]
Updated to produce the new, single format sqlf xml.

19 years agoDoc tweaks.
Mark Addison [Thu, 8 Jul 2004 17:29:56 +0000]
Doc tweaks.

19 years agosilence redefined warnings
Allen Day [Thu, 24 Jun 2004 00:35:36 +0000]
silence redefined warnings

19 years agoFixed problems with non-unique names.
Ken Youens-Clark [Fri, 4 Jun 2004 19:39:48 +0000]
Fixed problems with non-unique names.

20 years agoAdded experimental pre_process_schema method.
Mark Addison [Fri, 14 May 2004 03:37:37 +0000]
Added experimental pre_process_schema method.

20 years agoTweaked to use the default reading of __DATA__
Mark Addison [Fri, 14 May 2004 03:36:32 +0000]
Tweaked to use the default reading of __DATA__

20 years agoInitial stab at a section on building producers with TT::Base
Mark Addison [Fri, 14 May 2004 03:08:15 +0000]
Initial stab at a section on building producers with TT::Base

20 years agoDocumentation.
Mark Addison [Fri, 14 May 2004 00:46:32 +0000]
Documentation.

20 years agoTweaked tt_schema
Mark Addison [Fri, 14 May 2004 00:45:55 +0000]
Tweaked tt_schema

20 years agoAdded test for tt_config
Mark Addison [Thu, 13 May 2004 22:52:42 +0000]
Added test for tt_config

20 years agoAdded hook for sub classes to set Template config. Docs next...
Mark Addison [Thu, 13 May 2004 22:52:00 +0000]
Added hook for sub classes to set Template config. Docs next...

20 years agoSome changes to get tests to pass.
Ken Youens-Clark [Wed, 12 May 2004 21:33:49 +0000]
Some changes to get tests to pass.

20 years agoFixed merge.
Ken Youens-Clark [Wed, 12 May 2004 20:16:11 +0000]
Fixed merge.

20 years agoUpdates to the Turnkey class bindings, will need to be revised later when we switch...
Brian O'Connor [Sun, 25 Apr 2004 18:08:06 +0000]
Updates to the Turnkey class bindings, will need to be revised later when we switch to search on it's own handler.

20 years agoURL link corrections
Brian O'Connor [Sun, 25 Apr 2004 10:18:49 +0000]
URL link corrections

20 years agoModified the Turnkey producer to correcly output URLs. This method will need to...
Brian O'Connor [Sun, 25 Apr 2004 10:13:31 +0000]
Modified the Turnkey producer to correcly output URLs.  This method will need to be updated once we start
using more than the /db/ prefix.

20 years agoRemoved some character escape problems with the Turnkey producer.
Brian O'Connor [Sun, 25 Apr 2004 00:38:40 +0000]
Removed some character escape problems with the Turnkey producer.

20 years agoAs a quick test to see if Test::SQL::Translator really is quicker added tests
Mark Addison [Fri, 23 Apr 2004 19:41:06 +0000]
As a quick test to see if Test::SQL::Translator really is quicker added tests
for the 1st 2 tables in test scheam. 130 Ok's added in 15 mins :)

20 years agoFixed error in output.
Ken Youens-Clark [Fri, 23 Apr 2004 12:46:53 +0000]
Fixed error in output.

20 years agoAdded bit to help.
Ken Youens-Clark [Fri, 23 Apr 2004 00:44:10 +0000]
Added bit to help.

20 years agoGive higher billing for manual.
Ken Youens-Clark [Thu, 22 Apr 2004 19:59:46 +0000]
Give higher billing for manual.

20 years agoUpped version. We should release soon.
Ken Youens-Clark [Thu, 22 Apr 2004 19:57:29 +0000]
Upped version.  We should release soon.

20 years agoUpdated tests for alternate unique constraint.
Ken Youens-Clark [Thu, 22 Apr 2004 19:56:47 +0000]
Updated tests for alternate unique constraint.

20 years agoAdded alternate way to declare unique constraints.
Ken Youens-Clark [Thu, 22 Apr 2004 19:56:28 +0000]
Added alternate way to declare unique constraints.

20 years agoUpdates for dump method.
Brian O'Connor [Tue, 20 Apr 2004 02:31:14 +0000]
Updates for dump method.

20 years agoFixed bug in Data::Dumper statement
Brian O'Connor [Tue, 20 Apr 2004 02:25:56 +0000]
Fixed bug in Data::Dumper statement

20 years agoUpdated heredocs to not be interpreted.
Brian O'Connor [Tue, 20 Apr 2004 02:13:48 +0000]
Updated heredocs to not be interpreted.

20 years agoAdded dumper method.
Brian O'Connor [Tue, 20 Apr 2004 01:59:07 +0000]
Added dumper method.