001/*
002 * Syncany, www.syncany.org
003 * Copyright (C) 2011-2016 Philipp C. Heckel <philipp.heckel@gmail.com> 
004 *
005 * This program is free software: you can redistribute it and/or modify
006 * it under the terms of the GNU General Public License as published by
007 * the Free Software Foundation, either version 3 of the License, or
008 * (at your option) any later version.
009 *
010 * This program is distributed in the hope that it will be useful,
011 * but WITHOUT ANY WARRANTY; without even the implied warranty of
012 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
013 * GNU General Public License for more details.
014 *
015 * You should have received a copy of the GNU General Public License
016 * along with this program.  If not, see <http://www.gnu.org/licenses/>.
017 */
018package org.syncany.database.dao;
019
020import java.io.IOException;
021import java.sql.Connection;
022import java.sql.PreparedStatement;
023import java.sql.SQLException;
024
025import org.syncany.database.DatabaseConnectionFactory;
026import org.syncany.util.SqlRunner;
027
028/**
029 * Small helper class to implement common tasks for the inheriting 
030 * SQL data access objects.
031 * 
032 * @author Philipp C. Heckel (philipp.heckel@gmail.com)
033 */
034public abstract class AbstractSqlDao {
035        protected Connection connection;
036        
037        public AbstractSqlDao(Connection connection) {
038                this.connection = connection;
039        }
040        
041        public Connection getConnection() {
042                return connection;
043        }
044        
045        protected PreparedStatement getStatement(String resourceId) throws SQLException {
046                return getStatement(connection, resourceId);
047        }
048        
049        protected PreparedStatement getStatement(Connection overrideConnection, String resourceId) throws SQLException {
050                return overrideConnection.prepareStatement(DatabaseConnectionFactory.getStatement(resourceId));
051        }
052        
053        protected void runScript(String resourceId) throws SQLException, IOException {
054                SqlRunner.runScript(connection, DatabaseConnectionFactory.getStatementInputStream(resourceId));
055        }
056}