src/pkgmgrinfo_private.c

   1 /*
   2  * pkgmgr-info
   3  *
   4  * Copyright (c) 2000 - 2011 Samsung Electronics Co., Ltd. All rights reserved.
   5  *
   6  * Contact: Jayoun Lee <airjany@samsung.com>, Sewook Park <sewook7.park@samsung.com>,
   7  * Jaeho Lee <jaeho81.lee@samsung.com>, Shobhit Srivastava <shobhit.s@samsung.com>
   8  *
   9  * Licensed under the Apache License, Version 2.0 (the "License");
  10  * you may not use this file except in compliance with the License.
  11  * You may obtain a copy of the License at
  12  *
  13  * http://www.apache.org/licenses/LICENSE-2.0
  14  *
  15  * Unless required by applicable law or agreed to in writing, software
  16  * distributed under the License is distributed on an "AS IS" BASIS,
  17  * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  18  * See the License for the specific language governing permissions and
  19  * limitations under the License.
  20  *
  21  */
  22
  23 #include <stdlib.h>
  24 #include <string.h>
  25 #include <stdio.h>
  26 #include <ctype.h>
  27 #include <dlfcn.h>
  28
  29 #include <vconf.h>
  30 #include <sqlite3.h>
  31 #include <glib.h>
  32 #include <unzip.h>
  33
  34 #include "pkgmgr-info.h"
  35 #include "pkgmgrinfo_debug.h"
  36 #include "pkgmgrinfo_private.h"
  37 #include "pkgmgr_parser.h"
  38
  39 static GHashTable *plugin_set_list;
  40
  41 struct _pkginfo_str_map_t {
  42         pkgmgrinfo_pkginfo_filter_prop_str prop;
  43         const char *property;
  44 };
  45
  46 static struct _pkginfo_str_map_t pkginfo_str_prop_map[] = {
  47         {E_PMINFO_PKGINFO_PROP_PACKAGE_ID,      PMINFO_PKGINFO_PROP_PACKAGE_ID},
  48         {E_PMINFO_PKGINFO_PROP_PACKAGE_TYPE,    PMINFO_PKGINFO_PROP_PACKAGE_TYPE},
  49         {E_PMINFO_PKGINFO_PROP_PACKAGE_VERSION, PMINFO_PKGINFO_PROP_PACKAGE_VERSION},
  50         {E_PMINFO_PKGINFO_PROP_PACKAGE_INSTALL_LOCATION,        PMINFO_PKGINFO_PROP_PACKAGE_INSTALL_LOCATION},
  51         {E_PMINFO_PKGINFO_PROP_PACKAGE_INSTALLED_STORAGE,       PMINFO_PKGINFO_PROP_PACKAGE_INSTALLED_STORAGE},
  52         {E_PMINFO_PKGINFO_PROP_PACKAGE_AUTHOR_NAME,     PMINFO_PKGINFO_PROP_PACKAGE_AUTHOR_NAME},
  53         {E_PMINFO_PKGINFO_PROP_PACKAGE_AUTHOR_EMAIL,    PMINFO_PKGINFO_PROP_PACKAGE_AUTHOR_EMAIL},
  54         {E_PMINFO_PKGINFO_PROP_PACKAGE_AUTHOR_HREF,     PMINFO_PKGINFO_PROP_PACKAGE_AUTHOR_HREF},
  55         {E_PMINFO_PKGINFO_PROP_PACKAGE_PRIVILEGE,       PMINFO_PKGINFO_PROP_PACKAGE_PRIVILEGE}
  56 };
  57
  58 struct _pkginfo_int_map_t {
  59         pkgmgrinfo_pkginfo_filter_prop_int prop;
  60         const char *property;
  61 };
  62
  63 static struct _pkginfo_int_map_t pkginfo_int_prop_map[] = {
  64         {E_PMINFO_PKGINFO_PROP_PACKAGE_SIZE,    PMINFO_PKGINFO_PROP_PACKAGE_SIZE}
  65 };
  66
  67 struct _pkginfo_bool_map_t {
  68         pkgmgrinfo_pkginfo_filter_prop_bool prop;
  69         const char *property;
  70 };
  71
  72 static struct _pkginfo_bool_map_t pkginfo_bool_prop_map[] = {
  73         {E_PMINFO_PKGINFO_PROP_PACKAGE_REMOVABLE,       PMINFO_PKGINFO_PROP_PACKAGE_REMOVABLE},
  74         {E_PMINFO_PKGINFO_PROP_PACKAGE_PRELOAD,         PMINFO_PKGINFO_PROP_PACKAGE_PRELOAD},
  75         {E_PMINFO_PKGINFO_PROP_PACKAGE_READONLY,        PMINFO_PKGINFO_PROP_PACKAGE_READONLY},
  76         {E_PMINFO_PKGINFO_PROP_PACKAGE_UPDATE,          PMINFO_PKGINFO_PROP_PACKAGE_UPDATE},
  77         {E_PMINFO_PKGINFO_PROP_PACKAGE_APPSETTING,      PMINFO_PKGINFO_PROP_PACKAGE_APPSETTING},
  78         {E_PMINFO_PKGINFO_PROP_PACKAGE_NODISPLAY_SETTING,       PMINFO_PKGINFO_PROP_PACKAGE_NODISPLAY_SETTING},
  79         {E_PMINFO_PKGINFO_PROP_PACKAGE_SUPPORT_DISABLE, PMINFO_PKGINFO_PROP_PACKAGE_SUPPORT_DISABLE},
  80         {E_PMINFO_PKGINFO_PROP_PACKAGE_DISABLE, PMINFO_PKGINFO_PROP_PACKAGE_DISABLE},
  81         {E_PMINFO_PKGINFO_PROP_PACKAGE_CHECK_STORAGE,   PMINFO_PKGINFO_PROP_PACKAGE_CHECK_STORAGE},
  82         {E_PMINFO_PKGINFO_PROP_PACKAGE_SYSTEM,          PMINFO_PKGINFO_PROP_PACKAGE_SYSTEM}
  83 };
  84
  85 struct _appinfo_str_map_t {
  86         pkgmgrinfo_appinfo_filter_prop_str prop;
  87         const char *property;
  88 };
  89
  90 static struct _appinfo_str_map_t appinfo_str_prop_map[] = {
  91         {E_PMINFO_APPINFO_PROP_APP_ID,          PMINFO_APPINFO_PROP_APP_ID},
  92         {E_PMINFO_APPINFO_PROP_APP_COMPONENT,   PMINFO_APPINFO_PROP_APP_COMPONENT},
  93         {E_PMINFO_APPINFO_PROP_APP_EXEC,        PMINFO_APPINFO_PROP_APP_EXEC},
  94         {E_PMINFO_APPINFO_PROP_APP_ICON,        PMINFO_APPINFO_PROP_APP_ICON},
  95         {E_PMINFO_APPINFO_PROP_APP_TYPE,        PMINFO_APPINFO_PROP_APP_TYPE},
  96         {E_PMINFO_APPINFO_PROP_APP_OPERATION,   PMINFO_APPINFO_PROP_APP_OPERATION},
  97         {E_PMINFO_APPINFO_PROP_APP_URI, PMINFO_APPINFO_PROP_APP_URI},
  98         {E_PMINFO_APPINFO_PROP_APP_MIME,        PMINFO_APPINFO_PROP_APP_MIME},
  99         {E_PMINFO_APPINFO_PROP_APP_CATEGORY,    PMINFO_APPINFO_PROP_APP_CATEGORY},
 100         {E_PMINFO_APPINFO_PROP_APP_HWACCELERATION,      PMINFO_APPINFO_PROP_APP_HWACCELERATION},
 101         {E_PMINFO_APPINFO_PROP_APP_SCREENREADER,        PMINFO_APPINFO_PROP_APP_SCREENREADER},
 102         {E_PMINFO_APPINFO_PROP_APP_PACKAGE,     PMINFO_APPINFO_PROP_APP_PACKAGE},
 103         {E_PMINFO_APPINFO_PROP_APP_INSTALLED_STORAGE,   PMINFO_APPINFO_PROP_APP_INSTALLED_STORAGE},
 104         {E_PMINFO_APPINFO_PROP_PRIVILEGE,       PMINFO_APPINFO_PROP_PRIVILEGE}
 105 };
 106
 107 struct _appinfo_int_map_t {
 108         pkgmgrinfo_appinfo_filter_prop_int prop;
 109         const char *property;
 110 };
 111
 112 static struct _appinfo_int_map_t appinfo_int_prop_map[] = {
 113         {E_PMINFO_APPINFO_PROP_APP_SUPPORT_MODE,        PMINFO_APPINFO_PROP_APP_SUPPORT_MODE}
 114 };
 115
 116 struct _appinfo_bool_map_t {
 117         pkgmgrinfo_appinfo_filter_prop_bool prop;
 118         const char *property;
 119 };
 120
 121 static struct _appinfo_bool_map_t appinfo_bool_prop_map[] = {
 122         {E_PMINFO_APPINFO_PROP_APP_NODISPLAY,           PMINFO_APPINFO_PROP_APP_NODISPLAY},
 123         {E_PMINFO_APPINFO_PROP_APP_MULTIPLE,            PMINFO_APPINFO_PROP_APP_MULTIPLE},
 124         {E_PMINFO_APPINFO_PROP_APP_ONBOOT,              PMINFO_APPINFO_PROP_APP_ONBOOT},
 125         {E_PMINFO_APPINFO_PROP_APP_AUTORESTART,         PMINFO_APPINFO_PROP_APP_AUTORESTART},
 126         {E_PMINFO_APPINFO_PROP_APP_TASKMANAGE,          PMINFO_APPINFO_PROP_APP_TASKMANAGE},
 127         {E_PMINFO_APPINFO_PROP_APP_LAUNCHCONDITION,             PMINFO_APPINFO_PROP_APP_LAUNCHCONDITION},
 128         {E_PMINFO_APPINFO_PROP_APP_UI_GADGET,           PMINFO_APPINFO_PROP_APP_UI_GADGET},
 129         {E_PMINFO_APPINFO_PROP_APP_SUPPORT_DISABLE,             PMINFO_APPINFO_PROP_APP_SUPPORT_DISABLE},
 130         {E_PMINFO_APPINFO_PROP_APP_DISABLE,             PMINFO_APPINFO_PROP_APP_DISABLE},
 131         {E_PMINFO_APPINFO_PROP_APP_CHECK_STORAGE,               PMINFO_APPINFO_PROP_APP_CHECK_STORAGE},
 132         {E_PMINFO_APPINFO_PROP_PKG_DISABLE,             PMINFO_APPINFO_PROP_PKG_DISABLE}
 133 };
 134
 135 API pkgmgrinfo_pkginfo_filter_prop_str _pminfo_pkginfo_convert_to_prop_str(const char *property)
 136 {
 137         int i = 0;
 138         int max = 0;
 139         pkgmgrinfo_pkginfo_filter_prop_str prop = -1;
 140
 141         if (property == NULL)
 142                 return -1;
 143         max = E_PMINFO_PKGINFO_PROP_PACKAGE_MAX_STR - E_PMINFO_PKGINFO_PROP_PACKAGE_MIN_STR + 1;
 144         for (i = 0 ; i < max; i++) {
 145                 if (strcmp(property, pkginfo_str_prop_map[i].property) == 0) {
 146                         prop =  pkginfo_str_prop_map[i].prop;
 147                         break;
 148                 }
 149         }
 150         return prop;
 151 }
 152
 153 API pkgmgrinfo_pkginfo_filter_prop_int _pminfo_pkginfo_convert_to_prop_int(const char *property)
 154 {
 155         int i = 0;
 156         int max = 0;
 157         pkgmgrinfo_pkginfo_filter_prop_int prop = -1;
 158
 159         if (property == NULL)
 160                 return -1;
 161         max = E_PMINFO_PKGINFO_PROP_PACKAGE_MAX_INT - E_PMINFO_PKGINFO_PROP_PACKAGE_MIN_INT + 1;
 162         for (i = 0 ; i < max; i++) {
 163                 if (strcmp(property, pkginfo_int_prop_map[i].property) == 0) {
 164                         prop =  pkginfo_int_prop_map[i].prop;
 165                         break;
 166                 }
 167         }
 168         return prop;
 169 }
 170
 171 API pkgmgrinfo_pkginfo_filter_prop_bool _pminfo_pkginfo_convert_to_prop_bool(const char *property)
 172 {
 173         int i = 0;
 174         int max = 0;
 175         pkgmgrinfo_pkginfo_filter_prop_bool prop = -1;
 176
 177         if (property == NULL)
 178                 return -1;
 179         max = E_PMINFO_PKGINFO_PROP_PACKAGE_MAX_BOOL - E_PMINFO_PKGINFO_PROP_PACKAGE_MIN_BOOL + 1;
 180         for (i = 0 ; i < max; i++) {
 181                 if (strcmp(property, pkginfo_bool_prop_map[i].property) == 0) {
 182                         prop =  pkginfo_bool_prop_map[i].prop;
 183                         break;
 184                 }
 185         }
 186         return prop;
 187 }
 188
 189 API pkgmgrinfo_appinfo_filter_prop_str _pminfo_appinfo_convert_to_prop_str(const char *property)
 190 {
 191         int i = 0;
 192         int max = 0;
 193         pkgmgrinfo_appinfo_filter_prop_str prop = -1;
 194
 195         if (property == NULL)
 196                 return -1;
 197         max = E_PMINFO_APPINFO_PROP_APP_MAX_STR - E_PMINFO_APPINFO_PROP_APP_MIN_STR + 1;
 198         for (i = 0 ; i < max; i++) {
 199                 if (strcmp(property, appinfo_str_prop_map[i].property) == 0) {
 200                         prop =  appinfo_str_prop_map[i].prop;
 201                         break;
 202                 }
 203         }
 204         return prop;
 205 }
 206
 207 API pkgmgrinfo_appinfo_filter_prop_int _pminfo_appinfo_convert_to_prop_int(const char *property)
 208 {
 209         int i = 0;
 210         int max = 0;
 211         pkgmgrinfo_appinfo_filter_prop_int prop = -1;
 212
 213         if (property == NULL)
 214                 return -1;
 215         max = E_PMINFO_APPINFO_PROP_APP_MAX_INT - E_PMINFO_APPINFO_PROP_APP_MIN_INT + 1;
 216         for (i = 0 ; i < max; i++) {
 217                 if (strcmp(property, appinfo_int_prop_map[i].property) == 0) {
 218                         prop =  appinfo_int_prop_map[i].prop;
 219                         break;
 220                 }
 221         }
 222         return prop;
 223 }
 224
 225 API pkgmgrinfo_appinfo_filter_prop_bool _pminfo_appinfo_convert_to_prop_bool(const char *property)
 226 {
 227         int i = 0;
 228         int max = 0;
 229         pkgmgrinfo_appinfo_filter_prop_bool prop = -1;
 230
 231         if (property == NULL)
 232                 return -1;
 233         max = E_PMINFO_APPINFO_PROP_APP_MAX_BOOL - E_PMINFO_APPINFO_PROP_APP_MIN_BOOL + 1;
 234         for (i = 0 ; i < max; i++) {
 235                 if (strcmp(property, appinfo_bool_prop_map[i].property) == 0) {
 236                         prop =  appinfo_bool_prop_map[i].prop;
 237                         break;
 238                 }
 239         }
 240         return prop;
 241 }
 242
 243 void _pkgmgrinfo_node_destroy(pkgmgrinfo_node_x *node)
 244 {
 245         if (node == NULL)
 246                 return;
 247
 248         free(node->value);
 249         free(node->key);
 250         free(node);
 251 }
 252
 253 API int __get_filter_condition(gpointer data, uid_t uid, char **condition, GList **params)
 254 {
 255         pkgmgrinfo_node_x *node = (pkgmgrinfo_node_x *)data;
 256         char buf[MAX_QUERY_LEN] = {'\0'};
 257         int flag = 0;
 258         char *value;
 259         char *ptr = NULL;
 260         char *saveptr = NULL;
 261
 262         switch (node->prop) {
 263         case E_PMINFO_PKGINFO_PROP_PACKAGE_ID:
 264                 snprintf(buf, sizeof(buf), "pi.package=?");
 265                 break;
 266         case E_PMINFO_PKGINFO_PROP_PACKAGE_TYPE:
 267                 snprintf(buf, sizeof(buf), "pi.package_type=?");
 268                 break;
 269         case E_PMINFO_PKGINFO_PROP_PACKAGE_VERSION:
 270                 snprintf(buf, sizeof(buf), "pi.package_version=?");
 271                 break;
 272         case E_PMINFO_PKGINFO_PROP_PACKAGE_INSTALL_LOCATION:
 273                 snprintf(buf, sizeof(buf), "pi.install_location=?");
 274                 break;
 275         case E_PMINFO_PKGINFO_PROP_PACKAGE_INSTALLED_STORAGE:
 276                 snprintf(buf, sizeof(buf), "pi.installed_storage=?");
 277                 break;
 278         case E_PMINFO_PKGINFO_PROP_PACKAGE_AUTHOR_NAME:
 279                 snprintf(buf, sizeof(buf), "pi.author_name=?");
 280                 break;
 281         case E_PMINFO_PKGINFO_PROP_PACKAGE_AUTHOR_HREF:
 282                 snprintf(buf, sizeof(buf), "pi.author_href=?");
 283                 break;
 284         case E_PMINFO_PKGINFO_PROP_PACKAGE_AUTHOR_EMAIL:
 285                 snprintf(buf, sizeof(buf), "pi.author_email=?");
 286                 break;
 287         case E_PMINFO_PKGINFO_PROP_PACKAGE_PRIVILEGE:
 288                 snprintf(buf, sizeof(buf), "package_privilege_info.privilege=?");
 289                 flag = E_PMINFO_PKGINFO_JOIN_PRIVILEGE_INFO;
 290                 break;
 291         case E_PMINFO_PKGINFO_PROP_PACKAGE_SIZE:
 292                 snprintf(buf, sizeof(buf), "pi.package_size=?");
 293                 break;
 294         case E_PMINFO_PKGINFO_PROP_PACKAGE_REMOVABLE:
 295                 snprintf(buf, sizeof(buf), "pi.package_removable=? COLLATE NOCASE");
 296                 break;
 297         case E_PMINFO_PKGINFO_PROP_PACKAGE_PRELOAD:
 298                 snprintf(buf, sizeof(buf), "pi.package_preload=? COLLATE NOCASE");
 299                 break;
 300         case E_PMINFO_PKGINFO_PROP_PACKAGE_READONLY:
 301                 snprintf(buf, sizeof(buf), "pi.package_readonly=? COLLATE NOCASE");
 302                 break;
 303         case E_PMINFO_PKGINFO_PROP_PACKAGE_UPDATE:
 304                 snprintf(buf, sizeof(buf), "pi.package_update=? COLLATE NOCASE");
 305                 break;
 306         case E_PMINFO_PKGINFO_PROP_PACKAGE_APPSETTING:
 307                 snprintf(buf, sizeof(buf), "pi.package_appsetting=? COLLATE NOCASE");
 308                 break;
 309         case E_PMINFO_PKGINFO_PROP_PACKAGE_NODISPLAY_SETTING:
 310                 snprintf(buf, sizeof(buf), "pi.package_nodisplay=? COLLATE NOCASE");
 311                 break;
 312         case E_PMINFO_PKGINFO_PROP_PACKAGE_SUPPORT_DISABLE:
 313                 snprintf(buf, sizeof(buf), "pi.package_support_disable=? COLLATE NOCASE");
 314                 break;
 315         case E_PMINFO_PKGINFO_PROP_PACKAGE_DISABLE:
 316                 snprintf(buf, sizeof(buf), "pi.package_disable=? COLLATE NOCASE");
 317                 break;
 318         case E_PMINFO_PKGINFO_PROP_PACKAGE_SYSTEM:
 319                 snprintf(buf, sizeof(buf), "pi.package_system=? COLLATE NOCASE");
 320                 break;
 321
 322         case E_PMINFO_APPINFO_PROP_APP_ID:
 323                 snprintf(buf, sizeof(buf), "ai.app_id=?");
 324                 break;
 325         case E_PMINFO_APPINFO_PROP_APP_COMPONENT:
 326                 snprintf(buf, sizeof(buf), "ai.app_component=?");
 327                 break;
 328         case E_PMINFO_APPINFO_PROP_APP_EXEC:
 329                 snprintf(buf, sizeof(buf), "ai.app_exec=?");
 330                 break;
 331         case E_PMINFO_APPINFO_PROP_APP_ICON:
 332                 snprintf(buf, sizeof(buf), "package_app_localized_info.app_icon=?");
 333                 flag = E_PMINFO_APPINFO_JOIN_LOCALIZED_INFO;
 334                 break;
 335         case E_PMINFO_APPINFO_PROP_APP_TYPE:
 336                 snprintf(buf, sizeof(buf), "ai.app_type=?");
 337                 break;
 338         case E_PMINFO_APPINFO_PROP_APP_OPERATION:
 339                 snprintf(buf, sizeof(buf), "package_app_app_control.app_control LIKE ?||'|%%%%|%%%%'");
 340                 flag = E_PMINFO_APPINFO_JOIN_APP_CONTROL;
 341                 break;
 342         case E_PMINFO_APPINFO_PROP_APP_URI:
 343                 snprintf(buf, sizeof(buf), "package_app_app_control.app_control LIKE '%%%%|'||?||'|%%%%'");
 344                 flag = E_PMINFO_APPINFO_JOIN_APP_CONTROL;
 345                 break;
 346         case E_PMINFO_APPINFO_PROP_APP_MIME:
 347                 snprintf(buf, sizeof(buf), "package_app_app_control.app_control LIKE '%%%%|%%%%|'||?");
 348                 flag = E_PMINFO_APPINFO_JOIN_APP_CONTROL;
 349                 break;
 350         case E_PMINFO_APPINFO_PROP_APP_CATEGORY:
 351                 snprintf(buf, sizeof(buf), "package_app_app_category.category IN (");
 352                 value = strdup(node->value);
 353                 if (value == NULL) {
 354                         _LOGE("out of memeory");
 355                         return 0;
 356                 }
 357                 ptr = strtok_r(value, ",", &saveptr);
 358                 if (ptr == NULL) {
 359                         free(value);
 360                         return 0;
 361                 }
 362                 strncat(buf, "?", sizeof(buf) - strlen(buf) - 1);
 363                 *params = g_list_append(*params, strdup(ptr));
 364                 while ((ptr = strtok_r(NULL, ",", &saveptr))) {
 365                         strncat(buf, ", ?", sizeof(buf) - strlen(buf) - 1);
 366                         *params = g_list_append(*params, strdup(ptr));
 367                 }
 368                 strncat(buf, ")", sizeof(buf) - strlen(buf) - 1);
 369                 *condition = strdup(buf);
 370                 flag = E_PMINFO_APPINFO_JOIN_CATEGORY;
 371                 free(value);
 372
 373                 return flag;
 374         case E_PMINFO_APPINFO_PROP_APP_NODISPLAY:
 375                 snprintf(buf, sizeof(buf), "ai.app_nodisplay=? COLLATE NOCASE");
 376                 break;
 377         case E_PMINFO_APPINFO_PROP_APP_MULTIPLE:
 378                 snprintf(buf, sizeof(buf), "ai.app_multiple=? COLLATE NOCASE");
 379                 break;
 380         case E_PMINFO_APPINFO_PROP_APP_ONBOOT:
 381                 snprintf(buf, sizeof(buf), "ai.app_onboot=? COLLATE NOCASE");
 382                 break;
 383         case E_PMINFO_APPINFO_PROP_APP_AUTORESTART:
 384                 snprintf(buf, sizeof(buf), "ai.app_autorestart=? COLLATE NOCASE");
 385                 break;
 386         case E_PMINFO_APPINFO_PROP_APP_TASKMANAGE:
 387                 snprintf(buf, sizeof(buf), "ai.app_taskmanage=? COLLATE NOCASE");
 388                 break;
 389         case E_PMINFO_APPINFO_PROP_APP_HWACCELERATION:
 390                 snprintf(buf, sizeof(buf), "ai.app_hwacceleration=?");
 391                 break;
 392         case E_PMINFO_APPINFO_PROP_APP_SCREENREADER:
 393                 snprintf(buf, sizeof(buf), "ai.app_screenreader=?");
 394                 break;
 395         case E_PMINFO_APPINFO_PROP_APP_LAUNCHCONDITION:
 396                 snprintf(buf, sizeof(buf), "ai.app_launchcondition=? COLLATE NOCASE");
 397                 break;
 398         case E_PMINFO_APPINFO_PROP_APP_PACKAGE:
 399                 snprintf(buf, sizeof(buf), "ai.package=?");
 400                 break;
 401         case E_PMINFO_APPINFO_PROP_APP_INSTALLED_STORAGE:
 402                 snprintf(buf, sizeof(buf), "ai.app_installed_storage=?");
 403                 break;
 404         case E_PMINFO_APPINFO_PROP_APP_UI_GADGET:
 405                 snprintf(buf, sizeof(buf), "ai.app_ui_gadget=? COLLATE NOCASE");
 406                 break;
 407         case E_PMINFO_APPINFO_PROP_APP_DISABLE:
 408                 if (strcasecmp(node->value, "true") == 0)
 409                         snprintf(buf, MAX_QUERY_LEN, "(ai.app_disable=? COLLATE NOCASE " \
 410                                         "OR ui.is_disabled='true' COLLATE NOCASE)");
 411                 else
 412                         snprintf(buf, MAX_QUERY_LEN, "(ai.app_disable=? COLLATE NOCASE " \
 413                                         "AND (ui.is_disabled='false' COLLATE NOCASE " \
 414                                         "OR ui.is_disabled IS NULL))");
 415                 break;
 416         case E_PMINFO_APPINFO_PROP_APP_SUPPORT_DISABLE:
 417                 snprintf(buf, MAX_QUERY_LEN, "ai.app_support_disable=? COLLATE NOCASE");
 418                 break;
 419         case E_PMINFO_APPINFO_PROP_PKG_DISABLE:
 420                 snprintf(buf, MAX_QUERY_LEN,
 421                                 "ai.package IN (SELECT package FROM " \
 422                                 "package_info WHERE package_disable=?)");
 423                 break;
 424         case E_PMINFO_APPINFO_PROP_APP_SUPPORT_MODE:
 425                 snprintf(buf, sizeof(buf), "ai.app_support_mode=?");
 426                 break;
 427         case E_PMINFO_PKGINFO_PROP_PACKAGE_CHECK_STORAGE:
 428         case E_PMINFO_APPINFO_PROP_APP_CHECK_STORAGE:
 429                 *condition = NULL;
 430                 return 0;
 431         case E_PMINFO_APPINFO_PROP_PRIVILEGE:
 432                 snprintf(buf, sizeof(buf), "package_privilege_info.privilege=?");
 433                 flag = E_PMINFO_APPINFO_JOIN_PRIVILEGE;
 434                 break;
 435         default:
 436                 _LOGE("Invalid Property Type\n");
 437                 *condition = NULL;
 438                 return 0;
 439         }
 440         *condition = strdup(buf);
 441         *params = g_list_append(*params, strdup(node->value));
 442         return flag;
 443 }
 444
 445 API int __get_metadata_filter_condition(gpointer data, char **condition,
 446                 GList **params)
 447 {
 448         pkgmgrinfo_metadata_node_x *node = (pkgmgrinfo_metadata_node_x *)data;
 449         char buf[MAX_QUERY_LEN];
 450
 451         snprintf(buf, sizeof(buf), "(package_app_app_metadata.md_key=?");
 452         if (node->value)
 453                 strncat(buf, " AND package_app_app_metadata.md_value=?",
 454                                 sizeof(buf) - strlen(buf) - 1);
 455         strncat(buf, ")", sizeof(buf) - strlen(buf) - 1);
 456
 457         *condition = strdup(buf);
 458         *params = g_list_append(*params, strdup(node->key));
 459         if (node->value)
 460                 *params = g_list_append(*params, strdup(node->value));
 461
 462         return E_PMINFO_APPINFO_JOIN_METADATA;
 463 }
 464
 465 API int _add_icon_info_into_list(const char *locale, char *value, GList **icon)
 466 {
 467         icon_x *info;
 468
 469         info = calloc(1, sizeof(icon_x));
 470         if (info == NULL) {
 471                 LOGE("out of memory");
 472                 return PMINFO_R_ERROR;
 473         }
 474         info->text = value;
 475         info->lang = strdup(locale);
 476         *icon = g_list_prepend(*icon, info);
 477
 478         return PMINFO_R_OK;
 479 }
 480
 481 API int _add_label_info_into_list(const char *locale, char *value, GList **label)
 482 {
 483         label_x *info;
 484
 485         info = calloc(1, sizeof(label_x));
 486         if (info == NULL) {
 487                 LOGE("out of memory");
 488                 return PMINFO_R_ERROR;
 489         }
 490         info->text = value;
 491         info->lang = strdup(locale);
 492         *label = g_list_prepend(*label, info);
 493
 494         return PMINFO_R_OK;
 495 }
 496
 497 API int __pkginfo_check_installed_storage(package_x *pkginfo)
 498 {
 499         char buf[MAX_QUERY_LEN] = {'\0'};
 500         int ret;
 501
 502         retvm_if(pkginfo->package == NULL, PMINFO_R_OK, "pkgid is NULL\n");
 503         retvm_if(pkginfo->installed_storage == NULL, PMINFO_R_ERROR,
 504                         "installed_storage is NULL\n");
 505
 506         if (strcmp(pkginfo->installed_storage, "installed_external") == 0) {
 507                 snprintf(buf, MAX_QUERY_LEN - 1, "%s", pkginfo->external_path);
 508                 ret = access(buf, R_OK);
 509                 if (ret != 0) {
 510                         _LOGE("can not access [%s] - %d", buf, ret);
 511                         return PMINFO_R_ERROR;
 512                 }
 513         }
 514
 515         return PMINFO_R_OK;
 516 }
 517
 518 API int __appinfo_check_installed_storage(application_x *appinfo)
 519 {
 520         retvm_if(appinfo->installed_storage == NULL, PMINFO_R_ERROR,
 521                         "installed_storage is NULL\n");
 522
 523         if (strcmp(appinfo->installed_storage, "installed_external") == 0) {
 524                 retvm_if(appinfo->external_path == NULL, PMINFO_R_ERROR,
 525                                 "external path is NULL\n");
 526                 if (access(appinfo->external_path, R_OK) != 0) {
 527                         _LOGE("can not access [%s]", appinfo->external_path);
 528                         return PMINFO_R_ERROR;
 529                 }
 530         }
 531
 532         return PMINFO_R_OK;
 533 }
 534
 535 struct type_map {
 536         const char *manifest;
 537         const char *type;
 538 };
 539
 540 const struct type_map type_map[] = {
 541         { "res/wgt/config.xml", "wgt" },
 542         { "config.xml", "wgt" },
 543         { "tizen-manifest.xml", "tpk" },
 544         { NULL, NULL}
 545 };
 546
 547 API char *__get_type_from_path(const char *pkg_path)
 548 {
 549         const char *type = NULL;
 550         unzFile uf;
 551         int i;
 552
 553         uf = unzOpen(pkg_path);
 554         if (uf == NULL) {
 555                 _LOGE("failed to open zip file %s", pkg_path);
 556                 return NULL;
 557         }
 558
 559         for (i = 0; type_map[i].manifest != NULL; i++) {
 560                 if (unzLocateFile(uf, type_map[i].manifest, 0) == UNZ_OK) {
 561                         _LOGD("pkgtype of %s: [%s]", pkg_path,
 562                                         type_map[i].type);
 563                         type = type_map[i].type;
 564                         break;
 565                 }
 566         }
 567         unzClose(uf);
 568
 569         if (type == NULL) {
 570                 _LOGE("cannot get pkg type of file %s", pkg_path);
 571                 return NULL;
 572         }
 573
 574         return strdup(type);
 575 }
 576
 577 static const char *__get_library_path(const char *pkg_type)
 578 {
 579         char buf[64];
 580         const char *path;
 581
 582         snprintf(buf, sizeof(buf), "package-manager/backendlib/lib%s.so",
 583                         pkg_type);
 584         path = tzplatform_mkpath(TZ_SYS_RO_ETC, buf);
 585
 586         return path;
 587 }
 588
 589 API pkg_plugin_set *__load_library(const char *pkg_type)
 590 {
 591         void *library_handle;
 592         pkg_plugin_set *plugin_set;
 593         bool (*on_load)(pkg_plugin_set *plugin);
 594         const char *library_path;
 595
 596         library_path = __get_library_path(pkg_type);
 597         if (library_path == NULL) {
 598                 _LOGE("cannot get library path for %s", pkg_type);
 599                 return NULL;
 600         }
 601
 602         if (plugin_set_list == NULL) {
 603                 plugin_set_list = g_hash_table_new_full(g_str_hash,
 604                                 g_str_equal, free, free);
 605                 if (plugin_set_list == NULL) {
 606                         _LOGE("out of memory");
 607                         return NULL;
 608                 }
 609         }
 610
 611         plugin_set = (pkg_plugin_set *)g_hash_table_lookup(plugin_set_list,
 612                         (gconstpointer)pkg_type);
 613         if (plugin_set) {
 614                 _LOGD("already loaded [%s]", library_path);
 615                 return plugin_set;
 616         }
 617
 618         library_handle = dlopen(library_path, RTLD_LAZY);
 619         if (library_handle == NULL) {
 620                 _LOGE("dlopen is failed library_path[%s]", library_path);
 621                 return NULL;
 622         }
 623
 624         on_load = dlsym(library_handle, "pkg_plugin_on_load");
 625         if (on_load == NULL || dlerror() != NULL) {
 626                 _LOGE("cannot find symbol");
 627                 dlclose(library_handle);
 628                 return NULL;
 629         }
 630
 631         plugin_set = (pkg_plugin_set *)calloc(1, sizeof(pkg_plugin_set));
 632         if (plugin_set == NULL) {
 633                 _LOGE("out of memory");
 634                 dlclose(library_handle);
 635                 return NULL;
 636         }
 637
 638         if (on_load(plugin_set) != 0) {
 639                 _LOGE("pkg_plugin_on_load failed");
 640                 free(plugin_set);
 641                 dlclose(library_handle);
 642                 plugin_set = NULL;
 643                 return NULL;
 644         }
 645
 646         plugin_set->plugin_handle = library_handle;
 647         snprintf(plugin_set->pkg_type,
 648                         sizeof(plugin_set->pkg_type), "%s", pkg_type);
 649
 650         g_hash_table_insert(plugin_set_list, (gpointer)strdup(pkg_type),
 651                         (gpointer)plugin_set);
 652
 653         _LOGD("library [%s] is loaded", library_path);
 654
 655         return plugin_set;
 656 }
 657
 658 API void __unload_library(const char *pkg_type)
 659 {
 660         pkg_plugin_set *plugin_set;
 661
 662         if (plugin_set_list == NULL)
 663                 return;
 664
 665         plugin_set = (pkg_plugin_set *)g_hash_table_lookup(plugin_set_list,
 666                         (gconstpointer)pkg_type);
 667
 668         if (plugin_set == NULL) {
 669                 _LOGE("pkg plugin for %s is not loaded", pkg_type);
 670                 return;
 671         }
 672
 673         plugin_set->plugin_on_unload();
 674         dlclose(plugin_set->plugin_handle);
 675         g_hash_table_remove(plugin_set_list, (gconstpointer)pkg_type);
 676 }