- 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;
- xo::pg_version: provide simple support for distinction of versions in pg - use recursive query for child-items in folder-tree in pg9 - add experimental package parameter "MenuBarSymLinks" in xowiki parameters to ease testing