Add deprecated API to internal for web API

[platform/core/api/media-content.git] / src / media_db.c

diff --git a/src/media_db.c b/src/media_db.c
index c50e8e2..dd2ea03 100755 (executable)
--- a/src/media_db.c
+++ b/src/media_db.c
@@ -63,26 +63,8 @@ static char * __media_db_get_group_name(media_group_e group)
                return (char *) DB_FIELD_MEDIA_LATITUDE;
        case MEDIA_CONTENT_GROUP_ALTITUDE:
                return (char *) DB_FIELD_MEDIA_ALTITUDE;
-       case MEDIA_CONTENT_GROUP_BURST_IMAGE:
-               return (char *) DB_FIELD_MEDIA_BURST_ID;
        case MEDIA_CONTENT_GROUP_RATING:
                return (char *) DB_FIELD_MEDIA_RATING;
-       case MEDIA_CONTENT_GROUP_AUTHOR:
-               return (char *) DB_FIELD_MEDIA_AUTHOR;
-       case MEDIA_CONTENT_GROUP_PROVIDER:
-               return (char *) DB_FIELD_MEDIA_PROVIDER;
-       case MEDIA_CONTENT_GROUP_CONTENT_NAME:
-               return (char *) DB_FIELD_MEDIA_CONTENT_NAME;
-       case MEDIA_CONTENT_GROUP_CATEGORY:
-               return (char *) DB_FIELD_MEDIA_CATEGORY;
-       case MEDIA_CONTENT_GROUP_LOCATION_TAG:
-               return (char *) DB_FIELD_MEDIA_LOCATION_TAG;
-       case MEDIA_CONTENT_GROUP_AGE_RATING:
-               return (char *) DB_FIELD_MEDIA_AGE_RATING;
-       case MEDIA_CONTENT_GROUP_KEYWORD:
-               return (char *) DB_FIELD_MEDIA_KEYWORD;
-       case MEDIA_CONTENT_GROUP_WEATHER:
-               return (char *) DB_FIELD_MEDIA_WEATHER;
 #ifdef _USE_TVPD_MODE
        case MEDIA_CONTENT_GROUP_MODIFIED_MONTH:
                return (char *) DB_FIELD_MEDIA_MODIFIED_DATE;
@@ -334,7 +316,7 @@ int _media_db_get_group_count(filter_h filter, group_list_e group_type, int *gro
        SAFE_FREE(option_query);
        media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 
-       while (sqlite3_step(stmt) == SQLITE_ROW)
+       if (sqlite3_step(stmt) == SQLITE_ROW)
                *group_count = (int)sqlite3_column_int(stmt, 0);
 
        SQLITE3_FINALIZE(stmt);
@@ -395,7 +377,7 @@ int _media_db_get_media_group_count(media_group_e group, filter_h filter, int *g
        SAFE_FREE(option_query);
        media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 
-       while (sqlite3_step(stmt) == SQLITE_ROW)
+       if (sqlite3_step(stmt) == SQLITE_ROW)
                *group_count = (int)sqlite3_column_int(stmt, 0);
 
        SQLITE3_FINALIZE(stmt);
@@ -594,8 +576,6 @@ int _media_db_get_folder(filter_h filter, media_folder_cb callback, void *user_d
        sqlite3_stmt *stmt = NULL;
        attribute_h attr = NULL;
        filter_s *_filter = (filter_s*)filter;
-       char *tmp_path = NULL;
-       char repl_path[MAX_PATH_LEN] = {0, };
 
        attr = _content_get_alias_attirbute_handle();
        memset(select_query, 0x00, sizeof(select_query));
@@ -624,17 +604,10 @@ int _media_db_get_folder(filter_h filter, media_folder_cb callback, void *user_d
                }
 
                _folder->folder_id = g_strdup((const char *)sqlite3_column_text(stmt, 0));
-
-               tmp_path = g_strdup((const char *)sqlite3_column_text(stmt, 1));
-               _media_content_rollback_path(tmp_path, repl_path);
-               _folder->path = g_strdup(repl_path);
-               SAFE_FREE(tmp_path);
-
+               _folder->path = g_strdup((const char *)sqlite3_column_text(stmt, 1));
                _folder->name = g_strdup((const char *)sqlite3_column_text(stmt, 2));
                _folder->storage_type = (int)sqlite3_column_int(stmt, 3);
-               _folder->modified_time = (int)sqlite3_column_int(stmt, 4);
-               _folder->storage_uuid = g_strdup((const char *)sqlite3_column_text(stmt, 5));
-               _folder->folder_order = (int)sqlite3_column_int(stmt, 6);
+               _folder->storage_uuid = g_strdup((const char *)sqlite3_column_text(stmt, 4));
 
                if (callback((media_folder_h)_folder, user_data) == false) {
                        media_folder_destroy((media_folder_h) _folder);
@@ -657,8 +630,6 @@ int _media_db_get_playlist(filter_h filter, media_playlist_cb callback, void *us
        char *option_query = NULL;
        sqlite3_stmt *stmt = NULL;
        attribute_h attr = NULL;
-       char *tmp_path = NULL;
-       char repl_path[MAX_PATH_LEN] = {0, };
 
        attr = _content_get_attirbute_handle();
        memset(select_query, 0x00, sizeof(select_query));
@@ -687,17 +658,7 @@ int _media_db_get_playlist(filter_h filter, media_playlist_cb callback, void *us
 
                _playlist->playlist_id = (int)sqlite3_column_int(stmt, 0);
                _playlist->name = g_strdup((const char *)sqlite3_column_text(stmt, 1));
-
-               memset(repl_path, 0x00, sizeof(repl_path));
-               tmp_path = g_strdup((const char *)sqlite3_column_text(stmt, 2));
-               if (STRING_VALID(tmp_path)) {
-                       _media_content_rollback_path(tmp_path, repl_path);
-                       _playlist->thumbnail_path = g_strdup(repl_path);
-               } else {
-                       _playlist->thumbnail_path = NULL;
-               }
-
-               SAFE_FREE(tmp_path);
+               _playlist->thumbnail_path = g_strdup((const char *)sqlite3_column_text(stmt, 2));
 
                if (callback((media_playlist_h)_playlist, user_data) == false) {
                        media_playlist_destroy((media_playlist_h)_playlist);
@@ -979,7 +940,7 @@ int _media_db_get_group_item_count_by_id(int group_id, filter_h filter, group_li
        SAFE_FREE(option_query);
        media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 
-       while (sqlite3_step(stmt) == SQLITE_ROW)
+       if (sqlite3_step(stmt) == SQLITE_ROW)
                *item_count = (int)sqlite3_column_int(stmt, 0);
 
        SQLITE3_FINALIZE(stmt);
@@ -1091,7 +1052,7 @@ int _media_db_get_group_item_count(const char *group_name, filter_h filter, grou
        SAFE_FREE(option_query);
        media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 
-       while (sqlite3_step(stmt) == SQLITE_ROW)
+       if (sqlite3_step(stmt) == SQLITE_ROW)
                *item_count = (int)sqlite3_column_int(stmt, 0);
 
        SQLITE3_FINALIZE(stmt);
@@ -1401,7 +1362,7 @@ int _media_db_get_media_group_item_count(const char *group_name, filter_h filter
        SAFE_FREE(option_query);
        media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 
-       while (sqlite3_step(stmt) == SQLITE_ROW)
+       if (sqlite3_step(stmt) == SQLITE_ROW)
                *item_count = (int)sqlite3_column_int(stmt, 0);
 
        SQLITE3_FINALIZE(stmt);
@@ -1603,6 +1564,7 @@ typedef enum {
        MEDIA_PVR_CHANNEL_TYPE,
        MEDIA_PVR_CHANNEL_NAME,
        MEDIA_PVR_CHANNEL_NUM,
+       MEDIA_PVR_SERVICE_PROFILE,
        MEDIA_PVR_PROGRAM_TITLE,
        MEDIA_PVR_PROGRAM_NUM,
        MEDIA_PVR_PROGRAM_CRID,
@@ -1667,6 +1629,8 @@ void _media_pvr_item_get_detail(sqlite3_stmt* stmt, media_pvr_h pvr)
 
        _pvr->channel_type = (int)sqlite3_column_int(stmt, MEDIA_PVR_CHANNEL_TYPE);
 
+       _pvr->service_profile = (unsigned int)sqlite3_column_int(stmt, MEDIA_PVR_SERVICE_PROFILE);
+
        if (STRING_VALID((const char *)sqlite3_column_text(stmt, MEDIA_PVR_CHANNEL_NAME)))
                _pvr->channel_name = strdup((const char *)sqlite3_column_text(stmt, MEDIA_PVR_CHANNEL_NAME));