HYTOS

    '''

        @brief      get Color

        @author     kyouho

        @date       2018.07.03

    '''

    def getPropertyColor(self, property):

        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 UID,RED,GREEN,BLUE,PROPERTY,VALUE from Colors WHERE PROPERTY = '{}'".format(property)

            cursor.execute(sql)

            rows = cursor.fetchall()

            for row in rows:

                result.append(Color(int(row[0]), int(row[1]), int(row[2]), int(row[3]), row[4], row[5]))

            # 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 one color

        @author     kyouho

        @date       2018.07.09

    '''

    def getColor(self, property, value):

        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 UID,RED,GREEN,BLUE,PROPERTY,VALUE from Colors WHERE PROPERTY = '{}' AND VALUE = '{}'".format(property, value)

            cursor.execute(sql)

            row = cursor.fetchall()

            if row:

                result = Color(int(row[0][0]), int(row[0][1]), int(row[0][2]), int(row[0][3]), row[0][4], row[0][5])

            # 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

    '''

        # default Color 

        defaultColor = docData.getPropertyColor('default')

        if defaultColor:

            self.defaultColor = defaultColor[0]