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 static int __media_content_create_attribute_handles(void);
  30 static int __media_content_destroy_attribute_handle(void);
  31
  32 typedef struct {
  33         char *user_attr;
  34         char *platform_attr;
  35         char *platform_alias_attr;
  36 } media_content_attribute_info_s;
  37
  38 static media_content_attribute_info_s g_content_attrs_info[] = {
  39         /* Media Info */
  40         {MEDIA_ID,                                              DB_FIELD_MEDIA_ID,                                              DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ID},
  41         {MEDIA_PATH,                                    DB_FIELD_MEDIA_PATH,                                    DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_PATH},
  42         {MEDIA_DISPLAY_NAME,                    DB_FIELD_MEDIA_DISPLAY_NAME,                    DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_DISPLAY_NAME},
  43         {MEDIA_TYPE,                                            DB_FIELD_MEDIA_TYPE,                                            DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_TYPE},
  44         {MEDIA_MIME_TYPE,                               DB_FIELD_MEDIA_MIME_TYPE,                               DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_MIME_TYPE},
  45         {MEDIA_SIZE,                                            DB_FIELD_MEDIA_SIZE,                                            DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_SIZE},
  46         {MEDIA_ADDED_TIME,                              DB_FIELD_MEDIA_ADDED_TIME,                              DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ADDED_TIME},
  47         {MEDIA_MODIFIED_TIME,                   DB_FIELD_MEDIA_MODIFIED_TIME,                   DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_MODIFIED_TIME},
  48         {MEDIA_TIMELINE,                                        DB_FIELD_MEDIA_TIMELINE,                                DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_TIMELINE},
  49         {MEDIA_THUMBNAIL_PATH,                  DB_FIELD_MEDIA_THUMBNAIL_PATH,                  DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_THUMBNAIL_PATH},
  50         {MEDIA_TITLE,                                   DB_FIELD_MEDIA_TITLE,                                   DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_TITLE},
  51         {MEDIA_ALBUM,                                   DB_FIELD_MEDIA_ALBUM,                                   DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ALBUM},
  52         {MEDIA_ARTIST,                                  DB_FIELD_MEDIA_ARTIST,                                  DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ARTIST},
  53         {MEDIA_ALBUM_ARTIST,                    DB_FIELD_MEDIA_ALBUM_ARTIST,                    DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ALBUM_ARTIST},
  54         {MEDIA_GENRE,                                   DB_FIELD_MEDIA_GENRE,                                   DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_GENRE},
  55         {MEDIA_COMPOSER,                                DB_FIELD_MEDIA_COMPOSER,                                DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_COMPOSER},
  56         {MEDIA_YEAR,                                    DB_FIELD_MEDIA_YEAR,                                    DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_YEAR},
  57         {MEDIA_RECORDED_DATE,                   DB_FIELD_MEDIA_RECORDED_DATE,                   DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_RECORDED_DATE},
  58         {MEDIA_COPYRIGHT,                               DB_FIELD_MEDIA_COPYRIGHT,                               DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_COPYRIGHT},
  59         {MEDIA_TRACK_NUM,                               DB_FIELD_MEDIA_TRACK_NUM,                               DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_TRACK_NUM},
  60         {MEDIA_DESCRIPTION,                             DB_FIELD_MEDIA_DESCRIPTION,                             DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_DESCRIPTION},
  61         {MEDIA_BITRATE,                                 DB_FIELD_MEDIA_BITRATE,                                 DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_BITRATE},
  62         {MEDIA_BITPERSAMPLE,                    DB_FIELD_MEDIA_BITPERSAMPLE,                    DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_BITPERSAMPLE},
  63         {MEDIA_SAMPLERATE,                              DB_FIELD_MEDIA_SAMPLERATE,                              DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_SAMPLERATE},
  64         {MEDIA_CHANNEL,                         DB_FIELD_MEDIA_CHANNEL,                         DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_CHANNEL},
  65         {MEDIA_DURATION,                                DB_FIELD_MEDIA_DURATION,                                DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_DURATION},
  66         {MEDIA_LONGITUDE,                               DB_FIELD_MEDIA_LONGITUDE,                               DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_LONGITUDE},
  67         {MEDIA_LATITUDE,                                DB_FIELD_MEDIA_LATITUDE,                                DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_LATITUDE},
  68         {MEDIA_ALTITUDE,                                DB_FIELD_MEDIA_ALTITUDE,                                DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ALTITUDE},
  69         {MEDIA_WIDTH,                                   DB_FIELD_MEDIA_WIDTH,                                   DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_WIDTH},
  70         {MEDIA_HEIGHT,                                  DB_FIELD_MEDIA_HEIGHT,                                  DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_HEIGHT},
  71         {MEDIA_DATETAKEN,                               DB_FIELD_MEDIA_DATETAKEN,                               DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_DATETAKEN},
  72         {MEDIA_ORIENTATION,                     DB_FIELD_MEDIA_ORIENTATION,                     DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ORIENTATION},
  73         {MEDIA_RATING,                                  DB_FIELD_MEDIA_RATING,                                  DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_RATING},
  74         {MEDIA_FAVOURITE,                               DB_FIELD_MEDIA_FAVOURITE,                               DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_FAVOURITE},
  75         {MEDIA_IS_DRM,                                  DB_FIELD_MEDIA_IS_DRM,                                  DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_IS_DRM},
  76         {MEDIA_STORAGE_TYPE,                    DB_FIELD_MEDIA_STORAGE_TYPE,                    DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_STORAGE_TYPE},
  77         {MEDIA_360,                                             DB_FIELD_MEDIA_360,                                             DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_360},
  78
  79         /* Pinyin */
  80         {MEDIA_FILE_NAME_PINYIN,                DB_FIELD_MEDIA_FILE_NAME_PINYIN,                DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_FILE_NAME_PINYIN},
  81         {MEDIA_TITLE_PINYIN,                            DB_FIELD_MEDIA_TITLE_PINYIN,                            DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_TITLE_PINYIN},
  82         {MEDIA_ALBUM_PINYIN,                    DB_FIELD_MEDIA_ALBUM_PINYIN,                    DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ALBUM_PINYIN},
  83         {MEDIA_ARTIST_PINYIN,                   DB_FIELD_MEDIA_ARTIST_PINYIN,                   DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ARTIST_PINYIN},
  84         {MEDIA_ALBUM_ARTIST_PINYIN,             DB_FIELD_MEDIA_ALBUM_ARTIST_PINYIN,             DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ALBUM_ARTIST_PINYIN},
  85         {MEDIA_GENRE_PINYIN,                    DB_FIELD_MEDIA_GENRE_PINYIN,                    DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_GENRE_PINYIN},
  86         {MEDIA_COMPOSER_PINYIN,         DB_FIELD_MEDIA_COMPOSER_PINYIN,         DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_COMPOSER_PINYIN},
  87         {MEDIA_COPYRIGHT_PINYIN,                DB_FIELD_MEDIA_COPYRIGHT_PINYIN,                DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_COPYRIGHT_PINYIN},
  88         {MEDIA_DESCRIPTION_PINYIN,              DB_FIELD_MEDIA_DESCRIPTION_PINYIN,              DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_DESCRIPTION_PINYIN},
  89
  90         /* Folder */
  91         {FOLDER_ID,                                             NULL,                                                                   DB_TABLE_ALIAS_FOLDER"."DB_FIELD_FOLDER_ID},
  92         {FOLDER_PATH,                                   NULL,                                                                   DB_TABLE_ALIAS_FOLDER"."DB_FIELD_FOLDER_PATH},
  93         {FOLDER_NAME,                                   NULL,                                                                   DB_TABLE_ALIAS_FOLDER"."DB_FIELD_FOLDER_NAME},
  94         {FOLDER_STORAGE_TYPE,                   NULL,                                                                   DB_TABLE_ALIAS_FOLDER"."DB_FIELD_FOLDER_STORAGE_TYPE},
  95         {FOLDER_NAME_PINYIN,                    NULL,                                                                   DB_TABLE_ALIAS_FOLDER"."DB_FIELD_FOLDER_NAME_PINYIN},
  96
  97         /* Playlist */
  98         {MEDIA_PLAYLIST_ID,                             DB_FIELD_PLAYLIST_ID,                                           NULL},
  99         {PLAYLIST_NAME,                                 DB_FIELD_PLAYLIST_NAME,                                 DB_TABLE_ALIAS_PLAYLIST"."DB_FIELD_PLAYLIST_NAME},
 100         {PLAYLIST_MEMBER_ORDER,         DB_FIELD_PLAYLIST_MEMBER_ORDER,         DB_TABLE_ALIAS_PLAYLIST_MAP"."DB_FIELD_PLAYLIST_MEMBER_ORDER},
 101
 102         /* Playlist View */
 103         {PLAYLIST_MEDIA_COUNT,                  DB_FIELD_PLAYLIST_MEDIA_COUNT,                  NULL},
 104
 105         /* Tag */
 106         {MEDIA_TAG_ID,                                  DB_FIELD_TAG_ID,                                                        NULL},
 107         {TAG_NAME,                                              DB_FIELD_TAG_NAME,                                              DB_TABLE_ALIAS_TAG"."DB_FIELD_TAG_NAME},
 108
 109         /* Tag View */
 110         {TAG_MEDIA_COUNT,                               DB_FIELD_TAG_MEDIA_COUNT,                               NULL},
 111
 112         /* Bookmark */
 113         {MEDIA_BOOKMARK_ID,                     DB_FIELD_BOOKMARK_ID,                                   DB_TABLE_ALIAS_BOOKMARK"."DB_FIELD_BOOKMARK_ID},
 114         {BOOKMARK_MARKED_TIME,          DB_FIELD_BOOKMARK_MARKED_TIME,          DB_TABLE_ALIAS_BOOKMARK"."DB_FIELD_BOOKMARK_MARKED_TIME},
 115         {BOOKMARK_NAME,                         DB_FIELD_BOOKMARK_NAME,                         DB_TABLE_ALIAS_BOOKMARK"."DB_FIELD_BOOKMARK_NAME},
 116
 117         /* Storage */
 118         {MEDIA_STORAGE_ID,                              DB_FIELD_STORAGE_ID,                                    NULL},
 119         {MEDIA_STORAGE_PATH,                    DB_FIELD_STORAGE_PATH,                                  NULL},
 120
 121         /* Face */
 122         {MEDIA_FACE_ID,                                 DB_FIELD_FACE_ID,                                               DB_TABLE_ALIAS_FACE"."DB_FIELD_FACE_ID},
 123         {MEDIA_FACE_TAG,                                DB_FIELD_FACE_TAG,                                              DB_TABLE_ALIAS_FACE"."DB_FIELD_FACE_TAG},
 124
 125 #ifdef _USE_SENIOR_MODE
 126         {MEDIA_CONTACT,                         DB_FIELD_MEDIA_CONTACT,                         DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_CONTACT},
 127         {MEDIA_APP_DATA,                                DB_FIELD_MEDIA_APP_DATA,                                DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_APP_DATA},
 128 #endif
 129 #ifdef _USE_TVPD_MODE
 130         {MEDIA_PLAYED_COUNT,                    DB_FIELD_MEDIA_PLAYED_COUNT,                    DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_PLAYED_COUNT},
 131         {MEDIA_LAST_PLAYED_TIME,                DB_FIELD_MEDIA_LAST_PLAYED_TIME,                DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_LAST_PLAYED_TIME},
 132         {MEDIA_LAST_PLAYED_POSITION,    DB_FIELD_MEDIA_LAST_PLAYED_POSITION,    DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_LAST_PLAYED_POSITION},
 133         {MEDIA_FOLDER_ID,                               DB_FIELD_MEDIA_FOLDER_ID,                               DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_FOLDER_ID},
 134         {MEDIA_STITCHED_INFO,                   DB_FIELD_MEDIA_STITCHED_INFO,                   NULL},
 135         {MEDIA_MODIFIED_MONTH,          DB_FIELD_MEDIA_MODIFIED_MONTH,          NULL},
 136         {MEDIA_MODIFIED_DATE,                   DB_FIELD_MEDIA_MODIFIED_DATE,                   NULL},
 137
 138         /* PVR */
 139         {PVR_DURATION,                                  DB_FIELD_PVR_DURATION,                                  NULL},
 140         {PVR_TIME_ZONE,                                 DB_FIELD_PVR_TIME_ZONE,                                 NULL},
 141         {PVR_PTC,                                               DB_FIELD_PVR_PTC,                                               NULL},
 142         {PVR_MAJOR,                                             DB_FIELD_PVR_MAJOR,                                             NULL},
 143         {PVR_MINOR,                                             DB_FIELD_PVR_MINOR,                                             NULL},
 144         {PVR_CHANNEL_TYPE,                              DB_FIELD_PVR_CHANNEL_TYPE,                              NULL},
 145         {PVR_CHANNEL_NAME,                              DB_FIELD_PVR_CHANNEL_NAME,                      NULL},
 146         {PVR_CHANNEL_NUM,                               DB_FIELD_PVR_CHANNEL_NUM,                               NULL},
 147         {PVR_PROGRAM_TITLE,                             DB_FIELD_PVR_PROGRAM_TITLE,                             NULL},
 148         {PVR_PROGRAM_NUM,                               DB_FIELD_PVR_PROGRAM_NUM,                               NULL},
 149         {PVR_PROGRAM_CRID,                              DB_FIELD_PVR_PROGRAM_CRID,                              NULL},
 150         {PVR_GUIDANCE,                                  DB_FIELD_PVR_GUIDANCE,                                  NULL},
 151         {PVR_SYNOPSIS,                                  DB_FIELD_PVR_SYNOPSIS,                                  NULL},
 152         {PVR_GENRE,                                             DB_FIELD_PVR_GENRE,                                             NULL},
 153         {PVR_LANGUAGE,                                  DB_FIELD_PVR_LANGUAGE,                                  NULL},
 154         {PVR_EMBARGO_TIME,                              DB_FIELD_PVR_EMBARGO_TIME,                              NULL},
 155         {PVR_EXPIRY_TIME,                               DB_FIELD_PVR_EXPIRY_TIME,                               NULL},
 156         {PVR_START_TIME,                                        DB_FIELD_PVR_START_TIME,                                        NULL},
 157         {PVR_PROGRAM_START_TIME,                DB_FIELD_PVR_PROGRAM_START_TIME,                NULL},
 158         {PVR_PROGRAM_END_TIME,                  DB_FIELD_PVR_PROGRAM_END_TIME,          NULL},
 159         {PVR_PROGRAM_DATE,                              DB_FIELD_PVR_PROGRAM_DATE,                              NULL},
 160         {PVR_PARENTAL_RATING,                   DB_FIELD_PVR_PARENTAL_RATING,                   NULL},
 161         {PVR_TIMER_RECORD,                              DB_FIELD_PVR_TIMER_RECORD,                              NULL},
 162         {PVR_SERIES_RECORD,                             DB_FIELD_PVR_SERIES_RECORD,                             NULL},
 163         {PVR_HD,                                                        DB_FIELD_PVR_HD,                                                        NULL},
 164         {PVR_SUBTITLE,                                  DB_FIELD_PVR_SUBTITLE,                                  NULL},
 165         {PVR_TTX,                                               DB_FIELD_PVR_TTX,                                               NULL},
 166         {PVR_AD,                                                        DB_FIELD_PVR_AD,                                                        NULL},
 167         {PVR_TTX,                                               DB_FIELD_PVR_TTX,                                               NULL},
 168         {PVR_DATA_SERVICE,                              DB_FIELD_PVR_DATA_SERVICE,                              NULL},
 169         {PVR_CONTENT_LOCK,                              DB_FIELD_PVR_CONTENT_LOCK,                              NULL},
 170         {PVR_CONTENT_WATCH,                     DB_FIELD_PVR_CONTENT_WATCH,                     NULL},
 171         {PVR_CONTENT_HAS_AUDIO_ONLY,    DB_FIELD_PVR_HAS_AUDIO_ONLY,                    NULL},
 172         {PVR_CONTENT_IS_LOCAL_RECORD,   DB_FIELD_PVR_IS_LOCAL_RECORD,                   NULL},
 173         {PVR_CONTENT_RESOLUTION,                DB_FIELD_PVR_RESOLUTION,                                NULL},
 174         {PVR_CONTENT_ASPECTRATIO,               DB_FIELD_PVR_ASPECTRATIO,                               NULL},
 175         {PVR_MODIFIED_MONTH,                    DB_FIELD_PVR_MODIFIED_DATE,                             NULL},
 176         {PVR_MODIFIED_DATE,                             DB_FIELD_PVR_MODIFIED_DATE,                             NULL},
 177         {PVR_SPORTS_TYPE,                               DB_FIELD_PVR_SPORTS_TYPE,                               NULL},
 178         {PVR_GUIDANCE_LENGTH,                   DB_FIELD_PVR_GUIDANCE_LENGTH,                   NULL},
 179         {PVR_TVMODE,                                    DB_FIELD_PVR_TVMODE,                                    NULL},
 180         {PVR_PLAY_COUNT,                                DB_FIELD_PVR_PLAY_COUNT,                                NULL},
 181         {PVR_PRIVATE_DATA,                              DB_FIELD_PVR_PRIVATE_DATA,                              NULL},
 182
 183         /* UHD */
 184         {UHD_CONTENT_TITLE,                             DB_FIELD_UHD_CONTENT_TITLE,                             NULL},
 185         {UHD_RELEASE_DATE,                              DB_FIELD_UHD_RELEASE_DATE,                              NULL},
 186         {UHD_SUB_TYPE,                                  DB_FIELD_UHD_SUB_TYPE,                                  NULL},
 187         {UHD_FILE_NAME,                                 DB_FIELD_UHD_FILE_NAME,                                 NULL},
 188         {UHD_FOLDER_ID,                                 DB_FIELD_FOLDER_ID,                                             NULL},
 189         {UHD_PLAYED_COUNT,                              DB_FIELD_UHD_PLAYED_COUNT,                              NULL},
 190 #endif
 191 };
 192
 193 static int __media_content_create_attribute_handles(void)
 194 {
 195         int ret = MEDIA_CONTENT_ERROR_NONE;
 196         int idx = 0;
 197         int count = 0;
 198         char *_attr_user = NULL;
 199         char *_attr_platform = NULL;
 200         char *_alias_attr_user = NULL;
 201         char *_alias_attr_platform = NULL;
 202         attribute_s *_attr = NULL;
 203         attribute_s *_alias_attr = NULL;
 204
 205         ret = _media_filter_attribute_create(&g_attr_handle);
 206         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 207
 208         ret = _media_filter_attribute_create(&g_alias_attr_handle);
 209         if (ret != MEDIA_CONTENT_ERROR_NONE)
 210                 goto ERROR;
 211
 212         _attr = (attribute_s*)g_attr_handle;
 213         _alias_attr = (attribute_s*)g_alias_attr_handle;
 214
 215         count = sizeof(g_content_attrs_info) / sizeof((g_content_attrs_info)[0]);
 216
 217         for (idx = 0; idx < count; idx++) {
 218                 _attr_user = NULL;
 219                 _attr_platform = NULL;
 220                 _alias_attr_user = NULL;
 221                 _alias_attr_platform = NULL;
 222
 223                 if (STRING_VALID(g_content_attrs_info[idx].user_attr)) {
 224                         /*attribute*/
 225                         if (STRING_VALID(g_content_attrs_info[idx].platform_attr)) {
 226                                 _attr_user = g_strdup(g_content_attrs_info[idx].user_attr);
 227                                 _attr_platform = g_strdup(g_content_attrs_info[idx].platform_attr);
 228
 229                                 if (_attr_user == NULL || _attr_platform == NULL) {
 230                                         SAFE_G_FREE(_attr_user);
 231                                         SAFE_G_FREE(_attr_platform);
 232                                         media_content_error("OUT_OF_MEMORY(0x%08x)", MEDIA_CONTENT_ERROR_OUT_OF_MEMORY);
 233                                         ret = MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
 234                                         goto ERROR;
 235                                 }
 236
 237                                 g_hash_table_insert(_attr->attr_map, _attr_user, _attr_platform);
 238
 239                         }
 240
 241                         /*alias attribute*/
 242                         if (STRING_VALID(g_content_attrs_info[idx].platform_alias_attr)) {
 243                                 _alias_attr_user = g_strdup(g_content_attrs_info[idx].user_attr);
 244                                 _alias_attr_platform = g_strdup(g_content_attrs_info[idx].platform_alias_attr);
 245
 246                                 if (_alias_attr_user == NULL || _alias_attr_platform == NULL) {
 247                                         SAFE_G_FREE(_alias_attr_user);
 248                                         SAFE_G_FREE(_alias_attr_platform);
 249                                         media_content_error("OUT_OF_MEMORY(0x%08x)", MEDIA_CONTENT_ERROR_OUT_OF_MEMORY);
 250                                         ret = MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
 251                                         goto ERROR;
 252                                 }
 253
 254                                 g_hash_table_insert(_alias_attr->attr_map, _alias_attr_user, _alias_attr_platform);
 255                         }
 256                 } else {
 257                         media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
 258                         ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
 259                         goto ERROR;
 260                 }
 261         }
 262
 263         return ret;
 264
 265 ERROR:
 266         media_content_error("Fail media_content_create_attribute_handles");
 267         __media_content_destroy_attribute_handle();
 268
 269         return ret;
 270 }
 271
 272 static int __media_content_destroy_attribute_handle(void)
 273 {
 274         int ret = MEDIA_CONTENT_ERROR_NONE;
 275
 276         ret = _media_filter_attribute_destory(g_attr_handle);
 277         ret = _media_filter_attribute_destory(g_alias_attr_handle);
 278
 279         g_attr_handle = NULL;
 280         g_alias_attr_handle = NULL;
 281
 282         return ret;
 283 }
 284
 285 attribute_h _content_get_attirbute_handle(void)
 286 {
 287         return g_attr_handle;
 288 }
 289
 290 attribute_h _content_get_alias_attirbute_handle(void)
 291 {
 292         return g_alias_attr_handle;
 293 }
 294
 295 MediaSvcHandle* _content_get_db_handle(void)
 296 {
 297         return db_handle;
 298 }
 299
 300 uid_t _content_get_uid(void)
 301 {
 302         if (content_g_uid == 0)
 303                 return tzplatform_getuid(TZ_USER_NAME);
 304         else
 305                 return content_g_uid;
 306 }
 307
 308 int _content_query_prepare(sqlite3_stmt **stmt, char *select_query, char *condition_query, char *option_query)
 309 {
 310         int len = 0;
 311         int err = MEDIA_CONTENT_ERROR_NONE;
 312         char query[MAX_QUERY_SIZE] = {0, };
 313         memset(query, '\0', sizeof(query));
 314
 315         media_content_retvm_if(db_handle == NULL, MEDIA_CONTENT_ERROR_DB_FAILED, "database is not connected");
 316         media_content_retvm_if(!STRING_VALID(select_query), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "invalid select_query");
 317
 318         if (!STRING_VALID(condition_query))
 319                 condition_query = (char *)" ";
 320
 321         if (!STRING_VALID(option_query))
 322                 option_query = (char *)" ";
 323
 324         /*query = sqlite3_mprintf("%s %s %s", select_query, condition_query, option_query);*/
 325         len = snprintf(query, sizeof(query), "%s %s %s", select_query, condition_query, option_query);
 326         if (len > 0 && len < sizeof(query))
 327                 query[len] = '\0';
 328         else if (len >= sizeof(query))
 329                 query[MAX_QUERY_SIZE -1] = '\0';
 330         else {
 331                 media_content_error("snprintf failed");
 332                 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
 333         }
 334
 335         media_content_sec_debug("Query : [%s]", query);
 336
 337         err = sqlite3_prepare_v2((sqlite3*)db_handle, query, strlen(query), stmt, NULL);
 338         if (err != SQLITE_OK) {
 339                 media_content_error("DB_FAILED(0x%08x) fail to sqlite3_prepare(), %s", MEDIA_CONTENT_ERROR_DB_FAILED, sqlite3_errmsg((sqlite3*)db_handle));
 340
 341                 if (err == SQLITE_BUSY) {
 342                         media_content_error(" BUSY ERROR");
 343                         return MEDIA_CONTENT_ERROR_DB_BUSY;
 344                 } else if (err == SQLITE_PERM) {
 345                         media_content_error("PERMISSION EROR");
 346                         return MEDIA_CONTENT_ERROR_PERMISSION_DENIED;
 347                 } else {
 348                         media_content_error("OTHER ERROR");
 349                         return MEDIA_CONTENT_ERROR_DB_FAILED;
 350                 }
 351         }
 352
 353         return MEDIA_CONTENT_ERROR_NONE;
 354 }
 355
 356 #ifdef _USE_SENIOR_MODE
 357 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)
 358 {
 359         int len = 0;
 360         int err = MEDIA_CONTENT_ERROR_NONE;
 361         char query[MAX_QUERY_SIZE] = {0, };
 362         memset(query, '\0', sizeof(query));
 363
 364         media_content_retvm_if(db_handle == NULL, MEDIA_CONTENT_ERROR_DB_FAILED, "database is not connected");
 365         media_content_retvm_if(!STRING_VALID(select_query1), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "invalid select_query1");
 366         media_content_retvm_if(!STRING_VALID(select_query2), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "invalid select_query2");
 367
 368         if (!STRING_VALID(condition_query1))
 369                 condition_query1 = (char *)" ";
 370
 371         if (!STRING_VALID(option_query1))
 372                 option_query1 = (char *)" ";
 373
 374         if (!STRING_VALID(condition_query2))
 375                 condition_query2 = (char *)" ";
 376
 377         if (!STRING_VALID(option_query2))
 378                 option_query2 = (char *)" ";
 379
 380         len = snprintf(query, sizeof(query), "SELECT * FROM (%s %s %s) as table1 UNION ALL SELECT * FROM (%s %s %s) as table2",
 381                         select_query1, condition_query1, option_query1, select_query2, condition_query2, option_query2);
 382         if (len > 0 && len < sizeof(query)) {
 383                 query[len] = '\0';
 384         } else if (len >= sizeof(query)) {
 385                 query[MAX_QUERY_SIZE -1] = '\0';
 386         } else {
 387                 media_content_error("snprintf failed");
 388                 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
 389         }
 390
 391         media_content_sec_debug("Query : [%s]", query);
 392
 393         err = sqlite3_prepare_v2((sqlite3*)db_handle, query, strlen(query), stmt, NULL);
 394         if (err != SQLITE_OK) {
 395                 media_content_error("DB_FAILED(0x%08x) fail to sqlite3_prepare(), %s", MEDIA_CONTENT_ERROR_DB_FAILED, sqlite3_errmsg((sqlite3*)db_handle));
 396
 397                 if (err == SQLITE_BUSY) {
 398                         media_content_error(" BUSY ERROR");
 399                         return MEDIA_CONTENT_ERROR_DB_BUSY;
 400                 } else if (err == SQLITE_PERM) {
 401                         media_content_error("PERMISSION EROR");
 402                         return MEDIA_CONTENT_ERROR_PERMISSION_DENIED;
 403                 } else {
 404                         media_content_error("OTHER ERROR");
 405                         return MEDIA_CONTENT_ERROR_DB_FAILED;
 406                 }
 407         }
 408
 409         return MEDIA_CONTENT_ERROR_NONE;
 410 }
 411 #endif
 412
 413 int _content_error_capi(int type, int content_error)
 414 {
 415         if (content_error != MEDIA_CONTENT_ERROR_NONE)
 416                 media_content_error("[type : %d] content_error : %d ", type, content_error);
 417
 418         /*Error None*/
 419         if (content_error == MS_MEDIA_ERR_NONE)
 420                 return MEDIA_CONTENT_ERROR_NONE;
 421
 422         /* Internal operation error*/
 423         else if ((content_error == MS_MEDIA_ERR_INVALID_PARAMETER) ||
 424                 (content_error == MS_MEDIA_ERR_INVALID_PATH) ||
 425                 (content_error == MS_MEDIA_ERR_THUMB_DUPLICATED_REQUEST))
 426                 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
 427
 428         else if (content_error == MS_MEDIA_ERR_OUT_OF_MEMORY)
 429                 return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
 430
 431         /* DB operation error*/
 432         else if (content_error == MS_MEDIA_ERR_DB_BUSY_FAIL)
 433                 return MEDIA_CONTENT_ERROR_DB_BUSY;
 434
 435         else if ((content_error <= MS_MEDIA_ERR_DB_CONNECT_FAIL) && (content_error >= MS_MEDIA_ERR_DB_INTERNAL))
 436                 return MEDIA_CONTENT_ERROR_DB_FAILED;
 437
 438         /* IPC operation error*/
 439         else if ((content_error <= MS_MEDIA_ERR_SOCKET_CONN) && (content_error >= MS_MEDIA_ERR_SOCKET_INTERNAL))
 440                 return MEDIA_CONTENT_ERROR_NETWORK;
 441
 442         /* MEDIA SERVER error*/
 443         else if (content_error == MS_MEDIA_ERR_PERMISSION_DENIED)
 444                 return MEDIA_CONTENT_ERROR_PERMISSION_DENIED;
 445
 446         /* Thumbnail error*/
 447         else if ((content_error == MS_MEDIA_ERR_THUMB_TOO_BIG) || (content_error == MS_MEDIA_ERR_THUMB_UNSUPPORTED))
 448                         return MEDIA_CONTENT_ERROR_UNSUPPORTED_CONTENT;
 449
 450         /*ETC*/
 451         return MEDIA_CONTENT_ERROR_INVALID_OPERATION;
 452 }
 453
 454 int _content_query_sql(char *query_str)
 455 {
 456         int ret = MEDIA_CONTENT_ERROR_NONE;
 457
 458         /*DB will be updated by Media Server.*/
 459         ret = media_svc_request_update_db(query_str, _content_get_uid());
 460
 461         return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
 462 }
 463
 464 int media_content_connect(void)
 465 {
 466         int ret = MEDIA_CONTENT_ERROR_NONE;
 467
 468         g_mutex_lock(&db_mutex);
 469         media_content_info("ref count : %d", ref_count);
 470
 471         if (ref_count == 0) {
 472                 if (db_handle == NULL) {
 473                         ret = __media_content_create_attribute_handles();
 474                         if (ret == MEDIA_CONTENT_ERROR_NONE) {
 475                                 ret = media_svc_connect(&db_handle, _content_get_uid(), false);
 476                                 ret = _content_error_capi(MEDIA_CONTENT_TYPE, ret);
 477                                 if (ret == MEDIA_CONTENT_ERROR_NONE)
 478                                         ref_count++;
 479                                 else
 480                                         __media_content_destroy_attribute_handle();
 481
 482                         } else {
 483                                 media_content_error("Internal DB Connection Error");
 484                         }
 485                 } else {
 486                         media_content_error("Wrong DB Connection status");
 487                         ret = MEDIA_CONTENT_ERROR_DB_FAILED;
 488                 }
 489         } else {
 490                 if (db_handle != NULL) {
 491                         ref_count++;
 492                 } else {
 493                         media_content_error("Wrong DB Handle status");
 494                         ret = MEDIA_CONTENT_ERROR_DB_FAILED;
 495                 }
 496         }
 497
 498         media_content_info("ref count changed to: %d", ref_count);
 499         g_mutex_unlock(&db_mutex);
 500
 501         return ret;
 502 }
 503
 504 int media_content_connect_with_uid(uid_t uid)
 505 {
 506         media_content_sec_debug("media_content_connect_with_uid [%d]", uid);
 507         content_g_uid = uid;
 508
 509         return media_content_connect();
 510 }
 511
 512 int media_content_disconnect(void)
 513 {
 514         int ret = MEDIA_CONTENT_ERROR_NONE;
 515
 516         g_mutex_lock(&db_mutex);
 517         media_content_debug("ref count : %d", ref_count);
 518         if (ref_count > 0) {
 519                 if (db_handle != NULL) {
 520                         ref_count--;
 521                 } else {
 522                         media_content_error("Wrong DB Handle status");
 523                         ret = MEDIA_CONTENT_ERROR_DB_FAILED;
 524                 }
 525         } else {
 526                 media_content_error("DB_FAILED(0x%08x) database is not connected", MEDIA_CONTENT_ERROR_DB_FAILED);
 527                 g_mutex_unlock(&db_mutex);
 528                 return MEDIA_CONTENT_ERROR_DB_FAILED;
 529         }
 530
 531         if (ref_count == 0) {
 532                 if (db_handle != NULL) {
 533                         ret = media_svc_disconnect(db_handle);
 534                         ret = _content_error_capi(MEDIA_CONTENT_TYPE, ret);
 535                         if (ret == MEDIA_CONTENT_ERROR_NONE) {
 536                                 ret = __media_content_destroy_attribute_handle();
 537                                 db_handle = NULL;
 538                         } else {
 539                                 media_content_error("database disconnect fail");
 540                                 ref_count++;
 541                         }
 542                 } else {
 543                         media_content_error("Wrong DB Handle status");
 544                         ret = MEDIA_CONTENT_ERROR_DB_FAILED;
 545                 }
 546
 547                 g_mutex_unlock(&db_mutex);
 548
 549                 media_content_info("ref count changed to: %d", ref_count);
 550
 551                 return ret;
 552         }
 553
 554         g_mutex_unlock(&db_mutex);
 555
 556         media_content_info("ref count changed to: %d", ref_count);
 557
 558         return ret;
 559 }
 560
 561 int media_content_scan_file(const char *path)
 562 {
 563         int ret = MEDIA_CONTENT_ERROR_NONE;
 564         bool ignore_file = FALSE;
 565         bool ignore_dir = FALSE;
 566         char *folder_path = NULL;
 567         int check_file = MEDIA_CONTENT_ERROR_NONE;
 568         char storage_id[MEDIA_CONTENT_UUID_SIZE+1] = {0,};
 569         char repl_path[MAX_PATH_LEN] = {0,};
 570
 571         media_content_retvm_if(!STRING_VALID(path), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "invalid path");
 572
 573         media_content_sec_debug("Path : %s", path);
 574
 575         memset(repl_path, 0, sizeof(repl_path));
 576         ret = _media_content_replace_path(path, repl_path);
 577         media_content_retvm_if(!STRING_VALID(repl_path), MEDIA_CONTENT_ERROR_INVALID_OPERATION, "path replacement failed");
 578
 579         ret = _media_util_check_ignore_file(repl_path, &ignore_file);
 580         media_content_retvm_if(ignore_file == TRUE, MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid path");
 581
 582         memset(storage_id, 0x00, sizeof(storage_id));
 583         ret = media_svc_get_storage_id(_content_get_db_handle(), repl_path, storage_id, _content_get_uid());
 584         if (ret != MS_MEDIA_ERR_NONE) {
 585                 media_content_error("media_svc_get_storage_id failed : %d", ret);
 586                 return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
 587         }
 588
 589         check_file = _media_util_check_file_exist(repl_path);
 590         if (check_file == MEDIA_CONTENT_ERROR_NONE) {
 591                 /* This means this path has to be inserted or refreshed */
 592                 folder_path = g_path_get_dirname(repl_path);
 593                 ret = _media_util_check_ignore_dir(folder_path, &ignore_dir);
 594                 SAFE_FREE(folder_path);
 595
 596                 media_content_retvm_if(ignore_dir == TRUE, MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid folder path");
 597                 /* check feature */
 598                 media_content_retvm_if(!_media_util_check_support_media_type(repl_path), MEDIA_CONTENT_ERROR_NOT_SUPPORTED, "Unsupported media type");
 599
 600                 media_svc_storage_type_e storage_type;
 601
 602                 ret = media_svc_get_storage_type(repl_path, &storage_type, _content_get_uid());
 603                 if (ret != MS_MEDIA_ERR_NONE) {
 604                         media_content_sec_error("media_svc_get_storage_type failed : %d (%s)", ret, repl_path);
 605                         return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
 606                 }
 607                 ret = media_svc_check_item_exist_by_path(_content_get_db_handle(), storage_id, repl_path);
 608                 if (ret == MS_MEDIA_ERR_NONE) {
 609                         /* Refresh */
 610                         ret = media_svc_refresh_item(_content_get_db_handle(), storage_id, storage_type, repl_path, _content_get_uid());
 611                         if (ret != MS_MEDIA_ERR_NONE) {
 612                                 media_content_error("media_svc_refresh_item failed : %d", ret);
 613                                 return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
 614                         }
 615
 616                 } else if (ret == MS_MEDIA_ERR_DB_NO_RECORD) {
 617                         /* Insert */
 618                         ret = media_svc_insert_item_immediately(_content_get_db_handle(), storage_id, storage_type, repl_path, _content_get_uid());
 619                         if (ret != MS_MEDIA_ERR_NONE) {
 620                                 if (ret == MS_MEDIA_ERR_DB_CONSTRAINT_FAIL) {
 621                                         media_content_sec_error("This item is already inserted. This may be normal operation because other process already did this (%s)", repl_path);
 622                                         ret = MEDIA_CONTENT_ERROR_NONE;
 623                                 } else {
 624                                         media_content_sec_error("media_svc_insert_item_immediately failed : %d (%s)", ret, repl_path);
 625                                 }
 626
 627                                 return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
 628                         }
 629                 } else {
 630                         media_content_error("media_svc_check_item_exist_by_path failed : %d", ret);
 631                         return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
 632                 }
 633         } else if (check_file == MEDIA_CONTENT_ERROR_PERMISSION_DENIED) {
 634                 media_content_error("You have no permission for this file %d", ret);
 635                 return MEDIA_CONTENT_ERROR_PERMISSION_DENIED;
 636         } else {
 637                 /* This means this path has to be deleted */
 638                 media_content_debug("This path doesn't exists in file system... So now start to delete it from DB");
 639                 ret = media_svc_delete_item_by_path(_content_get_db_handle(), storage_id, repl_path, _content_get_uid());
 640                 if (ret != MS_MEDIA_ERR_NONE) {
 641                         if (ret == MS_MEDIA_ERR_DB_NO_RECORD) {
 642                                 media_content_error("Does not exist in media DB also... So, this is an invalid parameter");
 643                                 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
 644                         }
 645
 646                         media_content_error("media_svc_delete_item_by_path failed : %d", ret);
 647                         return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
 648                 }
 649         }
 650
 651         return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
 652 }
 653
 654 void _media_content_scan_cb(media_request_result_s* result, void *user_data)
 655 {
 656         int err = -1;
 657         media_content_scan_cb_data *cb_data = user_data;
 658
 659         err = _content_error_capi(MEDIA_REGISTER_TYPE, result->result);
 660 #ifdef _USE_TVPD_MODE
 661         if (result->request_type != MEDIA_REQUEST_SCAN_COMPLETE &&
 662                 result->request_type != MEDIA_REQUEST_SCAN_PARTIAL) {
 663                 if (cb_data && cb_data->callback) {
 664                         media_content_debug("begin:User callback is being called now, result=%d", err);
 665                         cb_data->callback(err, cb_data->user_data);
 666                         media_content_debug("end:User callback is being called now, result=%d", err);
 667                 }
 668
 669                 SAFE_FREE(cb_data);
 670         }
 671 #else
 672         if (cb_data && cb_data->callback) {
 673                 media_content_debug("User callback is being called now");
 674                 cb_data->callback(err, cb_data->user_data);
 675         }
 676
 677         SAFE_FREE(cb_data);
 678 #endif
 679
 680         return;
 681 }
 682
 683 #ifdef _USE_TVPD_MODE
 684 void _media_content_scan_cb_v2(media_request_result_s* result, void *user_data)
 685 {
 686         int err = -1;
 687         media_content_scan_cb_data_v2 *cb_data = user_data;
 688         media_content_complete_phase_e complete_phase = -1;
 689         if (!cb_data)
 690                 media_content_debug("cb_data is NULL");
 691         err = _content_error_capi(MEDIA_REGISTER_TYPE, result->result);
 692         media_content_debug("result is %d", err);
 693
 694         if (result->request_type == MEDIA_REQUEST_SCAN_PARTIAL)
 695                 complete_phase = MEDIA_CONTENT_SCAN_PARTIAL_COMPLETE;
 696         else if (result->request_type == MEDIA_REQUEST_SCAN_COMPLETE)
 697                 complete_phase = MEDIA_CONTENT_SCAN_COMPLETE;
 698         else if (result->request_type == MEDIA_REQUEST_EXTRACT_COMPLETE)
 699                 complete_phase = MEDIA_CONTENT_EXTRACT_COMPLETE;
 700
 701         if (cb_data && cb_data->callback)
 702                 cb_data->callback(err, complete_phase, cb_data->user_data);
 703         else
 704                 media_content_debug("run error");
 705
 706         if ((result->request_type != MEDIA_REQUEST_SCAN_COMPLETE) &&
 707         (result->request_type != MEDIA_REQUEST_SCAN_PARTIAL))
 708                 SAFE_FREE(cb_data);
 709
 710         return;
 711 }
 712 #endif
 713
 714 int media_content_scan_folder(const char *path, bool is_recursive, media_scan_completed_cb callback, void *user_data)
 715 {
 716         int ret = MEDIA_CONTENT_ERROR_NONE;
 717         bool ignore_dir = FALSE;
 718         char storage_id[MEDIA_CONTENT_UUID_SIZE+1] = {0, };
 719         char repl_path[MAX_PATH_LEN] = {0, };
 720         media_svc_storage_type_e storage_type = MEDIA_SVC_STORAGE_MAX;
 721
 722         media_content_retvm_if(!STRING_VALID(path), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid path");
 723         memset(repl_path, 0, sizeof(repl_path));
 724         ret = _media_content_replace_path(path, repl_path);
 725         media_content_retvm_if(!STRING_VALID(repl_path), MEDIA_CONTENT_ERROR_INVALID_OPERATION, "path replacement failed");
 726
 727         memset(storage_id, 0x00, sizeof(storage_id));
 728
 729         ret = _media_content_check_dir(repl_path);
 730         media_content_retvm_if(ret == MEDIA_CONTENT_ERROR_PERMISSION_DENIED, ret, "Permission Denied");
 731
 732         if (ret == MEDIA_CONTENT_ERROR_NONE) {
 733                 /* If directory exist check that's ignore directory or not*/
 734                 ret = _media_util_check_ignore_dir(repl_path, &ignore_dir);
 735                 media_content_retvm_if((ignore_dir == TRUE || ret != MEDIA_CONTENT_ERROR_NONE), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid folder path");
 736         } else {
 737                 /* This means this folder has to be deleted */
 738                 /* Or, it is real invalid path.. check storage type */
 739                 ret = media_svc_get_storage_type(repl_path, &storage_type, _content_get_uid());
 740                 if (ret != MS_MEDIA_ERR_NONE) {
 741                         media_content_sec_error("media_svc_get_storage_type failed : %d (%s)", ret, repl_path);
 742                         return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
 743                 }
 744
 745                 media_content_debug("This path doesn't exists in file system... So will be deleted it from DB");
 746         }
 747
 748         ret = media_svc_get_storage_id(_content_get_db_handle(), repl_path, storage_id, _content_get_uid());
 749         if (ret != MS_MEDIA_ERR_NONE) {
 750                 media_content_error("media_svc_get_storage_id failed : %d", ret);
 751                 return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
 752         }
 753
 754         media_content_scan_cb_data *cb_data = NULL;
 755         cb_data = (media_content_scan_cb_data *)malloc(sizeof(media_content_scan_cb_data));
 756         media_content_retvm_if(cb_data == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY");
 757
 758         cb_data->callback = callback;
 759         cb_data->user_data = user_data;
 760
 761         ret = media_directory_scanning_async(repl_path, storage_id, is_recursive, _media_content_scan_cb, cb_data, _content_get_uid());
 762         if (ret != MS_MEDIA_ERR_NONE) {
 763                 media_content_error("media_directory_scanning_async failed : %d", ret);
 764                 SAFE_FREE(cb_data);
 765         }
 766
 767         return _content_error_capi(MEDIA_REGISTER_TYPE, ret);
 768 }
 769
 770 #ifdef _USE_TVPD_MODE
 771 int media_content_scan_folder_v2(const char *path, bool is_recursive, media_scan_completed_cb_v2 callback, void *user_data)
 772 {
 773         int ret = MEDIA_CONTENT_ERROR_NONE;
 774         bool ignore_dir = FALSE;
 775         char storage_id[MEDIA_CONTENT_UUID_SIZE+1] = {0, };
 776
 777         media_content_retvm_if(!STRING_VALID(path), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid path");
 778         memset(storage_id, 0x00, sizeof(storage_id));
 779
 780         ret = _media_util_check_ignore_dir(path, &ignore_dir);
 781         media_content_retvm_if(ignore_dir, MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid folder path");
 782
 783         ret = _media_content_check_dir(path);
 784         media_content_retvm_if(ret == MEDIA_CONTENT_ERROR_PERMISSION_DENIED, ret, "Permission Denied");
 785         media_content_retvm_if(ret == MEDIA_CONTENT_ERROR_INVALID_PARAMETER, ret, "invalid path[%s]", path);
 786
 787         media_content_scan_cb_data_v2* cb_data = NULL;
 788         cb_data = (media_content_scan_cb_data_v2*)malloc(sizeof(media_content_scan_cb_data_v2));
 789         media_content_retvm_if(cb_data == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY");
 790
 791         cb_data->callback = callback;
 792         cb_data->user_data = user_data;
 793
 794         ret = media_svc_get_storage_id(_content_get_db_handle(), path, storage_id, _content_get_uid());
 795         /*FIX ME. need to check ret value?*/
 796
 797         ret = media_directory_scanning_async(path, storage_id, is_recursive, _media_content_scan_cb_v2, cb_data, _content_get_uid());
 798         if (ret != MS_MEDIA_ERR_NONE)
 799                 media_content_error("media_directory_scanning_async failed : %d", ret);
 800
 801         return _content_error_capi(MEDIA_REGISTER_TYPE, ret);
 802 }
 803 #endif
 804
 805 int media_content_cancel_scan_folder(const char *path)
 806 {
 807         int ret = MEDIA_CONTENT_ERROR_NONE;
 808         char repl_path[MAX_PATH_LEN] = {0, };
 809
 810         media_content_retvm_if(!STRING_VALID(path), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid path");
 811
 812         memset(repl_path, 0, sizeof(repl_path));
 813         ret = _media_content_replace_path(path, repl_path);
 814         media_content_retvm_if(!STRING_VALID(repl_path), MEDIA_CONTENT_ERROR_INVALID_OPERATION, "path replacement failed");
 815
 816         ret = media_directory_scanning_cancel(repl_path, _content_get_uid());
 817         if (ret != MS_MEDIA_ERR_NONE)
 818                 media_content_error("media_directory_scanning_async failed : %d", ret);
 819
 820         return _content_error_capi(MEDIA_REGISTER_TYPE, ret);
 821 }
 822
 823 void _media_content_db_update_noti_cb(
 824                                                         int pid,
 825                                                         media_item_type_e item,
 826                                                         media_item_update_type_e update_type,
 827                                                         char* path,
 828                                                         char* uuid,
 829                                                         media_type_e content_type,
 830                                                         char *mime_type,
 831                                                         void *user_data)
 832 {
 833         int error_value = MEDIA_CONTENT_ERROR_NONE;
 834
 835         media_noti_cb_s *_noti_info = (media_noti_cb_s *)user_data;
 836
 837         if (_noti_info != NULL) {
 838                 if (_noti_info->update_noti_cb)
 839                         _noti_info->update_noti_cb(error_value, pid, item, update_type, content_type, uuid, path, mime_type, _noti_info->user_data);
 840         }
 841
 842         return;
 843 }
 844
 845 int media_content_add_db_updated_cb(media_content_db_update_cb callback, void *user_data, media_content_noti_h *noti_handle)
 846 {
 847         int ret = MEDIA_CONTENT_ERROR_NONE;
 848         media_noti_cb_s *noti_info = NULL;
 849
 850         if (noti_handle == NULL) {
 851                 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
 852                 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
 853         }
 854
 855         if (callback == NULL) {
 856                 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
 857                 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
 858         }
 859
 860         noti_info = (media_noti_cb_s *)calloc(1, sizeof(media_noti_cb_s));
 861         if (noti_info == NULL) {
 862                 media_content_error("Failed to create noti info");
 863                 return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
 864         }
 865
 866         noti_info->update_noti_cb = callback;
 867         noti_info->user_data = user_data;
 868
 869         ret = media_db_update_subscribe_internal((MediaNotiHandle*)noti_handle, _media_content_db_update_noti_cb, (void *)noti_info);
 870
 871         return _content_error_capi(MEDIA_REGISTER_TYPE, ret);
 872 }
 873
 874 void __media_content_clear_user_data(void *user_data)
 875 {
 876         media_noti_cb_s *noti_info = user_data;
 877
 878         SAFE_FREE(noti_info);
 879
 880         return;
 881 }
 882
 883 int media_content_remove_db_updated_cb(media_content_noti_h noti_handle)
 884 {
 885         int ret = MEDIA_CONTENT_ERROR_NONE;
 886
 887         ret = media_db_update_unsubscribe_internal((MediaNotiHandle)noti_handle, __media_content_clear_user_data);
 888
 889         return _content_error_capi(MEDIA_REGISTER_TYPE, ret);
 890 }
 891 #ifdef _USE_TVPD_MODE
 892 GMutex* _content_get_db_mutex(void)
 893 {
 894         return &db_mutex;
 895 }
 896 #endif