df = pd.read_excel('autodoor.xml')
keys = ['time', 'user_name', 'rfid_key', 'litre', 'type']
df[keys].to_sql(name, conn, if_exists='replace')newdf[keys].to_sql(name, conn, if_exists='replace').from seleniumwire import webdriver
from selenium.webdriver.chrome.service import Service as ChromeService
from webdriver_manager.chrome import ChromeDriverManager
from selenium.webdriver.common.by import By
# Selenium Wire configuration to use a proxy
proxy_username = 'fgrlkbxt'
proxy_password = 'cs01nzezlfen'
seleniumwire_options = {
'proxy': {
'http': f'http://{proxy_username}:{proxy_password}@185.199.229.156:7492',
'verify_ssl': False,
},
}
driver = webdriver.Chrome(
seleniumwire_options=seleniumwire_options
)
driver.get('http://httpbin.org/ip')
print(driver.find_element(By.TAG_NAME, 'body').text) # { "origin": "185.199.229.156" }