HYTOS

            sql = "select UID, Name, DisplayName, Type, LimitNumber, [index] from LineProperties order by [index]" 

                res.append((row[0], row[1], row[2], row[3], row[4], row[5]))

        # Catch the exception

        except Exception as ex:

            # Roll back any change if something goes wrong

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

            db.close()

        return res

    '''

        @brief  return line properties

        @author humkyung

        @date   2018.04.09

    '''

    def getLinePropertiesByUID(self, UID):

        res = []

        try:

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

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

            db = sqlite3.connect(dbPath)

            # Get a cursor object

            cursor = db.cursor()

            sql = "select UID, Name, DisplayName, Type, LimitNumber, [index] from LineProperties where uid = '{}'".format(UID)

            cursor.execute(sql)

            rows = cursor.fetchall()

            for row in rows:

                res.append((row[0], row[1], row[2], row[3], row[4], row[5]))

        @brief      save symbol attributes

        @author     humkyung

        @date       2018.08.14

    '''

    def saveLineAttributes(self, attrs):

        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 = 'delete from LineProperties'

            cursor.execute(sql)

            for attr in attrs:

                sql = 'insert into LineProperties(UID, Name, DisplayName, Type, LimitNumber, [index]) values(?, ?, ?, ?, ?, ?)'

                param = tuple(attr)

                cursor.execute(sql, param)

            conn.commit()

            # Catch the exception

        except Exception as ex:

            # Roll back any change if something goes wrong

            conn.rollback()

            from App import App 

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

            App.mainWnd().addMessage.emit(MessageType.Error, message)

        finally:

            # Close the db connection

            conn.close()

    '''

        @brief      get Code Table Data

        @author     kyouho

        @date       2018.07.10

    '''

    def getCodeTable(self, property, forCheckLineNumber = False):

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

            if property == "NominalDiameter" and forCheckLineNumber:

                sql = 'select InchStr, MetricStr from [{}] order by length(code) DESC'.format(property)

                cursor.execute(sql)

                rows = cursor.fetchall()

                for index in range(2):

                    for row in rows:

                        if row[index] != '':

                            result.append(row[index])

            else:

                sql = 'select uid, code, description from [{}] order by length(code) DESC'.format(property)

                cursor.execute(sql)

                rows = cursor.fetchall()

                for row in rows:

                    if forCheckLineNumber:

                        data = row[1]

                    else:

                        data = (row[0], row[1], row[2])

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

    '''