fix getting "(NULL)" value of icon_path

[platform/core/appfw/pkgmgr-info.git] / src / pkgmgrinfo_db.c

diff --git a/src/pkgmgrinfo_db.c b/src/pkgmgrinfo_db.c
index d5ea9af..cd59b40 100644 (file)
--- a/src/pkgmgrinfo_db.c
+++ b/src/pkgmgrinfo_db.c
@@ -20,24 +20,61 @@
 #include "pkgmgr_parser.h"
 #include "pkgmgr_parser_internal.h"
 
-#define QUERY_CREATE_TABLE_PACKAGE_CERT_INDEX_INFO "create table if not exists package_cert_index_info " \
-                                               "(cert_info text not null, " \
-                                               "cert_id integer, " \
-                                               "cert_ref_count integer, " \
-                                               "PRIMARY KEY(cert_id)) "
-
-#define QUERY_CREATE_TABLE_PACKAGE_CERT_INFO "create table if not exists package_cert_info " \
-                                               "(package text not null, " \
-                                               "author_root_cert integer, " \
-                                               "author_im_cert integer, " \
-                                               "author_signer_cert integer, " \
-                                               "dist_root_cert integer, " \
-                                               "dist_im_cert integer, " \
-                                               "dist_signer_cert integer, " \
-                                               "dist2_root_cert integer, " \
-                                               "dist2_im_cert integer, " \
-                                               "dist2_signer_cert integer, " \
-                                               "PRIMARY KEY(package)) "
+#define QUERY_CREATE_TABLE_PACKAGE_CERT_INDEX_INFO \
+       "CREATE TABLE IF NOT EXISTS package_cert_index_info( " \
+       " cert_info TEXT UNIQUE, " \
+       " cert_id INTEGER PRIMARY KEY, " \
+       " cert_ref_count INTEGER NOT NULL)"
+
+#define QUERY_CREATE_TABLE_PACKAGE_CERT_INFO \
+       "CREATE TABLE IF NOT EXISTS package_cert_info( " \
+       " package TEXT PRIMARY KEY, " \
+       " author_root_cert INTEGER, " \
+       " author_im_cert INTEGER, " \
+       " author_signer_cert INTEGER, " \
+       " dist_root_cert INTEGER, " \
+       " dist_im_cert INTEGER, " \
+       " dist_signer_cert INTEGER, " \
+       " dist2_root_cert INTEGER, " \
+       " dist2_im_cert INTEGER, " \
+       " dist2_signer_cert INTEGER)"
+
+#define QUERY_CREATE_TRIGGER_DELETE_CERT_INFO \
+       "CREATE TRIGGER IF NOT EXISTS delete_cert_info " \
+       "AFTER DELETE ON package_cert_info " \
+       "BEGIN" \
+       " UPDATE package_cert_index_info SET" \
+       "  cert_ref_count = cert_ref_count - 1" \
+       " WHERE cert_id = OLD.author_root_cert" \
+       "  OR cert_id = OLD.author_im_cert" \
+       "  OR cert_id = OLD.author_signer_cert" \
+       "  OR cert_id = OLD.dist_root_cert" \
+       "  OR cert_id = OLD.dist_im_cert" \
+       "  OR cert_id = OLD.dist_signer_cert" \
+       "  OR cert_id = OLD.dist2_root_cert" \
+       "  OR cert_id = OLD.dist2_im_cert" \
+       "  OR cert_id = OLD.dist2_signer_cert;" \
+       "END;"
+
+#define QUERY_CREATE_TRIGGER_UPDATE_CERT_INDEX_INFO \
+       "CREATE TRIGGER IF NOT EXISTS update_cert_index_info " \
+       "AFTER UPDATE ON package_cert_index_info " \
+       "WHEN ((SELECT cert_ref_count FROM package_cert_index_info " \
+       "       WHERE cert_id = OLD.cert_id) = 0) "\
+       "BEGIN" \
+       " DELETE FROM package_cert_index_info WHERE cert_id = OLD.cert_id;" \
+       "END;"
+
+#define QUERY_CREATE_TRIGGER_UPDATE_CERT_INFO_FORMAT \
+       "CREATE TRIGGER IF NOT EXISTS update_%s_info " \
+       "AFTER UPDATE ON package_cert_info " \
+       "WHEN (OLD.%s IS NOT NULL) " \
+       "BEGIN" \
+       " UPDATE package_cert_index_info SET" \
+       "  cert_ref_count = cert_ref_count - 1" \
+       " WHERE cert_id = OLD.%s;" \
+       "END;"
+
 __thread db_handle manifest_db;
 __thread db_handle cert_db;
 
@@ -144,11 +181,33 @@ static int __exec_db_query(sqlite3 *db, char *query, sqlite_query_callback callb
 
 int _check_create_cert_db(sqlite3 *certdb)
 {
+       int i;
+       char buf[BUFSIZE];
+       static const char *columns[] = {
+               "author_root_cert", "author_im_cert", "author_signer_cert",
+               "dist_root_cert", "dist_im_cert", "dist_signer_cert",
+               "dist2_root_cert", "dist2_im_cert", "dist2_signer_cert",
+               NULL};
        int ret = 0;
        ret = __exec_db_query(certdb, QUERY_CREATE_TABLE_PACKAGE_CERT_INDEX_INFO, NULL, NULL);
        if (ret < 0)
                return ret;
        ret = __exec_db_query(certdb, QUERY_CREATE_TABLE_PACKAGE_CERT_INFO, NULL, NULL);
+       if (ret < 0)
+               return ret;
+       ret = __exec_db_query(certdb, QUERY_CREATE_TRIGGER_DELETE_CERT_INFO, NULL, NULL);
+       if (ret < 0)
+               return ret;
+       ret = __exec_db_query(certdb, QUERY_CREATE_TRIGGER_UPDATE_CERT_INDEX_INFO, NULL, NULL);
+
+       for (i = 0; columns[i] != NULL; i++) {
+               snprintf(buf, sizeof(buf),
+                               QUERY_CREATE_TRIGGER_UPDATE_CERT_INFO_FORMAT,
+                               columns[i], columns[i], columns[i]);
+               ret = __exec_db_query(certdb, buf, NULL, NULL);
+               if (ret < 0)
+                       return ret;
+       }
        return ret;
 }
 static gid_t _get_gid(const char *name)
@@ -400,6 +459,11 @@ int __open_cert_db(uid_t uid, bool readonly)
        return 0;
 }
 
+void _save_column_int(sqlite3_stmt *stmt, int idx, int *i)
+{
+       *i = sqlite3_column_int(stmt, idx);
+}
+
 void _save_column_str(sqlite3_stmt *stmt, int idx, const char **str)
 {
        const char *val;
@@ -569,7 +633,6 @@ API int pkgmgrinfo_pkginfo_set_usr_installed_storage(const char *pkgid, INSTALL_
 {
        retvm_if(pkgid == NULL, PMINFO_R_EINVAL, "pkgid is NULL\n");
        int ret = -1;
-       int exist = 0;
        sqlite3 *pkgmgr_parser_db = NULL;
        char *query = NULL;