回答此问题可获得 20 贡献值,回答如果被采纳可获得 50 分。
<p>我正在尝试用python执行一个动态sql查询。它看起来像下面</p>
<pre><code>import json
from decimal import Decimal
import psycopg2
def initial_execution(param_name):
time = get_timestamp(param_name)
query = 'SELECT name, account_mgr, addr1, addr2, ap_email, bill_to_nbr, billto_only, city, controlling_nbr, controlling_only, country, cust_contact, email, load_create_date, load_update_date, nbr, owner, sales_rep, source_system, state, station, zip FROM public.customers WHERE billto_only = 'Y' OR controlling_only = 'Y' AND load_create_date >= \''+time+'\' OR load_update_date >= \''+time+'\''
queryData = execute_db_query(query)
</code></pre>
<p>执行\u db\u查询->;此函数使用pscopg2以红移方式运行
我通过从用户输入中动态提取“时间”来执行此脚本。我犯了一个错误</p>
<pre><code>[ERROR] Runtime.UserCodeSyntaxError: Syntax error in module
'src/customers':
invalid syntax (customers.py, line 78)
Traceback
(most recent call last): File "/var/task/src/customers.py"
Line 78 query = 'SELECT name,billto_only, controlling_only , load_create_date, load_update_date, nbr, owner, sales_rep,
source_system, state, station, zip FROM public.test WHERE billto_only
= 'Y' OR controlling_only = 'Y' AND load_create_date >= \''+time+'\' OR load_update_date >= \''+time+'\''
</code></pre>
<p>sql中的相同查询如下所示编写并正确执行</p>
<pre><code>SELECT name,billto_only, controlling_only,load_create_date, load_update_date, nbr, owner, sales_rep, source_system, state, station, zip FROM public.test
WHERE (billto_only = 'Y' OR controlling_only = 'Y') AND (load_create_date >= '2020-10-09 07:04:51' OR load_update_date >= '2020-10-09 07:04:51') limit 5;
</code></pre>