Exemple de graphe social professionnel.

recommendations.cypher

Example CREATE (flo:CONTACT {name: 'Florent'}) RETURN flo;
CREATE (eric:CONTACT {name: 'Eric'}) RETURN eric;
CREATE (jb:CONTACT {name: 'Jean-Baptiste'}) RETURN jb;
CREATE (samuel:CONTACT {name: 'Samuel'}) RETURN samuel;

CREATE (meta:COMPANY {name: 'Metaboli'}) RETURN meta;
CREATE (lt:COMPANY {name: 'Lateral Thoughts'}) RETURN lt;

// -- Florent worked for Metaboli
MATCH (flo:CONTACT), (meta:COMPANY)
WHERE flo.name = 'Florent' AND meta.name = 'Metaboli'
CREATE (flo)-[flo_meta:WORKED_IN {beginning:1305705600, end:1325264400}]->(meta)
RETURN flo_meta;

// -- Samuel works for Metaboli
MATCH (sam:CONTACT), (meta:COMPANY)
WHERE sam.name = 'Samuel' AND meta.name = 'Metaboli'
CREATE (sam)-[sam_meta:WORKED_IN {beginning:1209708000, end:1325264400}]->(meta)
RETURN sam_meta;

// -- Eric worked for Metaboli
MATCH (eric:CONTACT), (meta:COMPANY)
WHERE eric.name = 'Eric' AND meta.name = 'Metaboli'
CREATE (eric)-[eric_meta:WORKED_IN {beginning:1265007600, end:1341072000}]->(meta)
RETURN eric_meta;

// -- Jean-Baptiste works for LT
MATCH (jb:CONTACT), (lt:COMPANY)
WHERE jb.name = 'Jean-Baptiste' AND lt.name = 'Lateral Thoughts'
CREATE (jb)-[jb_lt:WORKED_IN {beginning:1314864000}]->(lt)
RETURN jb_lt;


// -- Florent is in contact with JB
MATCH (flo:CONTACT), (jb:CONTACT)
WHERE flo.name = 'Florent' AND jb.name = 'Jean-Baptiste'
CREATE (flo)-[flo_jb:IN_CONTACT_WITH]-(jb)
RETURN flo_jb;

// -- Florent is in contact with Sam
MATCH (flo:CONTACT), (sam:CONTACT)
WHERE flo.name = 'Florent' AND sam.name = 'Samuel'
CREATE (flo)-[flo_sam:IN_CONTACT_WITH]-(sam)
RETURN flo_sam;

// -- JB is in contact with Eric
MATCH (jb:CONTACT), (eric:CONTACT)
WHERE jb.name = 'Jean-Baptiste' AND eric.name = 'Eric'
CREATE (jb)-[jb_eric:IN_CONTACT_WITH]-(eric)
RETURN jb_eric;