check_articles_task.py 391 B

1234567891011121314151617181920212223
  1. """
  2. @author: luojunhui
  3. """
  4. from datetime import datetime, timedelta
  5. from tqdm import tqdm
  6. from applications import WeixinSpider, PQMySQL
  7. db_client = PQMySQL()
  8. spider = WeixinSpider()
  9. def main():
  10. """
  11. 入口函数
  12. :return:
  13. """
  14. select_sql = f"""
  15. SELECT accountName, ghId, ContentUrl
  16. FROM official_articles_v2
  17. WHERE publish_timestamp > ''
  18. """