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