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

There is now a CVS commit mailing list for SQSC. You can subscribe to it
at http://sourceforge.net/mail/?group_id=28383

-- 
Colin Bell
http://squirrel-sql.sf.net

Hi

Is there a reason why the objects/SQL/messages part of the UI is structured
so that messages are visible while in
the objects view?
I can't see a reason and it's taking up valuable screen real estate :-)

Thanks,
   Noel

Disclaimer

"Everything in this e-mail and attachments relating to the official business
of Medscheme Holdings ( Pty ) Ltd ( Reg Number 1970/015014/07 ) is
proprietary to the company. It is confidential, legally privileged and
protected by law. Medscheme Holdings does not own and endorse any other
content. Views and opinions are those of the sender unless clearly stated as
being that of Medscheme Holdings. The person addressed in the e-mail is the
sole authorised recipient. Please notify the sender immediately if it has
unintentionally reached you and do not read, disclose or use the content in
any way. Whilst all reasonable steps are taken to ensure the accuracy and
integrity of information and data transmitted electronically and to preserve
the confidentiality thereof, no liability or responsibility whatsoever is
accepted if information or data is,for whatever reason, corrupted or does
not reach its intended destination."

Hi Jason

Any chance you're going to be adding "explain plan" functionality?

I could dig up the necessary commands.
(It is fairly simple - execute an additional SQL query before and after the
query you're interested in, and you get a nice 
result set back)

Regards,
   Noel

Disclaimer

"Everything in this e-mail and attachments relating to the official business
of Medscheme Holdings ( Pty ) Ltd ( Reg Number 1970/015014/07 ) is
proprietary to the company. It is confidential, legally privileged and
protected by law. Medscheme Holdings does not own and endorse any other
content. Views and opinions are those of the sender unless clearly stated as
being that of Medscheme Holdings. The person addressed in the e-mail is the
sole authorised recipient. Please notify the sender immediately if it has
unintentionally reached you and do not read, disclose or use the content in
any way. Whilst all reasonable steps are taken to ensure the accuracy and
integrity of information and data transmitted electronically and to preserve
the confidentiality thereof, no liability or responsibility whatsoever is
accepted if information or data is,for whatever reason, corrupted or does
not reach its intended destination."

Hi Colin,

On Windows and Linux (I don't have access to a Mac) the new font used is
like the one used in most other applications. On Mac I don't think that
Metal L&F is default also when run on XP I think that the new XP L&F
will be used - in these cases no change of the L&F is done, which is
desired.

Basically it should be ok to use, but I agree that a command line
argument would be nice!

Btw. can I participate in developing Squirrel? I'm especially interested
in Oracle specific features like being able to see comments on table and
columns and viewing refcursor results like any other select.

/Kim

On Fri, 2004-04-02 at 01:35, Colin Bell wrote:

> Hi Kim,
> 
> Does this give reasonable results on the standard platforms Windows,
> Linux and OS X?
> 
> Thanks
> Col
> 
> > -----Original Message-----
> > From: Kim Jersin [mailto:ki...@je...]
> > Sent: Friday, 13 February 2004 20:43
> > To: Squirrel develop
> > Subject: [Squirrel-sql-develop] Metal L&F font change
> > 
> > 
> > The default font used for menues, buttons etc. in the Metal look and
> > feel is a bold serif kind of font, which looks really ugly. 
> > This is not
> > fault of Squirrel but that of the Metal L&F theme.
> > (You get the Metal L&F as default when running a Swing app on Linux or
> > other Unix'es).
> > 
> > It is quite easy to top level change that font into a more reasonable
> > "standard" font. Below is a function which does the job!
> > 
> > The function must be called in the program initialization 
> > fase sometimes
> > before the instantiation of the first window (Code snippet to handle
> > this shown further down).
> > 
> > // Change all font resources into using a non bold sans serif font
> > // with user specified font size!
> > public static void setFont(int fontSize) {
> >   Font defaultFont= new Font("SansSerif", Font.PLAIN, fontSize);
> >   for(Enumeration i=UIManager.getDefaults().keys();         
> > 	i.hasMoreElements();) 
> >   {
> >     Object key= i.nextElement();
> >     if(UIManager.get(key) instanceof FontUIResource) {
> >       UIManager.put(key, new FontUIResource(defaultFont));
> >     }
> >   }
> > }
> > 
> > 
> > Example of an application main, which I use for most swing apps
> > 
> > public static void main(String[] args)
> > {
> >   try
> >   {
> >     // Set look and feel to the system default.
> >     // On systems where default is "Metal", replace the default font
> >     String uiClassName = UIManager.getSystemLookAndFeelClassName();
> >     if(uiClassName.endsWith("MetalLookAndFeel")) {
> >       setFont(12);
> >     }
> >     UIManager.setLookAndFeel(uiClassName);
> >   }
> >   catch(Exception e)
> >   {
> >     e.printStackTrace();
> >   }
> >   new App();
> > }
> > 
> > NOTE: I'm not an active Squirrel developer so I don't have 
> > source update
> > access. I would be happy if the maintainer could apply the code!
> > 
> > /Kim
> > 
> > 
> > 
> > -------------------------------------------------------
> > SF.Net is sponsored by: Speed Start Your Linux Apps Now.
> > Build and deploy apps & Web services for Linux with
> > a free DVD software kit from IBM. Click Now!
> > http://ads.osdn.com/?ad_id=1356&alloc_id=3438&op=click
> > _______________________________________________
> > Squirrel-sql-develop mailing list
> > Squ...@li...
> > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
> > 
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by: IBM Linux Tutorials
> Free Linux tutorial presented by Daniel Robbins, President and CEO of
> GenToo technologies. Learn everything from fundamentals to system
> administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
> _______________________________________________
> Squirrel-sql-develop mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop

I was thinking of adding a new argument that would turn it off, something
similar to the existing --use-default-metal-theme argument which removes
the Metal theme supplied by Karsten Lentzsch

usage: squirrel-sql
 -userdir,--user-settings-dir <userdir>   SQuirreL settings directory
 -l,--log-config-file <l>                 Logging configuration file
 -home,--squirrel-home <home>             SQuirreL home directory
 -n,--native-laf                          Use native look and feel
 -nop,--no-plugins                        Don't load plugins
 -nos,--no-splash                         Don't display splash screen
 -m,--use-default-metal-theme             Use default metal theme
 -help                                    Display Help and exit


-----Original Message-----
From: Height, Jason [mailto:jh...@su...]
Sent: Friday, 2 April 2004 9:44
To: Squirrel develop
Subject: RE: [Squirrel-sql-develop] Metal L&F font change




Should this be a user changeable property, rather than hard coded to break
the L&F standards? 
Jason 
  
-----Original Message----- 
From: Colin Bell [mailto:Col...@as...] 
Sent: Friday, 2 April 2004 9:06 AM 
To: Squirrel develop 
Subject: RE: [Squirrel-sql-develop] Metal L&F font change 
Hi Kim, 
Does this give reasonable results on the standard platforms Windows, 
Linux and OS X? 
Thanks 
Col 
> -----Original Message----- 
> From: Kim Jersin [mailto:ki...@je...] 
> Sent: Friday, 13 February 2004 20:43 
> To: Squirrel develop 
> Subject: [Squirrel-sql-develop] Metal L&F font change 
> 
> 
> The default font used for menues, buttons etc. in the Metal look and 
> feel is a bold serif kind of font, which looks really ugly. 
> This is not 
> fault of Squirrel but that of the Metal L&F theme. 
> (You get the Metal L&F as default when running a Swing app on Linux or 
> other Unix'es). 
> 
> It is quite easy to top level change that font into a more reasonable 
> "standard" font. Below is a function which does the job! 
> 
> The function must be called in the program initialization 
> fase sometimes 
> before the instantiation of the first window (Code snippet to handle 
> this shown further down). 
> 
> // Change all font resources into using a non bold sans serif font 
> // with user specified font size! 
> public static void setFont(int fontSize) { 
>   Font defaultFont= new Font("SansSerif", Font.PLAIN, fontSize); 
>   for(Enumeration i=UIManager.getDefaults().keys();         
>       i.hasMoreElements();) 
>   { 
>     Object key= i.nextElement(); 
>     if(UIManager.get(key) instanceof FontUIResource) { 
>       UIManager.put(key, new FontUIResource(defaultFont)); 
>     } 
>   } 
> } 
> 
> 
> Example of an application main, which I use for most swing apps 
> 
> public static void main(String[] args) 
> { 
>   try 
>   { 
>     // Set look and feel to the system default. 
>     // On systems where default is "Metal", replace the default font 
>     String uiClassName = UIManager.getSystemLookAndFeelClassName(); 
>     if(uiClassName.endsWith("MetalLookAndFeel")) { 
>       setFont(12); 
>     } 
>     UIManager.setLookAndFeel(uiClassName); 
>   } 
>   catch(Exception e) 
>   { 
>     e.printStackTrace(); 
>   } 
>   new App(); 
> } 
> 
> NOTE: I'm not an active Squirrel developer so I don't have 
> source update 
> access. I would be happy if the maintainer could apply the code! 
> 
> /Kim 
> 
> 
> 
> ------------------------------------------------------- 
> SF.Net is sponsored by: Speed Start Your Linux Apps Now. 
> Build and deploy apps & Web services for Linux with 
> a free DVD software kit from IBM. Click Now! 
> http://ads.osdn.com/?ad_id56&alloc_id438&op=click 
> _______________________________________________ 
> Squirrel-sql-develop mailing list 
> Squ...@li... 
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop 
> 


------------------------------------------------------- 
This SF.Net email is sponsored by: IBM Linux Tutorials 
Free Linux tutorial presented by Daniel Robbins, President and CEO of 
GenToo technologies. Learn everything from fundamentals to system 
administration.http://ads.osdn.com/?ad_id70&alloc_id638&op=click 
_______________________________________________ 
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
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.

Should this be a user changeable property, rather than hard coded to break
the L&F standards?

Jason
 
-----Original Message-----
From: Colin Bell [mailto:Col...@as...] 
Sent: Friday, 2 April 2004 9:06 AM
To: Squirrel develop
Subject: RE: [Squirrel-sql-develop] Metal L&F font change

Hi Kim,

Does this give reasonable results on the standard platforms Windows,
Linux and OS X?

Thanks
Col

> -----Original Message-----
> From: Kim Jersin [mailto:ki...@je...]
> Sent: Friday, 13 February 2004 20:43
> To: Squirrel develop
> Subject: [Squirrel-sql-develop] Metal L&F font change
> 
> 
> The default font used for menues, buttons etc. in the Metal look and
> feel is a bold serif kind of font, which looks really ugly. 
> This is not
> fault of Squirrel but that of the Metal L&F theme.
> (You get the Metal L&F as default when running a Swing app on Linux or
> other Unix'es).
> 
> It is quite easy to top level change that font into a more reasonable
> "standard" font. Below is a function which does the job!
> 
> The function must be called in the program initialization 
> fase sometimes
> before the instantiation of the first window (Code snippet to handle
> this shown further down).
> 
> // Change all font resources into using a non bold sans serif font
> // with user specified font size!
> public static void setFont(int fontSize) {
>   Font defaultFont= new Font("SansSerif", Font.PLAIN, fontSize);
>   for(Enumeration i=UIManager.getDefaults().keys();         
> 	i.hasMoreElements();) 
>   {
>     Object key= i.nextElement();
>     if(UIManager.get(key) instanceof FontUIResource) {
>       UIManager.put(key, new FontUIResource(defaultFont));
>     }
>   }
> }
> 
> 
> Example of an application main, which I use for most swing apps
> 
> public static void main(String[] args)
> {
>   try
>   {
>     // Set look and feel to the system default.
>     // On systems where default is "Metal", replace the default font
>     String uiClassName = UIManager.getSystemLookAndFeelClassName();
>     if(uiClassName.endsWith("MetalLookAndFeel")) {
>       setFont(12);
>     }
>     UIManager.setLookAndFeel(uiClassName);
>   }
>   catch(Exception e)
>   {
>     e.printStackTrace();
>   }
>   new App();
> }
> 
> NOTE: I'm not an active Squirrel developer so I don't have 
> source update
> access. I would be happy if the maintainer could apply the code!
> 
> /Kim
> 
> 
> 
> -------------------------------------------------------
> SF.Net is sponsored by: Speed Start Your Linux Apps Now.
> Build and deploy apps & Web services for Linux with
> a free DVD software kit from IBM. Click Now!
> http://ads.osdn.com/?ad_id56&alloc_id438&op=click
> _______________________________________________
> Squirrel-sql-develop mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
> 


-------------------------------------------------------
This SF.Net email is sponsored by: IBM Linux Tutorials
Free Linux tutorial presented by Daniel Robbins, President and CEO of
GenToo technologies. Learn everything from fundamentals to system
administration.http://ads.osdn.com/?ad_id70&alloc_id638&op=click
_______________________________________________
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 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.

Hi Kim,

Does this give reasonable results on the standard platforms Windows,
Linux and OS X?

Thanks
Col

> -----Original Message-----
> From: Kim Jersin [mailto:ki...@je...]
> Sent: Friday, 13 February 2004 20:43
> To: Squirrel develop
> Subject: [Squirrel-sql-develop] Metal L&F font change
> 
> 
> The default font used for menues, buttons etc. in the Metal look and
> feel is a bold serif kind of font, which looks really ugly. 
> This is not
> fault of Squirrel but that of the Metal L&F theme.
> (You get the Metal L&F as default when running a Swing app on Linux or
> other Unix'es).
> 
> It is quite easy to top level change that font into a more reasonable
> "standard" font. Below is a function which does the job!
> 
> The function must be called in the program initialization 
> fase sometimes
> before the instantiation of the first window (Code snippet to handle
> this shown further down).
> 
> // Change all font resources into using a non bold sans serif font
> // with user specified font size!
> public static void setFont(int fontSize) {
>   Font defaultFont= new Font("SansSerif", Font.PLAIN, fontSize);
>   for(Enumeration i=UIManager.getDefaults().keys();         
> 	i.hasMoreElements();) 
>   {
>     Object key= i.nextElement();
>     if(UIManager.get(key) instanceof FontUIResource) {
>       UIManager.put(key, new FontUIResource(defaultFont));
>     }
>   }
> }
> 
> 
> Example of an application main, which I use for most swing apps
> 
> public static void main(String[] args)
> {
>   try
>   {
>     // Set look and feel to the system default.
>     // On systems where default is "Metal", replace the default font
>     String uiClassName = UIManager.getSystemLookAndFeelClassName();
>     if(uiClassName.endsWith("MetalLookAndFeel")) {
>       setFont(12);
>     }
>     UIManager.setLookAndFeel(uiClassName);
>   }
>   catch(Exception e)
>   {
>     e.printStackTrace();
>   }
>   new App();
> }
> 
> NOTE: I'm not an active Squirrel developer so I don't have 
> source update
> access. I would be happy if the maintainer could apply the code!
> 
> /Kim
> 
> 
> 
> -------------------------------------------------------
> SF.Net is sponsored by: Speed Start Your Linux Apps Now.
> Build and deploy apps & Web services for Linux with
> a free DVD software kit from IBM. Click Now!
> http://ads.osdn.com/?ad_id=1356&alloc_id=3438&op=click
> _______________________________________________
> Squirrel-sql-develop mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
> 

Hi Noel,

 

Yup. I agree with what you have said. I think that I will create a patch on
this basis, the first time that such a method is called, then a flag will be
set to indicate no further modifications.

 

Certainly the oracle plugin would only do it if it is attached to an oracle
session.

 

Jason

 

-----Original Message-----
From: Noel Grandin [mailto:No...@Me...] 
Sent: Thursday, 1 April 2004 4:59 PM
To: 'Height, Jason'; 'squ...@li...'
Subject: RE: [Squirrel-sql-develop] Tree support for database specific pro
cedures

 

My 2 cents:

 

This is one of those places where only one plugin can really have control.
If more than one attempts to take control, the code should probably throw
some kind of exception. It is then the plugin's responsibility to say
"Sorry, but you've got a conflict here. This piece of my functionality won't
be active".

 

But given the number of plugins squirrel appears to have so far, I don't see
this being an issue for quite some time.

 

I assume the oracle plugin has some kind of test such that it only becomes
active for those sessions which are actually connected to an oracle
database?

 

Regards,

   Noel

 

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

http://sourceforge.net/tracker/index.php?func=detail&aid=904016&group_id=283
83&atid=393414

I've managed to trace this down further. It is not a ctrl-enter thing. It
happens randomly if I do enough editing.

I've enclosed the stack traces of the active threads. Eclipse does not seem
to think that there is a deadlock, but it sure
looks like a deadlock.


Thread [AWT-EventQueue-0] (Suspended)
	OsterTextControl$HighLightedDocument.insertString(int, String,
AttributeSet) line: 820
	OsterTextControl$HighLightedDocument(AbstractDocument).replace(int,
int, String, AttributeSet) line: 668
	OsterTextControl(JTextPane).replaceSelection(String, AttributeSet)
line: 186
	OsterTextControl(JTextPane).replaceSelection(String) line: 153
	DefaultEditorKit$DefaultKeyTypedAction.actionPerformed(ActionEvent)
line: 839
	SwingUtilities.notifyAction(Action, KeyStroke, KeyEvent, Object,
int) line: 1530
	OsterTextControl(JComponent).processKeyBinding(KeyStroke, KeyEvent,
int, boolean) line: 2438
	OsterTextControl(JComponent).processKeyBindings(KeyEvent, boolean)
line: 2473
	OsterTextControl(JComponent).processKeyEvent(KeyEvent) line: 2401
	OsterTextControl(Component).processEvent(AWTEvent) line: 4909
	OsterTextControl(Container).processEvent(AWTEvent) line: 1569
	OsterTextControl(Component).dispatchEventImpl(AWTEvent) line: 3615
	OsterTextControl(Container).dispatchEventImpl(AWTEvent) line: 1627
	OsterTextControl(Component).dispatchEvent(AWTEvent) line: 3477
	
DefaultKeyboardFocusManager(KeyboardFocusManager).redispatchEvent(Component,
AWTEvent) line: 1713
	DefaultKeyboardFocusManager.dispatchKeyEvent(KeyEvent) line: 627
	DefaultKeyboardFocusManager.preDispatchKeyEvent(KeyEvent) line: 831
	DefaultKeyboardFocusManager.typeAheadAssertions(Component, AWTEvent)
line: 741
	DefaultKeyboardFocusManager.dispatchEvent(AWTEvent) line: 592
	MainFrame(Component).dispatchEventImpl(AWTEvent) line: 3506
	MainFrame(Container).dispatchEventImpl(AWTEvent) line: 1627
	MainFrame(Window).dispatchEventImpl(AWTEvent) line: 1606
	MainFrame(Component).dispatchEvent(AWTEvent) line: 3477
	EventQueue.dispatchEvent(AWTEvent) line: 456
	EventDispatchThread.pumpOneEventForHierarchy(int, Component) line:
201
	EventDispatchThread.pumpEventsForHierarchy(int, Conditional,
Component) line: 151
	EventDispatchThread.pumpEvents(int, Conditional) line: 145
	EventDispatchThread.pumpEvents(Conditional) line: 137
	EventDispatchThread.run() line: 100

Thread [Thread-3] (Suspended)
	Object.wait(long) line: not available [native method]
	OsterTextControl$HighLightedDocument(Object).wait() line: 429 [local
variables unavailable]
	OsterTextControl$HighLightedDocument(AbstractDocument).writeLock()
line: 1342 [local variables unavailable]
	
OsterTextControl$HighLightedDocument(DefaultStyledDocument).setCharacterAttr
ibutes(int, int, AttributeSet, boolean) line: 338
	OsterTextControl$Colorer.run() line: 683

Disclaimer

"Everything in this e-mail and attachments relating to the official business
of Medscheme Holdings ( Pty ) Ltd ( Reg Number 1970/015014/07 ) is
proprietary to the company. It is confidential, legally privileged and
protected by law. Medscheme Holdings does not own and endorse any other
content. Views and opinions are those of the sender unless clearly stated as
being that of Medscheme Holdings. The person addressed in the e-mail is the
sole authorised recipient. Please notify the sender immediately if it has
unintentionally reached you and do not read, disclose or use the content in
any way. Whilst all reasonable steps are taken to ensure the accuracy and
integrity of information and data transmitted electronically and to preserve
the confidentiality thereof, no liability or responsibility whatsoever is
accepted if information or data is,for whatever reason, corrupted or does
not reach its intended destination."

My 2 cents:
 
This is one of those places where only one plugin can really have control.
If more than one attempts to take control, the code should probably throw
some kind of exception. It is then the plugin's responsibility to say
"Sorry, but you've got a conflict here. This piece of my functionality won't
be active".
 
But given the number of plugins squirrel appears to have so far, I don't see
this being an issue for quite some time.
 
I assume the oracle plugin has some kind of test such that it only becomes
active for those sessions which are actually connected to an oracle
database?
 
Regards,
   Noel

-----Original Message-----
From: squ...@li...
[mailto:squ...@li...]On Behalf Of
Height, Jason
Sent: 01 April 2004 01:55
To: 'squ...@li...'
Subject: [Squirrel-sql-develop] Tree support for database specific
procedures



Hi All,

 

I have finalised the multiple windows patch that enables multiple trees and
sql worksheets to be acive for a given session. I have sent this to colin
(directly) and I expect it to be applied when he gets back.

 

Moving on now, I am looking at an issue with the oracle plugin/database. In
oracle, and I am sure that this is the same with other databases, there are
a number of different types of stored procedures. There are procedures,
functions and packages.

 

Unfortunately at the moment the base tree functionality of squirrel has a
standard expander for procedures that uses the
DatabasemetaData.getProcedures. What this means is that all procedures
appear under a "Procedures" node in the tree. The oracle plugin then adds a
"Functions" and a "Packages" node, but the problem is that the procedures
that should ONLY appear beneath the "Functions" or "Packages" node also
appear beneath the "Procedures" node.

 

I would like to be able to override/remove the standard tree procedure
expander when the session is an oracle one, but I am a bit stumped on how to
do it. I could add a "IObjectTreeAPI.setStandardExpander(DatabaseObjectType
dboType, INodeExpander expander)" method but I am concerned on how to
prevent multiple plugins overlapping. Does anyone have any ideas?

 

Thanks

 

Jason Height

 

Senior Software Engineer

Software Engineering

Systems/Technologies Department

Australian Submarine Corporation

 


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



Disclaimer

"Everything in this e-mail and attachments relating to the official business
of Medscheme Holdings ( Pty ) Ltd ( Reg Number 1970/015014/07 ) is
proprietary to the company. It is confidential, legally privileged and
protected by law. Medscheme Holdings does not own and endorse any other
content. Views and opinions are those of the sender unless clearly stated as
being that of Medscheme Holdings. The person addressed in the e-mail is the
sole authorised recipient. Please notify the sender immediately if it has
unintentionally reached you and do not read, disclose or use the content in
any way. Whilst all reasonable steps are taken to ensure the accuracy and
integrity of information and data transmitted electronically and to preserve
the confidentiality thereof, no liability or responsibility whatsoever is
accepted if information or data is,for whatever reason, corrupted or does
not reach its intended destination."

Hi All,

 

I have finalised the multiple windows patch that enables multiple trees and
sql worksheets to be acive for a given session. I have sent this to colin
(directly) and I expect it to be applied when he gets back.

 

Moving on now, I am looking at an issue with the oracle plugin/database. In
oracle, and I am sure that this is the same with other databases, there are
a number of different types of stored procedures. There are procedures,
functions and packages.

 

Unfortunately at the moment the base tree functionality of squirrel has a
standard expander for procedures that uses the
DatabasemetaData.getProcedures. What this means is that all procedures
appear under a "Procedures" node in the tree. The oracle plugin then adds a
"Functions" and a "Packages" node, but the problem is that the procedures
that should ONLY appear beneath the "Functions" or "Packages" node also
appear beneath the "Procedures" node.

 

I would like to be able to override/remove the standard tree procedure
expander when the session is an oracle one, but I am a bit stumped on how to
do it. I could add a "IObjectTreeAPI.setStandardExpander(DatabaseObjectType
dboType, INodeExpander expander)" method but I am concerned on how to
prevent multiple plugins overlapping. Does anyone have any ideas?

 

Thanks

 

Jason Height

 

Senior Software Engineer

Software Engineering

Systems/Technologies Department

Australian Submarine Corporation

 

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

Index: =
net/sourceforge/squirrel_sql/fw/datasetviewer/DataSetViewerTablePanel.ja=
va
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
RCS file: =
D:/Personal2/Data_Files/CVSRepository/default/Squirrel-sql/fw-src/net/so=
urceforge/squirrel_sql/fw/datasetviewer/DataSetViewerTablePanel.java,v
retrieving revision 1.1
diff -u -r1.1 DataSetViewerTablePanel.java
--- =
net/sourceforge/squirrel_sql/fw/datasetviewer/DataSetViewerTablePanel.ja=
va	20 Mar 2004 17:57:03 -0000	1.1
+++ =
net/sourceforge/squirrel_sql/fw/datasetviewer/DataSetViewerTablePanel.ja=
va	30 Mar 2004 20:14:06 -0000
@@ -98,8 +98,13 @@
=20
 	public void setColumnDefinitions(ColumnDisplayDefinition[] colDefs)
 	{
-		super.setColumnDefinitions(colDefs);
-		_comp.setColumnDefinitions(colDefs);
+		if (super.getColumnDefinitions()=3D=3DcolDefs) {
+			// if we got passed the same object as last time, we're still =
displaying the same stuff.
+			// If the the user decided to move some of the columns around, we =
should just leave them alone
+		} else {
+			super.setColumnDefinitions(colDefs);
+			_comp.setColumnDefinitions(colDefs);
+		}
 	}
=20
 	public void moveToTop()

The "Ugly as sin [SQL pane] print plugin" for 1.1 final 1 is quite usable now.  I've reduced the margins, reduced the font size, and fixed the tab printing bug.  It's now a very easy to use and even somewhat useful plugin!  Still no setup screen to change font, etc, but believe me, it'd be easy to add, and the source is in the jar.  I believe you'll find the default settings useful enough for SQL debug printing, however.

Here's the link:
http://mywebpages.comcast.net/rufbo1/wackApps/

Third from top/last one.

The whitespace plugin has some bugs, but is still useful enough that I use it weekly.  Included with the print free of charge, as always.  Oh boy.

Ruffin Bailey

Index: =
client-src/net/sourceforge/squirrel_sql/client/preferences/I18NStrings.p=
roperties
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
RCS file: =
D:/Personal2/Data_Files/CVSRepository/default/Squirrel-sql/client-src/ne=
t/sourceforge/squirrel_sql/client/preferences/I18NStrings.properties,v
retrieving revision 1.2
diff -u -r1.2 I18NStrings.properties
--- =
client-src/net/sourceforge/squirrel_sql/client/preferences/I18NStrings.p=
roperties	20 Mar 2004 18:12:43 -0000	1.2
+++ =
client-src/net/sourceforge/squirrel_sql/client/preferences/I18NStrings.p=
roperties	22 Mar 2004 16:42:11 -0000
@@ -49,4 +49,4 @@
 SQLPreferencesPanel.jdbcdebugfile=3DJDBC Debug File
 SQLPreferencesPanel.zerounlimited=3DZero means unlimited
 SQLPreferencesPanel.keepQueryResults=3DKeep the query result windows
-SQLPreferencesPanel.prettyPrintMetadata=3DPretty print the column =
metadata
+SQLPreferencesPanel.prettyPrintMetadata=3DPretty print the metadata
Index: =
client-src/net/sourceforge/squirrel_sql/client/session/mainpanel/objectt=
ree/tabs/table/ColumnsTab.java
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
RCS file: =
D:/Personal2/Data_Files/CVSRepository/default/Squirrel-sql/client-src/ne=
t/sourceforge/squirrel_sql/client/session/mainpanel/objecttree/tabs/tabl=
e/ColumnsTab.java,v
retrieving revision 1.2
diff -u -r1.2 ColumnsTab.java
--- =
client-src/net/sourceforge/squirrel_sql/client/session/mainpanel/objectt=
ree/tabs/table/ColumnsTab.java	20 Mar 2004 18:13:14 -0000	1.2
+++ =
client-src/net/sourceforge/squirrel_sql/client/session/mainpanel/objectt=
ree/tabs/table/ColumnsTab.java	22 Mar 2004 16:42:11 -0000
@@ -100,17 +100,15 @@
=20
 	private static final class NiceViewDataSet extends TransformerDataSet =
{
=20
-		private static final ColumnDisplayDefinition[] colDefs =3D new =
ColumnDisplayDefinition[2];
-		private static final DataSetDefinition _dataSetDefinition =3D new =
DataSetDefinition(colDefs);
-		static {
-			colDefs[0] =3D new ColumnDisplayDefinition(20, "Name");
-			colDefs[1] =3D new ColumnDisplayDefinition(60, "Description");
-		}
+		private static final ColumnDisplayDefinition[] colDefs =3D {
+			new ColumnDisplayDefinition(20, "Name"),
+			new ColumnDisplayDefinition(60, "Description")
+		};
 	=09
 		public NiceViewDataSet(IDataSet innerDataSet)=20
 			throws DataSetException=20
 		{=09
-			super(innerDataSet, _dataSetDefinition);
+			super(innerDataSet, colDefs);
 		}
=20
 		public synchronized Object get(int columnIndex) throws =
DataSetException
Index: =
client-src/net/sourceforge/squirrel_sql/client/session/mainpanel/objectt=
ree/tabs/table/ExportedKeysTab.java
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
RCS file: =
D:/Personal2/Data_Files/CVSRepository/default/Squirrel-sql/client-src/ne=
t/sourceforge/squirrel_sql/client/session/mainpanel/objecttree/tabs/tabl=
e/ExportedKeysTab.java,v
retrieving revision 1.1
diff -u -r1.1 ExportedKeysTab.java
--- =
client-src/net/sourceforge/squirrel_sql/client/session/mainpanel/objectt=
ree/tabs/table/ExportedKeysTab.java	20 Mar 2004 18:00:01 -0000	1.1
+++ =
client-src/net/sourceforge/squirrel_sql/client/session/mainpanel/objectt=
ree/tabs/table/ExportedKeysTab.java	22 Mar 2004 16:42:11 -0000
@@ -17,14 +17,22 @@
  * License along with this library; if not, write to the Free Software
  * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  =
02111-1307  USA
  */
+import java.sql.DatabaseMetaData;
 import java.sql.ResultSet;
 import java.sql.SQLException;
+import java.util.ArrayList;
+import java.util.Iterator;
+import java.util.List;
=20
+import =
net.sourceforge.squirrel_sql.fw.datasetviewer.ColumnDisplayDefinition;
+import =
net.sourceforge.squirrel_sql.fw.datasetviewer.DataSetDefinition;
 import net.sourceforge.squirrel_sql.fw.datasetviewer.DataSetException;
 import net.sourceforge.squirrel_sql.fw.datasetviewer.IDataSet;
+import =
net.sourceforge.squirrel_sql.fw.datasetviewer.ObjectArrayDataSet;
 import net.sourceforge.squirrel_sql.fw.datasetviewer.ResultSetDataSet;
 import net.sourceforge.squirrel_sql.fw.sql.ITableInfo;
 import net.sourceforge.squirrel_sql.fw.sql.SQLConnection;
+
 /**
  * This tab shows the columns in the currently selected table.
  *
@@ -75,8 +83,14 @@
 			try
 			{
 				final ResultSetDataSet rsds =3D new ResultSetDataSet();
- 				rsds.setResultSet(rs, =
getSession().getProperties().getLargeResultSetObjectInfo(), new int[] { =
1,2,3,4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14}, true);
-				return rsds;
+				if =
(getSession().getApplication().getSquirrelPreferences().getPrettyPrintMe=
tadata()) {
+					rsds.setResultSet(rs, =
getSession().getProperties().getLargeResultSetObjectInfo());=20
+					final IDataSet dataSet =3D buildNiceView(rsds);
+					return dataSet;
+				} else {
+	 				rsds.setResultSet(rs, =
getSession().getProperties().getLargeResultSetObjectInfo(), new int[] { =
1,2,3,4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14}, true);
+					return rsds;
+				}
 			}
 			finally
 			{
@@ -88,4 +102,147 @@
 			throw new DataSetException(ex);
 		}
 	}
+
+	/*
+		0  PKTABLE_CAT String =3D> primary key table catalog (may be null)=20
+		1  PKTABLE_SCHEM String =3D> primary key table schema (may be null)=20
+		2  PKTABLE_NAME String =3D> primary key table name=20
+		3  PKCOLUMN_NAME String =3D> primary key column name=20
+		4  FKTABLE_CAT String =3D> foreign key table catalog (may be null) =
being exported (may be null)=20
+		5  FKTABLE_SCHEM String =3D> foreign key table schema (may be null) =
being exported (may be null)=20
+		6  FKTABLE_NAME String =3D> foreign key table name being exported=20
+		7  FKCOLUMN_NAME String =3D> foreign key column name being exported=20
+		8  KEY_SEQ short =3D> sequence number within foreign key=20
+		9  UPDATE_RULE short =3D> What happens to foreign key when primary =
is updated:=20
+			importedNoAction - do not allow update of primary key if it has =
been imported=20
+			importedKeyCascade - change imported key to agree with primary key =
update=20
+			importedKeySetNull - change imported key to NULL if its primary key =
has been updated=20
+			importedKeySetDefault - change imported key to default values if =
its primary key has been updated=20
+			importedKeyRestrict - same as importedKeyNoAction (for ODBC 2.x =
compatibility)=20
+		10 DELETE_RULE short =3D> What happens to the foreign key when =
primary is deleted.=20
+			importedKeyNoAction - do not allow delete of primary key if it has =
been imported=20
+			importedKeyCascade - delete rows that import a deleted key=20
+			importedKeySetNull - change imported key to NULL if its primary key =
has been deleted=20
+			importedKeyRestrict - same as importedKeyNoAction (for ODBC 2.x =
compatibility)=20
+			importedKeySetDefault - change imported key to default if its =
primary key has been deleted=20
+		11 FK_NAME String =3D> foreign key name (may be null)=20
+		12 PK_NAME String =3D> primary key name (may be null)=20
+		13 DEFERRABILITY short =3D> can the evaluation of foreign key =
constraints be deferred until commit=20
+			importedKeyInitiallyDeferred - see SQL92 for definition=20
+			importedKeyInitiallyImmediate - see SQL92 for definition=20
+			importedKeyNotDeferrable - see SQL92 for definition=20
+	*/
+	private static final ColumnDisplayDefinition[] colDefs =3D {
+		new ColumnDisplayDefinition(20, "Foreign Key Table"),
+		new ColumnDisplayDefinition(20, "Foreign Key Name"),
+		new ColumnDisplayDefinition(20, "Foreign Key Columns"),
+		new ColumnDisplayDefinition(20, "Primary Key Name"),
+		new ColumnDisplayDefinition(20, "Primary Key Columns"),
+		new ColumnDisplayDefinition(20, "Modifiers"),
+	};
+
+	public static IDataSet buildNiceView(IDataSet dataSet) throws =
DataSetException {
+
+		final StringBuffer fkTableColumns =3D new StringBuffer();
+		final StringBuffer pkTableColumns =3D new StringBuffer();
+		final List list =3D new ArrayList();
+			=09
+		int lastKeySeq =3D -1;
+		while (true) {
+			final boolean isNext =3D dataSet.next(null);
+			if (!isNext && lastKeySeq=3D=3D-1) {
+				break; // no rows
+			}
+			final int thisKeySeq =3D =
Integer.parseInt(dataSet.get(8).toString());
+			if (!isNext || thisKeySeq<lastKeySeq) {
+				final String [] cols =3D new String[6];
+
+				cols[0] =3D=20
+					(dataSet.get(4)=3D=3Dnull ? "" : dataSet.get(4) + ".") // catalog
+					+ (dataSet.get(5)=3D=3Dnull ? "" : dataSet.get(5) + ".") // =
schema
+					+ dataSet.get(6); // fktable_name
+
+				cols[1] =3D dataSet.get(11).toString(); // fk_name
+			=09
+				cols[2] =3D fkTableColumns.toString();
+
+				cols[3] =3D (dataSet.get(0)=3D=3Dnull ? "" : dataSet.get(0) + ".") =
// catalog
+						+ (dataSet.get(1)=3D=3Dnull ? "" : dataSet.get(1) + ".") // =
schema
+						+ dataSet.get(2); // pktable_name
+
+				cols[4] =3D pkTableColumns.toString();
+
+				StringBuffer buf =3D new StringBuffer();
+			=09
+				final short updateRule =3D =
Short.parseShort(dataSet.get(9).toString());
+				updateDeleteRule(buf, "update", updateRule);
+
+				final short deleteRule =3D =
Short.parseShort(dataSet.get(10).toString());
+				updateDeleteRule(buf, "delete", deleteRule);
+
+				// FIXME not sure about the syntax for deferrability
+				final short deferrability =3D =
Short.parseShort(dataSet.get(13).toString());
+				if =
(deferrability=3D=3DDatabaseMetaData.importedKeyInitiallyImmediate) {
+				} else {
+					buf.append("defer ");
+					if =
(deferrability=3D=3DDatabaseMetaData.importedKeyInitiallyDeferred) {
+						buf.append("initial ");
+					} else if =
(deferrability=3D=3DDatabaseMetaData.importedKeyNotDeferrable) {
+						buf.append("not ");
+					}
+				}
+
+				cols[5] =3D buf.toString();
+
+				list.add(cols);
+
+				// clear buffers
+				buf.setLength(0);
+				fkTableColumns.setLength(0);
+				pkTableColumns.setLength(0);	=09
+			=09
+				lastKeySeq =3D -1;
+			} else {
+				lastKeySeq =3D thisKeySeq;
+			}
+			if (!isNext) {
+				break;
+			}
+
+			if (fkTableColumns.length()>0) {
+				fkTableColumns.append(", ");
+			}
+			fkTableColumns.append(dataSet.get(7));
+			if (pkTableColumns.length()>0) {
+				pkTableColumns.append(", ");
+			}
+			pkTableColumns.append(dataSet.get(3));	=09
+		}
+
+		final Object [][] objA =3D new Object[list.size()][0];
+		int i =3D 0;
+		for (Iterator iter=3Dlist.iterator(); iter.hasNext(); ) {
+			String[] item =3D (String[]) iter.next();
+			objA[i++] =3D item;
+		}
+		return new ObjectArrayDataSet(objA, new DataSetDefinition(colDefs));
+	}
+
+	private static void updateDeleteRule(final StringBuffer buf, String =
action, final short rule) {
+		if (rule=3D=3DDatabaseMetaData.importedKeyNoAction) {
+		} else if (rule=3D=3DDatabaseMetaData.importedKeyRestrict) {
+		} else {
+			buf.append("on ");
+			buf.append(action);
+			buf.append(" ");
+			if (rule=3D=3DDatabaseMetaData.importedKeyCascade) {
+				buf.append("cascade ");
+			} else if (rule=3D=3DDatabaseMetaData.importedKeySetNull) {
+				buf.append("set null ");
+			} else if (rule=3D=3DDatabaseMetaData.importedKeySetDefault) {
+				buf.append("set default ");
+			}
+		}
+	}
+
 }
Index: =
client-src/net/sourceforge/squirrel_sql/client/session/mainpanel/objectt=
ree/tabs/table/ImportedKeysTab.java
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
RCS file: =
D:/Personal2/Data_Files/CVSRepository/default/Squirrel-sql/client-src/ne=
t/sourceforge/squirrel_sql/client/session/mainpanel/objecttree/tabs/tabl=
e/ImportedKeysTab.java,v
retrieving revision 1.1
diff -u -r1.1 ImportedKeysTab.java
--- =
client-src/net/sourceforge/squirrel_sql/client/session/mainpanel/objectt=
ree/tabs/table/ImportedKeysTab.java	20 Mar 2004 18:00:01 -0000	1.1
+++ =
client-src/net/sourceforge/squirrel_sql/client/session/mainpanel/objectt=
ree/tabs/table/ImportedKeysTab.java	22 Mar 2004 16:42:11 -0000
@@ -77,8 +77,14 @@
 			try
 			{
 				final ResultSetDataSet rsds =3D new ResultSetDataSet();
- 				rsds.setResultSet(rs, =
getSession().getProperties().getLargeResultSetObjectInfo(), new int[] { =
1,2,3,4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14}, true);
-				return rsds;
+				if =
(getSession().getApplication().getSquirrelPreferences().getPrettyPrintMe=
tadata()) {
+					rsds.setResultSet(rs, =
getSession().getProperties().getLargeResultSetObjectInfo());=20
+					final IDataSet dataSet =3D ExportedKeysTab.buildNiceView(rsds);
+					return dataSet;
+				} else {
+	 				rsds.setResultSet(rs, =
getSession().getProperties().getLargeResultSetObjectInfo(), new int[] { =
1,2,3,4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14}, true);
+					return rsds;
+				}
 			}
 			finally
 			{
Index: =
client-src/net/sourceforge/squirrel_sql/client/session/mainpanel/objectt=
ree/tabs/table/PrimaryKeyTab.java
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
RCS file: =
D:/Personal2/Data_Files/CVSRepository/default/Squirrel-sql/client-src/ne=
t/sourceforge/squirrel_sql/client/session/mainpanel/objecttree/tabs/tabl=
e/PrimaryKeyTab.java,v
retrieving revision 1.1
diff -u -r1.1 PrimaryKeyTab.java
--- =
client-src/net/sourceforge/squirrel_sql/client/session/mainpanel/objectt=
ree/tabs/table/PrimaryKeyTab.java	20 Mar 2004 18:00:01 -0000	1.1
+++ =
client-src/net/sourceforge/squirrel_sql/client/session/mainpanel/objectt=
ree/tabs/table/PrimaryKeyTab.java	22 Mar 2004 16:42:11 -0000
@@ -17,12 +17,17 @@
  * License along with this library; if not, write to the Free Software
  * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  =
02111-1307  USA
  */
+import java.math.BigDecimal;
 import java.sql.ResultSet;
 import java.sql.SQLException;
+import java.sql.Types;
=20
+import =
net.sourceforge.squirrel_sql.fw.datasetviewer.ColumnDisplayDefinition;
+import =
net.sourceforge.squirrel_sql.fw.datasetviewer.DataSetDefinition;
 import net.sourceforge.squirrel_sql.fw.datasetviewer.DataSetException;
 import net.sourceforge.squirrel_sql.fw.datasetviewer.IDataSet;
 import net.sourceforge.squirrel_sql.fw.datasetviewer.ResultSetDataSet;
+import =
net.sourceforge.squirrel_sql.fw.datasetviewer.TransformerDataSet;
 import net.sourceforge.squirrel_sql.fw.sql.SQLConnection;
 /**
  * This tab shows the primary key info for the currently selected =
table.
@@ -73,8 +78,13 @@
 			try
 			{
 				final ResultSetDataSet rsds =3D new ResultSetDataSet();
- 				rsds.setResultSet(rs, =
getSession().getProperties().getLargeResultSetObjectInfo(), new int[] { =
6, 5, 4 }, true);
-				return rsds;
+				if =
(getSession().getApplication().getSquirrelPreferences().getPrettyPrintMe=
tadata()) {
+					rsds.setResultSet(rs, =
getSession().getProperties().getLargeResultSetObjectInfo());=20
+					return new NiceViewDataSet(rsds);
+				} else {
+ 					rsds.setResultSet(rs, =
getSession().getProperties().getLargeResultSetObjectInfo(), new int[] { =
6, 5, 4 }, true);
+					return rsds;
+				}
 			}
 			finally
 			{
@@ -86,4 +96,35 @@
 			throw new DataSetException(ex);
 		}
 	}
+
+	private static final class NiceViewDataSet extends TransformerDataSet =
{
+
+		private static final ColumnDisplayDefinition[] colDefs =3D {
+			new ColumnDisplayDefinition(20, "Primary Key Name"),
+			new ColumnDisplayDefinition(10, "Sequence"),
+			new ColumnDisplayDefinition(20, "Column Name")
+		};
+	=09
+		public NiceViewDataSet(IDataSet innerDataSet)=20
+			throws DataSetException=20
+		{=09
+			super(innerDataSet, colDefs);
+		}
+
+		public synchronized Object get(int columnIndex) throws =
DataSetException
+		{
+			if (columnIndex=3D=3D0) {
+				return this._innerDataSet.get(5);
+			} else if (columnIndex=3D=3D1) {
+				return this._innerDataSet.get(4);
+			} else if (columnIndex=3D=3D2) {
+				return this._innerDataSet.get(3);
+			} else {
+				throw new IllegalStateException(""+columnIndex);
+			}
+		}
+
+	}
+
+
 }
Index: =
fw-src/net/sourceforge/squirrel_sql/fw/datasetviewer/TransformerDataSet.=
java
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
RCS file: =
D:/Personal2/Data_Files/CVSRepository/default/Squirrel-sql/fw-src/net/so=
urceforge/squirrel_sql/fw/datasetviewer/TransformerDataSet.java,v
retrieving revision 1.1
diff -u -r1.1 TransformerDataSet.java
--- =
fw-src/net/sourceforge/squirrel_sql/fw/datasetviewer/TransformerDataSet.=
java	20 Mar 2004 18:11:21 -0000	1.1
+++ =
fw-src/net/sourceforge/squirrel_sql/fw/datasetviewer/TransformerDataSet.=
java	22 Mar 2004 16:42:11 -0000
@@ -24,6 +24,14 @@
 	protected IDataSet _innerDataSet;
 	private DataSetDefinition _innerDataSetDef;
=20
+	/**
+	 * convenience constructor
+	 */
+	public TransformerDataSet(IDataSet innerDataSet, =
ColumnDisplayDefinition[] colDefs) throws DataSetException
+	{
+		this(innerDataSet, new DataSetDefinition(colDefs));
+	}
+=09
 	public TransformerDataSet(IDataSet innerDataSet, DataSetDefinition =
innerDataSetDef) throws DataSetException
 	{
 		super();

I've mentioned to Colin previously I would do something about key 
mapping on Mac OSX. I have had an ongoing problem that by default the 
Quit Application on the mac is <apple key>Q which if you did that in 
Squirrel SQL it wouldn't write out configuration files - e.g. drivers 
and alias lists. The same would be true if you just closed the window, 
or selected quit from the application menu (a special menu that OS/X 
adds to every app). I could always get around that by using <ctrl>Q or 
File->Quit but that wasn't very apple-like and I kept on forgetting.

So as a start of that, I've written something to get the About and Quit 
menu items working as-per Apple. This consists of a quick change to 
MainFrameMenuBar.java to disable the normal menu items on OS/X, and a 
Mac OS/X plugin to enable the apple-style menus.

Anyone interested let me know.

Neville


--------------------------------------------------------------------------------
The information contained herein is confidential and is intended solely for the
addressee. Access by any other party is unauthorised without the express 
written permission of the sender. If you are not the intended recipient, please 
contact the sender either via the company switchboard on +44 (0)20 7623 8000, or
via e-mail return. If you have received this e-mail in error or wish to read our
e-mail disclaimer statement and monitoring policy, please refer to 
http://www.drkw.com/disc/email/ or contact the sender.
--------------------------------------------------------------------------------

Hi,

Just a quick note to let you all know that I'm away for the next two
weeks - a very delayed honeymoon.

I'll be applying the last of the patches when I get back.

-- 
Colin Bell
http://squirrel-sql.sf.net

Hi everybody,

I have just moved house and my PC has been packed away in a box for the
last week or so. My wife has now allowed me to unpack it so I'm back
online :-)

I'll be catching up with my email over the next few nights.

-- 
Colin Bell
http://squirrel-sql.sf.net

Any way to develop a plugin to show the Object tree on the SQL tab?  Also,
could you drag a Table name from the Object tree into the SQL Editor and it
would insert the Table name into the sql statement at the location of the
cursor?

diff -ur =
..\..\..\squirrel-sql-src-1.2beta4.tar\client-src\net\sourceforge\squir=
rel_sql\client\preferences\I18NStrings.properties =
.\net\sourceforge\squirrel_sql\client\preferences\I18NStrings.propertie=
s
--- =
..\..\..\squirrel-sql-src-1.2beta4.tar\client-src\net\sourceforge\squir=
rel_sql\client\preferences\I18NStrings.properties	Mon Oct 06 19:37:50 =
2003
+++ =
.\net\sourceforge\squirrel_sql\client\preferences\I18NStrings.propertie=
s	Wed Mar 03 21:54:04 2004
@@ -46,4 +46,7 @@
 SQLPreferencesPanel.logintimeout=3DLogin Timeout (secs):
 SQLPreferencesPanel.title=3DSQL
 SQLPreferencesPanel.jdbcdebug=3DJDBC Debug (can slow application)
+SQLPreferencesPanel.jdbcdebugfile=3DJDBC Debug File
 SQLPreferencesPanel.zerounlimited=3DZero means unlimited
+SQLPreferencesPanel.keepQueryResults=3DKeep the query result windows
+SQLPreferencesPanel.prettyPrintMetadata=3DPretty print the column =
metadata
diff -ur =
..\..\..\squirrel-sql-src-1.2beta4.tar\client-src\net\sourceforge\squir=
rel_sql\client\preferences\SQLPreferencesPanel.java =
.\net\sourceforge\squirrel_sql\client\preferences\SQLPreferencesPanel.j=
ava
--- =
..\..\..\squirrel-sql-src-1.2beta4.tar\client-src\net\sourceforge\squir=
rel_sql\client\preferences\SQLPreferencesPanel.java	Mon Oct 06 19:38:36 =
2003
+++ =
.\net\sourceforge\squirrel_sql\client\preferences\SQLPreferencesPanel.j=
ava	Wed Mar 03 22:12:04 2004
@@ -18,11 +18,14 @@
  * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  =
02111-1307  USA
  */
 import java.awt.Component;
+import java.awt.FlowLayout;
 import java.awt.GridBagConstraints;
 import java.awt.GridBagLayout;
 import java.awt.Insets;
=20
 import javax.swing.BorderFactory;
+import javax.swing.Box;
+import javax.swing.BoxLayout;
 import javax.swing.JCheckBox;
 import javax.swing.JLabel;
 import javax.swing.JPanel;
@@ -105,20 +108,10 @@
=20
 	private static final class SQLPrefsPanel extends JPanel
 	{
-		/**
-		 * This interface defines locale specific strings. This should be
-		 * replaced with a property file.
-		 */
-		interface SQLPrefsPanelI18n
-		{
-//			String DEBUG_JDBC =3D "JDBC Debug (can slow application)";
-//			String LOGIN_TIMEOUT =3D "Login Timeout (secs):";
-//			String TAB_HINT =3D "SQL";
-//			String TAB_TITLE =3D "SQL";
-		}
-
 		private IntegerField _loginTimeout =3D new IntegerField();
 		private JCheckBox _debugJdbc =3D new =
JCheckBox(s_stringMgr.getString("SQLPreferencesPanel.jdbcdebug"));
+		private JCheckBox _keepQueryResults =3D new =
JCheckBox(s_stringMgr.getString("SQLPreferencesPanel.keepQueryResults"))=
;
+		private JCheckBox _prettyPrintMetadata =3D new =
JCheckBox(s_stringMgr.getString("SQLPreferencesPanel.prettyPrintMetadata=
"));
 		private JLabel _jdbcDebugLogFileNameLbl =3D new OutputLabel(" ");
=20
 		SQLPrefsPanel()
@@ -132,6 +125,8 @@
 			final ApplicationFiles appFiles =3D new ApplicationFiles();
 			_loginTimeout.setInt(prefs.getLoginTimeout());
 			_debugJdbc.setSelected(prefs.getDebugJdbc());
+			_keepQueryResults.setSelected(prefs.getKeepQueryResults());
+			_prettyPrintMetadata.setSelected(prefs.getPrettyPrintMetadata());
 			=
_jdbcDebugLogFileNameLbl.setText(appFiles.getJDBCDebugLogFile().getPath(=
));
 		}
=20
@@ -139,6 +134,8 @@
 		{
 			prefs.setLoginTimeout(_loginTimeout.getInt());
 			prefs.setDebugJdbc(_debugJdbc.isSelected());
+			prefs.setKeepQueryResults(_keepQueryResults.isSelected());
+			prefs.setPrettyPrintMetadata(_prettyPrintMetadata.isSelected());
 		}
=20
 		private void createUserInterface()
@@ -156,26 +153,27 @@
=20
 		private JPanel createGeneralPanel()
 		{
-			JPanel pnl =3D new JPanel(new GridBagLayout());
+			final JPanel pnl =3D new JPanel();
+			pnl.setLayout(new BoxLayout(pnl, BoxLayout.Y_AXIS));
 			=
pnl.setBorder(BorderFactory.createTitledBorder(s_stringMgr.getString("SQ=
LPreferencesPanel.general")));
=20
+			final Box pnl2 =3D new Box(BoxLayout.X_AXIS);
+			pnl.add(pnl2);
+				=09
 			_loginTimeout.setColumns(4);
-
-			final GridBagConstraints gbc =3D new GridBagConstraints();
-			gbc.anchor =3D GridBagConstraints.WEST;
-			gbc.fill =3D GridBagConstraints.NONE;
-			gbc.insets =3D new Insets(4, 4, 4, 4);
-
-			gbc.gridx =3D 0;
-			gbc.gridy =3D 0;
-			pnl.add(new =
JLabel(s_stringMgr.getString("SQLPreferencesPanel.logintimeout")), =
gbc);
-
-			++gbc.gridx;
-			pnl.add(_loginTimeout, gbc);
-
-			++gbc.gridx;
-			gbc.weightx =3D 1;
-			pnl.add(new =
JLabel(s_stringMgr.getString("SQLPreferencesPanel.zerounlimited")), =
gbc);
+			pnl2.add(new =
JLabel(s_stringMgr.getString("SQLPreferencesPanel.logintimeout")));
+			pnl2.add(Box.createHorizontalStrut(10));
+			pnl2.add(_loginTimeout);
+			pnl2.add(Box.createHorizontalStrut(10));
+			pnl2.add(new =
JLabel(s_stringMgr.getString("SQLPreferencesPanel.zerounlimited")));
+
+			final JPanel pnl3 =3D new JPanel(new FlowLayout(FlowLayout.LEFT));
+			pnl.add(pnl3);
+			pnl3.add(_keepQueryResults);
+
+			final JPanel pnl4 =3D new JPanel(new FlowLayout(FlowLayout.LEFT));
+			pnl.add(pnl4);
+			pnl4.add(_prettyPrintMetadata);
=20
 			return pnl;
 		}
diff -ur =
..\..\..\squirrel-sql-src-1.2beta4.tar\client-src\net\sourceforge\squir=
rel_sql\client\preferences\SquirrelPreferences.java =
.\net\sourceforge\squirrel_sql\client\preferences\SquirrelPreferences.j=
ava
--- =
..\..\..\squirrel-sql-src-1.2beta4.tar\client-src\net\sourceforge\squir=
rel_sql\client\preferences\SquirrelPreferences.java	Mon Oct 06 19:23:10 =
2003
+++ =
.\net\sourceforge\squirrel_sql\client\preferences\SquirrelPreferences.j=
ava	Wed Mar 03 21:39:12 2004
@@ -37,6 +37,7 @@
 import =
net.sourceforge.squirrel_sql.client.mainframe.MainFrameWindowState;
 import =
net.sourceforge.squirrel_sql.client.session.properties.SessionProperties=
;
 import net.sourceforge.squirrel_sql.client.util.ApplicationFiles;
+
 /**
  * This class represents the application preferences.
  *
@@ -49,6 +50,8 @@
 		String ACTION_KEYS =3D "actionKeys";
 		String ALIASES_SELECTED_INDEX =3D "aliasesSelectdIndex";
 		String DEBUG_JDBC =3D "debugJdbc";
+		String KEEP_QUERY_RESULTS=3D"keepQueryResults";
+		String PRETTY_PRINT_METADATA=3D"prettyPrintMetadata";
 		String DRIVERS_SELECTED_INDEX =3D "driversSelectdIndex";
 		String LOGIN_TIMEOUT =3D "loginTimeout";
 		String MAIN_FRAME_STATE =3D "mainFrameWindowState";
@@ -93,6 +96,12 @@
 	/** Login timeout (seconds). */
 	private int _loginTimeout =3D 30;
=20
+	/** Keep the query results tabs between user-activated queries */
+	private boolean _keepQueryResults =3D true;
+
+	/** Pretty print the metadata for table columns */
+	private boolean _prettyPrintMetadata =3D true;
+
 	/** Show tooltips for controls. */
 	private boolean _showToolTips =3D true;
=20
@@ -132,6 +141,25 @@
 	/** Show loaded drivers only in the Drivers window. */
 	private boolean _showLoadedDriversOnly;
=20
+	private boolean _columnsViewtableCat;
+	private boolean _columnsViewtableSchem;
+	private boolean _columnsViewtableName;
+	private boolean _columnsViewcolumnName;
+	private boolean _columnsViewdataType;
+	private boolean _columnsViewtypeName;
+	private boolean _columnsViewcolumnSize;
+	private boolean _columnsViewbufferLength;
+	private boolean _columnsViewdecimalDigits;
+	private boolean _columnsViewnumPrecRadix;
+	private boolean _columnsViewnullable;
+	private boolean _columnsViewremarks;
+	private boolean _columnsViewcolumnDef;
+	private boolean _columnsViewsqlDataType;
+	private boolean _columnsViewsqlDatetimeSub;
+	private boolean _columnsViewcharOctetLength;
+	private boolean _columnsViewordinalPosition;
+	private boolean _columnsViewisNullable;
+
 	/**
 	 * Objects stored by plugins. Each element of this collection is a =
<TT>Map</TT>
 	 * keyed by the plugin's internal name and containing all objects for =
that
@@ -291,6 +319,30 @@
 		final boolean oldValue =3D _debugJdbc;
 		_debugJdbc =3D data;
 		=
getPropertyChangeReporter().firePropertyChange(IPropertyNames.DEBUG_JDBC=
, oldValue, _debugJdbc);
+	}
+
+	public boolean getKeepQueryResults()
+	{
+		return _keepQueryResults;
+	}
+
+	public synchronized void setKeepQueryResults(boolean data)
+	{
+		final boolean oldValue =3D _keepQueryResults;
+		_keepQueryResults =3D data;
+		getPropertyChangeReporter().firePropertyChange(IPropertyNames.KEEP_QU=
ERY_RESULTS, oldValue, _keepQueryResults);
+	}
+
+	public boolean getPrettyPrintMetadata()
+	{
+		return _prettyPrintMetadata;
+	}
+
+	public synchronized void setPrettyPrintMetadata(boolean data)
+	{
+		final boolean oldValue =3D _prettyPrintMetadata;
+		_prettyPrintMetadata =3D data;
+		=
getPropertyChangeReporter().firePropertyChange(IPropertyNames.PRETTY_PRI=
NT_METADATA, oldValue, _keepQueryResults);
 	}
=20
 	public boolean getShowToolTips()
diff -ur =
..\..\..\squirrel-sql-src-1.2beta4.tar\client-src\net\sourceforge\squir=
rel_sql\client\session\mainpanel\objecttree\tabs\table\ColumnsTab.java =
.\net\sourceforge\squirrel_sql\client\session\mainpanel\objecttree\tabs=
\table\ColumnsTab.java
--- =
..\..\..\squirrel-sql-src-1.2beta4.tar\client-src\net\sourceforge\squir=
rel_sql\client\session\mainpanel\objecttree\tabs\table\ColumnsTab.java	=
Tue Mar 25 14:21:10 2003
+++ =
.\net\sourceforge\squirrel_sql\client\session\mainpanel\objecttree\tabs=
\table\ColumnsTab.java	Wed Mar 03 21:49:36 2004
@@ -17,12 +17,17 @@
  * License along with this library; if not, write to the Free Software
  * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  =
02111-1307  USA
  */
+import java.math.BigDecimal;
 import java.sql.ResultSet;
 import java.sql.SQLException;
+import java.sql.Types;
=20
+import =
net.sourceforge.squirrel_sql.fw.datasetviewer.ColumnDisplayDefinition;
+import =
net.sourceforge.squirrel_sql.fw.datasetviewer.DataSetDefinition;
 import net.sourceforge.squirrel_sql.fw.datasetviewer.DataSetException;
 import net.sourceforge.squirrel_sql.fw.datasetviewer.IDataSet;
 import net.sourceforge.squirrel_sql.fw.datasetviewer.ResultSetDataSet;
+import =
net.sourceforge.squirrel_sql.fw.datasetviewer.TransformerDataSet;
 import net.sourceforge.squirrel_sql.fw.sql.SQLConnection;
 /**
  * This tab shows the columns in the currently selected table.
@@ -73,8 +78,14 @@
 			try
 			{
 				final ResultSetDataSet rsds =3D new ResultSetDataSet();
- 				rsds.setResultSet(rs, =
getSession().getProperties().getLargeResultSetObjectInfo(), new int[] { =
4, 6, 7, 9, 18, 13, 12, 5, 8, 10, 11, 14, 15, 16, 17 }, true);
-				return rsds;
+				if =
(getSession().getApplication().getSquirrelPreferences().getPrettyPrintMe=
tadata()) {
+					rsds.setResultSet(rs, =
getSession().getProperties().getLargeResultSetObjectInfo());=20
+					return new NiceViewDataSet(rsds);
+				} else {
+					rsds.setResultSet(rs, =
getSession().getProperties().getLargeResultSetObjectInfo(),=20
+							new int[] { 4, 6, 7, 9, 18, 13, 12, 5, 8, 10, 11, 14, 15, 16, =
17 }, true);
+					return rsds;
+				}
 			}
 			finally
 			{
@@ -86,4 +97,60 @@
 			throw new DataSetException(ex);
 		}
 	}
+
+	private static final class NiceViewDataSet extends TransformerDataSet =
{
+
+		private static final ColumnDisplayDefinition[] colDefs =3D new =
ColumnDisplayDefinition[2];
+		private static final DataSetDefinition _dataSetDefinition =3D new =
DataSetDefinition(colDefs);
+		static {
+			colDefs[0] =3D new ColumnDisplayDefinition(20, "Name");
+			colDefs[1] =3D new ColumnDisplayDefinition(60, "Description");
+		}
+	=09
+		public NiceViewDataSet(IDataSet innerDataSet)=20
+			throws DataSetException=20
+		{=09
+			super(innerDataSet, _dataSetDefinition);
+		}
+
+		public synchronized Object get(int columnIndex) throws =
DataSetException
+		{
+			if (columnIndex=3D=3D0) {
+				return this._innerDataSet.get(3);
+			} else if (columnIndex=3D=3D1) {
+				String s =3D (String) this._innerDataSet.get(5);
+				final int sqlType =3D ((BigDecimal) =
this._innerDataSet.get(4)).intValue();
+				switch (sqlType) {
+					case Types.CHAR :=20
+					case Types.VARCHAR :=20
+					case Types.LONGVARCHAR :=20
+					case Types.BINARY :
+					case Types.VARBINARY :
+					case Types.LONGVARBINARY :=20
+						s +=3D "(" + this._innerDataSet.get(6) + ")";
+						break;
+					case Types.NUMERIC :=20
+					case Types.DECIMAL :=20
+						s +=3D "(" + this._innerDataSet.get(6) + "," + =
this._innerDataSet.get(8) + ")";
+						break;
+					default : ;
+				}
+				if (this._innerDataSet.get(17).equals("NO")) {
+					s +=3D " NOT NULL";
+				}
+				if (this._innerDataSet.get(12)!=3Dnull) {
+					s +=3D " DEFAULT " + this._innerDataSet.get(12);
+				}
+				final String remark =3D (String) this._innerDataSet.get(11);
+				if (remark!=3Dnull && remark.length()>0) {
+					s +=3D " REMARK \"" + remark + "\"";
+				}
+				return s;			=09
+			} else {
+				throw new IllegalStateException(""+columnIndex);
+			}
+		}
+
+	}
+
 }
diff -ur =
..\..\..\squirrel-sql-src-1.2beta4.tar\client-src\net\sourceforge\squir=
rel_sql\client\session\mainpanel\SQLExecuterTask.java =
.\net\sourceforge\squirrel_sql\client\session\mainpanel\SQLExecuterTask=
.java
--- =
..\..\..\squirrel-sql-src-1.2beta4.tar\client-src\net\sourceforge\squir=
rel_sql\client\session\mainpanel\SQLExecuterTask.java	Fri Aug 22 =
21:24:28 2003
+++ =
.\net\sourceforge\squirrel_sql\client\session\mainpanel\SQLExecuterTask=
.java	Wed Mar 03 20:12:14 2004
@@ -39,6 +39,9 @@
 import javax.swing.JLabel;
 import javax.swing.JPanel;
=20
+import =
net.sourceforge.squirrel_sql.client.preferences.SquirrelPreferences;
+import net.sourceforge.squirrel_sql.client.session.ISession;
+import =
net.sourceforge.squirrel_sql.client.session.properties.SessionProperties=
;
 import net.sourceforge.squirrel_sql.fw.datasetviewer.DataSetException;
 import net.sourceforge.squirrel_sql.fw.datasetviewer.ResultSetDataSet;
 import =
net.sourceforge.squirrel_sql.fw.datasetviewer.ResultSetMetaDataDataSet;
@@ -48,9 +51,6 @@
 import net.sourceforge.squirrel_sql.fw.util.log.ILogger;
 import net.sourceforge.squirrel_sql.fw.util.log.LoggerController;
=20
-import net.sourceforge.squirrel_sql.client.session.ISession;
-import =
net.sourceforge.squirrel_sql.client.session.properties.SessionProperties=
;
-
 public class SQLExecuterTask implements Runnable
 {
 	/** Logger for this class. */
@@ -133,6 +133,10 @@
 				_cancelPanel.setQueryCount(queryStrings.size());
 				_currentQueryIndex =3D 0;
=20
+				if =
(!_session.getApplication().getSquirrelPreferences().getKeepQueryResults=
()) {
+					_sqlPanel.closeAllSQLResultTabs();
+				}
+			=09
 				// Process each individual query.
 				boolean maxRowsHasBeenSet =3D correctlySupportsMaxRows;
 				while (!queryStrings.isEmpty())

First off -- is sourceforge dropping archives of this list or is it just me?

Fwiw, the SqlWhitespace plugin I mentioned before should be working relatively well now.  Nested statements aren't handled expertly yet (should be indented, at least) and I still haven't fixed the app.getActiveSessions()[0].getSQLPanelAPI(this) kludge.

The SqlWhitespace plugin makes your single line, computer generated SQL purty enough to debug.  Also includes a fancy-smancy printing plugin FOR NO EXTRA CHARGE.  ;^)  Source is in the "jarball" as well.

The plugin is for SQuirreL 1.1, though it's simple enough I'm hopeful it'll be easy to port.

http://mywebpages.comcast.net/rufbo1/wackApps/SqlWhitespace.jar

Will also need to drop this jar in your lib folder:
http://mywebpages.comcast.net/rufbo1/wackApps/lib/jakarta-oro-2.0.8.jar

Also noticed the print plugin wasn't handling tabs well -- I'll just search and replace those with spaces soon.

Enjoy, etc.  For entertainment purposes only.  Comments & flames welcome.

Ruffin Bailey

The default font used for menues, buttons etc. in the Metal look and
feel is a bold serif kind of font, which looks really ugly. This is not
fault of Squirrel but that of the Metal L&F theme.
(You get the Metal L&F as default when running a Swing app on Linux or
other Unix'es).

It is quite easy to top level change that font into a more reasonable
"standard" font. Below is a function which does the job!

The function must be called in the program initialization fase sometimes
before the instantiation of the first window (Code snippet to handle
this shown further down).

// Change all font resources into using a non bold sans serif font
// with user specified font size!
public static void setFont(int fontSize) {
  Font defaultFont= new Font("SansSerif", Font.PLAIN, fontSize);
  for(Enumeration i=UIManager.getDefaults().keys();         
	i.hasMoreElements();) 
  {
    Object key= i.nextElement();
    if(UIManager.get(key) instanceof FontUIResource) {
      UIManager.put(key, new FontUIResource(defaultFont));
    }
  }
}


Example of an application main, which I use for most swing apps

public static void main(String[] args)
{
  try
  {
    // Set look and feel to the system default.
    // On systems where default is "Metal", replace the default font
    String uiClassName = UIManager.getSystemLookAndFeelClassName();
    if(uiClassName.endsWith("MetalLookAndFeel")) {
      setFont(12);
    }
    UIManager.setLookAndFeel(uiClassName);
  }
  catch(Exception e)
  {
    e.printStackTrace();
  }
  new App();
}

NOTE: I'm not an active Squirrel developer so I don't have source update
access. I would be happy if the maintainer could apply the code!

/Kim

If we want to give the use the best chance of being able to edit a cell 
in the SQL tab, we could use the following algorithm.

STARTING CONDITIONS:
- user has edited a cell and just exited it
- we have the original SQL statement
- we have the result set

ALGORITHM:
- extract the FROM clause, starting from the end of 'FROM' and going to 
the end of the statement, a 'WHERE', or an 'ORDER BY'.  (Do we need to 
look for other things?)
- get the list of tablesAndAlias names (separate the FROM clause at the 
commas, if any)
- for each name, separate the table name from the alias, if any, and 
remember both for later use
- For each table, get all of that table's column info
- For each column in the result set, identify which tables it belongs 
to.  A column may belong to multiple tables.
- For each table that the edited element belongs to:
    - create a WHERE clause using all of the columns in the
       result set that belong to that table
    - check for # of rows matching existing data.
        Warn user about multiple rows being updated.
        If user decides not to proceed, abort the update.
    - check for # of rows matching data after the proposed update.
        Warn user about multiple rows matching after update.
        If use decides not to proceed, abort the update.
- Start a transaction
- For each table that the edited element belongs to:
    - update the table
- End transaction

<END ALGORITHM>

For queries involving a single table, this degenerates into something 
similar to the ContentsTab, though with the possibility that the user 
did not include all of the fields from the table.  This will certainly 
work as well as ContentsTab for "SELECT * FROM <table> [WHERE...]" 
queries, and will also allow for updates in some joins.

The question comes down to, how often will the query contain enough 
fields from the table(s) to uniquely identify a single row in the table 
being updated?

Glenn

Colin Bell wrote:

>>-----Original Message-----
>>From: gwg [mailto:gw...@co...]
>>Sent: Friday, 6 February 2004 15:55
>>To: squ...@li...
>>Subject: Re: [Squirrel-sql-develop] New plugin planned
>>
>>
>>Help me out here.  If someone is looking at just one table, 
>>why are they 
>>not using the ContentsTab?  Since one of our fellow contributors 
>>recently added the ability to do a WHERE clause filter on the 
>>ContentsTab, it seems to me the user gets the same capability 
>>with less 
>>typing than in the SQL tab.  Given the severe limitations on 
>>what could 
>>be updateable in the SQL tab and the inconsistancy of 
>>sometimes-editable 
>>sometimes-not, what would be the benefit of adding editing 
>>there?  Maybe 
>>instead of adding that feature, we just point people to the 
>>ContentsTab?
>>
>>Of course, if you could edit/update the results of a join, 
>>that would be 
>>a different story, but I haven't heard any suggestions on how 
>>to do that.
>>
>>
> 
> Sorry, missed this paragraph when I first read the email, I definitel;y need
> some sleep. Good question. I tend to use the filter a lot, drilling down to
> the data I actually want to view. Most of the 1.2 enhancements aren't yet in
> the help text (the only stuff thats there really is what you have done, I
> haven't got around to it yet). Once its properly documented I suspect that
> most people will use it. If the SQL starts getting more complicated and they
> move to the SQL tab the query probably won't be updateable anyway. But
> remember that queries like
> 
> select * from tab1 where col1 in (select col1 friom tab2 where ...)
> 
> should be updateable but cannot easily be done (unless I've missed somethign
> obvious) in the filter dialog.
> 
> Also there will always be people who prefer keying up the SQL rather than
> using a point and click interface so I think we should allow maintenacne
> from the SQL tab. But your point emphasises that allowing it from the SQL
> tab is secondary, I think it should be be working fully in the Contents tab
> before its applied to the SQL tab.
> 
> My 2 cents worth
> 
> Col
> 
> 
> 
> -------------------------------------------------------
> The SF.Net email is sponsored by EclipseCon 2004
> Premiere Conference on Open Tools Development and Integration
> See the breadth of Eclipse activity. February 3-5 in Anaheim, CA.
> http://www.eclipsecon.org/osdn
> _______________________________________________
> Squirrel-sql-develop mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
> 
> 

> -----Original Message-----
> From: gwg [mailto:gw...@co...]
> Sent: Friday, 6 February 2004 15:55
> To: squ...@li...
> Subject: Re: [Squirrel-sql-develop] New plugin planned
> 
> 
> Help me out here.  If someone is looking at just one table, 
> why are they 
> not using the ContentsTab?  Since one of our fellow contributors 
> recently added the ability to do a WHERE clause filter on the 
> ContentsTab, it seems to me the user gets the same capability 
> with less 
> typing than in the SQL tab.  Given the severe limitations on 
> what could 
> be updateable in the SQL tab and the inconsistancy of 
> sometimes-editable 
> sometimes-not, what would be the benefit of adding editing 
> there?  Maybe 
> instead of adding that feature, we just point people to the 
> ContentsTab?
> 
> Of course, if you could edit/update the results of a join, 
> that would be 
> a different story, but I haven't heard any suggestions on how 
> to do that.
> 

Sorry, missed this paragraph when I first read the email, I definitel;y need
some sleep. Good question. I tend to use the filter a lot, drilling down to
the data I actually want to view. Most of the 1.2 enhancements aren't yet in
the help text (the only stuff thats there really is what you have done, I
haven't got around to it yet). Once its properly documented I suspect that
most people will use it. If the SQL starts getting more complicated and they
move to the SQL tab the query probably won't be updateable anyway. But
remember that queries like

select * from tab1 where col1 in (select col1 friom tab2 where ...)

should be updateable but cannot easily be done (unless I've missed somethign
obvious) in the filter dialog.

Also there will always be people who prefer keying up the SQL rather than
using a point and click interface so I think we should allow maintenacne
from the SQL tab. But your point emphasises that allowing it from the SQL
tab is secondary, I think it should be be working fully in the Contents tab
before its applied to the SQL tab.

My 2 cents worth

Col

> -----Original Message-----
> From: Stanislaw Berka [mailto:sb...@po...]
> Sent: Saturday, 7 February 2004 4:08
> To: gwg
> Cc: squ...@li...
> Subject: [Squirrel-sql-develop] Re: New plugin planned
> 
> By the way, do you know if there is a way to do cvs checkout 
> from behind 
> the firewall without having to open the port on the firewall? 
>  Our admin 
> is rather particular about it.  Like over http?  Sorry, if 
> it's a stupid 
> question.  We've been using cvs only internallly, so far.
> 

Hi Stan,

Take a look at this link

http://sourceforge.net/docman/display_doc.php?docid=14033&group_id=1#firewal
l

for info about accessing CVS at SF from behing a firewall. I've had some
limited success doing this - some days it works, some days it doesn't. I
tried a couple of days ago and it didn't work but SF were doing some CVS
upgrades at the time.

Col

> -----Original Message-----
> From: gwg [mailto:gw...@co...]
> Sent: Friday, 6 February 2004 15:55
> To: squ...@li...
> Subject: Re: [Squirrel-sql-develop] New plugin planned
> 

> 
> 
> Well, we could be a bit less restrictive by saying:
> - any table with a primary key OR
> - any query of the form "SELECT * FROM <table> [WHERE...]"
> That would give us enough to do the same update we do now in 
> ContentsTab.  Of course, that eliminates the really useful 
> part of the 
> SQL tab - the ability to do joins.  It could also be rather 
> annoying to 
> have the results be sometimes editable and sometimes not.

Of course if I'd thought about it properly I would have realized this. If we
use the same restriction (I.E. if the update will only update 1 rows then
its _safe_) then we can allow updates on a greater number of queries. As
well as only one table in the column list there should be no join clause.

It doesn't elimate joins in the SQL tab, it just means that if you use joins
(either in the FROM/WHERE clauses or in the JOIN clause) then you can't
update the data. I don't see a problem with this.

Col