---

import sys
from kod import QwerysSql
from PyQt6.QtWidgets import QMainWindow, QWidget, QTableWidget, QLabel, QVBoxLayout, QTableWidgetItem, QApplication
from PyQt6 import QtCore, QtGui

class MainWindow(QMainWindow):
    def __init__(self):
        super().__init__()
        self.setWindowTitle('Питомцы')
        self.resize(500, 400)
        order_data = QwerysSql().show_available_pets()
        cent_widget = QWidget()

        table = QTableWidget(cent_widget)
        table.setColumnCount(len(order_data[0]))
        headers = ["Категория", "Порода", "Кличка", "Окрас", "Возраст", "Стоимость"]
        table.setHorizontalHeaderLabels(headers)
        table.setRowCount(len(order_data))
        lb_title = QLabel("Список питомцов")
        lb_title.setStyleSheet("font-size: 20px;")
        lb_title.setAlignment(QtCore.Qt.AlignmentFlag.AlignCenter)

        layout = QVBoxLayout()
        layout.addWidget(lb_title)

        for i, rows in enumerate(order_data):
            for j, row in enumerate(rows):
                table.setItem(i, j, QTableWidgetItem(str(row)))

        layout.addWidget(table)
        cent_widget.setLayout(layout)
        self.setCentralWidget(cent_widget)

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