OpenACS / openacs-4 / packages / acs-tcl / tcl

site-nodes-procs-oracle.xql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 12
Last Commit: 03 Nov
Commits this week: 0
Total Lines of Code (LoC): 50
Net change in LoC this week: 0

Commit Activity

Commits By Day In Week
52 week commits volume
Commits By Day In Week
Commits by day
Commits By Day In Week
Commits by hour
Commits By Hour In Day
Commit calendar
 

Most active committers (90 days)

loading
loading
  • last updated 18 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Tuesday 03 Sep
5:37 pm

gustafn

merge from oacs-5-10

Options
    • -6
    • +0
    ./site-nodes-procs-oracle.xql
  2. … 8099 more files in changeset.
Monday 21 Feb 2022
9:35 pm

gustafn

Reform of site-nodes-procs

- made XOTcl2 based implementation of site-nodes usable during

initial bootstrap

- made new site-node cache implementation working for Oracle

- now, the same code works during bootstrap, for PostgreSQL and Oracle

and independent of xotcl-core being installed or not.

- removed old and broken nsv-based site-node cache

- reduced need of .xql files (removed query for delete.delete_site_node)

- moved deprecated calls to deprecated-procs.tcl

This change make the code much clearer and eases maintenance and debugging.

Options
    • -6
    • +0
    ./site-nodes-procs-oracle.xql
  2. … 3 more files in changeset.
Tuesday 08 Aug 2017
1:47 am

gustafn

merged changes from the oacs-5-9 branch and resolved conflicts

Options
    • -9
    • +0
    ./site-nodes-procs-oracle.xql
  2. … 7834 more files in changeset.
Saturday 02 Jan 2016
12:22 pm

gustafn

.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

Options
    • -9
    • +0
    ./site-nodes-procs-oracle.xql
  2. … 22 more files in changeset.
Saturday 12 Apr 2008
12:37 am

donb

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).

Options
    • -27
    • +2
    ./site-nodes-procs-oracle.xql
  2. … 3 more files in changeset.
Friday 11 Apr 2008
11:18 pm

donb

Got rid of malte's broken site node lazy caching code. Someone should make

lazy caching work someday...

Options
    • -27
    • +2
    ./site-nodes-procs-oracle.xql
  2. … 3 more files in changeset.
Sunday 20 Jan 2008
4:27 pm

donb

Fixed a broken oracle query

Options
    • -1
    • +1
    ./site-nodes-procs-oracle.xql
Tuesday 13 Mar 2007
10:09 am

maltes

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

Options
    • -2
    • +27
    ./site-nodes-procs-oracle.xql
  2. … 3 more files in changeset.
Thursday 27 Nov 2003
4:24 pm

timoh

populate site-nodes-cache by resolving urls in tcl instead of using the slow plsql

Options
    • -40
    • +35
    ./site-nodes-procs-oracle.xql
  2. … 6 more files in changeset.
Tuesday 30 Sep 2003
2:10 pm

mohanp

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)

Options
    • -1
    • +1
    ./site-nodes-procs-oracle.xql
  2. … 275 more files in changeset.
Monday 29 Sep 2003
1:52 pm

lars

Fixed bug with cache not being updated on Oracle when no package is mounted at a site node

Options
    • -2
    • +2
    ./site-nodes-procs-oracle.xql
  2. … 1 more file in changeset.
Friday 29 Aug 2003
3:29 pm

peterm

added missing outer join so that site_node::init_cache will cache nodes that don't have packages mounted

Options
    • -1
    • +1
    ./site-nodes-procs-oracle.xql
Thursday 28 Aug 2003
11:41 am

lars

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

Options
    • -4
    • +10
    ./site-nodes-procs-oracle.xql
  2. … 816 more files in changeset.
Wednesday 02 Jul 2003
9:39 pm

lars

Added package_type (i.e. package key) to the site nodes internal structure.

Options
    • -4
    • +10
    ./site-nodes-procs-oracle.xql
  2. … 1 more file in changeset.
Saturday 17 May 2003
11:55 am

jeffd

merge of 4.6.3b1 to HEAD

Options
    • -0
    • +3
    ./site-nodes-procs-oracle.xql
  2. … 107 more files in changeset.
Monday 24 Mar 2003
11:28 am

peterm

fixed previous commit of a pg function in an oracle xql file

Options
    • -1
    • +1
    ./site-nodes-procs-oracle.xql
Thursday 20 Mar 2003
1:48 pm

peterm

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.

Options
    • -0
    • +1
    ./site-nodes-procs-oracle.xql
  2. … 3 more files in changeset.
Sunday 02 Feb 2003
10:19 pm

jeffd

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).

Options
    • -0
    • +2
    ./site-nodes-procs-oracle.xql
  2. … 2 more files in changeset.
Saturday 14 Sep 2002
10:20 pm

lars

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.

Options
    • -2
    • +4
    ./site-nodes-procs-oracle.xql
  2. … 2 more files in changeset.
Saturday 22 Jun 2002
10:09 pm

yon

more improvements to the site-node api

Options
    • -2
    • +2
    ./site-nodes-procs-oracle.xql
  2. … 17 more files in changeset.
7:28 pm

yon

update cache on delete of node; new cache that maps between node_ids and thier respective urls

Options
    • -6
    • +0
    ./site-nodes-procs-oracle.xql
  2. … 2 more files in changeset.
Friday 21 Jun 2002
8:54 pm

yon

more of the new api

Options
    • -6
    • +14
    ./site-nodes-procs-oracle.xql
  2. … 3 more files in changeset.
12:58 am

yon

new site node api (not done); new caching methodology; if something breaks let me know

Options
    • -61
    • +51
    ./site-nodes-procs-oracle.xql
  2. … 4 more files in changeset.
Sunday 03 Feb 2002
2:31 pm

stevew

Remove the semicolon

Options
    • -1
    • +1
    ./site-nodes-procs-oracle.xql
Friday 01 Feb 2002
4:16 pm

donb

Tilmann Singer noted that my previous change to the site_nodes_select

query wasn't quite right.

Options
    • -3
    • +3
    ./site-nodes-procs-oracle.xql
  2. … 1 more file in changeset.
Saturday 01 Dec 2001
6:55 pm

donb

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.

Options
    • -1
    • +1
    ./site-nodes-procs-oracle.xql
  2. … 11 more files in changeset.
Friday 30 Nov 2001
5:06 am

ben

fixed an oracle XQL bug

Options
    • -2
    • +2
    ./site-nodes-procs-oracle.xql
Sunday 19 Aug 2001
6:32 pm

ben

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

Options
    • -0
    • +16
    ./site-nodes-procs-oracle.xql
  2. … 14 more files in changeset.
Tuesday 24 Apr 2001
8:02 am

danw

query extractor output for acs-tcl

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