notifications-package-create.sql

  • last updated 13 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Merging back to HEAD branch oacs-5-8 (using tag vg-merge-oacs-5-8-from-20141027).

    • -25
    • +28
    ./notifications-package-create.sql
  1. … 2547 more files in changeset.
- add missing function args

    • -25
    • +28
    ./notifications-package-create.sql
  1. … 8 more files in changeset.
- update postgres function to modern style plpgsql definitions using dollar quoting

    • -53
    • +29
    ./notifications-package-create.sql
  1. … 1 more file in changeset.
- update postgres function to modern style plpgsql definitions, avoid backslash escaping

- add missing function_args

    • -96
    • +153
    ./notifications-package-create.sql
  1. … 19 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.
merge of changes on oacs-5-1 branch between tags jcd-merge-5-1-20040517 and jcd-merge-5-1-20040628 to HEAD

  1. … 687 more files in changeset.
fix from Sloan: proc to delete all notifications for a user, which will be used later when we have callbacks to call things like this when we delete a user from core

  1. … 4 more files in changeset.
Merged 4.6.4d1 (unreleased) to HEAD. This marks the end of the life of the oacs-4-6 branch.

    • -11
    • +12
    ./notifications-package-create.sql
  1. … 816 more files 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

    • -11
    • +12
    ./notifications-package-create.sql
  1. … 27 more files in changeset.
merge of 4.6.3b1 to HEAD

  1. … 41 more files in changeset.
Upgrade to 4.6.2: Notifications extensions - dynamic notifications recipients.

    • -12
    • +24
    ./notifications-package-create.sql
  1. … 20 more files in changeset.
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 ...

  1. … 39 more files in changeset.
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.

  1. … 15 more files in changeset.
Added support for dynamic notifications

    • -12
    • +23
    ./notifications-package-create.sql
  1. … 32 more files in changeset.
merge bartt PG 7.3 fixes from HEAD

  1. … 54 more files in changeset.
Patches to make OpenACS PG 7.3 compatible.

  1. … 54 more files in changeset.
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

  1. … 4 more files in changeset.
removed parens from around select clause in for clause which barfs on pg 7.1. fix from davb

copyright OpenForce -> MIT

  1. … 113 more files in changeset.
postgres port stuff

    • -41
    • +41
    ./notifications-package-create.sql
  1. … 7 more files in changeset.
ported notifications to PG (the new stuff)

    • -39
    • +11
    ./notifications-package-create.sql
  1. … 4 more files in changeset.
merged

    • -68
    • +99
    ./notifications-package-create.sql
  1. … 11 more files in changeset.
fixed some defaults

    • -211
    • +199
    ./notifications-package-create.sql
  1. … 1 more file in changeset.
begun PG port

    • -0
    • +282
    ./notifications-package-create.sql
  1. … 5 more files in changeset.