OpenACS / openacs-4 / packages / forums

sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 30
Last Commit: 26 Dec
Commits this week: 0
Total Lines of Code (LoC): 7,294
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 5 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Tuesday 03 Sep
12:43 pm

antoniop

Cleanup leftover references to files deleted in https://cvs.openacs.org/changelog/OpenACS?cs=oacs-5-10%3Aantoniop%3A20200507144307

This was not preventing the installation or functionalities of the forums package, so it has been long missed. Upon closer inspection, errors were popping up in the installation UI.

Options
    • -4
    • +1
    ./oracle/forums-create.sql
    • -3
    • +0
    ./oracle/forums-drop.sql
    • -3
    • +0
    ./postgresql/forums-create.sql
    • -3
    • +0
    ./postgresql/forums-drop.sql
  5. … 1 more file in changeset.
Saturday 12 Feb 2022
9:11 pm

gustafn

improving Oracle upgrade scripts

Oracle has no "ALTER TABLE ADD COLUMN ...."

Oracle has no "ALTER TABLE ADD COLUMN if exists .."

Options
    • -1
    • +1
    ./oracle/upgrade/upgrade-1.3-1.3d1.sql
    • -1
    • +1
    ./oracle/upgrade/upgrade-1.3.1d2-1.3.1d3.sql
  3. … 7 more files in changeset.
Thursday 29 Apr 2021
4:03 pm

antoniop

Handle correctly the indexing of moderated messages in fulltext search:

so far the fulltext search would also include unapproved messages and threads. With this reform we address this by:

- making sure unapproved threads are deleted from the index

- making sure new threads are added to the index only when the are approved

- making sure we unindex or reindex a thread whenever the approval state changes

- not fetching unapproved messages in the datasource callback, hence excluding them from the index

Note that Oracle has not been targeted by the reform. However, the situation improves for Oracle as well, because we won't render unmoderated messages in the datasource callback anymore.

Options
    • -6
    • +59
    ./postgresql/forums-sc-create.sql
    • -0
    • +124
    ./postgresql/upgrade/upgrade-1.4.0d3-1.4.0d4.sql
  3. … 2 more files in changeset.
4:03 pm

antoniop

file upgrade-1.4.0d3-1.4.0d4.sql was initially added on branch oacs-5-10.

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-1.4.0d3-1.4.0d4.sql
Tuesday 06 Oct 2020
10:23 am

antoniop

New index on the forums_reading_info table

Options
    • -0
    • +1
    ./postgresql/forums-reading-info-create.sql
    • -0
    • +3
    ./postgresql/upgrade/upgrade-1.4d2-1.4d3.sql
  3. … 1 more file in changeset.
10:23 am

antoniop

file upgrade-1.4d2-1.4d3.sql was initially added on branch oacs-5-10.

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-1.4d2-1.4d3.sql
10:20 am

antoniop

Whitespace cleanup

Options
    • -8
    • +7
    ./postgresql/forums-reading-info-create.sql
Thursday 07 May 2020
4:43 pm

antoniop

Move logics to create forum notification type to tcl to:

- reduce code duplication

- make it simpler to extend forums with new notification types

This reform was triggered by a downstream request, where users would like a new kind of notification for forum moderators that triggers also when a forum message has not been approved

Options
    • -118
    • +0
    ./oracle/forums-notifications-init.sql
    • -128
    • +0
    ./oracle/forums-notifications-sanitize.sql
    • -134
    • +0
    ./postgresql/forums-notifications-init.sql
    • -151
    • +0
    ./postgresql/forums-notifications-sanitize.sql
  5. … 1 more file in changeset.
Wednesday 11 Mar 2020
8:50 pm

antoniop

file upgrade-1.3.1d16-1.3.1d17.sql was initially added on branch oacs-5-10.

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-1.3.1d16-1.3.1d17.sql
8:50 pm

antoniop

Redefine forum charter as text, therefore without length limit

Options
    • -3
    • +17
    ./postgresql/forums-forums-create.sql
    • -0
    • +27
    ./postgresql/upgrade/upgrade-1.3.1d16-1.3.1d17.sql
  3. … 1 more file in changeset.
Tuesday 18 Jun 2019
8:38 pm

hectorr

Add column 'attachments_allowed_p' to 'forums_forums', to be used to allow/disallow attachments on a per forum basis. Currently, the attachment logic is package instance wise, so if the forums instance has an attachment instance mounted below, then attachments are assumed to be enabled for all forums in that package instance. The idea with this change is to check for both the attachments instance mounted under a particular forum instance, and the 'attachments_allowed_p' column on 'forums_forums', to decide if attachments are enabled or not (both should be true). Next step would be to rewrite the logic to achieve that.

Options
    • -0
    • +6
    ./oracle/forums-forums-create.sql
    • -0
    • +15
    ./oracle/upgrade/upgrade-1.3.1d12-1.3.1d13.sql
    • -1
    • +4
    ./postgresql/forums-forums-create.sql
    • -0
    • +10
    ./postgresql/upgrade/upgrade-1.3.1d12-1.3.1d13.sql
  5. … 1 more file in changeset.
8:38 pm

hectorr

file upgrade-1.3.1d12-1.3.1d13.sql was initially added on branch oacs-5-10.

Options
    • -0
    • +0
    ./oracle/upgrade/upgrade-1.3.1d12-1.3.1d13.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-1.3.1d12-1.3.1d13.sql
Wednesday 15 Aug 2018
6:49 pm

gustafn

Removed obsolete @arch-tag

Options
    • -2
    • +1
    ./oracle/upgrade/upgrade-1.2.0d3-1.2.0d4.sql
    • -2
    • +1
    ./postgresql/upgrade/upgrade-1.2.0d3-1.2.0d4.sql
  3. … 25 more files in changeset.
Wednesday 04 Apr 2018
6:18 am

gustafn

improve spelliing

Options
    • -2
    • +2
    ./postgresql/forums-messages-package-create.sql
    • -1
    • +1
    ./postgresql/upgrade/upgrade-1.2d1-1.2d2.sql
  3. … 2 more files in changeset.
Thursday 29 Mar 2018
5:03 pm

hectorr

Fix typos

Options
    • -1
    • +1
    ./postgresql/upgrade/upgrade-1.3.1d2-1.3.1d3.sql
  2. … 61 more files in changeset.
Monday 29 Jan 2018
1:01 pm

gustafn

- fix inconsistency between updated versions and new intallations: check always the message format

- add text/markdown to accepted formats

Options
    • -0
    • +2
    ./postgresql/forums-messages-create.sql
    • -0
    • +11
    ./postgresql/upgrade/upgrade-1.3.1d4-1.3.1d5.sql
  3. … 1 more file in changeset.
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
    • -5
    • +16
    ./oracle/forums-reading-info-package-create.sql
    • -0
    • +163
    ./oracle/upgrade/upgrade-1.3.1d3-1.3.1d4.sql
    • -2
    • +6
    ./postgresql/forums-reading-info-create.sql
    • -0
    • +34
    ./postgresql/upgrade/upgrade-1.3.1d3-1.3.1d4.sql
  5. … 4 more files in changeset.
1:52 pm

antoniop

Fix sql update to populate new forum_id column in existing data

Options
    • -3
    • +9
    ./oracle/upgrade/upgrade-1.3.1d2-1.3.1d3.sql
    • -4
    • +9
    ./postgresql/upgrade/upgrade-1.3.1d2-1.3.1d3.sql
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
    • -17
    • +10
    ./oracle/forums-reading-info-create.sql
    • -3
    • +3
    ./oracle/forums-reading-info-drop.sql
    • -143
    • +5
    ./oracle/forums-reading-info-package-create.sql
    • -0
    • +186
    ./oracle/upgrade/upgrade-1.3.1d2-1.3.1d3.sql
    • -195
    • +68
    ./postgresql/forums-reading-info-create.sql
    • -9
    • +4
    ./postgresql/forums-reading-info-drop.sql
    • -0
    • +173
    ./postgresql/upgrade/upgrade-1.3.1d2-1.3.1d3.sql
  8. … 2 more files in changeset.
Wednesday 08 Nov 2017
1:05 pm

antoniop

Implement post anonymously through explicit forum attribute in table

Now moderators can explicitly decide whether a forum will enable posting anonymously or not.

Forum must be in a policy different from closed and the anonymous flag must be set accordingly for this to happen.

Also:

- normalize api in a way it can accomodate all current attributes. In particular,

now edit api will now leave every unspecified attribute unchanged, instead of

setting it to some default.

- fix some usability issues when managing forum parameters (e.g. values not

retrieved in form when editing existing forum)

- introduce missing Oracle upgrade script for the whole forum reform

- fix oracle creation script

Options
    • -1
    • +7
    ./oracle/forums-forums-create.sql
    • -0
    • +27
    ./oracle/upgrade/upgrade-1.3.1d1-1.3.1d2.sql
    • -0
    • +3
    ./postgresql/forums-forums-create.sql
    • -0
    • +13
    ./postgresql/upgrade/upgrade-1.3.1d1-1.3.1d2.sql
  5. … 7 more files in changeset.
Wednesday 27 Sep 2017
1:07 pm

antoniop

Forum reform

- remove hardcoded dependency with registered_users group. Target is to improve suitability in convoluted multi groups/multi subsites context

- in place of previous permission-based machinery, use plain table columns to detect whether user can or cannot post replies/new threads

- remove permission check at the message level in favor of that on forum level

Options
    • -0
    • +6
    ./oracle/forums-forums-create.sql
    • -0
    • +18
    ./oracle/upgrade/upgrade-1.3-1.3d1.sql
    • -0
    • +3
    ./postgresql/forums-forums-create.sql
    • -0
    • +13
    ./postgresql/upgrade/upgrade-1.3-1.3.1d1.sql
  5. … 18 more files in changeset.
Tuesday 08 Aug 2017
1:47 am

gustafn

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

Options
    • -6
    • +4
    ./postgresql/forums-forums-create.sql
    • -5
    • +3
    ./postgresql/forums-messages-create.sql
    • -5
    • +5
    ./postgresql/forums-messages-package-create.sql
    • -0
    • +1
    ./postgresql/forums-reading-info-create.sql
    • -0
    • +39
    ./postgresql/upgrade/upgrade-1.3d12-1.3d13.sql
  6. … 7830 more files in changeset.
Saturday 14 May 2016
7:51 pm

gustafn

- make update script more robust

Options
    • -6
    • +27
    ./postgresql/upgrade/upgrade-1.3d12-1.3d13.sql
7:33 pm

gustafn

Alter caveman style booleans (type character(1)) to real SQL boolean types.

Options
    • -6
    • +4
    ./postgresql/forums-forums-create.sql
    • -5
    • +3
    ./postgresql/forums-messages-create.sql
    • -5
    • +5
    ./postgresql/forums-messages-package-create.sql
    • -0
    • +18
    ./postgresql/upgrade/upgrade-1.3d12-1.3d13.sql
  5. … 1 more file in changeset.
7:33 pm

gustafn

file upgrade-1.3d12-1.3d13.sql was initially added on branch oacs-5-9.

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-1.3d12-1.3d13.sql
Sunday 11 Oct 2015
8:10 pm

gustafn

- add function args for completeness

Options
    • -0
    • +1
    ./postgresql/forums-reading-info-create.sql
Tuesday 30 Jun 2015
1:39 pm

gustafn

- add function args missed by earlier upgrades

- bump version numbers

Options
    • -0
    • +21
    ./postgresql/upgrade/upgrade-1.3d10-1.3d11.sql
  2. … 9 more files in changeset.
Tuesday 03 Sep 2013
9:34 pm

gustafn

- fix half-baken dollar quoting

Options
    • -3
    • +6
    ./postgresql/forums-forums-create.sql
    • -3
    • +3
    ./postgresql/upgrade/upgrade-1.1.2d4-1.1.2d5.sql
Sunday 25 Aug 2013
12:04 pm

gustafn

- fix half-baken dollar quoting

Options
    • -3
    • +6
    ./postgresql/forums-forums-create.sql
    • -3
    • +3
    ./postgresql/upgrade/upgrade-1.1.2d4-1.1.2d5.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
    • -10
    • +11
    ./postgresql/forums-forums-create.sql
    • -16
    • +16
    ./postgresql/forums-forums-drop.sql
    • -32
    • +51
    ./postgresql/forums-forums-package-create.sql
    • -13
    • +13
    ./postgresql/forums-messages-create.sql
    • -5
    • +5
    ./postgresql/forums-messages-drop.sql
    • -82
    • +132
    ./postgresql/forums-messages-package-create.sql
    • -45
    • +53
    ./postgresql/forums-notifications-init.sql
    • -37
    • +52
    ./postgresql/forums-notifications-sanitize.sql
    • -55
    • +116
    ./postgresql/forums-reading-info-create.sql
    • -33
    • +40
    ./postgresql/forums-sc-create.sql
    • -7
    • +14
    ./postgresql/forums-tree-create.sql
    • -44
    • +70
    ./postgresql/upgrade/upgrade-0.1d-0.2d.sql
    • -7
    • +16
    ./postgresql/upgrade/upgrade-0.2d-0.3d.sql
    • -47
    • +76
    ./postgresql/upgrade/upgrade-1.0.6-1.0.7d.sql
    • -23
    • +30
    ./postgresql/upgrade/upgrade-1.0d4-1.0.1d2.sql
  16. … 9 more files in changeset.