type or def runAction(self, event):
"""
This event is fired when the 'action' of the component occurs.
Arguments:
self: A reference to the component that is invoking this function.
event: An empty event object.
"""
#loop through dataset and send to sql
#get dataSet parameters
dataSet = self.parent.parent.parent.getChild("Table").props.data
rowCount = dataSet.getRowCount()
modIndex = dataSet.getColumnIndex("modified")
#get edited value indexes
ignition_g_kpi_ndxIndex = dataSet.getColumnIndex("ignition_g_kpi_ndx")
unitNumberIndex = dataSet.getColumnIndex("unitNumber")
orderNumberIndex = dataSet.getColumnIndex("orderNumber")
shiftIndex = dataSet.getColumnIndex("ShiftName")
validIndex = dataSet.getColumnIndex("valid")
commentsIndex = dataSet.getColumnIndex("comments")
#loop through dataset and change any rows that have been modified
self.parent.parent.parent.getChild("FlexContainer_0").getChild("Label").props.text = dataSet#test1
for row in range(rowCount):
dataSet = self.parent.parent.parent.getChild("Table").props.data
self.parent.parent.parent.getChild("FlexContainer_0").getChild("Label_0").props.text = dataSet#test2
modified = dataSet.getValueAt(row, modIndex)
if modified == 1:
ignition_g_kpi_ndx = dataSet.getValueAt(row, ignition_g_kpi_ndxIndex)
unitNumber = dataSet.getValueAt(row, unitNumberIndex)
orderNumber = dataSet.getValueAt(row, orderNumberIndex)
shift = dataSet.getValueAt(row, shiftIndex)
valid = dataSet.getValueAt(row, validIndex)
comments = dataSet.getValueAt(row, commentsIndex)
dataSetOrderNumber = self.view.params.data[0]['Order Number']
#run named query to update dataset and return updated dataset
namedQuery = "ignition_g_kpi Update"
parameters = {"ignition_g_kpi_ndx":ignition_g_kpi_ndx, "unitNumberIndex":unitNumberIndex, "orderNumber":orderNumber, "shift":shift, "valid":valid, "comments":comments, "dataSetOrderNumber":dataSetOrderNumber}
dataSet = system.db.runNamedQuery(namedQuery, parameters)
self.view.params.data[0]['Order Number']
#set dataset props to new dataset
self.parent.parent.parent.getChild("Table").props.data = dataSet
self.parent.parent.parent.getChild("Table").custom.backUpData
#turn edit mode off
self.view.params.edit = False
I've been trying to loop through a dataset to get the values at different rows.
I'm getting an error that I can't use getValueAt on an Int because it's not an attribute.
I then looked to see what's happening to my dataset and read it before and after the for loop and printed it to a label. Before the for loop I get my dataset, after the for loop it's turning into the int "1"
This happens even if I re define the dataset inside the for loop.
Any help would be appreciated, thanks!