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