00-database-procs.tcl

  • last updated 20 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
updated translations from translate.openacs.org

  1. … 999 more files in changeset.
better comments for the -dbn stuff

See: http://openacs.org/forums/message-view?message_id=186200

Changed comment for when using more than 1 database.

merge changes on oacs-5-1 branch to head, changes between jcd-merge-20040420 and jcd-merge-5-1-20040517 were merged, head pre changes is jcd-merge-pre-20040517 and post is jcd-merge-post-20040517

  1. … 834 more files in changeset.
Pass dbn to db_with_handle fixes bug 1753

merge all the changes on the oacs-5-1 and dotlrn-2-0 branches up to tag jcd-merge-20040420

  1. … 647 more files in changeset.
Added doc for -unclobber switch to db_mutlirow

fixing some variable name misakes in my previous bind var/quoting fix

Changing proc db_bind_var_substitution (used only for db_exec_plsql) so that it doesn't do bind var substitution for bind variables that are in quotes. fixing bug 1113

  1. … 1 more file in changeset.
use db_get_dbhost to get host for windows remote connections to work bug 1258 fix by John Sequeira

missing -dbn switches in db_transaction caused wrong db handle to be aborted on failure, patch 406 Kolja Lehmann

Changing most Returns to @return in proc docs

all TCL's clock clicks always with the -milliseconds option. The TCL manual

explicitly states that without this switch the return result is platform

dependant. The OpenACS code works at the millisecond granulartiy and silently

assumes that 1 millisecond equals 1000 clicks which is not necessarily true.

I used this shell script to automatize the replacing:

#!/bin/bash

for file in `grep -lsr "\[clock clicks\]" /web/openacs-head/packages/ `; do

echo "repairing $file"

sed "s/\[clock clicks\]/\[clock clicks -milliseconds\]/g" $file > fout

mv fout $file

done

And then grepped for

grep -r "expr.*clock clicks" /web/openacs-head/packages/

to manually remove the divisions by 1000.

  1. … 10 more files in changeset.
merge of changes on oacs-5-0 branch to oacs-5-0-0b4 tag

  1. … 598 more files in changeset.
drop the __exec_ functions for anonymous plpgsql blocks

alias table name so db_tables will work on postgres

typo in ns_log command

switch to using \\copy rather than copy since the backend typically

is not able to read the dat file because of permissions (or if it is

on a remote machine the file typically will not even exist).

bug #1033

  1. … 8 more files in changeset.
Marking all procs with -public that are mentioned in /doc/db-api-detailed.html

Adding a note that db_dml deals with blobs.

Make db_boolean public

Marking some procs public and private

Oracle9i porting changes

- Changed procedure names from delete to del

- Changed view declaration to use actual column names

- Changed "rel_constraints_violated_one" and "rel_constraints_violated_two"

(http://openacs.org/forums/message-view?message_id=81045)

  1. … 275 more files in changeset.
Added db_boolean proc, which converts a Tcl boolean to a DB boolean

Merged 4.6.4d1 (unreleased) to HEAD. This marks the end of the life of the oacs-4-6 branch.

  1. … 816 more files in changeset.
Merge from oacs-4-6-4d1: Replaced proc_doc with ad_proc (1.19.2.5)

Merged over 1.19.2.7 change: -unclobber, db_multirow_group_last_row_p

changed write to puts, changed @tmpnam to .tcl

Decided that assuming SQL data files are CSV-formatted files is a bad idea

after running into a package that embeds comments in its data! Changed

from .csv to .dat and all that implies. Still more testing to do...

  1. … 33 more files in changeset.
Added code to allow loading of data for packages like ref-timezones with

SQL*Loader or PostgreSQL's COPY command.

  1. … 8 more files in changeset.