/*
 * 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();
	    }
    }

}

/*
 * 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 HeartbeatThread ht = null;
    protected ScheduledExecutorService executor = Executors.newSingleThreadScheduledExecutor();
    protected ThreadPoolExecutor conExecutor;
    protected ServerSocket ls;
	
    @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");
            ht = new HeartbeatThread(db);
            
			executor.scheduleAtFixedRate(ht, 1, 5, TimeUnit.SECONDS);

			conExecutor = (ThreadPoolExecutor)Executors.newCachedThreadPool();
			conExecutor.execute(new DBThread(db, conExecutor, ls));
			//print("ddd");
		    /*****************************
		     * TODO:
		     * 1. make db thread - done
		     * 2. make db command - done
		     * 3. make heartbeat - done
		     * 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();
	    }
    }

}

add heatbeatthread