1 files changed, 50 insertions, 2 deletions
diff --git a/src/test/java/com/juick/tests/JsonTests.java b/src/test/java/com/juick/tests/JsonTests.java
index f44fac20..c99432a6 100644
--- a/src/test/java/com/juick/tests/JsonTests.java
+++ b/src/test/java/com/juick/tests/JsonTests.java
@@ -1,11 +1,59 @@
 package com.juick.tests;
 
-import static org.junit.Assert.assertEquals;
-
+import com.juick.json.MessageSerializer;
+import com.juick.server.MessagesQueries;
+import org.junit.Assert;
+import org.junit.Before;
 import org.junit.Test;
 
+import java.io.FileInputStream;
+import java.io.IOException;
+import java.nio.file.Files;
+import java.nio.file.Paths;
+import java.sql.Connection;
+import java.sql.DriverManager;
+import java.sql.SQLException;
+import java.util.ArrayList;
+import java.util.Properties;
+
 public class JsonTests {
+
+    Connection sql;
+
+    @Before
+    public void setupConnection() {
+        Properties conf = new Properties();
+        try {
+            conf.load(new FileInputStream("/etc/juick/api.conf"));
+            Class.forName("com.mysql.jdbc.Driver");
+            sql = DriverManager.getConnection("jdbc:mysql://localhost/juick?autoReconnect=true&user="
+                    + conf.getProperty("mysql_username", "")
+                    + "&password=" + conf.getProperty("mysql_password", ""));
+        } catch (IOException e) {
+            e.printStackTrace();
+        } catch (ClassNotFoundException e) {
+            e.printStackTrace();
+        } catch (SQLException e) {
+            e.printStackTrace();
+        }
+    }
+
     @Test
     public void CompareSerializers() {
+        ArrayList<Integer> mids = MessagesQueries.getMyFeed(sql, 3694, 2799786);
+        MessageSerializer messageSerializer = new MessageSerializer();
+        if (mids != null && !mids.isEmpty()) {
+            ArrayList<com.juick.Message> msgs = MessagesQueries.getMessages(sql, mids);
+            if (msgs != null && !msgs.isEmpty()) {
+                String json = messageSerializer.serializeList(msgs);
+                try {
+                    String data = new String(Files.readAllBytes(Paths.get("original.json")), "UTF-8");
+                    Assert.assertEquals("json should match", data, json);
+                } catch (IOException e) {
+                    e.printStackTrace();
+                }
+
+            }
+        }
     }
 }
 \ No newline at end of file