Fix security_manager_02_app_install_uninstall_full test

[platform/core/test/security-tests.git] / tests / security-manager-tests / common / sm_db.cpp

diff --git a/tests/security-manager-tests/common/sm_db.cpp b/tests/security-manager-tests/common/sm_db.cpp
index 2f420bf..8e3e562 100644 (file)
--- a/tests/security-manager-tests/common/sm_db.cpp
+++ b/tests/security-manager-tests/common/sm_db.cpp
@@ -187,15 +187,13 @@ void TestSecurityManagerDatabase::setup_privilege_groups(const std::string &priv
     if (!m_base.is_open())
         m_base.open();
 
-    sql << "INSERT OR IGNORE INTO privilege (name) VALUES ('" << privilege << "')";
-    m_base.execute(sql.str(), result);
-
     for (const auto &group : groups) {
         sql.clear();
         sql.str("");
-        sql << "INSERT OR IGNORE INTO privilege_group (privilege_id, name) "
-               "VALUES ((SELECT privilege_id FROM privilege WHERE name = '"
-                << privilege << "'), '" << group << "')";
+        sql << "INSERT INTO privilege_group_view (privilege_name, group_name) "
+               "VALUES ("
+                << "'" << privilege << "'" << ","
+                << "'" << group << "'" << ")";
         m_base.execute(sql.str(), result);
     }
 }