X-Git-Url: http://git.megacz.com/?a=blobdiff_plain;f=src%2Forg%2Fibex%2Fmail%2FGraylist.java;fp=src%2Forg%2Fibex%2Fmail%2FGraylist.java;h=3754c6200d3005bc5acc5971b6a9d112793bb4d3;hb=8f7212f973567b5caf9d8a4d7f9b5b400f53f44f;hp=06280626ece5c578e90d536ec015f9ec970bacba;hpb=d10aa46b70cf0b6aa92b6a763b276fdb9ec1bc6b;p=org.ibex.mail.git

diff --git a/src/org/ibex/mail/Graylist.java b/src/org/ibex/mail/Graylist.java
index 0628062..3754c62 100644
--- a/src/org/ibex/mail/Graylist.java
+++ b/src/org/ibex/mail/Graylist.java
@@ -7,21 +7,16 @@ import java.io.*;
 import java.util.*;
 import java.sql.Timestamp;
 
-public class Graylist {
-
-    private Connection conn;
+public class Graylist extends SqliteTable {
 
     public Graylist(String filename) {
-        try {
-            Class.forName("org.sqlite.JDBC");
-            conn = DriverManager.getConnection("jdbc:sqlite:"+filename);
-            conn.prepareStatement("create table if not exists "+
-                                  "'whitelist' (ip unique)").executeUpdate();
-            conn.prepareStatement("create table if not exists "+
-                                  "'graylist' (ip,fromaddr,toaddr,date, primary key(ip,fromaddr,toaddr))").executeUpdate();
-        }
-        catch (SQLException e) { throw new RuntimeException(e); }
-        catch (ClassNotFoundException e) { throw new RuntimeException(e); }
+        super(filename,
+              new String[] {
+                  "create table if not exists 'whitelist' (ip unique)",
+                  "create table if not exists 'graylist' (ip,fromaddr,toaddr,date, primary key(ip,fromaddr,toaddr))"
+              },
+              "graylist",
+              "date");
     }
 
     public synchronized void addWhitelist(InetAddress ip) {