Admin commands to create multiple DBs in Python

Drivers & Stacks Python
1

Hello,

Is it possible to create a new database with a specific name via the Python-Neo4j driver?
For example, executing the following Admin commands in a Python script:

:USE system
CREATE DATABASE dbname

Thanks, Ariel

3

Too bad...,
but thanks anyhow!

4

You can maybe do a batch (.bat) script do achieve it. Then use Python to execute the batch script :slight_smile:

5

Thanks for the suggestion!
I was thinking to create a TXT file with the names of all the databases that I want to create, e.g.:

:USE system
CREATE DATABASE db1;
CREATE DATABASE db2;

...

and to paste this manually into the Neo4j Browser. I would need to do this only once.

6

Yeah you could do this, it's the more easier :slight_smile:

7

It is possible to create a database through the driver. Here is a code snippet:

from neo4j import GraphDatabase


driver = GraphDatabase.driver(uri, auth=(username, password))

with driver.session(database="system") as session:
    with session.begin_transaction() as tx:
        res = tx.run("CREATE DATABASE db1 IF NOT EXISTS")
    bookmark = session.last_bookmark()

with driver.session(database="db1", bookmarks=(bookmark,)) as session:
    with session.begin_transaction() as tx:
        res = tx.run('CREATE (n:Node {foo: "bar"}) RETURN n')
        print(list(res))

Note that I'm passing along the bookmark of the session that creates the database to the session that uses the database. If you don't do this, you might end up with an error because the second session tries to start the transaction on db1 before it has been fully created.

3 Likes
8

I didn't know you could do this :open_mouth:

9

Thank you so much Rouven!
Although I already chose for the "manual" solution, it is good to know that the Python driver has this great option.

10

This is really useful.. Didn't know this. Thank you!

11

If anyone stumbles over this in the future, I'd like to add that bookmarks alone might not be enough depending on the server version you're running against.

You might need a WAIT clause like this

tx.run("CREATE DATABASE db1 IF NOT EXISTS WAIT")

See also: https://www.neo4j.com/docs/cypher-manual/current/administration/databases/#administration-wait-nowait

1 Like