jest-dynalite
jest-dynalite copied to clipboard
partiQL Support?
Hello,
Does this package support running queries using the partiQL statement execution syntax? I'm trying to do it now but am running into UnknownOperationException
errors.
It could be that partiQL is generating a query which is not supported? For example transactions are not yet supported by dynalite, nor are streams.
@mikewolfd it's been a while since this was opened, but do you happen to remember if you were able to get around it?
I just hit this issue, not sure what would be incorrect about the PartiQL statement I'm trying to run as a dummy test...
const statement = {
Statement: `SELECT * FROM "MyTableName" WHERE id='${someId}' AND typeId='${someTypeId}'`
};
await ddb.executeStatement(statement).promise();
The same type of select statement works just fine from the AWS console. I've tried every which way I can think of to change single vs. double quotes, no quotes, etc. but still get an UnknownOperationException
when running the executeStatement
in a test.
Just updated to latest [email protected]
and [email protected]
@Jack-Barry Did you find a way to work around? I'm at your situation now.
@khoaleanhvn I never did, ended up punting on using PartiQL, partly because of this issue