py_partiql_parser_query_execution_on_python_dicts.py

1from py_partiql_parser import DynamoDBStatementParser
2
3# The data to query
4source_data = {
5    "table1": [
6        {"id": "msg1", "body": "first message"},
7        {"id": "msg2", "body": "second message"},
8    ]
9}
10
11# The query to run
12query = "SELECT * FROM table1 WHERE id = \"msg1\""
13
14# Initialize the parser
15parser = DynamoDBStatementParser(source_data=source_data)
16
17# Parse and execute the query
18result = parser.parse(query)
19
20# Print the result
21print(result)
22# [{'id': 'msg1', 'body': 'first message'}]