import urllib.request
import urllib.response
from bs4 import BeautifulSoup
import cx_Oracle
 
url_euribor = 'https://www.bankai.lt/paskolos/tarpbankines-palukanu-normos/euribor'
r1 = urllib.request.Request(url_euribor)
response1 = urllib.request.urlopen(r1)
response_data1 = response1.read()
 
soup1 = BeautifulSoup(response_data1, "html.parser")
 
date1 = soup1.find('div', {"class": "tline tline50 rowbox1"}).find('div', {"class": "t cb s14 rico icob"}).text
EUR1M = soup1.find('div', {"class": "tline tline50 rowbox1"}).find('div', {"class": "t fr bl tc s14 rci-1-3 rick cell row1 col3"}).text
EUR3M = soup1.find('div', {"class": "tline tline50 rowbox1"}).find('div', {"class": "t fr bl tc s14 rci-1-4 rick cell row1 col4"}).text
EUR6M = soup1.find('div', {"class": "tline tline50 rowbox1"}).find('div', {"class": "t fr bl tc s14 bgy rci-1-5 rick cell row1 col5"}).text
EUR12M = soup1.find('div', {"class": "tline tline50 rowbox1"}).find('div', {"class": "t fr bl tc s14 rci-1-6 rick cell row1 col6"}).text
print(date1)
line1 = "insert into s_base_rates (BRA_BRT_MNEMO, BRA_DT, BRA_CRNC, BRA_VALUE) values ('1MEURIBOR', TO_DATE('" + date1 + "','YYYY-MM-DD'), 'EUR', '" + EUR1M + "');\n"
line2 = "insert into s_base_rates (BRA_BRT_MNEMO, BRA_DT, BRA_CRNC, BRA_VALUE) values ('3MEURIBOR', TO_DATE('" + date1 + "','YYYY-MM-DD'), 'EUR', '" + EUR3M + "');\n"
line3 = "insert into s_base_rates (BRA_BRT_MNEMO, BRA_DT, BRA_CRNC, BRA_VALUE) values ('6MEURIBOR', TO_DATE('" + date1 + "','YYYY-MM-DD'), 'EUR', '" + EUR6M + "');\n"
line4 = "insert into s_base_rates (BRA_BRT_MNEMO, BRA_DT, BRA_CRNC, BRA_VALUE) values ('1YEURIBOR', TO_DATE('" + date1 + "','YYYY-MM-DD'), 'EUR', '" + EUR12M + "');\n"
... сокращено ...
file_name = "Libor_" + date1 + ".sql"
with open(file_name, 'w') as output_file:
    output_file.write("-- EURIBOR/LIBOR procentines normos uz " + date1 + "\n")
 
lines = line1 + line2 + line3 + line4 + line5 + line6 + line7 + line8 + line9 + line10 + line11 + line12
with open(file_name, 'a') as output_file:
    output_file.write(lines)