import json
import redis
import pymysql
def main():
# 指定redis数据库信息
rediscli = redis.StrictRedis(host=‘10.0.126.13’, port=6379, db=0)
# 指定mysql数据库
mysqlcli = pymysql.connect(host=‘47.94.252.144’, user=‘root’, passwd=’***’, db=‘tc58’, port=3306,
use_unicode=True)
while True:
# FIFO模式为 blpop,LIFO模式为 brpop,获取键值
source, data = rediscli.blpop(["zufang:items"])
item = json.loads(data)
try:
# 使用cursor()方法获取操作游标
cur = mysqlcli.cursor()
# 使用execute方法执行SQL INSERT语句
cur.execute(
"INSERT INTO zufang(title, room, pic, price, jingjiren, address, phone) VALUES (%s, %s, %s, %s, %s, %s, %s)",
[item['title'], item['room'], item['pic'], item['price'], item['jingjiren'], item['address'],
item['phone']])
# 提交sql事务
mysqlcli.commit()
# 关闭本次操作
cur.close()
except pymysql.Error as e:
print("Mysql Error %d: %s" % (e.args[0], e.args[1]))
if name == ‘main’:
main()