kastaliarbre.sql
with recursive tree as (
select obj,
sub,
array[obj] as all_ancestors,
array[knot_name] as ancestor_names
from bounds left join knots on obj=knot_id
where sub=1 and predicate='is_parent'
union all
select c.obj,
c.sub,
p.all_ancestors||c.obj,
p.ancestor_names || knot_name
from bounds c
join tree p
on c.sub = p.obj
and c.obj <> ALL (p.all_ancestors) -- avoids endless loops
left join knots on c.obj=knot_id
)
select all_ancestors,ancestor_names
from tree order by all_ancestors;
Views
Default
Arbre
Pannellum
VK-slides
KuM-slides
Knoids
Presentation
Textrec
Recview
Repetitio
Bildung
Reveal
Impress
HTML ?
Axones
-
please provide an algorithm which can transform lists provided by kastaliarbre.sql
{6301,6302} | {Presentations,OEB.global}
{6301,6302,6303} | {Presentations,OEB.global,"Order of the day"}
{6301,6302,6304} | {Presentations,OEB.global,"All which shall be presented is work-in-progress."}
{6301,6302,6305} | {Presentations,OEB.global,"Reform Pedagogy"}
{6301,6302,6305,6306} | {Presentations,OEB.global,"Reform Pedagogy","Waldorf Pedagogy"}
{6301,6302,6305,6307} | {Presentations,OEB.global,"Reform Pedagogy"," Montessori Pedagogy"}
{6301,6302,6305,6308} | {Presentations,OEB.global,"Reform Pedagogy","Freinet Pedagogy"}
{6301,6302,6309} | {Presentations,OEB.global," Commonalities among Waldorf / Montessori / Freinet"}
{6301,6302,6310}
into jsons having form
var treeData = [
{
"name": "Top Level",
"parent": "null",
"children": [
{
"name": "Level 2: A",
"parent": "Top Level",
"children": [
{
"name": "Son of A",
"parent": "Level 2: A"
},
{
"name": "Daughter of A",
"parent": "Level 2: A"
}
]
},
{
"name": "Level 2: B",
"parent": "Top Level"
}
]
}
];
Zeitgeist Log
2020-04-22 21:39:11.586568 daniel-hromada@medienhaus.udk-berlin.de executed add_bound with variables "obj"=>"7697", "ord"=>"1", "sub"=>"7568", "bound_id"=>"19795", "predicate"=>"is_parent"
2020-04-22 21:39:11.595352 daniel-hromada@medienhaus.udk-berlin.de executed add_bound with variables "obj"=>"7697", "ord"=>"1", "sub"=>"2697", "bound_id"=>"19796", "predicate"=>"created_by"
2020-04-22 21:56:27.624566 daniel-hromada@medienhaus.udk-berlin.de executed add_bound with variables "obj"=>"7698", "ord"=>"1", "sub"=>"7697", "bound_id"=>"19797", "predicate"=>"is_parent"
2020-04-22 21:57:36.015998 daniel-hromada@medienhaus.udk-berlin.de executed /view/7697/ with variables
2020-04-22 21:58:53.706258 daniel-hromada@medienhaus.udk-berlin.de executed /view/7697/ with variables
2020-04-23 16:18:46.102678 daniel-hromada@medienhaus.udk-berlin.de executed /view/7697/ with variables
2020-04-23 16:19:03.434665 paul-seidler@medienhaus.udk-berlin.de executed /view/7697/ with variables
2020-04-23 16:20:57.18027 paul-seidler@medienhaus.udk-berlin.de executed add_bound with variables "obj"=>"7697", "ord"=>"1", "sub"=>"7629", "bound_id"=>"19799", "predicate"=>"has_bookmark"
2020-04-23 21:35:25.086169 daniel-hromada@medienhaus.udk-berlin.de executed /view/7697/ with variables
2020-04-30 09:58:28.231532 daniel-hromada@medienhaus.udk-berlin.de executed /view/7697/ with variables
2020-04-30 09:59:18.987607 paul-seidler@medienhaus.udk-berlin.de executed /view/7697/ with variables
2020-04-30 09:59:24.008792 paul-seidler@medienhaus.udk-berlin.de executed add_bound with variables "obj"=>"7697", "ord"=>"1", "sub"=>"7629", "bound_id"=>"19858", "predicate"=>"has_bookmark"
2020-05-05 07:39:34.088121 paul-seidler@medienhaus.udk-berlin.de executed /view/7697/ with variables
2020-05-05 11:26:27.860303 daniel-hromada@medienhaus.udk-berlin.de executed /view/7697/ with variables
2020-05-05 11:26:28.021966 daniel-hromada@medienhaus.udk-berlin.de executed /view/7697/ with variables
2020-05-07 07:53:42.405546 daniel-hromada@medienhaus.udk-berlin.de executed /view/7697/ with variables
2020-05-07 09:47:29.629222 daniel-hromada@medienhaus.udk-berlin.de executed /view/7697/ with variables
2020-05-07 10:17:36.987123 daniel-hromada@medienhaus.udk-berlin.de executed /view/7697/ with variables
2020-06-23 13:39:30.235344 daniel-hromada@medienhaus.udk-berlin.de executed /view/7697/ with variables
2020-06-23 13:39:34.181463 daniel-hromada@medienhaus.udk-berlin.de executed /view/7697/ with variables
2020-10-30 21:15:11.932486 paul-seidler@medienhaus.udk-berlin.de executed /view/7697/ with variables