wiki:ValuePropagationPlugin

Version 2 (modified by Chris Nelson, 13 years ago) (diff)

Extended notes

Value Propagation Plugin

Description

A configurable ticket change listener plugin that can update other fields or fields on other tickets when a ticket changes. This is a fairly rough first draft. It handles ticket changes fairly well, doesn't blow up on ticket creation and doesn't do anything on ticket deletion. Looking for feedback.

Update values in other tickets based on ticket changes. For example, with Subtickets plugin and Timing and Estimation plugin in place, a parent ticket's estimate may be the sum of its children's estimates. This plugin can update the parent when the child changes.

There are three types of relationships:

  • self - the "other" ticket is the current ticket (update another field)
  • link - the other tickets are listed in a field of this ticket
  • query - the other tickets can be queried based on this ticket's ID

There are several methods of updating the other ticket's value:

  • sum - add this ticket's value to the other ticket's value. (This ticket's old value is subtracted first.) Essentially:
oldOther[to] -= old_values[from]
newOther[to] += ticket[from]
  • min - the other ticket's value is the minimum of it's old value and this ticket's value
  • max - the other ticket's value is the maximum of it's old value and this ticket's value
  • suffix - this ticket's value is added as a suffix to the other ticket's value. (This ticket's old value is removed first.)
  • prefix - this ticket's value is added as a prefix to the other ticket's value. (This ticket's old value is removed first.)

Other desirable methods which are not yet implemented:

  • union: like sum but field f is a list (set)
  • set: other's f2 is ticket's f1.

FIXME - A system of pluggable types and methods would be nice.

When the enum priority changes, the pseudo-field "priority_value" is available for processing.

Configuration looks something like:

[value_propagation]
r1.type = link
r1.link = parents
r1.fields = estimatedhours, hours
r1.method.estimatedhours = sum
r1.method.hours = sum

r2.type = query
r2.query = SELECT child FROM subtickets WHERE parent = %s
r2.fields = effpriority
r2.method.effpriority = prefix

r3.type = self
r3.fields = priority:effpriority
r2.method.priority = suffix

Bugs/Feature Requests

Existing bugs and feature requests for ValuePropagationPlugin are here.

If you have any issues, create a new ticket.

Download

Download the zipped source from [download:valuepropagationplugin here].

Source

You can check out ValuePropagationPlugin from here using Subversion, or browse the source with Trac.

Example

[value_propagation] r1.fields = estimatedhours, hours r1.link = parents r1.method.estimatedhours = sum r1.method.hours = sum r1.type = link

Recent Changes

16190 by rjollos on 2017-01-20 07:49:25
1.2.0dev: Adapt to Trac 1.2 API

  • Fix variable referenced before assigned, fixes #12084
  • Fix attribute error due to int cnum, fixes #11033

Fixes #13038.

16189 by rjollos on 2017-01-20 06:02:09
1.2.0dev: Conform to PEP8
16188 by rjollos on 2017-01-20 05:48:11
Branch for Trac 1.2 support
(more)

Author/Contributors

Author: ChrisNelson
Maintainer: ChrisNelson
Contributors: