-
Notifications
You must be signed in to change notification settings - Fork 1
/
query_executor.py
52 lines (42 loc) · 1.27 KB
/
query_executor.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
import json
import logging
import log_helper
from botocore.exceptions import ClientError
from app.athena import Athena
from app.sqs import Sqs
from aws_xray_sdk.core import patch_all
patch_all()
log_helper.init_log_config()
def handler(event, context):
"""
Lambda is triggered by 'athena-query-dev' queue.
"""
print('event:' + str(event))
athena = Athena()
sqs = Sqs()
for record in event['Records']:
print('body: ' + str(record))
json_query = json.loads(record['body'])
print('postApiBody: ' + str(json_query))
# query = postApiBody['query']
receipt_handle = record['receiptHandle']
try:
athena.start_query(json_query)
sqs.delete_message(receipt_handle)
return {
"statusCode": 200,
"body": json.dumps({
"code ": 'OK',
"message ": 'SUCCESS'
})
}
except ClientError as e:
logging.error(e)
print(e)
return {
"statusCode": 500,
"body": json.dumps({
"code ": 'ERROR',
"message ": e
})
}