How to insert record and return the identity value with the module sdk

Module Development
1

How does one do the equivalent of system.db.runUpdateQuery or runPrepUpdate with getKey=1 within the sdk? According to the SRConnection docs SRConnection, there is a runPrepInsertGetKey, but it returns:

java.lang.NoSuchMethodError: 'int com.inductiveautomation.ignition.gateway.datasource.SRConnection.runPrepInsertGetKey(java.lang.String, java.lang.String, java.lang.String, java.lang.Object)'

This error occurred on 8.1.12 and 8.1.15

2

That looks like you're calling an instance method as a static method. You need to obtain an SRConnection first, probably by going into a DatasourceManager off of the GatewayContext provided in your module's setup hook.

3

It is being called as an instance method. The call works when calling 'runPrepUpdate', but returns the number of records created (1), not the Id.

newKey = __db.connection().runPrepInsertGetKey(query, ...

4

What language are you writing your module in? Can you make your typing explicit and/or see what you actually have after __db.connection()?

Unless you’re calling com.inductiveautomation.ignition.gateway.datasource.DatasourceManager#getConnection(java.lang.String), I’m not sure you actually have an SRConnection.

5

runPrepInsertGetKey returns long starting with Ignition 8.1.6.

1 Like
6

That was it! When we started the modules the target gateway was back at 8.0.13, and the modules were built accordingly. This particular call was in a shared jar file which had upgraded references. Once all version references were updated and updated modules installed, the call to runPrepInsertGetKey runs successfully.

7

Is this in fact the method used to implement the system.db.runPrepUpdate with getKey=1? runPrepInsertGetKey requires the table and column to be passed in, which is not part of the python interface.

8

runUpdateQuery and runPrepUpdate use it and pass in null values for table and column, despite what the Javadoc says about it…