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