# HG changeset patch
# User Paul Boddie <paul@boddie.org.uk>
# Date 1461330196 -7200
# Node ID 6f9d4c2c206c9857c2ad3b4dfbee47bbd77e302d
# Parent  e690f82677364f4799fa8da9208543f1bb8ca5ff
Determine store users by also looking in the objects and recurrences tables.

diff -r e690f8267736 -r 6f9d4c2c206c imiptools/stores/database/common.py
--- a/imiptools/stores/database/common.py	Fri Apr 22 00:09:07 2016 +0200
+++ b/imiptools/stores/database/common.py	Fri Apr 22 15:03:16 2016 +0200
@@ -52,7 +52,11 @@
 
         "Return a list of users."
 
-        query = "select distinct store_user from freebusy"
+        query = "select distinct store_user from (" \
+                "select store_user from freebusy " \
+                "union all select store_user from objects " \
+                "union all select store_user from recurrences" \
+                ") as users"
         self.cursor.execute(query)
         return [r[0] for r in self.cursor.fetchall()]