Активное подключение к БД

import pymysql.cursors 
import pymysqlpool 
from tkinter import * 
  
# Подключение к БД 
connection = pymysql.connect(host='127.0.0.1', 
                             user='root', 
                             password='', 
                             db='python', 
                             charset='utf8mb4', 
                             cursorclass=pymysql.cursors.DictCursor, 
							 autocommit=True) 
 
  
root = Tk() 
root.title("Считыватель Штрих кодов и комит в БД") 
 
 
 
def func(event): 
	label = Label(text = name.get()) 
	 
	try: 
		with connection.cursor() as cursor: 
			# Отправка SQL запроса 
			sql = "INSERT INTO `scaner` (`number`) VALUES (%s)" 
			cursor.execute(sql, (label['text'])) 
 
		# Сохранение изменения 
		connection.commit() 
		 
 
	finally: 
		print(label['text']) 
		name_entry.delete(0, END) 
root.bind('<Return>', func)	 
def display_full_name(): 
	 
	label = Label(text = name.get()) 
	 
	try: 
		with connection.cursor() as cursor: 
			# Отправка SQL запроса 
			sql = "INSERT INTO `scaner` (`number`) VALUES (%s)" 
			cursor.execute(sql, (label['text'])) 
 
		# Сохранение изменения 
		connection.commit() 
 
	finally: 
		print(label['text']) 
		name_entry.delete(0, END) 
 
 
 
name = StringVar() 
name_label = Label(text="Введите штрихкод:") 
name_label.grid(row=0, column=0, sticky="w") 
name_entry = Entry(textvariable=name) 
name_entry.grid(row=0,column=1, padx=5, pady=5) 
message_button = Button(text="Отправить", command=display_full_name) 
message_button.grid(row=2,column=1, padx=5, pady=5, sticky="e") 
 
 
 
root.mainloop()