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

acs-db-12-procs.tcl

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 1
Last Commit: 12 Nov
Commits this week: 0
Total Lines of Code (LoC): 739
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 19 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Tuesday 01 Oct 2024
2:50 pm

gustafn

whitespace change

Options
    • -4
    • +4
    ./acs-db-12-procs.tcl
Tuesday 03 Sep 2024
5:37 pm

gustafn

merge from oacs-5-10

Options
    • -0
    • +739
    ./acs-db-12-procs.tcl
  2. … 8099 more files in changeset.
Tuesday 20 Aug 2024
3:58 pm

gustafn

Fix potential problems when calling polymorphic SQL functions from Tcl

Some functions are defined in the database with the same number of

arguments but different types, e.g., first argument "package_key"

(type text) or "package_id" (type integer). This is fine from the SQL

standpoint, but when calling from Tcl via bind-vars

(e.g. ":package_id"), everything is passed as a string, and

potentially, the wrong function is called.

Now, all the automatically generated subs are generated with casts,

when the integer based variant must be called.

Some examples:

Before:

set s [ns_pg_bind 0or1row $__DB {select apm__set_value(:package_id,:parameter_name,:attr_value)}]

set s [ns_pg_bind 0or1row $__DB {select apm__get_value(:package_id,:parameter_name)}]

Now:

set s [ns_pg_bind 0or1row $__DB {select apm__set_value(CAST(:package_id AS integer),:parameter_name,:attr_value)}]

set s [ns_pg_bind 0or1row $__DB {select apm__get_value(CAST(:package_id AS integer),:parameter_name)}]

- bumped version number to 5.10.1b11

Options
    • -13
    • +110
    ./acs-db-12-procs.tcl
  2. … 2 more files in changeset.
Tuesday 13 Aug 2024
11:06 am

gustafn

improved souce code documentation

Options
    • -1
    • +7
    ./acs-db-12-procs.tcl
Tuesday 07 Feb 2023
6:27 pm

gustafn

silence warning about query names in the log file

Options
    • -2
    • +2
    ./acs-db-12-procs.tcl
Tuesday 22 Feb 2022
12:24 pm

gustafn

Fine-tuning the new db function interface

#

# Check, wether we have to regenerate the database function interface.

#

# - During initial setup, there are no db-functions, so nothing has to

# be done.

#

# - During regular startup of the server, the generation of the stub

# interface happens in the *init procs (hopefully this is always

# sufficient, but seems so)

#

# - During reloads of acs-db-*-procs, the base classes are interface

# objects are recreated and cleaned up from all prior definitons,

# which means that in this situations, we have to regeneate the

# interface.

#

# - One might call manually the regeneration, when database functions

# have been altered and no restart is desired.

#

Options
    • -10
    • +41
    ./acs-db-12-procs.tcl
Monday 21 Feb 2022
9:27 pm

gustafn

Update of SQL function calling interface to make it usable during initial bootstrap

- add sanity checks and produce error messages,

when function args are incorrect.

- do not throw errors in case it is called before the

table acs_function_args was created (during boot)

- added preliminary "list" call to acs::dc

- added first *-init.tcl to be called after loading

the *-proc.tcl files.

- removed all references to the ::xo::* namespace

Options
    • -7
    • +50
    ./acs-db-12-procs.tcl
  2. … 3 more files in changeset.
9:49 am

gustafn

improve spelling and formulations

Options
    • -9
    • +10
    ./acs-db-12-procs.tcl
  2. … 2 more files in changeset.
Sunday 20 Feb 2022
8:45 pm

gustafn

Added new interface for calling database functions

This is tested for PostgreSQL and Oracle and the drivers nsdb and nsdbi.

For details, see https://openacs.org/xowiki/calling-database-functions

Options
    • -0
    • +561
    ./acs-db-12-procs.tcl
  2. … 2 more files in changeset.
8:45 pm

gustafn

file acs-db-12-procs.tcl was initially added on branch oacs-5-10.

Options
    • -0
    • +0
    ./acs-db-12-procs.tcl