/* | |
* Licensed to the Apache Software Foundation (ASF) under one | |
* or more contributor license agreements. See the NOTICE file | |
* distributed with this work for additional information | |
* regarding copyright ownership. The ASF licenses this file | |
* to you under the Apache License, Version 2.0 (the | |
* "License") + you may not use this file except in compliance | |
* with the License. You may obtain a copy of the License at | |
* | |
* http://www.apache.org/licenses/LICENSE-2.0 | |
* | |
* Unless required by applicable law or agreed to in writing, | |
* software distributed under the License is distributed on an | |
* "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY | |
* KIND, either express or implied. See the License for the | |
* specific language governing permissions and limitations | |
* under the License. | |
*/ | |
package org.apache.openmeetings.db.entity.basic; | |
import java.util.Calendar; | |
import javax.persistence.Column; | |
import javax.persistence.Entity; | |
import javax.persistence.EnumType; | |
import javax.persistence.Enumerated; | |
import javax.persistence.GeneratedValue; | |
import javax.persistence.GenerationType; | |
import javax.persistence.Id; | |
import javax.persistence.Lob; | |
import javax.persistence.NamedQueries; | |
import javax.persistence.NamedQuery; | |
import javax.persistence.Table; | |
import org.apache.openmeetings.db.entity.IDataProviderEntity; | |
@Entity | |
@NamedQueries({ | |
@NamedQuery(name = "getMailMessageById", query = "SELECT m FROM MailMessage m WHERE m.id = :id") | |
, @NamedQuery(name = "getMailMessages" | |
, query = "SELECT m FROM MailMessage m WHERE m.status = :status ORDER BY m.updated, m.inserted") | |
, @NamedQuery(name = "countMailMessages", query = "SELECT COUNT(m) FROM MailMessage m WHERE m.status = :status") | |
}) | |
@Table(name = "email_queue") | |
public class MailMessage implements IDataProviderEntity { | |
public enum Status { | |
NONE | |
, SENDING | |
, ERROR | |
, DONE | |
} | |
@Id | |
@GeneratedValue(strategy = GenerationType.IDENTITY) | |
@Column(name = "id") | |
private Long id; | |
@Lob | |
@Column(name = "recipients") | |
private String recipients; | |
@Column(name = "replyTo") | |
private String replyTo; | |
@Column(name = "subject") | |
private String subject; | |
@Lob | |
@Column(name = "body") | |
private String body; | |
@Lob | |
@Column(name = "ics") | |
private byte[] ics; | |
@Column(name = "status", nullable = false) | |
@Enumerated(EnumType.STRING) | |
private Status status = Status.NONE; | |
@Column(name = "inserted") | |
private Calendar inserted; | |
@Column(name = "updated") | |
private Calendar updated; | |
@Column(name = "error_count", nullable = false) | |
private int errorCount = 0; | |
@Lob | |
@Column(name = "last_error") | |
private String lastError; | |
public MailMessage() { | |
this(null, null, null, null, null); | |
} | |
public MailMessage(String recipients, String replyTo, String subject, String body) { | |
this(recipients, replyTo, subject, body, null); | |
} | |
public MailMessage(String recipients, String replyTo, String subject, String body, byte[] ics) { | |
this.recipients = recipients; | |
this.replyTo = replyTo; | |
this.subject = subject; | |
this.body = body; | |
this.ics = ics; | |
} | |
public Long getId() { | |
return id; | |
} | |
public void setId(Long id) { | |
this.id = id; | |
} | |
public String getRecipients() { | |
return recipients; | |
} | |
public void setRecipients(String recipients) { | |
this.recipients = recipients; | |
} | |
public String getReplyTo() { | |
return replyTo; | |
} | |
public void setReplyTo(String replyTo) { | |
this.replyTo = replyTo; | |
} | |
public String getSubject() { | |
return subject; | |
} | |
public void setSubject(String subject) { | |
this.subject = subject; | |
} | |
public String getBody() { | |
return body; | |
} | |
public void setBody(String body) { | |
this.body = body; | |
} | |
public Status getStatus() { | |
return status; | |
} | |
public void setStatus(Status status) { | |
this.status = status; | |
} | |
public Calendar getInserted() { | |
return inserted; | |
} | |
public void setInserted(Calendar inserted) { | |
this.inserted = inserted; | |
} | |
public Calendar getUpdated() { | |
return updated; | |
} | |
public void setUpdated(Calendar updated) { | |
this.updated = updated; | |
} | |
public byte[] getIcs() { | |
return ics; | |
} | |
public void setIcs(byte[] ics) { | |
this.ics = ics; | |
} | |
public int getErrorCount() { | |
return errorCount; | |
} | |
public void setErrorCount(int errorCount) { | |
this.errorCount = errorCount; | |
} | |
public String getLastError() { | |
return lastError; | |
} | |
public void setLastError(String lastError) { | |
this.lastError = lastError; | |
} | |
} |