X-Git-Url: http://review.tizen.org/git/?a=blobdiff_plain;f=src%2Fmedia_db.c;h=4ae086389a647015256fddc78b370a8cd143cdbf;hb=8472301bb1cc6eead8fcfaf57f3a7547098a64f4;hp=08b8ab5787bb8236cbbbb26f484347e6be77eb8f;hpb=34ef3e3cd4a841e93e7d8e718b6af70fe773a247;p=platform%2Fcore%2Fapi%2Fmedia-content.git

diff --git a/src/media_db.c b/src/media_db.c
index 08b8ab5..4ae0863 100755
--- a/src/media_db.c
+++ b/src/media_db.c
@@ -285,7 +285,6 @@ int _media_db_get_media_group_count(media_group_e group, filter_h filter, int *g
 	char *tmp_option = NULL;
 	filter_s *_filter = (filter_s *)filter;
 
-	memset(select_query, 0x00, sizeof(select_query));
 	if (group < MEDIA_PVR_GROUP_DURATION) {	/*media content*/
 		if ((_filter != NULL) && STRING_VALID(_filter->storage_id))
 			snprintf(select_query, sizeof(select_query), SELECT_MEDIA_GROUP_COUNT, __media_db_get_group_name(group), _filter->storage_id);
@@ -335,7 +334,7 @@ int _media_db_get_media_group(media_group_e group, filter_h filter, media_group_
 	char *name = NULL;
 	sqlite3_stmt *stmt = NULL;
 	filter_s *_filter = (filter_s *)filter;
-	memset(select_query, 0x00, sizeof(select_query));
+
 	if (group < MEDIA_PVR_GROUP_DURATION) {	/*media content */
 		if ((_filter != NULL) && STRING_VALID(_filter->storage_id))
 			snprintf(select_query, sizeof(select_query), SELECT_MEDIA_GROUP_LIST, __media_db_get_group_name(group), _filter->storage_id);
@@ -387,9 +386,6 @@ int _media_db_get_media_group_and_count(media_group_e group, filter_h filter, me
 	sqlite3_stmt *stmt = NULL;
 	filter_s *_filter = (filter_s *)filter;
 
-	memset(select_query, 0x00, sizeof(select_query));
-	memset(group_query, 0x00, sizeof(group_query));
-
 	const char* group_name = __media_db_get_group_name(group);
 	if (!STRING_VALID(group_name)) {
 		ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
@@ -606,7 +602,6 @@ int _media_db_get_album(filter_h filter, media_album_cb callback, void *user_dat
 	sqlite3_stmt *stmt = NULL;
 	filter_s *_filter = (filter_s *)filter;
 
-	memset(select_query, 0x00, sizeof(select_query));
 #ifdef _USE_TVPD_MODE
 	if ((_filter != NULL) && STRING_VALID(_filter->storage_id))
 		snprintf(select_query, sizeof(select_query), SELECT_ALBUM_LIST, _filter->storage_id);
@@ -662,7 +657,6 @@ int _media_db_get_folder(filter_h filter, media_folder_cb callback, void *user_d
 	sqlite3_stmt *stmt = NULL;
 	filter_s *_filter = (filter_s *)filter;
 
-	memset(select_query, 0x00, sizeof(select_query));
 #ifdef _USE_TVPD_MODE
 	if ((_filter != NULL) && STRING_VALID(_filter->storage_id))
 		snprintf(select_query, sizeof(select_query), SELECT_FOLDER_LIST_BY_STORAGE_ID, _filter->storage_id, _filter->storage_id);
@@ -857,7 +851,6 @@ int _media_db_get_bookmark(const char *media_id, filter_h filter, media_bookmark
 	sqlite3_stmt *stmt = NULL;
 	filter_s *_filter = (filter_s *)filter;
 
-	memset(select_query, 0x00, sizeof(select_query));
 #ifdef _USE_TVPD_MODE
 	if (STRING_VALID(media_id)) {	//get bookmark by media_id
 		if ((_filter != NULL) && STRING_VALID(_filter->storage_id))
@@ -927,7 +920,6 @@ int _media_db_get_face(const char *media_id, filter_h filter, media_face_cb call
 	sqlite3_stmt *stmt = NULL;
 	filter_s *_filter = (filter_s *)filter;
 
-	memset(select_query, 0x00, sizeof(select_query));
 #ifdef _USE_TVPD_MODE
 	if (STRING_VALID(media_id)) {	//get face by media_id
 		if ((_filter != NULL) && STRING_VALID(_filter->storage_id))
@@ -999,8 +991,6 @@ int _media_db_get_group_item_count_by_id(int group_id, filter_h filter, group_li
 	char *option_query = NULL;
 	filter_s *_filter = (filter_s *)filter;
 
-	memset(select_query, 0x00, sizeof(select_query));
-
 	switch (group_type) {
 	case MEDIA_GROUP_ALBUM:
 #ifdef _USE_TVPD_MODE
@@ -1056,8 +1046,6 @@ int _media_db_get_group_item_count(const char *group_name, filter_h filter, grou
 	bool need_bracket = false;
 	filter_s *_filter = (filter_s *)filter;
 
-	memset(select_query, 0x00, sizeof(select_query));
-
 	switch (group_type) {
 	case MEDIA_GROUP_NONE:
 		if (!_filter) {
@@ -1197,8 +1185,6 @@ int _media_db_get_group_item_by_id(int group_id, filter_h filter, media_info_cb
 	sqlite3_stmt *stmt = NULL;
 	filter_s *_filter = (filter_s *)filter;
 
-	memset(select_query, 0x00, sizeof(select_query));
-
 	switch (group_type) {
 	case MEDIA_GROUP_ALBUM:
 #ifdef _USE_TVPD_MODE
@@ -1287,8 +1273,6 @@ int _media_db_get_group_item(const char *group_name, filter_h filter, media_info
 	sqlite3_stmt *stmt = NULL;
 	filter_s *_filter = (filter_s *)filter;
 
-	memset(select_query, 0x00, sizeof(select_query));
-
 	switch (group_type) {
 	case MEDIA_GROUP_NONE:
 #ifdef _USE_TVPD_MODE
@@ -1373,8 +1357,6 @@ int _media_db_get_group_item_by_union_select(const char *group_name, filter_h fi
 	filter_s *_filter1 = (filter_s *)filter1;
 	filter_s *_filter2 = (filter_s *)filter2;
 
-	memset(select_query1, 0x00, sizeof(select_query1));
-
 	if ((_filter1 != NULL) && STRING_VALID(_filter1->storage_id))
 		snprintf(select_query1, sizeof(select_query1), SELECT_MEDIA_FROM_FOLDER, _filter1->storage_id, group_name);
 	else
@@ -1388,8 +1370,6 @@ int _media_db_get_group_item_by_union_select(const char *group_name, filter_h fi
 		return ret;
 	}
 
-	memset(select_query2, 0x00, sizeof(select_query2));
-
 	if ((_filter2 != NULL) && STRING_VALID(_filter2->storage_id))
 		snprintf(select_query2, sizeof(select_query2), SELECT_MEDIA_FROM_FOLDER, _filter2->storage_id, group_name);
 	else
@@ -1446,7 +1426,6 @@ int _media_db_get_media_group_item_count(const char *group_name, filter_h filter
 	char *option_query = NULL;
 	filter_s *_filter = (filter_s *)filter;
 
-	memset(select_query, 0x00, sizeof(select_query));
 #ifdef _USE_TVPD_MODE
 	if (group < MEDIA_PVR_GROUP_DURATION) { /*media content */
 		if (group_name != NULL) {
@@ -1532,7 +1511,6 @@ int _media_db_get_media_group_item(const char *group_name, filter_h filter, medi
 	sqlite3_stmt *stmt = NULL;
 	filter_s *_filter = (filter_s *)filter;
 
-	memset(select_query, 0x00, sizeof(select_query));
 #ifdef _USE_TVPD_MODE
 	if (group_name != NULL) {
 		if ((_filter != NULL) && STRING_VALID(_filter->storage_id))
@@ -1664,8 +1642,6 @@ int _media_db_get_pvr_group_item(const char *group_name, filter_h filter, media_
 	sqlite3_stmt *stmt = NULL;
 	filter_s *_filter = (filter_s *)filter;
 
-	memset(select_query, 0x00, sizeof(select_query));
-
 	if (group_name != NULL) {
 		if ((_filter != NULL) && STRING_VALID(_filter->storage_id))
 			sqlite3_snprintf(sizeof(select_query), select_query, SELECT_PVR_FROM_GROUP_BY_STORAGE_ID, _filter->storage_id, __media_db_get_group_name(group), group_name);
@@ -1885,8 +1861,6 @@ int _media_db_get_pvr(filter_h filter, media_pvr_cb callback, void *user_data)
 	sqlite3_stmt *stmt = NULL;
 	filter_s *_filter = (filter_s *)filter;
 
-	memset(select_query, 0x00, sizeof(select_query));
-
 	if ((_filter != NULL) && STRING_VALID(_filter->storage_id))
 		snprintf(select_query, sizeof(select_query), SELECT_PVR_LIST_BY_STORAGE_ID, _filter->storage_id);
 	else
@@ -1984,8 +1958,6 @@ int _media_db_get_uhd(filter_h filter, media_uhd_cb callback, void *user_data)
 	sqlite3_stmt *stmt = NULL;
 	filter_s *_filter = (filter_s *)filter;
 
-	memset(select_query, 0x00, sizeof(select_query));
-
 	if ((_filter != NULL) && STRING_VALID(_filter->storage_id))
 		snprintf(select_query, sizeof(select_query), SELECT_UHD_LIST_BY_STORAGE_ID, _filter->storage_id);
 	else