darcs - gombemi

2 --

3 -- This file is part of Gombe-MI.

4 --

5 -- Gombe-MI is free software; you can redistribute it and/or modify

6 -- it under the terms of the GNU General Public License as published by

7 -- the Free Software Foundation; either version 3 of the License, or

8 -- (at your option) any later version.

9 --

10 -- This program is distributed in the hope that it will be useful,

11 -- but WITHOUT ANY WARRANTY; without even the implied warranty of

12 -- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the

13 -- GNU General Public License for more details.

14 --

15 -- You should have received a copy of the GNU General Public License

16 -- along with Gombe-MI. If not, see <http://www.gnu.org/licenses/>.

17 --

18 -- Test of behaviors trigger, mom can't be actee (other): update events

19 -- changing grooming event to 'other' event.

20 --

21 -- All data appearing in this work are fictitious. Any resemblance to

22 -- actual data, living or archived, is purely coincidental.

23 --

24 -- Karl O. Pinc <kop@meme.com>

25 --

27 -- Allow the "other" behavior to have infant actees to ensure

28 -- we get the mom as the participant.

29 update behaviors

30 set infant_actor = true

31 , infant_w_nf_actee = false

32 , both_directions = false

33 where behavior = 'O';

35 -- Comment the existing data so we get a new commit to test the

36 -- parts trigger.

37 commit;

38 begin;

40 update events

41 set behavior = 'O'

42 from intervals

43 , parts as mom

44 , parts as kid

45 where intervals.followid = 1

46 and intervals.time = '9:00'

47 and events.intid = intervals.intid

48 and events.behavior = 'G'

49 and mom.eid = events.eid

50 and mom.participant = 'MOM'

51 and mom.part = 'E'

52 and kid.eid = events.eid

53 and kid.participant = 'KID'

54 and kid.part = 'R';