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: 17 Jul 19
Commits this week: 0
Total Lines of Code (LoC): 0
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 18 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Monday 02 Jan
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
Monday 01 Mar 2021
10:26 am

gustafn

move function db_current_rdbms to acs-bootstrap installer to improve code locality

Options
    • -6
    • +1
    ./01-database-procs.tcl
  2. … 1 more file in changeset.
10:19 am

gustafn

Cleanup of low-level DB-interace: use dict instead of list with fixed positions

VS: ----------------------------------------------------------------------

Options
    • -2
    • +2
    ./01-database-procs.tcl
  2. … 3 more files in changeset.
Sunday 28 Feb 2021
10:56 pm

gustafn

reduce usage of ad_arg_parser by using c-level implementation; fixes as well broken cases of bind-var handling

Options
    • -46
    • +23
    ./01-database-procs.tcl
Saturday 27 Feb 2021
11:25 pm

gustafn

Added support for trailing non-positional arguments

The change makes the old hack with the own trailing-argument-parser

"ad_arg_parser" obsolete by using directly the c-level argument parser

which is anyhow capable of handling trailing arguments. A few changes

were necessary for api doc to handle there trailing arguments as well.

The proc "db_string" is already converted to use native arguments.

Options
    • -6
    • +5
    ./01-database-procs.tcl
  2. … 7 more files in changeset.
6:48 pm

gustafn

Fix for issue #3442 to support range types in .xql files

PostgreSQL supports range types since 9.5. When using range types,

square braces have to be used in SQL statements. Since OpenACS uses

always Tcl substitution in .xql files, and OpenACS does NOT allow

backslash substitution in these files, square brackets could not be

escaped and therefore not be used in .xql files so far. This change

allows now a developer to deactivate the substitution by passing

e.g. "-subst none" to the db_* command using the .xql file. Valid

values for "-subst" are "all", "none", "vars", and "commands", default

is "all" which is exactly the behavior of before. Therefore, this

change is fully backward compatible.

Options
    • -55
    • +65
    ./01-database-procs.tcl
  2. … 3 more files in changeset.
Monday 22 Feb 2021
4:51 pm

antoniop

Make api public, complies with acs-api-browser.graph__bad_calls automated test

Options
    • -2
    • +2
    ./01-database-procs.tcl
  2. … 4 more files in changeset.
Wednesday 17 Feb 2021
9:20 am

gustafn

prefer ns_dbquotevalue over db_quote, mark latter as deprecated

Options
    • -3
    • +8
    ./01-database-procs.tcl
  2. … 3 more files in changeset.
Monday 01 Feb 2021
11:47 am

gustafn

make end of options explicit

Options
    • -2
    • +2
    ./01-database-procs.tcl
  2. … 42 more files in changeset.
Tuesday 08 Dec 2020
3:33 pm

gustafn

whitespace changes: break overlong lines

Options
    • -4
    • +11
    ./01-database-procs.tcl
3:31 pm

gustafn

don't throw error message on transaction rollbacks (these are no errors, but use the same exception handling)

Options
    • -3
    • +9
    ./01-database-procs.tcl
Wednesday 28 Oct 2020
4:39 pm

hectorr

Prefer 'namespace which' over 'info commands', as it is faster (on local tests, around 2x) and returns a single value. Many thanks to Nathan Coulter.

Options
    • -2
    • +2
    ./01-database-procs.tcl
  2. … 58 more files in changeset.
Tuesday 22 Sep 2020
10:44 am

gustafn

fix broken support for explicit bindvars to db_foreach

Options
    • -2
    • +3
    ./01-database-procs.tcl