[Squirrel-sql-commits] sql12/plugins/mssql/src/net/sourceforge/squirrel_sql/plugins/mssql/action ShrinkDatabaseFileAction.java,NONE,1.1 ShrinkDatabaseFileCommand.java,NONE,1.1

[Ryan W. <gen...@us...>]

Update of /cvsroot/squirrel-sql/sql12/plugins/mssql/src/net/sourceforge/squirrel_sql/plugins/mssql/action
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv16967

Added Files:
	ShrinkDatabaseFileAction.java ShrinkDatabaseFileCommand.java 
Log Message:
added Shrink Database File function

--- NEW FILE: ShrinkDatabaseFileAction.java ---
package net.sourceforge.squirrel_sql.plugins.mssql.action;

/*
 * Copyright (C) 2004 Ryan Walberg <gen...@ya...>
 *
 * 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 java.awt.event.ActionEvent;

import net.sourceforge.squirrel_sql.client.IApplication;
import net.sourceforge.squirrel_sql.client.action.SquirrelAction;
import net.sourceforge.squirrel_sql.client.plugin.IPlugin;
import net.sourceforge.squirrel_sql.client.session.IObjectTreeAPI;
import net.sourceforge.squirrel_sql.client.session.ISession;
import net.sourceforge.squirrel_sql.client.session.action.ISessionAction;
import net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTreeNode;
import net.sourceforge.squirrel_sql.fw.gui.Dialogs;
import net.sourceforge.squirrel_sql.fw.sql.IDatabaseObjectInfo;
import net.sourceforge.squirrel_sql.fw.util.Resources;

import net.sourceforge.squirrel_sql.plugins.mssql.MssqlPlugin;
import net.sourceforge.squirrel_sql.plugins.mssql.sql.dbfile.DatabaseFile;

public class ShrinkDatabaseFileAction extends SquirrelAction implements ISessionAction {
	private ISession _session;
	private final MssqlPlugin _plugin;
    private String _catalogName;
    private DatabaseFile _databaseFile;

	public ShrinkDatabaseFileAction(IApplication app, Resources rsrc, MssqlPlugin plugin, String catalogName, DatabaseFile databaseFile) {
		super(app, rsrc);
        
        /* the constructor above sets this from resources, but we'll override it with
         * the name of the database file and its size. */
        putValue(javax.swing.Action.NAME,databaseFile.getName() + " (" + databaseFile.getSize() + ")");
        
		_plugin = plugin;
        _catalogName = catalogName;
        _databaseFile = databaseFile;
	}

	public void actionPerformed(ActionEvent evt) {
		if (_session != null) {
			new ShrinkDatabaseFileCommand(_session, _plugin, _catalogName, _databaseFile.getName()).execute();
		}
	}

	public void setSession(ISession session) {
		_session = session;
	}
}

--- NEW FILE: ShrinkDatabaseFileCommand.java ---
package net.sourceforge.squirrel_sql.plugins.mssql.action;

/*
 * Copyright (C) 2004 Ryan Walberg <gen...@ya...>
 *
 * 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.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;

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

    String _catalogName;
    String _databaseFileName;
    
	public ShrinkDatabaseFileCommand(ISession session, MssqlPlugin plugin, String catalogName, String databaseFileName) {
		super();
		if (session == null)
			throw new IllegalArgumentException("ISession == null");

        _session = session;
		_plugin = plugin;
		_catalogName = catalogName;
        _databaseFileName = databaseFileName;
	}

	public void execute() {
		final String sqlSep = _session.getProperties().getSQLStatementSeparator();
		final StringBuffer buf = new StringBuffer();
        buf.append("USE ");
        buf.append(_catalogName);
        buf.append(sqlSep + "\n");
        buf.append("DBCC SHRINKFILE (");
        buf.append(_databaseFileName);
        buf.append(", TRUNCATEONLY)");
        buf.append(sqlSep + "\n");

        _session.getSQLPanelAPI(_plugin).appendSQLScript(buf.toString(), true);
        _session.getSQLPanelAPI(_plugin).executeCurrentSQL();
        _session.selectMainTab(ISession.IMainPanelTabIndexes.SQL_TAB);
	}
}