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