00-database-procs.tcl

  • last updated 20 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Remove historical debugging log statement! (finally)

Get rid of the postgres warning "adding missing FROM-clause entry " on sequences

Make "db_nextval acs_object_id_seq" more than twice as fast (from 948 microseconds to 378 microseconds)

  1. … 9 more files in changeset.
rollback last commit on unrelated files

  1. … 2 more files in changeset.
fix a bug in ad_html_to_text: This function breaks, when it encounters a (valid) entity like &0038;

The problem was, that the old code interpreted the numeric value of the entity as an octal value

because it starts with leading zeros.

  1. … 3 more files in changeset.
Merged the 5.3 branch with HEAD. Look for tags with the pattern

drb-*-20070513

  1. … 324 more files in changeset.
Fixed a caching bug ...

fix db_string to work with different databases

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.