Remove senior mode
[platform/core/api/media-content.git] / src / media_content.c
old mode 100755 (executable)
new mode 100644 (file)
index c59daf1..8b2b3af
 */
 
 
-#include <media-thumb-error.h>
-#include <media_content.h>
 #include <media_info_private.h>
-#include <media-util.h>
+#include <media_util_private.h>
 
-
-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 = NULL;
-
-static __thread media_noti_cb_s *g_noti_info = NULL;
+static GMutex db_mutex;
+static uid_t content_g_uid = 0;
 
-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);
+sqlite3 * _content_get_db_handle(void)
+{
+       return db_handle;
+}
 
+uid_t _content_get_uid(void)
+{
+       if (content_g_uid == 0)
+               return tzplatform_getuid(TZ_USER_NAME);
+       else
+               return content_g_uid;
+}
 
-static int __media_content_create_attr_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_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_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_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_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);
+       content_retip_if_fail(select_query);
 
-       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_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);
-
-       /* 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);
+       /* 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);
 
-       /* 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);
+       } else {
+               query = sqlite3_mprintf("%s", select_query);
+       }
 
-       /* 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 = _content_get_result(query, stmt);
+       SQLITE3_SAFE_FREE(query);
 
        return ret;
 }
 
-static int __media_content_create_alias_attr_handle(void)
+int _content_get_result(char *query, sqlite3_stmt **stmt)
 {
-       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_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_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_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);
+       int err = MEDIA_CONTENT_ERROR_NONE;
 
-       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);
+       content_retip_if_fail(_content_get_db_handle());
+       content_retip_if_fail(query);
 
-       ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_KEYWORD, DB_TABLE_ALIAS_MEDIA"."MEDIA_KEYWORD);
-       media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
+       content_sec_debug("Query[%s]", query);
 
-       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);
+       err = sqlite3_prepare_v2(_content_get_db_handle(), query, strlen(query), stmt, NULL);
+       if (err != SQLITE_OK) {
+               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)
+                       return MEDIA_CONTENT_ERROR_PERMISSION_DENIED;
+               else
+                       return MEDIA_CONTENT_ERROR_DB_FAILED;
+       }
 
-       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);
+       return MEDIA_CONTENT_ERROR_NONE;
+}
 
-       /* 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);
+int _content_error_capi(int internal_error)
+{
+       if (internal_error == MS_MEDIA_ERR_NONE)
+               return MEDIA_CONTENT_ERROR_NONE;
 
-       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);
+       content_error("MS Error[%d]", internal_error);
 
-       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);
+       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;
+       case MS_MEDIA_ERR_DB_BUSY_FAIL:
+               return MEDIA_CONTENT_ERROR_DB_BUSY;
+       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;
+       case MS_MEDIA_ERR_IPC:
+               return MEDIA_CONTENT_ERROR_NETWORK;
+       case MS_MEDIA_ERR_PERMISSION_DENIED:
+               return MEDIA_CONTENT_ERROR_PERMISSION_DENIED;
+       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;
+       }
+}
 
-       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);
+int _content_query_sql(char *query_str)
+{
+       int ret = MEDIA_CONTENT_ERROR_NONE;
 
-       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);
+       /*DB will be updated by Media Server.*/
+       ret = media_db_request_update_db(query_str, _content_get_uid());
 
-       /* 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);
+       return _content_error_capi(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);
+int media_content_connect(void)
+{
+       int ret = MEDIA_CONTENT_ERROR_NONE;
 
-       /* 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);
+       g_mutex_lock(&db_mutex);
+       content_info("ref count : %d", ref_count);
 
-       /* 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);
+       if (ref_count == 0) {
+               if (db_handle == NULL) {
+                       ret = media_db_connect(&db_handle, _content_get_uid(), false);
+                       ret = _content_error_capi(ret);
+                       if (ret == MEDIA_CONTENT_ERROR_NONE)
+                               ref_count++;
+               } else {
+                       content_error("Wrong DB Connection status");
+                       ret = MEDIA_CONTENT_ERROR_DB_FAILED;
+               }
+       } else {
+               if (db_handle != NULL) {
+                       ref_count++;
+               } else {
+                       content_error("Wrong DB Handle status");
+                       ret = MEDIA_CONTENT_ERROR_DB_FAILED;
+               }
+       }
 
-       /* Album */
+       content_info("ref count changed to: %d", ref_count);
+       g_mutex_unlock(&db_mutex);
 
        return ret;
 }
 
-static int __media_content_create_attribute_handle(void)
+int media_content_connect_with_uid(uid_t uid)
 {
-       int ret = MEDIA_CONTENT_ERROR_NONE;
-
-       ret = __media_content_create_attr_handle();
-       media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
+       content_sec_debug("media_content_connect_with_uid [%d]", uid);
+       content_g_uid = uid;
 
-       ret = __media_content_create_alias_attr_handle();
-
-       return ret;
+       return media_content_connect();
 }
 
-static int __media_content_destroy_attribute_handle(void)
+int media_content_disconnect(void)
 {
-       int ret = MEDIA_CONTENT_ERROR_NONE;
+       g_mutex_lock(&db_mutex);
+       content_debug("ref count : %d", ref_count);
 
-       ret = _media_filter_attribute_destory(g_attr_handle);
-       ret = _media_filter_attribute_destory(g_alias_attr_handle);
+       if (db_handle && ref_count > 0) {
+               if (--ref_count == 0) {
+                       media_db_disconnect(db_handle);
+                       db_handle = NULL;
+               }
+       } else {
+               content_error("Database is not connected");
+               g_mutex_unlock(&db_mutex);
+               return MEDIA_CONTENT_ERROR_DB_FAILED;
+       }
 
-       g_attr_handle = NULL;
-       g_alias_attr_handle = NULL;
+       g_mutex_unlock(&db_mutex);
 
-       return ret;
-}
+       content_info("ref count changed to: %d", ref_count);
 
-attribute_h _content_get_attirbute_handle(void)
-{
-       return g_attr_handle;
+       return MEDIA_CONTENT_ERROR_NONE;
 }
 
-attribute_h _content_get_alias_attirbute_handle(void)
+int media_content_scan_file(const char *path)
 {
-       return g_alias_attr_handle;
-}
+       int ret = MEDIA_CONTENT_ERROR_NONE;
+       char *folder_path = NULL;
+       int check_file = MEDIA_CONTENT_ERROR_NONE;
+       char storage_id[MEDIA_CONTENT_UUID_SIZE+1] = {0,};
+       char repl_path[MAX_PATH_LEN] = {0,};
 
-MediaSvcHandle* _content_get_db_handle(void)
-{
-       return db_handle;
-}
+       content_retip_if_fail(STRING_VALID(path));
 
-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];
-       memset(query, '\0', sizeof(query));
+       content_sec_debug("Path : %s", path);
 
-       if(db_handle == NULL)
-       {
-               media_content_error("DB_FAILED(0x%08x) database is not connected", MEDIA_CONTENT_ERROR_DB_FAILED);
-               return MEDIA_CONTENT_ERROR_DB_FAILED;
-       }
+       ret = _media_content_replace_path(path, repl_path);
+       content_retvm_if(!STRING_VALID(repl_path), MEDIA_CONTENT_ERROR_INVALID_OPERATION, "path replacement failed");
 
-       if(STRING_VALID(select_query)) {
-               if(!STRING_VALID(condition_query)) {
-                       condition_query = " ";
-               }
+       content_retvm_if(_media_util_is_ignorable_file(repl_path), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid path");
 
-               if(!STRING_VALID(option_query)) {
-                       option_query = " ";
+       ret = media_svc_get_storage_id(_content_get_db_handle(), repl_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);
+       }
 
-               }
+       check_file = _media_util_check_file_exist(repl_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);
 
-               //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) {
-                       query[len] = '\0';
-               } else {
-                       media_content_error("snprintf failed");
+               if (_media_util_is_ignorable_dir(folder_path)) {
+                       g_free(folder_path);
                        return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
                }
 
-               media_content_info("Query : [%s]", query);
+               /* check feature */
+               content_retvm_if(!_media_util_check_support_media_type(repl_path), MEDIA_CONTENT_ERROR_NOT_SUPPORTED, "Unsupported media type");
 
-               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));
+               ms_user_storage_type_e storage_type;
 
-                       if (err == SQLITE_BUSY)
-                               return MEDIA_CONTENT_ERROR_DB_BUSY;
-                       else
-                               return MEDIA_CONTENT_ERROR_DB_FAILED;
+               ret = ms_user_get_storage_type(_content_get_uid(), repl_path, &storage_type);
+               if (ret != MS_MEDIA_ERR_NONE) {
+                       content_sec_error("ms_user_get_storage_type failed : %d (%s)", ret, repl_path);
+                       return _content_error_capi(ret);
                }
-       }
-       else
-       {
-               media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
-               return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
-       }
+               ret = media_svc_check_item_exist_by_path(_content_get_db_handle(), storage_id, repl_path);
+               if (ret == MS_MEDIA_ERR_NONE) {
+                       /* Refresh */
+                       ret = media_svc_refresh_item(_content_get_db_handle(), false, storage_id, storage_type, repl_path, _content_get_uid());
+                       if (ret != MS_MEDIA_ERR_NONE) {
+                               content_error("media_svc_refresh_item failed : %d", ret);
+                               return _content_error_capi(ret);
+                       }
 
-       return MEDIA_CONTENT_ERROR_NONE;
-}
+               } 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, _content_get_uid());
+                       if (ret != MS_MEDIA_ERR_NONE) {
+                               if (ret == MS_MEDIA_ERR_DB_CONSTRAINT_FAIL) {
+                                       content_sec_error("This item is already inserted. This may be normal operation because other process already did this (%s)", repl_path);
+                                       ret = MEDIA_CONTENT_ERROR_NONE;
+                               } else {
+                                       content_sec_error("media_svc_insert_item_immediately failed : %d (%s)", ret, repl_path);
+                               }
 
-int _content_error_capi(int type, int content_error)
-{
-       media_content_debug("[type : %d] content_error : %d ", type, content_error);
+                               return _content_error_capi(ret);
+                       }
+               } else {
+                       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) {
+               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 */
+               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, _content_get_uid());
+               if (ret != MS_MEDIA_ERR_NONE) {
+                       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;
+                       }
 
-       if(type == MEDIA_CONTENT_TYPE)
-       {
-               if(content_error == MEDIA_INFO_ERROR_NONE)
-                       return MEDIA_CONTENT_ERROR_NONE;
-               else if(content_error == MEDIA_INFO_ERROR_INVALID_PARAMETER)
-                       return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
-               else if((content_error == MEDIA_INFO_ERROR_DATABASE_CONNECT) || (content_error == MEDIA_INFO_ERROR_DATABASE_DISCONNECT) ||
-                               (content_error == MEDIA_INFO_ERROR_DATABASE_NO_RECORD) ||(content_error == MEDIA_INFO_ERROR_DATABASE_INTERNAL))
-                       return MEDIA_CONTENT_ERROR_DB_FAILED;
-               else if((content_error == MS_MEDIA_ERR_SOCKET_CONN) ||(content_error == MS_MEDIA_ERR_SOCKET_INTERNAL) ||
-                               (content_error == MS_MEDIA_ERR_SOCKET_SEND) ||(content_error == MS_MEDIA_ERR_SOCKET_RECEIVE) || (content_error == MS_MEDIA_ERR_SOCKET_RECEIVE_TIMEOUT))
-                       return MEDIA_CONTENT_ERROR_NETWORK;
-       } else if(type == MEDIA_THUMBNAIL_TYPE) {
-               if(content_error == MEDIA_THUMB_ERROR_NONE)
-                       return MEDIA_CONTENT_ERROR_NONE;
-               else if(content_error == MEDIA_THUMB_ERROR_INVALID_PARAMETER || content_error == MEDIA_THUMB_ERROR_DUPLICATED_REQUEST)
-                       return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
-               else if(content_error == MEDIA_THUMB_ERROR_DB)
-                       return MEDIA_CONTENT_ERROR_DB_FAILED;
-               else if(content_error == MEDIA_THUMB_ERROR_NETWORK)
-                       return MEDIA_CONTENT_ERROR_NETWORK;
-               else if(content_error == MEDIA_THUMB_ERROR_TIMEOUT)
-                       return MEDIA_CONTENT_ERROR_NETWORK;
-               else if(content_error == MEDIA_THUMB_ERROR_MM_UTIL)                     /* Error in mm-util lib */
-                       return MEDIA_CONTENT_ERROR_INVALID_OPERATION;
-               else if(content_error == MEDIA_THUMB_ERROR_HASHCODE)            /* Failed to generate hash code */
-                       return MEDIA_CONTENT_ERROR_INVALID_OPERATION;
-               else if(content_error == MEDIA_THUMB_ERROR_TOO_BIG)                     /* Original is too big to make thumb */
-                       return MEDIA_CONTENT_ERROR_UNSUPPORTED_CONTENT;
-               else if(content_error == MEDIA_THUMB_ERROR_UNSUPPORTED) /* Unsupported type */
-                       return MEDIA_CONTENT_ERROR_UNSUPPORTED_CONTENT;
-
-       } else if(type == MEDIA_REGISTER_TYPE) {
-               if(content_error == MS_MEDIA_ERR_NONE)
-                       return MEDIA_CONTENT_ERROR_NONE;
-               else if(content_error == MS_MEDIA_ERR_INVALID_PARAMETER || content_error == MS_MEDIA_ERR_INVALID_PATH)
-                       return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
-               else if(content_error == MS_MEDIA_ERR_DB_INSERT_FAIL || content_error == MS_MEDIA_ERR_DRM_REGISTER_FAIL)
-                       return MEDIA_CONTENT_ERROR_DB_FAILED;
-               else if(content_error == MS_MEDIA_ERR_SCANNING_BUSY)
-                       return MEDIA_CONTENT_ERROR_DB_BUSY;
-               else if(content_error == MS_MEDIA_ERR_ALLOCATE_MEMORY_FAIL)
-                       return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
-               else if(content_error == MS_MEDIA_ERR_DBUS_GET || content_error == MS_MEDIA_ERR_DBUS_ADD_FILTER)
-                       return MEDIA_CONTENT_ERROR_INVALID_OPERATION;
-               else if(content_error == MS_MEDIA_ERR_VCONF_GET_FAIL)
-                       return MEDIA_CONTENT_ERROR_INVALID_OPERATION;
+                       content_error("media_svc_delete_item_by_path failed : %d", ret);
+                       return _content_error_capi(ret);
+               }
        }
 
-       return MEDIA_CONTENT_ERROR_INVALID_OPERATION;
+       return _content_error_capi(ret);
 }
 
-int _content_query_sql(char *query_str)
+void _media_content_scan_cb(media_request_result_s* result, void *user_data)
 {
-       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));
-
-       return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
+       int err = -1;
+       media_content_scan_cb_data *cb_data = user_data;
 
-#if 0
-       int err = MEDIA_CONTENT_ERROR_NONE;
-       char *err_msg;
+       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_RECURSIVE_START) {
+               if (cb_data && cb_data->callback) {
+                       content_debug("begin:User callback is being called now, result=%d", err);
+                       cb_data->callback(err, cb_data->user_data);
+                       content_debug("end:User callback is being called now, result=%d", err);
+               }
 
-       if(db_handle == NULL)
-       {
-               media_content_error("DB_FAILED(0x%08x) database is not connected", MEDIA_CONTENT_ERROR_DB_FAILED);
-               return MEDIA_CONTENT_ERROR_DB_FAILED;
+               g_free(cb_data);
+       }
+#else
+       if (cb_data && cb_data->callback) {
+               content_debug("User callback is being called now");
+               cb_data->callback(err, cb_data->user_data);
        }
 
-       err = sqlite3_exec(db_handle, query_str, NULL, NULL, &err_msg);
-       if(SQLITE_OK != err)
-       {
-               if(err_msg)
-               {
-                       media_content_error("DB_FAILED : %s", err_msg);
-                       media_content_error("DB_FAILED SQL: %s", query_str);
-                       sqlite3_free(err_msg);
-               }
+       g_free(cb_data);
+#endif
 
-               media_content_error("DB_FAILED(0x%08x) database operation is failed", MEDIA_CONTENT_ERROR_DB_FAILED);
+       return;
+}
 
-               if (err == SQLITE_BUSY)
-                       return MEDIA_CONTENT_ERROR_DB_BUSY;
-               else
-                       return MEDIA_CONTENT_ERROR_DB_FAILED;
-       }
+#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)
+               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;
+       else if (result->request_type == MEDIA_REQUEST_SCAN_COMPLETE)
+               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_info("DB_SUCCESS: %s", query_str);
-       }
+               content_debug("run error");
 
-       if(err_msg)
-               sqlite3_free(err_msg);
+       if ((result->request_type != MEDIA_REQUEST_SCAN_COMPLETE) &&
+       (result->request_type != MEDIA_REQUEST_SCAN_PARTIAL) &&
+       (result->request_type != MEDIA_RECURSIVE_START))
+               g_free(cb_data);
 
-       return MEDIA_CONTENT_ERROR_NONE;
-#endif
+       return;
 }
+#endif
 
-int media_content_connect(void)
+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;
+       char storage_id[MEDIA_CONTENT_UUID_SIZE+1] = {0, };
+       char repl_path[MAX_PATH_LEN] = {0, };
+       ms_user_storage_type_e storage_type = MS_USER_STORAGE_INTERNAL;
 
-       if (!db_mutex)
-               db_mutex = g_mutex_new();
+       content_retip_if_fail(STRING_VALID(path));
+       content_retip_if_fail(callback);
 
-       if (db_mutex != NULL) {
-               g_mutex_lock(db_mutex);
+       ret = _media_content_replace_path(path, repl_path);
+       content_retvm_if(!STRING_VALID(repl_path), MEDIA_CONTENT_ERROR_INVALID_OPERATION, "path replacement failed");
 
-               media_content_debug("ref count : %d", ref_count);
+       ret = _media_content_check_dir(repl_path);
+       content_retvm_if(ret == MEDIA_CONTENT_ERROR_PERMISSION_DENIED, ret, "Permission Denied");
 
-               if(ref_count == 0)
-               {
-                       if(db_handle == NULL)
-                       {
-                               ret = media_svc_connect(&db_handle,tzplatform_getuid(TZ_USER_NAME));
-                       }
-
-                       ret = _content_error_capi(MEDIA_CONTENT_TYPE, ret);
-
-                       if(ret == MEDIA_CONTENT_ERROR_NONE) {
-                               ret = __media_content_create_attribute_handle();
-                       }
+       if (ret == MEDIA_CONTENT_ERROR_NONE) {
+               /* If directory exist check that's ignore directory or not*/
+               content_retvm_if(_media_util_is_ignorable_dir(repl_path), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid folder path");
+       } else {
+               /* This means this folder has to be deleted */
+               /* Or, it is real invalid path.. check storage type */
+               ret = ms_user_get_storage_type(_content_get_uid(), repl_path, &storage_type);
+               if (ret != MS_MEDIA_ERR_NONE) {
+                       content_sec_error("ms_user_get_storage_type failed : %d (%s)", ret, repl_path);
+                       return _content_error_capi(ret);
                }
 
-               ref_count++;
-               g_mutex_unlock(db_mutex);
-       } else {
-               media_content_error("mutex is NULL");
+               content_debug("This path doesn't exists in file system... So will be deleted it from DB");
        }
 
-       return ret;
-}
-
-int media_content_disconnect(void)
-{
-       int ret = MEDIA_CONTENT_ERROR_NONE;
-
-       if (db_mutex != NULL) {
-               g_mutex_lock(db_mutex);
-
-               media_content_debug("ref count : %d", ref_count);
-               if(ref_count > 0)
-               {
-                       ref_count--;
-               }
-               else
-               {
-                       media_content_error("DB_FAILED(0x%08x) database is not connected", MEDIA_CONTENT_ERROR_DB_FAILED);
-                       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;
-                               }
-                       }
+       ret = media_svc_get_storage_id(_content_get_db_handle(), repl_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);
+       }
 
-                       g_mutex_unlock(db_mutex);
-                       g_mutex_free(db_mutex);
-                       db_mutex = NULL;
+       media_content_scan_cb_data *cb_data = NULL;
+       cb_data = g_new0(media_content_scan_cb_data, 1);
 
-                       return ret;
-               }
+       cb_data->callback = callback;
+       cb_data->user_data = user_data;
 
-               g_mutex_unlock(db_mutex);
-       } else {
-               media_content_error("mutex is NULL");
+       ret = media_directory_scanning_async(repl_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 ret;
+       return _content_error_capi(ret);
 }
 
-int media_content_scan_file(const char *path)
+#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;
+       char storage_id[MEDIA_CONTENT_UUID_SIZE+1] = {0, };
 
-       if (!STRING_VALID(path)) {
-               media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
-               return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
-       }
-
-       media_content_debug("Path : %s", path);
+       content_retip_if_fail(STRING_VALID(path));
+       content_retip_if_fail(callback);
 
-       if (g_file_test(path, G_FILE_TEST_EXISTS)) {
-               if (g_file_test(path, G_FILE_TEST_IS_REGULAR)) {
-                       /* This means this path has to be inserted or refreshed */
-                       media_content_debug("This path exists in file system.");
+       content_retvm_if(_media_util_is_ignorable_dir(path), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid folder path");
 
-                       media_svc_storage_type_e storage_type;
+       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);
 
-                       ret = media_svc_get_storage_type(path, &storage_type);
-                       if (ret < 0) {
-                               media_content_error("media_svc_get_storage_type failed : %d (%s)", ret, path);
-                               return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
-                       }
-
-                       ret = media_svc_check_item_exist_by_path(_content_get_db_handle(), path);
-                       if (ret == MEDIA_INFO_ERROR_NONE) {
-                               /* Refresh */
-                               ret = media_svc_refresh_item(_content_get_db_handle(), storage_type, path, tzplatform_getuid(TZ_USER_NAME));
-                               if (ret < 0) {
-                                       media_content_error("media_svc_refresh_item failed : %d", ret);
-                                       return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
-                               }
-
-                       } else if (ret == MEDIA_INFO_ERROR_DATABASE_NO_RECORD) {
-                               /* Insert */
-                               ret = media_svc_insert_item_immediately(_content_get_db_handle(), storage_type, path, tzplatform_getuid(TZ_USER_NAME));
-                               if (ret < 0) {
-                                       media_content_error("media_svc_insert_item_immediately failed : %d", ret);
-                                       return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
-                               }
-                       } else {
-                               media_content_error("media_svc_check_item_exist_by_path failed : %d", ret);
-                               return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
-                       }
-               } else if (g_file_test(path, G_FILE_TEST_IS_DIR)) {
-                       /* Dierectory is not accpted in this function */
-                       media_content_error("This path is directory");
-                       return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
-               }
-       } 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(), path, tzplatform_getuid(TZ_USER_NAME));
-               if (ret < 0) {
-                       media_content_error("media_svc_delete_item_by_path failed : %d", ret);
-                       return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
-               }
-       }
-
-       return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
-}
-
-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;
+       media_content_scan_cb_data_v2* cb_data = NULL;
+       cb_data = g_new0(media_content_scan_cb_data_v2, 1);
 
-       err = result->result;
+       cb_data->callback = callback;
+       cb_data->user_data = user_data;
 
-       if (cb_data && cb_data->callback) {
-               media_content_debug("User callback is being called now");
-               cb_data->callback(err, cb_data->user_data);
-       }
+       ret = media_svc_get_storage_id(_content_get_db_handle(), path, storage_id, _content_get_uid());
+       /*FIX ME. need to check ret value?*/
 
-       SAFE_FREE(cb_data);
+       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)
+               content_error("media_directory_scanning_async failed : %d", ret);
 
-       return;
+       return _content_error_capi(ret);
 }
+#endif
 
-int media_content_scan_folder(const char *path, bool is_recursive, media_scan_completed_cb callback, void *user_data)
+int media_content_cancel_scan_folder(const char *path)
 {
        int ret = MEDIA_CONTENT_ERROR_NONE;
+       char repl_path[MAX_PATH_LEN] = {0, };
 
-       if (!STRING_VALID(path)) {
-               media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
-               return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
-       }
+       content_retip_if_fail(STRING_VALID(path));
 
-       media_content_scan_cb_data *cb_data = NULL;
-       cb_data = (media_content_scan_cb_data *)malloc(sizeof(media_content_scan_cb_data));
-       if (cb_data == NULL) {
-               media_content_error("malloc failed");
-               return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
-       }
+       ret = _media_content_replace_path(path, repl_path);
+       content_retvm_if(!STRING_VALID(repl_path), MEDIA_CONTENT_ERROR_INVALID_OPERATION, "path replacement failed");
 
-       cb_data->callback = callback;
-       cb_data->user_data = user_data;
-
-       ret = media_directory_scanning_async(path, is_recursive, _media_content_scan_cb, cb_data, tzplatform_getuid(TZ_USER_NAME));
-       if (ret < 0) {
-               media_content_error("media_directory_scanning_async failed : %d", ret);
-       }
+       ret = media_directory_scanning_cancel(repl_path, _content_get_uid());
+       if (ret != MS_MEDIA_ERR_NONE)
+               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(
@@ -779,44 +454,61 @@ 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;
+       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_set_db_updated_cb(media_content_db_update_cb callback, void *user_data)
+int media_content_add_db_updated_cb(media_content_db_update_cb callback, void *user_data, media_content_noti_h *noti_handle)
 {
        int ret = MEDIA_CONTENT_ERROR_NONE;
+       media_noti_cb_s *noti_info = NULL;
 
-       g_noti_info = (media_noti_cb_s*)calloc(1, sizeof(media_noti_cb_s));
-       if (g_noti_info == NULL) {
-               media_content_error("Failed to create noti info");
-               return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
-       }
+       content_retip_if_fail(callback);
+       content_retip_if_fail(noti_handle);
+
+       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((MediaNotiHandle*)noti_handle, _media_content_db_update_noti_cb, (void *)noti_info);
+       if (ret != MS_MEDIA_ERR_NONE)
+               g_free(noti_info);
 
-       g_noti_info->update_noti_cb = callback;
-       g_noti_info->user_data = user_data;
+       return _content_error_capi(ret);
+}
 
-       ret = media_db_update_subscribe(_media_content_db_update_noti_cb, (void *)g_noti_info);
+#ifdef TIZEN_FEATURE_COMPATIBILITY
+int media_content_set_db_updated_cb(media_content_db_update_cb callback, void *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_unset_db_updated_cb()
+int media_content_remove_db_updated_cb(media_content_noti_h noti_handle)
 {
        int ret = MEDIA_CONTENT_ERROR_NONE;
 
-       SAFE_FREE(g_noti_info);
-       ret = media_db_update_unsubscribe();
+       ret = media_db_update_unsubscribe((MediaNotiHandle)noti_handle);
 
-       return _content_error_capi(MEDIA_REGISTER_TYPE, ret);
+       return _content_error_capi(ret);
 }
-
+#ifdef _USE_TVPD_MODE
+GMutex* _content_get_db_mutex(void)
+{
+       return &db_mutex;
+}
+#endif