summaryrefslogtreecommitdiff
path: root/database/mongo-init-opendc-db.sh
blob: 28a75f5cca3f05c7bd9adfc09c68b2e01e1ed9b1 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
#!/bin/bash

echo 'Creating OpenDC user and database'

mongo opendc --host localhost \
        --port 27017 \
        -u "$MONGO_INITDB_ROOT_USERNAME" \
        -p "$MONGO_INITDB_ROOT_PASSWORD" \
        --authenticationDatabase admin \
        --eval "db.createUser({user: '$OPENDC_DB_USERNAME', pwd: '$OPENDC_DB_PASSWORD', roles:[{role:'dbOwner', db: '$OPENDC_DB'}]});"

MONGO_CMD="mongo $OPENDC_DB -u $OPENDC_DB_USERNAME -p $OPENDC_DB_PASSWORD --authenticationDatabase $OPENDC_DB"

echo 'Creating collections'

$MONGO_CMD --eval 'db.createCollection("users");'
$MONGO_CMD --eval 'db.createCollection("projects");'
$MONGO_CMD --eval 'db.createCollection("topologies");'
$MONGO_CMD --eval 'db.createCollection("portfolios");'
$MONGO_CMD --eval 'db.createCollection("scenarios");'
$MONGO_CMD --eval 'db.createCollection("traces");'
$MONGO_CMD --eval 'db.createCollection("prefabs");'

echo 'Loading default traces'

$MONGO_CMD --eval 'db.traces.update(
    {"_id": "bitbrains-small"},
    {
        "$set": {
            "_id": "bitbrains-small",
            "name": "bitbrains-small",
            "type": "VM",
        }
    },
    {"upsert": true}
);'

# echo 'Loading test data'

# $MONGO_CMD --eval 'db.prefabs.insertOne(
#     {
#         "type": "rack",
#         "name": "testRack3",
#         "size": 42,
#         "depth": 42,
#         "author": "Jacob Burley",
#         "visibility": "public",
#         "children": [
#             {
#                 "type": "switch",
#                 "ports": 48,
#                 "powerDraw": 150,
#                 "psus": 1,
#                 "size": 1
#             },
#             {
#                 "type": "chassis",
#                 "size": 4,
#                 "children": [
#                     {
#                         "type": "mainboard",
#                         "sockets": 1,
#                         "dimmSlots": 4,
#                         "nics": 1,
#                         "pcieSlots": 2,
#                         "children": [
#                             {
#                                 "type": "CPU",
#                                 "coreCount": 4,
#                                 "SMT": true,
#                                 "baseClk": 3.5,
#                                 "boostClk": 3.9,
#                                 "brand": "Intel",
#                                 "SKU": "i7-3770K",
#                                 "socket": "LGA1155",
#                                 "TDP": 77
#                             },
#                             {
#                                 "type": "DDR3",
#                                 "capacity": 4096,
#                                 "memfreq": 1333,
#                                 "ecc": false
#                             },
#                             {
#                                 "type": "DDR3",
#                                 "capacity": 4096,
#                                 "memfreq": 1333,
#                                 "ecc": false
#                             },
#                             {
#                                 "type": "DDR3",
#                                 "capacity": 4096,
#                                 "memfreq": 1333,
#                                 "ecc": false
#                             },
#                             {
#                                 "type": "DDR3",
#                                 "capacity": 4096,
#                                 "memfreq": 1333,
#                                 "ecc": false
#                             },
#                             {
#                                 "type": "GPU",
#                                 "VRAM": 8192,
#                                 "coreCount": 2304,
#                                 "brand": "AMD",
#                                 "technologies": "OpenCL",
#                                 "pcieGen": "3x16",
#                                 "tdp": 169,
#                                 "slots": 2
#                             }
#                         ]
#                     },
#                     {
#                         "type": "PSU",
#                         "wattage": 550,
#                         "ac": true
#                     },
#                     {
#                         "type": "disk",
#                         "size": 2000,
#                         "interface": "SATA",
#                         "media": "flash",
#                         "formFactor": 2.5
#                     }
#                 ]
#             }
#         ]
#     });'