Implement Enhancements to the Microservice

Change-Id: Ie3b11fe14f1794fdd6880c40bc382eccbef34aa2
Issue-ID: DCAEGEN2-1109
Signed-off-by: krishna moorthy <krishna.moorthy6@wipro.com>

2 files changed, 41 insertions, 39 deletions

diff --git a/src/main/resources/logback.xml b/src/main/resources/logback.xml
index b7baa6f..28586fd 100644
--- a/src/main/resources/logback.xml
+++ b/src/main/resources/logback.xml
@@ -1,24 +1,14 @@
 <?xml version="1.0" encoding="UTF-8"?>
-<!--
-     ============LICENSE_START=======================================================
-     son-handler
-     ================================================================================
-      Copyright (C) 2019 Wipro Limited.
-      ==============================================================================
-        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=========================================================
-     
- -->
+<!-- ============LICENSE_START======================================================= 
+	son-handler ================================================================================ 
+	Copyright (C) 2019 Wipro Limited. ============================================================================== 
+	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========================================================= -->
 <configuration>
 	<appender name="FILE-THREAD" class="ch.qos.logback.classic.sift.SiftingAppender">
 		<discriminator>
@@ -27,23 +17,27 @@
 		</discriminator>
 
 		<sift>
-    		<appender name="file-${logFileName}" class="ch.qos.logback.core.rolling.RollingFileAppender">
-    			<file>/var/log/onap/son-handler/${logFileName}.log</file>
-    			<rollingPolicy class="ch.qos.logback.core.rolling.FixedWindowRollingPolicy">
-      				<fileNamePattern>${logFileName}.%i.log.zip</fileNamePattern>
-      				<minIndex>1</minIndex>
-      				<maxIndex>5</maxIndex>
-    			</rollingPolicy>
-    			<triggeringPolicy class="ch.qos.logback.core.rolling.SizeBasedTriggeringPolicy">
-      				<maxFileSize>5MB</maxFileSize>
-    			</triggeringPolicy>
-        		<encoder>
-            		<pattern>%d{dd-MM-yyyy HH:mm:ss.SSS} %magenta([%thread]) %highlight(%-5level) %logger{36}.%M - %msg%n</pattern>
-        		</encoder>
-    		</appender>
-    	</sift>
+			<appender name="file-${logFileName}"
+				class="ch.qos.logback.core.rolling.RollingFileAppender">
+				<file>/var/log/onap/son-handler/${logFileName}.log</file>
+				<rollingPolicy
+					class="ch.qos.logback.core.rolling.FixedWindowRollingPolicy">
+					<fileNamePattern>${logFileName}.%i.log.zip</fileNamePattern>
+					<minIndex>1</minIndex>
+					<maxIndex>5</maxIndex>
+				</rollingPolicy>
+				<triggeringPolicy
+					class="ch.qos.logback.core.rolling.SizeBasedTriggeringPolicy">
+					<maxFileSize>5MB</maxFileSize>
+				</triggeringPolicy>
+				<encoder>
+					<pattern>%d{dd-MM-yyyy HH:mm:ss.SSS} %magenta([%thread])
+						%highlight(%-5level) %logger{36}.%M - %msg%n</pattern>
+				</encoder>
+			</appender>
+		</sift>
 	</appender>
-    <root level="debug">
-        <appender-ref ref="FILE-THREAD" />
-    </root>
+	<root level="info">
+		<appender-ref ref="FILE-THREAD" />
+	</root>
 </configuration>
diff --git a/src/main/resources/schema.sql b/src/main/resources/schema.sql
index 88b64d5..72cdbcf 100644
--- a/src/main/resources/schema.sql
+++ b/src/main/resources/schema.sql
@@ -24,4 +24,12 @@ CREATE TABLE FAULT_NOTIFICATIONS(
 	notification TEXT PRIMARY KEY NOT NULL,
 	created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
 );
-		
+CREATE TABLE PERFORMANCE_NOTIFICATIONS(
+	notification TEXT PRIMARY KEY NOT NULL,
+	created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
+);
+CREATE TABLE HANDOVER_METRICS(
+	src_cell_id TEXT PRIMARY KEY NOT NULL,
+	ho_details TEXT NOT NULL,
+	created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
+);