/*  Copyright (C) 2003-2011 JabRef contributors.
    This program is free software; you can redistribute it and/or modify
    it under the terms of the GNU General public static License as published by
    the Free Software Foundation; either version 2 of the License, or
    (at your option) any later version.

    This program is distributed in the hope that it will be useful,
    but WITHOUT ANY WARRANTY; without even the implied warranty of
    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    GNU General public static License for more details.

    You should have received a copy of the GNU General public static License along
    with this program; if not, write to the Free Software Foundation, Inc.,
    51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
 */

package net.sf.jabref.sql.importer;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import net.sf.jabref.sql.DBStrings;
import net.sf.jabref.sql.SQLUtil;

/**
 * 
 * @author ifsteinm.
 * 
 *  Jan 20th	Extends DBImporter to provide features specific for MySQL
 *  			Created after a refactory on SQLUtil
 *          
 */
public class MySQLImporter extends DBImporter {

	private static MySQLImporter instance = null;

	private MySQLImporter() {
	}

	/**
	 * 
	 * @return The singleton instance of the MySQLImporter
	 */
	public static MySQLImporter getInstance() {
		if (instance == null)
			instance = new MySQLImporter();
		return instance;
	}

	@Override
	protected ResultSet readColumnNames(Connection conn) throws SQLException {
		Statement statement = (Statement) SQLUtil.processQueryWithResults(conn,
				"SHOW columns FROM entries;");
		ResultSet rs = statement.getResultSet();
		return rs;
	}
	
	protected Connection connectToDB(DBStrings dbstrings) throws Exception{
		String url = SQLUtil.createJDBCurl(dbstrings, true);
		String drv = "com.mysql.jdbc.Driver";

		Class.forName(drv).newInstance();
		Connection conn = DriverManager.getConnection(url,
				dbstrings.getUsername(), dbstrings.getPassword());
		return conn;
	}

}