HYTOS

                if fileName.endswith(".sql") and (1 == len(os.path.splitext(fileName).split('.'))):

        @brief      return project database path

        @history    humkyung 2018.04.19 return Project.db in Program Data folder instead of PROJECT_DB_PATH variable

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

        if not os.path.exists(path): os.makedirs(path)

        prjDatabaseFilePath = os.path.join(path, 'Project.db')

        try:

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

            conn = sqlite3.connect(prjDatabaseFilePath)

            # Get a cursor object

            cursor = conn.cursor()

            filePath = os.path.join(os.path.dirname(os.path.realpath(__file__)), 'Scripts', 'Project.Projects.sql')

            try:

                file = QFile(filePath)

                file.open(QFile.ReadOnly)

                sql = file.readAll()

                sql = str(sql, encoding='utf8')

                cursor.executescript(sql)

            finally:

                file.close()

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

        return prjDatabaseFilePath

        @history    humkyung 2018.04.19 use getPrjDatabasePath function instead of PROJECT_DB_PATH variable

        try:

            prjDatabaseFilePath = self.getPrjDatabasePath()

            conn = sqlite3.connect(prjDatabaseFilePath)

            folderName = dir.split('/')[-1]

            if folderName:

                nowDate = datetime.datetime.now().strftime('%Y.%m.%d %H:%M')

                sql = "INSERT INTO Projects(Name, Path, CreatedDate, UpdatedDate) VALUES('" + folderName + "', '" + dir + "', '" + nowDate + "', '" + nowDate + "')"

                cur = conn.cursor()

                cur.execute(sql)

                conn.commit()

            else:

                print("Empty folder name")

        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:

        @history    humkyung 2018.04.19 use getPrjDatabasePath function instead of PROJECT_DB_PATH variable

        try:

            prjDatabaseFilePath = self.getPrjDatabasePath()

            conn = sqlite3.connect(prjDatabaseFilePath)

            nowDate = datetime.datetime.now().strftime('%Y.%m.%d %H:%M')

            sql = '''

                UPDATE Projects

                SET UpdatedDate = ?

                WHERE Id = ?

            '''

            cur = conn.cursor()

            cur.execute(sql, (nowDate, id))

            conn.commit()

        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:

            conn.close()

        @history    humkyung 2018.04.18 add only project which's project exists

            sql = 'SELECT id,name,path,createddate,updateddate  FROM Projects ORDER BY UpdatedDate DESC'

                    if os.path.isdir(row[2]):   # check if folder exists

                        projectList.append(Project(row[0], row[1], row[2], row[3], row[4]))

CREATE TABLE IF NOT EXISTS `Projects` (

	`Id`	INTEGER PRIMARY KEY AUTOINCREMENT,

	`Name`	TEXT,

	`Path`	TEXT,

	`CreatedDate`	TEXT,

	`UpdatedDate`	TEXT

);