def GetInformationDeviceSon(list_information_with_father):
for element in list_information_with_father:
list_element = element.split(';')
if len(list_element) == 5:
if list_element[2] != '-':
query = "select * from dispositivo where serial = '%s'" % list_element[
2]
if Query.ExistElementInDB(query) == 1:
query = "insert into dispositivo values ('%s', %d, '%s', '%s', '%s', %d, %d)" % (
list_element[2], 0, list_element[3], '',
list_element[1], 0, 0)
Query.InsertDBWithOutMessage(query)
UpdateModelDevice(list_element[4], list_element[2])
else:
#update atributes...
UpdateIPDevice(list_element[2], list_element[1])
UpdateNameDevice(list_element[3], list_element[2])
UpdateModelDevice(list_element[4], list_element[2])
try:
#get serial version of device by IP
serial = GetSerialDevice(list_element[0])
query = "Insert into conecta values('%s', '%s', %d)" % (
serial, list_element[2], 0)
Query.InsertDBWithOutMessage(query)
except:
pass
def UpdateDeviceInDataBase():
file_read = open("information_actual_and_SNMP.csv", 'r')#open output file RecopilaInformatioSNMP.py
#read file...
line = file_read.readline()
while line:
line = line.strip('\n')
line_information = line.split(';')
#ask if device response to SNMP...
if line_information[3] == "si":
#ask if serial exists in data base...
query = "select * from dispositivo where serial = '%s'" % line_information[0]
if Query.ExistElementInDB(query) == 0:
#update atributes...
UpdateIPDevice(line_information[4], line_information[0])
UpdateNameDevice(line_information[1], line_information[0])
UpdateModelDevice(line_information[2], line_information[0])
print line_information
else:
#the device not exists in data base... is necesary change element...
print line_information[0]
query = "insert into dispositivo values ('%s', %d, '%s', '%s', '%s', %d, %d)" % (line_information[0], 0, line_information[1], '', line_information[4], 0, 0)
Query.InsertDBWithOutMessage(query)
UpdateModelDevice(line_information[2], line_information[0])
line = file_read.readline()
file_read.close()
def InsertDevices(list_element):
first_element = list_element[0]
cont = 0
for element in list_element:
if element == first_element:
cont += 1
if cont > 1:
break
#make split to element
information_element = element.split(";")
query = "select * from dispositivo where serial = '%s'" % information_element[
1]
print information_element
if Query.ExistElementInDB(query) == 1:
query = "insert into dispositivo values ('%s', %d, '%s', '%s', '%s', %d, %d)" % (
information_element[1], 0, information_element[2], '',
information_element[0], 0, 0)
Query.InsertDBWithOutMessage(query)
UpdateModelDevice(information_element[3], information_element[1])
else:
#update atributes...
UpdateIPDevice(information_element[1], information_element[0])
UpdateNameDevice(information_element[2], information_element[1])
UpdateModelDevice(information_element[3], information_element[1])
def UpdateModelDevice(
model_device,
serial): #Falta el id de la marca y del tipo de dispositivo!!!
#evaluate if exists the model in data base...
query = "select * from modelo where nom_modelo = '%s'" % model_device
if Query.ExistElementInDB(query) == 0: #exists in db...
#get the id of model
query = "select id_modelo from modelo where nom_modelo = '%s'" % model_device
database_elements = Comunication.BeginComunication() #init connection
response = Comunication.MakeQueryDB(
query, database_elements[1]) #manage query
#update the id of model device...
query = "update dispositivo set id_modelo = %d where serial = '%s'" % (
int(response[0][0]), serial)
Query.UpdateDBWithOutMessage(query)
else: #the model device not exist in data base...
#insert model in data base...
id_model = Query.GetMaxIDinTable(
'modelo',
'id_modelo') #falta agregar el tipo de dispositivo y la marca...
if id_model == None:
id_model = 0
query = "insert into modelo values (%d, %d, %d, '%s')" % (
id_model, 0, 0, model_device)
Query.InsertDBWithOutMessage(query)
query = "update dispositivo set id_modelo = %d where serial = '%s'" % (
id_model, serial)
Query.UpdateDBWithOutMessage(query)
else:
id_model += 1
query = "insert into modelo values (%d, %d, %d, '%s')" % (
id_model, 0, 0, model_device)
Query.InsertDBWithOutMessage(query)
query = "update dispositivo set id_modelo = %d where serial = '%s'" % (
id_model, serial)
Query.UpdateDBWithOutMessage(query)
def InsertModelDevice(
model_device): #Falta el id de la marca y del tipo de dispositivo!!!
#evaluate if exists the model in data base...
query = "select * from modelo where nom_modelo = '%s'" % model_device
if Query.ExistElementInDB(query) != 0: #exists in db...
id_model = 0
#insert model in data base...
id_model = Query.GetMaxIDinTable(
'modelo',
'id_modelo') #falta agregar el tipo de dispositivo y la marca...
if id_model == None:
id_model = 1
else:
id_model += 1
query = "insert into modelo values (%d, %d, %d, '%s')" % (
id_model, 0, 0, model_device)
Query.InsertDBWithOutMessage(query)