src/media_content.c

   1 /*
   2 * Copyright (c) 2011 Samsung Electronics Co., Ltd All Rights Reserved
   3 *
   4 * Licensed under the Apache License, Version 2.0 (the "License");
   5 * you may not use this file except in compliance with the License.
   6 * You may obtain a copy of the License at
   7 *
   8 * http://www.apache.org/licenses/LICENSE-2.0
   9 *
  10 * Unless required by applicable law or agreed to in writing, software
  11 * distributed under the License is distributed on an "AS IS" BASIS,
  12 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  13 * See the License for the specific language governing permissions and
  14 * limitations under the License.
  15 */
  16
  17
  18 #include <media_info_private.h>
  19 #include <media_util_private.h>
  20
  21
  22 static attribute_h g_attr_handle = NULL;
  23 static attribute_h g_alias_attr_handle = NULL;
  24 static MediaSvcHandle *db_handle = NULL;
  25 static int ref_count = 0;
  26 static GMutex db_mutex;
  27 static __thread media_noti_cb_s *g_noti_info = NULL;
  28 static uid_t content_g_uid = 0;
  29
  30 #if 0
  31 static int __media_content_create_attr_handle(void);
  32 static int __media_content_create_alias_attr_handle(void);
  33 static int __media_content_create_attribute_handle(void);
  34 #endif
  35 static int __media_content_create_attribute_handles(void);
  36 static int __media_content_destroy_attribute_handle(void);
  37
  38 typedef struct {
  39         char *user_attr;
  40         char *platform_attr;
  41         char *platform_alias_attr;
  42 } media_content_attribute_info_s;
  43
  44 static media_content_attribute_info_s g_content_attrs_info[] = {
  45         /* Media Info */
  46         {MEDIA_ID,                                              DB_FIELD_MEDIA_ID,                                              DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ID},
  47         {MEDIA_PATH,                                    DB_FIELD_MEDIA_PATH,                                    DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_PATH},
  48         {MEDIA_DISPLAY_NAME,                    DB_FIELD_MEDIA_DISPLAY_NAME,                    DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_DISPLAY_NAME},
  49         {MEDIA_TYPE,                                            DB_FIELD_MEDIA_TYPE,                                            DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_TYPE},
  50         {MEDIA_MIME_TYPE,                               DB_FIELD_MEDIA_MIME_TYPE,                               DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_MIME_TYPE},
  51         {MEDIA_SIZE,                                            DB_FIELD_MEDIA_SIZE,                                            DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_SIZE},
  52         {MEDIA_ADDED_TIME,                              DB_FIELD_MEDIA_ADDED_TIME,                              DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ADDED_TIME},
  53         {MEDIA_MODIFIED_TIME,                   DB_FIELD_MEDIA_MODIFIED_TIME,                   DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_MODIFIED_TIME},
  54         {MEDIA_TIMELINE,                                        DB_FIELD_MEDIA_TIMELINE,                                DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_TIMELINE},
  55         {MEDIA_THUMBNAIL_PATH,                  DB_FIELD_MEDIA_THUMBNAIL_PATH,                  DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_THUMBNAIL_PATH},
  56         {MEDIA_TITLE,                                   DB_FIELD_MEDIA_TITLE,                                   DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_TITLE},
  57         {MEDIA_ALBUM,                                   DB_FIELD_MEDIA_ALBUM,                                   DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ALBUM},
  58         {MEDIA_ARTIST,                                  DB_FIELD_MEDIA_ARTIST,                                  DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ARTIST},
  59         {MEDIA_ALBUM_ARTIST,                    DB_FIELD_MEDIA_ALBUM_ARTIST,                    DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ALBUM_ARTIST},
  60         {MEDIA_GENRE,                                   DB_FIELD_MEDIA_GENRE,                                   DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_GENRE},
  61         {MEDIA_COMPOSER,                                DB_FIELD_MEDIA_COMPOSER,                                DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_COMPOSER},
  62         {MEDIA_YEAR,                                    DB_FIELD_MEDIA_YEAR,                                    DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_YEAR},
  63         {MEDIA_RECORDED_DATE,                   DB_FIELD_MEDIA_RECORDED_DATE,                   DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_RECORDED_DATE},
  64         {MEDIA_COPYRIGHT,                               DB_FIELD_MEDIA_COPYRIGHT,                               DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_COPYRIGHT},
  65         {MEDIA_TRACK_NUM,                               DB_FIELD_MEDIA_TRACK_NUM,                               DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_TRACK_NUM},
  66         {MEDIA_DESCRIPTION,                             DB_FIELD_MEDIA_DESCRIPTION,                             DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_DESCRIPTION},
  67         {MEDIA_BITRATE,                                 DB_FIELD_MEDIA_BITRATE,                                 DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_BITRATE},
  68         {MEDIA_BITPERSAMPLE,                    DB_FIELD_MEDIA_BITPERSAMPLE,                    DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_BITPERSAMPLE},
  69         {MEDIA_SAMPLERATE,                              DB_FIELD_MEDIA_SAMPLERATE,                              DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_SAMPLERATE},
  70         {MEDIA_CHANNEL,                         DB_FIELD_MEDIA_CHANNEL,                         DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_CHANNEL},
  71         {MEDIA_DURATION,                                DB_FIELD_MEDIA_DURATION,                                DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_DURATION},
  72         {MEDIA_LONGITUDE,                               DB_FIELD_MEDIA_LONGITUDE,                               DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_LONGITUDE},
  73         {MEDIA_LATITUDE,                                DB_FIELD_MEDIA_LATITUDE,                                DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_LATITUDE},
  74         {MEDIA_ALTITUDE,                                DB_FIELD_MEDIA_ALTITUDE,                                DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ALTITUDE},
  75         {MEDIA_WIDTH,                                   DB_FIELD_MEDIA_WIDTH,                                   DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_WIDTH},
  76         {MEDIA_HEIGHT,                                  DB_FIELD_MEDIA_HEIGHT,                                  DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_HEIGHT},
  77         {MEDIA_DATETAKEN,                               DB_FIELD_MEDIA_DATETAKEN,                               DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_DATETAKEN},
  78         {MEDIA_ORIENTATION,                     DB_FIELD_MEDIA_ORIENTATION,                     DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ORIENTATION},
  79         {MEDIA_BURST_ID,                                DB_FIELD_MEDIA_BURST_ID,                                DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_BURST_ID},
  80         {MEDIA_PLAYED_COUNT,                    DB_FIELD_MEDIA_PLAYED_COUNT,                    DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_PLAYED_COUNT},
  81         {MEDIA_LAST_PLAYED_TIME,                DB_FIELD_MEDIA_LAST_PLAYED_TIME,                DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_LAST_PLAYED_TIME},
  82         {MEDIA_LAST_PLAYED_POSITION,    DB_FIELD_MEDIA_LAST_PLAYED_POSITION,    DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_LAST_PLAYED_POSITION},
  83         {MEDIA_RATING,                                  DB_FIELD_MEDIA_RATING,                                  DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_RATING},
  84         {MEDIA_FAVOURITE,                               DB_FIELD_MEDIA_FAVOURITE,                               DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_FAVOURITE},
  85         {MEDIA_AUTHOR,                                  DB_FIELD_MEDIA_AUTHOR,                                  DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_AUTHOR},
  86         {MEDIA_PROVIDER,                                DB_FIELD_MEDIA_PROVIDER,                                DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_PROVIDER},
  87         {MEDIA_CONTENT_NAME,                    DB_FIELD_MEDIA_CONTENT_NAME,                    DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_CONTENT_NAME},
  88         {MEDIA_CATEGORY,                                DB_FIELD_MEDIA_CATEGORY,                                DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_CATEGORY},
  89         {MEDIA_LOCATION_TAG,                    DB_FIELD_MEDIA_LOCATION_TAG,                    DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_LOCATION_TAG},
  90         {MEDIA_AGE_RATING,                              DB_FIELD_MEDIA_AGE_RATING,                              DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_AGE_RATING},
  91         {MEDIA_KEYWORD,                         DB_FIELD_MEDIA_KEYWORD,                         DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_KEYWORD},
  92         {MEDIA_WEATHER,                         DB_FIELD_MEDIA_WEATHER,                         DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_WEATHER},
  93         {MEDIA_IS_DRM,                                  DB_FIELD_MEDIA_IS_DRM,                                  DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_IS_DRM},
  94         {MEDIA_STORAGE_TYPE,                    DB_FIELD_MEDIA_STORAGE_TYPE,                    DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_STORAGE_TYPE},
  95         {MEDIA_360,                                             DB_FIELD_MEDIA_360,                                             DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_360},
  96
  97         /* Pinyin */
  98         {MEDIA_FILE_NAME_PINYIN,                DB_FIELD_MEDIA_FILE_NAME_PINYIN,                DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_FILE_NAME_PINYIN},
  99         {MEDIA_TITLE_PINYIN,                            DB_FIELD_MEDIA_TITLE_PINYIN,                            DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_TITLE_PINYIN},
 100         {MEDIA_ALBUM_PINYIN,                    DB_FIELD_MEDIA_ALBUM_PINYIN,                    DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ALBUM_PINYIN},
 101         {MEDIA_ARTIST_PINYIN,                   DB_FIELD_MEDIA_ARTIST_PINYIN,                   DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ARTIST_PINYIN},
 102         {MEDIA_ALBUM_ARTIST_PINYIN,             DB_FIELD_MEDIA_ALBUM_ARTIST_PINYIN,             DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ALBUM_ARTIST_PINYIN},
 103         {MEDIA_GENRE_PINYIN,                    DB_FIELD_MEDIA_GENRE_PINYIN,                    DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_GENRE_PINYIN},
 104         {MEDIA_COMPOSER_PINYIN,         DB_FIELD_MEDIA_COMPOSER_PINYIN,         DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_COMPOSER_PINYIN},
 105         {MEDIA_COPYRIGHT_PINYIN,                DB_FIELD_MEDIA_COPYRIGHT_PINYIN,                DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_COPYRIGHT_PINYIN},
 106         {MEDIA_DESCRIPTION_PINYIN,              DB_FIELD_MEDIA_DESCRIPTION_PINYIN,              DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_DESCRIPTION_PINYIN},
 107         {MEDIA_AUTHOR_PINYIN,                   DB_FIELD_MEDIA_AUTHOR_PINYIN,                   DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_AUTHOR_PINYIN},
 108         {MEDIA_PROVIDER_PINYIN,                 DB_FIELD_MEDIA_PROVIDER_PINYIN,                 DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_PROVIDER_PINYIN},
 109         {MEDIA_CONTENT_NAME_PINYIN,     DB_FIELD_MEDIA_CONTENT_NAME_PINYIN,     DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_CONTENT_NAME_PINYIN},
 110         {MEDIA_CATEGORY_PINYIN,                 DB_FIELD_MEDIA_CATEGORY_PINYIN,         DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_CATEGORY_PINYIN},
 111         {MEDIA_LOCATION_TAG_PINYIN,     DB_FIELD_MEDIA_LOCATION_TAG_PINYIN,     DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_LOCATION_TAG_PINYIN},
 112         {MEDIA_AGE_RATING_PINYIN,               DB_FIELD_MEDIA_AGE_RATING_PINYIN,               DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_AGE_RATING_PINYIN},
 113         {MEDIA_KEYWORD_PINYIN,                  DB_FIELD_MEDIA_KEYWORD_PINYIN,                  DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_KEYWORD_PINYIN},
 114
 115         /* Folder */
 116         {FOLDER_ID,                                             NULL,                                                                   DB_TABLE_ALIAS_FOLDER"."DB_FIELD_FOLDER_ID},
 117         {FOLDER_PATH,                                   NULL,                                                                   DB_TABLE_ALIAS_FOLDER"."DB_FIELD_FOLDER_PATH},
 118         {FOLDER_NAME,                                   NULL,                                                                   DB_TABLE_ALIAS_FOLDER"."DB_FIELD_FOLDER_NAME},
 119         {FOLDER_MODIFIED_TIME,                  NULL,                                                                   DB_TABLE_ALIAS_FOLDER"."DB_FIELD_FOLDER_MODIFIED_TIME},
 120         {FOLDER_STORAGE_TYPE,                   NULL,                                                                   DB_TABLE_ALIAS_FOLDER"."DB_FIELD_FOLDER_STORAGE_TYPE},
 121         {FOLDER_NAME_PINYIN,                    NULL,                                                                   DB_TABLE_ALIAS_FOLDER"."DB_FIELD_FOLDER_NAME_PINYIN},
 122         {FOLDER_ORDER,                                  NULL,                                                                   DB_TABLE_ALIAS_FOLDER"."DB_FIELD_FOLDER_ORDER},
 123
 124         /* Playlist */
 125         {MEDIA_PLAYLIST_ID,                             DB_FIELD_PLAYLIST_ID,                                           NULL},
 126         {PLAYLIST_NAME,                                 DB_FIELD_PLAYLIST_NAME,                                 DB_TABLE_ALIAS_PLAYLIST"."DB_FIELD_PLAYLIST_NAME},
 127         {PLAYLIST_MEMBER_ORDER,         DB_FIELD_PLAYLIST_MEMBER_ORDER,         DB_TABLE_ALIAS_PLAYLIST_MAP"."DB_FIELD_PLAYLIST_MEMBER_ORDER},
 128
 129         /* Playlist View */
 130         {PLAYLIST_MEDIA_COUNT,                  DB_FIELD_PLAYLIST_MEDIA_COUNT,                  NULL},
 131
 132         /* Tag */
 133         {MEDIA_TAG_ID,                                  DB_FIELD_TAG_ID,                                                        NULL},
 134         {TAG_NAME,                                              DB_FIELD_TAG_NAME,                                              DB_TABLE_ALIAS_TAG"."DB_FIELD_TAG_NAME},
 135
 136         /* Tag View */
 137         {TAG_MEDIA_COUNT,                               DB_FIELD_TAG_MEDIA_COUNT,                               NULL},
 138
 139         /* Bookmark */
 140         {MEDIA_BOOKMARK_ID,                     DB_FIELD_BOOKMARK_ID,                                   DB_TABLE_ALIAS_BOOKMARK"."DB_FIELD_BOOKMARK_ID},
 141         {BOOKMARK_MARKED_TIME,          DB_FIELD_BOOKMARK_MARKED_TIME,          DB_TABLE_ALIAS_BOOKMARK"."DB_FIELD_BOOKMARK_MARKED_TIME},
 142         {BOOKMARK_NAME,                         DB_FIELD_BOOKMARK_NAME,                         DB_TABLE_ALIAS_BOOKMARK"."DB_FIELD_BOOKMARK_NAME},
 143
 144         /* Storage */
 145         {MEDIA_STORAGE_ID,                              DB_FIELD_STORAGE_ID,                                    NULL},
 146         {MEDIA_STORAGE_PATH,                    DB_FIELD_STORAGE_PATH,                                  NULL},
 147
 148         /* Face */
 149         {MEDIA_FACE_ID,                                 DB_FIELD_FACE_ID,                                               DB_TABLE_ALIAS_FACE"."DB_FIELD_FACE_ID},
 150         {MEDIA_FACE_TAG,                                DB_FIELD_FACE_TAG,                                              DB_TABLE_ALIAS_FACE"."DB_FIELD_FACE_TAG},
 151
 152 #ifdef _USE_SENIOR_MODE
 153         {MEDIA_CONTACT,                         DB_FIELD_MEDIA_CONTACT,                         DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_CONTACT},
 154         {MEDIA_APP_DATA,                                DB_FIELD_MEDIA_APP_DATA,                                DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_APP_DATA},
 155 #endif
 156 #ifdef _USE_TVPD_MODE
 157         {MEDIA_FOLDER_ID,                               DB_FIELD_MEDIA_FOLDER_ID,                               DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_FOLDER_ID},
 158         {MEDIA_STITCHED_INFO,                   DB_FIELD_MEDIA_STITCHED_INFO,                   NULL},
 159         {MEDIA_MODIFIED_MONTH,          DB_FIELD_MEDIA_MODIFIED_MONTH,          NULL},
 160         {MEDIA_MODIFIED_DATE,                   DB_FIELD_MEDIA_MODIFIED_DATE,                   NULL},
 161
 162         /* PVR */
 163         {PVR_DURATION,                                  DB_FIELD_PVR_DURATION,                                  NULL},
 164         {PVR_TIME_ZONE,                                 DB_FIELD_PVR_TIME_ZONE,                                 NULL},
 165         {PVR_PTC,                                               DB_FIELD_PVR_PTC,                                               NULL},
 166         {PVR_MAJOR,                                             DB_FIELD_PVR_MAJOR,                                             NULL},
 167         {PVR_MINOR,                                             DB_FIELD_PVR_MINOR,                                             NULL},
 168         {PVR_CHANNEL_TYPE,                              DB_FIELD_PVR_CHANNEL_TYPE,                              NULL},
 169         {PVR_CHANNEL_NAME,                              DB_FIELD_PVR_CHANNEL_NAME,                      NULL},
 170         {PVR_CHANNEL_NUM,                               DB_FIELD_PVR_CHANNEL_NUM,                               NULL},
 171         {PVR_PROGRAM_TITLE,                             DB_FIELD_PVR_PROGRAM_TITLE,                             NULL},
 172         {PVR_PROGRAM_NUM,                               DB_FIELD_PVR_PROGRAM_NUM,                               NULL},
 173         {PVR_PROGRAM_CRID,                              DB_FIELD_PVR_PROGRAM_CRID,                              NULL},
 174         {PVR_GUIDANCE,                                  DB_FIELD_PVR_GUIDANCE,                                  NULL},
 175         {PVR_SYNOPSIS,                                  DB_FIELD_PVR_SYNOPSIS,                                  NULL},
 176         {PVR_GENRE,                                             DB_FIELD_PVR_GENRE,                                             NULL},
 177         {PVR_LANGUAGE,                                  DB_FIELD_PVR_LANGUAGE,                                  NULL},
 178         {PVR_EMBARGO_TIME,                              DB_FIELD_PVR_EMBARGO_TIME,                              NULL},
 179         {PVR_EXPIRY_TIME,                               DB_FIELD_PVR_EXPIRY_TIME,                               NULL},
 180         {PVR_START_TIME,                                        DB_FIELD_PVR_START_TIME,                                        NULL},
 181         {PVR_PROGRAM_START_TIME,                DB_FIELD_PVR_PROGRAM_START_TIME,                NULL},
 182         {PVR_PROGRAM_END_TIME,                  DB_FIELD_PVR_PROGRAM_END_TIME,          NULL},
 183         {PVR_PROGRAM_DATE,                              DB_FIELD_PVR_PROGRAM_DATE,                              NULL},
 184         {PVR_PARENTAL_RATING,                   DB_FIELD_PVR_PARENTAL_RATING,                   NULL},
 185         {PVR_TIMER_RECORD,                              DB_FIELD_PVR_TIMER_RECORD,                              NULL},
 186         {PVR_SERIES_RECORD,                             DB_FIELD_PVR_SERIES_RECORD,                             NULL},
 187         {PVR_HD,                                                        DB_FIELD_PVR_HD,                                                        NULL},
 188         {PVR_SUBTITLE,                                  DB_FIELD_PVR_SUBTITLE,                                  NULL},
 189         {PVR_TTX,                                               DB_FIELD_PVR_TTX,                                               NULL},
 190         {PVR_AD,                                                        DB_FIELD_PVR_AD,                                                        NULL},
 191         {PVR_TTX,                                               DB_FIELD_PVR_TTX,                                               NULL},
 192         {PVR_DATA_SERVICE,                              DB_FIELD_PVR_DATA_SERVICE,                              NULL},
 193         {PVR_CONTENT_LOCK,                              DB_FIELD_PVR_CONTENT_LOCK,                              NULL},
 194         {PVR_CONTENT_WATCH,                     DB_FIELD_PVR_CONTENT_WATCH,                     NULL},
 195         {PVR_CONTENT_HAS_AUDIO_ONLY,    DB_FIELD_PVR_HAS_AUDIO_ONLY,                    NULL},
 196         {PVR_CONTENT_IS_LOCAL_RECORD,   DB_FIELD_PVR_IS_LOCAL_RECORD,                   NULL},
 197         {PVR_CONTENT_RESOLUTION,                DB_FIELD_PVR_RESOLUTION,                                NULL},
 198         {PVR_CONTENT_ASPECTRATIO,               DB_FIELD_PVR_ASPECTRATIO,                               NULL},
 199         {PVR_MODIFIED_MONTH,                    DB_FIELD_PVR_MODIFIED_DATE,                             NULL},
 200         {PVR_MODIFIED_DATE,                             DB_FIELD_PVR_MODIFIED_DATE,                             NULL},
 201         {PVR_SPORTS_TYPE,                               DB_FIELD_PVR_SPORTS_TYPE,                               NULL},
 202         {PVR_GUIDANCE_LENGTH,                   DB_FIELD_PVR_GUIDANCE_LENGTH,                   NULL},
 203         {PVR_TVMODE,                                    DB_FIELD_PVR_TVMODE,                                    NULL},
 204         {PVR_PLAY_COUNT,                                DB_FIELD_PVR_PLAY_COUNT,                                NULL},
 205         {PVR_PRIVATE_DATA,                              DB_FIELD_PVR_PRIVATE_DATA,                              NULL},
 206
 207         /* UHD */
 208         {UHD_CONTENT_TITLE,                             DB_FIELD_UHD_CONTENT_TITLE,                             NULL},
 209         {UHD_RELEASE_DATE,                              DB_FIELD_UHD_RELEASE_DATE,                              NULL},
 210         {UHD_SUB_TYPE,                                  DB_FIELD_UHD_SUB_TYPE,                                  NULL},
 211         {UHD_FILE_NAME,                                 DB_FIELD_UHD_FILE_NAME,                                 NULL},
 212         {UHD_FOLDER_ID,                                 DB_FIELD_FOLDER_ID,                                             NULL},
 213         {UHD_PLAYED_COUNT,                              DB_FIELD_UHD_PLAYED_COUNT,                              NULL},
 214 #endif
 215 };
 216
 217 #if 0
 218 static int __media_content_create_attr_handle(void)
 219 {
 220         int ret = MEDIA_CONTENT_ERROR_NONE;
 221
 222         ret = _media_filter_attribute_create(&g_attr_handle);
 223         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 224
 225         /* Media Info */
 226         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_ID, DB_FIELD_MEDIA_ID);
 227         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 228
 229         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_PATH, DB_FIELD_MEDIA_PATH);
 230         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 231
 232         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_DISPLAY_NAME, DB_FIELD_MEDIA_DISPLAY_NAME);
 233         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 234
 235         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_TYPE, DB_FIELD_MEDIA_TYPE);
 236         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 237
 238         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_MIME_TYPE, DB_FIELD_MEDIA_MIME_TYPE);
 239         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 240
 241         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_SIZE, DB_FIELD_MEDIA_SIZE);
 242         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 243
 244         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_ADDED_TIME, DB_FIELD_MEDIA_ADDED_TIME);
 245         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 246
 247         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_MODIFIED_TIME, DB_FIELD_MEDIA_MODIFIED_TIME);
 248         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 249
 250         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_TIMELINE, DB_FIELD_MEDIA_TIMELINE);
 251         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 252
 253         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_THUMBNAIL_PATH, DB_FIELD_MEDIA_THUMBNAIL_PATH);
 254         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 255
 256         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_TITLE, DB_FIELD_MEDIA_TITLE);
 257         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 258
 259         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_ALBUM, DB_FIELD_MEDIA_ALBUM);
 260         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 261
 262         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_ARTIST, DB_FIELD_MEDIA_ARTIST);
 263         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 264
 265         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_ALBUM_ARTIST, DB_FIELD_MEDIA_ALBUM_ARTIST);
 266         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 267
 268         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_GENRE, DB_FIELD_MEDIA_GENRE);
 269         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 270
 271         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_COMPOSER, DB_FIELD_MEDIA_COMPOSER);
 272         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 273
 274         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_YEAR, DB_FIELD_MEDIA_YEAR);
 275         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 276
 277         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_RECORDED_DATE, DB_FIELD_MEDIA_RECORDED_DATE);
 278         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 279
 280         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_COPYRIGHT, DB_FIELD_MEDIA_COPYRIGHT);
 281         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 282
 283         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_TRACK_NUM, DB_FIELD_MEDIA_TRACK_NUM);
 284         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 285
 286         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_DESCRIPTION, DB_FIELD_MEDIA_DESCRIPTION);
 287         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 288
 289         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_BITRATE, DB_FIELD_MEDIA_BITRATE);
 290         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 291
 292         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_BITPERSAMPLE, DB_FIELD_MEDIA_BITPERSAMPLE);
 293         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 294
 295         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_SAMPLERATE, DB_FIELD_MEDIA_SAMPLERATE);
 296         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 297
 298         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_CHANNEL, DB_FIELD_MEDIA_CHANNEL);
 299         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 300
 301         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_DURATION, DB_FIELD_MEDIA_DURATION);
 302         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 303
 304         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_LONGITUDE, DB_FIELD_MEDIA_LONGITUDE);
 305         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 306
 307         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_LATITUDE, DB_FIELD_MEDIA_LATITUDE);
 308         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 309
 310         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_ALTITUDE, DB_FIELD_MEDIA_ALTITUDE);
 311         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 312
 313         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_WIDTH, DB_FIELD_MEDIA_WIDTH);
 314         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 315
 316         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_HEIGHT, DB_FIELD_MEDIA_HEIGHT);
 317         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 318
 319         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_DATETAKEN, DB_FIELD_MEDIA_DATETAKEN);
 320         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 321
 322         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_ORIENTATION, DB_FIELD_MEDIA_ORIENTATION);
 323         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 324
 325         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_BURST_ID, DB_FIELD_MEDIA_BURST_ID);
 326         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 327
 328         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_PLAYED_COUNT, DB_FIELD_MEDIA_PLAYED_COUNT);
 329         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 330
 331         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_LAST_PLAYED_TIME, DB_FIELD_MEDIA_LAST_PLAYED_TIME);
 332         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 333
 334         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_LAST_PLAYED_POSITION, DB_FIELD_MEDIA_LAST_PLAYED_POSITION);
 335         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 336
 337         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_RATING, DB_FIELD_MEDIA_RATING);
 338         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 339
 340         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_FAVOURITE, DB_FIELD_MEDIA_FAVOURITE);
 341         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 342
 343         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_AUTHOR, DB_FIELD_MEDIA_AUTHOR);
 344         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 345
 346         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_PROVIDER, DB_FIELD_MEDIA_PROVIDER);
 347         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 348
 349         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_CONTENT_NAME, DB_FIELD_MEDIA_CONTENT_NAME);
 350         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 351
 352         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_CATEGORY, DB_FIELD_MEDIA_CATEGORY);
 353         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 354
 355         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_LOCATION_TAG, DB_FIELD_MEDIA_LOCATION_TAG);
 356         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 357
 358         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_AGE_RATING, DB_FIELD_MEDIA_AGE_RATING);
 359         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 360
 361         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_KEYWORD, DB_FIELD_MEDIA_KEYWORD);
 362         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 363
 364         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_WEATHER, DB_FIELD_MEDIA_WEATHER);
 365         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 366
 367         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_IS_DRM, DB_FIELD_MEDIA_IS_DRM);
 368         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 369
 370         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_STORAGE_TYPE, DB_FIELD_MEDIA_STORAGE_TYPE);
 371         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 372
 373         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_360, DB_FIELD_MEDIA_360);
 374         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 375
 376         /* Pinyin*/
 377         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_FILE_NAME_PINYIN, DB_FIELD_MEDIA_FILE_NAME_PINYIN);
 378         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 379
 380         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_TITLE_PINYIN, DB_FIELD_MEDIA_TITLE_PINYIN);
 381         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 382
 383         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_ALBUM_PINYIN, DB_FIELD_MEDIA_ALBUM_PINYIN);
 384         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 385
 386         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_ARTIST_PINYIN, DB_FIELD_MEDIA_ARTIST_PINYIN);
 387         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 388
 389         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_ALBUM_ARTIST_PINYIN, DB_FIELD_MEDIA_ALBUM_ARTIST_PINYIN);
 390         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 391
 392         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_GENRE_PINYIN, DB_FIELD_MEDIA_GENRE_PINYIN);
 393         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 394
 395         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_COMPOSER_PINYIN, DB_FIELD_MEDIA_COMPOSER_PINYIN);
 396         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 397
 398         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_COPYRIGHT_PINYIN, DB_FIELD_MEDIA_COPYRIGHT_PINYIN);
 399         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 400
 401         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_DESCRIPTION_PINYIN, DB_FIELD_MEDIA_DESCRIPTION_PINYIN);
 402         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 403
 404         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_AUTHOR_PINYIN, DB_FIELD_MEDIA_AUTHOR_PINYIN);
 405         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 406
 407         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_PROVIDER_PINYIN, DB_FIELD_MEDIA_PROVIDER_PINYIN);
 408         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 409
 410         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_CONTENT_NAME_PINYIN, DB_FIELD_MEDIA_CONTENT_NAME_PINYIN);
 411         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 412
 413         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_CATEGORY_PINYIN, DB_FIELD_MEDIA_CATEGORY_PINYIN);
 414         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 415
 416         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_LOCATION_TAG_PINYIN, DB_FIELD_MEDIA_LOCATION_TAG_PINYIN);
 417         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 418
 419         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_AGE_RATING_PINYIN, DB_FIELD_MEDIA_AGE_RATING_PINYIN);
 420         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 421
 422         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_KEYWORD_PINYIN, DB_FIELD_MEDIA_KEYWORD_PINYIN);
 423         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 424
 425         /* Playlist*/
 426         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_PLAYLIST_ID, DB_FIELD_PLAYLIST_ID);
 427         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 428
 429         ret = _media_filter_attribute_add(g_attr_handle, PLAYLIST_NAME, DB_FIELD_PLAYLIST_NAME);
 430         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 431
 432         ret = _media_filter_attribute_add(g_attr_handle, PLAYLIST_MEMBER_ORDER, DB_FIELD_PLAYLIST_MEMBER_ORDER);
 433         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 434
 435         /* Playlist View */
 436         ret = _media_filter_attribute_add(g_attr_handle, PLAYLIST_MEDIA_COUNT, DB_FIELD_PLAYLIST_MEDIA_COUNT);
 437         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 438
 439         /* Tag*/
 440         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_TAG_ID, DB_FIELD_TAG_ID);
 441         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 442
 443         ret = _media_filter_attribute_add(g_attr_handle, TAG_NAME, DB_FIELD_TAG_NAME);
 444         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 445
 446         /* Tag View */
 447         ret = _media_filter_attribute_add(g_attr_handle, TAG_MEDIA_COUNT, DB_FIELD_TAG_MEDIA_COUNT);
 448         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 449
 450         /* Bookmark*/
 451         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_BOOKMARK_ID, DB_FIELD_BOOKMARK_ID);
 452         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 453
 454         ret = _media_filter_attribute_add(g_attr_handle, BOOKMARK_MARKED_TIME, DB_FIELD_BOOKMARK_MARKED_TIME);
 455         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 456
 457         ret = _media_filter_attribute_add(g_attr_handle, BOOKMARK_NAME, DB_FIELD_BOOKMARK_NAME);
 458         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 459
 460         /* Storage*/
 461         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_STORAGE_ID, DB_FIELD_STORAGE_ID);
 462         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 463
 464         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_STORAGE_PATH, DB_FIELD_STORAGE_PATH);
 465         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 466
 467         /* Face */
 468         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_FACE_TAG, DB_FIELD_FACE_TAG);
 469         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 470
 471         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_FACE_ID, DB_FIELD_FACE_ID);
 472         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 473
 474 #ifdef _USE_SENIOR_MODE
 475         if (_media_content_is_support_senior_mode()) {
 476                 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_CONTACT, DB_FIELD_MEDIA_CONTACT);
 477                 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 478
 479                 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_APP_DATA, DB_FIELD_MEDIA_APP_DATA);
 480                 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 481         }
 482 #endif
 483 #ifdef _USE_TVPD_MODE
 484         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_FOLDER_ID, DB_FIELD_MEDIA_FOLDER_ID);
 485         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 486
 487         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_STITCHED_INFO, DB_FIELD_MEDIA_STITCHED_INFO);
 488         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 489
 490         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_MODIFIED_MONTH, DB_FIELD_MEDIA_MODIFIED_MONTH);
 491         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 492
 493         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_MODIFIED_DATE, DB_FIELD_MEDIA_MODIFIED_DATE);
 494         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 495
 496         /* PVR*/
 497         ret = _media_filter_attribute_add(g_attr_handle, PVR_DURATION, DB_FIELD_PVR_DURATION);
 498         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 499
 500         ret = _media_filter_attribute_add(g_attr_handle, PVR_TIME_ZONE, DB_FIELD_PVR_TIME_ZONE);
 501         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 502
 503         ret = _media_filter_attribute_add(g_attr_handle, PVR_PTC, DB_FIELD_PVR_PTC);
 504         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 505
 506         ret = _media_filter_attribute_add(g_attr_handle, PVR_MAJOR, DB_FIELD_PVR_MAJOR);
 507         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 508
 509         ret = _media_filter_attribute_add(g_attr_handle, PVR_MINOR, DB_FIELD_PVR_MINOR);
 510         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 511
 512         ret = _media_filter_attribute_add(g_attr_handle, PVR_CHANNEL_TYPE, DB_FIELD_PVR_CHANNEL_TYPE);
 513         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 514
 515         ret = _media_filter_attribute_add(g_attr_handle, PVR_CHANNEL_NAME, DB_FIELD_PVR_CHANNEL_NAME);
 516         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 517
 518         ret = _media_filter_attribute_add(g_attr_handle, PVR_CHANNEL_NUM, DB_FIELD_PVR_CHANNEL_NUM);
 519         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 520
 521         ret = _media_filter_attribute_add(g_attr_handle, PVR_PROGRAM_TITLE, DB_FIELD_PVR_PROGRAM_TITLE);
 522         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 523
 524         ret = _media_filter_attribute_add(g_attr_handle, PVR_PROGRAM_NUM, DB_FIELD_PVR_PROGRAM_NUM);
 525         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 526
 527         ret = _media_filter_attribute_add(g_attr_handle, PVR_PROGRAM_CRID, DB_FIELD_PVR_PROGRAM_CRID);
 528         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 529
 530         ret = _media_filter_attribute_add(g_attr_handle, PVR_GUIDANCE, DB_FIELD_PVR_GUIDANCE);
 531         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 532
 533         ret = _media_filter_attribute_add(g_attr_handle, PVR_SYNOPSIS, DB_FIELD_PVR_SYNOPSIS);
 534         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 535
 536         ret = _media_filter_attribute_add(g_attr_handle, PVR_GENRE, DB_FIELD_PVR_GENRE);
 537         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 538
 539         ret = _media_filter_attribute_add(g_attr_handle, PVR_LANGUAGE, DB_FIELD_PVR_LANGUAGE);
 540         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 541
 542         ret = _media_filter_attribute_add(g_attr_handle, PVR_EMBARGO_TIME, DB_FIELD_PVR_EMBARGO_TIME);
 543         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 544
 545         ret = _media_filter_attribute_add(g_attr_handle, PVR_EXPIRY_TIME, DB_FIELD_PVR_EXPIRY_TIME);
 546         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 547
 548         ret = _media_filter_attribute_add(g_attr_handle, PVR_START_TIME, DB_FIELD_PVR_START_TIME);
 549         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 550
 551         ret = _media_filter_attribute_add(g_attr_handle, PVR_PROGRAM_START_TIME, DB_FIELD_PVR_PROGRAM_START_TIME);
 552         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 553
 554         ret = _media_filter_attribute_add(g_attr_handle, PVR_PROGRAM_END_TIME, DB_FIELD_PVR_PROGRAM_END_TIME);
 555         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 556
 557         ret = _media_filter_attribute_add(g_attr_handle, PVR_PROGRAM_DATE, DB_FIELD_PVR_PROGRAM_DATE);
 558         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 559
 560         ret = _media_filter_attribute_add(g_attr_handle, PVR_PARENTAL_RATING, DB_FIELD_PVR_PARENTAL_RATING);
 561         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 562
 563         ret = _media_filter_attribute_add(g_attr_handle, PVR_TIMER_RECORD, DB_FIELD_PVR_TIMER_RECORD);
 564         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 565
 566         ret = _media_filter_attribute_add(g_attr_handle, PVR_SERIES_RECORD, DB_FIELD_PVR_SERIES_RECORD);
 567         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 568
 569         ret = _media_filter_attribute_add(g_attr_handle, PVR_HD, DB_FIELD_PVR_HD);
 570         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 571
 572         ret = _media_filter_attribute_add(g_attr_handle, PVR_SUBTITLE, DB_FIELD_PVR_SUBTITLE);
 573         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 574
 575         ret = _media_filter_attribute_add(g_attr_handle, PVR_TTX, DB_FIELD_PVR_TTX);
 576         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 577
 578         ret = _media_filter_attribute_add(g_attr_handle, PVR_AD, DB_FIELD_PVR_AD);
 579         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 580
 581         ret = _media_filter_attribute_add(g_attr_handle, PVR_TTX, DB_FIELD_PVR_TTX);
 582         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 583
 584         ret = _media_filter_attribute_add(g_attr_handle, PVR_DATA_SERVICE, DB_FIELD_PVR_DATA_SERVICE);
 585         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 586
 587         ret = _media_filter_attribute_add(g_attr_handle, PVR_CONTENT_LOCK, DB_FIELD_PVR_CONTENT_LOCK);
 588         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 589
 590         ret = _media_filter_attribute_add(g_attr_handle, PVR_CONTENT_WATCH, DB_FIELD_PVR_CONTENT_WATCH);
 591         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 592
 593         ret = _media_filter_attribute_add(g_attr_handle, PVR_CONTENT_HAS_AUDIO_ONLY, DB_FIELD_PVR_HAS_AUDIO_ONLY);
 594         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 595
 596         ret = _media_filter_attribute_add(g_attr_handle, PVR_CONTENT_IS_LOCAL_RECORD, DB_FIELD_PVR_IS_LOCAL_RECORD);
 597         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 598
 599         ret = _media_filter_attribute_add(g_attr_handle, PVR_CONTENT_RESOLUTION, DB_FIELD_PVR_RESOLUTION);
 600         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 601
 602         ret = _media_filter_attribute_add(g_attr_handle, PVR_CONTENT_ASPECTRATIO, DB_FIELD_PVR_ASPECTRATIO);
 603         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 604
 605         ret = _media_filter_attribute_add(g_attr_handle, PVR_MODIFIED_MONTH, DB_FIELD_PVR_MODIFIED_DATE);
 606         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 607
 608         ret = _media_filter_attribute_add(g_attr_handle, PVR_MODIFIED_DATE, DB_FIELD_PVR_MODIFIED_DATE);
 609         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 610
 611         ret = _media_filter_attribute_add(g_attr_handle, PVR_SPORTS_TYPE, DB_FIELD_PVR_SPORTS_TYPE);
 612         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 613
 614         ret = _media_filter_attribute_add(g_attr_handle, PVR_GUIDANCE_LENGTH, DB_FIELD_PVR_GUIDANCE_LENGTH);
 615         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 616
 617         ret = _media_filter_attribute_add(g_attr_handle, PVR_TVMODE, DB_FIELD_PVR_TVMODE);
 618         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 619
 620         ret = _media_filter_attribute_add(g_attr_handle, PVR_PLAY_COUNT, DB_FIELD_PVR_PLAY_COUNT);
 621         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 622
 623         ret = _media_filter_attribute_add(g_attr_handle, PVR_PRIVATE_DATA, DB_FIELD_PVR_PRIVATE_DATA);
 624         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 625
 626         /* UHD*/
 627         ret = _media_filter_attribute_add(g_attr_handle, UHD_CONTENT_TITLE, DB_FIELD_UHD_CONTENT_TITLE);
 628         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 629
 630         ret = _media_filter_attribute_add(g_attr_handle, UHD_RELEASE_DATE, DB_FIELD_UHD_RELEASE_DATE);
 631         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 632
 633         ret = _media_filter_attribute_add(g_attr_handle, UHD_SUB_TYPE, DB_FIELD_UHD_SUB_TYPE);
 634         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 635
 636         ret = _media_filter_attribute_add(g_attr_handle, UHD_FILE_NAME, DB_FIELD_UHD_FILE_NAME);
 637         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 638
 639         ret = _media_filter_attribute_add(g_attr_handle, UHD_FOLDER_ID, DB_FIELD_FOLDER_ID);
 640         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 641
 642         ret = _media_filter_attribute_add(g_attr_handle, UHD_PLAYED_COUNT, DB_FIELD_UHD_PLAYED_COUNT);
 643         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 644 #endif
 645         return ret;
 646 }
 647
 648 static int __media_content_create_alias_attr_handle(void)
 649 {
 650         int ret = MEDIA_CONTENT_ERROR_NONE;
 651
 652         ret = _media_filter_attribute_create(&g_alias_attr_handle);
 653         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 654
 655         /* Media Info */
 656         ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_ID, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ID);
 657         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 658
 659         ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_PATH, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_PATH);
 660         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 661
 662         ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_DISPLAY_NAME, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_DISPLAY_NAME);
 663         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 664
 665         ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_TYPE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_TYPE);
 666         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 667
 668         ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_MIME_TYPE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_MIME_TYPE);
 669         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 670
 671         ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_SIZE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_SIZE);
 672         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 673
 674         ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_ADDED_TIME, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ADDED_TIME);
 675         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 676
 677         ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_MODIFIED_TIME, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_MODIFIED_TIME);
 678         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 679
 680         ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_TIMELINE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_TIMELINE);
 681         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 682 #ifdef _USE_TVPD_MODE
 683         ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_FOLDER_ID, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_FOLDER_ID);
 684         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 685 #endif
 686
 687         ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_THUMBNAIL_PATH, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_THUMBNAIL_PATH);
 688         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 689
 690         ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_TITLE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_TITLE);
 691         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 692
 693         ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_ALBUM, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ALBUM);
 694         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 695
 696         ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_ARTIST, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ARTIST);
 697         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 698
 699         ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_ALBUM_ARTIST, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ALBUM_ARTIST);
 700         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 701
 702         ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_GENRE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_GENRE);
 703         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 704
 705         ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_COMPOSER, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_COMPOSER);
 706         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 707
 708         ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_YEAR, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_YEAR);
 709         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 710
 711         ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_RECORDED_DATE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_RECORDED_DATE);
 712         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 713
 714         ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_COPYRIGHT, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_COPYRIGHT);
 715         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 716
 717         ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_TRACK_NUM, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_TRACK_NUM);
 718         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 719
 720         ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_DESCRIPTION, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_DESCRIPTION);
 721         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 722
 723         ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_BITRATE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_BITRATE);
 724         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 725
 726         ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_BITPERSAMPLE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_BITPERSAMPLE);
 727         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 728
 729         ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_SAMPLERATE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_SAMPLERATE);
 730         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 731
 732         ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_CHANNEL, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_CHANNEL);
 733         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 734
 735         ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_DURATION, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_DURATION);
 736         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 737
 738         ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_LONGITUDE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_LONGITUDE);
 739         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 740
 741         ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_LATITUDE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_LATITUDE);
 742         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 743
 744         ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_ALTITUDE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ALTITUDE);
 745         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 746
 747         ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_WIDTH, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_WIDTH);
 748         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 749
 750         ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_HEIGHT, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_HEIGHT);
 751         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 752
 753         ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_DATETAKEN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_DATETAKEN);
 754         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 755
 756         ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_ORIENTATION, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ORIENTATION);
 757         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 758
 759         ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_BURST_ID, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_BURST_ID);
 760         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 761
 762         ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_PLAYED_COUNT, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_PLAYED_COUNT);
 763         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 764
 765         ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_LAST_PLAYED_TIME, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_LAST_PLAYED_TIME);
 766         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 767
 768         ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_LAST_PLAYED_POSITION, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_LAST_PLAYED_POSITION);
 769         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 770
 771         ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_RATING, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_RATING);
 772         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 773
 774         ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_FAVOURITE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_FAVOURITE);
 775         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 776
 777         ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_AUTHOR, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_AUTHOR);
 778         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 779
 780         ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_PROVIDER, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_PROVIDER);
 781         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 782
 783         ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_CONTENT_NAME, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_CONTENT_NAME);
 784         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 785
 786         ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_CATEGORY, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_CATEGORY);
 787         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 788
 789         ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_LOCATION_TAG, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_LOCATION_TAG);
 790         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 791
 792         ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_AGE_RATING, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_AGE_RATING);
 793         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 794
 795         ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_KEYWORD, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_KEYWORD);
 796         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 797
 798         ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_WEATHER, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_WEATHER);
 799         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 800
 801         ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_IS_DRM, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_IS_DRM);
 802         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 803
 804         ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_STORAGE_TYPE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_STORAGE_TYPE);
 805         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 806
 807         ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_360, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_360);
 808         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 809
 810 #ifdef _USE_SENIOR_MODE
 811         if (_media_content_is_support_senior_mode()) {
 812                 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_CONTACT, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_CONTACT);
 813                 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 814
 815                 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_APP_DATA, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_APP_DATA);
 816                 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 817         }
 818 #endif
 819
 820         /* Pinyin*/
 821         ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_FILE_NAME_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_FILE_NAME_PINYIN);
 822         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 823
 824         ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_TITLE_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_TITLE_PINYIN);
 825         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 826
 827         ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_ALBUM_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ALBUM_PINYIN);
 828         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 829
 830         ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_ARTIST_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ARTIST_PINYIN);
 831         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 832
 833         ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_ALBUM_ARTIST_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ALBUM_ARTIST_PINYIN);
 834         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 835
 836         ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_GENRE_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_GENRE_PINYIN);
 837         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 838
 839         ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_COMPOSER_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_COMPOSER_PINYIN);
 840         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 841
 842         ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_COPYRIGHT_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_COPYRIGHT_PINYIN);
 843         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 844
 845         ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_DESCRIPTION_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_DESCRIPTION_PINYIN);
 846         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 847
 848         ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_AUTHOR_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_AUTHOR_PINYIN);
 849         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 850
 851         ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_PROVIDER_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_PROVIDER_PINYIN);
 852         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 853
 854         ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_CONTENT_NAME_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_CONTENT_NAME_PINYIN);
 855         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 856
 857         ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_CATEGORY_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_CATEGORY_PINYIN);
 858         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 859
 860         ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_LOCATION_TAG_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_LOCATION_TAG_PINYIN);
 861         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 862
 863         ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_AGE_RATING_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_AGE_RATING_PINYIN);
 864         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 865
 866         ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_KEYWORD_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_KEYWORD_PINYIN);
 867         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 868
 869         /* Folder */
 870         ret = _media_filter_attribute_add(g_alias_attr_handle, FOLDER_ID, DB_TABLE_ALIAS_FOLDER"."DB_FIELD_FOLDER_ID);
 871         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 872
 873         ret = _media_filter_attribute_add(g_alias_attr_handle, FOLDER_PATH, DB_TABLE_ALIAS_FOLDER"."DB_FIELD_FOLDER_PATH);
 874         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 875
 876         ret = _media_filter_attribute_add(g_alias_attr_handle, FOLDER_NAME, DB_TABLE_ALIAS_FOLDER"."DB_FIELD_FOLDER_NAME);
 877         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 878
 879         ret = _media_filter_attribute_add(g_alias_attr_handle, FOLDER_MODIFIED_TIME, DB_TABLE_ALIAS_FOLDER"."DB_FIELD_FOLDER_MODIFIED_TIME);
 880         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 881
 882         ret = _media_filter_attribute_add(g_alias_attr_handle, FOLDER_STORAGE_TYPE, DB_TABLE_ALIAS_FOLDER"."DB_FIELD_FOLDER_STORAGE_TYPE);
 883         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 884
 885         ret = _media_filter_attribute_add(g_alias_attr_handle, FOLDER_NAME_PINYIN, DB_TABLE_ALIAS_FOLDER"."DB_FIELD_FOLDER_NAME_PINYIN);
 886         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 887
 888         ret = _media_filter_attribute_add(g_alias_attr_handle, FOLDER_ORDER, DB_TABLE_ALIAS_FOLDER"."DB_FIELD_FOLDER_ORDER);
 889         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 890
 891         ret = _media_filter_attribute_add(g_alias_attr_handle, FOLDER_PARENT_FOLDER_ID, DB_TABLE_ALIAS_FOLDER"."DB_FIELD_FOLDER_PARENT_FOLDER_ID);
 892         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 893
 894         /* Playlist*/
 895         ret = _media_filter_attribute_add(g_alias_attr_handle, PLAYLIST_NAME, DB_TABLE_ALIAS_PLAYLIST"."DB_FIELD_PLAYLIST_NAME);
 896         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 897
 898         ret = _media_filter_attribute_add(g_alias_attr_handle, PLAYLIST_MEMBER_ORDER, DB_TABLE_ALIAS_PLAYLIST_MAP"."DB_FIELD_PLAYLIST_MEMBER_ORDER);
 899         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 900
 901         /* Tag*/
 902         ret = _media_filter_attribute_add(g_alias_attr_handle, TAG_NAME, DB_TABLE_ALIAS_TAG"."DB_FIELD_TAG_NAME);
 903         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 904
 905         /* Bookmark*/
 906         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_BOOKMARK_ID, DB_TABLE_ALIAS_BOOKMARK"."DB_FIELD_BOOKMARK_ID);
 907         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 908
 909         ret = _media_filter_attribute_add(g_alias_attr_handle, BOOKMARK_MARKED_TIME, DB_TABLE_ALIAS_BOOKMARK"."DB_FIELD_BOOKMARK_MARKED_TIME);
 910         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 911
 912         ret = _media_filter_attribute_add(g_alias_attr_handle, BOOKMARK_NAME, DB_TABLE_ALIAS_BOOKMARK"."DB_FIELD_BOOKMARK_NAME);
 913         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 914
 915         /* Face */
 916         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_FACE_TAG, DB_TABLE_ALIAS_FACE"."DB_FIELD_FACE_TAG);
 917         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 918
 919         ret = _media_filter_attribute_add(g_attr_handle, MEDIA_FACE_ID, DB_TABLE_ALIAS_FACE"."DB_FIELD_FACE_ID);
 920         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 921
 922         return ret;
 923 }
 924
 925 static int __media_content_create_attribute_handle(void)
 926 {
 927         int ret = MEDIA_CONTENT_ERROR_NONE;
 928
 929         ret = __media_content_create_attr_handle();
 930         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 931
 932         ret = __media_content_create_alias_attr_handle();
 933         if (ret != MEDIA_CONTENT_ERROR_NONE)
 934                 _media_filter_attribute_destory(g_attr_handle);
 935
 936         return ret;
 937 }
 938 #endif
 939
 940 static int __media_content_create_attribute_handles(void)
 941 {
 942         int ret = MEDIA_CONTENT_ERROR_NONE;
 943         int idx = 0;
 944         int count = 0;
 945         char *_attr_user = NULL;
 946         char *_attr_platform = NULL;
 947         char *_alias_attr_user = NULL;
 948         char *_alias_attr_platform = NULL;
 949
 950         ret = _media_filter_attribute_create(&g_attr_handle);
 951         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 952
 953         ret = _media_filter_attribute_create(&g_alias_attr_handle);
 954         if (ret != MEDIA_CONTENT_ERROR_NONE)
 955                 goto ERROR;
 956
 957         attribute_s *_attr = (attribute_s*)g_attr_handle;
 958         attribute_s *_alias_attr = (attribute_s*)g_alias_attr_handle;
 959
 960         count = sizeof(g_content_attrs_info) / sizeof((g_content_attrs_info)[0]);
 961
 962         for (idx = 0; idx < count; idx++) {
 963                 _attr_user = NULL;
 964                 _attr_platform = NULL;
 965                 _alias_attr_user = NULL;
 966                 _alias_attr_platform = NULL;
 967
 968                 if (STRING_VALID(g_content_attrs_info[idx].user_attr)) {
 969                         /*attribute*/
 970                         if (STRING_VALID(g_content_attrs_info[idx].platform_attr)) {
 971                                 _attr_user = g_strdup(g_content_attrs_info[idx].user_attr);
 972                                 _attr_platform = g_strdup(g_content_attrs_info[idx].platform_attr);
 973
 974                                 if (_attr_user == NULL || _attr_platform == NULL) {
 975                                         SAFE_G_FREE(_attr_user);
 976                                         SAFE_G_FREE(_attr_platform);
 977                                         media_content_error("OUT_OF_MEMORY(0x%08x)", MEDIA_CONTENT_ERROR_OUT_OF_MEMORY);
 978                                         ret = MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
 979                                         goto ERROR;
 980                                 }
 981
 982                                 g_hash_table_insert(_attr->attr_map, _attr_user, _attr_platform);
 983
 984                         }
 985
 986                         /*alias attribute*/
 987                         if (STRING_VALID(g_content_attrs_info[idx].platform_alias_attr)) {
 988                                 _alias_attr_user = g_strdup(g_content_attrs_info[idx].user_attr);
 989                                 _alias_attr_platform = g_strdup(g_content_attrs_info[idx].platform_alias_attr);
 990
 991                                 if (_alias_attr_user == NULL || _alias_attr_platform == NULL) {
 992                                         SAFE_G_FREE(_alias_attr_user);
 993                                         SAFE_G_FREE(_alias_attr_platform);
 994                                         media_content_error("OUT_OF_MEMORY(0x%08x)", MEDIA_CONTENT_ERROR_OUT_OF_MEMORY);
 995                                         ret = MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
 996                                         goto ERROR;
 997                                 }
 998
 999                                 g_hash_table_insert(_alias_attr->attr_map, _alias_attr_user, _alias_attr_platform);
1000                         }
1001                 } else {
1002                         media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
1003                         ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
1004                         goto ERROR;
1005                 }
1006         }
1007
1008         return ret;
1009
1010 ERROR:
1011         media_content_error("Fail media_content_create_attribute_handles");
1012         __media_content_destroy_attribute_handle();
1013
1014         return ret;
1015 }
1016
1017 static int __media_content_destroy_attribute_handle(void)
1018 {
1019         int ret = MEDIA_CONTENT_ERROR_NONE;
1020
1021         ret = _media_filter_attribute_destory(g_attr_handle);
1022         ret = _media_filter_attribute_destory(g_alias_attr_handle);
1023
1024         g_attr_handle = NULL;
1025         g_alias_attr_handle = NULL;
1026
1027         return ret;
1028 }
1029
1030 attribute_h _content_get_attirbute_handle(void)
1031 {
1032         return g_attr_handle;
1033 }
1034
1035 attribute_h _content_get_alias_attirbute_handle(void)
1036 {
1037         return g_alias_attr_handle;
1038 }
1039
1040 MediaSvcHandle* _content_get_db_handle(void)
1041 {
1042         return db_handle;
1043 }
1044
1045 uid_t _content_get_uid(void)
1046 {
1047         if (content_g_uid == 0)
1048                 return tzplatform_getuid(TZ_USER_NAME);
1049         else
1050                 return content_g_uid;
1051 }
1052
1053 int _content_query_prepare(sqlite3_stmt **stmt, char *select_query, char *condition_query, char *option_query)
1054 {
1055         int len = 0;
1056         int err = MEDIA_CONTENT_ERROR_NONE;
1057         char query[MAX_QUERY_SIZE] = {0, };
1058         memset(query, '\0', sizeof(query));
1059
1060         media_content_retvm_if(db_handle == NULL, MEDIA_CONTENT_ERROR_DB_FAILED, "database is not connected");
1061         media_content_retvm_if(!STRING_VALID(select_query), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "invalid select_query");
1062
1063         if (!STRING_VALID(condition_query))
1064                 condition_query = (char *)" ";
1065
1066         if (!STRING_VALID(option_query))
1067                 option_query = (char *)" ";
1068
1069         /*query = sqlite3_mprintf("%s %s %s", select_query, condition_query, option_query);*/
1070         len = snprintf(query, sizeof(query), "%s %s %s", select_query, condition_query, option_query);
1071         if (len > 0 && len < sizeof(query))
1072                 query[len] = '\0';
1073         else if (len >= sizeof(query))
1074                 query[MAX_QUERY_SIZE -1] = '\0';
1075         else {
1076                 media_content_error("snprintf failed");
1077                 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
1078         }
1079
1080         media_content_sec_debug("Query : [%s]", query);
1081
1082         err = sqlite3_prepare_v2((sqlite3*)db_handle, query, strlen(query), stmt, NULL);
1083         if (err != SQLITE_OK) {
1084                 media_content_error("DB_FAILED(0x%08x) fail to sqlite3_prepare(), %s", MEDIA_CONTENT_ERROR_DB_FAILED, sqlite3_errmsg((sqlite3*)db_handle));
1085
1086                 if (err == SQLITE_BUSY) {
1087                         media_content_error(" BUSY ERROR");
1088                         return MEDIA_CONTENT_ERROR_DB_BUSY;
1089                 } else if (err == SQLITE_PERM) {
1090                         media_content_error("PERMISSION EROR");
1091                         return MEDIA_CONTENT_ERROR_PERMISSION_DENIED;
1092                 } else {
1093                         media_content_error("OTHER ERROR");
1094                         return MEDIA_CONTENT_ERROR_DB_FAILED;
1095                 }
1096         }
1097
1098         return MEDIA_CONTENT_ERROR_NONE;
1099 }
1100
1101 #ifdef _USE_SENIOR_MODE
1102 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)
1103 {
1104         int len = 0;
1105         int err = MEDIA_CONTENT_ERROR_NONE;
1106         char query[MAX_QUERY_SIZE] = {0, };
1107         memset(query, '\0', sizeof(query));
1108
1109         media_content_retvm_if(db_handle == NULL, MEDIA_CONTENT_ERROR_DB_FAILED, "database is not connected");
1110         media_content_retvm_if(!STRING_VALID(select_query1), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "invalid select_query1");
1111         media_content_retvm_if(!STRING_VALID(select_query2), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "invalid select_query2");
1112
1113         if (!STRING_VALID(condition_query1))
1114                 condition_query1 = (char *)" ";
1115
1116         if (!STRING_VALID(option_query1))
1117                 option_query1 = (char *)" ";
1118
1119         if (!STRING_VALID(condition_query2))
1120                 condition_query2 = (char *)" ";
1121
1122         if (!STRING_VALID(option_query2))
1123                 option_query2 = (char *)" ";
1124
1125         len = snprintf(query, sizeof(query), "SELECT * FROM (%s %s %s) as table1 UNION ALL SELECT * FROM (%s %s %s) as table2",
1126                         select_query1, condition_query1, option_query1, select_query2, condition_query2, option_query2);
1127         if (len > 0 && len < sizeof(query)) {
1128                 query[len] = '\0';
1129         } else if (len >= sizeof(query)) {
1130                 query[MAX_QUERY_SIZE -1] = '\0';
1131         } else {
1132                 media_content_error("snprintf failed");
1133                 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
1134         }
1135
1136         media_content_sec_debug("Query : [%s]", query);
1137
1138         err = sqlite3_prepare_v2((sqlite3*)db_handle, query, strlen(query), stmt, NULL);
1139         if (err != SQLITE_OK) {
1140                 media_content_error("DB_FAILED(0x%08x) fail to sqlite3_prepare(), %s", MEDIA_CONTENT_ERROR_DB_FAILED, sqlite3_errmsg((sqlite3*)db_handle));
1141
1142                 if (err == SQLITE_BUSY) {
1143                         media_content_error(" BUSY ERROR");
1144                         return MEDIA_CONTENT_ERROR_DB_BUSY;
1145                 } else if (err == SQLITE_PERM) {
1146                         media_content_error("PERMISSION EROR");
1147                         return MEDIA_CONTENT_ERROR_PERMISSION_DENIED;
1148                 } else {
1149                         media_content_error("OTHER ERROR");
1150                         return MEDIA_CONTENT_ERROR_DB_FAILED;
1151                 }
1152         }
1153
1154         return MEDIA_CONTENT_ERROR_NONE;
1155 }
1156 #endif
1157
1158 int _content_error_capi(int type, int content_error)
1159 {
1160         if (content_error != MEDIA_CONTENT_ERROR_NONE)
1161                 media_content_error("[type : %d] content_error : %d ", type, content_error);
1162
1163         /*Error None*/
1164         if (content_error == MS_MEDIA_ERR_NONE)
1165                 return MEDIA_CONTENT_ERROR_NONE;
1166
1167         /* Internal operation error*/
1168         else if ((content_error == MS_MEDIA_ERR_INVALID_PARAMETER) ||
1169                 (content_error == MS_MEDIA_ERR_INVALID_PATH) ||
1170                 (content_error == MS_MEDIA_ERR_THUMB_DUPLICATED_REQUEST))
1171                 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
1172
1173         else if (content_error == MS_MEDIA_ERR_OUT_OF_MEMORY)
1174                 return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
1175
1176         /* DB operation error*/
1177         else if (content_error == MS_MEDIA_ERR_DB_BUSY_FAIL)
1178                 return MEDIA_CONTENT_ERROR_DB_BUSY;
1179
1180         else if ((content_error <= MS_MEDIA_ERR_DB_CONNECT_FAIL) && (content_error >= MS_MEDIA_ERR_DB_INTERNAL))
1181                 return MEDIA_CONTENT_ERROR_DB_FAILED;
1182
1183         /* IPC operation error*/
1184         else if ((content_error <= MS_MEDIA_ERR_SOCKET_CONN) && (content_error >= MS_MEDIA_ERR_SOCKET_INTERNAL))
1185                 return MEDIA_CONTENT_ERROR_NETWORK;
1186
1187         /* MEDIA SERVER error*/
1188         else if (content_error == MS_MEDIA_ERR_PERMISSION_DENIED)
1189                 return MEDIA_CONTENT_ERROR_PERMISSION_DENIED;
1190
1191         /* Thumbnail error*/
1192         else if ((content_error == MS_MEDIA_ERR_THUMB_TOO_BIG) || (content_error == MS_MEDIA_ERR_THUMB_UNSUPPORTED))
1193                         return MEDIA_CONTENT_ERROR_UNSUPPORTED_CONTENT;
1194
1195         /*ETC*/
1196         return MEDIA_CONTENT_ERROR_INVALID_OPERATION;
1197 }
1198
1199 int _content_query_sql(char *query_str)
1200 {
1201         int ret = MEDIA_CONTENT_ERROR_NONE;
1202
1203         /*DB will be updated by Media Server.*/
1204         ret = media_svc_request_update_db(query_str, _content_get_uid());
1205
1206         return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
1207 }
1208
1209 int media_content_connect(void)
1210 {
1211         int ret = MEDIA_CONTENT_ERROR_NONE;
1212
1213         g_mutex_lock(&db_mutex);
1214         media_content_info("ref count : %d", ref_count);
1215
1216         if (ref_count == 0) {
1217                 if (db_handle == NULL) {
1218                         ret = __media_content_create_attribute_handles();
1219                         if (ret == MEDIA_CONTENT_ERROR_NONE) {
1220                                 ret = media_svc_connect(&db_handle, _content_get_uid(), false);
1221                                 ret = _content_error_capi(MEDIA_CONTENT_TYPE, ret);
1222                                 if (ret == MEDIA_CONTENT_ERROR_NONE)
1223                                         ref_count++;
1224                                 else
1225                                         __media_content_destroy_attribute_handle();
1226
1227                         } else {
1228                                 media_content_error("Internal DB Connection Error");
1229                         }
1230                 } else {
1231                         media_content_error("Wrong DB Connection status");
1232                         ret = MEDIA_CONTENT_ERROR_DB_FAILED;
1233                 }
1234         } else {
1235                 if (db_handle != NULL) {
1236                         ref_count++;
1237                 } else {
1238                         media_content_error("Wrong DB Handle status");
1239                         ret = MEDIA_CONTENT_ERROR_DB_FAILED;
1240                 }
1241         }
1242
1243         media_content_info("ref count changed to: %d", ref_count);
1244         g_mutex_unlock(&db_mutex);
1245
1246         return ret;
1247 }
1248
1249 int media_content_connect_with_uid(uid_t uid)
1250 {
1251         media_content_sec_debug("media_content_connect_with_uid [%d]", uid);
1252         content_g_uid = uid;
1253
1254         return media_content_connect();
1255 }
1256
1257 int media_content_disconnect(void)
1258 {
1259         int ret = MEDIA_CONTENT_ERROR_NONE;
1260
1261         g_mutex_lock(&db_mutex);
1262         media_content_debug("ref count : %d", ref_count);
1263         if (ref_count > 0) {
1264                 if (db_handle != NULL) {
1265                         ref_count--;
1266                 } else {
1267                         media_content_error("Wrong DB Handle status");
1268                         ret = MEDIA_CONTENT_ERROR_DB_FAILED;
1269                 }
1270         } else {
1271                 media_content_error("DB_FAILED(0x%08x) database is not connected", MEDIA_CONTENT_ERROR_DB_FAILED);
1272                 g_mutex_unlock(&db_mutex);
1273                 return MEDIA_CONTENT_ERROR_DB_FAILED;
1274         }
1275
1276         if (ref_count == 0) {
1277                 if (db_handle != NULL) {
1278                         ret = media_svc_disconnect(db_handle);
1279                         ret = _content_error_capi(MEDIA_CONTENT_TYPE, ret);
1280                         if (ret == MEDIA_CONTENT_ERROR_NONE) {
1281                                 ret = __media_content_destroy_attribute_handle();
1282                                 db_handle = NULL;
1283                         } else {
1284                                 media_content_error("database disconnect fail");
1285                                 ref_count++;
1286                         }
1287                 } else {
1288                         media_content_error("Wrong DB Handle status");
1289                         ret = MEDIA_CONTENT_ERROR_DB_FAILED;
1290                 }
1291
1292                 g_mutex_unlock(&db_mutex);
1293
1294                 media_content_info("ref count changed to: %d", ref_count);
1295
1296                 return ret;
1297         }
1298
1299         g_mutex_unlock(&db_mutex);
1300
1301         media_content_info("ref count changed to: %d", ref_count);
1302
1303         return ret;
1304 }
1305
1306 int media_content_scan_file(const char *path)
1307 {
1308         int ret = MEDIA_CONTENT_ERROR_NONE;
1309         bool ignore_file = FALSE;
1310         bool ignore_dir = FALSE;
1311         char *folder_path = NULL;
1312         int check_file = MEDIA_CONTENT_ERROR_NONE;
1313         char storage_id[MEDIA_CONTENT_UUID_SIZE+1] = {0,};
1314         char repl_path[MAX_PATH_LEN] = {0,};
1315
1316         media_content_retvm_if(!STRING_VALID(path), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "invalid path");
1317
1318         media_content_sec_debug("Path : %s", path);
1319         memset(repl_path, 0, sizeof(repl_path));
1320         ret = _media_content_replace_path(path, repl_path);
1321         media_content_retvm_if(!STRING_VALID(repl_path), MEDIA_CONTENT_ERROR_INVALID_OPERATION, "path replacement failed");
1322
1323         ret = _media_util_check_ignore_file(repl_path, &ignore_file);
1324         media_content_retvm_if(ignore_file == TRUE, MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid path");
1325
1326         memset(storage_id, 0x00, sizeof(storage_id));
1327         ret = media_svc_get_storage_id(_content_get_db_handle(), repl_path, storage_id, _content_get_uid());
1328         if (ret != MS_MEDIA_ERR_NONE) {
1329                 media_content_error("media_svc_get_storage_id failed : %d", ret);
1330                 return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
1331         }
1332
1333         check_file = _media_util_check_file_exist(repl_path);
1334         if (check_file == MEDIA_CONTENT_ERROR_NONE) {
1335                 /* This means this path has to be inserted or refreshed */
1336                 folder_path = g_path_get_dirname(repl_path);
1337                 ret = _media_util_check_ignore_dir(folder_path, &ignore_dir);
1338                 SAFE_FREE(folder_path);
1339
1340                 media_content_retvm_if(ignore_dir == TRUE, MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid folder path");
1341
1342                 media_svc_storage_type_e storage_type;
1343
1344                 ret = media_svc_get_storage_type(repl_path, &storage_type, _content_get_uid());
1345                 if (ret != MS_MEDIA_ERR_NONE) {
1346                         media_content_sec_error("media_svc_get_storage_type failed : %d (%s)", ret, repl_path);
1347                         return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
1348                 }
1349                 ret = media_svc_check_item_exist_by_path(_content_get_db_handle(), storage_id, repl_path);
1350                 if (ret == MS_MEDIA_ERR_NONE) {
1351                         /* Refresh */
1352                         ret = media_svc_refresh_item(_content_get_db_handle(), storage_id, storage_type, repl_path, _content_get_uid());
1353                         if (ret != MS_MEDIA_ERR_NONE) {
1354                                 media_content_error("media_svc_refresh_item failed : %d", ret);
1355                                 return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
1356                         }
1357
1358                 } else if (ret == MS_MEDIA_ERR_DB_NO_RECORD) {
1359                         /* Insert */
1360                         ret = media_svc_insert_item_immediately(_content_get_db_handle(), storage_id, storage_type, repl_path, _content_get_uid());
1361                         if (ret != MS_MEDIA_ERR_NONE) {
1362                                 if (ret == MS_MEDIA_ERR_DB_CONSTRAINT_FAIL) {
1363                                         media_content_sec_error("This item is already inserted. This may be normal operation because other process already did this (%s)", repl_path);
1364                                         ret = MEDIA_CONTENT_ERROR_NONE;
1365                                 } else {
1366                                         media_content_sec_error("media_svc_insert_item_immediately failed : %d (%s)", ret, repl_path);
1367                                 }
1368
1369                                 return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
1370                         }
1371                 } else {
1372                         media_content_error("media_svc_check_item_exist_by_path failed : %d", ret);
1373                         return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
1374                 }
1375         } else if (check_file == MEDIA_CONTENT_ERROR_PERMISSION_DENIED) {
1376                 media_content_error("You have no permission for this file %d", ret);
1377                 return MEDIA_CONTENT_ERROR_PERMISSION_DENIED;
1378         } else {
1379                 /* This means this path has to be deleted */
1380                 media_content_debug("This path doesn't exists in file system... So now start to delete it from DB");
1381                 ret = media_svc_delete_item_by_path(_content_get_db_handle(), storage_id, repl_path, _content_get_uid());
1382                 if (ret != MS_MEDIA_ERR_NONE) {
1383                         if (ret == MS_MEDIA_ERR_DB_NO_RECORD) {
1384                                 media_content_error("Does not exist in media DB also... So, this is an invalid parameter");
1385                                 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
1386                         }
1387
1388                         media_content_error("media_svc_delete_item_by_path failed : %d", ret);
1389                         return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
1390                 }
1391         }
1392
1393         return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
1394 }
1395
1396 void _media_content_scan_cb(media_request_result_s* result, void *user_data)
1397 {
1398         int err = -1;
1399         media_content_scan_cb_data *cb_data = user_data;
1400
1401         err = _content_error_capi(MEDIA_REGISTER_TYPE, result->result);
1402 #ifdef _USE_TVPD_MODE
1403         if (result->request_type != MEDIA_REQUEST_SCAN_COMPLETE &&
1404                 result->request_type != MEDIA_REQUEST_SCAN_PARTIAL) {
1405                 if (cb_data && cb_data->callback) {
1406                         media_content_debug("begin:User callback is being called now, result=%d", err);
1407                         cb_data->callback(err, cb_data->user_data);
1408                         media_content_debug("end:User callback is being called now, result=%d", err);
1409                 }
1410
1411                 SAFE_FREE(cb_data);
1412         }
1413 #else
1414         if (cb_data && cb_data->callback) {
1415                 media_content_debug("User callback is being called now");
1416                 cb_data->callback(err, cb_data->user_data);
1417         }
1418
1419         SAFE_FREE(cb_data);
1420 #endif
1421
1422         return;
1423 }
1424
1425 #ifdef _USE_TVPD_MODE
1426 void _media_content_scan_cb_v2(media_request_result_s* result, void *user_data)
1427 {
1428         int err = -1;
1429         media_content_scan_cb_data_v2 *cb_data = user_data;
1430         media_content_complete_phase_e complete_phase = -1;
1431         if (!cb_data)
1432                 media_content_debug("cb_data is NULL");
1433         err = _content_error_capi(MEDIA_REGISTER_TYPE, result->result);
1434         media_content_debug("result is %d", err);
1435
1436         if (result->request_type == MEDIA_REQUEST_SCAN_PARTIAL)
1437                 complete_phase = MEDIA_CONTENT_SCAN_PARTIAL_COMPLETE;
1438         else if (result->request_type == MEDIA_REQUEST_SCAN_COMPLETE)
1439                 complete_phase = MEDIA_CONTENT_SCAN_COMPLETE;
1440         else if (result->request_type == MEDIA_REQUEST_EXTRACT_COMPLETE)
1441                 complete_phase = MEDIA_CONTENT_EXTRACT_COMPLETE;
1442
1443         if (cb_data && cb_data->callback)
1444                 cb_data->callback(err, complete_phase, cb_data->user_data);
1445         else
1446                 media_content_debug("run error");
1447
1448         if ((result->request_type != MEDIA_REQUEST_SCAN_COMPLETE) &&
1449         (result->request_type != MEDIA_REQUEST_SCAN_PARTIAL))
1450                 SAFE_FREE(cb_data);
1451
1452         return;
1453 }
1454 #endif
1455
1456 static int __media_content_check_dir(const char *path)
1457 {
1458         DIR *dp = NULL;
1459
1460         dp = opendir(path);
1461         if (dp == NULL) {
1462                 media_content_sec_error("path [%s]", path);
1463                 media_content_stderror("open dir fail");
1464
1465                 if (errno == EACCES || errno == EPERM)
1466                         return MEDIA_CONTENT_ERROR_PERMISSION_DENIED;
1467                 else
1468                         return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
1469         }
1470
1471         closedir(dp);
1472
1473         return MEDIA_CONTENT_ERROR_NONE;
1474 }
1475
1476 int media_content_scan_folder(const char *path, bool is_recursive, media_scan_completed_cb callback, void *user_data)
1477 {
1478         int ret = MEDIA_CONTENT_ERROR_NONE;
1479         bool ignore_dir = FALSE;
1480         char storage_id[MEDIA_CONTENT_UUID_SIZE+1] = {0, };
1481         char repl_path[MAX_PATH_LEN] = {0, };
1482         media_svc_storage_type_e storage_type = MEDIA_SVC_STORAGE_MAX;
1483
1484         media_content_retvm_if(!STRING_VALID(path), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid path");
1485         memset(repl_path, 0, sizeof(repl_path));
1486         ret = _media_content_replace_path(path, repl_path);
1487         media_content_retvm_if(!STRING_VALID(repl_path), MEDIA_CONTENT_ERROR_INVALID_OPERATION, "path replacement failed");
1488
1489         memset(storage_id, 0x00, sizeof(storage_id));
1490
1491         ret = __media_content_check_dir(repl_path);
1492         media_content_retvm_if(ret == MEDIA_CONTENT_ERROR_PERMISSION_DENIED, ret, "Permission Denied");
1493
1494         if (ret == MEDIA_CONTENT_ERROR_NONE) {
1495                 /* If directory exist check that's ignore directory or not*/
1496         ret = _media_util_check_ignore_dir(repl_path, &ignore_dir);
1497                 media_content_retvm_if(ignore_dir == TRUE, MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid folder path");
1498         } else {
1499                 /* This means this folder has to be deleted */
1500                 /* Or, it is real invalid path.. check storage type */
1501                 ret = media_svc_get_storage_type(repl_path, &storage_type, _content_get_uid());
1502                 if (ret != MS_MEDIA_ERR_NONE) {
1503                         media_content_sec_error("media_svc_get_storage_type failed : %d (%s)", ret, repl_path);
1504                         return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
1505                 }
1506
1507                 media_content_debug("This path doesn't exists in file system... So will be deleted it from DB");
1508         }
1509
1510         ret = media_svc_get_storage_id(_content_get_db_handle(), repl_path, storage_id, _content_get_uid());
1511         if (ret != MS_MEDIA_ERR_NONE) {
1512                 media_content_error("media_svc_get_storage_id failed : %d", ret);
1513                 return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
1514         }
1515
1516         media_content_scan_cb_data *cb_data = NULL;
1517         cb_data = (media_content_scan_cb_data *)malloc(sizeof(media_content_scan_cb_data));
1518         media_content_retvm_if(cb_data == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY");
1519
1520         cb_data->callback = callback;
1521         cb_data->user_data = user_data;
1522
1523         ret = media_directory_scanning_async(repl_path, storage_id, is_recursive, _media_content_scan_cb, cb_data, _content_get_uid());
1524         if (ret != MS_MEDIA_ERR_NONE) {
1525                 media_content_error("media_directory_scanning_async failed : %d", ret);
1526                 SAFE_FREE(cb_data);
1527         }
1528
1529         return _content_error_capi(MEDIA_REGISTER_TYPE, ret);
1530 }
1531
1532 #ifdef _USE_TVPD_MODE
1533 int media_content_scan_folder_v2(const char *path, bool is_recursive, media_scan_completed_cb_v2 callback, void *user_data)
1534 {
1535         int ret = MEDIA_CONTENT_ERROR_NONE;
1536         bool ignore_dir = FALSE;
1537         char storage_id[MEDIA_CONTENT_UUID_SIZE+1] = {0, };
1538
1539         media_content_retvm_if(!STRING_VALID(path), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid path");
1540         memset(storage_id, 0x00, sizeof(storage_id));
1541
1542         ret = _media_util_check_ignore_dir(path, &ignore_dir);
1543         media_content_retvm_if(ignore_dir, MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid folder path");
1544
1545         ret = __media_content_check_dir(path);
1546         media_content_retvm_if(ret == MEDIA_CONTENT_ERROR_PERMISSION_DENIED, ret, "Permission Denied");
1547
1548         media_content_scan_cb_data_v2* cb_data = NULL;
1549         cb_data = (media_content_scan_cb_data_v2*)malloc(sizeof(media_content_scan_cb_data_v2));
1550         media_content_retvm_if(cb_data == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY");
1551
1552         cb_data->callback = callback;
1553         cb_data->user_data = user_data;
1554
1555         ret = media_svc_get_storage_id(_content_get_db_handle(), path, storage_id, _content_get_uid());
1556         /*FIX ME. need to check ret value?*/
1557
1558         ret = media_directory_scanning_async(path, storage_id, is_recursive, _media_content_scan_cb_v2, cb_data, _content_get_uid());
1559         if (ret != MS_MEDIA_ERR_NONE)
1560                 media_content_error("media_directory_scanning_async failed : %d", ret);
1561
1562         return _content_error_capi(MEDIA_REGISTER_TYPE, ret);
1563 }
1564 #endif
1565
1566 int media_content_cancel_scan_folder(const char *path)
1567 {
1568         int ret = MEDIA_CONTENT_ERROR_NONE;
1569         char repl_path[MAX_PATH_LEN] = {0, };
1570
1571         media_content_retvm_if(!STRING_VALID(path), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid path");
1572
1573         memset(repl_path, 0, sizeof(repl_path));
1574         ret = _media_content_replace_path(path, repl_path);
1575         media_content_retvm_if(!STRING_VALID(repl_path), MEDIA_CONTENT_ERROR_INVALID_OPERATION, "path replacement failed");
1576
1577         ret = media_directory_scanning_cancel(repl_path, _content_get_uid());
1578         if (ret != MS_MEDIA_ERR_NONE)
1579                 media_content_error("media_directory_scanning_async failed : %d", ret);
1580
1581         return _content_error_capi(MEDIA_REGISTER_TYPE, ret);
1582 }
1583
1584 void _media_content_db_update_noti_cb(
1585                                                         int pid,
1586                                                         media_item_type_e item,
1587                                                         media_item_update_type_e update_type,
1588                                                         char* path,
1589                                                         char* uuid,
1590                                                         media_type_e content_type,
1591                                                         char *mime_type,
1592                                                         void *user_data)
1593 {
1594         int error_value = MEDIA_CONTENT_ERROR_NONE;
1595
1596         media_noti_cb_s *_noti_info = (media_noti_cb_s *)user_data;
1597
1598         if (_noti_info != NULL) {
1599                 if (_noti_info->update_noti_cb)
1600                         _noti_info->update_noti_cb(error_value, pid, item, update_type, content_type, uuid, path, mime_type, _noti_info->user_data);
1601         }
1602
1603         return;
1604 }
1605
1606 int media_content_set_db_updated_cb(media_content_db_update_cb callback, void *user_data)
1607 {
1608         int ret = MEDIA_CONTENT_ERROR_NONE;
1609         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.");
1610
1611         media_content_retvm_if(callback == NULL, MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid callback");
1612         media_content_retvm_if(g_noti_info != NULL, MEDIA_CONTENT_ERROR_INVALID_OPERATION, "Noti callback is already set");
1613
1614         g_noti_info = (media_noti_cb_s *)calloc(1, sizeof(media_noti_cb_s));
1615         media_content_retvm_if(g_noti_info == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY");
1616
1617         g_noti_info->update_noti_cb = callback;
1618         g_noti_info->user_data = user_data;
1619
1620         ret = media_db_update_subscribe(_media_content_db_update_noti_cb, (void *)g_noti_info);
1621
1622         return _content_error_capi(MEDIA_REGISTER_TYPE, ret);
1623 }
1624
1625 int media_content_unset_db_updated_cb(void)
1626 {
1627         int ret = MEDIA_CONTENT_ERROR_NONE;
1628         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.");
1629
1630         SAFE_FREE(g_noti_info);
1631         ret = media_db_update_unsubscribe();
1632
1633         return _content_error_capi(MEDIA_REGISTER_TYPE, ret);
1634 }
1635
1636 int media_content_add_db_updated_cb(media_content_db_update_cb callback, void *user_data, media_content_noti_h *noti_handle)
1637 {
1638         int ret = MEDIA_CONTENT_ERROR_NONE;
1639         media_noti_cb_s *noti_info = NULL;
1640
1641         if (noti_handle == NULL) {
1642                 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
1643                 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
1644         }
1645
1646         if (callback == NULL) {
1647                 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
1648                 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
1649         }
1650
1651         noti_info = (media_noti_cb_s *)calloc(1, sizeof(media_noti_cb_s));
1652         if (noti_info == NULL) {
1653                 media_content_error("Failed to create noti info");
1654                 return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
1655         }
1656
1657         noti_info->update_noti_cb = callback;
1658         noti_info->user_data = user_data;
1659
1660         ret = media_db_update_subscribe_internal((MediaNotiHandle*)noti_handle, _media_content_db_update_noti_cb, (void *)noti_info);
1661
1662         return _content_error_capi(MEDIA_REGISTER_TYPE, ret);
1663 }
1664
1665 void __media_content_clear_user_data(void *user_data)
1666 {
1667         media_noti_cb_s *noti_info = user_data;
1668
1669         SAFE_FREE(noti_info);
1670
1671         return;
1672 }
1673
1674 int media_content_remove_db_updated_cb(media_content_noti_h noti_handle)
1675 {
1676         int ret = MEDIA_CONTENT_ERROR_NONE;
1677
1678         ret = media_db_update_unsubscribe_internal((MediaNotiHandle)noti_handle, __media_content_clear_user_data);
1679
1680         return _content_error_capi(MEDIA_REGISTER_TYPE, ret);
1681 }
1682 #ifdef _USE_TVPD_MODE
1683 GMutex* _content_get_db_mutex(void)
1684 {
1685         return &db_mutex;
1686 }
1687 #endif