maxdemarzi

    // Setup Template Engine
    use(new Rockerby());
    RockerRuntime.getInstance().setReloading(true);

maxdemarzi

CALL com.maxdemarzi.similarity(0.90, 100)

maxdemarzi

package com.maxdemarzi.imports;


import com.github.benmanes.caffeine.cache.Caffeine;
import com.github.benmanes.caffeine.cache.LoadingCache;
import com.maxdemarzi.schema.Labels;
import com.maxdemarzi.schema.RelationshipTypes;
import org.apache.commons.csv.CSVFormat;
import org.apache.commons.csv.CSVRecord;
import org.neo4j.graphdb.*;

maxdemarzi

CREATE (f1:Family {id:'f1'})
CREATE (f2:Family {id:'f2'})
CREATE (f3:Family {id:'f3'})
CREATE (a1:Asset {id:'a1'})
CREATE (a2:Asset {id:'a2'})
CREATE (a3:Asset {id:'a3'})
CREATE (a4:Asset {id:'a4'})
CREATE (a5:Asset {id:'a5'})
CREATE (a6:Asset {id:'a6'})
CREATE (a7:Asset {id:'a7'})

maxdemarzi

CREATE (person1:Person {name: "Max"})
CREATE (person2:Person {name: "Alex"})
CREATE (person3:Person {name: "Andrew"})
CREATE (floor1:Floor {name: "Floor 1"})
CREATE (floor2:Floor {name: "Floor 2"})
CREATE (person1)-[:SITS_IN]->(floor1)
CREATE (person2)-[:SITS_IN]->(floor1)
CREATE (person3)-[:SITS_IN]->(floor2)
CREATE (room1:Room {name:"Room 1"})
CREATE (room2:Room {name:"Room 2"})

maxdemarzi

package com.maxdemarzi.models;

import humanize.Humanize;
import lombok.Data;
import org.jooby.Upload;

import java.time.ZonedDateTime;
import java.time.format.DateTimeFormatter;
import java.util.Date;

maxdemarzi

MATCH (company)<-[:WORKS_FOR]-(me:Person{username:'ian'})-[:HAS_SKILL]->(skill),
      (company)<-[:WORKS_FOR]-(colleague)-[r:HAS_SKILL]->(skill)
WHERE  r.level > 1
RETURN colleague.username AS username,
       count(skill) AS score,
       collect(skill.name) AS skills
ORDER BY score DESC

maxdemarzi

CREATE (john:User {name:"John"})
CREATE (sheila:User {name:"Sheila"})
CREATE (robert:User {name:"Robert"})
CREATE (karen:User {name:"Karen"})
CREATE (m1:Merchant {name:"Computer Store"})
CREATE (m2:Merchant {name:"Gas Station"})
CREATE (m3:Merchant {name:"Jewelry Store"})
CREATE (m4:Merchant {name:"Furniture Store"})
CREATE (m5:Merchant {name:"Optometrist"})
CREATE (m6:Merchant {name:"Coffee Shop"})

maxdemarzi

MATCH (n:User)
RETURN n.partition, COUNT(*) AS members, COLLECT(n.name) AS names
ORDER BY members DESC
LIMIT 10

maxdemarzi

Schema
------


	CREATE CONSTRAINT ON (n:Location) ASSERT n.id IS UNIQUE;
	CREATE CONSTRAINT ON (n:Owner) ASSERT n.name IS UNIQUE;
	CREATE INDEX ON :Address(addr, zip);


Data Exploration