for clef in product_dict[z].keys():
if clef not in text_var:
try:
value = product_dict[z][clef]
value = value.replace("m", "")
value = value.replace("kg", "")
value = value.replace("kn", "")
value = value.replace("kn", "")
value = value.strip()
value = float(value)
product_dict[z][clef] = value
except:
pass
try:
product_dict[z][clef] = product_dict[z][clef].replace("\r\n", " ")
product_dict[z][clef] = product_dict[z][clef].replace("'", " ")
except:
pass
for key in product_dict:
try:
request = "UPDATE modeles SET LONGUEUR = %(long).9f WHERE ID_MODELE = %(id)i" % {
"long": product_dict[key]["Length"],
"id": product_dict[key]["id"],
}
data_handler.exec_request(request)
except:
pass
