OpenACS / openacs-4 / packages / acs-tcl / tcl

01-database-procs.tcl

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 3
Last Commit: 12 Jun
Commits this week: 0
Total Lines of Code (LoC): 3,993
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 11 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Wednesday 12 Mar
10:11 am

gustafn

improved log messages to pinpoint location and reason

Options
    • -2
    • +2
    ./01-database-procs.tcl
  2. … 1 more file in changeset.
Monday 21 Oct 2024
5:49 pm

gustafn

improved inline documentation

Options
    • -24
    • +40
    ./01-database-procs.tcl
  2. … 1 more file in changeset.
Sunday 20 Oct 2024
12:13 pm

gustafn

improved API documentation

Options
    • -6
    • +6
    ./01-database-procs.tcl
  2. … 1 more file in changeset.
Wednesday 11 Sep 2024
8:11 am

gustafn

merge with missing files

Options
    • -0
    • +0
    ./01-database-procs.tcl
  2. … 1464 more files in changeset.
Tuesday 03 Sep 2024
5:37 pm

gustafn

merge from oacs-5-10

Options
    • -0
    • +3977
    ./01-database-procs.tcl
  2. … 8099 more files in changeset.
Friday 16 Aug 2024
9:01 am

antoniop

Fix regression in db_multirow_group_last_row_p

Row is last when the next value changes

Many thanks to Miachel Aram for reporting the issue

Options
    • -2
    • +2
    ./01-database-procs.tcl
Saturday 10 Aug 2024
4:47 pm

gustafn

reduced verbosity in the system log, provide hint to message

Options
    • -2
    • +14
    ./01-database-procs.tcl
Friday 17 Nov 2023
2:32 pm

gustafn

db_multirow: fall back to -local behavior, when used outside of an ADP file

The old behavior was, that when "db_multirow" was called outside an ADP

environment, an error was generated, since the uplevel was determined

without the "-local" flag by [template::adp_level]. Outside ADP,

the result of the function is empty, leading to an error that

a level "#" is invalid. Depending on an optional flag is strange

for a "db_*" command.

Now, the default behavior outside ADP file is local (i.e., when

calling outside ADP, the output variables are set in the calling

scope, unless a different "upvar_level" is specified).

Options
    • -10
    • +22
    ./01-database-procs.tcl
Thursday 20 Apr 2023
5:49 pm

antoniop

Fallback to the location of the psql executable when a pgbin was not explicitly defined in the config file (which is allowed)

Options
    • -2
    • +15
    ./01-database-procs.tcl
Tuesday 21 Feb 2023
11:59 am

antoniop

Fix typo

Options
    • -2
    • +2
    ./01-database-procs.tcl
11:53 am

antoniop

Repair -column_set flag

A more efficient approach would use db api returning ns_sets directly, rather than db_list_of_lists, however this would require a deeper refactoring.

Options
    • -7
    • +26
    ./01-database-procs.tcl
Monday 06 Feb 2023
6:11 pm

antoniop

Deprecate old api

Options
    • -2
    • +12
    ./01-database-procs.tcl
Monday 02 Jan 2023
6:46 pm

antoniop

Fix typo

Options
    • -2
    • +2
    ./01-database-procs.tcl
Thursday 29 Dec 2022
1:52 pm

gustafn

improved support for cluster-wide operations

Options
    • -4
    • +14
    ./01-database-procs.tcl
  2. … 2 more files in changeset.
Monday 28 Nov 2022
6:49 pm

gustafn

New package parameter for acs-tcl: DbLogMinDuration

This parameter can be used to adjust the time threshold for longdb

warnings in the log file. When SQL logging is turned on, it might

also adjust the threshold, unless it is already more sensitive.

Bump version number to 5.10.1d25.

Options
    • -4
    • +60
    ./01-database-procs.tcl
  2. … 2 more files in changeset.
Sunday 27 Nov 2022
6:55 pm

gustafn

improve spelling

Options
    • -4
    • +4
    ./01-database-procs.tcl
  2. … 9 more files in changeset.
Friday 25 Nov 2022
2:07 pm

gustafn

Bugfix: Get database name from postgres connection string keywords

The connection string can be provided for libpq either as the plain

dbname (old style) or as a list of keywords (new style).

In the latter case, the full keyword string was returned

instead of the dbname.

Options
    • -7
    • +25
    ./01-database-procs.tcl
Monday 29 Aug 2022
11:06 am

gustafn

fix bug in db_multirow_group_last_row_p

The bug showed up in bug-tracker usage of multirows,

where db_multirow_group_last_row_p was still expecting the

dict structure

Options
    • -3
    • +10
    ./01-database-procs.tcl
Tuesday 23 Aug 2022
1:10 pm

gustafn

Changed "db_multirow" to use "db_list_of_lists" instead of "db_list_of_ns_sets"

Thanks to the recent improvements in NaviServer for

"db_list_of_lists", it is more efficient to use this in "db_multirow"

(actually in "db_multirow_helper"). The implementation revealed a bug

in "db_list_of_lists", when both options "-columns_var" and

"-with_headers" were set.

Extended regression test to cover the former bug.

Options
    • -9
    • +19
    ./01-database-procs.tcl
  2. … 1 more file in changeset.
Friday 29 Jul 2022
7:27 pm

gustafn

fix testcase as indicated by hector, extend regression test

Options
    • -2
    • +2
    ./01-database-procs.tcl
  2. … 1 more file in changeset.
Wednesday 20 Jul 2022
1:45 pm

gustafn

Improved db-functions db_list_of_nssets, db_list_of_lists, and db_foreach

These versions were developed in the conjunction with the NaviServer

ns_set reform. Especially ns_list_of_lists is improved, since it

avoids duplication of the data. This is especially important, when

queries return huge amount of data.

Options
    • -64
    • +90
    ./01-database-procs.tcl
Sunday 20 Feb 2022
2:18 pm

gustafn

minor cleanup to make code more consistent

Options
    • -17
    • +7
    ./01-database-procs.tcl
Tuesday 28 Dec 2021
4:26 pm

antoniop

Fix typo

Options
    • -2
    • +2
    ./01-database-procs.tcl
4:24 pm

antoniop

Streamline ns_set idioms

Options
    • -41
    • +17
    ./01-database-procs.tcl
Sunday 05 Dec 2021
4:39 pm

gustafn

get rid of pipe-open, when nsproxy exec is available

Options
    • -27
    • +26
    ./01-database-procs.tcl
Monday 29 Nov 2021
3:37 pm

gustafn

added dropped "cd" command

Options
    • -1
    • +2
    ./01-database-procs.tcl
3:33 pm

gustafn

reduce cases of tcl pipe open in acs-core

AFIKT, the semantics are the same.

For background, see: https://openacs.org/forums/message-view?message_id=5539060

Options
    • -36
    • +33
    ./01-database-procs.tcl
  2. … 1 more file in changeset.
Thursday 30 Sep 2021
2:34 pm

gustafn

Change caching of driver keys

There seems to be a bug in "db_driverkey", when OpenACS connects to

multiple databases [1]. The situation with "db_driverkey" is

complicated by the fact that this function is sometimes called with a

database name in its argument "dbn", and sometimes with a database

handle. This is something to look at in the future.

The new version removes the per-thread caching, which was introduced

to reduce the high number of mutex locks caused in busy machines. The

new version is better by a factor of 2 than older versions, but relies

on NaviServer.

[1] https://openacs.org/forums/message-view?message_id=5537865

Options
    • -33
    • +42
    ./01-database-procs.tcl
Monday 02 Aug 2021
11:26 pm

gustafn

Reduce usage of ns_mktemp in OpenACS

ns_mktemp uses the deprecated old POSIX call mktemp(), which should

not be used anymore for security reasons (race between the name

creation and opening the file). This change removes several usages of

"ns_mktemp" from OpenACS and replaces it with calls to the

safe Tcl call "file tempfile ..." (introduced by Tcl 8.6).

Options
    • -6
    • +3
    ./01-database-procs.tcl
  2. … 7 more files in changeset.
Wednesday 03 Mar 2021
11:32 am

gustafn

whitespace changes: break overlong lines

Options
    • -21
    • +36
    ./01-database-procs.tcl