01: /*
02: * Copyright 2001-2007 Geert Bevin <gbevin[remove] at uwyn dot com>
03: * Distributed under the terms of either:
04: * - the common development and distribution license (CDDL), v1.0; or
05: * - the GNU Lesser General Public License, v2.1 or later
06: * $Id: TestDropTable.java 3634 2007-01-08 21:42:24Z gbevin $
07: */
08: package com.uwyn.rife.database.queries;
09:
10: import com.uwyn.rife.database.DbQueryManager;
11: import com.uwyn.rife.database.exceptions.DatabaseException;
12:
13: public abstract class TestDropTable extends TestQuery {
14: public TestDropTable(String name) {
15: super (name);
16: }
17:
18: public void execute(DropTable query) {
19: try {
20: DbQueryManager manager = new DbQueryManager(query
21: .getDatasource());
22: CreateTable create_table = new CreateTable(query
23: .getDatasource());
24: create_table.column("firstcolumn", int.class);
25:
26: for (String table : query.getTables()) {
27: create_table.table(table);
28: manager.executeUpdate(create_table);
29: }
30: manager.executeUpdate(query);
31: } catch (DatabaseException e) {
32: throw new RuntimeException(e);
33: }
34: }
35: }
|