site-nodes-procs-postgresql.xql

  • last updated 16 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Fix installer by uniforming columns returned by the two query variants

change queries on site-node tree from tree_sortkey to recursive queries

    • -16
    • +14
    ./site-nodes-procs-postgresql.xql
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.
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

    • -36
    • +31
    ./site-nodes-procs-postgresql.xql
  1. … 6 more files in changeset.
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.
fix postgres install

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

    • -64
    • +47
    ./site-nodes-procs-postgresql.xql
  1. … 4 more files in changeset.

Tilmann Singer noted that my previous change to the site_nodes_select

query wasn't quite right.

  1. … 1 more file in changeset.
Fixed bug in site_node_create.node_new query

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 a few more queries in subsite, added a correction to the API for subsite nodes.

  1. … 14 more files in changeset.
fixed some bugs related to loading and parsing of generic .xql files

  1. … 9 more files in changeset.

Ignore the remove, it was due to cockpit error.

The rest is minor cleanup stuff.

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

  1. … 41 more files in changeset.

applied patches from Steve Woodcock that port a few more queries, fix a few data model PL/SQL quirks, and generally allow us to get further into a working OpenACS!

  1. … 6 more files in changeset.
finalized QD last fixes, and began porting more queries

    • -0
    • +16
    ./site-nodes-procs-postgresql.xql