public EmailAddress[] getEmails() {
try {
- PreparedStatement ps = DatabaseConnection.getInstance().prepare("SELECT id FROM email WHERE memid=?");
+ PreparedStatement ps = DatabaseConnection.getInstance().prepare(
+ "SELECT id FROM email WHERE memid=? AND deleted=0");
ps.setInt(1, id);
ResultSet rs = ps.executeQuery();
rs.last();
return null;
}
+ public Domain[] getDomains() {
+ try {
+ PreparedStatement ps = DatabaseConnection.getInstance().prepare(
+ "SELECT id FROM domain WHERE memid=? AND deleted IS NULL");
+ ps.setInt(1, id);
+ ResultSet rs = ps.executeQuery();
+ rs.last();
+ int count = rs.getRow();
+ Domain[] data = new Domain[count];
+ rs.beforeFirst();
+ for (int i = 0; i < data.length; i++) {
+ if (!rs.next()) {
+ throw new Error("Internal sql api violation.");
+ }
+ data[i] = Domain.getById(rs.getInt(1));
+ }
+ rs.close();
+ return data;
+ } catch (SQLException e) {
+ e.printStackTrace();
+ }
+
+ return null;
+ }
+
public void updateDefaultEmail(EmailAddress newMail) throws GigiApiException {
try {
EmailAddress[] adrs = getEmails();
if (getEmail().equals(mail.getAddress())) {
throw new GigiApiException("Can't delete user's default e-mail.");
}
- try {
- PreparedStatement ps = DatabaseConnection.getInstance().prepare("UPDATE email SET deleted=1 WHERE id=?");
- ps.setInt(1, mail.getId());
- ps.execute();
- } catch (SQLException e) {
- throw new GigiApiException(e);
+ EmailAddress[] emails = getEmails();
+ for (int i = 0; i < emails.length; i++) {
+ if (emails[i].getId() == mail.getId()) {
+ try {
+ PreparedStatement ps = DatabaseConnection.getInstance().prepare(
+ "UPDATE email SET deleted=? WHERE id=?");
+ ps.setDate(1, new Date(System.currentTimeMillis()));
+ ps.setInt(2, mail.getId());
+ ps.execute();
+ } catch (SQLException e) {
+ e.printStackTrace();
+ throw new GigiApiException(e);
+ }
+ return;
+ }
}
+ throw new GigiApiException("Email not one user's mail addresses.");
}
}