---

import sys
from PyQt6.QtWidgets import *
import MySQLdb as mdb
from untitled import *

conn = mdb.connect(host='127.0.0.1', user='root', password='root',database='trafik', port=3307)
cursor = conn.cursor()
class Main(QMainWindow, Ui_MainWindow):
    def __init__(self):
        super().__init__()
        self.setupUi(self)
        self.load_data()

    def load_data(self):
        cursor.execute("SELECT * FROM provaider")
        zapici = cursor.fetchall()
        for zapic in zapici:
            name_postavshik, kolvo_tarifov, kolvo_dogovorov, sum_kolvo = zapic
            self.listWidget.addItem(f'Имя: {name_postavshik}\n'
                                    f'Кол-во тарифов: {kolvo_tarifov}\n'
                                    f'Кол-во договоров: {kolvo_dogovorov}\n'
                                    f'Сумма: {sum_kolvo}\n')

if __name__ == '__main__':
    app = QApplication(sys.argv)
    window = Main()
    window.show()
    sys.exit(app.exec())