kw_tools/SEO/mysql_to_redis.py

import dataset
import pymysql
pymysql.install_as_MySQLdb()
import redis
import json


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="plantA"')
for c in cur:
    lst.append([c['term'],c['domain']])
db.close()

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

#####用記事本替換#######