neo4j cypher dsl queries - simple embedded test example / published by https://github.com/dacr/code-examples-manager #b5e57ba2-a5cb-44f8-b0e1-5efadbe2f684/5ee3a1856dafbcb85434a0ebb8922062c33042ab

neo4j-cypher-dsl-hello.sc

// summary : neo4j cypher dsl queries - simple embedded test example
// keywords : scala, scalatest, neo4j, cypher, dsl, @testable
// publish : gist
// authors : David Crosson
// license : Apache NON-AI License Version 2.0 (https://raw.githubusercontent.com/non-ai-licenses/non-ai-licenses/main/NON-AI-APACHE2)
// id : b5e57ba2-a5cb-44f8-b0e1-5efadbe2f684
// created-on : 2024-06-19T08:30:46+02:00
// managed-by : https://github.com/dacr/code-examples-manager
// run-with : scala-cli $file

// ---------------------
//> using scala "3.4.2"
//> using dep "org.neo4j.test:neo4j-harness:5.20.0"
//> using dep "org.neo4j.driver:neo4j-java-driver:5.21.0"
//> using dep "org.neo4j:neo4j-cypher-dsl:2024.0.1"
// ---------------------

import org.neo4j.cypherdsl.core.Cypher
import org.neo4j.cypherdsl.core.renderer.Renderer
import org.neo4j.driver.{AuthTokens, GraphDatabase}

import scala.util.Using

val fixture =
  """
    |CREATE (:Person {name: 'Jane'})
    |CREATE (:Person {name: 'Joe'})
    |""".stripMargin

val builder =
  org.neo4j.harness.Neo4jBuilders
    .newInProcessBuilder()
    .withFixture(fixture)

Using(builder.build()) { embedded =>
  Using(GraphDatabase.driver(embedded.boltURI(), AuthTokens.none())) { driver =>
    Using(driver.session()) { session =>
      val node      = Cypher.anyNode().named("n")
      val statement =
        Cypher
          .`match`(node)
          .returning(Cypher.count(node).as("count"))
          .build()
      val renderer  = Renderer.getDefaultRenderer
      val query     = renderer.render(statement)
      val result    = session.run(query) // in tests we don't care about closing session
      val count     = result.single().get("count").asInt()
      println(s"'$query' : count = $count")
    }
  }
}