Reset database through HTTP?

[Johnny Weng Luu]

Is there a way to reset the database to an empty state through HTTP for my integration tests?

Or do I have to fetch all nodes and relationships and delete them manually?

[Peter Neubauer]

Michael has written
https://github.com/jexp/neo4j-clean-remote-db-addon that comes in
handy there ...

Cheers,

/peter neubauer

Google:neubauer.peter
Skype:peter.neubauer
Phone: +46 704 106975
LinkedIn   http://www.linkedin.com/in/neubauer
Twitter      @peterneubauer

brew install neo4j && neo4j start
heroku addons:add neo4j

[Johnny Weng Luu]

I am using the hosted Neo4j instance from Heroku.

How do I use this plugin there?

Johnny

[James Thornton]

Use the Gremlin plugin (http://docs.neo4j.org/chunked/1.4/gremlin-plugin.html) to execute the script g.clear()...

POST http://localhost:7474/db/data/ext/GremlinPlugin/graphdb/execute_script

BODY '{"script"="g.clear()"}'

The Gremlin plugin provides Groovy scripting access to the:

1. Gremlin API

https://github.com/tinkerpop/gremlin/wiki

2. Blueprints API

http://tinkerpop.com/maven2/com/tinkerpop/blueprints/blueprints/1.1/api/

3. Neo4j Java API

http://api.neo4j.org/

The g.clear() method is part of the Blueprints API (http://tinkerpop.com/maven2/com/tinkerpop/blueprints/blueprints/1.1/api/), and Neo4j Server pre-sets the Blueprints Graph var "g" var for you. 

FYI: To get a reference to the raw Neo4j graph so you can use the Neo4j Java API, use the Blueprints getRawGraph() method:

neo4j = g.getRawGraph();

- James

[Johnny Weng Luu]

Is there a way to delete all nodes except the reference node(0) ?

Johnny

[Johnny Weng Luu]

An error I got:

javax.script.ScriptException: java.lang.RuntimeException: read only index

I can't delete the auto_nodex_index manually either.

Any clue?

[Peter Neubauer]

https://github.com/jexp/neo4j-clean-remote-db-addon is probably the
best way to remove the DB right if you have autoindexing involved.

Cheers,

/peter neubauer

Google:    neubauer.peter
Skype:     peter.neubauer
Phone:     +46 704 106975
LinkedIn:  http://www.linkedin.com/in/neubauer
Twitter:    @peterneubauer

Tungle:    tungle.me/peterneubauer

brew install neo4j && neo4j start
heroku addons:add neo4j

[Johnny Weng Luu]

How can I use the plugin with the Heroku addon?

Johnny

[Peter Neubauer]

Johnny,
adding plugins on hosted instances is in the works, currently you
can't. Gremlin removing is probably the best thing to do there.

Cheers,

/peter neubauer

Google:    neubauer.peter
Skype:     peter.neubauer
Phone:     +46 704 106975
LinkedIn:  http://www.linkedin.com/in/neubauer
Twitter:    @peterneubauer
Tungle:    tungle.me/peterneubauer

brew install neo4j && neo4j start
heroku addons:add neo4j

[Johnny Weng Luu]

It doesn't work since there is an node_auto_index that can't be deleted.

Johnny

[Peter Neubauer]

Ok,
that is an issue. Let me circle back with Thomas and see if we can
deploy the clean-plugin on Heroku. Per default.

Cheers,

/peter neubauer

Google:    neubauer.peter
Skype:     peter.neubauer
Phone:     +46 704 106975
LinkedIn:  http://www.linkedin.com/in/neubauer
Twitter:    @peterneubauer
Tungle:    tungle.me/peterneubauer

brew install neo4j && neo4j start
heroku addons:add neo4j

On Fri, Jan 20, 2012 at 11:36 AM, Johnny Weng Luu

[Johnny Weng Luu]

That would be great for testing purpose!

Johnny

[Peter Neubauer]

Yes,
this is a valid issue, added
https://github.com/neo4j/cloud-issues/issues/2 to track it.

Cheers,

/peter neubauer

G:  neubauer.peter
S:  peter.neubauer
P:  +46 704 106975
L:   http://www.linkedin.com/in/neubauer
T:   @peterneubauer

Neo4j 1.6 released                 - dzone.com/6S4K
The Neo4j Heroku Challenge   - http://neo4j-challenge.herokuapp.com/

On Fri, Jan 20, 2012 at 11:40 AM, Johnny Weng Luu