Fix some outdated sqlite query logic
[platform/core/appfw/pkgmgr-info.git] / src / pkgmgrinfo_private.h
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
24 #ifndef __PKGMGRINFO_PRIVATE_H__
25 #define __PKGMGRINFO_PRIVATE_H__
26
27 #include <stdbool.h>
28 #include <unistd.h>
29 #include <sys/types.h>
30
31 #include <sqlite3.h>
32 #include <glib.h>
33 #include <tzplatform_config.h>
34
35 #include "pkgmgrinfo_type.h"
36 #include "pkgmgrinfo_basic.h"
37
38 #ifndef DEPRECATED
39 #define DEPRECATED      __attribute__ ((__deprecated__))
40 #endif
41
42 #ifndef API
43 #define API __attribute__ ((visibility("default")))
44 #endif
45
46 #ifdef LOG_TAG
47 #undef LOG_TAG
48 #endif
49 #define LOG_TAG "PKGMGR_INFO"
50
51 #define ASC_CHAR(s) (const char *)s
52 #define XML_CHAR(s) (const xmlChar *)s
53
54 #define MANIFEST_DB     tzplatform_mkpath(TZ_SYS_DB, ".pkgmgr_parser.db")
55 #define MAX_QUERY_LEN   4096
56 #define MAX_CERT_TYPE   9
57 #define CERT_DB         tzplatform_mkpath(TZ_SYS_DB, ".pkgmgr_cert.db")
58 #define PKG_STRING_LEN_MAX 1024
59 #define PKG_TYPE_STRING_LEN_MAX         128
60 #define PKG_VERSION_STRING_LEN_MAX      128
61 #define PKG_VALUE_STRING_LEN_MAX                512
62 #define PKG_RW_PATH tzplatform_mkpath(TZ_USER_APP, "")
63 #define PKG_RO_PATH tzplatform_mkpath(TZ_SYS_RO_APP, "")
64 #define BLOCK_SIZE      4096 /*in bytes*/
65 #define BUFSIZE 4096
66 #define ROOT_UID 0
67 #define APPFW_UID 301
68
69 #define PKG_SD_PATH tzplatform_mkpath3(TZ_SYS_STORAGE, "sdcard", "app2sd/")
70 #define PKG_INSTALLATION_PATH tzplatform_mkpath(TZ_USER_APP, "")
71
72 #define SERVICE_NAME "org.tizen.system.deviced"
73 #define PATH_NAME "/Org/Tizen/System/DeviceD/Mmc"
74 #define INTERFACE_NAME "org.tizen.system.deviced.Mmc"
75 #define METHOD_NAME "RequestMountApp2ext"
76
77 /*String properties for filtering based on package info*/
78 typedef enum _pkgmgrinfo_pkginfo_filter_prop_str {
79         E_PMINFO_PKGINFO_PROP_PACKAGE_MIN_STR = 101,
80         E_PMINFO_PKGINFO_PROP_PACKAGE_ID = E_PMINFO_PKGINFO_PROP_PACKAGE_MIN_STR,
81         E_PMINFO_PKGINFO_PROP_PACKAGE_TYPE,
82         E_PMINFO_PKGINFO_PROP_PACKAGE_VERSION,
83         E_PMINFO_PKGINFO_PROP_PACKAGE_INSTALL_LOCATION,
84         E_PMINFO_PKGINFO_PROP_PACKAGE_INSTALLED_STORAGE,
85         E_PMINFO_PKGINFO_PROP_PACKAGE_AUTHOR_NAME,
86         E_PMINFO_PKGINFO_PROP_PACKAGE_AUTHOR_EMAIL,
87         E_PMINFO_PKGINFO_PROP_PACKAGE_AUTHOR_HREF,
88         E_PMINFO_PKGINFO_PROP_PACKAGE_PRIVILEGE,
89         E_PMINFO_PKGINFO_PROP_PACKAGE_MAX_STR = E_PMINFO_PKGINFO_PROP_PACKAGE_PRIVILEGE
90 } pkgmgrinfo_pkginfo_filter_prop_str;
91
92 /*Boolean properties for filtering based on package info*/
93 typedef enum _pkgmgrinfo_pkginfo_filter_prop_bool {
94         E_PMINFO_PKGINFO_PROP_PACKAGE_MIN_BOOL = 201,
95         E_PMINFO_PKGINFO_PROP_PACKAGE_REMOVABLE = E_PMINFO_PKGINFO_PROP_PACKAGE_MIN_BOOL,
96         E_PMINFO_PKGINFO_PROP_PACKAGE_PRELOAD,
97         E_PMINFO_PKGINFO_PROP_PACKAGE_READONLY,
98         E_PMINFO_PKGINFO_PROP_PACKAGE_UPDATE,
99         E_PMINFO_PKGINFO_PROP_PACKAGE_APPSETTING,
100         E_PMINFO_PKGINFO_PROP_PACKAGE_NODISPLAY_SETTING,
101         E_PMINFO_PKGINFO_PROP_PACKAGE_SUPPORT_DISABLE,
102         E_PMINFO_PKGINFO_PROP_PACKAGE_DISABLE,
103         E_PMINFO_PKGINFO_PROP_PACKAGE_CHECK_STORAGE,
104         E_PMINFO_PKGINFO_PROP_PACKAGE_MAX_BOOL = E_PMINFO_PKGINFO_PROP_PACKAGE_CHECK_STORAGE
105 } pkgmgrinfo_pkginfo_filter_prop_bool;
106
107 /*Integer properties for filtering based on package info*/
108 typedef enum _pkgmgrinfo_pkginfo_filter_prop_int {
109         E_PMINFO_PKGINFO_PROP_PACKAGE_MIN_INT = 301,
110         E_PMINFO_PKGINFO_PROP_PACKAGE_SIZE = E_PMINFO_PKGINFO_PROP_PACKAGE_MIN_INT,
111         E_PMINFO_PKGINFO_PROP_PACKAGE_MAX_INT = E_PMINFO_PKGINFO_PROP_PACKAGE_SIZE
112 } pkgmgrinfo_pkginfo_filter_prop_int;
113
114 /*String properties for filtering based on app info*/
115 typedef enum _pkgmgrinfo_appinfo_filter_prop_str {
116         E_PMINFO_APPINFO_PROP_APP_MIN_STR = 401,
117         E_PMINFO_APPINFO_PROP_APP_ID = E_PMINFO_APPINFO_PROP_APP_MIN_STR,
118         E_PMINFO_APPINFO_PROP_APP_COMPONENT,
119         E_PMINFO_APPINFO_PROP_APP_EXEC,
120         E_PMINFO_APPINFO_PROP_APP_ICON,
121         E_PMINFO_APPINFO_PROP_APP_TYPE,
122         E_PMINFO_APPINFO_PROP_APP_OPERATION,
123         E_PMINFO_APPINFO_PROP_APP_URI,
124         E_PMINFO_APPINFO_PROP_APP_MIME,
125         E_PMINFO_APPINFO_PROP_APP_HWACCELERATION,
126         E_PMINFO_APPINFO_PROP_APP_CATEGORY,
127         E_PMINFO_APPINFO_PROP_APP_SCREENREADER,
128         E_PMINFO_APPINFO_PROP_APP_PACKAGE,
129         E_PMINFO_APPINFO_PROP_APP_INSTALLED_STORAGE,
130         E_PMINFO_APPINFO_PROP_APP_MAX_STR = E_PMINFO_APPINFO_PROP_APP_INSTALLED_STORAGE
131 } pkgmgrinfo_appinfo_filter_prop_str;
132
133 /*Boolean properties for filtering based on app info*/
134 typedef enum _pkgmgrinfo_appinfo_filter_prop_bool {
135         E_PMINFO_APPINFO_PROP_APP_MIN_BOOL = 501,
136         E_PMINFO_APPINFO_PROP_APP_NODISPLAY = E_PMINFO_APPINFO_PROP_APP_MIN_BOOL,
137         E_PMINFO_APPINFO_PROP_APP_MULTIPLE,
138         E_PMINFO_APPINFO_PROP_APP_ONBOOT,
139         E_PMINFO_APPINFO_PROP_APP_AUTORESTART,
140         E_PMINFO_APPINFO_PROP_APP_TASKMANAGE,
141         E_PMINFO_APPINFO_PROP_APP_LAUNCHCONDITION,
142         E_PMINFO_APPINFO_PROP_APP_UI_GADGET,
143         E_PMINFO_APPINFO_PROP_APP_DISABLE,
144         E_PMINFO_APPINFO_PROP_APP_SUPPORT_DISABLE,
145         E_PMINFO_APPINFO_PROP_APP_CHECK_STORAGE,
146         E_PMINFO_APPINFO_PROP_PKG_DISABLE,
147         E_PMINFO_APPINFO_PROP_APP_MAX_BOOL = E_PMINFO_APPINFO_PROP_PKG_DISABLE
148 } pkgmgrinfo_appinfo_filter_prop_bool;
149
150 /*Integer properties for filtering based on app info*/
151 typedef enum _pkgmgrinfo_appinfo_filter_prop_int {
152         /*Currently No Fields*/
153         E_PMINFO_APPINFO_PROP_APP_MIN_INT = 601,
154         E_PMINFO_APPINFO_PROP_APP_SUPPORT_MODE = E_PMINFO_APPINFO_PROP_APP_MIN_INT,
155         E_PMINFO_APPINFO_PROP_APP_MAX_INT = E_PMINFO_APPINFO_PROP_APP_SUPPORT_MODE
156 } pkgmgrinfo_appinfo_filter_prop_int;
157
158 /*Integer properties for filtering based on app info*/
159 typedef enum _pkgmgrinfo_pkginfo_filter_prop_range {
160         /*Currently No Fields*/
161         E_PMINFO_PKGINFO_PROP_RANGE_MIN_INT = 701,
162         E_PMINFO_PKGINFO_PROP_RANGE_BASIC,
163         E_PMINFO_PKGINFO_PROP_RANGE_MAX_INT = E_PMINFO_PKGINFO_PROP_RANGE_BASIC
164 } pkgmgrinfo_pkginfo_filter_prop_range;
165
166 typedef enum _pkgmgrinfo_pkginfo_join_flag {
167         E_PMINFO_PKGINFO_JOIN_LOCALIZED_INFO = 0x0001,
168         E_PMINFO_PKGINFO_JOIN_PRIVILEGE_INFO = 0x0002,
169 } pkgmgrinfo_pkginfo_join_flag;
170
171 typedef enum _pkgmgrinfo_appinfo_join_flag {
172         E_PMINFO_APPINFO_JOIN_LOCALIZED_INFO = 0x0001,
173         E_PMINFO_APPINFO_JOIN_CATEGORY = 0x0002,
174         E_PMINFO_APPINFO_JOIN_APP_CONTROL = 0x0004,
175         E_PMINFO_APPINFO_JOIN_METADATA = 0x0008,
176 } pkgmgrinfo_appinfo_join_flag;
177
178 typedef enum _pkgmgrinfo_appinfo_disable_type {
179         E_APPINFO_DISABLE_TYPE_PKG = 0,
180         E_APPINFO_DISABLE_TYPE_APP
181 } pkgmgrinfo_appinfo_disable_type;
182
183 typedef struct _pkgmgr_pkginfo_x {
184         uid_t uid;
185         package_x *pkg_info;
186         char *locale;
187 } pkgmgr_pkginfo_x;
188
189 typedef struct _pkgmgr_appinfo_x {
190         const char *package;
191         char *locale;
192         pkgmgrinfo_app_component app_component;
193         application_x *app_info;
194 } pkgmgr_appinfo_x;
195
196 /*For filter APIs*/
197 typedef struct _pkgmgrinfo_filter_x {
198         uid_t uid;
199         GSList *list;
200         GSList *list_metadata;
201 } pkgmgrinfo_filter_x;
202
203 typedef struct _pkgmgrinfo_node_x {
204         int prop;
205         char *key;
206         char *value;
207 } pkgmgrinfo_node_x;
208
209 typedef struct _pkgmgrinfo_metadata_node_x {
210         char *key;
211         char *value;
212 } pkgmgrinfo_metadata_node_x;
213
214 typedef struct _pkgmgrinfo_appcontrol_x {
215         int operation_count;
216         int uri_count;
217         int mime_count;
218         int subapp_count;
219         char **operation;
220         char **uri;
221         char **mime;
222         char **subapp;
223 } pkgmgrinfo_appcontrol_x;
224
225 typedef struct _db_handle {
226         sqlite3 *dbHandle;
227         int ref;
228 } db_handle;
229
230 /* TODO: refine below structures */
231 #define PKG_TYPE_STRING_LEN_MAX 128
232 #define PKG_NAME_STRING_LEN_MAX 128
233 #define PKG_VERSION_STRING_LEN_MAX      128
234 #define PKG_VALUE_STRING_LEN_MAX 512
235 #define PKG_URL_STRING_LEN_MAX 1024
236 #define PKG_LABEL_STRING_LEN_MAX 128
237 #define PKG_PATH_STRING_LEN_MAX 512
238
239 typedef struct _package_manager_pkg_info_t {
240         char pkg_type[PKG_TYPE_STRING_LEN_MAX];
241         char pkg_name[PKG_NAME_STRING_LEN_MAX];
242         char pkgid[PKG_NAME_STRING_LEN_MAX];
243         char version[PKG_VERSION_STRING_LEN_MAX];
244         struct _package_manager_pkg_info_t *next;
245 } package_manager_pkg_info_t;
246
247 typedef struct _package_manager_pkg_detail_info_t {
248         char pkg_type[PKG_TYPE_STRING_LEN_MAX];
249         char pkg_name[PKG_NAME_STRING_LEN_MAX];
250         char pkgid[PKG_NAME_STRING_LEN_MAX];
251         char version[PKG_VERSION_STRING_LEN_MAX];
252         char api_version[PKG_VERSION_STRING_LEN_MAX];
253         char pkg_description[PKG_VALUE_STRING_LEN_MAX];
254         char min_platform_version[PKG_VERSION_STRING_LEN_MAX];
255         time_t installed_time;  /* installed time it must be GMT+0 time */
256         int installed_size;             /* installed total size */
257         int app_size;                   /* installed app size */
258         int data_size;                  /* data size which is made on run time */
259         char optional_id[PKG_NAME_STRING_LEN_MAX]; /*package ID if exists */
260         void *pkg_optional_info;
261         char label[PKG_LABEL_STRING_LEN_MAX];
262         char author[PKG_VALUE_STRING_LEN_MAX];
263         char *icon_buf;
264         int icon_size;
265         GList *privilege_list;
266 } package_manager_pkg_detail_info_t;
267
268 typedef void (*_pkg_plugin_unload)(void);
269 typedef int (*_pkg_plugin_pkg_is_installed) (const char *pkgid);
270 typedef int (*_pkg_plugin_get_installed_pkg_list)(
271                 const char *category, const char *option,
272                 package_manager_pkg_info_t **list, int *count);
273 typedef int (*_pkg_plugin_get_pkg_detail_info)(const char *pkgid,
274                 package_manager_pkg_detail_info_t *pkg_detail_info);
275 typedef int (*_pkg_plugin_get_pkg_detail_info_from_package)(
276                 const char *pkg_path,
277                 package_manager_pkg_detail_info_t *pkg_detail_info);
278
279 typedef struct _pkg_plugin_set {
280         char pkg_type[PKG_TYPE_STRING_LEN_MAX];
281         void *plugin_handle;
282         _pkg_plugin_unload plugin_on_unload;
283         _pkg_plugin_pkg_is_installed pkg_is_installed;
284         _pkg_plugin_get_installed_pkg_list get_installed_pkg_list;
285         _pkg_plugin_get_pkg_detail_info get_pkg_detail_info;
286         _pkg_plugin_get_pkg_detail_info_from_package
287         get_pkg_detail_info_from_package;
288 } pkg_plugin_set;
289
290 pkgmgrinfo_pkginfo_filter_prop_str _pminfo_pkginfo_convert_to_prop_str(const char *property);
291 pkgmgrinfo_pkginfo_filter_prop_int _pminfo_pkginfo_convert_to_prop_int(const char *property);
292 pkgmgrinfo_pkginfo_filter_prop_bool _pminfo_pkginfo_convert_to_prop_bool(const char *property);
293
294 pkgmgrinfo_appinfo_filter_prop_str _pminfo_appinfo_convert_to_prop_str(const char *property);
295 pkgmgrinfo_appinfo_filter_prop_int _pminfo_appinfo_convert_to_prop_int(const char *property);
296 pkgmgrinfo_appinfo_filter_prop_bool _pminfo_appinfo_convert_to_prop_bool(const char *property);
297
298 pkgmgrinfo_pkginfo_filter_prop_range _pminfo_pkginfo_convert_to_prop_range(const char *property);
299
300 int _check_create_cert_db(void);
301 void _save_column_int(sqlite3_stmt *stmt, int idx, int *i);
302 void _save_column_str(sqlite3_stmt *stmt, int idx, char **str);
303 char *_get_system_locale(void);
304 int __get_filter_condition(gpointer data, uid_t uid, char **condition, GList **param);
305 int __get_metadata_filter_condition(gpointer data, char **condition, GList **param);
306 int _add_icon_info_into_list(const char *locale, char *value, GList **icon);
307 int _add_label_info_into_list(const char *locale, char *value, GList **label);
308 int __pkginfo_check_installed_storage(package_x *pkginfo);
309 int __appinfo_check_installed_storage(application_x *appinfo);
310 int __open_db(const char *path, sqlite3 **db, int flags);
311 char *__get_type_from_path(const char *pkg_path);
312 pkg_plugin_set *__load_library(const char *pkg_type);
313 void __unload_library(const char *pkg_type);
314
315 #define GLOBAL_USER tzplatform_getuid(TZ_SYS_GLOBALAPP_USER)
316 #define REGULAR_USER 5000
317 static inline uid_t _getuid(void)
318 {
319         uid_t uid = getuid();
320
321         if (uid < REGULAR_USER)
322                 return tzplatform_getuid(TZ_SYS_GLOBALAPP_USER);
323         else
324                 return uid;
325 }
326
327 #endif  /* __PKGMGRINFO_PRIVATE_H__ */