From 3e182d0476637fca2ee618d26aa6776f0e20b2c7 Mon Sep 17 00:00:00 2001
From: jc0b <j.burley@vu.nl>
Date: Thu, 23 Apr 2020 14:59:48 +0200
Subject: Added basic mongodb framework

---
 docker-compose.yml              | 22 ++++++++++++++
 mongodb/Dockerfile              |  6 ++++
 mongodb/mongo-init-opendc-db.sh | 12 ++++++++
 mongodb/mongo-init.js           | 67 +++++++++++++++++++++++++++++++++++++++++
 mongodb/mongo-opendc-schema.sh  |  7 +++++
 5 files changed, 114 insertions(+)
 create mode 100644 mongodb/Dockerfile
 create mode 100644 mongodb/mongo-init-opendc-db.sh
 create mode 100644 mongodb/mongo-init.js
 create mode 100644 mongodb/mongo-opendc-schema.sh

diff --git a/docker-compose.yml b/docker-compose.yml
index 9145c551..a7c3698f 100644
--- a/docker-compose.yml
+++ b/docker-compose.yml
@@ -48,3 +48,25 @@ services:
     # uncomment in production
     # volumes:
     #   - "/data/mariadb:/var/lib/mysql"
+  mongo:
+    build:
+        context: ./mongodb
+    restart: on-failure
+    environment:
+      MONGO_INITDB_ROOT_USERNAME: root
+      MONGO_INITDB_ROOT_PASSWORD: rootpassword
+      MONGO_INITDB_DATABASE: admin
+      OPENDC_DB: opendc
+      OPENDC_DB_USERNAME: opendc
+      OPENDC_DB_PASSWORD: opendcpassword
+    ports:
+      - 27017:27017
+
+  mongo-express:
+    image: mongo-express
+    restart: on-failure
+    ports:
+      - 8082:8081
+    environment:
+      ME_CONFIG_MONGODB_ADMINUSERNAME: root
+      ME_CONFIG_MONGODB_ADMINPASSWORD: rootpassword
\ No newline at end of file
diff --git a/mongodb/Dockerfile b/mongodb/Dockerfile
new file mode 100644
index 00000000..e8dd98bc
--- /dev/null
+++ b/mongodb/Dockerfile
@@ -0,0 +1,6 @@
+FROM mongo:4.2.5
+MAINTAINER Jacob Burley <j.burley@vu.nl>
+
+# Import init script
+ADD mongo-init-opendc-db.sh /docker-entrypoint-initdb.d
+ADD mongo-opendc-schema.sh /docker-entrypoint-initdb.d
\ No newline at end of file
diff --git a/mongodb/mongo-init-opendc-db.sh b/mongodb/mongo-init-opendc-db.sh
new file mode 100644
index 00000000..55e9ec68
--- /dev/null
+++ b/mongodb/mongo-init-opendc-db.sh
@@ -0,0 +1,12 @@
+#!/bin/bash
+
+echo 'Creating opendc user and db'
+
+mongo opendc \
+        --host localhost \
+        --port 27017 \
+        -u $MONGO_INITDB_ROOT_USERNAME \
+        -p $MONGO_INITDB_ROOT_PASSWORD \
+        --authenticationDatabase admin \
+        --eval "db.createUser({user: 'opendc', pwd: 'opendcpassword', roles:[{role:'dbOwner', db: 'opendc'}]});"
+$MONGO_CMD = "mongo opendc --host localhost --port 27017 -u $MONGO_INITDB_ROOT_USERNAME -p $MONGO_INITDB_ROOT_PASSWORD --authenticationDatabase admin"
\ No newline at end of file
diff --git a/mongodb/mongo-init.js b/mongodb/mongo-init.js
new file mode 100644
index 00000000..562bda6f
--- /dev/null
+++ b/mongodb/mongo-init.js
@@ -0,0 +1,67 @@
+db.auth('root', 'rootpassword')
+
+let error = true
+
+db.createUser(
+  {
+      user: "admin",
+      pwd: "adminpassword",
+      roles: [
+          {
+              role: "readWrite",
+              db: "admin"
+          }
+      ]
+  }
+)
+
+db = db.getSiblingDB('opendc')
+
+db.createUser(
+        {
+            user: "opendc",
+            pwd: "opendcpassword",
+            roles: [
+                {
+                    role: "readWrite",
+                    db: "opendc"
+                }
+            ]
+        }
+);
+
+db.createCollection(users)
+db.createCollection(authorizations)
+db.createCollection(authorization_levels)
+db.createCollection(simulations)
+db.createCollection(experiments)
+db.createCollection(paths)
+db.createCollection(sections)
+db.createCollection(schedulers)
+db.createCollection(traces)
+db.createCollection(jobs)
+db.createCollection(tasks)
+db.createCollection(task_dependencies)
+db.createCollection(task_states)
+db.createCollection(machine_states)
+db.createCollection(datacenters)
+db.createCollection(rooms)
+db.createCollection(room_types)
+db.createCollection(tiles)
+db.createCollection(objects)
+db.createCollection(object_types)
+db.createCollection(allowed_objects)
+db.createCollection(psus)
+db.createCollection(cooling_items)
+db.createCollection(racks)
+db.createCollection(machines)
+db.createCollection(machine_tags)
+db.createCollection(failure_models)
+db.createCollection(cpus)
+db.createCollection(machine_cpus)
+db.createCollection(gpus)
+db.createCollection(machine_gpus)
+db.createCollection(memories)
+db.createCollection(machine_memories)
+db.createCollection(storages)
+db.createCollection(machine_storages)
\ No newline at end of file
diff --git a/mongodb/mongo-opendc-schema.sh b/mongodb/mongo-opendc-schema.sh
new file mode 100644
index 00000000..7fd9d10f
--- /dev/null
+++ b/mongodb/mongo-opendc-schema.sh
@@ -0,0 +1,7 @@
+#!/bin/bash
+
+echo 'Creating opendc db schema...'
+
+$MONGO_CMD = "mongo opendc --host localhost --port 27017 -u $OPENDC_DB_USERNAME -p $OPENDC_DB_PASSWORD --authenticationDatabase opendc"
+
+eval $MONGO_COMMAND --eval "db.createCollection('environments'); db.createCollection('rooms'); db.createCollection('datacenters');"
\ No newline at end of file
-- 
cgit v1.2.3