OpenACS / openacs-4 / packages / notifications / sql / postgresql / upgrade

upgrade-5.10.0d6-5.10.0d7.sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 2
Last Commit: 27 Dec
Commits this week: 0
Total Lines of Code (LoC): 8
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 3 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Friday 06 Nov 2020
4:52 pm

antoniop

Add missing semicolon

Options
    • -1
    • +1
    ./upgrade-5.10.0d6-5.10.0d7.sql
4:51 pm

antoniop

Solve a potential issue when one would cleanup "dynamic" notification requests: this was done directly on the table and could therefore leave dangling acs_objects around

- cleanup all acs_objects of type 'notification_request' that do not have a corresponding entry in the table (~35000 downstream)

- embed logic of delete_dynamic_requests query inside select_invalid_request_ids query, as there the deletion is done properly

Options
    • -0
    • +8
    ./upgrade-5.10.0d6-5.10.0d7.sql
  2. … 3 more files in changeset.