gistfile1.sql

// Try to find a contact that is connected to a node 
// with an email addrss of bob@google.com or jerk@hello.com
// Pick the first one (there should never be multiple contacts with the same emails)
// but just in case, pick the first found)
MATCH (e1:Email)-[:EMAIL]-(c1:Contact)
WHERE (e1.address IN ['bob@google.com','jerk@hello.com'])
WITH e1,c1
LIMIT 1
// Create or make user based on ID
MERGE (u:User {id: 3})

// this is the part I am not sure how to do
(IF c1 WAS NOT FOUND)
  CREATE (c:Contact)
(END)

CREATE (u)-[:KNOWS]->(c)

FOREACH(email in ["jack@hall-inc.com",'jerk@hello.com']  |
  MERGE (e:Email {address:email})
  MERGE (c)-[:EMAIL]-(e)
)

MERGE (a:Alias {name: "Jack"})
MERGE (c)-[:ALIAS]-(a);