| //load nodes | |
| LOAD CSV WITH HEADERS FROM "https://docs.google.com/spreadsheets/u/0/d/1eL3IrbzgvZzkNnQUwDCZ1mwVfA6sypZYvDHBoeq48IM/export?format=csv&id=1eL3IrbzgvZzkNnQUwDCZ1mwVfA6sypZYvDHBoeq48IM&gid=0" AS csv | |
| CALL apoc.create.nodes([csv.Label], [{id: csv.ID, name: csv.Name}]) YIELD node | |
| RETURN count(node); | |
| MATCH (n) | |
| SET n:Node; | |
| CREATE INDEX ON :Node(id); |
| //contact tracing data import | |
| //full spreadsheet with synthetic data | |
| //https://docs.google.com/spreadsheets/d/1R-XVuynPsOWcXSderLpq3DacZdk10PZ8v6FiYGTncIE/edit#gid=0 | |
| // person sheet˝ | |
| // https://docs.google.com/spreadsheets/u/0/d/1R-XVuynPsOWcXSderLpq3DacZdk10PZ8v6FiYGTncIE/export?format=csv&id=1R-XVuynPsOWcXSderLpq3DacZdk10PZ8v6FiYGTncIE&gid=0 | |
| // Person: PersonId PersonName Healthstatus ConfirmedTime | |
| // place sheet |
| //Import Google Product Taxonomy | |
| //WITH IDENTIFIERS | |
| //downloaded from https://support.google.com/merchants/answer/1705911 | |
| create index on :Cat1(name); | |
| create index on :Cat2(name); | |
| create index on :Cat3(name); | |
| create index on :Cat4(name); | |
| create index on :Cat5(name); | |
| create index on :Cat6(name); |
Today I came across a really interesting StackOverflow question:
Given a forest of trees in a Neo4j REST server, I`m trying to return a single tree given the root vertex. Being each tree quite large, I need a de-duplicated list of all vertices and edges in order to be able to reconstruct the full tree on the client side.
| all: json2bson | |
| clean: | |
| rm -f json2bson | |
| json2bson: json2bson.c | |
| ${CC} $(shell pkg-config --cflags json libmongo-client glib-2.0) -Wall -O0 -ggdb3 -std=c99 ${CFLAGS} \ | |
| $(shell pkg-config --libs json libmongo-client glib-2.0) -o $@ $^ | |
| check: all | |
| ./json2bson <test.json >test.bson |
| "\e[A": history-search-backward | |
| "\e[B": history-search-forward | |
| set show-all-if-ambiguous on | |
| set completion-ignore-case on |
I hereby claim:
To claim this, I am signing this object:
