00-database-procs.tcl

  • last updated 4 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
db_string was totally ignoring the -dbn swith!!

Normalizing string comparison operations into tcl 8.4 operations, enabling byte-code compilation for expressions and many conditionals

  1. … 367 more files in changeset.
First round of oacs-5-3 merge to HEAD commits

  1. … 96 more files in changeset.
Merged oacs-5-2 -> oacs-5-3 branches.

  1. … 66 more files in changeset.
Made the comment about long db queries a little bit more readable

Merged acs-core oacs-5-2 (currently 5.2.3) -> HEAD.

TODO:

1. Bump acs-core package version numbers to 5.3.0d1

2. Would be nice to do a test install, wouldn't it?

  1. … 721 more files in changeset.
Added a simple caching mechanism to the database API as discussed (and approved)

in TIP #57 many, many moons ago. Commands which are cache-enabled are db_string,

db_0or1row, db_1row, db_list, db_list_of_lists, and db_multirow.

  1. … 2 more files in changeset.
Adding new proc db_bounce_pools and calling it after each package is installed or upgraded. Installations/upgrades are done in a separate process, making changes that could affect our sessions. This is particularly a problem with the content_item package on Oracle. To be on the safe side we refresh the db connections after each install/upgrade.

  1. … 1 more file in changeset.
Reverted back to keep database procs low level

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