|
From: Gerd W. <bir...@t-...> - 2006-11-14 23:05:38
|
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 |
