squirrel-sql-develop Mailing List for SQuirreL SQL Client (Page 32)

Would whomever (Colin?) is working on 
net.sourceforge.squirrel_sql.client.session.mainpanel.SQLExecutionInfo.java 
and net.sourceforge.squirrel_sql.client.session.ISession.java in sql12 
please commit the latest versions to CVS, if they're ready?  The first 
file doesn't exist, and the second doesn't contain the method 
getSQLPanelAPI.

Thanks a bunch... Maury.

Hello,

Yes this functionality is available in CVS right now. Just get the
latest cvs code and compile to get the functionality.=20

Just a few issues with compiling:
1) Make sure that you uncomment the compilation of the oracle plugin
from the build.xml.
2) You have to delete the SQLExecuterTask class that gives a compilation
warning inorder to successfully compile. Just try to compile you will
see what I mean.

Any problems just holler.

Jason

-----Original Message-----
From: squ...@li...
[mailto:squ...@li...] On Behalf Of
squ...@an...
Sent: Thursday, 16 September 2004 5:54 AM
To: squ...@li...
Subject: [Squirrel-sql-develop] EXPLAIN PLAN plugin for Oracle

A while back someone mentioned interest in a plug-in that would support=20
getting and displaying the query plan for a query from Oracle.  I also
would=20
be interested in such a plug-in; if nobody else is working on one, I'd=20
probably be interested in developing such a plug-in myself.


-------------------------------------------------------
This SF.Net email is sponsored by: thawte's Crypto Challenge Vl
Crack the code and win a Sony DCRHC40 MiniDV Digital Handycam
Camcorder. More prizes in the weekly Lunch Hour Challenge.
Sign up NOW http://ad.doubleclick.net/clk;10740251;10262165;m
_______________________________________________
Squirrel-sql-develop mailing list
Squ...@li...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop

---------------------------------------------------------------------------=
-----------------------------------------
This e-mail (including attachments) is confidential information of Australi=
an Submarine Corporation Pty Limited (ASC).  It may also be legally privile=
ged.  Unauthorised use and disclosure is prohibited.  ASC is not taken to h=
ave waived confidentiality or privilege if this e-mail was sent to you in e=
rror. If you have received it in error, please notify the sender promptly. =
 While ASC takes steps to identify and eliminate viruses, it cannot confirm=
 that this e-mail is free from them.  You should scan this e-mail for virus=
es before it is used.  The statements in this e-mail are those of the sende=
r only, unless specifically stated to be those of ASC by someone with autho=
rity to do so.

> -----Original Message-----
> From: squ...@an... [mailto:squ...@an...]
> Sent: Thursday, September 16, 2004 6:24 AM
> To: squ...@li...
> Subject: [Squirrel-sql-develop] EXPLAIN PLAN plugin for Oracle
> 
> 
> A while back someone mentioned interest in a plug-in that 
> would support 
> getting and displaying the query plan for a query from 
> Oracle.  I also would 
> be interested in such a plug-in; if nobody else is working on 
> one, I'd 
> probably be interested in developing such a plug-in myself.

Jason Height (subscribed to this list) is currently working on this.

All yours

> -----Original Message-----
> From: Neil Gordon [mailto:ne...@as...]
> Sent: Friday, September 10, 2004 1:43 AM
> To: Colin Bell
> Cc: squ...@li...
> Subject: [Squirrel-sql-develop] Compiere Plugin
> 
> 
> Colin,
> 
> Have written a little plugin which shows Compiere (see
> http://www.compiere.org) meta-info on the table info section.
> 
> Any chance of reserving the namespace 'compiereplugin?' 
> 
> (package net.sourceforge.squirrel_sql.plugins.compiereplugin)
> 
> Thanks Neil
> 
> 
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by BEA Weblogic Workshop
> FREE Java Enterprise J2EE developer tools!
> Get your free copy of BEA WebLogic Workshop 8.1 today.
> http://ads.osdn.com/?ad_id=5047&alloc_id=10808&op=click
> _______________________________________________
> Squirrel-sql-develop mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
> 

A while back someone mentioned interest in a plug-in that would support 
getting and displaying the query plan for a query from Oracle.  I also would 
be interested in such a plug-in; if nobody else is working on one, I'd 
probably be interested in developing such a plug-in myself.

Colin,

Have written a little plugin which shows Compiere (see
http://www.compiere.org) meta-info on the table info section.

Any chance of reserving the namespace 'compiereplugin?' 

(package net.sourceforge.squirrel_sql.plugins.compiereplugin)

Thanks Neil

Thanks mate, I should get it done over the weekend.

-- 
Colin Bell
http://www.squirrelsql.org

Done!

Jason

-----Original Message-----
From: squ...@li...
[mailto:squ...@li...] On Behalf Of
Colin Bell
Sent: Tuesday, 7 September 2004 10:02 PM
To: squ...@li...
Subject: Re: [Squirrel-sql-develop] [PATCH] Allows plugins to override
default object tree expanders

Hi Jason,

On Mon, Sep 06, 2004 at 02:00:20PM +0930, Height, Jason wrote:
=20
> Please find attached a patch that allows a plugin to override the
> default object tree expanders.=20

Could you redo this patch using ISessionPlugin and DefaultSessionPlugin
rather than IPlugin and DefaultPlugin? IPlugin shouldn't have any
session related behaviour.

Thanks

--=20
Colin Bell
http://www.squirrelsql.org


-------------------------------------------------------
This SF.Net email is sponsored by BEA Weblogic Workshop
FREE Java Enterprise J2EE developer tools!
Get your free copy of BEA WebLogic Workshop 8.1 today.
http://ads.osdn.com/?ad_idP47&alloc_id=10808&op=3Dclick
_______________________________________________
Squirrel-sql-develop mailing list
Squ...@li...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop

---------------------------------------------------------------------------=
-----------------------------------------
This e-mail (including attachments) is confidential information of Australi=
an Submarine Corporation Pty Limited (ASC).  It may also be legally privile=
ged.  Unauthorised use and disclosure is prohibited.  ASC is not taken to h=
ave waived confidentiality or privilege if this e-mail was sent to you in e=
rror. If you have received it in error, please notify the sender promptly. =
 While ASC takes steps to identify and eliminate viruses, it cannot confirm=
 that this e-mail is free from them.  You should scan this e-mail for virus=
es before it is used.  The statements in this e-mail are those of the sende=
r only, unless specifically stated to be those of ASC by someone with autho=
rity to do so.

Hi Jason,

On Mon, Sep 06, 2004 at 02:00:20PM +0930, Height, Jason wrote:
 
> Please find attached a patch that allows a plugin to override the
> default object tree expanders. 

Could you redo this patch using ISessionPlugin and DefaultSessionPlugin
rather than IPlugin and DefaultPlugin? IPlugin shouldn't have any
session related behaviour.

Thanks

-- 
Colin Bell
http://www.squirrelsql.org

Hi Neil,

On Wed, Sep 01, 2004 at 08:29:32AM +0200, Neil Gordon wrote:
> Nice to have feature,
> 
> On the SQL-Output (sql results) it would be nice to have a 'close all'
> button which closes all the resultsets. Or like with Eclipse, 'Close
> all', 'Close others'
 
Could you please add an RFE for this. That way I won't forget abut it.
http://sourceforge.net/tracker/?atid=393417&group_id=28383

-- 
Colin Bell
http://www.squirrelsql.org

Nice to have feature,

On the SQL-Output (sql results) it would be nice to have a 'close all'
button which closes all the resultsets. Or like with Eclipse, 'Close
all', 'Close others'

Hi Neil,

> -----Original Message-----
> From: Neil Gordon [mailto:ne...@as...]
> Sent: Monday, 30 August 2004 4:13 PM
> To: squ...@li...
> Subject: [Squirrel-sql-develop] Objects/Tables

> On the objects/table screen (where we see the tabs Info/Content/Row
> Count/etc..) is it possible to add a new tab from within a plugin?
> 
> Would also need to build the right-click menu at the same location.

Examples of the APIs you want are:

IObjectTreeAPI.addDetailTab(DatabaseObjectType.TABLE, new ShowColumnsTab());
IObjectTreeAPI.addToPopup(DatabaseObjectType.TABLE, createMysqlTableMenu());

You can see an example of this in the MySQL plugin

http://cvs.sourceforge.net/viewcvs.py/squirrel-sql/sql12/plugins/mysql/src/n
et/sourceforge/squirrel_sql/plugins/mysql/MysqlPlugin.java?view=markup

This works with 1.2beta6 but is currently broken in CVS as the CVS
version now allows multiple object trees per session so the API
has to change. This should be finished over the next couple of
weeks.

Col

Thanks for a really great product!

On the objects/table screen (where we see the tabs Info/Content/Row
Count/etc..) is it possible to add a new tab from within a plugin?

Would also need to build the right-click menu at the same location.

Have done this by modifying the source but would prefer writing a
plugin.

Hate to reply to myself, but I think that I have to here. I have had a
further look into this and it appears that jdbc drivers vary so much in
their use of catalog that the plugin for a particular database will need
to handle the below functionality. So I am back to looking into how to
best accomplish this.

=20

Jason

=20

-----Original Message-----
From: Height, Jason=20
Sent: Thursday, 26 August 2004 2:02 PM
To: 'squ...@li...'
Subject: ObjectTree procedure node

=20

Hi All,

=20

When connecting Squirrel to Oracle the standard behaviour (without using
the oracle plugin) of the procedure node in the object tree shows
procedures, functions and also procedures and functions within packages.

=20

I believe that this is confusing and that only procedures ie those db
procedures that do not return a result and do not belong to a package
should be displayed.

=20

I suggest that:

1) ProcedureTypeExpander class should be changed such that it only
returns procedures with the criteria above

2) A FUNCTION node is added that shows db procedures that return a
result.

3) That procedures that are contained within a package ie where the
catalogName is non null are not displayed and are left to the plugins
for each database type OR

3a) That a PACKAGE node is added to deal with procedures and functions
that are contained within a package.

=20

I would imagine that the concept of a procedure vs function is easily
understood, but the idea of a package may only be quite specific to
Oracle and therefore should be done by the oracle plugin and not by
default.

=20

What do other databases and jdbcdrivers use the catalogName for in
relation to the getProcedures call? Oracle uses it for the Package name.

=20

Previously I posted that the plugins should be able to override the
standard expander behaviour to overcome these problems, but now I am not
so sure and I think that the default behaviour of Squirrel should
change.

=20

Thoughts?

=20

Colin would you accept a patch for points 1, 2 and 3?

=20

Thanks

=20

Jason Height

---------------------------------------------------------------------------=
-----------------------------------------
This e-mail (including attachments) is confidential information of Australi=
an Submarine Corporation Pty Limited (ASC).  It may also be legally privile=
ged.  Unauthorised use and disclosure is prohibited.  ASC is not taken to h=
ave waived confidentiality or privilege if this e-mail was sent to you in e=
rror. If you have received it in error, please notify the sender promptly. =
 While ASC takes steps to identify and eliminate viruses, it cannot confirm=
 that this e-mail is free from them.  You should scan this e-mail for virus=
es before it is used.  The statements in this e-mail are those of the sende=
r only, unless specifically stated to be those of ASC by someone with autho=
rity to do so.

Hi All,

=20

When connecting Squirrel to Oracle the standard behaviour (without using
the oracle plugin) of the procedure node in the object tree shows
procedures, functions and also procedures and functions within packages.

=20

I believe that this is confusing and that only procedures ie those db
procedures that do not return a result and do not belong to a package
should be displayed.

=20

I suggest that:

1) ProcedureTypeExpander class should be changed such that it only
returns procedures with the criteria above

2) A FUNCTION node is added that shows db procedures that return a
result.

3) That procedures that are contained within a package ie where the
catalogName is non null are not displayed and are left to the plugins
for each database type OR

3a) That a PACKAGE node is added to deal with procedures and functions
that are contained within a package.

=20

I would imagine that the concept of a procedure vs function is easily
understood, but the idea of a package may only be quite specific to
Oracle and therefore should be done by the oracle plugin and not by
default.

=20

What do other databases and jdbcdrivers use the catalogName for in
relation to the getProcedures call? Oracle uses it for the Package name.

=20

Previously I posted that the plugins should be able to override the
standard expander behaviour to overcome these problems, but now I am not
so sure and I think that the default behaviour of Squirrel should
change.

=20

Thoughts?

=20

Colin would you accept a patch for points 1, 2 and 3?

=20

Thanks

=20

Jason Height

---------------------------------------------------------------------------=
-----------------------------------------
This e-mail (including attachments) is confidential information of Australi=
an Submarine Corporation Pty Limited (ASC).  It may also be legally privile=
ged.  Unauthorised use and disclosure is prohibited.  ASC is not taken to h=
ave waived confidentiality or privilege if this e-mail was sent to you in e=
rror. If you have received it in error, please notify the sender promptly. =
 While ASC takes steps to identify and eliminate viruses, it cannot confirm=
 that this e-mail is free from them.  You should scan this e-mail for virus=
es before it is used.  The statements in this e-mail are those of the sende=
r only, unless specifically stated to be those of ASC by someone with autho=
rity to do so.

It just came through before this message ;-)

=20

No worries, with the timeframe. Your doing a fantastic job with the
merge, especially since the codebase has moved on significantly since
the patch was developed.

=20

Im looking forward to committing the oracle plugin improvements, which
is why all of this came up in the first place ;-). I assume that my
commit access went through since I never checked.

=20

One thing that we will need to be careful about with multiple windows,
is to ensure that jdbc drivers allow for concurrent statements &
resultsets from the one connection. I know for a fact that Oracle does,
but I believe that the JDBC-ODBC may not. Shouldn't be a big problem,
just need to add some code to prohibit more than one statement executing
on those drivers that don't allow it. Cross this bridge when the bug
reports start coming in with weird jdbc error messages ;-)

=20

Jason

=20

-----Original Message-----
From: squ...@li...
[mailto:squ...@li...] On Behalf Of
Colin Bell
Sent: Wednesday, 18 August 2004 8:09 AM
To: 'squ...@li...'
Subject: RE: [Squirrel-sql-develop] Multiple windows patch issues to
resolve

=20

Hi Jason,

=20

I sent (I think I sent) a reply to the list last night but it doesn't
seem to have gone through, I'll resend it when I get home tonight. The
only thing you need from it is not to worry if CVS doesn't compile. Only
one class doesn't and that class isn't used in the app, its just holding
some code that I need to merge back into your code. I'll be doing that
over the next couple of days.

=20

Col

	-----Original Message-----
	From: Height, Jason [mailto:jh...@su...]
	Sent: Tuesday, 17 August 2004 8:28 AM
	To: squ...@li...
	Subject: [Squirrel-sql-develop] Multiple windows patch issues to
resolve

	Colin,

	=20

	I notice that there are a number of comments with //JASON in the
code that you have questions over. Yep I actually read MOST of the
commit logs ;-)

	=20

	Let me know when it is safe to start working on them so that I
can supply you a patch where required. Or if you have some ideas on how
to address some comments then fire away ahead.

	=20

	I haven't tried to compile the app yet, just refreshing my CVS
repository for a clean start!

	=20

	Thanks

	=20

	Jason Height

	=20

	Senior Software Engineer

	Software Engineering

	C3 Department

	Australian Submarine Corporation

	(08) 8348 7709

	=20

=09
=09
------------------------------------------------------------------------
--------------------------------------------
	This e-mail (including attachments) is confidential information
of Australian Submarine Corporation Pty Limited (ASC). It may also be
legally privileged. Unauthorised use and disclosure is prohibited. ASC
is not taken to have waived confidentiality or privilege if this e-mail
was sent to you in error. If you have received it in error, please
notify the sender promptly. While ASC takes steps to identify and
eliminate viruses, it cannot confirm that this e-mail is free from them.
You should scan this e-mail for viruses before it is used. The
statements in this e-mail are those of the sender only, unless
specifically stated to be those of ASC by someone with authority to do
so.


_____________________________________________________________________=20
This e-mail has been scanned for viruses by MCI's Internet Managed=20
Scanning Services - powered by MessageLabs. For further information=20
visit http://www.mci.com

---------------------------------------------------------------------------=
-----------------------------------------
This e-mail (including attachments) is confidential information of Australi=
an Submarine Corporation Pty Limited (ASC).  It may also be legally privile=
ged.  Unauthorised use and disclosure is prohibited.  ASC is not taken to h=
ave waived confidentiality or privilege if this e-mail was sent to you in e=
rror. If you have received it in error, please notify the sender promptly. =
 While ASC takes steps to identify and eliminate viruses, it cannot confirm=
 that this e-mail is free from them.  You should scan this e-mail for virus=
es before it is used.  The statements in this e-mail are those of the sende=
r only, unless specifically stated to be those of ASC by someone with autho=
rity to do so.

Hi Jason,

On Tue, Aug 17, 2004 at 07:58:24AM +0930, Height, Jason wrote:

> I notice that there are a number of comments with //JASON in the code
> that you have questions over. Yep I actually read MOST of the commit
> logs ;-)

I'm glad somebody does.

I hadn't intended to appply your patch back into CVS until after beta7
but the two streams were starting to move apart again so I decided to
make beta7 the "bigger than Ben Hur" release.

> Let me know when it is safe to start working on them so that I can
> supply you a patch where required. Or if you have some ideas on how to
> address some comments then fire away ahead.

The JASON: tag is actually a TODO tag just for this patch, but many of
the notes will end up being questions for you. Give me a few more days
on it and I'll have a lot of questions for you, trust me on this :-)

> I haven't tried to compile the app yet, just refreshing my CVS
> repository for a clean start!

It doesn't compile at the moment, but it will run. The code that doesn't
comile is actually not executed, its just sitting there waiting for me
to reapply it back in to your new code

Thanks for the patch, and thanks for your patience waiting for me to
apply it.

-- 
Colin Bell
http://www.squirrelsql.org

Hi Jason,
 
I sent (I think I sent) a reply to the list last night but it doesn't seem
to have gone through, I'll resend it when I get home tonight. The only thing
you need from it is not to worry if CVS doesn't compile. Only one class
doesn't and that class isn't used in the app, its just holding some code
that I need to merge back into your code. I'll be doing that over the next
couple of days.
 
Col

-----Original Message-----
From: Height, Jason [mailto:jh...@su...]
Sent: Tuesday, 17 August 2004 8:28 AM
To: squ...@li...
Subject: [Squirrel-sql-develop] Multiple windows patch issues to resolve



Colin,

 

I notice that there are a number of comments with //JASON in the code that
you have questions over. Yep I actually read MOST of the commit logs ;-)

 

Let me know when it is safe to start working on them so that I can supply
you a patch where required. Or if you have some ideas on how to address some
comments then fire away ahead.

 

I haven't tried to compile the app yet, just refreshing my CVS repository
for a clean start!

 

Thanks

 

Jason Height

 

Senior Software Engineer

Software Engineering

C3 Department

Australian Submarine Corporation

(08) 8348 7709

 


----------------------------------------------------------------------------
----------------------------------------
This e-mail (including attachments) is confidential information of
Australian Submarine Corporation Pty Limited (ASC). It may also be legally
privileged. Unauthorised use and disclosure is prohibited. ASC is not taken
to have waived confidentiality or privilege if this e-mail was sent to you
in error. If you have received it in error, please notify the sender
promptly. While ASC takes steps to identify and eliminate viruses, it cannot
confirm that this e-mail is free from them. You should scan this e-mail for
viruses before it is used. The statements in this e-mail are those of the
sender only, unless specifically stated to be those of ASC by someone with
authority to do so.

Colin,

=20

I notice that there are a number of comments with //JASON in the code
that you have questions over. Yep I actually read MOST of the commit
logs ;-)

=20

Let me know when it is safe to start working on them so that I can
supply you a patch where required. Or if you have some ideas on how to
address some comments then fire away ahead.

=20

I haven't tried to compile the app yet, just refreshing my CVS
repository for a clean start!

=20

Thanks

=20

Jason Height

=20

Senior Software Engineer

Software Engineering

C3 Department

Australian Submarine Corporation

(08) 8348 7709

=20

---------------------------------------------------------------------------=
-----------------------------------------
This e-mail (including attachments) is confidential information of Australi=
an Submarine Corporation Pty Limited (ASC).  It may also be legally privile=
ged.  Unauthorised use and disclosure is prohibited.  ASC is not taken to h=
ave waived confidentiality or privilege if this e-mail was sent to you in e=
rror. If you have received it in error, please notify the sender promptly. =
 While ASC takes steps to identify and eliminate viruses, it cannot confirm=
 that this e-mail is free from them.  You should scan this e-mail for virus=
es before it is used.  The statements in this e-mail are those of the sende=
r only, unless specifically stated to be those of ASC by someone with autho=
rity to do so.

For the next week or two the SQuirreL code in CVS won't compile as I
apply a patch. If you need a compilable version check out the CVS TAG 
sqsc16aug2004 It was created prior to applying this patch.

-- 
Colin Bell
http://www.squirrelsql.org

> -----Original Message-----
> From: gwg [mailto:gw...@co...]
> Sent: Wednesday, 11 August 2004 1:58 PM
> To: squ...@li...
> Subject: Re: [Squirrel-sql-develop] FlyingSquirrel feature/plugin?

> The answer to your questions is: Sure! Squirrel could do 
> that!  Sounds 
> neat.  So when are you going to build it?  :-)

Go for it!!!

Just one note. I'm desperately trying to get the stable version of
1.2 out the door (1.1 was released in Nov 2002, nearly 2 years ago)
so I'd prefer this done in the next version. Thats not to say you
can't start now however and be ready to go once 1.2 stable is
released.

<snip/>
> appropriate row and column from that table.  The column name 
> to display 
> could be entered by the user in the "Data Types" section of 
> the General 
> Preferences window.

I'm not sure what you mean by this. Could you explain in a bit
more detail?


> This could be a significant performance hit during the inital 
> display of 
> the table, since each row could have several foreign keys and each 
> foreign key would require another JDBC access, but there are probably 
> ways around that.

A setting in "Session Preferences" saying whether to do the lookup
or not not coupled with a way of overriding this setting at a table
level would help.


> I don't see any problem with your feature # 3 except that I 
> don't know 
> what happens if we try to display two different tables in the same 
> session.  Probably could be done.

Shouldn't be a problem. I've currently got a patched version of SQuirreL
(courtsy of Jason Height) that allows multiple object trees within a single
session and I'm quite happily viewing different tables at the same time. FYI
this patch will be in beta8.

Col

Hi Glenn,

Thanks for the encouragement.  There is a lot to figure out before diving in.

I can see how the display of labels in place of values of foreign keys
could be completely implemented by rendering as you suggested (figure out
that a column is a foreign key and set an appropriate renderer for the the
column).  I also understand the performance hit on rendering.  I suppose that
there may be a trade-off between ease of implementation and performance.
A more intrusive implementation would be to modify the query for row
values when a user clicks on the contents tab. The query would change
from something like a simple SELECT * to a join in which the label is
used instead.  The result set could then be rendered without (I assume)
modification.  Is that too at odds with the design of Squirrel?

I have been thinking that a good place to specify the labels
would be in the primary key tab.  The row there specifies the column that
is the primary key and an extra blank could be added that specifies which
column is used as a label for the primary key.  (The idea is that one label
is designated to replace the primary key and that it is used for every table
to which the primary key is exported.) This could be done for each table.
Persistence of label designations between sessions would be nice, presumably
stored along with the connection info for an alias. I have also been thinking
of enabling/disabling translation of foreign keys in some sort of session
option or alias-specific option or wherever seems most appropriate for
squirrel.  Possible?  If so, which classes should I begin studying?

Collecting and using foreign key relations for databases that support foreign
key specifications seems like it should be very straight forward. (My
Mckoi database showed up very nicely in the primary key tab, eported keys tab
and foreign key tab.) What about db's like MySQL where my foreign key specs
in create statements are treated as comments by MySQL?  Is there any hope? Is
it too much of a kludge to load key information for databases like MySQL?

Today I have a much better idea of how to implement a general cell editor
for foreign keys.  The simply presents a list of acceptable label values
and returns something appropriate.  That's a little vague and depends on
how rendering is done.

HOW EDITING MIGHT WORK IF EVERYTHING IS DONE USING CELL RENDERERS AND
EDITORS

1) SQL query is unmodified and returns appropriate objects.
2) Table model unmodified.
3) Cell editor maintains mapping of foreign key values and labels and presents
   a list of labels.  When user selects label, appropriate foreign key
   value is returned.

HOW EDITING MIGHT WORK IF SQL QUERY IS MODIFIED

1) SQL query for table contents modified to return labels for columns that
   contain foreign keys.
2) Table model reports foreign key columns to be class String.
3) Cell editor presents choice of label values and returns label value.
4) Table model looks up the correct foreign key value and updates
   table in database accordingly.

If all of the above works, it becomes time to think about how to display
multiple result sets if the user requests to see all observations in all
tables to which a particular value of a primary key is exported.

What do you think?  What's feasible?  And, again, an tips on which classes
to study?

Thanks,

Dick

On Tue, 10 Aug 2004, gwg wrote:

> Date: Tue, 10 Aug 2004 23:57:30 -0400
> From: gwg <gw...@co...>
> To: squ...@li...
> Subject: Re: [Squirrel-sql-develop] FlyingSquirrel feature/plugin?
>
> Hi Dick,
>
> The answer to your questions is: Sure! Squirrel could do that!  Sounds
> neat.  So when are you going to build it?  :-)
>
> What you are talking about is the representation and editing of data
> within a cell.  All of that functionality is encapsulated in DataTypeXXX
> classes, where XXX represents a Java data type that can be gotten from
> SQL, e.g. String, Integer, Date, etc.  One way to handle your requests
> would be to have the all of the DataTypes (where it makes sense) check
> whether the field is a foreign key, then do an extra lookup to get the
> appropriate row and column from that table.  The column name to display
> could be entered by the user in the "Data Types" section of the General
> Preferences window.
>
> This could be a significant performance hit during the inital display of
> the table, since each row could have several foreign keys and each
> foreign key would require another JDBC access, but there are probably
> ways around that.
>
> Your feature # 2 would use a similar approach, but in the cell editor
> section of the DataType objects.  It would also need to handle the
> reverse lookup (e.g. string-to-code) when the editing is completed.  The
> current code all assumes that the user is typeing text into a JTextField
> object, so I don't know off hand what other issues might arrise from
> using some other Swing component.
>
> I don't see any problem with your feature # 3 except that I don't know
> what happens if we try to display two different tables in the same
> session.  Probably could be done.
>
> Glenn
>

Hi Dick,

The answer to your questions is: Sure! Squirrel could do that!  Sounds 
neat.  So when are you going to build it?  :-)

What you are talking about is the representation and editing of data 
within a cell.  All of that functionality is encapsulated in DataTypeXXX 
classes, where XXX represents a Java data type that can be gotten from 
SQL, e.g. String, Integer, Date, etc.  One way to handle your requests 
would be to have the all of the DataTypes (where it makes sense) check 
whether the field is a foreign key, then do an extra lookup to get the 
appropriate row and column from that table.  The column name to display 
could be entered by the user in the "Data Types" section of the General 
Preferences window.

This could be a significant performance hit during the inital display of 
the table, since each row could have several foreign keys and each 
foreign key would require another JDBC access, but there are probably 
ways around that.

Your feature # 2 would use a similar approach, but in the cell editor 
section of the DataType objects.  It would also need to handle the 
reverse lookup (e.g. string-to-code) when the editing is completed.  The 
current code all assumes that the user is typeing text into a JTextField 
object, so I don't know off hand what other issues might arrise from 
using some other Swing component.

I don't see any problem with your feature # 3 except that I don't know 
what happens if we try to display two different tables in the same 
session.  Probably could be done.

Glenn

Dick Repasky wrote:
> Hi,
> 
> I've been looking at database browsers/editors, and I know what I want. I
> haven't found it yet, and my question is whether the following is
> reasonable to think about doing with SquirrelSQL.
> 
> What I'm looking for when browsing/editing tables is
> transparent translation of 1-to-many relations.  There are three features
> that I have in mind.
> 
> 1) When browsing a table, I would like to have values in columns that
>    are foreign keys be replaced with labels taken from the tables that
>    are referenced by the foreign key columns.  For example, if a table has
>    a column named system_id that is a foreign key to a table that contains the
>    names of systems, I'd like to have the system name displayed instead
>    of the value of the foreign key.  Instead of a number like 32, I want
>    to see "Scramble Linux Cluster".
> 
>    This feature appears to need only one piece of information that
>    isn't in the usual schema data - for each table that has a primary key
>    that is referenced by foreign keys, a column that is the name to be
>    used to represent them in tables that have foreign keys.
> 
>    If the the labels and schema are known, the SQL to do this isn't
>    bad
> 
>       SELECT ... system_id ... FROM accounts
> 
>   becomes
> 
>       SELECT ... refa.system_name ... FROM accounts, systems AS refa WHERE ...
> 
>   The AS allows for multiple foreign keys pointing to the same table and
>   self-referential foreign keys.
> 
> 2) When editing a table.  If I choose to edit a cell that is a foreign key
>    (and represented as described above), I want to choose a new value
>    from a list of labels taken from the label column of the table that is
>    referenced by the foreign key.
> 
>    I have thought less about how to implement this one, but I assume that
>    it can be done with a shell game of data classes  and a
>    ForeignKeyCellEditor  class.
> 
> 3) When browsing a table that has a primary key that is referenced by
>    foreign keys in other tables, I'd like to be able to select a row
>    and popup a menu that allows me to select one or more of those
>    other tables and have them queried for all rows that have foreign key
>    values that match the row that I have selected.  (In relatively
>    unconnected schemas, it might be nice to have an "all tables" menu item
>    that queries all tables that reference the table for the value of
>    interest and pops up a table window for each.
> 
> These features strike me as very useful and general.  The question is:
> are they practical with SquirrelSQL?  And, I suppose, does anyone know
> of a browser/editor that does these things.
> 
> Thanks,
> 
> Dick Repasky
> 
> 
> -------------------------------------------------------
> SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
> 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
> Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
> http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
> _______________________________________________
> Squirrel-sql-develop mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
> 

Hi,

I've been looking at database browsers/editors, and I know what I want. I
haven't found it yet, and my question is whether the following is
reasonable to think about doing with SquirrelSQL.

What I'm looking for when browsing/editing tables is
transparent translation of 1-to-many relations.  There are three features
that I have in mind.

1) When browsing a table, I would like to have values in columns that
   are foreign keys be replaced with labels taken from the tables that
   are referenced by the foreign key columns.  For example, if a table has
   a column named system_id that is a foreign key to a table that contains the
   names of systems, I'd like to have the system name displayed instead
   of the value of the foreign key.  Instead of a number like 32, I want
   to see "Scramble Linux Cluster".

   This feature appears to need only one piece of information that
   isn't in the usual schema data - for each table that has a primary key
   that is referenced by foreign keys, a column that is the name to be
   used to represent them in tables that have foreign keys.

   If the the labels and schema are known, the SQL to do this isn't
   bad

      SELECT ... system_id ... FROM accounts

  becomes

      SELECT ... refa.system_name ... FROM accounts, systems AS refa WHERE ...

  The AS allows for multiple foreign keys pointing to the same table and
  self-referential foreign keys.

2) When editing a table.  If I choose to edit a cell that is a foreign key
   (and represented as described above), I want to choose a new value
   from a list of labels taken from the label column of the table that is
   referenced by the foreign key.

   I have thought less about how to implement this one, but I assume that
   it can be done with a shell game of data classes  and a
   ForeignKeyCellEditor  class.

3) When browsing a table that has a primary key that is referenced by
   foreign keys in other tables, I'd like to be able to select a row
   and popup a menu that allows me to select one or more of those
   other tables and have them queried for all rows that have foreign key
   values that match the row that I have selected.  (In relatively
   unconnected schemas, it might be nice to have an "all tables" menu item
   that queries all tables that reference the table for the value of
   interest and pops up a table window for each.

These features strike me as very useful and general.  The question is:
are they practical with SquirrelSQL?  And, I suppose, does anyone know
of a browser/editor that does these things.

Thanks,

Dick Repasky

Hi,

indeed, the files were there, but not for my update. This drove me nuts, 
because
    cvs -z5 update
was not enough, instead
    cvs -z5 update -d
helped.

Thanks for the hint,
Victor

Colin Bell wrote:

>Hi Victor,
>
>On Mon, Aug 09, 2004 at 12:14:59PM +0200, Victor Ott wrote:
>
>  
>
>>after refreshing my CVS copy, 'compile_app' target complains about 
>>package net.sourceforge.squirrel_sql.client.session.parser missing. 
>>And indeed it's missing. Any hint?
>>    
>>
> 
>Works for me:
>
>cvs -z3 -d:pserver:ano...@cv...:/cvsroot/squirrel-sql co sql12
>
><snip/>
>
>U sql12/app/src/net/sourceforge/squirrel_sql/client/session/parser/IParserEventsProcessor.java
>U sql12/app/src/net/sourceforge/squirrel_sql/client/session/parser/ParserEventsAdapter.java
>U sql12/app/src/net/sourceforge/squirrel_sql/client/session/parser/ParserEventsListener.java
>U sql12/app/src/net/sourceforge/squirrel_sql/client/session/parser/ParserEventsProcessor.java
>U sql12/app/src/net/sourceforge/squirrel_sql/client/session/parser/SQLSchemaImpl.java
>U sql12/app/src/net/sourceforge/squirrel_sql/client/session/parser/kernel/Completion.java
>...
>
>Try again, I've had some funny transient problems with the CVS
>repository in the past.
>
>  
>