00-database-procs.tcl

  • last updated 21 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Merged from 5.4.2

  1. … 283 more files in changeset.
Relaxed the db_multirow restriction on appending when cached to allow it if

the multirow is empty.

new version of sequence name caching; use now system catalogs as last ressort

Commented out Gustaf's broken version of db_nextval, and replaced it with

the slower, but *correct*, earlier version. The "improved" version can be

commented back in locally for those who don't care about correctness. Or

it can be corrected and put back in if someone cares to fix it.

Commented out Gustaf's broken version of db_nextval, and replaced it with

the slower, but *correct*, earlier version. The "improved" version can be

commented back in locally for those who don't care about correctness. Or

it can be corrected and put back in if someone cares to fix it.

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.