com.serotonin.mango.db.dao

Class MailingListDao

java.lang.Object

com.serotonin.db.DaoUtils

com.serotonin.mango.db.dao.BaseDao

com.serotonin.mango.db.dao.MailingListDao

public class MailingListDao
extends BaseDao

Author:

Matthew Lohbihler

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
(package private) class	MailingListDao.EmailRecipientRowMapper
(package private) class	MailingListDao.MailingListRowMapper
(package private) class	MailingListDao.MailingListScheduleInactiveMapper

Field Summary

Fields

Modifier and Type	Field and Description
private static java.lang.String	MAILING_LIST_ENTRIES_SELECT
private static java.lang.String	MAILING_LIST_ENTRY_INSERT
private static java.lang.String	MAILING_LIST_INACTIVE_INSERT
private static java.lang.String	MAILING_LIST_INACTIVE_SELECT
private static java.lang.String	MAILING_LIST_INSERT
private static java.lang.String	MAILING_LIST_SELECT
private static java.lang.String	MAILING_LIST_UPDATE

Fields inherited from class com.serotonin.db.DaoUtils

dataSource, ejt, tm

Constructor Summary

Constructors

Constructor and Description
MailingListDao()

Method Summary

Modifier and Type	Method and Description
void	deleteMailingList(int mailingListId)
java.lang.String	generateUniqueXid()
MailingList	getMailingList(int id)
MailingList	getMailingList(java.lang.String xid)
java.util.List<MailingList>	getMailingLists()
java.util.Set<java.lang.String>	getRecipientAddresses(java.util.List<RecipientListEntryBean> beans, org.joda.time.DateTime sendTime)
boolean	isXidUnique(java.lang.String xid, int excludeId)
void	populateEntrySubclasses(java.util.List<EmailRecipient> entries)
void	saveMailingList(MailingList ml)
(package private) void	saveRelationalData(MailingList ml)
private void	setRelationalData(java.util.List<MailingList> mls)
private void	setRelationalData(MailingList ml)

Methods inherited from class com.serotonin.mango.db.dao.BaseDao

boolToChar, charToBool, deleteInChunks, doInsert, doInsert, doInsert, doInsertLong, doInsertLong, doInsertLong, generateUniqueXid, getGeneratedKeyName, getPreparedStatementCreator, isXidUnique

Methods inherited from class com.serotonin.db.DaoUtils

batchUpdate, createDelimitedList, createDelimitedList, createDelimitedList, createIntValuePairs, createKeyValuePairs, dbEncodeSearchString, getInt, getTransactionManager, getTransactionTemplate, now, query, query, query, query, query, query, queryForList, queryForList, queryForObject, queryForObject, queryForObject, setInt

Methods inherited from class java.lang.Object

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

Field Detail

MAILING_LIST_SELECT

private static final java.lang.String MAILING_LIST_SELECT

See Also:

Constant Field Values

MAILING_LIST_INACTIVE_SELECT

private static final java.lang.String MAILING_LIST_INACTIVE_SELECT

See Also:

Constant Field Values

MAILING_LIST_ENTRIES_SELECT

private static final java.lang.String MAILING_LIST_ENTRIES_SELECT

See Also:

Constant Field Values

MAILING_LIST_INSERT

private static final java.lang.String MAILING_LIST_INSERT

See Also:

Constant Field Values

MAILING_LIST_UPDATE

private static final java.lang.String MAILING_LIST_UPDATE

See Also:

Constant Field Values

MAILING_LIST_INACTIVE_INSERT

private static final java.lang.String MAILING_LIST_INACTIVE_INSERT

See Also:

Constant Field Values

MAILING_LIST_ENTRY_INSERT

private static final java.lang.String MAILING_LIST_ENTRY_INSERT

See Also:

Constant Field Values

Constructor Detail

MailingListDao

public MailingListDao()

Method Detail

generateUniqueXid

public java.lang.String generateUniqueXid()

isXidUnique

public boolean isXidUnique(java.lang.String xid,
                           int excludeId)

getMailingLists

public java.util.List<MailingList> getMailingLists()

getMailingList

public MailingList getMailingList(int id)

getMailingList

public MailingList getMailingList(java.lang.String xid)

setRelationalData

private void setRelationalData(java.util.List<MailingList> mls)

setRelationalData

private void setRelationalData(MailingList ml)

getRecipientAddresses

public java.util.Set<java.lang.String> getRecipientAddresses(java.util.List<RecipientListEntryBean> beans,
                                                             org.joda.time.DateTime sendTime)

populateEntrySubclasses

public void populateEntrySubclasses(java.util.List<EmailRecipient> entries)

saveMailingList

public void saveMailingList(MailingList ml)

saveRelationalData

void saveRelationalData(MailingList ml)

deleteMailingList

public void deleteMailingList(int mailingListId)