Add pkg update info features
[platform/core/appfw/pkgmgr-info.git] / parser / src / pkgmgr_parser_db.c
index 65ddf55..944651d 100644 (file)
@@ -50,6 +50,7 @@
 #define MAX_QUERY_LEN          4096
 #define BUFSIZE 4096
 #define OWNER_ROOT 0
+#define APPFW_USER "app_fw"
 #define MAX_INTEGER_LENGTH 10
 
 #define LDPI "ldpi"
@@ -135,6 +136,14 @@ sqlite3 *pkgmgr_cert_db;
                                                "REFERENCES package_info(package) " \
                                                "ON DELETE CASCADE)"
 
+#define QUERY_CREATE_TABLE_PACKAGE_UPDATE_INFO "CREATE TABLE IF NOT EXISTS package_update_info " \
+                                               "(package TEXT PRIMARY KEY, " \
+                                               "update_version TEXT NOT NULL, " \
+                                               "update_type TEXT NOT NULL DEFAULT 'none', " \
+                                               "FOREIGN KEY(package) " \
+                                               "REFERENCES package_info(package) " \
+                                               "ON DELETE CASCADE)"
+
 #define QUERY_CREATE_TABLE_PACKAGE_APP_INFO "CREATE TABLE IF NOT EXISTS package_app_info " \
                                                "(app_id TEXT PRIMARY KEY NOT NULL, " \
                                                "app_component TEXT NOT NULL, " \
@@ -180,6 +189,7 @@ sqlite3 *pkgmgr_cert_db;
                                                "app_effective_appid TEXT, " \
                                                "app_splash_screen_display TEXT NOT NULL DEFAULT 'true', " \
                                                "app_external_path TEXT, " \
+                                               "app_setup_appid TEXT, " \
                                                "FOREIGN KEY(package) " \
                                                "REFERENCES package_info(package) " \
                                                "ON DELETE CASCADE)"
@@ -270,7 +280,8 @@ sqlite3 *pkgmgr_cert_db;
                                                "providerid TEXT NOT NULL, " \
                                                "access TEXT NOT NULL, " \
                                                "type TEXT NOT NULL, " \
-                                               "PRIMARY KEY(app_id, providerid, access, type) " \
+                                               "trusted TEXT NOT NULL, " \
+                                               "PRIMARY KEY(providerid, type) " \
                                                "FOREIGN KEY(app_id) " \
                                                "REFERENCES package_app_info(app_id) " \
                                                "ON DELETE CASCADE)"
@@ -543,6 +554,11 @@ static int __exec_query(char *query)
                return -1;
        }
        sqlite3_free(error_message);
+
+       if (strncmp(query, "DELETE", 6) && sqlite3_changes(pkgmgr_parser_db) == 0) {
+               _LOGE("No such record matches with given query : %s\n", query);
+               return -1;
+       }
        return 0;
 }
 
@@ -1109,15 +1125,6 @@ static int __insert_mainapp_info(manifest_x *mfx)
                app = (application_x *)tmp->data;
                if (app == NULL)
                        continue;
-
-               sqlite3_snprintf(MAX_QUERY_LEN, query,
-                               "UPDATE package_app_info SET app_mainapp=%Q WHERE app_id=%Q",
-                               app->mainapp, app->appid);
-               ret = __exec_query(query);
-               if (ret == -1) {
-                       _LOGD("Package App Info DB Insert Failed\n");
-                       return -1;
-               }
                if (strcasecmp(app->mainapp, "True") == 0)
                        mfx->mainapp_id = strdup(app->appid);
        }
@@ -1128,21 +1135,6 @@ static int __insert_mainapp_info(manifest_x *mfx)
                app = (application_x *)mfx->application->data;
                if (app == NULL)
                        return -1;
-               if (app->appid) {
-                       sqlite3_snprintf(MAX_QUERY_LEN, query,
-                                       "UPDATE package_app_info SET app_mainapp='true' WHERE app_id=%Q",
-                                       app->appid);
-               } else {
-                       _LOGD("Not valid appid\n");
-                       return -1;
-               }
-
-               ret = __exec_query(query);
-               if (ret == -1) {
-                       _LOGD("Package UiApp Info DB Insert Failed\n");
-                       return -1;
-               }
-
                free((void *)app->mainapp);
                app->mainapp = strdup("true");
                mfx->mainapp_id = strdup(app->appid);
@@ -1223,6 +1215,23 @@ static char *__get_bool(char *value, bool is_true)
        return (is_true) ? "true" : "false";
 }
 
+static int __insert_pkg_updateinfo_in_db(manifest_x *mfx, uid_t uid)
+{
+       char query[MAX_QUERY_LEN] = {'\0'};
+       int ret;
+
+       if (mfx == NULL)
+               return -1;
+
+       sqlite3_snprintf(MAX_QUERY_LEN, query,
+                       "INSERT INTO package_update_info(" \
+                       "package, update_version) VALUES(%Q, %Q)",
+                       mfx->package, mfx->version);
+       ret = __exec_query(query);
+
+       return ret;
+}
+
 /* _PRODUCT_LAUNCHING_ENHANCED_
 *  app->indicatordisplay, app->portraitimg, app->landscapeimg, app->guestmode_appstatus
 */
@@ -1264,7 +1273,7 @@ static int __insert_application_info(manifest_x *mfx)
                        "app_launch_mode, app_ui_gadget, app_support_mode, app_support_disable, component_type, package, " \
                        "app_tep_name, app_zip_mount_file, app_background_category, app_package_type, app_root_path, " \
                        "app_api_version, app_effective_appid, app_splash_screen_display, app_package_system, app_removable, " \
-                       "app_package_installed_time, app_support_ambient) " \
+                       "app_package_installed_time, app_support_ambient, app_setup_appid) " \
                        "VALUES(" \
                        "%Q, %Q, %Q, LOWER(%Q), %Q, " \
                        "LOWER(%Q), LOWER(%Q), LOWER(%Q), LOWER(%Q), " \
@@ -1274,7 +1283,7 @@ static int __insert_application_info(manifest_x *mfx)
                        "COALESCE(%Q, 'caller'), LOWER(%Q), %Q, LOWER(%Q), %Q, %Q, " \
                        "%Q, %Q, %d, %Q, %Q, " \
                        "%Q, %Q, LOWER(%Q), LOWER(%Q), LOWER(%Q), " \
-                       "%Q, LOWER(%Q))", \
+                       "%Q, LOWER(%Q), %Q)", \
                        app->appid, app->component_type, app->exec, __get_bool(app->nodisplay, false), app->type,
                        __get_bool(app->onboot, false), __get_bool(app->multiple, false), __get_bool(app->autorestart, false), __get_bool(app->taskmanage, false),
                        app->hwacceleration, app->screenreader, app->mainapp, app->recentimage, app->launchcondition,
@@ -1283,7 +1292,8 @@ static int __insert_application_info(manifest_x *mfx)
                        __get_bool(mfx->preload, false), __get_bool(app->submode, false), app->submode_mainid, mfx->installed_storage, __get_bool(app->process_pool, false),
                        app->launch_mode, __get_bool(app->ui_gadget, false), mfx->support_mode, __get_bool(mfx->support_disable, false), app->component_type, mfx->package,
                        mfx->tep_name, mfx->zip_mount_file, background_value, type, mfx->root_path, mfx->api_version,
-                       effective_appid, __get_bool(app->splash_screen_display, false), __get_bool(mfx->system, false), __get_bool(mfx->removable, true), mfx->installed_time, __get_bool(app->support_ambient, false));
+                       effective_appid, __get_bool(app->splash_screen_display, false), __get_bool(mfx->system, false), __get_bool(mfx->removable, true),
+                       mfx->installed_time, __get_bool(app->support_ambient, false), app->setup_appid);
 
                ret = __exec_query(query);
                if (ret == -1) {
@@ -1450,12 +1460,13 @@ static int __insert_application_datacontrol_info(manifest_x *mfx)
                        if (dc == NULL)
                                continue;
                        sqlite3_snprintf(MAX_QUERY_LEN, query,
-                                       "INSERT INTO package_app_data_control(app_id, providerid, access, type) " \
-                                       "VALUES(%Q, %Q, %Q, %Q)",\
+                                       "INSERT INTO package_app_data_control(app_id, providerid, access, type, trusted) " \
+                                       "VALUES(%Q, %Q, %Q, %Q, %Q)",\
                                        app->appid,
                                        dc->providerid,
                                        dc->access,
-                                       dc->type);
+                                       dc->type,
+                                       __get_bool(dc->trusted, false));
 
                        ret = __exec_query(query);
                        if (ret == -1) {
@@ -1783,6 +1794,12 @@ static int __insert_manifest_info_in_db(manifest_x *mfx, uid_t uid)
                return -1;
        }
 
+       ret = __insert_pkg_updateinfo_in_db(mfx, uid);
+       if (ret == -1) {
+               _LOGE("Package Update Info DB Insert Failed\n");
+               return -1;
+       }
+
        /*Insert in the package_privilege_info DB*/
        for (tmp = mfx->privileges; tmp; tmp = tmp->next) {
                pv = (privilege_x *)tmp->data;
@@ -1988,6 +2005,16 @@ static int __delete_manifest_info_from_db(manifest_x *mfx, uid_t uid)
        }
        memset(query, '\0', MAX_QUERY_LEN);
 
+       /*Delete from Package Update Info DB*/
+       sqlite3_snprintf(MAX_QUERY_LEN, query,
+                "DELETE FROM package_update_info WHERE package=%Q", mfx->package);
+       ret = __exec_query(query);
+       if (ret == -1) {
+               _LOGD("Package Update Info DB Delete Failed\n");
+               return -1;
+       }
+       memset(query, '\0', MAX_QUERY_LEN);
+
        /*Delete from Package Localized Info*/
        sqlite3_snprintf(MAX_QUERY_LEN, query,
                 "DELETE FROM package_localized_info WHERE package=%Q", mfx->package);
@@ -2278,6 +2305,11 @@ API int pkgmgr_parser_initialize_db(uid_t uid)
                _LOGD("package app app privilege DB initialization failed\n");
                return ret;
        }
+       ret = __initialize_db(pkgmgr_parser_db, QUERY_CREATE_TABLE_PACKAGE_UPDATE_INFO);
+       if (ret == -1) {
+               _LOGD("package update info DB initialization failed\n");
+               return ret;
+       }
        ret = __initialize_db(pkgmgr_parser_db, QUERY_CREATE_TABLE_PACKAGE_APP_INFO);
        if (ret == -1) {
                _LOGD("package app info DB initialization failed\n");
@@ -2430,8 +2462,13 @@ static int __parserdb_change_perm(const char *db_file, uid_t uid)
        if (getuid() != OWNER_ROOT) /* At this time we should be root to apply this */
                return 0;
        snprintf(journal_file, sizeof(journal_file), "%s%s", db_file, "-journal");
-       if (uid == OWNER_ROOT)
-               uid = GLOBAL_USER;
+       if (uid == OWNER_ROOT || uid == GLOBAL_USER) {
+               ret = getpwnam_r(APPFW_USER, &userinfo, buf, sizeof(buf), &result);
+               if (ret != 0 || result == NULL)
+                       return -1;
+               uid = userinfo.pw_uid;
+       }
+
        ret = getpwuid_r(uid, &userinfo, pwuid_buf, sizeof(pwuid_buf), &result);
        if (ret != 0 || result == NULL) {
                _LOGE("FAIL: user %d doesn't exist", uid);
@@ -2852,6 +2889,168 @@ API int pkgmgr_parser_delete_manifest_info_from_db(manifest_x *mfx)
        return pkgmgr_parser_delete_manifest_info_from_usr_db(mfx, _getuid());
 }
 
+static int _convert_update_type(pkgmgrinfo_updateinfo_update_type type, char **convert_type)
+{
+       if (type == PMINFO_UPDATEINFO_NONE)
+               *convert_type = PMINFO_UPDATEINFO_TYPE_NONE;
+       else if (type == PMINFO_UPDATEINFO_FORCE)
+               *convert_type = PMINFO_UPDATEINFO_TYPE_FORCE;
+       else if (type == PMINFO_UPDATEINFO_OPTIONAL)
+               *convert_type = PMINFO_UPDATEINFO_TYPE_OPTIONAL;
+       else
+               return -1;
+       return 0;
+}
+
+API int pkgmgr_parser_register_pkg_update_info_in_usr_db(pkgmgrinfo_updateinfo_h handle, uid_t uid)
+{
+       int ret;
+       updateinfo_x *update_info;
+       updateinfo_x *prev_update_info;
+       pkgmgrinfo_updateinfo_h prev_update_handle;
+       pkgmgrinfo_pkginfo_h pkginfo;
+       pkgmgrinfo_version_compare_type compare_result;
+       bool is_global_pkg;
+       char query[MAX_QUERY_LEN] = {'\0'};
+       char *convert_type;
+
+       if (handle == NULL)
+               return PMINFO_R_EINVAL;
+
+       update_info = (updateinfo_x *)handle;
+       if (update_info->pkgid == NULL || update_info->version == NULL)
+               return PMINFO_R_EINVAL;
+       if (_convert_update_type(update_info->type, &convert_type) != 0)
+               return PMINFO_R_EINVAL;
+
+       ret = pkgmgrinfo_updateinfo_get_usr_updateinfo(update_info->pkgid,
+                       &prev_update_handle, uid);
+       if (ret != PMINFO_R_OK)
+               return PMINFO_R_ERROR;
+
+       prev_update_info = (updateinfo_x *)prev_update_handle;
+       ret = pkgmgrinfo_compare_package_version(update_info->version,
+                       prev_update_info->version, &compare_result);
+       if (ret != PMINFO_R_OK) {
+               pkgmgrinfo_updateinfo_destroy(prev_update_handle);
+               return PMINFO_R_ERROR;
+       }
+
+       if (compare_result == PMINFO_VERSION_SAME &&
+                       prev_update_info->type == PMINFO_UPDATEINFO_NONE) {
+               _LOGI("Given update info version[%s] of pkgid[%s] will be ignored",
+                               update_info->version, update_info->pkgid);
+               pkgmgrinfo_updateinfo_destroy(prev_update_handle);
+               return PMINFO_R_OK;
+       }
+       pkgmgrinfo_updateinfo_destroy(prev_update_handle);
+
+       ret = pkgmgrinfo_pkginfo_get_usr_pkginfo(update_info->pkgid, uid,
+                       &pkginfo);
+       if (ret != PMINFO_R_OK)
+               return PMINFO_R_ERROR;
+
+       ret = pkgmgrinfo_pkginfo_is_global(pkginfo, &is_global_pkg);
+       if (ret != PMINFO_R_OK) {
+               pkgmgrinfo_pkginfo_destroy_pkginfo(pkginfo);
+               return PMINFO_R_ERROR;
+       }
+       pkgmgrinfo_pkginfo_destroy_pkginfo(pkginfo);
+
+       ret = pkgmgr_parser_check_and_create_db(
+                       (is_global_pkg) ? GLOBAL_USER : uid);
+       if (ret != PMINFO_R_OK)
+               return PMINFO_R_ERROR;
+
+       sqlite3_snprintf(MAX_QUERY_LEN, query,
+                       "UPDATE package_update_info SET update_version=%Q, " \
+                       "update_type=%Q WHERE package=%Q",
+                       update_info->version,
+                       convert_type,
+                       update_info->pkgid);
+
+       ret = __exec_query(query);
+       pkgmgr_parser_close_db();
+
+       return ret;
+}
+
+API int pkgmgr_parser_register_pkg_update_info_in_db(pkgmgrinfo_updateinfo_h handle)
+{
+       return pkgmgr_parser_register_pkg_update_info_in_usr_db(handle, _getuid());
+}
+
+API int pkgmgr_parser_unregister_pkg_update_info_in_usr_db(const char *pkgid, uid_t uid)
+{
+       pkgmgrinfo_pkginfo_h pkginfo = NULL;
+       int ret;
+       bool is_global_pkg;
+       char query[MAX_QUERY_LEN] = {'\0'};
+
+       if (pkgid == NULL)
+               return PMINFO_R_EINVAL;
+
+       ret = pkgmgrinfo_pkginfo_get_usr_pkginfo(pkgid, uid, &pkginfo);
+       if (ret != PMINFO_R_OK)
+               return -1;
+
+       ret = pkgmgrinfo_pkginfo_is_global(pkginfo, &is_global_pkg);
+       if (ret != PMINFO_R_OK) {
+               pkgmgrinfo_pkginfo_destroy_pkginfo(pkginfo);
+               return PMINFO_R_ERROR;
+       }
+       pkgmgrinfo_pkginfo_destroy_pkginfo(pkginfo);
+       ret = pkgmgr_parser_check_and_create_db((is_global_pkg) ? GLOBAL_USER : uid);
+       if (ret != PMINFO_R_OK)
+               return ret;
+
+       sqlite3_snprintf(MAX_QUERY_LEN, query,
+                       "UPDATE package_update_info SET update_type='none' " \
+                       "WHERE package=%Q", pkgid);
+
+       ret = __exec_query(query);
+       pkgmgr_parser_close_db();
+
+       return ret;
+}
+
+API int pkgmgr_parser_unregister_pkg_update_info_in_db(const char *pkgid)
+{
+       return pkgmgr_parser_unregister_pkg_update_info_in_usr_db(pkgid, _getuid());
+}
+
+API int pkgmgr_parser_unregister_all_pkg_update_info_in_usr_db(uid_t uid)
+{
+       int ret;
+       char query[MAX_QUERY_LEN] = {'\0'};
+       char *error_message = NULL;
+
+       ret = pkgmgr_parser_check_and_create_db(uid);
+       if (ret != 0)
+               return PMINFO_R_ERROR;
+
+       sqlite3_snprintf(MAX_QUERY_LEN, query,
+                       "UPDATE package_update_info SET update_type='none'");
+       ret = sqlite3_exec(pkgmgr_parser_db, query, NULL, NULL, &error_message);
+       if (ret != SQLITE_OK) {
+               _LOGE("Don't execute query = %s error message = %s\n", query,
+                      error_message);
+               sqlite3_free(error_message);
+               pkgmgr_parser_close_db();
+               return PMINFO_R_ERROR;
+       }
+       sqlite3_free(error_message);
+       error_message = NULL;
+       pkgmgr_parser_close_db();
+
+       return PMINFO_R_OK;
+}
+
+API int pkgmgr_parser_unregister_all_pkg_update_info_in_db(void)
+{
+       return pkgmgr_parser_unregister_all_pkg_update_info_in_usr_db(_getuid());
+}
+
 API int pkgmgr_parser_update_global_app_disable_for_uid_info_in_db(const char *appid, uid_t uid, int is_disable)
 {
        int ret = -1;