visitor@amsel.udk.ai:~$ pwd
visitor@amsel.udk.ai:~$ cat "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;
ls -la ./
tail -f zeitgeist.log
[2020-10-30 21:15:11.932486] GET /view/7697/ · paul-seidler@medienhaus.udk-berlin.de
[2020-06-23 13:39:34.181463] GET /view/7697/ · daniel-hromada@medienhaus.udk-berlin.de
[2020-06-23 13:39:30.235344] GET /view/7697/ · daniel-hromada@medienhaus.udk-berlin.de
[2020-05-07 10:17:36.987123] GET /view/7697/ · daniel-hromada@medienhaus.udk-berlin.de
[2020-05-07 09:47:29.629222] GET /view/7697/ · daniel-hromada@medienhaus.udk-berlin.de
[2020-05-07 07:53:42.405546] GET /view/7697/ · daniel-hromada@medienhaus.udk-berlin.de
[2020-05-05 11:26:28.021966] GET /view/7697/ · daniel-hromada@medienhaus.udk-berlin.de
[2020-05-05 11:26:27.860303] GET /view/7697/ · daniel-hromada@medienhaus.udk-berlin.de
[2020-05-05 07:39:34.088121] GET /view/7697/ · paul-seidler@medienhaus.udk-berlin.de
[2020-04-30 09:59:24.008792] post add_bound · paul-seidler@medienhaus.udk-berlin.de
[2020-04-30 09:59:18.987607] POST /view/7697/ · paul-seidler@medienhaus.udk-berlin.de
[2020-04-30 09:58:28.231532] GET /view/7697/ · daniel-hromada@medienhaus.udk-berlin.de
[2020-04-23 21:35:25.086169] GET /view/7697/ · daniel-hromada@medienhaus.udk-berlin.de
[2020-04-23 16:20:57.18027] post add_bound · paul-seidler@medienhaus.udk-berlin.de
[2020-04-23 16:19:03.434665] GET /view/7697/ · paul-seidler@medienhaus.udk-berlin.de
[2020-04-23 16:18:46.102678] GET /view/7697/ · daniel-hromada@medienhaus.udk-berlin.de
[2020-04-22 21:58:53.706258] GET /view/7697/ · daniel-hromada@medienhaus.udk-berlin.de
[2020-04-22 21:57:36.015998] GET /view/7697/ · daniel-hromada@medienhaus.udk-berlin.de
[2020-04-22 21:56:27.624566] post add_bound · daniel-hromada@medienhaus.udk-berlin.de
[2020-04-22 21:39:11.595352] post add_bound · daniel-hromada@medienhaus.udk-berlin.de