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 char *g_src_path = NULL;
23 int media_folder_get_folder_count_from_db(filter_h filter, int *folder_count)
25 int ret = MEDIA_CONTENT_ERROR_NONE;
28 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
29 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
32 ret = _media_db_get_group_count(filter, MEDIA_GROUP_FOLDER, folder_count);
37 int media_folder_foreach_folder_from_db(filter_h filter, media_folder_cb callback, void *user_data)
39 int ret = MEDIA_CONTENT_ERROR_NONE;
41 if (callback == NULL) {
42 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
43 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
47 g_mutex_lock(_content_get_db_mutex());
50 ret = _media_db_get_folder(filter, callback, user_data);
53 g_mutex_unlock(_content_get_db_mutex());
59 int media_folder_get_media_count_from_db(const char *folder_id, filter_h filter, int *media_count)
61 int ret = MEDIA_CONTENT_ERROR_NONE;
63 if (STRING_VALID(folder_id) && media_count) {
64 ret = _media_db_get_group_item_count(folder_id, filter, MEDIA_GROUP_FOLDER, media_count);
66 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
67 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
73 int media_folder_foreach_media_from_db(const char *folder_id, filter_h filter, media_info_cb callback, void *user_data)
75 int ret = MEDIA_CONTENT_ERROR_NONE;
77 if ((callback != NULL) && STRING_VALID(folder_id)) {
78 ret = _media_db_get_group_item(folder_id, filter, callback, user_data, MEDIA_GROUP_FOLDER);
80 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
81 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
87 #ifdef _USE_SENIOR_MODE
88 int media_folder_foreach_media_from_db_by_union_select(const char* folder_id, filter_h filter1, filter_h filter2, media_info_cb callback, void* user_data)
90 int ret = MEDIA_CONTENT_ERROR_NONE;
92 if ((callback != NULL) && STRING_VALID(folder_id)) {
93 ret = _media_db_get_group_item_by_union_select(folder_id, filter1, filter2, callback, user_data);
95 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
96 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
103 int media_folder_destroy(media_folder_h folder)
105 int ret = MEDIA_CONTENT_ERROR_NONE;
106 media_folder_s *_folder = (media_folder_s*)folder;
108 SAFE_FREE(_folder->path);
109 SAFE_FREE(_folder->name);
110 SAFE_FREE(_folder->folder_id);
111 SAFE_FREE(_folder->storage_uuid);
113 ret = MEDIA_CONTENT_ERROR_NONE;
115 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
116 ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
121 int media_folder_clone(media_folder_h *dst, media_folder_h src)
123 int ret = MEDIA_CONTENT_ERROR_NONE;
124 media_folder_s *_src = (media_folder_s*)src;
127 media_folder_s *_dst = (media_folder_s*)calloc(1, sizeof(media_folder_s));
128 media_content_retvm_if(_dst == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY");
130 if (STRING_VALID(_src->folder_id)) {
131 _dst->folder_id = strdup(_src->folder_id);
132 if (_dst->folder_id == NULL) {
134 media_content_error("OUT_OF_MEMORY(0x%08x)", MEDIA_CONTENT_ERROR_OUT_OF_MEMORY);
135 return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
139 if (STRING_VALID(_src->name)) {
140 _dst->name = strdup(_src->name);
141 if (_dst->name == NULL) {
142 media_content_error("OUT_OF_MEMORY(0x%08x)", MEDIA_CONTENT_ERROR_OUT_OF_MEMORY);
143 media_folder_destroy((media_folder_h)_dst);
144 return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
148 if (STRING_VALID(_src->path)) {
149 _dst->path = strdup(_src->path);
150 if (_dst->path == NULL) {
151 media_content_error("OUT_OF_MEMORY(0x%08x)", MEDIA_CONTENT_ERROR_OUT_OF_MEMORY);
152 media_folder_destroy((media_folder_h)_dst);
153 return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
157 if (STRING_VALID(_src->storage_uuid)) {
158 _dst->storage_uuid = strdup(_src->storage_uuid);
159 if (_dst->storage_uuid == NULL) {
160 media_content_error("OUT_OF_MEMORY(0x%08x)", MEDIA_CONTENT_ERROR_OUT_OF_MEMORY);
161 media_folder_destroy((media_folder_h)_dst);
162 return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
166 _dst->storage_type = _src->storage_type;
167 _dst->modified_time = _src->modified_time;
168 _dst->folder_order = _src->folder_order;
170 *dst = (media_folder_h)_dst;
172 ret = MEDIA_CONTENT_ERROR_NONE;
174 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
175 ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
181 int media_folder_get_folder_id(media_folder_h folder, char **folder_id)
183 int ret = MEDIA_CONTENT_ERROR_NONE;
184 media_folder_s *_folder = (media_folder_s*)folder;
187 if (STRING_VALID(_folder->folder_id)) {
188 *folder_id = strdup(_folder->folder_id);
189 media_content_retvm_if(*folder_id == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY");
193 ret = MEDIA_CONTENT_ERROR_NONE;
195 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
196 ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
202 int media_folder_get_parent_folder_id(media_folder_h folder, char **parent_folder_id)
204 int ret = MEDIA_CONTENT_ERROR_NONE;
205 media_content_warn("DEPRECATION WARNING: media_folder_get_parent_folder_id() is deprecated and will be removed from next release.");
206 media_folder_s *_folder = (media_folder_s*)folder;
207 sqlite3_stmt *stmt = NULL;
208 char tmp_path[MAX_PATH_LEN] = {0, };
209 char *parent_path = NULL;
210 char select_query[MAX_QUERY_SIZE] = {0, };
212 /* Usage is low. So, DB access when this fuction is called */
214 memset(tmp_path, 0x00, sizeof(tmp_path));
215 memset(select_query, 0x00, sizeof(select_query));
217 _media_content_replace_path(_folder->path, tmp_path);
219 parent_path = g_path_get_dirname(tmp_path);
220 snprintf(select_query, sizeof(select_query), SELECT_FOLDER_ID_BY_PATH, parent_path);
221 SAFE_FREE(parent_path);
223 ret = _content_query_prepare(&stmt, select_query, NULL, NULL);
224 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
226 if (sqlite3_step(stmt) == SQLITE_ROW)
227 *parent_folder_id = g_strdup((const char *)sqlite3_column_text(stmt, 0));
229 *parent_folder_id = NULL;
231 SQLITE3_FINALIZE(stmt);
233 ret = MEDIA_CONTENT_ERROR_NONE;
235 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
236 ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
242 int media_folder_get_path(media_folder_h folder, char **path)
244 int ret = MEDIA_CONTENT_ERROR_NONE;
245 media_folder_s *_folder = (media_folder_s*)folder;
248 if (STRING_VALID(_folder->path)) {
249 *path = strdup(_folder->path);
250 media_content_retvm_if(*path == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY");
254 ret = MEDIA_CONTENT_ERROR_NONE;
257 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
258 ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
265 int media_folder_get_name(media_folder_h folder, char **name)
267 int ret = MEDIA_CONTENT_ERROR_NONE;
268 media_folder_s *_folder = (media_folder_s*)folder;
271 if (STRING_VALID(_folder->name)) {
272 *name = strdup(_folder->name);
273 media_content_retvm_if(*name == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY");
277 ret = MEDIA_CONTENT_ERROR_NONE;
280 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
281 ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
287 int media_folder_get_modified_time(media_folder_h folder, time_t* time)
289 int ret = MEDIA_CONTENT_ERROR_NONE;
290 media_content_warn("DEPRECATION WARNING: media_folder_get_modified_time() is deprecated and will be removed from next release.");
291 media_folder_s *_folder = (media_folder_s*)folder;
294 *time = _folder->modified_time;
295 ret = MEDIA_CONTENT_ERROR_NONE;
297 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
298 ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
304 int media_folder_get_storage_type(media_folder_h folder, media_content_storage_e* storage_type)
306 int ret = MEDIA_CONTENT_ERROR_NONE;
307 media_folder_s *_folder = (media_folder_s*)folder;
310 *storage_type = _folder->storage_type;
311 ret = MEDIA_CONTENT_ERROR_NONE;
313 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
314 ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
320 int media_folder_get_storage_id(media_folder_h folder, char **storage_id)
322 int ret = MEDIA_CONTENT_ERROR_NONE;
323 media_folder_s *_folder = (media_folder_s*)folder;
326 if (STRING_VALID(_folder->storage_uuid)) {
327 *storage_id = strdup(_folder->storage_uuid);
328 media_content_retvm_if(*storage_id == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY");
332 ret = MEDIA_CONTENT_ERROR_NONE;
335 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
336 ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
342 int media_folder_get_order(media_folder_h folder, int *order)
344 int ret = MEDIA_CONTENT_ERROR_NONE;
345 media_content_warn("DEPRECATION WARNING: media_folder_get_order() is deprecated and will be removed from next release.");
346 media_folder_s *_folder = (media_folder_s*)folder;
349 *order = _folder->folder_order;
350 ret = MEDIA_CONTENT_ERROR_NONE;
352 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
353 ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
360 int media_folder_get_folder_from_db(const char *folder_id, media_folder_h *folder)
362 int ret = MEDIA_CONTENT_ERROR_NONE;
363 sqlite3_stmt *stmt = NULL;
364 char select_query[DEFAULT_QUERY_SIZE];
365 char *tmp_path = NULL;
366 char repl_path[MAX_PATH_LEN] = {0, };
367 media_folder_s *_folder = NULL;
369 if (!STRING_VALID(folder_id)) {
370 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
371 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
374 memset(select_query, 0x00, sizeof(select_query));
375 snprintf(select_query, sizeof(select_query), SELECT_FOLDER_FROM_FOLDER, folder_id);
377 ret = _content_query_prepare(&stmt, select_query, NULL, NULL);
378 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
380 if (sqlite3_step(stmt) == SQLITE_ROW) {
381 _folder = (media_folder_s*)calloc(1, sizeof(media_folder_s));
382 if (_folder == NULL) {
383 media_content_error("OUT_OF_MEMORY(0x%08x)", MEDIA_CONTENT_ERROR_OUT_OF_MEMORY);
384 SQLITE3_FINALIZE(stmt);
385 return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
388 _folder->folder_id = g_strdup((const char *)sqlite3_column_text(stmt, 0));
390 tmp_path = g_strdup((const char *)sqlite3_column_text(stmt, 1));
391 _media_content_rollback_path(tmp_path, repl_path);
392 _folder->path = g_strdup(repl_path);
395 _folder->name = g_strdup((const char *)sqlite3_column_text(stmt, 2));
396 _folder->modified_time = (int)sqlite3_column_int(stmt, 3);
397 _folder->storage_type = (int)sqlite3_column_int(stmt, 5);
398 _folder->storage_uuid = g_strdup((const char *)sqlite3_column_text(stmt, 6));
399 _folder->folder_order = (int)sqlite3_column_int(stmt, 7);
401 *folder = (media_folder_h)_folder;
404 SQLITE3_FINALIZE(stmt);
409 int media_folder_update_to_db(media_folder_h folder)
411 int ret = MEDIA_CONTENT_ERROR_NONE;
412 media_content_warn("DEPRECATION WARNING: media_folder_update_to_db() is deprecated and will be removed from next release.");
413 media_folder_s *_folder = (media_folder_s*)folder;
415 char repl_path[MAX_PATH_LEN] = {0, };
417 if ((_folder == NULL) || (_folder->folder_id == NULL)) {
418 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
419 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
422 /* Update folder order */
423 sql = sqlite3_mprintf(UPDATE_FOLDER_ORDER, _folder->folder_order, _folder->folder_id);
425 ret = _content_query_sql(sql);
426 SQLITE3_SAFE_FREE(sql);
428 if (STRING_VALID(_folder->folder_id) && g_src_path) {
429 char *name_pinyin = NULL;
430 bool pinyin_support = FALSE;
432 ret = _media_content_replace_path(_folder->path, repl_path);
434 /* Set modified time */
437 _folder->modified_time = date;
439 /*Update Pinyin If Support Pinyin*/
440 media_svc_check_pinyin_support(&pinyin_support);
442 media_svc_get_pinyin(_folder->name, &name_pinyin);
444 sql = sqlite3_mprintf("UPDATE %Q SET path='%q', name='%q', modified_time=%d, name_pinyin='%q' WHERE folder_uuid=%Q",
445 DB_TABLE_FOLDER, repl_path, _folder->name, _folder->modified_time, name_pinyin, _folder->folder_id);
447 ret = _content_query_sql(sql);
448 SQLITE3_SAFE_FREE(sql);
449 if (ret != MEDIA_CONTENT_ERROR_NONE) {
450 SAFE_FREE(g_src_path);
454 /* Update all folder record's path, which are matched by old parent path */
455 char *update_folder_path_sql = NULL;
456 char src_path_slash[MAX_PATH_LEN + 1] = {0, };
457 char dst_path_slash[MAX_PATH_LEN + 1] = {0, };
459 snprintf(src_path_slash, sizeof(src_path_slash), "%s/", g_src_path);
460 snprintf(dst_path_slash, sizeof(dst_path_slash), "%s/", repl_path);
462 update_folder_path_sql = sqlite3_mprintf("UPDATE folder SET path = REPLACE( path, '%q', '%q');", src_path_slash, dst_path_slash);
464 ret = _content_query_sql(update_folder_path_sql);
465 SQLITE3_SAFE_FREE(update_folder_path_sql);
466 if (ret != MEDIA_CONTENT_ERROR_NONE) {
467 SAFE_FREE(g_src_path);
471 ret = media_svc_rename_folder(_content_get_db_handle(), _folder->storage_uuid, g_src_path, repl_path, _content_get_uid());
472 SAFE_FREE(g_src_path);
474 return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
480 int media_folder_set_name(media_folder_h folder, const char *name)
482 int ret = MEDIA_CONTENT_ERROR_NONE;
483 media_content_warn("DEPRECATION WARNING: media_folder_set_name() is deprecated and will be removed from next release.");
484 media_folder_s *_folder = (media_folder_s*)folder;
486 if (_folder != NULL && STRING_VALID(name)) {
487 if (STRING_VALID(_folder->path) && STRING_VALID(_folder->name)) {
488 char *folder_path = NULL;
489 char new_folder_path[MAX_PATH_LEN] = {0,};
490 bool ignore_dir = FALSE;
491 char repl_path[MAX_PATH_LEN] = {0, };
493 memset(repl_path, 0, sizeof(repl_path));
494 ret = _media_content_replace_path(_folder->path, repl_path);
495 media_content_retvm_if(!STRING_VALID(repl_path), MEDIA_CONTENT_ERROR_INVALID_OPERATION, "path replacement failed");
497 folder_path = g_path_get_dirname(repl_path);
498 media_content_sec_debug("Existed Folder Path : %s", repl_path);
499 snprintf(new_folder_path, sizeof(new_folder_path), "%s/%s", folder_path, name);
500 media_content_sec_debug("New Path : %s", new_folder_path);
502 ret = _media_util_check_ignore_dir(new_folder_path, &ignore_dir);
503 if (ignore_dir == TRUE) {
504 media_content_error("Invalid folder path");
505 SAFE_FREE(folder_path);
509 SAFE_FREE(g_src_path);
510 g_src_path = strdup(repl_path);
512 SAFE_FREE(_folder->path);
513 SAFE_FREE(_folder->name);
514 SAFE_FREE(folder_path);
515 memset(repl_path, 0, sizeof(repl_path));
516 ret = _media_content_rollback_path(new_folder_path, repl_path);
517 media_content_retvm_if(!STRING_VALID(repl_path), MEDIA_CONTENT_ERROR_INVALID_OPERATION, "path replacement failed");
519 _folder->path = strdup(repl_path);
520 media_content_retvm_if(_folder->path == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY");
523 _folder->name = strdup(name);
524 media_content_retvm_if(_folder->name == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY");
526 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
527 ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
533 int media_folder_set_order(media_folder_h folder, int order)
535 int ret = MEDIA_CONTENT_ERROR_NONE;
536 media_content_warn("DEPRECATION WARNING: media_folder_set_order() is deprecated and will be removed from next release.");
537 media_folder_s *_folder = (media_folder_s*)folder;
539 if (_folder != NULL && order >= 0) {
540 _folder->folder_order = order;
542 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
543 ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
548 #ifdef _USE_TVPD_MODE
549 int media_folder_get_scan_status(const char *storage_uuid, char* path, media_folder_scan_status_e *scan_status)
551 int ret = MEDIA_CONTENT_ERROR_NONE;
552 int status = MEDIA_DIR_SCAN_NONE;
554 if (STRING_VALID(storage_uuid) && STRING_VALID(path)) {
555 ret = media_svc_get_folder_scan_status(_content_get_db_handle(), storage_uuid, path, &status);
556 if (ret != MS_MEDIA_ERR_NONE) {
557 media_content_error("media_svc_get_folder_scan_status failed");
558 ret = _content_error_capi(MEDIA_CONTENT_TYPE, ret);
560 *scan_status = status;
563 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
564 ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;