Package edu.suffolk.litlab.efsp.db

Class MessageSettingsDatabase

java.lang.Object

edu.suffolk.litlab.efsp.db.Database

edu.suffolk.litlab.efsp.db.MessageSettingsDatabase

All Implemented Interfaces:

AutoCloseable

public class MessageSettingsDatabase
extends Database

Field Summary

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

conn

Constructor Summary

Constructors

Constructor	Description
MessageSettingsDatabase(Connection conn)

Method Summary

Modifier and Type	Method	Description
void	createTablesIfAbsent()
Optional<MessageInfo>	findMessageInfo(UUID serverId)
static MessageSettingsDatabase	fromDS(DataSource ds)
void	updateTable(MessageInfo info)
void	updateTable(UUID serverId, String toEmail, String subjectLine, String emailTemplate, String confirmationSubjectLine, String emailConfirmation)

Methods inherited from class edu.suffolk.litlab.efsp.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

MessageSettingsDatabase

public MessageSettingsDatabase(Connection conn)

Method Details

fromDS

public static MessageSettingsDatabase fromDS(DataSource ds)

createTablesIfAbsent

public void createTablesIfAbsent()
                          throws SQLException

Specified by:

createTablesIfAbsent in class Database

Throws:

SQLException

updateTable

public void updateTable(MessageInfo info)
                 throws SQLException

Throws:

SQLException

updateTable

public void updateTable(UUID serverId,
 String toEmail,
 String subjectLine,
 String emailTemplate,
 String confirmationSubjectLine,
 String emailConfirmation)
                 throws SQLException

Throws:

SQLException

findMessageInfo

public Optional<MessageInfo> findMessageInfo(UUID serverId)