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,url from seo.sns_kw where client="理茶"')
for c in cur:
    lst.append([c['term'],c['url']])


print(lst)
# r = redis.Redis(host='db.ptt.cx', port=6379, db=1,password='choozmo9')
# r.set(lst)
['中 美 街 飲料', 'https://www.daisyyohoho.com/richa-drinks/'], ['中 美 街 飲料', 'https://www.walkerland.com.tw/article/view/340526'], ['中 美 街 飲料', 'https://www.facebook.com/Richa.drinks/'], ['中 美 街 飲料店', 'https://www.walkerland.com.tw/article/view/340526'], ['中 美 街 飲料 店', 'https://chiaoda.com/richa/'], ['勤美飲料店', 'https://playqueen888.com/tourall.php?twId=772&twlistId=1'], ['台中必喝飲料', 'https://playqueen888.com/tourall.php?twId=772&twlistId=1'], ['勤美 飲料 內用', 'https://www.walkerland.com.tw/article/view/340526'], ['精誠 路 飲料 店', 'https://chiaoda.com/richa/'], ['中 美 街 飲料 店推薦', 'https://zh-tw.facebook.com/Richa.drinks/'], ['台中中美街飲料', 'https://www.daisyyohoho.com/richa-drinks/'], ['中美街飲料推薦', 'https://www.daisyyohoho.com/richa-drinks/'], ['內用的手搖飲料店', 'https://taiwan17go.com/richa/'], ['台中限定飲料店', 'https://taiwan17go.com/richa/'], ['台中西區飲料推薦', 'https://chiaoda.com/richa/'], ['台中內用飲料店', 'https://chiaoda.com/richa/'], ['精誠路飲料', 'https://chiaoda.com/richa/'], ['台中中美街飲料', 'https://www.facebook.com/Richa.drinks/'], ['中美街 手搖飲', 'https://www.walkerland.com.tw/article/view/340526'], ['中美街 手搖飲', 'https://wandatw.com/richa/'], ['中美街手搖', 'https://www.daisyyohoho.com/richa-drinks/'], ['精誠路手搖', 'https://chiaoda.com/richa/']

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