kw_tools/SEO/mysql_to_redis.py

import dataset
import pymysql
pymysql.install_as_MySQLdb()
import redis


db = dataset.connect('mysql://choozmo:pAssw0rd@db.ptt.cx:3306/seo?charset=utf8mb4')
table=db['selected_kw']
lst = []
cur = db.query('select term,domain from seo.selected_kw where client="鑫富"')
for c in cur:
    lst.append([c['term'],c['domain']])

print(lst)
# r = redis.Redis(host='db.ptt.cx', port=6379, db=1,password='choozmo9')
# r.set(lst)