Check DB vs tag values, run update if different or

[lrose]

@rfolkes

Using script tool to test it appears that data1 != data2 comparison works maybe because they are both returning single row datasets?

I assure you that it doesn't work the way you might think it does.

Datasets not equal but no differences found?

I have to rewrite some stored procedures so I am writing a test to make sure for every input I am getting the same output. I have something like from com.inductiveautomation.common.util import DatasetTestUtils def testSP(): orig_call = system.db.createSProcCall('orginalSP') system.db.execSProcCall(orig_call) new_call = system.db.createSProceCall('newSP') system.db.execSProcCall(new_call) orig_data = orig_call.getResultSet() new_data = new_call.getResultSet() compar…

You can use wildcards at the folder level, and then filter from there to insure that the tag which triggered the event is one you care to work on.