MON changes for Grafana Multitenancy feature.
[osm/MON.git] / osm_mon / core / common_db.py
1 # -*- coding: utf-8 -*-
2
3 # Copyright 2018 Whitestack, LLC
4 # *************************************************************
5
6 # This file is part of OSM Monitoring module
7 # All Rights Reserved to Whitestack, LLC
8
9 # Licensed under the Apache License, Version 2.0 (the "License"); you may
10 # not use this file except in compliance with the License. You may obtain
11 # a copy of the License at
12
13 # http://www.apache.org/licenses/LICENSE-2.0
14
15 # Unless required by applicable law or agreed to in writing, software
16 # distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
17 # WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
18 # License for the specific language governing permissions and limitations
19 # under the License.
20
21 # For those usages not covered by the Apache License, Version 2.0 please
22 # contact: bdiaz@whitestack.com or glavado@whitestack.com
23 ##
24 from typing import List
25
26 from osm_common import dbmongo, dbmemory
27
28 from osm_mon.core.config import Config
29 from osm_mon.core.models import Alarm
30
31
32 class CommonDbClient:
33 def __init__(self, config: Config):
34 if config.get('database', 'driver') == "mongo":
35 self.common_db = dbmongo.DbMongo()
36 elif config.get('database', 'driver') == "memory":
37 self.common_db = dbmemory.DbMemory()
38 else:
39 raise Exception("Unknown database driver {}".format(config.get('section', 'driver')))
40 self.common_db.db_connect(config.get("database"))
41
42 def get_vnfr(self, nsr_id: str, member_index: int):
43 vnfr = self.common_db.get_one("vnfrs",
44 {"nsr-id-ref": nsr_id, "member-vnf-index-ref": str(member_index)})
45 return vnfr
46
47 def get_vnfrs(self, nsr_id: str = None, vim_account_id: str = None):
48 if nsr_id and vim_account_id:
49 raise NotImplementedError("Only one filter is currently supported")
50 if nsr_id:
51 vnfrs = [self.get_vnfr(nsr_id, member['member-vnf-index']) for member in
52 self.get_nsr(nsr_id)['nsd']['constituent-vnfd']]
53 elif vim_account_id:
54 vnfrs = self.common_db.get_list("vnfrs",
55 {"vim-account-id": vim_account_id})
56 else:
57 vnfrs = self.common_db.get_list('vnfrs')
58 return vnfrs
59
60 def get_vnfd(self, vnfd_id: str):
61 vnfd = self.common_db.get_one("vnfds",
62 {"_id": vnfd_id})
63 return vnfd
64
65 def get_vnfd_by_id(self, vnfd_id: str):
66 vnfd = self.common_db.get_one("vnfds",
67 {"id": vnfd_id})
68 return vnfd
69
70 def get_vnfd_by_name(self, vnfd_name: str):
71 # TODO: optimize way of getting single VNFD in shared enviroments (RBAC)
72 if self.common_db.get_list("vnfds", {"name": vnfd_name}):
73 vnfd = self.common_db.get_list("vnfds", {"name": vnfd_name})[0]
74 return vnfd
75 else:
76 return None
77
78 def get_nsrs(self):
79 return self.common_db.get_list('nsrs')
80
81 def get_nsr(self, nsr_id: str):
82 nsr = self.common_db.get_one("nsrs",
83 {"id": nsr_id})
84 return nsr
85
86 def get_nslcmop(self, nslcmop_id):
87 nslcmop = self.common_db.get_one("nslcmops",
88 {"_id": nslcmop_id})
89 return nslcmop
90
91 def get_vdur(self, nsr_id, member_index, vdur_name):
92 vnfr = self.get_vnfr(nsr_id, member_index)
93 for vdur in vnfr['vdur']:
94 if vdur['name'] == vdur_name:
95 return vdur
96 raise ValueError('vdur not found for nsr-id {}, member_index {} and vdur_name {}'.format(nsr_id, member_index,
97 vdur_name))
98
99 def decrypt_vim_password(self, vim_password: str, schema_version: str, vim_id: str):
100 return self.common_db.decrypt(vim_password, schema_version, vim_id)
101
102 def decrypt_sdnc_password(self, sdnc_password: str, schema_version: str, sdnc_id: str):
103 return self.common_db.decrypt(sdnc_password, schema_version, sdnc_id)
104
105 def get_vim_account_id(self, nsr_id: str, vnf_member_index: int) -> str:
106 vnfr = self.get_vnfr(nsr_id, vnf_member_index)
107 return vnfr['vim-account-id']
108
109 def get_vim_accounts(self):
110 return self.common_db.get_list('vim_accounts')
111
112 def get_vim_account(self, vim_account_id: str) -> dict:
113 vim_account = self.common_db.get_one('vim_accounts', {"_id": vim_account_id})
114 vim_account['vim_password'] = self.decrypt_vim_password(vim_account['vim_password'],
115 vim_account['schema_version'],
116 vim_account_id)
117 vim_config_encrypted_dict = {
118 "1.1": ("admin_password", "nsx_password", "vcenter_password"),
119 "default": ("admin_password", "nsx_password", "vcenter_password", "vrops_password")
120 }
121 vim_config_encrypted = vim_config_encrypted_dict['default']
122 if vim_account['schema_version'] in vim_config_encrypted_dict.keys():
123 vim_config_encrypted = vim_config_encrypted_dict[vim_account['schema_version']]
124 if 'config' in vim_account:
125 for key in vim_account['config']:
126 if key in vim_config_encrypted:
127 vim_account['config'][key] = self.decrypt_vim_password(vim_account['config'][key],
128 vim_account['schema_version'],
129 vim_account_id)
130 return vim_account
131
132 def get_sdncs(self):
133 return self.common_db.get_list('sdns')
134
135 def get_sdnc(self, sdnc_id: str):
136 return self.common_db.get_one('sdns', {'_id': sdnc_id})
137
138 def get_projects(self):
139 return self.common_db.get_list('projects')
140
141 def get_project(self, project_id: str):
142 return self.common_db.get_one('projects', {'_id': project_id})
143
144 def create_alarm(self, alarm: Alarm):
145 return self.common_db.create('alarms', alarm.to_dict())
146
147 def delete_alarm(self, alarm_uuid: str):
148 return self.common_db.del_one('alarms', {'uuid': alarm_uuid})
149
150 def get_alarms(self) -> List[Alarm]:
151 alarms = []
152 alarm_dicts = self.common_db.get_list('alarms')
153 for alarm_dict in alarm_dicts:
154 alarms.append(Alarm.from_dict(alarm_dict))
155 return alarms
156
157 def get_user(self, username: str):
158 return self.common_db.get_one('users', {'username': username})
159
160 def get_user_by_id(self, userid: str):
161 return self.common_db.get_one('users', {'_id': userid})
162
163 def get_role_by_name(self, name: str):
164 return self.common_db.get_one('roles', {'name': name})