Re: SQL statements to DB Schema (dia ?)
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. > > -- > http://termisoc.org/~betty";> Betty @ termisoc.org > "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
Re: SQL statements to DB Schema (dia ?)
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. -- http://termisoc.org/~betty";> Betty @ termisoc.org "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 ?)
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. This is not the answer you are looking for ... 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
Re: SQL statements to DB Schema (dia ?)
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. > > > If GraphViz doesn't do this already - it will by the end of the day :) > 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 ?)
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 ?)
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 ?)
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 ?)
> 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 ?)
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. If GraphViz doesn't do this already - it will by the end of the day :) 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.
SQL statements to DB Schema (dia ?)
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