tml.sql
Class DbConnection

java.lang.Object
  tml.sql.DbConnection

public class DbConnection
extends java.lang.Object

This class represents the metadata database. When annotations are obtained for a document, those annotations are stored in the metadata database. Annotations can be anything provided by an Annotator class, for example the PennTree annotator parses a sentence and stores the penn string associated with the parse.

Author:

Jorge Villalon

Constructor Summary

DbConnection()

Method Summary

void	cleanMetaDataStorage()
java.lang.String[][]	executeQuery(java.sql.PreparedStatement st, java.lang.String[] columns)
java.lang.String	getAnnotation(java.lang.String documentId, java.lang.String field)
java.lang.String[][]	getDocuments()
java.lang.String	getReview(java.lang.String documentId, java.lang.String reviewName, java.lang.String user)
java.lang.String[][]	getSubDocuments(java.lang.String externalId)
java.lang.String[][]	getUnannotatedDocument()
void	insertDocument(Repository repo, org.apache.lucene.document.Document document)
boolean	isDirty(java.util.Date date)
void	setAnnotation(java.lang.String documentId, java.lang.String field, java.lang.String annotation)
void	setReview(java.lang.String documentId, java.lang.String review_name, java.lang.String review, java.lang.String user)

Methods inherited from class java.lang.Object

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

Constructor Detail

DbConnection

public DbConnection()
             throws java.sql.SQLException,
                    java.io.IOException

Throws:

java.sql.SQLException

java.io.IOException

Method Detail

cleanMetaDataStorage

public void cleanMetaDataStorage()

getDocuments

public java.lang.String[][] getDocuments()
                                  throws java.lang.Exception

Throws:

java.lang.Exception

getSubDocuments

public java.lang.String[][] getSubDocuments(java.lang.String externalId)
                                     throws java.lang.Exception

Throws:

java.lang.Exception

insertDocument

public void insertDocument(Repository repo,
                           org.apache.lucene.document.Document document)
                    throws java.sql.SQLException

Throws:

java.sql.SQLException

setAnnotation

public void setAnnotation(java.lang.String documentId,
                          java.lang.String field,
                          java.lang.String annotation)

isDirty

public boolean isDirty(java.util.Date date)

getAnnotation

public java.lang.String getAnnotation(java.lang.String documentId,
                                      java.lang.String field)

getReview

public java.lang.String getReview(java.lang.String documentId,
                                  java.lang.String reviewName,
                                  java.lang.String user)

setReview

public void setReview(java.lang.String documentId,
                      java.lang.String review_name,
                      java.lang.String review,
                      java.lang.String user)

getUnannotatedDocument

public java.lang.String[][] getUnannotatedDocument()

executeQuery

public java.lang.String[][] executeQuery(java.sql.PreparedStatement st,
                                         java.lang.String[] columns)
                                  throws java.lang.Exception

Throws:

java.lang.Exception