site-nodes-procs-postgresql.xql

  • last updated 2 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.
.xql-file reform of acs-tcl (part 3)

- remove obsolete queries

ad_acs_admin_id.acs_admin_id_get

ad_db_select_widget.currency_info

ad_maybe_redirect_for_registration.sql_test_1

ad_maybe_redirect_for_registration.sql_test_2

ad_permission_p.n_privs

ad_user_class_query.sql_post_select_for_user_class

apm_file_add.apm_file_add

apm_file_remove.apm_file_remove

apm_package_install.version_exists_p

site_node::get_url_from_object_id.select_url_from_object_id

user_search

- remove obsolete files

tcl/00-database-procs-postgresql-postgresql.xql

tcl/00-database-procs-postgresql.tcl

tcl/defs-procs-oracle.xql

tcl/defs-procs-postgresql.xql

tcl/deprecated-utilities-procs.xql

tcl/request-processor-init.xql

tcl/request-processor-procs-oracle.xql

tcl/request-processor-procs-postgresql.xql

tcl/widgets-procs.xql

  1. … 22 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.
Got rid of malte's broken site node lazy caching code. Someone should make

lazy caching work someday...

  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.
Added package_type (i.e. package key) to the site nodes internal structure.

  1. … 1 more file in changeset.
merge of 4.6.3b1 to HEAD

  1. … 107 more files in changeset.
fixing bug 370 - deletion of empty departments in dotlrn. The apm_package_instance_delete proc was misspelled. Making the delete_site_nodes_and_package proc delete the child nodes before parents.

  1. … 3 more files in changeset.
Adds a -exact flag to site_node::get_from_url and better doc bug

204/patch 64 Randy o'Meara.

Adds site_nodes.name to node array (so you don't have to munge it from

the url).

  1. … 2 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