#!/bin/python

import mysql.connector
from time import time
from datetime import datetime
import logging
from socket import gethostname

logging.basicConfig(filename='connection.log',format='%(asctime)s %(levelname)s:%(message)s',level=logging.INFO)

host = gethostname()
ts = time()

try:
    	loggerdb = mysql.connector.connect(
                user='', password='',
                host='',
                database='')
        logging.debug("Connected to database")

        cursor=loggerdb.cursor()

        add_ping = ("INSERT INTO uptime ""(host, timestamp)""VALUES (%s, %s)")

        timestamp = datetime.fromtimestamp(ts).strftime('%Y-%m-%d %H:%M:%S')

        cursor.execute(add_ping, (host, timestamp))
        loggerdb.commit()
        logging.info("Inserted " + host + " " + timestamp + " into database.")

except:
       	logging.error("Unable to connect. Connection Error")

loggerdb.close()