01: package net.sourceforge.squirrel_sql.plugins.mssql.action;
02:
03: /*
04: * Copyright (C) 2004 Ryan Walberg <generalpf@yahoo.com>
05: *
06: * This library is free software; you can redistribute it and/or
07: * modify it under the terms of the GNU Lesser General Public
08: * License as published by the Free Software Foundation; either
09: * version 2.1 of the License, or (at your option) any later version.
10: *
11: * This library 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 GNU
14: * Lesser General Public License for more details.
15: *
16: * You should have received a copy of the GNU Lesser General Public
17: * License along with this library; if not, write to the Free Software
18: * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
19: */
20:
21: import net.sourceforge.squirrel_sql.client.session.ISession;
22: import net.sourceforge.squirrel_sql.fw.sql.ITableInfo;
23: import net.sourceforge.squirrel_sql.fw.util.ICommand;
24: import net.sourceforge.squirrel_sql.plugins.mssql.MssqlPlugin;
25:
26: public class IndexDefragCommand implements ICommand {
27: private ISession _session;
28: private final MssqlPlugin _plugin;
29:
30: private final ITableInfo _tableInfo;
31: private final String _indexName;
32:
33: public IndexDefragCommand(ISession session, MssqlPlugin plugin,
34: ITableInfo tableInfo, String indexName) {
35: super ();
36: if (session == null)
37: throw new IllegalArgumentException("ISession == null");
38: if (tableInfo == null)
39: throw new IllegalArgumentException("ITableInfo == null");
40:
41: _session = session;
42: _plugin = plugin;
43: _tableInfo = tableInfo;
44: _indexName = indexName;
45: }
46:
47: public void execute() {
48: StringBuffer sqlBuffer = new StringBuffer();
49: final String sqlSep = _session.getQueryTokenizer()
50: .getSQLStatementSeparator();
51: sqlBuffer.append("DBCC INDEXDEFRAG(");
52: sqlBuffer.append(_tableInfo.getCatalogName());
53: sqlBuffer.append(",");
54: sqlBuffer.append(_tableInfo.getSimpleName());
55: sqlBuffer.append(",");
56: sqlBuffer.append(_indexName);
57: sqlBuffer.append(")\n");
58: sqlBuffer.append(sqlSep);
59: sqlBuffer.append(" \n");
60:
61: _session.getSessionInternalFrame().getSQLPanelAPI()
62: .appendSQLScript(sqlBuffer.toString(), true);
63: _session.getSessionInternalFrame().getSQLPanelAPI()
64: .executeCurrentSQL();
65: _session.selectMainTab(ISession.IMainPanelTabIndexes.SQL_TAB);
66: }
67: }
|