Re: SQL statements to DB Schema (dia ?)

2001-05-31 Thread Aaron Trevena

On Wed, 30 May 2001, Leo Lapworth wrote:

 You might want to check out:
 
 Arron's Autodia - http://autodia.cuckoo.org/
 
 It's not quite at the stage I think you are after
 but I've lost track of what it can and can't do.
 Last I heard they were putting it up to be
 an candidate in the elections (actually, it's probably
 more intelligent than one of them!).
 
 Though the DB stuff might have been a conversation
 about GraphViz.. woo.. so many choices :)
 

hmm... SQL to Dia. Shouldn't be too hard to add the only issue would be
which shapes to use, I've never drawn a database scheme in Dia - anybody
care to reccomend some shapes and how they shoudl map to stuff - then I'll
code some DB handling magic into autodia.

btw - the current version of autodia (0.9) now handles c++ (if its very
simple) and perl (extracts *most* info) and has lots of lovelly commad
line options.

A.


-- 
A HREF = http://termisoc.org/~betty; Betty @ termisoc.org /A
As a youngster Fred fought sea battles on the village pond using a 
complex system of signals he devised that was later adopted by the Royal 
Navy.  (this email has nothing to do with any organisation except me)






Re: SQL statements to DB Schema (dia ?)

2001-05-31 Thread Paul Sharpe

Aaron Trevena wrote:
 
 On Wed, 30 May 2001, Leo Lapworth wrote:
 
  You might want to check out:
 
  Arron's Autodia - http://autodia.cuckoo.org/
 
  It's not quite at the stage I think you are after
  but I've lost track of what it can and can't do.
  Last I heard they were putting it up to be
  an candidate in the elections (actually, it's probably
  more intelligent than one of them!).
 
  Though the DB stuff might have been a conversation
  about GraphViz.. woo.. so many choices :)
 
 
 hmm... SQL to Dia. Shouldn't be too hard to add the only issue would be
 which shapes to use, I've never drawn a database scheme in Dia - anybody
 care to reccomend some shapes and how they shoudl map to stuff - then I'll
 code some DB handling magic into autodia.
 

Look at the ER shapes.

paul

 btw - the current version of autodia (0.9) now handles c++ (if its very
 simple) and perl (extracts *most* info) and has lots of lovelly commad
 line options.
 
 A.
 
 --
 A HREF = http://termisoc.org/~betty; Betty @ termisoc.org /A
 As a youngster Fred fought sea battles on the village pond using a
 complex system of signals he devised that was later adopted by the Royal
 Navy.  (this email has nothing to do with any organisation except me)

--
Paul Sharpe   Tel: +44 (20) 7407 5557
Miraclefish Ltd.  Fax: +44 (20) 7378 8711
Studio 12 mailto:[EMAIL PROTECTED]
37 Tanner Street  http://www.miraclefish.com/
London SE1 3LF
UNITED KINGDOM



SQL statements to DB Schema (dia ?)

2001-05-30 Thread Greg Cope

Dear All

This is not perl related, but I hope to tap your collective knowledge.

I'm involved with taking on a project started (and nearly finished) by
an Agency writen mostly in PHP and Delphi. No statements that I'm
already in trouble - thanks.

I have no DB schema, and as such could dump the SQL schema (via
mysqldump) - and I was wondering if there was a super thing that could
translate the create table stuff into a diagram I could print, and then
look at  If this worked on Linux and involved perl and Dia then it
would be fab.

Thanks for your time.

Greg





RE: SQL statements to DB Schema (dia ?)

2001-05-30 Thread Cross David - dcross

From: Greg Cope [EMAIL PROTECTED]
Sent: Wednesday, May 30, 2001 7:33 AM

 Dear All
 
 This is not perl related, but I hope to tap your collective knowledge.
 
 I'm involved with taking on a project started (and nearly finished) by
 an Agency writen mostly in PHP and Delphi. No statements that I'm
 already in trouble - thanks.
 
 I have no DB schema, and as such could dump the SQL schema (via
 mysqldump) - and I was wondering if there was a super thing that could
 translate the create table stuff into a diagram I could print, and then
 look at  If this worked on Linux and involved perl and Dia then it
 would be fab.

prediction
If GraphViz doesn't do this already - it will by the end of the day :)
/prediction

Dave...

-- 


The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged. If the reader 
of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited.  
If you have received this communication in error, please 
re-send this communication to the sender and delete the 
original message or any copy of it from your computer
system.



RE: SQL statements to DB Schema (dia ?)

2001-05-30 Thread Robert Thompson

 From: Greg Cope [mailto:[EMAIL PROTECTED]]
 
 I have no DB schema, and as such could dump the SQL schema (via
 mysqldump) - and I was wondering if there was a super thing that could
 translate the create table stuff into a diagram I could 
 print, and then
 look at  If this worked on Linux and involved perl and Dia then it
 would be fab.

Unfortunately not Linux... but a MS-Win program call Dezign (IIRC) does
this.

http://www.datanamic.com/

Rob


---
Any views expressed in this message are those of the individual sender,
except where the sender specifically states them to be the views of IBNet
Plc. 

This message contains confidential information and is intended only for the
individual named. If you are not the named addressee you should not
disseminate, distribute or copy this e-mail.  Please notify the sender
immediately by e-mail if you have received this e-mail by mistake and delete
this e-mail from your system. 

E-mail transmission cannot be guaranteed to be secure or error-free as
information could be intercepted, corrupted, lost, destroyed, arrive late or
incomplete, or contain viruses. The sender therefore does not accept
liability for any errors or omissions in the contents of this message which
arise as a result of e-mail transmission. If verification is required please
request a hard-copy version. 




Re: SQL statements to DB Schema (dia ?)

2001-05-30 Thread James Powell

I believe Visio will do this with an ODBC link to mysql...

But of course it costs...

On Wed, May 30, 2001 at 06:32:52AM +, Greg Cope wrote:
 Dear All
 
 This is not perl related, but I hope to tap your collective knowledge.
 
 I'm involved with taking on a project started (and nearly finished) by
 an Agency writen mostly in PHP and Delphi. No statements that I'm
 already in trouble - thanks.
 
 I have no DB schema, and as such could dump the SQL schema (via
 mysqldump) - and I was wondering if there was a super thing that could
 translate the create table stuff into a diagram I could print, and then
 look at  If this worked on Linux and involved perl and Dia then it
 would be fab.
 
 Thanks for your time.
 
 Greg
 



Re: SQL statements to DB Schema (dia ?)

2001-05-30 Thread Leo Lapworth

You might want to check out:

Arron's Autodia - http://autodia.cuckoo.org/

It's not quite at the stage I think you are after
but I've lost track of what it can and can't do.
Last I heard they were putting it up to be
an candidate in the elections (actually, it's probably
more intelligent than one of them!).

Though the DB stuff might have been a conversation
about GraphViz.. woo.. so many choices :)

Leo

N.B NOT starting the election thread again!

On Wed, May 30, 2001 at 06:32:52AM +, Greg Cope wrote:

 I have no DB schema, and as such could dump the SQL schema (via
 mysqldump) - and I was wondering if there was a super thing that could
 translate the create table stuff into a diagram I could print, and then
 look at  If this worked on Linux and involved perl and Dia then it
 would be fab.



Re: SQL statements to DB Schema (dia ?)

2001-05-30 Thread Greg McCarroll


so will ERwin for Windows

* James Powell ([EMAIL PROTECTED]) wrote:
 I believe Visio will do this with an ODBC link to mysql...
 
 But of course it costs...
 
 On Wed, May 30, 2001 at 06:32:52AM +, Greg Cope wrote:
  Dear All
  
  This is not perl related, but I hope to tap your collective knowledge.
  
  I'm involved with taking on a project started (and nearly finished) by
  an Agency writen mostly in PHP and Delphi. No statements that I'm
  already in trouble - thanks.
  
  I have no DB schema, and as such could dump the SQL schema (via
  mysqldump) - and I was wondering if there was a super thing that could
  translate the create table stuff into a diagram I could print, and then
  look at  If this worked on Linux and involved perl and Dia then it
  would be fab.
  
  Thanks for your time.
  
  Greg
  
-- 
Greg McCarroll  http://www.mccarroll.uklinux.net



Re: SQL statements to DB Schema (dia ?)

2001-05-30 Thread Marcel Grunauer

On Wednesday, May 30, 2001, at 10:51  AM, Cross David - dcross wrote:

 I have no DB schema, and as such could dump the SQL schema (via
 mysqldump) - and I was wondering if there was a super thing that could
 translate the create table stuff into a diagram I could print, and then
 look at  If this worked on Linux and involved perl and Dia then it
 would be fab.

 prediction
 If GraphViz doesn't do this already - it will by the end of the day :)
 /prediction

It did - for some time. GraphViz::DBI, by yours truly, does precisely
that. It relies, at this time, on a certain table/field naming
convention (but is subclassable so you can implement your own
convention). In a future version it'll be aware of constraints
(for foreign keys and such).

Marcel

--
my int ($x, $y, $z, $n); $x**$n + $y**$n = $z**$n is insoluble if $n  2;
I have discovered a truly remarkable proof which this signature is too
short to contain.  (20 Aug 2001: Pierre de Fermat's 400th birthday)



Re: SQL statements to DB Schema (dia ?)

2001-05-30 Thread Paul Makepeace

On Wed, May 30, 2001 at 06:32:52AM +, Greg Cope wrote:
 mysqldump) - and I was wondering if there was a super thing that could
 translate the create table stuff into a diagram I could print, and then
 look at  If this worked on Linux and involved perl and Dia then it
 would be fab.

obiwanThis is not the answer you are looking for/obiwan

... but Oracle Designer does exactly this and rules in so many ways I
couldn't possibly do it justice in this dial-up restricted email. I
don't think it runs on Linux (although Oracle server does).

Paul