notification-request-procs.xql

  • last updated 26 mins ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Added a new procedure to return all request_ids, so you could loop over the list and delete them (if you want to)

  1. … 1 more file in changeset.
Added procedure for retrieving the list of subscribers

  1. … 2 more files in changeset.
Added request_count procedure from 5.1

  1. … 1 more file in changeset.
Added new request proc from 5.1

  1. … 1 more file in changeset.
Added ability to count number of notifications of a type on a particular object

  1. … 2 more files in changeset.
Merge of all changes from oacs-4-6 to HEAD. All changes up to tag jcd-merge-2

on oacs-4-6 are included.

  1. … 56 more files in changeset.
1. Changed cleanup sweep interval to 15 minutes

2. Fixed broken PostgreSQL and Oracle queries that were supposed to select

notifications for deletion but rather returned all notifications if any

were ripe for deletion, causing seemingly random failure to deliver

notifications. Sloan had hacked this with a kludge to only delete

notifications older than two days but this didn't work on openacs.org,

which supports weekly summaries of notifications.

3. Changed notification::new to not insert notifications that have no

pending requests. This avoids having to waste time deleting them

afterwards.

4. Added notification_request::request_exists which returns true if

there's at least one notification request for a given object and

notification type.

5. Added a couple of indexes to speed queries that ran slow on openacs.org.

  1. … 9 more files in changeset.
fixed bug in xql file and cleaned them up too

  1. … 8 more files in changeset.
fixes

  1. … 1 more file in changeset.
notifications now works for instantaneous stuff

    • -0
    • +11
    ./notification-request-procs.xql
  1. … 21 more files in changeset.