#!/usr/bin/python

from Adafruit_CharLCD import Adafruit_CharLCD
import socket
import mysql.connector

class LCDTests:

        sites = ['www.google.com', 'yahoo.com']
        ip = ''

        def __init__(self):

                self.lcd = Adafruit_CharLCD();
                self.lcd.begin(16,1);

                try:
                        self.cnx = mysql.connector.connect(user = '', password='', database='', host='')
                except mysql.connector.Error, e:
                        self.lcd.message("Can't connect to the database");
                        try:
                                print("MySQL Error [%d]: %s" % (e.args[0], e.args[1]));
                        except IndexError:
                                print("MySQL Error: %s" % str(e));
                else:
                        self.cnx.close()

        def web_lookup(self, host):
                try:
                        self.ip[host] = socket.gethostbyname(host)
                except socket.gaierror as err:
                        self.lcd.message("Can't resolve hostname %s: " % (host, err[1]))
                else:
                        self.lcd.message(err)
        def run(self):
                self.lcd.message('loading...');
                self.web_lookup('youtube.com');

test = LCDTests()
test.run()