OpenACS / openacs-4 / packages / acs-subsite / www / site-map

index-postgresql.xql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 5
Last Commit: 14 Nov
Commits this week: 0
Total Lines of Code (LoC): 40
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 10 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Monday 18 Mar 2019
3:09 pm

antoniop

Rework publicly exposed query:

- inner join immediately with site_nodes_selection so query can terminate quickly when user site map is empty

- clarify query meaning

Options
    • -28
    • +27
    ./index-postgresql.xql
Monday 22 Oct 2018
9:41 am

gustafn

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

Options
    • -30
    • +15
    ./index-postgresql.xql
  2. … 1 more file in changeset.
Tuesday 08 Aug 2017
1:47 am

gustafn

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

Options
    • -55
    • +0
    ./index-postgresql.xql
  2. … 7834 more files in changeset.
Wednesday 28 Oct 2015
10:38 am

gustafn

.xql overhaul:

- removed misleading sql-statements from db_* calls, which were

ignored due .xql files

- removed bug where same query name was used in a single proc

with different intended sql queries, but the same was picked

up from the .xql file due to the name

- removed multiple entries of same query name from .xql files

(e.g. the entry "package_create_attribute_list.select_type_info" was

7 (!!!) times in a single .xql file)

- removed redundant queries for unsupported versions of the dbms

- added missing xql entries for db-backends, where other db-specific

queries exists (e.g. added an entry to -oracle.xql, where an entry

existed in -postgres.xql)

Options
    • -55
    • +0
    ./index-postgresql.xql
  2. … 70 more files in changeset.
Tuesday 02 Apr 2013
1:05 pm

victorg

Rewriting acs_permission__permission_p function to use recursive queries ( available in PG since 8.4 ) and modifiying

queries around core packages to avoid checking persmissions using a subquery on the acs_object_party_privilege_map view.

Options
    • -0
    • +52
    ./index-postgresql.xql
  2. … 14 more files in changeset.
Thursday 13 Jan 2005
2:54 pm

jeffd

commit to HEAD of merge of changes on oacs-5-1 branch between tags jcd-merge-5-1-20040724 and jcd-merge-5-1-20050111

Options
    • -0
    • +76
    ./index-postgresql.xql
  2. … 2275 more files in changeset.
Tuesday 23 Nov 2004
7:43 pm

vivianh

file index-postgresql.xql was initially added on branch oacs-5-1.

Options
    • -0
    • +0
    ./index-postgresql.xql
7:43 pm

vivianh

Site map viw interface

Options
    • -0
    • +76
    ./index-postgresql.xql
  2. … 3 more files in changeset.