OpenACS / openacs-4 / packages / chat / tcl

chat-procs-postgresql.xql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 8
Last Commit: 08 Aug 17
Commits this week: 0
Total Lines of Code (LoC): 36
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 13 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
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
    • -36
    • +0
    ./chat-procs-postgresql.xql
  2. … 9 more files in changeset.
Tuesday 08 Aug 2017
1:47 am

gustafn

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

Options
    • -221
    • +32
    ./chat-procs-postgresql.xql
  2. … 7834 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
    • -70
    • +2
    ./chat-procs-postgresql.xql
  2. … 12 more files in changeset.
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
    • -217
    • +99
    ./chat-procs-postgresql.xql
  2. … 11 more files in changeset.
Friday 28 Oct 2016
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
    • +8
    ./chat-procs-postgresql.xql
  2. … 15 more files in changeset.
Saturday 02 Jul 2016
12:41 pm

gustafn

- remove unneeded queries and .xql file

Options
    • -7
    • +0
    ./chat-procs-postgresql.xql
  2. … 5 more files in changeset.
Monday 19 Nov 2007
2:14 am

donb

Rolled back HEAD to the version on the 5.3 branch

Options
    • -342
    • +22
    ./chat-procs-postgresql.xql
  2. … 110 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
    • -44
    • +20
    ./chat-procs-postgresql.xql
  2. … 57 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
    • -2
    • +2
    ./chat-procs-postgresql.xql
  2. … 8 more files in changeset.
Thursday 07 Jun 2007
11:14 am

pablom

"New version of the package"

Options
    • -7
    • +303
    ./chat-procs-postgresql.xql
  2. … 88 more files in changeset.
Thursday 26 Oct 2006
1:11 pm

pablom

Improvements in order to increase the funcionalities, overall in the creation and using of chat rooms

Options
    • -20
    • +44
    ./chat-procs-postgresql.xql
  2. … 12 more files in changeset.
Saturday 24 Jun 2006
4:23 pm

gustafn

brought chat in cvs head to the same level as in oacs-5-2, normalized comparisons and expr (using eq etc.)

Options
    • -4
    • +6
    ./chat-procs-postgresql.xql
  2. … 81 more files in changeset.
Tuesday 11 Apr 2006
6:46 pm

emmar

reverting to previous revision to avoid duplicated queries. chat_flush_rooms.get_rooms and chat_flush_rooms.get_archives_messages are now in the common xql chat-procs.xql

Options
    • -19
    • +1
    ./chat-procs-postgresql.xql
1:29 pm

palberer

update to make xotcl a dependency

Options
    • -1
    • +19
    ./chat-procs-postgresql.xql
  2. … 12 more files in changeset.
9:59 am

emmar

extracting queries for auto-flushing

Options
    • -18
    • +0
    ./chat-procs-postgresql.xql
  2. … 2 more files in changeset.
Friday 07 Apr 2006
6:59 pm

palberer

Support flushing of messages at night

Options
    • -1
    • +21
    ./chat-procs-postgresql.xql
  2. … 18 more files in changeset.
Tuesday 14 Mar 2006
1:16 pm

emmar

Valencia chat package. Provides support for postgresql and few enhancements like user search.

Options
    • -0
    • +223
    ./chat-procs-postgresql.xql
  2. … 90 more files in changeset.