Fix to work app info for uid properly

- Change uid to global user's to set appinfo for uid properly
- Change trigger to work on insert event only

Change-Id: Id713b52fa4797c0d0b3bd4e56fd80c8d4cf08192
Signed-off-by: Junghyun Yeon <jungh.yeon@samsung.com>

diff --git a/parser/src/pkgmgr_parser_db.c b/parser/src/pkgmgr_parser_db.c
index 68d972d..95f2472 100644 (file)
--- a/parser/src/pkgmgr_parser_db.c
+++ b/parser/src/pkgmgr_parser_db.c
@@ -1970,9 +1970,9 @@ API int pkgmgr_parser_update_global_app_disable_for_uid_info_in_db(
                return PM_PARSER_R_EINVAL;
        }
 
-       dbpath = __get_parser_db_path(uid);
+       dbpath = __get_parser_db_path(GLOBAL_USER);
 
-       ret = __open_db(uid, dbpath, &db, SQLITE_OPEN_READWRITE);
+       ret = __open_db(GLOBAL_USER, dbpath, &db, SQLITE_OPEN_READWRITE);
        if (ret != SQLITE_OK) {
                _LOGE("open db failed: %d", ret);
                return PM_PARSER_R_ERROR;
@@ -2169,9 +2169,9 @@ API int pkgmgr_parser_update_global_app_splash_screen_display_info_in_usr_db(
                return PM_PARSER_R_EINVAL;
        }
 
-       dbpath = __get_parser_db_path(uid);
+       dbpath = __get_parser_db_path(GLOBAL_USER);
 
-       ret = __open_db(uid, dbpath, &db, SQLITE_OPEN_READWRITE);
+       ret = __open_db(GLOBAL_USER, dbpath, &db, SQLITE_OPEN_READWRITE);
        if (ret != SQLITE_OK) {
                _LOGE("open db failed: %d", ret);
                return PM_PARSER_R_ERROR;

diff --git a/parser/src/pkgmgr_parser_db_queries.h b/parser/src/pkgmgr_parser_db_queries.h
index 53666f6..8f2b906 100644 (file)
--- a/parser/src/pkgmgr_parser_db_queries.h
+++ b/parser/src/pkgmgr_parser_db_queries.h
@@ -235,13 +235,13 @@
 
 #define QUERY_CREATE_TRIGGER_UPDATE_PACKAGE_APP_INFO_FOR_UID \
        "CREATE TRIGGER IF NOT EXISTS update_package_appinfo_for_uid\n"\
-       "AFTER UPDATE ON package_app_info_for_uid\n" \
+       "AFTER INSERT ON package_app_info_for_uid\n" \
        "BEGIN\n" \
        "  DELETE FROM package_app_info_for_uid\n"\
         "    WHERE is_splash_screen_enabled=\n" \
        "    (SELECT package_app_info.app_splash_screen_display FROM\n" \
        "       package_app_info, package_app_info_for_uid\n" \
-        "     WHERE package_app_info.app_id=OLD.app_id) AND is_disabled='false';\n" \
+        "     WHERE package_app_info.app_id=NEW.app_id) AND is_disabled='false';\n" \
        "END;"
 
 #define QUERY_CREATE_TABLE_PACKAGE_APP_SPLASH_SCREEN \