Fix _get_filtered_query
[platform/core/appfw/pkgmgr-info.git] / src / pkgmgrinfo_pkginfo.c
index be7df99..09e9457 100644 (file)
@@ -19,7 +19,7 @@
  * limitations under the License.
  *
  */
+
 #define _GNU_SOURCE
 #include <stdio.h>
 #include <stdlib.h>
 #include "pkgmgr_parser_db.h"
 #include "pkgmgr_parser_internal.h"
 
-static int _pkginfo_get_pkginfo(const char *pkgid, uid_t uid,
-               pkgmgr_pkginfo_x **pkginfo);
-static char *_get_filtered_query(const char *query_raw,
-               pkgmgrinfo_filter_x *filter);
+static bool _get_bool_value(const char *str)
+{
+       if (str == NULL)
+               return false;
+       else if (!strcasecmp(str, "true"))
+               return true;
+       else
+               return false;
+}
 
 static gint __compare_func(gconstpointer data1, gconstpointer data2)
 {
@@ -131,233 +136,58 @@ long long _pkgmgr_calculate_dir_size(char *dirname)
        int q = 0; /*quotient*/
        int r = 0; /*remainder*/
        DIR *dp = NULL;
-       struct dirent *ep = NULL;
+       struct dirent ep, *result;
        struct stat fileinfo;
        char abs_filename[FILENAME_MAX] = { 0, };
        retvm_if(dirname == NULL, PMINFO_R_ERROR, "dirname is NULL");
 
        dp = opendir(dirname);
-       if (dp != NULL) {
-               while ((ep = readdir(dp)) != NULL) {
-                       if (!strcmp(ep->d_name, ".") ||
-                               !strcmp(ep->d_name, "..")) {
-                               continue;
-                       }
-                       snprintf(abs_filename, FILENAME_MAX, "%s/%s", dirname,
-                                ep->d_name);
-                       if (lstat(abs_filename, &fileinfo) < 0)
-                               perror(abs_filename);
-                       else {
-                               if (S_ISDIR(fileinfo.st_mode)) {
-                                       total += fileinfo.st_size;
-                                       if (strcmp(ep->d_name, ".")
-                                           && strcmp(ep->d_name, "..")) {
-                                               ret = _pkgmgr_calculate_dir_size
-                                                   (abs_filename);
-                                               total = total + ret;
-                                       }
-                               } else if (S_ISLNK(fileinfo.st_mode)) {
-                                       continue;
-                               } else {
-                                       /*It is a file. Calculate the actual
-                                       size occupied (in terms of 4096 blocks)*/
-                               q = (fileinfo.st_size / BLOCK_SIZE);
-                               r = (fileinfo.st_size % BLOCK_SIZE);
-                               if (r) {
-                                       q = q + 1;
-                               }
-                               total += q * BLOCK_SIZE;
-                               }
-                       }
-               }
-               (void)closedir(dp);
-       } else {
+       if (dp == NULL) {
                _LOGE("Couldn't open the directory\n");
                return -1;
        }
-       return total;
-
-}
-
-static gint __list_strcmp(gconstpointer a, gconstpointer b)
-{
-       return strcmp((char *)a, (char *)b);
-}
-
-static int _pkginfo_get_list(sqlite3 *db, const char *locale,
-               pkgmgrinfo_filter_x *filter, GList **list)
-{
-       static const char query_raw[] =
-               "SELECT DISTINCT package_info.package FROM package_info"
-               " LEFT OUTER JOIN package_localized_info"
-               "  ON package_info.package=package_localized_info.package"
-               "  AND package_localized_info.package_locale=%Q "
-               " LEFT OUTER JOIN package_privilege_info"
-               "  ON package_info.package=package_privilege_info.package";
-       int ret;
-       char *query;
-       char *query_localized;
-       sqlite3_stmt *stmt;
-       char *pkgid = NULL;
-
-       query = _get_filtered_query(query_raw, filter);
-       if (query == NULL)
-               return -1;
-       query_localized = sqlite3_mprintf(query, locale);
-       free(query);
-       if (query_localized == NULL)
-               return -1;
-
-       ret = sqlite3_prepare_v2(db, query_localized,
-                       strlen(query_localized), &stmt, NULL);
-       sqlite3_free(query_localized);
-       if (ret != SQLITE_OK) {
-               LOGE("prepare failed: %s", sqlite3_errmsg(db));
-               return -1;
-       }
-
-       while (sqlite3_step(stmt) == SQLITE_ROW) {
-               _save_column_str(stmt, 0, (const char **)&pkgid);
-               if (pkgid != NULL)
-                       *list = g_list_insert_sorted(*list, pkgid,
-                                       __list_strcmp);
-       }
-
-       sqlite3_finalize(stmt);
-
-       return 0;
-}
-
-static int _pkginfo_get_filtered_list(pkgmgrinfo_filter_x *filter, uid_t uid,
-               GList **list)
-{
-       int ret;
-       sqlite3 *db;
-       const char *dbpath;
-       char *locale;
-       GList *tmp;
-
-       locale = _get_system_locale();
-       if (locale == NULL)
-               return PMINFO_R_ERROR;
-
-       dbpath = getUserPkgParserDBPathUID(uid);
-       if (dbpath == NULL) {
-               free(locale);
-               return PMINFO_R_ERROR;
-       }
-
-       ret = sqlite3_open_v2(dbpath, &db, SQLITE_OPEN_READONLY, NULL);
-       if (ret != SQLITE_OK) {
-               _LOGE("failed to open db: %d", ret);
-               free(locale);
-               return PMINFO_R_ERROR;
-       }
-
-       if (_pkginfo_get_list(db, locale, filter, list)) {
-               free(locale);
-               sqlite3_close_v2(db);
-               return PMINFO_R_ERROR;
-       }
-       sqlite3_close_v2(db);
-
-       if (uid == GLOBAL_USER) {
-               free(locale);
-               return PMINFO_R_OK;
-       }
-
-       /* search again from global */
-       dbpath = getUserPkgParserDBPathUID(GLOBAL_USER);
-       if (dbpath == NULL) {
-               free(locale);
-               return PMINFO_R_ERROR;
-       }
 
-       ret = sqlite3_open_v2(dbpath, &db, SQLITE_OPEN_READONLY, NULL);
-       if (ret != SQLITE_OK) {
-               _LOGE("failed to open db: %d", ret);
-               free(locale);
-               return PMINFO_R_ERROR;
-       }
-
-       if (_pkginfo_get_list(db, locale, filter, list)) {
-               free(locale);
-               sqlite3_close_v2(db);
-               return PMINFO_R_ERROR;
-       }
-       sqlite3_close_v2(db);
-
-       /* remove duplicate element:
-        * since the list is sorted, we can remove duplicates in linear time
-        */
-       for (tmp = *list; tmp; tmp = tmp->next) {
-               if (tmp->prev == NULL || tmp->data == NULL)
+       for (ret = readdir_r(dp, &ep, &result);
+                       ret == 0 && result != NULL;
+                       ret = readdir_r(dp, &ep, &result)) {
+               if (!strcmp(ep.d_name, ".") ||
+                       !strcmp(ep.d_name, "..")) {
                        continue;
-               if (strcmp((const char *)tmp->prev->data,
-                                       (const char *)tmp->data) == 0)
-                       *list = g_list_delete_link(*list, tmp);
-       }
-
-       return PMINFO_R_OK;
-}
-
-
-static int _pkginfo_get_filtered_foreach_pkginfo(pkgmgrinfo_filter_x *filter,
-               pkgmgrinfo_pkg_list_cb pkg_list_cb, void *user_data, uid_t uid)
-{
-       int ret;
-       pkgmgr_pkginfo_x *info;
-       GList *list = NULL;
-       GList *tmp;
-       char *pkgid;
-       int stop = 0;
-
-       ret = _pkginfo_get_filtered_list(filter, uid, &list);
-       if (ret != PMINFO_R_OK)
-               return PMINFO_R_ERROR;
-
-       for (tmp = list; tmp; tmp = tmp->next) {
-               pkgid = (char *)tmp->data;
-               if (stop == 0) {
-                       ret = _pkginfo_get_pkginfo(pkgid, uid, &info);
-                       if (ret == PMINFO_R_ENOENT && uid != GLOBAL_USER)
-                               ret = _pkginfo_get_pkginfo(pkgid, GLOBAL_USER,
-                                               &info);
-                       if (ret != PMINFO_R_OK) {
-                               free(pkgid);
+               }
+               snprintf(abs_filename, FILENAME_MAX, "%s/%s", dirname,
+                        ep.d_name);
+               if (lstat(abs_filename, &fileinfo) < 0)
+                       perror(abs_filename);
+               else {
+                       if (S_ISDIR(fileinfo.st_mode)) {
+                               total += fileinfo.st_size;
+                               if (strcmp(ep.d_name, ".")
+                                   && strcmp(ep.d_name, "..")) {
+                                       ret = _pkgmgr_calculate_dir_size
+                                           (abs_filename);
+                                       total = total + ret;
+                               }
+                       } else if (S_ISLNK(fileinfo.st_mode)) {
                                continue;
+                       } else {
+                               /*It is a file. Calculate the actual
+                               size occupied (in terms of 4096 blocks)*/
+                       q = (fileinfo.st_size / BLOCK_SIZE);
+                       r = (fileinfo.st_size % BLOCK_SIZE);
+                       if (r) {
+                               q = q + 1;
+                       }
+                       total += q * BLOCK_SIZE;
                        }
-                       if (pkg_list_cb(info, user_data) < 0)
-                               stop = 1;
-                       pkgmgrinfo_pkginfo_destroy_pkginfo(info);
                }
-               free(pkgid);
-       }
-
-       g_list_free(list);
-
-       return PMINFO_R_OK;
-}
-
-API int pkgmgrinfo_pkginfo_get_usr_list(pkgmgrinfo_pkg_list_cb pkg_list_cb,
-               void *user_data, uid_t uid)
-{
-       if (pkg_list_cb == NULL) {
-               LOGE("invalid parameter");
-               return PMINFO_R_EINVAL;
        }
+       (void)closedir(dp);
+       return total;
 
-       return _pkginfo_get_filtered_foreach_pkginfo(NULL, pkg_list_cb,
-                       user_data, uid);
-}
-
-API int pkgmgrinfo_pkginfo_get_list(pkgmgrinfo_pkg_list_cb pkg_list_cb, void *user_data)
-{
-       return pkgmgrinfo_pkginfo_get_usr_list(pkg_list_cb, user_data, GLOBAL_USER);
 }
 
 static int _pkginfo_get_author(sqlite3 *db, const char *pkgid,
-               author_x **author)
+               GList **author)
 {
        static const char query_raw[] =
                "SELECT author_name, author_email, author_href "
@@ -400,7 +230,8 @@ static int _pkginfo_get_author(sqlite3 *db, const char *pkgid,
        _save_column_str(stmt, idx++, &info->email);
        _save_column_str(stmt, idx++, &info->href);
 
-       *author = info;
+       /* TODO: revised */
+       *author = g_list_append(*author, info);
 
        sqlite3_finalize(stmt);
 
@@ -408,7 +239,7 @@ static int _pkginfo_get_author(sqlite3 *db, const char *pkgid,
 }
 
 static int _pkginfo_get_label(sqlite3 *db, const char *pkgid,
-               const char *locale, label_x **label)
+               const char *locale, GList **label)
 {
        static const char query_raw[] =
                "SELECT package_label, package_locale "
@@ -439,21 +270,12 @@ static int _pkginfo_get_label(sqlite3 *db, const char *pkgid,
                if (info == NULL) {
                        LOGE("out of memory");
                        sqlite3_finalize(stmt);
-                       if (*label) {
-                               LISTHEAD(*label, info);
-                               *label = info;
-                       }
                        return PMINFO_R_ERROR;
                }
                idx = 0;
                _save_column_str(stmt, idx++, &info->text);
                _save_column_str(stmt, idx++, &info->lang);
-               LISTADD(*label, info);
-       }
-
-       if (*label) {
-               LISTHEAD(*label, info);
-               *label = info;
+               *label = g_list_append(*label, info);
        }
 
        sqlite3_finalize(stmt);
@@ -462,7 +284,7 @@ static int _pkginfo_get_label(sqlite3 *db, const char *pkgid,
 }
 
 static int _pkginfo_get_icon(sqlite3 *db, const char *pkgid, const char *locale,
-               icon_x **icon)
+               GList **icon)
 {
        static const char query_raw[] =
                "SELECT package_icon, package_locale "
@@ -493,21 +315,12 @@ static int _pkginfo_get_icon(sqlite3 *db, const char *pkgid, const char *locale,
                if (info == NULL) {
                        LOGE("out of memory");
                        sqlite3_finalize(stmt);
-                       if (*icon) {
-                               LISTHEAD(*icon, info);
-                               *icon = info;
-                       }
                        return PMINFO_R_ERROR;
                }
                idx = 0;
                _save_column_str(stmt, idx++, &info->text);
                _save_column_str(stmt, idx++, &info->lang);
-               LISTADD(*icon, info);
-       }
-
-       if (*icon) {
-               LISTHEAD(*icon, info);
-               *icon = info;
+               *icon = g_list_append(*icon, info);
        }
 
        sqlite3_finalize(stmt);
@@ -516,7 +329,7 @@ static int _pkginfo_get_icon(sqlite3 *db, const char *pkgid, const char *locale,
 }
 
 static int _pkginfo_get_description(sqlite3 *db, const char *pkgid,
-               const char *locale, description_x **description)
+               const char *locale, GList **description)
 {
        static const char query_raw[] =
                "SELECT package_description, package_locale "
@@ -547,21 +360,12 @@ static int _pkginfo_get_description(sqlite3 *db, const char *pkgid,
                if (info == NULL) {
                        LOGE("out of memory");
                        sqlite3_finalize(stmt);
-                       if (*description) {
-                               LISTHEAD(*description, info);
-                               *description = info;
-                       }
                        return PMINFO_R_ERROR;
                }
                idx = 0;
                _save_column_str(stmt, idx++, &info->text);
                _save_column_str(stmt, idx++, &info->lang);
-               LISTADD(*description, info);
-       }
-
-       if (*description) {
-               LISTHEAD(*description, info);
-               *description = info;
+               *description = g_list_append(*description, info);
        }
 
        sqlite3_finalize(stmt);
@@ -570,28 +374,18 @@ static int _pkginfo_get_description(sqlite3 *db, const char *pkgid,
 }
 
 static int _pkginfo_get_privilege(sqlite3 *db, const char *pkgid,
-               privileges_x **privileges)
+               GList **privileges)
 {
        static const char query_raw[] =
                "SELECT privilege FROM package_privilege_info WHERE package=%Q";
        int ret;
        char *query;
        sqlite3_stmt *stmt;
-       privileges_x *p;
-       privilege_x *info;
-
-       /* privilege list should stored in privileges_x... */
-       p = calloc(1, sizeof(privileges_x));
-       if (p == NULL) {
-               LOGE("out of memory");
-               return PMINFO_R_ERROR;
-       }
-       *privileges = p;
+       char *privilege;
 
        query = sqlite3_mprintf(query_raw, pkgid);
        if (query == NULL) {
                LOGE("out of memory");
-               free(p);
                return PMINFO_R_ERROR;
        }
 
@@ -600,28 +394,15 @@ static int _pkginfo_get_privilege(sqlite3 *db, const char *pkgid,
        sqlite3_free(query);
        if (ret != SQLITE_OK) {
                LOGE("prepare failed: %s", sqlite3_errmsg(db));
-               free(p);
                return PMINFO_R_ERROR;
        }
 
        while (sqlite3_step(stmt) == SQLITE_ROW) {
-               info = calloc(1, sizeof(privilege_x));
-               if (info == NULL) {
-                       LOGE("out of memory");
-                       sqlite3_finalize(stmt);
-                       if (p->privilege) {
-                               LISTHEAD(p->privilege, info);
-                               p->privilege = info;
-                       }
-                       return PMINFO_R_ERROR;
-               }
-               _save_column_str(stmt, 0, &info->text);
-               LISTADD(p->privilege, info);
-       }
-
-       if (p->privilege) {
-               LISTHEAD(p->privilege, info);
-               p->privilege = info;
+               privilege = NULL;
+               _save_column_str(stmt, 0, &privilege);
+               if (privilege)
+                       *privileges = g_list_append(*privileges,
+                                       (gpointer)privilege);
        }
 
        sqlite3_finalize(stmt);
@@ -629,221 +410,445 @@ static int _pkginfo_get_privilege(sqlite3 *db, const char *pkgid,
        return PMINFO_R_OK;
 }
 
-static char *_get_filtered_query(const char *query_raw,
-               pkgmgrinfo_filter_x *filter)
+static const char join_localized_info[] =
+       " LEFT OUTER JOIN package_localized_info"
+       "  ON pi.package=package_localized_info.package"
+       "  AND package_localized_info.package_locale=?";
+static const char join_privilege_info[] =
+       " LEFT OUTER JOIN package_privilege_info"
+       "  ON pi.package=package_privilege_info.package";
+
+static int _get_filtered_query(pkgmgrinfo_filter_x *filter,
+               const char *locale, char **query, GList **bind_params)
 {
-       char buf[MAX_QUERY_LEN] = { 0, };
-       char *condition;
-       size_t len;
-       GSList *list;
-       GSList *head = NULL;
+       int joined = 0;
+       char buf[MAX_QUERY_LEN] = { '\0' };
+       char buf2[MAX_QUERY_LEN] = { '\0' };
+       char *condition = NULL;
+       size_t len = 0;
+       GSList *list = NULL;
 
-       if (filter)
-               head = filter->list;
+       if (filter == NULL)
+               return PMINFO_R_OK;
 
-       strncat(buf, query_raw, MAX_QUERY_LEN - 1);
-       len = strlen(buf);
-       for (list = head; list; list = list->next) {
-               /* TODO: revise condition getter function */
-               __get_filter_condition(list->data, &condition);
+       len += strlen(" WHERE 1=1 ");
+       strncat(buf, " WHERE 1=1 ", MAX_QUERY_LEN - len - 1);
+       for (list = filter->list; list; list = list->next) {
+               joined |= __get_filter_condition(list->data, &condition,
+                               bind_params);
                if (condition == NULL)
                        continue;
-               if (buf[strlen(query_raw)] == '\0') {
-                       len += strlen(" WHERE ");
-                       strncat(buf, " WHERE ", MAX_QUERY_LEN - len - 1);
-               } else {
-                       len += strlen(" AND ");
-                       strncat(buf, " AND ", MAX_QUERY_LEN -len - 1);
-               }
+
+               len += strlen(" AND ");
+               strncat(buf, " AND ", MAX_QUERY_LEN - len - 1);
+
                len += strlen(condition);
                strncat(buf, condition, sizeof(buf) - len - 1);
                free(condition);
                condition = NULL;
        }
 
-       return strdup(buf);
+       if (joined & E_PMINFO_PKGINFO_JOIN_LOCALIZED_INFO) {
+               strncat(buf2, join_localized_info, MAX_QUERY_LEN - len - 1);
+               len += strlen(join_localized_info);
+               *bind_params = g_list_append(*bind_params, strdup(locale));
+       }
+       if (joined & E_PMINFO_PKGINFO_JOIN_PRIVILEGE_INFO) {
+               strncat(buf2, join_privilege_info, MAX_QUERY_LEN - len - 1);
+               len += strlen(join_privilege_info);
+       }
+       strncat(buf2, buf, MAX_QUERY_LEN - len - 1);
+
+       *query = strdup(buf2);
+       if (*query == NULL)
+               return PMINFO_R_ERROR;
+
+       return PMINFO_R_OK;
 }
 
-static int _pkginfo_get_package(sqlite3 *db, const char *pkgid,
-               const char *locale, package_x **package)
+static void __free_packages(gpointer data)
 {
-       static const char query_raw[] =
-               "SELECT package, package_version, "
-               "install_location, package_removable, package_preload, "
-               "package_readonly, package_update, package_appsetting, "
-               "package_system, package_type, package_size, installed_time, "
-               "installed_storage, storeclient_id, mainapp_id, package_url, "
-               "root_path, csc_path, package_nodisplay, package_api_version, "
-               "package_support_disable "
-               "FROM package_info WHERE package=%Q";
+       pkgmgrinfo_basic_free_package((package_x *)data);
+}
+
+static int __bind_params(sqlite3_stmt *stmt, GList *params)
+{
+       GList *tmp_list = NULL;
+       int idx = 0;
        int ret;
-       char *query;
+
+       if (stmt == NULL || params == NULL)
+               return PMINFO_R_EINVAL;
+
+       tmp_list = params;
+       while (tmp_list) {
+               ret = sqlite3_bind_text(stmt, ++idx, (char *)tmp_list->data, -1, SQLITE_STATIC);
+               if (ret != SQLITE_OK)
+                       return PMINFO_R_ERROR;
+               tmp_list = tmp_list->next;
+       }
+
+       return PMINFO_R_OK;
+}
+
+static int _pkginfo_get_packages(uid_t uid, const char *locale,
+               pkgmgrinfo_filter_x *filter, int flag, GHashTable *packages)
+{
+       static const char query_raw[] =
+               "SELECT DISTINCT pi.package, pi.package_version, "
+               "pi.install_location, pi.package_removable, "
+               "pi.package_preload, pi.package_readonly, pi.package_update, "
+               "pi.package_appsetting, pi.package_system, pi.package_type, "
+               "pi.package_size, pi.installed_time, pi.installed_storage, "
+               "pi.storeclient_id, pi.mainapp_id, pi.package_url, "
+               "pi.root_path, pi.csc_path, pi.package_nodisplay, "
+               "pi.package_api_version, pi.package_support_disable, "
+               "pi.package_tep_name, pi.package_zip_mount_file "
+               "FROM package_info as pi ";
+       int ret = PMINFO_R_ERROR;
+       int idx = 0;
+       const char *dbpath;
+       char *constraints = NULL;
+       char query[MAX_QUERY_LEN] = { '\0' };
+       package_x *info = NULL;
+       GList *bind_params = NULL;
+       sqlite3 *db;
        sqlite3_stmt *stmt;
-       int idx;
-       package_x *info;
+       pkgmgrinfo_filter_x *tmp_filter = NULL;
 
-       query = sqlite3_mprintf(query_raw, pkgid);
-       if (query == NULL) {
-               LOGE("out of memory");
+       dbpath = getUserPkgParserDBPathUID(uid);
+       if (dbpath == NULL)
                return PMINFO_R_ERROR;
-       }
 
-       ret = sqlite3_prepare_v2(db, query, strlen(query),
-                       &stmt, NULL);
-       sqlite3_free(query);
+       ret = sqlite3_open_v2(dbpath, &db, SQLITE_OPEN_READONLY, NULL);
        if (ret != SQLITE_OK) {
-               LOGE("prepare failed: %s", sqlite3_errmsg(db));
+               _LOGD("failed to open db: %d", ret);
                return PMINFO_R_ERROR;
        }
 
-       ret = sqlite3_step(stmt);
-       if (ret == SQLITE_DONE) {
-               sqlite3_finalize(stmt);
-               return PMINFO_R_ENOENT;
-       } else if (ret != SQLITE_ROW) {
-               LOGE("step failed: %s", sqlite3_errmsg(db));
-               sqlite3_finalize(stmt);
-               return PMINFO_R_ERROR;
+       if (filter != NULL) {
+               tmp_filter = filter;
+       } else {
+               ret = pkgmgrinfo_pkginfo_filter_create((void *)&tmp_filter);
+               if (ret != PMINFO_R_OK) {
+                       _LOGE("Failed to create filter");
+                       return PMINFO_R_ERROR;
+               }
        }
 
-       info = calloc(1, sizeof(package_x));
-       if (info == NULL) {
-               LOGE("out of memory");
-               sqlite3_finalize(stmt);
-               return PMINFO_R_ERROR;
+       /* add package_disable='false' clause by default */
+       pkgmgrinfo_pkginfo_filter_add_bool(tmp_filter, PMINFO_PKGINFO_PROP_PACKAGE_DISABLE, false);
+
+       ret = _get_filtered_query(tmp_filter, locale, &constraints, &bind_params);
+       if (ret != PMINFO_R_OK) {
+               LOGE("Failed to get WHERE clause");
+               goto catch;
        }
-       idx = 0;
-       _save_column_str(stmt, idx++, &info->package);
-       _save_column_str(stmt, idx++, &info->version);
-       _save_column_str(stmt, idx++, &info->installlocation);
-       _save_column_str(stmt, idx++, &info->removable);
-       _save_column_str(stmt, idx++, &info->preload);
-       _save_column_str(stmt, idx++, &info->readonly);
-       _save_column_str(stmt, idx++, &info->update);
-       _save_column_str(stmt, idx++, &info->appsetting);
-       _save_column_str(stmt, idx++, &info->system);
-       _save_column_str(stmt, idx++, &info->type);
-       _save_column_str(stmt, idx++, &info->package_size);
-       _save_column_str(stmt, idx++, &info->installed_time);
-       _save_column_str(stmt, idx++, &info->installed_storage);
-       _save_column_str(stmt, idx++, &info->storeclient_id);
-       _save_column_str(stmt, idx++, &info->mainapp_id);
-       _save_column_str(stmt, idx++, &info->package_url);
-       _save_column_str(stmt, idx++, &info->root_path);
-       _save_column_str(stmt, idx++, &info->csc_path);
-       _save_column_str(stmt, idx++, &info->nodisplay_setting);
-       _save_column_str(stmt, idx++, &info->api_version);
-       _save_column_str(stmt, idx++, &info->support_disable);
-
-       if (_pkginfo_get_author(db, info->package, &info->author)) {
-               pkgmgrinfo_basic_free_package(info);
-               sqlite3_finalize(stmt);
-               return PMINFO_R_ERROR;
+
+       if (constraints)
+               snprintf(query, MAX_QUERY_LEN - 1, "%s%s", query_raw, constraints);
+       else
+               snprintf(query, MAX_QUERY_LEN - 1, "%s", query_raw);
+
+       ret = sqlite3_prepare_v2(db, query, strlen(query), &stmt, NULL);
+       if (ret != SQLITE_OK) {
+               LOGE("prepare failed: %s", sqlite3_errmsg(db));
+               ret = PMINFO_R_ERROR;
+               goto catch;
        }
 
-       if (_pkginfo_get_label(db, info->package, locale, &info->label)) {
-               pkgmgrinfo_basic_free_package(info);
-               sqlite3_finalize(stmt);
-               return PMINFO_R_ERROR;
+       ret = __bind_params(stmt, bind_params);
+       if (ret != SQLITE_OK) {
+               LOGE("Failed to bind parameters");
+               goto catch;
        }
 
-       if (_pkginfo_get_icon(db, info->package, locale, &info->icon)) {
-               pkgmgrinfo_basic_free_package(info);
-               sqlite3_finalize(stmt);
-               return PMINFO_R_ERROR;
+       while (sqlite3_step(stmt) == SQLITE_ROW) {
+               info = calloc(1, sizeof(package_x));
+               if (info == NULL) {
+                       LOGE("out of memory");
+                       sqlite3_finalize(stmt);
+                       sqlite3_close_v2(db);
+                       return PMINFO_R_ERROR;
+               }
+               idx = 0;
+               _save_column_str(stmt, idx++, &info->package);
+               if (g_hash_table_contains(packages,
+                                       (gconstpointer)info->package)) {
+                       free(info->package);
+                       free(info);
+                       continue;
+               }
+               _save_column_str(stmt, idx++, &info->version);
+               _save_column_str(stmt, idx++, &info->installlocation);
+               _save_column_str(stmt, idx++, &info->removable);
+               _save_column_str(stmt, idx++, &info->preload);
+               _save_column_str(stmt, idx++, &info->readonly);
+               _save_column_str(stmt, idx++, &info->update);
+               _save_column_str(stmt, idx++, &info->appsetting);
+               _save_column_str(stmt, idx++, &info->system);
+               _save_column_str(stmt, idx++, &info->type);
+               _save_column_str(stmt, idx++, &info->package_size);
+               _save_column_str(stmt, idx++, &info->installed_time);
+               _save_column_str(stmt, idx++, &info->installed_storage);
+               _save_column_str(stmt, idx++, &info->storeclient_id);
+               _save_column_str(stmt, idx++, &info->mainapp_id);
+               _save_column_str(stmt, idx++, &info->package_url);
+               _save_column_str(stmt, idx++, &info->root_path);
+               _save_column_str(stmt, idx++, &info->csc_path);
+               _save_column_str(stmt, idx++, &info->nodisplay_setting);
+               _save_column_str(stmt, idx++, &info->api_version);
+               _save_column_str(stmt, idx++, &info->support_disable);
+               _save_column_str(stmt, idx++, &info->tep_name);
+               _save_column_str(stmt, idx++, &info->zip_mount_file);
+               info->for_all_users =
+                       strdup((uid != GLOBAL_USER) ? "false" : "true");
+
+               if (flag & PMINFO_PKGINFO_GET_AUTHOR) {
+                       if (_pkginfo_get_author(db, info->package,
+                                               &info->author)) {
+                               pkgmgrinfo_basic_free_package(info);
+                               sqlite3_finalize(stmt);
+                               sqlite3_close_v2(db);
+                               return PMINFO_R_ERROR;
+                       }
+               }
+
+               if (flag & PMINFO_PKGINFO_GET_LABEL) {
+                       if (_pkginfo_get_label(db, info->package, locale,
+                                               &info->label)) {
+                               pkgmgrinfo_basic_free_package(info);
+                               sqlite3_finalize(stmt);
+                               sqlite3_close_v2(db);
+                               return PMINFO_R_ERROR;
+                       }
+               }
+
+               if (flag & PMINFO_PKGINFO_GET_ICON) {
+                       if (_pkginfo_get_icon(db, info->package, locale,
+                                               &info->icon)) {
+                               pkgmgrinfo_basic_free_package(info);
+                               sqlite3_finalize(stmt);
+                               sqlite3_close_v2(db);
+                               return PMINFO_R_ERROR;
+                       }
+               }
+
+               if (flag & PMINFO_PKGINFO_GET_DESCRIPTION) {
+                       if (_pkginfo_get_description(db, info->package, locale,
+                                               &info->description)) {
+                               pkgmgrinfo_basic_free_package(info);
+                               sqlite3_finalize(stmt);
+                               sqlite3_close_v2(db);
+                               return PMINFO_R_ERROR;
+                       }
+               }
+
+               if (flag & PMINFO_PKGINFO_GET_PRIVILEGE) {
+                       if (_pkginfo_get_privilege(db, info->package,
+                                               &info->privileges)) {
+                               pkgmgrinfo_basic_free_package(info);
+                               sqlite3_finalize(stmt);
+                               sqlite3_close_v2(db);
+                               return PMINFO_R_ERROR;
+                       }
+               }
+
+               g_hash_table_insert(packages, (gpointer)info->package,
+                               (gpointer)info);
        }
 
-       if (_pkginfo_get_description(db, info->package, locale,
-                               &info->description)) {
+       ret = PMINFO_R_OK;
+
+catch:
+       if (constraints)
+               free(constraints);
+
+       if (ret != PMINFO_R_OK && info != NULL)
                pkgmgrinfo_basic_free_package(info);
-               sqlite3_finalize(stmt);
+
+       if (filter == NULL)
+               pkgmgrinfo_pkginfo_filter_destroy(tmp_filter);
+
+       g_list_free_full(bind_params, free);
+       sqlite3_close_v2(db);
+       sqlite3_finalize(stmt);
+
+       return ret;
+}
+
+static int _pkginfo_get_filtered_foreach_pkginfo(uid_t uid,
+               pkgmgrinfo_filter_x *filter, int flag,
+               pkgmgrinfo_pkg_list_cb pkg_list_cb, void *user_data)
+{
+       int ret;
+       char *locale;
+       package_x *pkg;
+       pkgmgr_pkginfo_x info;
+       GHashTable *list;
+       GHashTableIter iter;
+       gpointer value;
+
+       locale = _get_system_locale();
+       if (locale == NULL)
+               return PMINFO_R_ERROR;
+
+       list = g_hash_table_new_full(g_str_hash, g_str_equal, NULL,
+                       __free_packages);
+       if (list == NULL) {
+               free(locale);
                return PMINFO_R_ERROR;
        }
 
-       if (_pkginfo_get_privilege(db, info->package, &info->privileges)) {
-               pkgmgrinfo_basic_free_package(info);
-               sqlite3_finalize(stmt);
+       ret = _pkginfo_get_packages(uid, locale, filter, flag, list);
+       if (ret == PMINFO_R_OK && uid != GLOBAL_USER)
+               ret = _pkginfo_get_packages(GLOBAL_USER, locale, filter,
+                               flag, list);
+
+       if (ret != PMINFO_R_OK) {
+               g_hash_table_destroy(list);
+               free(locale);
                return PMINFO_R_ERROR;
        }
 
-       *package = info;
-       sqlite3_finalize(stmt);
+       g_hash_table_iter_init(&iter, list);
+       while (g_hash_table_iter_next(&iter, NULL, &value)) {
+               pkg = (package_x *)value;
+               info.uid = uid;
+               info.pkg_info = pkg;
+               info.locale = locale;
+               if (pkg_list_cb(&info, user_data) < 0)
+                       break;
+       }
+
+       g_hash_table_destroy(list);
+       free(locale);
 
        return PMINFO_R_OK;
 }
 
-static int _pkginfo_get_pkginfo(const char *pkgid, uid_t uid,
-               pkgmgr_pkginfo_x **pkginfo)
+API int pkgmgrinfo_pkginfo_get_usr_pkginfo(const char *pkgid, uid_t uid,
+               pkgmgrinfo_pkginfo_h *handle)
 {
        int ret;
-       sqlite3 *db;
-       const char *dbpath;
        char *locale;
+       GHashTable *list;
+       pkgmgrinfo_pkginfo_filter_h filter;
        pkgmgr_pkginfo_x *info;
 
-       dbpath = getUserPkgParserDBPathUID(uid);
-       if (dbpath == NULL)
-               return PMINFO_R_ERROR;
+       if (pkgid == NULL || handle == NULL) {
+               LOGE("invalid parameter");
+               return PMINFO_R_EINVAL;
+       }
 
        locale = _get_system_locale();
        if (locale == NULL)
                return PMINFO_R_ERROR;
 
-       ret = sqlite3_open_v2(dbpath, &db, SQLITE_OPEN_READONLY, NULL);
-       if (ret != SQLITE_OK) {
-               _LOGE("failed to open db: %d", ret);
+       ret = pkgmgrinfo_pkginfo_filter_create(&filter);
+       if (ret != PMINFO_R_OK) {
+               free(locale);
+               return ret;
+       }
+
+       ret = pkgmgrinfo_pkginfo_filter_add_string(filter,
+                       PMINFO_PKGINFO_PROP_PACKAGE_ID, pkgid);
+       if (ret != PMINFO_R_OK) {
+               pkgmgrinfo_pkginfo_filter_destroy(filter);
+               free(locale);
+               return PMINFO_R_ERROR;
+       }
+
+       list = g_hash_table_new(g_str_hash, g_str_equal);
+       if (list == NULL) {
+               pkgmgrinfo_pkginfo_filter_destroy(filter);
                free(locale);
                return PMINFO_R_ERROR;
        }
 
+       ret = _pkginfo_get_packages(uid, locale, filter,
+                       PMINFO_PKGINFO_GET_ALL, list);
+       if (!g_hash_table_size(list) && uid != GLOBAL_USER)
+               ret = _pkginfo_get_packages(GLOBAL_USER, locale, filter,
+                               PMINFO_PKGINFO_GET_ALL, list);
+
+       pkgmgrinfo_pkginfo_filter_destroy(filter);
+       if (ret != PMINFO_R_OK) {
+               g_hash_table_destroy(list);
+               free(locale);
+               return ret;
+       }
+
+       if (!g_hash_table_size(list)) {
+               _LOGI("pkginfo for [%s] is not existed for user [%d]",
+                               pkgid, uid);
+               g_hash_table_destroy(list);
+               free(locale);
+               return PMINFO_R_ENOENT;
+       }
+
        info = calloc(1, sizeof(pkgmgr_pkginfo_x));
        if (info == NULL) {
                _LOGE("out of memory");
+               g_hash_table_destroy(list);
                free(locale);
-               sqlite3_close_v2(db);
                return PMINFO_R_ERROR;
        }
 
-       ret = _pkginfo_get_package(db, pkgid, locale, &info->pkg_info);
-       if (ret == PMINFO_R_OK) {
-               info->locale = strdup(locale);
-               info->uid = uid;
-               info->pkg_info->for_all_users = strdup(
-                               uid != GLOBAL_USER ? "false" : "true");
-       }
+       info->uid = uid;
+       info->pkg_info = (package_x *)g_hash_table_lookup(list, pkgid);
+       info->locale = locale;
 
-       *pkginfo = info;
+       /* just free list only */
+       g_hash_table_destroy(list);
 
-       free(locale);
-       sqlite3_close_v2(db);
+       *handle = info;
 
        return ret;
 }
 
-API int pkgmgrinfo_pkginfo_get_usr_pkginfo(const char *pkgid, uid_t uid,
+API int pkgmgrinfo_pkginfo_get_pkginfo(const char *pkgid,
                pkgmgrinfo_pkginfo_h *handle)
 {
-       int ret;
+       return pkgmgrinfo_pkginfo_get_usr_pkginfo(pkgid, _getuid(), handle);
+}
 
-       if (pkgid == NULL || handle == NULL) {
+API int pkgmgrinfo_pkginfo_get_usr_list_full(pkgmgrinfo_pkg_list_cb pkg_list_cb,
+               int flag, void *user_data, uid_t uid)
+{
+       if (pkg_list_cb == NULL) {
                LOGE("invalid parameter");
                return PMINFO_R_EINVAL;
        }
 
-       ret = _pkginfo_get_pkginfo(pkgid, uid, (pkgmgr_pkginfo_x **)handle);
-       if (ret == PMINFO_R_ENOENT && uid != GLOBAL_USER)
-               ret = _pkginfo_get_pkginfo(pkgid, GLOBAL_USER,
-                               (pkgmgr_pkginfo_x **)handle);
+       return _pkginfo_get_filtered_foreach_pkginfo(uid, NULL, flag,
+                       pkg_list_cb, user_data);
+}
 
-       if (ret != PMINFO_R_OK)
-               _LOGE("failed to get pkginfo of %s for user %d", pkgid, uid);
+API int pkgmgrinfo_pkginfo_get_list_full(pkgmgrinfo_pkg_list_cb pkg_list_cb,
+               int flag, void *user_data)
+{
+       return pkgmgrinfo_pkginfo_get_usr_list_full(pkg_list_cb, flag,
+                       user_data, _getuid());
+}
+
+API int pkgmgrinfo_pkginfo_get_usr_list(pkgmgrinfo_pkg_list_cb pkg_list_cb,
+               void *user_data, uid_t uid)
+{
+       if (pkg_list_cb == NULL) {
+               LOGE("invalid parameter");
+               return PMINFO_R_EINVAL;
+       }
 
-       return ret;
+       return _pkginfo_get_filtered_foreach_pkginfo(uid, NULL,
+                       PMINFO_PKGINFO_GET_ALL, pkg_list_cb, user_data);
 }
 
-API int pkgmgrinfo_pkginfo_get_pkginfo(const char *pkgid, pkgmgrinfo_pkginfo_h *handle)
+API int pkgmgrinfo_pkginfo_get_list(pkgmgrinfo_pkg_list_cb pkg_list_cb,
+               void *user_data)
 {
-       return pkgmgrinfo_pkginfo_get_usr_pkginfo(pkgid, GLOBAL_USER, handle);
+       return pkgmgrinfo_pkginfo_get_usr_list(pkg_list_cb, user_data,
+                       _getuid());
 }
 
 API int pkgmgrinfo_pkginfo_get_pkgname(pkgmgrinfo_pkginfo_h handle, char **pkg_name)
@@ -906,6 +911,55 @@ API int pkgmgrinfo_pkginfo_get_version(pkgmgrinfo_pkginfo_h handle, char **versi
        return PMINFO_R_OK;
 }
 
+API int pkgmgrinfo_pkginfo_get_api_version(pkgmgrinfo_pkginfo_h handle, char **api_version)
+{
+       pkgmgr_pkginfo_x *info = (pkgmgr_pkginfo_x *)handle;
+
+       retvm_if(handle == NULL, PMINFO_R_EINVAL, "pkginfo handle is NULL\n");
+       retvm_if(api_version == NULL, PMINFO_R_EINVAL, "Argument supplied to hold return value is NULL\n");
+
+       if (info->pkg_info == NULL || info->pkg_info->api_version == NULL)
+               return PMINFO_R_ERROR;
+
+       *api_version = (char *)info->pkg_info->api_version;
+
+       return PMINFO_R_OK;
+}
+
+API int pkgmgrinfo_pkginfo_get_tep_name(pkgmgrinfo_pkginfo_h handle, char **tep_name)
+{
+       pkgmgr_pkginfo_x *info = (pkgmgr_pkginfo_x *)handle;
+
+       retvm_if(handle == NULL, PMINFO_R_EINVAL, "pkginfo handle is NULL\n");
+       retvm_if(tep_name == NULL, PMINFO_R_EINVAL, "Argument supplied to hold return value is NULL\n");
+
+       if (info->pkg_info == NULL || info->pkg_info->tep_name == NULL)
+               return PMINFO_R_ERROR;
+
+       if (strlen(info->pkg_info->tep_name) == 0)
+               return PMINFO_R_ERROR;
+
+       *tep_name = (char *)info->pkg_info->tep_name;
+
+       return PMINFO_R_OK;
+}
+
+API int pkgmgrinfo_pkginfo_get_zip_mount_file(pkgmgrinfo_pkginfo_h handle, char **zip_mount_file)
+{
+       pkgmgr_pkginfo_x *info = (pkgmgr_pkginfo_x *)handle;
+
+       retvm_if(handle == NULL, PMINFO_R_EINVAL, "pkginfo handle is NULL\n");
+       retvm_if(zip_mount_file == NULL, PMINFO_R_EINVAL, "Argument supplied to hold return value is NULL\n");
+
+       if (info->pkg_info == NULL)
+               return PMINFO_R_ERROR;
+
+       if (strlen(info->pkg_info->zip_mount_file) > 0)
+               *zip_mount_file = (char *)info->pkg_info->zip_mount_file;
+
+       return PMINFO_R_OK;
+}
+
 API int pkgmgrinfo_pkginfo_get_install_location(pkgmgrinfo_pkginfo_h handle, pkgmgrinfo_install_location *location)
 {
        char *val;
@@ -1103,8 +1157,9 @@ API int pkgmgrinfo_pkginfo_get_data_size(pkgmgrinfo_pkginfo_h handle, int *size)
 
 API int pkgmgrinfo_pkginfo_get_icon(pkgmgrinfo_pkginfo_h handle, char **icon)
 {
-       char *locale;
+       const char *locale;
        icon_x *ptr;
+       GList *tmp;
        pkgmgr_pkginfo_x *info = (pkgmgr_pkginfo_x *)handle;
 
        retvm_if(handle == NULL, PMINFO_R_EINVAL, "pkginfo handle is NULL");
@@ -1113,22 +1168,27 @@ API int pkgmgrinfo_pkginfo_get_icon(pkgmgrinfo_pkginfo_h handle, char **icon)
        locale = info->locale;
        retvm_if(locale == NULL, PMINFO_R_ERROR, "manifest locale is NULL");
 
-       for (ptr = info->pkg_info->icon; ptr != NULL; ptr = ptr->next) {
-               if (ptr->lang == NULL)
+       if (info->pkg_info == NULL)
+               return PMINFO_R_ERROR;
+
+       for (tmp = info->pkg_info->icon; tmp; tmp = tmp->next) {
+               ptr = (icon_x *)tmp->data;
+               if (ptr == NULL || ptr->text == NULL || ptr->lang == NULL ||
+                               !strcasecmp(ptr->text, "(null)") ||
+                               strcmp(ptr->lang, locale))
                        continue;
+               *icon = (char *)ptr->text;
+               return PMINFO_R_OK;
+       }
 
-               if (strcmp(ptr->lang, locale) == 0) {
-                       *icon = (char *)ptr->text;
-                       if (strcasecmp(*icon, "(null)") == 0) {
-                               locale = DEFAULT_LOCALE;
-                               continue;
-                       } else {
-                               return PMINFO_R_OK;
-                       }
-               } else if (strcmp(ptr->lang, DEFAULT_LOCALE) == 0) {
-                       *icon = (char *)ptr->text;
-                       return PMINFO_R_OK;
-               }
+       locale = DEFAULT_LOCALE;
+       for (tmp = info->pkg_info->icon; tmp; tmp = tmp->next) {
+               ptr = (icon_x *)tmp->data;
+               if (ptr == NULL || ptr->text == NULL || ptr->lang == NULL ||
+                               strcmp(ptr->lang, locale))
+                       continue;
+               *icon = (char *)ptr->text;
+               return PMINFO_R_OK;
        }
 
        return PMINFO_R_ERROR;
@@ -1136,8 +1196,9 @@ API int pkgmgrinfo_pkginfo_get_icon(pkgmgrinfo_pkginfo_h handle, char **icon)
 
 API int pkgmgrinfo_pkginfo_get_label(pkgmgrinfo_pkginfo_h handle, char **label)
 {
-       char *locale;
+       const char *locale;
        label_x *ptr;
+       GList *tmp;
        pkgmgr_pkginfo_x *info = (pkgmgr_pkginfo_x *)handle;
 
        retvm_if(handle == NULL, PMINFO_R_EINVAL, "pkginfo handle is NULL");
@@ -1146,22 +1207,23 @@ API int pkgmgrinfo_pkginfo_get_label(pkgmgrinfo_pkginfo_h handle, char **label)
        locale = info->locale;
        retvm_if(locale == NULL, PMINFO_R_ERROR, "manifest locale is NULL");
 
-       for (ptr = info->pkg_info->label; ptr != NULL; ptr = ptr->next) {
-               if (ptr->lang == NULL)
+       for (tmp = info->pkg_info->label; tmp != NULL; tmp = tmp->next) {
+               ptr = (label_x *)tmp->data;
+               if (ptr == NULL || ptr->text == NULL || ptr->lang == NULL ||
+                               strcmp(ptr->lang, locale))
                        continue;
+               *label = (char *)ptr->text;
+               return PMINFO_R_OK;
+       }
 
-               if (strcmp(ptr->lang, locale) == 0) {
-                       *label = (char *)ptr->text;
-                       if (strcasecmp(*label, "(null)") == 0) {
-                               locale = DEFAULT_LOCALE;
-                               continue;
-                       } else {
-                               return PMINFO_R_OK;
-                       }
-               } else if (strcmp(ptr->lang, DEFAULT_LOCALE) == 0) {
-                       *label = (char *)ptr->text;
-                       return PMINFO_R_OK;
-               }
+       locale = DEFAULT_LOCALE;
+       for (tmp = info->pkg_info->label; tmp != NULL; tmp = tmp->next) {
+               ptr = (label_x *)tmp->data;
+               if (ptr == NULL || ptr->text == NULL || ptr->lang == NULL ||
+                               strcmp(ptr->lang, locale))
+                       continue;
+               *label = (char *)ptr->text;
+               return PMINFO_R_OK;
        }
 
        return PMINFO_R_ERROR;
@@ -1169,8 +1231,9 @@ API int pkgmgrinfo_pkginfo_get_label(pkgmgrinfo_pkginfo_h handle, char **label)
 
 API int pkgmgrinfo_pkginfo_get_description(pkgmgrinfo_pkginfo_h handle, char **description)
 {
-       char *locale;
+       const char *locale;
        description_x *ptr;
+       GList *tmp;
        pkgmgr_pkginfo_x *info = (pkgmgr_pkginfo_x *)handle;
 
        retvm_if(handle == NULL, PMINFO_R_EINVAL, "pkginfo handle is NULL\n");
@@ -1179,22 +1242,23 @@ API int pkgmgrinfo_pkginfo_get_description(pkgmgrinfo_pkginfo_h handle, char **d
        locale = info->locale;
        retvm_if(locale == NULL, PMINFO_R_ERROR, "manifest locale is NULL");
 
-       for (ptr = info->pkg_info->description; ptr != NULL; ptr = ptr->next) {
-               if (ptr->lang == NULL)
+       for (tmp = info->pkg_info->description; tmp; tmp = tmp->next) {
+               ptr = (description_x *)tmp->data;
+               if (ptr == NULL || ptr->text == NULL || ptr->lang == NULL ||
+                               strcmp(ptr->lang, locale))
                        continue;
+               *description = (char *)ptr->text;
+               return PMINFO_R_OK;
+       }
 
-               if (strcmp(ptr->lang, locale) == 0) {
-                       *description = (char *)ptr->text;
-                       if (strcasecmp(*description, PKGMGR_PARSER_EMPTY_STR) == 0) {
-                               locale = DEFAULT_LOCALE;
-                               continue;
-                       } else {
-                               return PMINFO_R_OK;
-                       }
-               } else if (strcmp(ptr->lang, DEFAULT_LOCALE) == 0) {
-                       *description = (char *)ptr->text;
-                       return PMINFO_R_OK;
-               }
+       locale = DEFAULT_LOCALE;
+       for (tmp = info->pkg_info->description; tmp; tmp = tmp->next) {
+               ptr = (description_x *)tmp->data;
+               if (ptr == NULL || ptr->text == NULL || ptr->lang == NULL ||
+                               strcmp(ptr->lang, locale))
+                       continue;
+               *description = (char *)ptr->text;
+               return PMINFO_R_OK;
        }
 
        return PMINFO_R_ERROR;
@@ -1203,15 +1267,19 @@ API int pkgmgrinfo_pkginfo_get_description(pkgmgrinfo_pkginfo_h handle, char **d
 API int pkgmgrinfo_pkginfo_get_author_name(pkgmgrinfo_pkginfo_h handle, char **author_name)
 {
        pkgmgr_pkginfo_x *info = (pkgmgr_pkginfo_x *)handle;
+       author_x *author;
 
        retvm_if(handle == NULL, PMINFO_R_EINVAL, "pkginfo handle is NULL\n");
        retvm_if(author_name == NULL, PMINFO_R_EINVAL, "Argument supplied to hold return value is NULL\n");
 
-       if (info->pkg_info == NULL || info->pkg_info->author == NULL ||
-                       info->pkg_info->author->text == NULL)
+       if (info->pkg_info == NULL || info->pkg_info->author == NULL)
+               return PMINFO_R_ERROR;
+
+       author = (author_x *)info->pkg_info->author->data;
+       if (author == NULL || author->text == NULL)
                return PMINFO_R_ERROR;
 
-       *author_name = (char *)info->pkg_info->author->text;
+       *author_name = (char *)author->text;
 
        return PMINFO_R_OK;
 }
@@ -1219,15 +1287,19 @@ API int pkgmgrinfo_pkginfo_get_author_name(pkgmgrinfo_pkginfo_h handle, char **a
 API int pkgmgrinfo_pkginfo_get_author_email(pkgmgrinfo_pkginfo_h handle, char **author_email)
 {
        pkgmgr_pkginfo_x *info = (pkgmgr_pkginfo_x *)handle;
+       author_x *author;
 
        retvm_if(handle == NULL, PMINFO_R_EINVAL, "pkginfo handle is NULL\n");
        retvm_if(author_email == NULL, PMINFO_R_EINVAL, "Argument supplied to hold return value is NULL\n");
 
-       if (info->pkg_info == NULL || info->pkg_info->author == NULL ||
-                       info->pkg_info->author->email == NULL)
+       if (info->pkg_info == NULL || info->pkg_info->author == NULL)
                return PMINFO_R_ERROR;
 
-       *author_email = (char *)info->pkg_info->author->email;
+       author = (author_x *)info->pkg_info->author->data;
+       if (author == NULL || author->email == NULL)
+               return PMINFO_R_ERROR;
+
+       *author_email = (char *)author->email;
 
        return PMINFO_R_OK;
 }
@@ -1235,15 +1307,19 @@ API int pkgmgrinfo_pkginfo_get_author_email(pkgmgrinfo_pkginfo_h handle, char **
 API int pkgmgrinfo_pkginfo_get_author_href(pkgmgrinfo_pkginfo_h handle, char **author_href)
 {
        pkgmgr_pkginfo_x *info = (pkgmgr_pkginfo_x *)handle;
+       author_x *author;
 
        retvm_if(handle == NULL, PMINFO_R_EINVAL, "pkginfo handle is NULL\n");
        retvm_if(author_href == NULL, PMINFO_R_EINVAL, "Argument supplied to hold return value is NULL\n");
 
-       if (info->pkg_info == NULL || info->pkg_info->author == NULL ||
-                       info->pkg_info->author->href == NULL)
+       if (info->pkg_info == NULL || info->pkg_info->author == NULL)
+               return PMINFO_R_ERROR;
+
+       author = (author_x *)info->pkg_info->author->data;
+       if (author == NULL || author->href == NULL)
                return PMINFO_R_ERROR;
 
-       *author_href = (char *)info->pkg_info->author->href;
+       *author_href = (char *)author->href;
 
        return PMINFO_R_OK;
 }
@@ -1531,7 +1607,6 @@ API int pkgmgrinfo_pkginfo_is_accessible(pkgmgrinfo_pkginfo_h handle, bool *acce
 
 API int pkgmgrinfo_pkginfo_is_removable(pkgmgrinfo_pkginfo_h handle, bool *removable)
 {
-       char *val;
        pkgmgr_pkginfo_x *info = (pkgmgr_pkginfo_x *)handle;
 
        retvm_if(handle == NULL, PMINFO_R_EINVAL, "pkginfo handle is NULL\n");
@@ -1540,13 +1615,7 @@ API int pkgmgrinfo_pkginfo_is_removable(pkgmgrinfo_pkginfo_h handle, bool *remov
        if (info->pkg_info == NULL || info->pkg_info->removable == NULL)
                return PMINFO_R_ERROR;
 
-       val = (char *)info->pkg_info->removable;
-       if (strcasecmp(val, "true") == 0)
-               *removable = 1;
-       else if (strcasecmp(val, "false") == 0)
-               *removable = 0;
-       else
-               *removable = 1;
+       *removable = _get_bool_value(info->pkg_info->removable);
 
        return PMINFO_R_OK;
 }
@@ -1575,7 +1644,6 @@ API int pkgmgrinfo_pkginfo_is_movable(pkgmgrinfo_pkginfo_h handle, bool *movable
 
 API int pkgmgrinfo_pkginfo_is_preload(pkgmgrinfo_pkginfo_h handle, bool *preload)
 {
-       char *val;
        pkgmgr_pkginfo_x *info = (pkgmgr_pkginfo_x *)handle;
 
        retvm_if(handle == NULL, PMINFO_R_EINVAL, "pkginfo handle is NULL\n");
@@ -1584,20 +1652,13 @@ API int pkgmgrinfo_pkginfo_is_preload(pkgmgrinfo_pkginfo_h handle, bool *preload
        if (info->pkg_info == NULL || info->pkg_info->preload == NULL)
                return PMINFO_R_ERROR;
 
-       val = (char *)info->pkg_info->preload;
-       if (strcasecmp(val, "true") == 0)
-               *preload = 1;
-       else if (strcasecmp(val, "false") == 0)
-               *preload = 0;
-       else
-               *preload = 0;
+       *preload = _get_bool_value(info->pkg_info->preload);
 
        return PMINFO_R_OK;
 }
 
 API int pkgmgrinfo_pkginfo_is_system(pkgmgrinfo_pkginfo_h handle, bool *system)
 {
-       char *val;
        pkgmgr_pkginfo_x *info = (pkgmgr_pkginfo_x *)handle;
 
        retvm_if(handle == NULL, PMINFO_R_EINVAL, "pkginfo handle is NULL\n");
@@ -1606,20 +1667,13 @@ API int pkgmgrinfo_pkginfo_is_system(pkgmgrinfo_pkginfo_h handle, bool *system)
        if (info->pkg_info == NULL || info->pkg_info->system == NULL)
                return PMINFO_R_ERROR;
 
-       val = (char *)info->pkg_info->system;
-       if (strcasecmp(val, "true") == 0)
-               *system = 1;
-       else if (strcasecmp(val, "false") == 0)
-               *system = 0;
-       else
-               *system = 0;
+       *system = _get_bool_value(info->pkg_info->system);
 
        return PMINFO_R_OK;
 }
 
 API int pkgmgrinfo_pkginfo_is_readonly(pkgmgrinfo_pkginfo_h handle, bool *readonly)
 {
-       char *val;
        pkgmgr_pkginfo_x *info = (pkgmgr_pkginfo_x *)handle;
 
        retvm_if(handle == NULL, PMINFO_R_EINVAL, "pkginfo handle is NULL\n");
@@ -1628,20 +1682,13 @@ API int pkgmgrinfo_pkginfo_is_readonly(pkgmgrinfo_pkginfo_h handle, bool *readon
        if (info->pkg_info == NULL || info->pkg_info->readonly == NULL)
                return PMINFO_R_ERROR;
 
-       val = (char *)info->pkg_info->readonly;
-       if (strcasecmp(val, "true") == 0)
-               *readonly = 1;
-       else if (strcasecmp(val, "false") == 0)
-               *readonly = 0;
-       else
-               *readonly = 0;
+       *readonly = _get_bool_value(info->pkg_info->readonly);
 
        return PMINFO_R_OK;
 }
 
 API int pkgmgrinfo_pkginfo_is_update(pkgmgrinfo_pkginfo_h handle, bool *update)
 {
-       char *val;
        pkgmgr_pkginfo_x *info = (pkgmgr_pkginfo_x *)handle;
 
        retvm_if(handle == NULL, PMINFO_R_EINVAL, "pkginfo handle is NULL\n");
@@ -1650,20 +1697,13 @@ API int pkgmgrinfo_pkginfo_is_update(pkgmgrinfo_pkginfo_h handle, bool *update)
        if (info->pkg_info == NULL || info->pkg_info->update == NULL)
                return PMINFO_R_ERROR;
 
-       val = (char *)info->pkg_info->update;
-       if (strcasecmp(val, "true") == 0)
-               *update = 1;
-       else if (strcasecmp(val, "false") == 0)
-               *update = 0;
-       else
-               *update = 1;
+       *update = _get_bool_value(info->pkg_info->update);
 
        return PMINFO_R_OK;
 }
 
 API int pkgmgrinfo_pkginfo_is_support_disable(pkgmgrinfo_pkginfo_h handle, bool *support_disable)
 {
-       char *val;
        pkgmgr_pkginfo_x *info = (pkgmgr_pkginfo_x *)handle;
 
        retvm_if(handle == NULL, PMINFO_R_EINVAL, "pkginfo handle is NULL\n");
@@ -1672,39 +1712,31 @@ API int pkgmgrinfo_pkginfo_is_support_disable(pkgmgrinfo_pkginfo_h handle, bool
        if (info->pkg_info == NULL || info->pkg_info->support_disable == NULL)
                return PMINFO_R_ERROR;
 
-       val = (char *)info->pkg_info->support_disable;
-       if (strcasecmp(val, "true") == 0)
-               *support_disable = 1;
-       else if (strcasecmp(val, "false") == 0)
-               *support_disable = 0;
-       else
-               *support_disable = 1;
+       *support_disable = _get_bool_value(info->pkg_info->support_disable);
 
        return PMINFO_R_OK;
 }
 
-API int pkgmgrinfo_pkginfo_is_for_all_users(pkgmgrinfo_pkginfo_h handle, bool *for_all_users)
+API int pkgmgrinfo_pkginfo_is_global(pkgmgrinfo_pkginfo_h handle, bool *global)
 {
-       char *val;
        pkgmgr_pkginfo_x *info = (pkgmgr_pkginfo_x *)handle;
 
        retvm_if(handle == NULL, PMINFO_R_EINVAL, "pkginfo handle is NULL\n");
-       retvm_if(for_all_users == NULL, PMINFO_R_EINVAL, "Argument supplied to hold return value is NULL\n");
+       retvm_if(global == NULL, PMINFO_R_EINVAL, "Argument supplied to hold return value is NULL\n");
 
        if (info->pkg_info == NULL || info->pkg_info->for_all_users == NULL)
                return PMINFO_R_ERROR;
 
-       val = (char *)info->pkg_info->for_all_users;
-       if (strcasecmp(val, "true") == 0)
-               *for_all_users = 1;
-       else if (strcasecmp(val, "false") == 0)
-               *for_all_users = 0;
-       else
-               *for_all_users = 1;
+       *global = _get_bool_value(info->pkg_info->for_all_users);
 
        return PMINFO_R_OK;
 }
 
+API int pkgmgrinfo_pkginfo_is_for_all_users(pkgmgrinfo_pkginfo_h handle, bool *for_all_users)
+{
+       return pkgmgrinfo_pkginfo_is_global(handle, for_all_users);
+}
+
 API int pkgmgrinfo_pkginfo_destroy_pkginfo(pkgmgrinfo_pkginfo_h handle)
 {
        pkgmgr_pkginfo_x *info = (pkgmgr_pkginfo_x *)handle;
@@ -1816,9 +1848,9 @@ API int pkgmgrinfo_pkginfo_filter_add_bool(pkgmgrinfo_pkginfo_filter_h handle,
                return PMINFO_R_ERROR;
        }
        if (value)
-               val = strndup("('true','True')", 15);
+               val = strndup("true", 4);
        else
-               val = strndup("('false','False')", 17);
+               val = strndup("false", 5);
        if (val == NULL) {
                _LOGE("Out of Memory\n");
                free(node);
@@ -1892,27 +1924,48 @@ API int pkgmgrinfo_pkginfo_filter_add_string(pkgmgrinfo_pkginfo_filter_h handle,
 API int pkgmgrinfo_pkginfo_usr_filter_count(pkgmgrinfo_pkginfo_filter_h handle, int *count, uid_t uid)
 {
        int ret;
-       GList *list = NULL;
+       char *locale;
+       GHashTable *list = NULL;
 
        if (handle == NULL || count == NULL) {
                _LOGE("invalid parameter");
                return PMINFO_R_EINVAL;
        }
 
-       ret = _pkginfo_get_filtered_list((pkgmgrinfo_filter_x *)handle, uid, &list);
-       if (ret != PMINFO_R_OK)
+       locale = _get_system_locale();
+       if (locale == NULL)
+               return PMINFO_R_ERROR;
+
+       list = g_hash_table_new_full(g_str_hash, g_str_equal, NULL,
+                       __free_packages);
+       if (list == NULL) {
+               free(locale);
+               return PMINFO_R_ERROR;
+       }
+
+       ret = _pkginfo_get_packages(uid, locale,
+                       (pkgmgrinfo_filter_x *)handle, 0, list);
+       if (ret == PMINFO_R_OK && uid != GLOBAL_USER)
+               ret = _pkginfo_get_packages(GLOBAL_USER, locale, handle, 0,
+                               list);
+
+       if (ret != PMINFO_R_OK) {
+               g_hash_table_destroy(list);
+               free(locale);
                return PMINFO_R_ERROR;
+       }
 
-       *count = g_list_length(list);
+       *count = g_hash_table_size(list);
 
-       g_list_free_full(list, free);
+       g_hash_table_destroy(list);
+       free(locale);
 
        return PMINFO_R_OK;
 }
 
 API int pkgmgrinfo_pkginfo_filter_count(pkgmgrinfo_pkginfo_filter_h handle, int *count)
 {
-       return pkgmgrinfo_pkginfo_usr_filter_count(handle, count, GLOBAL_USER);
+       return pkgmgrinfo_pkginfo_usr_filter_count(handle, count, _getuid());
 }
 
 API int pkgmgrinfo_pkginfo_usr_filter_foreach_pkginfo(
@@ -1924,14 +1977,14 @@ API int pkgmgrinfo_pkginfo_usr_filter_foreach_pkginfo(
                return PMINFO_R_EINVAL;
        }
 
-       return _pkginfo_get_filtered_foreach_pkginfo(handle, pkg_cb, user_data,
-                       uid);
+       return _pkginfo_get_filtered_foreach_pkginfo(uid, handle,
+                       PMINFO_PKGINFO_GET_ALL, pkg_cb, user_data);
 }
 
 API int pkgmgrinfo_pkginfo_filter_foreach_pkginfo(pkgmgrinfo_pkginfo_filter_h handle,
                                pkgmgrinfo_pkg_list_cb pkg_cb, void *user_data)
 {
-       return pkgmgrinfo_pkginfo_usr_filter_foreach_pkginfo(handle, pkg_cb, user_data, GLOBAL_USER);
+       return pkgmgrinfo_pkginfo_usr_filter_foreach_pkginfo(handle, pkg_cb, user_data, _getuid());
 }
 
 API int pkgmgrinfo_pkginfo_foreach_privilege(pkgmgrinfo_pkginfo_h handle,
@@ -1939,332 +1992,21 @@ API int pkgmgrinfo_pkginfo_foreach_privilege(pkgmgrinfo_pkginfo_h handle,
 {
        retvm_if(handle == NULL, PMINFO_R_EINVAL, "pkginfo handle is NULL");
        retvm_if(privilege_func == NULL, PMINFO_R_EINVAL, "Callback function is NULL");
-       int ret = -1;
-       privilege_x *ptr = NULL;
-       pkgmgr_pkginfo_x *info = (pkgmgr_pkginfo_x *)handle;
-       ptr = info->pkg_info->privileges->privilege;
-       for (; ptr; ptr = ptr->next) {
-               if (ptr->text){
-                       ret = privilege_func(ptr->text, user_data);
-                       if (ret < 0)
-                               break;
-               }
-       }
-       return PMINFO_R_OK;
-}
-
-API int pkgmgrinfo_create_pkgusrdbinfo(const char *pkgid, uid_t uid, pkgmgrinfo_pkgdbinfo_h *handle)
-{
-       retvm_if(!pkgid, PMINFO_R_EINVAL, "pkgid is NULL");
-       retvm_if(!handle, PMINFO_R_EINVAL, "Argument supplied is NULL");
-
-       char *manifest = NULL;
-       manifest_x *mfx = NULL;
-       *handle = NULL;
-       manifest = pkgmgr_parser_get_usr_manifest_file(pkgid, uid);
-       retvm_if(manifest == NULL, PMINFO_R_EINVAL, "pkg[%s] dont have manifest file", pkgid);
-
-       mfx = pkgmgr_parser_usr_process_manifest_xml(manifest, uid);
-       if (manifest) {
-               free(manifest);
-               manifest = NULL;
-       }
-       retvm_if(mfx == NULL, PMINFO_R_EINVAL, "pkg[%s] parsing fail", pkgid);
-
-       *handle = (void *)mfx;
-
-       return PMINFO_R_OK;
-}
-
-API int pkgmgrinfo_create_pkgdbinfo(const char *pkgid, pkgmgrinfo_pkgdbinfo_h *handle)
-{
-       retvm_if(!pkgid, PMINFO_R_EINVAL, "pkgid is NULL");
-       retvm_if(!handle, PMINFO_R_EINVAL, "Argument supplied is NULL");
-
-       char *manifest = NULL;
-       manifest_x *mfx = NULL;
-       *handle = NULL;
-       manifest = pkgmgr_parser_get_manifest_file(pkgid);
-       retvm_if(manifest == NULL, PMINFO_R_EINVAL, "pkg[%s] dont have manifest file", pkgid);
-
-       mfx = pkgmgr_parser_process_manifest_xml(manifest);
-       if (manifest) {
-               free(manifest);
-               manifest = NULL;
-       }
-       retvm_if(mfx == NULL, PMINFO_R_EINVAL, "pkg[%s] parsing fail", pkgid);
-
-       *handle = (void *)mfx;
-
-       return PMINFO_R_OK;
-}
-
-API int pkgmgrinfo_set_type_to_pkgdbinfo(pkgmgrinfo_pkgdbinfo_h handle, const char *type)
-{
-       int len;
-       manifest_x *mfx = (manifest_x *)handle;
-
-       retvm_if(!type, PMINFO_R_EINVAL, "Argument supplied is NULL");
-       retvm_if(!handle, PMINFO_R_EINVAL, "Argument supplied is NULL");
-
-       len = strlen(type);
-       retvm_if(len > PKG_TYPE_STRING_LEN_MAX, PMINFO_R_EINVAL, "pkg type length exceeds the max limit");
-
-       if (mfx->type)
-               free((void *)mfx->type);
-
-       mfx->type = strndup(type, PKG_TYPE_STRING_LEN_MAX);
-
-       return PMINFO_R_OK;
-}
-
-API int pkgmgrinfo_set_version_to_pkgdbinfo(pkgmgrinfo_pkgdbinfo_h handle, const char *version)
-{
-       int len;
-       manifest_x *mfx = (manifest_x *)handle;
-
-       retvm_if(!version, PMINFO_R_EINVAL, "Argument supplied is NULL");
-       retvm_if(!handle, PMINFO_R_EINVAL, "Argument supplied is NULL");
-
-       len = strlen(version);
-       retvm_if(len > PKG_TYPE_STRING_LEN_MAX, PMINFO_R_EINVAL, "pkg type length exceeds the max limit");
-
-       if (mfx->version)
-               free((void *)mfx->version);
-
-       mfx->version = strndup(version, PKG_VERSION_STRING_LEN_MAX);
-       return PMINFO_R_OK;
-}
-
-API int pkgmgrinfo_set_install_location_to_pkgdbinfo(pkgmgrinfo_pkgdbinfo_h handle, INSTALL_LOCATION location)
-{
-       manifest_x *mfx = (manifest_x *)handle;
-
-       retvm_if(!handle, PMINFO_R_EINVAL, "Argument supplied is NULL");
-       retvm_if((location < 0) || (location > 1), PMINFO_R_EINVAL, "Argument supplied is NULL");
-
-       if (mfx->installlocation)
-               free((void *)mfx->installlocation);
-
-       if (location == INSTALL_INTERNAL)
-               mfx->installlocation = strdup("internal-only");
-       else if (location == INSTALL_EXTERNAL)
-               mfx->installlocation = strdup("prefer-external");
-
-       return PMINFO_R_OK;
-}
-
-API int pkgmgrinfo_set_size_to_pkgdbinfo(pkgmgrinfo_pkgdbinfo_h handle, const char *size)
-{
-       manifest_x *mfx = (manifest_x *)handle;
-
-       retvm_if(!handle, PMINFO_R_EINVAL, "Argument supplied is NULL");
-       retvm_if(size == NULL, PMINFO_R_EINVAL, "Argument supplied is NULL");
-
-       if (mfx->package_size)
-               free((void *)mfx->package_size);
-
-       mfx->package_size = strdup(size);
-
-       return PMINFO_R_OK;
-}
-
-API int pkgmgrinfo_set_label_to_pkgdbinfo(pkgmgrinfo_pkgdbinfo_h handle, const char *label_txt, const char *locale)
-{
-       int len;
-       manifest_x *mfx = (manifest_x *)handle;
-       label_x *label;
-
-       retvm_if(!handle, PMINFO_R_EINVAL, "Argument supplied is NULL");
-       retvm_if(!label_txt, PMINFO_R_EINVAL, "Argument supplied is NULL");
-
-       len = strlen(label_txt);
-       retvm_if(len > PKG_TYPE_STRING_LEN_MAX, PMINFO_R_EINVAL, "pkg type length exceeds the max limit");
-
-       label = calloc(1, sizeof(label_x));
-       retvm_if(label == NULL, PMINFO_R_EINVAL, "Malloc Failed");
-
-       LISTADD(mfx->label, label);
-       if (locale)
-               mfx->label->lang = strdup(locale);
-       else
-               mfx->label->lang = strdup(DEFAULT_LOCALE);
-       mfx->label->text = strdup(label_txt);
-
-       return PMINFO_R_OK;
-}
-
-API int pkgmgrinfo_set_icon_to_pkgdbinfo(pkgmgrinfo_pkgdbinfo_h handle, const char *icon_txt, const char *locale)
-{
-       int len;
-       manifest_x *mfx = (manifest_x *)handle;
-       icon_x *icon;
-
-       retvm_if(!handle, PMINFO_R_EINVAL, "Argument supplied is NULL");
-       retvm_if(!icon_txt, PMINFO_R_EINVAL, "Argument supplied is NULL");
-
-       len = strlen(icon_txt);
-       retvm_if(len > PKG_TYPE_STRING_LEN_MAX, PMINFO_R_EINVAL, "pkg type length exceeds the max limit");
-
-       icon = calloc(1, sizeof(icon_x));
-       retvm_if(icon == NULL, PMINFO_R_EINVAL, "Malloc Failed");
-
-       LISTADD(mfx->icon, icon);
-       if (locale)
-               mfx->icon->lang = strdup(locale);
-       else
-               mfx->icon->lang = strdup(DEFAULT_LOCALE);
-       mfx->icon->text = strdup(icon_txt);
-
-       return PMINFO_R_OK;
-}
-
-API int pkgmgrinfo_set_description_to_pkgdbinfo(pkgmgrinfo_pkgdbinfo_h handle, const char *desc_txt, const char *locale)
-{
-       int len = strlen(desc_txt);
-       manifest_x *mfx = (manifest_x *)handle;
-       description_x *description;
-
-       retvm_if(!handle, PMINFO_R_EINVAL, "Argument supplied is NULL");
-       retvm_if(!desc_txt, PMINFO_R_EINVAL, "Argument supplied is NULL");
-
-       len = strlen(desc_txt);
-       retvm_if(len > PKG_TYPE_STRING_LEN_MAX, PMINFO_R_EINVAL, "pkg type length exceeds the max limit");
-
-       description = calloc(1, sizeof(description_x));
-       retvm_if(description == NULL, PMINFO_R_EINVAL, "Malloc Failed");
-
-       LISTADD(mfx->description, description);
-       if (locale)
-               mfx->description->lang = strdup(locale);
-       else
-               mfx->description->lang = strdup(DEFAULT_LOCALE);
-       mfx->description->text = strdup(desc_txt);
-
-       return PMINFO_R_OK;
-}
-
-API int pkgmgrinfo_set_author_to_pkgdbinfo(pkgmgrinfo_pkgdbinfo_h handle, const char *author_name,
-               const char *author_email, const char *author_href, const char *locale)
-{
-       manifest_x *mfx = (manifest_x *)handle;
-       author_x *author;
-
-       retvm_if(!handle, PMINFO_R_EINVAL, "Argument supplied is NULL");
-
-       author = calloc(1, sizeof(author_x));
-       retvm_if(author == NULL, PMINFO_R_EINVAL, "Argument supplied is NULL");
-
-       LISTADD(mfx->author, author);
-       if (author_name)
-               mfx->author->text = strdup(author_name);
-       if (author_email)
-               mfx->author->email = strdup(author_email);
-       if (author_href)
-               mfx->author->href = strdup(author_href);
-       if (locale)
-               mfx->author->lang = strdup(locale);
-       else
-               mfx->author->lang = strdup(DEFAULT_LOCALE);
-       return PMINFO_R_OK;
-}
-
-API int pkgmgrinfo_set_removable_to_pkgdbinfo(pkgmgrinfo_pkgdbinfo_h handle, int removable)
-{
-       manifest_x *mfx = (manifest_x *)handle;
-
-       retvm_if(!handle, PMINFO_R_EINVAL, "Argument supplied is NULL");
-       retvm_if((removable < 0) || (removable > 1), PMINFO_R_EINVAL, "Argument supplied is NULL");
-
-       if (mfx->removable)
-               free((void *)mfx->removable);
-
-       if (removable == 0)
-               mfx->removable = strdup("false");
-       else if (removable == 1)
-               mfx->removable = strdup("true");
-
-       return PMINFO_R_OK;
-}
-
-API int pkgmgrinfo_set_preload_to_pkgdbinfo(pkgmgrinfo_pkgdbinfo_h handle, int preload)
-{
-       manifest_x *mfx = (manifest_x *)handle;
-
-       retvm_if(!handle, PMINFO_R_EINVAL, "Argument supplied is NULL");
-       retvm_if((preload < 0) || (preload > 1), PMINFO_R_EINVAL, "Argument supplied is NULL");
-
-       if (mfx->preload)
-               free((void *)mfx->preload);
-
-       if (preload == 0)
-               mfx->preload = strdup("false");
-       else if (preload == 1)
-               mfx->preload = strdup("true");
-
-       return PMINFO_R_OK;
-}
-
-API int pkgmgrinfo_set_installed_storage_to_pkgdbinfo(pkgmgrinfo_pkgdbinfo_h handle, INSTALL_LOCATION location)
-{
-       manifest_x *mfx = (manifest_x *)handle;
-
-       retvm_if(!handle, PMINFO_R_EINVAL, "Argument supplied is NULL");
-       retvm_if((location < 0) || (location > 1), PMINFO_R_EINVAL, "Argument supplied is NULL");
-
-       if (mfx->installed_storage)
-               free((void *)mfx->installed_storage);
-
-       if (location == INSTALL_INTERNAL)
-               mfx->installed_storage = strdup("installed_internal");
-       else if (location == INSTALL_EXTERNAL)
-               mfx->installed_storage = strdup("installed_external");
-
-       return PMINFO_R_OK;
-}
-
-API int pkgmgrinfo_save_pkgdbinfo(pkgmgrinfo_pkgdbinfo_h handle)
-{
        int ret;
-       manifest_x *mfx = (manifest_x *)handle;
-       mfx = (manifest_x *)handle;
-
-       retvm_if(!handle, PMINFO_R_EINVAL, "Argument supplied is NULL");
+       const char *privilege;
+       GList *tmp;
+       pkgmgr_pkginfo_x *info = (pkgmgr_pkginfo_x *)handle;
 
-       ret = pkgmgr_parser_update_manifest_info_in_db(mfx);
-       if (ret == 0) {
-               _LOGE("Successfully stored info in DB\n");
-               return PMINFO_R_OK;
-       } else {
-               _LOGE("Failed to store info in DB\n");
+       if (info->pkg_info == NULL)
                return PMINFO_R_ERROR;
-       }
-}
-
-API int pkgmgrinfo_save_pkgusrdbinfo(pkgmgrinfo_pkgdbinfo_h handle, uid_t uid)
-{
-       int ret;
-       manifest_x *mfx = (manifest_x *)handle;
 
-       retvm_if(!handle, PMINFO_R_EINVAL, "Argument supplied is NULL");
-
-       ret = pkgmgr_parser_update_manifest_info_in_usr_db(mfx, uid);
-       if (ret == 0) {
-               _LOGE("Successfully stored info in DB\n");
-               return PMINFO_R_OK;
-       } else {
-               _LOGE("Failed to store info in DB\n");
-               return PMINFO_R_ERROR;
+       for (tmp = info->pkg_info->privileges; tmp; tmp = tmp->next) {
+               privilege = (const char *)tmp->data;
+               if (privilege == NULL)
+                       continue;
+               ret = privilege_func(privilege, user_data);
+               if (ret < 0)
+                       break;
        }
-}
-
-API int pkgmgrinfo_destroy_pkgdbinfo(pkgmgrinfo_pkgdbinfo_h handle)
-{
-       manifest_x *mfx = (manifest_x *)handle;
-
-       retvm_if(!handle, PMINFO_R_EINVAL, "Argument supplied is NULL");
-
-       pkgmgrinfo_basic_free_package(mfx);
-
        return PMINFO_R_OK;
 }