OpenACS / openacs-4 / packages / forums / sql / postgresql

forums-reading-info-create.sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 4
Last Commit: 30 Apr
Commits this week: 0
Total Lines of Code (LoC): 165
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 10 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Tuesday 06 Oct 2020
10:23 am

antoniop

New index on the forums_reading_info table

Options
    • -0
    • +1
    ./forums-reading-info-create.sql
  2. … 2 more files in changeset.
10:20 am

antoniop

Whitespace cleanup

Options
    • -8
    • +7
    ./forums-reading-info-create.sql
Monday 13 Nov 2017
4:22 pm

antoniop

Port downstream only usage of reading info api

Also fix such api so that root message is retrieved for every given source message

Options
    • -2
    • +6
    ./forums-reading-info-create.sql
  2. … 7 more files in changeset.
Friday 10 Nov 2017
6:21 pm

antoniop

Maintenance of forum reading count feature

- removal of forums_reading_info_user (1Mio rows on Learn@WU).

This materialized view had to be constantly synced with

forums_reading_info table. Reimplemented as view.

- simplify logics in stored procedure due to new datamodel

- fix inconsistencies between oracle and postgres function definition

- re-enabled parameter to decide whether use these stats or not in

administration

TODO: consider further reform of this feature as stats grow very

large on busy sites for probably little value added

Options
    • -195
    • +68
    ./forums-reading-info-create.sql
  2. … 8 more files in changeset.
Tuesday 08 Aug 2017
1:47 am

gustafn

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

Options
    • -0
    • +1
    ./forums-reading-info-create.sql
  2. … 7834 more files in changeset.
Sunday 11 Oct 2015
8:10 pm

gustafn

- add function args for completeness

Options
    • -0
    • +1
    ./forums-reading-info-create.sql
Monday 12 Aug 2013
11:34 am

gustafn

- update postgres function to modern style plpgsql definitions, avoid backslash escaping

- add missing function_args

Options
    • -55
    • +116
    ./forums-reading-info-create.sql
  2. … 23 more files in changeset.
Monday 04 Jun 2007
2:43 pm

davidam

fixed some problems with constraints

Options
    • -3
    • +4
    ./forums-reading-info-create.sql
Tuesday 22 May 2007
11:42 am

michaelt

store and display reading info

Options
    • -0
    • +225
    ./forums-reading-info-create.sql
  2. … 19 more files in changeset.