HYTOS

    def getEquipmentItemNo(self):

        from EquipmentData import EquipmentData

        if not self.equipmentDataList:

            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 ITEM_NO from EQUIPMENT_DATA_LIST'

                cursor.execute(sql)

                rows = cursor.fetchall()

                for row in rows:

                    data = EquipmentData(row[0])

                    self.equipmentDataList.append(data)

            # 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 self.equipmentDataList 

    '''

        @brief      get equipment data list

        @author     humkyung

        @date       2018.05.03

    '''

                    self.equipmentDataList.append(row[0])