[sf-perl] Testing; please ignore

Joseph Brenner doom at kzsu.stanford.edu
Wed Apr 6 23:25:11 PDT 2005


I mentioned this module I was working on at the last meeting:

  http://search.cpan.org/~doom/GraphViz-DBI-General-0.1/

GraphViz::DBI::General is an object-oriented module that provides the
capability to automatically generate graphs of database schemas
(i.e. foreign key connections between tables).

This is a subclass of GraphViz::DBI, that extends it so that: 

(1) it will work with any database with a driver that supports the
foreign_key_info method (GraphViz::DBI relies on a naming convention to
identify foreign keys)

(2) it provides a way of specifying the name of the schema you're
interested in (which makes it possible to use this with postgresql,
otherwise you get a *huge* graph dominated by pg_catalog and possibly
the information_schema, if you're using postgresql 8.0).

There's a page about it on my site, with some sample output: 

  http://obsidianrook.com/graphviz_dbi_general/

If anyone has any suggestions on writing portable tests for something 
like this, I'd really like to hear them. 



More information about the SanFrancisco-pm mailing list