Proxy'leri kontrol edip veri tabanına kaydetme hakkında

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()```

![veritabani|639x484](upload://fYHUmcZ20sFYq2vGRdc5sSfSQVw.png)
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 :

![proxykontrol1|690x345](upload://oGy3AfNpDJz3fzv7F08hiDRwKJ1.png)
kontrol 1 sonuçu tutmadığını gördüm sonra siteden dir diyerek

![proxykontrol2|690x291](upload://pDRTCK89kRMzcBMfGJzl3vgcqvt.png)
ikinci kontrolu yaptım acaba nerede yanlış yapıyor olabilirim?

Düzeltmeyi başardım şükür saat 2:13 tam 8 saatimi aldı