4 * Copyright (c) 2000 - 2011 Samsung Electronics Co., Ltd. All rights reserved.
6 * Contact: Hyunjun Ko <zzoon.ko@samsung.com>, Haejeong Kim <backto.kim@samsung.com>
8 * Licensed under the Apache License, Version 2.0 (the "License");
9 * you may not use this file except in compliance with the License.
10 * You may obtain a copy of the License at
12 * http://www.apache.org/licenses/LICENSE-2.0
14 * Unless required by applicable law or agreed to in writing, software
15 * distributed under the License is distributed on an "AS IS" BASIS,
16 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
17 * See the License for the specific language governing permissions and
18 * limitations under the License.
24 #include <media-util.h>
25 #include "media-svc.h"
26 #include "media-svc-media.h"
27 #include "media-svc-debug.h"
28 #include "media-svc-util.h"
29 #include "media-svc-db-utils.h"
30 #include "media-svc-media-folder.h"
31 #include "media-svc-album.h"
34 static __thread int g_media_svc_item_validity_data_cnt = 1;
35 static __thread int g_media_svc_item_validity_cur_data_cnt = 0;
37 static __thread int g_media_svc_move_item_data_cnt = 1;
38 static __thread int g_media_svc_move_item_cur_data_cnt = 0;
40 static __thread int g_media_svc_insert_item_data_cnt = 1;
41 static __thread int g_media_svc_insert_item_cur_data_cnt = 0;
46 int media_svc_connect(MediaSvcHandle **handle)
48 int ret = MEDIA_INFO_ERROR_NONE;
49 MediaDBHandle *db_handle = NULL;
51 media_svc_debug_func();
53 #if 1 //Use libmedia_utils API
54 ret = media_db_connect(&db_handle);
55 if(ret != MS_MEDIA_ERR_NONE)
56 return _media_svc_error_convert(ret);
59 sqlite3 * db_handle = NULL;
61 ret = _media_svc_connect_db_with_handle(&db_handle);
62 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
66 return MEDIA_INFO_ERROR_NONE;
70 int media_svc_disconnect(MediaSvcHandle *handle)
72 MediaDBHandle * db_handle = (MediaDBHandle *)handle;
74 media_svc_debug_func();
76 media_svc_retvm_if(db_handle == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "Handle is NULL");
78 #if 1 //Use libmedia_utils API
79 int ret = MEDIA_INFO_ERROR_NONE;
81 ret = media_db_disconnect(db_handle);
82 return _media_svc_error_convert(ret);
84 sqlite3 * db_handle = (sqlite3 *)handle;
86 return _media_svc_disconnect_db_with_handle(db_handle);
90 int media_svc_create_table(MediaSvcHandle *handle)
92 int ret = MEDIA_INFO_ERROR_NONE;
93 sqlite3 * db_handle = (sqlite3 *)handle;
95 media_svc_debug_func();
97 media_svc_retvm_if(db_handle == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "Handle is NULL");
99 /*create media table*/
100 ret = _media_svc_create_media_table(handle);
101 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
103 /*create folder table*/
104 ret = _media_svc_create_folder_table(handle);
105 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
107 /*create playlist table*/
108 ret = _media_svc_create_playlist_table(handle);
109 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
111 /* create album table*/
112 ret = _media_svc_create_album_table(handle);
113 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
116 ret = _media_svc_create_tag_table(handle);
117 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
119 /*create bookmark table*/
120 ret = _media_svc_create_bookmark_table(handle);
121 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
123 #if 0 /*unify media and custom table*/
124 /*create custom table*/
125 ret = _media_svc_create_custom_table(handle);
126 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
129 return MEDIA_INFO_ERROR_NONE;
132 int media_svc_get_storage_type(const char *path, media_svc_storage_type_e *storage_type)
134 int ret = MEDIA_INFO_ERROR_NONE;
135 media_svc_storage_type_e type;
137 ret = _media_svc_get_store_type_by_path(path, &type);
138 media_svc_retvm_if(ret < MEDIA_INFO_ERROR_NONE, ret, "_media_svc_get_store_type_by_path failed : %d", ret);
140 *storage_type = type;
145 int media_svc_get_mime_type(const char *path, char *mimetype)
147 int ret = MEDIA_INFO_ERROR_NONE;
150 return MEDIA_INFO_ERROR_INVALID_PARAMETER;
152 /* In case of drm file. */
153 if (_media_svc_is_drm_file(path)) {
154 ret = _media_svc_get_mime_in_drm_info(path, mimetype);
155 if (ret != MEDIA_INFO_ERROR_NONE) {
156 media_svc_error("Fail to get mime");
160 /*in case of normal files */
161 if (aul_get_mime_from_file(path, mimetype, 255) < 0) {
162 media_svc_error("aul_get_mime_from_file fail");
163 return MEDIA_INFO_ERROR_INVALID_MEDIA;
167 return MEDIA_INFO_ERROR_NONE;
170 int media_svc_get_media_type(const char *path, const char *mime_type, media_svc_media_type_e *media_type)
172 int ret = MEDIA_INFO_ERROR_NONE;
175 media_svc_media_type_e type;
177 ret = _media_svc_get_content_type_from_mime(path, mime_type, &category);
179 media_svc_error("_media_svc_get_content_type_from_mime failed : %d", ret);
182 if (category & MEDIA_SVC_CATEGORY_SOUND) type = MEDIA_SVC_MEDIA_TYPE_SOUND;
183 else if (category & MEDIA_SVC_CATEGORY_MUSIC) type = MEDIA_SVC_MEDIA_TYPE_MUSIC;
184 else if (category & MEDIA_SVC_CATEGORY_IMAGE) type = MEDIA_SVC_MEDIA_TYPE_IMAGE;
185 else if (category & MEDIA_SVC_CATEGORY_VIDEO) type = MEDIA_SVC_MEDIA_TYPE_VIDEO;
186 else type = MEDIA_SVC_MEDIA_TYPE_OTHER;
193 int media_svc_check_item_exist_by_path(MediaSvcHandle *handle, const char *path)
195 int ret = MEDIA_INFO_ERROR_NONE;
196 sqlite3 * db_handle = (sqlite3 *)handle;
199 media_svc_retvm_if(db_handle == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "Handle is NULL");
200 media_svc_retvm_if(!STRING_VALID(path), MEDIA_INFO_ERROR_INVALID_PARAMETER, "Path is NULL");
202 ret = _media_svc_count_record_with_path(db_handle, path, &count);
203 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
206 media_svc_debug("item is exist in database");
207 return MEDIA_INFO_ERROR_NONE;
209 media_svc_debug("item is not exist in database");
210 return MEDIA_INFO_ERROR_DATABASE_NO_RECORD;
213 return MEDIA_INFO_ERROR_NONE;
216 int media_svc_insert_item_begin(MediaSvcHandle *handle, int data_cnt)
218 sqlite3 * db_handle = (sqlite3 *)handle;
220 media_svc_debug("Transaction data count : [%d]", data_cnt);
222 media_svc_retvm_if(db_handle == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "Handle is NULL");
223 media_svc_retvm_if(data_cnt < 1, MEDIA_INFO_ERROR_INVALID_PARAMETER, "data_cnt shuld be bigger than 1");
225 g_media_svc_insert_item_data_cnt = data_cnt;
226 g_media_svc_insert_item_cur_data_cnt = 0;
228 return MEDIA_INFO_ERROR_NONE;
231 int media_svc_insert_item_end(MediaSvcHandle *handle)
233 int ret = MEDIA_INFO_ERROR_NONE;
234 sqlite3 * db_handle = (sqlite3 *)handle;
236 media_svc_debug_func();
238 media_svc_retvm_if(db_handle == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "Handle is NULL");
240 if (g_media_svc_insert_item_cur_data_cnt > 0) {
242 ret = _media_svc_list_query_do(db_handle, MEDIA_SVC_QUERY_INSERT_ITEM);
245 g_media_svc_insert_item_data_cnt = 1;
246 g_media_svc_insert_item_cur_data_cnt = 0;
251 int media_svc_insert_item_bulk(MediaSvcHandle *handle, media_svc_storage_type_e storage_type,
252 const char *path, const char *mime_type, media_svc_media_type_e media_type)
254 int ret = MEDIA_INFO_ERROR_NONE;
255 sqlite3 * db_handle = (sqlite3 *)handle;
256 char folder_uuid[MEDIA_SVC_UUID_SIZE+1] = {0,};
258 media_svc_retvm_if(db_handle == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "Handle is NULL");
259 media_svc_retvm_if(!STRING_VALID(path), MEDIA_INFO_ERROR_INVALID_PARAMETER, "path is NULL");
260 media_svc_retvm_if(!STRING_VALID(mime_type), MEDIA_INFO_ERROR_INVALID_PARAMETER, "mime_type is NULL");
262 if ((storage_type != MEDIA_SVC_STORAGE_INTERNAL) && (storage_type != MEDIA_SVC_STORAGE_EXTERNAL)) {
263 media_svc_error("storage type is incorrect[%d]", storage_type);
264 return MEDIA_INFO_ERROR_INVALID_PARAMETER;
267 if ((media_type < MEDIA_SVC_MEDIA_TYPE_IMAGE) || (media_type > MEDIA_SVC_MEDIA_TYPE_OTHER)) {
268 media_svc_error("invalid media_type condition[%d]", media_type);
269 return MEDIA_INFO_ERROR_INVALID_PARAMETER;
272 media_svc_debug("storage[%d], path[%s], media_type[%d]", storage_type, path, media_type);
274 media_svc_content_info_s content_info;
275 memset(&content_info, 0, sizeof(media_svc_content_info_s));
278 ret = _media_svc_set_media_info(&content_info, storage_type, path, mime_type, media_type, FALSE);
279 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
281 if(media_type == MEDIA_SVC_MEDIA_TYPE_OTHER) {
283 } else if(media_type == MEDIA_SVC_MEDIA_TYPE_IMAGE) {
284 ret = _media_svc_extract_image_metadata(&content_info, media_type);
285 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
287 ret = _media_svc_extract_media_metadata(handle, &content_info, media_type);
288 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
291 /*Set or Get folder id*/
292 ret = _media_svc_get_and_append_folder_id_by_path(handle, path, storage_type, folder_uuid);
293 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
295 ret = __media_svc_malloc_and_strncpy(&content_info.folder_uuid, folder_uuid);
296 media_svc_retv_del_if(ret != MEDIA_INFO_ERROR_NONE, ret, &content_info);
298 if (g_media_svc_insert_item_data_cnt == 1) {
300 ret = _media_svc_insert_item_with_data(db_handle, &content_info, FALSE);
301 media_svc_retv_del_if(ret != MEDIA_INFO_ERROR_NONE, ret, &content_info);
303 } else if(g_media_svc_insert_item_cur_data_cnt < (g_media_svc_insert_item_data_cnt - 1)) {
305 ret = _media_svc_insert_item_with_data(db_handle, &content_info, TRUE);
306 media_svc_retv_del_if(ret != MEDIA_INFO_ERROR_NONE, ret, &content_info);
308 g_media_svc_insert_item_cur_data_cnt ++;
310 } else if (g_media_svc_insert_item_cur_data_cnt == (g_media_svc_insert_item_data_cnt - 1)) {
312 ret = _media_svc_insert_item_with_data(db_handle, &content_info, TRUE);
313 media_svc_retv_del_if(ret != MEDIA_INFO_ERROR_NONE, ret, &content_info);
315 ret = _media_svc_list_query_do(db_handle, MEDIA_SVC_QUERY_INSERT_ITEM);
316 media_svc_retv_del_if(ret != MEDIA_INFO_ERROR_NONE, ret, &content_info);
318 g_media_svc_insert_item_cur_data_cnt = 0;
321 media_svc_error("Error in media_svc_insert_item_bulk");
322 _media_svc_destroy_content_info(&content_info);
323 return MEDIA_INFO_ERROR_INTERNAL;
326 _media_svc_destroy_content_info(&content_info);
328 return MEDIA_INFO_ERROR_NONE;
331 int media_svc_insert_item_immediately(MediaSvcHandle *handle, media_svc_storage_type_e storage_type,
332 const char *path, const char *mime_type, media_svc_media_type_e media_type)
334 int ret = MEDIA_INFO_ERROR_NONE;
335 sqlite3 * db_handle = (sqlite3 *)handle;
336 char folder_uuid[MEDIA_SVC_UUID_SIZE+1] = {0,};
338 media_svc_retvm_if(db_handle == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "Handle is NULL");
339 media_svc_retvm_if(!STRING_VALID(path), MEDIA_INFO_ERROR_INVALID_PARAMETER, "path is NULL");
340 media_svc_retvm_if(!STRING_VALID(mime_type), MEDIA_INFO_ERROR_INVALID_PARAMETER, "mime_type is NULL");
342 if ((storage_type != MEDIA_SVC_STORAGE_INTERNAL) && (storage_type != MEDIA_SVC_STORAGE_EXTERNAL)) {
343 media_svc_error("storage type is incorrect[%d]", storage_type);
344 return MEDIA_INFO_ERROR_INVALID_PARAMETER;
347 if ((media_type < MEDIA_SVC_MEDIA_TYPE_IMAGE) || (media_type > MEDIA_SVC_MEDIA_TYPE_OTHER)) {
348 media_svc_error("invalid media_type condition[%d]", media_type);
349 return MEDIA_INFO_ERROR_INVALID_PARAMETER;
352 media_svc_debug("storage[%d], path[%s], media_type[%d]", storage_type, path, media_type);
354 media_svc_content_info_s content_info;
355 memset(&content_info, 0, sizeof(media_svc_content_info_s));
358 ret = _media_svc_set_media_info(&content_info, storage_type, path, mime_type, media_type, FALSE);
359 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
361 if(media_type == MEDIA_SVC_MEDIA_TYPE_OTHER) {
363 } else if(media_type == MEDIA_SVC_MEDIA_TYPE_IMAGE) {
364 ret = _media_svc_extract_image_metadata(&content_info, media_type);
365 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
367 ret = _media_svc_extract_media_metadata(handle, &content_info, media_type);
368 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
371 /*Set or Get folder id*/
372 ret = _media_svc_get_and_append_folder_id_by_path(handle, path, storage_type, folder_uuid);
373 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
375 ret = __media_svc_malloc_and_strncpy(&content_info.folder_uuid, folder_uuid);
376 media_svc_retv_del_if(ret != MEDIA_INFO_ERROR_NONE, ret, &content_info);
378 /* Extracting thumbnail */
379 if (media_type == MEDIA_SVC_MEDIA_TYPE_IMAGE || media_type == MEDIA_SVC_MEDIA_TYPE_VIDEO) {
380 char thumb_path[MEDIA_SVC_PATHNAME_SIZE + 1] = {0, };
384 ret = thumbnail_request_from_db_with_size(content_info.path, thumb_path, sizeof(thumb_path), &width, &height);
386 media_svc_error("thumbnail_request_from_db failed: %d", ret);
388 media_svc_debug("thumbnail_request_from_db success: %s", thumb_path);
391 if (content_info.media_meta.width <= 0)
392 content_info.media_meta.width = width;
394 if (content_info.media_meta.height <= 0)
395 content_info.media_meta.height = height;
397 ret = __media_svc_malloc_and_strncpy(&(content_info.thumbnail_path), thumb_path);
398 media_svc_retv_del_if(ret != MEDIA_INFO_ERROR_NONE, ret, &content_info);
401 ret = _media_svc_insert_item_with_data(db_handle, &content_info, FALSE);
403 _media_svc_destroy_content_info(&content_info);
407 int media_svc_insert_folder(MediaSvcHandle *handle, media_svc_storage_type_e storage_type, const char *path)
409 int ret = MEDIA_INFO_ERROR_NONE;
410 sqlite3 * db_handle = (sqlite3 *)handle;
412 media_svc_retvm_if(db_handle == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "Handle is NULL");
413 media_svc_retvm_if(!STRING_VALID(path), MEDIA_INFO_ERROR_INVALID_PARAMETER, "path is NULL");
415 if ((storage_type != MEDIA_SVC_STORAGE_INTERNAL) && (storage_type != MEDIA_SVC_STORAGE_EXTERNAL)) {
416 media_svc_error("storage type is incorrect[%d]", storage_type);
417 return MEDIA_INFO_ERROR_INVALID_PARAMETER;
420 media_svc_debug("storage[%d], folder_path[%s]", storage_type, path);
423 char *folder_name = NULL;
424 int folder_modified_date = 0;
425 char *folder_uuid = _media_info_generate_uuid();
426 if(folder_uuid == NULL ) {
427 media_svc_error("Invalid UUID");
428 return MEDIA_INFO_ERROR_INTERNAL;
431 folder_name = g_path_get_basename(path);
432 folder_modified_date = _media_svc_get_file_time(path);
434 ret = _media_svc_append_folder(handle, storage_type, folder_uuid, path, folder_name, folder_modified_date);
435 SAFE_FREE(folder_name);
437 if (ret < MEDIA_INFO_ERROR_NONE) {
438 media_svc_error("_media_svc_append_folder error [%d]", ret);
442 return MEDIA_INFO_ERROR_NONE;
445 int media_svc_move_item_begin(MediaSvcHandle *handle, int data_cnt)
447 sqlite3 * db_handle = (sqlite3 *)handle;
449 media_svc_debug("Transaction data count : [%d]", data_cnt);
451 media_svc_retvm_if(db_handle == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "Handle is NULL");
452 media_svc_retvm_if(data_cnt < 1, MEDIA_INFO_ERROR_INVALID_PARAMETER, "data_cnt shuld be bigger than 1");
454 g_media_svc_move_item_data_cnt = data_cnt;
455 g_media_svc_move_item_cur_data_cnt = 0;
457 return MEDIA_INFO_ERROR_NONE;
460 int media_svc_move_item_end(MediaSvcHandle *handle)
462 int ret = MEDIA_INFO_ERROR_NONE;
463 sqlite3 * db_handle = (sqlite3 *)handle;
465 media_svc_debug_func();
467 media_svc_retvm_if(db_handle == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "Handle is NULL");
469 if (g_media_svc_move_item_cur_data_cnt > 0) {
471 ret = _media_svc_list_query_do(db_handle, MEDIA_SVC_QUERY_MOVE_ITEM);
474 /*clean up old folder path*/
475 ret = _media_svc_update_folder_table(handle);
476 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
478 g_media_svc_move_item_data_cnt = 1;
479 g_media_svc_move_item_cur_data_cnt = 0;
484 int media_svc_move_item(MediaSvcHandle *handle, media_svc_storage_type_e src_storage, const char *src_path,
485 media_svc_storage_type_e dest_storage, const char *dest_path)
487 int ret = MEDIA_INFO_ERROR_NONE;
488 sqlite3 * db_handle = (sqlite3 *)handle;
489 char *file_name = NULL;
490 char *folder_path = NULL;
491 int modified_time = 0;
492 char folder_uuid[MEDIA_SVC_UUID_SIZE+1] = {0,};
493 char old_thumb_path[MEDIA_SVC_PATHNAME_SIZE] = {0,};
494 char new_thumb_path[MEDIA_SVC_PATHNAME_SIZE] = {0,};
497 media_svc_debug_func();
499 media_svc_retvm_if(db_handle == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "Handle is NULL");
500 media_svc_retvm_if(!STRING_VALID(src_path), MEDIA_INFO_ERROR_INVALID_PARAMETER, "src_path is NULL");
501 media_svc_retvm_if(!STRING_VALID(dest_path), MEDIA_INFO_ERROR_INVALID_PARAMETER, "dest_path is NULL");
503 if ((src_storage != MEDIA_SVC_STORAGE_INTERNAL) && (src_storage != MEDIA_SVC_STORAGE_EXTERNAL)) {
504 media_svc_error("src_storage type is incorrect[%d]", src_storage);
505 return MEDIA_INFO_ERROR_INVALID_PARAMETER;
507 if ((dest_storage != MEDIA_SVC_STORAGE_INTERNAL) && (dest_storage != MEDIA_SVC_STORAGE_EXTERNAL)) {
508 media_svc_error("dest_storage type is incorrect[%d]", dest_storage);
509 return MEDIA_INFO_ERROR_INVALID_PARAMETER;
512 /*check and update folder*/
513 ret = _media_svc_get_and_append_folder_id_by_path(handle, dest_path, dest_storage, folder_uuid);
514 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
517 file_name = g_path_get_basename(dest_path);
519 /*get modified_time*/
520 modified_time = _media_svc_get_file_time(dest_path);
522 /*get thumbnail_path to update. only for Imgae and Video items. Audio share album_art(thumbnail)*/
523 ret = _media_svc_get_media_type_by_path(handle, src_path, &media_type);
524 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
526 if((media_type == MEDIA_SVC_MEDIA_TYPE_IMAGE) ||(media_type == MEDIA_SVC_MEDIA_TYPE_VIDEO)) {
527 /*get old thumbnail_path*/
528 ret = _media_svc_get_thumbnail_path_by_path(handle, src_path, old_thumb_path);
529 media_svc_retv_if((ret != MEDIA_INFO_ERROR_NONE) && (ret != MEDIA_INFO_ERROR_DATABASE_NO_RECORD), ret);
531 _media_svc_get_thumbnail_path(dest_storage, new_thumb_path, dest_path, THUMB_EXT);
534 if (g_media_svc_move_item_data_cnt == 1) {
537 if((media_type == MEDIA_SVC_MEDIA_TYPE_IMAGE) ||(media_type == MEDIA_SVC_MEDIA_TYPE_VIDEO)) {
538 ret = _media_svc_update_item_by_path(handle, src_path, dest_storage, dest_path, file_name, modified_time, folder_uuid, new_thumb_path, FALSE);
540 ret = _media_svc_update_item_by_path(handle, src_path, dest_storage, dest_path, file_name, modified_time, folder_uuid, NULL, FALSE);
542 SAFE_FREE(file_name);
543 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
545 /*update folder modified_time*/
546 folder_path = g_path_get_dirname(dest_path);
547 ret = _media_svc_update_folder_modified_time_by_folder_uuid(handle, folder_uuid, folder_path, FALSE);
548 SAFE_FREE(folder_path);
549 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
551 ret = _media_svc_update_folder_table(handle);
552 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
554 } else if (g_media_svc_move_item_cur_data_cnt < (g_media_svc_move_item_data_cnt - 1)) {
557 if((media_type == MEDIA_SVC_MEDIA_TYPE_IMAGE) ||(media_type == MEDIA_SVC_MEDIA_TYPE_VIDEO)) {
558 ret = _media_svc_update_item_by_path(handle, src_path, dest_storage, dest_path, file_name, modified_time, folder_uuid, new_thumb_path, TRUE);
560 ret = _media_svc_update_item_by_path(handle, src_path, dest_storage, dest_path, file_name, modified_time, folder_uuid, NULL, TRUE);
562 SAFE_FREE(file_name);
563 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
565 /*update folder modified_time*/
566 folder_path = g_path_get_dirname(dest_path);
567 ret = _media_svc_update_folder_modified_time_by_folder_uuid(handle, folder_uuid, folder_path, TRUE);
568 SAFE_FREE(folder_path);
569 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
571 g_media_svc_move_item_cur_data_cnt ++;
573 } else if (g_media_svc_move_item_cur_data_cnt == (g_media_svc_move_item_data_cnt - 1)) {
576 if((media_type == MEDIA_SVC_MEDIA_TYPE_IMAGE) ||(media_type == MEDIA_SVC_MEDIA_TYPE_VIDEO)) {
577 ret = _media_svc_update_item_by_path(handle, src_path, dest_storage, dest_path, file_name, modified_time, folder_uuid, new_thumb_path, TRUE);
579 ret = _media_svc_update_item_by_path(handle, src_path, dest_storage, dest_path, file_name, modified_time, folder_uuid, NULL, TRUE);
581 SAFE_FREE(file_name);
582 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
584 /*update folder modified_time*/
585 folder_path = g_path_get_dirname(dest_path);
586 ret = _media_svc_update_folder_modified_time_by_folder_uuid(handle, folder_uuid, folder_path, TRUE);
587 SAFE_FREE(folder_path);
588 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
591 ret = _media_svc_list_query_do(db_handle, MEDIA_SVC_QUERY_MOVE_ITEM);
592 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
594 g_media_svc_move_item_cur_data_cnt = 0;
597 media_svc_error("Error in media_svc_move_item");
598 return MEDIA_INFO_ERROR_INTERNAL;
601 /*rename thumbnail file*/
602 if((media_type == MEDIA_SVC_MEDIA_TYPE_IMAGE) ||(media_type == MEDIA_SVC_MEDIA_TYPE_VIDEO)) {
603 if(strlen(old_thumb_path) > 0) {
604 ret = _media_svc_rename_file(old_thumb_path,new_thumb_path);
605 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
609 return MEDIA_INFO_ERROR_NONE;
612 int media_svc_set_item_validity_begin(MediaSvcHandle *handle, int data_cnt)
614 sqlite3 * db_handle = (sqlite3 *)handle;
616 media_svc_debug("Transaction data count : [%d]", data_cnt);
618 media_svc_retvm_if(db_handle == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "Handle is NULL");
619 media_svc_retvm_if(data_cnt < 1, MEDIA_INFO_ERROR_INVALID_PARAMETER, "data_cnt shuld be bigger than 1");
621 g_media_svc_item_validity_data_cnt = data_cnt;
622 g_media_svc_item_validity_cur_data_cnt = 0;
624 return MEDIA_INFO_ERROR_NONE;
627 int media_svc_set_item_validity_end(MediaSvcHandle *handle)
629 int ret = MEDIA_INFO_ERROR_NONE;
630 sqlite3 * db_handle = (sqlite3 *)handle;
632 media_svc_debug_func();
634 media_svc_retvm_if(db_handle == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "Handle is NULL");
636 if (g_media_svc_item_validity_cur_data_cnt > 0) {
638 ret = _media_svc_list_query_do(db_handle, MEDIA_SVC_QUERY_SET_ITEM_VALIDITY);
641 g_media_svc_item_validity_data_cnt = 1;
642 g_media_svc_item_validity_cur_data_cnt = 0;
647 int media_svc_set_item_validity(MediaSvcHandle *handle, const char *path, int validity)
649 int ret = MEDIA_INFO_ERROR_NONE;
650 sqlite3 * db_handle = (sqlite3 *)handle;
652 media_svc_retvm_if(db_handle == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "Handle is NULL");
653 media_svc_retvm_if(!STRING_VALID(path), MEDIA_INFO_ERROR_INVALID_PARAMETER, "path is NULL");
655 media_svc_debug("path=[%s], validity=[%d]", path, validity);
657 if (g_media_svc_item_validity_data_cnt == 1) {
659 return _media_svc_update_item_validity(db_handle, path, validity, FALSE);
661 } else if (g_media_svc_item_validity_cur_data_cnt < (g_media_svc_item_validity_data_cnt - 1)) {
663 ret = _media_svc_update_item_validity(db_handle, path, validity, TRUE);
664 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
666 g_media_svc_item_validity_cur_data_cnt ++;
668 } else if (g_media_svc_item_validity_cur_data_cnt == (g_media_svc_item_validity_data_cnt - 1)) {
670 ret = _media_svc_update_item_validity(db_handle, path, validity, TRUE);
671 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
673 ret = _media_svc_list_query_do(db_handle, MEDIA_SVC_QUERY_SET_ITEM_VALIDITY);
674 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
676 g_media_svc_item_validity_cur_data_cnt = 0;
680 media_svc_error("Error in media_svc_set_item_validity");
681 return MEDIA_INFO_ERROR_INTERNAL;
684 return MEDIA_INFO_ERROR_NONE;
687 int media_svc_delete_item_by_path(MediaSvcHandle *handle, const char *path)
689 int ret = MEDIA_INFO_ERROR_NONE;
690 sqlite3 * db_handle = (sqlite3 *)handle;
691 char thumb_path[MEDIA_SVC_PATHNAME_SIZE] = {0,};
693 media_svc_debug_func();
695 media_svc_retvm_if(db_handle == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "Handle is NULL");
696 media_svc_retvm_if(!STRING_VALID(path), MEDIA_INFO_ERROR_INVALID_PARAMETER, "path is NULL");
698 /*Get thumbnail path to delete*/
699 ret = _media_svc_get_thumbnail_path_by_path(db_handle, path, thumb_path);
700 media_svc_retv_if((ret != MEDIA_INFO_ERROR_NONE) && (ret != MEDIA_INFO_ERROR_DATABASE_NO_RECORD), ret);
703 ret = _media_svc_delete_item_by_path(db_handle, path);
704 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
707 if (strlen(thumb_path) > 0) {
708 if (_media_svc_remove_file(thumb_path) == FALSE) {
709 media_svc_error("fail to remove thumbnail file.");
710 return MEDIA_INFO_ERROR_INTERNAL;
714 return MEDIA_INFO_ERROR_NONE;
717 int media_svc_delete_all_items_in_storage(MediaSvcHandle *handle, media_svc_storage_type_e storage_type)
719 int ret = MEDIA_INFO_ERROR_NONE;
720 sqlite3 * db_handle = (sqlite3 *)handle;
721 char * dirpath = NULL;
723 media_svc_debug("media_svc_delete_all_items_in_storage [%d]", storage_type);
725 media_svc_retvm_if(db_handle == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "Handle is NULL");
727 if ((storage_type != MEDIA_SVC_STORAGE_INTERNAL) && (storage_type != MEDIA_SVC_STORAGE_EXTERNAL)) {
728 media_svc_error("storage type is incorrect[%d]", storage_type);
729 return MEDIA_INFO_ERROR_INVALID_PARAMETER;
732 ret = _media_svc_truncate_table(db_handle, storage_type);
733 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
735 dirpath = (storage_type == MEDIA_SVC_STORAGE_INTERNAL) ? MEDIA_SVC_THUMB_INTERNAL_PATH : MEDIA_SVC_THUMB_EXTERNAL_PATH;
737 /* remove thumbnails */
738 ret = _media_svc_remove_all_files_in_dir(dirpath);
739 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
741 return MEDIA_INFO_ERROR_NONE;
744 int media_svc_delete_invalid_items_in_storage(MediaSvcHandle *handle, media_svc_storage_type_e storage_type)
746 sqlite3 * db_handle = (sqlite3 *)handle;
748 media_svc_debug_func();
750 media_svc_retvm_if(db_handle == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "Handle is NULL");
752 if ((storage_type != MEDIA_SVC_STORAGE_INTERNAL) && (storage_type != MEDIA_SVC_STORAGE_EXTERNAL)) {
753 media_svc_error("storage type is incorrect[%d]", storage_type);
754 return MEDIA_INFO_ERROR_INVALID_PARAMETER;
757 /*Delete from DB and remove thumbnail files*/
758 return _media_svc_delete_invalid_items(db_handle, storage_type);
761 int media_svc_delete_invalid_items_in_folder(MediaSvcHandle *handle, const char *folder_path)
763 sqlite3 * db_handle = (sqlite3 *)handle;
765 media_svc_debug_func();
767 media_svc_retvm_if(db_handle == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "Handle is NULL");
769 /*Delete from DB and remove thumbnail files*/
770 return _media_svc_delete_invalid_folder_items(db_handle, folder_path);
773 int media_svc_set_all_storage_items_validity(MediaSvcHandle *handle, media_svc_storage_type_e storage_type, int validity)
775 sqlite3 * db_handle = (sqlite3 *)handle;
777 media_svc_retvm_if(db_handle == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "Handle is NULL");
779 if ((storage_type != MEDIA_SVC_STORAGE_INTERNAL) && (storage_type != MEDIA_SVC_STORAGE_EXTERNAL)) {
780 media_svc_error("storage type is incorrect[%d]", storage_type);
781 return MEDIA_INFO_ERROR_INVALID_PARAMETER;
784 return _media_svc_update_storage_item_validity(db_handle, storage_type, validity);
787 int media_svc_set_folder_items_validity(MediaSvcHandle *handle, const char *folder_path, int validity, int recursive)
789 sqlite3 * db_handle = (sqlite3 *)handle;
791 media_svc_retvm_if(db_handle == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "Handle is NULL");
792 media_svc_retvm_if(!STRING_VALID(folder_path), MEDIA_INFO_ERROR_INVALID_PARAMETER, "folder_path is NULL");
795 return _media_svc_update_recursive_folder_item_validity(db_handle, folder_path, validity);
797 return _media_svc_update_folder_item_validity(db_handle, folder_path, validity);
800 int media_svc_refresh_item(MediaSvcHandle *handle, media_svc_storage_type_e storage_type,
801 const char *path, media_svc_media_type_e media_type)
803 int ret = MEDIA_INFO_ERROR_NONE;
804 sqlite3 * db_handle = (sqlite3 *)handle;
806 media_svc_retvm_if(db_handle == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "Handle is NULL");
807 media_svc_retvm_if(!STRING_VALID(path), MEDIA_INFO_ERROR_INVALID_PARAMETER, "path is NULL");
809 if ((storage_type != MEDIA_SVC_STORAGE_INTERNAL) && (storage_type != MEDIA_SVC_STORAGE_EXTERNAL)) {
810 media_svc_error("storage type is incorrect[%d]", storage_type);
811 return MEDIA_INFO_ERROR_INVALID_PARAMETER;
814 if ((media_type < MEDIA_SVC_MEDIA_TYPE_IMAGE) || (media_type > MEDIA_SVC_MEDIA_TYPE_OTHER)) {
815 media_svc_error("invalid media_type condition[%d]", media_type);
816 return MEDIA_INFO_ERROR_INVALID_PARAMETER;
819 media_svc_debug("storage[%d], path[%s], media_type[%d]", storage_type, path, media_type);
821 media_svc_content_info_s content_info;
822 memset(&content_info, 0, sizeof(media_svc_content_info_s));
825 ret = _media_svc_set_media_info(&content_info, storage_type, path, NULL, media_type, TRUE);
826 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
828 /* Initialize thumbnail information to remake thumbnail. */
829 char thumb_path[MEDIA_SVC_PATHNAME_SIZE + 1];
830 ret = _media_svc_get_thumbnail_path_by_path(handle, path, thumb_path);
831 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
833 if (g_file_test(thumb_path, G_FILE_TEST_EXISTS)) {
834 ret = _media_svc_remove_file(thumb_path);
835 media_svc_retv_if(ret != TRUE, ret);
838 ret = _media_svc_update_thumbnail_path(handle, path, NULL);
839 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
841 if(media_type == MEDIA_SVC_MEDIA_TYPE_OTHER) {
843 } else if(media_type == MEDIA_SVC_MEDIA_TYPE_IMAGE) {
844 ret = _media_svc_extract_image_metadata(&content_info, media_type);
845 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
847 ret = _media_svc_extract_media_metadata(handle, &content_info, media_type);
848 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
851 /* Extracting thumbnail */
852 if (media_type == MEDIA_SVC_MEDIA_TYPE_IMAGE || media_type == MEDIA_SVC_MEDIA_TYPE_VIDEO) {
853 char thumb_path[MEDIA_SVC_PATHNAME_SIZE + 1] = {0, };
857 ret = thumbnail_request_from_db_with_size(content_info.path, thumb_path, sizeof(thumb_path), &width, &height);
859 media_svc_error("thumbnail_request_from_db failed: %d", ret);
861 media_svc_debug("thumbnail_request_from_db success: %s", thumb_path);
864 if (content_info.media_meta.width <= 0)
865 content_info.media_meta.width = width;
867 if (content_info.media_meta.height <= 0)
868 content_info.media_meta.height = height;
870 ret = __media_svc_malloc_and_strncpy(&(content_info.thumbnail_path), thumb_path);
871 media_svc_retv_del_if(ret != MEDIA_INFO_ERROR_NONE, ret, &content_info);
874 ret = _media_svc_update_item_with_data(db_handle, &content_info);
876 _media_svc_destroy_content_info(&content_info);
881 int media_svc_rename_folder(MediaSvcHandle *handle, const char *src_path, const char *dst_path)
883 sqlite3 * db_handle = (sqlite3 *)handle;
884 int ret = MEDIA_INFO_ERROR_NONE;
886 media_svc_retvm_if(db_handle == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "Handle is NULL");
887 media_svc_retvm_if(src_path == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "src_path is NULL");
888 media_svc_retvm_if(dst_path == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "dst_path is NULL");
890 media_svc_debug("Src path : %s, Dst Path : %s", src_path, dst_path);
892 ret = _media_svc_sql_begin_trans(handle);
893 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
895 /* Update all folder record's path, which are matched by old parent path */
896 char *update_folder_path_sql = NULL;
897 char src_path_slash[MEDIA_SVC_PATHNAME_SIZE + 1];
898 char dst_path_slash[MEDIA_SVC_PATHNAME_SIZE + 1];
900 snprintf(src_path_slash, sizeof(src_path_slash), "%s/", src_path);
901 snprintf(dst_path_slash, sizeof(dst_path_slash), "%s/", dst_path);
903 update_folder_path_sql = sqlite3_mprintf("UPDATE folder SET path = REPLACE( path, '%q', '%q');", src_path_slash, dst_path_slash);
905 //ret = _media_svc_sql_query(handle, update_folder_path_sql);
906 ret = media_db_request_update_db_batch(update_folder_path_sql);
907 sqlite3_free(update_folder_path_sql);
909 if (ret != SQLITE_OK) {
910 media_svc_error("failed to update folder path");
911 _media_svc_sql_rollback_trans(handle);
913 return MEDIA_INFO_ERROR_DATABASE_INTERNAL;
916 /* Update all folder record's modified date, which are changed above */
917 char *update_folder_modified_time_sql = NULL;
921 update_folder_modified_time_sql = sqlite3_mprintf("UPDATE folder SET modified_time = %d where path like '%q';", date, dst_path);
923 ret = media_db_request_update_db_batch(update_folder_modified_time_sql);
924 //ret = _media_svc_sql_query(handle, update_folder_modified_time_sql);
925 sqlite3_free(update_folder_modified_time_sql);
927 if (ret != SQLITE_OK) {
928 media_svc_error("failed to update folder modified time");
929 _media_svc_sql_rollback_trans(handle);
931 return MEDIA_INFO_ERROR_DATABASE_INTERNAL;
934 /* Update all items */
935 char *select_all_sql = NULL;
936 sqlite3_stmt *sql_stmt = NULL;
937 char dst_child_path[MEDIA_SVC_PATHNAME_SIZE + 1];
939 snprintf(dst_child_path, sizeof(dst_child_path), "%s/%%", dst_path);
941 select_all_sql = sqlite3_mprintf("SELECT media_uuid, path, thumbnail_path, media_type from media where folder_uuid IN ( SELECT folder_uuid FROM folder where path='%q' or path like '%q');", dst_path, dst_child_path);
943 media_svc_debug("[SQL query] : %s", select_all_sql);
945 ret = sqlite3_prepare_v2(handle, select_all_sql, -1, &sql_stmt, NULL);
946 sqlite3_free((char *)select_all_sql);
948 if (ret != SQLITE_OK) {
949 media_svc_error ("prepare error [%s]", sqlite3_errmsg(handle));
950 _media_svc_sql_rollback_trans(handle);
951 return MEDIA_INFO_ERROR_DATABASE_INTERNAL;
955 ret = sqlite3_step(sql_stmt);
956 if (ret != SQLITE_ROW) {
957 media_svc_debug("end of iteration");
961 char media_uuid[MEDIA_SVC_UUID_SIZE + 1] = {0,};
962 char media_path[MEDIA_SVC_PATHNAME_SIZE + 1] = {0,};
963 char media_thumb_path[MEDIA_SVC_PATHNAME_SIZE + 1] = {0,};
964 char media_new_thumb_path[MEDIA_SVC_PATHNAME_SIZE + 1] = {0,};
966 bool no_thumb = FALSE;
968 if (STRING_VALID((const char *)sqlite3_column_text(sql_stmt, 0))) {
969 strncpy(media_uuid, (const char *)sqlite3_column_text(sql_stmt, 0), sizeof(media_uuid));
971 media_svc_error("media UUID is NULL");
972 return MEDIA_INFO_ERROR_DATABASE_INVALID;
975 if (STRING_VALID((const char *)sqlite3_column_text(sql_stmt, 1))) {
976 strncpy(media_path, (const char *)sqlite3_column_text(sql_stmt, 1), sizeof(media_path));
978 media_svc_error("media path is NULL");
979 return MEDIA_INFO_ERROR_DATABASE_INVALID;
982 if (STRING_VALID((const char *)sqlite3_column_text(sql_stmt, 2))) {
983 strncpy(media_thumb_path, (const char *)sqlite3_column_text(sql_stmt, 2), sizeof(media_thumb_path));
985 media_svc_debug("media thumb path doesn't exist in DB");
989 media_type = sqlite3_column_int(sql_stmt, 3);
991 /* Update path, thumbnail path of this item */
992 char *replaced_path = NULL;
993 replaced_path = _media_svc_replace_path(media_path, src_path, dst_path);
994 if (replaced_path == NULL) {
995 media_svc_error("_media_svc_replace_path failed");
996 SQLITE3_FINALIZE(sql_stmt);
997 _media_svc_sql_rollback_trans(handle);
998 return MEDIA_INFO_ERROR_INTERNAL;
1001 media_svc_debug("New media path : %s", replaced_path);
1002 media_svc_storage_type_e storage_type;
1005 ret = _media_svc_get_store_type_by_path(replaced_path, &storage_type);
1007 media_svc_error("_media_svc_get_store_type_by_path failed : %d", ret);
1008 SAFE_FREE(replaced_path);
1009 _media_svc_sql_rollback_trans(handle);
1010 return MEDIA_INFO_ERROR_DATABASE_INTERNAL;
1013 ret = _media_svc_get_thumbnail_path(storage_type, media_new_thumb_path, replaced_path, THUMB_EXT);
1015 media_svc_error("_media_svc_get_thumbnail_path failed : %d", ret);
1016 SAFE_FREE(replaced_path);
1017 SQLITE3_FINALIZE(sql_stmt);
1018 _media_svc_sql_rollback_trans(handle);
1019 return MEDIA_INFO_ERROR_INTERNAL;
1022 //media_svc_debug("New media thumbnail path : %s", media_new_thumb_path);
1025 char *update_item_sql = NULL;
1028 update_item_sql = sqlite3_mprintf("UPDATE media SET path='%q' WHERE media_uuid='%q'", replaced_path, media_uuid);
1030 if (media_type == MEDIA_SVC_MEDIA_TYPE_IMAGE || media_type == MEDIA_SVC_MEDIA_TYPE_VIDEO) {
1031 update_item_sql = sqlite3_mprintf("UPDATE media SET path='%q', thumbnail_path='%q' WHERE media_uuid='%q'", replaced_path, media_new_thumb_path, media_uuid);
1033 update_item_sql = sqlite3_mprintf("UPDATE media SET path='%q', thumbnail_path='%q' WHERE media_uuid='%q'", replaced_path, media_thumb_path, media_uuid);
1037 ret = media_db_request_update_db_batch(update_item_sql);
1038 //ret = _media_svc_sql_query(handle, update_item_sql);
1039 sqlite3_free(update_item_sql);
1040 SAFE_FREE(replaced_path);
1042 if (ret != SQLITE_OK) {
1043 media_svc_error("failed to update item");
1044 SQLITE3_FINALIZE(sql_stmt);
1045 _media_svc_sql_rollback_trans(handle);
1047 return MEDIA_INFO_ERROR_DATABASE_INTERNAL;
1050 /* Rename thumbnail file of file system */
1051 if ((!no_thumb) && (media_type == MEDIA_SVC_MEDIA_TYPE_IMAGE || media_type == MEDIA_SVC_MEDIA_TYPE_VIDEO)) {
1052 ret = _media_svc_rename_file(media_thumb_path, media_new_thumb_path);
1054 media_svc_error("_media_svc_rename_file failed : %d", ret);
1055 SQLITE3_FINALIZE(sql_stmt);
1056 _media_svc_sql_rollback_trans(handle);
1058 return MEDIA_INFO_ERROR_INTERNAL;
1063 SQLITE3_FINALIZE(sql_stmt);
1065 ret = _media_svc_sql_end_trans(handle);
1066 if (ret != MEDIA_INFO_ERROR_NONE) {
1067 media_svc_error("mb_svc_sqlite3_commit_trans failed.. Now start to rollback\n");
1068 _media_svc_sql_rollback_trans(handle);
1072 return MEDIA_INFO_ERROR_NONE;
1075 int media_svc_request_update_db(const char *db_query)
1077 int ret = MEDIA_INFO_ERROR_NONE;
1079 media_svc_retvm_if(!STRING_VALID(db_query), MEDIA_INFO_ERROR_INVALID_PARAMETER, "db_query is NULL");
1081 ret = _media_svc_request_update_db(db_query);
1083 return _media_svc_error_convert(ret);