01: package net.sourceforge.squirrel_sql.plugins.editextras;
02:
03: /*
04: * Copyright (C) 2003 Gerd Wagner
05: *
06: * This program is free software; you can redistribute it and/or
07: * modify it under the terms of the GNU General Public License
08: * as published by the Free Software Foundation; either version 2
09: * of the License, or any later version.
10: *
11: * This program is distributed in the hope that it will be useful,
12: * but WITHOUT ANY WARRANTY; without even the implied warranty of
13: * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
14: * GNU General Public License for more details.
15: *
16: * You should have received a copy of the GNU General Public License
17: * along with this program; if not, write to the Free Software
18: * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
19: */
20: import net.sourceforge.squirrel_sql.fw.util.BaseException;
21: import net.sourceforge.squirrel_sql.fw.util.ICommand;
22:
23: import net.sourceforge.squirrel_sql.client.session.ISQLPanelAPI;
24: import net.sourceforge.squirrel_sql.client.session.ISQLEntryPanel;
25:
26: /**
27: * This command will remove "quotes" from an SQL string.
28: *
29: * @author Gerd Wagner
30: */
31: class RemoveQuotesCommand implements ICommand {
32: private final ISQLPanelAPI _api;
33:
34: RemoveQuotesCommand(ISQLPanelAPI api) {
35: super ();
36: _api = api;
37: }
38:
39: public void execute() throws BaseException {
40: ISQLEntryPanel entryPanel = _api.getSQLEntryPanel();
41:
42: unquoteSQL(entryPanel);
43: }
44:
45: static void unquoteSQL(ISQLEntryPanel entryPanel) {
46: int[] bounds = entryPanel.getBoundsOfSQLToBeExecuted();
47:
48: if (bounds[0] == bounds[1]) {
49: return;
50: }
51:
52: String textToUnquote = entryPanel.getSQLToBeExecuted();
53:
54: if (null == textToUnquote) {
55: return;
56: }
57:
58: String unquotedText = Utilities.unquoteText(textToUnquote);
59:
60: entryPanel.setSelectionStart(bounds[0]);
61: entryPanel.setSelectionEnd(bounds[1]);
62: entryPanel.replaceSelection(unquotedText);
63: }
64:
65: }
|