OpenACS / openacs-4 / packages / xotcl-core / tcl

05-db-procs.tcl

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 7
Last Commit: 17 May
Commits this week: 0
Total Lines of Code (LoC): 2,826
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 4 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Tuesday 29 Mar 2022
6:12 pm

antoniop

Fix typo

Options
    • -2
    • +2
    ./05-db-procs.tcl
6:07 pm

antoniop

Make ::xo::db::require package a shorthand for ::xo::library require, which will remember the dependency

This will also make sure that dependent files are reloaded when a dependency is reloaded

Options
    • -11
    • +6
    ./05-db-procs.tcl
Tuesday 15 Mar 2022
1:01 pm

gustafn

prefer global variable over proc

Options
    • -2
    • +2
    ./05-db-procs.tcl
  2. … 6 more files in changeset.
Tuesday 08 Mar 2022
9:56 am

gustafn

improve comment

Options
    • -4
    • +3
    ./05-db-procs.tcl
Wednesday 23 Feb 2022
7:40 pm

gustafn

Prefer "::acs::dc call ..." over "::xo::db::sql::..."

Use the common new acs interface rather than the xotcl-core variant.

Goal should be on the medium time range to replace all of the

"::xo::db::sql::*" interface.

Options
    • -123
    • +136
    ./05-db-procs.tcl
  2. … 2 more files in changeset.
Sunday 20 Feb 2022
6:24 pm

gustafn

Fixes for Oracle 19c: boolean and timestamp handling, *lobs

- fix boolean permission query

- function "now()" does not exist, use "CURRENT_TIMESTAMP" instead

- revived blob and clob handling in "xo::dc dml" since this is needed

for updating

- modernize Oracle offset/limit handling

- added missing "-dbn" attributes for Oracle xo::dc calls

Options
    • -14
    • +14
    ./05-db-procs.tcl
  2. … 2 more files in changeset.
Thursday 17 Feb 2022
11:37 am

gustafn

Fixes for Oracle 19c: consistenly rely on uppercasing of the schema names in the called functions

Options
    • -16
    • +4
    ./05-db-procs.tcl
Wednesday 16 Feb 2022
8:22 pm

gustafn

Fixes for Oracle 19c:

- added special rules for DML differences in Oracle ("MODIFY" option in ALTER TABLE)

- fixed call of ns_pg_bind in Oracle applications

- fixed call of an SQL function returning a table

Options
    • -6
    • +43
    ./05-db-procs.tcl
Saturday 05 Feb 2022
5:59 pm

gustafn

Improved startup time (of server, of threads) by using nsv_dict when available

During definition of attributes, the xo-db inteface checks whether

the db attributes managed by xotcl are in sync with the actual database.

This was done so far by a couple of small database query. When nsv_dict

is available, it can be used for quickly checking those values.

Options
    • -12
    • +52
    ./05-db-procs.tcl
Saturday 22 Jan 2022
12:33 pm

gustafn

make function private

Options
    • -2
    • +2
    ./05-db-procs.tcl
Thursday 13 Jan 2022
1:36 pm

gustafn

improved prepared-statement handling

- avoid separate SQL statement for testing, whether prepared statement

exists already in the SQL session.

- use true SQL session-id (obtained via "ns_pg pid") when available

- improve source code documentation

Options
    • -25
    • +50
    ./05-db-procs.tcl
Sunday 26 Dec 2021
7:24 am

gustafn

deactive callback definition to avoid calls of deprecated xo::parameter functions

Options
    • -1
    • +2
    ./05-db-procs.tcl
  2. … 1 more file in changeset.
Sunday 05 Dec 2021
5:18 pm

gustafn

modernize code

Options
    • -9
    • +6
    ./05-db-procs.tcl
Tuesday 07 Sep 2021
7:51 pm

gustafn

simplify code (allow warning, although i am not fully convinced, this is a good idea)

Options
    • -2
    • +1
    ./05-db-procs.tcl
  2. … 1 more file in changeset.
7:35 pm

gustafn

move documentation to the generic level, don't make methods public, which are intentionally non-public

Options
    • -5
    • +7
    ./05-db-procs.tcl
5:32 pm

antoniop

Improve doc

Options
    • -2
    • +6
    ./05-db-procs.tcl
5:27 pm

antoniop

"timestamp with time zone" is the name of a DBMS datatype, needs to be spelled this way

Options
    • -2
    • +2
    ./05-db-procs.tcl
Thursday 02 Sep 2021
6:40 pm

gustafn

improve spelling

Options
    • -2
    • +2
    ./05-db-procs.tcl
  2. … 42 more files in changeset.
Tuesday 23 Mar 2021
3:46 pm

gustafn

improve spelling

Options
    • -3
    • +2
    ./05-db-procs.tcl
  2. … 1 more file in changeset.
Friday 26 Feb 2021
8:16 pm

gustafn

whitespace changes

Options
    • -4
    • +4
    ./05-db-procs.tcl
Tuesday 23 Feb 2021
11:38 am

gustafn

small performance improvement

Options
    • -5
    • +5
    ./05-db-procs.tcl
Friday 19 Feb 2021
11:12 am

gustafn

replace call to deprecated function

Options
    • -2
    • +2
    ./05-db-procs.tcl
Thursday 11 Feb 2021
5:41 pm

antoniop

Fix typo

Options
    • -2
    • +2
    ./05-db-procs.tcl
Monday 01 Feb 2021
11:41 am

gustafn

make end of resub options explicit

Options
    • -3
    • +3
    ./05-db-procs.tcl
  2. … 12 more files in changeset.
Sunday 24 Jan 2021
8:54 pm

gustafn

Added support for row-level lock modes of PostgreSQL; used in "save" method of cr-items

This change is necesary to avoid potential dead-locks in concurrent "save" operations

Options
    • -1
    • +17
    ./05-db-procs.tcl
  2. … 1 more file in changeset.
Tuesday 05 Jan 2021
10:38 am

gustafn

improve spelling

Options
    • -4
    • +4
    ./05-db-procs.tcl
  2. … 1 more file in changeset.
Sunday 06 Dec 2020
9:37 am

gustafn

improve spelling

Options
    • -2
    • +2
    ./05-db-procs.tcl
  2. … 5 more files in changeset.
Thursday 03 Sep 2020
10:42 am

gustafn

reduce usage of idiom "select 1 from dual where exists" when not necessary

Options
    • -11
    • +7
    ./05-db-procs.tcl
Wednesday 02 Sep 2020
1:04 pm

antoniop

Replace limit with portable idiom

Options
    • -4
    • +5
    ./05-db-procs.tcl
Tuesday 01 Sep 2020
7:59 pm

antoniop

Fix oracle query as for most recent version limit is not supported

Options
    • -4
    • +8
    ./05-db-procs.tcl