Re: Graph- how to use?

-------- 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:
> > LeO Welsch wrote:
> > > Hi,
> > >
> > > I have added several tables on the Graph and now I wanna add
> >  > the relation, but the context-menu does not indicate how to do
> >  > this. The Menu-Item 'add table referenced by (no hit on FK)'
> >  > is grayed out. Is there a way to add it manually?
> >  > Or what have I done the wrong way?
> > No there is no way to change things in the database from within a Graph
> right
> > now. One day I'll implement it but not in the near future.
> >
> > Sorry
> >
> > Gerd
> >
> > P.S.: If anyone feels like doing it first. Please go ahead I'll be of
> any help I
> > can.
> 
> There is work being done at the moment on a plugin (Refactoring) whose
> goal is to make typical refactorings (such as adding a foreign key,
> among others) possible with a number of different database dialects.
> The work that is being done leverages (and extends) Hibernate's
> mechanism for generating correct SQL according to the dialect of SQL
> for the database that SQuirreL is connected to.  It will be some time
> (not even going to speculate at the moment) but
> adding/modifying/dropping constraints are definitely planned.  My
> intent here is just a little notification in case someone has decided
> to run off and implement this, that there is a framework in place to
> accomodate this functionality.  And we should probably coordinate
> efforts rather than duplicate them.
> 
> Rob


Sorry, do not wanna interfere the developers Geek-language ;) Is it right to 
summarize it the following way?

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.

Perhaps I misunderstood some things, but I hope nobody complains too much about 
this ;)

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 ...

Sorry for these questions, but the manual is not very eloquent about the Graph.

:)

LeO


-- 
Der GMX SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen! 
Ideal für Modem und ISDN: http://www.gmx.net/de/go/smartsurfer

-------------------------------------------------------------------------
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