db_examples/RSQLite_diagram.svg

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE svg PUBLIC "-//W3C//DTD SVG 1.1//EN"
 "http://www.w3.org/Graphics/SVG/1.1/DTD/svg11.dtd">
<!-- Generated by graphviz version 2.40.1 (20161225.0304)
 -->
<!-- Title: rquery_optree Pages: 1 -->
<svg width="283pt" height="786pt"
 viewBox="0.00 0.00 282.67 786.00" xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink">
<g id="graph0" class="graph" transform="scale(1 1) rotate(0) translate(4 782)">
<title>rquery_optree</title>
<polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-782 278.671,-782 278.671,4 -4,4"/>
<!-- table_d -->
<g id="node1" class="node">
<title>table_d</title>
<polygon fill="#66cd00" stroke="#000000" points="196.5876,-777.9002 193.5876,-781.9002 172.5876,-781.9002 169.5876,-777.9002 78.0834,-777.9002 78.0834,-669.2998 196.5876,-669.2998 196.5876,-777.9002"/>
<text text-anchor="start" x="86.2096" y="-761.4" font-family="Times,serif" font-size="14.00" fill="#000000">mk_td(d, c(</text>
<text text-anchor="start" x="86.2096" y="-744.6" font-family="Times,serif" font-size="14.00" fill="#000000"> &#160;subjectID,</text>
<text text-anchor="start" x="86.2096" y="-727.8" font-family="Times,serif" font-size="14.00" fill="#000000"> &#160;surveyCategory,</text>
<text text-anchor="start" x="86.2096" y="-711" font-family="Times,serif" font-size="14.00" fill="#000000"> &#160;assessmentTotal,</text>
<text text-anchor="start" x="86.2096" y="-694.2" font-family="Times,serif" font-size="14.00" fill="#000000"> &#160;irrelevantCol1,</text>
<text text-anchor="start" x="86.2096" y="-677.4" font-family="Times,serif" font-size="14.00" fill="#000000"> &#160;irrelevantCol2))</text>
</g>
<!-- node_2 -->
<g id="node2" class="node">
<title>node_2</title>
<polygon fill="#cdc673" stroke="#000000" points="274.5067,-634.2019 .1643,-634.2019 .1643,-592.9981 274.5067,-592.9981 274.5067,-634.2019"/>
<text text-anchor="start" x="8" y="-617.8" font-family="Times,serif" font-size="14.00" fill="#000000">extend(.,</text>
<text text-anchor="start" x="8" y="-601" font-family="Times,serif" font-size="14.00" fill="#000000"> &#160;probability := exp(assessmentTotal * 0.237))</text>
</g>
<!-- table_d&#45;&gt;node_2 -->
<g id="edge1" class="edge">
<title>table_d&#45;&gt;node_2</title>
<path fill="none" stroke="#000000" d="M137.3355,-669.2445C137.3355,-660.6856 137.3355,-652.106 137.3355,-644.3347"/>
<polygon fill="#000000" stroke="#000000" points="140.8356,-644.3164 137.3355,-634.3164 133.8356,-644.3164 140.8356,-644.3164"/>
<text text-anchor="middle" x="139.0855" y="-647.6" font-family="Times,serif" font-size="14.00" fill="#000000">.</text>
<polyline fill="none" stroke="#000000" points="140.8355,-643.4 137.3355,-643.4 137.3355,-651.8318 "/>
</g>
<!-- node_3 -->
<g id="node3" class="node">
<title>node_3</title>
<polygon fill="#cdc673" stroke="#000000" points="273.9805,-558 .6905,-558 .6905,-466 273.9805,-466 273.9805,-558"/>
<text text-anchor="start" x="8.763" y="-541.4" font-family="Times,serif" font-size="14.00" fill="#000000">extend(.,</text>
<text text-anchor="start" x="8.763" y="-524.6" font-family="Times,serif" font-size="14.00" fill="#000000"> &#160;probability := probability / sum(probability),</text>
<text text-anchor="start" x="8.763" y="-507.8" font-family="Times,serif" font-size="14.00" fill="#000000"> &#160;partitionby = c(subjectID),</text>
<text text-anchor="start" x="8.763" y="-491" font-family="Times,serif" font-size="14.00" fill="#000000"> &#160;orderby = c(),</text>
<text text-anchor="start" x="8.763" y="-474.2" font-family="Times,serif" font-size="14.00" fill="#000000"> &#160;reverse = c())</text>
</g>
<!-- node_2&#45;&gt;node_3 -->
<g id="edge2" class="edge">
<title>node_2&#45;&gt;node_3</title>
<path fill="none" stroke="#000000" d="M137.3355,-592.5484C137.3355,-585.3629 137.3355,-576.9513 137.3355,-568.3247"/>
<polygon fill="#000000" stroke="#000000" points="140.8356,-568.1595 137.3355,-558.1595 133.8356,-568.1596 140.8356,-568.1595"/>
<text text-anchor="middle" x="139.0855" y="-571.2" font-family="Times,serif" font-size="14.00" fill="#000000">.</text>
<polyline fill="none" stroke="#000000" points="140.8355,-567 137.3355,-567 137.3355,-575.5299 "/>
</g>
<!-- node_4 -->
<g id="node4" class="node">
<title>node_4</title>
<polygon fill="#cdc673" stroke="#000000" points="265.8765,-431.2 8.7945,-431.2 8.7945,-339.2 265.8765,-339.2 265.8765,-431.2"/>
<text text-anchor="start" x="16.5652" y="-414.6" font-family="Times,serif" font-size="14.00" fill="#000000">extend(.,</text>
<text text-anchor="start" x="16.5652" y="-397.8" font-family="Times,serif" font-size="14.00" fill="#000000"> &#160;row_number := row_number(),</text>
<text text-anchor="start" x="16.5652" y="-381" font-family="Times,serif" font-size="14.00" fill="#000000"> &#160;partitionby = c(subjectID),</text>
<text text-anchor="start" x="16.5652" y="-364.2" font-family="Times,serif" font-size="14.00" fill="#000000"> &#160;orderby = c(probability, surveyCategory),</text>
<text text-anchor="start" x="16.5652" y="-347.4" font-family="Times,serif" font-size="14.00" fill="#000000"> &#160;reverse = c(probability))</text>
</g>
<!-- node_3&#45;&gt;node_4 -->
<g id="edge3" class="edge">
<title>node_3&#45;&gt;node_4</title>
<path fill="none" stroke="#000000" d="M137.3355,-465.8636C137.3355,-457.9969 137.3355,-449.7464 137.3355,-441.649"/>
<polygon fill="#000000" stroke="#000000" points="140.8356,-441.5145 137.3355,-431.5145 133.8356,-441.5146 140.8356,-441.5145"/>
<text text-anchor="middle" x="139.0855" y="-444.4" font-family="Times,serif" font-size="14.00" fill="#000000">.</text>
<polyline fill="none" stroke="#000000" points="140.8355,-440.2 137.3355,-440.2 137.3355,-448.5056 "/>
</g>
<!-- node_5 -->
<g id="node5" class="node">
<title>node_5</title>
<polygon fill="#cdc673" stroke="#000000" points="203.8192,-304.2019 70.8518,-304.2019 70.8518,-262.9981 203.8192,-262.9981 203.8192,-304.2019"/>
<text text-anchor="start" x="79.0941" y="-287.8" font-family="Times,serif" font-size="14.00" fill="#000000">select_rows(.,</text>
<text text-anchor="start" x="79.0941" y="-271" font-family="Times,serif" font-size="14.00" fill="#000000"> &#160;&#160;row_number &lt;= 1)</text>
</g>
<!-- node_4&#45;&gt;node_5 -->
<g id="edge4" class="edge">
<title>node_4&#45;&gt;node_5</title>
<path fill="none" stroke="#000000" d="M137.3355,-339.1563C137.3355,-330.7819 137.3355,-322.2336 137.3355,-314.4324"/>
<polygon fill="#000000" stroke="#000000" points="140.8356,-314.344 137.3355,-304.3441 133.8356,-314.3441 140.8356,-314.344"/>
<text text-anchor="middle" x="139.0855" y="-317.6" font-family="Times,serif" font-size="14.00" fill="#000000">.</text>
<polyline fill="none" stroke="#000000" points="140.8355,-313.4 137.3355,-313.4 137.3355,-321.9368 "/>
</g>
<!-- node_6 -->
<g id="node6" class="node">
<title>node_6</title>
<polygon fill="#cdc673" stroke="#000000" points="236.9487,-227.8019 37.7223,-227.8019 37.7223,-186.5981 236.9487,-186.5981 236.9487,-227.8019"/>
<text text-anchor="start" x="45.5291" y="-211.4" font-family="Times,serif" font-size="14.00" fill="#000000">rename_columns(.,</text>
<text text-anchor="start" x="45.5291" y="-194.6" font-family="Times,serif" font-size="14.00" fill="#000000"> &#160;c(diagnosis = surveyCategory))</text>
</g>
<!-- node_5&#45;&gt;node_6 -->
<g id="edge5" class="edge">
<title>node_5&#45;&gt;node_6</title>
<path fill="none" stroke="#000000" d="M137.3355,-262.7234C137.3355,-255.1436 137.3355,-246.4093 137.3355,-238.1453"/>
<polygon fill="#000000" stroke="#000000" points="140.8356,-238.0514 137.3355,-228.0514 133.8356,-238.0514 140.8356,-238.0514"/>
<text text-anchor="middle" x="139.0855" y="-241.2" font-family="Times,serif" font-size="14.00" fill="#000000">.</text>
<polyline fill="none" stroke="#000000" points="140.8355,-237 137.3355,-237 137.3355,-245.1935 "/>
</g>
<!-- node_7 -->
<g id="node7" class="node">
<title>node_7</title>
<polygon fill="#cdc673" stroke="#000000" points="246.4019,-151.4019 28.2691,-151.4019 28.2691,-110.1981 246.4019,-110.1981 246.4019,-151.4019"/>
<text text-anchor="start" x="36.0525" y="-135" font-family="Times,serif" font-size="14.00" fill="#000000">select_columns(., c(</text>
<text text-anchor="start" x="36.0525" y="-118.2" font-family="Times,serif" font-size="14.00" fill="#000000"> &#160;&#160;subjectID, diagnosis, probability))</text>
</g>
<!-- node_6&#45;&gt;node_7 -->
<g id="edge6" class="edge">
<title>node_6&#45;&gt;node_7</title>
<path fill="none" stroke="#000000" d="M137.3355,-186.3234C137.3355,-178.7436 137.3355,-170.0093 137.3355,-161.7453"/>
<polygon fill="#000000" stroke="#000000" points="140.8356,-161.6514 137.3355,-151.6514 133.8356,-161.6514 140.8356,-161.6514"/>
<text text-anchor="middle" x="139.0855" y="-164.8" font-family="Times,serif" font-size="14.00" fill="#000000">.</text>
<polyline fill="none" stroke="#000000" points="140.8355,-160.6 137.3355,-160.6 137.3355,-168.7935 "/>
</g>
<!-- node_8 -->
<g id="node8" class="node">
<title>node_8</title>
<polygon fill="#cdc673" stroke="#000000" points="190.6626,-75.3003 84.0084,-75.3003 84.0084,.1003 190.6626,.1003 190.6626,-75.3003"/>
<text text-anchor="start" x="92.1722" y="-58.6" font-family="Times,serif" font-size="14.00" fill="#000000">order_rows(.,</text>
<text text-anchor="start" x="92.1722" y="-41.8" font-family="Times,serif" font-size="14.00" fill="#000000"> &#160;c(subjectID),</text>
<text text-anchor="start" x="92.1722" y="-25" font-family="Times,serif" font-size="14.00" fill="#000000"> &#160;reverse = c(),</text>
<text text-anchor="start" x="92.1722" y="-8.2" font-family="Times,serif" font-size="14.00" fill="#000000"> &#160;limit = NULL)</text>
</g>
<!-- node_7&#45;&gt;node_8 -->
<g id="edge7" class="edge">
<title>node_7&#45;&gt;node_8</title>
<path fill="none" stroke="#000000" d="M137.3355,-110.1159C137.3355,-102.7923 137.3355,-94.2166 137.3355,-85.5777"/>
<polygon fill="#000000" stroke="#000000" points="140.8356,-85.4786 137.3355,-75.4786 133.8356,-85.4786 140.8356,-85.4786"/>
<text text-anchor="middle" x="139.0855" y="-88.4" font-family="Times,serif" font-size="14.00" fill="#000000">.</text>
<polyline fill="none" stroke="#000000" points="140.8355,-84.2 137.3355,-84.2 137.3355,-92.8254 "/>
</g>
</g>
</svg>