Python requests ile proxy kontrol edip veritabanına kayıt etmeyi yapmaya çalışıyorum ama ne kadar doğruluk payı var bilemedim sizden ricam kontrol edip eksiğimi söyleyebilir misiniz ?
from selenium import webdriver
from selenium.webdriver.common.by import By
from selenium.webdriver.common.keys import Keys
from selenium.webdriver.support.ui import Select
from selenium.common.exceptions import NoSuchElementException
from selenium.common.exceptions import NoAlertPresentException
from selenium.common.exceptions import TimeoutException
from selenium.common.exceptions import WebDriverException as WDE
from selenium.common.exceptions import InvalidArgumentException
from selenium.webdriver.firefox.options import Options
from threading import Thread
from io import open
import time
import datetime
from datetime import date
import os
import sys
#reload(sys)
#sys.setdefaultencoding("utf-8")
from tkinter import *
import requests
from bs4 import BeautifulSoup
import mysql.connector
from random import choice
from random import randint
import pandas as pd
class Uygulama():
def __init__(self):
#HEADER
print("__SIRA NUMARASI__|____PROXY KAYIT TARİHİ____|__________________PROXY DURUM__________________|___PROXY ONAY___|________PROXY ADRES_______")
for i in range(1,100):
try:
self.veritabani()
self.onay = None
proxy = self.GetProxy()
proxyies = {"http": f"http://{proxy}"}
url = 'https://www.google.com/'
r = requests.get(url, proxies=proxyies)
if r.status_code == 200:
self.onay = 1
self.bugun = datetime.datetime.now()
self.tarih = f"{self.bugun.year}-{self.bugun.month}-{self.bugun.day} {self.bugun.hour}:{self.bugun.minute}{self.bugun.second}"
now = datetime.datetime.utcnow()
sql1 = "SELECT * FROM bcvc WHERE proxyadress = '"+proxy+"'"
self.database.execute(sql1)
proxysorgula = self.database.fetchall()
if proxysorgula:
print("========================================================================================================================================")
print(f"{i} - Proxy : {proxy} Sistemde Mevcuttur.")
print("========================================================================================================================================")
else:
print(f" {i} | {self.tarih} | Proxy Bağlanabilirlik Durumu : Başarılı | {self.onay} | {proxy}")
sql = "INSERT INTO bcvc SET proxyadress = %s, proxyregisterdate = %s, proxyonay = %s"
self.database.execute(sql,(proxy,now.strftime('%Y-%m-%d %H:%M:%S'),self.onay))
self.db.commit()
else:
self.onay = 0
self.bugun = datetime.datetime.now()
self.tarih = f"{self.bugun.year}-{self.bugun.month}-{self.bugun.day} {self.bugun.hour}:{self.bugun.minute}{self.bugun.second}"
now = datetime.datetime.utcnow()
sql1 = "SELECT * FROM bcvc WHERE proxyadress = '" + proxy + "'"
self.database.execute(sql1)
proxysorgula = self.database.fetchall()
if proxysorgula:
print("========================================================================================================================================")
print(f"{i} - Proxy : {proxy} Sistemde Mevcuttur.")
print("========================================================================================================================================")
else:
print(f" {i} | {self.tarih} | Proxy Bağlanabilirlik Durumu : Başarısız | {self.onay} | {proxy}")
sql = "INSERT INTO bcvc SET proxyadress = %s, proxyregisterdate = %s, proxyonay = %s"
self.database.execute(sql, (proxy, now.strftime('%Y-%m-%d %H:%M:%S'), self.onay))
self.db.commit()
except EXCEPTION as e:
print(e)
def veritabani(self):
self.db = mysql.connector.connect(
host="localhost",
user="barron4335",
password="1968Hram",
database="bcvcbots"
)
self.database = self.db.cursor(dictionary=True)
def GetProxy(self,):
url = 'https://free-proxy-list.net/'
r = requests.get(url)
soup = BeautifulSoup(r.content, 'html.parser')
div = soup.find('div', class_='table-responsive')
tbody = div.find("tbody")
proxies = tbody.find_all("tr")
proxy = proxies[randint(0, len(proxies) - 1)]
proxy_ip = proxy.find_all("td")[0].get_text()
proxy_port = proxy.find_all("td")[1].get_text()
return proxy_ip + ":" + proxy_port
if __name__ == '__main__':
Uygulama()```
nerede yanlış yapıyorum yada nerede hatam var bildirirmisiniz requests kullanmakta yeniyim hedefim başarılı olan proxyleri ve başarısız olan proxyleri çekmek
deneyen var mı acaba doğrumu yapıyorum ?
Öncelikle yaptığım dersimin tamamlanmış hali ama hala düzgün çalıştıramıyorum arkadaşlar çıldıracam yardım edermisiniz lütfen ?
import http.client
import ssl
import urllib3.exceptions
from selenium import webdriver
from selenium.webdriver.common.by import By
from selenium.webdriver.common.keys import Keys
from selenium.webdriver.support.ui import Select
from selenium.common.exceptions import NoSuchElementException
from selenium.common.exceptions import NoAlertPresentException
from selenium.common.exceptions import TimeoutException
from selenium.common.exceptions import WebDriverException as WDE
from selenium.common.exceptions import InvalidArgumentException
from selenium.webdriver.firefox.options import Options
from threading import Thread
from io import open
import time
import datetime
from datetime import date
import os
import sys
#reload(sys)
#sys.setdefaultencoding("utf-8")
from tkinter import *
import requests
from bs4 import BeautifulSoup
import mysql.connector
from random import choice
from random import randint
import pandas as pd
class Uygulama():
def __init__(self):
#HEADER
print("__SIRA NUMARASI__|______PROXY KAYIT TARİHİ_____|__________________PROXY DURUM____________________|___PROXY ONAY___|________PROXY ADRES_______")
for i in range(1,100):
try:
self.veritabani()
self.onay = None
proxy = self.GetProxy()
proxyies = {"http": f"http://{proxy}",
"https" : f"http://{proxy}",
"ssl" : f"http://{proxy}"}
url = 'https://www.google.com/'
r = requests.get(url, proxies=proxyies)
if r.status_code == 200:
self.onay = 1
now = datetime.datetime.utcnow()
sql1 = "SELECT * FROM bcvc WHERE proxyadress = '"+proxy+"'"
self.database.execute(sql1)
proxysorgula = self.database.fetchall()
if proxysorgula:
print("=============================================================================================================================================")
print(f"{i} - Proxy : {proxy} Sistemde Mevcuttur.")
print("=============================================================================================================================================")
else:
print(f" {i} | {now.strftime('%Y-%m-%d %H:%M:%S')} | Proxy Bağlanabilirlik Durumu : Başarılı | {self.onay} | {proxy}")
sql = "INSERT INTO bcvc SET proxyadress = %s, proxyregisterdate = %s, proxyonay = %s"
self.database.execute(sql,(proxy,now.strftime('%Y-%m-%d %H:%M:%S'),self.onay))
self.db.commit()
else:
self.onay = 0
now = datetime.datetime.utcnow()
sql1 = "SELECT * FROM bcvc WHERE proxyadress = '" + proxy + "'"
self.database.execute(sql1)
proxysorgula = self.database.fetchall()
if proxysorgula:
print("=============================================================================================================================================")
print(f"{i} - Proxy : {proxy} Sistemde Mevcuttur.")
print("=============================================================================================================================================")
else:
print(f" {i} | {now.strftime('%Y-%m-%d %H:%M:%S')} | Proxy Bağlanabilirlik Durumu : Başarısız | {self.onay} | {proxy}")
sql = "INSERT INTO bcvc SET proxyadress = %s, proxyregisterdate = %s, proxyonay = %s"
self.database.execute(sql, (proxy, now.strftime('%Y-%m-%d %H:%M:%S'), self.onay))
self.db.commit()
except ssl.SSLCertVerificationError:
print("=============================================================================================================================================")
print(f"{i} - Proxy : {proxy} SSL Hatası Mevcuttur.")
print("=============================================================================================================================================")
continue
except http.client.RemoteDisconnected:
print("=============================================================================================================================================")
print(f"{i} - Proxy : {proxy} Bağlı Ana Makine Reddeti.")
print("=============================================================================================================================================")
continue
except urllib3.exceptions.ConnectTimeoutError:
print("=============================================================================================================================================")
print(f"{i} - Proxy : {proxy} Zaman Aşımına Uğradı.")
print("=============================================================================================================================================")
continue
except urllib3.exceptions.MaxRetryError:
print("=============================================================================================================================================")
print(f"{i} - Proxy : {proxy} Bağlantı Sorunu Oluştu.")
print("=============================================================================================================================================")
continue
except requests.exceptions.ConnectTimeout:
print("=============================================================================================================================================")
print(f"{i} - Proxy : {proxy} Zaman Aşımına Uğradı.")
print("=============================================================================================================================================")
continue
except requests.exceptions.ProxyError:
print("=============================================================================================================================================")
print(f"{i} - Proxy : {proxy} Proxy Hatalı.")
print("=============================================================================================================================================")
continue
except requests.exceptions.SSLError:
print("=============================================================================================================================================")
print(f"{i} - Proxy : {proxy} SSL Hatası Mevcuttur.")
print("=============================================================================================================================================")
continue
def grafiks(self):
pass
def veritabani(self):
self.db = mysql.connector.connect(
host="localhost",
user="barron4335",
password="1968Hram",
database="bcvcbots"
)
self.database = self.db.cursor(dictionary=True)
def GetProxy(self,):
url = 'https://free-proxy-list.net/'
r = requests.get(url)
soup = BeautifulSoup(r.content, 'html.parser')
div = soup.find('div', class_='table-responsive')
tbody = div.find("tbody")
proxies = tbody.find_all("tr")
proxy = proxies[randint(0, len(proxies) - 1)]
proxy_ip = proxy.find_all("td")[0].get_text()
proxy_port = proxy.find_all("td")[1].get_text()
return proxy_ip + ":" + proxy_port
if __name__ == '__main__':
Uygulama()```

bu veritabanım bağlanılabilen proxye onay 1 bağlanılamayan proxye onay 0 yazdırdım sonra program düzgün mü diye online proxy kontrol yaptırdığımda ise :

kontrol 1 sonuçu tutmadığını gördüm sonra siteden dir diyerek

ikinci kontrolu yaptım acaba nerede yanlış yapıyor olabilirim?
Düzeltmeyi başardım şükür saat 2:13 tam 8 saatimi aldı