import pymysql.cursors
import pymysqlpool
from tkinter import *
from tkinter import messagebox


connection = pymysql.connect(host='127.0.0.1',
                             user='root',
                             password='',
                             db='python',
                             charset='utf8mb4',
                             cursorclass=pymysql.cursors.DictCursor,
                             autocommit=True)


def display_full_name():
    # Подключение к БД
    counter = True
    x=1
    while counter:
        text = name.get()
        x=x+1

        try:
            with connection.cursor() as cursor:
                # Отправка SQL запроса
                sql = "INSERT INTO `scaner` (`number`) VALUES (%s)"
                cursor.execute(sql, (text))

            # Сохранение изменения
            connection.commit()

        finally:
                print('Отправленно!')

        if x>1000000:
            counter=False
            connection.close()


root = Tk()
root.title("Считыватель Штрих кодов и комит в БД")

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

import sqlite3
from tkinter import *


def display_full_name(conn, val, entry):
    cursor = conn.cursor()

    cursor.execute("insert into codes (val) values (?)", (val,))
    conn.commit()
    entry.delete(0, 'end')


with sqlite3.connect("/tmp/tmp.db") as conn:

    cursor = conn.cursor()

    cursor.execute("create table codes (val int)")
    conn.commit()

    root = Tk()
    root.title("Считыватель Штрих кодов и комит в БД")
    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=lambda: display_full_name(conn, name.get(), name_entry))
    message_button.grid(row=2,column=1, padx=5, pady=5, sticky="e")
    root.mainloop()