org.vivoweb.harvester.fetch
Class JDBCFetch

java.lang.Object
  org.vivoweb.harvester.fetch.JDBCFetch

public class JDBCFetch
extends java.lang.Object

Fetches rdf data from a JDBC database placing the data in the supplied record handler.

Author:

Christopher Haines (hainesc@ctrip.ufl.edu)

Constructor Summary

JDBCFetch(ArgList opts)
Arglist Constructor

JDBCFetch(java.sql.Connection dbConn, RecordHandler output, java.lang.String uriNameSpace)
Constructor

JDBCFetch(java.sql.Connection dbConn, RecordHandler rh, java.lang.String uriNS, java.lang.String queryPre, java.lang.String querySuf, java.util.Set<java.lang.String> tableNames, java.util.Map<java.lang.String,java.lang.String> fromClauses, java.util.Map<java.lang.String,java.util.List<java.lang.String>> dataFields, java.util.Map<java.lang.String,java.util.List<java.lang.String>> idFields, java.util.Map<java.lang.String,java.util.List<java.lang.String>> whereClauses, java.util.Map<java.lang.String,java.util.Map<java.lang.String,java.lang.String>> relations, java.util.Map<java.lang.String,java.lang.String> queryStrings)
Library style Constructor

JDBCFetch(java.lang.String[] args)
Command line Constructor

Method Summary

void	execute() Executes the task
static void	main(java.lang.String... args) Main method
void	setFieldPrefix(java.lang.String fieldPrefix) Set the field prefix
void	setFieldSuffix(java.lang.String fieldSuffix) Set the field suffix

Methods inherited from class java.lang.Object

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

Constructor Detail

JDBCFetch

public JDBCFetch(java.sql.Connection dbConn,
                 RecordHandler output,
                 java.lang.String uriNameSpace)
          throws java.sql.SQLException

Constructor

Parameters:

dbConn - connection to the database

output - RecordHandler to write data to

uriNameSpace - namespace base for rdf records

Throws:

java.sql.SQLException - error talking with database

JDBCFetch

public JDBCFetch(java.lang.String[] args)
          throws java.io.IOException

Command line Constructor

Parameters:

args - commandline arguments

Throws:

java.io.IOException - error creating task

JDBCFetch

public JDBCFetch(ArgList opts)
          throws java.io.IOException

Arglist Constructor

Parameters:

opts - option set of parsed args

Throws:

java.io.IOException - error creating task

JDBCFetch

public JDBCFetch(java.sql.Connection dbConn,
                 RecordHandler rh,
                 java.lang.String uriNS,
                 java.lang.String queryPre,
                 java.lang.String querySuf,
                 java.util.Set<java.lang.String> tableNames,
                 java.util.Map<java.lang.String,java.lang.String> fromClauses,
                 java.util.Map<java.lang.String,java.util.List<java.lang.String>> dataFields,
                 java.util.Map<java.lang.String,java.util.List<java.lang.String>> idFields,
                 java.util.Map<java.lang.String,java.util.List<java.lang.String>> whereClauses,
                 java.util.Map<java.lang.String,java.util.Map<java.lang.String,java.lang.String>> relations,
                 java.util.Map<java.lang.String,java.lang.String> queryStrings)
          throws java.sql.SQLException

Library style Constructor

Parameters:

dbConn - The database Connection

rh - Record Handler to write records to

uriNS - the uri namespace to use

queryPre - Query prefix often "["

querySuf - Query suffix often "]"

tableNames - set of the table names

fromClauses - Mapping of extra tables for the from section

dataFields - Mapping of tablename to list of datafields

idFields - Mapping of tablename to idField name

whereClauses - List of conditions

relations - Mapping of tablename to mapping of fieldname to tablename

queryStrings - Mapping of tablename to query

Throws:

java.sql.SQLException - error accessing database

Method Detail

setFieldPrefix

public void setFieldPrefix(java.lang.String fieldPrefix)

Set the field prefix

Parameters:

fieldPrefix - the field prefix to use

setFieldSuffix

public void setFieldSuffix(java.lang.String fieldSuffix)

Set the field suffix

Parameters:

fieldSuffix - the field suffix to use

execute

public void execute()
             throws java.io.IOException

Executes the task

Throws:

java.io.IOException - error processing record handler or jdbc connection

main

public static void main(java.lang.String... args)

Main method

Parameters:

args - commandline arguments