| 123456789101112131415161718192021 |
- 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/']
- #####用記事本替換#######
|
