pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedFunction Dependency
3+ messages / 3 participants
[nested] [flat]
* Function Dependency
@ 2006-02-02 06:24 Padam J Singh <padam.singh@inventum.cc>
2006-02-06 02:18 ` Re: Function Dependency Tony Wasson <ajwasson@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Padam J Singh @ 2006-02-02 06:24 UTC (permalink / raw)
To: pgsql-sql
This is a multi-part message in MIME format.
--------------030008020104050005080209
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000066">
<font size="-1"><font face="Helvetica, Arial, sans-serif">Hello,<br>
<br>
I am maintaining an application that has over 400 procedures and
functions written in plsql, and around 100 tables.<br>
I want to generate a function dependency chart to depict the following:<br>
<br>
1. Inter function/procedure dependencies<br>
2. function-tables dependencies<br>
3. function-sequences depencies<br>
<br>
Is there a standard method of doing this? <br>
<br>
Thanks in advance,<br>
Padam.<br>
</font></font>
</body>
</html>
--------------030008020104050005080209
Content-Type: text/x-vcard; charset=utf-8;
name="padam.singh.vcf"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
filename="padam.singh.vcf"
begin:vcard
fn:Padam Singh
n:Singh;Padam
org:Inventum Technologies Pvt. Ltd.;Engineering
adr:SDA Commercial Complex;;C-17;New Delhi;Delhi;110016;India
email;internet:padam.singh@inventum.cc
title:Sr. Solutions Architect
tel;work:+91-11-55650222
tel;fax:+91-11-26518800
tel;cell:+91-9810146640
x-mozilla-html:TRUE
url:http://www.inventum.cc
version:2.1
end:vcard
--------------030008020104050005080209--
Attachments:
padam.singh.vcf (text/x-vcard, 361B) download
begin:vcard
fn:Padam Singh
n:Singh;Padam
org:Inventum Technologies Pvt. Ltd.;Engineering
adr:SDA Commercial Complex;;C-17;New Delhi;Delhi;110016;India
email;internet:padam.singh@inventum.cc
title:Sr. Solutions Architect
tel;work:+91-11-55650222
tel;fax:+91-11-26518800
tel;cell:+91-9810146640
x-mozilla-html:TRUE
url:http://www.inventum.cc
version:2.1
end:vcard
* Re: Function Dependency
2006-02-02 06:24 Function Dependency Padam J Singh <padam.singh@inventum.cc>
@ 2006-02-06 02:18 ` Tony Wasson <ajwasson@gmail.com>
2006-02-06 11:29 ` Re: Function Dependency Karsten Hilbert <Karsten.Hilbert@gmx.net>
0 siblings, 1 reply; 3+ messages in thread
From: Tony Wasson @ 2006-02-06 02:18 UTC (permalink / raw)
To: Padam J Singh <padam.singh@inventum.cc>; +Cc: pgsql-sql
On 2/1/06, Padam J Singh <padam.singh@inventum.cc> wrote:
> Hello,
>
> I am maintaining an application that has over 400 procedures and functions
> written in plsql, and around 100 tables.
> I want to generate a function dependency chart to depict the following:
>
> 1. Inter function/procedure dependencies
> 2. function-tables dependencies
> 3. function-sequences depencies
>
> Is there a standard method of doing this?
>
> Thanks in advance,
> Padam.
I too would be interested in a standardized tool to do this. I had a
similar situation and I ended up writing a perl script to parse my SQL
and make a graphviz dot file. I then used graphviz to make a function
dependency chart. I can't promise it would catch every single case,
but I can provide you with the code if you wish to give it a whirl.
Tony Wasson
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Function Dependency
2006-02-02 06:24 Function Dependency Padam J Singh <padam.singh@inventum.cc>
2006-02-06 02:18 ` Re: Function Dependency Tony Wasson <ajwasson@gmail.com>
@ 2006-02-06 11:29 ` Karsten Hilbert <Karsten.Hilbert@gmx.net>
0 siblings, 0 replies; 3+ messages in thread
From: Karsten Hilbert @ 2006-02-06 11:29 UTC (permalink / raw)
To: pgsql-sql; +Cc: Rod Taylor <pg@rbt.ca>
On Sun, Feb 05, 2006 at 07:18:33PM -0700, Tony Wasson wrote:
> > I am maintaining an application that has over 400 procedures and functions
> > written in plsql, and around 100 tables.
> > I want to generate a function dependency chart to depict the following:
> >
> > 1. Inter function/procedure dependencies
> > 2. function-tables dependencies
> > 3. function-sequences depencies
...
> I too would be interested in a standardized tool to do this. I had a
> similar situation and I ended up writing a perl script to parse my SQL
> and make a graphviz dot file. I then used graphviz to make a function
> dependency chart. I can't promise it would catch every single case,
> but I can provide you with the code if you wish to give it a whirl.
Tony,
what do you think about sending a copy of this code to the
pg_autodoc author ? I'm sure they'd be interested to have a
look at this.
http://www.rbt.ca/autodoc/index.html
I have CC'ed this to the author.
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2006-02-06 11:29 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-02-02 06:24 Function Dependency Padam J Singh <padam.singh@inventum.cc>
2006-02-06 02:18 ` Tony Wasson <ajwasson@gmail.com>
2006-02-06 11:29 ` Karsten Hilbert <Karsten.Hilbert@gmx.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox