NoteBook

Appearance

Example request Neo4j ​

Create Node: ​

CREATE
// Project Nodes
  (testpipe:Project {name: 'Test Pipe', code: 'tp'}),
  (testpipe2:Project {name: 'Test Pipe 2', code: 'tp2'}),

// Context Nodes
  (testPipeContext:Context {code: 'tpc', name: 'Test pipe Context', packages:['aces-1.2'], settings:['allow_floss']}),
  (testpipe)-[:USE {code: 'tpc'}]->(testPipeContext),

// Shot Nodes
  (testshot:Shot{name: 'Tst Shot', code: 'tst000', sgid: 0}),
  (testshot1:Shot{name: 'Tst Shot1', code: 'tst010', sgid: 1}),
  (testshot2:Shot{name: 'Tst Shot2', code: 'tst020', sgid: 2}),
  (testshot3:Shot{name: 'Tst Shot3', code: 'tst030', sgid: 3}),
  (testpipe)-[:CONTAINS {code: 'tp'}]->(testshot),
  (testpipe)-[:CONTAINS {code: 'tst010'}]->(testshot1),
  (testpipe)-[:CONTAINS {code: 'tst020'}]->(testshot2),
  (testpipe)-[:CONTAINS {code: 'tst030'}]->(testshot3),
  (testShotContext:Context {code: 'tsc', name: 'Test shot Context', packages:['arnold']}),
  (testShotContext1:Context {code: 'tsc1', name: 'Test shot1 Context', packages:['vray']}),
  (testshot)-[:USE {code: 'tsc'}]->(testShotContext),
  (testshot1)-[:USE {code: 'tsc1'}]->(testShotContext),

// Task Nodes
  (anim:Task{name: 'Anim', code: 'ANM', sgid: 0}),
  (testshot)-[:HAS {code: 'ANM'}]->(anim),
  (animContext:Context {code: 'ac', name: 'Test anim Context', packages:['animbot']}),
  (anim)-[:USE {code: 'ANM'}]->(animContext)

Create Constraints: ​

// Create project constraint
CREATE CONSTRAINT project_name FOR (project:Project) REQUIRE project.name IS UNIQUE;
CREATE CONSTRAINT project_code FOR (project:Project) REQUIRE project.code IS UNIQUE;

// Create context constraint
CREATE CONSTRAINT context_name FOR (context:Context) REQUIRE context.name IS UNIQUE;
CREATE CONSTRAINT context_code FOR (context:Context) REQUIRE context.code IS UNIQUE;

// Create shot constraint
CREATE CONSTRAINT shot_name FOR (shot:Shot) REQUIRE shot.name IS UNIQUE;
CREATE CONSTRAINT shot_code FOR (shot:Shot) REQUIRE shot.code IS UNIQUE;
CREATE CONSTRAINT shot_sgid FOR (shot:Shot) REQUIRE shot.sgid IS UNIQUE;

// Create task contraints:
CREATE CONSTRAINT task_name FOR (task:Task) REQUIRE task.name IS UNIQUE;
CREATE CONSTRAINT task_code FOR (task:Task) REQUIRE task.code IS UNIQUE;
CREATE CONSTRAINT task_sgid FOR (task:Task) REQUIRE task.sgid IS UNIQUE;

Example Select: ​

MATCH (p:Project)-[r]-(c)
RETURN p, c, r;

MATCH (p:Project), (c:Context), (s:Shot)
RETURN p, c, s;

// Clean
MATCH (p:Project)-[r]-(c)
DELETE r;

MATCH (p:Project), (c:Context), (s:Shot)
DELETE p, c, s;

Example Clean requests: ​

// Clean
MATCH (p:Project)-[r]-(c)
DELETE r;

MATCH (p:Context)-[r]-(c)
DELETE r;

MATCH (p:Shot)-[r]-(c)
DELETE r;

MATCH (p:Task)-[r]-(c)
DELETE r;

MATCH (p:Project) DELETE p;
MATCH (c:Context) DELETE c;
MATCH (s:Shot) DELETE s;
MATCH (t:Task) DELETE t;

DROP CONSTRAINT project_name IF EXISTS;
DROP CONSTRAINT project_code IF EXISTS;
DROP CONSTRAINT context_name IF EXISTS;
DROP CONSTRAINT context_code IF EXISTS;
DROP CONSTRAINT shot_name IF EXISTS;
DROP CONSTRAINT shot_code IF EXISTS;
DROP CONSTRAINT shot_sgid IF EXISTS;
DROP CONSTRAINT task_name IF EXISTS;
DROP CONSTRAINT task_code IF EXISTS;
DROP CONSTRAINT task_sgid IF EXISTS;

To get value by order by relation ​

MATCH path = (p:Project)-[*]->(r:Context)
WHERE p.code = 'tp'
WITH nodes(path) as nodes, r, length(path) as len
ORDER BY len ASC
return distinct r.packages