summaryrefslogtreecommitdiffstats
path: root/SdncReports/SdncReportsDao
diff options
context:
space:
mode:
Diffstat (limited to 'SdncReports/SdncReportsDao')
-rw-r--r--SdncReports/SdncReportsDao/pom.xml65
-rw-r--r--SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/model/CertificationInputs.java35
-rw-r--r--SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/model/DeviceConfig.java92
-rw-r--r--SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/model/Input.java53
-rw-r--r--SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/model/ODLClientResponse.java34
-rw-r--r--SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/model/Output.java101
-rw-r--r--SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/model/PreTestConfig.java120
-rw-r--r--SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/model/PreTestResponse.java85
-rw-r--r--SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/model/Request.java43
-rw-r--r--SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/model/Response.java39
-rw-r--r--SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/model/ValidationTestType.java47
-rw-r--r--SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/model/Vnf.java47
-rw-r--r--SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/model/VnfList.java54
-rw-r--r--SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/repository/DeviceRepository.java43
-rw-r--r--SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/repository/PreTestConfigRepository.java48
-rw-r--r--SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/rest/model/ConfigDetailsRestModel.java51
-rw-r--r--SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/rest/model/JSONTags.java55
-rw-r--r--SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/rest/model/PreTestModel.java113
-rw-r--r--SdncReports/SdncReportsDao/src/main/resources/application.properties11
-rw-r--r--SdncReports/SdncReportsDao/src/test/resources/application.properties17
20 files changed, 1153 insertions, 0 deletions
diff --git a/SdncReports/SdncReportsDao/pom.xml b/SdncReports/SdncReportsDao/pom.xml
new file mode 100644
index 00000000..5e6afa16
--- /dev/null
+++ b/SdncReports/SdncReportsDao/pom.xml
@@ -0,0 +1,65 @@
+<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
+ <modelVersion>4.0.0</modelVersion>
+ <artifactId>SdncReportsDao</artifactId>
+ <packaging>jar</packaging>
+
+ <parent>
+ <groupId>org.onap.ccsdk.parent</groupId>
+ <artifactId>SdncReports</artifactId>
+ <version>0.0.1-SNAPSHOT</version>
+ </parent>
+
+ <dependencies>
+ <dependency>
+ <groupId>org.springframework</groupId>
+ <artifactId>spring-context</artifactId>
+ </dependency>
+
+ <dependency>
+ <groupId>org.springframework.boot</groupId>
+ <artifactId>spring-boot-starter-test</artifactId>
+ <scope>test</scope>
+ <version>1.5.3.RELEASE</version>
+ </dependency>
+
+ <dependency>
+ <groupId>org.springframework.boot</groupId>
+ <artifactId>spring-boot-starter-data-jpa</artifactId>
+ <exclusions>
+ <exclusion>
+ <groupId>org.hibernate</groupId>
+ <artifactId>hibernate-entitymanager</artifactId>
+ </exclusion>
+ </exclusions>
+
+ </dependency>
+
+ <dependency>
+ <groupId>mysql</groupId>
+ <artifactId>mysql-connector-java</artifactId>
+ <scope>runtime</scope>
+ </dependency>
+
+ <!-- <dependency>
+ <groupId>org.springframework.boot</groupId>
+ <artifactId>spring-boot-starter-tomcat</artifactId>
+ <scope>provided</scope>
+ </dependency> -->
+
+ <dependency>
+ <groupId>com.fasterxml.jackson.core</groupId>
+ <artifactId>jackson-annotations</artifactId>
+ </dependency>
+
+ <!-- <dependency>
+ <groupId>org.hibernate.javax.persistence</groupId>
+ <artifactId>hibernate-jpa-2.0-api</artifactId>
+ <version>1.0.1.Final</version>
+ </dependency> -->
+ <dependency>
+ <groupId>org.mariadb.jdbc</groupId>
+ <artifactId>mariadb-java-client</artifactId>
+ <version>1.1.7</version>
+</dependency>
+ </dependencies>
+</project> \ No newline at end of file
diff --git a/SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/model/CertificationInputs.java b/SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/model/CertificationInputs.java
new file mode 100644
index 00000000..d8952fc4
--- /dev/null
+++ b/SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/model/CertificationInputs.java
@@ -0,0 +1,35 @@
+/*
+* ============LICENSE_START=======================================================
+* ONAP : SDNC-FEATURES
+* ================================================================================
+* Copyright 2018 TechMahindra
+*=================================================================================
+* Licensed under the Apache License, Version 2.0 (the "License");
+* you may not use this file except in compliance with the License.
+* You may obtain a copy of the License at
+*
+* http://www.apache.org/licenses/LICENSE-2.0
+*
+* Unless required by applicable law or agreed to in writing, software
+* distributed under the License is distributed on an "AS IS" BASIS,
+* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+* See the License for the specific language governing permissions and
+* limitations under the License.
+* ============LICENSE_END=========================================================
+*/
+package com.onap.sdnc.reports.model;
+
+public class CertificationInputs {
+
+ private Input input;
+
+ public Input getInput ()
+ {
+ return input;
+ }
+
+ public void setInput (Input input)
+ {
+ this.input = input;
+ }
+}
diff --git a/SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/model/DeviceConfig.java b/SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/model/DeviceConfig.java
new file mode 100644
index 00000000..2a999e2e
--- /dev/null
+++ b/SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/model/DeviceConfig.java
@@ -0,0 +1,92 @@
+/*
+* ============LICENSE_START=======================================================
+* ONAP : SDNC-FEATURES
+* ================================================================================
+* Copyright 2018 TechMahindra
+*=================================================================================
+* Licensed under the Apache License, Version 2.0 (the "License");
+* you may not use this file except in compliance with the License.
+* You may obtain a copy of the License at
+*
+* http://www.apache.org/licenses/LICENSE-2.0
+*
+* Unless required by applicable law or agreed to in writing, software
+* distributed under the License is distributed on an "AS IS" BASIS,
+* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+* See the License for the specific language governing permissions and
+* limitations under the License.
+* ============LICENSE_END=========================================================
+*/
+package com.onap.sdnc.reports.model;
+
+import java.io.Serializable;
+import java.util.Set;
+
+import javax.persistence.Column;
+import javax.persistence.Entity;
+import javax.persistence.GeneratedValue;
+import javax.persistence.GenerationType;
+import javax.persistence.Id;
+import javax.persistence.OneToMany;
+import javax.persistence.Table;
+
+@Entity
+@Table(name = "deviceconfig")
+public class DeviceConfig implements Serializable
+{
+ private static final long serialVersionUID = -3009157732242241606L;
+ @Id
+ @GeneratedValue(strategy = GenerationType.AUTO)
+ @Column(name = "deviceid")
+ private long id;
+
+ @Column(name = "deviceIP")
+ private String deviceIP;
+
+ @Column(name = "createdon")
+ private String createdon;
+
+ @OneToMany(mappedBy="device")
+ private Set<PreTestConfig> preTestConfig;
+
+ public DeviceConfig() {
+ }
+
+ public long getId() {
+ return id;
+ }
+
+ public void setId(long id) {
+ this.id = id;
+ }
+
+ public String getCreationDate() {
+ return createdon;
+ }
+
+ public void setCreationDate(String creationDate) {
+ this.createdon = creationDate;
+ }
+
+ public Set<PreTestConfig> getPreTestConfig() {
+ return preTestConfig;
+ }
+
+ public void setPreTestConfig(Set<PreTestConfig> preTestConfig) {
+ this.preTestConfig = preTestConfig;
+ }
+
+ public String getDeviceIP() {
+ return deviceIP;
+ }
+
+ public void setDeviceIP(String deviceIP) {
+ this.deviceIP = deviceIP;
+ }
+
+ @Override
+ public String toString() {
+ return "DeviceConfig [id=" + id + ", deviceName=" + ", createdon=" + createdon
+ + ", deviceIP=" + deviceIP + "]";
+ }
+}
diff --git a/SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/model/Input.java b/SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/model/Input.java
new file mode 100644
index 00000000..7a49034e
--- /dev/null
+++ b/SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/model/Input.java
@@ -0,0 +1,53 @@
+/*
+* ============LICENSE_START=======================================================
+* ONAP : SDNC-FEATURES
+* ================================================================================
+* Copyright 2018 TechMahindra
+*=================================================================================
+* Licensed under the Apache License, Version 2.0 (the "License");
+* you may not use this file except in compliance with the License.
+* You may obtain a copy of the License at
+*
+* http://www.apache.org/licenses/LICENSE-2.0
+*
+* Unless required by applicable law or agreed to in writing, software
+* distributed under the License is distributed on an "AS IS" BASIS,
+* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+* See the License for the specific language governing permissions and
+* limitations under the License.
+* ============LICENSE_END=========================================================
+*/
+package com.onap.sdnc.reports.model;
+
+public class Input {
+
+ private String ipaddress;
+ private String hostname;
+ private String network;
+
+ public String getHostname() {
+ return hostname;
+ }
+
+ public void setHostname(String hostname) {
+ this.hostname = hostname;
+ }
+
+ public String getIpaddress ()
+ {
+ return ipaddress;
+ }
+
+ public void setIpaddress (String ipaddress)
+ {
+ this.ipaddress = ipaddress;
+ }
+
+ public String getNetwork() {
+ return network;
+ }
+
+ public void setNetwork(String network) {
+ this.network = network;
+ }
+}
diff --git a/SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/model/ODLClientResponse.java b/SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/model/ODLClientResponse.java
new file mode 100644
index 00000000..999059df
--- /dev/null
+++ b/SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/model/ODLClientResponse.java
@@ -0,0 +1,34 @@
+/*
+* ============LICENSE_START=======================================================
+* ONAP : SDNC-FEATURES
+* ================================================================================
+* Copyright 2018 TechMahindra
+*=================================================================================
+* Licensed under the Apache License, Version 2.0 (the "License");
+* you may not use this file except in compliance with the License.
+* You may obtain a copy of the License at
+*
+* http://www.apache.org/licenses/LICENSE-2.0
+*
+* Unless required by applicable law or agreed to in writing, software
+* distributed under the License is distributed on an "AS IS" BASIS,
+* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+* See the License for the specific language governing permissions and
+* limitations under the License.
+* ============LICENSE_END=========================================================
+*/
+package com.onap.sdnc.reports.model;
+
+public class ODLClientResponse {
+ private Output output;
+
+ public Output getOutput ()
+ {
+ return output;
+ }
+
+ public void setOutput (Output output)
+ {
+ this.output = output;
+ }
+}
diff --git a/SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/model/Output.java b/SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/model/Output.java
new file mode 100644
index 00000000..3cc09324
--- /dev/null
+++ b/SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/model/Output.java
@@ -0,0 +1,101 @@
+/*
+* ============LICENSE_START=======================================================
+* ONAP : SDNC-FEATURES
+* ================================================================================
+* Copyright 2018 TechMahindra
+*=================================================================================
+* Licensed under the Apache License, Version 2.0 (the "License");
+* you may not use this file except in compliance with the License.
+* You may obtain a copy of the License at
+*
+* http://www.apache.org/licenses/LICENSE-2.0
+*
+* Unless required by applicable law or agreed to in writing, software
+* distributed under the License is distributed on an "AS IS" BASIS,
+* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+* See the License for the specific language governing permissions and
+* limitations under the License.
+* ============LICENSE_END=========================================================
+*/
+package com.onap.sdnc.reports.model;
+
+public class Output {
+
+ private String status;
+
+ private String testresult;
+
+ private String hostname;
+
+ private String ipaddress;
+
+ private String statistics;
+
+ private String avgTime;
+
+ private String reason;
+
+ public String getStatus ()
+ {
+ return status;
+ }
+
+ public String getStatistics() {
+ return statistics;
+ }
+
+ public void setStatistics(String statistics) {
+ this.statistics = statistics;
+ }
+
+ public void setStatus (String status)
+ {
+ this.status = status;
+ }
+
+ public String getTestresult ()
+ {
+ return testresult;
+ }
+
+ public void setTestresult (String testresult)
+ {
+ this.testresult = testresult;
+ }
+
+ public String getHostname ()
+ {
+ return hostname;
+ }
+
+ public void setHostname (String hostname)
+ {
+ this.hostname = hostname;
+ }
+
+ public String getIpaddress ()
+ {
+ return ipaddress;
+ }
+
+ public void setIpaddress (String ipaddress)
+ {
+ this.ipaddress = ipaddress;
+ }
+
+ public String getAvgTime() {
+ return avgTime;
+ }
+
+ public void setAvgTime(String avgTime) {
+ this.avgTime = avgTime;
+ }
+
+ public String getReason() {
+ return reason;
+ }
+
+ public void setReason(String reason) {
+ this.reason = reason;
+ }
+}
diff --git a/SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/model/PreTestConfig.java b/SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/model/PreTestConfig.java
new file mode 100644
index 00000000..672a6f2b
--- /dev/null
+++ b/SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/model/PreTestConfig.java
@@ -0,0 +1,120 @@
+/*
+* ============LICENSE_START=======================================================
+* ONAP : SDNC-FEATURES
+* ================================================================================
+* Copyright 2018 TechMahindra
+*=================================================================================
+* Licensed under the Apache License, Version 2.0 (the "License");
+* you may not use this file except in compliance with the License.
+* You may obtain a copy of the License at
+*
+* http://www.apache.org/licenses/LICENSE-2.0
+*
+* Unless required by applicable law or agreed to in writing, software
+* distributed under the License is distributed on an "AS IS" BASIS,
+* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+* See the License for the specific language governing permissions and
+* limitations under the License.
+* ============LICENSE_END=========================================================
+*/
+package com.onap.sdnc.reports.model;
+
+import java.io.Serializable;
+import java.util.Date;
+
+import javax.persistence.Column;
+import javax.persistence.Entity;
+import javax.persistence.GeneratedValue;
+import javax.persistence.GenerationType;
+import javax.persistence.Id;
+import javax.persistence.JoinColumn;
+import javax.persistence.ManyToOne;
+import javax.persistence.Table;
+import javax.persistence.Temporal;
+import javax.persistence.TemporalType;
+
+@Entity
+@Table(name = "pretestconfig")
+public class PreTestConfig implements Serializable{
+
+ private static final long serialVersionUID = -3009157732242241606L;
+ @Id
+ @GeneratedValue(strategy = GenerationType.AUTO)
+ @Column(name = "testid")
+ private long testId ;
+
+ @Column(name = "testname")
+ private String testName;
+
+ @Column(name = "result")
+ private String result;
+
+ @Column(name = "execuationdetails")
+ private String execuationDetails;
+
+ @Column(name = "timestamp")
+ @Temporal(TemporalType.DATE)
+ private Date timestamp;
+
+ @ManyToOne
+ @JoinColumn(name="deviceid",nullable=false)
+ private DeviceConfig device;
+
+ public PreTestConfig()
+ {
+ }
+
+ public long getTestId() {
+ return testId;
+ }
+
+ public void setTestId(long testId) {
+ this.testId = testId;
+ }
+
+ public String getTestName() {
+ return testName;
+ }
+
+ public void setTestName(String testName) {
+ this.testName = testName;
+ }
+
+ public DeviceConfig getDevice() {
+ return device;
+ }
+
+ public void setDevice(DeviceConfig device) {
+ this.device = device;
+ }
+
+ public String getResult() {
+ return result;
+ }
+
+ public void setResult(String result) {
+ this.result = result;
+ }
+
+ public String getExecuationDetails() {
+ return execuationDetails;
+ }
+
+ public void setExecuationDetails(String execuationDetails) {
+ this.execuationDetails = execuationDetails;
+ }
+
+ public Date getTimestamp() {
+ return timestamp;
+ }
+
+ public void setTimestamp(Date timestamp) {
+ this.timestamp = timestamp;
+ }
+
+ @Override
+ public String toString() {
+ return "PreTestConfig [testId=" + testId + ", testName=" + testName + ", result=" + result
+ + ", execuationDetails=" + execuationDetails + ", timestamp=" + timestamp + ", device=" + device + "]";
+ }
+}
diff --git a/SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/model/PreTestResponse.java b/SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/model/PreTestResponse.java
new file mode 100644
index 00000000..a2349e7d
--- /dev/null
+++ b/SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/model/PreTestResponse.java
@@ -0,0 +1,85 @@
+/*
+* ============LICENSE_START=======================================================
+* ONAP : SDNC-FEATURES
+* ================================================================================
+* Copyright 2018 TechMahindra
+*=================================================================================
+* Licensed under the Apache License, Version 2.0 (the "License");
+* you may not use this file except in compliance with the License.
+* You may obtain a copy of the License at
+*
+* http://www.apache.org/licenses/LICENSE-2.0
+*
+* Unless required by applicable law or agreed to in writing, software
+* distributed under the License is distributed on an "AS IS" BASIS,
+* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+* See the License for the specific language governing permissions and
+* limitations under the License.
+* ============LICENSE_END=========================================================
+*/
+package com.onap.sdnc.reports.model;
+
+import com.fasterxml.jackson.annotation.JsonInclude;
+
+@JsonInclude(JsonInclude.Include.NON_NULL)
+public class PreTestResponse {
+
+ private String ipaddress;
+ private String status;
+ private String testtype;
+ private String statistics;
+ private String avgTime;
+ private String hostname;
+
+ public PreTestResponse() {
+
+ }
+
+ public String getStatus() {
+ return status;
+ }
+
+ public void setStatus(String status) {
+ this.status = status;
+ }
+
+ public String getIpaddress() {
+ return ipaddress;
+ }
+
+ public void setIpaddress(String ipaddress) {
+ this.ipaddress = ipaddress;
+ }
+
+ public String getTesttype() {
+ return testtype;
+ }
+
+ public void setTesttype(String testtype) {
+ this.testtype = testtype;
+ }
+
+ public String getStatistics() {
+ return statistics;
+ }
+
+ public void setStatistics(String statistics) {
+ this.statistics = statistics;
+ }
+
+ public String getAvgTime() {
+ return avgTime;
+ }
+
+ public void setAvgTime(String avgTime) {
+ this.avgTime = avgTime;
+ }
+
+ public String getHostname() {
+ return hostname;
+ }
+
+ public void setHostname(String hostname) {
+ this.hostname = hostname;
+ }
+}
diff --git a/SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/model/Request.java b/SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/model/Request.java
new file mode 100644
index 00000000..e934a4c9
--- /dev/null
+++ b/SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/model/Request.java
@@ -0,0 +1,43 @@
+/*
+* ============LICENSE_START=======================================================
+* ONAP : SDNC-FEATURES
+* ================================================================================
+* Copyright 2018 TechMahindra
+*=================================================================================
+* Licensed under the Apache License, Version 2.0 (the "License");
+* you may not use this file except in compliance with the License.
+* You may obtain a copy of the License at
+*
+* http://www.apache.org/licenses/LICENSE-2.0
+*
+* Unless required by applicable law or agreed to in writing, software
+* distributed under the License is distributed on an "AS IS" BASIS,
+* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+* See the License for the specific language governing permissions and
+* limitations under the License.
+* ============LICENSE_END=========================================================
+*/
+package com.onap.sdnc.reports.model;
+
+public class Request {
+
+ private VnfList[] vnfList;
+
+ private ValidationTestType[] validationTestType;
+
+ public VnfList[] getVnfList() {
+ return vnfList;
+ }
+
+ public void setVnfList(VnfList[] vnfList) {
+ this.vnfList = vnfList;
+ }
+
+ public ValidationTestType[] getValidationTestType() {
+ return validationTestType;
+ }
+
+ public void setValidationTestType(ValidationTestType[] validationTestType) {
+ this.validationTestType = validationTestType;
+ }
+}
diff --git a/SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/model/Response.java b/SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/model/Response.java
new file mode 100644
index 00000000..e773212e
--- /dev/null
+++ b/SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/model/Response.java
@@ -0,0 +1,39 @@
+/*
+* ============LICENSE_START=======================================================
+* ONAP : SDNC-FEATURES
+* ================================================================================
+* Copyright 2018 TechMahindra
+*=================================================================================
+* Licensed under the Apache License, Version 2.0 (the "License");
+* you may not use this file except in compliance with the License.
+* You may obtain a copy of the License at
+*
+* http://www.apache.org/licenses/LICENSE-2.0
+*
+* Unless required by applicable law or agreed to in writing, software
+* distributed under the License is distributed on an "AS IS" BASIS,
+* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+* See the License for the specific language governing permissions and
+* limitations under the License.
+* ============LICENSE_END=========================================================
+*/
+package com.onap.sdnc.reports.model;
+
+import java.util.List;
+
+import com.fasterxml.jackson.annotation.JsonInclude;
+
+@JsonInclude(JsonInclude.Include.NON_NULL)
+public class Response {
+
+ private List<PreTestResponse> preTestResponse;
+
+ public List<PreTestResponse> getPreTestResponse() {
+ return preTestResponse;
+ }
+
+ public void setPreTestResponse(List<PreTestResponse> preTestResponse) {
+ this.preTestResponse = preTestResponse;
+ }
+
+}
diff --git a/SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/model/ValidationTestType.java b/SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/model/ValidationTestType.java
new file mode 100644
index 00000000..9d6c987b
--- /dev/null
+++ b/SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/model/ValidationTestType.java
@@ -0,0 +1,47 @@
+/*
+* ============LICENSE_START=======================================================
+* ONAP : SDNC-FEATURES
+* ================================================================================
+* Copyright 2018 TechMahindra
+*=================================================================================
+* Licensed under the Apache License, Version 2.0 (the "License");
+* you may not use this file except in compliance with the License.
+* You may obtain a copy of the License at
+*
+* http://www.apache.org/licenses/LICENSE-2.0
+*
+* Unless required by applicable law or agreed to in writing, software
+* distributed under the License is distributed on an "AS IS" BASIS,
+* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+* See the License for the specific language governing permissions and
+* limitations under the License.
+* ============LICENSE_END=========================================================
+*/
+package com.onap.sdnc.reports.model;
+
+public class ValidationTestType
+{
+ private String validationType;
+
+ private String typeId;
+
+ public String getValidationType ()
+ {
+ return validationType;
+ }
+
+ public void setValidationType (String validationType)
+ {
+ this.validationType = validationType;
+ }
+
+ public String getTypeId ()
+ {
+ return typeId;
+ }
+
+ public void setTypeId (String typeId)
+ {
+ this.typeId = typeId;
+ }
+}
diff --git a/SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/model/Vnf.java b/SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/model/Vnf.java
new file mode 100644
index 00000000..b7eb4566
--- /dev/null
+++ b/SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/model/Vnf.java
@@ -0,0 +1,47 @@
+/*
+* ============LICENSE_START=======================================================
+* ONAP : SDNC-FEATURES
+* ================================================================================
+* Copyright 2018 TechMahindra
+*=================================================================================
+* Licensed under the Apache License, Version 2.0 (the "License");
+* you may not use this file except in compliance with the License.
+* You may obtain a copy of the License at
+*
+* http://www.apache.org/licenses/LICENSE-2.0
+*
+* Unless required by applicable law or agreed to in writing, software
+* distributed under the License is distributed on an "AS IS" BASIS,
+* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+* See the License for the specific language governing permissions and
+* limitations under the License.
+* ============LICENSE_END=========================================================
+*/
+package com.onap.sdnc.reports.model;
+
+public class Vnf {
+
+ private VnfList[] vnfList;
+
+ private ValidationTestType[] validationTestType;
+
+ public VnfList[] getVnfList ()
+ {
+ return vnfList;
+ }
+
+ public void setVnfList (VnfList[] vnfList)
+ {
+ this.vnfList = vnfList;
+ }
+
+ public ValidationTestType[] getValidationTestType ()
+ {
+ return validationTestType;
+ }
+
+ public void setValidationTestType (ValidationTestType[] validationTestType)
+ {
+ this.validationTestType = validationTestType;
+ }
+}
diff --git a/SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/model/VnfList.java b/SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/model/VnfList.java
new file mode 100644
index 00000000..09bf2eb2
--- /dev/null
+++ b/SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/model/VnfList.java
@@ -0,0 +1,54 @@
+/*
+* ============LICENSE_START=======================================================
+* ONAP : SDNC-FEATURES
+* ================================================================================
+* Copyright 2018 TechMahindra
+*=================================================================================
+* Licensed under the Apache License, Version 2.0 (the "License");
+* you may not use this file except in compliance with the License.
+* You may obtain a copy of the License at
+*
+* http://www.apache.org/licenses/LICENSE-2.0
+*
+* Unless required by applicable law or agreed to in writing, software
+* distributed under the License is distributed on an "AS IS" BASIS,
+* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+* See the License for the specific language governing permissions and
+* limitations under the License.
+* ============LICENSE_END=========================================================
+*/
+package com.onap.sdnc.reports.model;
+
+public class VnfList<List> {
+
+ private String portNo;
+
+ private String ipAddress;
+
+ private String hostName;
+
+ public String getPortNo() {
+ return portNo;
+ }
+
+ public void setPortNo(String portNo) {
+ this.portNo = portNo;
+ }
+
+ public String getIpAddress() {
+ return ipAddress;
+ }
+
+ public void setIpAddress(String ipAddress) {
+ this.ipAddress = ipAddress;
+ }
+
+ public String getHostName() {
+ return hostName;
+ }
+
+ public void setHostName(String hostName) {
+ this.hostName = hostName;
+ }
+
+}
diff --git a/SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/repository/DeviceRepository.java b/SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/repository/DeviceRepository.java
new file mode 100644
index 00000000..9a33bad3
--- /dev/null
+++ b/SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/repository/DeviceRepository.java
@@ -0,0 +1,43 @@
+/*
+* ============LICENSE_START=======================================================
+* ONAP : SDNC-FEATURES
+* ================================================================================
+* Copyright 2018 TechMahindra
+*=================================================================================
+* Licensed under the Apache License, Version 2.0 (the "License");
+* you may not use this file except in compliance with the License.
+* You may obtain a copy of the License at
+*
+* http://www.apache.org/licenses/LICENSE-2.0
+*
+* Unless required by applicable law or agreed to in writing, software
+* distributed under the License is distributed on an "AS IS" BASIS,
+* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+* See the License for the specific language governing permissions and
+* limitations under the License.
+* ============LICENSE_END=========================================================
+*/
+package com.onap.sdnc.reports.repository;
+
+import javax.transaction.Transactional;
+
+import org.springframework.data.jpa.repository.JpaRepository;
+import org.springframework.data.jpa.repository.Modifying;
+import org.springframework.data.jpa.repository.Query;
+import org.springframework.data.repository.query.Param;
+import org.springframework.stereotype.Repository;
+
+import com.onap.sdnc.reports.model.DeviceConfig;
+
+
+@Repository
+public interface DeviceRepository extends JpaRepository<DeviceConfig, Long> {
+
+ @Query(value= "from DeviceConfig where deviceIP = :deviceIP" )
+ DeviceConfig findDeviceIP(@Param("deviceIP") String deviceIP);
+
+ @Modifying
+ @Query(value = "insert into DeviceConfig (deviceIP,createdOn) VALUES (:deviceIP,:createdOn)", nativeQuery = true)
+ @Transactional
+ void logDeviceName(@Param("deviceIP") String deviceIP, @Param("createdOn") String createdOn);
+}
diff --git a/SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/repository/PreTestConfigRepository.java b/SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/repository/PreTestConfigRepository.java
new file mode 100644
index 00000000..7c860429
--- /dev/null
+++ b/SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/repository/PreTestConfigRepository.java
@@ -0,0 +1,48 @@
+/*
+* ============LICENSE_START=======================================================
+* ONAP : SDNC-FEATURES
+* ================================================================================
+* Copyright 2018 TechMahindra
+*=================================================================================
+* Licensed under the Apache License, Version 2.0 (the "License");
+* you may not use this file except in compliance with the License.
+* You may obtain a copy of the License at
+*
+* http://www.apache.org/licenses/LICENSE-2.0
+*
+* Unless required by applicable law or agreed to in writing, software
+* distributed under the License is distributed on an "AS IS" BASIS,
+* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+* See the License for the specific language governing permissions and
+* limitations under the License.
+* ============LICENSE_END=========================================================
+*/
+package com.onap.sdnc.reports.repository;
+
+import java.util.Date;
+
+import java.util.List;
+
+import javax.transaction.Transactional;
+
+import org.springframework.data.jpa.repository.JpaRepository;
+import org.springframework.data.jpa.repository.Modifying;
+import org.springframework.data.jpa.repository.Query;
+import org.springframework.data.jpa.repository.config.EnableJpaRepositories;
+import org.springframework.data.repository.query.Param;
+import org.springframework.stereotype.Repository;
+
+import com.onap.sdnc.reports.model.PreTestConfig;
+
+
+@Repository
+public interface PreTestConfigRepository extends JpaRepository<PreTestConfig, Long> {
+
+ @Query(value= " from PreTestConfig where timestamp >= :startDate and timestamp <= :endDate and device.deviceIP = :deviceIP" )
+ List<PreTestConfig> findReportByDeviceIP(@Param("startDate") Date startDate, @Param("endDate")Date endDate, @Param("deviceIP")String deviceIP);
+
+ @Modifying
+ @Query(value = "insert into PreTestConfig (testName,result,execuationDetails,timestamp,deviceId) VALUES (:testName,:result,:execuationDetails,:timestamp,:deviceId)", nativeQuery = true)
+ @Transactional
+ void logPreTestReport(@Param("testName") String testName,@Param("result") String result, @Param("execuationDetails") String execuationDetails,@Param("timestamp") String timestamp,@Param("deviceId") long deviceId);
+}
diff --git a/SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/rest/model/ConfigDetailsRestModel.java b/SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/rest/model/ConfigDetailsRestModel.java
new file mode 100644
index 00000000..143e7263
--- /dev/null
+++ b/SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/rest/model/ConfigDetailsRestModel.java
@@ -0,0 +1,51 @@
+/*
+* ============LICENSE_START=======================================================
+* ONAP : SDNC-FEATURES
+* ================================================================================
+* Copyright 2018 TechMahindra
+*=================================================================================
+* Licensed under the Apache License, Version 2.0 (the "License");
+* you may not use this file except in compliance with the License.
+* You may obtain a copy of the License at
+*
+* http://www.apache.org/licenses/LICENSE-2.0
+*
+* Unless required by applicable law or agreed to in writing, software
+* distributed under the License is distributed on an "AS IS" BASIS,
+* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+* See the License for the specific language governing permissions and
+* limitations under the License.
+* ============LICENSE_END=========================================================
+*/
+package com.onap.sdnc.reports.rest.model;
+
+import com.fasterxml.jackson.annotation.JsonProperty;
+
+public class ConfigDetailsRestModel {
+
+ @JsonProperty(value = JSONTags.TAG_ROUTER)
+ String router;
+
+ @JsonProperty(value = JSONTags.TAG_DATE)
+ String date;
+
+ public ConfigDetailsRestModel() {
+ super();
+ }
+ public String getRouter() {
+ return router;
+ }
+
+ public void setRouter(String router) {
+ this.router = router;
+ }
+
+ public String getDate() {
+ return date;
+ }
+
+ public void setDate(String date) {
+ this.date = date;
+ }
+
+}
diff --git a/SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/rest/model/JSONTags.java b/SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/rest/model/JSONTags.java
new file mode 100644
index 00000000..54b5c0f0
--- /dev/null
+++ b/SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/rest/model/JSONTags.java
@@ -0,0 +1,55 @@
+/*
+* ============LICENSE_START=======================================================
+* ONAP : SDNC-FEATURES
+* ================================================================================
+* Copyright 2018 TechMahindra
+*=================================================================================
+* Licensed under the Apache License, Version 2.0 (the "License");
+* you may not use this file except in compliance with the License.
+* You may obtain a copy of the License at
+*
+* http://www.apache.org/licenses/LICENSE-2.0
+*
+* Unless required by applicable law or agreed to in writing, software
+* distributed under the License is distributed on an "AS IS" BASIS,
+* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+* See the License for the specific language governing permissions and
+* limitations under the License.
+* ============LICENSE_END=========================================================
+*/
+package com.onap.sdnc.reports.rest.model;
+
+public class JSONTags {
+
+ public static final String TAG_REQUEST_FNAME = "first_name";
+ public static final String TAG_REQUEST_MNAME = "middle_name";
+ public static final String TAG_STATUS_SUCCESS = "success";
+ public static final String TAG_RESPONSE_STATUS = "status";
+ public static final String TAG_REQUEST_FROM = "request_from";
+ public static final String TAG_REQUEST_ID = "request_id";
+ public static final String TAG_RESPONSE_DETAIL = "response_detail";
+ public static final String TAG_RESPONSE_BODY = "response_body";
+ public static final String TAG_REQUEST_BODY = "request_body";
+ public static final String TAG_RESPONSE_MESSAGE = "request";
+ public static final String TAG_ERROR_CODE = "error_code";
+ public static final String TAG_ERROR_CODE_SUCCESS = "100";
+
+
+ public static final String TAG_ROUTER = "router";
+ public static final String TAG_IPSLA = "ipsla";
+ public static final String TAG_OSPF = "ospf";
+ public static final String TAG_DATE = "date";
+ public static final String TAG_COS_ENTRY_NUMBER = "cos-entry-number";
+ public static final String TAG_DESTINATION_ADDRESS = "destination-address";
+ public static final String TAG_SOURCE_ADDRESS = "source-address";
+ public static final String TAG_CUSTOMER_NAME = "customer-name";
+ public static final String TAG_PROTOCOL_NAME = "protocol-name";
+
+ public static final String TAG_AS_NUMBER = "as-number";
+ public static final String TAG_ROUTER_ID = "router-id";
+ public static final String TAG_PEER_IP = "peer-ip";
+
+ public static final String TAG_PROCESS_ID = "process-id";
+
+
+}
diff --git a/SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/rest/model/PreTestModel.java b/SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/rest/model/PreTestModel.java
new file mode 100644
index 00000000..0a58121c
--- /dev/null
+++ b/SdncReports/SdncReportsDao/src/main/java/com/onap/sdnc/reports/rest/model/PreTestModel.java
@@ -0,0 +1,113 @@
+/*
+* ============LICENSE_START=======================================================
+* ONAP : SDNC-FEATURES
+* ================================================================================
+* Copyright 2018 TechMahindra
+*=================================================================================
+* Licensed under the Apache License, Version 2.0 (the "License");
+* you may not use this file except in compliance with the License.
+* You may obtain a copy of the License at
+*
+* http://www.apache.org/licenses/LICENSE-2.0
+*
+* Unless required by applicable law or agreed to in writing, software
+* distributed under the License is distributed on an "AS IS" BASIS,
+* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+* See the License for the specific language governing permissions and
+* limitations under the License.
+* ============LICENSE_END=========================================================
+*/
+package com.onap.sdnc.reports.rest.model;
+
+import java.io.Serializable;
+import java.util.Date;
+
+public class PreTestModel implements Serializable{
+
+ private static final long serialVersionUID = -3009157732242241606L;
+
+ private long testid;
+
+ private long deviceid;
+
+ private String testName;
+
+ private String deviceIP,execuationDetails,result;
+
+ private Date timeStamp;
+
+ public PreTestModel(long testid, long deviceid, String testName, String deviceIP, String execuationDetails,
+ String result, Date timeStamp) {
+ super();
+ this.testid = testid;
+ this.deviceid = deviceid;
+ this.testName = testName;
+ this.deviceIP = deviceIP;
+ this.execuationDetails = execuationDetails;
+ this.result = result;
+ this.timeStamp = timeStamp;
+ }
+
+ @Override
+ public String toString() {
+ return "PreTestModel [testid=" + testid + ", deviceid=" + deviceid + ", testName=" + testName + ", deviceName="
+ + deviceIP + ", execuationDetails=" + execuationDetails + ", result=" + result + ", timeStamp="
+ + timeStamp + "]";
+ }
+
+ public long getTestid() {
+ return testid;
+ }
+
+ public void setTestid(long testid) {
+ this.testid = testid;
+ }
+
+ public long getDeviceid() {
+ return deviceid;
+ }
+
+ public void setDeviceid(long deviceid) {
+ this.deviceid = deviceid;
+ }
+
+ public String getTestName() {
+ return testName;
+ }
+
+ public void setTestName(String testName) {
+ this.testName = testName;
+ }
+
+ public String getDeviceIP() {
+ return deviceIP;
+ }
+
+ public void setDeviceName(String deviceName) {
+ this.deviceIP = deviceName;
+ }
+
+ public String getExecuationDetails() {
+ return execuationDetails;
+ }
+
+ public void setExecuationDetails(String execuationDetails) {
+ this.execuationDetails = execuationDetails;
+ }
+
+ public String getResult() {
+ return result;
+ }
+
+ public void setResult(String result) {
+ this.result = result;
+ }
+
+ public Date getTimeStamp() {
+ return timeStamp;
+ }
+
+ public void setTimeStamp(Date timeStamp) {
+ this.timeStamp = timeStamp;
+ }
+}
diff --git a/SdncReports/SdncReportsDao/src/main/resources/application.properties b/SdncReports/SdncReportsDao/src/main/resources/application.properties
new file mode 100644
index 00000000..71ead1b4
--- /dev/null
+++ b/SdncReports/SdncReportsDao/src/main/resources/application.properties
@@ -0,0 +1,11 @@
+spring.jpa.generate-ddl=true
+spring.datasource.url=jdbc:mariadb://localhost:3306/testreports
+spring.datasource.username=root
+spring.datasource.password=12345
+spring.datasource.driver-class-name=org.mariadb.jdbc.Driver
+spring.jpa.database-platform=org.hibernate.dialect.MySQLDialect
+
+spring.datasource.testWhileIdle=true
+
+#spring.jpa.hibernate.ddl-auto=update
+
diff --git a/SdncReports/SdncReportsDao/src/test/resources/application.properties b/SdncReports/SdncReportsDao/src/test/resources/application.properties
new file mode 100644
index 00000000..bf76714f
--- /dev/null
+++ b/SdncReports/SdncReportsDao/src/test/resources/application.properties
@@ -0,0 +1,17 @@
+# H2 DB Details
+spring.jpa.hibernate.ddl-auto = update
+spring.jpa.database = HSQL
+spring.jpa.properties.hibernate.dialect = org.hibernate.dialect.HSQLDialect
+spring.datasource.driverClassName = org.hsqldb.jdbcDriver
+spring.datasource.url: jdbc:hsqldb:mem:scratchdb
+spring.datasource.username =sa
+spring.datasource.password =sa
+
+spring.datasource.tomcat.max-wait=20000
+spring.datasource.tomcat.max-active=50
+spring.datasource.tomcat.max-idle=20
+spring.datasource.tomcat.min-idle=15
+
+spring.jpa.show-sql=true
+
+