2178
46%
master: 45%

Ran 09 Jul 2016 06:16PM UTC

Jobs 1

Files 79

Run time 4s

Badge

Embed ▾

pending completion

Build # 2178

Build Type

push

travis-ci

Committed by

aschampion

Commit Message

Node: spatially query connectors and links

Previously, connectors were queried based on whether they were related
to a treenode in the bounding box or were in a z-section of the bounding
box. This had several downsides:

1. Joining a large set of treenodes into links when few would actually
   exist
2. Links where the connector and treenode were both outside the bounding
   box were omitted even if the link intersected the bounding box
3. Querying connectors by section axis does not generalize to arbitrary
   planes

Instead, query links and connectors spatially via a PostGIS edge table
as is done for treenodes.

There are several possible implementations. The one in this commit
creates an edge table for treenode_connectors that:

1. Indexes based on project, treenode and connector, not
   treenode_connector's ID (which is not used elsewhere and is
   unindexed)
2. Deduplicates edges for multiple treenode_connectors for
   the same treenode and connector but different relations
3. Allows treenode to be NULL, so that connectors can also be added to
   this edge table like root nodes in the treenode_edge table

This increases complexity of the edge table maintenance triggers
substantially, but prevents the need to separately query for connectors
without links.

Run Details

5528 of 11944 relevant lines covered (46.28%)

0.46 hits per line

Jobs

ID	Job ID	Ran	Files	Coverage
1	2178.1	09 Jul 2016 06:16PM UTC	0	46.28	Travis Job 2178.1

Source Files on build 2178

Detailed source file information is not available for this build.

catmaid / CATMAID / 2178
46%
master: 45%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 2178

catmaid / CATMAID / 2178 46% master: 45%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 2178

catmaid / CATMAID / 2178
46%
master: 45%

README BADGES
x