Re: mysql statement autogenerator...

[Mike Griffin]

I have written a .NET class library (fully scriptable via java script and 
vbscript too) that serves up all of the meta data for MySql, Sql, Oracle, 
Access, DB2 and a few others.  Not just the normal meta data but all kinds 
of custom meta data that's hard to get to.  So, if you're running on a 
Microsoft machine you can do stuff like this (java script example):

==============================================

var dbMeta = new ActiveXObject("MyMeta.Root");
dbMeta.Connect("MySql", "MyConnectionString");
var columns = 
dbMeta.Databases.Item("Northwind").Tables.Item("Employees").Columns;
for (var i = 0; i < columns.Count; i++)
{
  var col = columns.Item(i);

  output.write(col.TableName);
  output.write(col.Name);
  output.write(col.PhysicalName);
  output.write(col.TypeName);  // int,varchar, whatever ...
  output.write(col.IsInPrimaryKey);
  output.write(col.IsComputed);
  output.write(col.NumericScale);
  // and on and on, ...
}
==============================================
We have meta data for views, stored procedures (the next MySql), indexes, 
foreignkeys, and so on. We also allow you to override column, view, and 
tables names, for instance, if you have a poorly named database with bad 
fields names and you want to generate a business entity from it you supply a 
xml file that maps the names (each object has a Name, and PhysicalName, Name 
will match PhysicalName unless you override it). MyMeta will even generate 
the XML file for you, you just supply the "Name" attribute next to the 
proper "PhysicalName" attribute.

It's been months and months of work and unit tested against all kinds of 
databases. If anybody is interested in a beta let me know, it's near 
completion and a real time saver, you can generate stored procedures with 
it, business objects, ui code, anything.

Mike Griffin



From: "dan orlic" To: Subject: mysql statement autogenerator... Date: Tue, 
14 Oct 2003 14:01:52 -0500

Is anyone aware of an open source project that provides a graphical 
representation of tables that can then generate a database schema in sql 
statements. Something like Posiedon auto generating java beans. Perhaps one 
should be started? ;-)

dan
_________________________________________________________________
See when your friends are online with MSN Messenger 6.0. Download it now 
FREE! http://msnmessenger-download.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]