X-Git-Url: http://review.tizen.org/git/?a=blobdiff_plain;f=src%2Fcommon%2Fmedia-svc.c;h=2a139e67f7c31bd2f7ccacabf1286d48821bcdbd;hb=f64c28a18827b4995b8cd73d98ea8b875205895f;hp=4dd92e8caa939b070559698e3da5300c42a3e565;hpb=7e8c5f57cea63e7f3b06a8f801993671a9e42590;p=platform%2Fcore%2Fmultimedia%2Flibmedia-service.git diff --git a/src/common/media-svc.c b/src/common/media-svc.c index 4dd92e8..c8837f0 100755 --- a/src/common/media-svc.c +++ b/src/common/media-svc.c @@ -3,8 +3,6 @@ * * Copyright (c) 2000 - 2011 Samsung Electronics Co., Ltd. All rights reserved. * - * Contact: Hyunjun Ko , Haejeong Kim - * * Licensed under the Apache License, Version 2.0 (the "License"); * you may not use this file except in compliance with the License. * You may obtain a copy of the License at @@ -19,1184 +17,713 @@ * */ -#include -#include -#include -#include "media-svc.h" #include "media-svc-media.h" #include "media-svc-debug.h" #include "media-svc-util.h" #include "media-svc-db-utils.h" +#include "media-svc-env.h" #include "media-svc-media-folder.h" #include "media-svc-album.h" #include "media-svc-noti.h" +#include "media-svc-storage.h" -static __thread int g_media_svc_item_validity_data_cnt = 1; -static __thread int g_media_svc_item_validity_cur_data_cnt = 0; +#include -static __thread int g_media_svc_move_item_data_cnt = 1; -static __thread int g_media_svc_move_item_cur_data_cnt = 0; +#define CONTENT_INI_DEFAULT_PATH SYSCONFDIR"/multimedia/media_content_config.ini" -static __thread int g_media_svc_insert_item_data_cnt = 1; -static __thread int g_media_svc_insert_item_cur_data_cnt = 0; +//static __thread int g_media_svc_data_cnt = 0; +static __thread int g_media_svc_cur_data_cnt = 0; /* Flag for items to be published by notification */ -static __thread int g_insert_with_noti = FALSE; - -int media_svc_connect(MediaSvcHandle **handle) -{ - int ret = MEDIA_INFO_ERROR_NONE; - MediaDBHandle *db_handle = NULL; - - media_svc_debug_func(); - -#if 1 //Use libmedia_utils API - ret = media_db_connect(&db_handle); - if(ret != MS_MEDIA_ERR_NONE) - return _media_svc_error_convert(ret); - -#else - sqlite3 * db_handle = NULL; +static __thread bool g_insert_with_noti = false; - ret = _media_svc_connect_db_with_handle(&db_handle); - media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret); -#endif +#define BATCH_ITEM_COUNT_MAX 100 - *handle = db_handle; - return MEDIA_INFO_ERROR_NONE; - -} - -int media_svc_disconnect(MediaSvcHandle *handle) +int media_svc_check_table_exist(sqlite3 *handle, bool *exist) { - MediaDBHandle * db_handle = (MediaDBHandle *)handle; - - media_svc_debug_func(); - - media_svc_retvm_if(db_handle == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "Handle is NULL"); - -#if 1 //Use libmedia_utils API - int ret = MEDIA_INFO_ERROR_NONE; - - ret = media_db_disconnect(db_handle); - return _media_svc_error_convert(ret); -#else - sqlite3 * db_handle = (sqlite3 *)handle; - - return _media_svc_disconnect_db_with_handle(db_handle); -#endif + return _media_svc_check_table_exist(handle, exist); } -int media_svc_create_table(MediaSvcHandle *handle) +int media_svc_create_table(uid_t uid) { - int ret = MEDIA_INFO_ERROR_NONE; - sqlite3 * db_handle = (sqlite3 *)handle; + int ret = MS_MEDIA_ERR_NONE; + media_svc_debug_fenter(); - media_svc_debug_func(); - - media_svc_retvm_if(db_handle == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "Handle is NULL"); + ret = _media_svc_init_table_query(); + if (ret != MS_MEDIA_ERR_NONE) { + media_svc_error("_media_svc_init_table_query fail."); + goto ERROR; + } /*create media table*/ - ret = _media_svc_create_media_table(handle); - media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret); + ret = _media_svc_make_table_query(DB_TABLE_MEDIA, DB_LIST_MEDIA, uid); + if (ret != MS_MEDIA_ERR_NONE) { + media_svc_error("_media_svc_make_table_query fail."); + goto ERROR; + } /*create folder table*/ - ret = _media_svc_create_folder_table(handle); - media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret); + ret = _media_svc_make_table_query(DB_TABLE_FOLDER, DB_LIST_FOLDER, uid); + if (ret != MS_MEDIA_ERR_NONE) { + media_svc_error("_media_svc_make_table_query fail."); + goto ERROR; + } + + /*create playlist_map table*/ + ret = _media_svc_make_table_query(DB_TABLE_PLAYLIST_MAP, DB_LIST_PLAYLIST_MAP, uid); + if (ret != MS_MEDIA_ERR_NONE) { + media_svc_error("_media_svc_make_table_query fail."); + goto ERROR; + } /*create playlist table*/ - ret = _media_svc_create_playlist_table(handle); - media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret); + ret = _media_svc_make_table_query(DB_TABLE_PLAYLIST, DB_LIST_PLAYLIST, uid); + if (ret != MS_MEDIA_ERR_NONE) { + media_svc_error("_media_svc_make_table_query fail."); + goto ERROR; + } /* create album table*/ - ret = _media_svc_create_album_table(handle); - media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret); + ret = _media_svc_make_table_query(DB_TABLE_ALBUM, DB_LIST_ALBUM, uid); + if (ret != MS_MEDIA_ERR_NONE) { + media_svc_error("_media_svc_make_table_query fail."); + goto ERROR; + } + + /*create tag_map table*/ + ret = _media_svc_make_table_query(DB_TABLE_TAG_MAP, DB_LIST_TAG_MAP, uid); + if (ret != MS_MEDIA_ERR_NONE) { + media_svc_error("_media_svc_make_table_query fail."); + goto ERROR; + } /*create tag table*/ - ret = _media_svc_create_tag_table(handle); - media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret); + ret = _media_svc_make_table_query(DB_TABLE_TAG, DB_LIST_TAG, uid); + if (ret != MS_MEDIA_ERR_NONE) { + media_svc_error("_media_svc_make_table_query fail."); + goto ERROR; + } /*create bookmark table*/ - ret = _media_svc_create_bookmark_table(handle); - media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret); - -#if 0 /*unify media and custom table*/ - /*create custom table*/ - ret = _media_svc_create_custom_table(handle); - media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret); -#endif - - return MEDIA_INFO_ERROR_NONE; -} - -int media_svc_get_storage_type(const char *path, media_svc_storage_type_e *storage_type) -{ - int ret = MEDIA_INFO_ERROR_NONE; - media_svc_storage_type_e type; - - ret = _media_svc_get_store_type_by_path(path, &type); - media_svc_retvm_if(ret < MEDIA_INFO_ERROR_NONE, ret, "_media_svc_get_store_type_by_path failed : %d", ret); - - *storage_type = type; - - return ret; -} - -int media_svc_get_mime_type(const char *path, char *mimetype) -{ - int ret = MEDIA_INFO_ERROR_NONE; - - if (path == NULL) - return MEDIA_INFO_ERROR_INVALID_PARAMETER; - - /* In case of drm file. */ - if (_media_svc_is_drm_file(path)) { - ret = _media_svc_get_mime_in_drm_info(path, mimetype); - if (ret != MEDIA_INFO_ERROR_NONE) { - media_svc_error("Fail to get mime in DRM"); - } else { - return ret; - } + ret = _media_svc_make_table_query(DB_TABLE_BOOKMARK, DB_LIST_BOOKMARK, uid); + if (ret != MS_MEDIA_ERR_NONE) { + media_svc_error("_media_svc_make_table_query fail."); + goto ERROR; } - /*in case of normal files or failure to get mime in drm */ - if (aul_get_mime_from_file(path, mimetype, 255) < 0) { - media_svc_error("aul_get_mime_from_file fail"); - return MEDIA_INFO_ERROR_INVALID_MEDIA; + /*create storage table from tizen 2.4 */ + ret = _media_svc_make_table_query(DB_TABLE_STORAGE, DB_LIST_STORAGE, uid); + if (ret != MS_MEDIA_ERR_NONE) { + media_svc_error("_media_svc_make_table_query fail."); + goto ERROR; } - return MEDIA_INFO_ERROR_NONE; -} - -int media_svc_get_media_type(const char *path, const char *mime_type, media_svc_media_type_e *media_type) -{ - int ret = MEDIA_INFO_ERROR_NONE; - int category = 0; - - media_svc_media_type_e type; - - ret = _media_svc_get_content_type_from_mime(path, mime_type, &category); - if (ret < 0) { - media_svc_error("_media_svc_get_content_type_from_mime failed : %d", ret); + /*create face table. from tizen 3.0*/ + ret = _media_svc_make_table_query(DB_TABLE_FACE_SCAN_LIST, DB_LIST_FACE_SCAN_LIST, uid); + if (ret != MS_MEDIA_ERR_NONE) { + media_svc_error("_media_svc_make_table_query fail."); + goto ERROR; } - if (category & MEDIA_SVC_CATEGORY_SOUND) type = MEDIA_SVC_MEDIA_TYPE_SOUND; - else if (category & MEDIA_SVC_CATEGORY_MUSIC) type = MEDIA_SVC_MEDIA_TYPE_MUSIC; - else if (category & MEDIA_SVC_CATEGORY_IMAGE) type = MEDIA_SVC_MEDIA_TYPE_IMAGE; - else if (category & MEDIA_SVC_CATEGORY_VIDEO) type = MEDIA_SVC_MEDIA_TYPE_VIDEO; - else type = MEDIA_SVC_MEDIA_TYPE_OTHER; + ret = _media_svc_make_table_query(DB_TABLE_FACE, DB_LIST_FACE, uid); + if (ret != MS_MEDIA_ERR_NONE) { + media_svc_error("_media_svc_make_table_query fail."); + goto ERROR; + } +ERROR: + _media_svc_destroy_table_query(); - *media_type = type; + media_svc_debug_fleave(); return ret; } -int media_svc_check_item_exist_by_path(MediaSvcHandle *handle, const char *path) +int media_svc_check_item_exist_by_path(sqlite3 *handle, const char *storage_id, const char *path) { - int ret = MEDIA_INFO_ERROR_NONE; - sqlite3 * db_handle = (sqlite3 *)handle; - int count = -1; - - media_svc_retvm_if(db_handle == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "Handle is NULL"); - media_svc_retvm_if(!STRING_VALID(path), MEDIA_INFO_ERROR_INVALID_PARAMETER, "Path is NULL"); - - ret = _media_svc_count_record_with_path(db_handle, path, &count); - media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret); - - if(count > 0) { - media_svc_debug("item is exist in database"); - return MEDIA_INFO_ERROR_NONE; - } else { - media_svc_debug("item is not exist in database"); - return MEDIA_INFO_ERROR_DATABASE_NO_RECORD; - } - - return MEDIA_INFO_ERROR_NONE; + return _media_svc_check_data_by_path(handle, path); } -int media_svc_insert_item_begin(MediaSvcHandle *handle, int data_cnt, int with_noti, int from_pid) +int media_svc_get_modified_time(sqlite3 *handle, const char *storage_id, const char *path, int *modified_time) { - sqlite3 * db_handle = (sqlite3 *)handle; - - media_svc_debug("Transaction data count : [%d]", data_cnt); - - media_svc_retvm_if(db_handle == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "Handle is NULL"); - media_svc_retvm_if(data_cnt < 1, MEDIA_INFO_ERROR_INVALID_PARAMETER, "data_cnt shuld be bigger than 1"); + return _media_svc_get_modified_time(handle, path, modified_time); +} - g_media_svc_insert_item_data_cnt = data_cnt; - g_media_svc_insert_item_cur_data_cnt = 0; +int media_svc_insert_item_begin(bool with_noti, int from_pid) +{ + g_media_svc_cur_data_cnt = 0; /* Prepare for making noti item list */ if (with_noti) { media_svc_debug("making noti list from pid[%d]", from_pid); - if (_media_svc_create_noti_list(data_cnt) != MEDIA_INFO_ERROR_NONE) { - return MEDIA_INFO_ERROR_OUT_OF_MEMORY; - } - + _media_svc_initialize_noti_list(); _media_svc_set_noti_from_pid(from_pid); - g_insert_with_noti = TRUE; + g_insert_with_noti = true; } - return MEDIA_INFO_ERROR_NONE; + return MS_MEDIA_ERR_NONE; } -int media_svc_insert_item_end(MediaSvcHandle *handle) +int media_svc_insert_item_end(uid_t uid) { - int ret = MEDIA_INFO_ERROR_NONE; - sqlite3 * db_handle = (sqlite3 *)handle; - - media_svc_debug_func(); + int ret = MS_MEDIA_ERR_NONE; - media_svc_retvm_if(db_handle == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "Handle is NULL"); + media_svc_debug_fenter(); - if (g_media_svc_insert_item_cur_data_cnt > 0) { - - ret = _media_svc_list_query_do(db_handle, MEDIA_SVC_QUERY_INSERT_ITEM); + if (g_media_svc_cur_data_cnt > 0) { + ret = _media_svc_list_query_do(MEDIA_SVC_QUERY_SCANNER, uid); if (g_insert_with_noti) { media_svc_debug("sending noti list"); - _media_svc_publish_noti_list(g_media_svc_insert_item_cur_data_cnt); - _media_svc_destroy_noti_list(g_media_svc_insert_item_cur_data_cnt); - g_insert_with_noti = FALSE; + _media_svc_publish_noti_list(); + g_insert_with_noti = false; _media_svc_set_noti_from_pid(-1); } } - g_media_svc_insert_item_data_cnt = 1; - g_media_svc_insert_item_cur_data_cnt = 0; + g_media_svc_cur_data_cnt = 0; return ret; } -int media_svc_insert_item_bulk(MediaSvcHandle *handle, media_svc_storage_type_e storage_type, - const char *path, const char *mime_type, media_svc_media_type_e media_type, int is_burst) +int media_svc_insert_item_bulk(sqlite3 *handle, const char *storage_id, const char *path, uid_t uid) { - int ret = MEDIA_INFO_ERROR_NONE; - sqlite3 * db_handle = (sqlite3 *)handle; - char folder_uuid[MEDIA_SVC_UUID_SIZE+1] = {0,}; + int ret = MS_MEDIA_ERR_NONE; + long long int folder_id = 0; - media_svc_retvm_if(db_handle == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "Handle is NULL"); - media_svc_retvm_if(!STRING_VALID(path), MEDIA_INFO_ERROR_INVALID_PARAMETER, "path is NULL"); - media_svc_retvm_if(!STRING_VALID(mime_type), MEDIA_INFO_ERROR_INVALID_PARAMETER, "mime_type is NULL"); - - if ((storage_type != MEDIA_SVC_STORAGE_INTERNAL) && (storage_type != MEDIA_SVC_STORAGE_EXTERNAL)) { - media_svc_error("storage type is incorrect[%d]", storage_type); - return MEDIA_INFO_ERROR_INVALID_PARAMETER; - } - - if ((media_type < MEDIA_SVC_MEDIA_TYPE_IMAGE) || (media_type > MEDIA_SVC_MEDIA_TYPE_OTHER)) { - media_svc_error("invalid media_type condition[%d]", media_type); - return MEDIA_INFO_ERROR_INVALID_PARAMETER; - } - - media_svc_debug("storage[%d], path[%s], media_type[%d]", storage_type, path, media_type); + media_svc_retvm_if(handle == NULL, MS_MEDIA_ERR_INVALID_PARAMETER, "Handle is NULL"); + media_svc_retvm_if(!STRING_VALID(storage_id), MS_MEDIA_ERR_INVALID_PARAMETER, "storage_id is NULL"); + media_svc_retvm_if(!STRING_VALID(path), MS_MEDIA_ERR_INVALID_PARAMETER, "path is NULL"); media_svc_content_info_s content_info; memset(&content_info, 0, sizeof(media_svc_content_info_s)); /*Set media info*/ - ret = _media_svc_set_media_info(&content_info, storage_type, path, mime_type, media_type, FALSE); - media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret); - - if(media_type == MEDIA_SVC_MEDIA_TYPE_OTHER) { - /*Do nothing.*/ - } else if(media_type == MEDIA_SVC_MEDIA_TYPE_IMAGE) { - ret = _media_svc_extract_image_metadata(&content_info, media_type); - media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret); - } else { - ret = _media_svc_extract_media_metadata(handle, &content_info, media_type); - media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret); - } - - /*Set or Get folder id*/ - ret = _media_svc_get_and_append_folder_id_by_path(handle, path, storage_type, folder_uuid); - media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret); - - ret = __media_svc_malloc_and_strncpy(&content_info.folder_uuid, folder_uuid); - media_svc_retv_del_if(ret != MEDIA_INFO_ERROR_NONE, ret, &content_info); - - if (g_media_svc_insert_item_data_cnt == 1) { - - ret = _media_svc_insert_item_with_data(db_handle, &content_info, is_burst, FALSE); - media_svc_retv_del_if(ret != MEDIA_INFO_ERROR_NONE, ret, &content_info); - - if (g_insert_with_noti) - _media_svc_insert_item_to_noti_list(&content_info, g_media_svc_insert_item_cur_data_cnt++); + ret = _media_svc_set_media_info(&content_info, storage_id, path, false); + if (ret != MS_MEDIA_ERR_NONE) + return ret; - } else if(g_media_svc_insert_item_cur_data_cnt < (g_media_svc_insert_item_data_cnt - 1)) { + switch (content_info.media_type) { + case MEDIA_SVC_MEDIA_TYPE_IMAGE: + ret = _media_svc_extract_image_metadata(&content_info); + break; + case MEDIA_SVC_MEDIA_TYPE_VIDEO: + ret = _media_svc_extract_video_metadata(&content_info); + break; + case MEDIA_SVC_MEDIA_TYPE_SOUND: + case MEDIA_SVC_MEDIA_TYPE_MUSIC: + _media_svc_extract_audio_metadata(handle, true, &content_info, uid); + break; + case MEDIA_SVC_MEDIA_TYPE_BOOK: + ret = _media_svc_extract_book_metadata(&content_info); + break; + default: + /* The 'TITLE' should always be filled in */ + content_info.media_meta.title = _media_svc_get_title_from_filename(content_info.file_name); + break; + } + + media_svc_retv_del_if(ret != MS_MEDIA_ERR_NONE, ret, &content_info); - ret = _media_svc_insert_item_with_data(db_handle, &content_info, is_burst, TRUE); - media_svc_retv_del_if(ret != MEDIA_INFO_ERROR_NONE, ret, &content_info); + /*Set or Get folder id*/ + ret = _media_svc_get_and_append_folder_id_by_path(handle, true, storage_id, path, &folder_id, uid); + media_svc_retv_del_if(ret != MS_MEDIA_ERR_NONE, ret, &content_info); - if (g_insert_with_noti) - _media_svc_insert_item_to_noti_list(&content_info, g_media_svc_insert_item_cur_data_cnt); + content_info.folder_id = folder_id; + media_svc_retv_del_if(content_info.folder_id <= 0, MS_MEDIA_ERR_INTERNAL, &content_info); - g_media_svc_insert_item_cur_data_cnt ++; + ret = _media_svc_insert_item_stack(&content_info); + media_svc_retv_del_if(ret != MS_MEDIA_ERR_NONE, ret, &content_info); - } else if (g_media_svc_insert_item_cur_data_cnt == (g_media_svc_insert_item_data_cnt - 1)) { + if (g_insert_with_noti) + _media_svc_insert_item_to_noti_list(&content_info); - ret = _media_svc_insert_item_with_data(db_handle, &content_info, is_burst, TRUE); - media_svc_retv_del_if(ret != MEDIA_INFO_ERROR_NONE, ret, &content_info); + /* To avoid over-occupying memory, update per BATCH_ITEM_COUNT_MAX. */ + if (++g_media_svc_cur_data_cnt == BATCH_ITEM_COUNT_MAX) { + ret = _media_svc_list_query_do(MEDIA_SVC_QUERY_SCANNER, uid); + media_svc_retv_del_if(ret != MS_MEDIA_ERR_NONE, ret, &content_info); if (g_insert_with_noti) - _media_svc_insert_item_to_noti_list(&content_info, g_media_svc_insert_item_cur_data_cnt); - - ret = _media_svc_list_query_do(db_handle, MEDIA_SVC_QUERY_INSERT_ITEM); - media_svc_retv_del_if(ret != MEDIA_INFO_ERROR_NONE, ret, &content_info); + _media_svc_publish_noti_list(); - if (g_insert_with_noti) { - _media_svc_publish_noti_list(g_media_svc_insert_item_cur_data_cnt + 1); - _media_svc_destroy_noti_list(g_media_svc_insert_item_cur_data_cnt + 1); - - /* Recreate noti list */ - if (_media_svc_create_noti_list(g_media_svc_insert_item_data_cnt) != MEDIA_INFO_ERROR_NONE) { - return MEDIA_INFO_ERROR_OUT_OF_MEMORY; - } - } - - g_media_svc_insert_item_cur_data_cnt = 0; - - } else { - media_svc_error("Error in media_svc_insert_item_bulk"); - _media_svc_destroy_content_info(&content_info); - return MEDIA_INFO_ERROR_INTERNAL; + g_media_svc_cur_data_cnt = 0; } _media_svc_destroy_content_info(&content_info); - return MEDIA_INFO_ERROR_NONE; + return MS_MEDIA_ERR_NONE; } -int media_svc_insert_item_immediately(MediaSvcHandle *handle, media_svc_storage_type_e storage_type, - const char *path, const char *mime_type, media_svc_media_type_e media_type) +int media_svc_insert_item_immediately(sqlite3 *handle, const char *storage_id, const char *path, uid_t uid) { - int ret = MEDIA_INFO_ERROR_NONE; - sqlite3 * db_handle = (sqlite3 *)handle; - char folder_uuid[MEDIA_SVC_UUID_SIZE+1] = {0,}; - - media_svc_retvm_if(db_handle == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "Handle is NULL"); - media_svc_retvm_if(!STRING_VALID(path), MEDIA_INFO_ERROR_INVALID_PARAMETER, "path is NULL"); - media_svc_retvm_if(!STRING_VALID(mime_type), MEDIA_INFO_ERROR_INVALID_PARAMETER, "mime_type is NULL"); + int ret = MS_MEDIA_ERR_NONE; + long long int folder_id = 0; - if ((storage_type != MEDIA_SVC_STORAGE_INTERNAL) && (storage_type != MEDIA_SVC_STORAGE_EXTERNAL)) { - media_svc_error("storage type is incorrect[%d]", storage_type); - return MEDIA_INFO_ERROR_INVALID_PARAMETER; - } - - if ((media_type < MEDIA_SVC_MEDIA_TYPE_IMAGE) || (media_type > MEDIA_SVC_MEDIA_TYPE_OTHER)) { - media_svc_error("invalid media_type condition[%d]", media_type); - return MEDIA_INFO_ERROR_INVALID_PARAMETER; - } - - media_svc_debug("storage[%d], path[%s], media_type[%d]", storage_type, path, media_type); + media_svc_retvm_if(handle == NULL, MS_MEDIA_ERR_INVALID_PARAMETER, "Handle is NULL"); + media_svc_retvm_if(!STRING_VALID(storage_id), MS_MEDIA_ERR_INVALID_PARAMETER, "storage_id is NULL"); + media_svc_retvm_if(!STRING_VALID(path), MS_MEDIA_ERR_INVALID_PARAMETER, "path is NULL"); media_svc_content_info_s content_info; memset(&content_info, 0, sizeof(media_svc_content_info_s)); /*Set media info*/ - ret = _media_svc_set_media_info(&content_info, storage_type, path, mime_type, media_type, FALSE); - media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret); - - if(media_type == MEDIA_SVC_MEDIA_TYPE_OTHER) { - /*Do nothing.*/ - } else if(media_type == MEDIA_SVC_MEDIA_TYPE_IMAGE) { - ret = _media_svc_extract_image_metadata(&content_info, media_type); - media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret); - } else { - ret = _media_svc_extract_media_metadata(handle, &content_info, media_type); - media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret); - } + ret = _media_svc_set_media_info(&content_info, storage_id, path, false); + if (ret != MS_MEDIA_ERR_NONE) + return ret; + + switch (content_info.media_type) { + case MEDIA_SVC_MEDIA_TYPE_IMAGE: + ret = _media_svc_extract_image_metadata(&content_info); + break; + case MEDIA_SVC_MEDIA_TYPE_VIDEO: + ret = _media_svc_extract_video_metadata(&content_info); + break; + case MEDIA_SVC_MEDIA_TYPE_SOUND: + case MEDIA_SVC_MEDIA_TYPE_MUSIC: + _media_svc_extract_audio_metadata(handle, false, &content_info, uid); + break; + case MEDIA_SVC_MEDIA_TYPE_BOOK: + ret = _media_svc_extract_book_metadata(&content_info); + break; + default: + /* The 'TITLE' should always be filled in */ + content_info.media_meta.title = _media_svc_get_title_from_filename(content_info.file_name); + break; + } + + media_svc_retv_del_if(ret != MS_MEDIA_ERR_NONE, ret, &content_info); /*Set or Get folder id*/ - ret = _media_svc_get_and_append_folder_id_by_path(handle, path, storage_type, folder_uuid); - media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret); + ret = _media_svc_get_and_append_folder_id_by_path(handle, false, storage_id, path, &folder_id, uid); + media_svc_retv_del_if(ret != MS_MEDIA_ERR_NONE, ret, &content_info); - ret = __media_svc_malloc_and_strncpy(&content_info.folder_uuid, folder_uuid); - media_svc_retv_del_if(ret != MEDIA_INFO_ERROR_NONE, ret, &content_info); -#if 1 - /* Extracting thumbnail */ - if (media_type == MEDIA_SVC_MEDIA_TYPE_IMAGE || media_type == MEDIA_SVC_MEDIA_TYPE_VIDEO) { - char thumb_path[MEDIA_SVC_PATHNAME_SIZE + 1] = {0, }; - int width = 0; - int height = 0; - - ret = thumbnail_request_from_db_with_size(content_info.path, thumb_path, sizeof(thumb_path), &width, &height); - if (ret < 0) { - media_svc_error("thumbnail_request_from_db failed: %d", ret); - } else { - media_svc_debug("thumbnail_request_from_db success: %s", thumb_path); - ret = __media_svc_malloc_and_strncpy(&(content_info.thumbnail_path), thumb_path); - media_svc_retv_del_if(ret != MEDIA_INFO_ERROR_NONE, ret, &content_info); - } + content_info.folder_id = folder_id; + media_svc_retv_del_if(content_info.folder_id <= 0, MS_MEDIA_ERR_INTERNAL, &content_info); - if (content_info.media_meta.width <= 0) - content_info.media_meta.width = width; + /* Extracting thumbnail */ + if (content_info.thumbnail_path == NULL) { + if (content_info.media_type == MEDIA_SVC_MEDIA_TYPE_IMAGE || content_info.media_type == MEDIA_SVC_MEDIA_TYPE_VIDEO) { + char thumb_path[MEDIA_SVC_PATHNAME_SIZE + 1] = {0, }; - if (content_info.media_meta.height <= 0) - content_info.media_meta.height = height; + ret = _media_svc_create_thumbnail(content_info.path, thumb_path, content_info.media_type, uid); + if (ret == MS_MEDIA_ERR_NONE) + content_info.thumbnail_path = g_strdup(thumb_path); + } } -#endif - ret = _media_svc_insert_item_with_data(db_handle, &content_info, FALSE, FALSE); - if (ret == MEDIA_INFO_ERROR_NONE) { + ret = _media_svc_insert_item(&content_info, uid); + if (ret == MS_MEDIA_ERR_NONE) { media_svc_debug("Insertion is successful. Sending noti for this"); - _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); + _media_svc_publish_noti(MS_MEDIA_ITEM_INSERT, content_info.path, content_info.media_type, content_info.media_uuid, content_info.mime_type); + } else if (ret == MS_MEDIA_ERR_DB_CONSTRAINT_FAIL) { + media_svc_error("This item is already inserted. This may be normal operation because other process already did this"); } _media_svc_destroy_content_info(&content_info); return ret; } -int media_svc_insert_folder(MediaSvcHandle *handle, media_svc_storage_type_e storage_type, const char *path) +int media_svc_move_item(sqlite3 *handle, + const char *src_path, + const char *dest_path, + const char *media_id, + int media_type, + const char *mime_type, + uid_t uid) { - int ret = MEDIA_INFO_ERROR_NONE; - sqlite3 * db_handle = (sqlite3 *)handle; + int ret = MS_MEDIA_ERR_NONE; + char *file_name = NULL; + char *folder_path = NULL; + int modified_time = 0; + long long int folder_id = 0; + char old_thumb_path[MEDIA_SVC_PATHNAME_SIZE] = {0, }; + char dst_stg_id[MEDIA_SVC_UUID_SIZE + 1] = {0, }; - media_svc_retvm_if(db_handle == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "Handle is NULL"); - media_svc_retvm_if(!STRING_VALID(path), MEDIA_INFO_ERROR_INVALID_PARAMETER, "path is NULL"); + media_svc_debug_fenter(); - if ((storage_type != MEDIA_SVC_STORAGE_INTERNAL) && (storage_type != MEDIA_SVC_STORAGE_EXTERNAL)) { - media_svc_error("storage type is incorrect[%d]", storage_type); - return MEDIA_INFO_ERROR_INVALID_PARAMETER; - } + media_svc_retvm_if(handle == NULL, MS_MEDIA_ERR_INVALID_PARAMETER, "Handle is NULL"); + media_svc_retvm_if(!STRING_VALID(src_path), MS_MEDIA_ERR_INVALID_PARAMETER, "src_path is NULL"); + media_svc_retvm_if(!STRING_VALID(dest_path), MS_MEDIA_ERR_INVALID_PARAMETER, "dest_path is NULL"); + media_svc_retvm_if(!STRING_VALID(media_id), MS_MEDIA_ERR_INVALID_PARAMETER, "media_id is NULL"); + media_svc_retvm_if(!STRING_VALID(mime_type), MS_MEDIA_ERR_INVALID_PARAMETER, "mime_type is NULL"); - media_svc_debug("storage[%d], folder_path[%s]", storage_type, path); + /* Get storage_id */ + ret = _media_svc_get_storage_uuid(handle, dest_path, dst_stg_id, uid); + media_svc_retv_if(ret != MS_MEDIA_ERR_NONE, ret); - /*Get folder info*/ - char *folder_name = NULL; - int folder_modified_date = 0; - char *folder_uuid = _media_info_generate_uuid(); - if(folder_uuid == NULL ) { - media_svc_error("Invalid UUID"); - return MEDIA_INFO_ERROR_INTERNAL; - } + /*check and update folder*/ + ret = _media_svc_get_and_append_folder_id_by_path(handle, false, dst_stg_id, dest_path, &folder_id, uid); + media_svc_retv_if(ret != MS_MEDIA_ERR_NONE, ret); - folder_name = g_path_get_basename(path); - folder_modified_date = _media_svc_get_file_time(path); + /*get filename*/ + file_name = g_path_get_basename(dest_path); - ret = _media_svc_append_folder(handle, storage_type, folder_uuid, path, folder_name, folder_modified_date); - SAFE_FREE(folder_name); + /*get modified_time*/ + modified_time = _media_svc_get_file_time(dest_path); - if (ret < MEDIA_INFO_ERROR_NONE) { - media_svc_error("_media_svc_append_folder error [%d]", ret); + /*get old thumbnail_path and remove thumbnail */ + ret = _media_svc_get_thumbnail_path_by_path(handle, src_path, old_thumb_path); + if ((ret != MS_MEDIA_ERR_NONE) && (ret != MS_MEDIA_ERR_DB_NO_RECORD)) { + media_svc_error("_media_svc_get_thumbnail_path_by_path failed"); + g_free(file_name); return ret; } - return MEDIA_INFO_ERROR_NONE; -} - -int media_svc_move_item_begin(MediaSvcHandle *handle, int data_cnt) -{ - sqlite3 * db_handle = (sqlite3 *)handle; + _media_svc_remove_file(old_thumb_path); - media_svc_debug("Transaction data count : [%d]", data_cnt); + /*move item*/ + ret = _media_svc_update_item_by_path(src_path, dst_stg_id, dest_path, file_name, modified_time, folder_id, uid); + g_free(file_name); + media_svc_retv_if(ret != MS_MEDIA_ERR_NONE, ret); - media_svc_retvm_if(db_handle == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "Handle is NULL"); - media_svc_retvm_if(data_cnt < 1, MEDIA_INFO_ERROR_INVALID_PARAMETER, "data_cnt shuld be bigger than 1"); + media_svc_debug("Move is successful. Sending noti for this"); + _media_svc_publish_noti(MS_MEDIA_ITEM_UPDATE, src_path, media_type, media_id, mime_type); - g_media_svc_move_item_data_cnt = data_cnt; - g_media_svc_move_item_cur_data_cnt = 0; + /*update folder modified_time*/ + folder_path = g_path_get_dirname(dest_path); + ret = _media_svc_update_folder_modified_time(folder_path, uid); + g_free(folder_path); + media_svc_retv_if(ret != MS_MEDIA_ERR_NONE, ret); - return MEDIA_INFO_ERROR_NONE; + return MS_MEDIA_ERR_NONE; } -int media_svc_move_item_end(MediaSvcHandle *handle) +int media_svc_set_item_validity(const char *path, int validity, uid_t uid) { - int ret = MEDIA_INFO_ERROR_NONE; - sqlite3 * db_handle = (sqlite3 *)handle; + int ret = MS_MEDIA_ERR_NONE; - media_svc_debug_func(); + ret = _media_svc_update_item_validity(path, validity, true, uid); + media_svc_retv_if(ret != MS_MEDIA_ERR_NONE, ret); - media_svc_retvm_if(db_handle == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "Handle is NULL"); + /* To avoid over-occupying memory, update per BATCH_ITEM_COUNT_MAX. */ + if (++g_media_svc_cur_data_cnt == BATCH_ITEM_COUNT_MAX) { + ret = _media_svc_list_query_do(MEDIA_SVC_QUERY_SCANNER, uid); + media_svc_retv_if(ret != MS_MEDIA_ERR_NONE, ret); - if (g_media_svc_move_item_cur_data_cnt > 0) { - - ret = _media_svc_list_query_do(db_handle, MEDIA_SVC_QUERY_MOVE_ITEM); + g_media_svc_cur_data_cnt = 0; } - /*clean up old folder path*/ - ret = _media_svc_update_folder_table(handle); - media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret); - - g_media_svc_move_item_data_cnt = 1; - g_media_svc_move_item_cur_data_cnt = 0; - return ret; } -int media_svc_move_item(MediaSvcHandle *handle, media_svc_storage_type_e src_storage, const char *src_path, - media_svc_storage_type_e dest_storage, const char *dest_path) +int media_svc_delete_item_by_path(sqlite3 *handle, const char *storage_id, const char *path, uid_t uid) { - int ret = MEDIA_INFO_ERROR_NONE; - sqlite3 * db_handle = (sqlite3 *)handle; - char *file_name = NULL; - char *folder_path = NULL; - int modified_time = 0; - char folder_uuid[MEDIA_SVC_UUID_SIZE+1] = {0,}; - char old_thumb_path[MEDIA_SVC_PATHNAME_SIZE] = {0,}; - char new_thumb_path[MEDIA_SVC_PATHNAME_SIZE] = {0,}; - int media_type = -1; - - media_svc_debug_func(); + int ret = MS_MEDIA_ERR_NONE; + char thumb_path[MEDIA_SVC_PATHNAME_SIZE] = {0, }; + media_svc_noti_item *noti_item = NULL; - media_svc_retvm_if(db_handle == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "Handle is NULL"); - media_svc_retvm_if(!STRING_VALID(src_path), MEDIA_INFO_ERROR_INVALID_PARAMETER, "src_path is NULL"); - media_svc_retvm_if(!STRING_VALID(dest_path), MEDIA_INFO_ERROR_INVALID_PARAMETER, "dest_path is NULL"); + media_svc_debug_fenter(); - if ((src_storage != MEDIA_SVC_STORAGE_INTERNAL) && (src_storage != MEDIA_SVC_STORAGE_EXTERNAL)) { - media_svc_error("src_storage type is incorrect[%d]", src_storage); - return MEDIA_INFO_ERROR_INVALID_PARAMETER; - } - if ((dest_storage != MEDIA_SVC_STORAGE_INTERNAL) && (dest_storage != MEDIA_SVC_STORAGE_EXTERNAL)) { - media_svc_error("dest_storage type is incorrect[%d]", dest_storage); - return MEDIA_INFO_ERROR_INVALID_PARAMETER; - } + /*Get thumbnail path to delete*/ + ret = _media_svc_get_thumbnail_path_by_path(handle, path, thumb_path); + media_svc_retv_if((ret != MS_MEDIA_ERR_NONE) && (ret != MS_MEDIA_ERR_DB_NO_RECORD), ret); - /*check and update folder*/ - ret = _media_svc_get_and_append_folder_id_by_path(handle, dest_path, dest_storage, folder_uuid); - media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret); + /* Get notification info */ + ret = _media_svc_get_noti_info(handle, path, ¬i_item); + media_svc_retv_if(ret != MS_MEDIA_ERR_NONE, ret); - /*get filename*/ - file_name = g_path_get_basename(dest_path); + /*Delete item*/ + ret = _media_svc_delete_item_by_path(path, uid); + if (ret != MS_MEDIA_ERR_NONE) { + media_svc_error("_media_svc_delete_item_by_path failed : %d", ret); + _media_svc_destroy_noti_item(noti_item); - /*get modified_time*/ - modified_time = _media_svc_get_file_time(dest_path); + return ret; + } - /*get thumbnail_path to update. only for Imgae and Video items. Audio share album_art(thumbnail)*/ - ret = _media_svc_get_media_type_by_path(handle, src_path, &media_type); - media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret); + /* Send notification */ + media_svc_debug("Deletion is successful. Sending noti for this"); + _media_svc_publish_noti(MS_MEDIA_ITEM_DELETE, path, noti_item->media_type, noti_item->media_uuid, noti_item->mime_type); + _media_svc_destroy_noti_item(noti_item); - if((media_type == MEDIA_SVC_MEDIA_TYPE_IMAGE) ||(media_type == MEDIA_SVC_MEDIA_TYPE_VIDEO)) { - /*get old thumbnail_path*/ - ret = _media_svc_get_thumbnail_path_by_path(handle, src_path, old_thumb_path); - media_svc_retv_if((ret != MEDIA_INFO_ERROR_NONE) && (ret != MEDIA_INFO_ERROR_DATABASE_NO_RECORD), ret); + /*Delete thumbnail*/ + _media_svc_remove_file(thumb_path); - _media_svc_get_thumbnail_path(dest_storage, new_thumb_path, dest_path, THUMB_EXT); - } + return MS_MEDIA_ERR_NONE; +} - if (g_media_svc_move_item_data_cnt == 1) { +int media_svc_refresh_item(sqlite3 *handle, bool is_direct, const char *storage_id, const char *path, uid_t uid) +{ + int ret = MS_MEDIA_ERR_NONE; + char thumb_path[MEDIA_SVC_PATHNAME_SIZE + 1] = {0, }; + media_svc_content_info_s content_info = {0, }; + media_svc_noti_item *noti_item = NULL; - /*update item*/ - if((media_type == MEDIA_SVC_MEDIA_TYPE_IMAGE) ||(media_type == MEDIA_SVC_MEDIA_TYPE_VIDEO)) { - ret = _media_svc_update_item_by_path(handle, src_path, dest_storage, dest_path, file_name, modified_time, folder_uuid, new_thumb_path, FALSE); - } else { - ret = _media_svc_update_item_by_path(handle, src_path, dest_storage, dest_path, file_name, modified_time, folder_uuid, NULL, FALSE); - } - SAFE_FREE(file_name); - media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret); + media_svc_retvm_if(handle == NULL, MS_MEDIA_ERR_INVALID_PARAMETER, "Handle is NULL"); + media_svc_retvm_if(!STRING_VALID(storage_id), MS_MEDIA_ERR_INVALID_PARAMETER, "storage_id is NULL"); + media_svc_retvm_if(!STRING_VALID(path), MS_MEDIA_ERR_INVALID_PARAMETER, "path is NULL"); - media_svc_debug("Move is successful. Sending noti for this"); + /*Set media info*/ + ret = _media_svc_set_media_info(&content_info, storage_id, path, true); + media_svc_retv_if(ret != MS_MEDIA_ERR_NONE, ret); - /* Get notification info */ - media_svc_noti_item *noti_item = NULL; - ret = _media_svc_get_noti_info(handle, dest_path, MS_MEDIA_ITEM_FILE, ¬i_item); - media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret); + /* Initialize thumbnail information to remake thumbnail. */ + ret = _media_svc_get_thumbnail_path_by_path(handle, path, thumb_path); + if (ret != MS_MEDIA_ERR_NONE && ret != MS_MEDIA_ERR_DB_NO_RECORD) + goto REFRESH_FINALIZE; - /* Send notification for move */ - _media_svc_publish_noti(MS_MEDIA_ITEM_FILE, MS_MEDIA_ITEM_UPDATE, src_path, media_type, noti_item->media_uuid, noti_item->mime_type); - _media_svc_destroy_noti_item(noti_item); + if (strlen(thumb_path) > 0) { + _media_svc_remove_file(thumb_path); - /*update folder modified_time*/ - folder_path = g_path_get_dirname(dest_path); - ret = _media_svc_update_folder_modified_time_by_folder_uuid(handle, folder_uuid, folder_path, FALSE); - SAFE_FREE(folder_path); - media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret); + ret = _media_svc_update_thumbnail_path(path, NULL, uid); + if (ret != MS_MEDIA_ERR_NONE) + goto REFRESH_FINALIZE; + } - ret = _media_svc_update_folder_table(handle); - media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret); + /* Get notification info */ + ret = _media_svc_get_noti_info(handle, path, ¬i_item); + if (ret != MS_MEDIA_ERR_NONE) + goto REFRESH_FINALIZE; + + content_info.media_type = noti_item->media_type; + content_info.mime_type = g_strdup(noti_item->mime_type); + + switch (content_info.media_type) { + case MEDIA_SVC_MEDIA_TYPE_IMAGE: + ret = _media_svc_extract_image_metadata(&content_info); + break; + case MEDIA_SVC_MEDIA_TYPE_VIDEO: + ret = _media_svc_extract_video_metadata(&content_info); + break; + case MEDIA_SVC_MEDIA_TYPE_SOUND: + case MEDIA_SVC_MEDIA_TYPE_MUSIC: + _media_svc_extract_audio_metadata(handle, is_direct, &content_info, uid); + break; + case MEDIA_SVC_MEDIA_TYPE_BOOK: + ret = _media_svc_extract_book_metadata(&content_info); + break; + default: + /* The 'TITLE' should always be filled in */ + content_info.media_meta.title = _media_svc_get_title_from_filename(content_info.file_name); + break; + } + + if (ret != MS_MEDIA_ERR_NONE) + goto REFRESH_FINALIZE; - } else if (g_media_svc_move_item_cur_data_cnt < (g_media_svc_move_item_data_cnt - 1)) { + /* Extracting thumbnail */ + if (content_info.thumbnail_path == NULL) { + if (content_info.media_type == MEDIA_SVC_MEDIA_TYPE_IMAGE || content_info.media_type == MEDIA_SVC_MEDIA_TYPE_VIDEO) { + memset(thumb_path, 0, sizeof(thumb_path)); - /*update item*/ - if((media_type == MEDIA_SVC_MEDIA_TYPE_IMAGE) ||(media_type == MEDIA_SVC_MEDIA_TYPE_VIDEO)) { - ret = _media_svc_update_item_by_path(handle, src_path, dest_storage, dest_path, file_name, modified_time, folder_uuid, new_thumb_path, TRUE); - } else { - ret = _media_svc_update_item_by_path(handle, src_path, dest_storage, dest_path, file_name, modified_time, folder_uuid, NULL, TRUE); + ret = _media_svc_create_thumbnail(content_info.path, thumb_path, content_info.media_type, uid); + if (ret == MS_MEDIA_ERR_NONE) + content_info.thumbnail_path = g_strdup(thumb_path); } - SAFE_FREE(file_name); - media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret); - - /*update folder modified_time*/ - folder_path = g_path_get_dirname(dest_path); - ret = _media_svc_update_folder_modified_time_by_folder_uuid(handle, folder_uuid, folder_path, TRUE); - SAFE_FREE(folder_path); - media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret); + } - g_media_svc_move_item_cur_data_cnt ++; + ret = _media_svc_update_item_with_data(is_direct, &content_info, uid); - } else if (g_media_svc_move_item_cur_data_cnt == (g_media_svc_move_item_data_cnt - 1)) { + if (ret == MS_MEDIA_ERR_NONE) { + if (is_direct) { + /* To avoid over-occupying memory, update per BATCH_ITEM_COUNT_MAX. */ + if (++g_media_svc_cur_data_cnt == BATCH_ITEM_COUNT_MAX) { + ret = _media_svc_list_query_do(MEDIA_SVC_QUERY_SCANNER, uid); + if (ret != MS_MEDIA_ERR_NONE) + goto REFRESH_FINALIZE; - /*update item*/ - if((media_type == MEDIA_SVC_MEDIA_TYPE_IMAGE) ||(media_type == MEDIA_SVC_MEDIA_TYPE_VIDEO)) { - ret = _media_svc_update_item_by_path(handle, src_path, dest_storage, dest_path, file_name, modified_time, folder_uuid, new_thumb_path, TRUE); + g_media_svc_cur_data_cnt = 0; + } } else { - ret = _media_svc_update_item_by_path(handle, src_path, dest_storage, dest_path, file_name, modified_time, folder_uuid, NULL, TRUE); + /* Except scanner case */ + media_svc_debug("Update is successful. Sending noti for this"); + _media_svc_publish_noti(MS_MEDIA_ITEM_UPDATE, content_info.path, noti_item->media_type, noti_item->media_uuid, noti_item->mime_type); } - SAFE_FREE(file_name); - media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret); - - /*update folder modified_time*/ - folder_path = g_path_get_dirname(dest_path); - ret = _media_svc_update_folder_modified_time_by_folder_uuid(handle, folder_uuid, folder_path, TRUE); - SAFE_FREE(folder_path); - media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret); - - /*update db*/ - ret = _media_svc_list_query_do(db_handle, MEDIA_SVC_QUERY_MOVE_ITEM); - media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret); - - g_media_svc_move_item_cur_data_cnt = 0; - } else { - media_svc_error("Error in media_svc_move_item"); - return MEDIA_INFO_ERROR_INTERNAL; + media_svc_error("_media_svc_update_item_with_data failed : %d", ret); } - /*rename thumbnail file*/ - if((media_type == MEDIA_SVC_MEDIA_TYPE_IMAGE) ||(media_type == MEDIA_SVC_MEDIA_TYPE_VIDEO)) { - if(strlen(old_thumb_path) > 0) { - ret = _media_svc_rename_file(old_thumb_path,new_thumb_path); - media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret); - } - } +REFRESH_FINALIZE: + _media_svc_destroy_content_info(&content_info); + _media_svc_destroy_noti_item(noti_item); - return MEDIA_INFO_ERROR_NONE; + return ret; } -int media_svc_set_item_validity_begin(MediaSvcHandle *handle, int data_cnt) +int media_svc_send_dir_update_noti(const char *dir_path, const char *folder_id, int update_type, int pid) { - sqlite3 * db_handle = (sqlite3 *)handle; - - media_svc_debug("Transaction data count : [%d]", data_cnt); - - media_svc_retvm_if(db_handle == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "Handle is NULL"); - media_svc_retvm_if(data_cnt < 1, MEDIA_INFO_ERROR_INVALID_PARAMETER, "data_cnt shuld be bigger than 1"); + media_svc_retvm_if(!STRING_VALID(dir_path), MS_MEDIA_ERR_INVALID_PARAMETER, "dir_path is NULL"); - g_media_svc_item_validity_data_cnt = data_cnt; - g_media_svc_item_validity_cur_data_cnt = 0; - - return MEDIA_INFO_ERROR_NONE; + return _media_svc_publish_dir_noti((media_item_update_type_e)update_type, dir_path, folder_id, pid); } -int media_svc_set_item_validity_end(MediaSvcHandle *handle) +int media_svc_publish_update_noti(const char *path, int media_type, const char *uuid, const char *mime_type) { - int ret = MEDIA_INFO_ERROR_NONE; - sqlite3 * db_handle = (sqlite3 *)handle; - - media_svc_debug_func(); - - media_svc_retvm_if(db_handle == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "Handle is NULL"); - - if (g_media_svc_item_validity_cur_data_cnt > 0) { - - ret = _media_svc_list_query_do(db_handle, MEDIA_SVC_QUERY_SET_ITEM_VALIDITY); - } - - g_media_svc_item_validity_data_cnt = 1; - g_media_svc_item_validity_cur_data_cnt = 0; - - return ret; + return _media_svc_publish_noti(MS_MEDIA_ITEM_UPDATE, path, media_type, uuid, mime_type); } -int media_svc_set_item_validity(MediaSvcHandle *handle, const char *path, int validity) +int media_svc_set_storage_validity(const char *storage_id, int validity, uid_t uid) { - int ret = MEDIA_INFO_ERROR_NONE; - sqlite3 * db_handle = (sqlite3 *)handle; - - media_svc_retvm_if(db_handle == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "Handle is NULL"); - media_svc_retvm_if(!STRING_VALID(path), MEDIA_INFO_ERROR_INVALID_PARAMETER, "path is NULL"); - - media_svc_debug("path=[%s], validity=[%d]", path, validity); - - if (g_media_svc_item_validity_data_cnt == 1) { - - return _media_svc_update_item_validity(db_handle, path, validity, FALSE); - - } else if (g_media_svc_item_validity_cur_data_cnt < (g_media_svc_item_validity_data_cnt - 1)) { - - ret = _media_svc_update_item_validity(db_handle, path, validity, TRUE); - media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret); - - g_media_svc_item_validity_cur_data_cnt ++; - - } else if (g_media_svc_item_validity_cur_data_cnt == (g_media_svc_item_validity_data_cnt - 1)) { - - ret = _media_svc_update_item_validity(db_handle, path, validity, TRUE); - media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret); - - ret = _media_svc_list_query_do(db_handle, MEDIA_SVC_QUERY_SET_ITEM_VALIDITY); - media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret); - - g_media_svc_item_validity_cur_data_cnt = 0; - - } else { - - media_svc_error("Error in media_svc_set_item_validity"); - return MEDIA_INFO_ERROR_INTERNAL; - } - - return MEDIA_INFO_ERROR_NONE; + return _media_svc_update_storage_validity(storage_id, validity, uid); } -int media_svc_delete_item_by_path(MediaSvcHandle *handle, const char *path) +int media_svc_get_storage_id(sqlite3 *handle, const char *path, char *storage_id, uid_t uid) { - int ret = MEDIA_INFO_ERROR_NONE; - sqlite3 * db_handle = (sqlite3 *)handle; - char thumb_path[MEDIA_SVC_PATHNAME_SIZE] = {0,}; - - media_svc_debug_func(); - - media_svc_retvm_if(db_handle == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "Handle is NULL"); - media_svc_retvm_if(!STRING_VALID(path), MEDIA_INFO_ERROR_INVALID_PARAMETER, "path is NULL"); - - int media_type = -1; - ret = _media_svc_get_media_type_by_path(db_handle, path, &media_type); - media_svc_retv_if((ret != MEDIA_INFO_ERROR_NONE), ret); - - if((media_type == MEDIA_SVC_MEDIA_TYPE_IMAGE) ||(media_type == MEDIA_SVC_MEDIA_TYPE_VIDEO)) { - /*Get thumbnail path to delete*/ - ret = _media_svc_get_thumbnail_path_by_path(db_handle, path, thumb_path); - media_svc_retv_if((ret != MEDIA_INFO_ERROR_NONE) && (ret != MEDIA_INFO_ERROR_DATABASE_NO_RECORD), ret); - } else if ((media_type == MEDIA_SVC_MEDIA_TYPE_SOUND) ||(media_type == MEDIA_SVC_MEDIA_TYPE_MUSIC)) { - int count = 0; - ret = _media_svc_get_media_count_with_album_id_by_path(db_handle, path, &count); - media_svc_retv_if((ret != MEDIA_INFO_ERROR_NONE), ret); - - if (count == 1) { - /*Get thumbnail path to delete*/ - ret = _media_svc_get_thumbnail_path_by_path(db_handle, path, thumb_path); - media_svc_retv_if((ret != MEDIA_INFO_ERROR_NONE) && (ret != MEDIA_INFO_ERROR_DATABASE_NO_RECORD), ret); - } - } - - /* Get notification info */ - media_svc_noti_item *noti_item = NULL; - ret = _media_svc_get_noti_info(handle, path, MS_MEDIA_ITEM_FILE, ¬i_item); - media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret); - - /*Delete item*/ - ret = _media_svc_delete_item_by_path(db_handle, path); - media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret); - - /* Send notification */ - media_svc_debug("Deletion is successful. Sending noti for this"); - _media_svc_publish_noti(MS_MEDIA_ITEM_FILE, MS_MEDIA_ITEM_DELETE, path, media_type, noti_item->media_uuid, noti_item->mime_type); - _media_svc_destroy_noti_item(noti_item); - - /*Delete thumbnail*/ - if (strlen(thumb_path) > 0) { - if (_media_svc_remove_file(thumb_path) == FALSE) { - media_svc_error("fail to remove thumbnail file."); - } - } - - return MEDIA_INFO_ERROR_NONE; + return _media_svc_get_storage_uuid(handle, path, storage_id, uid); } -int media_svc_delete_all_items_in_storage(MediaSvcHandle *handle, media_svc_storage_type_e storage_type) +int media_svc_check_storage(sqlite3 *handle, const char *storage_id, char **storage_path, int *validity) { - int ret = MEDIA_INFO_ERROR_NONE; - sqlite3 * db_handle = (sqlite3 *)handle; - char * dirpath = NULL; - - media_svc_debug("media_svc_delete_all_items_in_storage [%d]", storage_type); - - media_svc_retvm_if(db_handle == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "Handle is NULL"); - - if ((storage_type != MEDIA_SVC_STORAGE_INTERNAL) && (storage_type != MEDIA_SVC_STORAGE_EXTERNAL)) { - media_svc_error("storage type is incorrect[%d]", storage_type); - return MEDIA_INFO_ERROR_INVALID_PARAMETER; - } - - ret = _media_svc_truncate_table(db_handle, storage_type); - media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret); - - dirpath = (storage_type == MEDIA_SVC_STORAGE_INTERNAL) ? MEDIA_SVC_THUMB_INTERNAL_PATH : MEDIA_SVC_THUMB_EXTERNAL_PATH; - - /* remove thumbnails */ - ret = _media_svc_remove_all_files_in_dir(dirpath); - media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret); + return _media_svc_check_storage(handle, storage_id, storage_path, validity); +} - return MEDIA_INFO_ERROR_NONE; +int media_svc_update_storage(sqlite3 *handle, const char *storage_id, const char *storage_path, uid_t uid) +{ + return _media_svc_update_storage_path(handle, storage_id, storage_path, uid); } -int media_svc_delete_invalid_items_in_storage(MediaSvcHandle *handle, media_svc_storage_type_e storage_type) +int media_svc_insert_storage(sqlite3 *handle, const char *storage_id, const char *storage_path, uid_t uid) { - sqlite3 * db_handle = (sqlite3 *)handle; + int ret = MS_MEDIA_ERR_NONE; - media_svc_debug_func(); + media_svc_retvm_if(handle == NULL, MS_MEDIA_ERR_INVALID_PARAMETER, "Handle is NULL"); + media_svc_retvm_if(storage_id == NULL, MS_MEDIA_ERR_INVALID_PARAMETER, "storage_id is NULL"); + media_svc_retvm_if(storage_path == NULL, MS_MEDIA_ERR_INVALID_PARAMETER, "storage_path is NULL"); - media_svc_retvm_if(db_handle == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "Handle is NULL"); + ret = _media_svc_append_storage(storage_id, storage_path, uid); + media_svc_retvm_if(ret != MS_MEDIA_ERR_NONE, ret, "append storage failed : %d", ret); - if ((storage_type != MEDIA_SVC_STORAGE_INTERNAL) && (storage_type != MEDIA_SVC_STORAGE_EXTERNAL)) { - media_svc_error("storage type is incorrect[%d]", storage_type); - return MEDIA_INFO_ERROR_INVALID_PARAMETER; - } + /* Remove external storage that validity is 0 */ + ret = _media_svc_delete_invalid_storage(handle, uid); + media_svc_retvm_if(ret != MS_MEDIA_ERR_NONE, ret, "Delete invalid storage failed : %d", ret); - /*Delete from DB and remove thumbnail files*/ - return _media_svc_delete_invalid_items(db_handle, storage_type); + return ret; } -int media_svc_delete_invalid_items_in_folder(MediaSvcHandle *handle, const char *folder_path) +int media_svc_insert_folder(sqlite3 *handle, const char *storage_id, const char *path, uid_t uid) { - sqlite3 * db_handle = (sqlite3 *)handle; - - media_svc_debug_func(); - - media_svc_retvm_if(db_handle == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "Handle is NULL"); + media_svc_retvm_if(handle == NULL, MS_MEDIA_ERR_INVALID_PARAMETER, "Handle is NULL"); + media_svc_retvm_if(!STRING_VALID(storage_id), MS_MEDIA_ERR_INVALID_PARAMETER, "storage_id is NULL"); + media_svc_retvm_if(!STRING_VALID(path), MS_MEDIA_ERR_INVALID_PARAMETER, "path is NULL"); - /*Delete from DB and remove thumbnail files*/ - return _media_svc_delete_invalid_folder_items(db_handle, folder_path); + return _media_svc_append_by_folder_path(handle, storage_id, path, uid); } -int media_svc_set_all_storage_items_validity(MediaSvcHandle *handle, media_svc_storage_type_e storage_type, int validity) +int media_svc_set_folder_validity(const char *start_path, int validity, bool is_recursive, uid_t uid) { - sqlite3 * db_handle = (sqlite3 *)handle; - - media_svc_retvm_if(db_handle == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "Handle is NULL"); - - if ((storage_type != MEDIA_SVC_STORAGE_INTERNAL) && (storage_type != MEDIA_SVC_STORAGE_EXTERNAL)) { - media_svc_error("storage type is incorrect[%d]", storage_type); - return MEDIA_INFO_ERROR_INVALID_PARAMETER; - } - - return _media_svc_update_storage_item_validity(db_handle, storage_type, validity); + return _media_svc_set_folder_validity(true, start_path, validity, is_recursive, uid); } -int media_svc_set_folder_items_validity(MediaSvcHandle *handle, const char *folder_path, int validity, int recursive) +int media_svc_check_folder_exist_by_path(sqlite3 *handle, const char *folder_path) { - sqlite3 * db_handle = (sqlite3 *)handle; - - media_svc_retvm_if(db_handle == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "Handle is NULL"); - media_svc_retvm_if(!STRING_VALID(folder_path), MEDIA_INFO_ERROR_INVALID_PARAMETER, "folder_path is NULL"); - - if(recursive) - return _media_svc_update_recursive_folder_item_validity(db_handle, folder_path, validity); - else - return _media_svc_update_folder_item_validity(db_handle, folder_path, validity); + return _media_svc_check_folder_by_path(handle, folder_path); } -int media_svc_refresh_item(MediaSvcHandle *handle, media_svc_storage_type_e storage_type, - const char *path, media_svc_media_type_e media_type) +int media_svc_append_query(const char *query, uid_t uid) { - int ret = MEDIA_INFO_ERROR_NONE; - sqlite3 * db_handle = (sqlite3 *)handle; - - media_svc_retvm_if(db_handle == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "Handle is NULL"); - media_svc_retvm_if(!STRING_VALID(path), MEDIA_INFO_ERROR_INVALID_PARAMETER, "path is NULL"); - - if ((storage_type != MEDIA_SVC_STORAGE_INTERNAL) && (storage_type != MEDIA_SVC_STORAGE_EXTERNAL)) { - media_svc_error("storage type is incorrect[%d]", storage_type); - return MEDIA_INFO_ERROR_INVALID_PARAMETER; - } - - if ((media_type < MEDIA_SVC_MEDIA_TYPE_IMAGE) || (media_type > MEDIA_SVC_MEDIA_TYPE_OTHER)) { - media_svc_error("invalid media_type condition[%d]", media_type); - return MEDIA_INFO_ERROR_INVALID_PARAMETER; - } - - media_svc_debug("storage[%d], path[%s], media_type[%d]", storage_type, path, media_type); - - /* Get notification info */ - media_svc_noti_item *noti_item = NULL; - ret = _media_svc_get_noti_info(handle, path, MS_MEDIA_ITEM_FILE, ¬i_item); - media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret); - - media_svc_content_info_s content_info; - memset(&content_info, 0, sizeof(media_svc_content_info_s)); + return _media_svc_append_query_list(query, uid); +} - /*Set media info*/ - ret = _media_svc_set_media_info(&content_info, storage_type, path, NULL, media_type, TRUE); - media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret); +int media_svc_send_query(uid_t uid) +{ + return _media_svc_list_query_do(MEDIA_SVC_QUERY_UPDATE_COMMON, uid); +} - /* Initialize thumbnail information to remake thumbnail. */ - char thumb_path[MEDIA_SVC_PATHNAME_SIZE + 1]; - ret = _media_svc_get_thumbnail_path_by_path(handle, path, thumb_path); - media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret); +int media_svc_get_media_type(const char *path, int *mediatype) +{ + return _media_svc_get_media_type(path, mediatype); +} - if (g_file_test(thumb_path, G_FILE_TEST_EXISTS)) { - ret = _media_svc_remove_file(thumb_path); - media_svc_retv_if(ret != TRUE, ret); +int media_svc_create_thumbnail(const char *file_path, int media_type, uid_t uid, char **thumbnail_path) +{ + int ret = MS_MEDIA_ERR_NONE; + char thumb_path[MEDIA_SVC_PATHNAME_SIZE + 1] = { 0, }; + char *sql = NULL; + + // 1. Check media type + if (media_type != MEDIA_SVC_MEDIA_TYPE_IMAGE && media_type != MEDIA_SVC_MEDIA_TYPE_VIDEO) + return MS_MEDIA_ERR_THUMB_UNSUPPORTED; + + // 2. try to create thumbnail + ret = _media_svc_create_thumbnail(file_path, thumb_path, media_type, uid); + if (ret != MS_MEDIA_ERR_NONE) { + media_svc_error("Failed to create thumbnail [%d]", ret); + if (ret == MS_MEDIA_ERR_THUMB_UNSUPPORTED) + return ret; } - ret = _media_svc_update_thumbnail_path(handle, path, NULL); - media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret); + // 3. Update creation result to media db + sql = sqlite3_mprintf("UPDATE %q SET media_thumbnail_path='%q' WHERE media_path='%q';", DB_TABLE_MEDIA, thumb_path, file_path); - if(media_type == MEDIA_SVC_MEDIA_TYPE_OTHER) { - /*Do nothing.*/ - } else if(media_type == MEDIA_SVC_MEDIA_TYPE_IMAGE) { - ret = _media_svc_extract_image_metadata(&content_info, media_type); - media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret); + ret = _media_svc_sql_query(sql, uid); + SQLITE3_SAFE_FREE(sql); + if (ret != MS_MEDIA_ERR_NONE) { + media_svc_error("Failed to update media db [%d]", ret); + *thumbnail_path = g_strdup(""); } else { - ret = _media_svc_extract_media_metadata(handle, &content_info, media_type); - media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret); + *thumbnail_path = g_strdup(thumb_path); } -#if 1 - /* Extracting thumbnail */ - if (media_type == MEDIA_SVC_MEDIA_TYPE_IMAGE || media_type == MEDIA_SVC_MEDIA_TYPE_VIDEO) { - char thumb_path[MEDIA_SVC_PATHNAME_SIZE + 1] = {0, }; - int width = 0; - int height = 0; - - ret = thumbnail_request_from_db_with_size(content_info.path, thumb_path, sizeof(thumb_path), &width, &height); - if (ret < 0) { - media_svc_error("thumbnail_request_from_db failed: %d", ret); - } else { - media_svc_debug("thumbnail_request_from_db success: %s", thumb_path); - ret = __media_svc_malloc_and_strncpy(&(content_info.thumbnail_path), thumb_path); - media_svc_retv_del_if(ret != MEDIA_INFO_ERROR_NONE, ret, &content_info); - } - - if (content_info.media_meta.width <= 0) - content_info.media_meta.width = width; - - if (content_info.media_meta.height <= 0) - content_info.media_meta.height = height; - } -#endif - ret = _media_svc_update_item_with_data(db_handle, &content_info); - - if (ret == MEDIA_INFO_ERROR_NONE) { - media_svc_debug("Update is successful. Sending noti for this"); - _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); - _media_svc_destroy_noti_item(noti_item); - } - - _media_svc_destroy_content_info(&content_info); return ret; } -int media_svc_rename_folder(MediaSvcHandle *handle, const char *src_path, const char *dst_path) +static int __media_svc_get_ebook_search_type(void) { - sqlite3 * db_handle = (sqlite3 *)handle; - int ret = MEDIA_INFO_ERROR_NONE; - - media_svc_retvm_if(db_handle == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "Handle is NULL"); - media_svc_retvm_if(src_path == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "src_path is NULL"); - media_svc_retvm_if(dst_path == NULL, MEDIA_INFO_ERROR_INVALID_PARAMETER, "dst_path is NULL"); - - media_svc_debug("Src path : %s, Dst Path : %s", src_path, dst_path); - - /* Get notification info */ - media_svc_noti_item *noti_item = NULL; - ret = _media_svc_get_noti_info(handle, src_path, MS_MEDIA_ITEM_DIRECTORY, ¬i_item); - media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret); - - ret = _media_svc_sql_begin_trans(handle); - media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret); - - /* Update all folder record's path, which are matched by old parent path */ - char *update_folder_path_sql = NULL; - char src_path_slash[MEDIA_SVC_PATHNAME_SIZE + 1]; - char dst_path_slash[MEDIA_SVC_PATHNAME_SIZE + 1]; - - snprintf(src_path_slash, sizeof(src_path_slash), "%s/", src_path); - snprintf(dst_path_slash, sizeof(dst_path_slash), "%s/", dst_path); - - update_folder_path_sql = sqlite3_mprintf("UPDATE folder SET path = REPLACE( path, '%q', '%q');", src_path_slash, dst_path_slash); - - //ret = _media_svc_sql_query(handle, update_folder_path_sql); - ret = media_db_request_update_db_batch(update_folder_path_sql); - sqlite3_free(update_folder_path_sql); - - if (ret != SQLITE_OK) { - media_svc_error("failed to update folder path"); - _media_svc_sql_rollback_trans(handle); - - return MEDIA_INFO_ERROR_DATABASE_INTERNAL; - } - - /* Update all folder record's modified date, which are changed above */ - char *update_folder_modified_time_sql = NULL; - time_t date; - time(&date); - - update_folder_modified_time_sql = sqlite3_mprintf("UPDATE folder SET modified_time = %d where path like '%q';", date, dst_path); - - ret = media_db_request_update_db_batch(update_folder_modified_time_sql); - //ret = _media_svc_sql_query(handle, update_folder_modified_time_sql); - sqlite3_free(update_folder_modified_time_sql); - - if (ret != SQLITE_OK) { - media_svc_error("failed to update folder modified time"); - _media_svc_sql_rollback_trans(handle); - - return MEDIA_INFO_ERROR_DATABASE_INTERNAL; - } - - /* Update all items */ - char *select_all_sql = NULL; - sqlite3_stmt *sql_stmt = NULL; - char dst_child_path[MEDIA_SVC_PATHNAME_SIZE + 1]; - - snprintf(dst_child_path, sizeof(dst_child_path), "%s/%%", dst_path); - - 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); - - media_svc_debug("[SQL query] : %s", select_all_sql); - - ret = sqlite3_prepare_v2(handle, select_all_sql, -1, &sql_stmt, NULL); - sqlite3_free((char *)select_all_sql); - - if (ret != SQLITE_OK) { - media_svc_error ("prepare error [%s]", sqlite3_errmsg(handle)); - _media_svc_sql_rollback_trans(handle); - return MEDIA_INFO_ERROR_DATABASE_INTERNAL; - } - - while (1) { - ret = sqlite3_step(sql_stmt); - if (ret != SQLITE_ROW) { - media_svc_debug("end of iteration"); - break; + dictionary *dict = NULL; + static int _ebook_search_type = -1; + + if (_ebook_search_type == -1) { + dict = iniparser_load(CONTENT_INI_DEFAULT_PATH); + if (!dict) { + media_svc_error("%s load failed. Use direct search.", CONTENT_INI_DEFAULT_PATH); + return MEDIA_SVC_SEARCH_TYPE_DIRECT; } - char media_uuid[MEDIA_SVC_UUID_SIZE + 1] = {0,}; - char media_path[MEDIA_SVC_PATHNAME_SIZE + 1] = {0,}; - char media_thumb_path[MEDIA_SVC_PATHNAME_SIZE + 1] = {0,}; - char media_new_thumb_path[MEDIA_SVC_PATHNAME_SIZE + 1] = {0,}; - int media_type; - bool no_thumb = FALSE; + _ebook_search_type = iniparser_getint(dict, "media-content-config:ebook_search_type", 0); + media_svc_debug("ebook_search_type [%d]", _ebook_search_type); - if (STRING_VALID((const char *)sqlite3_column_text(sql_stmt, 0))) { - strncpy(media_uuid, (const char *)sqlite3_column_text(sql_stmt, 0), sizeof(media_uuid)); - media_uuid[sizeof(media_uuid) - 1] = '\0'; - } else { - media_svc_error("media UUID is NULL"); - return MEDIA_INFO_ERROR_DATABASE_INVALID; - } - - if (STRING_VALID((const char *)sqlite3_column_text(sql_stmt, 1))) { - strncpy(media_path, (const char *)sqlite3_column_text(sql_stmt, 1), sizeof(media_path)); - media_path[sizeof(media_path) - 1] = '\0'; - } else { - media_svc_error("media path is NULL"); - return MEDIA_INFO_ERROR_DATABASE_INVALID; - } - - if (STRING_VALID((const char *)sqlite3_column_text(sql_stmt, 2))) { - strncpy(media_thumb_path, (const char *)sqlite3_column_text(sql_stmt, 2), sizeof(media_thumb_path)); - media_thumb_path[sizeof(media_thumb_path) - 1] = '\0'; - } else { - media_svc_debug("media thumb path doesn't exist in DB"); - no_thumb = TRUE; - } - - media_type = sqlite3_column_int(sql_stmt, 3); - - /* Update path, thumbnail path of this item */ - char *replaced_path = NULL; - replaced_path = _media_svc_replace_path(media_path, src_path, dst_path); - if (replaced_path == NULL) { - media_svc_error("_media_svc_replace_path failed"); - SQLITE3_FINALIZE(sql_stmt); - _media_svc_sql_rollback_trans(handle); - return MEDIA_INFO_ERROR_INTERNAL; - } + iniparser_freedict(dict); + } - media_svc_debug("New media path : %s", replaced_path); - media_svc_storage_type_e storage_type; + return _ebook_search_type; +} - if (!no_thumb) { - ret = _media_svc_get_store_type_by_path(replaced_path, &storage_type); - if (ret < 0) { - media_svc_error("_media_svc_get_store_type_by_path failed : %d", ret); - SAFE_FREE(replaced_path); - _media_svc_sql_rollback_trans(handle); - return MEDIA_INFO_ERROR_DATABASE_INTERNAL; - } +int media_svc_get_book_by_keyword(sqlite3 *handle, const char *keyword, uid_t uid, GList **result) +{ + int ret = MS_MEDIA_ERR_NONE; + GList *item_list = NULL; + GList *iter = NULL; + char *query = NULL; - ret = _media_svc_get_thumbnail_path(storage_type, media_new_thumb_path, replaced_path, THUMB_EXT); - if (ret < 0) { - media_svc_error("_media_svc_get_thumbnail_path failed : %d", ret); - SAFE_FREE(replaced_path); - SQLITE3_FINALIZE(sql_stmt); - _media_svc_sql_rollback_trans(handle); - return MEDIA_INFO_ERROR_INTERNAL; - } + media_svc_retvm_if(!handle, MS_MEDIA_ERR_INVALID_PARAMETER, "db handle is NULL"); + media_svc_retvm_if(!keyword, MS_MEDIA_ERR_INVALID_PARAMETER, "keyword is NULL"); + media_svc_retvm_if(!result, MS_MEDIA_ERR_INVALID_PARAMETER, "result is NULL"); - //media_svc_debug("New media thumbnail path : %s", media_new_thumb_path); - } + query = sqlite3_mprintf("SELECT media_path FROM %q WHERE media_type=%d AND validity=1;", + DB_TABLE_MEDIA, MEDIA_SVC_MEDIA_TYPE_BOOK); - char *update_item_sql = NULL; + ret = _media_svc_get_media(handle, query, &item_list); + media_svc_retvm_if(ret != MS_MEDIA_ERR_NONE, ret, "_media_svc_get_media failed"); - if (no_thumb) { - update_item_sql = sqlite3_mprintf("UPDATE media SET path='%q' WHERE media_uuid='%q'", replaced_path, media_uuid); - } else { - if (media_type == MEDIA_SVC_MEDIA_TYPE_IMAGE || media_type == MEDIA_SVC_MEDIA_TYPE_VIDEO) { - 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); - } else { - update_item_sql = sqlite3_mprintf("UPDATE media SET path='%q', thumbnail_path='%q' WHERE media_uuid='%q'", replaced_path, media_thumb_path, media_uuid); - } - } + if (__media_svc_get_ebook_search_type() == MEDIA_SVC_SEARCH_TYPE_DB) { + for (iter = item_list; iter; iter = g_list_next(iter)) + _media_svc_update_wordbook((char *)iter->data, uid); - ret = media_db_request_update_db_batch(update_item_sql); - //ret = _media_svc_sql_query(handle, update_item_sql); - sqlite3_free(update_item_sql); - SAFE_FREE(replaced_path); - - if (ret != SQLITE_OK) { - media_svc_error("failed to update item"); - SQLITE3_FINALIZE(sql_stmt); - _media_svc_sql_rollback_trans(handle); - - return MEDIA_INFO_ERROR_DATABASE_INTERNAL; - } + _media_svc_clean_wordbook(uid); - /* Rename thumbnail file of file system */ - if ((!no_thumb) && (media_type == MEDIA_SVC_MEDIA_TYPE_IMAGE || media_type == MEDIA_SVC_MEDIA_TYPE_VIDEO)) { - ret = _media_svc_rename_file(media_thumb_path, media_new_thumb_path); - if (ret < 0) { - media_svc_error("_media_svc_rename_file failed : %d", ret); - SQLITE3_FINALIZE(sql_stmt); - _media_svc_sql_rollback_trans(handle); - - return MEDIA_INFO_ERROR_INTERNAL; - } + if (!_media_svc_get_matched_list(keyword, uid, result)) + media_svc_error("_media_svc_get_matched_list failed"); + } else { + for (iter = item_list; iter; iter = g_list_next(iter)) { + if (_media_svc_is_keyword_included((char *)iter->data, keyword)) + *result = g_list_append(*result, g_strdup((gchar *)iter->data)); } } - SQLITE3_FINALIZE(sql_stmt); - - ret = _media_svc_sql_end_trans(handle); - if (ret != MEDIA_INFO_ERROR_NONE) { - media_svc_error("mb_svc_sqlite3_commit_trans failed.. Now start to rollback\n"); - _media_svc_sql_rollback_trans(handle); - return ret; - } - - media_svc_debug("Folder update is successful. Sending noti for this"); - _media_svc_publish_noti(MS_MEDIA_ITEM_DIRECTORY, MS_MEDIA_ITEM_UPDATE, src_path, -1, noti_item->media_uuid, NULL); - _media_svc_destroy_noti_item(noti_item); - - return MEDIA_INFO_ERROR_NONE; -} - -int media_svc_request_update_db(const char *db_query) -{ - int ret = MEDIA_INFO_ERROR_NONE; - - media_svc_retvm_if(!STRING_VALID(db_query), MEDIA_INFO_ERROR_INVALID_PARAMETER, "db_query is NULL"); - - ret = _media_svc_request_update_db(db_query); + g_list_free_full(item_list, g_free); - return _media_svc_error_convert(ret); + return ret; } -int media_svc_send_dir_update_noti(MediaSvcHandle *handle, const char *dir_path) +int media_svc_check_db(sqlite3 *handle, uid_t uid) { - int ret = MEDIA_INFO_ERROR_NONE; - sqlite3 * db_handle = (sqlite3 *)handle; - - media_svc_retvm_if(!STRING_VALID(dir_path), MEDIA_INFO_ERROR_INVALID_PARAMETER, "dir_path is NULL"); + int ret = MS_MEDIA_ERR_NONE; + bool exist = false; - /* Get notification info */ - media_svc_noti_item *noti_item = NULL; - ret = _media_svc_get_noti_info(db_handle, dir_path, MS_MEDIA_ITEM_DIRECTORY, ¬i_item); - media_svc_retv_if(ret != MEDIA_INFO_ERROR_NONE, ret); + ret = media_svc_check_table_exist(handle, &exist); + if (ret != MS_MEDIA_ERR_NONE) + return ret; - ret = _media_svc_publish_noti(MS_MEDIA_ITEM_DIRECTORY, MS_MEDIA_ITEM_UPDATE, dir_path, -1, noti_item->media_uuid, NULL); - _media_svc_destroy_noti_item(noti_item); + if (!exist) + ret = media_svc_create_table(uid); return ret; -} +} \ No newline at end of file