I am registering data from a measurement line in sql, an event script gateway and I do not register one of the update query.
This is the script, is there something wrong?
from java.util import Date
if flanco == 0:
now = Date() # creates a new date, for right now
Fecha = system.db.dateFormat(now, "yyyy-MM-dd HH:mm:ss")
Linea = "VDD"
B1 = system.tag.getTagValue("VDD/B1")/1000
B2 = system.tag.getTagValue("VDD/B2")/1000
B3 = system.tag.getTagValue("VDD/B3")/1000
B4 = system.tag.getTagValue("VDD/B4")/1000
B5 = system.tag.getTagValue("VDD/B5")/1000
B6 = system.tag.getTagValue("VDD/B6")/1000
P1 = system.tag.getTagValue("VDD/P1")/1000
P2 = system.tag.getTagValue("VDD/P2")/1000
B1B3 =system.tag.getTagValue("VDD/B1B3")/1000 # Control giro bisagra superior
B4B6 = system.tag.getTagValue("VDD/B4B6")/1000 # Control giro bisagra inferior
B2B1 = system.tag.getTagValue("VDD/B2B1")/1000 #Control paralelismo bisagra superior
B5B4 = system.tag.getTagValue("VDD/B5B4")/1000 # Control paralelislo bisagra inferior
flanco = system.tag.getTagValue("VDD/Flanco")
# *************** TOLERANCIAS **************
P_MAX_B5_B4 = system.tag.getTagValue("VDD/TOLERANCIAS/P_MAX_B5_B4")/1000
P_MIN_B5_B4 = system.tag.getTagValue("VDD/TOLERANCIAS/P_MIN_B5_B4")/1000
G_MAX_B6_B4 = system.tag.getTagValue("VDD/TOLERANCIAS/G_MAX_B6_B4")/1000
G_MIN_B6_B4 = system.tag.getTagValue("VDD/TOLERANCIAS/G_MIN_B6_B4")/1000
C_MAX_INF = system.tag.getTagValue("VDD/TOLERANCIAS/C_MAX_INF")/1000
C_MIN_INF = system.tag.getTagValue("VDD/TOLERANCIAS/C_MIN_INF")/1000
P_MAX_B2_B1 = system.tag.getTagValue("VDD/TOLERANCIAS/P_MAX_B2_B1")/1000
P_MIN_B2_B1 = system.tag.getTagValue("VDD/TOLERANCIAS/P_MIN_B2_B1")/1000
G_MAX_B3_B1 = system.tag.getTagValue("VDD/TOLERANCIAS/G_MAX_B3_B1")/1000
G_MIN_B3_B1 = system.tag.getTagValue("VDD/TOLERANCIAS/G_MIN_B3_B1")/1000
C_MAX_SUP = system.tag.getTagValue("VDD/TOLERANCIAS/C_MAX_SUP")/1000
C_MIN_SUP = system.tag.getTagValue("VDD/TOLERANCIAS/C_MIN_SUP")/1000
P_MAX_PUE = system.tag.getTagValue("VDD/TOLERANCIAS/P_MAX_PUE")/1000
P_MIN_PUE = system.tag.getTagValue("VDD/TOLERANCIAS/P_MIN_PUE")/1000
#**********************************************************************************
#************************************ CONTAJE ************************************
system.db.runUpdateQuery ("INSERT INTO Bisagras (B1, B2, B3, B4, B5, B6, P1, P2, B1B3, B4B6, B2B1, B5B4, t_stamp, P_MAX_B5_B4, P_MIN_B5_B4, G_MAX_B6_B4, G_MIN_B6_B4, C_MAX_INF, C_MIN_INF, P_MAX_B2_B1, P_MIN_B2_B1, G_MAX_B3_B1, G_MIN_B3_B1, C_MAX_SUP, C_MIN_SUP, P_MAX_PUE, P_MIN_PUE, Linea) VALUES ('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s')" %(B1, B2, B3, B4, B5, B6, P1, P2, B1B3, B4B6, B2B1, B5B4, Fecha, P_MAX_B5_B4, P_MIN_B5_B4, G_MAX_B6_B4, G_MIN_B6_B4, C_MAX_INF, C_MIN_INF, P_MAX_B2_B1, P_MIN_B2_B1, G_MAX_B3_B1, G_MIN_B3_B1, C_MAX_SUP, C_MIN_SUP, P_MAX_PUE, P_MIN_PUE, Linea))
PiezaOK = system.tag.getTagValue("VS20.VDD.MediciionBisagras.PiezaOK")
PAMHabilitada = system.tag.getTagValue("VS20.VDD.MediciionBisagras.PiezaAtornilla MHabilitada")
system.db.runUpdateQuery ("INSERT INTO B_contajes (t_stamp, LĂnea, PiezaOK, PAMHabilitada ) VALUES ('%s','%s','%s','%s')" %(Fecha, Linea, PiezaOK, PAMHabilitada))
system.tag.writeToTag("VDD/Flanco", 1)
else:
system.tag.writeToTag("VDD/Flanco", 0)