2 * ============LICENSE_START=======================================================
3 * ONAP : ccsdk features
4 * ================================================================================
5 * Copyright (C) 2019 highstreet technologies GmbH Intellectual Property.
7 * ================================================================================
8 * Licensed under the Apache License, Version 2.0 (the "License");
9 * you may not use this file except in compliance with the License.
10 * You may obtain a copy of the License at
12 * http://www.apache.org/licenses/LICENSE-2.0
14 * Unless required by applicable law or agreed to in writing, software
15 * distributed under the License is distributed on an "AS IS" BASIS,
16 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
17 * See the License for the specific language governing permissions and
18 * limitations under the License.
19 * ============LICENSE_END=========================================================
22 package org.onap.ccsdk.features.sdnr.wt.dataprovider.data;
24 import java.util.ArrayList;
25 import java.util.Arrays;
26 import java.util.Date;
27 import java.util.List;
29 import javax.annotation.Nonnull;
30 import org.eclipse.jdt.annotation.NonNull;
31 import org.eclipse.jdt.annotation.Nullable;
32 import org.onap.ccsdk.features.sdnr.wt.common.database.HtDatabaseClient;
33 import org.onap.ccsdk.features.sdnr.wt.common.database.queries.BoolQueryBuilder;
34 import org.onap.ccsdk.features.sdnr.wt.common.database.queries.QueryBuilder;
35 import org.onap.ccsdk.features.sdnr.wt.common.database.queries.QueryBuilders;
36 import org.onap.ccsdk.features.sdnr.wt.common.database.queries.RangeQueryBuilder;
37 import org.onap.ccsdk.features.sdnr.wt.dataprovider.database.EsDataObjectReaderWriter2;
38 import org.onap.ccsdk.features.sdnr.wt.dataprovider.model.ArchiveCleanProvider;
39 import org.onap.ccsdk.features.sdnr.wt.dataprovider.model.DataProvider;
40 import org.onap.ccsdk.features.sdnr.wt.dataprovider.model.NetconfTimeStamp;
41 import org.onap.ccsdk.features.sdnr.wt.dataprovider.model.types.NetconfTimeStampImpl;
42 import org.opendaylight.yang.gen.v1.urn.ietf.params.xml.ns.yang.ietf.yang.types.rev130715.DateAndTime;
43 import org.opendaylight.yang.gen.v1.urn.opendaylight.params.xml.ns.yang.data.provider.rev190801.ConnectionLogStatus;
44 import org.opendaylight.yang.gen.v1.urn.opendaylight.params.xml.ns.yang.data.provider.rev190801.ConnectionlogBuilder;
45 import org.opendaylight.yang.gen.v1.urn.opendaylight.params.xml.ns.yang.data.provider.rev190801.ConnectionlogEntity;
46 import org.opendaylight.yang.gen.v1.urn.opendaylight.params.xml.ns.yang.data.provider.rev190801.Entity;
47 import org.opendaylight.yang.gen.v1.urn.opendaylight.params.xml.ns.yang.data.provider.rev190801.EventlogBuilder;
48 import org.opendaylight.yang.gen.v1.urn.opendaylight.params.xml.ns.yang.data.provider.rev190801.EventlogEntity;
49 import org.opendaylight.yang.gen.v1.urn.opendaylight.params.xml.ns.yang.data.provider.rev190801.FaultcurrentBuilder;
50 import org.opendaylight.yang.gen.v1.urn.opendaylight.params.xml.ns.yang.data.provider.rev190801.FaultcurrentEntity;
51 import org.opendaylight.yang.gen.v1.urn.opendaylight.params.xml.ns.yang.data.provider.rev190801.FaultlogBuilder;
52 import org.opendaylight.yang.gen.v1.urn.opendaylight.params.xml.ns.yang.data.provider.rev190801.FaultlogEntity;
53 import org.opendaylight.yang.gen.v1.urn.opendaylight.params.xml.ns.yang.data.provider.rev190801.GranularityPeriodType;
54 import org.opendaylight.yang.gen.v1.urn.opendaylight.params.xml.ns.yang.data.provider.rev190801.Inventory;
55 import org.opendaylight.yang.gen.v1.urn.opendaylight.params.xml.ns.yang.data.provider.rev190801.InventoryBuilder;
56 import org.opendaylight.yang.gen.v1.urn.opendaylight.params.xml.ns.yang.data.provider.rev190801.InventoryEntity;
57 import org.opendaylight.yang.gen.v1.urn.opendaylight.params.xml.ns.yang.data.provider.rev190801.NetworkElementConnectionBuilder;
58 import org.opendaylight.yang.gen.v1.urn.opendaylight.params.xml.ns.yang.data.provider.rev190801.NetworkElementConnectionEntity;
59 import org.opendaylight.yang.gen.v1.urn.opendaylight.params.xml.ns.yang.data.provider.rev190801.PmdataEntity;
60 import org.opendaylight.yang.gen.v1.urn.opendaylight.params.xml.ns.yang.data.provider.rev190801.PmdataEntityBuilder;
61 import org.opendaylight.yang.gen.v1.urn.opendaylight.params.xml.ns.yang.data.provider.rev190801.UpdateNetworkElementConnectionInputBuilder;
62 import org.slf4j.Logger;
63 import org.slf4j.LoggerFactory;
66 * Event service, writing all events into the database into the appropriate index.
70 public class HtDatabaseEventsService implements ArchiveCleanProvider, DataProvider {
71 private static final Logger LOG = LoggerFactory.getLogger(HtDatabaseEventsService.class);
73 private static final NetconfTimeStamp NETCONFTIME_CONVERTER = NetconfTimeStampImpl.getConverter();
75 private HtDatabaseClient client;
76 private EsDataObjectReaderWriter2<EventlogEntity> eventRWEventLogDevicemanager;
77 private EsDataObjectReaderWriter2<InventoryEntity> eventRWEquipment;
78 private EsDataObjectReaderWriter2<FaultcurrentEntity> eventRWFaultCurrentDB;
79 private EsDataObjectReaderWriter2<FaultlogEntity> eventRWFaultLogDB;
80 private EsDataObjectReaderWriter2<ConnectionlogEntity> eventRWConnectionLogDB;
81 private final EsDataObjectReaderWriter2<NetworkElementConnectionEntity> networkelementConnectionDB;
82 private final EsDataObjectReaderWriter2<PmdataEntity> pmData15mDB;
83 private final EsDataObjectReaderWriter2<PmdataEntity> pmData24hDB;
85 @SuppressWarnings("unused")
86 private final ElasticSearchDataProvider dataProvider;
87 // --- Construct and initialize
90 public HtDatabaseEventsService(HtDatabaseClient client, ElasticSearchDataProvider elasticSearchDataProvider)
93 LOG.info("Create {} start", HtDatabaseEventsService.class);
94 this.dataProvider = elasticSearchDataProvider;
97 // Create control structure
100 eventRWEventLogDevicemanager = new EsDataObjectReaderWriter2<>(client, Entity.Eventlog,
101 EventlogEntity.class, EventlogBuilder.class);
103 eventRWEquipment = new EsDataObjectReaderWriter2<>(client, Entity.Inventoryequipment, InventoryEntity.class,
104 InventoryBuilder.class);
106 eventRWFaultCurrentDB = new EsDataObjectReaderWriter2<>(client, Entity.Faultcurrent,
107 FaultcurrentEntity.class, FaultcurrentBuilder.class);
109 eventRWFaultLogDB = new EsDataObjectReaderWriter2<>(client, Entity.Faultlog, FaultlogEntity.class,
110 FaultlogBuilder.class);
112 eventRWConnectionLogDB = new EsDataObjectReaderWriter2<>(client, Entity.Connectionlog,
113 ConnectionlogEntity.class, ConnectionlogBuilder.class);
115 networkelementConnectionDB = new EsDataObjectReaderWriter2<>(client, Entity.NetworkelementConnection,
116 NetworkElementConnectionEntity.class, NetworkElementConnectionBuilder.class)
117 .setEsIdAttributeName("_id");
119 pmData15mDB = new EsDataObjectReaderWriter2<>(client, Entity.Historicalperformance15min, PmdataEntity.class,
120 PmdataEntityBuilder.class);
122 pmData24hDB = new EsDataObjectReaderWriter2<>(client, Entity.Historicalperformance24h, PmdataEntity.class,
123 PmdataEntityBuilder.class);
125 } catch (Exception e) {
126 LOG.error("Can not start database client. Exception: {}", e);
127 throw new Exception("Can not start database client. Exception: {}", e);
129 LOG.info("Create {} finished. DB Service {} started.", HtDatabaseEventsService.class,
130 client != null ? "sucessfully" : "not");
137 public void writeConnectionLog(ConnectionlogEntity event) {
138 if (assertIfClientNull(event)) {
141 LOG.debug("Write event: {}", event);
142 eventRWConnectionLogDB.write(event, null);
148 public void writeEventLog(EventlogEntity event) {
149 if (assertIfClientNull("No client to write {}", event)) {
153 LOG.debug("Write event: {}", event.toString());
154 eventRWEventLogDevicemanager.write(event, null);
161 public void writeFaultLog(FaultlogEntity fault) {
162 if (assertIfClientNull(fault)) {
166 LOG.debug("Write fault to faultlog: {}", fault.toString());
167 eventRWFaultLogDB.write(fault, null);
173 public void updateFaultCurrent(FaultcurrentEntity fault) {
174 if (assertIfClientNull(fault)) {
178 if (FaultEntityManager.isManagedAsCurrentProblem(fault)) {
179 if (FaultEntityManager.isNoAlarmIndication(fault)) {
180 LOG.debug("Remove from currentFaults: {}", fault.toString());
181 eventRWFaultCurrentDB.remove(FaultEntityManager.genSpecificEsId(fault));
183 LOG.debug("Write to currentFaults: {}", fault.toString());
184 eventRWFaultCurrentDB.write(fault, FaultEntityManager.genSpecificEsId(fault));
187 LOG.debug("Ingnore for currentFaults: {}", fault.toString());
192 * Remove all entries for one node
194 * @param nodeName contains the mountpointname
195 * @return number of deleted entries
198 public int clearFaultsCurrentOfNode(String nodeName) {
199 if (assertIfClientNullForNodeName(nodeName)) {
203 LOG.debug("Remove from currentFaults all faults for node: {}", nodeName);
204 return eventRWFaultCurrentDB.remove(EsFaultCurrent.getQueryForOneNode(nodeName));
208 * Remove all entries for one node
210 * @param nodeName contains the mountpointname
211 * @param objectId of element to be deleted
212 * @return number of deleted entries
215 public int clearFaultsCurrentOfNodeWithObjectId(String nodeName, String objectId) {
216 if (assertIfClientNullForNodeName(nodeName)) {
220 LOG.debug("Remove from currentFaults all faults for node/objectId: {}/{}", nodeName, objectId);
221 return eventRWFaultCurrentDB.remove(EsFaultCurrent.getQueryForOneNodeAndObjectId(nodeName, objectId));
225 * Deliver list with all mountpoint/node-names in the database.
227 * @return List of all mountpoint/node-names the had active alarms.
230 public @Nonnull List<String> getAllNodesWithCurrentAlarms() {
231 if (assertIfClientNull("No DB, can not delete for all nodes", null)) {
232 return new ArrayList<>();
235 LOG.debug("Remove from currentFaults faults for all node");
236 List<String> nodeNames = new ArrayList<>();
238 for (FaultcurrentEntity fault : eventRWFaultCurrentDB.doReadAll().getHits()) {
239 String nodeName = fault.getNodeId();
240 if (!nodeNames.contains(nodeName)) {
241 // this.clearFaultsCurrentOfNode(nodeName); -> Function shifted
242 nodeNames.add(nodeName);
248 // -- Inventory and equipment current
251 * write internal equipment to database
253 * @param internalEquipment with mandatory fields.
256 public void writeInventory(Inventory internalEquipment) {
258 if (assertIfClientNullForNodeName(internalEquipment.getNodeId())) {
261 if (internalEquipment.getManufacturerIdentifier() == null) {
262 internalEquipment = new InventoryBuilder(internalEquipment).setManufacturerIdentifier("").build();
264 if (internalEquipment.getDate() == null) {
265 internalEquipment = new InventoryBuilder(internalEquipment).setDate("").build();
268 eventRWEquipment.write(internalEquipment, internalEquipment.getNodeId() + "/" + internalEquipment.getUuid());
276 * @param networkElementConnectionEntitiy to wirte to DB
277 * @param nodeId Id for this DB element
280 public void updateNetworkConnectionDeviceType(NetworkElementConnectionEntity networkElementConnectionEntitiy,
282 this.networkelementConnectionDB.update(networkElementConnectionEntitiy, nodeId);
286 * Update after new mountpoint registration
288 * @param networkElementConnectionEntitiy data
289 * @param nodeId of device (mountpoint name)
292 public void updateNetworkConnection22(NetworkElementConnectionEntity networkElementConnectionEntitiy,
294 this.networkelementConnectionDB.updateOrCreate(networkElementConnectionEntitiy, nodeId,
295 Arrays.asList("is-required", "username", "password"));
298 /* please do not remove */
299 // public void cleanNetworkElementConnections() {
300 // this.networkelementConnectionDB.remove(QueryBuilders.matchQuery("is-required", false));
301 // CreateNetworkElementConnectionInput x = new CreateNetworkElementConnectionInputBuilder().setStatus(ConnectionLogStatus.Disconnected).build();
302 // this.networkelementConnectionDB.update(x,QueryBuilders.matchAllQuery());
306 public void removeNetworkConnection(String nodeId) {
308 NetworkElementConnectionEntity e = this.networkelementConnectionDB.read(nodeId);
309 if (e != null && (isRequired = e.isIsRequired()) != null) {
311 LOG.debug("updating connection status for {} of required ne to disconnected", nodeId);
312 this.networkelementConnectionDB.update(new UpdateNetworkElementConnectionInputBuilder()
313 .setStatus(ConnectionLogStatus.Disconnected).build(), nodeId);
315 LOG.debug("remove networkelement-connection for {} entry because of non-required", nodeId);
316 this.networkelementConnectionDB.remove(nodeId);
319 LOG.warn("Unable to update connection-status. dbentry for {} not found in networkelement-connection",
327 public int doIndexClean(Date olderAreOutdated) {
329 String netconfTimeStamp = NETCONFTIME_CONVERTER.getTimeStampAsNetconfString(olderAreOutdated);
332 QueryBuilder queryEventBase = EsEventBase.getQueryForTimeStamp(netconfTimeStamp);
333 removed += eventRWEventLogDevicemanager.remove(queryEventBase);
335 QueryBuilder queryFaultLog = EsFaultLogDevicemanager.getQueryForTimeStamp(netconfTimeStamp);
336 removed += eventRWFaultLogDB.remove(queryFaultLog);
341 public int getNumberOfOldObjects(Date olderAreOutdated) {
343 String netconfTimeStamp = NETCONFTIME_CONVERTER.getTimeStampAsNetconfString(olderAreOutdated);
344 int numberOfElements = 0;
346 QueryBuilder queryEventBase = EsEventBase.getQueryForTimeStamp(netconfTimeStamp);
347 numberOfElements += eventRWEventLogDevicemanager.doReadAll(queryEventBase).getTotal();
349 QueryBuilder queryFaultLog = EsFaultLogDevicemanager.getQueryForTimeStamp(netconfTimeStamp);
350 numberOfElements += eventRWFaultLogDB.doReadAll(queryFaultLog).getTotal();
352 return numberOfElements;
358 * Verify status of client
360 * @param event that is printed with message
361 * @return true if client is null
363 private boolean assertIfClientNull(Object event) {
364 return assertIfClientNull("No DB, can not write: {}", event);
367 private boolean assertIfClientNullForNodeName(Object object) {
368 return assertIfClientNull("No DB, can not handle node: {}", object);
372 * Verify status of client
374 * @param message to print including {} for object printout.
375 * @return true if client is null
377 private boolean assertIfClientNull(String message, Object object) {
378 if (client == null) {
379 LOG.debug(message, object);
388 private static class EsEventBase {
390 * Query to get older Elements
392 * @param netconfTimeStamp to identify older Elements
393 * @return QueryBuilder for older elements related to timestamp
395 private static QueryBuilder getQueryForTimeStamp(String netconfTimeStamp) {
396 return new RangeQueryBuilder("timestamp").lte(netconfTimeStamp);
399 private static class EsFaultLogDevicemanager {
403 * @param netconfTimeStamp to identify query elements older than this timestamp.
404 * @return QueryBuilder for related elements
406 public static QueryBuilder getQueryForTimeStamp(String netconfTimeStamp) {
407 return new RangeQueryBuilder("timestamp").lte(netconfTimeStamp);
410 public static class EsFaultCurrent {
412 * @param nodeName name of the node
413 * @return query builder
415 public static QueryBuilder getQueryForOneNode(String nodeName) {
416 return QueryBuilders.matchQuery("node-id", nodeName);
419 public static QueryBuilder getQueryForOneNodeAndObjectId(String nodeName, String objectId) {
420 BoolQueryBuilder bq = QueryBuilders.boolQuery();
421 bq.must(QueryBuilders.matchQuery("node-id", nodeName));
422 bq.must(QueryBuilders.matchQuery("object-id", objectId));
428 public List<NetworkElementConnectionEntity> getNetworkElementConnections() {
429 return this.networkelementConnectionDB.doReadAll().getHits();
433 public void doWritePerformanceData(List<PmdataEntity> list) {
435 list.forEach(elem -> {
436 GranularityPeriodType granularityPeriod = nnGetGranularityPeriodType(elem.getGranularityPeriod());
437 //_id": "Sim12600/LP-MWPS-TTP-01/2017-07-04T15:15:00.0+00:00"
438 StringBuffer id = new StringBuffer();
439 DateAndTime date = elem.getTimeStamp();
440 id.append(elem.getNodeName());
442 id.append(elem.getUuidInterface());
444 id.append(date != null ? date.getValue() : "null");
446 switch (granularityPeriod) {
448 pmData15mDB.write(elem, id.toString());
451 pmData24hDB.write(elem, id.toString());
455 LOG.debug("Unknown granularity {} id {}", granularityPeriod, id);
463 GranularityPeriodType nnGetGranularityPeriodType(@Nullable GranularityPeriodType granularityPeriod) {
464 return granularityPeriod != null ? granularityPeriod : GranularityPeriodType.Unknown;
468 public HtDatabaseClient getRawClient() {