Mercurial > libervia-pubsub
changeset 249:aaf5e34ff765
fixed getItems when there are not authorized_groups + fixed default value for StoreItem
author | Goffi <goffi@goffi.org> |
---|---|
date | Fri, 08 Jun 2012 18:34:45 +0200 |
parents | 50f6ee966da8 |
children | eb14b8d30cba |
files | sat_pubsub/pgsql_storage.py |
diffstat | 1 files changed, 7 insertions(+), 5 deletions(-) [+] |
line wrap: on
line diff
--- a/sat_pubsub/pgsql_storage.py Sun Jun 03 15:57:28 2012 +0200 +++ b/sat_pubsub/pgsql_storage.py Fri Jun 08 18:34:45 2012 +0200 @@ -68,9 +68,9 @@ NS_ITEM_CONFIG = "http://jabber.org/protocol/pubsub#item-config" OPT_ACCESS_MODEL = 'pubsub#access_model' OPT_ROSTER_GROUPS_ALLOWED = 'pubsub#roster_groups_allowed' -VAL_DEFAULT = 'default' VAL_OPEN = 'open' VAL_ROSTER = 'roster' +VAL_DEFAULT = VAL_OPEN class Storage: @@ -608,11 +608,13 @@ INNER JOIN items USING (node_id) LEFT JOIN item_groups_authorized USING (item_id) WHERE node=%s AND - (items.access_model='open' or - (items.access_model='roster' and groupname in (%s)) - ) + (items.access_model='open' """ + + ("or (items.access_model='roster' and groupname in %s)" if authorized_groups else '') + + """) ORDER BY date DESC"""] - args = [self.nodeIdentifier, authorized_groups] + args = [self.nodeIdentifier] + if authorized_groups: + args.append(authorized_groups) if maxItems: query.append("LIMIT %s")