Coordinates is an object with an array

Ensure that the array is of a fixed length, add tests to check for that.

1 files changed, 7 insertions, 1 deletions

diff --git a/src/database/QueryUtils.java b/src/database/QueryUtils.java
index 228ccc8..66edd1c 100644
--- a/src/database/QueryUtils.java
+++ b/src/database/QueryUtils.java
@@ -94,7 +94,13 @@ public class QueryUtils {
         tweetStatement.setLong("favoritecount", tweet.favorite_count);
         tweetStatement.setLong("retweetcount", tweet.retweet_count);
         tweetStatement.setString("text", tweet.text);
-        tweetStatement.setString("coordinates", tweet.coordinates);
+        if (tweet.coordinates != null) {
+            float[] coords = tweet.coordinates.coordinates;
+            String coords_str = String.format("%f,%f", coords[0], coords[1]);
+            tweetStatement.setString("coordinates", coords_str);
+        } else {
+            tweetStatement.setString("coordinates", null);
+        }
         tweetStatement.setString("language", tweet.lang);
         if (tweet.retweeted_status != null) {
             tweetStatement.setLong("retweetid", tweet.retweeted_status.id);