OpenACS / openacs-4 / packages / notifications

sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 21
Last Commit: 27 Dec
Commits this week: 0
Total Lines of Code (LoC): 3,578
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 16 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
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
    • -1
    • +3
    ./oracle/notifications-core-create.sql
    • -3
    • +5
    ./postgresql/notifications-core-create.sql
  3. … 8 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
    • -2
    • +2
    ./oracle/notifications-core-create.sql
    • -2
    • +2
    ./postgresql/notifications-core-create.sql
  3. … 14 more files in changeset.
9:32 am

jeffd

fixes bug 1731/patch 442 Tilman Singer

Options
    • -1
    • +2
    ./postgresql/notifications-replies-package-create.sql
Monday 19 Aug 2002
10:38 pm

arjun

fixing

Options
    • -1
    • +13
    ./postgresql/upgrade/upgrade-0.1d-0.2d.sql
10:37 pm

arjun

1. updated .info file with some missing files for PG

2. fixed the notification.delete func in both DBs

3. bumped pacakge version to 0.2d

Options
    • -0
    • +2
    ./oracle/notifications-package-create.sql
    • -0
    • +1
    ./oracle/upgrade/upgrade-0.1d-0.2d.sql
    • -0
    • +1
    ./postgresql/notifications-package-create.sql
    • -0
    • +1
    ./postgresql/upgrade/upgrade-0.1d-0.2d.sql
  5. … 1 more file in changeset.
Monday 12 Aug 2002
9:56 pm

arjun

removed parens from around select clause in for clause which barfs on pg 7.1. fix from davb

Options
    • -3
    • +3
    ./postgresql/notifications-package-create.sql
Friday 09 Aug 2002
10:51 pm

yon

copyright OpenForce -> MIT

Options
    • -2
    • +2
    ./oracle/delivery-method-sc-create.sql
    • -2
    • +2
    ./oracle/email-sc-impl-create.sql
    • -2
    • +2
    ./oracle/notification-type-sc-create.sql
    • -2
    • +2
    ./oracle/notifications-core-create.sql
    • -2
    • +2
    ./oracle/notifications-core-drop.sql
    • -2
    • +2
    ./oracle/notifications-create.sql
    • -2
    • +2
    ./oracle/notifications-init.sql
    • -1
    • +1
    ./oracle/notifications-package-create.sql
    • -1
    • +1
    ./oracle/notifications-package-drop.sql
    • -1
    • +1
    ./oracle/notifications-replies-create.sql
    • -1
    • +1
    ./oracle/notifications-replies-package-create.sql
    • -3
    • +3
    ./postgresql/delivery-method-sc-create.sql
    • -2
    • +2
    ./postgresql/email-sc-impl-create.sql
    • -2
    • +2
    ./postgresql/notification-type-sc-create.sql
    • -2
    • +2
    ./postgresql/notifications-core-create.sql
  16. … 99 more files in changeset.
Sunday 21 Jul 2002
11:25 pm

chak

postgres port stuff

Options
    • -41
    • +41
    ./postgresql/notifications-package-create.sql
  2. … 7 more files in changeset.
Monday 01 Jul 2002
6:07 am

ben

ported notifications to PG (the new stuff)

Options
    • -2
    • +5
    ./postgresql/delivery-method-sc-create.sql
    • -0
    • +67
    ./postgresql/email-sc-impl-create.sql
    • -2
    • +0
    ./postgresql/notifications-create.sql
    • -9
    • +11
    ./postgresql/notifications-init.sql
    • -39
    • +11
    ./postgresql/notifications-package-create.sql
Saturday 29 Jun 2002
3:27 am

ben

reporting to PG

Options
    • -0
    • +69
    ./postgresql/delivery-method-sc-create.sql
    • -0
    • +73
    ./postgresql/notification-type-sc-create.sql
    • -0
    • +10
    ./postgresql/notifications-create.sql
    • -0
    • +42
    ./postgresql/notifications-replies-create.sql
    • -0
    • +62
    ./postgresql/notifications-replies-package-create.sql
Friday 28 Jun 2002
10:21 pm

ben

adding replies

Options
    • -1
    • +6
    ./oracle/notifications-create.sql
  2. … 5 more files in changeset.
Tuesday 25 Jun 2002
10:41 pm

ben

fixed more typos

Options
    • -4
    • +4
    ./oracle/email-sc-impl-create.sql
10:23 pm

ben

fixing typos

Options
    • -0
    • +68
    ./oracle/delivery-method-sc-create.sql
    • -0
    • +61
    ./oracle/email-sc-impl-create.sql
    • -0
    • +68
    ./oracle/notification-type-sc-create.sql
    • -2
    • +2
    ./oracle/notifications-core-create.sql
    • -1
    • +2
    ./oracle/notifications-create.sql
8:58 pm

ben

merged

Options
    • -2
    • +8
    ./oracle/notifications-core-create.sql
    • -1
    • +2
    ./oracle/notifications-create.sql
    • -7
    • +9
    ./oracle/notifications-init.sql
    • -4
    • +8
    ./oracle/notifications-package-create.sql
    • -2
    • +8
    ./postgresql/notifications-core-create.sql
    • -68
    • +99
    ./postgresql/notifications-package-create.sql
  7. … 6 more files in changeset.
12:12 am

yon

fixed some defaults

Options
    • -10
    • +15
    ./postgresql/notifications-core-create.sql
    • -211
    • +199
    ./postgresql/notifications-package-create.sql
Wednesday 12 Jun 2002
3:53 pm

yon

fixing postgres port

Options
    • -59
    • +88
    ./postgresql/notifications-core-create.sql
    • -34
    • +25
    ./postgresql/notifications-core-drop.sql
    • -1
    • +0
    ./postgresql/notifications-create.sql
    • -0
    • +15
    ./postgresql/notifications-drop.sql
    • -39
    • +47
    ./postgresql/notifications-init.sql
  6. … 4 more files in changeset.
Wednesday 05 Jun 2002
12:53 am

yon

adding "on delete cascade" clauses where appropriate

Options
    • -148
    • +163
    ./oracle/notifications-core-create.sql
    • -34
    • +23
    ./oracle/notifications-core-drop.sql
    • -3
    • +4
    ./oracle/notifications-create.sql
    • -27
    • +29
    ./oracle/notifications-init.sql
    • -162
    • +175
    ./postgresql/notifications-core-create.sql
Monday 03 Jun 2002
10:13 am

ben

begun adding support for replies

Options
    • -0
    • +44
    ./oracle/notifications-replies-create.sql
    • -0
    • +83
    ./oracle/notifications-replies-package-create.sql
  3. … 5 more files in changeset.
Saturday 01 Jun 2002
9:04 pm

ben

begun PG port

Options
    • -0
    • +211
    ./postgresql/notifications-core-create.sql
    • -0
    • +57
    ./postgresql/notifications-core-drop.sql
    • -0
    • +18
    ./postgresql/notifications-create.sql
    • -0
    • +53
    ./postgresql/notifications-init.sql
    • -0
    • +282
    ./postgresql/notifications-package-create.sql
    • -0
    • +47
    ./postgresql/notifications-package-drop.sql
Wednesday 29 May 2002
11:47 pm

ben

updates to notifications made to clobs

Options
    • -2
    • +2
    ./oracle/notifications-core-create.sql
    • -4
    • +5
    ./oracle/notifications-package-create.sql
  3. … 1 more file in changeset.
7:12 am

ben

notifications now works for instantaneous stuff

Options
    • -0
    • +1
    ./oracle/notifications-core-create.sql
    • -0
    • +2
    ./oracle/notifications-create.sql
    • -0
    • +45
    ./oracle/notifications-init.sql
    • -2
    • +20
    ./oracle/notifications-package-create.sql
  5. … 18 more files in changeset.
Friday 24 May 2002
10:42 pm

ben

initial check in of notifications

Options
    • -0
    • +0
    ./oracle/notifications-core-create.sql
    • -0
    • +0
    ./oracle/notifications-core-drop.sql
    • -0
    • +0
    ./oracle/notifications-create.sql
    • -0
    • +0
    ./oracle/notifications-package-create.sql
    • -0
    • +0
    ./oracle/notifications-package-drop.sql
  6. … 11 more files in changeset.
10:42 pm

ben

Initial revision

Options
    • -0
    • +201
    ./oracle/notifications-core-create.sql
    • -0
    • +60
    ./oracle/notifications-core-drop.sql
    • -0
    • +16
    ./oracle/notifications-create.sql
    • -0
    • +366
    ./oracle/notifications-package-create.sql
    • -0
    • +22
    ./oracle/notifications-package-drop.sql
  6. … 21 more files in changeset.