setting.py 1.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354
  1. # -*- coding: utf-8 -*-
  2. # @Author : ChenZhaoyuchen
  3. # @Time : 2024/9/26 16:00
  4. # @File : setting.py
  5. import mysql.connector
  6. # 初始url
  7. url_start = 'https://www.anjuke.com/fangjia'
  8. # 代理ip
  9. proxyHost = "proxy.abuyun.com"
  10. proxyPort = "9020"
  11. proxyUser = "HD24V56282LK28DD"
  12. proxyPass = "BECAB87B8820340C"
  13. proxyMeta = "http://%(user)s:%(pass)s@%(host)s:%(port)s" % {
  14. "host": proxyHost,
  15. "port": proxyPort,
  16. "user": proxyUser,
  17. "pass": proxyPass,
  18. }
  19. proxies = {
  20. "http": proxyMeta,
  21. "https": proxyMeta,
  22. }
  23. # 请求头
  24. headers = {
  25. 'accept':'text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7',
  26. 'accept-encoding':'gzip, deflate, br, zstd',
  27. 'accept-language':'zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6',
  28. 'cache-control':'max-age=0',
  29. 'connection':'keep-alive',
  30. 'host':'www.anjuke.com',
  31. 'if-none-match':"2db91-inlYvGp0xIvRpS6/mdxeLVOjQ9k",
  32. 'user-agent':'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36 Edg/129.0.0.0'
  33. }
  34. # mysql数据库
  35. MYSQL_HOST = "117.72.33.120"
  36. MYSQL_PORT = 3306
  37. MYSQL_USER = "root"
  38. MYSQL_PASS = "zzh9472"
  39. MYSQL_DB = "czyc_mysql"
  40. REDIS_HOST = "117.72.33.120"
  41. REDIS_PORT = 6379
  42. REDIS_PASSWORD = "ok_laidian_mima_123"
  43. db = mysql.connector.connect(
  44. host=MYSQL_HOST, # MySQL服务器地址
  45. user=MYSQL_USER, # 用户名
  46. password=MYSQL_PASS, # 密码
  47. database=MYSQL_DB # 数据库名称
  48. )