Работа с базой данных в python

#!/usr/bin/env python
# -*- coding: UTF-8 -*-
print('Content-Type: text/html; charset=utf-8\n')
 
import pymysql
from config import host, user, password, db_name
 
try:
  connection = pymysql.connect(
    host=host,
    port=3306,
    user=user,
    password=password,
    database=db_name,
    cursorclass=pymysql.cursors.DictCursor
  )
  print("successfully connected...")
  print("#" * 20)
  
  try:
       # select all data from table
       with connection.cursor() as cursor: 
           select_all_rows = "SELECT * FROM `smallposts`"
           cursor.execute(select_all_rows)
           #cursor.execute("SELECT * FROM `smallposts`")
           rows = cursor.fetchall()
           for row in rows:
              print(row['icon'])
           print("#" * 20)
  finally:
      connection.close()
except Exception as ex:
  print("Connection refused...")
  print(ex)

try:
       # select all data from table
       with connection.cursor() as cursor: 
           select_all_rows = "SELECT * FROM `smallposts`"
           cursor.execute(select_all_rows)
           
           rows = cursor.fetchall()
           for row in rows:
              #print(row['icon'])
              item = row['icon']
              html = f"""{item}"""
              
              soup = BeautifulSoup(html, "html.parser")
              
              link = html.find("a")
              print(link)
           print("#" * 20)
  finally:
      connection.close()

#!/usr/bin/env python
# -*- coding: UTF-8 -*-
print('Content-Type: text/html; charset=utf-8\n')
 
import pymysql
from config import host, user, password, db_name
import requests
from datetime import datetime
from datetime import date
import os
from bs4 import BeautifulSoup 
 
headers = {
  "Accept":"*/*",
  ""
}
 
today = date.today()
d1 = today.strftime("%d-%m-%Y")
 
path_in_file = 'data2/images/'+d1
if not os.path.exists(path_in_file):
  os.makedirs(path_in_file)
 
try:
  connection = pymysql.connect(
    host=host,
    port=3306,
    user=user,
    password=password,
    database=db_name,
    cursorclass=pymysql.cursors.DictCursor
  )
  print("successfully connected...")
  print("#" * 20)
  
  try:
       # select all data from table find("img")
       with connection.cursor() as cursor: 
           select_rows = "SELECT * FROM `smallposts` WHERE `id`=49"
           cursor.execute(select_rows)
           print("-" * 20)
           #row1 = cursor.execute("SELECT * FROM `smallposts` WHERE `id`=49")
           #row2 = row1.fetch()
           row1 = cursor.fetchone()
           
           item = row1['icon']
           html = f"{item}"
           soup = BeautifulSoup(html, 'lxml')
           #print(row1["icon"]) 
           all_data = soup.find_all("a")
           image_number = 1
           for item in all_data:
             link = item.get("href")
             image_bytes=requests.get(f'{link}').content
             millisec = int(datetime.now().timestamp() * 1000)
            # print(image_bytes)
             with open(f'data2/images/{d1}/{image_number}_{millisec}.jpg','wb') as file:
               file.write(image_bytes) 
             image_number += 1
             print(f'{image_number}  image save!')
           print("-" * 20)
           
  finally:
      connection.close()
except Exception as ex:
  print("Connection refused...")
  print(ex)