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 sqlite3 *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,                                 NULL},
 100         {PLAYLIST_MEMBER_ORDER,         DB_FIELD_PLAYLIST_MEMBER_ORDER,                         NULL},
 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,                                              NULL},
 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,                                           NULL},
 114         {BOOKMARK_MARKED_TIME,          DB_FIELD_BOOKMARK_MARKED_TIME,                          NULL},
 115         {BOOKMARK_NAME,                         DB_FIELD_BOOKMARK_NAME,                                         NULL},
 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,                                               NULL},
 123         {MEDIA_FACE_TAG,                                DB_FIELD_FACE_TAG,                                              NULL},
 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         /* This API use only folder query */
 293         return g_alias_attr_handle;
 294 }
 295
 296 sqlite3 * _content_get_db_handle(void)
 297 {
 298         return db_handle;
 299 }
 300
 301 uid_t _content_get_uid(void)
 302 {
 303         if (content_g_uid == 0)
 304                 return tzplatform_getuid(TZ_USER_NAME);
 305         else
 306                 return content_g_uid;
 307 }
 308
 309 int _content_query_prepare(sqlite3_stmt **stmt, char *select_query, char *condition_query, char *option_query)
 310 {
 311         int len = 0;
 312         int err = MEDIA_CONTENT_ERROR_NONE;
 313         char query[MAX_QUERY_SIZE] = {0, };
 314         memset(query, '\0', sizeof(query));
 315
 316         media_content_retvm_if(db_handle == NULL, MEDIA_CONTENT_ERROR_DB_FAILED, "database is not connected");
 317         media_content_retvm_if(!STRING_VALID(select_query), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "invalid select_query");
 318
 319         if (!STRING_VALID(condition_query))
 320                 condition_query = (char *)" ";
 321
 322         if (!STRING_VALID(option_query))
 323                 option_query = (char *)" ";
 324
 325         /*query = sqlite3_mprintf("%s %s %s", select_query, condition_query, option_query);*/
 326         len = snprintf(query, sizeof(query), "%s %s %s", select_query, condition_query, option_query);
 327         if (len > 0 && len < sizeof(query))
 328                 query[len] = '\0';
 329         else if (len >= sizeof(query))
 330                 query[MAX_QUERY_SIZE -1] = '\0';
 331         else {
 332                 media_content_error("snprintf failed");
 333                 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
 334         }
 335
 336         media_content_sec_debug("Query : [%s]", query);
 337
 338         err = sqlite3_prepare_v2(db_handle, query, strlen(query), stmt, NULL);
 339         if (err != SQLITE_OK) {
 340                 media_content_error("DB_FAILED(0x%08x) fail to sqlite3_prepare(), %s", MEDIA_CONTENT_ERROR_DB_FAILED, sqlite3_errmsg(db_handle));
 341
 342                 if (err == SQLITE_BUSY) {
 343                         media_content_error(" BUSY ERROR");
 344                         return MEDIA_CONTENT_ERROR_DB_BUSY;
 345                 } else if (err == SQLITE_PERM) {
 346                         media_content_error("PERMISSION EROR");
 347                         return MEDIA_CONTENT_ERROR_PERMISSION_DENIED;
 348                 } else {
 349                         media_content_error("OTHER ERROR");
 350                         return MEDIA_CONTENT_ERROR_DB_FAILED;
 351                 }
 352         }
 353
 354         return MEDIA_CONTENT_ERROR_NONE;
 355 }
 356
 357 #ifdef _USE_SENIOR_MODE
 358 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)
 359 {
 360         int len = 0;
 361         int err = MEDIA_CONTENT_ERROR_NONE;
 362         char query[MAX_QUERY_SIZE] = {0, };
 363         memset(query, '\0', sizeof(query));
 364
 365         media_content_retvm_if(db_handle == NULL, MEDIA_CONTENT_ERROR_DB_FAILED, "database is not connected");
 366         media_content_retvm_if(!STRING_VALID(select_query1), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "invalid select_query1");
 367         media_content_retvm_if(!STRING_VALID(select_query2), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "invalid select_query2");
 368
 369         if (!STRING_VALID(condition_query1))
 370                 condition_query1 = (char *)" ";
 371
 372         if (!STRING_VALID(option_query1))
 373                 option_query1 = (char *)" ";
 374
 375         if (!STRING_VALID(condition_query2))
 376                 condition_query2 = (char *)" ";
 377
 378         if (!STRING_VALID(option_query2))
 379                 option_query2 = (char *)" ";
 380
 381         len = snprintf(query, sizeof(query), "SELECT * FROM (%s %s %s) as table1 UNION ALL SELECT * FROM (%s %s %s) as table2",
 382                         select_query1, condition_query1, option_query1, select_query2, condition_query2, option_query2);
 383         if (len > 0 && len < sizeof(query)) {
 384                 query[len] = '\0';
 385         } else if (len >= sizeof(query)) {
 386                 query[MAX_QUERY_SIZE -1] = '\0';
 387         } else {
 388                 media_content_error("snprintf failed");
 389                 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
 390         }
 391
 392         media_content_sec_debug("Query : [%s]", query);
 393
 394         err = sqlite3_prepare_v2(db_handle, query, strlen(query), stmt, NULL);
 395         if (err != SQLITE_OK) {
 396                 media_content_error("DB_FAILED(0x%08x) fail to sqlite3_prepare(), %s", MEDIA_CONTENT_ERROR_DB_FAILED, sqlite3_errmsg(db_handle));
 397
 398                 if (err == SQLITE_BUSY) {
 399                         media_content_error(" BUSY ERROR");
 400                         return MEDIA_CONTENT_ERROR_DB_BUSY;
 401                 } else if (err == SQLITE_PERM) {
 402                         media_content_error("PERMISSION EROR");
 403                         return MEDIA_CONTENT_ERROR_PERMISSION_DENIED;
 404                 } else {
 405                         media_content_error("OTHER ERROR");
 406                         return MEDIA_CONTENT_ERROR_DB_FAILED;
 407                 }
 408         }
 409
 410         return MEDIA_CONTENT_ERROR_NONE;
 411 }
 412 #endif
 413
 414 int _content_error_capi(int type, int content_error)
 415 {
 416         if (content_error != MEDIA_CONTENT_ERROR_NONE)
 417                 media_content_error("[type : %d] content_error : %d ", type, content_error);
 418
 419         /*Error None*/
 420         if (content_error == MS_MEDIA_ERR_NONE)
 421                 return MEDIA_CONTENT_ERROR_NONE;
 422
 423         /* Internal operation error*/
 424         else if ((content_error == MS_MEDIA_ERR_INVALID_PARAMETER) ||
 425                 (content_error == MS_MEDIA_ERR_INVALID_PATH) ||
 426                 (content_error == MS_MEDIA_ERR_THUMB_DUPLICATED_REQUEST))
 427                 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
 428
 429         else if (content_error == MS_MEDIA_ERR_OUT_OF_MEMORY)
 430                 return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
 431
 432         /* DB operation error*/
 433         else if (content_error == MS_MEDIA_ERR_DB_BUSY_FAIL)
 434                 return MEDIA_CONTENT_ERROR_DB_BUSY;
 435
 436         else if ((content_error <= MS_MEDIA_ERR_DB_CONNECT_FAIL) && (content_error >= MS_MEDIA_ERR_DB_INTERNAL))
 437                 return MEDIA_CONTENT_ERROR_DB_FAILED;
 438
 439         /* IPC operation error*/
 440         else if ((content_error <= MS_MEDIA_ERR_SOCKET_CONN) && (content_error >= MS_MEDIA_ERR_SOCKET_INTERNAL))
 441                 return MEDIA_CONTENT_ERROR_NETWORK;
 442
 443         /* MEDIA SERVER error*/
 444         else if (content_error == MS_MEDIA_ERR_PERMISSION_DENIED)
 445                 return MEDIA_CONTENT_ERROR_PERMISSION_DENIED;
 446
 447         /* Thumbnail error*/
 448         else if ((content_error == MS_MEDIA_ERR_THUMB_TOO_BIG) || (content_error == MS_MEDIA_ERR_THUMB_UNSUPPORTED))
 449                         return MEDIA_CONTENT_ERROR_UNSUPPORTED_CONTENT;
 450
 451         /*ETC*/
 452         return MEDIA_CONTENT_ERROR_INVALID_OPERATION;
 453 }
 454
 455 int _content_query_sql(char *query_str)
 456 {
 457         int ret = MEDIA_CONTENT_ERROR_NONE;
 458
 459         /*DB will be updated by Media Server.*/
 460         ret = media_db_request_update_db(query_str, _content_get_uid());
 461
 462         return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
 463 }
 464
 465 int media_content_connect(void)
 466 {
 467         int ret = MEDIA_CONTENT_ERROR_NONE;
 468
 469         g_mutex_lock(&db_mutex);
 470         media_content_info("ref count : %d", ref_count);
 471
 472         if (ref_count == 0) {
 473                 if (db_handle == NULL) {
 474                         ret = __media_content_create_attribute_handles();
 475                         if (ret == MEDIA_CONTENT_ERROR_NONE) {
 476                                 ret = media_db_connect(&db_handle, _content_get_uid(), false);
 477                                 ret = _content_error_capi(MEDIA_CONTENT_TYPE, ret);
 478                                 if (ret == MEDIA_CONTENT_ERROR_NONE)
 479                                         ref_count++;
 480                                 else
 481                                         __media_content_destroy_attribute_handle();
 482
 483                         } else {
 484                                 media_content_error("Internal DB Connection Error");
 485                         }
 486                 } else {
 487                         media_content_error("Wrong DB Connection status");
 488                         ret = MEDIA_CONTENT_ERROR_DB_FAILED;
 489                 }
 490         } else {
 491                 if (db_handle != NULL) {
 492                         ref_count++;
 493                 } else {
 494                         media_content_error("Wrong DB Handle status");
 495                         ret = MEDIA_CONTENT_ERROR_DB_FAILED;
 496                 }
 497         }
 498
 499         media_content_info("ref count changed to: %d", ref_count);
 500         g_mutex_unlock(&db_mutex);
 501
 502         return ret;
 503 }
 504
 505 int media_content_connect_with_uid(uid_t uid)
 506 {
 507         media_content_sec_debug("media_content_connect_with_uid [%d]", uid);
 508         content_g_uid = uid;
 509
 510         return media_content_connect();
 511 }
 512
 513 int media_content_disconnect(void)
 514 {
 515         int ret = MEDIA_CONTENT_ERROR_NONE;
 516
 517         g_mutex_lock(&db_mutex);
 518         media_content_debug("ref count : %d", ref_count);
 519         if (ref_count > 0) {
 520                 if (db_handle != NULL) {
 521                         ref_count--;
 522                 } else {
 523                         media_content_error("Wrong DB Handle status");
 524                         ret = MEDIA_CONTENT_ERROR_DB_FAILED;
 525                 }
 526         } else {
 527                 media_content_error("DB_FAILED(0x%08x) database is not connected", MEDIA_CONTENT_ERROR_DB_FAILED);
 528                 g_mutex_unlock(&db_mutex);
 529                 return MEDIA_CONTENT_ERROR_DB_FAILED;
 530         }
 531
 532         if (ref_count == 0) {
 533                 if (db_handle != NULL) {
 534                         ret = media_db_disconnect(db_handle);
 535                         ret = _content_error_capi(MEDIA_CONTENT_TYPE, ret);
 536                         if (ret == MEDIA_CONTENT_ERROR_NONE) {
 537                                 ret = __media_content_destroy_attribute_handle();
 538                                 db_handle = NULL;
 539                         } else {
 540                                 media_content_error("database disconnect fail");
 541                                 ref_count++;
 542                         }
 543                 } else {
 544                         media_content_error("Wrong DB Handle status");
 545                         ret = MEDIA_CONTENT_ERROR_DB_FAILED;
 546                 }
 547
 548                 g_mutex_unlock(&db_mutex);
 549
 550                 media_content_info("ref count changed to: %d", ref_count);
 551
 552                 return ret;
 553         }
 554
 555         g_mutex_unlock(&db_mutex);
 556
 557         media_content_info("ref count changed to: %d", ref_count);
 558
 559         return ret;
 560 }
 561
 562 int media_content_scan_file(const char *path)
 563 {
 564         int ret = MEDIA_CONTENT_ERROR_NONE;
 565         bool ignore_file = FALSE;
 566         bool ignore_dir = FALSE;
 567         char *folder_path = NULL;
 568         int check_file = MEDIA_CONTENT_ERROR_NONE;
 569         char storage_id[MEDIA_CONTENT_UUID_SIZE+1] = {0,};
 570         char repl_path[MAX_PATH_LEN] = {0,};
 571
 572         media_content_retvm_if(!STRING_VALID(path), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "invalid path");
 573
 574         media_content_sec_debug("Path : %s", path);
 575
 576         memset(repl_path, 0, sizeof(repl_path));
 577         ret = _media_content_replace_path(path, repl_path);
 578         media_content_retvm_if(!STRING_VALID(repl_path), MEDIA_CONTENT_ERROR_INVALID_OPERATION, "path replacement failed");
 579
 580         ret = _media_util_check_ignore_file(repl_path, &ignore_file);
 581         media_content_retvm_if(ignore_file == TRUE, MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid path");
 582
 583         memset(storage_id, 0x00, sizeof(storage_id));
 584         ret = media_svc_get_storage_id(_content_get_db_handle(), repl_path, storage_id, _content_get_uid());
 585         if (ret != MS_MEDIA_ERR_NONE) {
 586                 media_content_error("media_svc_get_storage_id failed : %d", ret);
 587                 return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
 588         }
 589
 590         check_file = _media_util_check_file_exist(repl_path);
 591         if (check_file == MEDIA_CONTENT_ERROR_NONE) {
 592                 /* This means this path has to be inserted or refreshed */
 593                 folder_path = g_path_get_dirname(repl_path);
 594                 ret = _media_util_check_ignore_dir(folder_path, &ignore_dir);
 595                 SAFE_FREE(folder_path);
 596
 597                 media_content_retvm_if(ignore_dir == TRUE, MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid folder path");
 598                 /* check feature */
 599                 media_content_retvm_if(!_media_util_check_support_media_type(repl_path), MEDIA_CONTENT_ERROR_NOT_SUPPORTED, "Unsupported media type");
 600
 601                 ms_user_storage_type_e storage_type;
 602
 603                 ret = ms_user_get_storage_type(_content_get_uid(), repl_path, &storage_type);
 604                 if (ret != MS_MEDIA_ERR_NONE) {
 605                         media_content_sec_error("ms_user_get_storage_type failed : %d (%s)", ret, repl_path);
 606                         return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
 607                 }
 608                 ret = media_svc_check_item_exist_by_path(_content_get_db_handle(), storage_id, repl_path);
 609                 if (ret == MS_MEDIA_ERR_NONE) {
 610                         /* Refresh */
 611                         ret = media_svc_refresh_item(_content_get_db_handle(), storage_id, storage_type, repl_path, _content_get_uid());
 612                         if (ret != MS_MEDIA_ERR_NONE) {
 613                                 media_content_error("media_svc_refresh_item failed : %d", ret);
 614                                 return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
 615                         }
 616
 617                 } else if (ret == MS_MEDIA_ERR_DB_NO_RECORD) {
 618                         /* Insert */
 619                         ret = media_svc_insert_item_immediately(_content_get_db_handle(), storage_id, storage_type, repl_path, _content_get_uid());
 620                         if (ret != MS_MEDIA_ERR_NONE) {
 621                                 if (ret == MS_MEDIA_ERR_DB_CONSTRAINT_FAIL) {
 622                                         media_content_sec_error("This item is already inserted. This may be normal operation because other process already did this (%s)", repl_path);
 623                                         ret = MEDIA_CONTENT_ERROR_NONE;
 624                                 } else {
 625                                         media_content_sec_error("media_svc_insert_item_immediately failed : %d (%s)", ret, repl_path);
 626                                 }
 627
 628                                 return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
 629                         }
 630                 } else {
 631                         media_content_error("media_svc_check_item_exist_by_path failed : %d", ret);
 632                         return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
 633                 }
 634         } else if (check_file == MEDIA_CONTENT_ERROR_PERMISSION_DENIED) {
 635                 media_content_error("You have no permission for this file %d", ret);
 636                 return MEDIA_CONTENT_ERROR_PERMISSION_DENIED;
 637         } else {
 638                 /* This means this path has to be deleted */
 639                 media_content_debug("This path doesn't exists in file system... So now start to delete it from DB");
 640                 ret = media_svc_delete_item_by_path(_content_get_db_handle(), storage_id, repl_path, _content_get_uid());
 641                 if (ret != MS_MEDIA_ERR_NONE) {
 642                         if (ret == MS_MEDIA_ERR_DB_NO_RECORD) {
 643                                 media_content_error("Does not exist in media DB also... So, this is an invalid parameter");
 644                                 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
 645                         }
 646
 647                         media_content_error("media_svc_delete_item_by_path failed : %d", ret);
 648                         return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
 649                 }
 650         }
 651
 652         return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
 653 }
 654
 655 void _media_content_scan_cb(media_request_result_s* result, void *user_data)
 656 {
 657         int err = -1;
 658         media_content_scan_cb_data *cb_data = user_data;
 659
 660         err = _content_error_capi(MEDIA_REGISTER_TYPE, result->result);
 661 #ifdef _USE_TVPD_MODE
 662         if (result->request_type != MEDIA_REQUEST_SCAN_COMPLETE &&
 663                 result->request_type != MEDIA_REQUEST_SCAN_PARTIAL) {
 664                 if (cb_data && cb_data->callback) {
 665                         media_content_debug("begin:User callback is being called now, result=%d", err);
 666                         cb_data->callback(err, cb_data->user_data);
 667                         media_content_debug("end:User callback is being called now, result=%d", err);
 668                 }
 669
 670                 SAFE_FREE(cb_data);
 671         }
 672 #else
 673         if (cb_data && cb_data->callback) {
 674                 media_content_debug("User callback is being called now");
 675                 cb_data->callback(err, cb_data->user_data);
 676         }
 677
 678         SAFE_FREE(cb_data);
 679 #endif
 680
 681         return;
 682 }
 683
 684 #ifdef _USE_TVPD_MODE
 685 void _media_content_scan_cb_v2(media_request_result_s* result, void *user_data)
 686 {
 687         int err = -1;
 688         media_content_scan_cb_data_v2 *cb_data = user_data;
 689         media_content_complete_phase_e complete_phase = -1;
 690         if (!cb_data)
 691                 media_content_debug("cb_data is NULL");
 692         err = _content_error_capi(MEDIA_REGISTER_TYPE, result->result);
 693         media_content_debug("result is %d", err);
 694
 695         if (result->request_type == MEDIA_REQUEST_SCAN_PARTIAL)
 696                 complete_phase = MEDIA_CONTENT_SCAN_PARTIAL_COMPLETE;
 697         else if (result->request_type == MEDIA_REQUEST_SCAN_COMPLETE)
 698                 complete_phase = MEDIA_CONTENT_SCAN_COMPLETE;
 699         else if (result->request_type == MEDIA_REQUEST_EXTRACT_COMPLETE)
 700                 complete_phase = MEDIA_CONTENT_EXTRACT_COMPLETE;
 701
 702         if (cb_data && cb_data->callback)
 703                 cb_data->callback(err, complete_phase, cb_data->user_data);
 704         else
 705                 media_content_debug("run error");
 706
 707         if ((result->request_type != MEDIA_REQUEST_SCAN_COMPLETE) &&
 708         (result->request_type != MEDIA_REQUEST_SCAN_PARTIAL))
 709                 SAFE_FREE(cb_data);
 710
 711         return;
 712 }
 713 #endif
 714
 715 int media_content_scan_folder(const char *path, bool is_recursive, media_scan_completed_cb callback, void *user_data)
 716 {
 717         int ret = MEDIA_CONTENT_ERROR_NONE;
 718         bool ignore_dir = FALSE;
 719         char storage_id[MEDIA_CONTENT_UUID_SIZE+1] = {0, };
 720         char repl_path[MAX_PATH_LEN] = {0, };
 721         ms_user_storage_type_e storage_type = MS_USER_STORAGE_INTERNAL;
 722
 723         media_content_retvm_if(!STRING_VALID(path), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid path");
 724         memset(repl_path, 0, sizeof(repl_path));
 725         ret = _media_content_replace_path(path, repl_path);
 726         media_content_retvm_if(!STRING_VALID(repl_path), MEDIA_CONTENT_ERROR_INVALID_OPERATION, "path replacement failed");
 727
 728         memset(storage_id, 0x00, sizeof(storage_id));
 729
 730         ret = _media_content_check_dir(repl_path);
 731         media_content_retvm_if(ret == MEDIA_CONTENT_ERROR_PERMISSION_DENIED, ret, "Permission Denied");
 732
 733         if (ret == MEDIA_CONTENT_ERROR_NONE) {
 734                 /* If directory exist check that's ignore directory or not*/
 735                 ret = _media_util_check_ignore_dir(repl_path, &ignore_dir);
 736                 media_content_retvm_if((ignore_dir == TRUE || ret != MEDIA_CONTENT_ERROR_NONE), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid folder path");
 737         } else {
 738                 /* This means this folder has to be deleted */
 739                 /* Or, it is real invalid path.. check storage type */
 740                 ret = ms_user_get_storage_type(_content_get_uid(), repl_path, &storage_type);
 741                 if (ret != MS_MEDIA_ERR_NONE) {
 742                         media_content_sec_error("ms_user_get_storage_type failed : %d (%s)", ret, repl_path);
 743                         return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
 744                 }
 745
 746                 media_content_debug("This path doesn't exists in file system... So will be deleted it from DB");
 747         }
 748
 749         ret = media_svc_get_storage_id(_content_get_db_handle(), repl_path, storage_id, _content_get_uid());
 750         if (ret != MS_MEDIA_ERR_NONE) {
 751                 media_content_error("media_svc_get_storage_id failed : %d", ret);
 752                 return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
 753         }
 754
 755         media_content_scan_cb_data *cb_data = NULL;
 756         cb_data = (media_content_scan_cb_data *)malloc(sizeof(media_content_scan_cb_data));
 757         media_content_retvm_if(cb_data == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY");
 758
 759         cb_data->callback = callback;
 760         cb_data->user_data = user_data;
 761
 762         ret = media_directory_scanning_async(repl_path, storage_id, is_recursive, _media_content_scan_cb, cb_data, _content_get_uid());
 763         if (ret != MS_MEDIA_ERR_NONE) {
 764                 media_content_error("media_directory_scanning_async failed : %d", ret);
 765                 SAFE_FREE(cb_data);
 766         }
 767
 768         return _content_error_capi(MEDIA_REGISTER_TYPE, ret);
 769 }
 770
 771 #ifdef _USE_TVPD_MODE
 772 int media_content_scan_folder_v2(const char *path, bool is_recursive, media_scan_completed_cb_v2 callback, void *user_data)
 773 {
 774         int ret = MEDIA_CONTENT_ERROR_NONE;
 775         bool ignore_dir = FALSE;
 776         char storage_id[MEDIA_CONTENT_UUID_SIZE+1] = {0, };
 777
 778         media_content_retvm_if(!STRING_VALID(path), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid path");
 779         memset(storage_id, 0x00, sizeof(storage_id));
 780
 781         ret = _media_util_check_ignore_dir(path, &ignore_dir);
 782         media_content_retvm_if(ignore_dir, MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid folder path");
 783
 784         ret = _media_content_check_dir(path);
 785         media_content_retvm_if(ret == MEDIA_CONTENT_ERROR_PERMISSION_DENIED, ret, "Permission Denied");
 786         media_content_retvm_if(ret == MEDIA_CONTENT_ERROR_INVALID_PARAMETER, ret, "invalid path[%s]", path);
 787
 788         media_content_scan_cb_data_v2* cb_data = NULL;
 789         cb_data = (media_content_scan_cb_data_v2*)malloc(sizeof(media_content_scan_cb_data_v2));
 790         media_content_retvm_if(cb_data == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY");
 791
 792         cb_data->callback = callback;
 793         cb_data->user_data = user_data;
 794
 795         ret = media_svc_get_storage_id(_content_get_db_handle(), path, storage_id, _content_get_uid());
 796         /*FIX ME. need to check ret value?*/
 797
 798         ret = media_directory_scanning_async(path, storage_id, is_recursive, _media_content_scan_cb_v2, cb_data, _content_get_uid());
 799         if (ret != MS_MEDIA_ERR_NONE)
 800                 media_content_error("media_directory_scanning_async failed : %d", ret);
 801
 802         return _content_error_capi(MEDIA_REGISTER_TYPE, ret);
 803 }
 804 #endif
 805
 806 int media_content_cancel_scan_folder(const char *path)
 807 {
 808         int ret = MEDIA_CONTENT_ERROR_NONE;
 809         char repl_path[MAX_PATH_LEN] = {0, };
 810
 811         media_content_retvm_if(!STRING_VALID(path), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid path");
 812
 813         memset(repl_path, 0, sizeof(repl_path));
 814         ret = _media_content_replace_path(path, repl_path);
 815         media_content_retvm_if(!STRING_VALID(repl_path), MEDIA_CONTENT_ERROR_INVALID_OPERATION, "path replacement failed");
 816
 817         ret = media_directory_scanning_cancel(repl_path, _content_get_uid());
 818         if (ret != MS_MEDIA_ERR_NONE)
 819                 media_content_error("media_directory_scanning_async failed : %d", ret);
 820
 821         return _content_error_capi(MEDIA_REGISTER_TYPE, ret);
 822 }
 823
 824 void _media_content_db_update_noti_cb(
 825                                                         int pid,
 826                                                         media_item_type_e item,
 827                                                         media_item_update_type_e update_type,
 828                                                         char* path,
 829                                                         char* uuid,
 830                                                         media_type_e content_type,
 831                                                         char *mime_type,
 832                                                         void *user_data)
 833 {
 834         int error_value = MEDIA_CONTENT_ERROR_NONE;
 835
 836         media_noti_cb_s *_noti_info = (media_noti_cb_s *)user_data;
 837
 838         if (_noti_info != NULL) {
 839                 if (_noti_info->update_noti_cb)
 840                         _noti_info->update_noti_cb(error_value, pid, item, update_type, content_type, uuid, path, mime_type, _noti_info->user_data);
 841         }
 842
 843         return;
 844 }
 845
 846 int media_content_add_db_updated_cb(media_content_db_update_cb callback, void *user_data, media_content_noti_h *noti_handle)
 847 {
 848         int ret = MEDIA_CONTENT_ERROR_NONE;
 849         media_noti_cb_s *noti_info = NULL;
 850
 851         if (noti_handle == NULL) {
 852                 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
 853                 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
 854         }
 855
 856         if (callback == NULL) {
 857                 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
 858                 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
 859         }
 860
 861         noti_info = (media_noti_cb_s *)calloc(1, sizeof(media_noti_cb_s));
 862         if (noti_info == NULL) {
 863                 media_content_error("Failed to create noti info");
 864                 return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
 865         }
 866
 867         noti_info->update_noti_cb = callback;
 868         noti_info->user_data = user_data;
 869
 870         ret = media_db_update_subscribe_internal((MediaNotiHandle*)noti_handle, _media_content_db_update_noti_cb, (void *)noti_info);
 871
 872         return _content_error_capi(MEDIA_REGISTER_TYPE, ret);
 873 }
 874
 875 void __media_content_clear_user_data(void *user_data)
 876 {
 877         media_noti_cb_s *noti_info = user_data;
 878
 879         SAFE_FREE(noti_info);
 880
 881         return;
 882 }
 883
 884 int media_content_remove_db_updated_cb(media_content_noti_h noti_handle)
 885 {
 886         int ret = MEDIA_CONTENT_ERROR_NONE;
 887
 888         ret = media_db_update_unsubscribe_internal((MediaNotiHandle)noti_handle, __media_content_clear_user_data);
 889
 890         return _content_error_capi(MEDIA_REGISTER_TYPE, ret);
 891 }
 892 #ifdef _USE_TVPD_MODE
 893 GMutex* _content_get_db_mutex(void)
 894 {
 895         return &db_mutex;
 896 }
 897 #endif