Skip to content

Instantly share code, notes, and snippets.

@YuriPerro

YuriPerro/seed_neo4j.txt

Last active January 10, 2023 23:20
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save YuriPerro/d6bb9655c55b991eff003d816731a97e to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save YuriPerro/d6bb9655c55b991eff003d816731a97e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
seed_neo4j.txt
--- Create data
CREATE (:User {name: 'Lucas', age: 20, job: 'Teste job'})
CREATE (:User {name: 'Yuri', age: 30, job: 'Teste job 2'})
CREATE (:User {name: 'Deoclecio', age: 23, job: 'Teste job 3'})
CREATE (:User {name: 'Pedro', age: 46, job: 'Teste job 4'})
RETURN *
CREATE (a1:Address {state: 'Rio de Janeiro', city: 'Petrópolis', country: 'BR'})
CREATE (a2:Address {state: 'São Paulo', city: 'Campinas', country: 'BR'})
CREATE (a3:Address {state: 'Minas Gerais', city: 'Juiz de fora', country: 'BR'})
CREATE (a3:Address {state: 'Menlo Park', city: 'California', country: 'EUA'})
RETURN *
CREATE (c1:Company {name: 'Amazon', description: 'Big company founded by Jeff Bezos', rating: 8.4})
CREATE (c2:Company {name: 'Google', description: 'Google LLC is an American multinational technology company focusing on search engine technology', rating: 9.2})
CREATE (c3:Company {name: 'Facebook', description: 'Facebook is a social networking site that makes it easy for you to connect and share with family and friends online', rating: 8.1})
RETURN *
CREATE (p1:Post {title: 'Viagem pro chile', content: 'Essas são as minhas fotos quando viajei pro Chile'})
CREATE (p2:Post {title: 'Minha casa nova', content: 'Recentemente mudei de endereço...'})
CREATE (p3:Post {title: 'Natal passado', content: 'Meu último Natal no Brasil...'})
CREATE (p3:Post {title: 'Novo produto Amazon!', content: 'Adquira agora mesmo o nosso novo produto já disponível no site...'})
CREATE (p3:Post {title: 'Facebook investe milhões!', content: 'Facebook anuncia um dos seus maiores investimentos...'})
CREATE (p2:Post {title: 'Google lança uma nova tecnologia', content: 'Google disponibilizou nessa quinta-feira uma nova...'})
RETURN *
CREATE (c1:Comment {content: 'Ótimas fotos!'})
CREATE (c2:Comment {content: 'Parabéns!'})
CREATE (c3:Comment {content: 'Tudo de bom!'})
CREATE (c1:Comment {content: 'Ótimo produto!'})
CREATE (c2:Comment {content: 'Gostei muito do produto!'})
RETURN *
--- Relationships
MATCH (l:User {name: 'Lucas'})
MATCH (d:User {name: 'Deoclecio'})
MATCH (y:User {name: 'Yuri'})
MERGE (l)-[f1:FOLLOW]->(d)
MERGE (y)-[f2:FOLLOW]->(d)
MERGE (y)-[f3:FOLLOW]->(l)
RETURN l, d, y, f1, f2, f3
MATCH (l:User {name: 'Pedro'})
MATCH (d:User {name: 'Deoclecio'})
MERGE (d)-[f1:FOLLOW]->(l)
RETURN l, d, f1
MATCH (l:User {name: 'Lucas'})
MATCH (p:Post {title: 'Viagem pro chile'})
MERGE (l)-[f1:CREATE]->(p)
RETURN l, p, f1
MATCH (c:Comment {content: 'Ótimas fotos!'})
MATCH (p:Post {title: 'Viagem pro chile'})
MERGE (p)-[f1:IT_HAS]->(c)
RETURN p, c, f1
MATCH (l:User {name: 'Lucas'})
MATCH (p:Address {state: 'Minas Gerais'})
MERGE (l)-[f1:HAS_ONE]->(p)
RETURN l, p, f1
MATCH (y:User {name: 'Yuri'})
MATCH (p:User {name: 'Pedro'})
MATCH (d:User {name: 'Deoclecio'})
MERGE (y)-[f1:FOLLOW]->(p)
MERGE (p)-[f2:FOLLOW]->(d)
RETURN y, d, p, f1, f2
MATCH (y:User {name: 'Yuri'})
MATCH (p:Post {title: 'Natal passado'})
MERGE (y)-[f1:CREATE]->(p)
RETURN y, p, f1
MATCH (c:Comment {content: 'Tudo de bom!'})
MATCH (p:Post {title: 'Natal passado'})
MERGE (p)-[f1:IT_HAS]->(c)
RETURN p, c, f1
MATCH (l:User {name: 'Yuri'})
MATCH (p:Address {state: 'Rio de Janeiro'})
MERGE (l)-[f1:HAS_ONE]->(p)
RETURN l, p, f1
MATCH (l:User {name: 'Deoclecio'})
MATCH (p:Post {title: 'Minha casa nova'})
MERGE (l)-[f1:CREATE]->(p)
RETURN l, p, f1
MATCH (l:User {name: 'Deoclecio'})
MATCH (p:Address {state: 'São Paulo'})
MERGE (l)-[f1:HAS_ONE]->(p)
RETURN l, p, f1
MATCH (l:User {name: 'Pedro'})
MATCH (p:Address {state: 'Rio de Janeiro'})
MERGE (l)-[f1:HAS_ONE]->(p)
RETURN l, p, f1
MATCH (l:Company {name: 'Amazon'})
MATCH (p:Post {title: 'Novo produto Amazon!'})
MERGE (l)-[f1:CREATE]->(p)
RETURN l, p, f1
MATCH (l:Company {name: 'Facebook'})
MATCH (p:Post {title: 'Facebook investe milhões!'})
MERGE (l)-[f1:CREATE]->(p)
RETURN l, p, f1
MATCH (c:Comment {content: 'Ótimo produto!'})
MATCH (c2:Comment {content: 'Gostei muito do produto!'})
MATCH (p:Post {title: 'Novo produto Amazon!'})
MERGE (p)-[f1:IT_HAS]->(c)
MERGE (p)-[f2:IT_HAS]->(c2)
RETURN p, c, c2, f1, f2
MATCH (l:User {name: 'Lucas'})
MATCH (c:Comment {content: 'Ótimo produto!'})
MERGE (l)-[f1:ADDS]->(c)
RETURN l, c, f1
MATCH (l:Company {name: 'Google'})
MATCH (p:Post {title: 'Google lança uma nova tecnologia'})
MERGE (l)-[f1:CREATE]->(p)
RETURN l, p, f1
MATCH (l:User {name: 'Pedro'})
MATCH (c:Comment {content: 'Gostei muito do produto!'})
MERGE (l)-[f1:ADDS]->(c)
RETURN l, c, f1
MATCH (c:Company {name: 'Facebook'})
MATCH (c2:Company {name: 'Google'})
MATCH (a:Address {city: 'California'})
MERGE (c)-[f1:HAS_ONE]->(a)
MERGE (c2)-[f2:HAS_ONE]->(a)
RETURN c, a, f1, f2
MATCH (c:Company {name: 'Amazon'})
MATCH (a:Address {state: 'Seattle'})
MERGE (c)-[f1:HAS_ONE]->(a)
RETURN c, a, f1
MATCH (l:User {name: 'Pedro'})
MATCH (l2:User {name: 'Deoclecio'})
MATCH (c:Comment {content: 'Tudo de bom!'})
MATCH (c2:Comment {content: 'Parabéns!'})
MERGE (l)-[f1:ADDS]->(c)
MERGE (l2)-[f2:ADDS]->(c2)
RETURN l, c, f1
MATCH (l:User {name: 'Yuri'})
MATCH (c:Comment {content: 'Ótimas fotos!'})
MERGE (l)-[f1:ADDS]->(c)
RETURN l, c, f1
--- Insert properties
MATCH (p:Post {title: 'Natal passado'})
SET p.createdAt = date('2023-01-05')
RETURN p
MATCH (p:Post {title: 'Minha casa nova'})
SET p.createdAt = date('2023-01-05')
RETURN p
MATCH (p:Post {title: 'Google lança uma nova tecnologia'})
SET p.createdAt = date('2023-01-07')
RETURN p
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment