HYTOS

        app_doc_data = AppDocData.instance()

        app_style = app_doc_data.loadAppStyle()

        self.setStyle(app_style)

        configs = app_doc_data.getAppConfigs('app', 'stylesheet')

        if configs and len(configs) == 1:

            self.loadStyleSheet(os.path.dirname(os.path.realpath(__file__)) + '\\{}'.format(configs[0].value))

            self.stylesheet_name = configs[0].value

        else:

            self.loadStyleSheet(os.path.dirname(os.path.realpath(__file__)) + '\\coffee')

            self.stylesheet_name = 'coffee'

    def getAppDbPath(self):

        """

        @brief      Get application DB file path in ProgramData

        @author     humkyung

        @date       2018.10.01

        """

        path = os.path.join(os.getenv('ALLUSERSPROFILE'), 'Digital PID')

        app_database = os.path.join(path, 'App.db')

        return app_database 

    def getAppConfigs(self, section, key=None):

        """

            @brief  get application configurations

            @author humkyung

            @date   2018.11.01

        """

        res = []

        try:

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

            dbPath = self.getAppDbPath()

            conn = sqlite3.connect(dbPath)

            # Get a cursor object

            cursor = conn.cursor()

            if key is not None:

                sql = "select * from configuration where section=? and key=?"

                param = (section, key)

            else:

                sql = "select * from configuration where section=?"

                param = (section,)

            cursor.execute(sql, param)

            rows = cursor.fetchall()

            for row in rows:

                res.append(Config(row[0], row[1], row[2]))

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

    def saveAppConfigs(self, configs):

        """

        @brief      save application configurations

        @author     humkyung

        @date       2018.10.01

        """

        try:

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

            dbPath = self.getAppDbPath()

            conn = sqlite3.connect(dbPath)

            # Get a cursor object

            cursor = conn.cursor()

            for config in configs:

                value = config.value

                if type(value) is str and "'" in value:

                    value = value.replace("'", "''")

                sql = "insert or replace into configuration values(?,?,?)"

                param = (config.section, config.key, value)

                cursor.execute(sql, param)

            conn.commit()

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

    def deleteAppConfigs(self, section, key=None):

        """

        @brief  delete application configurations

        @author humkyung

        @date   2018.11.01

        """

        try:

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

            dbPath = self.getAppDbPath()

            conn = sqlite3.connect(dbPath)

            # Get a cursor object

            cursor = conn.cursor()

            if key is not None:

                sql = "delete from configuration where section='{}' and key='{}'".format(section, key)

            else:

                sql = "delete from configuration where section='{}'".format(section)

            cursor.execute(sql)

            conn.commit()

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

        stylesheet_name = QtWidgets.qApp.stylesheet_name

            action.setCheckable(True)

            action.setChecked(True) if stylesheet_name == file else action.setChecked(False)

        app_doc_data = AppDocData.instance()

        configs = [Config('app', 'stylesheet', file)]

        app_doc_data.saveAppConfigs(configs)

        for action in self.menuTheme.actions():

            if action.text() == file: continue

            action.setChecked(False)