• last updated 6 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
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
begun adding support for replies

    • -0
    • +44
    ./sql/oracle/notifications-replies-create.sql
    • -0
    • +83
    ./sql/oracle/notifications-replies-package-create.sql
    • -0
    • +13
    ./tcl/notification-reply-procs-oracle.xql
    • -0
    • +64
    ./tcl/notification-reply-procs.tcl
    • -0
    • +138
    ./tcl/reply-sweep-procs.tcl
fixes

bringing info files up to date

  1. … 1 more file in changeset.
begun PG port

    • -0
    • +211
    ./sql/postgresql/notifications-core-create.sql
    • -0
    • +57
    ./sql/postgresql/notifications-core-drop.sql
    • -0
    • +18
    ./sql/postgresql/notifications-create.sql
    • -0
    • +53
    ./sql/postgresql/notifications-init.sql
    • -0
    • +282
    ./sql/postgresql/notifications-package-create.sql
    • -0
    • +47
    ./sql/postgresql/notifications-package-drop.sql
added better notification format

    • -6
    • +27
    ./tcl/notification-display-procs.tcl
updates to notifications made to clobs

    • -2
    • +2
    ./sql/oracle/notifications-core-create.sql