run_sheet.py 1.0 KB

1234567891011121314151617181920212223242526272829303132333435363738
  1. import sys
  2. import codecs
  3. import traceback
  4. import requests
  5. import re
  6. import pandas as pd
  7. import random
  8. import urllib
  9. import json
  10. import gspread
  11. import datetime
  12. from gspread_pandas import Spread, Client
  13. from oauth2client.service_account import ServiceAccountCredentials
  14. import os
  15. import redis
  16. import time
  17. r = redis.Redis(host='db.ptt.cx', port=6379, db=1,password='choozmo9')
  18. js=r.get('innews_sheet')
  19. jsobj=json.loads(js)
  20. while True:
  21. kw=random.choice(jsobj) # 第一次(三組關鍵字)
  22. kw_innews = '引新聞 ' # 第二次(隨機選擇兩組關鍵字與引新聞)
  23. num = random.choices([0,1,2],k=2)
  24. for i in num:
  25. kw_innews+=kw['kw'].split(' ')[i]+' '
  26. print(kw)
  27. # os.chdir('/Users/zooeytsai/kw_tools/INNNews')
  28. os.system('python3 general_clickbot.py get --kw="'+kw['kw']+'" --domain=innews.com.tw')
  29. print('等待')
  30. time.sleep(120)
  31. # time.sleep(120)
  32. # os.system('python3 general_clickbot.py get --kw="'+kw_innews+'" --domain=innews.com.tw')
  33. # os.system('python notifytest.py send_msg')