moxious

/* From GraphConnect 2022 Presentation:  Node Art by M. David Allen 
 * Each Neo4j browser "favorite" query starts with //XX-Query Name
 */

//01-Make a Snake
WITH 100 as snakeSize, 3 as snakeLinkage
/* Create the nodes... */
FOREACH (id IN range(0,snakeSize) | CREATE (:SnakeNode {id:id}))
/* Link each node to the previous {snakeLinkage} nodes, creating a lattice */
WITH ['A', 'B', 'C'] as labels, snakeSize, snakeLinkage

moxious

/* Create a snake */
WITH 500 as snakeSize, 3 as snakeLinkage
/* Create the nodes... */
FOREACH (id IN range(0,snakeSize) | CREATE (:SnakeNode {id:id}))
/* Link each node to the previous {snakeLinkage} nodes, creating a lattice */
WITH ['A', 'B', 'C'] as labels, snakeSize, snakeLinkage
MATCH (n:SnakeNode), (n2:SnakeNode)
WHERE n2.id > n.id and n2.id < n.id + snakeLinkage
with n, n2, labels

moxious

Hierarchy Traversal

Example source: https://dev.mysql.com/doc/refman/8.0/en/with.html#common-table-expressions-recursive-hierarchy-traversal

SQL

CREATE TABLE employees ( 
  id INT PRIMARY KEY NOT NULL, 
  name VARCHAR(100) NOT NULL, manager_id INT NULL, 

moxious

CALL {
  USE fabric.db1
  MATCH (p:Person)
  RETURN { id: p.id, name: p.name, age: p.age } as result
}
CALL {
  USE fabric.db2
  WITH result
  MERGE (p:Person { id: result.id })
     SET p += result

moxious

WITH 'https://storage.googleapis.com/meetup-data/ghengis-khan-family-tree.csv' as data

LOAD CSV WITH HEADERS FROM data AS line
MERGE (p:Person { id: line.id })
SET 
    p.name = line.name,
    p.born = coalesce(line.born, 'Unknown'),
    p.died = coalesce(line.died, 'Unknown')
WITH p, line
MERGE (father:Person { id: coalesce(line.father_id, apoc.create.uuid()) })

moxious

public class JDBCExample {
  public static void main(String[] args) throws Exception {
        Connection conn = null;
        Statement stmt = null;
 
        try {
            //STEP 2: Register JDBC driver
            Class.forName(JDBC_DRIVER);
 
            //STEP 3: Open a connection

moxious

/* Sample Data */
CREATE (mark:User { name: 'Mark' })
WITH mark
CREATE (mark)-[:PHONE]->(:Phone { number: '555-123-456' })
CREATE (mark)-[:SSN]->(:SSN { ssn: 'XYZ-ABC-DEFG' })
CREATE (mark)-[:ADDRESS]->(:Address {
    street: '123 Elm St',
    state: 'VA',
    zip: '23226'
})

moxious

1.0.3 ========================================================================

Released 2020-05-06

Enhancements & New Features

 * [NEOJ-66] Java driver logging

   You can now log Neo4j Java driver activity by using the 
   EnableJavaDriverLogging connection URL option. The driver uses the

moxious

CREATE INDEX ON :Emoji(name);
CREATE INDEX ON :Emoji(column_a);
CREATE INDEX ON :Emoji(browser);
CREATE INDEX ON :Emoji(code);
CREATE INDEX ON :Category(name);

LOAD CSV WITH HEADERS FROM 'https://storage.googleapis.com/meetup-data/emojis/all-emojis.csv' as line
WITH line
WHERE line.code is not null
MERGE (e:Emoji { code: line.code })

moxious

== 3.5 == 

    CALL dbms.queryJmx("org.neo4j:instance=kernel#0,name=Transactions") 
    YIELD attributes WITH attributes as a 
    RETURN 
        a.NumberOfRolledBackTransactions.value as rolledBack, 
        a.NumberOfOpenTransactions.value as open, 
        a.LastCommittedTxId.value as lastCommittedId, 
        a.NumberOfOpenedTransactions.value as opened, 
        a.PeakNumberOfConcurrentTransactions.value as concurrent,