summaryrefslogtreecommitdiffstats
path: root/dovetail/utils/local_db/init_db.py
blob: 365927b5d20f218f302f0981363d29a1c2ee8257 (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
##############################################################################
# Copyright (c) 2016 HUAWEI TECHNOLOGIES CO.,LTD and others.
#
# All rights reserved. This program and the accompanying materials
# are made available under the terms of the Apache License, Version 2.0
# which accompanies this distribution, and is available at
# http://www.apache.org/licenses/LICENSE-2.0
##############################################################################

import requests
import json
import sys
import os

db_host_ip = sys.argv[1]
testapi_port = sys.argv[2]

target_url = 'http://{}:{}/api/v1'.format(db_host_ip, testapi_port)
print(target_url)
dir_path = os.path.dirname(os.path.realpath(__file__))


def get(url):
    return requests.get(url).json()


def post(url, data):
    headers = {'Content-Type': 'application/json'}
    res = requests.post(url, data=json.dumps(data), headers=headers)
    print(res.text)


def pod():
    target = '{}/pods'.format(target_url)

    with open(os.path.join(dir_path, 'pods.json'), 'r') as f:
        pods = json.load(f)
    for p in pods:
        post(target, p)


def project():
    target = '{}/projects'.format(target_url)
    with open(os.path.join(dir_path, 'projects.json'), 'r') as f:
        projects = json.load(f)
    for p in projects:
        post(target, p)


def cases():
    with open(os.path.join(dir_path, 'cases.json'), 'r') as f:
        for line in f:
            try:
                cases = json.loads(line)
                for c in cases["testcases"]:
                    target = '{}/projects/{}/cases'.format(target_url,
                                                           c['project_name'])
                    print(target)
                    post(target, c)
            except:
                print("useless data")
    add_case("functest", "tempest_custom")
    add_case("sdnvpn", "functest_testcase_4")
    add_case("sdnvpn", "functest_testcase_8")


def add_pod(name, mode):
    data = {
        "role": "",
        "name": name,
        "details": '',
        "mode": mode,
        "creation_date": "2017-2-23 11:23:03.765581"
    }
    pod_url = '{}/pods'.format(target_url)
    post(pod_url, data)


def add_case(project, case):
    data = {
        "project_name": project,
        "name": case,
    }
    case_url = '{}/projects/{}/cases'.format(target_url, project)
    post(case_url, data)


if __name__ == '__main__':
    pod()
    project()
    cases()