def test_delete(self):
req = MockRequest(self.env, authname='joe')
with self.env.db_transaction:
ids = [
self._add_subscriber(req, 'TicketSubscriber1'),
self._add_subscriber(req, 'TicketSubscriber2'),
self._add_subscriber(req, 'TicketSubscriber3'),
self._add_subscriber(req,
'XmppSubscriber1',
distributor='xmpp',
adverb='never'),
self._add_subscriber(req,
'XmppSubscriber2',
distributor='xmpp')
]
self.assertEqual(
5,
self.env.db_query(
"""\
SELECT COUNT(*) FROM notify_subscription
WHERE sid=%s AND authenticated=%s""", ('joe', 1))[0][0])
Subscription.delete(self.env, ids[1])
rows = self.env.db_query(
"""\
SELECT id, distributor, priority, class FROM notify_subscription
WHERE sid=%s AND authenticated=%s
ORDER BY distributor, priority""", ('joe', 1))
self.assertEqual((ids[0], 'email', 1, 'TicketSubscriber1'), rows[0])
self.assertEqual((ids[2], 'email', 2, 'TicketSubscriber3'), rows[1])
self.assertEqual((ids[3], 'xmpp', 1, 'XmppSubscriber1'), rows[2])
self.assertEqual((ids[4], 'xmpp', 2, 'XmppSubscriber2'), rows[3])
self.assertEqual(4, len(rows))
def _delete_rule(self, arg, req):
session = req.session
Subscription.delete(self.env, arg, session.sid, session.authenticated)
def _delete_rule(self, arg, req):
Subscription.delete(self.env, arg)
def _delete_rule(self, arg, req):
Subscription.delete(self.env, arg)
