[TEDIA2SQL-USERS] MySQL db types and gentoo

[Justin Foell]

Hello everyone,

First and foremost thanks for the great utility.  This utility, combined
with (obviously) dia and Autodia ( http://droogs.org/autodia/ ) is a
good combo for creating DDL from diagrams and vice-versa.  After
checking out the list, I tried dbdesigner but it was a binary build on
my gentoo box and after not being able to find libmysqlclient.so I
became angered with it.  Back to the good old perl script.

Anyway, attached is a patch for 1.2.12 which allows you to specify the
table type (overriding the default) in MySQL so you can have a mix of
MyISAM, InnoDB and any of the new MySQL 5.0 engine types.  I don't know
if you're interested in adding this to your source tree or maybe
implementing the feature in a different way (it currently uses the class
stereo type to override the table type).  

Also, is someone on this list the maintainer for the tedia2sql gentoo
ebuild?  Portage has only version 1.2.8 as it's latest... would be nice
to have 1.2.12.  Thanks,

--
Justin Foell
Lead Developer
The Selling Source, Inc.
Technology Driven Marketing Solutions
http://www.SellingSource.com
Justin.Foell@...
P: 800-397-7706 ext. 2188
F: 800-391-1178
Direct P: 702-407-0707 ext. 2188
Direct F: 702-407-0711


[mysql_table_type.patch.diff]

---

--- tedia2sql 2005-05-04 14:48:22.000000000 -0700
+++ tedia2sql.hacked 2005-05-04 14:52:19.000000000 -0700
@@ -622,6 +622,8 @@
  # get the Class name
  my $className = getValueFromObject ($class, "dia:attribute", "name", "name", "string");
  if ($verbose) { print "Class NAME=$className\n"; }
+ my $tableType = getValueFromObject ($class, "dia:attribute", "name", "stereotype", "string");
+ if ($verbose) { print "Type NAME=$tableType\n"; }
  # Associations will need this associative array to understand
  # what their endpoints are connected to
  $umlClass {$id} = $className;
@@ -676,7 +678,7 @@
  }
 
  if ($verbose) { print "Creating SQL for $className as a $classType\n"; }
- genTableViewSQL ($className, $classType, $attribStrings, $operationStrings);
+ genTableViewSQL ($className, $classType, $attribStrings, $operationStrings, $tableType);
 
  return 1;
 }
@@ -756,6 +758,7 @@
  my $objectType = shift;
  my $objectAttributes = shift;
  my $objectOperations = shift;
+ my $tableType = shift;
 
  my $singleColumn;
 
@@ -803,10 +806,16 @@
  print $createFileHandle &buildTableColumns ($objectName, $objectAttributes);
  print $createFileHandle ") ";
 
- if ($opt_t eq 'innodb') {
+ if ($opt_t eq 'innodb' && $tableType) {
+ print $createFileHandle "type = $tableType ";
+ } elsif($opt_t eq 'innodb') {
  print $createFileHandle "type = InnoDB ";
  }
 
+ if($opt_t eq 'mysql' && $tableType) {
+ print $createFileHandle "type = $tableType ";
+ }
+
  if ($opt_d) {
  print $pdout &dropTablePermissions ($objectName, $objectOperations);
  print $cdout &dropTableConstraints ($objectName, $objectOperations);

---

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Ed Epstein]

On 27-Sep-05, at 7:45 AM, Justin Foell wrote:

> Hello everyone,
>
> First and foremost thanks for the great utility.  This utility,  
> combined
> with (obviously) dia and Autodia ( http://droogs.org/autodia/ ) is a
> good combo for creating DDL from diagrams and vice-versa.  After
> checking out the list, I tried dbdesigner but it was a binary build on
> my gentoo box and after not being able to find libmysqlclient.so I
> became angered with it.  Back to the good old perl script.
>
> Anyway, attached is a patch for 1.2.12 which allows you to specify the
> table type (overriding the default) in MySQL so you can have a mix of
> MyISAM, InnoDB and any of the new MySQL 5.0 engine types.  I don't  
> know
> if you're interested in adding this to your source tree or maybe
> implementing the feature in a different way (it currently uses the  
> class
> stereo type to override the table type).
>
> Also, is someone on this list the maintainer for the tedia2sql gentoo
> ebuild?  Portage has only version 1.2.8 as it's latest... would be  
> nice
> to have 1.2.12.  Thanks,

I haven't used gentoo in any serious way since May, but I remember  
that it was pretty easy to do a version bump in any ebuild just by  
editing a few lines (assuming no large changes to the program or its  
dependencies). Have you looked in the .ebuild file and just tried  
changing the version number and link to the tarball to reflect the  
new version, and then building it?

If you give that a try, don't forget to update the md5sum in the file  
list or portage will yell at you.

--Ed

> --
> Justin Foell
> Lead Developer
> The Selling Source, Inc.
> Technology Driven Marketing Solutions
> http://www.SellingSource.com
> Justin.Foell@...
> P: 800-397-7706 ext. 2188
> F: 800-391-1178
> Direct P: 702-407-0707 ext. 2188
> Direct F: 702-407-0711
>
>
> <mysql_table_type.patch.diff>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@...
> For additional commands, e-mail: users-help@...

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Martin Boegelund]

----- Original Message -----
From: "Justin Foell" <justin.foell@...>
To: users@...
Subject: [TEDIA2SQL-USERS] MySQL db types and gentoo
Date: Tue, 27 Sep 2005 07:45:29 -0700

>
> Hello everyone,
>
> First and foremost thanks for the great utility.  This utility, combined
> with (obviously) dia and Autodia ( http://droogs.org/autodia/ ) is a
> good combo for creating DDL from diagrams and vice-versa.  After
> checking out the list, I tried dbdesigner but it was a binary build on
> my gentoo box and after not being able to find libmysqlclient.so I
> became angered with it.  Back to the good old perl script.

On a side note, let me mention that DBDesigner4 is on it's way to become MySQL Workbench. A couple of alphas of Workbench have been released, unfortunately only for Windows and MacOS X, but the Linux port is in the works.
See
http://forums.mysql.com/list.php?113 and
http://forums.mysql.com/read.php?113,44592,44592#msg-44592


--
_______________________________________________
Check out the latest SMS services @ http://www.linuxmail.org
This allows you to send and receive SMS through your mailbox.

Powered by Outblaze

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Martin Gebert]

>On a side note, let me mention that DBDesigner4 is on it's way to become MySQL Workbench.
>  
>
In the meanwhile I've been porting my private MySQL InnoDB projects from
Dia/tedia2sql to Druid <http://sourceforge.net/projects/druid>, and I
like that tool. It may not be as omnipotent or complete as CASE Studio
<http://www.casestudio.com>, which we've started to use at work, but in
a distinct way it's more flexible (or should I say less centered on a
single DBMS during design?) and quite right for my usage :-) I also
tried it for SQLite DBs for a short period, but that's what we are now
using CASE Studio for, which is quite good if you're willing to spend
the money.

Martin

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...