neo4j cypher queries - query parameters / published by https://github.com/dacr/code-examples-manager #9b544bf0-8bbc-4058-9992-1e3a35d519c1/4b5862cb2889f9697b5fd70478a3df6a050a07af

neo4j-cypher-raw-query-parameters.sc

// summary : neo4j cypher queries - query parameters
// keywords : scala, neo4j, cypher, @testable
// publish : gist
// authors : David Crosson
// license : Apache License Version 2.0 (https://www.apache.org/licenses/LICENSE-2.0.txt)
// id : 9b544bf0-8bbc-4058-9992-1e3a35d519c1
// created-on : 2024-06-19T17:23:21+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"
// ---------------------

import org.neo4j.driver.{AuthTokens, GraphDatabase, Result}
import scala.util.Using
import scala.util.chaining.*
import scala.jdk.CollectionConverters.*

val fixture =
  """CREATE (   jane:Person {firstName: 'DAISY',  lastName: 'DUCK',     age: 32} )
    |CREATE (    joe:Person {firstName: 'JOE',    lastName: 'DALTON',   age: 42} )
    |CREATE (  james:Person {firstName: 'JOHN',   lastName: 'CONNORS',  age: 64} )
    |CREATE ( albert:Person {firstName: 'ALBERT', lastName: 'EINSTEIN', age: 24} )
    |""".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 parameterizedQuery =
        """MATCH (n)
          |WHERE n.firstName = $firstName AND n.lastName = $lastName
          |RETURN n.age AS age
          |""".stripMargin

      val parameters1 = Map("firstName" -> "JOE", "lastName" -> "DALTON")
      val parameters2 = Map("firstName" -> "JOHN", "lastName" -> "CONNORS")

      val response1:Result = session.run(parameterizedQuery, parameters1.asJava)
      val joeAge  = response1.single().get("age")

      val response2:Result = session.run(parameterizedQuery, parameters2.asJava)
      val johnAge = response2.single().get("age")

      println(s"joe age is $joeAge and john age is $johnAge")
      // ------------------------------------------------
    }.tap(r => println(r))
  }.tap(r => println(r))
}.tap(r => println(r))