Package guru.interlis.convconf.runtime

Class JdbcRecordAdapter

java.lang.Object

guru.interlis.convconf.runtime.JdbcRecordAdapter

All Implemented Interfaces:

RecordSourceReader, RecordTargetWriter

Direct Known Subclasses:

H2Adapter, PostgreSqlAdapter

public class JdbcRecordAdapter
extends Object
implements RecordSourceReader, RecordTargetWriter

Generic JDBC implementation reusable for H2/PostgreSQL and other SQL databases.

Constructor Summary

Constructors

Constructor	Description
JdbcRecordAdapter(Connection connection)

Method Summary

Modifier and Type	Method	Description
List<Map<String,Object>>	read(String sourceName, Map<String,String> equalsFilter)	Reads rows from a backend object with an equality filter.
void	write(String targetName, List<Map<String,Object>> rows)	Writes rows to a backend object.

Methods inherited from class java.lang.Object

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

Constructor Details

JdbcRecordAdapter

public JdbcRecordAdapter(Connection connection)

Method Details

read

public List<Map<String,Object>> read(String sourceName,
 Map<String,String> equalsFilter)
                              throws SQLException

Description copied from interface: RecordSourceReader

Reads rows from a backend object with an equality filter.

Specified by:

read in interface RecordSourceReader

Parameters:

sourceName - backend-specific source object name

equalsFilter - key/value equality filter (column -> required value)

Returns:

list of rows as column/value maps

Throws:

SQLException

write

public void write(String targetName,
 List<Map<String,Object>> rows)
           throws SQLException

Description copied from interface: RecordTargetWriter

Writes rows to a backend object.

Specified by:

write in interface RecordTargetWriter

Parameters:

targetName - backend-specific target object name

rows - rows to write as column/value maps

Throws:

SQLException