主页 / user-543730

shezyy's questions

Martin Hope
shezyy
Asked: 2023-07-15 06:30:10 +0000 UTC
  • 5

一个有趣的任务出现了。表可以具有无限数量的列。每一列对应一个日期，并且也只有 4 个单元格。您需要显示所有空列的名称。DB - PostgreSQL，如果它突然发挥作用的话。我很想听听您的选择！

在此输入图像描述

UPD：我正在创建一个聊天机器人，人们可以在其中与同一位医生预约。这位医生没有固定的日程，即 没有明确的2/2或3/3。因此，为了记录在案，用户需要选择他来的日期。我想出了以下方案：医生向聊天机器人写入他可以接待客户的日期，之后创建一个请求，将新列添加到数据库中，其名称包含日期。嗯，每一行都是为一个人设计的，即 记录。

sql
Martin Hope
shezyy
Asked: 2023-07-14 03:04:45 +0000 UTC
  • 5

我开始学习SQL，当我尝试连接到数据库时，出现以下错误NameError：名称'连接'未定义我提供代码：

import psycopg2
from auth_data import host, password, db_name, user


def add_to_db():
    global connection
    try:
        connection = psycopg2.connect(host=host, user=user, password=password, database=db_name)

        with connection.cursor() as cursor:
            cursor.execute(f"SELECT * FROM records")
            connection.commit()
            result = cursor.fetchall()
            return result
    except Exception as _ex:
        print(f'[INFO] Error while working with PostgreSQL {_ex}')
    finally:
        if connection:
            connection.close()
            print(f'[INFO] PostgreSQL connection closed')

add_to_db()
python
Martin Hope
shezyy
Asked: 2023-05-29 04:12:05 +0000 UTC
  • 5

我实际上进入了某种死胡同，或者我没有看到最后的一切。当然，我更倾向于前者。

import requests


url = 'https://store.steampowered.com/specials'
s = requests.Session()
s.cookies.set('Steam_Language', 'russian', domain='store.steampowered.com')
r = s.get(url)
src = r.text

with open("index.html", "w", encoding="utf-8") as file:
    file.write(src)

我真的不明白这里代码的意义，但是哦，好吧。结果是我得到一个空数组后，我决定将所有内容写入 html 文件。我查看了 html 文件，意识到页面上除了标题之外的所有内容都是从服务器加载的。但我找不到确切的位置。请帮帮我！

需要这个街区的游戏：

需要这个街区的游戏

python
Martin Hope
shezyy
Asked: 2023-04-20 04:39:43 +0000 UTC
  • 7

我正在编写一个应该采用折扣结束日期的解析器，但出于某种原因，采用了网站的英文版本，尽管在标头中指定了接受语言。请帮忙解析俄罗斯数据！

import requests
from bs4 import BeautifulSoup
import re


def get_data(url):
    headers = {
        'Accept-Language': 'ru-RU,ru;q=0.9,en-US;q=0.8,en;q=0.7',
        'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) '
                      'Chrome/112.0.0.0 Safari/537.36'

    }

    req = requests.get(url, headers)
    soup = BeautifulSoup(req.text, 'lxml')
    date = soup.find('p', class_='game_purchase_discount_countdown').text
    regex_pattern = r'(\d{1,2})\s+(\w+)'

    match = re.search(regex_pattern, date)

    if match:
        day = match.group(1)
        month = match.group(2).capitalize()
        print(f"{day} {month}")
    

get_data("https://store.steampowered.com/app/552500/Warhammer_Vermintide_2/")

结论：

25 April
парсер
Martin Hope
shezyy
Asked: 2023-03-08 07:30:04 +0000 UTC
  • 5
from selenium import webdriver, common
import time
from bs4 import BeautifulSoup
from selenium import webdriver
import time
from selenium.webdriver.chrome.options import Options
from selenium.webdriver.chrome.service import Service
from selenium.webdriver.common.by import By
import json

url = f'https://store.steampowered.com/specials/'
s = Service(executable_path='C:\Пользователи\Олег\PycharmProjects\TelegramBot\chromedriver_win32\chromedriver.exe')
options = webdriver.ChromeOptions()
driver = webdriver.Chrome(service=s, options=options)
driver.get(url)
time.sleep(3)
try:
    for i in range(650):
        driver.execute_script("window.scrollTo(0, document.body.scrollHeight);")
        time.sleep(2)
        driver.find_element(By.XPATH, '//div[@class="saleitembrowser_ShowContentsContainer_3IRkb"]//button[text()="Показать больше"]').click()
except common.exceptions.NoSuchElementException:
    pass
time.sleep(3)
html = driver.page_source
soup = BeautifulSoup(html, "lxml")
games_names = soup.find_all('div', class_='salepreviewwidgets_StoreSaleWidgetRight_1lRFu')
all_sales_dict = {}
for game in games_names:
    try:
        name = game.find('div', 'salepreviewwidgets_TitleCtn_1F4bc').find('a').text
        price_sale = game.find('div', 'salepreviewwidgets_StoreSalePriceBox_Wh0L8').text
        price_orig = game.find('div', 'salepreviewwidgets_StoreOriginalPrice_1EKGZ').text
        sale = game.find('div', 'salepreviewwidgets_StoreSaleDiscountBox_2fpFv').text
        price = (f"Цена без скидки: {price_orig}. Скидка: {sale}. Цена со скидкой: {price_sale}")
        all_sales_dict[name] = price
    except AttributeError:
        pass
with open("all_sales.json", "w", encoding="utf-8") as file:
    json.dump(all_sales_dict, file, indent=4, ensure_ascii=False)
python