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"
32 #include "media-svc-noti.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;
43 /* Flag for items to be published by notification */
44 static __thread int g_insert_with_noti = FALSE;
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 in DRM");
162 /*in case of normal files or failure to get mime in drm */
163 if (aul_get_mime_from_file(path, mimetype, 255) < 0) {
164 media_svc_error("aul_get_mime_from_file fail");
165 return MEDIA_INFO_ERROR_INVALID_MEDIA;
168 return MEDIA_INFO_ERROR_NONE;
171 int media_svc_get_media_type(const char *path, const char *mime_type, media_svc_media_type_e *media_type)
173 int ret = MEDIA_INFO_ERROR_NONE;
176 media_svc_media_type_e type;
178 ret = _media_svc_get_content_type_from_mime(path, mime_type, &category);
180 media_svc_error("_media_svc_get_content_type_from_mime failed : %d", ret);
183 if (category & MEDIA_SVC_CATEGORY_SOUND) type = MEDIA_SVC_MEDIA_TYPE_SOUND;
184 else if (category & MEDIA_SVC_CATEGORY_MUSIC) type = MEDIA_SVC_MEDIA_TYPE_MUSIC;
185 else if (category & MEDIA_SVC_CATEGORY_IMAGE) type = MEDIA_SVC_MEDIA_TYPE_IMAGE;
186 else if (category & MEDIA_SVC_CATEGORY_VIDEO) type = MEDIA_SVC_MEDIA_TYPE_VIDEO;
187 else type = MEDIA_SVC_MEDIA_TYPE_OTHER;
194 int media_svc_check_item_exist_by_path(MediaSvcHandle *handle, const char *path)
196 int ret = MEDIA_INFO_ERROR_NONE;
197 sqlite3 * db_handle = (sqlite3 *)handle;
200 media_svc_retvm_if(db_handle == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "Handle is NULL");
201 media_svc_retvm_if(!STRING_VALID(path), MEDIA_INFO_ERROR_INVALID_PARAMETER, "Path is NULL");
203 ret = _media_svc_count_record_with_path(db_handle, path, &count);
204 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
207 media_svc_debug("item is exist in database");
208 return MEDIA_INFO_ERROR_NONE;
210 media_svc_debug("item is not exist in database");
211 return MEDIA_INFO_ERROR_DATABASE_NO_RECORD;
214 return MEDIA_INFO_ERROR_NONE;
217 int media_svc_insert_item_begin(MediaSvcHandle *handle, int data_cnt, int with_noti, int from_pid)
219 sqlite3 * db_handle = (sqlite3 *)handle;
221 media_svc_debug("Transaction data count : [%d]", data_cnt);
223 media_svc_retvm_if(db_handle == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "Handle is NULL");
224 media_svc_retvm_if(data_cnt < 1, MEDIA_INFO_ERROR_INVALID_PARAMETER, "data_cnt shuld be bigger than 1");
226 g_media_svc_insert_item_data_cnt = data_cnt;
227 g_media_svc_insert_item_cur_data_cnt = 0;
229 /* Prepare for making noti item list */
231 media_svc_debug("making noti list from pid[%d]", from_pid);
232 if (_media_svc_create_noti_list(data_cnt) != MEDIA_INFO_ERROR_NONE) {
233 return MEDIA_INFO_ERROR_OUT_OF_MEMORY;
236 _media_svc_set_noti_from_pid(from_pid);
237 g_insert_with_noti = TRUE;
240 return MEDIA_INFO_ERROR_NONE;
243 int media_svc_insert_item_end(MediaSvcHandle *handle)
245 int ret = MEDIA_INFO_ERROR_NONE;
246 sqlite3 * db_handle = (sqlite3 *)handle;
248 media_svc_debug_func();
250 media_svc_retvm_if(db_handle == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "Handle is NULL");
252 if (g_media_svc_insert_item_cur_data_cnt > 0) {
254 ret = _media_svc_list_query_do(db_handle, MEDIA_SVC_QUERY_INSERT_ITEM);
255 if (g_insert_with_noti) {
256 media_svc_debug("sending noti list");
257 _media_svc_publish_noti_list(g_media_svc_insert_item_cur_data_cnt);
258 _media_svc_destroy_noti_list(g_media_svc_insert_item_cur_data_cnt);
259 g_insert_with_noti = FALSE;
260 _media_svc_set_noti_from_pid(-1);
264 g_media_svc_insert_item_data_cnt = 1;
265 g_media_svc_insert_item_cur_data_cnt = 0;
270 int media_svc_insert_item_bulk(MediaSvcHandle *handle, media_svc_storage_type_e storage_type,
271 const char *path, const char *mime_type, media_svc_media_type_e media_type, int is_burst)
273 int ret = MEDIA_INFO_ERROR_NONE;
274 sqlite3 * db_handle = (sqlite3 *)handle;
275 char folder_uuid[MEDIA_SVC_UUID_SIZE+1] = {0,};
277 media_svc_retvm_if(db_handle == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "Handle is NULL");
278 media_svc_retvm_if(!STRING_VALID(path), MEDIA_INFO_ERROR_INVALID_PARAMETER, "path is NULL");
279 media_svc_retvm_if(!STRING_VALID(mime_type), MEDIA_INFO_ERROR_INVALID_PARAMETER, "mime_type is NULL");
281 if ((storage_type != MEDIA_SVC_STORAGE_INTERNAL) && (storage_type != MEDIA_SVC_STORAGE_EXTERNAL)) {
282 media_svc_error("storage type is incorrect[%d]", storage_type);
283 return MEDIA_INFO_ERROR_INVALID_PARAMETER;
286 if ((media_type < MEDIA_SVC_MEDIA_TYPE_IMAGE) || (media_type > MEDIA_SVC_MEDIA_TYPE_OTHER)) {
287 media_svc_error("invalid media_type condition[%d]", media_type);
288 return MEDIA_INFO_ERROR_INVALID_PARAMETER;
291 media_svc_debug("storage[%d], path[%s], media_type[%d]", storage_type, path, media_type);
293 media_svc_content_info_s content_info;
294 memset(&content_info, 0, sizeof(media_svc_content_info_s));
297 ret = _media_svc_set_media_info(&content_info, storage_type, path, mime_type, media_type, FALSE);
298 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
300 if(media_type == MEDIA_SVC_MEDIA_TYPE_OTHER) {
302 } else if(media_type == MEDIA_SVC_MEDIA_TYPE_IMAGE) {
303 ret = _media_svc_extract_image_metadata(&content_info, media_type);
304 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
306 ret = _media_svc_extract_media_metadata(handle, &content_info, media_type);
307 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
310 /*Set or Get folder id*/
311 ret = _media_svc_get_and_append_folder_id_by_path(handle, path, storage_type, folder_uuid);
312 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
314 ret = __media_svc_malloc_and_strncpy(&content_info.folder_uuid, folder_uuid);
315 media_svc_retv_del_if(ret != MEDIA_INFO_ERROR_NONE, ret, &content_info);
317 if (g_media_svc_insert_item_data_cnt == 1) {
319 ret = _media_svc_insert_item_with_data(db_handle, &content_info, is_burst, FALSE);
320 media_svc_retv_del_if(ret != MEDIA_INFO_ERROR_NONE, ret, &content_info);
322 if (g_insert_with_noti)
323 _media_svc_insert_item_to_noti_list(&content_info, g_media_svc_insert_item_cur_data_cnt++);
325 } else if(g_media_svc_insert_item_cur_data_cnt < (g_media_svc_insert_item_data_cnt - 1)) {
327 ret = _media_svc_insert_item_with_data(db_handle, &content_info, is_burst, TRUE);
328 media_svc_retv_del_if(ret != MEDIA_INFO_ERROR_NONE, ret, &content_info);
330 if (g_insert_with_noti)
331 _media_svc_insert_item_to_noti_list(&content_info, g_media_svc_insert_item_cur_data_cnt);
333 g_media_svc_insert_item_cur_data_cnt ++;
335 } else if (g_media_svc_insert_item_cur_data_cnt == (g_media_svc_insert_item_data_cnt - 1)) {
337 ret = _media_svc_insert_item_with_data(db_handle, &content_info, is_burst, TRUE);
338 media_svc_retv_del_if(ret != MEDIA_INFO_ERROR_NONE, ret, &content_info);
340 if (g_insert_with_noti)
341 _media_svc_insert_item_to_noti_list(&content_info, g_media_svc_insert_item_cur_data_cnt);
343 ret = _media_svc_list_query_do(db_handle, MEDIA_SVC_QUERY_INSERT_ITEM);
344 media_svc_retv_del_if(ret != MEDIA_INFO_ERROR_NONE, ret, &content_info);
346 if (g_insert_with_noti) {
347 _media_svc_publish_noti_list(g_media_svc_insert_item_cur_data_cnt + 1);
348 _media_svc_destroy_noti_list(g_media_svc_insert_item_cur_data_cnt + 1);
350 /* Recreate noti list */
351 if (_media_svc_create_noti_list(g_media_svc_insert_item_data_cnt) != MEDIA_INFO_ERROR_NONE) {
352 return MEDIA_INFO_ERROR_OUT_OF_MEMORY;
356 g_media_svc_insert_item_cur_data_cnt = 0;
359 media_svc_error("Error in media_svc_insert_item_bulk");
360 _media_svc_destroy_content_info(&content_info);
361 return MEDIA_INFO_ERROR_INTERNAL;
364 _media_svc_destroy_content_info(&content_info);
366 return MEDIA_INFO_ERROR_NONE;
369 int media_svc_insert_item_immediately(MediaSvcHandle *handle, media_svc_storage_type_e storage_type,
370 const char *path, const char *mime_type, media_svc_media_type_e media_type)
372 int ret = MEDIA_INFO_ERROR_NONE;
373 sqlite3 * db_handle = (sqlite3 *)handle;
374 char folder_uuid[MEDIA_SVC_UUID_SIZE+1] = {0,};
376 media_svc_retvm_if(db_handle == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "Handle is NULL");
377 media_svc_retvm_if(!STRING_VALID(path), MEDIA_INFO_ERROR_INVALID_PARAMETER, "path is NULL");
378 media_svc_retvm_if(!STRING_VALID(mime_type), MEDIA_INFO_ERROR_INVALID_PARAMETER, "mime_type is NULL");
380 if ((storage_type != MEDIA_SVC_STORAGE_INTERNAL) && (storage_type != MEDIA_SVC_STORAGE_EXTERNAL)) {
381 media_svc_error("storage type is incorrect[%d]", storage_type);
382 return MEDIA_INFO_ERROR_INVALID_PARAMETER;
385 if ((media_type < MEDIA_SVC_MEDIA_TYPE_IMAGE) || (media_type > MEDIA_SVC_MEDIA_TYPE_OTHER)) {
386 media_svc_error("invalid media_type condition[%d]", media_type);
387 return MEDIA_INFO_ERROR_INVALID_PARAMETER;
390 media_svc_debug("storage[%d], path[%s], media_type[%d]", storage_type, path, media_type);
392 media_svc_content_info_s content_info;
393 memset(&content_info, 0, sizeof(media_svc_content_info_s));
396 ret = _media_svc_set_media_info(&content_info, storage_type, path, mime_type, media_type, FALSE);
397 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
399 if(media_type == MEDIA_SVC_MEDIA_TYPE_OTHER) {
401 } else if(media_type == MEDIA_SVC_MEDIA_TYPE_IMAGE) {
402 ret = _media_svc_extract_image_metadata(&content_info, media_type);
403 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
405 ret = _media_svc_extract_media_metadata(handle, &content_info, media_type);
406 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
409 /*Set or Get folder id*/
410 ret = _media_svc_get_and_append_folder_id_by_path(handle, path, storage_type, folder_uuid);
411 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
413 ret = __media_svc_malloc_and_strncpy(&content_info.folder_uuid, folder_uuid);
414 media_svc_retv_del_if(ret != MEDIA_INFO_ERROR_NONE, ret, &content_info);
416 /* Extracting thumbnail */
417 if (media_type == MEDIA_SVC_MEDIA_TYPE_IMAGE || media_type == MEDIA_SVC_MEDIA_TYPE_VIDEO) {
418 char thumb_path[MEDIA_SVC_PATHNAME_SIZE + 1] = {0, };
422 ret = thumbnail_request_from_db_with_size(content_info.path, thumb_path, sizeof(thumb_path), &width, &height);
424 media_svc_error("thumbnail_request_from_db failed: %d", ret);
426 media_svc_debug("thumbnail_request_from_db success: %s", thumb_path);
427 ret = __media_svc_malloc_and_strncpy(&(content_info.thumbnail_path), thumb_path);
428 media_svc_retv_del_if(ret != MEDIA_INFO_ERROR_NONE, ret, &content_info);
431 if (content_info.media_meta.width <= 0)
432 content_info.media_meta.width = width;
434 if (content_info.media_meta.height <= 0)
435 content_info.media_meta.height = height;
438 ret = _media_svc_insert_item_with_data(db_handle, &content_info, FALSE, FALSE);
440 if (ret == MEDIA_INFO_ERROR_NONE) {
441 media_svc_debug("Insertion is successful. Sending noti for this");
442 _media_svc_publish_noti(MS_MEDIA_ITEM_FILE, MS_MEDIA_ITEM_INSERT, content_info.path, content_info.media_type, content_info.media_uuid, content_info.mime_type);
445 _media_svc_destroy_content_info(&content_info);
449 int media_svc_insert_folder(MediaSvcHandle *handle, media_svc_storage_type_e storage_type, const char *path)
451 int ret = MEDIA_INFO_ERROR_NONE;
452 sqlite3 * db_handle = (sqlite3 *)handle;
454 media_svc_retvm_if(db_handle == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "Handle is NULL");
455 media_svc_retvm_if(!STRING_VALID(path), MEDIA_INFO_ERROR_INVALID_PARAMETER, "path is NULL");
457 if ((storage_type != MEDIA_SVC_STORAGE_INTERNAL) && (storage_type != MEDIA_SVC_STORAGE_EXTERNAL)) {
458 media_svc_error("storage type is incorrect[%d]", storage_type);
459 return MEDIA_INFO_ERROR_INVALID_PARAMETER;
462 media_svc_debug("storage[%d], folder_path[%s]", storage_type, path);
465 char *folder_name = NULL;
466 int folder_modified_date = 0;
467 char *folder_uuid = _media_info_generate_uuid();
468 if(folder_uuid == NULL ) {
469 media_svc_error("Invalid UUID");
470 return MEDIA_INFO_ERROR_INTERNAL;
473 folder_name = g_path_get_basename(path);
474 folder_modified_date = _media_svc_get_file_time(path);
476 ret = _media_svc_append_folder(handle, storage_type, folder_uuid, path, folder_name, folder_modified_date);
477 SAFE_FREE(folder_name);
479 if (ret < MEDIA_INFO_ERROR_NONE) {
480 media_svc_error("_media_svc_append_folder error [%d]", ret);
484 return MEDIA_INFO_ERROR_NONE;
487 int media_svc_move_item_begin(MediaSvcHandle *handle, int data_cnt)
489 sqlite3 * db_handle = (sqlite3 *)handle;
491 media_svc_debug("Transaction data count : [%d]", data_cnt);
493 media_svc_retvm_if(db_handle == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "Handle is NULL");
494 media_svc_retvm_if(data_cnt < 1, MEDIA_INFO_ERROR_INVALID_PARAMETER, "data_cnt shuld be bigger than 1");
496 g_media_svc_move_item_data_cnt = data_cnt;
497 g_media_svc_move_item_cur_data_cnt = 0;
499 return MEDIA_INFO_ERROR_NONE;
502 int media_svc_move_item_end(MediaSvcHandle *handle)
504 int ret = MEDIA_INFO_ERROR_NONE;
505 sqlite3 * db_handle = (sqlite3 *)handle;
507 media_svc_debug_func();
509 media_svc_retvm_if(db_handle == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "Handle is NULL");
511 if (g_media_svc_move_item_cur_data_cnt > 0) {
513 ret = _media_svc_list_query_do(db_handle, MEDIA_SVC_QUERY_MOVE_ITEM);
516 /*clean up old folder path*/
517 ret = _media_svc_update_folder_table(handle);
518 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
520 g_media_svc_move_item_data_cnt = 1;
521 g_media_svc_move_item_cur_data_cnt = 0;
526 int media_svc_move_item(MediaSvcHandle *handle, media_svc_storage_type_e src_storage, const char *src_path,
527 media_svc_storage_type_e dest_storage, const char *dest_path)
529 int ret = MEDIA_INFO_ERROR_NONE;
530 sqlite3 * db_handle = (sqlite3 *)handle;
531 char *file_name = NULL;
532 char *folder_path = NULL;
533 int modified_time = 0;
534 char folder_uuid[MEDIA_SVC_UUID_SIZE+1] = {0,};
535 char old_thumb_path[MEDIA_SVC_PATHNAME_SIZE] = {0,};
536 char new_thumb_path[MEDIA_SVC_PATHNAME_SIZE] = {0,};
539 media_svc_debug_func();
541 media_svc_retvm_if(db_handle == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "Handle is NULL");
542 media_svc_retvm_if(!STRING_VALID(src_path), MEDIA_INFO_ERROR_INVALID_PARAMETER, "src_path is NULL");
543 media_svc_retvm_if(!STRING_VALID(dest_path), MEDIA_INFO_ERROR_INVALID_PARAMETER, "dest_path is NULL");
545 if ((src_storage != MEDIA_SVC_STORAGE_INTERNAL) && (src_storage != MEDIA_SVC_STORAGE_EXTERNAL)) {
546 media_svc_error("src_storage type is incorrect[%d]", src_storage);
547 return MEDIA_INFO_ERROR_INVALID_PARAMETER;
549 if ((dest_storage != MEDIA_SVC_STORAGE_INTERNAL) && (dest_storage != MEDIA_SVC_STORAGE_EXTERNAL)) {
550 media_svc_error("dest_storage type is incorrect[%d]", dest_storage);
551 return MEDIA_INFO_ERROR_INVALID_PARAMETER;
554 /*check and update folder*/
555 ret = _media_svc_get_and_append_folder_id_by_path(handle, dest_path, dest_storage, folder_uuid);
556 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
559 file_name = g_path_get_basename(dest_path);
561 /*get modified_time*/
562 modified_time = _media_svc_get_file_time(dest_path);
564 /*get thumbnail_path to update. only for Imgae and Video items. Audio share album_art(thumbnail)*/
565 ret = _media_svc_get_media_type_by_path(handle, src_path, &media_type);
566 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
568 if((media_type == MEDIA_SVC_MEDIA_TYPE_IMAGE) ||(media_type == MEDIA_SVC_MEDIA_TYPE_VIDEO)) {
569 /*get old thumbnail_path*/
570 ret = _media_svc_get_thumbnail_path_by_path(handle, src_path, old_thumb_path);
571 media_svc_retv_if((ret != MEDIA_INFO_ERROR_NONE) && (ret != MEDIA_INFO_ERROR_DATABASE_NO_RECORD), ret);
573 _media_svc_get_thumbnail_path(dest_storage, new_thumb_path, dest_path, THUMB_EXT);
576 if (g_media_svc_move_item_data_cnt == 1) {
579 if((media_type == MEDIA_SVC_MEDIA_TYPE_IMAGE) ||(media_type == MEDIA_SVC_MEDIA_TYPE_VIDEO)) {
580 ret = _media_svc_update_item_by_path(handle, src_path, dest_storage, dest_path, file_name, modified_time, folder_uuid, new_thumb_path, FALSE);
582 ret = _media_svc_update_item_by_path(handle, src_path, dest_storage, dest_path, file_name, modified_time, folder_uuid, NULL, FALSE);
584 SAFE_FREE(file_name);
585 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
587 media_svc_debug("Move is successful. Sending noti for this");
589 /* Get notification info */
590 media_svc_noti_item *noti_item = NULL;
591 ret = _media_svc_get_noti_info(handle, dest_path, MS_MEDIA_ITEM_FILE, ¬i_item);
592 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
594 /* Send notification for move */
595 _media_svc_publish_noti(MS_MEDIA_ITEM_FILE, MS_MEDIA_ITEM_UPDATE, src_path, media_type, noti_item->media_uuid, noti_item->mime_type);
596 _media_svc_destroy_noti_item(noti_item);
598 /*update folder modified_time*/
599 folder_path = g_path_get_dirname(dest_path);
600 ret = _media_svc_update_folder_modified_time_by_folder_uuid(handle, folder_uuid, folder_path, FALSE);
601 SAFE_FREE(folder_path);
602 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
604 ret = _media_svc_update_folder_table(handle);
605 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
607 } else if (g_media_svc_move_item_cur_data_cnt < (g_media_svc_move_item_data_cnt - 1)) {
610 if((media_type == MEDIA_SVC_MEDIA_TYPE_IMAGE) ||(media_type == MEDIA_SVC_MEDIA_TYPE_VIDEO)) {
611 ret = _media_svc_update_item_by_path(handle, src_path, dest_storage, dest_path, file_name, modified_time, folder_uuid, new_thumb_path, TRUE);
613 ret = _media_svc_update_item_by_path(handle, src_path, dest_storage, dest_path, file_name, modified_time, folder_uuid, NULL, TRUE);
615 SAFE_FREE(file_name);
616 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
618 /*update folder modified_time*/
619 folder_path = g_path_get_dirname(dest_path);
620 ret = _media_svc_update_folder_modified_time_by_folder_uuid(handle, folder_uuid, folder_path, TRUE);
621 SAFE_FREE(folder_path);
622 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
624 g_media_svc_move_item_cur_data_cnt ++;
626 } else if (g_media_svc_move_item_cur_data_cnt == (g_media_svc_move_item_data_cnt - 1)) {
629 if((media_type == MEDIA_SVC_MEDIA_TYPE_IMAGE) ||(media_type == MEDIA_SVC_MEDIA_TYPE_VIDEO)) {
630 ret = _media_svc_update_item_by_path(handle, src_path, dest_storage, dest_path, file_name, modified_time, folder_uuid, new_thumb_path, TRUE);
632 ret = _media_svc_update_item_by_path(handle, src_path, dest_storage, dest_path, file_name, modified_time, folder_uuid, NULL, TRUE);
634 SAFE_FREE(file_name);
635 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
637 /*update folder modified_time*/
638 folder_path = g_path_get_dirname(dest_path);
639 ret = _media_svc_update_folder_modified_time_by_folder_uuid(handle, folder_uuid, folder_path, TRUE);
640 SAFE_FREE(folder_path);
641 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
644 ret = _media_svc_list_query_do(db_handle, MEDIA_SVC_QUERY_MOVE_ITEM);
645 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
647 g_media_svc_move_item_cur_data_cnt = 0;
650 media_svc_error("Error in media_svc_move_item");
651 return MEDIA_INFO_ERROR_INTERNAL;
654 /*rename thumbnail file*/
655 if((media_type == MEDIA_SVC_MEDIA_TYPE_IMAGE) ||(media_type == MEDIA_SVC_MEDIA_TYPE_VIDEO)) {
656 if(strlen(old_thumb_path) > 0) {
657 ret = _media_svc_rename_file(old_thumb_path,new_thumb_path);
658 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
662 return MEDIA_INFO_ERROR_NONE;
665 int media_svc_set_item_validity_begin(MediaSvcHandle *handle, int data_cnt)
667 sqlite3 * db_handle = (sqlite3 *)handle;
669 media_svc_debug("Transaction data count : [%d]", data_cnt);
671 media_svc_retvm_if(db_handle == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "Handle is NULL");
672 media_svc_retvm_if(data_cnt < 1, MEDIA_INFO_ERROR_INVALID_PARAMETER, "data_cnt shuld be bigger than 1");
674 g_media_svc_item_validity_data_cnt = data_cnt;
675 g_media_svc_item_validity_cur_data_cnt = 0;
677 return MEDIA_INFO_ERROR_NONE;
680 int media_svc_set_item_validity_end(MediaSvcHandle *handle)
682 int ret = MEDIA_INFO_ERROR_NONE;
683 sqlite3 * db_handle = (sqlite3 *)handle;
685 media_svc_debug_func();
687 media_svc_retvm_if(db_handle == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "Handle is NULL");
689 if (g_media_svc_item_validity_cur_data_cnt > 0) {
691 ret = _media_svc_list_query_do(db_handle, MEDIA_SVC_QUERY_SET_ITEM_VALIDITY);
694 g_media_svc_item_validity_data_cnt = 1;
695 g_media_svc_item_validity_cur_data_cnt = 0;
700 int media_svc_set_item_validity(MediaSvcHandle *handle, const char *path, int validity)
702 int ret = MEDIA_INFO_ERROR_NONE;
703 sqlite3 * db_handle = (sqlite3 *)handle;
705 media_svc_retvm_if(db_handle == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "Handle is NULL");
706 media_svc_retvm_if(!STRING_VALID(path), MEDIA_INFO_ERROR_INVALID_PARAMETER, "path is NULL");
708 media_svc_debug("path=[%s], validity=[%d]", path, validity);
710 if (g_media_svc_item_validity_data_cnt == 1) {
712 return _media_svc_update_item_validity(db_handle, path, validity, FALSE);
714 } else if (g_media_svc_item_validity_cur_data_cnt < (g_media_svc_item_validity_data_cnt - 1)) {
716 ret = _media_svc_update_item_validity(db_handle, path, validity, TRUE);
717 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
719 g_media_svc_item_validity_cur_data_cnt ++;
721 } else if (g_media_svc_item_validity_cur_data_cnt == (g_media_svc_item_validity_data_cnt - 1)) {
723 ret = _media_svc_update_item_validity(db_handle, path, validity, TRUE);
724 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
726 ret = _media_svc_list_query_do(db_handle, MEDIA_SVC_QUERY_SET_ITEM_VALIDITY);
727 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
729 g_media_svc_item_validity_cur_data_cnt = 0;
733 media_svc_error("Error in media_svc_set_item_validity");
734 return MEDIA_INFO_ERROR_INTERNAL;
737 return MEDIA_INFO_ERROR_NONE;
740 int media_svc_delete_item_by_path(MediaSvcHandle *handle, const char *path)
742 int ret = MEDIA_INFO_ERROR_NONE;
743 sqlite3 * db_handle = (sqlite3 *)handle;
744 char thumb_path[MEDIA_SVC_PATHNAME_SIZE] = {0,};
746 media_svc_debug_func();
748 media_svc_retvm_if(db_handle == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "Handle is NULL");
749 media_svc_retvm_if(!STRING_VALID(path), MEDIA_INFO_ERROR_INVALID_PARAMETER, "path is NULL");
752 ret = _media_svc_get_media_type_by_path(db_handle, path, &media_type);
753 media_svc_retv_if((ret != MEDIA_INFO_ERROR_NONE), ret);
755 if((media_type == MEDIA_SVC_MEDIA_TYPE_IMAGE) ||(media_type == MEDIA_SVC_MEDIA_TYPE_VIDEO)) {
756 /*Get thumbnail path to delete*/
757 ret = _media_svc_get_thumbnail_path_by_path(db_handle, path, thumb_path);
758 media_svc_retv_if((ret != MEDIA_INFO_ERROR_NONE) && (ret != MEDIA_INFO_ERROR_DATABASE_NO_RECORD), ret);
759 } else if ((media_type == MEDIA_SVC_MEDIA_TYPE_SOUND) ||(media_type == MEDIA_SVC_MEDIA_TYPE_MUSIC)) {
761 ret = _media_svc_get_media_count_with_album_id_by_path(db_handle, path, &count);
762 media_svc_retv_if((ret != MEDIA_INFO_ERROR_NONE), ret);
765 /*Get thumbnail path to delete*/
766 ret = _media_svc_get_thumbnail_path_by_path(db_handle, path, thumb_path);
767 media_svc_retv_if((ret != MEDIA_INFO_ERROR_NONE) && (ret != MEDIA_INFO_ERROR_DATABASE_NO_RECORD), ret);
771 /* Get notification info */
772 media_svc_noti_item *noti_item = NULL;
773 ret = _media_svc_get_noti_info(handle, path, MS_MEDIA_ITEM_FILE, ¬i_item);
774 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
777 ret = _media_svc_delete_item_by_path(db_handle, path);
778 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
780 /* Send notification */
781 media_svc_debug("Deletion is successful. Sending noti for this");
782 _media_svc_publish_noti(MS_MEDIA_ITEM_FILE, MS_MEDIA_ITEM_DELETE, path, media_type, noti_item->media_uuid, noti_item->mime_type);
783 _media_svc_destroy_noti_item(noti_item);
786 if (strlen(thumb_path) > 0) {
787 if (_media_svc_remove_file(thumb_path) == FALSE) {
788 media_svc_error("fail to remove thumbnail file.");
792 return MEDIA_INFO_ERROR_NONE;
795 int media_svc_delete_all_items_in_storage(MediaSvcHandle *handle, media_svc_storage_type_e storage_type)
797 int ret = MEDIA_INFO_ERROR_NONE;
798 sqlite3 * db_handle = (sqlite3 *)handle;
799 char * dirpath = NULL;
801 media_svc_debug("media_svc_delete_all_items_in_storage [%d]", storage_type);
803 media_svc_retvm_if(db_handle == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "Handle is NULL");
805 if ((storage_type != MEDIA_SVC_STORAGE_INTERNAL) && (storage_type != MEDIA_SVC_STORAGE_EXTERNAL)) {
806 media_svc_error("storage type is incorrect[%d]", storage_type);
807 return MEDIA_INFO_ERROR_INVALID_PARAMETER;
810 ret = _media_svc_truncate_table(db_handle, storage_type);
811 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
813 dirpath = (storage_type == MEDIA_SVC_STORAGE_INTERNAL) ? MEDIA_SVC_THUMB_INTERNAL_PATH : MEDIA_SVC_THUMB_EXTERNAL_PATH;
815 /* remove thumbnails */
816 ret = _media_svc_remove_all_files_in_dir(dirpath);
817 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
819 return MEDIA_INFO_ERROR_NONE;
822 int media_svc_delete_invalid_items_in_storage(MediaSvcHandle *handle, media_svc_storage_type_e storage_type)
824 sqlite3 * db_handle = (sqlite3 *)handle;
826 media_svc_debug_func();
828 media_svc_retvm_if(db_handle == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "Handle is NULL");
830 if ((storage_type != MEDIA_SVC_STORAGE_INTERNAL) && (storage_type != MEDIA_SVC_STORAGE_EXTERNAL)) {
831 media_svc_error("storage type is incorrect[%d]", storage_type);
832 return MEDIA_INFO_ERROR_INVALID_PARAMETER;
835 /*Delete from DB and remove thumbnail files*/
836 return _media_svc_delete_invalid_items(db_handle, storage_type);
839 int media_svc_delete_invalid_items_in_folder(MediaSvcHandle *handle, const char *folder_path)
841 sqlite3 * db_handle = (sqlite3 *)handle;
843 media_svc_debug_func();
845 media_svc_retvm_if(db_handle == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "Handle is NULL");
847 /*Delete from DB and remove thumbnail files*/
848 return _media_svc_delete_invalid_folder_items(db_handle, folder_path);
851 int media_svc_set_all_storage_items_validity(MediaSvcHandle *handle, media_svc_storage_type_e storage_type, int validity)
853 sqlite3 * db_handle = (sqlite3 *)handle;
855 media_svc_retvm_if(db_handle == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "Handle is NULL");
857 if ((storage_type != MEDIA_SVC_STORAGE_INTERNAL) && (storage_type != MEDIA_SVC_STORAGE_EXTERNAL)) {
858 media_svc_error("storage type is incorrect[%d]", storage_type);
859 return MEDIA_INFO_ERROR_INVALID_PARAMETER;
862 return _media_svc_update_storage_item_validity(db_handle, storage_type, validity);
865 int media_svc_set_folder_items_validity(MediaSvcHandle *handle, const char *folder_path, int validity, int recursive)
867 sqlite3 * db_handle = (sqlite3 *)handle;
869 media_svc_retvm_if(db_handle == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "Handle is NULL");
870 media_svc_retvm_if(!STRING_VALID(folder_path), MEDIA_INFO_ERROR_INVALID_PARAMETER, "folder_path is NULL");
873 return _media_svc_update_recursive_folder_item_validity(db_handle, folder_path, validity);
875 return _media_svc_update_folder_item_validity(db_handle, folder_path, validity);
878 int media_svc_refresh_item(MediaSvcHandle *handle, media_svc_storage_type_e storage_type,
879 const char *path, media_svc_media_type_e media_type)
881 int ret = MEDIA_INFO_ERROR_NONE;
882 sqlite3 * db_handle = (sqlite3 *)handle;
884 media_svc_retvm_if(db_handle == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "Handle is NULL");
885 media_svc_retvm_if(!STRING_VALID(path), MEDIA_INFO_ERROR_INVALID_PARAMETER, "path is NULL");
887 if ((storage_type != MEDIA_SVC_STORAGE_INTERNAL) && (storage_type != MEDIA_SVC_STORAGE_EXTERNAL)) {
888 media_svc_error("storage type is incorrect[%d]", storage_type);
889 return MEDIA_INFO_ERROR_INVALID_PARAMETER;
892 if ((media_type < MEDIA_SVC_MEDIA_TYPE_IMAGE) || (media_type > MEDIA_SVC_MEDIA_TYPE_OTHER)) {
893 media_svc_error("invalid media_type condition[%d]", media_type);
894 return MEDIA_INFO_ERROR_INVALID_PARAMETER;
897 media_svc_debug("storage[%d], path[%s], media_type[%d]", storage_type, path, media_type);
899 /* Get notification info */
900 media_svc_noti_item *noti_item = NULL;
901 ret = _media_svc_get_noti_info(handle, path, MS_MEDIA_ITEM_FILE, ¬i_item);
902 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
904 media_svc_content_info_s content_info;
905 memset(&content_info, 0, sizeof(media_svc_content_info_s));
908 ret = _media_svc_set_media_info(&content_info, storage_type, path, NULL, media_type, TRUE);
909 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
911 /* Initialize thumbnail information to remake thumbnail. */
912 char thumb_path[MEDIA_SVC_PATHNAME_SIZE + 1];
913 ret = _media_svc_get_thumbnail_path_by_path(handle, path, thumb_path);
914 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
916 if (g_file_test(thumb_path, G_FILE_TEST_EXISTS)) {
917 ret = _media_svc_remove_file(thumb_path);
918 media_svc_retv_if(ret != TRUE, ret);
921 ret = _media_svc_update_thumbnail_path(handle, path, NULL);
922 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
924 if(media_type == MEDIA_SVC_MEDIA_TYPE_OTHER) {
926 } else if(media_type == MEDIA_SVC_MEDIA_TYPE_IMAGE) {
927 ret = _media_svc_extract_image_metadata(&content_info, media_type);
928 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
930 ret = _media_svc_extract_media_metadata(handle, &content_info, media_type);
931 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
934 /* Extracting thumbnail */
935 if (media_type == MEDIA_SVC_MEDIA_TYPE_IMAGE || media_type == MEDIA_SVC_MEDIA_TYPE_VIDEO) {
936 char thumb_path[MEDIA_SVC_PATHNAME_SIZE + 1] = {0, };
940 ret = thumbnail_request_from_db_with_size(content_info.path, thumb_path, sizeof(thumb_path), &width, &height);
942 media_svc_error("thumbnail_request_from_db failed: %d", ret);
944 media_svc_debug("thumbnail_request_from_db success: %s", thumb_path);
945 ret = __media_svc_malloc_and_strncpy(&(content_info.thumbnail_path), thumb_path);
946 media_svc_retv_del_if(ret != MEDIA_INFO_ERROR_NONE, ret, &content_info);
949 if (content_info.media_meta.width <= 0)
950 content_info.media_meta.width = width;
952 if (content_info.media_meta.height <= 0)
953 content_info.media_meta.height = height;
956 ret = _media_svc_update_item_with_data(db_handle, &content_info);
958 if (ret == MEDIA_INFO_ERROR_NONE) {
959 media_svc_debug("Update is successful. Sending noti for this");
960 _media_svc_publish_noti(MS_MEDIA_ITEM_FILE, MS_MEDIA_ITEM_UPDATE, content_info.path, media_type, noti_item->media_uuid, noti_item->mime_type);
961 _media_svc_destroy_noti_item(noti_item);
964 _media_svc_destroy_content_info(&content_info);
969 int media_svc_rename_folder(MediaSvcHandle *handle, const char *src_path, const char *dst_path)
971 sqlite3 * db_handle = (sqlite3 *)handle;
972 int ret = MEDIA_INFO_ERROR_NONE;
974 media_svc_retvm_if(db_handle == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "Handle is NULL");
975 media_svc_retvm_if(src_path == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "src_path is NULL");
976 media_svc_retvm_if(dst_path == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "dst_path is NULL");
978 media_svc_debug("Src path : %s, Dst Path : %s", src_path, dst_path);
980 /* Get notification info */
981 media_svc_noti_item *noti_item = NULL;
982 ret = _media_svc_get_noti_info(handle, src_path, MS_MEDIA_ITEM_DIRECTORY, ¬i_item);
983 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
985 ret = _media_svc_sql_begin_trans(handle);
986 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
988 /* Update all folder record's path, which are matched by old parent path */
989 char *update_folder_path_sql = NULL;
990 char src_path_slash[MEDIA_SVC_PATHNAME_SIZE + 1];
991 char dst_path_slash[MEDIA_SVC_PATHNAME_SIZE + 1];
993 snprintf(src_path_slash, sizeof(src_path_slash), "%s/", src_path);
994 snprintf(dst_path_slash, sizeof(dst_path_slash), "%s/", dst_path);
996 update_folder_path_sql = sqlite3_mprintf("UPDATE folder SET path = REPLACE( path, '%q', '%q');", src_path_slash, dst_path_slash);
998 //ret = _media_svc_sql_query(handle, update_folder_path_sql);
999 ret = media_db_request_update_db_batch(update_folder_path_sql);
1000 sqlite3_free(update_folder_path_sql);
1002 if (ret != SQLITE_OK) {
1003 media_svc_error("failed to update folder path");
1004 _media_svc_sql_rollback_trans(handle);
1006 return MEDIA_INFO_ERROR_DATABASE_INTERNAL;
1009 /* Update all folder record's modified date, which are changed above */
1010 char *update_folder_modified_time_sql = NULL;
1014 update_folder_modified_time_sql = sqlite3_mprintf("UPDATE folder SET modified_time = %d where path like '%q';", date, dst_path);
1016 ret = media_db_request_update_db_batch(update_folder_modified_time_sql);
1017 //ret = _media_svc_sql_query(handle, update_folder_modified_time_sql);
1018 sqlite3_free(update_folder_modified_time_sql);
1020 if (ret != SQLITE_OK) {
1021 media_svc_error("failed to update folder modified time");
1022 _media_svc_sql_rollback_trans(handle);
1024 return MEDIA_INFO_ERROR_DATABASE_INTERNAL;
1027 /* Update all items */
1028 char *select_all_sql = NULL;
1029 sqlite3_stmt *sql_stmt = NULL;
1030 char dst_child_path[MEDIA_SVC_PATHNAME_SIZE + 1];
1032 snprintf(dst_child_path, sizeof(dst_child_path), "%s/%%", dst_path);
1034 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);
1036 media_svc_debug("[SQL query] : %s", select_all_sql);
1038 ret = sqlite3_prepare_v2(handle, select_all_sql, -1, &sql_stmt, NULL);
1039 sqlite3_free((char *)select_all_sql);
1041 if (ret != SQLITE_OK) {
1042 media_svc_error ("prepare error [%s]", sqlite3_errmsg(handle));
1043 _media_svc_sql_rollback_trans(handle);
1044 return MEDIA_INFO_ERROR_DATABASE_INTERNAL;
1048 ret = sqlite3_step(sql_stmt);
1049 if (ret != SQLITE_ROW) {
1050 media_svc_debug("end of iteration");
1054 char media_uuid[MEDIA_SVC_UUID_SIZE + 1] = {0,};
1055 char media_path[MEDIA_SVC_PATHNAME_SIZE + 1] = {0,};
1056 char media_thumb_path[MEDIA_SVC_PATHNAME_SIZE + 1] = {0,};
1057 char media_new_thumb_path[MEDIA_SVC_PATHNAME_SIZE + 1] = {0,};
1059 bool no_thumb = FALSE;
1061 if (STRING_VALID((const char *)sqlite3_column_text(sql_stmt, 0))) {
1062 strncpy(media_uuid, (const char *)sqlite3_column_text(sql_stmt, 0), sizeof(media_uuid));
1063 media_uuid[sizeof(media_uuid) - 1] = '\0';
1065 media_svc_error("media UUID is NULL");
1066 return MEDIA_INFO_ERROR_DATABASE_INVALID;
1069 if (STRING_VALID((const char *)sqlite3_column_text(sql_stmt, 1))) {
1070 strncpy(media_path, (const char *)sqlite3_column_text(sql_stmt, 1), sizeof(media_path));
1071 media_path[sizeof(media_path) - 1] = '\0';
1073 media_svc_error("media path is NULL");
1074 return MEDIA_INFO_ERROR_DATABASE_INVALID;
1077 if (STRING_VALID((const char *)sqlite3_column_text(sql_stmt, 2))) {
1078 strncpy(media_thumb_path, (const char *)sqlite3_column_text(sql_stmt, 2), sizeof(media_thumb_path));
1079 media_thumb_path[sizeof(media_thumb_path) - 1] = '\0';
1081 media_svc_debug("media thumb path doesn't exist in DB");
1085 media_type = sqlite3_column_int(sql_stmt, 3);
1087 /* Update path, thumbnail path of this item */
1088 char *replaced_path = NULL;
1089 replaced_path = _media_svc_replace_path(media_path, src_path, dst_path);
1090 if (replaced_path == NULL) {
1091 media_svc_error("_media_svc_replace_path failed");
1092 SQLITE3_FINALIZE(sql_stmt);
1093 _media_svc_sql_rollback_trans(handle);
1094 return MEDIA_INFO_ERROR_INTERNAL;
1097 media_svc_debug("New media path : %s", replaced_path);
1098 media_svc_storage_type_e storage_type;
1101 ret = _media_svc_get_store_type_by_path(replaced_path, &storage_type);
1103 media_svc_error("_media_svc_get_store_type_by_path failed : %d", ret);
1104 SAFE_FREE(replaced_path);
1105 _media_svc_sql_rollback_trans(handle);
1106 return MEDIA_INFO_ERROR_DATABASE_INTERNAL;
1109 ret = _media_svc_get_thumbnail_path(storage_type, media_new_thumb_path, replaced_path, THUMB_EXT);
1111 media_svc_error("_media_svc_get_thumbnail_path failed : %d", ret);
1112 SAFE_FREE(replaced_path);
1113 SQLITE3_FINALIZE(sql_stmt);
1114 _media_svc_sql_rollback_trans(handle);
1115 return MEDIA_INFO_ERROR_INTERNAL;
1118 //media_svc_debug("New media thumbnail path : %s", media_new_thumb_path);
1121 char *update_item_sql = NULL;
1124 update_item_sql = sqlite3_mprintf("UPDATE media SET path='%q' WHERE media_uuid='%q'", replaced_path, media_uuid);
1126 if (media_type == MEDIA_SVC_MEDIA_TYPE_IMAGE || media_type == MEDIA_SVC_MEDIA_TYPE_VIDEO) {
1127 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);
1129 update_item_sql = sqlite3_mprintf("UPDATE media SET path='%q', thumbnail_path='%q' WHERE media_uuid='%q'", replaced_path, media_thumb_path, media_uuid);
1133 ret = media_db_request_update_db_batch(update_item_sql);
1134 //ret = _media_svc_sql_query(handle, update_item_sql);
1135 sqlite3_free(update_item_sql);
1136 SAFE_FREE(replaced_path);
1138 if (ret != SQLITE_OK) {
1139 media_svc_error("failed to update item");
1140 SQLITE3_FINALIZE(sql_stmt);
1141 _media_svc_sql_rollback_trans(handle);
1143 return MEDIA_INFO_ERROR_DATABASE_INTERNAL;
1146 /* Rename thumbnail file of file system */
1147 if ((!no_thumb) && (media_type == MEDIA_SVC_MEDIA_TYPE_IMAGE || media_type == MEDIA_SVC_MEDIA_TYPE_VIDEO)) {
1148 ret = _media_svc_rename_file(media_thumb_path, media_new_thumb_path);
1150 media_svc_error("_media_svc_rename_file failed : %d", ret);
1151 SQLITE3_FINALIZE(sql_stmt);
1152 _media_svc_sql_rollback_trans(handle);
1154 return MEDIA_INFO_ERROR_INTERNAL;
1159 SQLITE3_FINALIZE(sql_stmt);
1161 ret = _media_svc_sql_end_trans(handle);
1162 if (ret != MEDIA_INFO_ERROR_NONE) {
1163 media_svc_error("mb_svc_sqlite3_commit_trans failed.. Now start to rollback\n");
1164 _media_svc_sql_rollback_trans(handle);
1168 media_svc_debug("Folder update is successful. Sending noti for this");
1169 _media_svc_publish_noti(MS_MEDIA_ITEM_DIRECTORY, MS_MEDIA_ITEM_UPDATE, src_path, -1, noti_item->media_uuid, NULL);
1170 _media_svc_destroy_noti_item(noti_item);
1172 return MEDIA_INFO_ERROR_NONE;
1175 int media_svc_request_update_db(const char *db_query)
1177 int ret = MEDIA_INFO_ERROR_NONE;
1179 media_svc_retvm_if(!STRING_VALID(db_query), MEDIA_INFO_ERROR_INVALID_PARAMETER, "db_query is NULL");
1181 ret = _media_svc_request_update_db(db_query);
1183 return _media_svc_error_convert(ret);
1186 int media_svc_send_dir_update_noti(MediaSvcHandle *handle, const char *dir_path)
1188 int ret = MEDIA_INFO_ERROR_NONE;
1189 sqlite3 * db_handle = (sqlite3 *)handle;
1191 media_svc_retvm_if(!STRING_VALID(dir_path), MEDIA_INFO_ERROR_INVALID_PARAMETER, "dir_path is NULL");
1193 /* Get notification info */
1194 media_svc_noti_item *noti_item = NULL;
1195 ret = _media_svc_get_noti_info(db_handle, dir_path, MS_MEDIA_ITEM_DIRECTORY, ¬i_item);
1196 media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret);
1198 ret = _media_svc_publish_noti(MS_MEDIA_ITEM_DIRECTORY, MS_MEDIA_ITEM_UPDATE, dir_path, -1, noti_item->media_uuid, NULL);
1199 _media_svc_destroy_noti_item(noti_item);