summary refs log tree commit diff
path: root/synapse/storage/receipts.py
diff options
context:
space:
mode:
authorDavid Baker <dave@matrix.org>2016-05-23 18:33:51 +0100
committerDavid Baker <dave@matrix.org>2016-05-23 18:33:51 +0100
commita24bc5b2dc3a5d81cdfbe7be367dbb461d85b999 (patch)
tree594f9f3756483fe33880e0aba9fadf6e023dd58e /synapse/storage/receipts.py
parentRemove debug logging (diff)
downloadsynapse-a24bc5b2dc3a5d81cdfbe7be367dbb461d85b999.tar.xz
Add GET /notifications API
Diffstat (limited to 'synapse/storage/receipts.py')
-rw-r--r--synapse/storage/receipts.py25
1 files changed, 25 insertions, 0 deletions
diff --git a/synapse/storage/receipts.py b/synapse/storage/receipts.py
index f1774f0e44..d147a60602 100644
--- a/synapse/storage/receipts.py
+++ b/synapse/storage/receipts.py
@@ -75,6 +75,31 @@ class ReceiptsStore(SQLBaseStore):
         defer.returnValue({row["room_id"]: row["event_id"] for row in rows})
 
     @defer.inlineCallbacks
+    def get_receipts_for_user_with_orderings(self, user_id, receipt_type):
+        def f(txn):
+            sql = (
+                "SELECT rl.room_id, rl.event_id,"
+                " e.topological_ordering, e.stream_ordering"
+                " FROM receipts_linearized rl,"
+                " events e"
+                " WHERE rl.room_id = e.room_id"
+                " AND rl.event_id = e.event_id"
+                " AND user_id = ?"
+            )
+            txn.execute(sql, (user_id,))
+            return txn.fetchall()
+        rows = yield self.runInteraction(
+            "get_receipts_for_user_with_orderings", f
+        )
+        defer.returnValue({
+            row[0]: {
+                "event_id": row[1],
+                "topological_ordering": row[2],
+                "stream_ordering": row[3],
+            } for row in rows
+        })
+
+    @defer.inlineCallbacks
     def get_linearized_receipts_for_rooms(self, room_ids, to_key, from_key=None):
         """Get receipts for multiple rooms for sending to clients.