HYTOS

                    doc_names = "','".join(drawing_names)

                sql = f"select S.PnIDNumber, S.Tag_Seq_No, S.PipingMaterialsClass, S.InsulationPurpose, S.FluidCode, " \

                      f"join Drawings D on S.Drawing_UID=D.UID " \

                      f"where S.Drawing_UID in (select UID from Drawings where Name in ('{doc_names}'))"

                sql = self.project.database.to_sql(sql)

                    data['FROM'] = row['From']

                    data['TO'] = row['To']

                    data['Stream No'] = row['Stream_No']

                    data['index'] = row['Index']

                    data['Drawing Name'] = row['Name']

                index = 1

                for model_data in self._streamLineListModelDatas:

                    sql = f"insert into Stream_Line_List (UID, Drawing_UID, PnIDNumber, Tag_Seq_No, PipingMaterialsClass, InsulationPurpose, FluidCode, " \

                    params = (str(uuid.uuid4()), drawing_uid, model_data['PnIDNumber'], model_data['Tag Seq No'], model_data['PipingMaterialsClass'], model_data['InsulationPurpose'], \

                    cursor.execute(sql, params)

                    index += 1

            for row in rows:

                stream_no = QEngineeringLineNoTextItem()

                from_item = self.find_item(scene, row['From_Component_UID'])

                to_item = self.find_item(scene, row['To_Component_UID'])

        app_doc_data = AppDocData.instance()

        special_item_types = SpecialItemTypes.instance()

        self.lineColumnListAll.extend([prop.Attribute for prop in app_doc_data.getLineProperties()])

        self.lineColumnListAll = QItemDataExportDialog.add_hmb_header(self.lineColumnListAll)

        self.equipColumnListAll = ['UID', 'ITEM_NO']

            data['PHASE'] = phase if 'PHASE' not in data else data['PHASE']

            '''

            for name in names:

                matches = [data for data in datas if data.name == name]

                model_datas = []

                for row_data in row_datas:

                    matches = [hmb_data for hmb_data in hmb_datas if hmb_data.stream_no == stream_no]

                    hmb_data = None

                    data['TO'] = to_item

                    data['PnIDNumber'] = pnid_no

                    data['Stream No'] = stream_no

                    items = []

                    model_data = {}

            self.ui.tableViewFromTo.setModel(model)

            self.ui.tableViewFromTo.resizeColumnsToContents()

            self._from_to_widgets.clear()

            self._case_combobox.clear()

            for row_ in range(self.ui.tableViewFromTo.model().rowCount()):

                    caseCombobox.setEnabled(False)

                if hasattr(case_item, '_new') and case_item._new:

                    pal = caseCombobox.palette()

                    pal.setColor(QPalette.Button, QColor(Qt.yellow))

                    caseCombobox.setPalette(pal)

        drawing_item = QStandardItem(app_doc_data.activeDrawing.name)

        drawing_item.setData(app_doc_data.activeDrawing.UID, Qt.UserRole)

        self.ui.tableViewFromTo.selectionModel().setCurrentIndex(index, QItemSelectionModel.NoUpdate)

        from_button = FromToWidget(self.ui.tableViewFromTo, 1)

        self.ui.tableViewFromTo.setIndexWidget(i, to_button)

        self._from_to_widgets[to_button] = (i.row(), 2)

        row = self.ui.tableViewStreamNo.selectionModel().currentIndex().row()

        self.ui.tableViewStreamNo.model().item(row, 1)._new = True

    def on_del_from_to(self):

        """delete selected from/to"""

        row = self.ui.tableViewStreamNo.selectionModel().currentIndex().row()

        self.ui.tableViewStreamNo.model().item(row, 1)._new = True

    def on_select_comp(self, column: int):

        """select from or to component"""

        from App import App