HYTOS

            sql = 'select UID from SymbolAttribute where UID = ?'

            sql = 'select a.UID, a.Attribute, a.DisplayAttribute, a.AttributeType, a.[index] from SymbolAttribute a inner join SymbolType t on a.SymbolType = t.id and t.type = ? order by a.[index]'

                result.append((row[0], row[1], row[2], row[3]))

            # Catch the exception

        except Exception as ex:

            # Roll back any change if something goes wrong

            conn.rollback()

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

        finally:

            # Close the db connection

            conn.close()

        return result

    '''

        @brief      get Symbol Attribute by UID

        @author     kyouho

        @date       2018.08.17

    '''

    def getSymbolAttributeByUID(self, UID):

        result = None

        try:

            # Creates or opens a file called mydb with a SQLite3 DB

            dbPath = os.path.join(self.getCurrentProject().getDbFilePath(), 'ITI_PID.db')

            conn = sqlite3.connect(dbPath)

            # Get a cursor object

            cursor = conn.cursor()

            sql = 'select Attribute, DisplayAttribute, AttributeType from SymbolAttribute where uid = "{}"'.format(UID)

            cursor.execute(sql)

            rows = cursor.fetchall()

            if len(rows):

                result = (rows[0][0], rows[0][1], rows[0][2])

                sql = 'insert into SymbolAttribute(UID, SymbolType, Attribute, DisplayAttribute, AttributeType, [index]) values(?, ?, ?, ?, ?, ?)'

                attr.insert(1, type)

                param = tuple(attr)

        @brief      get symbol type id

        @author     kyouho

        @date       2018.08.17

    '''

    def getSymbolTypeId(self, symbolType):

        result = []

        try:

            # Creates or opens a file called mydb with a SQLite3 DB

            dbPath = os.path.join(self.getCurrentProject().getDbFilePath(), 'ITI_PID.db')

            conn = sqlite3.connect(dbPath)

            # Get a cursor object

            cursor = conn.cursor()

            sql = 'select id from SymbolType where type = ?'

            param = (symbolType,)

            cursor.execute(sql, param)

            rows = cursor.fetchall()

            if len(rows):

                result = rows[0][0]

            else:

                result = -1

            # Catch the exception

        except Exception as ex:

            # Roll back any change if something goes wrong

            conn.rollback()

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

        finally:

            # Close the db connection

            conn.close()

        return result

    '''

                    rowIndex = lineNo.index(line)

                equipData = self.sceneEquipData[uid]

                    rowIndex = uidList.index(uid)

                    for index in range(len(equipData)):

                        if str(equipData[index]):

                            oldData = equipTable.item(rowIndex, index).text()

                            if oldData != equipData[index]:

                                equipTable.item(rowIndex, index).setText(equipData[index])

                                equipTable.item(rowIndex, index).setBackground(QColor(int(134), int(229), int(127)))

                instData = self.sceneInstData[uid]

                    rowIndex = uidList.index(uid)

                    for index in range(len(instData)):

                        if str(instData[index]):

                            oldData = instTable.item(rowIndex, index).text()

                            if oldData != instData[index]:

                                instTable.item(rowIndex, index).setText(instData[index])

                                instTable.item(rowIndex, index).setBackground(QColor(int(134), int(229), int(127)))

        self.attrValueList = []

        self.attrValueList = []

                        attrType = docData.getSymbolAttributeByUID(key)

                        if attrType[2] == 'Text Item':

                            from PyQt5 import QtGui

                            icon = QtGui.QIcon()

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

                            valueItem.setIcon(icon)

                        self.attrValueList.append((valueItem, key))

                        keyText = docData.getSymbolAttributeByUID(key)

                        if keyText is not None:

                            keyItem.setText(keyText[1])

                            self.setItem(row, 0, keyItem)

                    else:

                        self.setItem(row, 0, keyItem)

                    self.mainWindow.refreshResultPropertyTableWidget()

    '''

    '''

    def cellChangedEvent(self, row, column):

        pass

            cell = self.resultPropertyTableWidget.item(row, column)

            uid = None

            for data in self.resultPropertyTableWidget.attrValueList:

                if data[0] == cell:

                    uid = data[1]

                    break

            if uid is not None:

                attrType = docData.getSymbolAttributeByUID(uid)

                if attrType[2] == 'Text Item':

                        self.graphicsView.currentAttribute = uid

                        items[0].removeSelfAttr(uid)

                else:

                    self.resultPropertyTableWidget.editItem(cell)

            #cell = self.resultPropertyTableWidget.item(row, 0)

            #if cell is not None and self.resultPropertyTableWidget.item(row, 0).text():

            #    cellText = self.resultPropertyTableWidget.item(row, 0).text()

            #    docData = AppDocData.instance()

            #    if docData.checkAttribute(cellText):

            #        items = self.graphicsView.scene.selectedItems()

            #        if items is not None and len(items) == 1:

            #            self.graphicsView.command = SelectAttributeCommand.SelectAttributeCommand(self.graphicsView)

            #            cursor = QCursor(Qt.PointingHandCursor)

            #            QApplication.instance().setOverrideCursor(cursor)

            #            self.graphicsView.currentAttribute = cellText

            #            # 기존 cellText를 가진 attrs 삭제

            #            items[0].removeSelfAttr(cellText)

            #            from PyQt5 import QtGui

            #            cellItem = QTableWidgetItem('')

            #            icon = QtGui.QIcon()

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

            #            cellItem.setIcon(icon)

            #            self.resultPropertyTableWidget.setItem(row, 1, cellItem)

	UID TEXT NOT NULL,

	"index" INTEGER NOT NULL,

	PRIMARY KEY([SymbolType], [Attribute])

--CONSTRAINT SymbolAttribute_SymbolType_FK FOREIGN KEY (SymbolType) REFERENCES SymbolType(id)

        self.attrList = []

            self.attrList.append((attr[0], attr[1], attr[2]))

            self.ui.comboBoxAttribute.addItem(attr[2])

        self.selectedAttribute = self.attrList[index][0]

                attrInfo = docData.getSymbolAttributeByUID(attr.attribute)

                attrName = attrInfo[0]

                if instColumnList.count(attrName):

                    colIndex = instColumnList.index(attrName)

                    dataList[colIndex] = attr.text()

        attrs = {}

            from AppDocData import AppDocData

            from EngineeringTextItem import QEngineeringTextItem

            attrs['Measured Variable Code'] = self.measuredVariableCode

            attrs['Type Modifier'] = self.typeModifier

            attrs['Tag Seq No'] = self.tagSeqNo

            attrs['Tag Suffix'] = self.tagSuffix

            # 해당 Type의 attribute setting

            docData = AppDocData.instance()

            symbolAttrs = docData.getSymbolAttribute(self.type)

            for attr in symbolAttrs:

                attrs[attr[0]] = ''

            for attr in self.attrs:

                if type(attr) is QEngineeringTextItem:

                    attrs[attr.attribute] = attr.text()

        return attrs

                attrInfo = docData.getSymbolAttributeByUID(attr.attribute)

                attrName = attrInfo[0]

                if instColumnList.count(attrName):

                    colIndex = instColumnList.index(attrName)

                    dataList[colIndex] = attr.text()

        self.currentTypeId = 0

        self.ui.tableWidgetAttr.setColumnCount(4)

        self.ui.tableWidgetAttr.setHorizontalHeaderLabels(['UID', 'Name', 'Display Name', 'Type'])

        self.currentTypeId = appDocData.getSymbolTypeId(symbolType)

            item = QTableWidgetItem(attr[1])

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

            item = QTableWidgetItem(attr[2])

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

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

            result = attrTypeComboBox.findText(attr[3])

        attrs = []

        table = self.ui.tableWidgetAttr

        for index in range(table.rowCount()):

            attr = []

            attr.append(table.item(index, 0).text() if table.item(index, 0) is not None else '')

            attr.append(table.item(index, 1).text() if table.item(index, 1) is not None else '')

            attr.append(table.item(index, 2).text() if table.item(index, 2) is not None else '')

            attr.append(table.cellWidget(index, 3).currentText())

            attr.append(index)

            attrs.append(attr)

        appDocData.saveSymbolAttributes(self.currentTypeId, attrs)

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

        import uuid

        self.ui.tableWidgetAttr.setItem(rows, 0, QTableWidgetItem(str(uuid.uuid4())))