Pass parameter to tag.writeAsync

Ignition
13

Sorry, I was pulled into a meeting as I was typing this, but if it helps, I do have a function to generate question marks for prep inserts.

def prepInsertQmarks(numOfGroups, groupSize):
	''' 
	    Generate a string of grouped question marks for prepUpdate inserts
	    example: Generate three groups of four question marks:
	    prepInsertQmarks(3, 4) returns (?,?,?,?),(?,?,?,?),(?,?,?,?)
	'''
	group = '(' + ','.join(['?'] * groupSize) + ')'
	return ','.join([group] * numOfGroups)
	

query = """
INSERT INTO [dbo].[DATA_RAW]
	([EQUIP_NUM]
	,[TIMESTAMP]
	,[PART_NUMBER]
	,[JOB_NUMBER]
	,[SAMPLE_NUMBER]
	,[SAMPLE_MEASUREMENT])
VALUES %s""" % prepInsertQmarks(4,6)
		
print query

Output:

INSERT INTO [dbo].[DATA_RAW]
	([EQUIP_NUM]
	,[TIMESTAMP]
	,[PART_NUMBER]
	,[JOB_NUMBER]
	,[SAMPLE_NUMBER]
	,[SAMPLE_MEASUREMENT])
VALUES (?,?,?,?,?,?),(?,?,?,?,?,?),(?,?,?,?,?,?),(?,?,?,?,?,?)
1 Like