Implement pkgmgr plugin execution info
[platform/core/appfw/pkgmgr-info.git] / src / pkgmgrinfo_pkginfo.c
index 501fa2b..d7a6a52 100644 (file)
 #include <libgen.h>
 #include <sys/stat.h>
 
-#include <libxml/parser.h>
-#include <libxml/xmlreader.h>
-#include <libxml/xmlschemas.h>
 #include <sqlite3.h>
 #include <glib.h>
 
-#include "pkgmgr_parser.h"
 #include "pkgmgrinfo_basic.h"
 #include "pkgmgrinfo_private.h"
 #include "pkgmgrinfo_debug.h"
 #include "pkgmgr-info.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"))
+       if (str && !strcmp(str, "true"))
                return true;
        else
                return false;
@@ -63,8 +50,8 @@ static bool _get_bool_value(const char *str)
 
 static gint __compare_func(gconstpointer data1, gconstpointer data2)
 {
-       pkgmgrinfo_node_x *node1 = (pkgmgrinfo_node_x*)data1;
-       pkgmgrinfo_node_x *node2 = (pkgmgrinfo_node_x*)data2;
+       pkgmgrinfo_node_x *node1 = (pkgmgrinfo_node_x *)data1;
+       pkgmgrinfo_node_x *node2 = (pkgmgrinfo_node_x *)data2;
        if (node1->prop == node2->prop)
                return 0;
        else if (node1->prop > node2->prop)
@@ -73,10 +60,20 @@ static gint __compare_func(gconstpointer data1, gconstpointer data2)
                return -1;
 }
 
+static gint __pkg_disable_chk_func(gconstpointer data1, gconstpointer data2)
+{
+       pkgmgrinfo_node_x *node = (pkgmgrinfo_node_x *)data1;
+
+       if (node->prop == E_PMINFO_PKGINFO_PROP_PACKAGE_DISABLE)
+               return 0;
+       else
+               return 1;
+}
+
 static void __destroy_each_node(gpointer data, gpointer user_data)
 {
        ret_if(data == NULL);
-       pkgmgrinfo_node_x *node = (pkgmgrinfo_node_x*)data;
+       pkgmgrinfo_node_x *node = (pkgmgrinfo_node_x *)data;
        if (node->value) {
                free(node->value);
                node->value = NULL;
@@ -89,10 +86,20 @@ static void __destroy_each_node(gpointer data, gpointer user_data)
        node = NULL;
 }
 
+static void __destroy_metadata_node(gpointer data)
+{
+       pkgmgrinfo_metadata_node_x *node = (pkgmgrinfo_metadata_node_x *)data;
+       if (node->key)
+               free(node->key);
+       if (node->value)
+               free(node->value);
+       free(node);
+}
+
 static void __cleanup_pkginfo(pkgmgr_pkginfo_x *data)
 {
        ret_if(data == NULL);
-       if (data->locale){
+       if (data->locale) {
                free((void *)data->locale);
                data->locale = NULL;
        }
@@ -103,37 +110,6 @@ static void __cleanup_pkginfo(pkgmgr_pkginfo_x *data)
        return;
 }
 
-static int __child_element(xmlTextReaderPtr reader, int depth)
-{
-       int ret = xmlTextReaderRead(reader);
-       int cur = xmlTextReaderDepth(reader);
-       while (ret == 1) {
-
-               switch (xmlTextReaderNodeType(reader)) {
-               case XML_READER_TYPE_ELEMENT:
-                       if (cur == depth + 1)
-                               return 1;
-                       break;
-               case XML_READER_TYPE_TEXT:
-                       /*text is handled by each function separately*/
-                       if (cur == depth + 1)
-                               return 0;
-                       break;
-               case XML_READER_TYPE_END_ELEMENT:
-                       if (cur == depth)
-                               return 0;
-                       break;
-               default:
-                       if (cur <= depth)
-                               return 0;
-                       break;
-               }
-               ret = xmlTextReaderRead(reader);
-               cur = xmlTextReaderDepth(reader);
-       }
-       return ret;
-}
-
 long long _pkgmgr_calculate_dir_size(char *dirname)
 {
        long long total = 0;
@@ -141,679 +117,1017 @@ 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;
        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;
+       if (dp == NULL) {
+               _LOGE("Couldn't open the directory\n");
+               return -1;
+       }
+
+       for (ep = readdir(dp); ep != NULL; ep = readdir(dp)) {
+               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 {
-               _LOGE("Couldn't open the directory\n");
-               return -1;
        }
+       (void)closedir(dp);
        return total;
 
 }
 
-static gint __list_strcmp(gconstpointer a, gconstpointer b)
+static int _pkginfo_add_description_info_into_list(const char *locale,
+               char *record, GList **description)
 {
-       return strcmp((char *)a, (char *)b);
+       description_x *info;
+
+       info = calloc(1, sizeof(description_x));
+       if (info == NULL) {
+               LOGE("out of memory");
+               return PMINFO_R_ERROR;
+       }
+       info->lang = strdup(locale);
+       info->text = record;
+       *description = g_list_append(*description, info);
+
+       return PMINFO_R_OK;
 }
 
-static int _pkginfo_get_list(sqlite3 *db, const char *locale,
-               pkgmgrinfo_filter_x *filter, GList **list)
+static int _pkginfo_get_plugin_execution_info(sqlite3 *db, const char *pkgid,
+               GList **plugins)
 {
        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";
+               "SELECT appid, plugin_type, plugin_name FROM package_plugin_info "
+               "WHERE pkgid=%Q";
        int ret;
        char *query;
-       char *query_localized;
        sqlite3_stmt *stmt;
-       char *pkgid = NULL;
+       plugin_x *plugin;
 
-       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;
+       query = sqlite3_mprintf(query_raw, pkgid);
+       if (query == NULL) {
+               LOGE("out of memory");
+               return PMINFO_R_ERROR;
+       }
 
-       ret = sqlite3_prepare_v2(db, query_localized,
-                       strlen(query_localized), &stmt, NULL);
-       sqlite3_free(query_localized);
+       ret = sqlite3_prepare_v2(db, query, strlen(query),
+                       &stmt, NULL);
+       sqlite3_free(query);
        if (ret != SQLITE_OK) {
                LOGE("prepare failed: %s", sqlite3_errmsg(db));
-               return -1;
+               return PMINFO_R_ERROR;
        }
 
        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);
+               plugin = calloc(1, sizeof(plugin_x));
+               if (!plugin) {
+                       LOGE("out of memory");
+                       sqlite3_finalize(stmt);
+                       return PMINFO_R_ERROR;
+               }
+               plugin->pkgid = strdup(pkgid);
+               _save_column_str(stmt, 0, &plugin->appid);
+               _save_column_str(stmt, 1, &plugin->plugin_type);
+               _save_column_str(stmt, 2, &plugin->plugin_name);
+               *plugins = g_list_append(*plugins,
+                               (gpointer)plugin);
        }
 
        sqlite3_finalize(stmt);
 
-       return 0;
+       return PMINFO_R_OK;
 }
 
-static int _pkginfo_get_filtered_list(pkgmgrinfo_filter_x *filter, uid_t uid,
-               GList **list)
+static int _pkginfo_get_privilege(sqlite3 *db, const char *pkgid,
+               GList **privileges)
 {
+       static const char query_raw[] =
+               "SELECT DISTINCT privilege, type FROM package_privilege_info "
+               "WHERE package=%Q";
        int ret;
-       sqlite3 *db;
-       const char *dbpath;
-       char *locale;
-       GList *tmp;
-       GList *tmp2;
-
-       locale = _get_system_locale();
-       if (locale == NULL)
-               return PMINFO_R_ERROR;
+       char *query;
+       sqlite3_stmt *stmt;
+       privilege_x *privilege;
 
-       dbpath = getUserPkgParserDBPathUID(uid);
-       if (dbpath == NULL) {
-               free(locale);
+       query = sqlite3_mprintf(query_raw, pkgid);
+       if (query == NULL) {
+               LOGE("out of memory");
                return PMINFO_R_ERROR;
        }
 
-       ret = sqlite3_open_v2(dbpath, &db, SQLITE_OPEN_READONLY, NULL);
+       ret = sqlite3_prepare_v2(db, query, strlen(query),
+                       &stmt, NULL);
+       sqlite3_free(query);
        if (ret != SQLITE_OK) {
-               _LOGE("failed to open db: %d", ret);
-               free(locale);
+               LOGE("prepare failed: %s", sqlite3_errmsg(db));
                return PMINFO_R_ERROR;
        }
 
-       if (_pkginfo_get_list(db, locale, filter, list)) {
-               free(locale);
-               sqlite3_close_v2(db);
-               return PMINFO_R_ERROR;
+       while (sqlite3_step(stmt) == SQLITE_ROW) {
+               privilege = calloc(1, sizeof(privilege_x));
+               _save_column_str(stmt, 0, &privilege->value);
+               _save_column_str(stmt, 1, &privilege->type);
+               *privileges = g_list_append(*privileges,
+                               (gpointer)privilege);
        }
-       sqlite3_close_v2(db);
 
-       if (uid == GLOBAL_USER) {
-               free(locale);
-               return PMINFO_R_OK;
-       }
+       sqlite3_finalize(stmt);
 
-       /* search again from global */
-       dbpath = getUserPkgParserDBPathUID(GLOBAL_USER);
-       if (dbpath == NULL) {
-               free(locale);
-               return PMINFO_R_ERROR;
-       }
+       return PMINFO_R_OK;
+}
 
-       ret = sqlite3_open_v2(dbpath, &db, SQLITE_OPEN_READONLY, NULL);
-       if (ret != SQLITE_OK) {
-               _LOGE("failed to open db: %d", ret);
-               free(locale);
+static int _pkginfo_get_appdefined_privilege(sqlite3 *db, const char *pkgid,
+               GList **privileges)
+{
+       static const char query_raw[] =
+               "SELECT DISTINCT privilege, license, type FROM "
+               "package_appdefined_privilege_info WHERE package=%Q";
+       int ret;
+       char *query;
+       sqlite3_stmt *stmt;
+       appdefined_privilege_x *privilege;
+
+       query = sqlite3_mprintf(query_raw, pkgid);
+       if (query == NULL) {
+               LOGE("out of memory");
                return PMINFO_R_ERROR;
        }
 
-       if (_pkginfo_get_list(db, locale, filter, list)) {
-               free(locale);
-               sqlite3_close_v2(db);
+       ret = sqlite3_prepare_v2(db, query, strlen(query),
+                       &stmt, NULL);
+       sqlite3_free(query);
+       if (ret != SQLITE_OK) {
+               LOGE("prepare failed: %s", sqlite3_errmsg(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, tmp2 = g_list_next(tmp); tmp;
-                       tmp = tmp2, tmp2 = g_list_next(tmp)) {
-               if (tmp->prev == NULL || tmp->data == NULL)
-                       continue;
-               if (strcmp((const char *)tmp->prev->data,
-                                       (const char *)tmp->data) == 0)
-                       *list = g_list_delete_link(*list, tmp);
+       while (sqlite3_step(stmt) == SQLITE_ROW) {
+               privilege = calloc(1, sizeof(appdefined_privilege_x));
+               if (!privilege) {
+                       LOGE("failed to alloc memory");
+                       sqlite3_finalize(stmt);
+                       return PMINFO_R_ERROR;
+               }
+               _save_column_str(stmt, 0, &privilege->value);
+               _save_column_str(stmt, 1, &privilege->license);
+               _save_column_str(stmt, 2, &privilege->type);
+               *privileges = g_list_append(*privileges,
+                               (gpointer)privilege);
        }
 
-       free(locale);
+       sqlite3_finalize(stmt);
 
        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)
+static int _pkginfo_get_dependency(sqlite3 *db, const char *pkgid,
+               GList **dependencies)
 {
+       static const char query[] =
+               "SELECT DISTINCT depends_on, type, required_version "
+               "FROM package_dependency_info WHERE package=?";
        int ret;
-       pkgmgr_pkginfo_x *info;
-       GList *list = NULL;
-       GList *tmp;
-       char *pkgid;
-       int stop = 0;
+       sqlite3_stmt *stmt;
+       dependency_x *dependency;
 
-       ret = _pkginfo_get_filtered_list(filter, uid, &list);
-       if (ret != PMINFO_R_OK)
+       ret = sqlite3_prepare_v2(db, query, strlen(query), &stmt, NULL);
+       if (ret != SQLITE_OK) {
+               LOGE("prepare failed: %s", sqlite3_errmsg(db));
                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);
-                               continue;
-                       }
-                       if (pkg_list_cb(info, user_data) < 0)
-                               stop = 1;
-                       pkgmgrinfo_pkginfo_destroy_pkginfo(info);
+       while (sqlite3_step(stmt) == SQLITE_ROW) {
+               dependency = calloc(1, sizeof(dependency_x));
+               if (!dependency) {
+                       LOGE("failed to alloc memory");
+                       sqlite3_finalize(stmt);
+                       return PMINFO_R_ERROR;
                }
-               free(pkgid);
+               _save_column_str(stmt, 0, &dependency->depends_on);
+               _save_column_str(stmt, 1, &dependency->type);
+               _save_column_str(stmt, 2, &dependency->required_version);
+               *dependencies = g_list_append(*dependencies,
+                               (gpointer)dependency);
        }
 
-       g_list_free(list);
+       sqlite3_finalize(stmt);
 
        return PMINFO_R_OK;
 }
 
-API int pkgmgrinfo_pkginfo_get_usr_list(pkgmgrinfo_pkg_list_cb pkg_list_cb,
-               void *user_data, uid_t uid)
+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, uid_t uid, char **query, GList **bind_params)
 {
-       if (pkg_list_cb == NULL) {
-               LOGE("invalid parameter");
-               return PMINFO_R_EINVAL;
+       int joined = 0;
+       char buf[MAX_QUERY_LEN] = { '\0' };
+       char buf2[MAX_QUERY_LEN] = { '\0' };
+       char *condition = NULL;
+       GSList *list = NULL;
+
+       if (filter == NULL)
+               return PMINFO_R_OK;
+
+       snprintf(buf, sizeof(buf), "%s", " WHERE 1=1 ");
+       for (list = filter->list; list; list = list->next) {
+               joined |= __get_filter_condition(list->data, uid, &condition,
+                               bind_params);
+               if (condition == NULL)
+                       continue;
+
+               strncat(buf, " AND ", sizeof(buf) - strlen(buf) - 1);
+
+               strncat(buf, condition, sizeof(buf) - strlen(buf) - 1);
+               free(condition);
+               condition = NULL;
        }
 
-       return _pkginfo_get_filtered_foreach_pkginfo(NULL, pkg_list_cb,
-                       user_data, uid);
+       if (joined & E_PMINFO_PKGINFO_JOIN_LOCALIZED_INFO) {
+               strncat(buf2, join_localized_info, sizeof(buf2) - strlen(buf2) - 1);
+               *bind_params = g_list_append(*bind_params, strdup(locale));
+       }
+       if (joined & E_PMINFO_PKGINFO_JOIN_PRIVILEGE_INFO)
+               strncat(buf2, join_privilege_info, sizeof(buf2) - strlen(buf2) - 1);
+       strncat(buf2, buf, sizeof(buf2) - strlen(buf2) - 1);
+
+       *query = strdup(buf2);
+       if (*query == NULL)
+               return PMINFO_R_ERROR;
+
+       return PMINFO_R_OK;
 }
 
-API int pkgmgrinfo_pkginfo_get_list(pkgmgrinfo_pkg_list_cb pkg_list_cb, void *user_data)
+static void __free_packages(gpointer data)
 {
-       return pkgmgrinfo_pkginfo_get_usr_list(pkg_list_cb, user_data, GLOBAL_USER);
+       pkgmgrinfo_basic_free_package((package_x *)data);
 }
 
-static int _pkginfo_get_author(sqlite3 *db, const char *pkgid,
-               GList **author)
+static bool __check_disable_filter_exist(pkgmgrinfo_filter_x *filter)
 {
-       static const char query_raw[] =
-               "SELECT author_name, author_email, author_href "
-               "FROM package_info WHERE package=%Q";
-       int ret;
-       char *query;
-       sqlite3_stmt *stmt;
-       int idx = 0;
-       author_x *info;
-
-       query = sqlite3_mprintf(query_raw, pkgid);
-       if (query == NULL) {
-               LOGE("out of memory");
-               return PMINFO_R_ERROR;
-       }
+       GSList *link;
 
-       ret = sqlite3_prepare_v2(db, query, strlen(query),
-                       &stmt, NULL);
-       sqlite3_free(query);
-       if (ret != SQLITE_OK) {
-               LOGE("prepare failed: %s", sqlite3_errmsg(db));
-               return PMINFO_R_ERROR;
-       }
+       if (filter == NULL)
+               return false;
 
-       if (sqlite3_step(stmt) == SQLITE_ERROR) {
-               LOGE("step error: %s", sqlite3_errmsg(db));
-               sqlite3_finalize(stmt);
-               return PMINFO_R_ERROR;
-       }
+       link = g_slist_find_custom(filter->list, NULL, __pkg_disable_chk_func);
+       if (link)
+               return true;
 
-       /* one author per one package */
-       info = calloc(1, sizeof(author_x));
-       if (info == NULL) {
-               LOGE("out of memory");
-               sqlite3_finalize(stmt);
-               return PMINFO_R_ERROR;
-       }
+       return false;
+}
 
-       _save_column_str(stmt, idx++, &info->text);
-       _save_column_str(stmt, idx++, &info->email);
-       _save_column_str(stmt, idx++, &info->href);
+static int __bind_params(sqlite3_stmt *stmt, GList *params)
+{
+       GList *tmp_list = NULL;
+       int idx = 0;
+       int ret;
 
-       /* TODO: revised */
-       *author = g_list_append(*author, info);
+       if (stmt == NULL || params == NULL)
+               return PMINFO_R_EINVAL;
 
-       sqlite3_finalize(stmt);
+       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_label(sqlite3 *db, const char *pkgid,
-               const char *locale, GList **label)
+static bool __check_package_storage_status(pkgmgrinfo_filter_x *tmp_filter)
+{
+       GSList *tmp_list = NULL;
+       pkgmgrinfo_node_x *tmp_node = NULL;
+       int property = -1;
+
+       property = _pminfo_pkginfo_convert_to_prop_bool(PMINFO_PKGINFO_PROP_PACKAGE_CHECK_STORAGE);
+       for (tmp_list = tmp_filter->list; tmp_list != NULL;
+                       tmp_list = g_slist_next(tmp_list)) {
+               tmp_node = (pkgmgrinfo_node_x *)tmp_list->data;
+               if (property == tmp_node->prop) {
+                       if (strcmp(tmp_node->value, "true") == 0)
+                               return true;
+                       else
+                               return false;
+               }
+       }
+       return true;
+}
+
+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 package_label, package_locale "
-               "FROM package_localized_info "
-               "WHERE package=%Q AND package_locale IN (%Q, %Q)";
-       int ret;
-       char *query;
-       sqlite3_stmt *stmt;
-       int idx;
-       label_x *info;
+               "SELECT DISTINCT pi.package, pi.installed_storage, pi.external_path";
+       static const char query_basic[] =
+               ", 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.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, pi.package_support_mode";
+       static const char query_author[] =
+               ", pi.author_name, pi.author_email, pi.author_href";
+       static const char query_label[] =
+               ", COALESCE("
+               "(SELECT package_label FROM package_localized_info WHERE pi.package=package AND package_locale=?), "
+               "(SELECT package_label FROM package_localized_info WHERE pi.package=package AND package_locale='No Locale'))";
+       static const char query_icon[] =
+               ", COALESCE("
+               "(SELECT package_icon FROM package_localized_info WHERE pi.package=package AND package_locale=?), "
+               "(SELECT package_icon FROM package_localized_info WHERE pi.package=package AND package_locale='No Locale'))";
+       static const char query_description[] =
+               ", COALESCE("
+               "(SELECT package_description FROM package_localized_info WHERE pi.package=package AND package_locale=?), "
+               "(SELECT package_description FROM package_localized_info WHERE pi.package=package AND package_locale='No Locale'))";
+       static const char query_from_clause[] = " FROM package_info as pi";
+       int ret = PMINFO_R_ERROR;
+       int idx = 0;
+       char *dbpath;
+       char *tmp_record = NULL;
+       char *constraints = NULL;
+       char query[MAX_QUERY_LEN] = { '\0' };
+       package_x *info = NULL;
+       author_x *author = NULL;
+       GList *bind_params = NULL;
+       sqlite3 *db;
+       sqlite3_stmt *stmt = NULL;
+       pkgmgrinfo_filter_x *tmp_filter = NULL;
+       bool is_check_storage = true;
+       const uid_t global_user_uid = GLOBAL_USER;
 
-       query = sqlite3_mprintf(query_raw, pkgid, locale, DEFAULT_LOCALE);
-       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 = __open_db(dbpath, &db, SQLITE_OPEN_READONLY);
        if (ret != SQLITE_OK) {
-               LOGE("prepare failed: %s", sqlite3_errmsg(db));
+               _LOGD("failed to open db(%s): %d", dbpath, ret);
+               free(dbpath);
                return PMINFO_R_ERROR;
        }
+       free(dbpath);
 
-       while (sqlite3_step(stmt) == SQLITE_ROW) {
-               info = calloc(1, sizeof(label_x));
-               if (info == NULL) {
-                       LOGE("out of memory");
-                       sqlite3_finalize(stmt);
+       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;
                }
-               idx = 0;
-               _save_column_str(stmt, idx++, &info->text);
-               _save_column_str(stmt, idx++, &info->lang);
-               *label = g_list_append(*label, info);
        }
 
-       sqlite3_finalize(stmt);
+       is_check_storage = __check_package_storage_status(tmp_filter);
 
-       return PMINFO_R_OK;
-}
+       snprintf(query, MAX_QUERY_LEN - 1, "%s", query_raw);
+       if (flag & PMINFO_APPINFO_GET_BASICINFO)
+               strncat(query, query_basic, sizeof(query) - strlen(query) - 1);
+       if (flag & PMINFO_PKGINFO_GET_AUTHOR)
+               strncat(query, query_author, sizeof(query) - strlen(query) - 1);
+       if (flag & PMINFO_PKGINFO_GET_LABEL) {
+               strncat(query, query_label, sizeof(query) - strlen(query) - 1);
+               bind_params = g_list_append(bind_params, strdup(locale));
+       }
+       if (flag & PMINFO_PKGINFO_GET_ICON) {
+               strncat(query, query_icon, sizeof(query) - strlen(query) - 1);
+               bind_params = g_list_append(bind_params, strdup(locale));
+       }
+       if (flag & PMINFO_PKGINFO_GET_DESCRIPTION) {
+               strncat(query, query_description, sizeof(query) - strlen(query) - 1);
+               bind_params = g_list_append(bind_params, strdup(locale));
+       }
 
-static int _pkginfo_get_icon(sqlite3 *db, const char *pkgid, const char *locale,
-               GList **icon)
-{
-       static const char query_raw[] =
-               "SELECT package_icon, package_locale "
-               "FROM package_localized_info "
-               "WHERE package=%Q AND package_locale IN (%Q, %Q)";
-       int ret;
-       char *query;
-       sqlite3_stmt *stmt;
-       int idx;
-       icon_x *info;
+       strncat(query, query_from_clause, sizeof(query) - strlen(query) - 1);
 
-       query = sqlite3_mprintf(query_raw, pkgid, locale, DEFAULT_LOCALE);
-       if (query == NULL) {
-               LOGE("out of memory");
-               return PMINFO_R_ERROR;
+       ret = _get_filtered_query(tmp_filter, locale, uid, &constraints, &bind_params);
+       if (ret != PMINFO_R_OK) {
+               LOGE("Failed to get WHERE clause");
+               goto catch;
        }
 
-       ret = sqlite3_prepare_v2(db, query, strlen(query),
-                       &stmt, NULL);
-       sqlite3_free(query);
+       if (constraints)
+               strncat(query, constraints, sizeof(query) - strlen(query) - 1);
+
+       ret = sqlite3_prepare_v2(db, query, strlen(query), &stmt, NULL);
        if (ret != SQLITE_OK) {
                LOGE("prepare failed: %s", sqlite3_errmsg(db));
-               return PMINFO_R_ERROR;
+               ret = PMINFO_R_ERROR;
+               goto catch;
+       }
+
+       ret = __bind_params(stmt, bind_params);
+       if (ret != SQLITE_OK) {
+               LOGE("Failed to bind parameters");
+               goto catch;
        }
 
        while (sqlite3_step(stmt) == SQLITE_ROW) {
-               info = calloc(1, sizeof(icon_x));
+               info = calloc(1, sizeof(package_x));
                if (info == NULL) {
                        LOGE("out of memory");
-                       sqlite3_finalize(stmt);
-                       return PMINFO_R_ERROR;
+                       ret = PMINFO_R_ERROR;
+                       goto catch;
                }
                idx = 0;
-               _save_column_str(stmt, idx++, &info->text);
-               _save_column_str(stmt, idx++, &info->lang);
-               *icon = g_list_append(*icon, info);
+               _save_column_str(stmt, idx++, &info->package);
+               _save_column_str(stmt, idx++, &info->installed_storage);
+               _save_column_str(stmt, idx++, &info->external_path);
+
+               if (flag & PMINFO_APPINFO_GET_BASICINFO) {
+                       _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->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);
+                       _save_column_str(stmt, idx++, &info->support_mode);
+               }
+
+               info->for_all_users =
+                       strdup((uid != global_user_uid) ? "false" : "true");
+
+               if (_pkginfo_get_plugin_execution_info(db, info->package, &info->plugin)) {
+                       ret = PMINFO_R_ERROR;
+                       goto catch;
+               }
+
+               if (flag & PMINFO_PKGINFO_GET_AUTHOR) {
+                       /* TODO : author should be retrieved at package_localized_info */
+                       author = calloc(1, sizeof(author_x));
+                       if (author == NULL) {
+                               ret = PMINFO_R_ERROR;
+                               goto catch;
+                       }
+                       _save_column_str(stmt, idx++, &author->text);
+                       _save_column_str(stmt, idx++, &author->email);
+                       _save_column_str(stmt, idx++, &author->href);
+                       info->author = g_list_append(info->author, author);
+               }
+
+               if (flag & PMINFO_PKGINFO_GET_LABEL) {
+                       tmp_record = NULL;
+                       _save_column_str(stmt, idx++, &tmp_record);
+
+                       if (_add_label_info_into_list(locale, tmp_record, &info->label)) {
+                               ret = PMINFO_R_ERROR;
+                               goto catch;
+                       }
+               }
+
+               if (flag & PMINFO_PKGINFO_GET_ICON) {
+                       tmp_record = NULL;
+                       _save_column_str(stmt, idx++, &tmp_record);
+                       if (_add_icon_info_into_list(locale, tmp_record, &info->icon)) {
+                               ret = PMINFO_R_ERROR;
+                               goto catch;
+                       }
+               }
+
+               if (flag & PMINFO_PKGINFO_GET_DESCRIPTION) {
+                       tmp_record = NULL;
+                       _save_column_str(stmt, idx++, &tmp_record);
+                       if (_pkginfo_add_description_info_into_list(locale, tmp_record,
+                                       &info->description)) {
+                               ret = PMINFO_R_ERROR;
+                               goto catch;
+                       }
+               }
+
+               if (flag & PMINFO_PKGINFO_GET_PRIVILEGE) {
+                       if (_pkginfo_get_privilege(db, info->package,
+                                               &info->privileges)) {
+                               ret = PMINFO_R_ERROR;
+                               goto catch;
+                       }
+               }
+
+               if (flag & PMINFO_PKGINFO_GET_APPDEFINED_PRIVILEGE) {
+                       if (_pkginfo_get_appdefined_privilege(db, info->package,
+                                               &info->appdefined_privileges)) {
+                               ret = PMINFO_R_ERROR;
+                               goto catch;
+                       }
+               }
+
+               if (flag & PMINFO_PKGINFO_GET_DEPENDENCY) {
+                       if (_pkginfo_get_dependency(db, info->package,
+                                               &info->dependencies)) {
+                               ret = PMINFO_R_ERROR;
+                               goto catch;
+                       }
+               }
+
+               if (is_check_storage &&
+                               __pkginfo_check_installed_storage(info) != PMINFO_R_OK) {
+                       ret = PMINFO_R_ERROR;
+                       pkgmgrinfo_basic_free_package(info);
+                       info = NULL;
+                       continue;
+               }
+
+               g_hash_table_insert(packages, (gpointer)info->package,
+                               (gpointer)info);
        }
 
+       ret = PMINFO_R_OK;
+
+catch:
        sqlite3_finalize(stmt);
+       sqlite3_close_v2(db);
 
-       return PMINFO_R_OK;
+       if (constraints)
+               free(constraints);
+
+       if (ret != PMINFO_R_OK && info != NULL)
+               pkgmgrinfo_basic_free_package(info);
+
+       if (filter == NULL)
+               pkgmgrinfo_pkginfo_filter_destroy(tmp_filter);
+
+       g_list_free_full(bind_params, free);
+
+       return ret;
 }
 
-static int _pkginfo_get_description(sqlite3 *db, const char *pkgid,
-               const char *locale, GList **description)
+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)
 {
-       static const char query_raw[] =
-               "SELECT package_description, package_locale "
-               "FROM package_localized_info "
-               "WHERE package=%Q AND package_locale IN (%Q, %Q)";
        int ret;
-       char *query;
-       sqlite3_stmt *stmt;
-       int idx;
-       description_x *info;
+       char *locale;
+       package_x *pkg;
+       pkgmgr_pkginfo_x info;
+       pkgmgrinfo_filter_x *tmp_filter = NULL;
+       GHashTable *list;
+       GHashTableIter iter;
+       gpointer value;
 
-       query = sqlite3_mprintf(query_raw, pkgid, locale, DEFAULT_LOCALE);
-       if (query == NULL) {
-               LOGE("out of memory");
+       locale = _get_system_locale();
+       if (locale == NULL)
                return PMINFO_R_ERROR;
-       }
 
-       ret = sqlite3_prepare_v2(db, query, strlen(query),
-                       &stmt, NULL);
-       sqlite3_free(query);
-       if (ret != SQLITE_OK) {
-               LOGE("prepare failed: %s", sqlite3_errmsg(db));
+       list = g_hash_table_new_full(g_str_hash, g_str_equal, NULL,
+                       __free_packages);
+       if (list == NULL) {
+               free(locale);
                return PMINFO_R_ERROR;
        }
 
-       while (sqlite3_step(stmt) == SQLITE_ROW) {
-               info = calloc(1, sizeof(description_x));
-               if (info == NULL) {
-                       LOGE("out of memory");
-                       sqlite3_finalize(stmt);
+       if (filter != NULL) {
+               tmp_filter = (pkgmgrinfo_filter_x *)filter;
+       } else {
+               ret = pkgmgrinfo_pkginfo_filter_create((void *)&tmp_filter);
+               if (ret != PMINFO_R_OK) {
+                       _LOGE("Failed to create filter");
+                       g_hash_table_destroy(list);
+                       free(locale);
                        return PMINFO_R_ERROR;
                }
-               idx = 0;
-               _save_column_str(stmt, idx++, &info->text);
-               _save_column_str(stmt, idx++, &info->lang);
-               *description = g_list_append(*description, info);
        }
 
-       sqlite3_finalize(stmt);
+       if (__check_disable_filter_exist(tmp_filter) == false) {
+               ret = pkgmgrinfo_pkginfo_filter_add_bool(tmp_filter,
+                               PMINFO_PKGINFO_PROP_PACKAGE_DISABLE, false);
+               if (ret != PMINFO_R_OK) {
+                       _LOGE("Failed to add filter");
+                       g_hash_table_destroy(list);
+                       free(locale);
+                       if (filter == NULL)
+                               pkgmgrinfo_pkginfo_filter_destroy(tmp_filter);
+                       return PMINFO_R_ERROR;
+               }
+       }
+
+       ret = _pkginfo_get_packages(uid, locale, tmp_filter,
+                       flag | PMINFO_PKGINFO_GET_BASICINFO, list);
+       if (ret == PMINFO_R_OK && uid != GLOBAL_USER)
+               ret = _pkginfo_get_packages(GLOBAL_USER, locale, tmp_filter,
+                               flag | PMINFO_PKGINFO_GET_BASICINFO, list);
+
+       if (ret != PMINFO_R_OK) {
+               g_hash_table_destroy(list);
+               free(locale);
+               if (filter == NULL)
+                       pkgmgrinfo_pkginfo_filter_destroy(tmp_filter);
+               return PMINFO_R_ERROR;
+       }
+
+       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);
+
+       if (filter == NULL)
+               pkgmgrinfo_pkginfo_filter_destroy(tmp_filter);
 
        return PMINFO_R_OK;
 }
 
-static int _pkginfo_get_privilege(sqlite3 *db, const char *pkgid,
-               GList **privileges)
+static int _pkgmgrinfo_get_pkginfo(const char *pkgid, uid_t uid,
+       pkgmgrinfo_pkginfo_filter_h filter, pkgmgrinfo_pkginfo_h *handle)
 {
-       static const char query_raw[] =
-               "SELECT privilege FROM package_privilege_info WHERE package=%Q";
        int ret;
-       char *query;
-       sqlite3_stmt *stmt;
-       const char *privilege;
+       char *locale;
+       GHashTable *list;
+       pkgmgr_pkginfo_x *info;
 
-       query = sqlite3_mprintf(query_raw, pkgid);
-       if (query == NULL) {
-               LOGE("out of memory");
-               return PMINFO_R_ERROR;
+       if (pkgid == NULL || filter == NULL || handle == NULL) {
+                       LOGE("invalid parameter");
+                       return PMINFO_R_EINVAL;
        }
 
-       ret = sqlite3_prepare_v2(db, query, strlen(query),
-                       &stmt, NULL);
-       sqlite3_free(query);
-       if (ret != SQLITE_OK) {
-               LOGE("prepare failed: %s", sqlite3_errmsg(db));
+       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;
        }
 
-       while (sqlite3_step(stmt) == SQLITE_ROW) {
-               privilege = NULL;
-               _save_column_str(stmt, 0, &privilege);
-               if (privilege)
-                       *privileges = g_list_append(*privileges,
-                                       (gpointer)privilege);
+       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);
+
+       if (ret != PMINFO_R_OK) {
+               g_hash_table_destroy(list);
+               free(locale);
+               return ret;
        }
 
-       sqlite3_finalize(stmt);
+       if (!g_hash_table_size(list)) {
+               _LOGD("pkginfo for [%s] is not existed for user [%d]",
+                               pkgid, uid);
+               g_hash_table_destroy(list);
+               free(locale);
+               return PMINFO_R_ENOENT;
+       }
 
-       return PMINFO_R_OK;
+       info = calloc(1, sizeof(pkgmgr_pkginfo_x));
+       if (info == NULL) {
+               _LOGE("out of memory");
+               g_hash_table_destroy(list);
+               free(locale);
+               return PMINFO_R_ERROR;
+       }
+
+       info->uid = uid;
+       info->pkg_info = (package_x *)g_hash_table_lookup(list, pkgid);
+       info->locale = locale;
+
+       /* just free list only */
+       g_hash_table_steal(list, (gconstpointer)pkgid);
+       g_hash_table_destroy(list);
+
+       *handle = info;
+
+       return ret;
 }
 
-static char *_get_filtered_query(const char *query_raw,
-               pkgmgrinfo_filter_x *filter)
+API int pkgmgrinfo_pkginfo_get_usr_pkginfo(const char *pkgid, uid_t uid,
+               pkgmgrinfo_pkginfo_h *handle)
 {
-       char buf[MAX_QUERY_LEN] = { 0, };
-       char *condition;
-       size_t len;
-       GSList *list;
-       GSList *head = NULL;
+       int ret;
+       pkgmgrinfo_pkginfo_filter_h filter;
 
-       if (filter)
-               head = filter->list;
+       if (pkgid == NULL || handle == NULL) {
+               LOGE("invalid parameter");
+               return PMINFO_R_EINVAL;
+       }
 
-       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);
-               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(condition);
-               strncat(buf, condition, sizeof(buf) - len - 1);
-               free(condition);
-               condition = NULL;
+       ret = pkgmgrinfo_pkginfo_filter_create(&filter);
+       if (ret != PMINFO_R_OK)
+               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);
+               return PMINFO_R_ERROR;
+       }
+
+       ret = pkgmgrinfo_pkginfo_filter_add_bool(filter,
+                       PMINFO_PKGINFO_PROP_PACKAGE_DISABLE, false);
+       if (ret != PMINFO_R_OK) {
+               pkgmgrinfo_pkginfo_filter_destroy(filter);
+               return PMINFO_R_ERROR;
        }
 
-       return strdup(buf);
+       ret = _pkgmgrinfo_get_pkginfo(pkgid, uid, filter, handle);
+       pkgmgrinfo_pkginfo_filter_destroy(filter);
+
+       return ret;
+}
+
+API int pkgmgrinfo_pkginfo_get_pkginfo(const char *pkgid,
+               pkgmgrinfo_pkginfo_h *handle)
+{
+       return pkgmgrinfo_pkginfo_get_usr_pkginfo(pkgid, _getuid(), handle);
 }
 
-static int _pkginfo_get_package(sqlite3 *db, const char *pkgid,
-               const char *locale, package_x **package)
+API int pkgmgrinfo_pkginfo_get_usr_disabled_pkginfo(const char *pkgid,
+               uid_t uid, pkgmgrinfo_pkginfo_h *handle)
 {
-       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, package_tep_name "
-               "FROM package_info WHERE package=%Q";
        int ret;
-       char *query;
-       sqlite3_stmt *stmt;
-       int idx;
-       package_x *info;
+       char *locale;
+       GHashTable *list;
+       pkgmgrinfo_pkginfo_filter_h filter;
+       pkgmgr_pkginfo_x *info;
 
-       query = sqlite3_mprintf(query_raw, pkgid);
-       if (query == NULL) {
-               LOGE("out of memory");
-               return PMINFO_R_ERROR;
+       if (pkgid == NULL || handle == NULL) {
+               LOGE("invalid parameter");
+               return PMINFO_R_EINVAL;
        }
 
-       ret = sqlite3_prepare_v2(db, query, strlen(query),
-                       &stmt, NULL);
-       sqlite3_free(query);
-       if (ret != SQLITE_OK) {
-               LOGE("prepare failed: %s", sqlite3_errmsg(db));
+       locale = _get_system_locale();
+       if (locale == NULL)
                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;
+       ret = pkgmgrinfo_pkginfo_filter_create(&filter);
+       if (ret != PMINFO_R_OK) {
+               free(locale);
+               return ret;
        }
 
-       info = calloc(1, sizeof(package_x));
-       if (info == NULL) {
-               LOGE("out of memory");
-               sqlite3_finalize(stmt);
+       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;
        }
-       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);
-       _save_column_str(stmt, idx++, &info->tep_name);
-
-       if (_pkginfo_get_author(db, info->package, &info->author)) {
-               pkgmgrinfo_basic_free_package(info);
-               sqlite3_finalize(stmt);
+
+       ret = pkgmgrinfo_pkginfo_filter_add_bool(filter,
+                       PMINFO_PKGINFO_PROP_PACKAGE_DISABLE, true);
+       if (ret != PMINFO_R_OK) {
+               pkgmgrinfo_pkginfo_filter_destroy(filter);
+               free(locale);
                return PMINFO_R_ERROR;
        }
 
-       if (_pkginfo_get_label(db, info->package, locale, &info->label)) {
-               pkgmgrinfo_basic_free_package(info);
-               sqlite3_finalize(stmt);
+       list = g_hash_table_new_full(g_str_hash, g_str_equal, NULL,
+                       __free_packages);
+       if (list == NULL) {
+               pkgmgrinfo_pkginfo_filter_destroy(filter);
+               free(locale);
                return PMINFO_R_ERROR;
        }
 
-       if (_pkginfo_get_icon(db, info->package, locale, &info->icon)) {
-               pkgmgrinfo_basic_free_package(info);
-               sqlite3_finalize(stmt);
-               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 (_pkginfo_get_description(db, info->package, locale,
-                               &info->description)) {
-               pkgmgrinfo_basic_free_package(info);
-               sqlite3_finalize(stmt);
-               return PMINFO_R_ERROR;
+       if (!g_hash_table_size(list)) {
+               _LOGD("disabled pkginfo for [%s] is not existed for user [%d]",
+                               pkgid, uid);
+               g_hash_table_destroy(list);
+               free(locale);
+               return PMINFO_R_ENOENT;
        }
 
-       if (_pkginfo_get_privilege(db, info->package, &info->privileges)) {
-               pkgmgrinfo_basic_free_package(info);
-               sqlite3_finalize(stmt);
+       info = calloc(1, sizeof(pkgmgr_pkginfo_x));
+       if (info == NULL) {
+               _LOGE("out of memory");
+               g_hash_table_destroy(list);
+               free(locale);
                return PMINFO_R_ERROR;
        }
 
-       *package = info;
-       sqlite3_finalize(stmt);
+       info->uid = uid;
+       info->pkg_info = (package_x *)g_hash_table_lookup(list, pkgid);
+       info->locale = locale;
 
-       return PMINFO_R_OK;
+       /* just free list only */
+       g_hash_table_steal(list, (gconstpointer)pkgid);
+       g_hash_table_destroy(list);
+
+       *handle = info;
+
+       return ret;
 }
 
-static int _pkginfo_get_pkginfo(const char *pkgid, uid_t uid,
-               pkgmgr_pkginfo_x **pkginfo)
+API int pkgmgrinfo_pkginfo_get_usr_all_pkginfo(const char *pkgid, uid_t uid,
+               pkgmgrinfo_pkginfo_h *handle)
 {
+
        int ret;
-       sqlite3 *db;
-       const char *dbpath;
-       char *locale;
-       pkgmgr_pkginfo_x *info;
+       pkgmgrinfo_pkginfo_filter_h filter;
 
-       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 = pkgmgrinfo_pkginfo_filter_create(&filter);
+       if (ret != PMINFO_R_OK)
+               return ret;
 
-       ret = sqlite3_open_v2(dbpath, &db, SQLITE_OPEN_READONLY, NULL);
-       if (ret != SQLITE_OK) {
-               _LOGE("failed to open db: %d", ret);
-               free(locale);
+       ret = pkgmgrinfo_pkginfo_filter_add_string(filter,
+                       PMINFO_PKGINFO_PROP_PACKAGE_ID, pkgid);
+       if (ret != PMINFO_R_OK) {
+               pkgmgrinfo_pkginfo_filter_destroy(filter);
                return PMINFO_R_ERROR;
        }
 
-       info = calloc(1, sizeof(pkgmgr_pkginfo_x));
-       if (info == NULL) {
-               _LOGE("out of memory");
-               free(locale);
-               sqlite3_close_v2(db);
+       ret = pkgmgrinfo_pkginfo_filter_add_bool(filter,
+                       PMINFO_PKGINFO_PROP_PACKAGE_CHECK_STORAGE, false);
+       if (ret != PMINFO_R_OK) {
+               pkgmgrinfo_pkginfo_filter_destroy(filter);
                return PMINFO_R_ERROR;
        }
 
-       ret = _pkginfo_get_package(db, pkgid, locale, &info->pkg_info);
-       if (ret != PMINFO_R_OK) {
-               free(info);
-               free(locale);
-               sqlite3_close_v2(db);
-               return ret;
+       ret = _pkgmgrinfo_get_pkginfo(pkgid, uid, filter, handle);
+       pkgmgrinfo_pkginfo_filter_destroy(filter);
+
+       return ret;
+}
+
+API int pkgmgrinfo_pkginfo_get_disabled_pkginfo(const char *pkgid,
+               pkgmgrinfo_pkginfo_h *handle)
+{
+       return pkgmgrinfo_pkginfo_get_usr_disabled_pkginfo(pkgid, _getuid(),
+                       handle);
+}
+
+API int pkgmgrinfo_pkginfo_get_all_pkginfo(const char *pkgid,
+               pkgmgrinfo_pkginfo_h *handle)
+{
+       return pkgmgrinfo_pkginfo_get_usr_all_pkginfo(pkgid, _getuid(), handle);
+}
+
+API int pkgmgrinfo_pkginfo_get_usr_list_full(pkgmgrinfo_pkg_list_cb pkg_list_cb,
+               int flag, void *user_data, uid_t uid)
+{
+       int ret;
+       pkgmgrinfo_pkginfo_filter_h filter;
+
+       if (pkg_list_cb == NULL) {
+               LOGE("invalid parameter");
+               return PMINFO_R_EINVAL;
        }
 
-       info->locale = locale;
-       info->uid = uid;
-       info->pkg_info->for_all_users = strdup(
-                       uid != GLOBAL_USER ? "false" : "true");
+       /* create an empty filter */
+       ret = pkgmgrinfo_pkginfo_filter_create(&filter);
+       if (ret != PMINFO_R_OK)
+               return ret;
 
-       *pkginfo = info;
+       ret = _pkginfo_get_filtered_foreach_pkginfo(uid, filter, flag,
+                       pkg_list_cb, user_data);
 
-       sqlite3_close_v2(db);
+       pkgmgrinfo_pkginfo_filter_destroy(filter);
 
        return ret;
 }
 
-API int pkgmgrinfo_pkginfo_get_usr_pkginfo(const char *pkgid, uid_t uid,
-               pkgmgrinfo_pkginfo_h *handle)
+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)
 {
        int ret;
+       pkgmgrinfo_pkginfo_filter_h filter;
 
-       if (pkgid == NULL || handle == NULL) {
+       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);
+       /* create an empty filter */
+       ret = pkgmgrinfo_pkginfo_filter_create(&filter);
+       if (ret != PMINFO_R_OK)
+               return ret;
+
+       ret = _pkginfo_get_filtered_foreach_pkginfo(uid, filter,
+                       PMINFO_PKGINFO_GET_ALL, pkg_list_cb, user_data);
+
+       pkgmgrinfo_pkginfo_filter_destroy(filter);
+
+       return ret;
+}
+
+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,
+                       _getuid());
+}
+
+API int pkgmgrinfo_pkginfo_get_usr_disabled_list(
+               pkgmgrinfo_pkg_list_cb pkg_list_cb, void *user_data, uid_t uid)
+{
+       int ret;
+       pkgmgrinfo_pkginfo_filter_h filter;
+
+       if (pkg_list_cb == NULL) {
+               LOGE("invalid parameter");
+               return PMINFO_R_EINVAL;
+       }
 
+       ret = pkgmgrinfo_pkginfo_filter_create(&filter);
        if (ret != PMINFO_R_OK)
-               _LOGE("failed to get pkginfo of %s for user %d", pkgid, uid);
+               return ret;
+
+       ret = pkgmgrinfo_pkginfo_filter_add_bool(filter,
+                       PMINFO_PKGINFO_PROP_PACKAGE_DISABLE, true);
+       if (ret != PMINFO_R_OK) {
+               pkgmgrinfo_pkginfo_filter_destroy(filter);
+               return PMINFO_R_ERROR;
+       }
+
+       ret = _pkginfo_get_filtered_foreach_pkginfo(uid, filter,
+                       PMINFO_PKGINFO_GET_ALL, pkg_list_cb, user_data);
+
+       pkgmgrinfo_pkginfo_filter_destroy(filter);
 
        return ret;
 }
 
-API int pkgmgrinfo_pkginfo_get_pkginfo(const char *pkgid, pkgmgrinfo_pkginfo_h *handle)
+API int pkgmgrinfo_pkginfo_get_disabled_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_disabled_list(pkg_list_cb, user_data,
+                       _getuid());
 }
 
 API int pkgmgrinfo_pkginfo_get_pkgname(pkgmgrinfo_pkginfo_h handle, char **pkg_name)
@@ -853,10 +1167,13 @@ API int pkgmgrinfo_pkginfo_get_type(pkgmgrinfo_pkginfo_h handle, char **type)
        retvm_if(handle == NULL, PMINFO_R_EINVAL, "pkginfo handle is NULL\n");
        retvm_if(type == NULL, PMINFO_R_EINVAL, "Argument supplied to hold return value is NULL\n");
 
-       if (info->pkg_info == NULL || info->pkg_info->type == NULL)
+       if (info->pkg_info == NULL)
                return PMINFO_R_ERROR;
 
-       *type = (char *)info->pkg_info->type;
+       if (info->pkg_info->type == NULL)
+               *type = "";
+       else
+               *type = (char *)info->pkg_info->type;
 
        return PMINFO_R_OK;
 }
@@ -868,10 +1185,13 @@ API int pkgmgrinfo_pkginfo_get_version(pkgmgrinfo_pkginfo_h handle, char **versi
        retvm_if(handle == NULL, PMINFO_R_EINVAL, "pkginfo handle is NULL\n");
        retvm_if(version == NULL, PMINFO_R_EINVAL, "Argument supplied to hold return value is NULL\n");
 
-       if (info->pkg_info == NULL || info->pkg_info->version == NULL)
+       if (info->pkg_info == NULL)
                return PMINFO_R_ERROR;
 
-       *version = (char *)info->pkg_info->version;
+       if (info->pkg_info->version == NULL)
+               *version = "";
+       else
+               *version = (char *)info->pkg_info->version;
 
        return PMINFO_R_OK;
 }
@@ -883,10 +1203,13 @@ API int pkgmgrinfo_pkginfo_get_api_version(pkgmgrinfo_pkginfo_h handle, char **a
        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)
+       if (info->pkg_info == NULL)
                return PMINFO_R_ERROR;
 
-       *api_version = (char *)info->pkg_info->api_version;
+       if (info->pkg_info->api_version == NULL)
+               *api_version = "";
+       else
+               *api_version = (char *)info->pkg_info->api_version;
 
        return PMINFO_R_OK;
 }
@@ -901,316 +1224,164 @@ API int pkgmgrinfo_pkginfo_get_tep_name(pkgmgrinfo_pkginfo_h handle, char **tep_
        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_install_location(pkgmgrinfo_pkginfo_h handle, pkgmgrinfo_install_location *location)
+API int pkgmgrinfo_pkginfo_get_zip_mount_file(pkgmgrinfo_pkginfo_h handle, char **zip_mount_file)
 {
-       char *val;
        pkgmgr_pkginfo_x *info = (pkgmgr_pkginfo_x *)handle;
 
        retvm_if(handle == NULL, PMINFO_R_EINVAL, "pkginfo handle is NULL\n");
-       retvm_if(location == NULL, PMINFO_R_EINVAL, "Argument supplied to hold return value 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 || info->pkg_info->installlocation == NULL)
+       if (info->pkg_info == NULL)
                return PMINFO_R_ERROR;
 
-       val = (char *)info->pkg_info->installlocation;
-       if (strcmp(val, "internal-only") == 0)
-               *location = PMINFO_INSTALL_LOCATION_INTERNAL_ONLY;
-       else if (strcmp(val, "prefer-external") == 0)
-               *location = PMINFO_INSTALL_LOCATION_PREFER_EXTERNAL;
+       if (info->pkg_info->zip_mount_file == NULL)
+               *zip_mount_file = "";
        else
-               *location = PMINFO_INSTALL_LOCATION_AUTO;
+               *zip_mount_file = (char *)info->pkg_info->zip_mount_file;
 
        return PMINFO_R_OK;
 }
 
-API int pkgmgrinfo_pkginfo_get_package_size(pkgmgrinfo_pkginfo_h handle, int *size)
+API int pkgmgrinfo_pkginfo_get_external_image_path(pkgmgrinfo_pkginfo_h handle, char **ext_image_path)
 {
        pkgmgr_pkginfo_x *info = (pkgmgr_pkginfo_x *)handle;
 
        retvm_if(handle == NULL, PMINFO_R_EINVAL, "pkginfo handle is NULL\n");
-       retvm_if(size == NULL, PMINFO_R_EINVAL, "Argument supplied to hold return value is NULL\n");
+       retvm_if(ext_image_path == NULL, PMINFO_R_EINVAL, "Argument supplied to hold return value is NULL\n");
 
-       if (info->pkg_info == NULL || info->pkg_info->package_size == NULL)
+       if (info->pkg_info == NULL)
                return PMINFO_R_ERROR;
 
-       *size = atoi((char *)info->pkg_info->package_size);
+       if (info->pkg_info->external_path == NULL)
+               return PMINFO_R_ENOENT;
+
+       *ext_image_path = (char *)info->pkg_info->external_path;
 
        return PMINFO_R_OK;
 }
 
-API int pkgmgrinfo_pkginfo_get_total_size(pkgmgrinfo_pkginfo_h handle, int *size)
+API int pkgmgrinfo_pkginfo_get_install_location(pkgmgrinfo_pkginfo_h handle, pkgmgrinfo_install_location *location)
 {
-       char *pkgid;
-       char device_path[PKG_STRING_LEN_MAX] = { '\0', };
-       long long rw_size = 0;
-       long long ro_size = 0;
-       long long tmp_size = 0;
-       long long total_size = 0;
-       struct stat fileinfo;
-       int ret;
+       char *val;
+       pkgmgr_pkginfo_x *info = (pkgmgr_pkginfo_x *)handle;
 
        retvm_if(handle == NULL, PMINFO_R_EINVAL, "pkginfo handle is NULL\n");
-       retvm_if(size == NULL, PMINFO_R_EINVAL, "Argument supplied to hold return value is NULL\n");
+       retvm_if(location == NULL, PMINFO_R_EINVAL, "Argument supplied to hold return value is NULL\n");
 
-       ret = pkgmgrinfo_pkginfo_get_pkgid(handle, &pkgid);
-       if (ret < 0)
+       if (info->pkg_info == NULL || info->pkg_info->installlocation == NULL)
                return PMINFO_R_ERROR;
 
-       /* RW area */
-       snprintf(device_path, PKG_STRING_LEN_MAX, "%s%s/bin", PKG_RW_PATH, pkgid);
-       if (lstat(device_path, &fileinfo) == 0) {
-               if (!S_ISLNK(fileinfo.st_mode)) {
-                       tmp_size = _pkgmgr_calculate_dir_size(device_path);
-                       if (tmp_size > 0)
-                               rw_size += tmp_size;
-               }
-       }
-
-       snprintf(device_path, PKG_STRING_LEN_MAX, "%s%s/info", PKG_RW_PATH, pkgid);
-       if (lstat(device_path, &fileinfo) == 0) {
-               if (!S_ISLNK(fileinfo.st_mode)) {
-                       tmp_size = _pkgmgr_calculate_dir_size(device_path);
-                       if (tmp_size > 0)
-                       rw_size += tmp_size;
-               }
-       }
-
-       snprintf(device_path, PKG_STRING_LEN_MAX, "%s%s/res", PKG_RW_PATH, pkgid);
-       if (lstat(device_path, &fileinfo) == 0) {
-               if (!S_ISLNK(fileinfo.st_mode)) {
-                       tmp_size = _pkgmgr_calculate_dir_size(device_path);
-                       if (tmp_size > 0)
-                       rw_size += tmp_size;
-               }
-       }
-
-       snprintf(device_path, PKG_STRING_LEN_MAX, "%s%s/data", PKG_RW_PATH, pkgid);
-       if (lstat(device_path, &fileinfo) == 0) {
-               if (!S_ISLNK(fileinfo.st_mode)) {
-                       tmp_size = _pkgmgr_calculate_dir_size(device_path);
-                       if (tmp_size > 0)
-                               rw_size += tmp_size;
-               }
-       }
-
-       snprintf(device_path, PKG_STRING_LEN_MAX, "%s%s/shared", PKG_RW_PATH, pkgid);
-       if (lstat(device_path, &fileinfo) == 0) {
-               if (!S_ISLNK(fileinfo.st_mode)) {
-                       tmp_size = _pkgmgr_calculate_dir_size(device_path);
-                       if (tmp_size > 0)
-                               rw_size += tmp_size;
-       }
-       }
-
-       snprintf(device_path, PKG_STRING_LEN_MAX, "%s%s/setting", PKG_RW_PATH, pkgid);
-       if (lstat(device_path, &fileinfo) == 0) {
-               if (!S_ISLNK(fileinfo.st_mode)) {
-                       tmp_size = _pkgmgr_calculate_dir_size(device_path);
-                       if (tmp_size > 0)
-                               rw_size += tmp_size;
-               }
-       }
-
-       /* RO area */
-       snprintf(device_path, PKG_STRING_LEN_MAX, "%s%s/bin", PKG_RO_PATH, pkgid);
-       if (lstat(device_path, &fileinfo) == 0) {
-               if (!S_ISLNK(fileinfo.st_mode)) {
-                       tmp_size = _pkgmgr_calculate_dir_size(device_path);
-                       if (tmp_size > 0)
-                               ro_size += tmp_size;
-               }
-       }
-
-       snprintf(device_path, PKG_STRING_LEN_MAX, "%s%s/info", PKG_RO_PATH, pkgid);
-       if (lstat(device_path, &fileinfo) == 0) {
-               if (!S_ISLNK(fileinfo.st_mode)) {
-                       tmp_size = _pkgmgr_calculate_dir_size(device_path);
-                       if (tmp_size > 0)
-                               ro_size += tmp_size;
-               }
-       }
-
-       snprintf(device_path, PKG_STRING_LEN_MAX, "%s%s/res", PKG_RO_PATH, pkgid);
-       if (lstat(device_path, &fileinfo) == 0) {
-               if (!S_ISLNK(fileinfo.st_mode)) {
-                       tmp_size = _pkgmgr_calculate_dir_size(device_path);
-                       if (tmp_size > 0)
-                               ro_size += tmp_size;
-               }
-       }
-
-       snprintf(device_path, PKG_STRING_LEN_MAX, "%s%s/data", PKG_RO_PATH, pkgid);
-       if (lstat(device_path, &fileinfo) == 0) {
-               if (!S_ISLNK(fileinfo.st_mode)) {
-                       tmp_size = _pkgmgr_calculate_dir_size(device_path);
-                       if (tmp_size > 0)
-                               ro_size += tmp_size;
-               }
-       }
-
-       snprintf(device_path, PKG_STRING_LEN_MAX, "%s%s/shared", PKG_RO_PATH, pkgid);
-       if (lstat(device_path, &fileinfo) == 0) {
-               if (!S_ISLNK(fileinfo.st_mode)) {
-                       tmp_size = _pkgmgr_calculate_dir_size(device_path);
-                       if (tmp_size > 0)
-                               ro_size += tmp_size;
-               }
-       }
-
-       snprintf(device_path, PKG_STRING_LEN_MAX, "%s%s/setting", PKG_RO_PATH, pkgid);
-       if (lstat(device_path, &fileinfo) == 0) {
-               if (!S_ISLNK(fileinfo.st_mode)) {
-                       tmp_size = _pkgmgr_calculate_dir_size(device_path);
-                       if (tmp_size > 0)
-                               ro_size += tmp_size;
-               }
-       }
-
-       /* Total size */
-       total_size = rw_size + ro_size;
-       *size = (int)total_size;
+       val = (char *)info->pkg_info->installlocation;
+       if (strcmp(val, "internal-only") == 0)
+               *location = PMINFO_INSTALL_LOCATION_INTERNAL_ONLY;
+       else if (strcmp(val, "prefer-external") == 0)
+               *location = PMINFO_INSTALL_LOCATION_PREFER_EXTERNAL;
+       else
+               *location = PMINFO_INSTALL_LOCATION_AUTO;
 
        return PMINFO_R_OK;
 }
 
-API int pkgmgrinfo_pkginfo_get_data_size(pkgmgrinfo_pkginfo_h handle, int *size)
+API int pkgmgrinfo_pkginfo_get_package_size(pkgmgrinfo_pkginfo_h handle, int *size)
 {
-       char *pkgid;
-       char device_path[PKG_STRING_LEN_MAX] = { '\0', };
-       long long total_size = 0;
+       pkgmgr_pkginfo_x *info = (pkgmgr_pkginfo_x *)handle;
+       char *temp = NULL;
 
        retvm_if(handle == NULL, PMINFO_R_EINVAL, "pkginfo handle is NULL\n");
        retvm_if(size == NULL, PMINFO_R_EINVAL, "Argument supplied to hold return value is NULL\n");
 
-       if (pkgmgrinfo_pkginfo_get_pkgid(handle, &pkgid) < 0)
+       if (info->pkg_info == NULL)
                return PMINFO_R_ERROR;
 
-       snprintf(device_path, PKG_STRING_LEN_MAX, "%s%s/data", PKG_RW_PATH, pkgid);
-       if (access(device_path, R_OK) == 0)
-               total_size = _pkgmgr_calculate_dir_size(device_path);
-       if (total_size < 0)
-               return PMINFO_R_ERROR;
+       if (info->pkg_info->package_size == NULL) {
+               temp = strdup("");
+               if (temp == NULL) {
+                       _LOGE("out of memory");
+                       return PMINFO_R_ERROR;
+               } else {
+                       info->pkg_info->package_size = temp;
+               }
+       }
 
-       *size = (int)total_size;
+       *size = atoi((char *)info->pkg_info->package_size);
 
        return PMINFO_R_OK;
 }
 
 API int pkgmgrinfo_pkginfo_get_icon(pkgmgrinfo_pkginfo_h handle, char **icon)
 {
-       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");
        retvm_if(icon == NULL, PMINFO_R_EINVAL, "Argument supplied to hold return value is NULL");
 
-       locale = info->locale;
-       retvm_if(locale == NULL, PMINFO_R_ERROR, "manifest locale is NULL");
-
-       if (info->pkg_info == NULL)
+       if (info->pkg_info == NULL || info->pkg_info->icon == 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;
-       }
+       ptr = (icon_x *)info->pkg_info->icon->data;
+       if (ptr == NULL)
+               return PMINFO_R_ERROR;
 
-       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;
-       }
+       /* TODO : should we return empty string if there was no icon? */
+       if (ptr->text == NULL)
+               *icon = "";
+       else
+               *icon = ptr->text;
 
-       return PMINFO_R_ERROR;
+       return PMINFO_R_OK;
 }
 
 API int pkgmgrinfo_pkginfo_get_label(pkgmgrinfo_pkginfo_h handle, char **label)
 {
-       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");
        retvm_if(label == NULL, PMINFO_R_EINVAL, "Argument supplied to hold return value is NULL");
 
-       locale = info->locale;
-       retvm_if(locale == NULL, PMINFO_R_ERROR, "manifest locale is NULL");
+       if (info->pkg_info == NULL || info->pkg_info->label == NULL)
+               return PMINFO_R_ERROR;
 
-       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;
-       }
+       ptr = (label_x *)info->pkg_info->label->data;
+       if (ptr == NULL)
+               return PMINFO_R_ERROR;
 
-       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;
-       }
+       /* TODO : should we return empty string if there was no label? */
+       if (ptr->text == NULL)
+               *label = "";
+       else
+               *label = ptr->text;
 
-       return PMINFO_R_ERROR;
+       return PMINFO_R_OK;
 }
 
 API int pkgmgrinfo_pkginfo_get_description(pkgmgrinfo_pkginfo_h handle, char **description)
 {
-       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");
        retvm_if(description == NULL, PMINFO_R_EINVAL, "Argument supplied to hold return value is NULL\n");
 
-       locale = info->locale;
-       retvm_if(locale == NULL, PMINFO_R_ERROR, "manifest locale is NULL");
+       if (info->pkg_info == NULL || info->pkg_info->description == NULL)
+               return PMINFO_R_ERROR;
 
-       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;
-       }
+       ptr = (description_x *)info->pkg_info->description->data;
+       if (ptr == NULL)
+               return PMINFO_R_ERROR;
 
-       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;
+       if (ptr->text == NULL)
+               *description = "";
+       else
                *description = (char *)ptr->text;
-               return PMINFO_R_OK;
-       }
 
-       return PMINFO_R_ERROR;
+       return PMINFO_R_OK;
 }
 
 API int pkgmgrinfo_pkginfo_get_author_name(pkgmgrinfo_pkginfo_h handle, char **author_name)
@@ -1225,10 +1396,13 @@ API int pkgmgrinfo_pkginfo_get_author_name(pkgmgrinfo_pkginfo_h handle, char **a
                return PMINFO_R_ERROR;
 
        author = (author_x *)info->pkg_info->author->data;
-       if (author == NULL || author->text == NULL)
+       if (author == NULL)
                return PMINFO_R_ERROR;
 
-       *author_name = (char *)author->text;
+       if (author->text == NULL)
+               *author_name = "";
+       else
+               *author_name = (char *)author->text;
 
        return PMINFO_R_OK;
 }
@@ -1245,10 +1419,13 @@ API int pkgmgrinfo_pkginfo_get_author_email(pkgmgrinfo_pkginfo_h handle, char **
                return PMINFO_R_ERROR;
 
        author = (author_x *)info->pkg_info->author->data;
-       if (author == NULL || author->email == NULL)
+       if (author == NULL)
                return PMINFO_R_ERROR;
 
-       *author_email = (char *)author->email;
+       if (author->email == NULL)
+               *author_email = "";
+       else
+               *author_email = (char *)author->email;
 
        return PMINFO_R_OK;
 }
@@ -1265,10 +1442,13 @@ API int pkgmgrinfo_pkginfo_get_author_href(pkgmgrinfo_pkginfo_h handle, char **a
                return PMINFO_R_ERROR;
 
        author = (author_x *)info->pkg_info->author->data;
-       if (author == NULL || author->href == NULL)
+       if (author == NULL)
                return PMINFO_R_ERROR;
 
-       *author_href = (char *)author->href;
+       if (author->href == NULL)
+               *author_href = "";
+       else
+               *author_href = (char *)author->href;
 
        return PMINFO_R_OK;
 }
@@ -1283,10 +1463,12 @@ API int pkgmgrinfo_pkginfo_get_installed_storage(pkgmgrinfo_pkginfo_h handle, pk
        if (info->pkg_info == NULL || info->pkg_info->installed_storage == NULL)
                return PMINFO_R_ERROR;
 
-       if (strcmp(info->pkg_info->installed_storage,"installed_internal") == 0)
+       if (strcmp(info->pkg_info->installed_storage, "installed_internal") == 0)
                *storage = PMINFO_INTERNAL_STORAGE;
-       else if (strcmp(info->pkg_info->installed_storage,"installed_external") == 0)
+       else if (strcmp(info->pkg_info->installed_storage, "installed_external") == 0)
                *storage = PMINFO_EXTERNAL_STORAGE;
+       else if (strcmp(info->pkg_info->installed_storage, "installed_extended") == 0)
+               *storage = PMINFO_EXTENDED_STORAGE;
        else
                return PMINFO_R_ERROR;
 
@@ -1315,10 +1497,13 @@ API int pkgmgrinfo_pkginfo_get_storeclientid(pkgmgrinfo_pkginfo_h handle, char *
        retvm_if(handle == NULL, PMINFO_R_EINVAL, "pkginfo handle is NULL\n");
        retvm_if(storeclientid == NULL, PMINFO_R_EINVAL, "Argument supplied to hold return value is NULL\n");
 
-       if (info->pkg_info == NULL || info->pkg_info->storeclient_id == NULL)
+       if (info->pkg_info == NULL)
                return PMINFO_R_ERROR;
 
-       *storeclientid = (char *)info->pkg_info->storeclient_id;
+       if (info->pkg_info->storeclient_id == NULL)
+               *storeclientid = "";
+       else
+               *storeclientid = (char *)info->pkg_info->storeclient_id;
 
        return PMINFO_R_OK;
 }
@@ -1345,120 +1530,17 @@ API int pkgmgrinfo_pkginfo_get_url(pkgmgrinfo_pkginfo_h handle, char **url)
        retvm_if(handle == NULL, PMINFO_R_EINVAL, "pkginfo handle is NULL\n");
        retvm_if(url == NULL, PMINFO_R_EINVAL, "Argument supplied to hold return value is NULL\n");
 
-       if (info->pkg_info == NULL || info->pkg_info->package_url == NULL)
-               return PMINFO_R_ERROR;
-
-       *url = (char *)info->pkg_info->package_url;
-
-       return PMINFO_R_OK;
-}
-
-API int pkgmgrinfo_pkginfo_get_size_from_xml(const char *manifest, int *size)
-{
-       const char *val = NULL;
-       const xmlChar *node;
-       xmlTextReaderPtr reader;
-       retvm_if(manifest == NULL, PMINFO_R_EINVAL, "Input argument is NULL\n");
-       retvm_if(size == NULL, PMINFO_R_EINVAL, "Argument supplied to hold return value is NULL\n");
-
-       xmlInitParser();
-       reader = xmlReaderForFile(manifest, NULL, 0);
-
-       if (reader){
-               if (__child_element(reader, -1)) {
-                       node = xmlTextReaderConstName(reader);
-                       if (!node) {
-                               _LOGE("xmlTextReaderConstName value is NULL\n");
-                               xmlFreeTextReader(reader);
-                               xmlCleanupParser();
-                               return PMINFO_R_ERROR;
-                       }
-
-                       if (!strcmp(ASC_CHAR(node), "manifest")) {
-                               if (xmlTextReaderGetAttribute(reader, XML_CHAR("size")))
-                                       val = ASC_CHAR(xmlTextReaderGetAttribute(reader, XML_CHAR("size")));
-
-                               if (val) {
-                                       *size = atoi(val);
-                               } else {
-                                       *size = 0;
-                                       _LOGE("package size is not specified\n");
-                                       xmlFreeTextReader(reader);
-                                       xmlCleanupParser();
-                                       return PMINFO_R_ERROR;
-                               }
-                       } else {
-                               _LOGE("Unable to create xml reader\n");
-                               xmlFreeTextReader(reader);
-                               xmlCleanupParser();
-                               return PMINFO_R_ERROR;
-                       }
-               }
-       } else {
-               _LOGE("xmlReaderForFile value is NULL\n");
-               xmlCleanupParser();
-               return PMINFO_R_ERROR;
-       }
-
-       xmlFreeTextReader(reader);
-       xmlCleanupParser();
-
-       return PMINFO_R_OK;
-}
-
-API int pkgmgrinfo_pkginfo_get_location_from_xml(const char *manifest, pkgmgrinfo_install_location *location)
-{
-       const char *val = NULL;
-       const xmlChar *node;
-       xmlTextReaderPtr reader;
-       retvm_if(manifest == NULL, PMINFO_R_EINVAL, "Input argument is NULL\n");
-       retvm_if(location == NULL, PMINFO_R_EINVAL, "Argument supplied to hold return value is NULL\n");
-
-       xmlInitParser();
-       reader = xmlReaderForFile(manifest, NULL, 0);
-
-       if (reader) {
-               if ( __child_element(reader, -1)) {
-                       node = xmlTextReaderConstName(reader);
-                       if (!node) {
-                               _LOGE("xmlTextReaderConstName value is NULL\n");
-                               xmlFreeTextReader(reader);
-                               xmlCleanupParser();
-                               return PMINFO_R_ERROR;
-                       }
-
-                       if (!strcmp(ASC_CHAR(node), "manifest")) {
-                               if (xmlTextReaderGetAttribute(reader, XML_CHAR("install-location")))
-                                       val = ASC_CHAR(xmlTextReaderGetAttribute(reader, XML_CHAR("install-location")));
-
-                               if (val) {
-                                       if (strcmp(val, "internal-only") == 0)
-                                               *location = PMINFO_INSTALL_LOCATION_INTERNAL_ONLY;
-                                       else if (strcmp(val, "prefer-external") == 0)
-                                               *location = PMINFO_INSTALL_LOCATION_PREFER_EXTERNAL;
-                                       else
-                                               *location = PMINFO_INSTALL_LOCATION_AUTO;
-                               }
-                       } else {
-                               _LOGE("Unable to create xml reader\n");
-                               xmlFreeTextReader(reader);
-                               xmlCleanupParser();
-                               return PMINFO_R_ERROR;
-                       }
-               }
-       } else {
-               _LOGE("xmlReaderForFile value is NULL\n");
-               xmlCleanupParser();
+       if (info->pkg_info == NULL)
                return PMINFO_R_ERROR;
-       }
 
-       xmlFreeTextReader(reader);
-       xmlCleanupParser();
+       if (info->pkg_info->package_url == NULL)
+               *url = "";
+       else
+               *url = (char *)info->pkg_info->package_url;
 
        return PMINFO_R_OK;
 }
 
-
 API int pkgmgrinfo_pkginfo_get_root_path(pkgmgrinfo_pkginfo_h handle, char **path)
 {
        pkgmgr_pkginfo_x *info = (pkgmgr_pkginfo_x *)handle;
@@ -1481,24 +1563,40 @@ API int pkgmgrinfo_pkginfo_get_csc_path(pkgmgrinfo_pkginfo_h handle, char **path
        retvm_if(handle == NULL, PMINFO_R_EINVAL, "pkginfo handle is NULL\n");
        retvm_if(path == NULL, PMINFO_R_EINVAL, "Argument supplied to hold return value is NULL\n");
 
-       if (info->pkg_info == NULL || info->pkg_info->csc_path == NULL)
+       if (info->pkg_info == NULL)
                return PMINFO_R_ERROR;
 
-       *path = (char *)info->pkg_info->csc_path;
+       if (info->pkg_info->csc_path == NULL)
+               *path = "";
+       else
+               *path = (char *)info->pkg_info->csc_path;
 
        return PMINFO_R_OK;
 }
 
+API int pkgmgrinfo_pkginfo_get_support_mode(pkgmgrinfo_pkginfo_h handle, int *support_mode)
+{
+       retvm_if(handle == NULL, PMINFO_R_EINVAL, "pkginfo handle is NULL\n");
+       retvm_if(support_mode == NULL, PMINFO_R_EINVAL, "Argument supplied to hold return value is NULL\n");
+
+       pkgmgr_pkginfo_x *info = (pkgmgr_pkginfo_x *)handle;
+       if (info->pkg_info->support_mode)
+               *support_mode = atoi(info->pkg_info->support_mode);
+       else
+               *support_mode = 0;
+
+       return PMINFO_R_OK;
+}
 
 API int pkgmgrinfo_pkginfo_is_accessible(pkgmgrinfo_pkginfo_h handle, bool *accessible)
 {
        retvm_if(handle == NULL, PMINFO_R_EINVAL, "pkginfo handle is NULL\n");
        retvm_if(accessible == NULL, PMINFO_R_EINVAL, "Argument supplied to hold return value is NULL\n");
 
-#if 0 //smack issue occured, check later
+#if 0 /* smack issue occured, check later */
        char *pkgid = NULL;
        pkgmgrinfo_pkginfo_get_pkgid(handle, &pkgid);
-       if (pkgid == NULL){
+       if (pkgid == NULL) {
                 _LOGD("invalid func parameters\n");
                 return PMINFO_R_ERROR;
        }
@@ -1508,13 +1606,13 @@ API int pkgmgrinfo_pkginfo_is_accessible(pkgmgrinfo_pkginfo_h handle, bool *acce
        char app_mmc_path[FILENAME_MAX] = { 0, };
        char app_dir_path[FILENAME_MAX] = { 0, };
        char app_mmc_internal_path[FILENAME_MAX] = { 0, };
-       snprintf(app_dir_path, FILENAME_MAX,"%s%s", PKG_INSTALLATION_PATH, pkgid);
-       snprintf(app_mmc_path, FILENAME_MAX,"%s%s", PKG_SD_PATH, pkgid);
-       snprintf(app_mmc_internal_path, FILENAME_MAX,"%s%s/.mmc", PKG_INSTALLATION_PATH, pkgid);
+       snprintf(app_dir_path, FILENAME_MAX, "%s%s", PKG_INSTALLATION_PATH, pkgid);
+       snprintf(app_mmc_path, FILENAME_MAX, "%s%s", PKG_SD_PATH, pkgid);
+       snprintf(app_mmc_internal_path, FILENAME_MAX, "%s%s/.mmc", PKG_INSTALLATION_PATH, pkgid);
 
        /*check whether application is in external memory or not */
        fp = fopen(app_mmc_path, "r");
-       if (fp == NULL){
+       if (fp == NULL) {
                _LOGD(" app path in external memory not accesible\n");
        } else {
                fclose(fp);
@@ -1525,7 +1623,6 @@ API int pkgmgrinfo_pkginfo_is_accessible(pkgmgrinfo_pkginfo_h handle, bool *acce
        }
 
        /*check whether application is in internal or not */
-       fp = fopen(app_dir_path, "r");
        if (fp == NULL) {
                _LOGD(" app path in internal memory not accesible\n");
                *accessible = 0;
@@ -1535,12 +1632,11 @@ API int pkgmgrinfo_pkginfo_is_accessible(pkgmgrinfo_pkginfo_h handle, bool *acce
                /*check whether the application is installed in SD card
                but SD card is not present*/
                fp = fopen(app_mmc_internal_path, "r");
-               if (fp == NULL){
+               if (fp == NULL) {
                        *accessible = 1;
                        _LOGD("pkgmgr_get_pkg_external_validation() : INTERNAL_MEM \n");
                        return PMINFO_R_OK;
-               }
-               else{
+               } else {
                        *accessible = 0;
                        _LOGD("pkgmgr_get_pkg_external_validation() : ERROR_MMC_STATUS \n");
                }
@@ -1583,8 +1679,6 @@ API int pkgmgrinfo_pkginfo_is_movable(pkgmgrinfo_pkginfo_h handle, bool *movable
        val = (char *)info->pkg_info->installlocation;
        if (strcmp(val, "internal-only") == 0)
                *movable = 0;
-       else if (strcmp(val, "prefer-external") == 0)
-               *movable = 1;
        else
                *movable = 1;
 
@@ -1703,7 +1797,7 @@ API int pkgmgrinfo_pkginfo_filter_create(pkgmgrinfo_pkginfo_filter_h *handle)
 
        retvm_if(handle == NULL, PMINFO_R_EINVAL, "Filter handle output parameter is NULL\n");
 
-       filter = (pkgmgrinfo_filter_x*)calloc(1, sizeof(pkgmgrinfo_filter_x));
+       filter = (pkgmgrinfo_filter_x *)calloc(1, sizeof(pkgmgrinfo_filter_x));
        if (filter == NULL) {
                _LOGE("Out of Memory!!!");
                return PMINFO_R_ERROR;
@@ -1725,6 +1819,8 @@ API int pkgmgrinfo_pkginfo_filter_destroy(pkgmgrinfo_pkginfo_filter_h handle)
                g_slist_free(filter->list);
        }
 
+       g_slist_free_full(filter->list_metadata, __destroy_metadata_node);
+
        free(filter);
 
        return PMINFO_R_OK;
@@ -1797,9 +1893,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);
@@ -1873,27 +1969,58 @@ 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;
+       }
+
+       if (__check_disable_filter_exist((pkgmgrinfo_filter_x *)handle) == false) {
+               ret = pkgmgrinfo_pkginfo_filter_add_bool(handle,
+                               PMINFO_PKGINFO_PROP_PACKAGE_DISABLE, false);
+               if (ret != PMINFO_R_OK) {
+                       free(locale);
+                       g_hash_table_destroy(list);
+                       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(
@@ -1905,14 +2032,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,
@@ -1921,7 +2048,8 @@ 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;
-       const char *privilege;
+       privilege_x *privilege;
+       appdefined_privilege_x *appdefined_privilege;
        GList *tmp;
        pkgmgr_pkginfo_x *info = (pkgmgr_pkginfo_x *)handle;
 
@@ -1929,328 +2057,385 @@ API int pkgmgrinfo_pkginfo_foreach_privilege(pkgmgrinfo_pkginfo_h handle,
                return PMINFO_R_ERROR;
 
        for (tmp = info->pkg_info->privileges; tmp; tmp = tmp->next) {
-               privilege = (const char *)tmp->data;
+               privilege = (privilege_x *)tmp->data;
                if (privilege == NULL)
                        continue;
-               ret = privilege_func(privilege, user_data);
+               ret = privilege_func(privilege->value, user_data);
                if (ret < 0)
-                       break;
+                       return PMINFO_R_OK;
        }
-       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;
+       for (tmp = info->pkg_info->appdefined_privileges; tmp;
+                       tmp = tmp->next) {
+               appdefined_privilege = (appdefined_privilege_x *)tmp->data;
+               if (appdefined_privilege == NULL)
+                       continue;
+               ret = privilege_func(appdefined_privilege->value, user_data);
+               if (ret < 0)
+                       return PMINFO_R_OK;
        }
-       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)
+API int pkgmgrinfo_pkginfo_foreach_plugin(pkgmgrinfo_pkginfo_h handle,
+                       pkgmgrinfo_plugin_list_cb plugin_func, void *user_data)
 {
-       retvm_if(!pkgid, PMINFO_R_EINVAL, "pkgid is NULL");
-       retvm_if(!handle, PMINFO_R_EINVAL, "Argument supplied is NULL");
+       retvm_if(handle == NULL, PMINFO_R_EINVAL, "pkginfo handle is NULL");
+       retvm_if(plugin_func == NULL, PMINFO_R_EINVAL,
+                       "Callback function is NULL");
+       int ret;
+       plugin_x *plugin;
+       GList *tmp;
+       pkgmgr_pkginfo_x *info = (pkgmgr_pkginfo_x *)handle;
 
-       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);
+       if (info->pkg_info == NULL)
+               return PMINFO_R_ERROR;
 
-       mfx = pkgmgr_parser_process_manifest_xml(manifest);
-       if (manifest) {
-               free(manifest);
-               manifest = NULL;
+       for (tmp = info->pkg_info->plugin; tmp; tmp = tmp->next) {
+               plugin = (plugin_x *)tmp->data;
+               if (plugin == NULL)
+                       continue;
+               ret = plugin_func(plugin->pkgid, plugin->appid,
+                               plugin->plugin_type, plugin->plugin_name, user_data);
+               if (ret < 0)
+                       return PMINFO_R_OK;
        }
-       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)
+API int pkgmgrinfo_pkginfo_foreach_appdefined_privilege(
+               pkgmgrinfo_pkginfo_h handle,
+               pkgmgrinfo_pkg_appdefined_privilege_list_cb privilege_func,
+               void *user_data)
 {
-       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");
+       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;
+       appdefined_privilege_x *privilege;
+       GList *tmp;
+       pkgmgr_pkginfo_x *info = (pkgmgr_pkginfo_x *)handle;
 
-       if (mfx->version)
-               free((void *)mfx->version);
+       if (info->pkg_info == NULL)
+               return PMINFO_R_ERROR;
 
-       mfx->version = strndup(version, PKG_VERSION_STRING_LEN_MAX);
+       for (tmp = info->pkg_info->appdefined_privileges; tmp;
+                       tmp = tmp->next) {
+               privilege = (appdefined_privilege_x *)tmp->data;
+               if (privilege == NULL)
+                       continue;
+               ret = privilege_func(privilege->value, privilege->license,
+                               user_data);
+               if (ret < 0)
+                       break;
+       }
        return PMINFO_R_OK;
 }
 
-API int pkgmgrinfo_set_install_location_to_pkgdbinfo(pkgmgrinfo_pkgdbinfo_h handle, INSTALL_LOCATION location)
+API int pkgmgrinfo_pkginfo_foreach_dependency(pkgmgrinfo_pkginfo_h handle,
+               pkgmgrinfo_pkg_dependency_list_cb dependency_cb,
+               void *user_data)
 {
-       manifest_x *mfx = (manifest_x *)handle;
+       int ret;
+       pkgmgr_pkginfo_x *info = (pkgmgr_pkginfo_x *)handle;
+       GList *tmp;
+       dependency_x *dependency;
 
-       retvm_if(!handle, PMINFO_R_EINVAL, "Argument supplied is NULL");
-       retvm_if((location < 0) || (location > 1), PMINFO_R_EINVAL, "Argument supplied is NULL");
+       if (handle == NULL || dependency_cb == NULL) {
+               LOGE("invalid parameter");
+               return PMINFO_R_EINVAL;
+       }
 
-       if (mfx->installlocation)
-               free((void *)mfx->installlocation);
+       if (info->pkg_info == NULL)
+               return PMINFO_R_ERROR;
 
-       if (location == INSTALL_INTERNAL)
-               mfx->installlocation = strdup("internal-only");
-       else if (location == INSTALL_EXTERNAL)
-               mfx->installlocation = strdup("prefer-external");
+       for (tmp = info->pkg_info->dependencies; tmp; tmp = tmp->next) {
+               dependency = (dependency_x *)tmp->data;
+               if (dependency == NULL)
+                       continue;
+               ret = dependency_cb(dependency->depends_on, dependency->type,
+                               dependency->required_version, user_data);
+               if (ret < 0)
+                       break;
+       }
 
        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;
-}
+struct required_by {
+       char *pkgid;
+       char *type;
+       char *version;
+};
 
-API int pkgmgrinfo_set_label_to_pkgdbinfo(pkgmgrinfo_pkgdbinfo_h handle, const char *label_txt, const char *locale)
+static int _get_required_by(sqlite3 *db, const char *pkgid, GQueue **queue,
+               GHashTable **table, GList **pkg_list)
 {
-       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");
-
-       if (locale)
-               label->lang = strdup(locale);
-       else
-               label->lang = strdup(DEFAULT_LOCALE);
-       label->text = strdup(label_txt);
-       mfx->label = g_list_append(mfx->label, label);
+       static const char query[] =
+               "SELECT package, type, required_version "
+               "FROM package_dependency_info WHERE depends_on=?";
+       int ret;
+       sqlite3_stmt *stmt;
+       struct required_by *req;
 
-       return PMINFO_R_OK;
-}
+       /* already checked */
+       if (!g_hash_table_insert(*table, strdup(pkgid), GINT_TO_POINTER(1)))
+               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;
+       ret = sqlite3_prepare_v2(db, query, strlen(query), &stmt, NULL);
+       if (ret != SQLITE_OK) {
+               LOGE("prepare failed: %s", sqlite3_errmsg(db));
+               return PMINFO_R_ERROR;
+       }
 
-       retvm_if(!handle, PMINFO_R_EINVAL, "Argument supplied is NULL");
-       retvm_if(!icon_txt, PMINFO_R_EINVAL, "Argument supplied is NULL");
+       ret = sqlite3_bind_text(stmt, 1, pkgid, -1, SQLITE_STATIC);
+       if (ret != SQLITE_OK) {
+               LOGE("bind failed: %s", sqlite3_errmsg(db));
+               sqlite3_finalize(stmt);
+               return PMINFO_R_ERROR;
+       }
 
-       len = strlen(icon_txt);
-       retvm_if(len > PKG_TYPE_STRING_LEN_MAX, PMINFO_R_EINVAL, "pkg type length exceeds the max limit");
+       while (sqlite3_step(stmt) == SQLITE_ROW) {
+               req = calloc(1, sizeof(struct required_by));
+               if (req == NULL) {
+                       LOGE("out of memory");
+                       sqlite3_finalize(stmt);
+                       return PMINFO_R_ERROR;
+               }
+               _save_column_str(stmt, 0, &req->pkgid);
+               _save_column_str(stmt, 1, &req->type);
+               _save_column_str(stmt, 2, &req->version);
 
-       icon = calloc(1, sizeof(icon_x));
-       retvm_if(icon == NULL, PMINFO_R_EINVAL, "Malloc Failed");
+               *pkg_list = g_list_append(*pkg_list, req);
+               g_queue_push_tail(*queue, strdup(req->pkgid));
+       }
 
-       if (locale)
-               icon->lang = strdup(locale);
-       else
-               icon->lang = strdup(DEFAULT_LOCALE);
-       icon->text = strdup(icon_txt);
-       mfx->icon = g_list_append(mfx->icon, icon);
+       sqlite3_finalize(stmt);
 
        return PMINFO_R_OK;
 }
 
-API int pkgmgrinfo_set_description_to_pkgdbinfo(pkgmgrinfo_pkgdbinfo_h handle, const char *desc_txt, const char *locale)
+static int _pkginfo_foreach_required_by(uid_t uid, const char *pkgid,
+               GList **pkg_list)
 {
-       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");
+       int ret;
+       char *dbpath;
+       sqlite3 *db;
+       GQueue *queue;
+       GHashTable *table;
+       char *item;
 
-       description = calloc(1, sizeof(description_x));
-       retvm_if(description == NULL, PMINFO_R_EINVAL, "Malloc Failed");
+       dbpath = getUserPkgParserDBPathUID(uid);
+       if (dbpath == NULL)
+               return PMINFO_R_ERROR;
 
-       if (locale)
-               description->lang = strdup(locale);
-       else
-               description->lang = strdup(DEFAULT_LOCALE);
-       description->text = strdup(desc_txt);
-       mfx->description = g_list_append(mfx->description, description);
+       ret = __open_db(dbpath, &db, SQLITE_OPEN_READONLY);
+       if (ret != SQLITE_OK) {
+               LOGD("failed to open db(%s): %d", dbpath, ret);
+               free(dbpath);
+               return PMINFO_R_ERROR;
+       }
+       free(dbpath);
 
-       return PMINFO_R_OK;
-}
+       queue = g_queue_new();
+       if (queue == NULL) {
+               LOGE("out of memory");
+               sqlite3_close_v2(db);
+               return PMINFO_R_ERROR;
+       }
 
-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;
+       table = g_hash_table_new_full(g_str_hash, g_str_equal, free, NULL);
 
-       retvm_if(!handle, PMINFO_R_EINVAL, "Argument supplied is NULL");
+       g_queue_push_tail(queue, strdup(pkgid));
+       while (!g_queue_is_empty(queue)) {
+               item = g_queue_pop_head(queue);
+               ret = _get_required_by(db, item, &queue, &table, pkg_list);
+               free(item);
+               if (ret != PMINFO_R_OK) {
+                       LOGE("failed to get required by pkgs");
+                       g_hash_table_destroy(table);
+                       g_queue_free_full(queue, free);
+                       sqlite3_close_v2(db);
+                       return PMINFO_R_ERROR;
+               }
+       }
 
-       author = calloc(1, sizeof(author_x));
-       retvm_if(author == NULL, PMINFO_R_EINVAL, "Argument supplied is NULL");
+       g_hash_table_destroy(table);
+       g_queue_free_full(queue, free);
+       sqlite3_close_v2(db);
 
-       if (author_name)
-               author->text = strdup(author_name);
-       if (author_email)
-               author->email = strdup(author_email);
-       if (author_href)
-               author->href = strdup(author_href);
-       if (locale)
-               author->lang = strdup(locale);
-       else
-               author->lang = strdup(DEFAULT_LOCALE);
-       mfx->author = g_list_append(mfx->author, author);
        return PMINFO_R_OK;
 }
 
-API int pkgmgrinfo_set_removable_to_pkgdbinfo(pkgmgrinfo_pkgdbinfo_h handle, int removable)
+static void __free_required_by(gpointer data)
 {
-       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);
+       struct required_by *req = (struct required_by *)data;
 
-       if (removable == 0)
-               mfx->removable = strdup("false");
-       else if (removable == 1)
-               mfx->removable = strdup("true");
-
-       return PMINFO_R_OK;
+       free(req->pkgid);
+       free(req->type);
+       free(req->version);
+       free(req);
 }
 
-API int pkgmgrinfo_set_preload_to_pkgdbinfo(pkgmgrinfo_pkgdbinfo_h handle, int preload)
+API int pkgmgrinfo_pkginfo_foreach_required_by(pkgmgrinfo_pkginfo_h handle,
+               pkgmgrinfo_pkg_dependency_list_cb dependency_cb,
+               void *user_data)
 {
-       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");
+       int ret;
+       pkgmgr_pkginfo_x *info = (pkgmgr_pkginfo_x *)handle;
+       GList *pkg_list = NULL;
+       GList *l;
+       struct required_by *req;
 
-       return PMINFO_R_OK;
-}
+       if (handle == NULL || dependency_cb == NULL || info->pkg_info == NULL) {
+               LOGE("invalid parameter");
+               return PMINFO_R_EINVAL;
+       }
 
-API int pkgmgrinfo_set_installed_storage_to_pkgdbinfo(pkgmgrinfo_pkgdbinfo_h handle, INSTALL_LOCATION location)
-{
-       manifest_x *mfx = (manifest_x *)handle;
+       ret = _pkginfo_foreach_required_by(info->uid, info->pkg_info->package,
+                       &pkg_list);
+       if (ret == PMINFO_R_OK && info->uid != GLOBAL_USER)
+               ret = _pkginfo_foreach_required_by(GLOBAL_USER,
+                               info->pkg_info->package, &pkg_list);
 
-       retvm_if(!handle, PMINFO_R_EINVAL, "Argument supplied is NULL");
-       retvm_if((location < 0) || (location > 1), PMINFO_R_EINVAL, "Argument supplied is NULL");
+       if (ret != PMINFO_R_OK) {
+               g_list_free_full(pkg_list, __free_required_by);
+               return ret;
+       }
 
-       if (mfx->installed_storage)
-               free((void *)mfx->installed_storage);
+       for (l = pkg_list; l != NULL; l = l->next) {
+               req = (struct required_by *)l->data;
+               ret = dependency_cb(req->pkgid, req->type, req->version,
+                               user_data);
+               if (ret < 0)
+                       break;
+       }
 
-       if (location == INSTALL_INTERNAL)
-               mfx->installed_storage = strdup("installed_internal");
-       else if (location == INSTALL_EXTERNAL)
-               mfx->installed_storage = strdup("installed_external");
+       g_list_free_full(pkg_list, __free_required_by);
 
        return PMINFO_R_OK;
 }
 
-API int pkgmgrinfo_save_pkgdbinfo(pkgmgrinfo_pkgdbinfo_h handle)
+int __compare_package_version(const char *version, int *major,
+               int *minor, int *macro, int *nano)
 {
-       int ret;
-       manifest_x *mfx = (manifest_x *)handle;
-       mfx = (manifest_x *)handle;
+       char *version_temp = NULL;
+       char *major_str = NULL;
+       char *minor_str = NULL;
+       char *macro_str = NULL;
+       char *nano_str = NULL;
+       char *save_str = NULL;
 
-       retvm_if(!handle, PMINFO_R_EINVAL, "Argument supplied is NULL");
+       if (version == NULL || major == NULL || minor == NULL ||
+               macro == NULL || nano == NULL) {
+               return PMINFO_R_EINVAL;
+       }
 
-       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");
+       version_temp = strdup(version);
+       if (version_temp == NULL) {
+               LOGE("Out of memory");
                return PMINFO_R_ERROR;
        }
-}
 
-API int pkgmgrinfo_save_pkgusrdbinfo(pkgmgrinfo_pkgdbinfo_h handle, uid_t uid)
-{
-       int ret;
-       manifest_x *mfx = (manifest_x *)handle;
+       major_str = strtok_r(version_temp, ".", &save_str);
+       if (major_str == NULL) {
+               _LOGE("major version is NULL");
+               free(version_temp);
+               return PMINFO_R_ERROR;
+       }
 
-       retvm_if(!handle, PMINFO_R_EINVAL, "Argument supplied is NULL");
+       minor_str = strtok_r(NULL, ".", &save_str);
+       if (minor_str == NULL) {
+               _LOGE("minor version is NULL");
+               free(version_temp);
+               return PMINFO_R_ERROR;
+       }
 
-       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;
+       *major = atoi(major_str);
+       *minor = atoi(minor_str);
+       *macro = 0;
+       *nano = 0;
+       macro_str = strtok_r(NULL, ".", &save_str);
+       if (macro_str == NULL) {
+               _LOGD("macro version is NULL");
        } else {
-               _LOGE("Failed to store info in DB\n");
-               return PMINFO_R_ERROR;
+               *macro = atoi(macro_str);
+               nano_str = strtok_r(NULL, ".", &save_str);
+               if (nano_str) {
+                       *nano = atoi(nano_str);
+                       _LOGD("nano version exists");
+               }
        }
+       _LOGD("version = [%s] -> major = [%d], minor = [%d]," \
+               " macro = [%d], nano = [%d]", version, *major,
+               *minor, *macro, *nano);
+
+       free(version_temp);
+
+       return PMINFO_R_OK;
 }
 
-API int pkgmgrinfo_destroy_pkgdbinfo(pkgmgrinfo_pkgdbinfo_h handle)
+API int pkgmgrinfo_compare_package_version(const char *current_version,
+               const char *target_version,
+               pkgmgrinfo_version_compare_type *res)
 {
-       manifest_x *mfx = (manifest_x *)handle;
+       int ret = 0;
+       int current_version_major = 0;
+       int current_version_minor = 0;
+       int current_version_macro = 0;
+       int current_version_nano = 0;
+       int target_version_major = 0;
+       int target_version_minor = 0;
+       int target_version_macro = 0;
+       int target_version_nano = 0;
 
-       retvm_if(!handle, PMINFO_R_EINVAL, "Argument supplied is NULL");
+       if (current_version == NULL || target_version == NULL ||
+               res == NULL) {
+               _LOGE("Invalid parameter");
+               return PMINFO_R_EINVAL;
+       }
 
-       pkgmgrinfo_basic_free_package(mfx);
+       ret = __compare_package_version(target_version,
+               &target_version_major, &target_version_minor,
+               &target_version_macro, &target_version_nano);
+       if (ret < 0) {
+               _LOGE("Failed to compare target version(%d)", ret);
+               return PMINFO_R_ERROR;
+       }
+
+       ret = __compare_package_version(current_version,
+               &current_version_major, &current_version_minor,
+               &current_version_macro, &current_version_nano);
+       if (ret < 0) {
+               _LOGE("Failed to compare current version(%d)", ret);
+               return PMINFO_R_ERROR;
+       }
+
+       _LOGD("new[%d.%d.%d.%d] old[%d.%d.%d.%d]", target_version_major,
+               target_version_minor, target_version_macro,
+               target_version_nano, current_version_major,
+               current_version_minor, current_version_macro,
+               target_version_nano);
+
+       if (target_version_major > current_version_major)
+               *res = PMINFO_VERSION_NEW;
+       else if (target_version_major < current_version_major)
+               *res = PMINFO_VERSION_OLD;
+       else if (target_version_minor > current_version_minor)
+               *res = PMINFO_VERSION_NEW;
+       else if (target_version_minor < current_version_minor)
+               *res = PMINFO_VERSION_OLD;
+       else if (target_version_macro > current_version_macro)
+               *res = PMINFO_VERSION_NEW;
+       else if (target_version_macro < current_version_macro)
+               *res = PMINFO_VERSION_OLD;
+       else if (target_version_nano > current_version_nano)
+               *res = PMINFO_VERSION_NEW;
+       else if (target_version_nano < current_version_nano)
+               *res = PMINFO_VERSION_OLD;
+       else
+               *res = PMINFO_VERSION_SAME;
 
        return PMINFO_R_OK;
 }