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)
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)