• last updated 6 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
remove superfluous package local masters and use sitewide master by default

  1. … 700 more files in changeset.
move title and context out of page, propigate context

fixing

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

    • -0
    • +1
    ./sql/oracle/upgrade/upgrade-0.1d-0.2d.sql
    • -0
    • +1
    ./sql/postgresql/upgrade/upgrade-0.1d-0.2d.sql
removed parens from around select clause in for clause which barfs on pg 7.1. fix from davb

copyright OpenForce -> MIT

    • -2
    • +2
    ./sql/oracle/delivery-method-sc-create.sql
    • -2
    • +2
    ./sql/oracle/notifications-core-create.sql
    • -2
    • +2
    ./sql/oracle/notifications-core-drop.sql
    • -1
    • +1
    ./sql/oracle/notifications-replies-package-create.sql
    • -2
    • +2
    ./sql/postgresql/email-sc-impl-create.sql
  1. … 99 more files in changeset.
Added header to the request-new page. Changed form id from 'request' to 'subscribe' to avoid clash with the form builder magic form id 'request'

I took the liberty to go ahead and implement this pretty_name addition to subscribe_url that I mentioned in the bboard thread.

The insert statement included a sysdate, yet it was in the common .xql file. I moved it out to the -oracle and -postgresql files and changed it to now() for postgresql.

    • -0
    • +11
    ./tcl/notification-procs-oracle.xql
    • -0
    • +10
    ./tcl/notification-procs-postgresql.xql
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

postgres port stuff

    • -0
    • +6
    ./tcl/notification-request-procs-postgresql.xql
  1. … 6 more files in changeset.
remove ad_system_name call from instant notification subject. left it in

batched notifications.

    • -24
    • +23
    ./tcl/notification-email-procs.tcl
parameterized all the right stuff

fixed the sweeper

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

ported notifications to PG (the new stuff)

    • -0
    • +67
    ./sql/postgresql/email-sc-impl-create.sql
    • -2
    • +0
    ./sql/postgresql/notifications-create.sql
    • -9
    • +11
    ./sql/postgresql/notifications-init.sql
reporting to PG

    • -0
    • +69
    ./sql/postgresql/delivery-method-sc-create.sql
    • -0
    • +73
    ./sql/postgresql/notification-type-sc-create.sql
    • -0
    • +10
    ./sql/postgresql/notifications-create.sql
    • -0
    • +42
    ./sql/postgresql/notifications-replies-create.sql
    • -0
    • +62
    ./sql/postgresql/notifications-replies-package-create.sql
fixed notifications and forums for replies

    • -0
    • +13
    ./tcl/notification-reply-procs.xql
    • -0
    • +17
    ./tcl/reply-sweep-procs.xql
  1. … 3 more files in changeset.
adding replies

fixed more typos

fixing typos

    • -0
    • +68
    ./sql/oracle/delivery-method-sc-create.sql
    • -0
    • +61
    ./sql/oracle/email-sc-impl-create.sql
    • -0
    • +68
    ./sql/oracle/notification-type-sc-create.sql
    • -2
    • +2
    ./sql/oracle/notifications-core-create.sql
adding reply processing

    • -0
    • +13
    ./tcl/delivery-method-procs.xql
    • -0
    • +181
    ./tcl/notification-email-procs.tcl
    • -0
    • +13
    ./tcl/reply-sweep-init.tcl
merged

    • -2
    • +8
    ./sql/oracle/notifications-core-create.sql
some postgres porting

    • -0
    • +12
    ./tcl/notification-procs-postgresql.xql
    • -0
    • +12
    ./tcl/notification-reply-procs-postgresql.xql
now the notifications sweep queries work in postgres too

    • -0
    • +44
    ./tcl/sweep-procs-postgresql.xql
fixed some defaults

    • -211
    • +199
    ./sql/postgresql/notifications-package-create.sql
fixing postgres port

    • -1
    • +0
    ./sql/postgresql/notifications-create.sql
    • -0
    • +15
    ./sql/postgresql/notifications-drop.sql
    • -39
    • +47
    ./sql/postgresql/notifications-init.sql
  1. … 4 more files in changeset.
adding "on delete cascade" clauses where appropriate

    • -148
    • +163
    ./sql/oracle/notifications-core-create.sql
    • -34
    • +23
    ./sql/oracle/notifications-core-drop.sql
    • -27
    • +29
    ./sql/oracle/notifications-init.sql
only add notification if it doesn't already exist

    • -6
    • +10
    ./tcl/notification-request-procs.tcl
fixed bug in xql file and cleaned them up too

    • -8
    • +9
    ./tcl/notification-reply-procs-oracle.xql
    • -15
    • +16
    ./tcl/notification-request-procs-oracle.xql
    • -6
    • +7
    ./tcl/notification-request-procs-postgresql.xql
    • -50
    • +67
    ./tcl/notification-type-procs.xql