Load articles titles in DB

gistfile1.groovy

// Put the article titles into a database
Class.forName("org.neo4j.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:neo4j://localhost:7474/");

titles.each {
    def cypherQuery = """
    MERGE (w:Website {name: {1}})
    MERGE (d:Day {date: {2}})
    CREATE
      (a:Article {3}),
      (a)-[:PUBLISHED_ON]->(w),
      (a)-[:PUBLISHED_AT]->(d)
    """
    def stmt = con.prepareStatement(cypherQuery)
    stmt.setString(1, "slate.com")
    stmt.setString(2, new Date().format("YYYY/MM/dd"))
    stmt.setObject(3, [title: it])
    stmt.executeUpdate()
    println "Inserted: ${it}"
}