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.

21 years agoUsed to be "sql_translator.cgi."
Ken Youens-Clark [Tue, 26 Aug 2003 16:25:34 +0000]
Used to be "sql_translator.cgi."

21 years agoUpdated with new bin file names.
Ken Youens-Clark [Tue, 26 Aug 2003 16:22:35 +0000]
Updated with new bin file names.

21 years agoFixed drop table rule.
Ken Youens-Clark [Tue, 26 Aug 2003 04:01:36 +0000]
Fixed drop table rule.

21 years agoAdded default of PAargs.
Ken Youens-Clark [Tue, 26 Aug 2003 03:59:46 +0000]
Added default of PAargs.

21 years agoAdded "title" arg.
Ken Youens-Clark [Tue, 26 Aug 2003 03:59:15 +0000]
Added "title" arg.

21 years agoChanges.
Ken Youens-Clark [Tue, 26 Aug 2003 03:58:29 +0000]
Changes.

21 years agoAdding new files.
Ken Youens-Clark [Tue, 26 Aug 2003 03:56:43 +0000]
Adding new files.

21 years agoFixed up POD, allow for other ways to specify db.
Ken Youens-Clark [Tue, 26 Aug 2003 03:55:33 +0000]
Fixed up POD, allow for other ways to specify db.

21 years agoMoved POD around, added all options for all parsers and non-graphical
Ken Youens-Clark [Tue, 26 Aug 2003 03:54:59 +0000]
Moved POD around, added all options for all parsers and non-graphical
producers.

21 years agoMoving files around, removing ".pl" suffixes, now all start with "sqlt."
Ken Youens-Clark [Tue, 26 Aug 2003 02:29:12 +0000]
Moving files around, removing ".pl" suffixes, now all start with "sqlt."

21 years agoNo real changes.
Ken Youens-Clark [Sun, 24 Aug 2003 15:12:25 +0000]
No real changes.

21 years agoFixing docs.
Ken Youens-Clark [Fri, 22 Aug 2003 22:51:51 +0000]
Fixing docs.

21 years agoCorrected the docs a bit (no more data structure to pass around!), but
Ken Youens-Clark [Fri, 22 Aug 2003 22:48:20 +0000]
Corrected the docs a bit (no more data structure to pass around!), but
still need to expand a bit.

21 years agoOK, I guess it's not necessary to explicitly add "META.yml" to the MANIFEST
Ken Youens-Clark [Fri, 22 Aug 2003 22:38:57 +0000]
OK, I guess it's not necessary to explicitly add "META.yml" to the MANIFEST
as this happens automatically, too.

21 years agoAdded "META.yml" as newest version of ExtUtils::MakeMaker will add this
Ken Youens-Clark [Fri, 22 Aug 2003 22:30:50 +0000]
Added "META.yml" as newest version of ExtUtils::MakeMaker will add this
on "make dist."

21 years agoOne day we'll make this the 0.03 release.
Ken Youens-Clark [Fri, 22 Aug 2003 22:26:41 +0000]
One day we'll make this the 0.03 release.

21 years agoGot rid of "SqlfXML."
Ken Youens-Clark [Fri, 22 Aug 2003 22:22:19 +0000]
Got rid of "SqlfXML."

21 years agoChanges to quit using "SqlfXML."
Ken Youens-Clark [Fri, 22 Aug 2003 22:21:52 +0000]
Changes to quit using "SqlfXML."

21 years agoAdding XML and XML-SQLFairy producers.
Ken Youens-Clark [Fri, 22 Aug 2003 22:13:35 +0000]
Adding XML and XML-SQLFairy producers.

21 years agoChanged the way "_list" works to use File::Find so it can go deeper to find
Ken Youens-Clark [Fri, 22 Aug 2003 20:35:18 +0000]
Changed the way "_list" works to use File::Find so it can go deeper to find
all the parsers and producers located in subdirectories.

21 years agoCosmetic changes.
Ken Youens-Clark [Fri, 22 Aug 2003 19:11:09 +0000]
Cosmetic changes.

21 years agoAdding old SqlfXML producer as XML/SQLFairy.
Ken Youens-Clark [Fri, 22 Aug 2003 18:01:50 +0000]
Adding old SqlfXML producer as XML/SQLFairy.

21 years agoMoving to XML/SQLFairy.pm.
Ken Youens-Clark [Fri, 22 Aug 2003 17:55:22 +0000]
Moving to XML/SQLFairy.pm.

21 years agoSmall change.
Ken Youens-Clark [Thu, 21 Aug 2003 20:27:39 +0000]
Small change.

21 years agoFixed problem with "deep recursion."
Ken Youens-Clark [Thu, 21 Aug 2003 20:27:04 +0000]
Fixed problem with "deep recursion."

21 years agoAdded link to CPAN ratings.
Ken Youens-Clark [Thu, 21 Aug 2003 18:13:30 +0000]
Added link to CPAN ratings.

21 years agoExpanded on AUTHORS, added dumping of Schema object if debugging, added
Ken Youens-Clark [Thu, 21 Aug 2003 18:12:56 +0000]
Expanded on AUTHORS, added dumping of Schema object if debugging, added
some POD.

21 years agoSome special logic to better handle check constraints (which don't have
Ken Youens-Clark [Thu, 21 Aug 2003 18:11:45 +0000]
Some special logic to better handle check constraints (which don't have
"fields"), also wasn't setting "expression" in "init," better returning of
"fields."

21 years agoSome special logic to handle check constraints.
Ken Youens-Clark [Thu, 21 Aug 2003 18:10:47 +0000]
Some special logic to handle check constraints.

21 years agoNow with check constraints!
Ken Youens-Clark [Thu, 21 Aug 2003 18:10:14 +0000]
Now with check constraints!

21 years agoWasn't adding check constraints! Fixed.
Ken Youens-Clark [Thu, 21 Aug 2003 18:09:50 +0000]
Wasn't adding check constraints!  Fixed.

21 years agoSome cosmetic changes, some stuff dealing with check constraints, make
Ken Youens-Clark [Thu, 21 Aug 2003 18:08:04 +0000]
Some cosmetic changes, some stuff dealing with check constraints, make
sure to differentiate b/w a constraint and an index.

21 years agoAdded test for check constraint.
Ken Youens-Clark [Thu, 21 Aug 2003 18:07:12 +0000]
Added test for check constraint.

21 years agoAdded tests for check constraint.
Ken Youens-Clark [Thu, 21 Aug 2003 18:05:47 +0000]
Added tests for check constraint.

21 years agoChanged default layout.
Ken Youens-Clark [Thu, 21 Aug 2003 02:52:40 +0000]
Changed default layout.

21 years agoChagned default.
Ken Youens-Clark [Thu, 21 Aug 2003 02:48:04 +0000]
Chagned default.