X-Git-Url: http://review.tizen.org/git/?a=blobdiff_plain;f=src%2Fmedia_content.c;h=8b2b3afa10a04b810e5851b55a17493887d70d3b;hb=e84e224cbb3cda3a91cea699a6d096401db850b8;hp=49a5933a449cd344cde314f0d907314c0f3742ba;hpb=392810363ac613a41b96c73c9d87effefe3fabb3;p=platform%2Fcore%2Fapi%2Fmedia-content.git diff --git a/src/media_content.c b/src/media_content.c index 49a5933..8b2b3af 100644 --- a/src/media_content.c +++ b/src/media_content.c @@ -83,62 +83,6 @@ int _content_get_result(char *query, sqlite3_stmt **stmt) return MEDIA_CONTENT_ERROR_NONE; } -#ifdef _USE_SENIOR_MODE -int _content_query_prepare_by_union_select(sqlite3_stmt **stmt, char *select_query1, char *condition_query1, char *option_query1, char *select_query2, char *condition_query2, char *option_query2) -{ - int len = 0; - int err = MEDIA_CONTENT_ERROR_NONE; - char query[MAX_QUERY_SIZE] = {0, }; - - content_retip_if_fail(_content_get_db_handle()); - content_retip_if_fail(select_query1); - content_retip_if_fail(select_query2); - - if (!STRING_VALID(condition_query1)) - condition_query1 = (char *)" "; - - if (!STRING_VALID(option_query1)) - option_query1 = (char *)" "; - - if (!STRING_VALID(condition_query2)) - condition_query2 = (char *)" "; - - if (!STRING_VALID(option_query2)) - option_query2 = (char *)" "; - - len = snprintf(query, sizeof(query), "SELECT * FROM (%s %s %s) as table1 UNION ALL SELECT * FROM (%s %s %s) as table2", - select_query1, condition_query1, option_query1, select_query2, condition_query2, option_query2); - if (len > 0 && len < sizeof(query)) { - query[len] = '\0'; - } else if (len >= sizeof(query)) { - query[MAX_QUERY_SIZE -1] = '\0'; - } else { - content_error("snprintf failed"); - return MEDIA_CONTENT_ERROR_INVALID_PARAMETER; - } - - content_sec_debug("Query : [%s]", query); - - err = sqlite3_prepare_v2(_content_get_db_handle(), query, strlen(query), stmt, NULL); - if (err != SQLITE_OK) { - content_error("DB_FAILED(0x%08x) fail to sqlite3_prepare(), %s", MEDIA_CONTENT_ERROR_DB_FAILED, sqlite3_errmsg(_content_get_db_handle())); - - if (err == SQLITE_BUSY) { - content_error(" BUSY ERROR"); - return MEDIA_CONTENT_ERROR_DB_BUSY; - } else if (err == SQLITE_PERM) { - content_error("PERMISSION EROR"); - return MEDIA_CONTENT_ERROR_PERMISSION_DENIED; - } else { - content_error("OTHER ERROR"); - return MEDIA_CONTENT_ERROR_DB_FAILED; - } - } - - return MEDIA_CONTENT_ERROR_NONE; -} -#endif - int _content_error_capi(int internal_error) { if (internal_error == MS_MEDIA_ERR_NONE)