HYTOS

            cursor = conn.cursor()

            for data in datas:

                if not uid:

                    sql = "insert or replace into {}(UID, CODE, DESCRIPTION, ALLOWABLES) values(lower(hex(randomblob(16))), ?, ?, ?)".format(tableName)

                    param = (data[1], data[2], data[3])

                else:

                    sql = "update {} SET CODE=?, DESCRIPTION=?, ALLOWABLES=? WHERE UID = ?".format(tableName)

                    param = (data[1], data[2], data[3], data[0])

        except Exception as ex:

            # Roll back any change if something goes wrong

            conn.rollback()

        finally:

            # Close the db connection

            conn.close()

import CodeTable_UI

class QCodeTableDialog(QDialog):

    def __init__(self, parent):

        QDialog.__init__(self, parent)

        self.currentCode = {}

        self.ui = CodeTable_UI.Ui_CodeTableDialog()

        self.ui.tableWidgetValveOperCodes.setSortingEnabled(True)

        #DB Table명 기준으로 작성

    '''

        @brief      Setting Table

            table.setRowCount(len(tableDatas))

            row = 0

            for tableData in tableDatas:

                row += 1

        except Exception as ex:

            print('error occured({}) in {}:{}'.format(ex, sys.exc_info()[-1].tb_frame.f_code.co_filename, sys.exc_info()[-1].tb_lineno))

    '''

        @brief      Find TableWidget with Name

        @author     kyouhokyouho

                    if tabText != "NominalDiameter":

                        for row in rowsIndex:

                            uid = table.item(row, 0).text()

                            self.removeUID[uid] = tabText

                            model.removeRow(row)

                        self.checkRowAndAddRow(tabText, table)

        except Exception as ex:

            print('error occured({}) in {}:{}'.format(ex, sys.exc_info()[-1].tb_frame.f_code.co_filename, sys.exc_info()[-1].tb_lineno))

            result = True

            if tableName != "NominalDiameter":

                for row in range(rowCount):

                    code = table.item(row, 1).text()

                    if not code:

                        result = False

            rowCount = table.rowCount()

            codes = []

            for row in range(rowCount):

                code = table.item(row, 1).text()

                codes.append(code)

        except Exception as ex:

            print('error occured({}) in {}:{}'.format(ex, sys.exc_info()[-1].tb_frame.f_code.co_filename, sys.exc_info()[-1].tb_lineno))

    '''

        @brief      replaceTextForCodeTable

        @author     kyouho

        @date       2018.07.12

    '''

    def accept(self):

        self.saveNomialPipeSize()

            table = self.findTableWidget(tableName)

            rowCount = table.rowCount()

            for row in range(rowCount):

                if code:

                    datas.append((uid, code, description, allowables))

    '''

        @brief      save common code data

        @author     kyouho

        @date       2018.07.16

    '''

    def saveNomialPipeSize(self):

            docData.insertNomialPipeSize(pipeSizes)

        except Exception as ex:

    '''

        @brief      save common code data

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

#

#

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

from PyQt5 import QtCore, QtGui, QtWidgets

class Ui_CodeTableDialog(object):

    def setupUi(self, CodeTableDialog):

        CodeTableDialog.setObjectName("CodeTableDialog")

        font = QtGui.QFont()

        font.setFamily("맑은 고딕")

        CodeTableDialog.setFont(font)

        self.gridLayout_20.addWidget(self.tableWidgetValveOperCodes, 0, 0, 1, 1)

        self.gridLayout_19.addWidget(self.groupBox_7, 0, 0, 1, 1)

        self.tabWidget.addTab(self.tab, "")

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

        self.retranslateUi(CodeTableDialog)

        self.tabWidget.setTabText(self.tabWidget.indexOf(self.tabUnitNumber), _translate("CodeTableDialog", "Unit Number"))

        self.groupBox_7.setTitle(_translate("CodeTableDialog", "Codes"))

        self.tabWidget.setTabText(self.tabWidget.indexOf(self.tab), _translate("CodeTableDialog", "Valve Oper Codes"))

        try:

            if 'mouseReleaseEvent' == param[0] and event.button() == Qt.LeftButton:

                from SymbolSvgItem import SymbolSvgItem

                from EngineeringTextItem import QEngineeringTextItem

                from EngineeringLineItem import QEngineeringLineItem

                from EngineeringSpecBreakItem import QEngineeringSpecBreakItem

                from EngineeringValveOperCodeTextItem import QEngineeringValveOperCodeTextItem

                if self._attr is not None:

                    item = self.imageViewer.scene.itemAt(scenePos, QTransform())

                        self._item.conns.clear()

                        self._item.conns.append(item)

                        self._item.attrs[self._attr] = str(item.uid)

                        self.onSuccess.emit()

        except Exception as ex:

            from App import App

            from AppDocData import MessageType

        """

        pass

        """

        return association type of given item

        """

        from SymbolSvgItem import SymbolSvgItem

        from EngineeringValveOperCodeTextItem import QEngineeringValveOperCodeTextItem

        from QEngineeringSizeTextItem import QEngineeringSizeTextItem

        _type = None

            _type = 'Size Text Item'

        elif type(item) is QEngineeringValveOperCodeTextItem:

            _type = 'Valve Oper Code'

        elif type(item) is QEngineeringTextItem or issubclass(type(item), QEngineeringTextItem):

            _type = 'Text Item'

        elif type(item) is SymbolSvgItem or issubclass(type(item), SymbolSvgItem):

        from EngineeringValveOperCodeTextItem import QEngineeringValveOperCodeTextItem

        from QEngineeringSizeTextItem import QEngineeringSizeTextItem

        if _type is not None:

            if not _type in self._associations:

                self._associations[_type] = []

# coding: utf-8

import sys

import os

from UserInputAttribute import UserInputAttribute

class QEngineeringEquipmentItem(SymbolSvgItem):

    clicked = pyqtSignal(QGraphicsSvgItem)

    ZVALUE = 10

    EQUIP_COLUMN_LIST = None

                if rect.contains(attr.center()):

                    self.add_assoc_item(attr)

                minDist = None

                selected = None

                # get nearest text from equipment

        _attrs = {}

        try:

            from AppDocData import AppDocData

            from EngineeringTextItem import QEngineeringTextItem

            # 해당 Type의 attribute setting

            _texts = self.texts()

            _symbols = self.symbols()

            for attr in symbolAttrs:

                    at = int(attr.AttrAt)

                    if len(items) > at:

                        item = items[at]

                        _attrs[attr] = eval(attr.Expression) if attr.Expression else ''

        _attrs = {}

        try:

            from AppDocData import AppDocData

            from EngineeringTextItem import QEngineeringTextItem

            # 해당 Type의 attribute setting

            for attr in symbolAttrs:

                if attr.AttributeType == 'Size Text Item' or attr.AttributeType == 'Text Item' or attr.AttributeType == 'Valve Oper Code':

                    at = int(attr.AttrAt)

                    if len(items) > at:

                        item = items[at]

                        _attrs[attr] = eval(attr.Expression) if attr.Expression else ''

        _attrs = {}

        try:

            from AppDocData import AppDocData

            from EngineeringTextItem import QEngineeringTextItem

            # 해당 Type의 attribute setting

            for attr in symbolAttrs:

                if attr.AttributeType == 'Size Text Item' or attr.AttributeType == 'Text Item' or attr.AttributeType == 'Valve Oper Code':

                    at = int(attr.AttrAt)

                    if len(items) > at:

                        item = items[at]

                        _attrs[attr] = eval(attr.Expression) if attr.Expression else ''

        _attrs = {}

        try:

            from AppDocData import AppDocData

            from EngineeringTextItem import QEngineeringTextItem

            from EngineeringValveOperCodeTextItem import QEngineeringValveOperCodeTextItem

            for attr in symbolAttrs:

                if attr.AttributeType == 'Size Text Item' or attr.AttributeType == 'Text Item' or attr.AttributeType == 'Valve Oper Code':

                    at = int(attr.AttrAt)

                    if len(items) > at:

                        item = items[at]

                        _attrs[attr] = eval(attr.Expression) if attr.Expression else ''

    '''

    def toXml(self):

        from xml.etree.ElementTree import Element, SubElement, dump, ElementTree

        from EngineeringTextItem import QEngineeringTextItem

        from EngineeringSpecBreakItem import QEngineeringSpecBreakItem

        from SymbolAttr import SymbolAttr

            attributeValueNode = Element('ASSOCIATIONS')

            for assoc in self.associations():

                assoc_node = Element('ASSOCIATION')

                assoc_node.text = str(assoc.uid)

                attributeValueNode.append(assoc_node)

            node.append(attributeValueNode)

        """

        return if attribute is selectable

        """

    @staticmethod

    def fromXml(node):

    """

    This is symbol attribute editor dialog class

    """

    def __init__(self, parent, symbolType = None):

        QDialog.__init__(self, parent)

            self.ui.tableWidgetAttr.setItem(row, 2, item)

            attrTypeComboBox = QComboBox()

            self.ui.tableWidgetAttr.setCellWidget(row, 3, attrTypeComboBox)

            result = attrTypeComboBox.findText(attr.AttributeType) # Type

            attrTypeComboBox.setCurrentIndex(result)

        self.ui.tableWidgetAttr.setRowCount(rows + 1)

        attrTypeComboBox = QComboBox()

        self.ui.tableWidgetAttr.setCellWidget(rows, 3, attrTypeComboBox)

        import uuid

        @date   2018.05.03

    '''

    def isTagNoText(self, text):

    def is_valve_operation_code(self, text):

        """

   <rect>

    <x>0</x>

    <y>0</y>

    <height>589</height>

   </rect>

  </property>

       </item>

      </layout>

     </widget>

    </widget>

   </item>

  </layout>