Re: Graph- how to use?

On 11/15/06, LeO Welsch <leo_zen@xxxxxx> wrote:
>
> -------- Original-Nachricht --------
> Datum: Tue, 14 Nov 2006 17:33:25 -0500
> Von: "Robert Manning" <robert.m.manning@xxxxxxxxx>
> An: "Gerd Wagner" <birgit-und-gerd@xxxxxxxxxxx>
> Betreff: Re: [Squirrel-sql-users] Graph- how to use?
>
> > On 11/14/06, Gerd Wagner <birgit-und-gerd@xxxxxxxxxxx> wrote:
>
> Currently not possible, as well not in near future. A refactoring Plugin is 
> currently developed, which would provide that kind of functionallity. The 
> purpose of this plugin is for Developers of Squirrel only. The Graph would 
> provide this feature, if Constrainsts would be addable (through the 
> refactoring Plugin) in the Graph-View.

Yes, with the exception that the refactoring plugin is intended for
users of SQuirreL.

>
> MY understanding from the Graph was that it is merley for visualization and 
> not so much for adding constraints and references to the Table. And therefore 
> I am interested  to add as Visualization the logical connections.
>
> Since I have little bit different understanding about how the Graph is 
> currently used, I am interested in what is the purpose of this view? *Only* 
> to display some tables and due to some internal mechanism a relationship is 
> generated? Cause the context-menu with 'Add ... tables' does not work as 
> well. And ordering the names of a DB might be helpful, but ...
>

Sure, but as I have used it, I thought I can remember that it uses
foreign keys to render dependency lines between fields in the tables.
So, a child column which is a member of a foreign key to a parent
primary key column in a different table will be shown on the graph
when both tables are added in such a way that the child column has a
line with an arrow pointing to the parent column.  So, if you want to
have the graph plugin show relationships visually, you must - for the
foreseeable future - define foreign keys using regular SQL in
SQuirreL. Sorry if this all wasn't clear from our conversation.  If
you have any other questions, feel free to ask.

Rob

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV