sweep-procs-postgresql.xql

  • last updated 16 mins ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Reduce divergency between oracle and postgres codebase

  1. … 2 more files in changeset.
Uniform sql codebase

  1. … 2 more files in changeset.
merged changes from the oacs-5-9 branch and resolved conflicts

  1. … 7834 more files in changeset.
- reduce dependencies on acs_object_party_privilege_map (for PostgreSQL)

  1. … 6 more files in changeset.
Rewriting acs_permission__permission_p function to use recursive queries ( available in PG since 8.4 ) and modifiying

queries around core packages to avoid checking persmissions using a subquery on the acs_object_party_privilege_map view.

  1. … 14 more files in changeset.
added security check to notifications sweep query - without this check and with no mechanism to remove requests for users who are no longer authorized, notifications still go out. not good.

  1. … 1 more file in changeset.
Fix query. Null notif_date is supported. By adding this we can allow a notif date in the future and schedule notifications for a certain time, ie: reminders.

  1. … 1 more file in changeset.
Adding support for file attachments via file_ids in the notifications table, includes sql upgrade scripts and bumps the version to 5.4.0d3

  1. … 10 more files in changeset.
Allow setting notification date from notification::new and support

checking notification date when sending out notiifcations.

  1. … 2 more files in changeset.
Merged 4.6.4d1 (unreleased) to HEAD. This marks the end of the life of the oacs-4-6 branch.

  1. … 816 more files in changeset.
Removed notif_user from queries temporarily - this is a 4.6.4 change and

shouldn't appear in HEAD until we merge.

  1. … 1 more file in changeset.
Applied Robert Locke's fix to the clean up query

  1. … 1 more file in changeset.
Applied Robert Locke's fixes to the cleanup query

  1. … 1 more file in changeset.
Added support for notifications going out as the user who sent the notification. This required changing the delivery method service contract, so I moved all service contracts into tcl

  1. … 27 more files in changeset.
Oops - typo in last commit

Integrated (probably unnecessary) changes from SSV2

  1. … 1 more file 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.
Some semicolons snuck in from my test .sql files

  1. … 1 more file in changeset.
The never ending attempt to fix notifications ...

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.
Fixes from sloan

* Increase field sizes for subject

* adds a manage page

* adds a object_id redirect (object-goto.tcl)

* linking to manage page in outgoing message.

  1. … 15 more files in changeset.
Missing columns in query. These were in the Oracle query, and at least the delivery_method_id was expected, and caused failure down the line

now the notifications sweep queries work in postgres too

    • -0
    • +44
    ./sweep-procs-postgresql.xql
  1. … 2 more files in changeset.