Experimental feature for SQL-Plugin (Schema Tool-Window)

Hi,

I just patched some changes into SQLQueryPlugin
http://www.intellij.org/twiki/bin/view/Main/SQLQueryPlugin

The database schema is now viewable as a separate idea tool window which can float above (like the standard window) but is dockable as any other tool window if needed.

The hack is missing important features

- no update of schema view if another connection is selected in the sql-window
- initial divider location is bad
- the schema-button in the sql-window does not reflect
the state of the schema-window

What do you think of the idea?

Find attached the two patched classes



Attachment(s):
ks-sql.jar
BrowserDialogStub.java
MainPanel.java
2 comments
Comment actions Permalink

I've tested your changes and they seem to work ok. I just don't know how
to display the DB structure for the different databases. There are a
number of possible solutions:

1. Different tabs
2. Different nodes in the tree (1 node per database)
3. Dropdown list like the one in the query window (Changing the
selection in one window reflects in the other window)
4. Different tool windows

I would prefer option 3.

Thanks, Stefan

Frank Bruch wrote:

Hi,

I just patched some changes into SQLQueryPlugin
http://www.intellij.org/twiki/bin/view/Main/SQLQueryPlugin

The database schema is now viewable as a separate idea tool window which can float above (like the standard window) but is dockable as any other tool window if needed.

The hack is missing important features

- no update of schema view if another connection is selected in the sql-window
- initial divider location is bad
- the schema-button in the sql-window does not reflect
the state of the schema-window

What do you think of the idea?

Find attached the two patched classes


0
Comment actions Permalink

Thanks for answering!

Synchronizing both windows is a good idea in my opinion.
(Switching database in one affects the other window, too)

Some people could like different tabs, some could like different tool windows (compare schemas?). No one can
really like different tree nodes as in WSAD 5, can he?

Ideally it is configurable, of course, but I would prefer a combobox here, too.

(Actionally I didn't quite like the combobox in the sql-window but that is another issue - I hope to make a suggestion here soon.)

Regards
Frank Bruch

0

Please sign in to leave a comment.