darcs - gombemi

1 <?xml version='1.0'?>

2 <!DOCTYPE para PUBLIC "-//OASIS//DTD DocBook XML 5.0//EN"

3 "http://www.oasis-open.org/docbook/xml/5.0/dtd/docbook.dtd" [

4

5 <!ENTITY % entities SYSTEM "../entities">

6 %entities;

7 <!ENTITY % constants SYSTEM "../constants">

8 %constants;

9 ]>

12 - See document output for full copyright information. -->

14 <!-- Core documentation on the ACTOR_ACTEES view.

16 - This is indeed the query that makes the view, so don't break it!

18 - The "code" element must have a 'role="view"' attribute

19 - so that Gombe-MI code generation can get the code

20 - and actually make the view!

21 -->

23 <para xmlns="http://docbook.org/ns/docbook"

24 version="5.0">

26 <figure xml:id="actor_actees-code">

27 <title>Query Defining the ACTOR_ACTEES View</title>

28 <literallayout>

29 <code role="view">SELECT events.eid AS eid

30 , events.intid AS intid

31 , actors.pid AS actorpid

32 , actees.pid AS acteepid

33 , events.behavior AS behavior

34 , events.position AS position

35 , events.uncertain AS uncertain

36 , followrole(intervals.followid, actors.participant) AS actorrole

37 , actors.participant AS actor

38 , followrole(intervals.followid, actees.participant) AS acteerole

39 , actees.participant AS actee

40 , events.comment AS comment

41 FROM events

42 JOIN intervals

43 ON (intervals.intid = events.intid)

44 JOIN parts AS actors

45 ON (actors.eid = events.eid)

46 JOIN parts AS actees

47 ON (actees.eid = events.eid)

48 WHERE actors.part = 'gmi_actor'

49 AND actees.part = 'gmi_actee'</code><code>;</code></literallayout>

50 </figure>

52

54 <!-- Use mediaobject role attribute to select either xhtml (html)

55 or pdf (dblatex) file paths. -->

57 <figure xml:id="actor_actees-erd">

58 <title>Entity Relationship Diagram of the ACTOR_ACTEES View</title>

59 <mediaobject>

60 <imageobject role="html">

61 <imagedata scalefit="1" width="6in"

62 fileref="/doc/diagrams/actor_actees.png" format="PNG" />

63 </imageobject>

64 <imageobject role="dblatex">

65 <imagedata scalefit="1" width="6in"

66 fileref="/diagrams/actor_actees.eps" format="EPS" />

67 </imageobject>

69 <textobject> <phrase>If we could we would display here the

70 diagram showing how the ACTOR_ACTEES view is constructed.</phrase>

71 </textobject>

72 </mediaobject>

73 </figure>

74 </para>

75 <!--

76 Local Variables:

77 mode: xml

78 End:

79 -->