org.relique.jdbc.csv.ZipFileTableReader Maven / Gradle / Ivy

Show more of this group Show more artifacts with this name
Show all versions of csvjdbc Show documentation
a Java JDBC driver for reading comma-separated-value files
There is a newer version: 1.0.43
/*
 *  CsvJdbc - a JDBC driver for CSV files
 *  Copyright (C) 2001  Jonathan Ackerman
 *  This library is free software; you can redistribute it and/or
 *  modify it under the terms of the GNU Lesser General Public
 *  License as published by the Free Software Foundation; either
 *  version 2.1 of the License, or (at your option) any later version.
 *  This library 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
 *  Lesser General Public License for more details.
 *  You should have received a copy of the GNU Lesser General Public
 *  License along with this library; if not, write to the Free Software
 *  Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301  USA
 */
package org.relique.jdbc.csv;

import java.io.IOException;
import java.io.InputStreamReader;
import java.io.Reader;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Enumeration;
import java.util.List;
import java.util.Vector;
import java.util.zip.ZipEntry;
import java.util.zip.ZipFile;

import org.relique.io.TableReader;

/**
 * Enables reading CSV files packed in a ZIP file as database tables.
 */
public class ZipFileTableReader implements TableReader
{
	private String zipFilename;
	private ZipFile zipFile;
	private String fileExtension;
	private String charset;

	public ZipFileTableReader(String zipFilename, String charset) throws IOException
	{
		this.zipFilename = zipFilename;
		this.zipFile = new ZipFile(zipFilename);
		this.charset = charset;
	}

	public void setExtension(String fileExtension)
	{
		this.fileExtension = fileExtension;
	}

	public String getZipFilename()
	{
		return zipFilename;
	}

	@Override
	public Reader getReader(Statement statement, String tableName) throws SQLException
	{
		try
		{
			ZipEntry zipEntry = zipFile.getEntry(tableName + fileExtension);
			if (zipEntry == null)
				throw new SQLException(CsvResources.getString("tableNotFound") + ": " + tableName);
			
			Reader reader;
			if (charset != null)    
				reader = new InputStreamReader(zipFile.getInputStream(zipEntry), charset);
			else
				reader = new InputStreamReader(zipFile.getInputStream(zipEntry));
			return reader;
		}
		catch (IOException e)
		{
			throw new SQLException(e);
		}
	}

	@Override
	public List getTableNames(Connection connection) throws SQLException
	{
		Vector v = new Vector();
		Enumeration en = zipFile.entries();
		while (en.hasMoreElements())
		{
			/*
			 * Strip file extensions.
			 */
			String name = ((ZipEntry)en.nextElement()).getName();
			if (name.endsWith(fileExtension))
				name = name.substring(0, name.length() - fileExtension.length());
			v.add(name);
		}
		return v;
	}
}