Загрузка данных


import sys
from PyQt6.QtWidgets import *
import pymysql

app = QApplication(sys.argv)

try:
    # Подключение
    conn = pymysql.connect(
        host="localhost",
        port=3306,
        user="root",
        password="",
        database="avtozapravka"
    )
    cursor = conn.cursor()
    
    # Запрос
    cursor.execute("SELECT * FROM clients")
    data = cursor.fetchall()
    names = [desc[0] for desc in cursor.description]
    
    # Окно
    win = QMainWindow()
    table = QTableWidget()
    win.setCentralWidget(table)
    table.setColumnCount(len(names))
    table.setHorizontalHeaderLabels(names)
    table.setRowCount(len(data))
    
    for i, row in enumerate(data):
        for j, val in enumerate(row):
            table.setItem(i, j, QTableWidgetItem(str(val)))
    
    cursor.close()
    conn.close()
    
    win.show()
    sys.exit(app.exec())
    
except pymysql.Error as e:
    print("Ошибка подключения:", e)
    input("Нажми Enter чтобы выйти...")