2 * Copyright (c) 2000 - 2016 Samsung Electronics Co., Ltd. All rights reserved.
4 * Licensed under the Apache License, Version 2.0 (the "License");
5 * you may not use this file except in compliance with the License.
6 * You may obtain a copy of the License at
8 * http://www.apache.org/licenses/LICENSE-2.0
10 * Unless required by applicable law or agreed to in writing, software
11 * distributed under the License is distributed on an "AS IS" BASIS,
12 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
13 * See the License for the specific language governing permissions and
14 * limitations under the License.
28 #include "db-schema.h"
30 #include "rua_private.h"
32 API int rua_add_history_for_uid(char *pkg_name, char *app_path, char *arg, uid_t uid)
35 char time_str[32] = {0,};
38 if (pkg_name == NULL || app_path == NULL) {
39 LOGE("invalid param");
43 r = _rua_util_check_uid(uid);
49 LOGE("bundle_create fail out of memory.");
52 snprintf(time_str, sizeof(time_str), "%d", (int)time(NULL));
53 bundle_add_str(b, AUL_K_RUA_PKGNAME, pkg_name);
54 bundle_add_str(b, AUL_K_RUA_APPPATH, app_path);
55 bundle_add_str(b, AUL_K_RUA_ARG, arg);
56 bundle_add_str(b, AUL_K_RUA_TIME, time_str);
58 r = aul_add_rua_history_for_uid(b, uid);
59 LOGI("rua_add_history_for_uid result : %d ", r);
64 API int rua_delete_history_with_pkgname_for_uid(char *pkg_name, uid_t uid)
69 r = _rua_util_check_uid(uid);
75 LOGE("bundle_create fail out of memory.");
78 bundle_add_str(b, AUL_K_RUA_PKGNAME, pkg_name);
79 r = aul_delete_rua_history_for_uid(b, uid);
80 LOGI("rua_delete_history_with_pkgname result : %d ", r);
85 API int rua_delete_history_with_pkgname(char *pkg_name)
87 return rua_delete_history_with_pkgname_for_uid(pkg_name, getuid());
90 API int rua_delete_history_with_apppath_for_uid(char *app_path, uid_t uid)
95 r = _rua_util_check_uid(uid);
101 LOGE("bundle_create fail out of memory.");
104 bundle_add_str(b, AUL_K_RUA_APPPATH, app_path);
105 r = aul_delete_rua_history_for_uid(b, uid);
106 LOGI("rua_delete_history_with_apppath result : %d ", r);
111 API int rua_delete_history_with_apppath(char *app_path)
113 return rua_delete_history_with_apppath_for_uid(app_path, getuid());
116 API int rua_clear_history_for_uid(uid_t uid)
120 r = _rua_util_check_uid(uid);
124 r = aul_delete_rua_history_for_uid(NULL, uid);
125 LOGI("rua_clear_history result : %d ", r);
129 API int rua_clear_history(void)
131 return rua_clear_history_for_uid(getuid());
134 API int rua_history_load_db_for_uid(char ***table, int *nrows, int *ncols, uid_t uid)
136 static const char query[] =
137 "SELECT pkg_name, app_path, arg, launch_time, instance_id,"
138 " instance_name, icon, uri, image "
139 "FROM rua_history ORDER BY launch_time DESC";
142 char **db_result = NULL;
145 if (table == NULL || nrows == NULL || ncols == NULL) {
146 LOGE("invalid parameter");
150 r = _rua_util_check_uid(uid);
154 r = _rua_util_open_db(&db, SQLITE_OPEN_READONLY, uid, RUA_DB_NAME);
158 r = sqlite3_get_table(db, query, &db_result, nrows, ncols, &db_err);
159 if (r != SQLITE_OK) {
160 LOGE("get table failed: %s", db_err);
161 sqlite3_free(db_err);
162 sqlite3_close_v2(db);
168 sqlite3_close_v2(db);
173 API int rua_history_load_db(char ***table, int *nrows, int *ncols)
175 return rua_history_load_db_for_uid(table, nrows, ncols, getuid());
178 API int rua_register_update_cb_for_uid(rua_history_update_cb callback, void *user_data, int *callback_id, uid_t uid)
182 if (callback == NULL)
185 r = _rua_util_check_uid(uid);
189 r = rua_dbus_signal_subscribe(callback, user_data, callback_id);
194 API int rua_register_update_cb(rua_history_update_cb callback, void *user_data, int *callback_id)
196 return rua_register_update_cb_for_uid(callback, user_data, callback_id, getuid());
199 API int rua_unregister_update_cb_for_uid(int callback_id, uid_t uid)
203 r = _rua_util_check_uid(uid);
207 r = rua_dbus_signal_unsubscribe(callback_id);
212 API int rua_unregister_update_cb(int callback_id)
214 return rua_unregister_update_cb_for_uid(callback_id, getuid());
217 API int rua_history_get_rec(struct rua_rec *rec, char **table, int nrows, int ncols,
220 char **db_result = NULL;
230 db_result = table + ((row + 1) * ncols);
232 tmp = db_result[RUA_COL_PKGNAME];
235 LOGI("get rec pkg_name %s", rec->pkg_name);
238 tmp = db_result[RUA_COL_APPPATH];
242 tmp = db_result[RUA_COL_ARG];
246 tmp = db_result[RUA_COL_LAUNCHTIME];
248 rec->launch_time = atoi(tmp);
250 tmp = db_result[RUA_COL_INSTANCE_ID];
251 if (tmp && tmp[0] != '\0')
252 rec->instance_id = tmp;
254 rec->instance_id = NULL;
256 tmp = db_result[RUA_COL_INSTANCE_NAME];
257 if (tmp && tmp[0] != '\0')
258 rec->instance_name = tmp;
260 rec->instance_name = NULL;
262 tmp = db_result[RUA_COL_ICON];
263 if (tmp && tmp[0] != '\0')
268 tmp = db_result[RUA_COL_URI];
269 if (tmp && tmp[0] != '\0')
274 tmp = db_result[RUA_COL_IMAGE];
275 if (tmp && tmp[0] != '\0')
283 API int rua_history_unload_db(char ***table)
286 sqlite3_free_table(*table);
293 API int rua_is_latest_app_for_uid(const char *pkg_name, uid_t uid)
295 static const char query[] =
296 "SELECT pkg_name FROM rua_history "
297 "ORDER BY launch_time DESC LIMIT 1";
300 const unsigned char *ct;
306 r = _rua_util_check_uid(uid);
310 r = _rua_util_open_db(&db, SQLITE_OPEN_READONLY, uid, RUA_DB_NAME);
314 r = sqlite3_prepare(db, query, strlen(query), &stmt, NULL);
315 if (r != SQLITE_OK) {
316 sqlite3_close_v2(db);
320 r = sqlite3_step(stmt);
321 if (r != SQLITE_ROW) {
322 if (r != SQLITE_DONE)
323 LOGE("step failed: %s", sqlite3_errmsg(db));
324 sqlite3_finalize(stmt);
325 sqlite3_close_v2(db);
329 ct = sqlite3_column_text(stmt, 0);
330 if (ct == NULL || ct[0] == '\0')
332 else if (strncmp(pkg_name, (const char *)ct, strlen(pkg_name)) == 0)
337 sqlite3_finalize(stmt);
338 sqlite3_close_v2(db);
343 API int rua_is_latest_app(const char *pkg_name)
345 return rua_is_latest_app_for_uid(pkg_name, getuid());
348 API int rua_init(void)
353 API int rua_fini(void)
358 API int rua_delete_history_with_instance_id(const char *app_id,
359 const char *instance_id)
364 if (app_id == NULL) {
365 LOGE("Invalid parameter");
371 LOGE("Out of memory");
375 bundle_add_str(b, AUL_K_RUA_PKGNAME, app_id);
377 bundle_add_str(b, AUL_K_RUA_INSTANCE_ID, instance_id);
379 ret = aul_delete_rua_history_for_uid(b, getuid());
382 LOGE("Failed to delete rua history - result(%d)", ret);