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(const char *select_query, const char *condition_query, const char *option_query, sqlite3_stmt **stmt)
41 int ret = MEDIA_CONTENT_ERROR_NONE;
44 content_retvm_if(!STRING_VALID(select_query), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "invalid select_query");
46 /* If 'option_query' is NULL, 'condition_query' is also NULL. */
48 if (STRING_VALID(condition_query))
49 query = sqlite3_mprintf("%s AND %s %s", select_query, condition_query, option_query);
51 query = sqlite3_mprintf("%s %s", select_query, option_query);
54 query = sqlite3_mprintf("%s", select_query);
57 ret = _content_get_result(query, stmt);
58 SQLITE3_SAFE_FREE(query);
63 int _content_get_result(char *query, sqlite3_stmt **stmt)
65 int err = MEDIA_CONTENT_ERROR_NONE;
67 content_retvm_if(_content_get_db_handle() == NULL, MEDIA_CONTENT_ERROR_DB_FAILED, "database is not connected");
68 content_retvm_if(!STRING_VALID(query), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "invalid query");
70 content_sec_debug("Query[%s]", query);
72 err = sqlite3_prepare_v2(_content_get_db_handle(), query, strlen(query), stmt, NULL);
73 if (err != SQLITE_OK) {
74 content_error("Failed to sqlite3_prepare_v2[%s]", sqlite3_errmsg(_content_get_db_handle()));
75 if (err == SQLITE_BUSY)
76 return MEDIA_CONTENT_ERROR_DB_BUSY;
77 else if (err == SQLITE_PERM)
78 return MEDIA_CONTENT_ERROR_PERMISSION_DENIED;
80 return MEDIA_CONTENT_ERROR_DB_FAILED;
83 return MEDIA_CONTENT_ERROR_NONE;
86 #ifdef _USE_SENIOR_MODE
87 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)
90 int err = MEDIA_CONTENT_ERROR_NONE;
91 char query[MAX_QUERY_SIZE] = {0, };
93 content_retvm_if(_content_get_db_handle() == NULL, MEDIA_CONTENT_ERROR_DB_FAILED, "database is not connected");
94 content_retvm_if(!STRING_VALID(select_query1), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "invalid select_query1");
95 content_retvm_if(!STRING_VALID(select_query2), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "invalid select_query2");
97 if (!STRING_VALID(condition_query1))
98 condition_query1 = (char *)" ";
100 if (!STRING_VALID(option_query1))
101 option_query1 = (char *)" ";
103 if (!STRING_VALID(condition_query2))
104 condition_query2 = (char *)" ";
106 if (!STRING_VALID(option_query2))
107 option_query2 = (char *)" ";
109 len = snprintf(query, sizeof(query), "SELECT * FROM (%s %s %s) as table1 UNION ALL SELECT * FROM (%s %s %s) as table2",
110 select_query1, condition_query1, option_query1, select_query2, condition_query2, option_query2);
111 if (len > 0 && len < sizeof(query)) {
113 } else if (len >= sizeof(query)) {
114 query[MAX_QUERY_SIZE -1] = '\0';
116 content_error("snprintf failed");
117 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
120 content_sec_debug("Query : [%s]", query);
122 err = sqlite3_prepare_v2(_content_get_db_handle(), query, strlen(query), stmt, NULL);
123 if (err != SQLITE_OK) {
124 content_error("DB_FAILED(0x%08x) fail to sqlite3_prepare(), %s", MEDIA_CONTENT_ERROR_DB_FAILED, sqlite3_errmsg(_content_get_db_handle()));
126 if (err == SQLITE_BUSY) {
127 content_error(" BUSY ERROR");
128 return MEDIA_CONTENT_ERROR_DB_BUSY;
129 } else if (err == SQLITE_PERM) {
130 content_error("PERMISSION EROR");
131 return MEDIA_CONTENT_ERROR_PERMISSION_DENIED;
133 content_error("OTHER ERROR");
134 return MEDIA_CONTENT_ERROR_DB_FAILED;
138 return MEDIA_CONTENT_ERROR_NONE;
142 int _content_error_capi(int internal_error)
144 if (internal_error == MS_MEDIA_ERR_NONE)
145 return MEDIA_CONTENT_ERROR_NONE;
147 content_error("MS Error[%d]", internal_error);
149 switch (internal_error) {
150 case MS_MEDIA_ERR_INVALID_PARAMETER:
151 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
152 case MS_MEDIA_ERR_OUT_OF_MEMORY:
153 return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
154 case MS_MEDIA_ERR_DB_BUSY_FAIL:
155 return MEDIA_CONTENT_ERROR_DB_BUSY;
156 case MS_MEDIA_ERR_DB_CONSTRAINT_FAIL:
157 case MS_MEDIA_ERR_DB_NO_RECORD:
158 case MS_MEDIA_ERR_DB_CORRUPT:
159 case MS_MEDIA_ERR_DB_FULL_FAIL:
160 case MS_MEDIA_ERR_DB_RESET:
161 case MS_MEDIA_ERR_DB_INTERNAL:
162 return MEDIA_CONTENT_ERROR_DB_FAILED;
163 case MS_MEDIA_ERR_IPC:
164 return MEDIA_CONTENT_ERROR_NETWORK;
165 case MS_MEDIA_ERR_PERMISSION_DENIED:
166 return MEDIA_CONTENT_ERROR_PERMISSION_DENIED;
167 case MS_MEDIA_ERR_THUMB_TOO_BIG:
168 case MS_MEDIA_ERR_THUMB_UNSUPPORTED:
169 return MEDIA_CONTENT_ERROR_UNSUPPORTED_CONTENT;
171 return MEDIA_CONTENT_ERROR_INVALID_OPERATION;
175 int _content_query_sql(char *query_str)
177 int ret = MEDIA_CONTENT_ERROR_NONE;
179 /*DB will be updated by Media Server.*/
180 ret = media_db_request_update_db(query_str, _content_get_uid());
182 return _content_error_capi(ret);
185 int media_content_connect(void)
187 int ret = MEDIA_CONTENT_ERROR_NONE;
189 g_mutex_lock(&db_mutex);
190 content_info("ref count : %d", ref_count);
192 if (ref_count == 0) {
193 if (db_handle == NULL) {
194 ret = media_db_connect(&db_handle, _content_get_uid(), false);
195 ret = _content_error_capi(ret);
196 if (ret == MEDIA_CONTENT_ERROR_NONE)
199 content_error("Wrong DB Connection status");
200 ret = MEDIA_CONTENT_ERROR_DB_FAILED;
203 if (db_handle != NULL) {
206 content_error("Wrong DB Handle status");
207 ret = MEDIA_CONTENT_ERROR_DB_FAILED;
211 content_info("ref count changed to: %d", ref_count);
212 g_mutex_unlock(&db_mutex);
217 int media_content_connect_with_uid(uid_t uid)
219 content_sec_debug("media_content_connect_with_uid [%d]", uid);
222 return media_content_connect();
225 int media_content_disconnect(void)
227 g_mutex_lock(&db_mutex);
228 content_debug("ref count : %d", ref_count);
230 if (db_handle && ref_count > 0) {
231 if (--ref_count == 0) {
232 media_db_disconnect(db_handle);
236 content_error("Database is not connected");
237 g_mutex_unlock(&db_mutex);
238 return MEDIA_CONTENT_ERROR_DB_FAILED;
241 g_mutex_unlock(&db_mutex);
243 content_info("ref count changed to: %d", ref_count);
245 return MEDIA_CONTENT_ERROR_NONE;
248 int media_content_scan_file(const char *path)
250 int ret = MEDIA_CONTENT_ERROR_NONE;
251 char *folder_path = NULL;
252 int check_file = MEDIA_CONTENT_ERROR_NONE;
253 char storage_id[MEDIA_CONTENT_UUID_SIZE+1] = {0,};
254 char repl_path[MAX_PATH_LEN] = {0,};
256 content_retvm_if(!STRING_VALID(path), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "invalid path");
258 content_sec_debug("Path : %s", path);
260 ret = _media_content_replace_path(path, repl_path);
261 content_retvm_if(!STRING_VALID(repl_path), MEDIA_CONTENT_ERROR_INVALID_OPERATION, "path replacement failed");
263 content_retvm_if(_media_util_is_ignorable_file(repl_path), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid path");
265 ret = media_svc_get_storage_id(_content_get_db_handle(), repl_path, storage_id, _content_get_uid());
266 if (ret != MS_MEDIA_ERR_NONE) {
267 content_error("media_svc_get_storage_id failed : %d", ret);
268 return _content_error_capi(ret);
271 check_file = _media_util_check_file_exist(repl_path);
272 if (check_file == MEDIA_CONTENT_ERROR_NONE) {
273 /* This means this path has to be inserted or refreshed */
274 folder_path = g_path_get_dirname(repl_path);
276 if (_media_util_is_ignorable_dir(folder_path)) {
278 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
282 content_retvm_if(!_media_util_check_support_media_type(repl_path), MEDIA_CONTENT_ERROR_NOT_SUPPORTED, "Unsupported media type");
284 ms_user_storage_type_e storage_type;
286 ret = ms_user_get_storage_type(_content_get_uid(), repl_path, &storage_type);
287 if (ret != MS_MEDIA_ERR_NONE) {
288 content_sec_error("ms_user_get_storage_type failed : %d (%s)", ret, repl_path);
289 return _content_error_capi(ret);
291 ret = media_svc_check_item_exist_by_path(_content_get_db_handle(), storage_id, repl_path);
292 if (ret == MS_MEDIA_ERR_NONE) {
294 ret = media_svc_refresh_item(_content_get_db_handle(), false, storage_id, storage_type, repl_path, _content_get_uid());
295 if (ret != MS_MEDIA_ERR_NONE) {
296 content_error("media_svc_refresh_item failed : %d", ret);
297 return _content_error_capi(ret);
300 } else if (ret == MS_MEDIA_ERR_DB_NO_RECORD) {
302 ret = media_svc_insert_item_immediately(_content_get_db_handle(), storage_id, storage_type, repl_path, _content_get_uid());
303 if (ret != MS_MEDIA_ERR_NONE) {
304 if (ret == MS_MEDIA_ERR_DB_CONSTRAINT_FAIL) {
305 content_sec_error("This item is already inserted. This may be normal operation because other process already did this (%s)", repl_path);
306 ret = MEDIA_CONTENT_ERROR_NONE;
308 content_sec_error("media_svc_insert_item_immediately failed : %d (%s)", ret, repl_path);
311 return _content_error_capi(ret);
314 content_error("media_svc_check_item_exist_by_path failed : %d", ret);
315 return _content_error_capi(ret);
317 } else if (check_file == MEDIA_CONTENT_ERROR_PERMISSION_DENIED) {
318 content_error("You have no permission for this file %d", ret);
319 return MEDIA_CONTENT_ERROR_PERMISSION_DENIED;
321 /* This means this path has to be deleted */
322 content_debug("This path doesn't exists in file system... So now start to delete it from DB");
323 ret = media_svc_delete_item_by_path(_content_get_db_handle(), storage_id, repl_path, _content_get_uid());
324 if (ret != MS_MEDIA_ERR_NONE) {
325 if (ret == MS_MEDIA_ERR_DB_NO_RECORD) {
326 content_error("Does not exist in media DB also... So, this is an invalid parameter");
327 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
330 content_error("media_svc_delete_item_by_path failed : %d", ret);
331 return _content_error_capi(ret);
335 return _content_error_capi(ret);
338 void _media_content_scan_cb(media_request_result_s* result, void *user_data)
341 media_content_scan_cb_data *cb_data = user_data;
343 err = _content_error_capi(result->result);
344 #ifdef _USE_TVPD_MODE
345 if (result->request_type != MEDIA_REQUEST_SCAN_COMPLETE &&
346 result->request_type != MEDIA_REQUEST_SCAN_PARTIAL &&
347 result->request_type != MEDIA_RECURSIVE_START) {
348 if (cb_data && cb_data->callback) {
349 content_debug("begin:User callback is being called now, result=%d", err);
350 cb_data->callback(err, cb_data->user_data);
351 content_debug("end:User callback is being called now, result=%d", err);
357 if (cb_data && cb_data->callback) {
358 content_debug("User callback is being called now");
359 cb_data->callback(err, cb_data->user_data);
368 #ifdef _USE_TVPD_MODE
369 void _media_content_scan_cb_v2(media_request_result_s* result, void *user_data)
372 media_content_scan_cb_data_v2 *cb_data = user_data;
373 media_content_complete_phase_e complete_phase = -1;
375 content_debug("cb_data is NULL");
376 err = _content_error_capi(result->result);
377 content_debug("result is %d", err);
379 if (result->request_type == MEDIA_REQUEST_SCAN_PARTIAL)
380 complete_phase = MEDIA_CONTENT_SCAN_PARTIAL_COMPLETE;
381 else if (result->request_type == MEDIA_REQUEST_SCAN_COMPLETE)
382 complete_phase = MEDIA_CONTENT_SCAN_COMPLETE;
383 else if (result->request_type == MEDIA_REQUEST_EXTRACT_COMPLETE)
384 complete_phase = MEDIA_CONTENT_EXTRACT_COMPLETE;
385 else if (result->request_type == MEDIA_RECURSIVE_START)
386 complete_phase = MEDIA_CONTENT_RECURSIVE_START;
388 if (cb_data && cb_data->callback)
389 cb_data->callback(err, complete_phase, cb_data->user_data);
391 content_debug("run error");
393 if ((result->request_type != MEDIA_REQUEST_SCAN_COMPLETE) &&
394 (result->request_type != MEDIA_REQUEST_SCAN_PARTIAL) &&
395 (result->request_type != MEDIA_RECURSIVE_START))
402 int media_content_scan_folder(const char *path, bool is_recursive, media_scan_completed_cb callback, void *user_data)
404 int ret = MEDIA_CONTENT_ERROR_NONE;
405 char storage_id[MEDIA_CONTENT_UUID_SIZE+1] = {0, };
406 char repl_path[MAX_PATH_LEN] = {0, };
407 ms_user_storage_type_e storage_type = MS_USER_STORAGE_INTERNAL;
409 content_retvm_if(!STRING_VALID(path), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid path");
411 ret = _media_content_replace_path(path, repl_path);
412 content_retvm_if(!STRING_VALID(repl_path), MEDIA_CONTENT_ERROR_INVALID_OPERATION, "path replacement failed");
414 ret = _media_content_check_dir(repl_path);
415 content_retvm_if(ret == MEDIA_CONTENT_ERROR_PERMISSION_DENIED, ret, "Permission Denied");
417 if (ret == MEDIA_CONTENT_ERROR_NONE) {
418 /* If directory exist check that's ignore directory or not*/
419 content_retvm_if(_media_util_is_ignorable_dir(repl_path), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid folder path");
421 /* This means this folder has to be deleted */
422 /* Or, it is real invalid path.. check storage type */
423 ret = ms_user_get_storage_type(_content_get_uid(), repl_path, &storage_type);
424 if (ret != MS_MEDIA_ERR_NONE) {
425 content_sec_error("ms_user_get_storage_type failed : %d (%s)", ret, repl_path);
426 return _content_error_capi(ret);
429 content_debug("This path doesn't exists in file system... So will be deleted it from DB");
432 ret = media_svc_get_storage_id(_content_get_db_handle(), repl_path, storage_id, _content_get_uid());
433 if (ret != MS_MEDIA_ERR_NONE) {
434 content_error("media_svc_get_storage_id failed : %d", ret);
435 return _content_error_capi(ret);
438 media_content_scan_cb_data *cb_data = NULL;
439 cb_data = (media_content_scan_cb_data *)malloc(sizeof(media_content_scan_cb_data));
440 content_retvm_if(cb_data == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY");
442 cb_data->callback = callback;
443 cb_data->user_data = user_data;
445 ret = media_directory_scanning_async(repl_path, storage_id, is_recursive, _media_content_scan_cb, cb_data, _content_get_uid());
446 if (ret != MS_MEDIA_ERR_NONE) {
447 content_error("media_directory_scanning_async failed : %d", ret);
451 return _content_error_capi(ret);
454 #ifdef _USE_TVPD_MODE
455 int media_content_scan_folder_v2(const char *path, bool is_recursive, media_scan_completed_cb_v2 callback, void *user_data)
457 int ret = MEDIA_CONTENT_ERROR_NONE;
458 char storage_id[MEDIA_CONTENT_UUID_SIZE+1] = {0, };
460 content_retvm_if(!STRING_VALID(path), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid path");
461 content_retvm_if(_media_util_is_ignorable_dir(path), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid folder path");
463 ret = _media_content_check_dir(path);
464 content_retvm_if(ret == MEDIA_CONTENT_ERROR_PERMISSION_DENIED, ret, "Permission Denied");
465 content_retvm_if(ret == MEDIA_CONTENT_ERROR_INVALID_PARAMETER, ret, "invalid path[%s]", path);
467 media_content_scan_cb_data_v2* cb_data = NULL;
468 cb_data = (media_content_scan_cb_data_v2*)malloc(sizeof(media_content_scan_cb_data_v2));
469 content_retvm_if(cb_data == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY");
471 cb_data->callback = callback;
472 cb_data->user_data = user_data;
474 ret = media_svc_get_storage_id(_content_get_db_handle(), path, storage_id, _content_get_uid());
475 /*FIX ME. need to check ret value?*/
477 ret = media_directory_scanning_async(path, storage_id, is_recursive, _media_content_scan_cb_v2, cb_data, _content_get_uid());
478 if (ret != MS_MEDIA_ERR_NONE)
479 content_error("media_directory_scanning_async failed : %d", ret);
481 return _content_error_capi(ret);
485 int media_content_cancel_scan_folder(const char *path)
487 int ret = MEDIA_CONTENT_ERROR_NONE;
488 char repl_path[MAX_PATH_LEN] = {0, };
490 content_retvm_if(!STRING_VALID(path), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid path");
492 ret = _media_content_replace_path(path, repl_path);
493 content_retvm_if(!STRING_VALID(repl_path), MEDIA_CONTENT_ERROR_INVALID_OPERATION, "path replacement failed");
495 ret = media_directory_scanning_cancel(repl_path, _content_get_uid());
496 if (ret != MS_MEDIA_ERR_NONE)
497 content_error("media_directory_scanning_async failed : %d", ret);
499 return _content_error_capi(ret);
502 void _media_content_db_update_noti_cb(
504 media_item_type_e item,
505 media_item_update_type_e update_type,
508 media_type_e content_type,
512 media_noti_cb_s *_noti_info = (media_noti_cb_s *)user_data;
514 if (_noti_info != NULL && _noti_info->update_noti_cb)
515 _noti_info->update_noti_cb(
516 MEDIA_CONTENT_ERROR_NONE,
524 _noti_info->user_data);
527 int media_content_add_db_updated_cb(media_content_db_update_cb callback, void *user_data, media_content_noti_h *noti_handle)
529 int ret = MEDIA_CONTENT_ERROR_NONE;
530 media_noti_cb_s *noti_info = NULL;
532 content_retvm_if(noti_handle == NULL, MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "handle is NULL");
533 content_retvm_if(callback == NULL, MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "callback is NULL");
535 noti_info = (media_noti_cb_s *)calloc(1, sizeof(media_noti_cb_s));
536 content_retvm_if(noti_info == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "Failed to create noti info");
538 noti_info->update_noti_cb = callback;
539 noti_info->user_data = user_data;
541 ret = media_db_update_subscribe_internal((MediaNotiHandle*)noti_handle, _media_content_db_update_noti_cb, (void *)noti_info);
542 if (ret != MS_MEDIA_ERR_NONE)
543 SAFE_FREE(noti_info);
545 return _content_error_capi(ret);
548 #ifdef TIZEN_FEATURE_COMPATIBILITY
549 int media_content_set_db_updated_cb(media_content_db_update_cb callback, void *user_data)
551 content_warn("DEPRECATION WARNING: media_content_set_db_updated_cb() is removed from 5.0.");
553 return MEDIA_CONTENT_ERROR_NONE;
557 static void __media_content_clear_user_data(void *user_data)
559 media_noti_cb_s *noti_info = user_data;
561 SAFE_FREE(noti_info);
564 int media_content_remove_db_updated_cb(media_content_noti_h noti_handle)
566 int ret = MEDIA_CONTENT_ERROR_NONE;
568 ret = media_db_update_unsubscribe_internal((MediaNotiHandle)noti_handle, __media_content_clear_user_data);
570 return _content_error_capi(ret);
572 #ifdef _USE_TVPD_MODE
573 GMutex* _content_get_db_mutex(void)