Add debugging log for disabled pkg/app for db
[platform/core/appfw/pkgmgr-info.git] / src / pkgmgrinfo_private.c
index 21b4840..e6d023d 100644 (file)
@@ -27,7 +27,6 @@
 #include <dlfcn.h>
 
 #include <vconf.h>
-#include <sqlite3.h>
 #include <glib.h>
 #include <unzip.h>
 
@@ -52,7 +51,8 @@ static struct _pkginfo_str_map_t pkginfo_str_prop_map[] = {
        {E_PMINFO_PKGINFO_PROP_PACKAGE_AUTHOR_NAME,     PMINFO_PKGINFO_PROP_PACKAGE_AUTHOR_NAME},
        {E_PMINFO_PKGINFO_PROP_PACKAGE_AUTHOR_EMAIL,    PMINFO_PKGINFO_PROP_PACKAGE_AUTHOR_EMAIL},
        {E_PMINFO_PKGINFO_PROP_PACKAGE_AUTHOR_HREF,     PMINFO_PKGINFO_PROP_PACKAGE_AUTHOR_HREF},
-       {E_PMINFO_PKGINFO_PROP_PACKAGE_PRIVILEGE,       PMINFO_PKGINFO_PROP_PACKAGE_PRIVILEGE}
+       {E_PMINFO_PKGINFO_PROP_PACKAGE_PRIVILEGE,       PMINFO_PKGINFO_PROP_PACKAGE_PRIVILEGE},
+       {E_PMINFO_PKGINFO_PROP_PACKAGE_RES_TYPE,        PMINFO_PKGINFO_PROP_PACKAGE_RES_TYPE}
 };
 
 struct _pkginfo_int_map_t {
@@ -78,7 +78,8 @@ static struct _pkginfo_bool_map_t pkginfo_bool_prop_map[] = {
        {E_PMINFO_PKGINFO_PROP_PACKAGE_NODISPLAY_SETTING,       PMINFO_PKGINFO_PROP_PACKAGE_NODISPLAY_SETTING},
        {E_PMINFO_PKGINFO_PROP_PACKAGE_SUPPORT_DISABLE, PMINFO_PKGINFO_PROP_PACKAGE_SUPPORT_DISABLE},
        {E_PMINFO_PKGINFO_PROP_PACKAGE_DISABLE, PMINFO_PKGINFO_PROP_PACKAGE_DISABLE},
-       {E_PMINFO_PKGINFO_PROP_PACKAGE_CHECK_STORAGE,   PMINFO_PKGINFO_PROP_PACKAGE_CHECK_STORAGE}
+       {E_PMINFO_PKGINFO_PROP_PACKAGE_CHECK_STORAGE,   PMINFO_PKGINFO_PROP_PACKAGE_CHECK_STORAGE},
+       {E_PMINFO_PKGINFO_PROP_PACKAGE_SYSTEM,          PMINFO_PKGINFO_PROP_PACKAGE_SYSTEM}
 };
 
 struct _appinfo_str_map_t {
@@ -99,7 +100,8 @@ static struct _appinfo_str_map_t appinfo_str_prop_map[] = {
        {E_PMINFO_APPINFO_PROP_APP_HWACCELERATION,      PMINFO_APPINFO_PROP_APP_HWACCELERATION},
        {E_PMINFO_APPINFO_PROP_APP_SCREENREADER,        PMINFO_APPINFO_PROP_APP_SCREENREADER},
        {E_PMINFO_APPINFO_PROP_APP_PACKAGE,     PMINFO_APPINFO_PROP_APP_PACKAGE},
-       {E_PMINFO_APPINFO_PROP_APP_INSTALLED_STORAGE,   PMINFO_APPINFO_PROP_APP_INSTALLED_STORAGE}
+       {E_PMINFO_APPINFO_PROP_APP_INSTALLED_STORAGE,   PMINFO_APPINFO_PROP_APP_INSTALLED_STORAGE},
+       {E_PMINFO_APPINFO_PROP_PRIVILEGE,       PMINFO_APPINFO_PROP_PRIVILEGE}
 };
 
 struct _appinfo_int_map_t {
@@ -126,10 +128,11 @@ static struct _appinfo_bool_map_t appinfo_bool_prop_map[] = {
        {E_PMINFO_APPINFO_PROP_APP_UI_GADGET,           PMINFO_APPINFO_PROP_APP_UI_GADGET},
        {E_PMINFO_APPINFO_PROP_APP_SUPPORT_DISABLE,             PMINFO_APPINFO_PROP_APP_SUPPORT_DISABLE},
        {E_PMINFO_APPINFO_PROP_APP_DISABLE,             PMINFO_APPINFO_PROP_APP_DISABLE},
-       {E_PMINFO_APPINFO_PROP_APP_CHECK_STORAGE,               PMINFO_APPINFO_PROP_APP_CHECK_STORAGE}
+       {E_PMINFO_APPINFO_PROP_APP_CHECK_STORAGE,               PMINFO_APPINFO_PROP_APP_CHECK_STORAGE},
+       {E_PMINFO_APPINFO_PROP_PKG_DISABLE,             PMINFO_APPINFO_PROP_PKG_DISABLE}
 };
 
-inline pkgmgrinfo_pkginfo_filter_prop_str _pminfo_pkginfo_convert_to_prop_str(const char *property)
+API pkgmgrinfo_pkginfo_filter_prop_str _pminfo_pkginfo_convert_to_prop_str(const char *property)
 {
        int i = 0;
        int max = 0;
@@ -147,7 +150,7 @@ inline pkgmgrinfo_pkginfo_filter_prop_str _pminfo_pkginfo_convert_to_prop_str(co
        return prop;
 }
 
-inline pkgmgrinfo_pkginfo_filter_prop_int _pminfo_pkginfo_convert_to_prop_int(const char *property)
+API pkgmgrinfo_pkginfo_filter_prop_int _pminfo_pkginfo_convert_to_prop_int(const char *property)
 {
        int i = 0;
        int max = 0;
@@ -165,7 +168,7 @@ inline pkgmgrinfo_pkginfo_filter_prop_int _pminfo_pkginfo_convert_to_prop_int(co
        return prop;
 }
 
-inline pkgmgrinfo_pkginfo_filter_prop_bool _pminfo_pkginfo_convert_to_prop_bool(const char *property)
+API pkgmgrinfo_pkginfo_filter_prop_bool _pminfo_pkginfo_convert_to_prop_bool(const char *property)
 {
        int i = 0;
        int max = 0;
@@ -183,7 +186,7 @@ inline pkgmgrinfo_pkginfo_filter_prop_bool _pminfo_pkginfo_convert_to_prop_bool(
        return prop;
 }
 
-inline pkgmgrinfo_appinfo_filter_prop_str _pminfo_appinfo_convert_to_prop_str(const char *property)
+API pkgmgrinfo_appinfo_filter_prop_str _pminfo_appinfo_convert_to_prop_str(const char *property)
 {
        int i = 0;
        int max = 0;
@@ -201,7 +204,7 @@ inline pkgmgrinfo_appinfo_filter_prop_str _pminfo_appinfo_convert_to_prop_str(co
        return prop;
 }
 
-inline pkgmgrinfo_appinfo_filter_prop_int _pminfo_appinfo_convert_to_prop_int(const char *property)
+API pkgmgrinfo_appinfo_filter_prop_int _pminfo_appinfo_convert_to_prop_int(const char *property)
 {
        int i = 0;
        int max = 0;
@@ -219,7 +222,7 @@ inline pkgmgrinfo_appinfo_filter_prop_int _pminfo_appinfo_convert_to_prop_int(co
        return prop;
 }
 
-inline pkgmgrinfo_appinfo_filter_prop_bool _pminfo_appinfo_convert_to_prop_bool(const char *property)
+API pkgmgrinfo_appinfo_filter_prop_bool _pminfo_appinfo_convert_to_prop_bool(const char *property)
 {
        int i = 0;
        int max = 0;
@@ -237,7 +240,17 @@ inline pkgmgrinfo_appinfo_filter_prop_bool _pminfo_appinfo_convert_to_prop_bool(
        return prop;
 }
 
-int __get_filter_condition(gpointer data, uid_t uid, char **condition, GList **params)
+void _pkgmgrinfo_node_destroy(pkgmgrinfo_node_x *node)
+{
+       if (node == NULL)
+               return;
+
+       free(node->value);
+       free(node->key);
+       free(node);
+}
+
+API int __get_filter_condition(gpointer data, uid_t uid, char **condition, GList **params)
 {
        pkgmgrinfo_node_x *node = (pkgmgrinfo_node_x *)data;
        char buf[MAX_QUERY_LEN] = {'\0'};
@@ -245,7 +258,6 @@ int __get_filter_condition(gpointer data, uid_t uid, char **condition, GList **p
        char *value;
        char *ptr = NULL;
        char *saveptr = NULL;
-       size_t len = 0;
 
        switch (node->prop) {
        case E_PMINFO_PKGINFO_PROP_PACKAGE_ID:
@@ -301,9 +313,23 @@ int __get_filter_condition(gpointer data, uid_t uid, char **condition, GList **p
                snprintf(buf, sizeof(buf), "pi.package_support_disable=? COLLATE NOCASE");
                break;
        case E_PMINFO_PKGINFO_PROP_PACKAGE_DISABLE:
-               snprintf(buf, sizeof(buf), "pi.package_disable=? COLLATE NOCASE");
-               break;
-
+               return 0;
+       case E_PMINFO_PKGINFO_PROP_PACKAGE_SYSTEM:
+               snprintf(buf, sizeof(buf), "pi.package_system=? COLLATE NOCASE");
+               break;
+       case E_PMINFO_PKGINFO_PROP_PACKAGE_RES_TYPE:
+               if (node->value == NULL || strlen(node->value) == 0) {
+                       *condition = strdup("package_res_info.res_type IS NOT NULL COLLATE NOCASE");
+                       if (*condition == NULL) {
+                               _LOGE("out of memeory");
+                               return 0;
+                       }
+                       return E_PMINFO_PKGINFO_JOIN_RES_INFO;
+               } else {
+                       snprintf(buf, sizeof(buf), "package_res_info.res_type=? COLLATE NOCASE");
+                       flag = E_PMINFO_PKGINFO_JOIN_RES_INFO;
+                       break;
+               }
        case E_PMINFO_APPINFO_PROP_APP_ID:
                snprintf(buf, sizeof(buf), "ai.app_id=?");
                break;
@@ -344,16 +370,13 @@ int __get_filter_condition(gpointer data, uid_t uid, char **condition, GList **p
                        free(value);
                        return 0;
                }
-               strncat(buf, "?", MAX_QUERY_LEN - len - 1);
-               len += strlen("?");
+               strncat(buf, "?", sizeof(buf) - strlen(buf) - 1);
                *params = g_list_append(*params, strdup(ptr));
                while ((ptr = strtok_r(NULL, ",", &saveptr))) {
-                       strncat(buf, ", ?", MAX_QUERY_LEN - len - 1);
-                       len += strlen(", ?");
+                       strncat(buf, ", ?", sizeof(buf) - strlen(buf) - 1);
                        *params = g_list_append(*params, strdup(ptr));
                }
-               strncat(buf, ")", MAX_QUERY_LEN - len - 1);
-               len += strlen("?");
+               strncat(buf, ")", sizeof(buf) - strlen(buf) - 1);
                *condition = strdup(buf);
                flag = E_PMINFO_APPINFO_JOIN_CATEGORY;
                free(value);
@@ -393,17 +416,14 @@ int __get_filter_condition(gpointer data, uid_t uid, char **condition, GList **p
                snprintf(buf, sizeof(buf), "ai.app_ui_gadget=? COLLATE NOCASE");
                break;
        case E_PMINFO_APPINFO_PROP_APP_DISABLE:
-               if (strcasecmp(node->value, "true") == 0)
-                       snprintf(buf, MAX_QUERY_LEN, "(ai.app_disable=? COLLATE NOCASE " \
-                                       "OR ui.is_disabled='true' COLLATE NOCASE)");
-               else
-                       snprintf(buf, MAX_QUERY_LEN, "(ai.app_disable=? COLLATE NOCASE " \
-                                       "AND (ui.is_disabled='false' COLLATE NOCASE " \
-                                       "OR ui.is_disabled IS NULL))");
+               return 0;
                break;
        case E_PMINFO_APPINFO_PROP_APP_SUPPORT_DISABLE:
                snprintf(buf, MAX_QUERY_LEN, "ai.app_support_disable=? COLLATE NOCASE");
                break;
+       case E_PMINFO_APPINFO_PROP_PKG_DISABLE:
+               return 0;
+               break;
        case E_PMINFO_APPINFO_PROP_APP_SUPPORT_MODE:
                snprintf(buf, sizeof(buf), "ai.app_support_mode=?");
                break;
@@ -411,6 +431,10 @@ int __get_filter_condition(gpointer data, uid_t uid, char **condition, GList **p
        case E_PMINFO_APPINFO_PROP_APP_CHECK_STORAGE:
                *condition = NULL;
                return 0;
+       case E_PMINFO_APPINFO_PROP_PRIVILEGE:
+               snprintf(buf, sizeof(buf), "package_privilege_info.privilege=?");
+               flag = E_PMINFO_APPINFO_JOIN_PRIVILEGE;
+               break;
        default:
                _LOGE("Invalid Property Type\n");
                *condition = NULL;
@@ -421,22 +445,37 @@ int __get_filter_condition(gpointer data, uid_t uid, char **condition, GList **p
        return flag;
 }
 
-int __get_metadata_filter_condition(gpointer data, char **condition,
+API int __get_pkg_metadata_filter_condition(gpointer data, char **condition,
+               GList **params)
+{
+       pkgmgrinfo_metadata_node_x *node = (pkgmgrinfo_metadata_node_x *)data;
+       char buf[MAX_QUERY_LEN];
+
+       snprintf(buf, sizeof(buf), "(package_metadata.md_key=?");
+       if (node->value)
+               strncat(buf, " AND package_metadata.md_value=?",
+                               sizeof(buf) - strlen(buf) - 1);
+       strncat(buf, ")", sizeof(buf) - strlen(buf) - 1);
+
+       *condition = strdup(buf);
+       *params = g_list_append(*params, strdup(node->key));
+       if (node->value)
+               *params = g_list_append(*params, strdup(node->value));
+
+       return E_PMINFO_PKGINFO_JOIN_METADATA;
+}
+
+API int __get_metadata_filter_condition(gpointer data, char **condition,
                GList **params)
 {
        pkgmgrinfo_metadata_node_x *node = (pkgmgrinfo_metadata_node_x *)data;
        char buf[MAX_QUERY_LEN];
-       size_t len = 0;
 
        snprintf(buf, sizeof(buf), "(package_app_app_metadata.md_key=?");
-       len += strlen("(package_app_app_metadata.md_key=?");
-       if (node->value) {
+       if (node->value)
                strncat(buf, " AND package_app_app_metadata.md_value=?",
-                               sizeof(buf) - len - 1);
-               len += strlen(" AND package_app_app_metadata.md_value=?");
-       }
-       strncat(buf, ")", sizeof(buf) - len - 1);
-       len += strlen(")");
+                               sizeof(buf) - strlen(buf) - 1);
+       strncat(buf, ")", sizeof(buf) - strlen(buf) - 1);
 
        *condition = strdup(buf);
        *params = g_list_append(*params, strdup(node->key));
@@ -446,7 +485,7 @@ int __get_metadata_filter_condition(gpointer data, char **condition,
        return E_PMINFO_APPINFO_JOIN_METADATA;
 }
 
-int _add_icon_info_into_list(const char *locale, char *value, GList **icon)
+API int _add_icon_info_into_list(const char *locale, char *value, GList **icon)
 {
        icon_x *info;
 
@@ -457,12 +496,12 @@ int _add_icon_info_into_list(const char *locale, char *value, GList **icon)
        }
        info->text = value;
        info->lang = strdup(locale);
-       *icon = g_list_append(*icon, info);
+       *icon = g_list_prepend(*icon, info);
 
        return PMINFO_R_OK;
 }
 
-int _add_label_info_into_list(const char *locale, char *value, GList **label)
+API int _add_label_info_into_list(const char *locale, char *value, GList **label)
 {
        label_x *info;
 
@@ -473,45 +512,12 @@ int _add_label_info_into_list(const char *locale, char *value, GList **label)
        }
        info->text = value;
        info->lang = strdup(locale);
-       *label = g_list_append(*label, info);
+       *label = g_list_prepend(*label, info);
 
        return PMINFO_R_OK;
 }
 
-char *_get_system_locale(void)
-{
-       char *lang;
-       char *locale;
-
-       lang = vconf_get_str(VCONFKEY_LANGSET);
-       if (lang == NULL) {
-               locale = strdup(DEFAULT_LOCALE);
-               if (locale == NULL) {
-                       LOGE("out of memory");
-                       return NULL;
-               }
-               return locale;
-       }
-
-       locale = malloc(sizeof(char) * 6);
-       if (locale == NULL) {
-               LOGE("out of memory");
-               free(lang);
-               return NULL;
-       }
-
-       strncpy(locale, lang, 2);
-       locale[2] = '-';
-       locale[3] = tolower(lang[3]);
-       locale[4] = tolower(lang[4]);
-       locale[5] = '\0';
-
-       free(lang);
-
-       return locale;
-}
-
-int __pkginfo_check_installed_storage(package_x *pkginfo)
+API int __pkginfo_check_installed_storage(package_x *pkginfo)
 {
        char buf[MAX_QUERY_LEN] = {'\0'};
        int ret;
@@ -532,7 +538,7 @@ int __pkginfo_check_installed_storage(package_x *pkginfo)
        return PMINFO_R_OK;
 }
 
-int __appinfo_check_installed_storage(application_x *appinfo)
+API int __appinfo_check_installed_storage(application_x *appinfo)
 {
        retvm_if(appinfo->installed_storage == NULL, PMINFO_R_ERROR,
                        "installed_storage is NULL\n");
@@ -549,51 +555,19 @@ int __appinfo_check_installed_storage(application_x *appinfo)
        return PMINFO_R_OK;
 }
 
-#define BUSY_WAITING_USEC (1000000 / 10 / 2) /* 0.05 sec */
-#define BUSY_WAITING_MAX 20 /* wait for max 1 sec */
-static int __db_busy_handler(void *data, int count)
-{
-       if (count < BUSY_WAITING_MAX) {
-               usleep(BUSY_WAITING_USEC);
-               return 1;
-       } else {
-               /* sqlite3_prepare_v2 will return SQLITE_BUSY */
-               return 0;
-       }
-}
-
-int __open_db(const char *path, sqlite3 **db, int flags)
-{
-       int ret;
-
-       ret = sqlite3_open_v2(path, db, flags, NULL);
-       if (ret != SQLITE_OK)
-               return ret;
-
-       ret = sqlite3_busy_handler(*db, __db_busy_handler, NULL);
-       if (ret != SQLITE_OK) {
-               _LOGE("failed to register busy handler: %s",
-                               sqlite3_errmsg(*db));
-               sqlite3_close_v2(*db);
-               return ret;
-       }
-
-       return ret;
-}
-
 struct type_map {
        const char *manifest;
        const char *type;
 };
 
-struct type_map type_map[] = {
+const struct type_map type_map[] = {
        { "res/wgt/config.xml", "wgt" },
        { "config.xml", "wgt" },
        { "tizen-manifest.xml", "tpk" },
        { NULL, NULL}
 };
 
-char *__get_type_from_path(const char *pkg_path)
+API char *__get_type_from_path(const char *pkg_path)
 {
        const char *type = NULL;
        unzFile uf;
@@ -623,26 +597,24 @@ char *__get_type_from_path(const char *pkg_path)
        return strdup(type);
 }
 
-static const char *__get_library_path(const char *pkg_type)
+static void __get_library_path(const char *pkg_type, const char **path)
 {
        char buf[64];
-       const char *path;
 
        snprintf(buf, sizeof(buf), "package-manager/backendlib/lib%s.so",
                        pkg_type);
-       path = tzplatform_mkpath(TZ_SYS_RO_ETC, buf);
 
-       return path;
+       *path = tzplatform_mkpath(TZ_SYS_RO_ETC, buf);
 }
 
-pkg_plugin_set *__load_library(const char *pkg_type)
+API pkg_plugin_set *__load_library(const char *pkg_type)
 {
        void *library_handle;
        pkg_plugin_set *plugin_set;
        bool (*on_load)(pkg_plugin_set *plugin);
        const char *library_path;
 
-       library_path = __get_library_path(pkg_type);
+       __get_library_path(pkg_type, &library_path);
        if (library_path == NULL) {
                _LOGE("cannot get library path for %s", pkg_type);
                return NULL;
@@ -664,13 +636,14 @@ pkg_plugin_set *__load_library(const char *pkg_type)
                return plugin_set;
        }
 
-       if ((library_handle = dlopen(library_path, RTLD_LAZY)) == NULL) {
+       library_handle = dlopen(library_path, RTLD_LAZY);
+       if (library_handle == NULL) {
                _LOGE("dlopen is failed library_path[%s]", library_path);
                return NULL;
        }
 
-       if ((on_load = dlsym(library_handle, "pkg_plugin_on_load")) == NULL ||
-                       dlerror() != NULL) {
+       on_load = dlsym(library_handle, "pkg_plugin_on_load");
+       if (on_load == NULL || dlerror() != NULL) {
                _LOGE("cannot find symbol");
                dlclose(library_handle);
                return NULL;
@@ -703,7 +676,7 @@ pkg_plugin_set *__load_library(const char *pkg_type)
        return plugin_set;
 }
 
-void __unload_library(const char *pkg_type)
+API void __unload_library(const char *pkg_type)
 {
        pkg_plugin_set *plugin_set;