00-database-procs.tcl

  • last updated 16 mins ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
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.

Make db_boolean public

Marking some procs public and private

Oracle9i porting changes

- Changed procedure names from delete to del

- Changed view declaration to use actual column names

- Changed "rel_constraints_violated_one" and "rel_constraints_violated_two"

(http://openacs.org/forums/message-view?message_id=81045)

  1. … 275 more files in changeset.
Added db_boolean proc, which converts a Tcl boolean to a DB boolean

Merged 4.6.4d1 (unreleased) to HEAD. This marks the end of the life of the oacs-4-6 branch.

  1. … 816 more files in changeset.
Merge from oacs-4-6-4d1: Replaced proc_doc with ad_proc (1.19.2.5)

Merged over 1.19.2.7 change: -unclobber, db_multirow_group_last_row_p

changed write to puts, changed @tmpnam to .tcl

Decided that assuming SQL data files are CSV-formatted files is a bad idea

after running into a package that embeds comments in its data! Changed

from .csv to .dat and all that implies. Still more testing to do...

  1. … 33 more files in changeset.
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