Мобильная версияБлагодаря некоторому журналированию я вижу, что прокси-серверы циклически работают правильно, но независимо от того, что я делаю не вижу использования прокси на панели управления прокси. Мало того, он записывает около 8 частей, а затем зависает в сообщении «Прослушивание браузера: info», что и происходит без использования прокси. Они определенно не используются для запросов, хотя я настроил их точно так, как указано в документации PyPartPicker GitHub и PIP. Есть ли у кого-нибудь идеи относительно того, как на самом деле узнать, какой IP-адрес используется для соединения? Единственное, что может быть, прокси-серверы ДОЛЖНЫ быть Socks5? Но похоже, что они есть. Я использую бесплатный план Webshare.io. Или если я делаю что-то не так? Любая помощь будет оценена
import pypartpicker
import time
import random
from supabase import create_client, Client
import logging
from requests.exceptions import HTTPError
import requests_html
import asyncio
from itertools import cycle
proxy_list = [
"socks5://lxpclygj:9bauszs4gj1x@198.23.239.134:6540",
"socks5://lxpclygj:9bauszs4gj1x@207.244.217.165:6712",
"socks5://lxpclygj:9bauszs4gj1x@107.172.163.27:6543",
"socks5://lxpclygj:9bauszs4gj1x@64.137.42.112:5157",
"socks5://lxpclygj:9bauszs4gj1x@173.211.0.148:6641",
"socks5://lxpclygj:9bauszs4gj1x@161.123.152.115:6360",
"socks5://lxpclygj:9bauszs4gj1x@167.160.180.203:6754",
"socks5://lxpclygj:9bauszs4gj1x@154.36.110.199:6853",
"socks5://lxpclygj:9bauszs4gj1x@173.0.9.70:5653",
"socks5://lxpclygj:9bauszs4gj1x@173.0.9.209:5792",
]
proxy_cycle = cycle(proxy_list)
session = requests_html.HTMLSession()
# Setup logging
logging.basicConfig(level=logging.INFO, format="%(asctime)s - %(levelname)s - %(message)s")
# Initialize Supabase client
url = "https://kfykcyomsfroptqipcez.supabase.co" # Replace with your Supabase URL
key = "eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJzdXBhYmFzZSIsInJlZiI6ImtmeWtjeW9tc2Zyb3B0cWlwY2V6Iiwicm9sZSI6ImFub24iLCJpYXQiOjE3MzQ3NjE2MDEsImV4cCI6MjA1MDMzNzYwMX0.jEeyzZOdS7YA0fGrPJpV8ganlGtjwkHf_j4DhXhMMEo" # Replace with your Supabase API key
try:
supabase: Client = create_client(url, key)
logging.info("Connected to Supabase successfully.")
except Exception as e:
logging.error(f"Failed to connect to Supabase: {e}")
exit(1)
# Supported Product Types
CPU_PRODUCTS = ["Intel Core i3", "Intel Core i5", "Intel Core i7", "Intel Core i9", "Intel Xeon", "AMD Ryzen 3", "AMD Ryzen 5", "AMD Ryzen 7", "AMD Ryzen 9", "AMD Threadripper", "AMD Athlon 3000G", "AMD Athlon 200GE", "Intel Pentium G6400", "Intel Pentium 5", "Intel Pentium 6", "Intel Pentium 7", "Intel Celeron G4", "Intel Celeron G5", "Intel Celeron G6"]
def response_retriever(url):
retries = 5
backoff_time = 2 # Initial backoff in seconds
for _ in range(retries):
proxy = next(proxy_cycle) # Rotate proxy
try:
logging.info(f"Using proxy {proxy} for {url}")
response = session.get(url, proxies={"http": proxy, "https": proxy})
if response.status_code == 200:
logging.info(f"Successfully retrieved response from {url} using proxy {proxy}")
return response
elif response.status_code == 429:
logging.warning(f"Rate limited (429) for {url}. Retrying in {backoff_time}s...")
time.sleep(backoff_time)
backoff_time *= random.uniform(1.5, 2.0) # Exponential backoff
else:
logging.warning(f"Unexpected status code {response.status_code} for {url}")
return None
except requests_html.RequestException as e:
logging.error(f"Failed to connect to {url} using proxy {proxy}: {e}")
time.sleep(backoff_time)
backoff_time *= random.uniform(1.5, 2.0) # Exponential backoff
logging.error(f"Failed to retrieve a valid response after {retries} attempts for {url}")
return None
# Initialize PyPartPicker Client with the custom response retriever
pcpp = pypartpicker.Client(response_retriever=response_retriever)
async def fetch_top_parts():
async with pypartpicker.AsyncClient() as pcpp:
# Counters for debugging
error_count = 0
warning_count = 0
skipped_parts = []
# Iterate through each product type and fetch all results
for product in CPU_PRODUCTS:
page = 1
while True:
try:
logging.info(f"Fetching {product} parts on page {page}...")
result = await pcpp.get_part_search(product, page=page, region="au")
if result and result.parts:
for part_summary in result.parts:
if part_summary and part_summary.url:
while True:
try:
proxy = next(proxy_cycle)
logging.info(f"Using proxy {proxy} for {part_summary.url}")
part = await pcpp.get_part(part_summary.url)
if part:
# Validate and prepare data for insertion
in_stock_vendors = [
vendor for vendor in part.vendors if vendor.in_stock
] if part.vendors else []
in_stock_vendors.sort(key=lambda v: v.price.total if v.price else float('inf'))
cheapest_vendor = in_stock_vendors[0] if in_stock_vendors else None
data = {
"part_type": "processor",
"name": part.name if part.name else None,
"total_price": cheapest_vendor.price.total if cheapest_vendor and cheapest_vendor.price else None,
"base_price": cheapest_vendor.price.base if cheapest_vendor and cheapest_vendor.price else None,
"discounts": cheapest_vendor.price.discounts if cheapest_vendor and cheapest_vendor.price else None,
"shipping_price": cheapest_vendor.price.shipping if cheapest_vendor and cheapest_vendor.price else None,
"tax_price": cheapest_vendor.price.tax if cheapest_vendor and cheapest_vendor.price else None,
"vendor_store": getattr(cheapest_vendor, "name", "N/A") if cheapest_vendor else None,
"store_product_url": getattr(cheapest_vendor, "buy_url", "N/A") if cheapest_vendor else None,
"vendor_logo_url": getattr(cheapest_vendor, "logo_url", "N/A") if cheapest_vendor else None,
"in_stock": bool(in_stock_vendors) and cheapest_vendor is not None,
"product_url": getattr(part, "url", "N/A"),
"image_urls": part.image_urls if part.image_urls else None,
"manufacturer": part.specs.get("Manufacturer", None) if part.specs else None,
"part_number": part.specs.get("Part #", None) if part.specs else None,
"series": part.specs.get("Series", None) if part.specs else None,
"microarchitecture": part.specs.get("Microarchitecture", None) if part.specs else None,
"core_family": part.specs.get("Core Family", None) if part.specs else None,
"socket": part.specs.get("Socket", None) if part.specs else None,
"core_count": part.specs.get("Core Count", None) if part.specs else None,
"thread_count": part.specs.get("Thread Count", None) if part.specs else None,
"performance_core_clock": part.specs.get("Performance Core Clock", None) if part.specs else None,
"performance_core_boost_clock": part.specs.get("Performance Core Boost Clock", None) if part.specs else None,
"l2_cache": part.specs.get("L2 Cache", None) if part.specs else None,
"l3_cache": part.specs.get("L3 Cache", None) if part.specs else None,
"tdp": part.specs.get("TDP", None) if part.specs else None,
"integrated_graphics": part.specs.get("Integrated Graphics", None) if part.specs else None,
"maximum_supported_memory": part.specs.get("Maximum Supported Memory", None) if part.specs else None,
"ecc_support": part.specs.get("ECC Support", None) if part.specs else None,
"includes_cooler": part.specs.get("Includes Cooler", None) if part.specs else None,
"packaging": part.specs.get("Packaging", None) if part.specs else None,
"lithography": part.specs.get("Lithography", None) if part.specs else None,
"simultaneous_multithreading": part.specs.get("Simultaneous Multithreading", None) if part.specs else None,
"rating_average": getattr(part.rating, "average", None) if part.rating else None,
"rating_count": getattr(part.rating, "count", None) if part.rating else None,
}
supabase.table("cpus").insert([data]).execute()
response = supabase.table("cpus").insert([data]).execute()
logging.info(f"Inserted {data['name']} into database.")
else:
warning_count += 1
logging.warning("Part details could not be fetched.")
break # Exit the retry loop if successful
except AttributeError as e:
if "'NoneType' object has no attribute 'text'" in str(e):
input("Verify link and press Enter to continue...")
else:
raise e
except Exception as e:
error_count += 1
logging.error(f"Error fetching part details: {e}")
break
else:
logging.info(f"No more results for {product} on page {page}.")
break # Exit loop if no more results
page += 1
await asyncio.sleep(4) # Prevent hitting rate limits
except HTTPError as e:
error_count += 1
logging.error(f"HTTP error occurred: {e}")
await asyncio.sleep(10) # Wait before retrying
except Exception as e:
error_count += 1
logging.error(f"Unexpected error: {e}")
await asyncio.sleep(10) # Short wait before retrying
continue
# Final Debug Summary
logging.info("\nDebug Summary:")
logging.info(f"Total Errors: {error_count}")
logging.info(f"Total Warnings: {warning_count}")
logging.info(f"Total Skipped Parts: {len(skipped_parts)}")
if skipped_parts:
for name, part_number in skipped_parts:
logging.info(f"Skipped Part: {name} | Part Number: {part_number}")
asyncio.run(fetch_top_parts())
def response_retriever(url):
retries = 5
backoff_time = 2 # Initial backoff in seconds
for _ in range(retries):
proxy = next(proxy_cycle) # Rotate proxy
try:
logging.info(f"Attempting to use proxy {proxy} for {url}")
# Add proxy verification using an external service
debug_url = "https://httpbin.org/ip" # Service to check the outgoing IP
response = session.get(
debug_url, proxies={"http": proxy, "https": proxy}, timeout=10
)
proxy_ip = response.json().get("origin")
logging.info(f"Outgoing IP as per proxy: {proxy_ip}")
# Verify proxy works by making the actual request
response = session.get(
url, proxies={"http": proxy, "https": proxy}, timeout=10
)
if response.status_code == 200:
logging.info(f"Successfully retrieved response from {url} using proxy {proxy_ip}")
return response
elif response.status_code == 429:
logging.warning(f"Rate limited (429) for {url}. Retrying in {backoff_time}s...")
time.sleep(backoff_time)
backoff_time *= random.uniform(1.5, 2.0) # Exponential backoff
else:
logging.warning(f"Unexpected status code {response.status_code} for {url}")
return None
except requests_html.RequestException as e:
logging.error(f"Proxy {proxy} failed for {url}: {e}")
time.sleep(backoff_time)
backoff_time *= random.uniform(1.5, 2.0) # Exponential backoff
logging.error(f"Failed to retrieve a valid response after {retries} attempts for {url}")
return None
Подробнее здесь: https://stackoverflow.com/questions/793 ... g-utilised
