00-database-procs.tcl

  • last updated 20 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Fixed bug #2101 for PG 8.0 on windows

Fixed another bug whose number I forgot, that prevented users from deactivating

their account.

  1. … 1 more file in changeset.
Interesting side effect as acs-lang is loaded after acs-tcl. lang::util::localize was unknown, so I had to add a check to the db_list_of_lists procedure to test if the string is actually a message key before localizing it. Now install works.

Added the ability to localize the return of db_list_of_lists. This is something I should have done already way back before I changed db_list_of_list calls to db_foreach everywhere. Well, stupidity rules....

Updated to work with Oracle 10. Was using Oracle8 hardcoded -- the new

code is is more flexible with what the driver calls itself.

  1. … 1 more file in changeset.
stub ds procs rather than call ad_call_proc_if_defined_and_function_name_too_short

  1. … 2 more files in changeset.
change ad_verify_and_get_user_id to ad_conn user_id, change ad_maybe_redirect_for_registration to auth::require_login, make some db_ and dt_ function -public

  1. … 689 more files in changeset.
removed the remaining procs which were -deprecated -warn in 5.0 and fixed most occurances of those procs in the code

  1. … 43 more files in changeset.
make some proc things into ad_proc, remove a couple useless debug messages, log long query times as a WARNING message in the log

  1. … 1 more file in changeset.
commit to HEAD of merge of changes on oacs-5-1 branch between tags jcd-merge-5-1-20040724 and jcd-merge-5-1-20050111

  1. … 2275 more files in changeset.
removed some obsolete comments and added a link

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.