python - AWS BOTO3 连接到 MS SQL 数据库时出错

Question

当我想使用 AWS BOTO3 python(在 aws lambda 上)连接和解析对 RDS-MSSQL 的查询时，请帮助我修改代码

这是我的代码

import json
import boto3

database_name = database_name 
db_cluster_arn = db_cluster_arn 
query=query
rds_client=boto3.client('rds-data')

def execute_statement(sql):{
    print('===== Example - Simple query =====')
    response = rds_client.execute_statement(
        database=database_name,
        resourceArn=db_cluster_arn,
        sql=sql
    )
    return response

    response = execute_statement(query)
    print(response['records'])

My Error

Answer 1

发现两个问题。如果你解决了这些问题，它应该可以工作。

1. 下面一行的语法中有一个 {:

   def execute_statement(sql):{
   

2. 下面的行也没有正确缩进。

   response = execute_statement(query)
   

这是修复后的代码:

import json
import boto3

database_name = 'HSA_NONSAN_PROD'
db_cluster_arn = 'arn:aws:rds:ap-southeast-1:499461857546:db:prod-hsaplus-db-2'
query='SELECT (CASE WHEN Status=1 THEN \'OK\' ELSE \'BAD\' END) AS Status FROM dbo.tbAllCustomer_NONSAN_JOBSTATUS WHERE JobRunNo=(SELECT MAX(JobRunNo) FROM dbo.tbAllCustomer_NONSAN_JOBSTATUS)'
rds_client=boto3.client('rds-data')

def execute_statement(sql):
    print('===== Example - Simple query =====')
    response = rds_client.execute_statement(
        database=database_name,
        resourceArn=db_cluster_arn,
        sql=sql
    )
    return response

response = execute_statement(query)
print(response['records'])