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