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