HYTOS

                # Get a cursor object

                cursor = conn.cursor()

                origin_attrs = self.getSymbolAttribute(type_str)

                for origin_attr in origin_attrs:

                    remain = False

                    for attr in attrs:

                        if str(origin_attr.UID) == attr[0]:

                            remain = True

                            break

                        attr[-1] = self.getCodeTable('SymbolAttributeCodeTable', forCheckLineNumber=False, symbol_attribute_uid=origin_attr.UID)

                    sql = "delete from SymbolAttributeCodeTable where SymbolAttribute_UID = '{}'".format(origin_attr.UID)

                    cursor.execute(sql)

                        for code in attr[-1]:

                            sql = self.project.database.to_sql( \

                                "insert into SymbolAttributeCodeTable(UID, Code, Description, Allowables, SymbolAttribute_UID) VALUES(?,?,?,?,?)")

                            cursor.execute(sql, param)

                # up to here

        @date       2018.07.10

    '''

        try:

            tableName = self.replaceText(tableName)

            docData = AppDocData.instance()

            if tableName == "NominalDiameter":

                tableDatas = docData.getNomialPipeSizeData()

            elif tableName == "SymbolAttributeCodeTable":

            else:

                tableDatas = docData.getCodeTable(tableName)

                table.setItem(row, 0, QTableWidgetItem(tableData[0]))  # UID

                table.setItem(row, 1, QTableWidgetItem(tableData[1]))  # Name

                table.setItem(row, 2, QTableWidgetItem(tableData[2]))  # Description

                row += 1

        except Exception as ex:

            from App import App

                        if QEngineeringAbstractItem.assoc_type(item) not in self._item._associations:

                            self._item._associations[QEngineeringAbstractItem.assoc_type(item)] = []

                        for key in self._item.attrs.keys():

                            if key.Attribute == self._attr.Attribute:

                elif self._attr is not None and type(self._attr) is SymbolProp:

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

                    if item is not None and self._attr.match_type(item):

        self._update_line_type = update_line_type

        self._update_flow_mark = update_flow_mark

        self._update_spec = update_spec

    '''

        @brief  execute connecting attributes

                        type(text) is QEngineeringTagNoTextItem or type(text) is QEngineeringTextItem):

                targetText.append(text)

        for text in targetText:

        """ update line type """

        if update_line_type:

                            self.itemTreeWidget.addTreeItem(item, connectedItem)

                # up to here

                self.tableWidgetInconsistency.clearContents()

                if self.dlgConnectAttr.ui.checkBoxValidation.isChecked():

                    self.onValidation()

                    else:

                        items = [text for text in _texts if QEngineeringAbstractItem.assoc_type(text) == attr.AttributeType]

                        attr.AssocItem = items[at]

                        item = attr.AssocItem

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

from AppDocData import *

from EngineeringAbstractItem import QEngineeringAbstractItem

from TextInfo import TextInfo

class QEngineeringTextItem(QGraphicsTextItem, QEngineeringAbstractItem):

    HIGHLIGHT = '#BC4438'

                        break

            for symbol in target_symbols:

                    dx = symbol.center().x() - center.x()

                    dy = symbol.center().y() - center.y()            

                for attr in attrs:

                    ret = attr.Codes.find_match_exactly(self.text())

                    if ret:

                        target_attr = attr

                        break

                if selected.add_assoc_item(self, at=int(target_attr.AttrAt)):

                    self.owner = selected

        except Exception as ex:

            from App import App 

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

import OcrResultDialog

from AppDocData import AppDocData, MessageType

from EngineeringTextItem import QEngineeringTextItem

from SymbolSvgItem import SymbolSvgItem

class QEngineeringValveOperCodeTextItem(QEngineeringTextItem):

import SymbolAttrCodeTable_UI

class SymbolAttrCodeTableDialog(QCodeTableDialog):

        QCodeTableDialog.__init__(self, parent, 'SymbolAttributeCodeTable')

        self.ui = SymbolAttrCodeTable_UI.Ui_AttributeCodeTable()

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

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

    '''

        @brief  accept dialog

    '''

                    uid = table.item(row, 0).text() if table.item(row, 0).text() else str(uuid.uuid4())

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

                    description = table.item(row, 2).text() if table.item(row, 2) is not None else ''

                if code:

                    self.code_data.append((uid, code, description, allowables))

            if column == 7:

                symbolType = self.ui.comboBoxSymbolType.currentText()

                (isAccept, code_data) = dialog.showDialog()

                if isAccept:

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

            item = QTableWidgetItem('...')

            item.setTextAlignment(Qt.AlignHCenter)

            item.setFlags(Qt.ItemIsEnabled)

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