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>
20 static void __media_tag_item_add(media_tag_s *tag_s, media_tag_item_s *item_s);
21 static void __media_tag_item_release(media_tag_s *tag_s);
22 static int __media_tag_insert_item_to_tag(int tag_id, const char *media_id);
23 static int __media_tag_remove_item_from_tag(int tag_id, const char *media_id);
24 static int __media_tag_update_tag_name(int tag_id, const char *tag_name);
25 static int __media_tag_get_tag_info_from_db(const char *name, media_tag_h tag);
27 static void __media_tag_item_add(media_tag_s *tag_s, media_tag_item_s *item_s)
29 tag_s->item_list = g_list_append(tag_s->item_list, item_s);
32 static void __media_tag_item_release(media_tag_s *tag_s)
36 media_tag_item_s *item = NULL;
38 list_cnt = g_list_length(tag_s->item_list);
40 media_content_debug("list_cnt : [%d]", list_cnt);
42 for (idx = 0; idx < list_cnt; idx++) {
43 item = (media_tag_item_s*)g_list_nth_data(tag_s->item_list, idx);
45 SAFE_FREE(item->media_id);
46 SAFE_FREE(item->tag_name);
51 g_list_free(tag_s->item_list);
52 tag_s->item_list = NULL;
56 static int __media_tag_insert_item_to_tag(int tag_id, const char *media_id)
58 int ret = MEDIA_CONTENT_ERROR_NONE;
59 char *query_str = NULL;
61 query_str = sqlite3_mprintf("INSERT INTO %q (tag_id, media_uuid) values (%d, '%q')",
62 DB_TABLE_TAG_MAP, tag_id, media_id);
63 ret = _content_query_sql(query_str);
64 SQLITE3_SAFE_FREE(query_str);
69 static int __media_tag_remove_item_from_tag(int tag_id, const char *media_id)
71 int ret = MEDIA_CONTENT_ERROR_NONE;
72 char *query_str = NULL;
74 query_str = sqlite3_mprintf(REMOVE_TAG_ITEM_FROM_TAG_MAP, tag_id, media_id);
76 ret = _content_query_sql(query_str);
77 SQLITE3_SAFE_FREE(query_str);
82 static int __media_tag_update_tag_name(int tag_id, const char *tag_name)
84 int ret = MEDIA_CONTENT_ERROR_NONE;
85 char *query_str = NULL;
87 query_str = sqlite3_mprintf(UPDATE_TAG_NAME_FROM_TAG, tag_name, tag_id);
89 ret = _content_query_sql(query_str);
90 SQLITE3_SAFE_FREE(query_str);
95 static int __media_tag_get_tag_info_from_db(const char *name, media_tag_h tag)
97 int ret = MEDIA_CONTENT_ERROR_NONE;
98 sqlite3_stmt *stmt = NULL;
99 char *select_query = NULL;
101 char *tag_name = NULL;
102 media_tag_s *_tag = (media_tag_s*)tag;
104 media_content_retvm_if(_tag == NULL, MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "invalid tag");
106 select_query = sqlite3_mprintf(SELECT_TAG_BY_NAME, name);
108 ret = _content_query_prepare(&stmt, select_query, NULL, NULL);
109 SQLITE3_SAFE_FREE(select_query);
110 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
112 while (sqlite3_step(stmt) == SQLITE_ROW) {
115 id = (int)sqlite3_column_int(stmt, 0);
116 tag_name = g_strdup((const char *)sqlite3_column_text(stmt, 1));
120 _tag->name = tag_name;
122 SQLITE3_FINALIZE(stmt);
127 int media_tag_insert_to_db(const char *tag_name, media_tag_h *tag)
129 int ret = MEDIA_CONTENT_ERROR_NONE;
130 char *query_str = NULL;
132 if (!STRING_VALID(tag_name)) {
133 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
134 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
137 query_str = sqlite3_mprintf(INSERT_TAG_TO_TAG, tag_name);
138 ret = _content_query_sql(query_str);
139 SQLITE3_SAFE_FREE(query_str);
141 if (ret == MEDIA_CONTENT_ERROR_NONE) {
142 media_tag_s *_tag = (media_tag_s*)calloc(1, sizeof(media_tag_s));
143 media_content_retvm_if(_tag == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY");
145 ret = __media_tag_get_tag_info_from_db(tag_name, (media_tag_h)_tag);
146 *tag = (media_tag_h)_tag;
152 int media_tag_delete_from_db(int tag_id)
154 int ret = MEDIA_CONTENT_ERROR_NONE;
155 char *query_str = NULL;
158 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
159 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
162 query_str = sqlite3_mprintf(DELETE_TAG_FROM_TAG, tag_id);
164 ret = _content_query_sql(query_str);
166 SQLITE3_SAFE_FREE(query_str);
171 int media_tag_get_tag_count_from_db(filter_h filter, int *tag_count)
173 int ret = MEDIA_CONTENT_ERROR_NONE;
175 if (tag_count != NULL) {
176 ret = _media_db_get_group_count(filter, MEDIA_GROUP_TAG, tag_count);
178 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
179 ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
185 int media_tag_foreach_tag_from_db(filter_h filter, media_tag_cb callback, void *user_data)
187 int ret = MEDIA_CONTENT_ERROR_NONE;
189 if (callback == NULL) {
190 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
191 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
194 ret = _media_db_get_tag(NULL, filter, callback, user_data);
199 int media_tag_get_media_count_from_db(int tag_id, filter_h filter, int *media_count)
201 int ret = MEDIA_CONTENT_ERROR_NONE;
203 if ((tag_id > 0) && (media_count != NULL)) {
204 ret = _media_db_get_group_item_count_by_id(tag_id, filter, MEDIA_GROUP_TAG, media_count);
206 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
207 ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
213 int media_tag_foreach_media_from_db(int tag_id, filter_h filter, media_info_cb callback, void *user_data)
215 int ret = MEDIA_CONTENT_ERROR_NONE;
217 if (callback == NULL) {
218 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
219 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
222 ret = _media_db_get_group_item_by_id(tag_id, filter, callback, user_data, MEDIA_GROUP_TAG);
227 int media_tag_destroy(media_tag_h tag)
229 int ret = MEDIA_CONTENT_ERROR_NONE;
230 media_tag_s *_tag = (media_tag_s*)tag;
232 SAFE_FREE(_tag->name);
234 ret = MEDIA_CONTENT_ERROR_NONE;
236 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
237 ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
242 int media_tag_clone(media_tag_h *dst, media_tag_h src)
244 int ret = MEDIA_CONTENT_ERROR_NONE;
245 media_tag_s *_src = (media_tag_s*)src;
246 media_tag_s *_dst = NULL;
248 if ((_src != NULL)) {
249 _dst = (media_tag_s*)calloc(1, sizeof(media_tag_s));
250 media_content_retvm_if(_dst == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY");
252 _dst->tag_id = _src->tag_id;
254 if (STRING_VALID(_src->name)) {
255 _dst->name = strdup(_src->name);
256 if (_dst->name == NULL) {
258 media_content_error("OUT_OF_MEMORY(0x%08x)", MEDIA_CONTENT_ERROR_OUT_OF_MEMORY);
259 return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
262 *dst = (media_tag_h)_dst;
263 ret = MEDIA_CONTENT_ERROR_NONE;
265 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
266 ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
272 int media_tag_get_tag_id(media_tag_h tag, int *tag_id)
274 int ret = MEDIA_CONTENT_ERROR_NONE;
275 media_tag_s *_tag = (media_tag_s*)tag;
277 if ((_tag != NULL) && (tag_id != NULL)) {
278 *tag_id = _tag->tag_id;
279 ret = MEDIA_CONTENT_ERROR_NONE;
281 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
282 ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
288 int media_tag_get_name(media_tag_h tag, char **name)
290 int ret = MEDIA_CONTENT_ERROR_NONE;
291 media_tag_s *_tag = (media_tag_s*)tag;
293 if (STRING_VALID(_tag->name)) {
294 *name = strdup(_tag->name);
295 media_content_retvm_if(*name == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY");
299 ret = MEDIA_CONTENT_ERROR_NONE;
302 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
303 ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
309 int media_tag_get_tag_from_db(int tag_id, media_tag_h *tag)
311 int ret = MEDIA_CONTENT_ERROR_NONE;
312 sqlite3_stmt *stmt = NULL;
313 char select_query[DEFAULT_QUERY_SIZE];
316 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
317 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
320 memset(select_query, 0x00, sizeof(select_query));
322 snprintf(select_query, sizeof(select_query), SELECT_TAG_FROM_TAG, tag_id);
324 ret = _content_query_prepare(&stmt, select_query, NULL, NULL);
325 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
327 media_tag_s *_tag = NULL;
329 while (sqlite3_step(stmt) == SQLITE_ROW) {
331 media_tag_destroy((media_tag_h)_tag);
333 _tag = (media_tag_s*)calloc(1, sizeof(media_tag_s));
335 SQLITE3_FINALIZE(stmt);
336 media_content_error("OUT_OF_MEMORY(0x%08x)", MEDIA_CONTENT_ERROR_OUT_OF_MEMORY);
337 return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
340 _tag->tag_id = (int)sqlite3_column_int(stmt, 0);
341 _tag->name = g_strdup((const char *)sqlite3_column_text(stmt, 1));
343 *tag = (media_tag_h)_tag;
346 SQLITE3_FINALIZE(stmt);
351 int media_tag_add_media(media_tag_h tag, const char *media_id)
353 int ret = MEDIA_CONTENT_ERROR_NONE;
354 media_tag_s *_tag = (media_tag_s*)tag;
356 if ((_tag != NULL) && STRING_VALID(media_id)) {
357 media_tag_item_s *_item = (media_tag_item_s*)calloc(1, sizeof(media_tag_item_s));
358 media_content_retvm_if(_item == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY");
360 _item->media_id = strdup(media_id);
361 _item->function = MEDIA_TAG_ADD;
363 if (_item->media_id == NULL) {
365 media_content_error("OUT_OF_MEMORY(0x%08x)", MEDIA_CONTENT_ERROR_OUT_OF_MEMORY);
366 return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
369 __media_tag_item_add(_tag, _item);
371 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
372 ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
378 int media_tag_remove_media(media_tag_h tag, const char *media_id)
380 int ret = MEDIA_CONTENT_ERROR_NONE;
381 media_tag_s *_tag = (media_tag_s*)tag;
383 if (_tag != NULL && STRING_VALID(media_id)) {
384 media_tag_item_s *_item = (media_tag_item_s*)calloc(1, sizeof(media_tag_item_s));
385 media_content_retvm_if(_item == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY");
387 _item->media_id = strdup(media_id);
388 _item->function = MEDIA_TAG_REMOVE;
390 if (_item->media_id == NULL) {
392 media_content_error("OUT_OF_MEMORY(0x%08x)", MEDIA_CONTENT_ERROR_OUT_OF_MEMORY);
393 return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
396 __media_tag_item_add(_tag, _item);
398 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
399 ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
405 int media_tag_set_name(media_tag_h tag, char *tag_name)
407 int ret = MEDIA_CONTENT_ERROR_NONE;
408 media_tag_s *_tag = (media_tag_s*)tag;
410 if (_tag != NULL && STRING_VALID(tag_name)) {
411 SAFE_FREE(_tag->name);
413 media_tag_item_s *_item = (media_tag_item_s*)calloc(1, sizeof(media_tag_item_s));
414 media_content_retvm_if(_item == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY");
416 _item->tag_name = strdup(tag_name);
417 _item->function = MEDIA_TAG_UPDATE_TAG_NAME;
419 if (_item->tag_name == NULL) {
421 media_content_error("OUT_OF_MEMORY(0x%08x)", MEDIA_CONTENT_ERROR_OUT_OF_MEMORY);
422 return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
425 _tag->name = strdup(tag_name);
426 if (_tag->name == NULL) {
427 SAFE_FREE(_item->tag_name);
429 media_content_error("OUT_OF_MEMORY(0x%08x)", MEDIA_CONTENT_ERROR_OUT_OF_MEMORY);
430 return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
433 __media_tag_item_add(_tag, _item);
435 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
436 ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
442 int media_tag_update_to_db(media_tag_h tag)
444 int ret = MEDIA_CONTENT_ERROR_NONE;
445 media_tag_s *_tag = (media_tag_s*)tag;
448 media_tag_item_s *_tag_item = NULL;
451 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
452 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
455 if (_tag->item_list != NULL) {
456 length = g_list_length(_tag->item_list);
458 media_content_debug("operation list length is 0");
459 return MEDIA_CONTENT_ERROR_NONE;
462 for (idx = 0; idx < length; idx++) {
463 _tag_item = (media_tag_item_s*)g_list_nth_data(_tag->item_list, idx);
464 if (_tag_item != NULL) {
465 switch (_tag_item->function) {
468 ret = __media_tag_insert_item_to_tag(_tag->tag_id, _tag_item->media_id);
472 case MEDIA_TAG_REMOVE:
474 ret = __media_tag_remove_item_from_tag(_tag->tag_id, _tag_item->media_id);
478 case MEDIA_TAG_UPDATE_TAG_NAME:
480 ret = __media_tag_update_tag_name(_tag->tag_id, _tag_item->tag_name);
490 __media_tag_item_release(_tag);