• last updated 7 hours 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.
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.
Merged from 5.4.2

  1. … 283 more files in changeset.
Fixed problem with query on oracle. Drop condition and !>>>!notifications.notif_date < sysdate because it doesn't exist on pg query.

It's "sysdate", not "sysdate()", folks :)

  1. … 2 more files 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.
Integrated (probably unnecessary) changes from SSV2

  1. … 1 more file in changeset.
should pull out notif_text in oracle query bug 236/patch 76 Bruno Mattarollo

should pull out notif_text in oracle query bug 236/patch 76 Bruno Mattarollo

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.
Made the queries match the working PG queries

Some semicolons snuck in from my test .sql files

  1. … 1 more file 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.
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.
added batched notification capability (still alpha with lots of logging)

  1. … 4 more files in changeset.
fixed notifications and forums for replies

  1. … 11 more files in changeset.
adding replies

  1. … 5 more files in changeset.
merged

  1. … 11 more files in changeset.
now the notifications sweep queries work in postgres too

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

  1. … 8 more files in changeset.