OpenACS / openacs-4 / packages / notifications / tcl

sweep-procs-postgresql.xql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 10
Last Commit: 17 Dec
Commits this week: 0
Total Lines of Code (LoC): 0
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 21 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Tuesday 03 Sep
5:37 pm

gustafn

merge from oacs-5-10

Options
    • -40
    • +0
    ./sweep-procs-postgresql.xql
  2. … 8099 more files in changeset.
Friday 15 Mar 2019
5:48 pm

antoniop

Reduce divergency between oracle and postgres codebase

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

antoniop

Uniform sql codebase

Options
    • -13
    • +0
    ./sweep-procs-postgresql.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
    • -4
    • +1
    ./sweep-procs-postgresql.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
    • -4
    • +1
    ./sweep-procs-postgresql.xql
  2. … 6 more files in changeset.
Tuesday 02 Apr 2013
1:05 pm

victorg

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.

Options
    • -0
    • +9
    ./sweep-procs-postgresql.xql
  2. … 14 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
    • +4
    ./sweep-procs-postgresql.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-postgresql.xql
  2. … 1 more file 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-postgresql.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
    • +1
    ./sweep-procs-postgresql.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-postgresql.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-postgresql.xql
  2. … 1 more file in changeset.
10:40 pm

donb

Applied Robert Locke's fix to the clean up query

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

donb

Applied Robert Locke's fixes to the cleanup query

Options
    • -2
    • +3
    ./sweep-procs-postgresql.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-postgresql.xql
  2. … 27 more files in changeset.
Wednesday 04 Jun 2003
10:43 pm

donb

Oops - typo in last commit

Options
    • -1
    • +1
    ./sweep-procs-postgresql.xql
10:41 pm

donb

Integrated (probably unnecessary) changes from SSV2

Options
    • -2
    • +3
    ./sweep-procs-postgresql.xql
  2. … 1 more file in changeset.
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
    • -31
    • +22
    ./sweep-procs-postgresql.xql
  2. … 56 more files in changeset.
Tuesday 17 Dec 2002
8:58 pm

donb

Some semicolons snuck in from my test .sql files

Options
    • -2
    • +2
    ./sweep-procs-postgresql.xql
  2. … 1 more file in changeset.
5:53 pm

donb

The never ending attempt to fix notifications ...

Options
    • -29
    • +20
    ./sweep-procs-postgresql.xql
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
    • -15
    • +15
    ./sweep-procs-postgresql.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-postgresql.xql
  2. … 15 more files in changeset.
Thursday 01 Aug 2002
2:55 pm

lars

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

Options
    • -0
    • +3
    ./sweep-procs-postgresql.xql
Tuesday 25 Jun 2002
6:27 pm

yon

now the notifications sweep queries work in postgres too

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