# -*- coding: utf-8 -*-
# @Author  : ChenZhaoyuchen
# @Time    : 2024/9/26 16:00
# @File    : setting.py

import mysql.connector

# 初始url
url_start = 'https://www.anjuke.com/fangjia'

# 代理ip
proxyHost = "proxy.abuyun.com"
proxyPort = "9020"
proxyUser = "HD24V56282LK28DD"
proxyPass = "BECAB87B8820340C"
proxyMeta = "http://%(user)s:%(pass)s@%(host)s:%(port)s" % {
    "host": proxyHost,
    "port": proxyPort,
    "user": proxyUser,
    "pass": proxyPass,
}
proxies = {
    "http": proxyMeta,
    "https": proxyMeta,
}

# 请求头
headers = {
	'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',
	'accept-encoding':'gzip, deflate, br, zstd',
	'accept-language':'zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6',
	'cache-control':'max-age=0',
	'connection':'keep-alive',
	'host':'www.anjuke.com',
	'if-none-match':"2db91-inlYvGp0xIvRpS6/mdxeLVOjQ9k",
	'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'
}

# mysql数据库
MYSQL_HOST = "117.72.33.120"
MYSQL_PORT = 3306
MYSQL_USER = "root"
MYSQL_PASS = "zzh9472"
MYSQL_DB = "czyc_mysql"
REDIS_HOST = "117.72.33.120"
REDIS_PORT = 6379
REDIS_PASSWORD =  "ok_laidian_mima_123"

db = mysql.connector.connect(
    host=MYSQL_HOST,  # MySQL服务器地址
    user=MYSQL_USER,  # 用户名
    password=MYSQL_PASS,  # 密码
    database=MYSQL_DB  # 数据库名称
)