21 years agoA better YAML producer, actually using the YAML module. Updated test
Darren Chamberlain [Wed, 8 Oct 2003 17:27:40 +0000]
A better YAML producer, actually using the YAML module.  Updated test

21 years agoAdded YAML stuff
Darren Chamberlain [Wed, 8 Oct 2003 16:35:14 +0000]
Added YAML stuff

21 years agoAdded YAML parser, producer, and basic test. All need more work!
Darren Chamberlain [Wed, 8 Oct 2003 16:33:13 +0000]
Added YAML parser, producer, and basic test.  All need more work!

21 years agoFixed a problem with POD.
Ken Youens-Clark [Wed, 8 Oct 2003 16:03:01 +0000]
Fixed a problem with POD.

21 years agoMade debugging work and it now exports its parse method.
Mark Addison [Mon, 6 Oct 2003 15:43:41 +0000]
Made debugging work and it now exports its parse method.

21 years agoChanged ends to associationEnds in the Association's spec.
Mark Addison [Mon, 6 Oct 2003 15:06:20 +0000]
Changed ends to associationEnds in the Association's spec.

21 years agoRemoved TODO comment- cos its done
Mark Addison [Mon, 6 Oct 2003 15:05:17 +0000]
Removed TODO comment- cos its done

21 years agoFixed broken otherEnd linking for assoctionEnds.
Mark Addison [Mon, 6 Oct 2003 15:03:07 +0000]
Fixed broken otherEnd linking for assoctionEnds.

21 years agoRemoved some unneeded, commented out code.
Mark Addison [Mon, 6 Oct 2003 13:29:45 +0000]
Removed some unneeded, commented out code.

21 years agoAdded multiplicity to AssociationEnds.
Mark Addison [Mon, 6 Oct 2003 13:28:36 +0000]
Added multiplicity to AssociationEnds.

21 years agoFixed serious bug in xmiDeref: was only working for tags with xmi.idref
Mark Addison [Mon, 6 Oct 2003 13:23:04 +0000]
Fixed serious bug in xmiDeref: was only working for tags with xmi.idref
attrib, tags with xmi.id blew up XPath!

21 years agoNo longer require file arg here -- let modules decide.
Ken Youens-Clark [Sat, 4 Oct 2003 01:22:46 +0000]
No longer require file arg here -- let modules decide.

21 years agoDisabling some suspect code.
Ken Youens-Clark [Sat, 4 Oct 2003 01:22:04 +0000]
Disabling some suspect code.

21 years agoLots o' refinements.
Ken Youens-Clark [Sat, 4 Oct 2003 01:21:36 +0000]
Lots o' refinements.

21 years agoDon't make up unnecessary monikers, added support for table options that
Ken Youens-Clark [Sat, 4 Oct 2003 01:21:10 +0000]
Don't make up unnecessary monikers, added support for table options that
DDL::Oracle has.

21 years agoNow parsing and adding views and triggers to schema.
Ken Youens-Clark [Sat, 4 Oct 2003 01:16:39 +0000]
Now parsing and adding views and triggers to schema.

21 years agoextract out text of stored procedures and triggers
Paul Harrington [Sat, 4 Oct 2003 00:10:00 +0000]
extract out text of stored procedures and triggers

21 years agodump out views and stored procedures
Paul Harrington [Sat, 4 Oct 2003 00:06:39 +0000]
dump out views and stored procedures

21 years agoTests for triggers.
Ken Youens-Clark [Fri, 3 Oct 2003 23:56:54 +0000]
Tests for triggers.

21 years agoNew trigger class.
Ken Youens-Clark [Fri, 3 Oct 2003 23:56:41 +0000]
New trigger class.

21 years agoAdded "add_trigger" method.
Ken Youens-Clark [Fri, 3 Oct 2003 23:56:21 +0000]
Added "add_trigger" method.

21 years agoBasic test for SQL::Translator::Shell
Darren Chamberlain [Fri, 3 Oct 2003 21:17:53 +0000]
Basic test for SQL::Translator::Shell

21 years agoCommand-line wrapper for SQL::Translator::Shell.
Darren Chamberlain [Fri, 3 Oct 2003 21:15:55 +0000]
Command-line wrapper for SQL::Translator::Shell.

21 years agoSQL::Translator::Shell - and interactive Schema browser. This is a placeholder commit.
Darren Chamberlain [Fri, 3 Oct 2003 21:13:37 +0000]
SQL::Translator::Shell - and interactive Schema browser.  This is a placeholder commit.

21 years agoAdding new Sybase entries -- should the full "use" statement be used or
Ken Youens-Clark [Fri, 3 Oct 2003 20:58:18 +0000]
Adding new Sybase entries -- should the full "use" statement be used or
should I defer to Translator->load?

21 years agoFixed syntax error.
Ken Youens-Clark [Fri, 3 Oct 2003 20:56:40 +0000]
Fixed syntax error.

21 years agoAdding Sybase parser for Paul.
Ken Youens-Clark [Fri, 3 Oct 2003 20:48:38 +0000]
Adding Sybase parser for Paul.

21 years agoSome mods.
Ken Youens-Clark [Fri, 3 Oct 2003 20:39:53 +0000]
Some mods.

21 years agoRemoved definedness check for file-based data, for the DBI-based parsers, which will...
Darren Chamberlain [Fri, 3 Oct 2003 20:17:48 +0000]
Removed definedness check for file-based data, for the DBI-based parsers, which will not pass a data or file element.

21 years agoTabs suck! Die 0x09, die!
Darren Chamberlain [Fri, 3 Oct 2003 20:09:37 +0000]
Tabs suck!  Die 0x09, die!

21 years agoFixing AUTHORS.
Ken Youens-Clark [Fri, 3 Oct 2003 19:47:19 +0000]
Fixing AUTHORS.

21 years agoAdding a MySQL/DBI parser that talks to the db for the structures.
Ken Youens-Clark [Fri, 3 Oct 2003 19:29:31 +0000]
Adding a MySQL/DBI parser that talks to the db for the structures.

21 years agoStreamlined.
Ken Youens-Clark [Fri, 3 Oct 2003 18:13:32 +0000]
Streamlined.

21 years agoAdded tagged values to DataType's
Mark Addison [Fri, 3 Oct 2003 18:07:13 +0000]
Added tagged values to DataType's

21 years agoAdded options for DBI parser.
Ken Youens-Clark [Fri, 3 Oct 2003 17:08:46 +0000]
Added options for DBI parser.

21 years agoMade dataType a proper obj instead of just a name.
Mark Addison [Fri, 3 Oct 2003 13:17:28 +0000]
Made dataType a proper obj instead of just a name.

21 years agoAdding new DBI and experimental DBI::SQLite parsers.
Ken Youens-Clark [Fri, 3 Oct 2003 00:21:41 +0000]
Adding new DBI and experimental DBI::SQLite parsers.

21 years agoNew SQLite parser.
Ken Youens-Clark [Fri, 3 Oct 2003 00:20:51 +0000]
New SQLite parser.

21 years agoAdded test for the Rational profile.
Mark Addison [Thu, 2 Oct 2003 01:41:32 +0000]
Added test for the Rational profile.
Removed product table from test DB.

21 years agoRemoved debug warning
Mark Addison [Thu, 2 Oct 2003 01:40:06 +0000]
Removed debug warning

21 years agoTidy up, as they seemed to be a bit of a mess.
Mark Addison [Wed, 1 Oct 2003 21:55:05 +0000]
Tidy up, as they seemed to be a bit of a mess.

21 years agoMoved visibility test to its own .t
Mark Addison [Wed, 1 Oct 2003 21:12:00 +0000]
Moved visibility test to its own .t

21 years agoAdded some test xmi files for rational profile (tests coming soon ;-)
Mark Addison [Wed, 1 Oct 2003 17:51:54 +0000]
Added some test xmi files for rational profile (tests coming soon ;-)

21 years agoAdded FKeys from associations
Mark Addison [Wed, 1 Oct 2003 17:47:02 +0000]
Added FKeys from associations

21 years agoAssociationEnds gets an 'otherEnd' ref added so you can navigate associations
Mark Addison [Wed, 1 Oct 2003 17:45:47 +0000]
AssociationEnds gets an 'otherEnd' ref added so you can navigate associations
from class to class easily.

21 years agoChanged debug to dump xmi model data and not just classes.
Mark Addison [Wed, 1 Oct 2003 17:17:24 +0000]
Changed debug to dump xmi model data and not just classes.

21 years agoKill size attribute if field data type is "text."
Ken Youens-Clark [Mon, 29 Sep 2003 14:55:26 +0000]
Kill size attribute if field data type is "text."

21 years agoDifferent versions of XMI now handled by sub-classes (still generating methods
Mark Addison [Mon, 29 Sep 2003 12:02:36 +0000]
Different versions of XMI now handled by sub-classes (still generating methods
from specs) with the Parser mod returning the appropriate sub class. This keeps
the specs in sperate files and allows for overrides of the generated methods for
tweaking porpoises.

21 years agoThe data, as it is being parsed, is added to $self->{model}. Anything seen before
Mark Addison [Mon, 29 Sep 2003 11:17:04 +0000]
The data, as it is being parsed, is added to $self->{model}. Anything seen before
is then looked up in here and reffed so we don't go round in circles! Allows
parser to build up self referncing data structure for the model.

Added associations for classes, linked by the ends.

21 years agoAdded comment for FKs (if necessary).
Ken Youens-Clark [Fri, 26 Sep 2003 22:54:48 +0000]
Added comment for FKs (if necessary).

21 years agoPush foreign key defs to end of file to avoid errors with referenced tables
Ken Youens-Clark [Fri, 26 Sep 2003 22:48:53 +0000]
Push foreign key defs to end of file to avoid errors with referenced tables
not existing yet.

21 years agoNo need to create constraint names if they don't already exist (and PG
Ken Youens-Clark [Fri, 26 Sep 2003 22:35:23 +0000]
No need to create constraint names if they don't already exist (and PG
might still complain about existing ones);  leave off 'Constraint "name"'
when no name is present;  remove default values for date/timestamp fields
(a real mess when moving from MySQL);  max precision for a timestamp is
"6," not "13."

21 years agoFixed "parse_list_args" to not stringify reference arguments.
Ken Youens-Clark [Fri, 26 Sep 2003 21:04:32 +0000]
Fixed "parse_list_args" to not stringify reference arguments.

21 years agoRemoved unnecessary code.
Ken Youens-Clark [Fri, 26 Sep 2003 21:04:07 +0000]
Removed unnecessary code.

21 years agoAdded some rules to better handle the output of DDL::Oracle, now saving
Ken Youens-Clark [Fri, 26 Sep 2003 21:03:28 +0000]
Added some rules to better handle the output of DDL::Oracle, now saving
table options

21 years agooops, missing }
Allen Day [Thu, 25 Sep 2003 17:29:25 +0000]
oops, missing }

21 years agofix for strange interpretation of 1liner
Allen Day [Thu, 25 Sep 2003 17:28:37 +0000]
fix for strange interpretation of 1liner

21 years agothis is pretty stable, and is ( i think ) generating usable class::dbi
Allen Day [Thu, 25 Sep 2003 01:31:28 +0000]
this is pretty stable, and is ( i think ) generating usable class::dbi
code.  still template problems for other output formats.

21 years agoMoved Rational profile code to its own mod. Added support for tagged values, so
Mark Addison [Mon, 22 Sep 2003 11:41:07 +0000]
Moved Rational profile code to its own mod. Added support for tagged values, so
we can now model the data type, size and nullability of fields using rational.
Updated the docs.

21 years agoTrying to correct header for HTML.
Ken Youens-Clark [Thu, 18 Sep 2003 19:11:45 +0000]
Trying to correct header for HTML.

21 years agoAdded lib/SQL/Translator/XMI/Parser.pm
Mark Addison [Wed, 17 Sep 2003 16:30:04 +0000]
Added lib/SQL/Translator/XMI/Parser.pm

21 years agoStarted on rational data modeling profile.
Mark Addison [Wed, 17 Sep 2003 16:27:21 +0000]
Started on rational data modeling profile.

21 years agoDoc notes on version selection and added xmi.id to specs.
Mark Addison [Tue, 16 Sep 2003 17:23:21 +0000]
Doc notes on version selection and added xmi.id to specs.

21 years agoSplit out XMI parsing to SQL::Translator::XMI::Parser. All the XPath is
Mark Addison [Tue, 16 Sep 2003 16:29:50 +0000]
Split out XMI parsing to SQL::Translator::XMI::Parser. All the XPath is
hidden in this mod so we can transparently handle XMI1.0 and XMI1.2.
Schema gen is now based on the perl data structure returned from
SQL::Translator::XMI::Parser::get_classes().

Basic XMI1.0 support.

Removed <<Table>> stereotype checks on Classes as this will be profile
specific.

21 years agoChecking for field comments now.
Ken Youens-Clark [Tue, 9 Sep 2003 16:05:24 +0000]
Checking for field comments now.

21 years agoWasn't producing field comments.
Ken Youens-Clark [Tue, 9 Sep 2003 16:05:09 +0000]
Wasn't producing field comments.

21 years agoAdded a comment for a test.
Ken Youens-Clark [Tue, 9 Sep 2003 16:04:38 +0000]
Added a comment for a test.

21 years agoAdded tests for alternate form of comments.
Ken Youens-Clark [Tue, 9 Sep 2003 15:57:55 +0000]
Added tests for alternate form of comments.

21 years agoAdded alternate form of comments "/* ... */."
Ken Youens-Clark [Tue, 9 Sep 2003 15:57:38 +0000]
Added alternate form of comments "/* ... */."

21 years agoAdded parsing of operations from the XMI. Do we have enough to do the Rational Profil...
Mark Addison [Tue, 9 Sep 2003 01:37:25 +0000]
Added parsing of operations from the XMI. Do we have enough to do the Rational Profile now?

21 years agoMore refactoring and code tidy. We now have get_attributes and
Mark Addison [Tue, 9 Sep 2003 01:00:44 +0000]
More refactoring and code tidy. We now have get_attributes and
get_stereotype.

21 years agoAllow space as part of default value.
Ken Youens-Clark [Mon, 8 Sep 2003 18:16:04 +0000]
Allow space as part of default value.

21 years agoRefactored the internals so that the XMI parsing is seperate from the
Mark Addison [Mon, 8 Sep 2003 17:10:07 +0000]
Refactored the internals so that the XMI parsing is seperate from the
Schema generation. This should make it easy to work with and extend and
is laying the ground work for making the XMI parser a seperate mod.

The Classes to build are now more directly selected using xpaths.

Added xmiVisible() xpath function.

21 years agoFixed problems in foreign key rule.
Ken Youens-Clark [Mon, 8 Sep 2003 15:09:19 +0000]
Fixed problems in foreign key rule.

21 years ago+ Added visability arg.
Mark Addison [Mon, 8 Sep 2003 12:27:29 +0000]
+ Added visability arg.
- Removed all the <UML:Diagram> ... </> stuff from the file to speed the
test up.

21 years agoadding more XMI files. these are identical models in different XMI
Allen Day [Fri, 5 Sep 2003 12:17:57 +0000]
adding more XMI files.  these are identical models in different XMI
formats (rose xmi 1.0, poseidon/argoUML 1.2).  you should be able to
produce the same data structure from both!

21 years agomoved graph generating code (except hyperedges) to Graph.pm, producer
Allen Day [Fri, 5 Sep 2003 11:25:42 +0000]
moved graph generating code (except hyperedges) to Graph.pm, producer
class is now mostly templates.

this is still not a functional producer.

21 years agoadding dg classes to represent schema. these are currently dependent on
Allen Day [Fri, 5 Sep 2003 11:21:26 +0000]
adding dg classes to represent schema.  these are currently dependent on
the schema::* classes, but i'd like them to break away at some point as
an alternate way to represent a schema.

21 years agoInitial version of XMI parser.
Mark Addison [Thu, 4 Sep 2003 15:55:48 +0000]
Initial version of XMI parser.

21 years agoPG was choking on a lot of small errors, and some of the translations didn't
Ken Youens-Clark [Thu, 4 Sep 2003 15:33:24 +0000]
PG was choking on a lot of small errors, and some of the translations didn't
seem quite right.

21 years agoTypo fix.
Darren Chamberlain [Wed, 3 Sep 2003 14:52:50 +0000]
Typo fix.

21 years agoturnkey producer still broken, will try to get it working on the plane...
Allen Day [Tue, 2 Sep 2003 00:24:07 +0000]
turnkey producer still broken, will try to get it working on the plane...

21 years agoRemoved backslash-escaping of single quotes where unnecessary, ran new
Ken Youens-Clark [Fri, 29 Aug 2003 14:54:01 +0000]
Removed backslash-escaping of single quotes where unnecessary, ran new
code through perltidy to make it match the rest of the module, fixed some
POD and cosmetic issues.

21 years agoChanged POD to match class name, added link to Turnkey project page.
Ken Youens-Clark [Fri, 29 Aug 2003 14:52:56 +0000]
Changed POD to match class name, added link to Turnkey project page.

21 years agofirming up can_link()
Allen Day [Fri, 29 Aug 2003 08:25:32 +0000]
firming up can_link()

21 years agomore functionality in Table.pm, Turnkey.pm is broken (working on it...)
Allen Day [Fri, 29 Aug 2003 08:00:51 +0000]
more functionality in Table.pm, Turnkey.pm is broken (working on it...)

21 years agomoving reusable (useful?) code into schema classes
Allen Day [Fri, 29 Aug 2003 05:38:56 +0000]
moving reusable (useful?) code into schema classes

21 years agoThe Turnkey package is based on the ClassDBI package (1.35) and includes functionalit...
Brian O'Connor [Thu, 28 Aug 2003 08:51:09 +0000]
The Turnkey package is based on the ClassDBI package (1.35) and includes functionality needed by the
Turnkey SF project.  It generates a variety of xml, dbi, and visualization classes automatically
based on the schema of the input file.

21 years agoTrying to expand to cover all args to parsers and producers; NEED HELP
Ken Youens-Clark [Wed, 27 Aug 2003 04:01:14 +0000]
Trying to expand to cover all args to parsers and producers;  NEED HELP
GETTING THE MIME TYPES RIGHT!

21 years agoThe arg is called "output_type," not "image_type."
Ken Youens-Clark [Wed, 27 Aug 2003 03:44:08 +0000]
The arg is called "output_type," not "image_type."

21 years agoAdded some Oracle datatypes so you can translate Oracle-to-Oracle; better
Ken Youens-Clark [Wed, 27 Aug 2003 02:28:21 +0000]
Added some Oracle datatypes so you can translate Oracle-to-Oracle; better
checking of default value and NULL values so as not to create a bogus
default; no need to make up a new index name if one is provided.

21 years agoAdded rule for "create index" and fine tuned "default_value" rule.
Ken Youens-Clark [Wed, 27 Aug 2003 02:26:16 +0000]
Added rule for "create index" and fine tuned "default_value" rule.

21 years agoAdded test for table comment as SQL comment.
Ken Youens-Clark [Tue, 26 Aug 2003 21:50:17 +0000]
Added test for table comment as SQL comment.

21 years agoFixed bug in comment rule.
Ken Youens-Clark [Tue, 26 Aug 2003 21:50:03 +0000]
Fixed bug in comment rule.

21 years agoFixed docs.
Ken Youens-Clark [Tue, 26 Aug 2003 21:45:40 +0000]
Fixed docs.

21 years agoFixed EXE_FILES filenames.
Ken Youens-Clark [Tue, 26 Aug 2003 21:45:23 +0000]
Fixed EXE_FILES filenames.

21 years agoNo longer calling script "sql_translator.pl."
Ken Youens-Clark [Tue, 26 Aug 2003 21:41:21 +0000]
No longer calling script "sql_translator.pl."

21 years agoAdded drop table rule, saving of table comments.
Ken Youens-Clark [Tue, 26 Aug 2003 21:38:24 +0000]
Added drop table rule, saving of table comments.

21 years agoFixed script name.
Ken Youens-Clark [Tue, 26 Aug 2003 16:48:14 +0000]
Fixed script name.

21 years agoAlias to XML::SQLFairy.
Ken Youens-Clark [Tue, 26 Aug 2003 16:26:33 +0000]
Alias to XML::SQLFairy.