weave.utils

Class DBFUtils

java.lang.Object

weave.utils.DBFUtils

public class DBFUtils
extends java.lang.Object

Author:

skolman, adufilie

Constructor Summary

Constructors

Constructor and Description
DBFUtils()

Method Summary

Methods

Modifier and Type	Method and Description
static java.util.List<java.lang.String>	getAttributeNames(java.io.File dbfFile)
static java.lang.Object[][]	getDBFData(java.io.File dbfFile, java.lang.String[] fieldNames)
static boolean	isColumnUnique(java.io.File[] dbfFiles, java.lang.String[] columnNames) Tests a combined column for uniqueness across several files
static void	storeAttributes(java.io.File[] dbfFiles, java.sql.Connection conn, java.lang.String sqlSchema, java.lang.String sqlTable, boolean overwriteTables, java.lang.String[] nullValues)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

DBFUtils

public DBFUtils()

Method Detail

getAttributeNames

public static java.util.List<java.lang.String> getAttributeNames(java.io.File dbfFile)
                                                          throws java.io.IOException

Parameters:

dbfFile - A DBF file

Returns:

A list of attribute names in the DBF file

Throws:

java.io.IOException

isColumnUnique

public static boolean isColumnUnique(java.io.File[] dbfFiles,
                     java.lang.String[] columnNames)
                              throws java.io.IOException

Tests a combined column for uniqueness across several files

Parameters:

dbfFiles -

columnNames -

Returns:

A value of true if the columns contain values that uniquely identify rows in all the dbf files.

Throws:

java.io.IOException

getDBFData

public static java.lang.Object[][] getDBFData(java.io.File dbfFile,
                              java.lang.String[] fieldNames)
                                       throws java.io.IOException

Parameters:

dbfFile - A DBF file

fieldNames - A list of field names to retrieve, or null for all columns

Returns:

A list of attribute names in the DBF file

Throws:

java.io.IOException

storeAttributes

public static void storeAttributes(java.io.File[] dbfFiles,
                   java.sql.Connection conn,
                   java.lang.String sqlSchema,
                   java.lang.String sqlTable,
                   boolean overwriteTables,
                   java.lang.String[] nullValues)
                            throws java.io.IOException,
                                   java.sql.SQLException

Parameters:

dbfFiles - A list of DBF files to merge

conn - a database connection

sqlSchema - schema to store table

sqlTable - table name to store data

overwriteTables - Set this to true to overwrite an existing SQL table.

nullValues - A list of Strings to interpret as null values.

Throws:

IOException,SQLException

java.io.IOException

java.sql.SQLException