neo4j 스탭롤 넣기 기록하기

일단 파일은.

/home/cine21/neo4j/insert_staff_role.php

1. mysql query

select P.person_id, P.hname, M.movie_id, M.hname, S.role_name from mov_staffroll as S 

left join mov_movie as M on S.movie_id=M.movie_id 

left join mov_person as P on S.mov_id=P.person_id

where S.staff_code="001" and S.movie_id=38279 and type="PS"

2. 입력 함수 만들기.

function match_role($person_id, $movie_id, $role){

global $client;

$q[] = "MERGE (actor:Person { person_id: ".$person_id." }) RETURN actor";

$q[] = "MERGE (movie:Movie { movie_id: ".$movie_id." }) RETURN movie";

$q[] = "MATCH (actor:Person { person_id: ".$person_id." }),(movie:Movie { movie_id: ".$movie_id." })

MERGE (actor)-[r:ACTED_IN{role:'".$role."'}]->(movie)

RETURN r;

";

foreach($q as $queryString){

$query = new Everyman\Neo4j\Cypher\Query($client, $queryString);

$result[] = $query->getResultSet();

}

return $result;

}

3. 밀어넣기.

pr(match_role(200, 2000, "장군"));