import org.cacert.gigi.localisation.Language;
import org.cacert.gigi.util.RandomToken;
-public class EmailAddress implements IdCachable {
+public class EmailAddress implements IdCachable, Verifyable {
private String address;
this.hash = RandomToken.generateToken(16);
}
- public void insert(Language l) {
- if (id != 0) {
- throw new IllegalStateException("already inserted.");
- }
+ public void insert(Language l) throws GigiApiException {
try {
- GigiPreparedStatement ps = DatabaseConnection.getInstance().prepare("INSERT INTO `emails` SET memid=?, hash=?, email=?");
- ps.setInt(1, owner.getId());
- ps.setString(2, hash);
- ps.setString(3, address);
synchronized (EmailAddress.class) {
+ if (id != 0) {
+ throw new IllegalStateException("already inserted.");
+ }
+ GigiPreparedStatement psCheck = DatabaseConnection.getInstance().prepare("SELECT 1 FROM `emails` WHERE email=? AND deleted is NULL");
+ GigiPreparedStatement ps = DatabaseConnection.getInstance().prepare("INSERT INTO `emails` SET memid=?, hash=?, email=?");
+ ps.setInt(1, owner.getId());
+ ps.setString(2, hash);
+ ps.setString(3, address);
+ psCheck.setString(1, address);
+ GigiResultSet res = psCheck.executeQuery();
+ if (res.next()) {
+ throw new GigiApiException("The email is currently valid");
+ }
ps.execute();
id = ps.lastInsertId();
myCache.put(this);