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_filter.h>
19 #include <media_info.h>
20 #include <media_info_private.h>
21 #include <media_util_private.h>
23 static void __media_playlist_item_free(gpointer item)
25 media_playlist_item_s *_item = (media_playlist_item_s *)item;
27 g_free(_item->media_id);
28 g_free(_item->playlist_name);
29 g_free(_item->thumbnail_path);
33 static void __media_playlist_item_release(media_playlist_s *playlist)
35 if (!playlist || !playlist->item_list)
38 g_list_free_full(playlist->item_list, __media_playlist_item_free);
39 playlist->item_list = NULL;
42 static int __media_playlist_insert_playlist_record(const char *playlist_name, int *playlist_id)
44 int ret = MEDIA_CONTENT_ERROR_NONE;
46 sqlite3_stmt *stmt = NULL;
48 query = sqlite3_mprintf(INSERT_PLAYLIST_TO_PLAYLIST, playlist_name);
50 ret = _content_query_sql(query);
51 SQLITE3_SAFE_FREE(query);
52 content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
54 query = sqlite3_mprintf(SELECT_PLAYLIST_ID_FROM_PLAYLIST, playlist_name);
56 ret = _content_get_result(query, &stmt);
57 SQLITE3_SAFE_FREE(query);
58 content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
60 if (sqlite3_step(stmt) == SQLITE_ROW)
61 *playlist_id = sqlite3_column_int(stmt, 0);
63 SQLITE3_FINALIZE(stmt);
65 return MEDIA_CONTENT_ERROR_NONE;
68 static int __media_playlist_insert_item_to_playlist(int playlist_id, const char *media_id)
70 int ret = MEDIA_CONTENT_ERROR_NONE;
71 sqlite3_stmt *stmt = NULL;
75 query = sqlite3_mprintf(SELECT_MAX_PLAY_ORDER_FROM_PLAYLIST_VIEW, playlist_id);
77 /* get the max play_order */
78 ret = _content_get_result(query, &stmt);
79 SQLITE3_SAFE_FREE(query);
80 content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
82 if (sqlite3_step(stmt) == SQLITE_ROW)
83 play_order = sqlite3_column_int(stmt, 0);
85 SQLITE3_FINALIZE(stmt);
87 query = sqlite3_mprintf(INSERT_PLAYLIST_ITEM_TO_PLAYLIST_MAP, playlist_id, media_id, ++play_order);
88 ret = media_svc_append_query(query, _content_get_uid());
90 return _content_error_capi(ret);
93 static int __media_playlist_remove_item_from_playlist(int playlist_id, int playlist_member_id)
95 int ret = MEDIA_CONTENT_ERROR_NONE;
96 char *query_str = NULL;
98 query_str = sqlite3_mprintf(REMOVE_PLAYLIST_ITEM_FROM_PLAYLIST_MAP, playlist_id, playlist_member_id);
99 ret = media_svc_append_query(query_str, _content_get_uid());
101 return _content_error_capi(ret);
104 static int __media_playlist_update_playlist_name(int playlist_id, const char *playlist_name)
106 int ret = MEDIA_CONTENT_ERROR_NONE;
107 char *query_str = NULL;
109 query_str = sqlite3_mprintf(UPDATE_PLAYLIST_NAME_FROM_PLAYLIST, playlist_name, playlist_id);
110 ret = media_svc_append_query(query_str, _content_get_uid());
112 return _content_error_capi(ret);
115 static int __media_playlist_update_thumbnail_path(int playlist_id, const char *path)
117 int ret = MEDIA_CONTENT_ERROR_NONE;
118 char *query_str = NULL;
120 query_str = sqlite3_mprintf(UPDATE_PLAYLIST_THUMBNAIL_FROM_PLAYLIST, path, playlist_id);
121 ret = media_svc_append_query(query_str, _content_get_uid());
123 return _content_error_capi(ret);
126 static int __media_playlist_update_play_order(int playlist_id, int playlist_member_id, int play_order)
128 int ret = MEDIA_CONTENT_ERROR_NONE;
129 char *query_str = NULL;
131 query_str = sqlite3_mprintf(UPDATE_PLAYLIST_ORDER_FROM_PLAYLIST_MAP, play_order, playlist_id, playlist_member_id);
132 ret = media_svc_append_query(query_str, _content_get_uid());
134 return _content_error_capi(ret);
137 static bool __media_playlist_member_cb(int playlist_member_id, media_info_h media, void *user_data)
139 int ret = MEDIA_CONTENT_ERROR_NONE;
140 GList **list = (GList**)user_data;
143 ret = media_info_get_file_path(media, &path);
144 content_retvm_if(ret != MEDIA_CONTENT_ERROR_NONE, FALSE, "media_info_get_file_path fail");
146 *list = g_list_append(*list, path);
151 static int __media_playlist_reset_file(const char *playlist_path)
155 fp = fopen(playlist_path, "wb");
157 content_stderror("fopen failed");
158 return MEDIA_CONTENT_ERROR_INVALID_OPERATION;
161 fputs("", fp); /* remove previous playlist */
165 return MEDIA_CONTENT_ERROR_NONE;
168 static int __media_playlist_append_to_file(const char *playlist_path, const char *path)
172 fp = fopen(playlist_path, "a"); /* append only */
174 content_stderror("fopen failed");
175 return MEDIA_CONTENT_ERROR_INVALID_OPERATION;
184 return MEDIA_CONTENT_ERROR_NONE;
187 static int __media_playlist_import_item_from_file(const char *playlist_path, GSList **item_list)
190 char tmp_str[MAX_PATH_LEN] = {0, };
191 char repl_item[MAX_PATH_LEN] = {0, };
194 fp = fopen(playlist_path, "rb");
196 content_stderror("fopen failed");
197 return MEDIA_CONTENT_ERROR_INVALID_OPERATION;
200 while (fgets(tmp_str, MAX_PATH_LEN, fp) != NULL) {
201 memset(repl_item, 0, sizeof(repl_item));
202 _media_content_replace_path(tmp_str, repl_item);
204 tmp_str_len = strlen(repl_item);
205 /* Check for empty file */
206 if (tmp_str_len <= 1)
209 if (repl_item[0] == '#')
213 if (repl_item[tmp_str_len - 1] == '\n')
214 repl_item[tmp_str_len - 1] = '\0';
216 *item_list = g_slist_append(*item_list, g_strdup(repl_item));
221 return MEDIA_CONTENT_ERROR_NONE;
224 int media_playlist_insert_to_db(const char *name, media_playlist_h *playlist)
226 int ret = MEDIA_CONTENT_ERROR_NONE;
229 content_retip_if_fail(STRING_VALID(name));
230 content_retip_if_fail(playlist);
232 media_playlist_s *_playlist = g_new0(media_playlist_s, 1);
234 ret = __media_playlist_insert_playlist_record(name, &playlist_id);
235 if (ret != MEDIA_CONTENT_ERROR_NONE) {
240 _playlist->playlist_id = playlist_id;
241 _playlist->name = g_strdup(name);
243 *playlist = (media_playlist_h)_playlist;
248 int media_playlist_delete_from_db(int playlist_id)
250 int ret = MEDIA_CONTENT_ERROR_NONE;
251 char *query_str = NULL;
253 content_retipm_if_fail(playlist_id >= 0, "%d", playlist_id);
255 query_str = sqlite3_mprintf(DELETE_PLAYLIST_FROM_PLAYLIST, playlist_id);
257 ret = _content_query_sql(query_str);
258 SQLITE3_SAFE_FREE(query_str);
263 int media_playlist_get_playlist_count_from_db(filter_h filter, int *playlist_count)
265 content_retip_if_fail(playlist_count);
267 return _media_db_get_group_count(filter, MEDIA_GROUP_PLAYLIST, playlist_count);
270 int media_playlist_foreach_playlist_from_db(filter_h filter, media_playlist_cb callback, void *user_data)
272 content_retip_if_fail(callback);
274 return _media_db_get_playlist(filter, callback, user_data);
277 int media_playlist_get_media_count_from_db(int playlist_id, filter_h filter, int *media_count)
279 content_retip_if_fail(media_count);
280 content_retipm_if_fail(playlist_id > 0, "%d", playlist_id);
282 return _media_db_get_group_item_count_by_id(playlist_id, filter, MEDIA_GROUP_PLAYLIST, media_count);
285 int media_playlist_foreach_media_from_db(int playlist_id, filter_h filter, playlist_member_cb callback, void *user_data)
287 content_retip_if_fail(callback);
288 content_retipm_if_fail(playlist_id > 0, "%d", playlist_id);
290 return _media_db_get_playlist_item(playlist_id, filter, callback, user_data);
293 int media_playlist_destroy(media_playlist_h playlist)
295 media_playlist_s *_playlist = (media_playlist_s *)playlist;
297 content_retip_if_fail(playlist);
299 __media_playlist_item_release(_playlist);
301 g_free(_playlist->name);
302 g_free(_playlist->thumbnail_path);
305 return MEDIA_CONTENT_ERROR_NONE;
308 int media_playlist_clone(media_playlist_h *dst, media_playlist_h src)
310 media_playlist_s *_src = (media_playlist_s *)src;
312 content_retip_if_fail(dst);
313 content_retip_if_fail(src);
315 media_playlist_s *_dst = g_new0(media_playlist_s, 1);
317 _dst->playlist_id = _src->playlist_id;
318 _dst->name = g_strdup(_src->name);
320 *dst = (media_playlist_h)_dst;
322 return MEDIA_CONTENT_ERROR_NONE;
325 int media_playlist_get_playlist_from_db(int playlist_id, media_playlist_h *playlist)
327 int ret = MEDIA_CONTENT_ERROR_NONE;
328 sqlite3_stmt *stmt = NULL;
331 content_retipm_if_fail(playlist_id > 0, "%d", playlist_id);
332 content_retip_if_fail(playlist);
334 query = sqlite3_mprintf(SELECT_PLAYLIST_FROM_PLAYLIST, playlist_id);
336 ret = _content_get_result(query, &stmt);
337 SQLITE3_SAFE_FREE(query);
338 content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
340 media_playlist_s *_playlist = NULL;
342 if (sqlite3_step(stmt) == SQLITE_ROW) {
343 _playlist = g_new0(media_playlist_s, 1);
345 _playlist->playlist_id = playlist_id;
346 _playlist->name = g_strdup((const char *)sqlite3_column_text(stmt, 0));
347 _playlist->thumbnail_path = g_strdup((const char *)sqlite3_column_text(stmt, 1));
349 *playlist = (media_playlist_h)_playlist;
351 content_error("Nonexistent playlist id[%d]", playlist_id);
352 ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
355 SQLITE3_FINALIZE(stmt);
360 int media_playlist_get_playlist_id(media_playlist_h playlist, int *playlist_id)
362 media_playlist_s *_playlist = (media_playlist_s *)playlist;
364 content_retip_if_fail(playlist);
365 content_retip_if_fail(playlist_id);
367 *playlist_id = _playlist->playlist_id;
369 return MEDIA_CONTENT_ERROR_NONE;
372 int media_playlist_get_name(media_playlist_h playlist, char **name)
374 media_playlist_s *_playlist = (media_playlist_s *)playlist;
376 content_retip_if_fail(playlist);
377 content_retip_if_fail(name);
379 *name = g_strdup(_playlist->name);
381 return MEDIA_CONTENT_ERROR_NONE;
384 int media_playlist_get_thumbnail_path(media_playlist_h playlist, char **path)
386 media_playlist_s *_playlist = (media_playlist_s *)playlist;
388 content_retip_if_fail(playlist);
389 content_retip_if_fail(path);
391 *path = g_strdup(_playlist->thumbnail_path);
393 return MEDIA_CONTENT_ERROR_NONE;
396 int media_playlist_get_play_order(media_playlist_h playlist, int playlist_member_id, int *play_order)
398 int ret = MEDIA_CONTENT_ERROR_NONE;
399 media_playlist_s *_playlist = (media_playlist_s *)playlist;
400 sqlite3_stmt *stmt = NULL;
403 content_retip_if_fail(playlist);
404 content_retipm_if_fail(playlist_member_id >= 0, "%d", playlist_member_id);
405 content_retip_if_fail(play_order);
407 query = sqlite3_mprintf(SELECT_PLAY_ORDER_FROM_PLAYLIST_VIEW, _playlist->playlist_id, playlist_member_id);
408 ret = _content_get_result(query, &stmt);
409 SQLITE3_SAFE_FREE(query);
410 content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
412 if (sqlite3_step(stmt) == SQLITE_ROW)
413 *play_order = sqlite3_column_int(stmt, 0);
415 SQLITE3_FINALIZE(stmt);
420 int media_playlist_set_name(media_playlist_h playlist, const char *playlist_name)
422 media_playlist_s *_playlist = (media_playlist_s *)playlist;
423 media_playlist_item_s *item = NULL;
425 content_retip_if_fail(playlist);
426 content_retip_if_fail(STRING_VALID(playlist_name));
428 g_free(_playlist->name);
430 item = g_new0(media_playlist_item_s, 1);
432 item->playlist_name = g_strdup(playlist_name);
433 item->function = MEDIA_PLAYLIST_UPDATE_PLAYLIST_NAME;
435 _playlist->name = g_strdup(playlist_name);
436 _playlist->item_list = g_list_append(_playlist->item_list, item);
438 return MEDIA_CONTENT_ERROR_NONE;
441 int media_playlist_set_thumbnail_path(media_playlist_h playlist, const char *path)
443 media_playlist_s *_playlist = (media_playlist_s *)playlist;
444 media_playlist_item_s *item = NULL;
446 content_retip_if_fail(playlist);
447 content_retip_if_fail(STRING_VALID(path));
449 g_free(_playlist->thumbnail_path);
451 item = g_new0(media_playlist_item_s, 1);
453 item->thumbnail_path = g_strdup(path);
454 item->function = MEDIA_PLAYLIST_UPDATE_THUMBNAIL_PATH;
456 _playlist->thumbnail_path = g_strdup(path);
457 _playlist->item_list = g_list_append(_playlist->item_list, item);
459 return MEDIA_CONTENT_ERROR_NONE;
462 int media_playlist_set_play_order(media_playlist_h playlist, int playlist_member_id, int play_order)
464 media_playlist_s *_playlist = (media_playlist_s *)playlist;
465 media_playlist_item_s *item = NULL;
467 content_retip_if_fail(playlist);
468 content_retipm_if_fail(playlist_member_id > 0, "%d", playlist_member_id);
469 content_retipm_if_fail(play_order >= 0, "%d", play_order);
471 item = g_new0(media_playlist_item_s, 1);
473 item->playlist_member_id = playlist_member_id;
474 item->function = MEDIA_PLAYLIST_UPDATE_PLAY_ORDER;
475 item->play_order = play_order;
477 _playlist->item_list = g_list_append(_playlist->item_list, item);
479 return MEDIA_CONTENT_ERROR_NONE;
482 int media_playlist_add_media(media_playlist_h playlist, const char *media_id)
484 media_playlist_s *_playlist = (media_playlist_s *)playlist;
485 media_playlist_item_s *item = NULL;
487 content_retip_if_fail(playlist);
488 content_retip_if_fail(STRING_VALID(media_id));
490 item = g_new0(media_playlist_item_s, 1);
492 item->media_id = g_strdup(media_id);
493 item->function = MEDIA_PLAYLIST_ADD;
495 _playlist->item_list = g_list_append(_playlist->item_list, item);
497 return MEDIA_CONTENT_ERROR_NONE;
500 int media_playlist_remove_media(media_playlist_h playlist, int playlist_member_id)
502 media_playlist_s *_playlist = (media_playlist_s *)playlist;
503 media_playlist_item_s *item = NULL;
505 content_retip_if_fail(playlist);
506 content_retipm_if_fail(playlist_member_id > 0, "%d", playlist_member_id);
508 item = g_new0(media_playlist_item_s, 1);
510 item->playlist_member_id = playlist_member_id;
511 item->function = MEDIA_PLAYLIST_REMOVE;
513 _playlist->item_list = g_list_append(_playlist->item_list, item);
515 return MEDIA_CONTENT_ERROR_NONE;
518 void __media_playlist_foreach_request(gpointer data, gpointer user_data)
520 int ret = MEDIA_CONTENT_ERROR_NONE;
521 media_playlist_item_s *_playlist_item = (media_playlist_item_s *)data;
522 int playlist_id = *((int *)user_data);
527 switch (_playlist_item->function) {
528 case MEDIA_PLAYLIST_ADD:
529 ret = __media_playlist_insert_item_to_playlist(playlist_id, _playlist_item->media_id);
532 case MEDIA_PLAYLIST_REMOVE:
533 ret = __media_playlist_remove_item_from_playlist(playlist_id, _playlist_item->playlist_member_id);
536 case MEDIA_PLAYLIST_UPDATE_PLAYLIST_NAME:
537 ret = __media_playlist_update_playlist_name(playlist_id, _playlist_item->playlist_name);
540 case MEDIA_PLAYLIST_UPDATE_THUMBNAIL_PATH:
541 ret = __media_playlist_update_thumbnail_path(playlist_id, _playlist_item->thumbnail_path);
544 case MEDIA_PLAYLIST_UPDATE_PLAY_ORDER:
545 ret = __media_playlist_update_play_order(playlist_id, _playlist_item->playlist_member_id, _playlist_item->play_order);
552 if (ret != MEDIA_CONTENT_ERROR_NONE)
553 content_error("Failed some operation[%d]", _playlist_item->function);
556 int media_playlist_update_to_db(media_playlist_h playlist)
558 int ret = MEDIA_CONTENT_ERROR_NONE;
559 media_playlist_s *_playlist = (media_playlist_s *)playlist;
561 content_retip_if_fail(playlist);
562 content_retvm_if(!_playlist->item_list, MEDIA_CONTENT_ERROR_NONE, "operation list length is 0");
564 g_list_foreach(_playlist->item_list, __media_playlist_foreach_request, &(_playlist->playlist_id));
566 ret = media_svc_send_query(_content_get_uid());
568 __media_playlist_item_release(_playlist);
570 return _content_error_capi(ret);
573 static int __media_playlist_get_media_id_by_path(const char *path, char **media_id)
575 int ret = MEDIA_CONTENT_ERROR_NONE;
577 sqlite3_stmt *stmt = NULL;
579 content_retip_if_fail(path);
580 content_retip_if_fail(media_id);
582 #ifdef _USE_TVPD_MODE
583 query = sqlite3_mprintf("SELECT media_id FROM '%q' WHERE media_path='%q'", DB_VIEW_MEDIA, path);
585 query = sqlite3_mprintf("SELECT media_id FROM '%q' WHERE media_path='%q'", DB_TABLE_MEDIA, path);
587 ret = _content_get_result(query, &stmt);
588 SQLITE3_SAFE_FREE(query);
589 content_retvm_if(ret != MEDIA_CONTENT_ERROR_NONE, ret, "Failed to get media_id");
591 if (sqlite3_step(stmt) == SQLITE_ROW)
592 *media_id = g_strdup((const char *)sqlite3_column_text(stmt, 0));
594 SQLITE3_FINALIZE(stmt);
599 static void __media_playlist_foreach_item(gpointer item, gpointer user_data)
601 int ret = MEDIA_CONTENT_ERROR_NONE;
602 char *path = (char *)item;
603 media_playlist_h *playlist = (media_playlist_h *)user_data;
604 char *media_id = NULL;
606 ret = __media_playlist_get_media_id_by_path(path, &media_id);
607 if (ret != MEDIA_CONTENT_ERROR_NONE) {
608 content_sec_error("Fail to get media_id [%s]", path);
612 ret = media_playlist_add_media(*playlist, media_id);
614 if (ret != MEDIA_CONTENT_ERROR_NONE) {
615 content_sec_error("Fail to add media [%s]", path);
620 int media_playlist_import_from_file(const char *path, const char *playlist_name, media_playlist_h *playlist)
622 int ret = MEDIA_CONTENT_ERROR_NONE;
623 GSList *item_list = NULL;
624 char repl_path[MAX_PATH_LEN] = {0, };
626 content_retip_if_fail(STRING_VALID(path));
627 content_retip_if_fail(STRING_VALID(playlist_name));
629 ret = _media_content_replace_path(path, repl_path);
630 content_retvm_if(!STRING_VALID(repl_path), MEDIA_CONTENT_ERROR_INVALID_OPERATION, "path replacement failed");
632 ret = media_playlist_insert_to_db(playlist_name, playlist);
633 content_retvm_if(ret != MEDIA_CONTENT_ERROR_NONE, ret, "media_playlist_insert_to_db fail");
635 ret = __media_playlist_import_item_from_file(repl_path, &item_list);
636 content_retvm_if(ret != MEDIA_CONTENT_ERROR_NONE, ret, "Fail to get playlist from file");
638 g_slist_foreach(item_list, __media_playlist_foreach_item, playlist);
640 ret = media_playlist_update_to_db(*playlist);
641 g_slist_free_full(item_list, g_free);
646 int media_playlist_export_to_file(media_playlist_h playlist, const char *path)
648 int ret = MEDIA_CONTENT_ERROR_NONE;
649 media_playlist_s *_playlist = (media_playlist_s *)playlist;
650 GList *item_list = NULL;
651 unsigned int idx = 0;
652 char repl_path[MAX_PATH_LEN] = {0, };
654 content_retip_if_fail(STRING_VALID(path));
655 content_retip_if_fail(playlist);
656 content_retipm_if_fail(_playlist->playlist_id > 0, "%d", _playlist->playlist_id);
658 ret = _media_content_replace_path(path, repl_path);
659 content_retvm_if(!STRING_VALID(repl_path), MEDIA_CONTENT_ERROR_INVALID_OPERATION, "path replacement failed");
661 ret = _media_db_get_playlist_item(_playlist->playlist_id, NULL, __media_playlist_member_cb, &item_list);
662 content_retvm_if(ret != MEDIA_CONTENT_ERROR_NONE, ret, "_media_db_get_playlist_item fail");
664 ret = __media_playlist_reset_file(repl_path);
665 if (ret != MEDIA_CONTENT_ERROR_NONE) {
666 g_list_free_full(item_list, g_free);
667 content_error("Fail to init playlist file");
671 for (idx = 0; idx < g_list_length(item_list); idx++) {
672 char *item = g_list_nth_data(item_list, idx);
673 if (STRING_VALID(item)) {
674 ret = __media_playlist_append_to_file(repl_path, item);
675 if (ret != MEDIA_CONTENT_ERROR_NONE) {
676 g_list_free_full(item_list, g_free);
677 content_error("Fail to export paths into file");
683 g_list_free_full(item_list, g_free);
688 int media_playlist_create(media_playlist_h *playlist)
690 content_retip_if_fail(playlist);
692 media_playlist_s *_playlist = g_new0(media_playlist_s, 1);
694 _playlist->playlist_id = -1;
695 _playlist->name = NULL;
696 _playlist->thumbnail_path = NULL;
697 _playlist->item_list = NULL;
699 *playlist = (media_playlist_h)_playlist;
701 return MEDIA_CONTENT_ERROR_NONE;
704 int media_playlist_get_play_order_v2(int playlist_id, int playlist_member_id, int *play_order)
706 int ret = MEDIA_CONTENT_ERROR_NONE;
707 sqlite3_stmt *stmt = NULL;
710 content_retipm_if_fail(playlist_id >= 0, "%d", playlist_id);
711 content_retipm_if_fail(playlist_member_id >= 0, "%d", playlist_member_id);
712 content_retip_if_fail(play_order);
714 query = sqlite3_mprintf(SELECT_PLAY_ORDER_FROM_PLAYLIST_VIEW, playlist_id, playlist_member_id);
716 ret = _content_get_result(query, &stmt);
717 SQLITE3_SAFE_FREE(query);
718 content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
720 if (sqlite3_step(stmt) == SQLITE_ROW)
721 *play_order = sqlite3_column_int(stmt, 0);
723 SQLITE3_FINALIZE(stmt);
728 int media_playlist_insert_to_db_v2(media_playlist_h playlist)
730 int ret = MEDIA_CONTENT_ERROR_NONE;
731 media_playlist_s *_playlist = (media_playlist_s *)playlist;
734 content_retip_if_fail(playlist);
735 content_retipm_if_fail(_playlist->playlist_id == -1, "%d", _playlist->playlist_id);
737 ret = __media_playlist_insert_playlist_record(_playlist->name, &playlist_id);
738 if (ret != MEDIA_CONTENT_ERROR_NONE) {
739 __media_playlist_item_release(_playlist);
740 content_error("Insert playlist Fail");
744 _playlist->playlist_id = playlist_id;
746 return media_playlist_update_to_db(playlist);
749 int media_playlist_update_to_db_v2(int playlist_id, media_playlist_h playlist)
751 media_playlist_s *_playlist = (media_playlist_s *)playlist;
752 content_retip_if_fail(playlist);
754 _playlist->playlist_id = playlist_id;
756 return media_playlist_update_to_db(playlist);