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.client.session.ISQLPanelAPI;
21: import net.sourceforge.squirrel_sql.client.session.ISession;
22: import net.sourceforge.squirrel_sql.fw.codereformat.CodeReformator;
23: import net.sourceforge.squirrel_sql.fw.codereformat.CommentSpec;
24: import net.sourceforge.squirrel_sql.fw.util.BaseException;
25: import net.sourceforge.squirrel_sql.fw.util.ICommand;
26:
27: /**
28: * This command will "quote" an SQL string.
29: *
30: * @author Gerd Wagner
31: */
32: class FormatSQLCommand implements ICommand {
33: private final ISession _session;
34: private final EditExtrasPlugin _plugin;
35:
36: FormatSQLCommand(ISession session, EditExtrasPlugin plugin) {
37: super ();
38: _session = session;
39: _plugin = plugin;
40: }
41:
42: public void execute() throws BaseException {
43: ISQLPanelAPI api = FrameWorkAcessor.getSQLPanelAPI(_session,
44: _plugin);
45:
46: int[] bounds = api.getSQLEntryPanel()
47: .getBoundsOfSQLToBeExecuted();
48:
49: if (bounds[0] == bounds[1]) {
50: return;
51: }
52:
53: String textToReformat = api.getSQLEntryPanel()
54: .getSQLToBeExecuted();
55:
56: if (null == textToReformat) {
57: return;
58: }
59:
60: CommentSpec[] commentSpecs = new CommentSpec[] {
61: new CommentSpec("/*", "*/"),
62: new CommentSpec("--", "\n") };
63:
64: String statementSep = _session.getQueryTokenizer()
65: .getSQLStatementSeparator();
66:
67: CodeReformator cr = new CodeReformator(statementSep,
68: commentSpecs);
69:
70: String reformatedText = cr.reformat(textToReformat);
71:
72: api.getSQLEntryPanel().setSelectionStart(bounds[0]);
73: api.getSQLEntryPanel().setSelectionEnd(bounds[1]);
74: api.getSQLEntryPanel().replaceSelection(reformatedText);
75:
76: }
77: }
|