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: 20:00
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 34 mins ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Thursday 06 Nov 2003
5:44 pm

matk

o updated create/drop scripts

o removed debug statement

o correct param documentation of bounce_mail_message

Options
    • -2
    • +2
    ./oracle/notifications-create.sql
    • -0
    • +1
    ./postgresql/notifications-create.sql
    • -0
    • +1
    ./postgresql/notifications-drop.sql
  4. … 1 more file in changeset.
3:28 pm

matk

Added bounce messages for improperly addressed emails and for emails

from unauthorized senders.

Messages follow the qmail-send Bounce Messages Format (QDBMF)

http://cr.yp.to/proto/qsbmf.txt

Added a notification_email_hold table to hold possible bounce messages

until they are accepted by the system.

Options
    • -0
    • +7
    ./oracle/notifications-replies-extra-create.sql
    • -0
    • +1
    ./oracle/notifications-replies-extra-drop.sql
    • -0
    • +7
    ./postgresql/notifications-replies-extra-create.sql
    • -0
    • +1
    ./postgresql/notifications-replies-extra-drop.sql
  5. … 4 more files in changeset.
Wednesday 08 Oct 2003
6:53 pm

mohanp

Added upgrade to upgrade to changes made for Oracle 9i support

Options
    • -0
    • +486
    ./oracle/upgrade/upgrade-4.6.4-5.0d1.sql
  2. … 23 more files in changeset.
Tuesday 30 Sep 2003
2:10 pm

mohanp

Oracle9i porting changes

- Changed procedure names from delete to del

- Changed view declaration to use actual column names

- Changed "rel_constraints_violated_one" and "rel_constraints_violated_two"

(http://openacs.org/forums/message-view?message_id=81045)

Options
    • -2
    • +2
    ./oracle/notifications-core-drop.sql
    • -23
    • +23
    ./oracle/notifications-package-create.sql
    • -4
    • +4
    ./oracle/notifications-replies-package-create.sql
  4. … 273 more files in changeset.
Monday 22 Sep 2003
10:56 pm

lars

Applied patch #123: Added dropping of these objects and permissions removal. This should be rolled into acs_object.delete, but if this makes dropping work, that's better than nothing

Options
    • -1
    • +37
    ./oracle/notifications-core-drop.sql
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
    • -68
    • +0
    ./oracle/delivery-method-sc-create.sql
    • -61
    • +0
    ./oracle/email-sc-impl-create.sql
    • -68
    • +0
    ./oracle/notification-type-sc-create.sql
    • -2
    • +5
    ./oracle/notifications-core-create.sql
    • -8
    • +2
    ./oracle/notifications-create.sql
    • -10
    • +1
    ./oracle/notifications-init.sql
    • -2
    • +4
    ./oracle/notifications-package-create.sql
    • -0
    • +99
    ./oracle/upgrade/upgrade-4.6.2-4.6.4.sql
    • -72
    • +0
    ./postgresql/delivery-method-sc-create.sql
    • -67
    • +0
    ./postgresql/email-sc-impl-create.sql
    • -73
    • +0
    ./postgresql/notification-type-sc-create.sql
    • -73
    • +67
    ./postgresql/notifications-core-create.sql
    • -8
    • +0
    ./postgresql/notifications-create.sql
    • -53
    • +29
    ./postgresql/notifications-init.sql
    • -11
    • +12
    ./postgresql/notifications-package-create.sql
  16. … 802 more files in changeset.
Tuesday 17 Jun 2003
9:19 am

lars

Forgot to remove the call to notification-type-sc-create.sql. Can't believe I didn't catch this in my fresh-install test

Options
    • -2
    • +0
    ./oracle/notifications-create.sql
    • -2
    • +0
    ./postgresql/notifications-create.sql
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
    • -68
    • +0
    ./oracle/delivery-method-sc-create.sql
    • -61
    • +0
    ./oracle/email-sc-impl-create.sql
    • -68
    • +0
    ./oracle/notification-type-sc-create.sql
    • -1
    • +4
    ./oracle/notifications-core-create.sql
    • -7
    • +3
    ./oracle/notifications-create.sql
    • -10
    • +1
    ./oracle/notifications-init.sql
    • -2
    • +4
    ./oracle/notifications-package-create.sql
    • -0
    • +99
    ./oracle/upgrade/upgrade-4.6.2-4.6.4.sql
    • -72
    • +0
    ./postgresql/delivery-method-sc-create.sql
    • -67
    • +0
    ./postgresql/email-sc-impl-create.sql
    • -73
    • +0
    ./postgresql/notification-type-sc-create.sql
    • -72
    • +66
    ./postgresql/notifications-core-create.sql
    • -6
    • +0
    ./postgresql/notifications-create.sql
    • -53
    • +29
    ./postgresql/notifications-init.sql
    • -11
    • +12
    ./postgresql/notifications-package-create.sql
  16. … 13 more files in changeset.
3:34 pm

lars

file upgrade-4.6.2-4.6.4.sql was initially added on branch oacs-4-6.

Options
    • -0
    • +0
    ./oracle/upgrade/upgrade-4.6.2-4.6.4.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-4.6.2-4.6.4.sql
Saturday 17 May 2003
12:47 pm

jeffd

merge of 4.6.3b1 to HEAD

Options
    • -1
    • +10
    ./oracle/notifications-core-create.sql
    • -1
    • +8
    ./oracle/notifications-package-create.sql
    • -0
    • +4
    ./oracle/notifications-replies-create.sql
    • -0
    • +1
    ./oracle/upgrade/upgrade-0.2d-0.3d.sql
    • -0
    • +69
    ./oracle/upgrade/upgrade-0.4d-4.6.1.sql
    • -0
    • +156
    ./oracle/upgrade/upgrade-4.6.1-4.6.2.sql
    • -3
    • +12
    ./postgresql/notifications-core-create.sql
    • -6
    • +16
    ./postgresql/notifications-package-create.sql
    • -5
    • +5
    ./postgresql/notifications-package-drop.sql
    • -1
    • +6
    ./postgresql/notifications-replies-create.sql
    • -1
    • +1
    ./postgresql/notifications-replies-package-create.sql
    • -0
    • +1
    ./postgresql/upgrade/upgrade-0.2d-0.3d.sql
    • -0
    • +21
    ./postgresql/upgrade/upgrade-0.4d-4.6.1.sql
    • -0
    • +89
    ./postgresql/upgrade/upgrade-4.6.1-4.6.2.sql
  15. … 28 more files in changeset.
Wednesday 05 Mar 2003
4:03 pm

lars

file upgrade-4.6.1-4.6.2.sql was initially added on branch oacs-4-6.

Options
    • -0
    • +0
    ./oracle/upgrade/upgrade-4.6.1-4.6.2.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-4.6.1-4.6.2.sql
4:02 pm

lars

Upgrade to 4.6.2: Notifications extensions - dynamic notifications recipients.

Options
    • -7
    • +16
    ./oracle/notifications-core-create.sql
    • -3
    • +6
    ./oracle/notifications-package-create.sql
    • -0
    • +156
    ./oracle/upgrade/upgrade-4.6.1-4.6.2.sql
    • -2
    • +3
    ./postgresql/notifications-core-create.sql
    • -12
    • +24
    ./postgresql/notifications-package-create.sql
    • -0
    • +89
    ./postgresql/upgrade/upgrade-4.6.1-4.6.2.sql
  7. … 15 more files in changeset.
Sunday 02 Mar 2003
11:42 pm

donb

I've changed "timestamp" to "timestamptz" and have begun fixing some

code that used to be legal but as of PG 7.3 is not. You can no longer

subtract an integer from a timestamp but must cast to date, "timestamp"

disappeared (must use "interval" now), "datetime" disappeared ("timestamptz"),

and suchwhat.

Not done but closer than it was before ...

Options
    • -3
    • +3
    ./postgresql/notifications-core-create.sql
    • -5
    • +5
    ./postgresql/notifications-package-create.sql
    • -5
    • +5
    ./postgresql/notifications-package-drop.sql
    • -1
    • +1
    ./postgresql/notifications-replies-create.sql
    • -1
    • +1
    ./postgresql/notifications-replies-package-create.sql
  6. … 35 more files in changeset.
Wednesday 26 Feb 2003
3:27 am

donb

file upgrade-0.4d-4.6.1.sql was initially added on branch oacs-4-6.

Options
    • -0
    • +0
    ./oracle/upgrade/upgrade-0.4d-4.6.1.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-0.4d-4.6.1.sql
3:21 am

donb

A bunch of things

1. AOLserver 4.0's nsxml appears to expose a gcc bug which causes the

backwards-compatible "getattr" command to fail. I dug around nsxml

and it does appear to be a gcc bug. I changed to the proper nsxml v2

syntax.

2. In the course of exploring #1 above, I realized that the calls to

dom:: Tcl XML package commands were still being executed despite

being commented out. Typical Tcl misunderstanding on someone's part.

Net effect: we were parsing all APM .info files twice, once in Tcl

and once in ns_xml! Yuk!

3. Fixed a minor notifications bug - you couldn't delete a notification

request if any unsent notifications were pending, causing the homework

package to bomb if you deleted an uploaded homework file and the prof

hadn't yet received their notification.

4. Fixed an obscure corner case in my permissions denormalization code.

Options
    • -1
    • +8
    ./oracle/notifications-package-create.sql
    • -0
    • +69
    ./oracle/upgrade/upgrade-0.4d-4.6.1.sql
    • -1
    • +10
    ./postgresql/notifications-package-create.sql
    • -0
    • +21
    ./postgresql/upgrade/upgrade-0.4d-4.6.1.sql
  5. … 12 more files in changeset.
Tuesday 25 Feb 2003
11:16 am

lars

Make Oracle version cascade in all the places that the PG version does

Options
    • -0
    • +43
    ./oracle/upgrade/upgrade-0.4d-0.5d.sql
  2. … 1 more file in changeset.
11:05 am

lars

Added support for dynamic notifications

Options
    • -7
    • +16
    ./oracle/notifications-core-create.sql
    • -3
    • +6
    ./oracle/notifications-package-create.sql
    • -0
    • +112
    ./oracle/upgrade/upgrade-0.3d-0.4d.sql
    • -2
    • +3
    ./postgresql/notifications-core-create.sql
    • -12
    • +23
    ./postgresql/notifications-package-create.sql
    • -0
    • +89
    ./postgresql/upgrade/upgrade-0.3d-0.4d.sql
  7. … 27 more files in changeset.
Saturday 01 Feb 2003
1:14 am

jeffd

file upgrade-0.2d-0.3d.sql was initially added on branch oacs-4-6.

Options
    • -0
    • +0
    ./oracle/upgrade/upgrade-0.2d-0.3d.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-0.2d-0.3d.sql
1:14 am

jeffd

file upgrade-0.3d-0.4d.sql was initially added on branch oacs-4-6.

Options
    • -0
    • +0
    ./oracle/upgrade/upgrade-0.3d-0.4d.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-0.3d-0.4d.sql
1:14 am

jeffd

adds indexes for foreign keys, bumps to version 0.4d, upgrade scripts added

Options
    • -1
    • +10
    ./oracle/notifications-core-create.sql
    • -0
    • +4
    ./oracle/notifications-replies-create.sql
    • -0
    • +1
    ./oracle/upgrade/upgrade-0.2d-0.3d.sql
    • -0
    • +23
    ./oracle/upgrade/upgrade-0.3d-0.4d.sql
    • -1
    • +10
    ./postgresql/notifications-core-create.sql
    • -0
    • +5
    ./postgresql/notifications-replies-create.sql
    • -0
    • +1
    ./postgresql/upgrade/upgrade-0.2d-0.3d.sql
    • -0
    • +23
    ./postgresql/upgrade/upgrade-0.3d-0.4d.sql
  9. … 1 more file in changeset.
Tuesday 21 Jan 2003
2:45 pm

jeffd

merge bartt PG 7.3 fixes from HEAD

Options
    • -5
    • +5
    ./postgresql/notifications-package-create.sql
    • -1
    • +1
    ./postgresql/notifications-replies-package-create.sql
  3. … 53 more files 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
    • -1
    • +3
    ./oracle/notifications-core-create.sql
    • -3
    • +5
    ./postgresql/notifications-core-create.sql
  3. … 55 more files in changeset.
Saturday 21 Dec 2002
11:27 pm

bartt

Patches to make OpenACS PG 7.3 compatible.

Options
    • -5
    • +5
    ./postgresql/notifications-package-create.sql
    • -1
    • +1
    ./postgresql/notifications-replies-package-create.sql
  3. … 53 more files 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
    • -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.