/*
 * Copyright 2016 Open Networking Laboratory
 *
 * 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.
 */
package mclab;

import java.net.*;
import java.sql.*;
import java.io.*;
import java.util.concurrent.*;
import mclab.*;

import org.apache.felix.scr.annotations.Activate;
import org.apache.felix.scr.annotations.Component;
import org.apache.felix.scr.annotations.Deactivate;
import org.apache.felix.scr.annotations.Service;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

/**
 * Skeletal ONOS application component.
 */
@Component(immediate = true)
public class AppComponent {

    private final Logger log = LoggerFactory.getLogger(getClass());
    protected final String MYSQL_DRIVER = "com.mysql.jdbc.Driver";
    protected final String MYSQL_URL = "jdbc:mysql://localhost:3306/AP_Information?" +
    					"user=root&password=mclab1";
    protected final String MYSQL_USER = "root";
    protected final String MYSQL_PASSWORD = "mclab1";

    protected MySQLdb db = null;
    protected ScheduledExecutorService executor = Executors.newSingleThreadScheduledExecutor();
    protected ThreadPoolExecutor conExecutor;
    protected ServerSocket ls;

    protected void heartbeatThread() {
    		db.heartbeat();
		//onos.print("heartbeat");
    }

    @Activate
    protected void activate() {
	    try {
	    		db = new MySQLdb(MYSQL_DRIVER,MYSQL_URL, MYSQL_USER, MYSQL_PASSWORD);
			System.out.println("makedb");
	    		//ls = new ServerSocket(12015);
			//print("serverSocket");
			executor.scheduleAtFixedRate(this::heartbeatThread, 1, 5, TimeUnit.SECONDS);

			conExecutor = (ThreadPoolExecutor)Executors.newCachedThreadPool();
			conExecutor.execute(new DBThread(db, conExecutor, ls));
			//print("ddd");
		    /*****************************
		     * TODO:
		     * 1. make db thread
		     * 2. make db command
		     * 3. make heartbeat 
		     * 4. make show command
		     * ***************************/
		    log.info("Started");
	    }
	    catch(Exception e)
	    {e.printStackTrace();}
    }

    @Deactivate
    protected void deactivate() {
    	try {
	    log.info("Stopped");
	    ls.close();
	    executor.shutdown();
	    conExecutor.shutdown();
	    }catch(Exception e) {
	    	e.printStackTrace();
	    }
    }

}

@@ -1485,16 +1485,57 @@
 = null;%0A
+    protected HeartbeatThread ht = null;%0A
     prot
@@ -1703,105 +1703,9 @@
 ls;%0A
-%0A    protected void heartbeatThread() %7B%0A    %09%09db.heartbeat();%0A%09%09//onos.print(%22heartbeat%22);%0A    %7D%0A
+%09
 %0A   
@@ -1935,16 +1935,71 @@
 cket%22);%0A
+            ht = new HeartbeatThread(db);%0A            %0A
 %09%09%09execu
@@ -2026,29 +2026,10 @@
 ate(
+h
 t
-his::heartbeatThread
 , 1,
@@ -2278,16 +2278,23 @@
 b thread
+ - done
 %0A%09%09     
@@ -2305,32 +2305,39 @@
  make db command
+ - done
 %0A%09%09     * 3. mak
@@ -2348,16 +2348,22 @@
 artbeat 
+- done
 %0A%09%09     

add heatbeatthread