分类技术下的文章

docker：构建mysql8.0

作者: 忘忧君
时间: 2025-03-24
分类: 技术
评论

1、拉取mysql8.0镜像

docker pull mysql:8.0

2、运行

docker run -d --name mysql8 --restart=unless-stopped -p 3307:3306 \
-v D:/dev/mysql8/data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=123456 mysql:8.0 \ 
--default-authentication-plugin=mysql_native_password

创建虚拟环境

conda create -n mytest python==3.10.8 -y

激活环境

conda activate mytest

退出环境

conda deactivate

环境列表

conda env list

指定虚拟环境python安装依赖包

python -m pip install 包名 -i https://mirrors.aliyun.com/pypi/simple/ --trusted-host=mirrors.aliyun.com

...后续补充

from selenium import webdriver
from selenium.webdriver.common.by import By
from selenium.webdriver.chrome.service import Service
from selenium.common.exceptions import WebDriverException
import time
from datetime import datetime

def get_default_chrome_options():

options = webdriver.ChromeOptions()
options.add_argument("--no-sandbox")
return options

def getLocalSession():

startDate = ""
endDate = ""
# 读取时间配置文件
with open('D:/tmp/seller_open_sets.txt', 'r', encoding='utf-8') as file:
    sets = file.readlines()
    print(sets)
    for setItem in sets:
        setItem = setItem.strip()
        if not setItem:
            continue
        
        if "开始时间" in setItem:
            startDate = setItem.replace("开始时间:", "")
            startDate = startDate.strip()

        if "结束时间" in setItem:
            endDate = setItem.replace("结束时间:", "")
            endDate = endDate.strip()

if not startDate or not endDate:
    print('未配置开始结束时间')
    return

print(startDate)
print(endDate)
# return


# 指定日期
# startDate = "2025-01-25 18:00:00"
# endDate = "2025-01-25 18:15:00"
startDateObject = datetime.strptime(startDate, "%Y-%m-%d %H:%M:%S")
endDateObject = datetime.strptime(endDate, "%Y-%m-%d %H:%M:%S")
# 转为时间戳
startTime = startDateObject.timestamp()
endTime = endDateObject.timestamp()
nowTime = datetime.now().timestamp()

if nowTime < startTime or nowTime > endTime:
    print('不在执行时间内')
    return

# 浏览器用户数据目录路径
user_data_dir = "C:/Users/Admin/AppData/Local/Google/Chrome/User Data"  # 替换为实际路径

# 设置 Chrome 选项
options = webdriver.ChromeOptions()
# options.add_argument("--no-sandbox")
# options.add_argument(f"--user-data-dir={user_data_dir}")
options.add_argument("--user-data-dir=C:/Users/Admin/AppData/Local/Google/Chrome/User Data")
options.add_argument("--profile-directory=Default")  # 使用默认配置文件
options.add_experimental_option("detach", True)

# 启动浏览器
# service = webdriver.ChromeService()
driver = webdriver.Chrome(service=Service("D:/chromedriver/chromedriver.exe"), options=options)
# driver = webdriver.Chrome(service=service, options=options)
# driver = webdriver.Chrome(options=options)

# 打开 Amazon 商铺后台页面
# driver.get("https://sellercentral.amazon.com/")

driver.get("https://sellercentral.amazon.com/coupons/coupons-dashboard-page")

# 获取打开链接
with open('D:/tmp/seller_open_links.txt', 'r', encoding='utf-8') as file:
    lines = file.readlines()
    for line in lines:
        print(line.strip())  # 去掉行末的换行符
        line = line.strip()
        driver.execute_script(f"window.open('{line}', '_blank');")

print(driver.window_handles)

tabs = driver.window_handles[1:]

# nums = 2
# while nums > 0:
while nowTime >= startTime and nowTime <= endTime:
    for pageUrl in tabs:
        driver.switch_to.window(pageUrl)
        driver.implicitly_wait(1.5)

        # todo 执行逻辑
        element = driver.find_element(By.ID, "key")
        element.send_keys("1")

        # actButtons = driver.find_element(By.CLASS_NAME, "actions-cancel-edit")
        # cancelButton = actButtons.find_element(By.TAG_NAME, 'kat-button')
        # searchButton.click()

        # driver.implicitly_wait(5)

        # # 弹框确认
        # actModal = actButtons.find_element(By.TAG_NAME, 'kat-modal')
        # ynButtons = actModal.find_element(By.TAG_NAME, 'kat-button')
        # # 否
        # noButton = ynButtons[0].click()
        # # 是
        # # yesButton = ynButtons[1].click()

        time.sleep(10)

        nowTime = datetime.now().timestamp()

    
driver.quit()

        









# driver.get("https://sellercentral.amazon.com/")
# element = driver.find_element(By.ID, "key")
# element.send_keys("茅台酒")

# driver.implicitly_wait(5)

# searchButton = driver.find_element(By.CSS_SELECTOR,"#search .button")
# searchButton.click()

# driver.implicitly_wait(5)

# # 打开标签页
# # 打开新标签页
# driver.execute_script("window.open('https://www.baidu.com/', '_blank');")
# # 切换到新打开的标签页
# driver.switch_to.window(driver.window_handles[1])


# driver.implicitly_wait(5)


# # 打开一个新的标签页
# driver.execute_script("window.open('https://www.jd.com/', '_blank');")
# # 切换到新打开的标签页
# driver.switch_to.window(driver.window_handles[2])


# # 获取所有标签页句柄
# tabs = driver.window_handles
# print("Tabs:", tabs)

# 创建新实例
# driver1 = webdriver.Chrome(service=Service("D:/chromedriver/chromedriver.exe"), options=options)
# driver1.get("https://www.baidu.com/")



# driver.quit()

getLocalSession()

[BLOCK_START]
<开始时间>: 2025-02-05 13:40:00
<结束时间>: 2025-02-06 11:35:00
<打开链接>
https://www.jd.com/
https://www.jd.com/
</打开链接>
[BLOCK_END]

isRun = False

startDate = ""
endDate = ""
links = []
# 读取时间配置文件
with open("D:/tmp/seller_open_sets.txt", "r", encoding="utf-8") as file:
    content = file.read()

pattern = r"\[BLOCK_START\](.*?)\[BLOCK_END\]"
matches = re.findall(pattern, content, re.DOTALL)

for match in matches:
    print("匹配到的块:", match)

    tmpLinks = []
    inside_block = False
    lines = match.splitlines()
    print(lines)

    for line in lines:
        if not line:
            continue
        
        if "<开始时间>:" in line:
            startDate = line.replace("<开始时间>:", "")
            startDate = startDate.strip()

        if "<结束时间>:" in line:
            endDate = line.replace("<结束时间>:", "")
            endDate = endDate.strip()

        # 获取打开链接
        if "<打开链接>" in line:
            inside_block = True
            tmpLinks = []
        elif "</打开链接>" in line:
            inside_block = False
            links = tmpLinks
        elif inside_block:
            tmpLinks.append(line.strip())

    if not startDate or not endDate:
        print('未配置开始结束时间')
        continue
    
    # 指定日期
    # startDate = "2025-01-25 18:00:00"
    # endDate = "2025-01-25 18:15:00"
    startDateObject = datetime.strptime(startDate, "%Y-%m-%d %H:%M:%S")
    endDateObject = datetime.strptime(endDate, "%Y-%m-%d %H:%M:%S")
    # 转为时间戳
    startTime = startDateObject.timestamp()
    endTime = endDateObject.timestamp()
    nowTime = datetime.now().timestamp()

    if nowTime < startTime or nowTime > endTime:
        # print('不在执行时间内')
        continue

    isRun = True
    break

if not isRun:
    print("未匹配到运行时间段")
    return

print('匹配到的开始时间: ' + startDate)
print('匹配到的结束时间: ' + endDate)
print(links)

linux配置sftp chroot

作者: 忘忧君
时间: 2025-01-23
分类: 技术
评论

step1: 添加ftp用户

useradd -s /sbin/nologin -m -d /data/www/ledong_web_pc ledong_web_pc

step2: 配置目录权限

chown root:root /data/www/ledong_web_pc
chmod 755 /data/www/ledong_web_pc
chown ledong_web_pc:ledong_web_pc /data/www/ledong_web_pc/dist
chmod 755 /data/www/ledong_web_pc/dist

step3: 配置ssh

vim /etc/ssh/sshd_config

添加如下内容

Subsystem sftp internal-sftp
Match User ledong_web_pc
      ChrootDirectory /data/www/ledong_web_pc
      ForceCommand internal-sftp

step4 重启ssh

systemctl restart sshd

PS：如果nginx做代理，要修改nginx.conf中user为root

正则表达式常用规则

作者: 忘忧君
时间: 2025-01-23
分类: 技术
评论

一、校验数字的表达式

数字：^[0-9]*$

n位的数字：^\d{n}$

至少n位的数字：^\d{n,}$

m-n位的数字：^\d{m,n}$

零和非零开头的数字：^(0|1-9*)$

非零开头的最多带两位小数的数字：^(1-9*)+(.[0-9]{1,2})?$

带1-2位小数的正数或负数：^(-)?\d+(.\d{1,2})?$

正数、负数、和小数：^(-|+)?\d+(.\d+)?$

有两位小数的正实数：^[0-9]+(.[0-9]{2})?$

有1~3位小数的正实数：^[0-9]+(.[0-9]{1,3})?$

非零的正整数：^[1-9]\d$ 或 ^([1-9][0-9]*){1,3}$ 或 ^+?1-9$

非零的负整数：^-[1-9][]0-9"*$ 或 ^-[1-9]\d*$

非负整数：^\d+$ 或 ^[1-9]\d*|0$

非正整数：^-[1-9]\d*|0$ 或 ^((-\d+)|(0+))$

- 阅读剩余部分 -

docker：构建mysql8.0

python conda安装