#!/usr/bin/python

import datetime

from socket import gethostbyname

from termcolor import colored

import MySQLdb as mdb

f = open('failed', 'w')

f.close()

f = open('sitesok', 'w')

f.close()

f = open('siteserror', 'w')

f.close()

f = open('domains.html', 'w')

f.close()

f = open('checkfailed', 'w')

f.close

# Mysql connection

#con = mdb.connect('localhost', 'user', 'test123', 'domains');

# END Mysql connection

with open('/root/sitedxr.com/victorconnect.csv') as input:

for line in input:

host, index = line.strip().split(',')

now = datetime.datetime.now()

try:

output = gethostbyname(host)

if output == index:

print colored(host,'red'),colored(output,'green')

now1 = now.strftime("%Y-%m-%d %H:%M")

f = open('sitesok','a')

f.write(host + " ==>> " + output + " " + "SERVER IP : " + " " + index + " " + now1)

# f.write(host + " , " + output)

f.write('\n')

h = open ('domains.html','a') # For monitoring System

h.write("<a href=http://" + host +" target=_blank\>" + host + "</a></br>") # Links for monitoring system

# XML File

# h.write("<link><title>" + host + " -> Netwise2</title><url>http://" + host + "</url></link>")

# End XML FILE

h.write('\n')

# Mysql database insert domains

# cur = con.cursor()

# cur.execute("CREATE TABLE IF NOT EXISTS Domains(Id INT PRIMARY KEY AUTO_INCREMENT, Name VARCHAR(50), IP VARCHAR(25), Resolving VARCHAR(25), Server VARCHAR(60))")

# cur.execute("""INSERT INTO Domains(Name, IP, Resolving, Server) VALUES(%s, %s, %s, 'Server Beach')""", (host, index, output))

# End mysql database insert

#cur = con.cursor()

#cur.execute("Update Domains set Problem='0' Where Name = %s", (host))

else:

#cur2 = con.cursor()

# Insert Domains into Mysql Database

# cur.execute("INSERT INTO Domains(Name, IP, Resolving, Server, Problem) VALUES(%s, %s, %s, 'Problem', '1')", (host, index, output))

# End Insert Domains into Mysql Database

#cur2.execute("Update Domains set Problem=1 Where Name = %s", (host))

print colored(host, 'white'),colored(index, 'red'), colored(output, 'red'), colored(now.strftime("%Y-%m-%d"), 'white')

z = open('failed', 'a')

z.write(host + " old ip : " + index + " new ip : " + output)

z.write('\n')

z.close()

except:

print "Error" , host

f = open('siteserror','a')

# f.write(host + " ==>> " + "SERVER IP: " + index)

f.write(host)

f.write('\n')

import sys

sys.stdin = open ('sitesok', 'r')

data = sys.stdin.readlines()

print "Domains : ", colored(len(data), 'red'), "domains"

sys.stdin = open ('failed', 'r')

data = sys.stdin.readlines()

print "Error resolving : ", colored(len(data), 'white'), "failed domains"

#import subprocess

#process = subprocess.Popen(['/root/niki/starter'], shell=True, executable="/bin/bash")

#output = process.communicate()[0]

#import smtplib

#from email.mime.text import MIMEText

#fp = open('/root/niki/checkfailed', 'r')

#msg = MIMEText(fp.read())

#fp.close()

#msg['Subject'] = 'Web site ip monitoring Warning'

#msg['From'] = 'monitor@sitedxr.com'

#msg['To'] = 'itsupport@1stonlinesolutions.com'

#toaddr = "hdimitrov@1stonlinesolutions.co.uk"

#cc = ['itsupport@1stonlinesolutions.com']

#toaddrs = [toaddr] + cc

#s = smtplib.SMTP('localhost')

#s.set_debuglevel(True)

#s.sendmail('monitor@sitedxr.com', toaddrs, msg.as_string())

#s.quit()