Package edu.suffolk.litlab.efspserver.db

Class UserDatabase

java.lang.Object

edu.suffolk.litlab.efspserver.db.Database

edu.suffolk.litlab.efspserver.db.UserDatabase

All Implemented Interfaces:

AutoCloseable

public class UserDatabase
extends Database

Very similar to the CodeDatabase, but for user data, kept at a minimum.

At the most, we save the transaction ID for the filing and some method of contact (maybe their name too), so they can have instructions on what to do.

Author:

brycew

Field Summary

Fields inherited from class edu.suffolk.litlab.efspserver.db.Database

conn

Constructor Summary

Constructors

Constructor	Description
UserDatabase(Connection conn)

Method Summary

Modifier and Type	Method	Description
void	addToTable(String name, UUID filingPartyId, Optional<String> phoneNumber, String email, List<UUID> transactionIds, UUID serverId, String apiKeyUsed, String caseType, String courtId, Timestamp submitted, String acceptedTmpl, String acceptedSubject, String rejectedTmpl, String rejectedSubject, String neutralTmpl, String neutralSubject, String caseTitle, String envelopeId)
void	addToTable(String name, UUID filingPartyId, Optional<String> phoneNumber, String email, UUID transactionId, UUID serverId, String apiKeyUsed, String caseType, String courtId, Timestamp submitted, String acceptedTmpl, String acceptedSubject, String rejectedTmpl, String rejectedSubject, String neutralTmpl, String neutralSubject, String caseTitle, String envelopeId)	Adds the given values as a row in the submitted table.
void	createTablesIfAbsent()	Creates the userdatabase table if it doesn't exist yet.
Optional<Transaction>	findTransaction(UUID transactionToFind)	Gets the info from the table by using the (Primary key'd) transaction id.
boolean	removeFromTable(UUID transactionToRm)

Methods inherited from class edu.suffolk.litlab.efspserver.db.Database

close, commit, rollback, setAutoCommit, setSavepoint

Methods inherited from class java.lang.Object

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

Constructor Details

UserDatabase

public UserDatabase(Connection conn)

Method Details

createTablesIfAbsent

public void createTablesIfAbsent()
                          throws SQLException

Creates the userdatabase table if it doesn't exist yet.

Specified by:

createTablesIfAbsent in class Database

Throws:

SQLException

addToTable

public void addToTable(String name,
 UUID filingPartyId,
 Optional<String> phoneNumber,
 String email,
 List<UUID> transactionIds,
 UUID serverId,
 String apiKeyUsed,
 String caseType,
 String courtId,
 Timestamp submitted,
 String acceptedTmpl,
 String acceptedSubject,
 String rejectedTmpl,
 String rejectedSubject,
 String neutralTmpl,
 String neutralSubject,
 String caseTitle,
 String envelopeId)
                throws SQLException

Throws:

SQLException

addToTable

public void addToTable(String name,
 UUID filingPartyId,
 Optional<String> phoneNumber,
 String email,
 UUID transactionId,
 UUID serverId,
 String apiKeyUsed,
 String caseType,
 String courtId,
 Timestamp submitted,
 String acceptedTmpl,
 String acceptedSubject,
 String rejectedTmpl,
 String rejectedSubject,
 String neutralTmpl,
 String neutralSubject,
 String caseTitle,
 String envelopeId)
                throws SQLException

Adds the given values as a row in the submitted table.

Throws:

SQLException

findTransaction

public Optional<Transaction> findTransaction(UUID transactionToFind)
                                      throws SQLException

Gets the info from the table by using the (Primary key'd) transaction id.

Throws:

SQLException

removeFromTable

public boolean removeFromTable(UUID transactionToRm)
                        throws SQLException

Throws:

SQLException