Python 更新sql

def updateSystemAccount(response):
    print('--------------返回数据是',response.json)
    
    host = 'xxx-mysql-m.a.pa.com'
    user = 'hfqa'
    passwd = 'qn3p@bI0qg'
    db = 'dcloud_pack_account_db'
    conn = pymysql.connect(host,user,passwd,db)
    cur = conn.cursor()
    
    accountId = response.json['data']['id']
    sql_update = "update t_standard_account set is_deleted = '%d' where id = %d"
    
    try:
        cur.execute(sql_update % (1,accountId))  #像sql语句传递参数
        #提交
        conn.commit()
        print('update成功')
        
    except Exception as e:
        #错误回滚
        conn.rollback()
    finally:
        conn.close()