node-management-system/database_setup.py at master · tmchen44/node-management-system · GitHub

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
import boto3

# dynamodb = boto3.resource('dynamodb', region_name='us-west-1)
dynamodb = boto3.resource('dynamodb', endpoint_url='http://localhost:8000')

# Create table to store nodes
node_table = dynamodb.create_table(
    TableName='nodes',
    KeySchema=[
        {
            'AttributeName': 'node_id',
            'KeyType': 'HASH'
        }
    ],
    AttributeDefinitions=[
        {
            'AttributeName': 'node_id',
            'AttributeType': 'S'
        }
    ],
    ProvisionedThroughput={
        'ReadCapacityUnits': 5,
        'WriteCapacityUnits': 5
    }
)

# Create table to store projects
project_table = dynamodb.create_table(
    TableName='projects',
    KeySchema=[
        {
            'AttributeName': 'project_id',
            'KeyType': 'HASH'
        }
    ],
    AttributeDefinitions=[
        {
            'AttributeName': 'project_id',
            'AttributeType': 'S'
        }
    ],
    ProvisionedThroughput={
        'ReadCapacityUnits': 5,
        'WriteCapacityUnits': 5
    }
)

# Wait until table exists
node_table.meta.client.get_waiter('table_exists').wait(TableName='nodes')
project_table.meta.client.get_waiter('table_exists').wait(TableName='projects')

# Place first item to act as counter
node_table.put_item(
    Item={
        'node_id': '0',
        'current_id': 0
    }
)

project_table.put_item(
    Item={
        'project_id': '0',
        'current_id': 0
    }
)