---

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

        # Создаем и заполняем таблицу
        table = QTableWidget()
        headers = ["Категория", "Порода", "Кличка", "Окрас", "Возраст", "Стоимость"]
        table.setColumnCount(len(headers))
        table.setHorizontalHeaderLabels(headers)
        table.setRowCount(len(order_data))

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

        layout = QVBoxLayout()
        layout.addWidget(table)

        cent_widget = QWidget()
        cent_widget.setLayout(layout)
        self.setCentralWidget(cent_widget)


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