1 package org.apache.velocity.test.sql;
2
3 /*
4 * Licensed to the Apache Software Foundation (ASF) under one
5 * or more contributor license agreements. See the NOTICE file
6 * distributed with this work for additional information
7 * regarding copyright ownership. The ASF licenses this file
8 * to you under the Apache License, Version 2.0 (the
9 * "License"); you may not use this file except in compliance
10 * with the License. You may obtain a copy of the License at
11 *
12 * http://www.apache.org/licenses/LICENSE-2.0
13 *
14 * Unless required by applicable law or agreed to in writing,
15 * software distributed under the License is distributed on an
16 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
17 * KIND, either express or implied. See the License for the
18 * specific language governing permissions and limitations
19 * under the License.
20 */
21
22 import java.sql.Connection;
23 import java.sql.SQLException;
24 import java.sql.Statement;
25
26 import org.apache.velocity.test.BaseTestCase;
27
28 /**
29 * A base class to implement tests that need a running
30 * Velocity engine and an initialized Hsql Database. Yeah, I should probably
31 * use Derby at some point...
32 *
33 * @author <a href="mailto:henning@apache.org">Henning P. Schmiedehausen</a>
34 * @version $Id: BaseSQLTest.java 898045 2010-01-11 20:11:02Z nbubna $
35 */
36
37 public abstract class BaseSQLTest
38 extends BaseTestCase
39 {
40 private static HsqlDB hsqlDB = null;
41
42 public BaseSQLTest(String name, String path)
43 throws Exception
44 {
45 super(name);
46
47 if (hsqlDB == null)
48 {
49 hsqlDB = new HsqlDB("jdbc:hsqldb:.", path + "/create-db.sql");
50 }
51 }
52
53 public void executeSQL(String sql)
54 throws SQLException
55 {
56 Connection connection = hsqlDB.getConnection();
57 Statement statement = connection.createStatement();
58 statement.executeUpdate(sql);
59 }
60 }