2 // Open Service Platform
\r
3 // Copyright (c) 2012 Samsung Electronics Co., Ltd.
\r
5 // Licensed under the Apache License, Version 2.0 (the License);
\r
6 // you may not use this file except in compliance with the License.
\r
7 // You may obtain a copy of the License at
\r
9 // http://www.apache.org/licenses/LICENSE-2.0
\r
11 // Unless required by applicable law or agreed to in writing, software
\r
12 // distributed under the License is distributed on an "AS IS" BASIS,
\r
13 // WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
\r
14 // See the License for the specific language governing permissions and
\r
15 // limitations under the License.
\r
18 * @file FCnt_ContentSearchImpl.cpp
\r
19 * @brief This is the implementation file for the %_ContentSearchImpl class.
\r
21 * This file contains implementation of the %_ContentSearchImpl class.
\r
25 #include <FBaseSysLog.h>
\r
26 #include <FBaseInteger.h>
\r
27 #include <FBaseLongLong.h>
\r
28 #include <FBaseFloat.h>
\r
29 #include <FBaseColIList.h>
\r
30 #include <FBaseUtilStringTokenizer.h>
\r
31 #include <FCntContentSearch.h>
\r
32 #include <FCntContentSearchResult.h>
\r
33 #include <FBase_StringConverter.h>
\r
34 #include <FCnt_ContentUtility.h>
\r
35 #include <FCnt_ContentSearchImpl.h>
\r
37 using namespace Tizen::Base;
\r
38 using namespace Tizen::Base::Collection;
\r
39 using namespace Tizen::Base::Utility;
\r
40 using namespace Tizen::Io;
\r
42 namespace Tizen { namespace Content
\r
45 static const int QUERY_LENGTH = 4096;
\r
47 // Declaration for Callback function registered to each media info details
\r
48 bool MediaItemCb(media_info_h media, void* pUserdata);
\r
49 // Declaration for Callback function registered to each column details
\r
50 bool GroupItemCb(const char* pGroupName, void* pUserdata);
\r
51 // Declaration for Callback function registered to each album details
\r
52 bool AlbumItemCb(media_album_h album, void* pUserdata);
\r
54 // Default constructor
\r
55 _ContentSearchImpl::_ContentSearchImpl(void)
\r
57 , __contentType(CONTENT_TYPE_UNKNOWN)
\r
58 , __pFinalOutList(NULL)
\r
60 , __inputColumnName(L"")
\r
61 , __inputSortOrder(SORT_ORDER_NONE)
\r
62 , __pFilterHandle(0)
\r
64 SysLog(NID_CNT, "Enter\n");
\r
68 // Default destructor (disconnects the DB connection)
\r
69 _ContentSearchImpl::~_ContentSearchImpl(void)
\r
71 SysLog(NID_CNT, "Enter\n");
\r
73 int ret = MEDIA_CONTENT_ERROR_NONE;
\r
74 result r = E_SUCCESS;
\r
76 ret = media_content_disconnect();
\r
77 r = MapCoreErrorToNativeResult(ret);
\r
78 SysTryLog(NID_CNT, r == E_SUCCESS, "[%s] Propagated in ~_ContentSearchImpl", GetErrorMessage(r));
\r
82 _ContentSearchImpl::GetInstance(ContentSearch& contentSearch)
\r
84 return contentSearch.__pImpl;
\r
87 const _ContentSearchImpl*
\r
88 _ContentSearchImpl::GetInstance(const ContentSearch& contentSearch)
\r
90 return contentSearch.__pImpl;
\r
93 //make a connection to DB
\r
95 _ContentSearchImpl::Construct(ContentType type)
\r
97 SysLog(NID_CNT, "Enter\n");
\r
99 result r = E_SUCCESS;
\r
100 int ret = MEDIA_CONTENT_ERROR_NONE;
\r
102 ret = media_content_connect();
\r
103 SysTryReturnResult(NID_CNT, r == E_SUCCESS , E_SYSTEM, "Failed to perform media_content_connect operation.");
\r
105 __contentType = type;
\r
110 // Creates a filter for the input query string along with content type
\r
111 // Initializes filter handle
\r
112 // Image - MEDIA_TYPE=0
\r
113 // Vide0 - MEDIA_TYPE=1
\r
114 // Audio - MEDIA_TYPE=2 or MEDIA_TYPE=3
\r
115 // Others - MEDIA_TYPE=4
\r
117 // Appends MEDIA_TYPE with "AND" (if the input expression is not empty and content type is not ALL) and input expression
\r
118 // Sets the condition and order.
\r
119 // If any argument is not proper E_INVALID_ARG is returned
\r
121 _ContentSearchImpl::CreateQueryFilter(bool isAndAppendReq) const
\r
123 int ret = MEDIA_CONTENT_ERROR_NONE;
\r
124 result r = E_SUCCESS;
\r
126 std::unique_ptr<char[]> pInputCond;
\r
127 std::unique_ptr<char[]> pSortCol;
\r
129 String inputCondition;
\r
132 std::unique_ptr<filter_h, SearchFilterHandleDeleter> pFilterHandle(new (std::nothrow) filter_h);
\r
134 ret = media_filter_create(pFilterHandle.get());
\r
135 SysTryReturnResult(NID_CNT, ret == MEDIA_CONTENT_ERROR_NONE, E_SYSTEM, "Failed to perform media_filter_create operation.");
\r
137 switch (__contentType)
\r
139 // Image-0,video-1,sound-2,music-3,other-4
\r
140 case CONTENT_TYPE_OTHER:
\r
141 inputCondition = "MEDIA_TYPE=4 ";
\r
143 case CONTENT_TYPE_IMAGE:
\r
144 inputCondition = "MEDIA_TYPE=0 ";
\r
146 case CONTENT_TYPE_AUDIO:
\r
147 inputCondition = "(MEDIA_TYPE=2 or MEDIA_TYPE=3) ";
\r
149 case CONTENT_TYPE_VIDEO:
\r
150 inputCondition = "MEDIA_TYPE=1 ";
\r
152 case CONTENT_TYPE_ALL:
\r
153 //If content type is CONTENT_TYPE_ALL, then MEDIA_TYPE is empty
\r
159 if (!__inputExpr.IsEmpty())
\r
161 if (isAndAppendReq && (!inputCondition.IsEmpty())) //For CONTENT_TYPE_ALL inputCondition is empty
\r
163 r = inputCondition.Append("AND ");
\r
164 SysTryReturnResult(NID_CNT, !IsFailed(r), r, "Failed to perform append operation.");
\r
167 r = inputCondition.Append(__inputExpr);
\r
168 SysTryReturnResult(NID_CNT, !IsFailed(r), r, "Failed to perform append operation.");
\r
171 if (!inputCondition.IsEmpty())
\r
173 //CopyToCharArrayN: utility function, converts a osp string to char*
\r
174 pInputCond = std::unique_ptr<char[]>(_StringConverter::CopyToCharArrayN(inputCondition));
\r
175 SysTryReturnResult(NID_CNT, (pInputCond.get())[0], E_OUT_OF_MEMORY, "pInputCond is NULL.");
\r
177 SysLog(NID_CNT, "pInputCond = %s", pInputCond.get());
\r
179 if ((pInputCond.get())[0])
\r
181 ret = media_filter_set_condition(*(pFilterHandle.get()), pInputCond.get(), MEDIA_CONTENT_COLLATE_DEFAULT);
\r
182 SysTryReturnResult(NID_CNT, ret == MEDIA_CONTENT_ERROR_NONE, E_SYSTEM, "Failed to perform media_filter_set_condition operation.");
\r
186 if (!__inputColumnName.IsEmpty()) // SortColumn is optional in case of SearchN
\r
188 //__inputColumnName (osp column name) is replaced with slpColumn (slp column name).
\r
189 r = GetSlpColumnName(slpColumn);
\r
190 SysTryReturnResult(NID_CNT, !IsFailed(r), r, "Failed to perform GetSlpColumnName operation.");
\r
192 //CopyToCharArrayN: utility function, converts a osp string to char*
\r
194 pSortCol = std::unique_ptr<char[]>(_StringConverter::CopyToCharArrayN(slpColumn));
\r
195 SysTryReturnResult(NID_CNT, (pSortCol.get())[0], E_OUT_OF_MEMORY, "pSortCol is NULL.");
\r
197 if (__inputSortOrder == SORT_ORDER_ASCENDING)
\r
199 ret = media_filter_set_order(*(pFilterHandle.get()), MEDIA_CONTENT_ORDER_ASC, pSortCol.get(), MEDIA_CONTENT_COLLATE_DEFAULT);
\r
200 SysTryReturnResult(NID_CNT, ret == MEDIA_CONTENT_ERROR_NONE, E_SYSTEM, "Failed to perform media_filter_set_order operation.");
\r
202 else if (__inputSortOrder == SORT_ORDER_DESCENDING)
\r
204 ret = media_filter_set_order(*(pFilterHandle.get()), MEDIA_CONTENT_ORDER_DESC, pSortCol.get(), MEDIA_CONTENT_COLLATE_DEFAULT);
\r
205 SysTryReturnResult(NID_CNT, ret == MEDIA_CONTENT_ERROR_NONE, E_SYSTEM, "Failed to perform media_filter_set_order operation.");
\r
209 __pFilterHandle.reset(pFilterHandle.release());
\r
214 // Osp column names are mapped with slp column names
\r
215 // CONTENT_TYPE_OTHER and CONTENT_TYPE_IMAGE (0 - 13 ) are valid columns
\r
216 // CONTENT_TYPE_VIDEO (0 - 16 ) are valid columns
\r
217 // CONTENT_TYPE_ALL and CONTENT_TYPE_VIDEO (0 - 18 ) are valid columns
\r
218 // if the given osp column is out of the specified range of the type, E_INVALID_ARG is retuned.
\r
220 _ContentSearchImpl::GetSlpColumnName(String& inputCol) const
\r
222 String ospColumnName(L"");
\r
223 String slpColumnName(L"");
\r
224 String columnName(__inputColumnName);
\r
225 result r = E_SUCCESS;
\r
227 switch (__contentType)
\r
229 case CONTENT_TYPE_OTHER:
\r
231 case CONTENT_TYPE_IMAGE:
\r
232 maxCols = MAX_QUERY_COLUMNS_FOR_IMAGE_OTHERS;
\r
234 case CONTENT_TYPE_VIDEO:
\r
235 maxCols = MAX_QUERY_COLUMNS_FOR_VIDEO;
\r
237 case CONTENT_TYPE_AUDIO:
\r
239 case CONTENT_TYPE_ALL:
\r
240 maxCols = MAX_QUERY_COLUMNS;
\r
245 for (int colIndex = 0; colIndex < maxCols; colIndex++)
\r
247 ospColumnName.Clear();
\r
248 slpColumnName.Clear();
\r
250 ospColumnName = dbfieldinfo[colIndex].dbFieldOspName ;
\r
251 slpColumnName = dbfieldinfo[colIndex].dbFieldSlpName ;
\r
253 ospColumnName.ToUpper();
\r
254 columnName.ToUpper();
\r
255 if (columnName == ospColumnName)
\r
257 inputCol = slpColumnName;
\r
261 return E_INVALID_ARG;
\r
264 //If the input expression contains any osp column name, it will be replaced with slp column name.
\r
265 // only CONTENT_TYPE_AUDIO and CONTENT_TYPE_ALL allowed to use all given columns
\r
266 // so, check for invalid column for CONTENT_TYPE_OTHER,CONTENT_TYPE_IMAGE and CONTENT_TYPE_VIDEO.
\r
267 // all the osp columns in the expression should be replaced with slp column names.
\r
268 // ' is used as a delimeter in parsing user query. so, \\' is saved as a special@apostrophe string.
\r
269 // \\' is replaced with '', which considers ' as normal character.
\r
272 _ContentSearchImpl::ReplaceOspColumnNameWithSlp(void) const
\r
274 String ospColumnName(L"");
\r
275 String slpColumnName(L"");
\r
276 String splApostrophe(L"special@apostrophe");
\r
277 result r = E_SUCCESS;
\r
282 String strToBeReplaced(L"\\'");
\r
283 int strLen = strToBeReplaced.GetLength();
\r
284 int startIndex = 0;
\r
286 while(E_SUCCESS == __inputExpr.IndexOf(strToBeReplaced,startIndex,indexOf))
\r
288 int lenAfterSubStr = indexOf + strLen;
\r
289 while ((lenAfterSubStr < __inputExpr.GetLength()) && (__inputExpr[lenAfterSubStr] == ' '))
\r
293 if ((lenAfterSubStr < __inputExpr.GetLength()) && ((__inputExpr[lenAfterSubStr] == '\'') ||
\r
294 ((!__inputExpr.StartsWith(L"AND ", lenAfterSubStr)) && (!__inputExpr.StartsWith(L"OR ", lenAfterSubStr)))))
\r
296 r = __inputExpr.Remove(indexOf,strLen);
\r
297 SysTryReturnResult(NID_CNT, r == E_SUCCESS, E_SYSTEM, "Failed to perform Remove operation.");
\r
298 r = __inputExpr.Insert(splApostrophe,indexOf);
\r
299 SysTryReturnResult(NID_CNT, r == E_SUCCESS, E_SYSTEM, "Failed to perform Insert operation.");
\r
300 startIndex = indexOf + splApostrophe.GetLength();
\r
304 startIndex = lenAfterSubStr;
\r
308 SysLog(NID_CNT, "__inputExpr after splApostrophe append = %ls", __inputExpr.GetPointer());
\r
310 switch (__contentType)
\r
312 case CONTENT_TYPE_OTHER:
\r
314 case CONTENT_TYPE_IMAGE:
\r
315 r = CheckInvalidColumnInQuery();
\r
316 SysTryReturnResult(NID_CNT, r == E_SUCCESS, E_INVALID_ARG, "Invalid Column In QueryString.");
\r
317 maxCols = MAX_QUERY_COLUMNS_FOR_IMAGE_OTHERS;
\r
319 case CONTENT_TYPE_VIDEO:
\r
320 r = CheckInvalidColumnInQuery();
\r
321 SysTryReturnResult(NID_CNT, r == E_SUCCESS, E_INVALID_ARG, "Invalid Column In QueryString.");
\r
322 maxCols = MAX_QUERY_COLUMNS_FOR_VIDEO;
\r
324 case CONTENT_TYPE_AUDIO:
\r
326 case CONTENT_TYPE_ALL:
\r
327 maxCols = MAX_QUERY_COLUMNS;
\r
332 for (int colIndex = 0; colIndex < maxCols; colIndex++)
\r
334 ospColumnName.Clear();
\r
335 slpColumnName.Clear();
\r
337 ospColumnName = dbfieldinfo[colIndex].dbFieldOspName ;
\r
338 slpColumnName = dbfieldinfo[colIndex].dbFieldSlpName ;
\r
340 ReplaceString(ospColumnName,slpColumnName);
\r
343 // Append ESCAPE '\' for LIKE query
\r
344 r = AppendEscapeKeywordForLikeQuery();
\r
345 SysTryReturnResult(NID_CNT, r == E_SUCCESS, E_SYSTEM, "AppendEscapeKeywordForLikeQuery failed.");
\r
347 r = ReplaceDateTimeStringWithInt();
\r
348 SysTryReturnResult(NID_CNT, r == E_SUCCESS, E_SYSTEM, "ReplaceDateTimeStringWithInt failed.");
\r
350 // replace splApostrophe string with actual
\r
351 r = __inputExpr.Replace(splApostrophe, "''");
\r
352 SysTryReturnResult(NID_CNT, r == E_SUCCESS, E_SYSTEM, "string Replace failed.");
\r
357 //This function is to appened ESCAPE keyword for _ and % special characters in LIKE query.
\r
360 _ContentSearchImpl::AppendEscapeKeywordForLikeQuery(void) const
\r
362 String delim = L"'"; //Delimeters is ' .
\r
363 result r = E_SUCCESS;
\r
365 bool isAppendEscape = false;
\r
368 String inputExpr = __inputExpr;
\r
370 // Create a StringTokenizer instance
\r
371 StringTokenizer strTok(inputExpr, delim);
\r
375 while (strTok.HasMoreTokens())
\r
377 r = strTok.GetNextToken(token);
\r
378 SysTryReturnResult(NID_CNT, r == E_SUCCESS, E_SYSTEM, "GetNextToken failed.");
\r
379 if (isCol) //column name
\r
382 tokenUpper = token;
\r
383 tokenUpper.ToUpper();
\r
384 if (tokenUpper.Contains(" LIKE"))
\r
386 isAppendEscape = true;
\r
390 isAppendEscape = false;
\r
392 r = inputExpr.Append(token);
\r
393 SysTryReturnResult(NID_CNT, r == E_SUCCESS, E_SYSTEM, "string append failed.");
\r
395 else // value of the column
\r
398 r = inputExpr.Append("'");
\r
399 SysTryReturnResult(NID_CNT, r == E_SUCCESS, E_SYSTEM, "string append failed.");
\r
400 r = inputExpr.Append(token);
\r
401 SysTryReturnResult(NID_CNT, r == E_SUCCESS, E_SYSTEM, "string append failed.");
\r
402 r = inputExpr.Append("'");
\r
403 SysTryReturnResult(NID_CNT, r == E_SUCCESS, E_SYSTEM, "string append failed.");
\r
405 if (isAppendEscape)
\r
407 if (token.Contains("\\_") || token.Contains("\\%"))
\r
409 r = inputExpr.Append("ESCAPE'\\' ");
\r
410 SysTryReturnResult(NID_CNT, r == E_SUCCESS, E_SYSTEM, "string append failed.");
\r
416 __inputExpr.Clear();
\r
417 r = __inputExpr.Insert(inputExpr, 0);
\r
418 SysTryReturnResult(NID_CNT, r == E_SUCCESS, E_SYSTEM, "string insert failed.");
\r
423 //This function is to replace DateTime value(osp datetime type is string) which is string with int.(SLP dateTime column type is int)
\r
426 _ContentSearchImpl::ReplaceDateTimeStringWithInt(void) const
\r
428 String delim = L"'"; //Delimeters is ' .
\r
429 result r = E_SUCCESS;
\r
431 bool isConvertReq = false;
\r
432 bool isBetweenExistsInDateTimeQuery = false;
\r
435 String inputExpr = __inputExpr;
\r
437 if(!inputExpr.Contains("MEDIA_ADDED_TIME"))
\r
442 // Create a StringTokenizer instance
\r
443 StringTokenizer strTok(inputExpr, delim);
\r
447 while (strTok.HasMoreTokens())
\r
449 r = strTok.GetNextToken(token);
\r
450 SysTryReturnResult(NID_CNT, r == E_SUCCESS, E_SYSTEM, "GetNextToken failed.");
\r
451 if (isCol) //column name
\r
454 tokenUpper = token;
\r
455 tokenUpper.ToUpper();
\r
456 if(isBetweenExistsInDateTimeQuery)
\r
458 isBetweenExistsInDateTimeQuery = false;
\r
459 isConvertReq = true;
\r
463 if (tokenUpper.Contains("MEDIA_ADDED_TIME"))
\r
465 if (tokenUpper.Contains("BETWEEN"))
\r
467 isBetweenExistsInDateTimeQuery = true;
\r
469 isConvertReq = true;
\r
473 isConvertReq = false;
\r
476 r = inputExpr.Append(token);
\r
477 SysTryReturnResult(NID_CNT, r == E_SUCCESS, E_SYSTEM, "string append failed.");
\r
479 else // value of the column
\r
482 r = inputExpr.Append("'");
\r
483 SysTryReturnResult(NID_CNT, r == E_SUCCESS, E_SYSTEM, "string append failed.");
\r
487 Tizen::Base::DateTime dt;
\r
488 Tizen::Base::DateTime::Parse(token, dt);
\r
490 int year = dt.GetYear();
\r
491 int month = dt.GetMonth();
\r
492 int day = dt.GetDay();
\r
493 int hour = dt.GetHour();
\r
494 int minute = dt.GetMinute();
\r
495 int second = dt.GetSecond();
\r
498 struct tm* timeInfo;
\r
501 timeInfo = localtime(&rawTime);
\r
502 timeInfo->tm_year = year - 1900;
\r
503 timeInfo->tm_mon = month - 1;
\r
504 timeInfo->tm_mday = day;
\r
505 timeInfo->tm_hour = hour;
\r
506 timeInfo->tm_min = minute;
\r
507 timeInfo->tm_sec = second;
\r
509 time_t seconds = mktime(timeInfo);
\r
510 long long ticksInSeconds = (long long)seconds;
\r
512 r = inputExpr.Append(ticksInSeconds);
\r
513 SysTryReturnResult(NID_CNT, r == E_SUCCESS, E_SYSTEM, "string append failed.");
\r
517 r = inputExpr.Append(token);
\r
518 SysTryReturnResult(NID_CNT, r == E_SUCCESS, E_SYSTEM, "string append failed.");
\r
520 r = inputExpr.Append("'");
\r
521 SysTryReturnResult(NID_CNT, r == E_SUCCESS, E_SYSTEM, "string append failed.");
\r
525 __inputExpr.Clear();
\r
526 r = __inputExpr.Insert(inputExpr, 0);
\r
527 SysTryReturnResult(NID_CNT, r == E_SUCCESS, E_SYSTEM, "string insert failed.");
\r
532 // CONTENT_TYPE_OTHER and CONTENT_TYPE_IMAGE (0 - 13 ) are valid columns
\r
533 // CONTENT_TYPE_VIDEO (0 - 16 ) are valid columns
\r
534 // CONTENT_TYPE_ALL and CONTENT_TYPE_VIDEO (0 - 18 ) are valid columns
\r
535 // This functions checks for invalid column in the given input string (only allowed columns should be used by content type other wise
\r
536 // E_INVALID_ARG is returned)
\r
537 // StringTokenizer is used to parse input expression, by using delimater "'", to differentiate column and value.
\r
538 // As values may also contain column names
\r
539 // Ex: 1. where author = syam_author_01 2. where album = jalsa_album_name_01.
\r
542 _ContentSearchImpl::CheckInvalidColumnInQuery(void) const
\r
544 result r = E_SUCCESS;
\r
546 String delim = L"'"; //Delimeters is ' .
\r
547 bool isColReplaceReq = true;
\r
549 String inputExpr = __inputExpr;
\r
551 // Create a StringTokenizer instance
\r
552 StringTokenizer strTok(inputExpr, delim);
\r
556 while (strTok.HasMoreTokens())
\r
558 r = strTok.GetNextToken(token);
\r
559 SysTryReturnResult(NID_CNT, r == E_SUCCESS, E_SYSTEM, "strTok GetNextToken failed.");
\r
561 SysLog(NID_CNT, "In CheckInvalidColumnInQuery token[%d] = %ls", ++tokenNo, token.GetPointer());
\r
563 if (isColReplaceReq)
\r
565 isColReplaceReq = false;
\r
566 r = inputExpr.Append(token);
\r
567 SysTryReturnResult(NID_CNT, r == E_SUCCESS, E_SYSTEM, "string append failed.");
\r
569 switch (__contentType)
\r
571 case CONTENT_TYPE_OTHER:
\r
573 case CONTENT_TYPE_IMAGE:
\r
574 if ((token.Contains("TITLE")) || (token.Contains("ARTIST")) || (token.Contains("GENRE")))
\r
576 SysLog(NID_CNT, "Title or Artist or Genre are not valid cloumns for this content type");
\r
577 return E_INVALID_ARG;
\r
580 case CONTENT_TYPE_VIDEO:
\r
581 if ((token.Contains("COMPOSER")) || (token.Contains("ALBUM")))
\r
583 SysLog(NID_CNT, "Composer or Album are not valid cloumns for this content type");
\r
584 return E_INVALID_ARG;
\r
593 isColReplaceReq = true;
\r
594 r = inputExpr.Append("'");
\r
595 SysTryReturnResult(NID_CNT, r == E_SUCCESS, E_SYSTEM, "string append failed.");
\r
596 r = inputExpr.Append(token);
\r
597 SysTryReturnResult(NID_CNT, r == E_SUCCESS, E_SYSTEM, "string append failed.");
\r
598 r = inputExpr.Append("'");
\r
599 SysTryReturnResult(NID_CNT, r == E_SUCCESS, E_SYSTEM, "string append failed.");
\r
605 // It replaces osp column name with slp column name.
\r
606 // StringTokenizer is used to parse input expression, by using delimater "'", to differentiate column and value.
\r
607 // As values may also contain column names
\r
608 // Only column names are replaced but not values(values may contain column names)
\r
609 // Ex: 1. where author = syam_author_01 2. where album = jalsa_album_name_01.
\r
612 _ContentSearchImpl::ReplaceString(String ospColumnName, String slpColumnName) const
\r
614 String delim = L"'"; //Delimeters is ' .
\r
615 result r = E_SUCCESS;
\r
616 bool isColReplaceReq = true;
\r
618 String inputExpr = __inputExpr;
\r
620 // Create a StringTokenizer instance
\r
621 StringTokenizer strTok(inputExpr, delim);
\r
625 while (strTok.HasMoreTokens())
\r
627 r = strTok.GetNextToken(token); // Osp, StringTokenizer, Sample, code
\r
628 SysTryReturnResult(NID_CNT, r == E_SUCCESS, E_SYSTEM, "string GetNextToken() failed.");
\r
629 if (isColReplaceReq) //column name
\r
631 isColReplaceReq = false;
\r
632 r = token.Replace(ospColumnName, slpColumnName);
\r
633 SysTryReturnResult(NID_CNT, r == E_SUCCESS, E_SYSTEM, "string replace() failed.");
\r
634 r = inputExpr.Append(token);
\r
635 SysTryReturnResult(NID_CNT, r == E_SUCCESS, E_SYSTEM, "string append failed.");
\r
637 else // value of the column
\r
639 isColReplaceReq = true;
\r
640 r = inputExpr.Append("'");
\r
641 SysTryReturnResult(NID_CNT, r == E_SUCCESS, E_SYSTEM, "string append failed.");
\r
642 r = inputExpr.Append(token);
\r
643 SysTryReturnResult(NID_CNT, r == E_SUCCESS, E_SYSTEM, "string append failed.");
\r
644 r = inputExpr.Append("'");
\r
645 SysTryReturnResult(NID_CNT, r == E_SUCCESS, E_SYSTEM, "string append failed.");
\r
648 __inputExpr.Clear();
\r
649 r = __inputExpr.Insert(inputExpr, 0);
\r
650 SysTryReturnResult(NID_CNT, r == E_SUCCESS, E_SYSTEM, "string insert() failed.");
\r
655 //Retuns list of search result for the given expression and content type.
\r
657 _ContentSearchImpl::SearchN(int pageNo, int countPerPage, int& totalPageCount, int& totalCount, const String& whereExpr, const String& sortColumn, SortOrder sortOrder) const
\r
659 SysLog(NID_CNT, "pageNo = %d, countPerPage = %d, whereExpr = %ls", pageNo, countPerPage, whereExpr.GetPointer());
\r
663 result r = E_SUCCESS;
\r
664 int ret = MEDIA_CONTENT_ERROR_NONE;
\r
667 __inputColumnName.Clear();
\r
668 __inputExpr.Clear();
\r
669 __inputColumnName = sortColumn;
\r
670 __inputSortOrder = sortOrder;
\r
671 totalPageCount = 0;
\r
674 if (!whereExpr.IsEmpty()) // copy whereExpr if not empty to class variable __inputExpr
\r
676 //r = __inputExpr.Format(QUERY_LENGTH, L"%ls", whereExpr.GetPointer());
\r
677 r = __inputExpr.Append(whereExpr);
\r
678 SysTryReturn(NID_CNT, r == E_SUCCESS, NULL, r, "[%s] __inputExpr.Append Failed as whereExpr is not empty.", GetErrorMessage(r));
\r
680 r = ReplaceOspColumnNameWithSlp();
\r
681 SysTryReturn(NID_CNT, r == E_SUCCESS, NULL, r, "[%s] ReplaceOspColumnNameWithSlp for InputExpr Failed.", GetErrorMessage(r));
\r
683 SysLog(NID_CNT, "After replace __inputExpr = %ls", __inputExpr.GetPointer());
\r
685 if ((__inputColumnName.IsEmpty()) && ((__inputSortOrder == SORT_ORDER_ASCENDING) || (__inputSortOrder == SORT_ORDER_DESCENDING)))
\r
687 SysLog(NID_CNT, "sort column name is empty and sort oder is not none. so,E_INVALID_ARG occured.");
\r
688 SetLastResult(E_INVALID_ARG);
\r
693 std::unique_ptr<ArrayList, AllElementsDeleter> pFinalOutList(new (std::nothrow) ArrayList());
\r
694 SysTryReturn(NID_CNT, pFinalOutList.get() != null, NULL, E_OUT_OF_MEMORY, "[E_OUT_OF_MEMORY] Failed to construct ArrayList.");
\r
696 r = pFinalOutList->Construct();
\r
697 SysTryReturn(NID_CNT, !IsFailed(r), NULL, r, "[%s] Failed to construct ArrayList.", GetErrorMessage(r));
\r
699 __pFinalOutList = std::move(pFinalOutList);
\r
701 r = CreateQueryFilter(true);
\r
702 SysTryReturn(NID_CNT, !IsFailed(r), NULL, r, "[%s] Failed to perform CreateQueryFilter operation.", GetErrorMessage(r));
\r
704 ret = media_info_get_media_count_from_db(*(__pFilterHandle.get()), &totalCount);
\r
705 r = MapCoreErrorToNativeResult(ret);
\r
706 SysTryReturn(NID_CNT, r == E_SUCCESS , NULL, r, "[%s] Failed to perform media_info_get_media_count_from_db operation.", GetErrorMessage(r));
\r
708 SysLog(NID_CNT, "totalCount is [%d] for media_info_get_media_count_from_db", totalCount);
\r
710 if (totalCount > 0)
\r
712 if ((totalCount % countPerPage) == 0)
\r
714 totalPageCount = totalCount / countPerPage;
\r
718 totalPageCount = (totalCount / countPerPage) + 1;
\r
721 SysTryReturn(NID_CNT, ((pageNo >= 1) && (pageNo <= totalPageCount)) , NULL, E_INVALID_ARG, "[E_INVALID_ARG] (pageNo < 1) || (pageNo > totalPageCount).");
\r
723 offset = (pageNo * countPerPage) - countPerPage;
\r
725 SysLog(NID_CNT, " SearchN totalCount [%d] totalPageCount[%d] __countPerPage[%d] __pageNo[%d] offset[%d]",
\r
726 totalCount, totalPageCount, countPerPage, pageNo, offset);
\r
728 ret = media_filter_set_offset(*(__pFilterHandle.get()), offset, countPerPage);
\r
729 r = MapCoreErrorToNativeResult(ret);
\r
730 SysTryReturn(NID_CNT, r == E_SUCCESS, NULL, r,
\r
731 "[%s] Failed to perform media_filter_set_offset operation.", GetErrorMessage(r));
\r
733 r = ExecuteAndFillFinalOutList();
\r
734 SysTryReturn(NID_CNT, r == E_SUCCESS, NULL, E_SYSTEM, "[E_SYSTEM] ExecuteAndFillFinalOutList Failed.");
\r
736 else if (pageNo > 1)
\r
739 SysTryReturn(NID_CNT, r == E_SUCCESS, NULL, r, "[E_INVALID_ARG] (pageNo > 1) and (totalcount = 0).");
\r
743 return __pFinalOutList.release();
\r
746 // Fills final result list
\r
748 _ContentSearchImpl::ExecuteAndFillFinalOutList(void) const
\r
750 SysLog(NID_CNT, "Enter\n");
\r
752 int ret = MEDIA_CONTENT_ERROR_NONE;
\r
753 result r = E_SUCCESS;
\r
755 std::unique_ptr<GList, SearchGListDeleter> pItemList;
\r
756 GList* pTemp = NULL;
\r
757 std::unique_ptr<media_info_s, SearchMediaHandleDeleter> pMediaHandle;
\r
759 ContentInfo::_ContentData* pContentData = null;
\r
760 ImageContentInfo::_ImageContentData* pImageContentData = null;
\r
761 AudioContentInfo::_AudioContentData* pAudioContentData = null;
\r
762 VideoContentInfo::_VideoContentData* pVideoContentData = null;
\r
764 std::unique_ptr<ImageContentInfo> pImageContentInfo;
\r
765 std::unique_ptr<AudioContentInfo> pAudioContentInfo;
\r
766 std::unique_ptr<VideoContentInfo> pVideoContentInfo;
\r
767 std::unique_ptr<OtherContentInfo> pOtherContentInfo;
\r
769 std::unique_ptr<ContentSearchResult> pContentSearchResult;
\r
771 pTemp = pItemList.get();
\r
773 ret = media_info_foreach_media_from_db(*(__pFilterHandle.get()), MediaItemCb, &pTemp);
\r
774 r = MapCoreErrorToNativeResult(ret);
\r
775 SysTryReturnResult(NID_CNT, r == E_SUCCESS, r, "Failed to perform media_info_foreach_media_from_db operation.");
\r
777 SysTryReturnResult(NID_CNT, pTemp != NULL, r, "media_info_foreach_media_from_db pTemp is null.");
\r
779 media_content_type_e mediaType = MEDIA_CONTENT_TYPE_OTHERS;
\r
781 for (int idx = 0; idx < (int)g_list_length(pTemp); idx++)
\r
783 pMediaHandle.reset(static_cast<media_info_h>(g_list_nth_data(pTemp, idx)));
\r
785 ret = media_info_get_media_type(pMediaHandle.get(), &mediaType);
\r
786 r = MapCoreErrorToNativeResult(ret);
\r
787 SysTryReturnResult(NID_CNT, !IsFailed(r), r, "Failed to perform media_info_get_media_type.");
\r
791 case MEDIA_CONTENT_TYPE_OTHERS:
\r
792 //memset(&contentData, 0, sizeof(contentData));
\r
794 pOtherContentInfo = std::unique_ptr<OtherContentInfo>(new (std::nothrow) OtherContentInfo);
\r
795 SysTryReturnResult(NID_CNT, pOtherContentInfo.get() != null, E_OUT_OF_MEMORY, "Failed to create pOtherContentInfo.");
\r
797 pContentData = pOtherContentInfo->GetContentData();
\r
798 SysTryReturnResult(NID_CNT, pContentData != null, E_OUT_OF_MEMORY, "The memory is insufficient.");
\r
800 r = _ContentUtility::FillContentData(pMediaHandle.get(), pContentData);
\r
801 SysTryReturnResult(NID_CNT, !IsFailed(r), r, "Failed to perform FillContentData operation.");
\r
804 pContentSearchResult = std::unique_ptr<ContentSearchResult>(new (std::nothrow) ContentSearchResult);
\r
805 SysTryReturnResult(NID_CNT, pContentSearchResult.get() != null, E_OUT_OF_MEMORY, "Failed to create pContentSearchResult.");
\r
807 pContentSearchResult->SetContentType(CONTENT_TYPE_OTHER);
\r
808 pContentSearchResult->SetContentInfo(pOtherContentInfo.release());
\r
810 // Shallow copy, adds just the pointer: not the element
\r
812 r = __pFinalOutList->Add(*(pContentSearchResult.release()));
\r
813 SysTryReturnResult(NID_CNT, !IsFailed(r), r, "Failed to perform Add operation for ArrayList.");
\r
815 //pOtherContentInfo = null;
\r
816 //pContentSearchResult = null;
\r
817 //_ContentUtility::DeleteContentData(&contentData);
\r
819 case MEDIA_CONTENT_TYPE_IMAGE:
\r
820 //memset(&contentData, 0, sizeof(contentData));
\r
821 //memset(&imageContentData, 0, sizeof(imageContentData));
\r
823 pImageContentInfo = std::unique_ptr<ImageContentInfo>(new (std::nothrow) ImageContentInfo);
\r
824 SysTryReturnResult(NID_CNT, pImageContentInfo.get() != null, E_OUT_OF_MEMORY, "Failed to create pImageContentInfo.");
\r
826 pContentData = pImageContentInfo->GetContentData();
\r
827 SysTryReturnResult(NID_CNT, pContentData != null, E_OUT_OF_MEMORY, "The memory is insufficient.");
\r
829 pImageContentData = pImageContentInfo->GetImageContentData();
\r
830 SysTryReturnResult(NID_CNT, pImageContentData != null, E_OUT_OF_MEMORY, "The memory is insufficient.");
\r
832 r = _ContentUtility::FillContentData(pMediaHandle.get(), pContentData);
\r
833 SysTryReturnResult(NID_CNT, !IsFailed(r), r, "Failed to perform FillContentData operation.");
\r
835 r = _ContentUtility::FillImageContentData(pMediaHandle.get(), pImageContentData);
\r
836 SysTryReturnResult(NID_CNT, !IsFailed(r), r, "Failed to perform GetDataFromImageTable operation.");
\r
838 pContentSearchResult = std::unique_ptr<ContentSearchResult>(new (std::nothrow) ContentSearchResult);
\r
839 SysTryReturnResult(NID_CNT, pContentSearchResult.get() != null, E_OUT_OF_MEMORY, "Failed to create pContentSearchResult.");
\r
841 pContentSearchResult->SetContentType(CONTENT_TYPE_IMAGE);
\r
842 pContentSearchResult->SetContentInfo(pImageContentInfo.release());
\r
844 // Shallow copy, adds just the pointer: not the element
\r
846 r = __pFinalOutList->Add(*(pContentSearchResult.release()));
\r
847 SysTryReturnResult(NID_CNT, !IsFailed(r), r, "Failed to perform Add operation for ArrayList.");
\r
848 //pImageContentInfo = null;
\r
849 //pContentSearchResult = null;
\r
850 //_ContentUtility::DeleteContentData(&contentData);
\r
852 case MEDIA_CONTENT_TYPE_MUSIC:
\r
854 case MEDIA_CONTENT_TYPE_SOUND:
\r
855 //memset(&contentData, 0, sizeof(contentData));
\r
856 //memset(&audioContentData, 0, sizeof(audioContentData));
\r
858 pAudioContentInfo = std::unique_ptr<AudioContentInfo>(new (std::nothrow) AudioContentInfo);
\r
859 SysTryReturnResult(NID_CNT, pAudioContentInfo.get() != null, E_OUT_OF_MEMORY, "Failed to create pAudioContentInfo.");
\r
861 pContentData = pAudioContentInfo->GetContentData();
\r
862 SysTryReturnResult(NID_CNT, pContentData != null, E_OUT_OF_MEMORY, "The memory is insufficient.");
\r
864 pAudioContentData = pAudioContentInfo->GetAudioContentData();
\r
865 SysTryReturnResult(NID_CNT, pAudioContentData != null, E_OUT_OF_MEMORY, "The memory is insufficient.");
\r
867 r = _ContentUtility::FillContentData(pMediaHandle.get(), pContentData);
\r
868 SysTryReturnResult(NID_CNT, !IsFailed(r), r, "Failed to perform FillContentData operation.");
\r
870 r = _ContentUtility::FillAudioContentData(pMediaHandle.get(), pAudioContentData);
\r
871 SysTryReturnResult(NID_CNT, !IsFailed(r), r, "Failed to perform FillAudioContentData operation.");
\r
873 pContentSearchResult = std::unique_ptr<ContentSearchResult>(new (std::nothrow) ContentSearchResult);
\r
874 SysTryReturnResult(NID_CNT, pContentSearchResult.get() != null, E_OUT_OF_MEMORY, "Failed to create pContentSearchResult.");
\r
876 pContentSearchResult->SetContentType(CONTENT_TYPE_AUDIO);
\r
877 pContentSearchResult->SetContentInfo(pAudioContentInfo.release());
\r
879 // Shallow copy, adds just the pointer: not the element
\r
881 r = __pFinalOutList->Add(*(pContentSearchResult.release()));
\r
882 SysTryReturnResult(NID_CNT, !IsFailed(r), r, "Failed to perform Add operation for ArrayList.");
\r
884 //pAudioContentInfo = null;
\r
885 //pContentSearchResult = null;
\r
886 //_ContentUtility::DeleteContentData(&contentData);
\r
887 //_ContentUtility::DeleteAudioContentData(&audioContentData);
\r
889 case MEDIA_CONTENT_TYPE_VIDEO:
\r
890 //memset(&contentData, 0, sizeof(contentData));
\r
891 //memset(&videoContentData, 0, sizeof(videoContentData));
\r
893 pVideoContentInfo = std::unique_ptr<VideoContentInfo>(new (std::nothrow) VideoContentInfo);
\r
894 SysTryReturnResult(NID_CNT, pVideoContentInfo.get() != null, E_OUT_OF_MEMORY, "Failed to create pVideoContentInfo.");
\r
896 pContentData = pVideoContentInfo->GetContentData();
\r
897 SysTryReturnResult(NID_CNT, pContentData != null, E_OUT_OF_MEMORY, "The memory is insufficient.");
\r
899 pVideoContentData = pVideoContentInfo->GetVideoContentData();
\r
900 SysTryReturnResult(NID_CNT, pVideoContentData != null, E_OUT_OF_MEMORY, "The memory is insufficient.");
\r
902 r = _ContentUtility::FillContentData(pMediaHandle.get(), pContentData);
\r
903 SysTryReturnResult(NID_CNT, !IsFailed(r), r, "Failed to perform FillContentData operation.");
\r
905 r = _ContentUtility::FillVideoContentData(pMediaHandle.get(), pVideoContentData);
\r
906 SysTryReturnResult(NID_CNT, !IsFailed(r), r, "Failed to perform FillVideoContentData operation.");
\r
908 pContentSearchResult = std::unique_ptr<ContentSearchResult>(new (std::nothrow) ContentSearchResult);
\r
909 SysTryReturnResult(NID_CNT, pContentSearchResult.get() != null, E_OUT_OF_MEMORY, "Failed to create pContentSearchResult.");
\r
911 pContentSearchResult->SetContentType(CONTENT_TYPE_VIDEO);
\r
912 pContentSearchResult->SetContentInfo(pVideoContentInfo.release());
\r
914 // Shallow copy, adds just the pointer: not the element
\r
916 r = __pFinalOutList->Add(*(pContentSearchResult.release()));
\r
917 SysTryReturnResult(NID_CNT, !IsFailed(r), r, "Failed to perform Add operation for ArrayList.");
\r
919 //pVideoContentInfo = null;
\r
920 //pContentSearchResult = null;
\r
921 //_ContentUtility::DeleteContentData(&contentData);
\r
922 //_ContentUtility::DeleteVideoContentData(&videoContentData);
\r
931 // returns given column value list in the requested order
\r
933 _ContentSearchImpl::GetValueListN(const String& sortColumn, SortOrder sortOrder)
\r
935 SysLog(NID_CNT, "inputColumn = %ls", sortColumn.GetPointer());
\r
938 result r = E_SUCCESS;
\r
942 __inputColumnName.Clear();
\r
943 __inputExpr.Clear();
\r
945 __inputColumnName = sortColumn;
\r
946 __inputSortOrder = sortOrder;
\r
948 String ospColumnName(L"");
\r
949 String slpColumnName(L"");
\r
951 String columnName(__inputColumnName);
\r
953 if ((__inputColumnName.IsEmpty()) && ((__inputSortOrder == SORT_ORDER_ASCENDING) || (__inputSortOrder == SORT_ORDER_DESCENDING)))
\r
955 SysLog(NID_CNT, "sort column name is empty and sort oder is not none. so,E_INVALID_ARG occured.");
\r
956 SetLastResult(E_INVALID_ARG);
\r
961 std::unique_ptr<ArrayList, AllElementsDeleter> pFinalOutList(new (std::nothrow) ArrayList());
\r
962 SysTryReturn(NID_CNT, pFinalOutList.get() != null, NULL, E_OUT_OF_MEMORY, "[E_OUT_OF_MEMORY] Failed to construct ArrayList.");
\r
964 r = pFinalOutList->Construct();
\r
965 SysTryReturn(NID_CNT, !IsFailed(r), NULL, E_OUT_OF_MEMORY, "[E_OUT_OF_MEMORY] Failed to construct ArrayList.");
\r
967 __pFinalOutList = std::move(pFinalOutList);
\r
969 switch (__contentType)
\r
971 case CONTENT_TYPE_OTHER:
\r
973 case CONTENT_TYPE_IMAGE:
\r
974 maxCols = MAX_QUERY_COLUMNS_FOR_IMAGE_OTHERS;
\r
976 case CONTENT_TYPE_VIDEO:
\r
977 maxCols = MAX_QUERY_COLUMNS_FOR_VIDEO;
\r
979 case CONTENT_TYPE_AUDIO:
\r
981 case CONTENT_TYPE_ALL:
\r
982 maxCols = MAX_QUERY_COLUMNS;
\r
988 for (colIndex = 0; colIndex < maxCols; colIndex++)
\r
990 ospColumnName.Clear();
\r
991 slpColumnName.Clear();
\r
993 ospColumnName = dbfieldinfo[colIndex].dbFieldOspName ;
\r
994 slpColumnName = dbfieldinfo[colIndex].dbFieldSlpName ;
\r
996 ospColumnName.ToUpper();
\r
997 columnName.ToUpper();
\r
998 if (columnName == ospColumnName)
\r
1000 r = FillColumnsList(colIndex);
\r
1001 SysTryReturn(NID_CNT, r == E_SUCCESS, NULL, r, "[%s] FillColumnsList Failed.", GetErrorMessage(r));
\r
1005 if (colIndex == maxCols)
\r
1007 r = E_INVALID_ARG;
\r
1008 SysTryReturn(NID_CNT, r == E_SUCCESS, NULL, r, "[E_INVALID_ARG] invalid column.");
\r
1012 return __pFinalOutList.release();
\r
1015 // returns given column value list in the requested order
\r
1016 Collection::IList*
\r
1017 _ContentSearchImpl::GetValueListN(int pageNo, int countPerPage, int& totalPageCount, int& totalCount, const String& sortColumn, SortOrder sortOrder) const
\r
1019 SysLog(NID_CNT, "pageNo = %d, countPerPage = %d, inputColumn = %ls", pageNo, countPerPage, sortColumn.GetPointer());
\r
1021 ClearLastResult();
\r
1023 result r = E_SUCCESS;
\r
1027 __inputColumnName.Clear();
\r
1028 __inputExpr.Clear();
\r
1030 __inputColumnName = sortColumn;
\r
1031 __inputSortOrder = sortOrder;
\r
1033 String ospColumnName(L"");
\r
1034 String slpColumnName(L"");
\r
1036 String columnName(__inputColumnName);
\r
1038 if ((__inputColumnName.IsEmpty()) && ((__inputSortOrder == SORT_ORDER_ASCENDING) || (__inputSortOrder == SORT_ORDER_DESCENDING)))
\r
1040 SysLog(NID_CNT, "sort column name is empty and sort oder is not none. so,E_INVALID_ARG occured.");
\r
1041 SetLastResult(E_INVALID_ARG);
\r
1046 std::unique_ptr<ArrayList, AllElementsDeleter> pFinalOutList(new (std::nothrow) ArrayList());
\r
1047 SysTryReturn(NID_CNT, pFinalOutList.get() != null, NULL, E_OUT_OF_MEMORY, "[E_OUT_OF_MEMORY] Failed to construct ArrayList.");
\r
1049 r = pFinalOutList->Construct();
\r
1050 SysTryReturn(NID_CNT, !IsFailed(r), NULL, r, "[%s] Failed to construct ArrayList.", GetErrorMessage(r));
\r
1052 __pFinalOutList = std::move(pFinalOutList);
\r
1054 switch (__contentType)
\r
1056 case CONTENT_TYPE_OTHER:
\r
1058 case CONTENT_TYPE_IMAGE:
\r
1059 maxCols = MAX_QUERY_COLUMNS_FOR_IMAGE_OTHERS;
\r
1061 case CONTENT_TYPE_VIDEO:
\r
1062 maxCols = MAX_QUERY_COLUMNS_FOR_VIDEO;
\r
1064 case CONTENT_TYPE_AUDIO:
\r
1066 case CONTENT_TYPE_ALL:
\r
1067 maxCols = MAX_QUERY_COLUMNS;
\r
1073 for (colIndex = 0; colIndex < maxCols; colIndex++)
\r
1075 ospColumnName.Clear();
\r
1076 slpColumnName.Clear();
\r
1078 ospColumnName = dbfieldinfo[colIndex].dbFieldOspName ;
\r
1079 slpColumnName = dbfieldinfo[colIndex].dbFieldSlpName ;
\r
1081 ospColumnName.ToUpper();
\r
1082 columnName.ToUpper();
\r
1083 if (columnName == ospColumnName)
\r
1085 r = FillColumnsList(pageNo, countPerPage, totalPageCount, totalCount, colIndex);
\r
1086 SysTryReturn(NID_CNT, r == E_SUCCESS, NULL, r, "[%s] FillColumnsList Failed.", GetErrorMessage(r));
\r
1090 if (colIndex == maxCols)
\r
1092 r = E_INVALID_ARG;
\r
1093 SysTryReturn(NID_CNT, r == E_SUCCESS, NULL, r, "[E_INVALID_ARG] invalid column.");
\r
1097 return __pFinalOutList.release();
\r
1100 // prepares query expression to be used in group api. colIndex is mapped to actual group value.
\r
1102 _ContentSearchImpl::GetIndexAndCreateQueryExp(int colIndex) const
\r
1104 media_group_e groupIndex = MEDIA_CONTENT_GROUP_DISPLAY_NAME;;
\r
1107 case 0://"ContentType", "MEDIA_TYPE"
\r
1108 groupIndex = MEDIA_CONTENT_GROUP_TYPE;
\r
1109 __inputExpr = "MEDIA_TYPE IS NOT NULL";
\r
1111 case 1://"ContentFileName", "MEDIA_DISPLAY_NAME"
\r
1112 groupIndex = MEDIA_CONTENT_GROUP_DISPLAY_NAME;
\r
1113 __inputExpr = "MEDIA_DISPLAY_NAME IS NOT NULL";
\r
1115 case 2://"ContentName", "MEDIA_CONTENT_NAME"
\r
1116 groupIndex = MEDIA_CONTENT_GROUP_CONTENT_NAME;
\r
1117 __inputExpr = "MEDIA_CONTENT_NAME IS NOT NULL";
\r
1119 case 3://"Category", "MEDIA_CATEGORY"
\r
1120 groupIndex = MEDIA_CONTENT_GROUP_CATEGORY;
\r
1121 __inputExpr = "MEDIA_CATEGORY IS NOT NULL";
\r
1123 case 4://"Author", "MEDIA_AUTHOR"
\r
1124 groupIndex = MEDIA_CONTENT_GROUP_AUTHOR;
\r
1125 __inputExpr = "MEDIA_AUTHOR IS NOT NULL";
\r
1127 case 5://"keyword", "MEDIA_KEYWORD"
\r
1128 groupIndex = MEDIA_CONTENT_GROUP_KEYWORD;
\r
1129 __inputExpr = "MEDIA_KEYWORD IS NOT NULL";
\r
1131 case 6://"Provider", "MEDIA_PROVIDER"
\r
1132 groupIndex = MEDIA_CONTENT_GROUP_PROVIDER;
\r
1133 __inputExpr = "MEDIA_PROVIDER IS NOT NULL";
\r
1135 case 7://"Rating", "MEDIA_AGE_RATING"
\r
1136 groupIndex = MEDIA_CONTENT_GROUP_AGE_RATING;
\r
1137 __inputExpr = "MEDIA_AGE_RATING IS NOT NULL";
\r
1139 case 8://"LocationTag", "MEDIA_LOCATION_TAG"
\r
1140 groupIndex = MEDIA_CONTENT_GROUP_LOCATION_TAG;
\r
1141 __inputExpr = "MEDIA_LOCATION_TAG IS NOT NULL";
\r
1143 case 9://"ContentSize", "MEDIA_SIZE"
\r
1144 groupIndex = MEDIA_CONTENT_GROUP_SIZE;
\r
1145 __inputExpr = "MEDIA_SIZE IS NOT NULL";
\r
1147 case 10://"DateTime", "MEDIA_ADDED_TIME"
\r
1148 groupIndex = MEDIA_CONTENT_GROUP_ADDED_TIME;
\r
1149 __inputExpr = "MEDIA_ADDED_TIME IS NOT NULL";
\r
1151 case 11://"Latitude", "MEDIA_LATITUDE"
\r
1152 groupIndex = MEDIA_CONTENT_GROUP_LATITUDE;
\r
1153 __inputExpr = "MEDIA_LATITUDE IS NOT NULL";
\r
1155 case 12://"Longitude", "MEDIA_LONGITUDE"
\r
1156 groupIndex = MEDIA_CONTENT_GROUP_LONGITUDE;
\r
1157 __inputExpr = "MEDIA_LONGITUDE IS NOT NULL";
\r
1159 case 13://"Altitude", "MEDIA_ALTITUDE"
\r
1160 groupIndex = MEDIA_CONTENT_GROUP_ALTITUDE;
\r
1161 __inputExpr = "MEDIA_ALTITUDE IS NOT NULL";
\r
1163 case 14://"Title", "MEDIA_TITLE"
\r
1164 groupIndex = MEDIA_CONTENT_GROUP_TITLE;
\r
1165 __inputExpr = "MEDIA_TITLE IS NOT NULL";
\r
1167 case 15://"Artist", "MEDIA_ARTIST"
\r
1168 groupIndex = MEDIA_CONTENT_GROUP_ARTIST;
\r
1169 __inputExpr = "MEDIA_ARTIST IS NOT NULL";
\r
1171 case 16://"Genre", "MEDIA_GENRE"
\r
1172 groupIndex = MEDIA_CONTENT_GROUP_GENRE;
\r
1173 __inputExpr = "MEDIA_GENRE IS NOT NULL";
\r
1175 case 17://"Year", "MEDIA_YEAR"
\r
1176 groupIndex = MEDIA_CONTENT_GROUP_YEAR;
\r
1177 __inputExpr = "MEDIA_YEAR IS NOT NULL";
\r
1179 case 18://"Composer", "MEDIA_COMPOSER"
\r
1180 groupIndex = MEDIA_CONTENT_GROUP_COMPOSER;
\r
1181 __inputExpr = "MEDIA_COMPOSER IS NOT NULL";
\r
1183 case 19://"Album", "MEDIA_ALBUM"
\r
1184 __inputExpr = "MEDIA_ALBUM IS NOT NULL";
\r
1189 return groupIndex;
\r
1192 // Fills given column value list and destroys filter handle
\r
1194 _ContentSearchImpl::FillColumnsList(int colIndex) const
\r
1196 result r = E_SUCCESS;
\r
1197 int ret = MEDIA_CONTENT_ERROR_NONE;
\r
1198 int totalCount = 0;
\r
1199 media_group_e groupIndex = GetIndexAndCreateQueryExp(colIndex);
\r
1201 r = CreateQueryFilter(true);
\r
1202 SysTryReturnResult(NID_CNT, !IsFailed(r), r, "CreateQueryFilter Failed.");
\r
1204 if (colIndex == ALBUM_COLUMN_NUM)
\r
1206 ret = media_album_get_album_count_from_db(*(__pFilterHandle.get()), &totalCount);
\r
1210 ret = media_group_get_group_count_from_db(*(__pFilterHandle.get()), groupIndex, &totalCount);
\r
1212 r = MapCoreErrorToNativeResult(ret);
\r
1213 SysTryReturnResult(NID_CNT, ret == MEDIA_CONTENT_ERROR_NONE, r, "Failed to perform media_album/group count_from_db operation.");
\r
1215 SysLog(NID_CNT, "totalCount = %d for media_album/group count_from_db", totalCount);
\r
1217 if (totalCount > 0)
\r
1219 if (colIndex == ALBUM_COLUMN_NUM)
\r
1221 r = ExecuteAndFillAlbumValues();
\r
1222 SysTryReturnResult(NID_CNT, !IsFailed(r), r, "ExecuteAndFillAlbumValues Failed.");
\r
1226 r = ExecuteAndFillGetValueListN(groupIndex, colIndex);
\r
1227 SysTryReturnResult(NID_CNT, !IsFailed(r), r, "ExecuteAndFillGetValueListN Failed.");
\r
1233 // prepares input expression to be sent for create filter and fills given column value list
\r
1235 _ContentSearchImpl::FillColumnsList(int pageNo, int countPerPage, int& totalPageCount, int& totalCount, int colIndex) const
\r
1237 result r = E_SUCCESS;
\r
1238 int ret = MEDIA_CONTENT_ERROR_NONE;
\r
1240 totalPageCount = 0;
\r
1242 media_group_e groupIndex = GetIndexAndCreateQueryExp(colIndex);
\r
1244 r = CreateQueryFilter(true);
\r
1245 SysTryReturnResult(NID_CNT, !IsFailed(r), r, "CreateQueryFilter Failed.");
\r
1247 if (colIndex == ALBUM_COLUMN_NUM)
\r
1249 ret = media_album_get_album_count_from_db(*(__pFilterHandle.get()), &totalCount);
\r
1253 ret = media_group_get_group_count_from_db(*(__pFilterHandle.get()), groupIndex, &totalCount);
\r
1255 r = MapCoreErrorToNativeResult(ret);
\r
1256 SysTryReturnResult(NID_CNT, ret == MEDIA_CONTENT_ERROR_NONE, r, "Failed to perform media_album/group count_from_db operation.");
\r
1258 SysLog(NID_CNT, "totalCount = %d for media_album/group count_from_db", totalCount);
\r
1260 if (totalCount > 0)
\r
1262 if ((totalCount % countPerPage) == 0)
\r
1264 totalPageCount = totalCount / countPerPage;
\r
1268 totalPageCount = (totalCount / countPerPage) + 1;
\r
1271 if ((pageNo < 1) || (pageNo > totalPageCount))
\r
1273 r = E_INVALID_ARG;
\r
1274 SysTryReturnResult(NID_CNT, !IsFailed(r), r, "(pageNo < 1) || (pageNo > totalPageCount).");
\r
1277 offset = (pageNo * countPerPage) - countPerPage;
\r
1279 SysLog(NID_CNT, "GetValueListN totalCount [%d] totalPageCount[%d] __countPerPage[%d] __pageNo[%d] offset[%d]",
\r
1280 totalCount, totalPageCount, countPerPage, pageNo, offset);
\r
1282 ret = media_filter_set_offset(*(__pFilterHandle.get()),offset,countPerPage);
\r
1283 r = MapCoreErrorToNativeResult(ret);
\r
1284 SysTryReturnResult(NID_CNT, ret == MEDIA_CONTENT_ERROR_NONE, r, "failed to perform media_filter_set_offset operation.");
\r
1286 if (colIndex == ALBUM_COLUMN_NUM)
\r
1288 r = ExecuteAndFillAlbumValues();
\r
1289 SysTryReturnResult(NID_CNT, !IsFailed(r), r, "ExecuteAndFillAlbumValues Failed.");
\r
1293 r = ExecuteAndFillGetValueListN(groupIndex, colIndex);
\r
1294 SysTryReturnResult(NID_CNT, !IsFailed(r), r, "ExecuteAndFillGetValueListN Failed.");
\r
1298 else if (pageNo > 1)
\r
1300 r = E_INVALID_ARG;
\r
1301 SysTryReturnResult(NID_CNT, !IsFailed(r), r, "(pageNo > 1) and (totalcount = 0).");
\r
1307 // fills given column value list for GetValuelistN api
\r
1309 _ContentSearchImpl::ExecuteAndFillGetValueListN(media_group_e groupIndex, int colIndex) const
\r
1311 SysLog(NID_CNT, "Enter\n");
\r
1313 int ret = MEDIA_CONTENT_ERROR_NONE;
\r
1314 result r = E_SUCCESS;
\r
1315 result res = E_SUCCESS;
\r
1316 std::unique_ptr<GList, SearchGListDeleter> pItemList;
\r
1317 GList* pTemp = NULL;
\r
1319 std::unique_ptr<Object> pValue;
\r
1321 DateTime dateTime;
\r
1323 long long contentSize = 0;
\r
1324 long long addedTime = 0;
\r
1327 char *pColumnVal = null;
\r
1328 int contentType = 0;
\r
1330 pTemp = pItemList.get();
\r
1332 ret = media_group_foreach_group_from_db(*(__pFilterHandle.get()), groupIndex, GroupItemCb, &pTemp);
\r
1333 r = MapCoreErrorToNativeResult(ret);
\r
1334 SysTryReturnResult(NID_CNT, r == E_SUCCESS, r, "Failed to perform media_group_foreach_group_from_db operation.");
\r
1336 SysTryReturnResult(NID_CNT, pTemp != NULL, r, "media_info_foreach_media_from_db pTemp is null.");
\r
1338 for (int idx = 0; idx < (int)g_list_length(pTemp); idx++)
\r
1340 SysLog(NID_CNT, "idx = %d and (int)g_list_length(pItemList) = %d", idx, (int)g_list_length(pTemp));
\r
1342 pColumnVal = (char *)g_list_nth_data(pTemp, idx);
\r
1344 String strColVal(pColumnVal);
\r
1346 _ContentUtility::DoSafeFree(pColumnVal);
\r
1348 SysLog(NID_CNT, "pColumnVal = %ls", strColVal.GetPointer());
\r
1352 case 0://"ContentType", "MEDIA_TYPE"
\r
1353 if ((strColVal.CompareTo(L"Unknown") != 0) && (!strColVal.IsEmpty()))
\r
1355 res = Integer::Parse(strColVal, contentType);
\r
1356 SysTryLog(NID_CNT, res == E_SUCCESS, "[%s] Integer parse failed.", GetErrorMessage(res));
\r
1358 switch ((media_content_type_e)contentType)
\r
1360 case MEDIA_CONTENT_TYPE_OTHERS:
\r
1361 pValue.reset(new (std::nothrow) String(CONTENT_TYPE_OTHER));
\r
1362 SysLog(NID_CNT, "mediaType = CONTENT_TYPE_OTHER");
\r
1364 case MEDIA_CONTENT_TYPE_IMAGE:
\r
1365 pValue.reset(new (std::nothrow) String(CONTENT_TYPE_IMAGE));
\r
1366 SysLog(NID_CNT, "mediaType = CONTENT_TYPE_IMAGE");
\r
1368 case MEDIA_CONTENT_TYPE_SOUND:
\r
1370 case MEDIA_CONTENT_TYPE_MUSIC:
\r
1371 pValue.reset(new (std::nothrow) String(CONTENT_TYPE_AUDIO));
\r
1372 SysLog(NID_CNT, "mediaType = CONTENT_TYPE_AUDIO");
\r
1374 case MEDIA_CONTENT_TYPE_VIDEO:
\r
1375 pValue.reset(new (std::nothrow) String(CONTENT_TYPE_VIDEO));
\r
1376 SysLog(NID_CNT, "mediaType = CONTENT_TYPE_VIDEO");
\r
1382 case 1://"ContentFileName", "MEDIA_DISPLAY_NAME"
\r
1384 case 2://"ContentName", "MEDIA_CONTENT_NAME"
\r
1386 case 3://"Category", "MEDIA_CATEGORY"
\r
1388 case 4://"Author", "MEDIA_AUTHOR"
\r
1390 case 5://"keyword", "MEDIA_KEYWORD"
\r
1392 case 6://"Provider", "MEDIA_PROVIDER"
\r
1394 case 7://"Rating", "MEDIA_AGE_RATING"
\r
1396 case 8://"LocationTag", "MEDIA_LOCATION_TAG"
\r
1398 case 14://"Title", "MEDIA_TITLE"
\r
1400 case 15://"Artist", "MEDIA_ARTIST"
\r
1402 case 16://"Genre", "MEDIA_GENRE"
\r
1404 case 17://"Year", "MEDIA_YEAR"
\r
1406 case 18://"Composer", "MEDIA_COMPOSER"
\r
1408 pValue.reset(new (std::nothrow) String(strColVal));
\r
1411 case 9://"ContentSize", "MEDIA_SIZE"
\r
1412 if ((strColVal.CompareTo(L"Unknown") != 0) && (!strColVal.IsEmpty()))
\r
1414 res = LongLong::Parse(strColVal, contentSize);
\r
1415 SysTryLog(NID_CNT, res == E_SUCCESS, "[%s] LongLong parse failed.", GetErrorMessage(res));
\r
1418 pValue.reset(new (std::nothrow) LongLong(contentSize));
\r
1420 case 10://"DateTime", "MEDIA_ADDED_TIME"
\r
1421 if ((strColVal.CompareTo(L"Unknown") != 0) && (!strColVal.IsEmpty()))
\r
1423 res = LongLong::Parse(strColVal, addedTime);
\r
1424 SysTryLog(NID_CNT, res == E_SUCCESS, "[%s] LongLong parse failed.", GetErrorMessage(res));
\r
1427 res = dateTime.SetValue(1970, 1, 1);
\r
1428 SysTryLog(NID_CNT, res == E_SUCCESS, "[%s] dateTime.SetValue failed.", GetErrorMessage(res));
\r
1430 res = dateTime.AddSeconds(addedTime);
\r
1431 SysTryLog(NID_CNT, res == E_SUCCESS, "[%s] dateTime.AddSeconds failed.", GetErrorMessage(res));
\r
1433 SysLog(NID_CNT, "DateTime : %ls", dateTime.ToString().GetPointer());
\r
1435 pValue.reset(new (std::nothrow) DateTime(dateTime));
\r
1438 case 11://"Latitude", "MEDIA_LATITUDE"
\r
1440 case 12://"Longitude", "MEDIA_LONGITUDE"
\r
1442 case 13://"Altitude", "MEDIA_ALTITUDE"
\r
1443 if ((strColVal.CompareTo(L"Unknown") != 0) && (!strColVal.IsEmpty()))
\r
1445 res = Double::Parse(strColVal, dVal);
\r
1446 SysTryLog(NID_CNT, res == E_SUCCESS, "[%s] double parse failed.", GetErrorMessage(res));
\r
1448 pValue.reset(new (std::nothrow) Double(dVal));
\r
1451 case 19://"Album", "MEDIA_ALBUM"
\r
1456 if (pValue.get() != NULL)
\r
1458 r = __pFinalOutList->Add(*(pValue.release()));
\r
1459 SysTryReturnResult(NID_CNT, r == E_SUCCESS, r, "Failed to perform arraylist Add operation.");
\r
1467 _ContentSearchImpl::ExecuteAndFillAlbumValues(void) const
\r
1469 int ret = MEDIA_CONTENT_ERROR_NONE;
\r
1470 result r = E_SUCCESS;
\r
1471 std::unique_ptr<GList, SearchGListDeleter> pItemList;
\r
1472 GList* pTemp = NULL;
\r
1473 std::unique_ptr<media_album_s, AlbumHandleDeleter> pAlbumHandle;
\r
1475 Object* pValue = NULL;
\r
1476 char* __pAlbumName = NULL;
\r
1477 std::unique_ptr<char, CharDeleter> pAlbumName;
\r
1479 pTemp = pItemList.get();
\r
1481 ret = media_album_foreach_album_from_db(*(__pFilterHandle.get()), AlbumItemCb, &pTemp);
\r
1482 r = MapCoreErrorToNativeResult(ret);
\r
1483 SysTryReturnResult(NID_CNT, r == E_SUCCESS, r, "Failed to perform media_album_foreach_album_from_db operation.");
\r
1484 SysTryReturnResult(NID_CNT, pTemp != NULL, r, "media_info_foreach_media_from_db pTemp is null.");
\r
1486 for (int idx = 0; idx < (int)g_list_length(pTemp); idx++)
\r
1488 pAlbumHandle.reset(static_cast<media_album_h>(g_list_nth_data(pTemp, idx)));
\r
1489 ret = media_album_get_name(pAlbumHandle.get(), &__pAlbumName);
\r
1490 r = MapCoreErrorToNativeResult(ret);
\r
1491 SysTryReturnResult(NID_CNT, !IsFailed(r), r, "Failed to perform media_album_get_name.");
\r
1493 if (__pAlbumName != NULL)
\r
1495 SysLog(NID_CNT, "pColumnVal = %s", __pAlbumName);
\r
1497 pAlbumName.reset(__pAlbumName);
\r
1499 pValue = new (std::nothrow) String(pAlbumName.get());
\r
1500 SysTryReturnResult(NID_CNT, pValue != NULL, E_OUT_OF_MEMORY, "media_info_foreach_media_from_db pTemp is null.");
\r
1503 if (pValue != NULL)
\r
1505 r = __pFinalOutList->Add(*pValue);
\r
1506 SysTryReturnResult(NID_CNT, r == E_SUCCESS, r, "Failed to perform arraylist Add operation.");
\r
1515 _ContentSearchImpl::MapCoreErrorToNativeResult(int reason) const
\r
1517 result r = E_SUCCESS;
\r
1521 case MEDIA_CONTENT_ERROR_NONE:
\r
1525 case MEDIA_CONTENT_ERROR_INVALID_PARAMETER:
\r
1526 r = E_INVALID_ARG;
\r
1527 SysLog(NID_CNT, "MEDIA_CONTENT_ERROR_INVALID_PARAMETER");
\r
1530 case MEDIA_CONTENT_ERROR_DB_FAILED:
\r
1532 SysLog(NID_CNT, "MEDIA_CONTENT_ERROR_DB_FAILED");
\r
1535 case MEDIA_CONTENT_ERROR_OUT_OF_MEMORY:
\r
1536 r = E_OUT_OF_MEMORY;
\r
1537 SysLog(NID_CNT, "MEDIA_CONTENT_ERROR_OUT_OF_MEMORY");
\r
1541 SysLog(NID_CNT, "default");
\r
1548 //Callback function registered to each media info details
\r
1549 // all items are appened to the list
\r
1551 MediaItemCb(media_info_h media, void* pUserdata)
\r
1553 int ret = MEDIA_CONTENT_ERROR_NONE;
\r
1554 media_info_h new_media = NULL;
\r
1555 ret = media_info_clone(&new_media, media);
\r
1556 SysTryLog(NID_CNT, ret == MEDIA_CONTENT_ERROR_NONE, "[E_SYSTEM] Failed to perform media_info_clone");
\r
1558 GList** pList = (GList**)pUserdata;
\r
1559 *pList = g_list_append(*pList, new_media);
\r
1564 //Callback function registered for column values
\r
1565 // all items are appened to the list
\r
1567 GroupItemCb(const char* pGroupName, void* pUserdata)
\r
1569 char* pGrpName = strdup(pGroupName);
\r
1570 GList** pList = (GList**)pUserdata;
\r
1571 *pList = g_list_append(*pList, pGrpName);
\r
1576 //Callback function registered to each media info details
\r
1577 // all items are appened to the list
\r
1579 AlbumItemCb(media_album_h album, void* pUserdata)
\r
1581 int ret = MEDIA_CONTENT_ERROR_NONE;
\r
1582 media_album_h new_album = NULL;
\r
1583 ret = media_album_clone(&new_album, album);
\r
1584 SysTryLog(NID_CNT, ret == MEDIA_CONTENT_ERROR_NONE, "[E_SYSTEM] Failed to perform media_album_clone");
\r
1586 GList** pList = (GList**)pUserdata;
\r
1587 *pList = g_list_append(*pList, new_album);
\r