如何在partiqL DynamodB中使用IN语句

Question

我想转换这个查询，从lKey中选择KeyMapping，其中gKey在'A#1'，'A#2'，‘A#3’中；

我有一个包含A#1，A#2和A#3的列表

在Java代码中使用DynamoDB从PartiQL中提取记录

Answer 1

@Autowired
private AmazonDynamoDB client;


List<String> paramList = new ArrayList<>(); //List of Parameters
paramList.add("A#1");
paramList.add("A#2");
paramList.add("A#3");

ExecuteStatementRequest request = new ExecuteStatementRequest();
String[] placeholders = new String[paramList.size()];
Arrays.fill(placeholders, "?");
String commalist = Arrays.stream(placeholders).collect(Collectors.joining(","));
        request.setStatement("select * from "+appConfigs.getBoclipsTableName()+" where id in ("+commalist+")");

List<AttributeValue> parameters = new ArrayList<>();
for(String videoId: videoIds){
    parameters.add(new AttributeValue(videoId));
}
System.out.println(client.executeStatement(request).toString());