HYTOS

                    sql = f"insert into HMB_From_To(UID,[Drawing_UID],[From_Component_UID],[To_Component_UID],[Stream_No],[Case]) values" \

                          f"(?,?,?,?,?,?)"

                    params = (str(uuid.uuid4()), stream_line[0], stream_line[1], stream_line[2], stream_line[3], stream_line[4])

                    sql = f"select h.Drawing_UID, h.From_Component_UID, h.To_Component_UID, d.Name, h.[Case] from HMB_From_To h " \

                    sql = f"select h.From_Component_UID, h.To_Component_UID, s.Stream_No, h.[Case] from HMB_From_To h " \

            self.ui.pushButtonAdd.clicked.connect(self.add_stream_no)

            self.ui.pushButtonDelete.clicked.connect(self.delete_stream_no)

    def add_stream_no(self):

        from StreamNoAddDialog import QStreamNoAddDialog

        if self.hmbs:

            stream_nos = [hmb.stream_no for hmb in self.hmbs]

            dlg = QStreamNoAddDialog(self, stream_nos)

            if QDialog.Accepted == dlg.exec_():

                new_stream_no = dlg.stream_no

    def delete_stream_no(self):

        pass

        self.gridLayout_2.addWidget(self.buttonBox, 0, 3, 1, 1)

        self.pushButtonAdd = QtWidgets.QPushButton(HMBDialog)

        self.pushButtonAdd.setObjectName("pushButtonAdd")

        self.gridLayout_2.addWidget(self.pushButtonAdd, 0, 1, 1, 1)

        self.pushButtonDelete = QtWidgets.QPushButton(HMBDialog)

        self.pushButtonDelete.setObjectName("pushButtonDelete")

        self.gridLayout_2.addWidget(self.pushButtonDelete, 0, 2, 1, 1)

        self.pushButtonAdd.setText(_translate("HMBDialog", "Add Stream No"))

        self.pushButtonDelete.setText(_translate("HMBDialog", "Delete Stream No"))

                            keys = match.attrs.keys()

                            for attr in keys:

	[Case] VARCHAR ( 100 ), 

	[Case]	VARCHAR ( 100 ),

	`Case` VARCHAR ( 100 ), 

	`Case`	VARCHAR ( 100 ),

                for attr_node in node.iterfind('ATTRIBUTE'):

# coding: utf-8

""" This is validation dialog module """

import os

import sys

from PyQt5.QtCore import *

from PyQt5.QtGui import *

from PyQt5.QtWidgets import *

from AppDocData import AppDocData, MessageType

import StreamNoAddDialog_UI

class QStreamNoAddDialog(QDialog):

    """ This Training Algorithm dialog class """

    def __init__(self, parent, stream_nos):

        QDialog.__init__(self, parent)

        self.ui = StreamNoAddDialog_UI.Ui_StreamNoAddDialog()

        self.ui.setupUi(self)

        self.stream_nos = stream_nos

        self.stream_no = ''

        #self.ui.buttonBox.bu.clicked.connect(self.accept)

        #self.ui.pushButtonClose.clicked.connect(self.reject)

    def accept(self):

        self.stream_no = self.ui.lineEditStreamNo.text()

        if self.stream_no and self.stream_no not in self.stream_nos:

            QDialog.accept(self)

        else:

            QMessageBox.about(self, self.tr("Notice"), self.tr('Please check Stream No.'))

    def reject(self):

        QDialog.reject(self)

# -*- coding: utf-8 -*-

# Form implementation generated from reading ui file './UI/StreamNoAddDialog.ui'

#

# Created by: PyQt5 UI code generator 5.11.3

#

# WARNING! All changes made in this file will be lost!

from PyQt5 import QtCore, QtGui, QtWidgets

class Ui_StreamNoAddDialog(object):

    def setupUi(self, StreamNoAddDialog):

        StreamNoAddDialog.setObjectName("StreamNoAddDialog")

        StreamNoAddDialog.resize(314, 96)

        icon = QtGui.QIcon()

        icon.addPixmap(QtGui.QPixmap(":/newPrefix/ID2.png"), QtGui.QIcon.Normal, QtGui.QIcon.Off)

        StreamNoAddDialog.setWindowIcon(icon)

        StreamNoAddDialog.setSizeGripEnabled(True)

        self.gridLayout_2 = QtWidgets.QGridLayout(StreamNoAddDialog)

        self.gridLayout_2.setObjectName("gridLayout_2")

        self.gridLayout = QtWidgets.QGridLayout()

        self.gridLayout.setObjectName("gridLayout")

        self.label = QtWidgets.QLabel(StreamNoAddDialog)

        self.label.setObjectName("label")

        self.gridLayout.addWidget(self.label, 0, 0, 1, 1)

        self.lineEditStreamNo = QtWidgets.QLineEdit(StreamNoAddDialog)

        self.lineEditStreamNo.setObjectName("lineEditStreamNo")

        self.gridLayout.addWidget(self.lineEditStreamNo, 0, 1, 1, 1)

        self.gridLayout_2.addLayout(self.gridLayout, 0, 0, 1, 1)

        self.buttonBox = QtWidgets.QDialogButtonBox(StreamNoAddDialog)

        self.buttonBox.setOrientation(QtCore.Qt.Horizontal)

        self.buttonBox.setStandardButtons(QtWidgets.QDialogButtonBox.Cancel|QtWidgets.QDialogButtonBox.Ok)

        self.buttonBox.setObjectName("buttonBox")

        self.gridLayout_2.addWidget(self.buttonBox, 1, 0, 1, 1)

        self.retranslateUi(StreamNoAddDialog)

        self.buttonBox.accepted.connect(StreamNoAddDialog.accept)

        self.buttonBox.rejected.connect(StreamNoAddDialog.reject)

        QtCore.QMetaObject.connectSlotsByName(StreamNoAddDialog)

    def retranslateUi(self, StreamNoAddDialog):

        _translate = QtCore.QCoreApplication.translate

        StreamNoAddDialog.setWindowTitle(_translate("StreamNoAddDialog", "Add Stream No"))

        self.label.setText(_translate("StreamNoAddDialog", "Stream No : "))

import MainWindow_rc

if __name__ == "__main__":

    import sys

    app = QtWidgets.QApplication(sys.argv)

    StreamNoAddDialog = QtWidgets.QDialog()

    ui = Ui_StreamNoAddDialog()

    ui.setupUi(StreamNoAddDialog)

    StreamNoAddDialog.show()

    sys.exit(app.exec_())

                        from_item.setData(from_, Qt.UserRole)

                        to_item.setData(to_, Qt.UserRole)

                        case = row_['Case'] if row_['Case'] else ''

                        case_item = QStandardItem(case)

                        case_item.setData(case, Qt.UserRole)

                        items = [drawing_item, from_item, to_item, case_item]

                model.setHorizontalHeaderLabels(['Drawing No', 'From', 'To', 'Case'])

                case_ = model.item(row, 3)

                case_ = case_.data(Qt.UserRole)

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

                    case_._new = False

                from_to_data.append((drawing_uid, from_uid, to_uid, stream_no, case_))

     <item row="0" column="3">

     <item row="0" column="1">

      <widget class="QPushButton" name="pushButtonAdd">

       <property name="text">

        <string>Add Stream No</string>

       </property>

      </widget>

     </item>

     <item row="0" column="2">

      <widget class="QPushButton" name="pushButtonDelete">

       <property name="text">

        <string>Delete Stream No</string>

       </property>

      </widget>

     </item>

<?xml version="1.0" encoding="UTF-8"?>

<ui version="4.0">

 <class>StreamNoAddDialog</class>

 <widget class="QDialog" name="StreamNoAddDialog">

  <property name="geometry">

   <rect>

    <x>0</x>

    <y>0</y>

    <width>314</width>

    <height>96</height>

   </rect>

  </property>

  <property name="windowTitle">

   <string>Add Stream No</string>

  </property>

  <property name="windowIcon">

   <iconset resource="../res/MainWindow.qrc">

    <normaloff>:/newPrefix/ID2.png</normaloff>:/newPrefix/ID2.png</iconset>

  </property>

  <property name="sizeGripEnabled">

   <bool>true</bool>

  </property>

  <layout class="QGridLayout" name="gridLayout_2">

   <item row="0" column="0">

    <layout class="QGridLayout" name="gridLayout">

     <item row="0" column="0">

      <widget class="QLabel" name="label">

       <property name="text">

        <string>Stream No : </string>

       </property>

      </widget>

     </item>

     <item row="0" column="1">

      <widget class="QLineEdit" name="lineEditStreamNo"/>

     </item>

    </layout>

   </item>

   <item row="1" column="0">

    <widget class="QDialogButtonBox" name="buttonBox">

     <property name="orientation">

      <enum>Qt::Horizontal</enum>

     </property>

     <property name="standardButtons">

      <set>QDialogButtonBox::Cancel|QDialogButtonBox::Ok</set>

     </property>

    </widget>

   </item>

  </layout>

 </widget>

 <resources>

  <include location="../res/MainWindow.qrc"/>

 </resources>

 <connections>

  <connection>

   <sender>buttonBox</sender>

   <signal>accepted()</signal>

   <receiver>StreamNoAddDialog</receiver>

   <slot>accept()</slot>

   <hints>

    <hint type="sourcelabel">

     <x>248</x>

     <y>254</y>

    </hint>

    <hint type="destinationlabel">

     <x>157</x>

     <y>274</y>

    </hint>

   </hints>

  </connection>

  <connection>

   <sender>buttonBox</sender>

   <signal>rejected()</signal>

   <receiver>StreamNoAddDialog</receiver>

   <slot>reject()</slot>

   <hints>

    <hint type="sourcelabel">

     <x>316</x>

     <y>260</y>

    </hint>

    <hint type="destinationlabel">

     <x>286</x>

     <y>274</y>

    </hint>

   </hints>

  </connection>

 </connections>

</ui>