Re: [Squirrel-sql-develop] [Squirrel-sql-users] Graph- how to use?

[Gerd W. <bir...@t-...>]

Robert Manning wrote:
> On 11/14/06, Gerd Wagner <bir...@t-...> 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.
You are absolutely right. I would even try to use the refactoring Plugin from 
within a Graph. Some time ago I introduced a mechanism that allows Plugins to 
communicate with each other. I did that to use the Scrips Plugin from within the 
Graph Plugin.

One suggestion for the Refactoring Plugin: Could you allow to generate DDL 
Scripts in the SQL Editor?


Gerd