/**
 * Licensed to the Apache Software Foundation (ASF) under one
 * or more contributor license agreements.  See the NOTICE file
 * distributed with this work for additional information
 * regarding copyright ownership.  The ASF licenses this file
 * to you under the Apache License, Version 2.0 (the
 * "License"); you may not use this file except in compliance
 * with the License.  You may obtain a copy of the License at
 *
 *   http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing,
 * software distributed under the License is distributed on an
 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
 * KIND, either express or implied.  See the License for the
 * specific language governing permissions and limitations
 * under the License.
 */
package org.apache.lens.examples;

import java.io.BufferedReader;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;

/**
 * The Class DatabaseUtil.
 */
public final class DatabaseUtil {

  private DatabaseUtil() {

  }

  /**
   * Initalize database storage.
   *
   * @throws Exception the exception
   */
  public static void initializeDatabaseStorage() throws Exception {
    try {
      Class.forName("org.hsqldb.jdbcDriver");
    } catch (ClassNotFoundException e) {
      System.err.println("Unable to locate the JDBC driver class for DB Storage");
    }
    Connection con = DriverManager.getConnection("jdbc:hsqldb:/tmp/db-storage.db", "SA", "");

    con.setAutoCommit(true);
    Statement statement = con.createStatement();
    BufferedReader reader = null;
    try {
      InputStream file = DatabaseUtil.class.getClassLoader().getResourceAsStream("db-storage-schema.sql");
      reader = new BufferedReader(new InputStreamReader(file, "UTF-8"));
      String line;
      while ((line = reader.readLine()) != null) {
        if (line.trim().equals("") || line.startsWith("--")) {
          continue;
        }
        statement.executeUpdate(line);
      }
    } finally {
      if (reader != null) {
        reader.close();
      }
      statement.execute("SHUTDOWN");
      statement.close();
      con.close();
    }
  }

  /**
   * The main method.
   *
   * @param args the arguments
   * @throws Exception the exception
   */
  public static void main(String[] args) throws Exception {
    DatabaseUtil.initializeDatabaseStorage();
  }
}