第四篇：python操作数据库时的传参问题

def sql_func(time):
    time = "‘" + time + "‘"
    fail_sql=‘‘‘
    SELECT substr(s_start_time,1,10)  "日期",count(*)  "失败数量"
      FROM T_SG_WS_EXE_LOG L
     WHERE 1 = 1
       AND (S_WS_METHOD = ‘NotifyOrderStatus‘ OR (S_WS_METHOD = ‘placeOrder‘ AND S_IS_OK = ‘false‘))
    and s_request_str not like  ‘%"deployStatus":"2120"%‘ and s_request_str not like  ‘%"deployStatus":"0"%‘
    and  substr(s_start_time,1,10) = ‘‘‘+time +‘‘‘group by substr(s_start_time,1,10) 
    ‘‘‘
    # 使用cursor进行各种操作
    y=cr.execute(fail_sql)
    result = y.fetchall()
    return result

参考文档：https://www.cnblogs.com/goodhacker/p/3257882.html

第四篇：python操作数据库时的传参问题

标签：自己   失败   www.   hacker   als   group by   遇到   insert   log