OpenACS / openacs-4 / packages / xowiki / tcl

xowiki-utility-procs.tcl

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 5
Last Commit: 28 Dec 24
Commits this week: 0
Total Lines of Code (LoC): 1,084
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
Sunday 28 Feb 2016
11:41 am

gustafn

- added helper "::xowiki::get_raw_request_body" to obtain the content of the request body either -as_string or as_file (abstracts spool file handling away)

Options
    • -2
    • +30
    ./xowiki-utility-procs.tcl
Thursday 11 Feb 2016
11:06 am

gustafn

- There are still instances having old constraint names. The updated

version of ::xowiki::refresh_id_column_fk_constraints takes care about these relicts.

Options
    • -1
    • +3
    ./xowiki-utility-procs.tcl
  2. … 2 more files in changeset.
Wednesday 02 Sep 2015
12:45 pm

gustafn

- refactor code: factor our renaming logic from web-callable method Package.change-page-order into utility method "::xowiki::utility change_page_order"

Options
    • -1
    • +90
    ./xowiki-utility-procs.tcl
  2. … 1 more file in changeset.
Thursday 20 Aug 2015
7:09 pm

gustafn

- make update script more robust

Options
    • -2
    • +2
    ./xowiki-utility-procs.tcl
Friday 14 Aug 2015
7:28 pm

gustafn

- backport from oacs-5-9

Options
    • -2
    • +8
    ./xowiki-utility-procs.tcl
  2. … 2 more files in changeset.
7:25 pm

gustafn

- when form_instance_item_index is dropped, and hstore should be used,

repopulate the item_index with hstore values

- ::xowiki::hstore::update_update_all_form_instances respects now the

use_hstore package parameter values

Options
    • -2
    • +8
    ./xowiki-utility-procs.tcl
  2. … 2 more files in changeset.
Monday 18 May 2015
11:20 am

gustafn

- fix merge bug

Options
    • -3
    • +3
    ./xowiki-utility-procs.tcl
11:19 am

gustafn

- fix merge bug

Options
    • -3
    • +3
    ./xowiki-utility-procs.tcl
Sunday 03 May 2015
10:36 am

gustafn

- no need for semicolon

Options
    • -2
    • +2
    ./xowiki-utility-procs.tcl
Saturday 02 May 2015
6:38 pm

gustafn

- refresh fks of id_columns: some old installations have no proper foreign keys with cascading delete. Simply refresh all of these

- bump version number to 5.9.0d1

Options
    • -1
    • +12
    ./xowiki-utility-procs.tcl
  2. … 2 more files in changeset.
Wednesday 29 Apr 2015
1:16 pm

gustafn

- backport from HEAD

Options
    • -1
    • +21
    ./xowiki-utility-procs.tcl
  2. … 1 more file in changeset.
1:10 pm

gustafn

- improve robustness of upgrade scripts: handle cases with old installations, where some update scripts were not executed

Options
    • -1
    • +21
    ./xowiki-utility-procs.tcl
  2. … 1 more file in changeset.
Monday 27 Apr 2015
5:28 pm

victorg

Merging back to HEAD all changes that happened in branch oacs-5-8 between tags: vg-merge-oacs-5-8-from-20141027 and vg-merge-oacs-5-8-from-20150427

Options
    • -13
    • +119
    ./xowiki-utility-procs.tcl
  2. … 520 more files in changeset.
Wednesday 01 Apr 2015
5:57 pm

victorg

This procs were meant to be defined at the top level namespace.

Options
    • -3
    • +3
    ./xowiki-utility-procs.tcl
Tuesday 31 Mar 2015
11:29 am

gustafn

- ease updating of hstore in xowiki_form_instance_item_index for many instances (i just did the update for 35.000 instances on one machine).

- improve robustness of index generation

- fix bug with missing variable in instvars

Options
    • -3
    • +34
    ./xowiki-utility-procs.tcl
  2. … 1 more file in changeset.
Monday 23 Mar 2015
12:54 pm

gustafn

- bumped version to 0.161

- substantially improved scalability when acessing xowiki form pages

based on attributes specified in revision tables.

- much faster version of folders.folder_query (mostly relevant, when having

hundreds/thousands of folders) and FormPage.get_form_entries

- transferred hstore support from xowf to xowiki (e.g. utilities in

::xowiki::hstore::*)

- FormPage.hstore_attributes: added configurable support for

specifying, what attributes of instance-attributes should

be used in hstore.

- change virus scanning from "clamscan" to "clamdscan"

(use daemon-based version for improved performance

when uploading files)

# - xowiki_form_instance_item_index:

#

# A materialized table of xowiki formpage instances, containing

# just the item information, but combined with other attributes

# frequently used for indexing (like page_id, paren_id, ... hkey).

#

# Rationale: The quality of indices on cr_revisions tend to

# decrease when there are many revisions stored in the database,

# since the number of duplicates increases due to non-live

# revisions. This table can be used for indexing just the live

# revision on the item level.

#

# select count(*) from xowiki_form_instance_item_index

# where package_id = 18255683

# and page_template = 20260757

# and publish_status='ready';

#

#

# Define helper views in connection with the form_instance_item_index:

#

# - xowiki_form_instance_item_view:

#

# A view similar to xowiki_form_pagei, but containing already

# often extra-joined attributes like parent_id, object_type,

# publish_status, etc.. This view returns

# only the values of the live revisions, and uses

# "form_instance_item_index" for quick lookup.

#

# select * from xowiki_form_instance_item_view

# where package_id = 18255683

# and page_template = 20260757

# and publish_status='ready';

#

#

# - xowiki_form_instance_children:

#

# Return the root_item_id and all attributes of the

# form_instance_item_index of all child items under the tree based

# on parent_ids. Use a query like the following to count the

# children of an item having a certain page_template (e.g.

# find all the folders/links/... having the the specified item as

# parent).

#

# select count(*) from xowiki_form_instance_children

# where root_item_id = 18255779

# and page_template = 20260757

# and publish_status='ready';

#

# - xowiki_form_instance_attributes

#

# Return for a given item_id the full set of attributes like the

# one returned from xowiki_form_instance_item_view. The idea is to

# make it convenient to obtain from a query all attributes

# necessary for creating instances. The same view can be used to

# complete either values from the xowiki_form_instance_item_index

#

# select * from xowiki_form_instance_item_index xi

# left join xowiki_form_instance_attributes xa on xi.item_id = xa.item_id;

#

# or from xowiki_form_instance_children

#

# select * from xowiki_form_instance_children ch

# left join xowiki_form_instance_attributes xa on ch.item_id = xa.item_id;

Options
    • -3
    • +78
    ./xowiki-utility-procs.tcl
  2. … 5 more files in changeset.
Tuesday 03 Mar 2015
5:08 pm

victorg

Using ::xo::dc api instead of db_*.

Options
    • -12
    • +12
    ./xowiki-utility-procs.tcl
  2. … 3 more files in changeset.
Monday 27 Oct 2014
5:38 pm

victorg

Merging back to HEAD branch oacs-5-8 (using tag vg-merge-oacs-5-8-from-20141027).

Options
    • -108
    • +125
    ./xowiki-utility-procs.tcl
  2. … 2547 more files in changeset.
Tuesday 09 Sep 2014
10:39 am

gustafn

- Standardize spelling of OpenACS in xo* packages

Options
    • -2
    • +2
    ./xowiki-utility-procs.tcl
  2. … 7 more files in changeset.
Friday 06 Jun 2014
1:56 pm

gustafn

- don't treat all warnings from clamav as virus detections (had false positives on flash files; many thanks to Markus Moser for the suggestion and testing)

Options
    • -2
    • +5
    ./xowiki-utility-procs.tcl
Tuesday 01 Apr 2014
8:37 pm

gustafn

- The C-library function tmpnam() is deprecated since a while. Therefore naviserver has deprecated ns_tmpnam as well.

Therefore we introduce a new function "ad_tmpnam" which requires just a minimal change and uses ns_mktemp.

Options
    • -2
    • +2
    ./xowiki-utility-procs.tcl
  2. … 27 more files in changeset.
Thursday 13 Mar 2014
1:33 pm

gustafn

- make publish-status for get_page_order_items and page_order_renames configurable

Options
    • -5
    • +11
    ./xowiki-utility-procs.tcl
1:28 pm

gustafn

- use spaces rather then tabs

Options
    • -83
    • +84
    ./xowiki-utility-procs.tcl
11:14 am

gustafn

- fix page order increment function to handle multi-digit suffix

Options
    • -2
    • +3
    ./xowiki-utility-procs.tcl
Tuesday 11 Feb 2014
12:58 pm

gustafn

* use new interface in order to be able to use dbi-*

* updated dependencies

* bumped revision number

Options
    • -18
    • +24
    ./xowiki-utility-procs.tcl
  2. … 24 more files in changeset.
Monday 30 Sep 2013
1:37 pm

gustafn

- don't abbreviate subcommands

Options
    • -4
    • +4
    ./xowiki-utility-procs.tcl
  2. … 22 more files in changeset.
Tuesday 17 Sep 2013
7:49 pm

gustafn

- use lassign instead of "foreach ... break" idiom

Options
    • -4
    • +4
    ./xowiki-utility-procs.tcl
  2. … 21 more files in changeset.
Monday 12 Aug 2013
9:46 pm

gustafn

- use more tcl 8.5 idioms

Options
    • -2
    • +2
    ./xowiki-utility-procs.tcl
  2. … 7 more files in changeset.
Monday 29 Jul 2013
10:59 am

gustafn

- added utility function "xowiki::utility user_is_active" to centralize logic about querying and rendering active users

Options
    • -1
    • +20
    ./xowiki-utility-procs.tcl
Thursday 11 Apr 2013
11:53 pm

gustafn

- make use of ::xo::db_list* functions

Options
    • -6
    • +6
    ./xowiki-utility-procs.tcl
  2. … 4 more files in changeset.