X-Git-Url: http://review.tizen.org/git/?a=blobdiff_plain;f=src%2Fmedia_content.c;h=8d20d33fb03d3e30000ef5ce42fa1e91f9f3dfa3;hb=a14f941978dec0d06fa06ae3f6daccec168be1dc;hp=1a2fa6036f596ea1c903f78b5f6b7da753415e7b;hpb=65341b899cae83f25cbde0e4ddf69e377ef45805;p=platform%2Fcore%2Fapi%2Fmedia-content.git diff --git a/src/media_content.c b/src/media_content.c old mode 100755 new mode 100644 index 1a2fa60..8d20d33 --- a/src/media_content.c +++ b/src/media_content.c @@ -15,903 +15,105 @@ */ -#include #include #include -#include -#include -#include -#include -#ifdef _USE_TV_PROFILE -#include -#endif -#include -#include -#include -#ifdef _USE_TV_PROFILE -#include -#include -#endif - -static attribute_h g_attr_handle = NULL; -static attribute_h g_alias_attr_handle = NULL; -static MediaSvcHandle *db_handle = NULL; +static sqlite3 *db_handle = NULL; static int ref_count = 0; static GMutex db_mutex; -static __thread media_noti_cb_s *g_noti_info = NULL; - -static int __media_content_create_attr_handle(void); -static int __media_content_create_alias_attr_handle(void); -static int __media_content_create_attribute_handle(void); -static int __media_content_destroy_attribute_handle(void); - -static int __media_content_create_attr_handle(void) -{ - int ret = MEDIA_CONTENT_ERROR_NONE; - - ret = _media_filter_attribute_create(&g_attr_handle); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - /* Media Info */ - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_ID, DB_FIELD_MEDIA_ID); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_PATH, DB_FIELD_MEDIA_PATH); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_DISPLAY_NAME, DB_FIELD_MEDIA_DISPLAY_NAME); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_TYPE, DB_FIELD_MEDIA_TYPE); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_MIME_TYPE, DB_FIELD_MEDIA_MIME_TYPE); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_SIZE, DB_FIELD_MEDIA_SIZE); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_ADDED_TIME, DB_FIELD_MEDIA_ADDED_TIME); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_MODIFIED_TIME, DB_FIELD_MEDIA_MODIFIED_TIME); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_TIMELINE, DB_FIELD_MEDIA_TIMELINE); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); -#ifdef _USE_TV_PROFILE - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_FOLDER_ID, DB_FIELD_MEDIA_FOLDER_ID); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); -#endif - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_THUMBNAIL_PATH, DB_FIELD_MEDIA_THUMBNAIL_PATH); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_TITLE, DB_FIELD_MEDIA_TITLE); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_ALBUM, DB_FIELD_MEDIA_ALBUM); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_ARTIST, DB_FIELD_MEDIA_ARTIST); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_ALBUM_ARTIST, DB_FIELD_MEDIA_ALBUM_ARTIST); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_GENRE, DB_FIELD_MEDIA_GENRE); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_COMPOSER, DB_FIELD_MEDIA_COMPOSER); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_YEAR, DB_FIELD_MEDIA_YEAR); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_RECORDED_DATE, DB_FIELD_MEDIA_RECORDED_DATE); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_COPYRIGHT, DB_FIELD_MEDIA_COPYRIGHT); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_TRACK_NUM, DB_FIELD_MEDIA_TRACK_NUM); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_DESCRIPTION, DB_FIELD_MEDIA_DESCRIPTION); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_BITRATE, DB_FIELD_MEDIA_BITRATE); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_BITPERSAMPLE, DB_FIELD_MEDIA_BITPERSAMPLE); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_SAMPLERATE, DB_FIELD_MEDIA_SAMPLERATE); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_CHANNEL, DB_FIELD_MEDIA_CHANNEL); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_DURATION, DB_FIELD_MEDIA_DURATION); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_LONGITUDE, DB_FIELD_MEDIA_LONGITUDE); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_LATITUDE, DB_FIELD_MEDIA_LATITUDE); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_ALTITUDE, DB_FIELD_MEDIA_ALTITUDE); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_WIDTH, DB_FIELD_MEDIA_WIDTH); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_HEIGHT, DB_FIELD_MEDIA_HEIGHT); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_DATETAKEN, DB_FIELD_MEDIA_DATETAKEN); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_ORIENTATION, DB_FIELD_MEDIA_ORIENTATION); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_BURST_ID, DB_FIELD_MEDIA_BURST_ID); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_PLAYED_COUNT, DB_FIELD_MEDIA_PLAYED_COUNT); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_LAST_PLAYED_TIME, DB_FIELD_MEDIA_LAST_PLAYED_TIME); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_LAST_PLAYED_POSITION, DB_FIELD_MEDIA_LAST_PLAYED_POSITION); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_RATING, DB_FIELD_MEDIA_RATING); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_FAVOURITE, DB_FIELD_MEDIA_FAVOURITE); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_AUTHOR, DB_FIELD_MEDIA_AUTHOR); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_PROVIDER, DB_FIELD_MEDIA_PROVIDER); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_CONTENT_NAME, DB_FIELD_MEDIA_CONTENT_NAME); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_CATEGORY, DB_FIELD_MEDIA_CATEGORY); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_LOCATION_TAG, DB_FIELD_MEDIA_LOCATION_TAG); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_AGE_RATING, DB_FIELD_MEDIA_AGE_RATING); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_KEYWORD, DB_FIELD_MEDIA_KEYWORD); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_WEATHER, DB_FIELD_MEDIA_WEATHER); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_IS_DRM, DB_FIELD_MEDIA_IS_DRM); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_STORAGE_TYPE, DB_FIELD_MEDIA_STORAGE_TYPE); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - /* Pinyin*/ - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_FILE_NAME_PINYIN, DB_FIELD_MEDIA_FILE_NAME_PINYIN); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_TITLE_PINYIN, DB_FIELD_MEDIA_TITLE_PINYIN); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_ALBUM_PINYIN, DB_FIELD_MEDIA_ALBUM_PINYIN); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_ARTIST_PINYIN, DB_FIELD_MEDIA_ARTIST_PINYIN); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_ALBUM_ARTIST_PINYIN, DB_FIELD_MEDIA_ALBUM_ARTIST_PINYIN); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_GENRE_PINYIN, DB_FIELD_MEDIA_GENRE_PINYIN); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_COMPOSER_PINYIN, DB_FIELD_MEDIA_COMPOSER_PINYIN); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_COPYRIGHT_PINYIN, DB_FIELD_MEDIA_COPYRIGHT_PINYIN); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_DESCRIPTION_PINYIN, DB_FIELD_MEDIA_DESCRIPTION_PINYIN); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_AUTHOR_PINYIN, DB_FIELD_MEDIA_AUTHOR_PINYIN); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_PROVIDER_PINYIN, DB_FIELD_MEDIA_PROVIDER_PINYIN); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_CONTENT_NAME_PINYIN, DB_FIELD_MEDIA_CONTENT_NAME_PINYIN); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_CATEGORY_PINYIN, DB_FIELD_MEDIA_CATEGORY_PINYIN); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_LOCATION_TAG_PINYIN, DB_FIELD_MEDIA_LOCATION_TAG_PINYIN); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_AGE_RATING_PINYIN, DB_FIELD_MEDIA_AGE_RATING_PINYIN); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_KEYWORD_PINYIN, DB_FIELD_MEDIA_KEYWORD_PINYIN); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - /* Playlist*/ - ret = _media_filter_attribute_add(g_attr_handle, PLAYLIST_NAME, DB_FIELD_PLAYLIST_NAME); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, PLAYLIST_MEMBER_ORDER, DB_FIELD_PLAYLIST_MEMBER_ORDER); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - /* Playlist View */ - ret = _media_filter_attribute_add(g_attr_handle, PLAYLIST_MEDIA_COUNT, DB_FIELD_PLAYLIST_MEDIA_COUNT); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - /* Tag*/ - ret = _media_filter_attribute_add(g_attr_handle, TAG_NAME, DB_FIELD_TAG_NAME); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - /* Tag View */ - ret = _media_filter_attribute_add(g_attr_handle, TAG_MEDIA_COUNT, DB_FIELD_TAG_MEDIA_COUNT); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - /* Bookmark*/ - ret = _media_filter_attribute_add(g_attr_handle, BOOKMARK_MARKED_TIME, DB_FIELD_BOOKMARK_MARKED_TIME); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_360, DB_FIELD_MEDIA_360); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - -#ifdef _USE_TV_PROFILE - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_STITCHED_INFO, DB_FIELD_MEDIA_STITCHED_INFO); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); -#endif - - /* Storage*/ - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_STORAGE_ID, DB_FIELD_STORAGE_ID); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_STORAGE_PATH, DB_FIELD_STORAGE_PATH); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - /* Face */ - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_FACE_TAG, DB_FIELD_FACE_TAG); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); -#ifdef _USE_TV_PROFILE - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_MODIFIED_MONTH, DB_FIELD_MEDIA_MODIFIED_DATE); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_MODIFIED_DATE, DB_FIELD_MEDIA_MODIFIED_DATE); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); -#endif -#ifdef _USE_SENIOR_MODE - if (_media_content_is_support_senior_mode()) { - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_CONTACT, DB_FIELD_MEDIA_CONTACT); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, MEDIA_APP_DATA, DB_FIELD_MEDIA_APP_DATA); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - } -#endif -#ifdef _USE_TV_PROFILE - /* PVR*/ - ret = _media_filter_attribute_add(g_attr_handle, PVR_DURATION, DB_FIELD_PVR_DURATION); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, PVR_TIME_ZONE, DB_FIELD_PVR_TIME_ZONE); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, PVR_PTC, DB_FIELD_PVR_PTC); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, PVR_MAJOR, DB_FIELD_PVR_MAJOR); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, PVR_MINOR, DB_FIELD_PVR_MINOR); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, PVR_CHANNEL_TYPE, DB_FIELD_PVR_CHANNEL_TYPE); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, PVR_CHANNEL_NAME, DB_FIELD_PVR_CHANNEL_NAME); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, PVR_CHANNEL_NUM, DB_FIELD_PVR_CHANNEL_NUM); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, PVR_PROGRAM_TITLE, DB_FIELD_PVR_PROGRAM_TITLE); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, PVR_PROGRAM_NUM, DB_FIELD_PVR_PROGRAM_NUM); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, PVR_PROGRAM_CRID, DB_FIELD_PVR_PROGRAM_CRID); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, PVR_GUIDANCE, DB_FIELD_PVR_GUIDANCE); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); +static uid_t content_g_uid = 0; - ret = _media_filter_attribute_add(g_attr_handle, PVR_SYNOPSIS, DB_FIELD_PVR_SYNOPSIS); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, PVR_GENRE, DB_FIELD_PVR_GENRE); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, PVR_LANGUAGE, DB_FIELD_PVR_LANGUAGE); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, PVR_EMBARGO_TIME, DB_FIELD_PVR_EMBARGO_TIME); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, PVR_EXPIRY_TIME, DB_FIELD_PVR_EXPIRY_TIME); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, PVR_START_TIME, DB_FIELD_PVR_START_TIME); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, PVR_PROGRAM_START_TIME, DB_FIELD_PVR_PROGRAM_START_TIME); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, PVR_PROGRAM_END_TIME, DB_FIELD_PVR_PROGRAM_END_TIME); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, PVR_PROGRAM_DATE, DB_FIELD_PVR_PROGRAM_DATE); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, PVR_PARENTAL_RATING, DB_FIELD_PVR_PARENTAL_RATING); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, PVR_TIMER_RECORD, DB_FIELD_PVR_TIMER_RECORD); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, PVR_SERIES_RECORD, DB_FIELD_PVR_SERIES_RECORD); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, PVR_HD, DB_FIELD_PVR_HD); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, PVR_SUBTITLE, DB_FIELD_PVR_SUBTITLE); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, PVR_TTX, DB_FIELD_PVR_TTX); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, PVR_AD, DB_FIELD_PVR_AD); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, PVR_TTX, DB_FIELD_PVR_TTX); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, PVR_DATA_SERVICE, DB_FIELD_PVR_DATA_SERVICE); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, PVR_CONTENT_LOCK, DB_FIELD_PVR_CONTENT_LOCK); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, PVR_CONTENT_WATCH, DB_FIELD_PVR_CONTENT_WATCH); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, PVR_CONTENT_HAS_AUDIO_ONLY, DB_FIELD_PVR_HAS_AUDIO_ONLY); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, PVR_CONTENT_IS_LOCAL_RECORD, DB_FIELD_PVR_IS_LOCAL_RECORD); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, PVR_CONTENT_RESOLUTION, DB_FIELD_PVR_RESOLUTION); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, PVR_CONTENT_ASPECTRATIO, DB_FIELD_PVR_ASPECTRATIO); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, PVR_MODIFIED_MONTH, DB_FIELD_PVR_MODIFIED_DATE); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, PVR_MODIFIED_DATE, DB_FIELD_PVR_MODIFIED_DATE); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, PVR_SPORTS_TYPE, DB_FIELD_PVR_SPORTS_TYPE); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, PVR_GUIDANCE_LENGTH, DB_FIELD_PVR_GUIDANCE_LENGTH); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, PVR_TVMODE, DB_FIELD_PVR_TVMODE); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, PVR_PLAY_COUNT, DB_FIELD_PVR_PLAY_COUNT); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, PVR_PRIVATE_DATA, DB_FIELD_PVR_PRIVATE_DATA); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - /* UHD*/ - ret = _media_filter_attribute_add(g_attr_handle, UHD_CONTENT_TITLE, DB_FIELD_UHD_CONTENT_TITLE); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, UHD_RELEASE_DATE, DB_FIELD_UHD_RELEASE_DATE); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, UHD_SUB_TYPE, DB_FIELD_UHD_SUB_TYPE); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, UHD_FILE_NAME, DB_FIELD_UHD_FILE_NAME); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, UHD_FOLDER_ID, DB_FIELD_FOLDER_ID); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_attr_handle, UHD_PLAYED_COUNT, DB_FIELD_UHD_PLAYED_COUNT); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); -#endif - return ret; -} - -static int __media_content_create_alias_attr_handle(void) +sqlite3 * _content_get_db_handle(void) { - int ret = MEDIA_CONTENT_ERROR_NONE; - - ret = _media_filter_attribute_create(&g_alias_attr_handle); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - /* Media Info */ - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_ID, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ID); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_PATH, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_PATH); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_DISPLAY_NAME, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_DISPLAY_NAME); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_TYPE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_TYPE); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_MIME_TYPE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_MIME_TYPE); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_SIZE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_SIZE); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_ADDED_TIME, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ADDED_TIME); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_MODIFIED_TIME, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_MODIFIED_TIME); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_TIMELINE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_TIMELINE); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); -#ifdef _USE_TV_PROFILE - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_FOLDER_ID, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_FOLDER_ID); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); -#endif - - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_THUMBNAIL_PATH, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_THUMBNAIL_PATH); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_TITLE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_TITLE); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_ALBUM, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ALBUM); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_ARTIST, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ARTIST); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_ALBUM_ARTIST, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ALBUM_ARTIST); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_GENRE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_GENRE); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_COMPOSER, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_COMPOSER); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_YEAR, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_YEAR); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_RECORDED_DATE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_RECORDED_DATE); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_COPYRIGHT, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_COPYRIGHT); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_TRACK_NUM, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_TRACK_NUM); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_DESCRIPTION, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_DESCRIPTION); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_BITRATE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_BITRATE); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_BITPERSAMPLE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_BITPERSAMPLE); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_SAMPLERATE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_SAMPLERATE); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_CHANNEL, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_CHANNEL); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_DURATION, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_DURATION); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_LONGITUDE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_LONGITUDE); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_LATITUDE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_LATITUDE); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_ALTITUDE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ALTITUDE); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_WIDTH, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_WIDTH); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_HEIGHT, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_HEIGHT); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_DATETAKEN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_DATETAKEN); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_ORIENTATION, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ORIENTATION); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_BURST_ID, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_BURST_ID); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_PLAYED_COUNT, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_PLAYED_COUNT); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_LAST_PLAYED_TIME, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_LAST_PLAYED_TIME); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_LAST_PLAYED_POSITION, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_LAST_PLAYED_POSITION); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_RATING, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_RATING); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_FAVOURITE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_FAVOURITE); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_AUTHOR, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_AUTHOR); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_PROVIDER, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_PROVIDER); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_CONTENT_NAME, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_CONTENT_NAME); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_CATEGORY, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_CATEGORY); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_LOCATION_TAG, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_LOCATION_TAG); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_AGE_RATING, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_AGE_RATING); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_KEYWORD, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_KEYWORD); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_WEATHER, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_WEATHER); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_IS_DRM, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_IS_DRM); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_STORAGE_TYPE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_STORAGE_TYPE); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_360, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_360); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - -#ifdef _USE_SENIOR_MODE - if (_media_content_is_support_senior_mode()) { - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_CONTACT, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_CONTACT); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_APP_DATA, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_APP_DATA); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - } -#endif - - /* Pinyin*/ - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_FILE_NAME_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_FILE_NAME_PINYIN); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_TITLE_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_TITLE_PINYIN); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_ALBUM_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ALBUM_PINYIN); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_ARTIST_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ARTIST_PINYIN); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_ALBUM_ARTIST_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ALBUM_ARTIST_PINYIN); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_GENRE_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_GENRE_PINYIN); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_COMPOSER_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_COMPOSER_PINYIN); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_COPYRIGHT_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_COPYRIGHT_PINYIN); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_DESCRIPTION_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_DESCRIPTION_PINYIN); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_AUTHOR_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_AUTHOR_PINYIN); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_PROVIDER_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_PROVIDER_PINYIN); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_CONTENT_NAME_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_CONTENT_NAME_PINYIN); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_CATEGORY_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_CATEGORY_PINYIN); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_LOCATION_TAG_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_LOCATION_TAG_PINYIN); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_AGE_RATING_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_AGE_RATING_PINYIN); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_KEYWORD_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_KEYWORD_PINYIN); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - /* Folder */ - ret = _media_filter_attribute_add(g_alias_attr_handle, FOLDER_ID, DB_TABLE_ALIAS_FOLDER"."DB_FIELD_FOLDER_ID); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, FOLDER_PATH, DB_TABLE_ALIAS_FOLDER"."DB_FIELD_FOLDER_PATH); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, FOLDER_NAME, DB_TABLE_ALIAS_FOLDER"."DB_FIELD_FOLDER_NAME); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, FOLDER_MODIFIED_TIME, DB_TABLE_ALIAS_FOLDER"."DB_FIELD_FOLDER_MODIFIED_TIME); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, FOLDER_STORAGE_TYPE, DB_TABLE_ALIAS_FOLDER"."DB_FIELD_FOLDER_STORAGE_TYPE); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, FOLDER_NAME_PINYIN, DB_TABLE_ALIAS_FOLDER"."DB_FIELD_FOLDER_NAME_PINYIN); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, FOLDER_ORDER, DB_TABLE_ALIAS_FOLDER"."DB_FIELD_FOLDER_ORDER); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, FOLDER_PARENT_FOLDER_ID, DB_TABLE_ALIAS_FOLDER"."DB_FIELD_FOLDER_PARENT_FOLDER_ID); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - /* Playlist*/ - ret = _media_filter_attribute_add(g_alias_attr_handle, PLAYLIST_NAME, DB_TABLE_ALIAS_PLAYLIST"."DB_FIELD_PLAYLIST_NAME); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = _media_filter_attribute_add(g_alias_attr_handle, PLAYLIST_MEMBER_ORDER, DB_TABLE_ALIAS_PLAYLIST_MAP"."DB_FIELD_PLAYLIST_MEMBER_ORDER); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - /* Tag*/ - ret = _media_filter_attribute_add(g_alias_attr_handle, TAG_NAME, DB_TABLE_ALIAS_TAG"."DB_FIELD_TAG_NAME); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - /* Bookmark*/ - ret = _media_filter_attribute_add(g_alias_attr_handle, BOOKMARK_MARKED_TIME, DB_TABLE_ALIAS_BOOKMARK"."DB_FIELD_BOOKMARK_MARKED_TIME); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - return ret; + return db_handle; } -static int __media_content_create_attribute_handle(void) +uid_t _content_get_uid(void) { - int ret = MEDIA_CONTENT_ERROR_NONE; - - ret = __media_content_create_attr_handle(); - media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret); - - ret = __media_content_create_alias_attr_handle(); - if (ret != MEDIA_CONTENT_ERROR_NONE) - _media_filter_attribute_destory(g_attr_handle); - - return ret; + if (content_g_uid == 0) + return tzplatform_getuid(TZ_USER_NAME); + else + return content_g_uid; } -static int __media_content_destroy_attribute_handle(void) +int _content_query_prepare(const char *select_query, const char *condition_query, const char *option_query, sqlite3_stmt **stmt) { int ret = MEDIA_CONTENT_ERROR_NONE; + char *query = NULL; - ret = _media_filter_attribute_destory(g_attr_handle); - ret = _media_filter_attribute_destory(g_alias_attr_handle); - - g_attr_handle = NULL; - g_alias_attr_handle = NULL; - - return ret; -} - -attribute_h _content_get_attirbute_handle(void) -{ - return g_attr_handle; -} + content_retip_if_fail(select_query); -attribute_h _content_get_alias_attirbute_handle(void) -{ - return g_alias_attr_handle; -} - -MediaSvcHandle* _content_get_db_handle(void) -{ - return db_handle; -} + /* If 'option_query' is NULL, 'condition_query' is also NULL. */ + if (option_query) { + if (STRING_VALID(condition_query)) + query = sqlite3_mprintf("%s AND %s %s", select_query, condition_query, option_query); + else + query = sqlite3_mprintf("%s %s", select_query, option_query); -int _content_query_prepare(sqlite3_stmt **stmt, char *select_query, char *condition_query, char *option_query) -{ - int len = 0; - int err = MEDIA_CONTENT_ERROR_NONE; - char query[MAX_QUERY_SIZE] = {0, }; - memset(query, '\0', sizeof(query)); - - media_content_retvm_if(db_handle == NULL, MEDIA_CONTENT_ERROR_DB_FAILED, "database is not connected"); - media_content_retvm_if(!STRING_VALID(select_query), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "invalid select_query"); - - if (!STRING_VALID(condition_query)) - condition_query = (char *)" "; - - if (!STRING_VALID(option_query)) - option_query = (char *)" "; - - /*query = sqlite3_mprintf("%s %s %s", select_query, condition_query, option_query);*/ - len = snprintf(query, sizeof(query), "%s %s %s", select_query, condition_query, option_query); - if (len > 0 && len < MAX_QUERY_SIZE) - query[len] = '\0'; - else if (len >= MAX_QUERY_SIZE) - query[MAX_QUERY_SIZE -1] = '\0'; - else { - media_content_error("snprintf failed"); - return MEDIA_CONTENT_ERROR_INVALID_PARAMETER; + } else { + query = sqlite3_mprintf("%s", select_query); } - media_content_sec_debug("Query : [%s]", query); + ret = _content_get_result(query, stmt); + SQLITE3_SAFE_FREE(query); - err = sqlite3_prepare_v2((sqlite3*)db_handle, query, strlen(query), stmt, NULL); - if (err != SQLITE_OK) { - media_content_error("DB_FAILED(0x%08x) fail to sqlite3_prepare(), %s", MEDIA_CONTENT_ERROR_DB_FAILED, sqlite3_errmsg((sqlite3*)db_handle)); - - if (err == SQLITE_BUSY) { - media_content_error(" BUSY ERROR"); - return MEDIA_CONTENT_ERROR_DB_BUSY; - } else if (err == SQLITE_PERM) { - media_content_error("PERMISSION EROR"); - return MEDIA_CONTENT_ERROR_PERMISSION_DENIED; - } else { - media_content_error("OTHER ERROR"); - return MEDIA_CONTENT_ERROR_DB_FAILED; - } - } - - return MEDIA_CONTENT_ERROR_NONE; + return ret; } -#ifdef _USE_SENIOR_MODE -int _content_query_prepare_by_union_select(sqlite3_stmt **stmt, char *select_query1, char *condition_query1, char *option_query1, char *select_query2, char *condition_query2, char *option_query2) +int _content_get_result(char *query, sqlite3_stmt **stmt) { - int len = 0; int err = MEDIA_CONTENT_ERROR_NONE; - char query[MAX_QUERY_SIZE] = {0, }; - memset(query, '\0', sizeof(query)); - - media_content_retvm_if(db_handle == NULL, MEDIA_CONTENT_ERROR_DB_FAILED, "database is not connected"); - media_content_retvm_if(!STRING_VALID(select_query1), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "invalid select_query1"); - media_content_retvm_if(!STRING_VALID(select_query2), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "invalid select_query2"); - - if (!STRING_VALID(condition_query1)) - condition_query1 = (char *)" "; - - if (!STRING_VALID(option_query1)) - option_query1 = (char *)" "; - if (!STRING_VALID(condition_query2)) - condition_query2 = (char *)" "; + content_retip_if_fail(_content_get_db_handle()); + content_retip_if_fail(query); - if (!STRING_VALID(option_query2)) - option_query2 = (char *)" "; + content_sec_debug("Query[%s]", query); - len = snprintf(query, sizeof(query), "SELECT * FROM (%s %s %s) as table1 UNION ALL SELECT * FROM (%s %s %s) as table2", - select_query1, condition_query1, option_query1, select_query2, condition_query2, option_query2); - if (len > 0 && len < MAX_QUERY_SIZE) { - query[len] = '\0'; - } else if (len >= MAX_QUERY_SIZE) { - query[MAX_QUERY_SIZE -1] = '\0'; - } else { - media_content_error("snprintf failed"); - return MEDIA_CONTENT_ERROR_INVALID_PARAMETER; - } - - media_content_sec_debug("Query : [%s]", query); - - err = sqlite3_prepare_v2((sqlite3*)db_handle, query, strlen(query), stmt, NULL); + err = sqlite3_prepare_v2(_content_get_db_handle(), query, strlen(query), stmt, NULL); if (err != SQLITE_OK) { - media_content_error("DB_FAILED(0x%08x) fail to sqlite3_prepare(), %s", MEDIA_CONTENT_ERROR_DB_FAILED, sqlite3_errmsg((sqlite3*)db_handle)); - - if (err == SQLITE_BUSY) { - media_content_error(" BUSY ERROR"); + content_error("Failed to sqlite3_prepare_v2[%s]", sqlite3_errmsg(_content_get_db_handle())); + if (err == SQLITE_BUSY) return MEDIA_CONTENT_ERROR_DB_BUSY; - } else if (err == SQLITE_PERM) { - media_content_error("PERMISSION EROR"); + else if (err == SQLITE_PERM) return MEDIA_CONTENT_ERROR_PERMISSION_DENIED; - } else { - media_content_error("OTHER ERROR"); + else return MEDIA_CONTENT_ERROR_DB_FAILED; - } } return MEDIA_CONTENT_ERROR_NONE; } -#endif -int _content_error_capi(int type, int content_error) +int _content_error_capi(int internal_error) { - if (content_error != MEDIA_CONTENT_ERROR_NONE) - media_content_error("[type : %d] content_error : %d ", type, content_error); - - /*Error None*/ - if (content_error == MS_MEDIA_ERR_NONE) + if (internal_error == MS_MEDIA_ERR_NONE) return MEDIA_CONTENT_ERROR_NONE; - /* Internal operation error*/ - else if ((content_error == MS_MEDIA_ERR_INVALID_PARAMETER) || - (content_error == MS_MEDIA_ERR_INVALID_PATH) || - (content_error == MS_MEDIA_ERR_THUMB_DUPLICATED_REQUEST)) - return MEDIA_CONTENT_ERROR_INVALID_PARAMETER; + content_error("MS Error[%d]", internal_error); - else if (content_error == MS_MEDIA_ERR_OUT_OF_MEMORY) + switch (internal_error) { + case MS_MEDIA_ERR_INVALID_PARAMETER: + return MEDIA_CONTENT_ERROR_INVALID_PARAMETER; + case MS_MEDIA_ERR_OUT_OF_MEMORY: return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY; - - /* DB operation error*/ - else if (content_error == MS_MEDIA_ERR_DB_BUSY_FAIL) + case MS_MEDIA_ERR_DB_BUSY_FAIL: return MEDIA_CONTENT_ERROR_DB_BUSY; - - else if ((content_error <= MS_MEDIA_ERR_DB_CONNECT_FAIL) && (content_error >= MS_MEDIA_ERR_DB_INTERNAL)) + case MS_MEDIA_ERR_DB_CONSTRAINT_FAIL: + case MS_MEDIA_ERR_DB_NO_RECORD: + case MS_MEDIA_ERR_DB_CORRUPT: + case MS_MEDIA_ERR_DB_FULL_FAIL: + case MS_MEDIA_ERR_DB_RESET: + case MS_MEDIA_ERR_DB_INTERNAL: return MEDIA_CONTENT_ERROR_DB_FAILED; - - /* IPC operation error*/ - else if ((content_error <= MS_MEDIA_ERR_SOCKET_CONN) && (content_error >= MS_MEDIA_ERR_SOCKET_INTERNAL)) + case MS_MEDIA_ERR_IPC: return MEDIA_CONTENT_ERROR_NETWORK; - - /* MEDIA SERVER error*/ - else if (content_error == MS_MEDIA_ERR_PERMISSION_DENIED) + case MS_MEDIA_ERR_PERMISSION_DENIED: return MEDIA_CONTENT_ERROR_PERMISSION_DENIED; - - /* Thumbnail error*/ - else if (content_error == MS_MEDIA_ERR_THUMB_TOO_BIG) - return MEDIA_CONTENT_ERROR_UNSUPPORTED_CONTENT; - - /*ETC*/ - return MEDIA_CONTENT_ERROR_INVALID_OPERATION; + case MS_MEDIA_ERR_THUMB_TOO_BIG: + case MS_MEDIA_ERR_THUMB_UNSUPPORTED: + return MEDIA_CONTENT_ERROR_UNSUPPORTED_CONTENT; + default: + return MEDIA_CONTENT_ERROR_INVALID_OPERATION; + } } int _content_query_sql(char *query_str) @@ -919,9 +121,9 @@ int _content_query_sql(char *query_str) int ret = MEDIA_CONTENT_ERROR_NONE; /*DB will be updated by Media Server.*/ - ret = media_svc_request_update_db(query_str, tzplatform_getuid(TZ_USER_NAME)); + ret = media_db_request_update_db(query_str, _content_get_uid()); - return _content_error_capi(MEDIA_CONTENT_TYPE, ret); + return _content_error_capi(ret); } int media_content_connect(void) @@ -929,173 +131,150 @@ int media_content_connect(void) int ret = MEDIA_CONTENT_ERROR_NONE; g_mutex_lock(&db_mutex); - media_content_info("ref count : %d", ref_count); + content_info("ref count : %d", ref_count); if (ref_count == 0) { if (db_handle == NULL) { - ret = __media_content_create_attribute_handle(); - if (ret == MEDIA_CONTENT_ERROR_NONE) { - ret = media_svc_connect(&db_handle, tzplatform_getuid(TZ_USER_NAME), false); - ret = _content_error_capi(MEDIA_CONTENT_TYPE, ret); - if (ret == MEDIA_CONTENT_ERROR_NONE) - ref_count++; - else - __media_content_destroy_attribute_handle(); - - } else { - media_content_error("Internal DB Connection Error"); - } + ret = media_db_connect(&db_handle, _content_get_uid(), false); + ret = _content_error_capi(ret); + if (ret == MEDIA_CONTENT_ERROR_NONE) + ref_count++; } else { - media_content_error("Wrong DB Connection status"); + content_error("Wrong DB Connection status"); ret = MEDIA_CONTENT_ERROR_DB_FAILED; } } else { if (db_handle != NULL) { ref_count++; } else { - media_content_error("Wrong DB Handle status"); + content_error("Wrong DB Handle status"); ret = MEDIA_CONTENT_ERROR_DB_FAILED; } } - media_content_info("ref count changed to: %d", ref_count); + content_info("ref count changed to: %d", ref_count); g_mutex_unlock(&db_mutex); return ret; } -int media_content_disconnect(void) +int media_content_connect_with_uid(uid_t uid) { - int ret = MEDIA_CONTENT_ERROR_NONE; + content_sec_debug("media_content_connect_with_uid [%d]", uid); + content_g_uid = uid; + return media_content_connect(); +} + +int media_content_disconnect(void) +{ g_mutex_lock(&db_mutex); - media_content_debug("ref count : %d", ref_count); - if (ref_count > 0) { - if (db_handle != NULL) { - ref_count--; - } else { - media_content_error("Wrong DB Handle status"); - ret = MEDIA_CONTENT_ERROR_DB_FAILED; + content_debug("ref count : %d", ref_count); + + if (db_handle && ref_count > 0) { + if (--ref_count == 0) { + media_db_disconnect(db_handle); + db_handle = NULL; } } else { - media_content_error("DB_FAILED(0x%08x) database is not connected", MEDIA_CONTENT_ERROR_DB_FAILED); + content_error("Database is not connected"); g_mutex_unlock(&db_mutex); return MEDIA_CONTENT_ERROR_DB_FAILED; } - if (ref_count == 0) { - if (db_handle != NULL) { - ret = media_svc_disconnect(db_handle); - ret = _content_error_capi(MEDIA_CONTENT_TYPE, ret); - if (ret == MEDIA_CONTENT_ERROR_NONE) { - ret = __media_content_destroy_attribute_handle(); - db_handle = NULL; - } else { - media_content_error("database disconnect fail"); - ref_count++; - } - } else { - media_content_error("Wrong DB Handle status"); - ret = MEDIA_CONTENT_ERROR_DB_FAILED; - } - - g_mutex_unlock(&db_mutex); - - media_content_info("ref count changed to: %d", ref_count); - - return ret; - } - g_mutex_unlock(&db_mutex); - media_content_info("ref count changed to: %d", ref_count); + content_info("ref count changed to: %d", ref_count); - return ret; + return MEDIA_CONTENT_ERROR_NONE; } int media_content_scan_file(const char *path) { int ret = MEDIA_CONTENT_ERROR_NONE; - bool ignore_file = FALSE; - bool ignore_dir = FALSE; char *folder_path = NULL; int check_file = MEDIA_CONTENT_ERROR_NONE; char storage_id[MEDIA_CONTENT_UUID_SIZE+1] = {0,}; - char repl_path[MAX_QUERY_SIZE] = {0,}; - media_content_retvm_if(!STRING_VALID(path), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "invalid path"); + content_retip_if_fail(STRING_VALID(path)); - media_content_sec_debug("Path : %s", path); - memset(repl_path, 0, sizeof(repl_path)); - ret = _media_content_replace_path(path, repl_path); - media_content_retvm_if(!STRING_VALID(repl_path), MEDIA_CONTENT_ERROR_INVALID_OPERATION, "path replacement failed"); + content_sec_debug("Path : %s", path); - ret = _media_util_check_ignore_file(repl_path, &ignore_file); - media_content_retvm_if(ignore_file == TRUE, MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid path"); + content_retvm_if(_media_util_is_ignorable_file(path), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid path"); - memset(storage_id, 0x00, sizeof(storage_id)); - ret = media_svc_get_storage_id(_content_get_db_handle(), repl_path, storage_id, tzplatform_getuid(TZ_USER_NAME)); + ret = media_svc_get_storage_id(_content_get_db_handle(), path, storage_id, _content_get_uid()); if (ret != MS_MEDIA_ERR_NONE) { - media_content_error("media_svc_get_storage_id failed : %d", ret); - return _content_error_capi(MEDIA_CONTENT_TYPE, ret); + content_error("media_svc_get_storage_id failed : %d", ret); + return _content_error_capi(ret); } - check_file = _media_util_check_file_exist(repl_path); + check_file = _media_util_check_file_exist(path); if (check_file == MEDIA_CONTENT_ERROR_NONE) { /* This means this path has to be inserted or refreshed */ - folder_path = g_path_get_dirname(repl_path); - ret = _media_util_check_ignore_dir(folder_path, &ignore_dir); - SAFE_FREE(folder_path); + folder_path = g_path_get_dirname(path); + + if (_media_util_is_ignorable_dir(folder_path)) { + g_free(folder_path); + return MEDIA_CONTENT_ERROR_INVALID_PARAMETER; + } - media_content_retvm_if(ignore_dir == TRUE, MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid folder path"); + g_free(folder_path); - media_svc_storage_type_e storage_type; + /* check feature */ + content_retvm_if(!_media_util_check_support_media_type(path), MEDIA_CONTENT_ERROR_NOT_SUPPORTED, "Unsupported media type"); - ret = media_svc_get_storage_type(repl_path, &storage_type, tzplatform_getuid(TZ_USER_NAME)); + ms_user_storage_type_e storage_type; + + ret = ms_user_get_storage_type(_content_get_uid(), path, &storage_type); if (ret != MS_MEDIA_ERR_NONE) { - media_content_sec_error("media_svc_get_storage_type failed : %d (%s)", ret, repl_path); - return _content_error_capi(MEDIA_CONTENT_TYPE, ret); + content_sec_error("ms_user_get_storage_type failed : %d (%s)", ret, path); + return _content_error_capi(ret); } - ret = media_svc_check_item_exist_by_path(_content_get_db_handle(), storage_id, repl_path); + ret = media_svc_check_item_exist_by_path(_content_get_db_handle(), storage_id, path); if (ret == MS_MEDIA_ERR_NONE) { /* Refresh */ - ret = media_svc_refresh_item(_content_get_db_handle(), storage_id, storage_type, repl_path, tzplatform_getuid(TZ_USER_NAME)); + ret = media_svc_refresh_item(_content_get_db_handle(), false, storage_id, storage_type, path, _content_get_uid()); if (ret != MS_MEDIA_ERR_NONE) { - media_content_error("media_svc_refresh_item failed : %d", ret); - return _content_error_capi(MEDIA_CONTENT_TYPE, ret); + content_error("media_svc_refresh_item failed : %d", ret); + return _content_error_capi(ret); } } else if (ret == MS_MEDIA_ERR_DB_NO_RECORD) { /* Insert */ - ret = media_svc_insert_item_immediately(_content_get_db_handle(), storage_id, storage_type, repl_path, tzplatform_getuid(TZ_USER_NAME)); + ret = media_svc_insert_item_immediately(_content_get_db_handle(), storage_id, storage_type, path, _content_get_uid()); if (ret != MS_MEDIA_ERR_NONE) { if (ret == MS_MEDIA_ERR_DB_CONSTRAINT_FAIL) { - media_content_sec_error("This item is already inserted. This may be normal operation because other process already did this (%s)", repl_path); + content_sec_error("This item is already inserted. This may be normal operation because other process already did this (%s)", path); ret = MEDIA_CONTENT_ERROR_NONE; } else { - media_content_sec_error("media_svc_insert_item_immediately failed : %d (%s)", ret, repl_path); + content_sec_error("media_svc_insert_item_immediately failed : %d (%s)", ret, path); } - return _content_error_capi(MEDIA_CONTENT_TYPE, ret); + return _content_error_capi(ret); } } else { - media_content_error("media_svc_check_item_exist_by_path failed : %d", ret); - return _content_error_capi(MEDIA_CONTENT_TYPE, ret); + content_error("media_svc_check_item_exist_by_path failed : %d", ret); + return _content_error_capi(ret); } } else if (check_file == MEDIA_CONTENT_ERROR_PERMISSION_DENIED) { - media_content_error("You have no permission for this file %d", ret); + content_error("You have no permission for this file %d", ret); return MEDIA_CONTENT_ERROR_PERMISSION_DENIED; } else { /* This means this path has to be deleted */ - media_content_debug("This path doesn't exists in file system... So now start to delete it from DB"); - ret = media_svc_delete_item_by_path(_content_get_db_handle(), storage_id, repl_path, tzplatform_getuid(TZ_USER_NAME)); + content_debug("This path doesn't exists in file system... So now start to delete it from DB"); + ret = media_svc_delete_item_by_path(_content_get_db_handle(), storage_id, path, _content_get_uid()); if (ret != MS_MEDIA_ERR_NONE) { - media_content_error("media_svc_delete_item_by_path failed : %d", ret); - return _content_error_capi(MEDIA_CONTENT_TYPE, ret); + if (ret == MS_MEDIA_ERR_DB_NO_RECORD) { + content_error("Does not exist in media DB also... So, this is an invalid parameter"); + return MEDIA_CONTENT_ERROR_INVALID_PARAMETER; + } + + content_error("media_svc_delete_item_by_path failed : %d", ret); + return _content_error_capi(ret); } } - return _content_error_capi(MEDIA_CONTENT_TYPE, ret); + return _content_error_capi(ret); } void _media_content_scan_cb(media_request_result_s* result, void *user_data) @@ -1103,40 +282,41 @@ void _media_content_scan_cb(media_request_result_s* result, void *user_data) int err = -1; media_content_scan_cb_data *cb_data = user_data; - err = _content_error_capi(MEDIA_REGISTER_TYPE, result->result); -#ifdef _USE_TV_PROFILE + err = _content_error_capi(result->result); +#ifdef _USE_TVPD_MODE if (result->request_type != MEDIA_REQUEST_SCAN_COMPLETE && - result->request_type != MEDIA_REQUEST_SCAN_PARTIAL) { + result->request_type != MEDIA_REQUEST_SCAN_PARTIAL && + result->request_type != MEDIA_RECURSIVE_START) { if (cb_data && cb_data->callback) { - media_content_debug("begin:User callback is being called now, result=%d", err); + content_debug("begin:User callback is being called now, result=%d", err); cb_data->callback(err, cb_data->user_data); - media_content_debug("end:User callback is being called now, result=%d", err); + content_debug("end:User callback is being called now, result=%d", err); } - SAFE_FREE(cb_data); + g_free(cb_data); } #else if (cb_data && cb_data->callback) { - media_content_debug("User callback is being called now"); + content_debug("User callback is being called now"); cb_data->callback(err, cb_data->user_data); } - SAFE_FREE(cb_data); + g_free(cb_data); #endif return; } -#ifdef _USE_TV_PROFILE +#ifdef _USE_TVPD_MODE void _media_content_scan_cb_v2(media_request_result_s* result, void *user_data) { int err = -1; media_content_scan_cb_data_v2 *cb_data = user_data; media_content_complete_phase_e complete_phase = -1; if (!cb_data) - media_content_debug("cb_data is NULL"); - err = _content_error_capi(MEDIA_REGISTER_TYPE, result->result); - media_content_debug("result is %d", err); + content_debug("cb_data is NULL"); + err = _content_error_capi(result->result); + content_debug("result is %d", err); if (result->request_type == MEDIA_REQUEST_SCAN_PARTIAL) complete_phase = MEDIA_CONTENT_SCAN_PARTIAL_COMPLETE; @@ -1144,133 +324,114 @@ void _media_content_scan_cb_v2(media_request_result_s* result, void *user_data) complete_phase = MEDIA_CONTENT_SCAN_COMPLETE; else if (result->request_type == MEDIA_REQUEST_EXTRACT_COMPLETE) complete_phase = MEDIA_CONTENT_EXTRACT_COMPLETE; + else if (result->request_type == MEDIA_RECURSIVE_START) + complete_phase = MEDIA_CONTENT_RECURSIVE_START; if (cb_data && cb_data->callback) cb_data->callback(err, complete_phase, cb_data->user_data); else - media_content_debug("run error"); + content_debug("run error"); if ((result->request_type != MEDIA_REQUEST_SCAN_COMPLETE) && - (result->request_type != MEDIA_REQUEST_SCAN_PARTIAL)) - SAFE_FREE(cb_data); + (result->request_type != MEDIA_REQUEST_SCAN_PARTIAL) && + (result->request_type != MEDIA_RECURSIVE_START)) + g_free(cb_data); return; } #endif -static int __media_content_check_dir(const char *path) -{ - DIR *dp = NULL; - - dp = opendir(path); - if (dp == NULL) { - media_content_sec_error("path [%s]", path); - media_content_stderror("open dir fail"); - - if (errno == EACCES || errno == EPERM) - return MEDIA_CONTENT_ERROR_PERMISSION_DENIED; - else - return MEDIA_CONTENT_ERROR_INVALID_PARAMETER; - } - - closedir(dp); - - return MEDIA_CONTENT_ERROR_NONE; -} - int media_content_scan_folder(const char *path, bool is_recursive, media_scan_completed_cb callback, void *user_data) { int ret = MEDIA_CONTENT_ERROR_NONE; - bool ignore_dir = FALSE; char storage_id[MEDIA_CONTENT_UUID_SIZE+1] = {0, }; - char repl_path[MAX_QUERY_SIZE] = {0, }; - - media_content_retvm_if(!STRING_VALID(path), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid path"); - memset(repl_path, 0, sizeof(repl_path)); - ret = _media_content_replace_path(path, repl_path); - media_content_retvm_if(!STRING_VALID(repl_path), MEDIA_CONTENT_ERROR_INVALID_OPERATION, "path replacement failed"); + ms_user_storage_type_e storage_type = MS_USER_STORAGE_INTERNAL; - memset(storage_id, 0x00, sizeof(storage_id)); + content_retip_if_fail(STRING_VALID(path)); + content_retip_if_fail(callback); - ret = __media_content_check_dir(repl_path); - media_content_retvm_if(ret == MEDIA_CONTENT_ERROR_PERMISSION_DENIED, ret, "Permission Denied"); + ret = _media_content_check_dir(path); + content_retvm_if(ret == MEDIA_CONTENT_ERROR_PERMISSION_DENIED, ret, "Permission Denied"); if (ret == MEDIA_CONTENT_ERROR_NONE) { /* If directory exist check that's ignore directory or not*/ - ret = _media_util_check_ignore_dir(repl_path, &ignore_dir); - media_content_retvm_if(ignore_dir == TRUE, MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid folder path"); + content_retvm_if(_media_util_is_ignorable_dir(path), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid folder path"); } else { /* This means this folder has to be deleted */ - media_content_debug("This path doesn't exists in file system... So will be deleted it from DB"); + /* Or, it is real invalid path.. check storage type */ + ret = ms_user_get_storage_type(_content_get_uid(), path, &storage_type); + if (ret != MS_MEDIA_ERR_NONE) { + content_sec_error("ms_user_get_storage_type failed : %d (%s)", ret, path); + return _content_error_capi(ret); + } + + content_debug("This path doesn't exists in file system... So will be deleted it from DB"); + } + + ret = media_svc_get_storage_id(_content_get_db_handle(), path, storage_id, _content_get_uid()); + if (ret != MS_MEDIA_ERR_NONE) { + content_error("media_svc_get_storage_id failed : %d", ret); + return _content_error_capi(ret); } media_content_scan_cb_data *cb_data = NULL; - cb_data = (media_content_scan_cb_data *)malloc(sizeof(media_content_scan_cb_data)); - media_content_retvm_if(cb_data == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY"); + cb_data = g_new0(media_content_scan_cb_data, 1); cb_data->callback = callback; cb_data->user_data = user_data; - ret = media_svc_get_storage_id(_content_get_db_handle(), repl_path, storage_id, tzplatform_getuid(TZ_USER_NAME)); - /*FIX ME. need to check ret value?*/ - - ret = media_directory_scanning_async(repl_path, storage_id, is_recursive, _media_content_scan_cb, cb_data, tzplatform_getuid(TZ_USER_NAME)); - if (ret != MS_MEDIA_ERR_NONE) - media_content_error("media_directory_scanning_async failed : %d", ret); + ret = media_directory_scanning_async(path, storage_id, is_recursive, _media_content_scan_cb, cb_data, _content_get_uid()); + if (ret != MS_MEDIA_ERR_NONE) { + content_error("media_directory_scanning_async failed : %d", ret); + g_free(cb_data); + } - return _content_error_capi(MEDIA_REGISTER_TYPE, ret); + return _content_error_capi(ret); } -#ifdef _USE_TV_PROFILE +#ifdef _USE_TVPD_MODE int media_content_scan_folder_v2(const char *path, bool is_recursive, media_scan_completed_cb_v2 callback, void *user_data) { int ret = MEDIA_CONTENT_ERROR_NONE; - bool ignore_dir = FALSE; char storage_id[MEDIA_CONTENT_UUID_SIZE+1] = {0, }; - media_content_retvm_if(!STRING_VALID(path), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid path"); - memset(storage_id, 0x00, sizeof(storage_id)); + content_retip_if_fail(STRING_VALID(path)); + content_retip_if_fail(callback); - ret = _media_util_check_ignore_dir(path, &ignore_dir); - media_content_retvm_if(ignore_dir, MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid folder path"); + content_retvm_if(_media_util_is_ignorable_dir(path), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid folder path"); - ret = __media_content_check_dir(path); - media_content_retvm_if(ret == MEDIA_CONTENT_ERROR_PERMISSION_DENIED, ret, "Permission Denied"); + ret = _media_content_check_dir(path); + content_retvm_if(ret == MEDIA_CONTENT_ERROR_PERMISSION_DENIED, ret, "Permission Denied"); + content_retvm_if(ret == MEDIA_CONTENT_ERROR_INVALID_PARAMETER, ret, "invalid path[%s]", path); media_content_scan_cb_data_v2* cb_data = NULL; - cb_data = (media_content_scan_cb_data_v2*)malloc(sizeof(media_content_scan_cb_data_v2)); - media_content_retvm_if(cb_data == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY"); + cb_data = g_new0(media_content_scan_cb_data_v2, 1); cb_data->callback = callback; cb_data->user_data = user_data; - ret = media_svc_get_storage_id(_content_get_db_handle(), path, storage_id, tzplatform_getuid(TZ_USER_NAME)); + ret = media_svc_get_storage_id(_content_get_db_handle(), path, storage_id, _content_get_uid()); /*FIX ME. need to check ret value?*/ - ret = media_directory_scanning_async(path, storage_id, is_recursive, _media_content_scan_cb_v2, cb_data, tzplatform_getuid(TZ_USER_NAME)); + ret = media_directory_scanning_async(path, storage_id, is_recursive, _media_content_scan_cb_v2, cb_data, _content_get_uid()); if (ret != MS_MEDIA_ERR_NONE) - media_content_error("media_directory_scanning_async failed : %d", ret); + content_error("media_directory_scanning_async failed : %d", ret); - return _content_error_capi(MEDIA_REGISTER_TYPE, ret); + return _content_error_capi(ret); } #endif int media_content_cancel_scan_folder(const char *path) { int ret = MEDIA_CONTENT_ERROR_NONE; - char repl_path[MAX_QUERY_SIZE] = {0, }; - - media_content_retvm_if(!STRING_VALID(path), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid path"); - memset(repl_path, 0, sizeof(repl_path)); - ret = _media_content_replace_path(path, repl_path); - media_content_retvm_if(!STRING_VALID(repl_path), MEDIA_CONTENT_ERROR_INVALID_OPERATION, "path replacement failed"); + content_retip_if_fail(STRING_VALID(path)); - ret = media_directory_scanning_cancel(repl_path, tzplatform_getuid(TZ_USER_NAME)); + ret = media_directory_scanning_cancel(path, _content_get_uid()); if (ret != MS_MEDIA_ERR_NONE) - media_content_error("media_directory_scanning_async failed : %d", ret); + content_error("media_directory_scanning_async failed : %d", ret); - return _content_error_capi(MEDIA_REGISTER_TYPE, ret); + return _content_error_capi(ret); } void _media_content_db_update_noti_cb( @@ -1283,75 +444,19 @@ void _media_content_db_update_noti_cb( char *mime_type, void *user_data) { - int error_value = MEDIA_CONTENT_ERROR_NONE; - media_noti_cb_s *_noti_info = (media_noti_cb_s *)user_data; - if (_noti_info != NULL) { - if (_noti_info->update_noti_cb) - _noti_info->update_noti_cb(error_value, pid, item, update_type, content_type, uuid, path, mime_type, _noti_info->user_data); - } - - return; -} - -int media_content_set_db_updated_cb(media_content_db_update_cb callback, void *user_data) -{ - int ret = MEDIA_CONTENT_ERROR_NONE; - media_content_warn("DEPRECATION WARNING: media_content_set_db_updated_cb() is deprecated and will be removed from next release. Use media_content_add_db_updated_cb() instead."); - - media_content_retvm_if(callback == NULL, MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid callback"); - media_content_retvm_if(g_noti_info != NULL, MEDIA_CONTENT_ERROR_INVALID_OPERATION, "Noti callback is already set"); - - g_noti_info = (media_noti_cb_s *)calloc(1, sizeof(media_noti_cb_s)); - media_content_retvm_if(g_noti_info == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY"); - - g_noti_info->update_noti_cb = callback; - g_noti_info->user_data = user_data; - - ret = media_db_update_subscribe(_media_content_db_update_noti_cb, (void *)g_noti_info); - - return _content_error_capi(MEDIA_REGISTER_TYPE, ret); -} - -int media_content_unset_db_updated_cb(void) -{ - int ret = MEDIA_CONTENT_ERROR_NONE; - media_content_warn("DEPRECATION WARNING: media_content_unset_db_updated_cb() is deprecated and will be removed from next release. Use media_content_remove_db_updated_cb() instead."); - - SAFE_FREE(g_noti_info); - ret = media_db_update_unsubscribe(); - - return _content_error_capi(MEDIA_REGISTER_TYPE, ret); -} - -int media_content_set_db_updated_cb_v2(media_content_noti_h *noti_handle, media_content_db_update_cb callback, void *user_data) -{ - int ret = MEDIA_CONTENT_ERROR_NONE; - media_noti_cb_s *noti_info = NULL; - - if (noti_handle == NULL) { - media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER); - return MEDIA_CONTENT_ERROR_INVALID_PARAMETER; - } - - if (callback == NULL) { - media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER); - return MEDIA_CONTENT_ERROR_INVALID_PARAMETER; - } - - noti_info = (media_noti_cb_s *)calloc(1, sizeof(media_noti_cb_s)); - if (noti_info == NULL) { - media_content_error("Failed to create noti info"); - return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY; - } - - noti_info->update_noti_cb = callback; - noti_info->user_data = user_data; - - ret = media_db_update_subscribe_internal((MediaNotiHandle*)noti_handle, _media_content_db_update_noti_cb, (void *)noti_info); - - return _content_error_capi(MEDIA_REGISTER_TYPE, ret); + if (_noti_info != NULL && _noti_info->update_noti_cb) + _noti_info->update_noti_cb( + MEDIA_CONTENT_ERROR_NONE, + pid, + item, + update_type, + content_type, + uuid, + path, + mime_type, + _noti_info->user_data); } int media_content_add_db_updated_cb(media_content_db_update_cb callback, void *user_data, media_content_noti_h *noti_handle) @@ -1359,58 +464,39 @@ int media_content_add_db_updated_cb(media_content_db_update_cb callback, void *u int ret = MEDIA_CONTENT_ERROR_NONE; media_noti_cb_s *noti_info = NULL; - if (noti_handle == NULL) { - media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER); - return MEDIA_CONTENT_ERROR_INVALID_PARAMETER; - } + content_retip_if_fail(callback); + content_retip_if_fail(noti_handle); - if (callback == NULL) { - media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER); - return MEDIA_CONTENT_ERROR_INVALID_PARAMETER; - } - - noti_info = (media_noti_cb_s *)calloc(1, sizeof(media_noti_cb_s)); - if (noti_info == NULL) { - media_content_error("Failed to create noti info"); - return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY; - } + noti_info = g_new0(media_noti_cb_s, 1); noti_info->update_noti_cb = callback; noti_info->user_data = user_data; - ret = media_db_update_subscribe_internal((MediaNotiHandle*)noti_handle, _media_content_db_update_noti_cb, (void *)noti_info); - - return _content_error_capi(MEDIA_REGISTER_TYPE, ret); -} - -void __media_content_clear_user_data(void *user_data) -{ - media_noti_cb_s *noti_info = user_data; - - SAFE_FREE(noti_info); + ret = media_db_update_subscribe((MediaNotiHandle*)noti_handle, _media_content_db_update_noti_cb, (void *)noti_info); + if (ret != MS_MEDIA_ERR_NONE) + g_free(noti_info); - return; + return _content_error_capi(ret); } -int media_content_unset_db_updated_cb_v2(media_content_noti_h noti_handle) +#ifdef TIZEN_FEATURE_COMPATIBILITY +int media_content_set_db_updated_cb(media_content_db_update_cb callback, void *user_data) { - int ret = MEDIA_CONTENT_ERROR_NONE; - - ret = media_db_update_unsubscribe_internal((MediaNotiHandle)noti_handle, __media_content_clear_user_data); + content_warn("DEPRECATION WARNING: media_content_set_db_updated_cb() is removed from 5.0."); - return _content_error_capi(MEDIA_REGISTER_TYPE, ret); + return MEDIA_CONTENT_ERROR_NONE; } - +#endif int media_content_remove_db_updated_cb(media_content_noti_h noti_handle) { int ret = MEDIA_CONTENT_ERROR_NONE; - ret = media_db_update_unsubscribe_internal((MediaNotiHandle)noti_handle, __media_content_clear_user_data); + ret = media_db_update_unsubscribe((MediaNotiHandle)noti_handle); - return _content_error_capi(MEDIA_REGISTER_TYPE, ret); + return _content_error_capi(ret); } -#ifdef _USE_TV_PROFILE +#ifdef _USE_TVPD_MODE GMutex* _content_get_db_mutex(void) { return &db_mutex;