OpenACS / openacs-4 / packages / chat

sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 11
Last Commit: 14 Nov
Commits this week: 0
Total Lines of Code (LoC): 1,990
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 1 hour ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
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-5.0.1d6-5.0.1d7.sql
  2. … 8 more files in changeset.
Friday 09 Aug 2019
11:11 pm

gustafn

improve spelling

Options
    • -2
    • +2
    ./oracle/chat-create.sql
    • -2
    • +2
    ./postgresql/chat-create.sql
    • -2
    • +2
    ./postgresql/chat-drop.sql
    • -1
    • +1
    ./postgresql/upgrade/upgrade-5.0d10-5.0d11.sql
    • -1
    • +1
    ./postgresql/upgrade/upgrade-5.0d12-5.0d13.sql
    • -1
    • +1
    ./postgresql/upgrade/upgrade-5.0d8-5.0d9.sql
  7. … 4 more files in changeset.
Wednesday 19 Jun 2019
12:51 pm

antoniop

Fix oracle upgrade, remembering to keep privilege creation, which should indeed happen in the upgrade

Options
    • -11
    • +1
    ./oracle/upgrade/upgrade-5.0.1d5-5.0.1d6.sql
    • -6
    • +3
    ./postgresql/upgrade/upgrade-5.0.1d5-5.0.1d6.sql
Tuesday 18 Jun 2019
11:13 pm

antoniop

Skip column and attribute creation in this upgrade: people will get it from xotcl ORM in version 6.* and this upgrade would conflict

Options
    • -5
    • +5
    ./postgresql/upgrade/upgrade-5.0.1d5-5.0.1d6.sql
Monday 04 Mar 2019
3:45 pm

hectorr

Fix upgrade script

Options
    • -3
    • +5
    ./postgresql/upgrade/upgrade-6.0.0d1-6.0.0d2.sql
Friday 01 Mar 2019
6:40 pm

hectorr

file upgrade-6.0.0d1-6.0.0d2.sql was initially added on branch oacs-5-10.

Options
    • -0
    • +0
    ./oracle/upgrade/upgrade-6.0.0d1-6.0.0d2.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-6.0.0d1-6.0.0d2.sql
6:40 pm

hectorr

Chat Reform: reduce complexity by removing the 'chat_avatar_allow' privilege, 'chat_room_edit' should suffice.

Options
    • -4
    • +1
    ./oracle/chat-create.sql
    • -3
    • +1
    ./oracle/chat-drop.sql
    • -0
    • +12
    ./oracle/upgrade/upgrade-6.0.0d1-6.0.0d2.sql
    • -4
    • +1
    ./postgresql/chat-create.sql
    • -3
    • +1
    ./postgresql/chat-drop.sql
    • -0
    • +12
    ./postgresql/upgrade/upgrade-6.0.0d1-6.0.0d2.sql
  7. … 2 more files in changeset.
6:25 pm

antoniop

Major reform in the chat backend: use xotcl-core ORM to define all the relevant objects and data model

This greatly converges oracle and postgres codebase and will make easier to apply incremental updates to the data model in the future. It will also automatically update the acs_object_type metadata automatically

TODO: remove legacy procs, temporarly reimplemented using the new backend

Options
    • -188
    • +1
    ./oracle/chat-create.sql
    • -290
    • +1
    ./postgresql/chat-create.sql
    • -36
    • +4
    ./postgresql/chat-drop.sql
  4. … 3 more files in changeset.
Thursday 28 Feb 2019
5:09 pm

antoniop

Chat data-model reform:

- introduce on delete cascade on foreign key constraints so package can be removed easily e.g. from the subsite UI

- remove remaining stored procedures (and function_args definitions) to relieve the burden on the development process and reduce divergency between oracle and postgres code

- converge oracle and postgres datamodels:

. oracle -> add missing messages_time_window column

. postgres -> remove creation_date from chat_transcripts, which was found to be still existing on old downstream installations

Options
    • -367
    • +12
    ./oracle/chat-create.sql
    • -4
    • +1
    ./oracle/chat-drop.sql
    • -0
    • +28
    ./oracle/upgrade/upgrade-5.0.1d6-5.0.1d7.sql
    • -137
    • +8
    ./postgresql/chat-create.sql
    • -7
    • +1
    ./postgresql/chat-drop.sql
    • -0
    • +34
    ./postgresql/upgrade/upgrade-5.0.1d6-5.0.1d7.sql
  7. … 4 more files in changeset.
5:09 pm

antoniop

file upgrade-5.0.1d6-5.0.1d7.sql was initially added on branch oacs-5-10.

Options
    • -0
    • +0
    ./oracle/upgrade/upgrade-5.0.1d6-5.0.1d7.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.0.1d6-5.0.1d7.sql
Tuesday 26 Feb 2019
7:26 pm

hectorr

Whitespace changes

Options
    • -151
    • +149
    ./oracle/chat-create.sql
    • -14
    • +5
    ./oracle/chat-drop.sql
    • -4
    • +1
    ./postgresql/chat-create.sql
    • -22
    • +11
    ./postgresql/chat-drop.sql
  5. … 1 more file in changeset.
7:06 pm

hectorr

Chat Redesign: enable/disable avatar pictures by room, using the new attribute 'avatar_p', instead of by package instance, using the 'ShowAvatar' parameter.

Options
    • -17
    • +29
    ./oracle/chat-create.sql
    • -1
    • +3
    ./oracle/chat-drop.sql
    • -0
    • +26
    ./oracle/upgrade/upgrade-5.0.1d5-5.0.1d6.sql
    • -25
    • +34
    ./postgresql/chat-create.sql
    • -1
    • +3
    ./postgresql/chat-drop.sql
    • -0
    • +19
    ./postgresql/upgrade/upgrade-5.0.1d5-5.0.1d6.sql
  7. … 14 more files in changeset.
7:06 pm

hectorr

file upgrade-5.0.1d5-5.0.1d6.sql was initially added on branch oacs-5-10.

Options
    • -0
    • +0
    ./oracle/upgrade/upgrade-5.0.1d5-5.0.1d6.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.0.1d5-5.0.1d6.sql
Thursday 12 Jul 2018
2:43 pm

antoniop

Align case of acs_object_type with that of the actual table (fixes automated tests)

This change intentionally ignores Oracle, as its behavior with respect to case is not clear to me.

Options
    • -5
    • +5
    ./postgresql/chat-create.sql
    • -0
    • +8
    ./postgresql/upgrade/upgrade-5.0-5.0.1d0.sql
  3. … 1 more file in changeset.
Tuesday 08 Aug 2017
1:47 am

gustafn

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

Options
    • -4
    • +19
    ./oracle/chat-create.sql
    • -0
    • +255
    ./oracle/upgrade/upgrade-5.0d10-5.0d11.sql
    • -295
    • +69
    ./postgresql/chat-create.sql
    • -90
    • +60
    ./postgresql/chat-drop.sql
    • -0
    • +114
    ./postgresql/upgrade/upgrade-5.0d10-5.0d11.sql
    • -0
    • +57
    ./postgresql/upgrade/upgrade-5.0d11-5.0d12.sql
    • -0
    • +18
    ./postgresql/upgrade/upgrade-5.0d12-5.0d13.sql
    • -32
    • +50
    ./postgresql/upgrade/upgrade-5.0d4-5.0d5.sql
    • -42
    • +68
    ./postgresql/upgrade/upgrade-5.0d6-5.0d7.sql
    • -13
    • +20
    ./postgresql/upgrade/upgrade-5.0d8-5.0d9.sql
  11. … 7825 more files in changeset.
Friday 21 Apr 2017
10:11 pm

gustafn

Fix spelling errors

Options
    • -2
    • +2
    ./postgresql/chat-create.sql
    • -1
    • +1
    ./postgresql/upgrade/upgrade-5.0d10-5.0d11.sql
  3. … 15 more files in changeset.
Wednesday 23 Nov 2016
8:51 pm

antoniop

Allow user to specify how far in the past people connecting to the chat will see.

This is important on Learn@WU because people joining the chat room later want to

see the full conversation and before this was not settable from the UI. (Now defaults

to 4 hours) Useful also when somebody accidentally refreshes the chat after the

timewindow has passed.

Took this chance to ease a bit every future development: removed stored procedures

slowing greatly any change on the data model in favor of plain sql statements.

Incremented usage of cache.

Removed duplicated database operation when managing transcripts.

Fixed transcript name not being shown when deleting.

Options
    • -247
    • +6
    ./postgresql/chat-create.sql
    • -38
    • +1
    ./postgresql/chat-drop.sql
    • -0
    • +18
    ./postgresql/upgrade/upgrade-5.0d12-5.0d13.sql
  4. … 10 more files in changeset.
8:51 pm

antoniop

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

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.0d12-5.0d13.sql
Tuesday 22 Nov 2016
7:34 pm

antoniop

Chats won't throw an error anymore when people keep looking to a room that has been closed.

Instead, user will be informed that the room is unavailable.

Added missing locale key source of errors in the log.

Fixed wrong stored procedure, stating different arguments than in actual usage.

Cleaned up weird idioms in xql files and chat api, moved many db operations into tcl api.

Exploited cache (ns_cache) to retrieve quickly chat room information.

Improved code quality a bit.

Ported upstream some local modification, like prettifying of flags in chat room management

and fix of double quoting in chat's javascript.

Options
    • -110
    • +11
    ./postgresql/chat-create.sql
    • -0
    • +57
    ./postgresql/upgrade/upgrade-5.0d11-5.0d12.sql
  3. … 10 more files in changeset.
7:34 pm

antoniop

file upgrade-5.0d11-5.0d12.sql was initially added on branch oacs-5-9.

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.0d11-5.0d12.sql
Friday 28 Oct 2016
9:10 pm

antoniop

Fix typo from previous commit

Options
    • -1
    • +2
    ./postgresql/chat-create.sql
    • -0
    • +1
    ./postgresql/upgrade/upgrade-5.0d10-5.0d11.sql
8:57 pm

antoniop

Introduced new options to set chat rooms so login and/or logout message are not issued everytime a user enters/exits the chat.

Options
    • -4
    • +19
    ./oracle/chat-create.sql
    • -0
    • +255
    ./oracle/upgrade/upgrade-5.0d10-5.0d11.sql
    • -20
    • +47
    ./postgresql/chat-create.sql
    • -0
    • +113
    ./postgresql/upgrade/upgrade-5.0d10-5.0d11.sql
  5. … 12 more files in changeset.
8:57 pm

antoniop

file upgrade-5.0d10-5.0d11.sql was initially added on branch oacs-5-9.

Options
    • -0
    • +0
    ./oracle/upgrade/upgrade-5.0d10-5.0d11.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.0d10-5.0d11.sql
Monday 20 Jun 2016
11:00 am

gustafn

- modernize SQL

Options
    • -107
    • +193
    ./postgresql/chat-create.sql
    • -53
    • +60
    ./postgresql/chat-drop.sql
    • -32
    • +50
    ./postgresql/upgrade/upgrade-5.0d4-5.0d5.sql
    • -42
    • +68
    ./postgresql/upgrade/upgrade-5.0d6-5.0d7.sql
    • -13
    • +20
    ./postgresql/upgrade/upgrade-5.0d8-5.0d9.sql
  6. … 4 more files in changeset.
Tuesday 14 Dec 2010
4:04 pm

victorg

PG 9.0 support. Avoiding using acs_object_id_seq view for fetchting next value for the t_acs_object_id_seq sequence.

Options
    • -2
    • +2
    ./postgresql/chat-create.sql
    • -0
    • +49
    ./postgresql/upgrade/upgrade-5.0d8-5.0d9.sql
  3. … 1 more file in changeset.
Wednesday 05 Mar 2008
10:44 am

avni

upgrade script for 2.3.0->2.4 which is really a downgrade ; does the same as upgrade-5.0d4-5.0d5.sql

Options
    • -0
    • +264
    ./oracle/upgrade/upgrade-5.0d6-5.0d7.sql
Tuesday 04 Mar 2008
9:16 am

avni

upgrade scripts which is really a downgrade; does the same as upgrade-5.0d4-5.0d5.sql

Options
    • -0
    • +92
    ./postgresql/upgrade/upgrade-5.0d6-5.0d7.sql
Monday 19 Nov 2007
2:14 am

donb

Rolled back HEAD to the version on the 5.3 branch

Options
    • -1
    • +1
    ./oracle/chat-create.sql
    • -1
    • +1
    ./oracle/chat-drop.sql
    • -758
    • +156
    ./postgresql/chat-create.sql
    • -39
    • +5
    ./postgresql/chat-drop.sql
    • -677
    • +0
    ./postgresql/upgrade/upgrade-5.0d6-5.1d.sql
  6. … 106 more files in changeset.
Tuesday 03 Jul 2007
9:49 am

avni

reverting pablom's commits to oacs-5-2: see http://openacs.org/forums/message-view?message_id=1042586

Options
    • -0
    • +0
    ./oracle/chat-create.sql
    • -0
    • +0
    ./oracle/chat-drop.sql
    • -170
    • +71
    ./postgresql/chat-create.sql
    • -4
    • +2
    ./postgresql/chat-drop.sql
  5. … 54 more files in changeset.
Sunday 24 Jun 2007
5:21 pm

maltes

Fixing a lot of bad programming techniques and try to get .LRN out of the package, in vain...

Options
    • -21
    • +5
    ./postgresql/chat-create.sql
    • -21
    • +6
    ./postgresql/upgrade/upgrade-5.0d6-5.1d.sql
  3. … 7 more files in changeset.