net.sourceforge.squirrel_sql.plugins.mssql.action.UpdateStatisticsCommand Maven / Gradle / Ivy

Go to download
package net.sourceforge.squirrel_sql.plugins.mssql.action;

/*
 * Copyright (C) 2004 Ryan Walberg 
 *
 * This library is free software; you can redistribute it and/or
 * modify it under the terms of the GNU Lesser General Public
 * License as published by the Free Software Foundation; either
 * version 2.1 of the License, or (at your option) any later version.
 *
 * This library is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
 * Lesser General Public License for more details.
 *
 * You should have received a copy of the GNU Lesser General Public
 * 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 net.sourceforge.squirrel_sql.client.session.IObjectTreeAPI;
import net.sourceforge.squirrel_sql.client.session.ISession;
import net.sourceforge.squirrel_sql.fw.sql.IDatabaseObjectInfo;
import net.sourceforge.squirrel_sql.fw.util.ICommand;
import net.sourceforge.squirrel_sql.plugins.mssql.MssqlPlugin;

import javax.swing.*;

public class UpdateStatisticsCommand implements ICommand {
	private ISession _session;
	private final MssqlPlugin _plugin;

	public UpdateStatisticsCommand(ISession session, MssqlPlugin plugin) {
		super();
		if (session == null)
			throw new IllegalArgumentException("ISession == null");

		_session = session;
		_plugin = plugin;
	}

	public void execute() {
        final String sqlSep = _session.getQueryTokenizer().getSQLStatementSeparator();
        final IObjectTreeAPI api = _session.getSessionInternalFrame().getObjectTreeAPI();
		final IDatabaseObjectInfo[] dbObjs = api.getSelectedDatabaseObjects();

		// Get the names of all the selected tables in a comma separated list,
        final StringBuffer cmd = new StringBuffer(512);
		for (int i = 0; i < dbObjs.length; ++i) {
            cmd.append("UPDATE STATISTICS ");
            cmd.append(dbObjs[i].getCatalogName());
            cmd.append(".");
            cmd.append(dbObjs[i].getSchemaName());
            cmd.append(".");
            cmd.append(dbObjs[i].getSimpleName());
            cmd.append(" WITH FULLSCAN, ALL\n");
            cmd.append(sqlSep);
            cmd.append("\n");
		}

        if (cmd != null && cmd.length() > 0) {
			_session.getSessionInternalFrame().getSQLPanelAPI().appendSQLScript(cmd.toString(), true);
			_session.getSessionInternalFrame().getSQLPanelAPI().executeCurrentSQL();
			_session.selectMainTab(ISession.IMainPanelTabIndexes.SQL_TAB);
		}
	}
}