• last updated 18 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Using bind variables in queries in order to improve query-caching.

Fixed second typo in SQL condition for publish_status

Fixed typo in SQL condition for publish_status

- set sql-spec of attribute "description" of cr_revisions from varchar(1000) to text

- improve comments

- fixed quoting

- change tabs into spaces

  1. … 22 more files in changeset.
* overworked db-abstraction layer with support for dbi_*

* dbi_* support is per default deactivated, can be activated via

e.g. setting ::acs::preferdbi to 1 in 0-acs-init.tcl

* bump version number to use dependencies for packages, using the new interface

  1. … 9 more files in changeset.
- reduce verbosity

- keep required "eval" since it is necessary to substitute variables

- use tcl 8.5 expand operator instead of eval

  1. … 5 more files in changeset.
- use tcl 8.5 lindex features

  1. … 4 more files in changeset.
- use lassign instead of "foreach ... break" idiom

  1. … 21 more files in changeset.
- fix comment

- add opimized versions of db_list and db_list_of_lists in the xo namespace

  1. … 1 more file in changeset.
- provide optimized database interface for postgres (often, speed improvements of 25-30% for queries already in the code)

  1. … 1 more file in changeset.
- add show-link in reviews view for SWAs

- ease debugging, when CrClass is called with an unknown name

- keep non-persistent variables after caching

- reduce verbosity

- store objects in the state before initialize_loaded_object in the cache to save memory

- add support for content_type image

  1. … 1 more file in changeset.
- get package_id in instance_select_query as well always (e.g. also

for queries based on cr_revisions)

- bump version number to 0.117

  1. … 1 more file in changeset.
- return always package_id for instance_select_query (requires OpenACS 5.2).

- rewrite query, since pg makes sequential scans when the or is used

- deactivate per-thread caching of CrClass get_name and get_parent_id until we get rid of the "folder object" in xowiki

  1. … 1 more file in changeset.
- provide proper query-names for db_* interface

  1. … 8 more files in changeset.
- extended CrClass api with get_parent_id, get_name and

get_child_item_ids (all three methods do not instantiate objects)

- bumped version number to require these methods

  1. … 1 more file in changeset.
- fix the strange problem reported by Jörg Schaller with PO, where the query based on cr_revisionsi returned duplicate entries

- some refactoring:

moved ::xo::db::CrClass->require_folder to ::xo::Package->require_root_folder

and simplified it significantly

- new method :xo::db::CrFolder ad_proc register_content_types

- ::xo::db::CrFolder ad_instproc save_new

registers content types, if allowed_content_types are specified

- ::xo::db::CrFolder instproc delete: don't call UI-stuff from the library

- bump version number to let other packages depend on it

  1. … 2 more files in changeset.
- improving low level support for folders to cirumvent a name clash with the xowiki folder object (which should go away in the future)

  1. … 1 more file in changeset.