I am tring to insert records for previous_efficiency into my table but only one row which is Twister 1 is inserting into the table. Is there something wrong Iam doing?
if system.tag.readBlocking("[default]zzzTimezzz/Twisting Data Write 810am 810pm")[0].value == True:
line = [1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62]
#quad = [A,B,C,D]
for i in line:
tagPathLeft_Eff = "[default]Twisters/TW" + str(i) +"/Left/Shift_2/Previous_Efficiency"
tagPathRight_Eff = "[default]Twisters/TW" + str(i) +"/Right/Shift_2/Previous_Efficiency"
Left_Eff = system.tag.readBlocking(tagPathLeft_Eff)[0].value
Right_Eff = system.tag.readBlocking(tagPathRight_Eff)[0].value
Twisters = i
DateTime = system.date.now()
Shift = system.tag.readBlocking("[default]Twisters/Previous Shift")[0].value[0]
# Use a dictionary to map supervisor names based on twisters and Shift
Supervisor_mapping = {
('J', True): 'Carol Brookeshire' if Twisters <= 32 else 'Lind Smith',
('K', True): 'Andrew Frazier' if Twisters <= 32 else 'Tracy Presley',
('L', True): 'Sandra McIntyre' if Twisters <= 33 else 'Tim Foley',
('M', True): 'Juanita Gordon' if Twisters <= 33 else 'Jan Kelly',
}
# Get supervisor name from the dictionary based on Shift and Twisters
Supervisor = Supervisor_mapping.get((Shift, True), 'Unknown Supervisor')
system.db.runPrepUpdate("INSERT INTO Plt65_NightShift_Twisting_Efficiencies (Twisters, DateTime, Shift, Supervisor, Left_Eff, Right_Eff) VALUES(?,?,?,?,?,?)", [Twisters, DateTime, Shift, Supervisor, Left_Eff, Right_Eff], 'IgnitionHUD')
logger.info("NIGHT SHIFT EXECUTED")