HYTOS

        @brief      get Symbol Attribute

        @author     kyouho

        @date       2018.07.18

    '''

    def getSymbolAttribute(self, _type):

        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 attribute from SymbolAttribute where SymbolType = ?'

            param = (_type,)

            cursor.execute(sql, param)

            rows = cursor.fetchall()

            for row in rows:

                result.append(row[0])

            # 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

    '''

    <Compile Include="SelectAttributeDialog.py" />

CREATE TABLE IF NOT EXISTS [SymbolAttribute](

  [SymbolType] TEXT, 

  [Attribute] TEXT, 

  PRIMARY KEY([SymbolType], [Attribute]));

# coding: utf-8

import os

import sys

from PyQt5.QtCore import *

from PyQt5.QtGui import *

from PyQt5.QtWidgets import *

import sqlite3

from AppDocData import AppDocData

from AppDocData import Config

import SelectAttribute_UI

class QSelectAttributeDialog(QDialog):

    def __init__(self, parent, symbolType):

        QDialog.__init__(self, parent)

        self.removeUID = {}

        self.currentCode = {}

        self.ui = SelectAttribute_UI.Ui_SelectAttributeDialog()

        self.ui.setupUi(self)

        self.dialogResult = False

        self.selectedAttribute = ''

        self.settingComboBoxAttribute(symbolType)

    def settingComboBoxAttribute(self, symbolType):

        docData = AppDocData.instance()

        symbolAttrs = docData.getSymbolAttribute(symbolType)

        for attr in symbolAttrs:

            self.ui.comboBoxAttribute.addItem(attr)

    def accept(self):

        self.dialogResult = True

        index = self.ui.comboBoxAttribute.currentIndex()

        self.selectedAttribute = self.ui.comboBoxAttribute.itemText(index)

        QDialog.accept(self)

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

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

#

# Created by: PyQt5 UI code generator 5.9.2

#

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

from PyQt5 import QtCore, QtGui, QtWidgets

class Ui_SelectAttributeDialog(object):

    def setupUi(self, SelectAttributeDialog):

        SelectAttributeDialog.setObjectName("SelectAttributeDialog")

        SelectAttributeDialog.resize(277, 67)

        self.gridLayout = QtWidgets.QGridLayout(SelectAttributeDialog)

        self.gridLayout.setObjectName("gridLayout")

        self.buttonBox = QtWidgets.QDialogButtonBox(SelectAttributeDialog)

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

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

        self.buttonBox.setObjectName("buttonBox")

        self.gridLayout.addWidget(self.buttonBox, 1, 1, 1, 1)

        self.comboBoxAttribute = QtWidgets.QComboBox(SelectAttributeDialog)

        self.comboBoxAttribute.setObjectName("comboBoxAttribute")

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

        self.label = QtWidgets.QLabel(SelectAttributeDialog)

        self.label.setObjectName("label")

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

        self.retranslateUi(SelectAttributeDialog)

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

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

        QtCore.QMetaObject.connectSlotsByName(SelectAttributeDialog)

    def retranslateUi(self, SelectAttributeDialog):

        _translate = QtCore.QCoreApplication.translate

        SelectAttributeDialog.setWindowTitle(_translate("SelectAttributeDialog", "Dialog"))

        self.label.setText(_translate("SelectAttributeDialog", "Attribute"))

if __name__ == "__main__":

    import sys

    app = QtWidgets.QApplication(sys.argv)

    SelectAttributeDialog = QtWidgets.QDialog()

    ui = Ui_SelectAttributeDialog()

    ui.setupUi(SelectAttributeDialog)

    SelectAttributeDialog.show()

    sys.exit(app.exec_())

        self.attribute = ''

import SelectAttributeDialog

        self.isClick = False

        self.currentCursor = 0

        self.currentCursor = int(Qt.OpenHandCursor)

#kyouho Edit Start

        @history kyouho 2018.07.18 edit ArrowCursor

        self.currentCursor = int(Qt.ArrowCursor)

        cursor = QCursor(Qt.ArrowCursor)

        QApplication.instance().setOverrideCursor(cursor)

        @history    kyouho 2018.07.18 add isClick logic

            #Type에 따라서 isClick 조절 설정 가능

            self.isClick = True

    '''

        @brief      Mouse Release Event

        @author     kyouho

        @date       18.07.17

    '''

    def mouseReleaseEvent(self, event):

        super().mouseReleaseEvent(event)

        if self.isClick:

            self.isClick = False

            self.currentCursor = int(Qt.ArrowCursor)

            cursor = QCursor(Qt.ArrowCursor)

            QApplication.instance().setOverrideCursor(cursor)

            self.update()

            scenePos = self.mapToScene(event.pos())

            result = self.findTextItemInPoint(scenePos)

            if result[0]:

                item = result[1]

                dialog = SelectAttributeDialog.QSelectAttributeDialog(None, self.type)

                dialog.exec_()

                if dialog.dialogResult and dialog.selectedAttribute:

                    attrStr = dialog.selectedAttribute

                    item.attribute = attrStr

                    #기존 연결되있는 Attr 제거

                    self.removeAttr(item)

                    self.attrs.append(item)

    '''

        @brief      Mouse Move Event

        @author     kyouho

        @date       18.07.17

    '''

    def mouseMoveEvent(self, event):

        if self.isClick and self.currentCursor != int(Qt.ClosedHandCursor):

            self.currentCursor = int(Qt.ClosedHandCursor)

            cursor = QCursor(Qt.ClosedHandCursor)

            QApplication.instance().setOverrideCursor(cursor)

            self.update()

    '''

        @brief      Mouse Move Event

        @author     kyouho

        @date       18.07.17

    '''

    def findTextItemInPoint(self, point):

        from QEngineeringTextItem import QEngineeringTextItem

        scene = self.scene()

        for item in scene.items():

            if type(item) is QEngineeringTextItem:

                if self.isOverlapItemAndPoint(item, point):

                    return (True, item)

        return (False,)

    '''

        @brief      Mouse Move Event

        @author     kyouho

        @date       18.07.17

    '''

    def isOverlapItemAndPoint(self, item, point):

        x = point.x()

        y = point.y()

        loc = item.loc

        size = item.size

        if loc[0] <= x and loc[0] + size[0] >= x and loc[1] <= y and loc[1] + size[1] >= y:

            return True

        else:

            return False

    '''

        @brief      Remove Attr

        @author     kyouho

        @date       18.07.17

    '''

    def removeAttr(self, item):

        scene = self.scene()

        for symbol in scene.items():

            if type(symbol) is SymbolSvgItem:

                for attr in symbol.attrs:

                    if attr == item:

                        symbol.attrs.remove(item)

#kyouho Edit End

        @history    kyouho  2018.07.18  Add only attr QEngineeringTextItem

        from QEngineeringTextItem import QEngineeringTextItem

        for attr in self.attrs:

            if type(attr) is QEngineeringTextItem:

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

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

<ui version="4.0">

 <class>SelectAttributeDialog</class>

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

  <property name="geometry">

   <rect>

    <x>0</x>

    <y>0</y>

    <width>277</width>

    <height>67</height>

   </rect>

  </property>

  <property name="windowTitle">

   <string>Dialog</string>

  </property>

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

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

    <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>

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

    <widget class="QComboBox" name="comboBoxAttribute"/>

   </item>

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

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

     <property name="text">

      <string>Attribute</string>

     </property>

    </widget>

   </item>

  </layout>

 </widget>

 <resources/>

 <connections>

  <connection>

   <sender>buttonBox</sender>

   <signal>accepted()</signal>

   <receiver>SelectAttributeDialog</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>SelectAttributeDialog</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>