00-database-procs.tcl

  • last updated 12 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
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.
Added Oracle suport to db_blob_get. Changed site_node_closest_ancestor_package so that it takes a list of keys.

  1. … 1 more file in changeset.
1. Added -unclobber switch to db_multirow.

2. Added peek-ahead to db_multirow, which enables you to do something similar to the templating system's <group> tag when building up a multirow. See documentation to

db_multirow_group_last_row_p for details.

3. Untabified the whole buffer, which, unfortunately, makes the concrete changes I've made totally obscure. Sorry.

1. Took out my earlier kludge to get around the AOLserver 4 ns_eval problem.

2. bracketed "if" exprs to avoid unnecessary recompilations of exprs

  1. … 15 more files in changeset.
Replaced proc_doc with ad_proc

merge of 4.6.3b1 to HEAD

  1. … 107 more files in changeset.
Trivial tweak to syntax of db_available_pools proc.

  1. … 3 more files in changeset.
Completed db_* api multi-database support. Can now use db api for

both Oracle and PostgreSQL at the same time.

    • -386
    • +2140
    ./00-database-procs.tcl
  1. … 3 more files in changeset.
dont default the magic args var in db_list_of_ns_sets

Added base multi-db support to the db_* API.

  1. … 6 more files in changeset.
Deprecating apm_version_file_list and making it use apm_get_package_files. Deprecating db_package_supports_rdbms_p (use apm_package_supports_rdbms_p instead). Removing debug printouts

  1. … 4 more files in changeset.
Improved handling of errors in db_transaction (at least I hope I did)

  1. … 1 more file in changeset.
Upgrade to 4.6.2

  1. … 30 more files in changeset.
adding the -upvar_level switch that determines how many levels local multirow variables should be set

merge changes from 4.6

Corrects db_transaction doc. Closes bug 104/patch 22 Vinod Kurup

making sure message catalog files are loaded during package installation and package upgrade

  1. … 4 more files in changeset.
merge from oacs-4-6

  1. … 130 more files in changeset.
cross reference the multirow procs

  1. … 1 more file in changeset.
allows queries in on_error block to work with db_transaction under postgresql

cleanup javadoc tags (eg @cvs_id @cvs @cvs-id: instead if @cvs-id)

  1. … 692 more files in changeset.
* Added documentation for db_multirow -local switch

db_multirow: Ignore -append switch if the multirow hasn't been created already

Forgot a couple things (still on documentation).

Cosmetic enhancements to the improved ad_proc documentation.

* Corrected documentation for DB API, that was wrong/incomplete/missing in most

cases.

* Added a "Usage:" paragraph to almost all api calls.

Merged with the 4.5 branch (oacs-4-5 tag "don-merge-1")

  1. … 58 more files in changeset.
Added -extend switch to db_multirow and removed Arjun's regsub hack in same. db_multirow also sets the varname:columns list, and it checks that columns stay the same when you append. I've also added documentation, as per SDM #1486

1. Changed a lot of package info files to fix problems ...

2. Added Vinod's bboard patch

3. Rationalized party e-mail checking by putting a "before insert or update"

trigger on the table that lower-cases email (this was already done by the

party.new() func but at least one update missed this). Got rid of all

"lower(email) = " and "upper(email) = " checks and just made all use the

db email column directly and lower-cased Tcl vars. In this way the index

on the email column is always and consistently used without needing to

define functional indexes on the column (an EE feature for Oracle).

4. Rationalized naming of a couple of workflows and fixed a glossary PG bug

where apparently its workflow got overwritten by one from the CMS at some

point in time.

5. Made the .cmp/.dat/.frm filters in the template code usable though not

very beautiful nor exactly correct. But with practice you can use them

to debug pages in the packages/* hierarchy. I also turned these off by

default as there's no need to run these filters on a production site!

6. Performed minor surgery on templating, including adding a new

"ad_return_exception_template" that allows you to return a templated

error page and aborts the script.

7. ??? probably but I think this covers most stuff.

  1. … 74 more files in changeset.
adding db api call to return the result set as a list of ns_sets, one for each row in the result set