2 * Copyright (c) 2011 Samsung Electronics Co., Ltd All Rights Reserved
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
8 * http://www.apache.org/licenses/LICENSE-2.0
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.
18 #include <media_info_private.h>
19 #include <media_util_private.h>
21 static sqlite3 *db_handle = NULL;
22 static int ref_count = 0;
23 static GMutex db_mutex;
24 static uid_t content_g_uid = 0;
26 sqlite3 * _content_get_db_handle(void)
31 uid_t _content_get_uid(void)
33 if (content_g_uid == 0)
34 return tzplatform_getuid(TZ_USER_NAME);
39 int _content_query_prepare(const char *select_query, const char *condition_query, const char *option_query, sqlite3_stmt **stmt)
41 int ret = MEDIA_CONTENT_ERROR_NONE;
44 content_retip_if_fail(select_query);
46 /* If 'option_query' is NULL, 'condition_query' is also NULL. */
48 if (STRING_VALID(condition_query))
49 query = sqlite3_mprintf("%s AND %s %s", select_query, condition_query, option_query);
51 query = sqlite3_mprintf("%s %s", select_query, option_query);
54 query = sqlite3_mprintf("%s", select_query);
57 ret = _content_get_result(query, stmt);
58 SQLITE3_SAFE_FREE(query);
63 int _content_get_result(char *query, sqlite3_stmt **stmt)
65 int err = MEDIA_CONTENT_ERROR_NONE;
67 content_retip_if_fail(_content_get_db_handle());
68 content_retip_if_fail(query);
70 content_sec_debug("Query[%s]", query);
72 err = sqlite3_prepare_v2(_content_get_db_handle(), query, strlen(query), stmt, NULL);
73 if (err != SQLITE_OK) {
74 content_error("Failed to sqlite3_prepare_v2[%s]", sqlite3_errmsg(_content_get_db_handle()));
75 if (err == SQLITE_BUSY)
76 return MEDIA_CONTENT_ERROR_DB_BUSY;
77 else if (err == SQLITE_PERM)
78 return MEDIA_CONTENT_ERROR_PERMISSION_DENIED;
80 return MEDIA_CONTENT_ERROR_DB_FAILED;
83 return MEDIA_CONTENT_ERROR_NONE;
86 int _content_error_capi(int internal_error)
88 if (internal_error == MS_MEDIA_ERR_NONE)
89 return MEDIA_CONTENT_ERROR_NONE;
91 content_error("MS Error[%d]", internal_error);
93 switch (internal_error) {
94 case MS_MEDIA_ERR_INVALID_PARAMETER:
95 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
96 case MS_MEDIA_ERR_OUT_OF_MEMORY:
97 return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
98 case MS_MEDIA_ERR_DB_BUSY_FAIL:
99 return MEDIA_CONTENT_ERROR_DB_BUSY;
100 case MS_MEDIA_ERR_DB_CONSTRAINT_FAIL:
101 case MS_MEDIA_ERR_DB_NO_RECORD:
102 case MS_MEDIA_ERR_DB_CORRUPT:
103 case MS_MEDIA_ERR_DB_FULL_FAIL:
104 case MS_MEDIA_ERR_DB_RESET:
105 case MS_MEDIA_ERR_DB_INTERNAL:
106 return MEDIA_CONTENT_ERROR_DB_FAILED;
107 case MS_MEDIA_ERR_IPC:
108 return MEDIA_CONTENT_ERROR_NETWORK;
109 case MS_MEDIA_ERR_PERMISSION_DENIED:
110 return MEDIA_CONTENT_ERROR_PERMISSION_DENIED;
111 case MS_MEDIA_ERR_THUMB_TOO_BIG:
112 case MS_MEDIA_ERR_THUMB_UNSUPPORTED:
113 return MEDIA_CONTENT_ERROR_UNSUPPORTED_CONTENT;
115 return MEDIA_CONTENT_ERROR_INVALID_OPERATION;
119 int _content_query_sql(char *query_str)
121 int ret = MEDIA_CONTENT_ERROR_NONE;
123 /*DB will be updated by Media Server.*/
124 ret = media_db_request_update_db(query_str, _content_get_uid());
126 return _content_error_capi(ret);
129 int media_content_connect(void)
131 int ret = MEDIA_CONTENT_ERROR_NONE;
133 g_mutex_lock(&db_mutex);
134 content_info("ref count : %d", ref_count);
136 if (ref_count == 0) {
137 if (db_handle == NULL) {
138 ret = media_db_connect(&db_handle, _content_get_uid(), false);
139 ret = _content_error_capi(ret);
140 if (ret == MEDIA_CONTENT_ERROR_NONE)
143 content_error("Wrong DB Connection status");
144 ret = MEDIA_CONTENT_ERROR_DB_FAILED;
147 if (db_handle != NULL) {
150 content_error("Wrong DB Handle status");
151 ret = MEDIA_CONTENT_ERROR_DB_FAILED;
155 content_info("ref count changed to: %d", ref_count);
156 g_mutex_unlock(&db_mutex);
161 int media_content_connect_with_uid(uid_t uid)
163 content_sec_debug("media_content_connect_with_uid [%d]", uid);
166 return media_content_connect();
169 int media_content_disconnect(void)
171 g_mutex_lock(&db_mutex);
172 content_debug("ref count : %d", ref_count);
174 if (db_handle && ref_count > 0) {
175 if (--ref_count == 0) {
176 media_db_disconnect(db_handle);
180 content_error("Database is not connected");
181 g_mutex_unlock(&db_mutex);
182 return MEDIA_CONTENT_ERROR_DB_FAILED;
185 g_mutex_unlock(&db_mutex);
187 content_info("ref count changed to: %d", ref_count);
189 return MEDIA_CONTENT_ERROR_NONE;
192 int media_content_scan_file(const char *path)
194 int ret = MEDIA_CONTENT_ERROR_NONE;
195 char *folder_path = NULL;
196 int check_file = MEDIA_CONTENT_ERROR_NONE;
197 char storage_id[MEDIA_CONTENT_UUID_SIZE+1] = {0,};
198 char repl_path[MAX_PATH_LEN] = {0,};
200 content_retip_if_fail(STRING_VALID(path));
202 content_sec_debug("Path : %s", path);
204 ret = _media_content_replace_path(path, repl_path);
205 content_retvm_if(!STRING_VALID(repl_path), MEDIA_CONTENT_ERROR_INVALID_OPERATION, "path replacement failed");
207 content_retvm_if(_media_util_is_ignorable_file(repl_path), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid path");
209 ret = media_svc_get_storage_id(_content_get_db_handle(), repl_path, storage_id, _content_get_uid());
210 if (ret != MS_MEDIA_ERR_NONE) {
211 content_error("media_svc_get_storage_id failed : %d", ret);
212 return _content_error_capi(ret);
215 check_file = _media_util_check_file_exist(repl_path);
216 if (check_file == MEDIA_CONTENT_ERROR_NONE) {
217 /* This means this path has to be inserted or refreshed */
218 folder_path = g_path_get_dirname(repl_path);
220 if (_media_util_is_ignorable_dir(folder_path)) {
222 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
226 content_retvm_if(!_media_util_check_support_media_type(repl_path), MEDIA_CONTENT_ERROR_NOT_SUPPORTED, "Unsupported media type");
228 ms_user_storage_type_e storage_type;
230 ret = ms_user_get_storage_type(_content_get_uid(), repl_path, &storage_type);
231 if (ret != MS_MEDIA_ERR_NONE) {
232 content_sec_error("ms_user_get_storage_type failed : %d (%s)", ret, repl_path);
233 return _content_error_capi(ret);
235 ret = media_svc_check_item_exist_by_path(_content_get_db_handle(), storage_id, repl_path);
236 if (ret == MS_MEDIA_ERR_NONE) {
238 ret = media_svc_refresh_item(_content_get_db_handle(), false, storage_id, storage_type, repl_path, _content_get_uid());
239 if (ret != MS_MEDIA_ERR_NONE) {
240 content_error("media_svc_refresh_item failed : %d", ret);
241 return _content_error_capi(ret);
244 } else if (ret == MS_MEDIA_ERR_DB_NO_RECORD) {
246 ret = media_svc_insert_item_immediately(_content_get_db_handle(), storage_id, storage_type, repl_path, _content_get_uid());
247 if (ret != MS_MEDIA_ERR_NONE) {
248 if (ret == MS_MEDIA_ERR_DB_CONSTRAINT_FAIL) {
249 content_sec_error("This item is already inserted. This may be normal operation because other process already did this (%s)", repl_path);
250 ret = MEDIA_CONTENT_ERROR_NONE;
252 content_sec_error("media_svc_insert_item_immediately failed : %d (%s)", ret, repl_path);
255 return _content_error_capi(ret);
258 content_error("media_svc_check_item_exist_by_path failed : %d", ret);
259 return _content_error_capi(ret);
261 } else if (check_file == MEDIA_CONTENT_ERROR_PERMISSION_DENIED) {
262 content_error("You have no permission for this file %d", ret);
263 return MEDIA_CONTENT_ERROR_PERMISSION_DENIED;
265 /* This means this path has to be deleted */
266 content_debug("This path doesn't exists in file system... So now start to delete it from DB");
267 ret = media_svc_delete_item_by_path(_content_get_db_handle(), storage_id, repl_path, _content_get_uid());
268 if (ret != MS_MEDIA_ERR_NONE) {
269 if (ret == MS_MEDIA_ERR_DB_NO_RECORD) {
270 content_error("Does not exist in media DB also... So, this is an invalid parameter");
271 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
274 content_error("media_svc_delete_item_by_path failed : %d", ret);
275 return _content_error_capi(ret);
279 return _content_error_capi(ret);
282 void _media_content_scan_cb(media_request_result_s* result, void *user_data)
285 media_content_scan_cb_data *cb_data = user_data;
287 err = _content_error_capi(result->result);
288 #ifdef _USE_TVPD_MODE
289 if (result->request_type != MEDIA_REQUEST_SCAN_COMPLETE &&
290 result->request_type != MEDIA_REQUEST_SCAN_PARTIAL &&
291 result->request_type != MEDIA_RECURSIVE_START) {
292 if (cb_data && cb_data->callback) {
293 content_debug("begin:User callback is being called now, result=%d", err);
294 cb_data->callback(err, cb_data->user_data);
295 content_debug("end:User callback is being called now, result=%d", err);
301 if (cb_data && cb_data->callback) {
302 content_debug("User callback is being called now");
303 cb_data->callback(err, cb_data->user_data);
312 #ifdef _USE_TVPD_MODE
313 void _media_content_scan_cb_v2(media_request_result_s* result, void *user_data)
316 media_content_scan_cb_data_v2 *cb_data = user_data;
317 media_content_complete_phase_e complete_phase = -1;
319 content_debug("cb_data is NULL");
320 err = _content_error_capi(result->result);
321 content_debug("result is %d", err);
323 if (result->request_type == MEDIA_REQUEST_SCAN_PARTIAL)
324 complete_phase = MEDIA_CONTENT_SCAN_PARTIAL_COMPLETE;
325 else if (result->request_type == MEDIA_REQUEST_SCAN_COMPLETE)
326 complete_phase = MEDIA_CONTENT_SCAN_COMPLETE;
327 else if (result->request_type == MEDIA_REQUEST_EXTRACT_COMPLETE)
328 complete_phase = MEDIA_CONTENT_EXTRACT_COMPLETE;
329 else if (result->request_type == MEDIA_RECURSIVE_START)
330 complete_phase = MEDIA_CONTENT_RECURSIVE_START;
332 if (cb_data && cb_data->callback)
333 cb_data->callback(err, complete_phase, cb_data->user_data);
335 content_debug("run error");
337 if ((result->request_type != MEDIA_REQUEST_SCAN_COMPLETE) &&
338 (result->request_type != MEDIA_REQUEST_SCAN_PARTIAL) &&
339 (result->request_type != MEDIA_RECURSIVE_START))
346 int media_content_scan_folder(const char *path, bool is_recursive, media_scan_completed_cb callback, void *user_data)
348 int ret = MEDIA_CONTENT_ERROR_NONE;
349 char storage_id[MEDIA_CONTENT_UUID_SIZE+1] = {0, };
350 char repl_path[MAX_PATH_LEN] = {0, };
351 ms_user_storage_type_e storage_type = MS_USER_STORAGE_INTERNAL;
353 content_retip_if_fail(STRING_VALID(path));
354 content_retip_if_fail(callback);
356 ret = _media_content_replace_path(path, repl_path);
357 content_retvm_if(!STRING_VALID(repl_path), MEDIA_CONTENT_ERROR_INVALID_OPERATION, "path replacement failed");
359 ret = _media_content_check_dir(repl_path);
360 content_retvm_if(ret == MEDIA_CONTENT_ERROR_PERMISSION_DENIED, ret, "Permission Denied");
362 if (ret == MEDIA_CONTENT_ERROR_NONE) {
363 /* If directory exist check that's ignore directory or not*/
364 content_retvm_if(_media_util_is_ignorable_dir(repl_path), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid folder path");
366 /* This means this folder has to be deleted */
367 /* Or, it is real invalid path.. check storage type */
368 ret = ms_user_get_storage_type(_content_get_uid(), repl_path, &storage_type);
369 if (ret != MS_MEDIA_ERR_NONE) {
370 content_sec_error("ms_user_get_storage_type failed : %d (%s)", ret, repl_path);
371 return _content_error_capi(ret);
374 content_debug("This path doesn't exists in file system... So will be deleted it from DB");
377 ret = media_svc_get_storage_id(_content_get_db_handle(), repl_path, storage_id, _content_get_uid());
378 if (ret != MS_MEDIA_ERR_NONE) {
379 content_error("media_svc_get_storage_id failed : %d", ret);
380 return _content_error_capi(ret);
383 media_content_scan_cb_data *cb_data = NULL;
384 cb_data = g_new0(media_content_scan_cb_data, 1);
386 cb_data->callback = callback;
387 cb_data->user_data = user_data;
389 ret = media_directory_scanning_async(repl_path, storage_id, is_recursive, _media_content_scan_cb, cb_data, _content_get_uid());
390 if (ret != MS_MEDIA_ERR_NONE) {
391 content_error("media_directory_scanning_async failed : %d", ret);
395 return _content_error_capi(ret);
398 #ifdef _USE_TVPD_MODE
399 int media_content_scan_folder_v2(const char *path, bool is_recursive, media_scan_completed_cb_v2 callback, void *user_data)
401 int ret = MEDIA_CONTENT_ERROR_NONE;
402 char storage_id[MEDIA_CONTENT_UUID_SIZE+1] = {0, };
404 content_retip_if_fail(STRING_VALID(path));
405 content_retip_if_fail(callback);
407 content_retvm_if(_media_util_is_ignorable_dir(path), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid folder path");
409 ret = _media_content_check_dir(path);
410 content_retvm_if(ret == MEDIA_CONTENT_ERROR_PERMISSION_DENIED, ret, "Permission Denied");
411 content_retvm_if(ret == MEDIA_CONTENT_ERROR_INVALID_PARAMETER, ret, "invalid path[%s]", path);
413 media_content_scan_cb_data_v2* cb_data = NULL;
414 cb_data = g_new0(media_content_scan_cb_data_v2, 1);
416 cb_data->callback = callback;
417 cb_data->user_data = user_data;
419 ret = media_svc_get_storage_id(_content_get_db_handle(), path, storage_id, _content_get_uid());
420 /*FIX ME. need to check ret value?*/
422 ret = media_directory_scanning_async(path, storage_id, is_recursive, _media_content_scan_cb_v2, cb_data, _content_get_uid());
423 if (ret != MS_MEDIA_ERR_NONE)
424 content_error("media_directory_scanning_async failed : %d", ret);
426 return _content_error_capi(ret);
430 int media_content_cancel_scan_folder(const char *path)
432 int ret = MEDIA_CONTENT_ERROR_NONE;
433 char repl_path[MAX_PATH_LEN] = {0, };
435 content_retip_if_fail(STRING_VALID(path));
437 ret = _media_content_replace_path(path, repl_path);
438 content_retvm_if(!STRING_VALID(repl_path), MEDIA_CONTENT_ERROR_INVALID_OPERATION, "path replacement failed");
440 ret = media_directory_scanning_cancel(repl_path, _content_get_uid());
441 if (ret != MS_MEDIA_ERR_NONE)
442 content_error("media_directory_scanning_async failed : %d", ret);
444 return _content_error_capi(ret);
447 void _media_content_db_update_noti_cb(
449 media_item_type_e item,
450 media_item_update_type_e update_type,
453 media_type_e content_type,
457 media_noti_cb_s *_noti_info = (media_noti_cb_s *)user_data;
459 if (_noti_info != NULL && _noti_info->update_noti_cb)
460 _noti_info->update_noti_cb(
461 MEDIA_CONTENT_ERROR_NONE,
469 _noti_info->user_data);
472 int media_content_add_db_updated_cb(media_content_db_update_cb callback, void *user_data, media_content_noti_h *noti_handle)
474 int ret = MEDIA_CONTENT_ERROR_NONE;
475 media_noti_cb_s *noti_info = NULL;
477 content_retip_if_fail(callback);
478 content_retip_if_fail(noti_handle);
480 noti_info = g_new0(media_noti_cb_s, 1);
482 noti_info->update_noti_cb = callback;
483 noti_info->user_data = user_data;
485 ret = media_db_update_subscribe((MediaNotiHandle*)noti_handle, _media_content_db_update_noti_cb, (void *)noti_info);
486 if (ret != MS_MEDIA_ERR_NONE)
489 return _content_error_capi(ret);
492 #ifdef TIZEN_FEATURE_COMPATIBILITY
493 int media_content_set_db_updated_cb(media_content_db_update_cb callback, void *user_data)
495 content_warn("DEPRECATION WARNING: media_content_set_db_updated_cb() is removed from 5.0.");
497 return MEDIA_CONTENT_ERROR_NONE;
501 int media_content_remove_db_updated_cb(media_content_noti_h noti_handle)
503 int ret = MEDIA_CONTENT_ERROR_NONE;
505 ret = media_db_update_unsubscribe((MediaNotiHandle)noti_handle);
507 return _content_error_capi(ret);
509 #ifdef _USE_TVPD_MODE
510 GMutex* _content_get_db_mutex(void)