2 * Copyright (c) 2011 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.
18 #include <media_info_private.h>
19 #include <media_util_private.h>
21 static sqlite3 *db_handle = NULL;
22 static int ref_count = 0;
23 static GMutex db_mutex;
24 static uid_t content_g_uid = 0;
26 sqlite3 * _content_get_db_handle(void)
31 uid_t _content_get_uid(void)
33 if (content_g_uid == 0)
34 return tzplatform_getuid(TZ_USER_NAME);
39 int _content_query_prepare(char *select_query, char *condition_query, char *option_query, sqlite3_stmt **stmt)
41 int ret = MEDIA_CONTENT_ERROR_NONE;
44 media_content_retvm_if(!STRING_VALID(select_query), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "invalid select_query");
46 if (!STRING_VALID(condition_query))
47 condition_query = (char *)" ";
49 if (!STRING_VALID(option_query))
50 option_query = (char *)" ";
52 query = sqlite3_mprintf("%s %s %s", select_query, condition_query, option_query);
53 ret = _content_get_result(query, stmt);
54 SQLITE3_SAFE_FREE(query);
59 int _content_get_result(char *query, sqlite3_stmt **stmt)
61 int err = MEDIA_CONTENT_ERROR_NONE;
63 media_content_retvm_if(db_handle == NULL, MEDIA_CONTENT_ERROR_DB_FAILED, "database is not connected");
64 media_content_retvm_if(!STRING_VALID(query), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "invalid query");
66 media_content_sec_debug("Query[%s]", query);
68 err = sqlite3_prepare_v2(db_handle, query, strlen(query), stmt, NULL);
69 if (err != SQLITE_OK) {
70 media_content_error("Failed to sqlite3_prepare_v2[%s]", sqlite3_errmsg(db_handle));
71 if (err == SQLITE_BUSY)
72 return MEDIA_CONTENT_ERROR_DB_BUSY;
73 else if (err == SQLITE_PERM)
74 return MEDIA_CONTENT_ERROR_PERMISSION_DENIED;
76 return MEDIA_CONTENT_ERROR_DB_FAILED;
79 return MEDIA_CONTENT_ERROR_NONE;
82 #ifdef _USE_SENIOR_MODE
83 int _content_query_prepare_by_union_select(sqlite3_stmt **stmt, char *select_query1, char *condition_query1, char *option_query1, char *select_query2, char *condition_query2, char *option_query2)
86 int err = MEDIA_CONTENT_ERROR_NONE;
87 char query[MAX_QUERY_SIZE] = {0, };
88 memset(query, '\0', sizeof(query));
90 media_content_retvm_if(db_handle == NULL, MEDIA_CONTENT_ERROR_DB_FAILED, "database is not connected");
91 media_content_retvm_if(!STRING_VALID(select_query1), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "invalid select_query1");
92 media_content_retvm_if(!STRING_VALID(select_query2), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "invalid select_query2");
94 if (!STRING_VALID(condition_query1))
95 condition_query1 = (char *)" ";
97 if (!STRING_VALID(option_query1))
98 option_query1 = (char *)" ";
100 if (!STRING_VALID(condition_query2))
101 condition_query2 = (char *)" ";
103 if (!STRING_VALID(option_query2))
104 option_query2 = (char *)" ";
106 len = snprintf(query, sizeof(query), "SELECT * FROM (%s %s %s) as table1 UNION ALL SELECT * FROM (%s %s %s) as table2",
107 select_query1, condition_query1, option_query1, select_query2, condition_query2, option_query2);
108 if (len > 0 && len < sizeof(query)) {
110 } else if (len >= sizeof(query)) {
111 query[MAX_QUERY_SIZE -1] = '\0';
113 media_content_error("snprintf failed");
114 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
117 media_content_sec_debug("Query : [%s]", query);
119 err = sqlite3_prepare_v2(db_handle, query, strlen(query), stmt, NULL);
120 if (err != SQLITE_OK) {
121 media_content_error("DB_FAILED(0x%08x) fail to sqlite3_prepare(), %s", MEDIA_CONTENT_ERROR_DB_FAILED, sqlite3_errmsg(db_handle));
123 if (err == SQLITE_BUSY) {
124 media_content_error(" BUSY ERROR");
125 return MEDIA_CONTENT_ERROR_DB_BUSY;
126 } else if (err == SQLITE_PERM) {
127 media_content_error("PERMISSION EROR");
128 return MEDIA_CONTENT_ERROR_PERMISSION_DENIED;
130 media_content_error("OTHER ERROR");
131 return MEDIA_CONTENT_ERROR_DB_FAILED;
135 return MEDIA_CONTENT_ERROR_NONE;
139 int _content_error_capi(int content_error)
141 if (content_error != MEDIA_CONTENT_ERROR_NONE)
142 media_content_error("MS Error[%d]", content_error);
145 if (content_error == MS_MEDIA_ERR_NONE)
146 return MEDIA_CONTENT_ERROR_NONE;
148 /* Internal operation error*/
149 else if ((content_error == MS_MEDIA_ERR_INVALID_PARAMETER) ||
150 (content_error == MS_MEDIA_ERR_INVALID_PATH) ||
151 (content_error == MS_MEDIA_ERR_THUMB_DUPLICATED_REQUEST))
152 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
154 else if (content_error == MS_MEDIA_ERR_OUT_OF_MEMORY)
155 return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
157 /* DB operation error*/
158 else if (content_error == MS_MEDIA_ERR_DB_BUSY_FAIL)
159 return MEDIA_CONTENT_ERROR_DB_BUSY;
161 else if ((content_error <= MS_MEDIA_ERR_DB_CONNECT_FAIL) && (content_error >= MS_MEDIA_ERR_DB_INTERNAL))
162 return MEDIA_CONTENT_ERROR_DB_FAILED;
164 /* IPC operation error*/
165 else if ((content_error <= MS_MEDIA_ERR_SOCKET_CONN) && (content_error >= MS_MEDIA_ERR_SOCKET_INTERNAL))
166 return MEDIA_CONTENT_ERROR_NETWORK;
168 /* MEDIA SERVER error*/
169 else if (content_error == MS_MEDIA_ERR_PERMISSION_DENIED)
170 return MEDIA_CONTENT_ERROR_PERMISSION_DENIED;
173 else if ((content_error == MS_MEDIA_ERR_THUMB_TOO_BIG) || (content_error == MS_MEDIA_ERR_THUMB_UNSUPPORTED))
174 return MEDIA_CONTENT_ERROR_UNSUPPORTED_CONTENT;
177 return MEDIA_CONTENT_ERROR_INVALID_OPERATION;
180 int _content_query_sql(char *query_str)
182 int ret = MEDIA_CONTENT_ERROR_NONE;
184 /*DB will be updated by Media Server.*/
185 ret = media_db_request_update_db(query_str, _content_get_uid());
187 return _content_error_capi(ret);
190 int media_content_connect(void)
192 int ret = MEDIA_CONTENT_ERROR_NONE;
194 g_mutex_lock(&db_mutex);
195 media_content_info("ref count : %d", ref_count);
197 if (ref_count == 0) {
198 if (db_handle == NULL) {
199 ret = media_db_connect(&db_handle, _content_get_uid(), false);
200 ret = _content_error_capi(ret);
201 if (ret == MEDIA_CONTENT_ERROR_NONE)
204 media_content_error("Wrong DB Connection status");
205 ret = MEDIA_CONTENT_ERROR_DB_FAILED;
208 if (db_handle != NULL) {
211 media_content_error("Wrong DB Handle status");
212 ret = MEDIA_CONTENT_ERROR_DB_FAILED;
216 media_content_info("ref count changed to: %d", ref_count);
217 g_mutex_unlock(&db_mutex);
222 int media_content_connect_with_uid(uid_t uid)
224 media_content_sec_debug("media_content_connect_with_uid [%d]", uid);
227 return media_content_connect();
230 int media_content_disconnect(void)
232 int ret = MEDIA_CONTENT_ERROR_NONE;
234 g_mutex_lock(&db_mutex);
235 media_content_debug("ref count : %d", ref_count);
237 if (db_handle != NULL) {
240 media_content_error("Wrong DB Handle status");
241 ret = MEDIA_CONTENT_ERROR_DB_FAILED;
244 media_content_error("DB_FAILED(0x%08x) database is not connected", MEDIA_CONTENT_ERROR_DB_FAILED);
245 g_mutex_unlock(&db_mutex);
246 return MEDIA_CONTENT_ERROR_DB_FAILED;
249 if (ref_count == 0) {
250 if (db_handle != NULL) {
251 ret = media_db_disconnect(db_handle);
252 ret = _content_error_capi(ret);
253 if (ret == MEDIA_CONTENT_ERROR_NONE) {
256 media_content_error("database disconnect fail");
260 media_content_error("Wrong DB Handle status");
261 ret = MEDIA_CONTENT_ERROR_DB_FAILED;
264 g_mutex_unlock(&db_mutex);
266 media_content_info("ref count changed to: %d", ref_count);
271 g_mutex_unlock(&db_mutex);
273 media_content_info("ref count changed to: %d", ref_count);
278 int media_content_scan_file(const char *path)
280 int ret = MEDIA_CONTENT_ERROR_NONE;
281 bool ignore_file = FALSE;
282 bool ignore_dir = FALSE;
283 char *folder_path = NULL;
284 int check_file = MEDIA_CONTENT_ERROR_NONE;
285 char storage_id[MEDIA_CONTENT_UUID_SIZE+1] = {0,};
286 char repl_path[MAX_PATH_LEN] = {0,};
288 media_content_retvm_if(!STRING_VALID(path), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "invalid path");
290 media_content_sec_debug("Path : %s", path);
292 memset(repl_path, 0, sizeof(repl_path));
293 ret = _media_content_replace_path(path, repl_path);
294 media_content_retvm_if(!STRING_VALID(repl_path), MEDIA_CONTENT_ERROR_INVALID_OPERATION, "path replacement failed");
296 ret = _media_util_check_ignore_file(repl_path, &ignore_file);
297 media_content_retvm_if(ignore_file == TRUE, MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid path");
299 memset(storage_id, 0x00, sizeof(storage_id));
300 ret = media_svc_get_storage_id(_content_get_db_handle(), repl_path, storage_id, _content_get_uid());
301 if (ret != MS_MEDIA_ERR_NONE) {
302 media_content_error("media_svc_get_storage_id failed : %d", ret);
303 return _content_error_capi(ret);
306 check_file = _media_util_check_file_exist(repl_path);
307 if (check_file == MEDIA_CONTENT_ERROR_NONE) {
308 /* This means this path has to be inserted or refreshed */
309 folder_path = g_path_get_dirname(repl_path);
310 ret = _media_util_check_ignore_dir(folder_path, &ignore_dir);
311 SAFE_FREE(folder_path);
313 media_content_retvm_if(ignore_dir == TRUE, MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid folder path");
315 media_content_retvm_if(!_media_util_check_support_media_type(repl_path), MEDIA_CONTENT_ERROR_NOT_SUPPORTED, "Unsupported media type");
317 ms_user_storage_type_e storage_type;
319 ret = ms_user_get_storage_type(_content_get_uid(), repl_path, &storage_type);
320 if (ret != MS_MEDIA_ERR_NONE) {
321 media_content_sec_error("ms_user_get_storage_type failed : %d (%s)", ret, repl_path);
322 return _content_error_capi(ret);
324 ret = media_svc_check_item_exist_by_path(_content_get_db_handle(), storage_id, repl_path);
325 if (ret == MS_MEDIA_ERR_NONE) {
327 ret = media_svc_refresh_item(_content_get_db_handle(), storage_id, storage_type, repl_path, _content_get_uid());
328 if (ret != MS_MEDIA_ERR_NONE) {
329 media_content_error("media_svc_refresh_item failed : %d", ret);
330 return _content_error_capi(ret);
333 } else if (ret == MS_MEDIA_ERR_DB_NO_RECORD) {
335 ret = media_svc_insert_item_immediately(_content_get_db_handle(), storage_id, storage_type, repl_path, _content_get_uid());
336 if (ret != MS_MEDIA_ERR_NONE) {
337 if (ret == MS_MEDIA_ERR_DB_CONSTRAINT_FAIL) {
338 media_content_sec_error("This item is already inserted. This may be normal operation because other process already did this (%s)", repl_path);
339 ret = MEDIA_CONTENT_ERROR_NONE;
341 media_content_sec_error("media_svc_insert_item_immediately failed : %d (%s)", ret, repl_path);
344 return _content_error_capi(ret);
347 media_content_error("media_svc_check_item_exist_by_path failed : %d", ret);
348 return _content_error_capi(ret);
350 } else if (check_file == MEDIA_CONTENT_ERROR_PERMISSION_DENIED) {
351 media_content_error("You have no permission for this file %d", ret);
352 return MEDIA_CONTENT_ERROR_PERMISSION_DENIED;
354 /* This means this path has to be deleted */
355 media_content_debug("This path doesn't exists in file system... So now start to delete it from DB");
356 ret = media_svc_delete_item_by_path(_content_get_db_handle(), false, storage_id, repl_path, _content_get_uid());
357 if (ret != MS_MEDIA_ERR_NONE) {
358 if (ret == MS_MEDIA_ERR_DB_NO_RECORD) {
359 media_content_error("Does not exist in media DB also... So, this is an invalid parameter");
360 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
363 media_content_error("media_svc_delete_item_by_path failed : %d", ret);
364 return _content_error_capi(ret);
368 return _content_error_capi(ret);
371 void _media_content_scan_cb(media_request_result_s* result, void *user_data)
374 media_content_scan_cb_data *cb_data = user_data;
376 err = _content_error_capi(result->result);
377 #ifdef _USE_TVPD_MODE
378 if (result->request_type != MEDIA_REQUEST_SCAN_COMPLETE &&
379 result->request_type != MEDIA_REQUEST_SCAN_PARTIAL) {
380 if (cb_data && cb_data->callback) {
381 media_content_debug("begin:User callback is being called now, result=%d", err);
382 cb_data->callback(err, cb_data->user_data);
383 media_content_debug("end:User callback is being called now, result=%d", err);
389 if (cb_data && cb_data->callback) {
390 media_content_debug("User callback is being called now");
391 cb_data->callback(err, cb_data->user_data);
400 #ifdef _USE_TVPD_MODE
401 void _media_content_scan_cb_v2(media_request_result_s* result, void *user_data)
404 media_content_scan_cb_data_v2 *cb_data = user_data;
405 media_content_complete_phase_e complete_phase = -1;
407 media_content_debug("cb_data is NULL");
408 err = _content_error_capi(result->result);
409 media_content_debug("result is %d", err);
411 if (result->request_type == MEDIA_REQUEST_SCAN_PARTIAL)
412 complete_phase = MEDIA_CONTENT_SCAN_PARTIAL_COMPLETE;
413 else if (result->request_type == MEDIA_REQUEST_SCAN_COMPLETE)
414 complete_phase = MEDIA_CONTENT_SCAN_COMPLETE;
415 else if (result->request_type == MEDIA_REQUEST_EXTRACT_COMPLETE)
416 complete_phase = MEDIA_CONTENT_EXTRACT_COMPLETE;
418 if (cb_data && cb_data->callback)
419 cb_data->callback(err, complete_phase, cb_data->user_data);
421 media_content_debug("run error");
423 if ((result->request_type != MEDIA_REQUEST_SCAN_COMPLETE) &&
424 (result->request_type != MEDIA_REQUEST_SCAN_PARTIAL))
431 int media_content_scan_folder(const char *path, bool is_recursive, media_scan_completed_cb callback, void *user_data)
433 int ret = MEDIA_CONTENT_ERROR_NONE;
434 bool ignore_dir = FALSE;
435 char storage_id[MEDIA_CONTENT_UUID_SIZE+1] = {0, };
436 char repl_path[MAX_PATH_LEN] = {0, };
437 ms_user_storage_type_e storage_type = MS_USER_STORAGE_INTERNAL;
439 media_content_retvm_if(!STRING_VALID(path), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid path");
440 memset(repl_path, 0, sizeof(repl_path));
441 ret = _media_content_replace_path(path, repl_path);
442 media_content_retvm_if(!STRING_VALID(repl_path), MEDIA_CONTENT_ERROR_INVALID_OPERATION, "path replacement failed");
444 memset(storage_id, 0x00, sizeof(storage_id));
446 ret = _media_content_check_dir(repl_path);
447 media_content_retvm_if(ret == MEDIA_CONTENT_ERROR_PERMISSION_DENIED, ret, "Permission Denied");
449 if (ret == MEDIA_CONTENT_ERROR_NONE) {
450 /* If directory exist check that's ignore directory or not*/
451 ret = _media_util_check_ignore_dir(repl_path, &ignore_dir);
452 media_content_retvm_if((ignore_dir == TRUE || ret != MEDIA_CONTENT_ERROR_NONE), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid folder path");
454 /* This means this folder has to be deleted */
455 /* Or, it is real invalid path.. check storage type */
456 ret = ms_user_get_storage_type(_content_get_uid(), repl_path, &storage_type);
457 if (ret != MS_MEDIA_ERR_NONE) {
458 media_content_sec_error("ms_user_get_storage_type failed : %d (%s)", ret, repl_path);
459 return _content_error_capi(ret);
462 media_content_debug("This path doesn't exists in file system... So will be deleted it from DB");
465 ret = media_svc_get_storage_id(_content_get_db_handle(), repl_path, storage_id, _content_get_uid());
466 if (ret != MS_MEDIA_ERR_NONE) {
467 media_content_error("media_svc_get_storage_id failed : %d", ret);
468 return _content_error_capi(ret);
471 media_content_scan_cb_data *cb_data = NULL;
472 cb_data = (media_content_scan_cb_data *)malloc(sizeof(media_content_scan_cb_data));
473 media_content_retvm_if(cb_data == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY");
475 cb_data->callback = callback;
476 cb_data->user_data = user_data;
478 ret = media_directory_scanning_async(repl_path, storage_id, is_recursive, _media_content_scan_cb, cb_data, _content_get_uid());
479 if (ret != MS_MEDIA_ERR_NONE) {
480 media_content_error("media_directory_scanning_async failed : %d", ret);
484 return _content_error_capi(ret);
487 #ifdef _USE_TVPD_MODE
488 int media_content_scan_folder_v2(const char *path, bool is_recursive, media_scan_completed_cb_v2 callback, void *user_data)
490 int ret = MEDIA_CONTENT_ERROR_NONE;
491 bool ignore_dir = FALSE;
492 char storage_id[MEDIA_CONTENT_UUID_SIZE+1] = {0, };
494 media_content_retvm_if(!STRING_VALID(path), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid path");
495 memset(storage_id, 0x00, sizeof(storage_id));
497 ret = _media_util_check_ignore_dir(path, &ignore_dir);
498 media_content_retvm_if(ignore_dir, MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid folder path");
500 ret = _media_content_check_dir(path);
501 media_content_retvm_if(ret == MEDIA_CONTENT_ERROR_PERMISSION_DENIED, ret, "Permission Denied");
502 media_content_retvm_if(ret == MEDIA_CONTENT_ERROR_INVALID_PARAMETER, ret, "invalid path[%s]", path);
504 media_content_scan_cb_data_v2* cb_data = NULL;
505 cb_data = (media_content_scan_cb_data_v2*)malloc(sizeof(media_content_scan_cb_data_v2));
506 media_content_retvm_if(cb_data == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY");
508 cb_data->callback = callback;
509 cb_data->user_data = user_data;
511 ret = media_svc_get_storage_id(_content_get_db_handle(), path, storage_id, _content_get_uid());
512 /*FIX ME. need to check ret value?*/
514 ret = media_directory_scanning_async(path, storage_id, is_recursive, _media_content_scan_cb_v2, cb_data, _content_get_uid());
515 if (ret != MS_MEDIA_ERR_NONE)
516 media_content_error("media_directory_scanning_async failed : %d", ret);
518 return _content_error_capi(ret);
522 int media_content_cancel_scan_folder(const char *path)
524 int ret = MEDIA_CONTENT_ERROR_NONE;
525 char repl_path[MAX_PATH_LEN] = {0, };
527 media_content_retvm_if(!STRING_VALID(path), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid path");
529 memset(repl_path, 0, sizeof(repl_path));
530 ret = _media_content_replace_path(path, repl_path);
531 media_content_retvm_if(!STRING_VALID(repl_path), MEDIA_CONTENT_ERROR_INVALID_OPERATION, "path replacement failed");
533 ret = media_directory_scanning_cancel(repl_path, _content_get_uid());
534 if (ret != MS_MEDIA_ERR_NONE)
535 media_content_error("media_directory_scanning_async failed : %d", ret);
537 return _content_error_capi(ret);
540 void _media_content_db_update_noti_cb(
542 media_item_type_e item,
543 media_item_update_type_e update_type,
546 media_type_e content_type,
550 media_noti_cb_s *_noti_info = (media_noti_cb_s *)user_data;
552 if (_noti_info != NULL && _noti_info->update_noti_cb)
553 _noti_info->update_noti_cb(
554 MEDIA_CONTENT_ERROR_NONE,
562 _noti_info->user_data);
565 int media_content_add_db_updated_cb(media_content_db_update_cb callback, void *user_data, media_content_noti_h *noti_handle)
567 int ret = MEDIA_CONTENT_ERROR_NONE;
568 media_noti_cb_s *noti_info = NULL;
570 media_content_retvm_if(noti_handle == NULL, MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "handle is NULL");
571 media_content_retvm_if(callback == NULL, MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "callback is NULL");
573 noti_info = (media_noti_cb_s *)calloc(1, sizeof(media_noti_cb_s));
574 media_content_retvm_if(noti_info == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "Failed to create noti info");
576 noti_info->update_noti_cb = callback;
577 noti_info->user_data = user_data;
579 ret = media_db_update_subscribe_internal((MediaNotiHandle*)noti_handle, _media_content_db_update_noti_cb, (void *)noti_info);
581 return _content_error_capi(ret);
584 void __media_content_clear_user_data(void *user_data)
586 media_noti_cb_s *noti_info = user_data;
588 SAFE_FREE(noti_info);
593 int media_content_remove_db_updated_cb(media_content_noti_h noti_handle)
595 int ret = MEDIA_CONTENT_ERROR_NONE;
597 ret = media_db_update_unsubscribe_internal((MediaNotiHandle)noti_handle, __media_content_clear_user_data);
599 return _content_error_capi(ret);
601 #ifdef _USE_TVPD_MODE
602 GMutex* _content_get_db_mutex(void)