no.esito.anonymizer

Class MappingUtil

java.lang.Object

no.esito.anonymizer.MappingUtil

public class MappingUtil
extends Object

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	MappingUtil.Usage Holder for a set of keys, table and column names

Constructor Summary

Constructors

Constructor and Description
MappingUtil()

Method Summary

Modifier and Type	Method and Description
static Set<String>	analyze(Collection<MappingUtil.Usage> usages) Analyzes correlation and returns the combined set of keys
static Collection<String>	loadKeys(String filename) Loads keys from an ordered line-delimited file
static void	saveKeys(Collection<String> keys, String filename) Saves keys to an ordered line-delimited file
static void	saveMappingFile(Collection<String> keys, String filename, String prefix) Creates mappings to prefix with a sequence and saves as a Java properties file
static ResultSet	sqlExecuteQuery(Connection conn, String cmd) Executes a SQL statement and returns a resultset
static MappingUtil.Usage	sqlRead(Connection conn, String table, String column, String where) Reads values from <table>.<column> into a Usage instance

Methods inherited from class java.lang.Object

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

Constructor Detail

MappingUtil

public MappingUtil()

Method Detail

sqlRead

public static MappingUtil.Usage sqlRead(Connection conn,
                                        String table,
                                        String column,
                                        String where)
                                 throws SQLException

Reads values from <table>.<column> into a Usage instance

Parameters:

conn - Connection

table - name

column - name

where - clause

Returns:

Usage object

Throws:

SQLException - exception

sqlExecuteQuery

public static ResultSet sqlExecuteQuery(Connection conn,
                                        String cmd)
                                 throws SQLException

Executes a SQL statement and returns a resultset

Parameters:

conn - Connection

cmd - SQL command

Returns:

ResultSet

Throws:

SQLException - exception

loadKeys

public static Collection<String> loadKeys(String filename)
                                   throws FileNotFoundException

Loads keys from an ordered line-delimited file

Parameters:

filename - of file

Returns:

LinkedHashSet of keys

Throws:

FileNotFoundException - when file missing

saveKeys

public static void saveKeys(Collection<String> keys,
                            String filename)
                     throws IOException

Saves keys to an ordered line-delimited file

Parameters:

keys - strings

filename - name

Throws:

IOException - when problems writing file

analyze

public static Set<String> analyze(Collection<MappingUtil.Usage> usages)

Analyzes correlation and returns the combined set of keys

Parameters:

usages - Collection of Usages

Returns:

Set of strings

saveMappingFile

public static void saveMappingFile(Collection<String> keys,
                                   String filename,
                                   String prefix)
                            throws IOException

Creates mappings to prefix with a sequence and saves as a Java properties file

Parameters:

keys - to save

filename - for mapping file

prefix - for properties

Throws:

IOException - when problems writing mapping file