Procedural Database Initialization

[gramian]

When setting up my ArcadeDB server (container), I want to initialize a database of which I formulated a "schema" procedurally in a .sql file. To automate this, I wrote a shell script that first attempts to create a database on the localhost for a given port, user, password and database name. Then, if successful, optionally a SQL script file is executed in this database if provided. Maybe this is useful to other users, too.

[gramian]

After reading this post, I found out that the (ArcadeDB) console also can run scripts if passed as a command line argument, ie bin/console.sh myscript.sql. However, there can still be circumstances where you may have need for the shell script: first, using only the console, the server setting -Darcadedb.server.databaseDirectory=... cannot be respected. Second, parameters like host, port, username, password, database name can be passed via environment variables which can be the case in container environments.

[gramian]

I read in the OrientDB docs, there is a LOAD SCRIPT console command for running a local script, which basically is an integrated version of my script.

[gramian]

It turns out, ArcadeDB already supports a load command, see https://docs.arcadedb.com/#Console , so this functionality is included!