Fixed Svace(memory_leak)
[platform/core/dotnet/launcher.git] / NativeLauncher / installer-plugin / prefer_nuget_cache_plugin.cc
index 6e3e2c3..da66f24 100644 (file)
  */
 
 #include "log.h"
-#include "ni_common.h"
 #include "utils.h"
 #include "db_manager.h"
+#include "path_manager.h"
+#include "plugin_manager.h"
+#include "tac_common.h"
 
 #include <cstring>
 #include <fstream>
@@ -46,7 +48,7 @@ typedef struct Metadata {
        const char *value;
 } Metadata;
 
-std::vector<std::string> nugetPackagesAssembliesShaR2R;
+std::vector<std::string> nugetPackagesAssembliesSha;
 std::vector<std::string> tacDB;
 std::vector<std::string> createDirectories;
 std::vector<std::string> updateTac;
@@ -54,7 +56,6 @@ std::string status = "";
 std::string rootPath;
 std::string execName;
 std::string binPath;
-bool isCreateDirectory = false;
 static sqlite3 *tac_db = NULL;
 
 bool metadataCheck(GList *list)
@@ -65,9 +66,12 @@ bool metadataCheck(GList *list)
        mdInfo = (Metadata*)tag->data;
        if (strcmp(mdInfo->key, TAC_METADATA_KEY) == 0 && strcmp(mdInfo->value, METADATA_VALUE) == 0) {
                _DBG("Prefer nuget cache set TRUE");
-               NiCommonOption option = {std::string(), std::string(), std::string()};
-               if (initNICommon(&option) < 0) {
-                       _ERR("Fail to initialize NI Common");
+               if (initializePluginManager("normal")) {
+                       _ERR("Fail to initialize PluginManager");
+                       return false;
+               }
+               if (initializePathManager(std::string(), std::string(), std::string())) {
+                       _ERR("Fail to initialize PathManger");
                        return false;
                }
                return true;
@@ -137,7 +141,7 @@ void SHA256(std::string path, char outputBuffer[65])
        }
        SHA256_Final(hash, &sha256);
        for (int i = 0; i < SHA256_DIGEST_LENGTH; i++) {
-               sprintf(outputBuffer + (i * 2), "%02x", hash[i]);
+               snprintf(outputBuffer + (i * 2), 3, "%02x", hash[i]);
        }
        outputBuffer[64] = 0;
 
@@ -145,92 +149,86 @@ void SHA256(std::string path, char outputBuffer[65])
        free(buffer);
 }
 
-int depsJsonParser()
+void createSHA256Info(std::string sha256_info, std::string np)
 {
-       std::string deps_json_name = execName.substr(0, execName.rfind(".dll")) + ".deps.json";
-       if (bf::exists(concatPath(rootPath, deps_json_name))) {
-               std::string deps_json_path = concatPath(rootPath, deps_json_name);
-               std::ifstream ifs(deps_json_path);
-               Json::CharReaderBuilder reader;
-               Json::Value root;
-               std::string error;
-               if (ifs.is_open()) {
-                       if (!Json::parseFromStream(reader, ifs, &root, &error)) {
-                               _ERR("Failed to parse of deps.json");
-                               ifs.close();
-                               return -1;
-                       }
-                       const Json::Value runtimeTargetName = root["runtimeTarget"]["name"];
-                       const Json::Value nugetPackages = root["targets"][runtimeTargetName.asString().c_str()];
-                       for (auto& nuget : nugetPackages.getMemberNames()) {
-                               if (strstr(nuget.c_str(), TIZEN_DOTNET_NUGET) != NULL ||
-                                       strstr(nuget.c_str(), TIZEN_DOTNET_SDK_NUGET) != NULL ||
-                                       strstr(nuget.c_str(), (execName.substr(0, execName.find(".Tizen."))).c_str()) != NULL ||
-                                       strstr(nuget.c_str(), (execName.substr(0, execName.find(".dll"))).c_str()) != NULL) {
-                                       continue;
-                               } else {
-                                       const Json::Value assemblies = nugetPackages[nuget.c_str()]["runtime"];
-                                       if (assemblies != Json::nullValue) {
-                                               const Json::Value dependencies = nugetPackages[nuget.c_str()]["dependencies"];
-                                               std::string r2r = "";
-                                               for (auto& dependency : dependencies.getMemberNames()) {
-                                                       if (strstr(dependency.c_str(), TIZEN_DOTNET_NUGET) != NULL ||
-                                                               strstr(dependency.c_str(), NET_STANDARD_LIBRARY_NUGET) != NULL) {
-                                                               continue;
-                                                       } else {
-                                                               r2r = "--r2r";
-                                                       }
-                                               }
-                                               if (strcmp(r2r.c_str(), "--r2r") != 0) {
-                                                       tacDB.push_back(nuget);
-                                                       _INFO("Nuget package : %s", nuget.c_str());
-                                                       for (auto& assembly : assemblies.getMemberNames()) {
-                                                               std::string assembly_name = assembly.substr(assembly.rfind('/') + 1);
-                                                               char buffer[65] = {0};
-                                                               SHA256(concatPath(binPath, assembly_name), buffer);
-                                                               nugetPackagesAssembliesShaR2R.push_back(nuget + "/" + assembly_name + "/" + buffer + "/" + r2r);
-                                                               _INFO("Assembly / SHA256 : %s / %s", assembly_name.c_str(), buffer);
-                                                       }
-                                               }
+       std::ofstream ofs(sha256_info, std::ios::app);
+       int assembly_count = 0;
+       for (auto& npAssemblySha : nugetPackagesAssembliesSha) {
+               std::string nuget_package_assembly = npAssemblySha.substr(0, npAssemblySha.rfind(':'));
+               std::string nuget_package = nuget_package_assembly.substr(0, nuget_package_assembly.rfind(':'));
+               std::string assembly = nuget_package_assembly.substr(nuget_package_assembly.rfind(':') + 1);
+               std::string sha = npAssemblySha.substr(npAssemblySha.rfind(':') + 1);
+               if (!strcmp(nuget_package.c_str(), np.c_str())) {
+                       ofs << assembly << ":" << sha << std::endl;
+                       assembly_count++;
+               }
+       }
+       ofs << assembly_count << std::endl;
+       ofs.close();
+}
+
+int compareSHA256Info(std::string sha256_info, std::string np)
+{
+       int compare_count = 0;
+       int assembly_count = 0;
+       std::string sha256_count = "0";
+       for (auto& npAssemblySha : nugetPackagesAssembliesSha) {
+               std::string nuget_package_assembly = npAssemblySha.substr(0, npAssemblySha.rfind(':'));
+               std::string nuget_package = nuget_package_assembly.substr(0, nuget_package_assembly.rfind(':'));
+               std::string assembly = nuget_package_assembly.substr(nuget_package_assembly.rfind(':') + 1);
+               std::string sha = npAssemblySha.substr(npAssemblySha.rfind(':') + 1);
+               if (!strcmp(nuget_package.c_str(), np.c_str())) {
+                       assembly_count++;
+                       std::ifstream ifs(sha256_info);
+                       std::string get_str;
+                       if (ifs.is_open()) {
+                               while (getline(ifs, get_str)) {
+                                       if (!strcmp(get_str.c_str(), (assembly + ":" + sha).c_str())) {
+                                               compare_count++;
                                        }
+                                       sha256_count = get_str;
                                }
+                               ifs.close();
                        }
-                       ifs.close();
                }
        }
+       if (!strcmp(std::to_string(assembly_count).c_str(), std::to_string(compare_count).c_str()) &&
+               !strcmp(std::to_string(assembly_count).c_str(), sha256_count.c_str())) {
+               _INFO("Same nuget : %s", np.c_str());
+               return 1;
+       }
        return 0;
 }
 
-int createSymlink(std::string tac_version_dir, std::string np)
+int copyNCreateSymlink(std::string tac_version_dir, std::string np, bool is_create_tac_dir)
 {
-       uid_t uid = 0;
+       uid_t g_uid = 0;
+       gid_t g_gid = 0;
+       if (pkgmgr_installer_info_get_target_uid(&g_uid) < 0) {
+               _ERR("Failed to get UID");
+               return -1;
+       }
+
        std::string tac_dir = concatPath(binPath, TAC_SYMLINK_SUB_DIR);
        if (!createDir(tac_dir)) {
-               _INFO("Cannot create directory: %s", tac_dir.c_str());
+               _ERR("Cannot create directory: %s", tac_dir.c_str());
                return -1;
        }
 
-       for (auto& npAssemblyShaR2R : nugetPackagesAssembliesShaR2R) {
-               std::string nuget_package_assembly_sha = npAssemblyShaR2R.substr(0, npAssemblyShaR2R.rfind('/'));
-               std::string sha = nuget_package_assembly_sha.substr(nuget_package_assembly_sha.rfind('/') + 1);
-               std::string nuget_package_assembly = nuget_package_assembly_sha.substr(0, nuget_package_assembly_sha.rfind('/'));
-               std::string nuget_package = nuget_package_assembly.substr(0, nuget_package_assembly.rfind('/'));
-               std::string assembly = nuget_package_assembly.substr(nuget_package_assembly.rfind('/') + 1);
-               std::string r2r = npAssemblyShaR2R.substr(npAssemblyShaR2R.rfind('/') + 1);
+       for (auto& npAssemblySha : nugetPackagesAssembliesSha) {
+               std::string nuget_package_assembly = npAssemblySha.substr(0, npAssemblySha.rfind(':'));
+               std::string nuget_package = nuget_package_assembly.substr(0, nuget_package_assembly.rfind(':'));
+               std::string assembly = nuget_package_assembly.substr(nuget_package_assembly.rfind(':') + 1);
                if (!strcmp(nuget_package.c_str(), np.c_str())) {
                        if (bf::exists(concatPath(binPath, assembly))) {
-                               if (isCreateDirectory) {
+                               if (is_create_tac_dir) {
                                        if (!copyFile(concatPath(binPath, assembly), concatPath(tac_version_dir, assembly))) {
-                                               _ERR("Failed to move of %s", assembly.c_str());
+                                               _ERR("Failed to copy of %s", assembly.c_str());
                                                return -1;
                                        }
                                }
-                               if (pkgmgr_installer_info_get_target_uid(&uid) < 0) {
-                                       _ERR("Failed to get UID");
-                                       return -1;
-                               }
                                bf::create_symlink(concatPath(tac_version_dir, assembly), concatPath(tac_dir, assembly));
-                               if (lchown(concatPath(tac_dir, assembly).c_str(), uid, 0)) {
+                               if (lchown(concatPath(tac_dir, assembly).c_str(), g_uid, g_gid)) {
                                        _ERR("Failed to change owner of: %s", concatPath(tac_dir, assembly).c_str());
                                        return -1;
                                }
@@ -244,6 +242,20 @@ int createSymlink(std::string tac_version_dir, std::string np)
        return 0;
 }
 
+void depsJsonCheck() {
+       for (auto& npAssembly : depsJsonParser(rootPath, execName, getTPA())) {
+               std::string nugetPackage = npAssembly.substr(0, npAssembly.rfind(':'));
+               std::string assemblyName = npAssembly.substr(npAssembly.rfind(':') + 1);
+               tacDB.push_back(nugetPackage);
+               char buffer[65] = {0};
+               SHA256(concatPath(binPath, assemblyName), buffer);
+               nugetPackagesAssembliesSha.push_back(nugetPackage + ":" + assemblyName + ":" + buffer);
+               _INFO("Assembly : [%s] / SHA256 : [%s]", assemblyName.c_str(), buffer);
+       }
+       std::sort(tacDB.begin(), tacDB.end());
+       tacDB.erase(unique(tacDB.begin(), tacDB.end()), tacDB.end());
+}
+
 extern "C" int PKGMGR_MDPARSER_PLUGIN_INSTALL(const char *pkgId, const char *appId, GList *list)
 {
        _DBG("[===== PKGMGR_MDPARSER_PLUGIN_INSTALL =====]");
@@ -262,25 +274,18 @@ extern "C" int PKGMGR_MDPARSER_PLUGIN_INSTALL(const char *pkgId, const char *app
                binPath = concatPath(rootPath, "bin");
        }
        if (metadataCheck(list)) {
-               if (depsJsonParser() < 0) {
-                       return 0;
-               }
+               depsJsonCheck();
        }
 
        status = "install";
        tac_db = dbCreate(TAC_APP_LIST_DB);
-       if (tac_db) {
-               if (!dbOpen(tac_db, TAC_APP_LIST_DB)) {
-                       _ERR("Sqlite open error");
-                       return 0;
-               }
-       } else {
+       if (!tac_db) {
                _ERR("Sqlite create error");
                return 0;
        }
 
        if (tacDB.empty()) {
-               _ERR("Not exist .deps.json file");
+               _INFO("Not exist .deps.json file");
                return 0;
        }
 
@@ -292,78 +297,50 @@ extern "C" int PKGMGR_MDPARSER_PLUGIN_INSTALL(const char *pkgId, const char *app
 
                std::string tac_version_dir = concatPath(__TAC_DIR, np);
                std::string sha256_info = concatPath(tac_version_dir, TAC_SHA_256_INFO);
-               isCreateDirectory = false;
                if (!bf::exists(tac_version_dir)) {
                        _INFO("Create tac_version_dir [%s]", tac_version_dir.c_str());
                        if (!createDir(tac_version_dir)) {
                                _ERR("Cannot create directory: %s", tac_version_dir.c_str());
                                return 0;
                        }
-                       isCreateDirectory = true;
                        createDirectories.push_back(tac_version_dir);
-                       std::ofstream ofs(sha256_info, std::ios::app);
-                       int assembly_count = 0;
-                       for (auto& npAssemblyShaR2R : nugetPackagesAssembliesShaR2R) {
-                               std::string nuget_package_assembly_sha = npAssemblyShaR2R.substr(0, npAssemblyShaR2R.rfind('/'));
-                               std::string sha = nuget_package_assembly_sha.substr(nuget_package_assembly_sha.rfind('/') + 1);
-                               std::string nuget_package_assembly = nuget_package_assembly_sha.substr(0, nuget_package_assembly_sha.rfind('/'));
-                               std::string nuget_package = nuget_package_assembly.substr(0, nuget_package_assembly.rfind('/'));
-                               std::string assembly = nuget_package_assembly.substr(nuget_package_assembly.rfind('/') + 1);
-                               std::string r2r = npAssemblyShaR2R.substr(npAssemblyShaR2R.rfind('/') + 1);
-                               if (!strcmp(nuget_package.c_str(), np.c_str())) {
-                                       ofs << assembly << ";" << sha << std::endl;
-                                       assembly_count++;
-                               }
+                       if (!bf::is_symlink(sha256_info)) {
+                               createSHA256Info(sha256_info, np);
+                       } else {
+                               _ERR("Failed to create sha256_info. Symbolic link is detected");
+                               return -1;
                        }
-                       ofs << assembly_count << std::endl;
-                       ofs.close();
 
-                       if (createSymlink(tac_version_dir, np) < 0) {
+                       if (copyNCreateSymlink(tac_version_dir, np, true) < 0) {
                                _ERR("Failed to create symlink");
                                return -1;
                        }
-                       std::string sql = "INSERT INTO TAC (PKGID, NUGET, NAME, VERSION) " \
-                                       "VALUES ('" + std::string(pkgId) + "', '" + np + "', '" + tac_name + "', '" + tac_version + "');";
+
+                       char *sql = sqlite3_mprintf(
+                               "INSERT INTO TAC (PKGID, NUGET, NAME, VERSION) " \
+                               "VALUES (%Q, %Q, %Q, %Q);", pkgId, np.c_str(), tac_name.c_str(), tac_version.c_str());
                        dbInsert(tac_db, TAC_APP_LIST_DB, sql);
+                       sqlite3_free(sql);
                } else {
                        _INFO("Exists tac_version_dir [%s]", tac_version_dir.c_str());
-                       int compare_count = 0;
-                       int assembly_count = 0;
-                       std::string sha256_count = "0";
-                       for (auto& npAssemblyShaR2R : nugetPackagesAssembliesShaR2R) {
-                               std::string nuget_package_assembly_sha = npAssemblyShaR2R.substr(0, npAssemblyShaR2R.rfind('/'));
-                               std::string sha = nuget_package_assembly_sha.substr(nuget_package_assembly_sha.rfind('/') + 1);
-                               std::string nuget_package_assembly = nuget_package_assembly_sha.substr(0, nuget_package_assembly_sha.rfind('/'));
-                               std::string nuget_package = nuget_package_assembly.substr(0, nuget_package_assembly.rfind('/'));
-                               std::string assembly = nuget_package_assembly.substr(nuget_package_assembly.rfind('/') + 1);
-                               std::string r2r = npAssemblyShaR2R.substr(npAssemblyShaR2R.rfind('/') + 1);
-                               if (!strcmp(nuget_package.c_str(), np.c_str())) {
-                                       assembly_count++;
-                                       std::ifstream ifs(sha256_info);
-                                       std::string get_str;
-                                       if (ifs.is_open()) {
-                                               while (getline(ifs, get_str)) {
-                                                       if (!strcmp(get_str.c_str(), (assembly + ";" + sha).c_str())) {
-                                                               compare_count++;
-                                                       }
-                                                       sha256_count = get_str;
-                                               }
-                                               ifs.close();
+                       if (!bf::is_symlink(sha256_info)) {
+                               if (compareSHA256Info(sha256_info, np)) {
+                                       if (copyNCreateSymlink(tac_version_dir, np, false) < 0) {
+                                               _ERR("Failed to create symlink");
+                                               return -1;
                                        }
+
+                                       char *sql = sqlite3_mprintf(
+                                               "INSERT INTO TAC (PKGID, NUGET, NAME, VERSION) " \
+                                               "VALUES (%Q, %Q, %Q, %Q);", pkgId, np.c_str(), tac_name.c_str(), tac_version.c_str());
+                                       dbInsert(tac_db, TAC_APP_LIST_DB, sql);
+                                       sqlite3_free(sql);
+                               } else {
+                                       _INFO("Different nuget : %s", np.c_str());
                                }
-                       }
-                       if (!strcmp(std::to_string(assembly_count).c_str(), std::to_string(compare_count).c_str()) &&
-                               !strcmp(std::to_string(assembly_count).c_str(), sha256_count.c_str())) {
-                               _INFO("Same : %s", tac_name.c_str());
-                               if (createSymlink(tac_version_dir, np) < 0) {
-                                       _ERR("Failed to create symlink");
-                                       return -1;
-                               }
-                               std::string sql = "INSERT INTO TAC (PKGID, NUGET, NAME, VERSION) " \
-                                               "VALUES ('" + std::string(pkgId) + "', '" + np + "', '" + tac_name + "', '" + tac_version + "');";
-                               dbInsert(tac_db, TAC_APP_LIST_DB, sql);
                        } else {
-                               _INFO("Different : %s", tac_name.c_str());
+                               _ERR("Failed to create sha256_info. Symbolic link is detected");
+                               return -1;
                        }
                }
                if (!bf::exists(sha256_info)) {
@@ -375,30 +352,21 @@ extern "C" int PKGMGR_MDPARSER_PLUGIN_INSTALL(const char *pkgId, const char *app
        return 0;
 }
 
-static int sqliteCb(void *count, int argc, char **argv, char **azColName) {
+static int sqliteCb(void *count, int argc, char **argv, char **colName) {
        int *c = (int*)count;
        *c = atoi(argv[0]);
        return 0;
 }
 
-int updateTacDB(const char *pkgId)
+int updateTacDB(sqlite3 *sqlite)
 {
        for (auto& unp : updateTac) {
-               int ret;
                int count = -1;
-               if (tac_db) {
-                       if (!dbOpen(tac_db, TAC_APP_LIST_DB)) {
-                               _ERR("Sqlite open error");
-                               return -1;
-                       }
-               } else {
-                       _ERR("Sqlite create error");
-                       return -1;
-               }
-               std::string sql = "SELECT COUNT(NUGET) FROM TAC WHERE NUGET = '" + unp + "';";
-               ret = sqlite3_exec(tac_db, sql.c_str(), sqliteCb, &count, NULL);
+               char *sql = sqlite3_mprintf("SELECT COUNT(NUGET) FROM TAC WHERE NUGET = %Q;", unp.c_str());
+               int ret = sqlite3_exec(sqlite, sql, sqliteCb, &count, NULL);
                if (ret != SQLITE_OK) {
                        _ERR("Sqlite select error");
+                       sqlite3_free(sql);
                        return -1;
                }
                if (count == 0) {
@@ -406,13 +374,16 @@ int updateTacDB(const char *pkgId)
                        std::string tac_version_dir_backup = tac_version_dir_prev + ".bck";
                        if (!copyDir(tac_version_dir_prev, tac_version_dir_backup)) {
                                _ERR("Failed to copy of %s to %s", tac_version_dir_prev.c_str(), tac_version_dir_backup.c_str());
+                               sqlite3_free(sql);
                                return -1;
                        }
                        if (!removeAll(tac_version_dir_prev)) {
                                _ERR("Failed to remove of %s", tac_version_dir_prev.c_str());
+                               sqlite3_free(sql);
                                return -1;
                        }
                }
+               sqlite3_free(sql);
        }
        return 0;
 }
@@ -438,31 +409,26 @@ extern "C" int PKGMGR_MDPARSER_PLUGIN_UPGRADE(const char *pkgId, const char *app
                _INFO("Skipped to parse of deps.json");
        } else {
                if (metadataCheck(list)) {
-                       if (depsJsonParser() < 0) {
-                               return 0;
-                       }
+                       depsJsonCheck();
                }
        }
 
        status = "update";
        tac_db = dbCreate(TAC_APP_LIST_DB);
-       if (tac_db) {
-               if (!dbOpen(tac_db, TAC_APP_LIST_DB)) {
-                       _ERR("Sqlite open error");
-                       return 0;
-               }
-       } else {
-               _ERR("Sqlite create error");
+       if (!tac_db) {
+               _ERR("Sqlite open error");
                return 0;
        }
 
-       std::string sql = "SELECT * FROM TAC WHERE PKGID = '" + std::string(pkgId) + "';";
+       char *sql = sqlite3_mprintf("SELECT * FROM TAC WHERE PKGID = %Q;", pkgId);
        updateTac = dbSelect(tac_db, TAC_APP_LIST_DB, sql);
+       sqlite3_free(sql);
 
        if (tacDB.empty()) {
-               sql = "DELETE FROM TAC WHERE PKGID = '" + std::string(pkgId) + "';";
+               sql = sqlite3_mprintf("DELETE FROM TAC WHERE PKGID = %Q;", pkgId);
                dbDelete(tac_db, TAC_APP_LIST_DB, sql);
-               if (updateTacDB(pkgId) < 0) {
+               sqlite3_free(sql);
+               if (updateTacDB(tac_db) < 0) {
                        return -1;
                }
        } else {
@@ -474,104 +440,86 @@ extern "C" int PKGMGR_MDPARSER_PLUGIN_UPGRADE(const char *pkgId, const char *app
 
                        std::string tac_version_dir = concatPath(__TAC_DIR, np);
                        std::string sha256_info = concatPath(tac_version_dir, TAC_SHA_256_INFO);
-                       isCreateDirectory = false;
                        if (!bf::exists(tac_version_dir)) {
                                _INFO("Create tac_version_dir [%s]", tac_version_dir.c_str());
                                if (!createDir(tac_version_dir)) {
                                        _ERR("Cannot create directory: %s", tac_version_dir.c_str());
                                        return 0;
                                }
-                               isCreateDirectory = true;
                                createDirectories.push_back(tac_version_dir);
-                               std::ofstream ofs2(sha256_info, std::ios::app);
-                               int assembly_count = 0;
-                               for (auto& npAssemblyShaR2R : nugetPackagesAssembliesShaR2R) {
-                                       std::string nuget_package_assembly_sha = npAssemblyShaR2R.substr(0, npAssemblyShaR2R.rfind('/'));
-                                       std::string sha = nuget_package_assembly_sha.substr(nuget_package_assembly_sha.rfind('/') + 1);
-                                       std::string nuget_package_assembly = nuget_package_assembly_sha.substr(0, nuget_package_assembly_sha.rfind('/'));
-                                       std::string nuget_package = nuget_package_assembly.substr(0, nuget_package_assembly.rfind('/'));
-                                       std::string assembly = nuget_package_assembly.substr(nuget_package_assembly.rfind('/') + 1);
-                                       std::string r2r = npAssemblyShaR2R.substr(npAssemblyShaR2R.rfind('/') + 1);
-                                       if (!strcmp(nuget_package.c_str(), np.c_str())) {
-                                               ofs2 << assembly << ";" << sha << std::endl;
-                                               assembly_count++;
-                                       }
+                               if (!bf::is_symlink(sha256_info)) {
+                                       createSHA256Info(sha256_info, np);
+                               } else {
+                                       _ERR("Failed to create sha256_info. Symbolic link is detected");
+                                       return -1;
                                }
-                               ofs2 << assembly_count << std::endl;
-                               ofs2.close();
-                               if (createSymlink(tac_version_dir, np) < 0) {
+
+                               if (copyNCreateSymlink(tac_version_dir, np, true) < 0) {
                                        _ERR("Failed to create symlink");
                                        return -1;
                                }
 
                                int count = -1;
-                               sql = "SELECT COUNT(NUGET) FROM TAC WHERE PKGID = '" + std::string(pkgId) + "' AND NAME = '" + tac_name + "';";
-                               int ret = sqlite3_exec(tac_db, sql.c_str(), sqliteCb, &count, NULL);
+                               sql = sqlite3_mprintf(
+                                               "SELECT COUNT(NUGET) FROM TAC WHERE PKGID = %Q AND NAME = %Q;", pkgId, tac_name.c_str());
+                               int ret = sqlite3_exec(tac_db, sql, sqliteCb, &count, NULL);
                                if (ret != SQLITE_OK) {
                                        _ERR("Sqlite select error");
+                                       sqlite3_free(sql);
                                        return -1;
                                }
+                               sqlite3_free(sql);
                                if (count == 1) {
-                                       sql = "UPDATE TAC SET NAME = '" + tac_name + "', VERSION = '" + tac_version + "', NUGET = '" + np + "' WHERE PKGID = '" + std::string(pkgId) + "' AND NAME = '" + tac_name + "';";
+                                       sql = sqlite3_mprintf(
+                                               "UPDATE TAC SET NAME = %Q, VERSION = %Q, NUGET = %Q WHERE PKGID = %Q AND NAME = %Q;",
+                                               tac_name.c_str(), tac_version.c_str(), np.c_str(), pkgId, tac_name.c_str());
                                        dbUpdate(tac_db, TAC_APP_LIST_DB, sql);
+                                       sqlite3_free(sql);
                                } else if (count == 0) {
-                                       sql = "INSERT INTO TAC (PKGID, NUGET, NAME, VERSION) " \
-                                               "VALUES ('" + std::string(pkgId) + "', '" + np + "', '" + tac_name + "', '" + tac_version + "');";
+                                       sql = sqlite3_mprintf(
+                                               "INSERT INTO TAC (PKGID, NUGET, NAME, VERSION) " \
+                                               "VALUES (%Q, %Q, %Q, %Q);", pkgId, np.c_str(), tac_name.c_str(), tac_version.c_str());
                                        dbInsert(tac_db, TAC_APP_LIST_DB, sql);
+                                       sqlite3_free(sql);
                                }
                        } else {
                                _INFO("Exists tac_version_dir [%s]", tac_version_dir.c_str());
-                               int compare_count = 0;
-                               int assembly_count = 0;
-                               std::string sha256_count = "0";
-                               for (auto& npAssemblyShaR2R : nugetPackagesAssembliesShaR2R) {
-                                       std::string nuget_package_assembly_sha = npAssemblyShaR2R.substr(0, npAssemblyShaR2R.rfind('/'));
-                                       std::string sha = nuget_package_assembly_sha.substr(nuget_package_assembly_sha.rfind('/') + 1);
-                                       std::string nuget_package_assembly = nuget_package_assembly_sha.substr(0, nuget_package_assembly_sha.rfind('/'));
-                                       std::string nuget_package = nuget_package_assembly.substr(0, nuget_package_assembly.rfind('/'));
-                                       std::string assembly = nuget_package_assembly.substr(nuget_package_assembly.rfind('/') + 1);
-                                       std::string r2r = npAssemblyShaR2R.substr(npAssemblyShaR2R.rfind('/') + 1);
-                                       if (!strcmp(nuget_package.c_str(), np.c_str())) {
-                                               assembly_count++;
-                                               std::ifstream ifs2(sha256_info);
-                                               std::string get_str;
-                                               if (ifs2.is_open()) {
-                                                       while (getline(ifs2, get_str)) {
-                                                               if (!strcmp(get_str.c_str(), (assembly + ";" + sha).c_str())) {
-                                                                       compare_count++;
-                                                               }
-                                                               sha256_count = get_str;
-                                                       }
-                                                       ifs2.close();
+                               if (!bf::is_symlink(sha256_info)) {
+                                       if (compareSHA256Info(sha256_info, np)) {
+                                               if (copyNCreateSymlink(tac_version_dir, np, false) < 0) {
+                                                       _ERR("Failed to create symlink");
+                                                       return -1;
                                                }
-                                       }
-                               }
-
-                               if (!strcmp(std::to_string(assembly_count).c_str(), std::to_string(compare_count).c_str()) &&
-                                       !strcmp(std::to_string(assembly_count).c_str(), sha256_count.c_str())) {
-                                       _INFO("Same : %s", tac_name.c_str());
-                                       if (createSymlink(tac_version_dir, np) < 0) {
-                                               _ERR("Failed to create symlink");
-                                               return -1;
-                                       }
 
-                                       int count = -1;
-                                       std::string sql = "SELECT COUNT(NUGET) FROM TAC WHERE PKGID = '" + std::string(pkgId) + "' AND NAME = '" + tac_name + "';";
-                                       int ret = sqlite3_exec(tac_db, sql.c_str(), sqliteCb, &count, NULL);
-                                       if (ret != SQLITE_OK) {
-                                               _ERR("Sqlite select error");
-                                               return -1;
-                                       }
-                                       if (count == 1) {
-                                               sql = "UPDATE TAC SET NAME = '" + tac_name + "', VERSION = '" + tac_version + "', NUGET = '" + np + "' WHERE PKGID = '" + std::string(pkgId) + "' AND NAME = '" + tac_name + "';";
-                                               dbUpdate(tac_db, TAC_APP_LIST_DB, sql);
-                                       } else if (count == 0) {
-                                               sql = "INSERT INTO TAC (PKGID, NUGET, NAME, VERSION) " \
-                                                       "VALUES ('" + std::string(pkgId) + "', '" + np + "', '" + tac_name + "', '" + tac_version + "');";
-                                               dbInsert(tac_db, TAC_APP_LIST_DB, sql);
+                                               int count = -1;
+                                               char *sql = sqlite3_mprintf(
+                                                       "SELECT COUNT(NUGET) FROM TAC WHERE PKGID = %Q AND NAME = %Q;", pkgId, tac_name.c_str());
+                                               int ret = sqlite3_exec(tac_db, sql, sqliteCb, &count, NULL);
+                                               if (ret != SQLITE_OK) {
+                                                       _ERR("Sqlite select error");
+                                                       sqlite3_free(sql);
+                                                       return -1;
+                                               }
+                                               sqlite3_free(sql);
+                                               if (count == 1) {
+                                                       sql = sqlite3_mprintf(
+                                                               "UPDATE TAC SET NAME = %Q, VERSION = %Q, NUGET = %Q WHERE PKGID = %Q AND NAME = %Q;",
+                                                               tac_name.c_str(), tac_version.c_str(), np.c_str(), pkgId, tac_name.c_str());
+                                                       dbUpdate(tac_db, TAC_APP_LIST_DB, sql);
+                                                       sqlite3_free(sql);
+                                               } else if (count == 0) {
+                                                       sql = sqlite3_mprintf(
+                                                               "INSERT INTO TAC (PKGID, NUGET, NAME, VERSION) " \
+                                                               "VALUES (%Q, %Q, %Q, %Q);", pkgId, np.c_str(), tac_name.c_str(), tac_version.c_str());
+                                                       dbInsert(tac_db, TAC_APP_LIST_DB, sql);
+                                                       sqlite3_free(sql);
+                                               }
+                                       } else {
+                                               _INFO("Different nuget : %s", np.c_str());
                                        }
                                } else {
-                                       _INFO("Different : %s", tac_name.c_str());
+                                       _ERR("Failed to create sha256_info. Symbolic link is detected");
+                                       return -1;
                                }
                        }
                        if (!bf::exists(sha256_info)) {
@@ -588,13 +536,13 @@ extern "C" int PKGMGR_MDPARSER_PLUGIN_UPGRADE(const char *pkgId, const char *app
                                        break;
                                }
                        }
-
                        if (!isExits) {
-                               std::string sql = "DELETE FROM TAC WHERE PKGID = '" + std::string(pkgId) + "' AND NUGET = '" + unp + "';";
+                               char *sql = sqlite3_mprintf("DELETE FROM TAC WHERE PKGID = %Q AND NUGET = %Q;", pkgId, unp.c_str());
                                dbDelete(tac_db, TAC_APP_LIST_DB, sql);
+                               sqlite3_free(sql);
                        }
                }
-               if (updateTacDB(pkgId) < 0) {
+               if (updateTacDB(tac_db) < 0) {
                        return -1;
                }
        }
@@ -607,24 +555,21 @@ extern "C" int PKGMGR_MDPARSER_PLUGIN_UNINSTALL(const char *pkgId, const char *a
        _INFO("PackageID : %s", pkgId);
 
        status = "uninstall";
-       tac_db = dbCreate(TAC_APP_LIST_DB);
-       if (tac_db) {
-               if (!dbOpen(tac_db, TAC_APP_LIST_DB)) {
-                       _ERR("Sqlite open error");
-                       return 0;
-               }
-       } else {
-               _ERR("Sqlite create error");
+       tac_db = dbOpen(TAC_APP_LIST_DB);
+       if (!tac_db) {
+               _ERR("Sqlite open error");
                return 0;
        }
 
-       std::string sql = "SELECT * FROM TAC WHERE PKGID = '" + std::string(pkgId) + "';";
+       char *sql = sqlite3_mprintf("SELECT * FROM TAC WHERE PKGID = %Q;", pkgId);
        updateTac = dbSelect(tac_db, TAC_APP_LIST_DB, sql);
+       sqlite3_free(sql);
 
-       sql = "DELETE FROM TAC WHERE PKGID = '" + std::string(pkgId) + "';";
+       sql = sqlite3_mprintf("DELETE FROM TAC WHERE PKGID = %Q;", pkgId);
        dbDelete(tac_db, TAC_APP_LIST_DB, sql);
+       sqlite3_free(sql);
 
-       if (updateTacDB(pkgId) < 0) {
+       if (updateTacDB(tac_db) < 0) {
                return -1;
        }
        return 0;
@@ -643,26 +588,33 @@ extern "C" int PKGMGR_MDPARSER_PLUGIN_REMOVED(const char *pkgId, const char *app
 void cleanStep(std::string tac)
 {
        std::string current_tac = concatPath(__TAC_DIR, tac.substr(0, tac.find('/')));
-       for (auto& bck : bf::recursive_directory_iterator(current_tac)) {
-               if (bf::is_directory(bck.path()) && strstr(bck.path().c_str(), ".bck") != NULL) {
-                       if (!removeAll(bck.path().string())) {
-                               _ERR("Failed to remove of %s", bck.path().c_str());
+       try {
+               for (auto& bck : bf::recursive_directory_iterator(current_tac)) {
+                       std::string bck_path = bck.path().string();
+                       if (bf::is_directory(bck_path) && strstr(bck_path.c_str(), ".bck") != NULL) {
+                               if (!removeAll(bck_path)) {
+                                       _ERR("Failed to remove of %s", bck_path.c_str());
+                               }
+                               break;
                        }
-                       break;
                }
-       }
 
-       bool isExist = false;
-       for (auto& bck : bf::recursive_directory_iterator(current_tac)) {
-               if (bf::exists(bck.path()) && bf::is_directory(bck.path()) && strstr(bck.path().c_str(), ".bck") == NULL) {
-                       isExist = true;
-                       break;
+               bool isExist = false;
+               for (auto& bck : bf::recursive_directory_iterator(current_tac)) {
+                       std::string bck_path = bck.path().string();
+                       if (bf::exists(bck_path) && bf::is_directory(bck_path) && strstr(bck_path.c_str(), ".bck") == NULL) {
+                               isExist = true;
+                               break;
+                       }
                }
-       }
-       if (!isExist) {
-               if (!removeAll(current_tac)) {
-                       _ERR("Failed to remove of %s", current_tac.c_str());
+               if (!isExist) {
+                       if (!removeAll(current_tac)) {
+                               _ERR("Failed to remove of %s", current_tac.c_str());
+                       }
                }
+       } catch (const bf::filesystem_error& error) {
+               _ERR("Failed to recursive directory: %s", error.what());
+               return;
        }
 }
 
@@ -710,14 +662,19 @@ extern "C" int PKGMGR_MDPARSER_PLUGIN_CLEAN(const char *pkgId, const char *appId
 void undoStep(std::string tac)
 {
        std::string current_tac = concatPath(__TAC_DIR, tac.substr(0, tac.find('/')));
-       for (auto& bck : bf::recursive_directory_iterator(current_tac)) {
-               if (bf::is_directory(bck.path()) && strstr(bck.path().c_str(), ".bck") != NULL) {
-                       if (!moveFile(bck.path(), bck.path().string().substr(0, bck.path().string().rfind(".bck")))) {
-                               _ERR("Failed to move %s to %s",
-                                       bck.path().c_str(), bck.path().string().substr(0, bck.path().string().rfind(".bck")).c_str());
+       try {
+               for (auto& bck : bf::recursive_directory_iterator(current_tac)) {
+                       std::string bck_path = bck.path().string();
+                       if (bf::is_directory(bck_path) && strstr(bck_path.c_str(), ".bck") != NULL) {
+                               if (!moveFile(bck_path, bck_path.substr(0, bck_path.rfind(".bck")))) {
+                                       _ERR("Failed to move %s", bck_path.c_str());
+                               }
+                               break;
                        }
-                       break;
                }
+       } catch (const bf::filesystem_error& error) {
+               _ERR("Failed to recursive directory: %s", error.what());
+               return;
        }
 }