OpenACS / openacs-4 / packages / notifications / tcl

sweep-procs-postgresql.xql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 10
Last Commit: 17 Dec
Commits this week: 0
Total Lines of Code (LoC): 0
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 21 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Tuesday 03 Sep
5:37 pm

gustafn

merge from oacs-5-10

Options
    • -40
    • +0
    ./sweep-procs-postgresql.xql
  2. … 8099 more files in changeset.
Wednesday 15 Nov 2017
11:40 am

antoniop

Uniform sql codebase

Options
    • -13
    • +0
    ./sweep-procs-postgresql.xql
  2. … 2 more files in changeset.
Tuesday 08 Aug 2017
1:47 am

gustafn

merged changes from the oacs-5-9 branch and resolved conflicts

Options
    • -4
    • +1
    ./sweep-procs-postgresql.xql
  2. … 7834 more files in changeset.
Tuesday 02 Apr 2013
1:05 pm

victorg

Rewriting acs_permission__permission_p function to use recursive queries ( available in PG since 8.4 ) and modifiying

queries around core packages to avoid checking persmissions using a subquery on the acs_object_party_privilege_map view.

Options
    • -0
    • +9
    ./sweep-procs-postgresql.xql
  2. … 14 more files in changeset.
Saturday 27 Mar 2010
3:26 pm

michaels

added security check to notifications sweep query - without this check and with no mechanism to remove requests for users who are no longer authorized, notifications still go out. not good.

Options
    • -0
    • +4
    ./sweep-procs-postgresql.xql
  2. … 1 more file in changeset.
Wednesday 03 Sep 2008
12:32 am

daveb

Fix query. Null notif_date is supported. By adding this we can allow a notif date in the future and schedule notifications for a certain time, ie: reminders.

Options
    • -1
    • +1
    ./sweep-procs-postgresql.xql
  2. … 1 more file in changeset.
Wednesday 27 Jun 2007
8:54 pm

matthewg

Adding support for file attachments via file_ids in the notifications table, includes sql upgrade scripts and bumps the version to 5.4.0d3

Options
    • -0
    • +1
    ./sweep-procs-postgresql.xql
  2. … 10 more files in changeset.
Wednesday 06 Sep 2006
8:11 pm

daveb

Allow setting notification date from notification::new and support

checking notification date when sending out notiifcations.

Options
    • -0
    • +1
    ./sweep-procs-postgresql.xql
  2. … 2 more files in changeset.
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
    • -1
    • +2
    ./sweep-procs-postgresql.xql
  2. … 816 more files in changeset.
Friday 04 Jul 2003
11:18 pm

donb

Removed notif_user from queries temporarily - this is a 4.6.4 change and

shouldn't appear in HEAD until we merge.

Options
    • -2
    • +1
    ./sweep-procs-postgresql.xql
  2. … 1 more file in changeset.
10:40 pm

donb

Applied Robert Locke's fix to the clean up query

Options
    • -3
    • +6
    ./sweep-procs-postgresql.xql
  2. … 1 more file 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
    • -31
    • +22
    ./sweep-procs-postgresql.xql
  2. … 56 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
    • -3
    • +3
    ./sweep-procs-postgresql.xql
  2. … 15 more files in changeset.
Thursday 01 Aug 2002
2:55 pm

lars

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

Options
    • -0
    • +3
    ./sweep-procs-postgresql.xql
Tuesday 25 Jun 2002
6:27 pm

yon

now the notifications sweep queries work in postgres too

Options
    • -0
    • +44
    ./sweep-procs-postgresql.xql
  2. … 2 more files in changeset.