#include <media_filter.h>
#include <media_info.h>
#include <media_info_private.h>
-#include <media_playlist.h>
+#include <media_util_private.h>
+
#define PLAYLIST_ARRAY_SIZE 20
#define PLAYLIST_ARRAY_EXPAND 10
select_query = sqlite3_mprintf(SELECT_PLAYLIST_ID_FROM_PLAYLIST, playlist_name);
- ret = _content_query_prepare(&stmt, select_query, NULL, NULL);
+ ret = _content_get_result(select_query, &stmt);
SQLITE3_SAFE_FREE(select_query);
media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
- while (sqlite3_step(stmt) == SQLITE_ROW)
+ if (sqlite3_step(stmt) == SQLITE_ROW)
*playlist_id = (int)sqlite3_column_int(stmt, 0);
SQLITE3_FINALIZE(stmt);
{
int ret = MEDIA_CONTENT_ERROR_NONE;
sqlite3_stmt *stmt = NULL;
- char select_query[DEFAULT_QUERY_SIZE];
+ char select_query[DEFAULT_QUERY_SIZE] = {0, };
char *query_str = NULL;
int play_order = 0;
snprintf(select_query, sizeof(select_query), SELECT_MAX_PLAY_ORDER_FROM_PLAYLIST_VIEW, playlist_id);
/* get the max play_order */
- ret = _content_query_prepare(&stmt, select_query, NULL, NULL);
+ ret = _content_get_result(select_query, &stmt);
media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
- while (sqlite3_step(stmt) == SQLITE_ROW)
+ if (sqlite3_step(stmt) == SQLITE_ROW)
play_order = (int)sqlite3_column_int(stmt, 0);
SQLITE3_FINALIZE(stmt);
++play_order;
- query_str = sqlite3_mprintf("INSERT INTO %q (playlist_id, media_uuid, play_order) values (%d, '%q', %d);",
- DB_TABLE_PLAYLIST_MAP, playlist_id, media_id, play_order);
- ret = media_svc_append_query(query_str, tzplatform_getuid(TZ_USER_NAME));
+ query_str = sqlite3_mprintf(INSERT_PLAYLIST_ITEM_TO_PLAYLIST_MAP, playlist_id, media_id, play_order);
+ ret = media_svc_append_query(query_str, _content_get_uid());
- return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
+ return _content_error_capi(ret);
}
static int __media_playlist_remove_item_from_playlist(int playlist_id, int playlist_member_id)
char *query_str = NULL;
query_str = sqlite3_mprintf(REMOVE_PLAYLIST_ITEM_FROM_PLAYLIST_MAP, playlist_id, playlist_member_id);
- ret = media_svc_append_query(query_str, tzplatform_getuid(TZ_USER_NAME));
+ ret = media_svc_append_query(query_str, _content_get_uid());
- return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
+ return _content_error_capi(ret);
}
static int __media_playlist_update_playlist_name(int playlist_id, const char *playlist_name)
char *query_str = NULL;
query_str = sqlite3_mprintf(UPDATE_PLAYLIST_NAME_FROM_PLAYLIST, playlist_name, playlist_id);
- ret = media_svc_append_query(query_str, tzplatform_getuid(TZ_USER_NAME));
+ ret = media_svc_append_query(query_str, _content_get_uid());
- return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
+ return _content_error_capi(ret);
}
static int __media_playlist_update_thumbnail_path(int playlist_id, const char *path)
char *query_str = NULL;
query_str = sqlite3_mprintf(UPDATE_PLAYLIST_THUMBNAIL_FROM_PLAYLIST, path, playlist_id);
- ret = media_svc_append_query(query_str, tzplatform_getuid(TZ_USER_NAME));
+ ret = media_svc_append_query(query_str, _content_get_uid());
- return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
+ return _content_error_capi(ret);
}
static int __media_playlist_update_play_order(int playlist_id, int playlist_member_id, int play_order)
char *query_str = NULL;
query_str = sqlite3_mprintf(UPDATE_PLAYLIST_ORDER_FROM_PLAYLIST_MAP, play_order, playlist_id, playlist_member_id);
- ret = media_svc_append_query(query_str, tzplatform_getuid(TZ_USER_NAME));
+ ret = media_svc_append_query(query_str, _content_get_uid());
- return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
+ return _content_error_capi(ret);
}
static bool __media_playlist_media_info_cb(media_info_h media, void *user_data)
int current_index = 0;
int current_max_size = PLAYLIST_ARRAY_SIZE;
int tmp_str_len = 0;
- char *buf = NULL;
char *tmp_buf = NULL;
- char *tmp_str = NULL;
-
+ char tmp_str[MAX_QUERY_SIZE] = {0, };
+ char repl_item[MAX_QUERY_SIZE] = {0, };
FILE *fp = NULL;
long int file_size = 0;
fp = fopen(playlist_path, "rb");
media_content_retvm_if(fp == NULL, MEDIA_CONTENT_ERROR_INVALID_OPERATION, "fopen fail");
- fseek(fp, 0, SEEK_END);
+ if (fseek(fp, 0, SEEK_END) < 0) {
+ media_content_stderror("fseek failed");
+ fclose(fp);
+ return MEDIA_CONTENT_ERROR_INVALID_OPERATION;
+ }
file_size = ftell(fp);
- fseek(fp, 0 , SEEK_SET);
-
if (file_size == 0) {
media_content_debug("file is empty.");
fclose(fp);
return MEDIA_CONTENT_ERROR_NONE;
}
- if (file_size > 0)
- buf = malloc(file_size + 1);
-
- if (buf == NULL) {
- media_content_error("Out of Memory");
- fclose(fp);
- return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
- }
-
- tmp_buf = buf;
-
- if (fread(buf, file_size, 1, fp) != 1) {
+ if (fseek(fp, 0, SEEK_SET) < 0) {
+ media_content_stderror("fseek failed");
fclose(fp);
- SAFE_FREE(buf);
- media_content_stderror("fread fail");
return MEDIA_CONTENT_ERROR_INVALID_OPERATION;
}
- buf[file_size] = 0;
- fclose(fp);
*item_list = calloc(current_max_size, sizeof(char*));
- tmp_str = malloc(MAX_TMP_STR);
- if (tmp_str == NULL || *item_list == NULL) {
+ if (*item_list == NULL) {
+ fclose(fp);
SAFE_FREE(*item_list);
- SAFE_FREE(buf);
- SAFE_FREE(tmp_str);
media_content_error("Out of Memory");
return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
}
+ memset(tmp_str, 0, sizeof(tmp_str));
- char format[25];
- snprintf(format, 25, "%%%d[^\n]", MAX_TMP_STR);
-
- while ((sscanf(tmp_buf, format, tmp_str) == 1) || (*tmp_buf == '\n')) {
- if (*tmp_buf == '\n') {
- tmp_buf += 1;
+ while (fgets(tmp_str, MAX_QUERY_SIZE, fp) != NULL) {
+ memset(repl_item, 0, sizeof(repl_item));
+ _media_content_replace_path(tmp_str, repl_item);
+ tmp_str_len = strlen(repl_item);
+ if (tmp_str_len > 0 && repl_item[tmp_str_len - 1] == '\n')
+ repl_item[tmp_str_len - 1] = '\0';
- if (tmp_buf < (buf + file_size))
- continue;
- else
- break;
- }
+ tmp_str_len = strlen(repl_item);
- tmp_str_len = strlen(tmp_str);
-
- if (tmp_str[0] != '#') {
+ if (tmp_str_len > 0 && repl_item[0] != '#') {
if (!(current_index < (current_max_size - 1))) {
current_max_size += PLAYLIST_ARRAY_EXPAND;
char **tmp_ptr = calloc(current_max_size, sizeof(char*));
if (tmp_ptr == NULL) {
__media_playlist_destroy_import_item(*item_list, current_index);
- SAFE_FREE(buf);
- SAFE_FREE(tmp_str);
media_content_error("Out of Memory");
+ fclose(fp);
return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
}
memmove(tmp_ptr, *item_list, sizeof(char*) * current_index);
(*item_list)[current_index] = malloc(tmp_str_len + 1);
if ((*item_list)[current_index] == NULL) {
__media_playlist_destroy_import_item(*item_list, current_index);
- SAFE_FREE(buf);
- SAFE_FREE(tmp_str);
media_content_error("Out of Memory");
+ fclose(fp);
return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
}
- memmove((*item_list)[current_index], tmp_str, tmp_str_len + 1);
+ memset((*item_list)[current_index], 0, tmp_str_len + 1);
+ memmove((*item_list)[current_index], repl_item, tmp_str_len);
current_index += 1;
}
- tmp_buf += (tmp_str_len + 1);
+ tmp_buf += (tmp_str_len);
}
*item_count = current_index;
-
- SAFE_FREE(buf);
- SAFE_FREE(tmp_str);
+ fclose(fp);
return MEDIA_CONTENT_ERROR_NONE;
}
{
int ret = MEDIA_CONTENT_ERROR_NONE;
sqlite3_stmt *stmt = NULL;
- char select_query[DEFAULT_QUERY_SIZE];
+ char select_query[DEFAULT_QUERY_SIZE] = {0, };
if (playlist_id > 0) {
memset(select_query, 0x00, sizeof(select_query));
snprintf(select_query, sizeof(select_query), SELECT_PLAYLIST_FROM_PLAYLIST, playlist_id);
- ret = _content_query_prepare(&stmt, select_query, NULL, NULL);
+ ret = _content_get_result(select_query, &stmt);
media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
media_playlist_s *_playlist = NULL;
- while (sqlite3_step(stmt) == SQLITE_ROW) {
- if (_playlist)
- media_playlist_destroy((media_playlist_h)_playlist);
-
+ if (sqlite3_step(stmt) == SQLITE_ROW) {
_playlist = (media_playlist_s*)calloc(1, sizeof(media_playlist_s));
if (_playlist == NULL) {
media_content_error("OUT_OF_MEMORY(0x%08x)", MEDIA_CONTENT_ERROR_OUT_OF_MEMORY);
return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
}
- _playlist->playlist_id = (int)sqlite3_column_int(stmt, 0);
- _playlist->name = g_strdup((const char *)sqlite3_column_text(stmt, 1));
- _playlist->thumbnail_path = g_strdup((const char *)sqlite3_column_text(stmt, 3));
+ _playlist->playlist_id = playlist_id;
+ _playlist->name = g_strdup((const char *)sqlite3_column_text(stmt, 0));
+ _playlist->thumbnail_path = g_strdup((const char *)sqlite3_column_text(stmt, 1));
*playlist = (media_playlist_h)_playlist;
+ } else {
+ media_content_error("Nonexistent playlist id[%d]", playlist_id);
+ ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
}
SQLITE3_FINALIZE(stmt);
media_playlist_s *_playlist = (media_playlist_s*)playlist;
int playlist_id = 0;
sqlite3_stmt *stmt = NULL;
- char select_query[DEFAULT_QUERY_SIZE];
+ char select_query[DEFAULT_QUERY_SIZE] = {0, };
if ((_playlist == NULL) || (playlist_member_id < 0) || (play_order == NULL)) {
media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
snprintf(select_query, sizeof(select_query), SELECT_PLAY_ORDER_FROM_PLAYLIST_VIEW, playlist_id, playlist_member_id);
- ret = _content_query_prepare(&stmt, select_query, NULL, NULL);
+ ret = _content_get_result(select_query, &stmt);
media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
- while (sqlite3_step(stmt) == SQLITE_ROW)
+ if (sqlite3_step(stmt) == SQLITE_ROW)
*play_order = (int)sqlite3_column_int(stmt, 0);
SQLITE3_FINALIZE(stmt);
media_playlist_item_s *item = (media_playlist_item_s*)calloc(1, sizeof(media_playlist_item_s));
media_content_retvm_if(item == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY");
- item->thumbnail_path = strdup(path);
+ item->thumbnail_path = g_strdup(path);
item->function = MEDIA_PLAYLIST_UPDATE_THUMBNAIL_PATH;
if (item->thumbnail_path == NULL) {
SAFE_FREE(item);
default:
break;
}
+
+ if (ret != MEDIA_CONTENT_ERROR_NONE)
+ media_content_error("Failed some operation[%d]", _playlist_item->function);
}
+
}
- ret = media_svc_send_query(tzplatform_getuid(TZ_USER_NAME));
+ ret = media_svc_send_query(_content_get_uid());
__media_playlist_item_release(_playlist);
- return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
+ return _content_error_capi(ret);
}
int media_playlist_import_from_file(const char *path, const char *playlist_name, media_playlist_h *playlist)
char** import_item_list = NULL;
int import_item_count = 0;
int idx;
+ char repl_path[MAX_PATH_LEN] = {0, };
media_content_retvm_if(!STRING_VALID(path), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid path");
media_content_retvm_if(!STRING_VALID(playlist_name), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid playlist_name");
+ memset(repl_path, 0, sizeof(repl_path));
+ ret = _media_content_replace_path(path, repl_path);
+ media_content_retvm_if(!STRING_VALID(repl_path), MEDIA_CONTENT_ERROR_INVALID_OPERATION, "path replacement failed");
ret = media_playlist_insert_to_db(playlist_name, playlist);
media_content_retvm_if(ret != MEDIA_CONTENT_ERROR_NONE, ret, "media_playlist_insert_to_db fail");
- ret = __media_playlist_import_item_from_file(path, &import_item_list, &import_item_count);
+ ret = __media_playlist_import_item_from_file(repl_path, &import_item_list, &import_item_count);
if (ret != MEDIA_CONTENT_ERROR_NONE) {
__media_playlist_destroy_import_item(import_item_list, import_item_count);
media_content_error("Fail to get playlist from file");
media_content_error("error media_filter_create");
return ret;
}
- condition = sqlite3_mprintf("path = '%q'", import_item_list[idx]);
+ condition = sqlite3_mprintf("media_path = '%q'", import_item_list[idx]);
ret = media_filter_set_condition(filter, condition, MEDIA_CONTENT_COLLATE_DEFAULT);
if (ret != MEDIA_CONTENT_ERROR_NONE) {
__media_playlist_destroy_import_item(import_item_list, import_item_count);
media_playlist_s *_playlist = (media_playlist_s*)playlist;
GList *item_list = NULL;
unsigned int idx = 0;
+ char repl_path[MAX_PATH_LEN] = {0, };
media_content_retvm_if(!STRING_VALID(path), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid path");
media_content_retvm_if(_playlist == NULL, MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid playlist");
media_content_retvm_if(_playlist->playlist_id <= 0, MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid playlist_id");
+ memset(repl_path, 0, sizeof(repl_path));
+ ret = _media_content_replace_path(path, repl_path);
+ media_content_retvm_if(!STRING_VALID(repl_path), MEDIA_CONTENT_ERROR_INVALID_OPERATION, "path replacement failed");
ret = _media_db_get_playlist_item(_playlist->playlist_id, NULL, __media_playlist_member_cb, &item_list);
media_content_retvm_if(ret != MEDIA_CONTENT_ERROR_NONE, ret, "_media_db_get_playlist_item fail");
- ret = __media_playlist_reset_file(path);
+ ret = __media_playlist_reset_file(repl_path);
if (ret != MEDIA_CONTENT_ERROR_NONE) {
g_list_free_full(item_list, __media_playlist_destroy_export_item);
media_content_error("Fail to init playlist file");
for (idx = 0; idx < g_list_length(item_list); idx++) {
char *item = g_list_nth_data(item_list, idx);
- ret = __media_playlist_append_to_file(path, item);
- if (ret != MEDIA_CONTENT_ERROR_NONE) {
- g_list_free_full(item_list, __media_playlist_destroy_export_item);
- media_content_error("Fail to export paths into file");
- return ret;
+ if (STRING_VALID(item)) {
+ ret = __media_playlist_append_to_file(repl_path, item);
+ if (ret != MEDIA_CONTENT_ERROR_NONE) {
+ g_list_free_full(item_list, __media_playlist_destroy_export_item);
+ media_content_error("Fail to export paths into file");
+ return ret;
+ }
}
}
return ret;
}
+
+int media_playlist_create(media_playlist_h *playlist)
+{
+ int ret = MEDIA_CONTENT_ERROR_NONE;
+
+ media_content_retvm_if(playlist == NULL, MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "invalid playlist");
+
+ media_playlist_s *_playlist = (media_playlist_s*)calloc(1, sizeof(media_playlist_s));
+ media_content_retvm_if(_playlist == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY");
+
+ _playlist->playlist_id = -1;
+ _playlist->name = NULL;
+ _playlist->thumbnail_path = NULL;
+ _playlist->item_list = NULL;
+
+ *playlist = (media_playlist_h)_playlist;
+
+ return ret;
+}
+
+int media_playlist_get_play_order_v2(int playlist_id, int playlist_member_id, int *play_order)
+{
+ int ret = MEDIA_CONTENT_ERROR_NONE;
+ sqlite3_stmt *stmt = NULL;
+ char select_query[DEFAULT_QUERY_SIZE] = {0, };
+
+ if ((playlist_id < 0) || (playlist_member_id < 0) || (play_order == NULL)) {
+ media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
+ return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
+ }
+
+ memset(select_query, 0x00, sizeof(select_query));
+
+ snprintf(select_query, sizeof(select_query), SELECT_PLAY_ORDER_FROM_PLAYLIST_VIEW, playlist_id, playlist_member_id);
+
+ ret = _content_get_result(select_query, &stmt);
+ media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
+
+ if (sqlite3_step(stmt) == SQLITE_ROW)
+ *play_order = (int)sqlite3_column_int(stmt, 0);
+
+ SQLITE3_FINALIZE(stmt);
+
+ return ret;
+}
+
+int media_playlist_insert_to_db_v2(media_playlist_h playlist)
+{
+ int ret = MEDIA_CONTENT_ERROR_NONE;
+ media_playlist_s *_playlist = (media_playlist_s*)playlist;
+ int playlist_id = 0;
+
+ media_content_retvm_if(_playlist == NULL, MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid playlist");
+ media_content_retvm_if(_playlist->playlist_id != -1, MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "invalid playlist insert");
+
+ ret = __media_playlist_insert_playlist_record(_playlist->name, &playlist_id);
+ if (ret != MEDIA_CONTENT_ERROR_NONE) {
+ __media_playlist_item_release(_playlist);
+ media_content_error("Insert playlist Fail");
+ return ret;
+ }
+
+ _playlist->playlist_id = playlist_id;
+
+ ret = media_playlist_update_to_db(playlist);
+
+ return ret;
+}
+
+int media_playlist_update_to_db_v2(int playlist_id, media_playlist_h playlist)
+{
+ media_playlist_s *_playlist = (media_playlist_s*)playlist;
+
+ media_content_retvm_if(_playlist == NULL, MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid playlist");
+
+ _playlist->playlist_id = playlist_id;
+
+ return media_playlist_update_to_db(playlist);
+}