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);
}
}