xowiki-utility-procs.tcl

  • last updated 19 mins ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Use hstore_attributes in the method update_item_index instead of the full list of the instance attributes to achieve consistency with ::xowiki::hstore::update_form_instance_item_index

  1. … 1 more file in changeset.
- reduce verbosity

- in case of invalid input, provide more detailed information

- fix omitted update after replacement of "xo::dc foreach" (many thanks to Thomas Renner)

- allow pretty_age to point to the future

- bump version to 5.9.1d10 to trigger reload of catalog files

  1. … 4 more files in changeset.
- move adp templates from xowiki/www to xowiki/resources/templates

- improve validity checking on tags (e.g. in path notation) to avoid

potential pg errors on invalid UTF-8

  1. … 24 more files in changeset.
- remove unneeded code

- remove unneeded code

- added support for HTML5 attribute "multiple" to form-field "file"

(requires updated naviserver for handling multiple files via [ns_getform])

- added dropzone to xowiki menubar

(easy means for uploading one or many files to the current folder)

  1. … 7 more files in changeset.
- 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)

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

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

  1. … 2 more files in changeset.
- refactor code: factor our renaming logic from web-callable method Package.change-page-order into utility method "::xowiki::utility change_page_order"

  1. … 1 more file in changeset.
- make update script more robust

- backport from oacs-5-9

  1. … 2 more files in changeset.
- 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

  1. … 2 more files in changeset.
- fix merge bug

- fix merge bug

- no need for semicolon

- 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

  1. … 2 more files in changeset.
- backport from HEAD

  1. … 1 more file in changeset.
- improve robustness of upgrade scripts: handle cases with old installations, where some update scripts were not executed

  1. … 1 more file in changeset.
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

  1. … 520 more files in changeset.
This procs were meant to be defined at the top level namespace.

- 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

  1. … 1 more file in changeset.
- 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;

  1. … 5 more files in changeset.
Using ::xo::dc api instead of db_*.

  1. … 3 more files in changeset.
Merging back to HEAD branch oacs-5-8 (using tag vg-merge-oacs-5-8-from-20141027).

    • -108
    • +125
    ./xowiki-utility-procs.tcl
  1. … 2547 more files in changeset.
- Standardize spelling of OpenACS in xo* packages

  1. … 7 more files in changeset.
- 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)

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

  1. … 27 more files in changeset.
- make publish-status for get_page_order_items and page_order_renames configurable