mjhjmtu

I have a cypher script that consists of multiline cypher queries that are delimited by a specific string e.g. -delmiter-.

I want to echo each of these segments into the cypher shell in a container and get the query that was sent into the cypher shell and the output of the shell.

When using dummy code it would be like this

#!/bin/bash
while read $multilinesegment
do
 echo $multilinesegment
 docker exec -i neo4j_container /bin/cypher-shell -u user -p password --format=verbose
done <<< import.cypher #-delimitedby'-delimiter-'

How can I split the script into these segments and run a loop with it?

edit:
My import.cypher looks like this:

match (a:Person)-[:Is_maried_to]-(b)
set b.last_name=a.last_name
return a,b;
-delimiter-
match (a:Person)-[:Is_maried_to]-(b)
set b.last_name=a.last_name
return a,b;
-delimiter-
match (a:Person)-[:Is_maried_to]-(b)
set b.last_name=a.last_name
return a,b;
-delimiter-
match (a:Person)-[:Is_maried_to]-(b)
set b.last_name=a.last_name
return a,b;
-delimiter-

Can -delimiter- be a blank line?

match (a:Person)-[:Is_maried_to]-(b)
set b.last_name=a.last_name
return a,b;

match (a:Person)-[:Is_maried_to]-(b)
set b.last_name=a.last_name
return a,b;

...

If so

awk 'BEGIN 
 RS=""
 command = "docker exec -i neo4j_container /bin/cypher-shell -u user -p password --format=verbose"
 
 print ' import.cypher

and then you do not need the (slow and) bad at reading lines while read loop. Bad in the sense that if the ultimate line lacks a newline, that line is

(echo one; echo -n two) | while read l; do echo $l; done

whoops! silent data loss!