Giter VIP home page Giter VIP logo

Comments (2)

nicolewhite avatar nicolewhite commented on August 12, 2024

These queries are run like this:

    def cypher(self, statement):
        error = False
        headers = []
        rows = []

        start = datetime.now()
        tx = self.graph.begin()

        try:
            result = tx.run(statement, self.parameters)
            headers = list(result.keys())
            rows = [[x[header] for header in headers] for x in result]
            tx.commit()
        except KeyboardInterrupt:
            tx.rollback()
            error = ""
        except Exception as e:
            error = e

Maybe @nigelsmall has an idea?

from cycli.

ptrdvds avatar ptrdvds commented on August 12, 2024

When using "USING PERIODIC COMMIT 250" with "LOAD CSV" in cycli i get the following error; "Executing queries that use periodic commit in an open transaction is not possible. [Neo.ClientError.Statement.SemanticError]"
Running the exact same query in cypher-shell connected to the same Neo4j Node (3.3.1) runs without any problems.

The query:

`USING PERIODIC COMMIT 250

LOAD CSV WITH HEADERS FROM "http://nginx/country.csv" AS countryLine FIELDTERMINATOR ','

MERGE (c:Country { fao: countryLine.fao,
numeric3: countryLine.numeric3,
alpha3: countryLine.alpha3,
alpha2: countryLine.alpha2,
name: countryLine.name })
WITH c
SET c :Geography;`

Tested on :
Cycli version: 0.7.6
Neo4j version: 3.3.1
Python 3.6.3 in python:alpine docker container

from cycli.

Related Issues (20)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.