01: package net.sourceforge.squirrel_sql.plugins.mysql.action;
02:
03: /*
04: * Copyright (C) 2003 Colin Bell
05: * colbell@users.sourceforge.net
06: *
07: * This library is free software; you can redistribute it and/or
08: * modify it under the terms of the GNU Lesser General Public
09: * License as published by the Free Software Foundation; either
10: * version 2.1 of the License, or (at your option) any later version.
11: *
12: * This library is distributed in the hope that it will be useful,
13: * but WITHOUT ANY WARRANTY; without even the implied warranty of
14: * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
15: * Lesser General Public License for more details.
16: *
17: * You should have received a copy of the GNU Lesser General Public
18: * License along with this library; if not, write to the Free Software
19: * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
20: */
21: import net.sourceforge.squirrel_sql.client.session.ISession;
22: import net.sourceforge.squirrel_sql.plugins.mysql.MysqlPlugin;
23:
24: /**
25: * This command will run a "CHECK TABLE" over the
26: * currently selected tables.
27: *
28: * @author <A HREF="mailto:colbell@users.sourceforge.net">Colin Bell</A>
29: */
30: class CheckTableCommand extends AbstractTableListCommand {
31: /** Type of check to run on the tables @see ICheckTypes. */
32: private int _checkType;
33:
34: /**
35: * Ctor.
36: *
37: * @throws IllegalArgumentException
38: * Thrown if a?<TT>null</TT> <TT>ISession</TT>,
39: * <TT>Resources</TT> or <TT>MysqlPlugin</TT> passed.
40: */
41: public CheckTableCommand(ISession session, MysqlPlugin plugin,
42: int checkType) {
43: super (session, plugin);
44: _checkType = checkType;
45: }
46:
47: /**
48: * Retrieve the MySQL command to run.
49: *
50: * @return the MySQL command to run.
51: */
52: protected String getMySQLCommand() {
53: return "check table";
54: }
55:
56: /**
57: * Add the "type" of the check to the command.
58: *
59: * @return The SQL command to execute.
60: */
61: protected String checkSQL(String sql) {
62: final StringBuffer buf = new StringBuffer(sql);
63: buf.append(' ').append(getResolvedCheckType());
64: return buf.toString();
65: }
66:
67: private String getResolvedCheckType() {
68: switch (_checkType) {
69: case CheckTableAction.ICheckTypes.QUICK:
70: return "Quick";
71: case CheckTableAction.ICheckTypes.FAST:
72: return "Fast";
73: case CheckTableAction.ICheckTypes.MEDIUM:
74: return "Medium";
75: case CheckTableAction.ICheckTypes.EXTENDED:
76: return "Extended";
77: case CheckTableAction.ICheckTypes.CHANGED:
78: return "Changed";
79: default:
80: throw new IllegalStateException("Invalid check type of "
81: + _checkType);
82: }
83: }
84: }
|