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_UNSUPPORTED:
112 return MEDIA_CONTENT_ERROR_UNSUPPORTED_CONTENT;
114 return MEDIA_CONTENT_ERROR_INVALID_OPERATION;
118 int _content_query_sql(char *query_str)
120 int ret = MEDIA_CONTENT_ERROR_NONE;
122 /*DB will be updated by Media Server.*/
123 ret = media_db_request_update_db(query_str, _content_get_uid());
125 return _content_error_capi(ret);
128 int media_content_connect(void)
130 int ret = MEDIA_CONTENT_ERROR_NONE;
132 g_mutex_lock(&db_mutex);
133 content_info("ref count : %d", ref_count);
135 if (ref_count == 0) {
136 if (db_handle == NULL) {
137 ret = media_db_connect(&db_handle, _content_get_uid(), false);
138 ret = _content_error_capi(ret);
139 if (ret == MEDIA_CONTENT_ERROR_NONE)
142 content_error("Wrong DB Connection status");
143 ret = MEDIA_CONTENT_ERROR_DB_FAILED;
146 if (db_handle != NULL) {
149 content_error("Wrong DB Handle status");
150 ret = MEDIA_CONTENT_ERROR_DB_FAILED;
154 content_info("ref count changed to: %d", ref_count);
155 g_mutex_unlock(&db_mutex);
160 int media_content_connect_with_uid(uid_t uid)
162 content_sec_debug("media_content_connect_with_uid [%d]", uid);
165 return media_content_connect();
168 int media_content_disconnect(void)
170 g_mutex_lock(&db_mutex);
171 content_debug("ref count : %d", ref_count);
173 if (db_handle && ref_count > 0) {
174 if (--ref_count == 0) {
175 media_db_disconnect(db_handle);
179 content_error("Database is not connected");
180 g_mutex_unlock(&db_mutex);
181 return MEDIA_CONTENT_ERROR_DB_FAILED;
184 g_mutex_unlock(&db_mutex);
186 content_info("ref count changed to: %d", ref_count);
188 return MEDIA_CONTENT_ERROR_NONE;
191 int media_content_scan_file(const char *path)
193 int ret = MEDIA_CONTENT_ERROR_NONE;
194 char *folder_path = NULL;
195 int check_file = MEDIA_CONTENT_ERROR_NONE;
196 char storage_id[MEDIA_CONTENT_UUID_SIZE+1] = {0,};
198 content_retip_if_fail(STRING_VALID(path));
200 content_sec_debug("Path : %s", path);
202 content_retvm_if(_media_util_is_ignorable_file(path), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid path");
204 ret = media_svc_get_storage_id(_content_get_db_handle(), path, storage_id, _content_get_uid());
205 if (ret != MS_MEDIA_ERR_NONE) {
206 content_error("media_svc_get_storage_id failed : %d", ret);
207 return _content_error_capi(ret);
210 check_file = _media_util_check_file_exist(path);
211 if (check_file == MEDIA_CONTENT_ERROR_NONE) {
212 /* This means this path has to be inserted or refreshed */
213 folder_path = g_path_get_dirname(path);
215 if (_media_util_is_ignorable_dir(folder_path)) {
217 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
223 content_retvm_if(!_media_util_check_support_media_type(path), MEDIA_CONTENT_ERROR_NOT_SUPPORTED, "Unsupported media type");
225 ms_user_storage_type_e storage_type;
227 ret = ms_user_get_storage_type(_content_get_uid(), path, &storage_type);
228 if (ret != MS_MEDIA_ERR_NONE) {
229 content_sec_error("ms_user_get_storage_type failed : %d (%s)", ret, path);
230 return _content_error_capi(ret);
232 ret = media_svc_check_item_exist_by_path(_content_get_db_handle(), storage_id, path);
233 if (ret == MS_MEDIA_ERR_NONE) {
235 ret = media_svc_refresh_item(_content_get_db_handle(), false, storage_id, storage_type, path, _content_get_uid());
236 if (ret != MS_MEDIA_ERR_NONE) {
237 content_error("media_svc_refresh_item failed : %d", ret);
238 return _content_error_capi(ret);
241 } else if (ret == MS_MEDIA_ERR_DB_NO_RECORD) {
243 ret = media_svc_insert_item_immediately(_content_get_db_handle(), storage_id, storage_type, path, _content_get_uid());
244 if (ret != MS_MEDIA_ERR_NONE) {
245 if (ret == MS_MEDIA_ERR_DB_CONSTRAINT_FAIL) {
246 content_sec_error("This item is already inserted. This may be normal operation because other process already did this (%s)", path);
247 ret = MEDIA_CONTENT_ERROR_NONE;
249 content_sec_error("media_svc_insert_item_immediately failed : %d (%s)", ret, path);
252 return _content_error_capi(ret);
255 content_error("media_svc_check_item_exist_by_path failed : %d", ret);
256 return _content_error_capi(ret);
258 } else if (check_file == MEDIA_CONTENT_ERROR_PERMISSION_DENIED) {
259 content_error("You have no permission for this file %d", ret);
260 return MEDIA_CONTENT_ERROR_PERMISSION_DENIED;
262 /* This means this path has to be deleted */
263 content_debug("This path doesn't exists in file system... So now start to delete it from DB");
264 ret = media_svc_delete_item_by_path(_content_get_db_handle(), storage_id, path, _content_get_uid());
265 if (ret != MS_MEDIA_ERR_NONE) {
266 if (ret == MS_MEDIA_ERR_DB_NO_RECORD) {
267 content_error("Does not exist in media DB also... So, this is an invalid parameter");
268 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
271 content_error("media_svc_delete_item_by_path failed : %d", ret);
272 return _content_error_capi(ret);
276 return _content_error_capi(ret);
279 void _media_content_scan_cb(media_request_result_s* result, void *user_data)
282 media_content_scan_cb_data *cb_data = user_data;
284 err = _content_error_capi(result->result);
285 #ifdef _USE_TVPD_MODE
286 if (result->request_type != MEDIA_REQUEST_SCAN_COMPLETE &&
287 result->request_type != MEDIA_REQUEST_SCAN_PARTIAL &&
288 result->request_type != MEDIA_RECURSIVE_START) {
289 if (cb_data && cb_data->callback) {
290 content_debug("begin:User callback is being called now, result=%d", err);
291 cb_data->callback(err, cb_data->user_data);
292 content_debug("end:User callback is being called now, result=%d", err);
298 if (cb_data && cb_data->callback) {
299 content_debug("User callback is being called now");
300 cb_data->callback(err, cb_data->user_data);
309 #ifdef _USE_TVPD_MODE
310 void _media_content_scan_cb_v2(media_request_result_s* result, void *user_data)
313 media_content_scan_cb_data_v2 *cb_data = user_data;
314 media_content_complete_phase_e complete_phase = -1;
316 content_debug("cb_data is NULL");
317 err = _content_error_capi(result->result);
318 content_debug("result is %d", err);
320 if (result->request_type == MEDIA_REQUEST_SCAN_PARTIAL)
321 complete_phase = MEDIA_CONTENT_SCAN_PARTIAL_COMPLETE;
322 else if (result->request_type == MEDIA_REQUEST_SCAN_COMPLETE)
323 complete_phase = MEDIA_CONTENT_SCAN_COMPLETE;
324 else if (result->request_type == MEDIA_REQUEST_EXTRACT_COMPLETE)
325 complete_phase = MEDIA_CONTENT_EXTRACT_COMPLETE;
326 else if (result->request_type == MEDIA_RECURSIVE_START)
327 complete_phase = MEDIA_CONTENT_RECURSIVE_START;
329 if (cb_data && cb_data->callback)
330 cb_data->callback(err, complete_phase, cb_data->user_data);
332 content_debug("run error");
334 if ((result->request_type != MEDIA_REQUEST_SCAN_COMPLETE) &&
335 (result->request_type != MEDIA_REQUEST_SCAN_PARTIAL) &&
336 (result->request_type != MEDIA_RECURSIVE_START))
343 int media_content_scan_folder(const char *path, bool is_recursive, media_scan_completed_cb callback, void *user_data)
345 int ret = MEDIA_CONTENT_ERROR_NONE;
346 char storage_id[MEDIA_CONTENT_UUID_SIZE+1] = {0, };
347 ms_user_storage_type_e storage_type = MS_USER_STORAGE_INTERNAL;
349 content_retip_if_fail(STRING_VALID(path));
350 content_retip_if_fail(callback);
352 ret = _media_content_check_dir(path);
353 content_retvm_if(ret == MEDIA_CONTENT_ERROR_PERMISSION_DENIED, ret, "Permission Denied");
355 if (ret == MEDIA_CONTENT_ERROR_NONE) {
356 /* If directory exist check that's ignore directory or not*/
357 content_retvm_if(_media_util_is_ignorable_dir(path), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid folder path");
359 /* This means this folder has to be deleted */
360 /* Or, it is real invalid path.. check storage type */
361 ret = ms_user_get_storage_type(_content_get_uid(), path, &storage_type);
362 if (ret != MS_MEDIA_ERR_NONE) {
363 content_sec_error("ms_user_get_storage_type failed : %d (%s)", ret, path);
364 return _content_error_capi(ret);
367 content_debug("This path doesn't exists in file system... So will be deleted it from DB");
370 ret = media_svc_get_storage_id(_content_get_db_handle(), path, storage_id, _content_get_uid());
371 if (ret != MS_MEDIA_ERR_NONE) {
372 content_error("media_svc_get_storage_id failed : %d", ret);
373 return _content_error_capi(ret);
376 media_content_scan_cb_data *cb_data = NULL;
377 cb_data = g_new0(media_content_scan_cb_data, 1);
379 cb_data->callback = callback;
380 cb_data->user_data = user_data;
382 ret = media_directory_scanning_async(path, storage_id, is_recursive, _media_content_scan_cb, cb_data, _content_get_uid());
383 if (ret != MS_MEDIA_ERR_NONE) {
384 content_error("media_directory_scanning_async failed : %d", ret);
388 return _content_error_capi(ret);
391 #ifdef _USE_TVPD_MODE
392 int media_content_scan_folder_v2(const char *path, bool is_recursive, media_scan_completed_cb_v2 callback, void *user_data)
394 int ret = MEDIA_CONTENT_ERROR_NONE;
395 char storage_id[MEDIA_CONTENT_UUID_SIZE+1] = {0, };
397 content_retip_if_fail(STRING_VALID(path));
398 content_retip_if_fail(callback);
400 content_retvm_if(_media_util_is_ignorable_dir(path), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid folder path");
402 ret = _media_content_check_dir(path);
403 content_retvm_if(ret == MEDIA_CONTENT_ERROR_PERMISSION_DENIED, ret, "Permission Denied");
404 content_retvm_if(ret == MEDIA_CONTENT_ERROR_INVALID_PARAMETER, ret, "invalid path[%s]", path);
406 media_content_scan_cb_data_v2* cb_data = NULL;
407 cb_data = g_new0(media_content_scan_cb_data_v2, 1);
409 cb_data->callback = callback;
410 cb_data->user_data = user_data;
412 ret = media_svc_get_storage_id(_content_get_db_handle(), path, storage_id, _content_get_uid());
413 /*FIX ME. need to check ret value?*/
415 ret = media_directory_scanning_async(path, storage_id, is_recursive, _media_content_scan_cb_v2, cb_data, _content_get_uid());
416 if (ret != MS_MEDIA_ERR_NONE)
417 content_error("media_directory_scanning_async failed : %d", ret);
419 return _content_error_capi(ret);
423 int media_content_cancel_scan_folder(const char *path)
425 int ret = MEDIA_CONTENT_ERROR_NONE;
427 content_retip_if_fail(STRING_VALID(path));
429 ret = media_directory_scanning_cancel(path, _content_get_uid());
430 if (ret != MS_MEDIA_ERR_NONE)
431 content_error("media_directory_scanning_async failed : %d", ret);
433 return _content_error_capi(ret);
436 void _media_content_db_update_noti_cb(
438 media_item_type_e item,
439 media_item_update_type_e update_type,
442 media_type_e content_type,
446 media_noti_cb_s *_noti_info = (media_noti_cb_s *)user_data;
448 if (_noti_info != NULL && _noti_info->update_noti_cb)
449 _noti_info->update_noti_cb(
450 MEDIA_CONTENT_ERROR_NONE,
458 _noti_info->user_data);
461 int media_content_add_db_updated_cb(media_content_db_update_cb callback, void *user_data, media_content_noti_h *noti_handle)
463 int ret = MEDIA_CONTENT_ERROR_NONE;
464 media_noti_cb_s *noti_info = NULL;
466 content_retip_if_fail(callback);
467 content_retip_if_fail(noti_handle);
469 noti_info = g_new0(media_noti_cb_s, 1);
471 noti_info->update_noti_cb = callback;
472 noti_info->user_data = user_data;
474 ret = media_db_update_subscribe((MediaNotiHandle*)noti_handle, _media_content_db_update_noti_cb, (void *)noti_info);
475 if (ret != MS_MEDIA_ERR_NONE)
478 return _content_error_capi(ret);
481 int media_content_remove_db_updated_cb(media_content_noti_h noti_handle)
483 int ret = MEDIA_CONTENT_ERROR_NONE;
485 ret = media_db_update_unsubscribe((MediaNotiHandle)noti_handle);
487 return _content_error_capi(ret);
489 #ifdef _USE_TVPD_MODE
490 GMutex* _content_get_db_mutex(void)