I have a function I’m writing a test for that calls another function which returns a query. The function I’m testing then references the return value’s identitycol value, which I’ll need to mock. However, I don’t see a way via mockbox.querysim to provide the identitycol value (looks like it’s more for select queries rather than insert/update queries). If I use querysim, store its return value in a variable (local.testquery) and then try to do something like local.testquery.identitycol = 1 I get a CF exception stating that
“An error occurred while trying to modify the query named class coldfusion.sql.QueryTable. Query objects cannot be modified, they can only be displayed.”
I’m not sure this is even possible, given the CF error I’m seeing. I suppose I could do something cringe-worthy, like have a transaction in my test that does an insert and then rolls the insert back just so I can have a query object that has an identitycol value in it. But my gut tells me there’s got to be a simpler way. The googles didn’t help me much (ok, the duckduckgos).
Thoughts/suggestions?