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