OpenACS / openacs-4 / packages / notifications / tcl

sweep-procs-oracle.xql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 11
Last Commit: 15 Nov 17
Commits this week: 0
Total Lines of Code (LoC): 52
Net change in LoC this week: 0

Commit Activity

Commits By Day In Week
52 week commits volume
Commits By Day In Week
Commits by day
Commits By Day In Week
Commits by hour
Commits By Hour In Day
Commit calendar
 

Most active committers (90 days)

loading
loading
  • last updated 5 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Friday 15 Mar 2019
5:48 pm

antoniop

Reduce divergency between oracle and postgres codebase

Options
    • -52
    • +0
    ./sweep-procs-oracle.xql
  2. … 2 more files in changeset.
Wednesday 15 Nov 2017
11:40 am

antoniop

Uniform sql codebase

Options
    • -19
    • +0
    ./sweep-procs-oracle.xql
  2. … 2 more files in changeset.
Tuesday 08 Aug 2017
1:47 am

gustafn

merged changes from the oacs-5-9 branch and resolved conflicts

Options
    • -0
    • +11
    ./sweep-procs-oracle.xql
  2. … 7834 more files in changeset.
Sunday 03 Jul 2016
5:41 pm

gustafn

- reduce dependencies on acs_object_party_privilege_map (for PostgreSQL)

Options
    • -0
    • +11
    ./sweep-procs-oracle.xql
  2. … 6 more files in changeset.
Saturday 27 Mar 2010
3:26 pm

michaels

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.

Options
    • -0
    • +5
    ./sweep-procs-oracle.xql
  2. … 1 more file in changeset.
Wednesday 03 Sep 2008
12:32 am

daveb

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.

Options
    • -1
    • +1
    ./sweep-procs-oracle.xql
  2. … 1 more file in changeset.
Saturday 07 Jun 2008
10:28 pm

donb

Merged from 5.4.2

Options
    • -1
    • +0
    ./sweep-procs-oracle.xql
  2. … 283 more files in changeset.
Wednesday 09 Apr 2008
10:30 am

marioa

Fixed problem with query on oracle. Drop condition and !>>>!notifications.notif_date < sysdate because it doesn't exist on pg query.

Options
    • -1
    • +0
    ./sweep-procs-oracle.xql
Tuesday 15 Jan 2008
7:29 pm

donb

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

Options
    • -2
    • +2
    ./sweep-procs-oracle.xql
  2. … 2 more files in changeset.
Wednesday 27 Jun 2007
8:54 pm

matthewg

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

Options
    • -0
    • +1
    ./sweep-procs-oracle.xql
  2. … 10 more files in changeset.
Wednesday 06 Sep 2006
8:11 pm

daveb

Allow setting notification date from notification::new and support

checking notification date when sending out notiifcations.

Options
    • -0
    • +2
    ./sweep-procs-oracle.xql
  2. … 2 more files in changeset.
Thursday 28 Aug 2003
11:41 am

lars

Merged 4.6.4d1 (unreleased) to HEAD. This marks the end of the life of the oacs-4-6 branch.

Options
    • -1
    • +2
    ./sweep-procs-oracle.xql
  2. … 816 more files in changeset.
Friday 04 Jul 2003
11:18 pm

donb

Removed notif_user from queries temporarily - this is a 4.6.4 change and

shouldn't appear in HEAD until we merge.

Options
    • -2
    • +1
    ./sweep-procs-oracle.xql
  2. … 1 more file in changeset.
10:40 pm

donb

Applied Robert Locke's fix to the clean up query

Options
    • -6
    • +9
    ./sweep-procs-oracle.xql
  2. … 1 more file in changeset.
10:39 pm

donb

Applied Robert Locke's fixes to the cleanup query

Options
    • -4
    • +6
    ./sweep-procs-oracle.xql
  2. … 1 more file in changeset.
Thursday 12 Jun 2003
3:34 pm

lars

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

Options
    • -1
    • +2
    ./sweep-procs-oracle.xql
  2. … 27 more files in changeset.
Wednesday 04 Jun 2003
10:41 pm

donb

Integrated (probably unnecessary) changes from SSV2

Options
    • -1
    • +1
    ./sweep-procs-oracle.xql
  2. … 1 more file in changeset.
Thursday 13 Feb 2003
9:24 pm

jeffd

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

Options
    • -0
    • +1
    ./sweep-procs-oracle.xql
9:23 pm

jeffd

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

Options
    • -0
    • +1
    ./sweep-procs-oracle.xql
Thursday 16 Jan 2003
2:48 pm

jeffd

Merge of all changes from oacs-4-6 to HEAD. All changes up to tag jcd-merge-2

on oacs-4-6 are included.

Options
    • -29
    • +32
    ./sweep-procs-oracle.xql
  2. … 56 more files in changeset.
Wednesday 18 Dec 2002
8:55 pm

donb

Made the queries match the working PG queries

Options
    • -28
    • +30
    ./sweep-procs-oracle.xql
Tuesday 17 Dec 2002
8:58 pm

donb

Some semicolons snuck in from my test .sql files

Options
    • -0
    • +2
    ./sweep-procs-oracle.xql
  2. … 1 more file in changeset.
Friday 06 Dec 2002
10:03 pm

donb

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.

Options
    • -17
    • +16
    ./sweep-procs-oracle.xql
  2. … 9 more files in changeset.
Friday 20 Sep 2002
11:18 pm

jeffd

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.

Options
    • -3
    • +3
    ./sweep-procs-oracle.xql
  2. … 15 more files in changeset.
Monday 01 Jul 2002
9:35 pm

ben

added batched notification capability (still alpha with lots of logging)

Options
    • -0
    • +3
    ./sweep-procs-oracle.xql
  2. … 4 more files in changeset.
Saturday 29 Jun 2002
2:21 am

ben

fixed notifications and forums for replies

Options
    • -0
    • +2
    ./sweep-procs-oracle.xql
  2. … 11 more files in changeset.
Friday 28 Jun 2002
10:21 pm

ben

adding replies

Options
    • -1
    • +1
    ./sweep-procs-oracle.xql
  2. … 5 more files in changeset.
Tuesday 25 Jun 2002
8:58 pm

ben

merged

Options
    • -0
    • +1
    ./sweep-procs-oracle.xql
  2. … 11 more files in changeset.
6:27 pm

yon

now the notifications sweep queries work in postgres too

Options
    • -2
    • +2
    ./sweep-procs-oracle.xql
  2. … 2 more files in changeset.
Tuesday 04 Jun 2002
12:27 am

yon

fixed bug in xql file and cleaned them up too

Options
    • -24
    • +34
    ./sweep-procs-oracle.xql
  2. … 8 more files in changeset.