consider an extra icon_path for only RO package

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

diff --git a/src/pkgmgrinfo_certinfo.c b/src/pkgmgrinfo_certinfo.c
index 5508ffd..4fceee2 100644 (file)
--- a/src/pkgmgrinfo_certinfo.c
+++ b/src/pkgmgrinfo_certinfo.c
@@ -57,13 +57,12 @@ static int _pkginfo_compare_certinfo(sqlite3 *db, const char *l_pkgid,
                pkgmgrinfo_cert_compare_result_type_e *result)
 {
        static const char query[] =
-               "SELECT author_signer_cert FROM package_cert_info "
+               "SELECT COALESCE(author_signer_cert, -1) FROM package_cert_info "
                "WHERE package=?";
        int ret;
        sqlite3_stmt *stmt;
        const char *pkgid[2];
        int certid[2] = {-1, -1};
-       int exists[2] = {-1, -1};
        int i;
 
        pkgid[0] = l_pkgid;
@@ -85,39 +84,29 @@ static int _pkginfo_compare_certinfo(sqlite3 *db, const char *l_pkgid,
 
                ret = sqlite3_step(stmt);
                if (ret == SQLITE_ROW) {
-                       exists[i] = 1;
                        _save_column_int(stmt, 0, &certid[i]);
                } else if (ret != SQLITE_DONE) {
                        _LOGE("step error: %s", sqlite3_errmsg(db));
                        sqlite3_finalize(stmt);
                        return PMINFO_R_ERROR;
-               } else {
-                       exists[i] = 0;
                }
 
                sqlite3_reset(stmt);
                sqlite3_clear_bindings(stmt);
        }
 
-       if (exists[0] == 0 && exists[1] == 0) {
+       if (certid[0] == -1 && certid[1] == -1)
                *result = PMINFO_CERT_COMPARE_BOTH_NO_CERT;
-               goto catch;
-       }       else if (exists[0] == 0) {
+       else if (certid[0] == -1)
                *result = PMINFO_CERT_COMPARE_LHS_NO_CERT;
-               goto catch;
-       }       else if (exists[1] == 0) {
+       else if (certid[1] == -1)
                *result = PMINFO_CERT_COMPARE_RHS_NO_CERT;
-               goto catch;
-       }
-
-       if (certid[0] == certid[1])
+       else if (certid[0] == certid[1])
                *result = PMINFO_CERT_COMPARE_MATCH;
        else
                *result = PMINFO_CERT_COMPARE_MISMATCH;
 
-catch:
        sqlite3_finalize(stmt);
-
        return PMINFO_R_OK;
 }
 
@@ -127,7 +116,7 @@ API int pkgmgrinfo_pkginfo_compare_usr_pkg_cert_info(const char *lhs_package_id,
 {
        int ret;
        sqlite3 *db;
-       const char *dbpath;
+       char *dbpath;
 
        if (lhs_package_id == NULL || rhs_package_id == NULL ||
                        compare_result == NULL) {
@@ -143,8 +132,10 @@ API int pkgmgrinfo_pkginfo_compare_usr_pkg_cert_info(const char *lhs_package_id,
        ret = sqlite3_open_v2(dbpath, &db, SQLITE_OPEN_READONLY, NULL);
        if (ret != SQLITE_OK) {
                _LOGE("failed to open db: %d", ret);
+               free(dbpath);
                return PMINFO_R_ERROR;
        }
+       free(dbpath);
 
        if (_pkginfo_compare_certinfo(db, lhs_package_id, rhs_package_id,
                                compare_result)) {
@@ -170,7 +161,7 @@ static int _pkginfo_get_pkgid_from_appid(uid_t uid, const char *appid,
                "SELECT package FROM package_app_info WHERE app_id=?";
        int ret;
        sqlite3 *db;
-       const char *dbpath;
+       char *dbpath;
        sqlite3_stmt *stmt;
 
        dbpath = getUserPkgParserDBPathUID(uid);
@@ -180,8 +171,10 @@ static int _pkginfo_get_pkgid_from_appid(uid_t uid, const char *appid,
        ret = sqlite3_open_v2(dbpath, &db, SQLITE_OPEN_READONLY, NULL);
        if (ret != SQLITE_OK) {
                _LOGE("failed to open db: %d", ret);
+               free(dbpath);
                return PMINFO_R_ERROR;
        }
+       free(dbpath);
 
        ret = sqlite3_prepare_v2(db, query, strlen(query), &stmt, NULL);
        if (ret != SQLITE_OK) {
@@ -203,7 +196,7 @@ static int _pkginfo_get_pkgid_from_appid(uid_t uid, const char *appid,
                _save_column_str(stmt, 0, pkgid);
                ret = PMINFO_R_OK;
        } else if (ret == SQLITE_DONE) {
-               _LOGI("cannot find pkgid of app %s for uid %d", appid);
+               _LOGI("cannot find pkgid of app %s for uid %d", appid, (int)uid);
                ret = PMINFO_R_ENOENT;
        } else {
                _LOGE("step error: %s", sqlite3_errmsg(db));
@@ -367,7 +360,7 @@ static int _pkginfo_get_certinfo(const char *pkgid, pkgmgr_certinfo_x *info)
 {
        int ret;
        sqlite3 *db;
-       const char *dbpath;
+       char *dbpath;
 
        /* open unified global cert db */
        dbpath = getUserPkgCertDBPathUID(GLOBAL_USER);
@@ -377,8 +370,10 @@ static int _pkginfo_get_certinfo(const char *pkgid, pkgmgr_certinfo_x *info)
        ret = sqlite3_open_v2(dbpath, &db, SQLITE_OPEN_READONLY, NULL);
        if (ret != SQLITE_OK) {
                _LOGE("failed to open db: %d", ret);
+               free(dbpath);
                return PMINFO_R_ERROR;
        }
+       free(dbpath);
 
        ret = _pkginfo_get_certid(db, pkgid, info->cert_id);
        if (ret != PMINFO_R_OK) {
@@ -475,11 +470,11 @@ static int _pkginfo_save_cert_info(sqlite3 *db, const char *pkgid,
                char *cert_info[])
 {
        static const char query_insert[] =
-               "INSERT INTO package_cert_info (package,"
+               "INSERT INTO package_cert_info (package, package_count,"
                " 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) "
-               "VALUES(?, "
+               "VALUES(?, 1,"
                " (SELECT cert_id FROM package_cert_index_info"
                "  WHERE cert_info=?),"
                " (SELECT cert_id FROM package_cert_index_info"
@@ -499,34 +494,8 @@ static int _pkginfo_save_cert_info(sqlite3 *db, const char *pkgid,
                " (SELECT cert_id FROM package_cert_index_info"
                "  WHERE cert_info=?))";
        static const char query_update[] =
-               "UPDATE package_cert_info SET "
-               " author_root_cert= "
-               "  (SELECT cert_id FROM package_cert_index_info"
-               "   WHERE cert_info=?),"
-               " author_im_cert= "
-               "  (SELECT cert_id FROM package_cert_index_info"
-               "   WHERE cert_info=?),"
-               " author_signer_cert= "
-               "  (SELECT cert_id FROM package_cert_index_info"
-               "   WHERE cert_info=?),"
-               " dist_root_cert= "
-               "  (SELECT cert_id FROM package_cert_index_info"
-               "   WHERE cert_info=?),"
-               " dist_im_cert= "
-               "  (SELECT cert_id FROM package_cert_index_info"
-               "   WHERE cert_info=?),"
-               " dist_signer_cert= "
-               "  (SELECT cert_id FROM package_cert_index_info"
-               "   WHERE cert_info=?),"
-               " dist2_root_cert= "
-               "  (SELECT cert_id FROM package_cert_index_info"
-               "   WHERE cert_info=?),"
-               "dist2_im_cert= "
-               "  (SELECT cert_id FROM package_cert_index_info"
-               "   WHERE cert_info=?),"
-               "dist2_signer_cert= "
-               "  (SELECT cert_id FROM package_cert_index_info"
-               "   WHERE cert_info=?) "
+               "UPDATE package_cert_info "
+               "SET package_count = package_count + 1 "
                "WHERE package=?";
        int ret;
        sqlite3_stmt *stmt;
@@ -560,16 +529,7 @@ static int _pkginfo_save_cert_info(sqlite3 *db, const char *pkgid,
                        _LOGE("prepare error: %s", sqlite3_errmsg(db));
                        return PMINFO_R_ERROR;
                }
-               idx = 1;
-               for (i = 0; i < MAX_CERT_TYPE; i++) {
-                       if (sqlite3_bind_text(stmt, idx++, cert_info[i], -1,
-                                       SQLITE_STATIC)) {
-                               _LOGE("bind error: %s", sqlite3_errmsg(db));
-                               sqlite3_finalize(stmt);
-                               return PMINFO_R_ERROR;
-                       }
-               }
-               sqlite3_bind_text(stmt, idx++, pkgid, -1, SQLITE_STATIC);
+               sqlite3_bind_text(stmt, 1, pkgid, -1, SQLITE_STATIC);
                ret = sqlite3_step(stmt);
                sqlite3_finalize(stmt);
        }
@@ -633,7 +593,7 @@ API int pkgmgrinfo_save_certinfo(const char *pkgid, pkgmgrinfo_instcertinfo_h ha
 {
        int ret;
        sqlite3 *db;
-       const char *dbpath;
+       char *dbpath;
        pkgmgr_instcertinfo_x *info = (pkgmgr_instcertinfo_x *)handle;
 
        if (pkgid == NULL || handle == NULL) {
@@ -649,8 +609,10 @@ API int pkgmgrinfo_save_certinfo(const char *pkgid, pkgmgrinfo_instcertinfo_h ha
        ret = sqlite3_open_v2(dbpath, &db, SQLITE_OPEN_READWRITE, NULL);
        if (ret != SQLITE_OK) {
                _LOGE("failed to open db: %d", ret);
+               free(dbpath);
                return PMINFO_R_ERROR;
        }
+       free(dbpath);
 
        ret = sqlite3_exec(db, "BEGIN EXCLUSIVE", NULL, NULL, NULL);
        if (ret != SQLITE_OK) {
@@ -667,6 +629,7 @@ API int pkgmgrinfo_save_certinfo(const char *pkgid, pkgmgrinfo_instcertinfo_h ha
                sqlite3_close_v2(db);
                return PMINFO_R_ERROR;
        }
+
        if (_pkginfo_save_cert_info(db, pkgid, info->cert_info)) {
                _LOGE("failed to save cert info, rollback now");
                sqlite3_exec(GET_DB(cert_db), "ROLLBACK", NULL, NULL, NULL);
@@ -711,7 +674,9 @@ API int pkgmgrinfo_destroy_certinfo_set_handle(pkgmgrinfo_instcertinfo_h handle)
 static int _pkginfo_delete_certinfo(sqlite3 *db, const char *pkgid)
 {
        static const char query[] =
-               "DELETE FROM package_cert_info WHERE package=?";
+               "UPDATE package_cert_info "
+               "SET package_count = package_count - 1 "
+               "WHERE package=?";
        int ret;
        sqlite3_stmt *stmt;
 
@@ -742,7 +707,7 @@ API int pkgmgrinfo_delete_usr_certinfo(const char *pkgid, uid_t uid)
 {
        int ret;
        sqlite3 *db;
-       const char *dbpath;
+       char *dbpath;
 
        if (pkgid == NULL) {
                _LOGE("invalid parameter");
@@ -757,8 +722,10 @@ API int pkgmgrinfo_delete_usr_certinfo(const char *pkgid, uid_t uid)
        ret = sqlite3_open_v2(dbpath, &db, SQLITE_OPEN_READWRITE, NULL);
        if (ret != SQLITE_OK) {
                _LOGE("failed to open db: %d", ret);
+               free(dbpath);
                return PMINFO_R_ERROR;
        }
+       free(dbpath);
 
        ret = sqlite3_exec(db, "BEGIN EXCLUSIVE", NULL, NULL, NULL);
        if (ret != SQLITE_OK) {