site-nodes-procs-oracle.xql

  • last updated 13 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
merged changes from the oacs-5-9 branch and resolved conflicts

  1. … 7834 more files in changeset.
Removed malte's broken site node caching code. If you want to fix it, the

version before this has the broken code (look at get_from_url).

  1. … 3 more files in changeset.
Fixed a broken oracle query

Implemented site node lazy caching. This will prevent the site from loading the whole site node at the startup but on demand

  1. … 3 more files in changeset.
populate site-nodes-cache by resolving urls in tcl instead of using the slow plsql

  1. … 6 more files in changeset.
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.
Fixed bug with cache not being updated on Oracle when no package is mounted at a site node

  1. … 1 more file in changeset.
added missing outer join so that site_node::init_cache will cache nodes that don't have packages mounted

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 of 4.6.3b1 to HEAD

  1. … 107 more files in changeset.
Added instance_name to the site_node structure, and changed the init_cache and update_cache procs to use column_array, which makes them much simpler.

  1. … 2 more files in changeset.
more improvements to the site-node api

  1. … 17 more files in changeset.
update cache on delete of node; new cache that maps between node_ids and thier respective urls

  1. … 2 more files in changeset.
more of the new api

  1. … 3 more files in changeset.
new site node api (not done); new caching methodology; if something breaks let me know

  1. … 4 more files in changeset.
Remove the semicolon

Tilmann Singer noted that my previous change to the site_nodes_select

query wasn't quite right.

  1. … 1 more file in changeset.

1. Replaced more "tree_sortkey like" with "tree_sortkey between" expressions

2. Fixed a bad port of an Oracle query in site-nodes-procs.tcl and removed

a needless outer join from both versions in the process.

  1. … 11 more files in changeset.
fixed an oracle XQL bug

fixed a few more queries in subsite, added a correction to the API for subsite nodes.

  1. … 14 more files in changeset.
query extractor output for acs-tcl

    • -0
    • +51
    ./site-nodes-procs-oracle.xql
  1. … 41 more files in changeset.