```python
defexecute_editProjStatus(status,name):
time.sleep(1)#等待1秒,因为不等待,更新操作会报错
conn = pymysql.connect(host="数据库的ip", user="数据库的用户名", password="数据库密码", database="数据库的库名")
cur = conn.cursor()
sql ='update `project` set `status`="%s" where `name`="%s"'%(status,name)
res=cur.execute(sql)# SQL执行# 关闭游标和连接
cur.close()
conn.commit()# 增删改都要要提交数据
conn.close()return res
defexecute_editDemaStatus(status,deliverStatus,demandId):
time.sleep(1)#等待1秒,因为不等待,更新操作会报错
conn = pymysql.connect(host="数据库的ip", user="数据库的用户名", password="数据库密码", database="数据库的库名")
cur = conn.cursor()
sql ='update `demand` set `status`="%s",delivery_status="%s" where id="%s"'%(status,deliverStatus,demandId)
res=cur.execute(sql)# SQL执行# 关闭游标和连接
cur.close()
conn.commit()# 增删改都要要提交数据
conn.close()return res
查询操作
```python
defexecute_getDetailIdById(strategyId):
conn = pymysql.connect(host="数据库的ip", user="数据库的用户名", password="数据库密码", database="数据库的库名")
cur = conn.cursor()
sql ='SELECT id FROM `strategy_detail` where strategy_id =%s;'%(strategyId)
res=cur.execute(sql)# SQL执行
res = cur.fetchall()# 所有数据# 关闭游标和连接
cur.close()
conn.close()return res[0][0]defexecute_getDemandId(name,merchantId):
time.sleep(1)
conn = pymysql.connect(host="数据库的ip", user="数据库的用户名", password="数据库密码", database="数据库的库名")
cur = conn.cursor()
sql ="SELECT id FROM demand where name like '%%%s%%' and merchant_id='%s' order by create_time desc limit 1 "%(name,merchantId)
res=cur.execute(sql)# SQL执行
res = cur.fetchall()# 所有数据# 关闭游标和连接
cur.close()
conn.close()return res[0][0]