From 1cf0241aed94015f5c5fc523b756cbbd5a797de7 Mon Sep 17 00:00:00 2001
From: Christian Schneppe <christian@pix-art.de>
Date: Sun, 20 Nov 2016 17:42:16 +0100
Subject: remove omemo devices from annoucement after 7 days of inactivity

---
 .../de/pixart/messenger/persistance/DatabaseBackend.java   | 14 ++++++++++++++
 1 file changed, 14 insertions(+)

(limited to 'src/main/java/de/pixart/messenger/persistance/DatabaseBackend.java')

diff --git a/src/main/java/de/pixart/messenger/persistance/DatabaseBackend.java b/src/main/java/de/pixart/messenger/persistance/DatabaseBackend.java
index 03b71c226..25fb2aeef 100644
--- a/src/main/java/de/pixart/messenger/persistance/DatabaseBackend.java
+++ b/src/main/java/de/pixart/messenger/persistance/DatabaseBackend.java
@@ -786,6 +786,20 @@ public class DatabaseBackend extends SQLiteOpenHelper {
         }
     }
 
+    public long getLastTimeFingerprintUsed(Account account, String fingerprint) {
+        String SQL = "select messages.timeSent from accounts join conversations on accounts.uuid=conversations.accountUuid join messages on conversations.uuid=messages.conversationUuid where accounts.uuid=? and messages.axolotl_fingerprint=? order by messages.timesent desc limit 1";
+        String[] args = {account.getUuid(), fingerprint};
+        Cursor cursor = getReadableDatabase().rawQuery(SQL,args);
+        long time;
+        if (cursor.moveToFirst()) {
+            time = cursor.getLong(0);
+        } else {
+            time = 0;
+        }
+        cursor.close();
+        return time;
+    }
+
     public Pair<Long, String> getLastClearDate(Account account) {
         SQLiteDatabase db = this.getReadableDatabase();
         String[] columns = {Conversation.ATTRIBUTES};
-- 
cgit v1.2.3