jcberquist / aws-cfml

Lucee/ColdFusion library for interacting with AWS API's
MIT License
72 stars 53 forks source link

Dynamodb partiql #54

Closed victorbvieira closed 3 years ago

victorbvieira commented 3 years ago

hello, I tried to implement the dynamodb partiql in the library, as it seemed simpler to run queries. but, I was not successful. Could you implement a method that uses dynamodb partiql ? https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/ql-reference.html

jcberquist commented 3 years ago

Hi in v1.21.0 I added support for ExecuteStatement, BatchExecuteStatement, and ExecuteTransaction. Let me know if this helps!

To give a simple example:

aws = new awscfml.aws();

statement = "
SELECT *
FROM Orders
WHERE OrderID = ?
"
res = aws.dynamodb.executeStatement( statement = statement, parameters = [ 100 ] );

writeDump( res );
victorbvieira commented 2 years ago

Very Tks ;)