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, E_OUT_OF_MEMORY, "pInputCond is NULL.");
\r
177 SysLog(NID_CNT, "pInputCond = %s", pInputCond.get());
\r
179 ret = media_filter_set_condition(*(pFilterHandle.get()), pInputCond.get(), MEDIA_CONTENT_COLLATE_DEFAULT);
\r
180 SysTryReturnResult(NID_CNT, ret == MEDIA_CONTENT_ERROR_NONE, E_SYSTEM, "Failed to perform media_filter_set_condition operation.");
\r
183 if (!__inputColumnName.IsEmpty()) // SortColumn is optional in case of SearchN
\r
185 //__inputColumnName (osp column name) is replaced with slpColumn (slp column name).
\r
186 r = GetSlpColumnName(slpColumn);
\r
187 SysTryReturnResult(NID_CNT, !IsFailed(r), r, "Failed to perform GetSlpColumnName operation.");
\r
189 //CopyToCharArrayN: utility function, converts a osp string to char*
\r
191 pSortCol = std::unique_ptr<char[]>(_StringConverter::CopyToCharArrayN(slpColumn));
\r
192 SysTryReturnResult(NID_CNT, pSortCol, E_OUT_OF_MEMORY, "pSortCol is NULL.");
\r
194 if (__inputSortOrder == SORT_ORDER_ASCENDING)
\r
196 ret = media_filter_set_order(*(pFilterHandle.get()), MEDIA_CONTENT_ORDER_ASC, pSortCol.get(), MEDIA_CONTENT_COLLATE_DEFAULT);
\r
197 SysTryReturnResult(NID_CNT, ret == MEDIA_CONTENT_ERROR_NONE, E_SYSTEM, "Failed to perform media_filter_set_order operation.");
\r
199 else if (__inputSortOrder == SORT_ORDER_DESCENDING)
\r
201 ret = media_filter_set_order(*(pFilterHandle.get()), MEDIA_CONTENT_ORDER_DESC, pSortCol.get(), MEDIA_CONTENT_COLLATE_DEFAULT);
\r
202 SysTryReturnResult(NID_CNT, ret == MEDIA_CONTENT_ERROR_NONE, E_SYSTEM, "Failed to perform media_filter_set_order operation.");
\r
206 __pFilterHandle.reset(pFilterHandle.release());
\r
211 // Osp column names are mapped with slp column names
\r
212 // CONTENT_TYPE_OTHER and CONTENT_TYPE_IMAGE (0 - 13 ) are valid columns
\r
213 // CONTENT_TYPE_VIDEO (0 - 16 ) are valid columns
\r
214 // CONTENT_TYPE_ALL and CONTENT_TYPE_VIDEO (0 - 18 ) are valid columns
\r
215 // if the given osp column is out of the specified range of the type, E_INVALID_ARG is retuned.
\r
217 _ContentSearchImpl::GetSlpColumnName(String& inputCol) const
\r
219 String ospColumnName(L"");
\r
220 String slpColumnName(L"");
\r
221 String columnName(__inputColumnName);
\r
222 result r = E_SUCCESS;
\r
224 switch (__contentType)
\r
226 case CONTENT_TYPE_OTHER:
\r
228 case CONTENT_TYPE_IMAGE:
\r
229 maxCols = MAX_QUERY_COLUMNS_FOR_IMAGE_OTHERS;
\r
231 case CONTENT_TYPE_VIDEO:
\r
232 maxCols = MAX_QUERY_COLUMNS_FOR_VIDEO;
\r
234 case CONTENT_TYPE_AUDIO:
\r
236 case CONTENT_TYPE_ALL:
\r
237 maxCols = MAX_QUERY_COLUMNS;
\r
242 for (int colIndex = 0; colIndex < maxCols; colIndex++)
\r
244 ospColumnName.Clear();
\r
245 slpColumnName.Clear();
\r
247 ospColumnName = dbfieldinfo[colIndex].dbFieldOspName ;
\r
248 slpColumnName = dbfieldinfo[colIndex].dbFieldSlpName ;
\r
250 ospColumnName.ToUpper();
\r
251 columnName.ToUpper();
\r
252 if (columnName == ospColumnName)
\r
254 inputCol = slpColumnName;
\r
258 return E_INVALID_ARG;
\r
261 //If the input expression contains any osp column name, it will be replaced with slp column name.
\r
262 // only CONTENT_TYPE_AUDIO and CONTENT_TYPE_ALL allowed to use all given columns
\r
263 // so, check for invalid column for CONTENT_TYPE_OTHER,CONTENT_TYPE_IMAGE and CONTENT_TYPE_VIDEO.
\r
264 // all the osp columns in the expression should be replaced with slp column names.
\r
265 // ' is used as a delimeter in parsing user query. so, \\' is saved as a special@apostrophe string.
\r
266 // \\' is replaced with '', which considers ' as normal character.
\r
269 _ContentSearchImpl::ReplaceOspColumnNameWithSlp(void) const
\r
271 String ospColumnName(L"");
\r
272 String slpColumnName(L"");
\r
273 String splApostrophe(L"special@apostrophe");
\r
274 result r = E_SUCCESS;
\r
279 String strToBeReplaced(L"\\'");
\r
280 int strLen = strToBeReplaced.GetLength();
\r
281 int startIndex = 0;
\r
283 while(E_SUCCESS == __inputExpr.IndexOf(strToBeReplaced,startIndex,indexOf))
\r
285 int lenAfterSubStr = indexOf + strLen;
\r
286 while ((lenAfterSubStr < __inputExpr.GetLength()) && (__inputExpr[lenAfterSubStr] == ' '))
\r
290 if ((lenAfterSubStr < __inputExpr.GetLength()) && ((__inputExpr[lenAfterSubStr] == '\'') ||
\r
291 ((!__inputExpr.StartsWith(L"AND ", lenAfterSubStr)) && (!__inputExpr.StartsWith(L"OR ", lenAfterSubStr)))))
\r
293 r = __inputExpr.Remove(indexOf,strLen);
\r
294 SysTryReturnResult(NID_CNT, r == E_SUCCESS, E_SYSTEM, "Failed to perform Remove operation.");
\r
295 r = __inputExpr.Insert(splApostrophe,indexOf);
\r
296 SysTryReturnResult(NID_CNT, r == E_SUCCESS, E_SYSTEM, "Failed to perform Insert operation.");
\r
297 startIndex = indexOf + splApostrophe.GetLength();
\r
301 startIndex = lenAfterSubStr;
\r
305 SysLog(NID_CNT, "__inputExpr after splApostrophe append = %ls", __inputExpr.GetPointer());
\r
307 switch (__contentType)
\r
309 case CONTENT_TYPE_OTHER:
\r
311 case CONTENT_TYPE_IMAGE:
\r
312 r = CheckInvalidColumnInQuery();
\r
313 SysTryReturnResult(NID_CNT, r == E_SUCCESS, E_INVALID_ARG, "Invalid Column In QueryString.");
\r
314 maxCols = MAX_QUERY_COLUMNS_FOR_IMAGE_OTHERS;
\r
316 case CONTENT_TYPE_VIDEO:
\r
317 r = CheckInvalidColumnInQuery();
\r
318 SysTryReturnResult(NID_CNT, r == E_SUCCESS, E_INVALID_ARG, "Invalid Column In QueryString.");
\r
319 maxCols = MAX_QUERY_COLUMNS_FOR_VIDEO;
\r
321 case CONTENT_TYPE_AUDIO:
\r
323 case CONTENT_TYPE_ALL:
\r
324 maxCols = MAX_QUERY_COLUMNS;
\r
329 for (int colIndex = 0; colIndex < maxCols; colIndex++)
\r
331 ospColumnName.Clear();
\r
332 slpColumnName.Clear();
\r
334 ospColumnName = dbfieldinfo[colIndex].dbFieldOspName ;
\r
335 slpColumnName = dbfieldinfo[colIndex].dbFieldSlpName ;
\r
337 ReplaceString(ospColumnName,slpColumnName);
\r
340 // Append ESCAPE '\' for LIKE query
\r
341 r = AppendEscapeKeywordForLikeQuery();
\r
342 SysTryReturnResult(NID_CNT, r == E_SUCCESS, E_SYSTEM, "AppendEscapeKeywordForLikeQuery failed.");
\r
344 r = ReplaceDateTimeStringWithInt();
\r
345 SysTryReturnResult(NID_CNT, r == E_SUCCESS, E_INVALID_ARG, "ReplaceDateTimeStringWithInt failed.");
\r
347 // replace splApostrophe string with actual
\r
348 r = __inputExpr.Replace(splApostrophe, "''");
\r
349 SysTryReturnResult(NID_CNT, r == E_SUCCESS, E_SYSTEM, "string Replace failed.");
\r
354 //This function is to appened ESCAPE keyword for _ and % special characters in LIKE query.
\r
357 _ContentSearchImpl::AppendEscapeKeywordForLikeQuery(void) const
\r
359 String delim = L"'"; //Delimeters is ' .
\r
360 result r = E_SUCCESS;
\r
362 bool isAppendEscape = false;
\r
365 String inputExpr = __inputExpr;
\r
367 // Create a StringTokenizer instance
\r
368 StringTokenizer strTok(inputExpr, delim);
\r
372 while (strTok.HasMoreTokens())
\r
374 r = strTok.GetNextToken(token);
\r
375 SysTryReturnResult(NID_CNT, r == E_SUCCESS, E_SYSTEM, "GetNextToken failed.");
\r
376 if (isCol) //column name
\r
379 tokenUpper = token;
\r
380 tokenUpper.ToUpper();
\r
381 if (tokenUpper.Contains(" LIKE"))
\r
383 isAppendEscape = true;
\r
387 isAppendEscape = false;
\r
389 r = inputExpr.Append(token);
\r
390 SysTryReturnResult(NID_CNT, r == E_SUCCESS, E_SYSTEM, "string append failed.");
\r
392 else // value of the column
\r
395 r = inputExpr.Append("'");
\r
396 SysTryReturnResult(NID_CNT, r == E_SUCCESS, E_SYSTEM, "string append failed.");
\r
397 r = inputExpr.Append(token);
\r
398 SysTryReturnResult(NID_CNT, r == E_SUCCESS, E_SYSTEM, "string append failed.");
\r
399 r = inputExpr.Append("'");
\r
400 SysTryReturnResult(NID_CNT, r == E_SUCCESS, E_SYSTEM, "string append failed.");
\r
402 if (isAppendEscape)
\r
404 if (token.Contains("\\_") || token.Contains("\\%"))
\r
406 r = inputExpr.Append("ESCAPE'\\' ");
\r
407 SysTryReturnResult(NID_CNT, r == E_SUCCESS, E_SYSTEM, "string append failed.");
\r
413 __inputExpr.Clear();
\r
414 r = __inputExpr.Insert(inputExpr, 0);
\r
415 SysTryReturnResult(NID_CNT, r == E_SUCCESS, E_SYSTEM, "string insert failed.");
\r
420 //This function is to replace DateTime value(osp datetime type is string) which is string with int.(SLP dateTime column type is int)
\r
423 _ContentSearchImpl::ReplaceDateTimeStringWithInt(void) const
\r
425 String delim = L"'"; //Delimeters is ' .
\r
426 result r = E_SUCCESS;
\r
428 bool isConvertReq = false;
\r
429 bool isBetweenExistsInDateTimeQuery = false;
\r
432 String inputExpr = __inputExpr;
\r
434 if(!inputExpr.Contains("MEDIA_ADDED_TIME"))
\r
439 // Create a StringTokenizer instance
\r
440 StringTokenizer strTok(inputExpr, delim);
\r
444 while (strTok.HasMoreTokens())
\r
446 r = strTok.GetNextToken(token);
\r
447 SysTryReturnResult(NID_CNT, r == E_SUCCESS, r, "GetNextToken failed.");
\r
448 if (isCol) //column name
\r
451 tokenUpper = token;
\r
452 tokenUpper.ToUpper();
\r
453 if(isBetweenExistsInDateTimeQuery)
\r
455 isBetweenExistsInDateTimeQuery = false;
\r
456 isConvertReq = true;
\r
460 if (tokenUpper.Contains("MEDIA_ADDED_TIME"))
\r
462 if (tokenUpper.Contains("BETWEEN"))
\r
464 isBetweenExistsInDateTimeQuery = true;
\r
466 isConvertReq = true;
\r
470 isConvertReq = false;
\r
474 r = inputExpr.Append(token);
\r
475 SysTryReturnResult(NID_CNT, r == E_SUCCESS, r, "string append failed.");
\r
477 else // value of the column
\r
480 r = inputExpr.Append("'");
\r
481 SysTryReturnResult(NID_CNT, r == E_SUCCESS, r, "string append failed.");
\r
485 Tizen::Base::DateTime dt;
\r
486 r = Tizen::Base::DateTime::Parse(token, dt);
\r
487 SysTryReturnResult(NID_CNT, r == E_SUCCESS, r, "Failed to parse DateTime.");
\r
489 int year = dt.GetYear();
\r
490 int month = dt.GetMonth();
\r
491 int day = dt.GetDay();
\r
492 int hour = dt.GetHour();
\r
493 int minute = dt.GetMinute();
\r
494 int second = dt.GetSecond();
\r
497 struct tm* timeInfo;
\r
500 timeInfo = localtime(&rawTime);
\r
501 timeInfo->tm_year = year - 1900;
\r
502 timeInfo->tm_mon = month - 1;
\r
503 timeInfo->tm_mday = day;
\r
504 timeInfo->tm_hour = hour;
\r
505 timeInfo->tm_min = minute;
\r
506 timeInfo->tm_sec = second;
\r
508 time_t seconds = mktime(timeInfo);
\r
509 SysTryReturnResult(NID_CNT, seconds != -1, E_INVALID_ARG, "Failed to convert DateTime to broken-down time.");
\r
511 long long ticksInSeconds = (long long)seconds;
\r
513 r = inputExpr.Append(ticksInSeconds);
\r
514 SysTryReturnResult(NID_CNT, r == E_SUCCESS, r, "string append failed.");
\r
518 r = inputExpr.Append(token);
\r
519 SysTryReturnResult(NID_CNT, r == E_SUCCESS, r, "string append failed.");
\r
522 r = inputExpr.Append("'");
\r
523 SysTryReturnResult(NID_CNT, r == E_SUCCESS, r, "string append failed.");
\r
527 __inputExpr.Clear();
\r
528 r = __inputExpr.Insert(inputExpr, 0);
\r
529 SysTryReturnResult(NID_CNT, r == E_SUCCESS, r, "string insert failed.");
\r
534 // CONTENT_TYPE_OTHER and CONTENT_TYPE_IMAGE (0 - 13 ) are valid columns
\r
535 // CONTENT_TYPE_VIDEO (0 - 16 ) are valid columns
\r
536 // CONTENT_TYPE_ALL and CONTENT_TYPE_VIDEO (0 - 18 ) are valid columns
\r
537 // This functions checks for invalid column in the given input string (only allowed columns should be used by content type other wise
\r
538 // E_INVALID_ARG is returned)
\r
539 // StringTokenizer is used to parse input expression, by using delimater "'", to differentiate column and value.
\r
540 // As values may also contain column names
\r
541 // Ex: 1. where author = syam_author_01 2. where album = jalsa_album_name_01.
\r
544 _ContentSearchImpl::CheckInvalidColumnInQuery(void) const
\r
546 result r = E_SUCCESS;
\r
548 String delim = L"'"; //Delimeters is ' .
\r
549 bool isColReplaceReq = true;
\r
551 String inputExpr = __inputExpr;
\r
553 // Create a StringTokenizer instance
\r
554 StringTokenizer strTok(inputExpr, delim);
\r
558 while (strTok.HasMoreTokens())
\r
560 r = strTok.GetNextToken(token);
\r
561 SysTryReturnResult(NID_CNT, r == E_SUCCESS, E_SYSTEM, "strTok GetNextToken failed.");
\r
563 SysLog(NID_CNT, "In CheckInvalidColumnInQuery token[%d] = %ls", ++tokenNo, token.GetPointer());
\r
565 if (isColReplaceReq)
\r
567 isColReplaceReq = false;
\r
568 r = inputExpr.Append(token);
\r
569 SysTryReturnResult(NID_CNT, r == E_SUCCESS, E_SYSTEM, "string append failed.");
\r
571 switch (__contentType)
\r
573 case CONTENT_TYPE_OTHER:
\r
575 case CONTENT_TYPE_IMAGE:
\r
576 if ((token.Contains("TITLE")) || (token.Contains("ARTIST")) || (token.Contains("GENRE")))
\r
578 SysLog(NID_CNT, "Title or Artist or Genre are not valid cloumns for this content type");
\r
579 return E_INVALID_ARG;
\r
582 case CONTENT_TYPE_VIDEO:
\r
583 if ((token.Contains("COMPOSER")) || (token.Contains("ALBUM")))
\r
585 SysLog(NID_CNT, "Composer or Album are not valid cloumns for this content type");
\r
586 return E_INVALID_ARG;
\r
595 isColReplaceReq = true;
\r
596 r = inputExpr.Append("'");
\r
597 SysTryReturnResult(NID_CNT, r == E_SUCCESS, E_SYSTEM, "string append failed.");
\r
598 r = inputExpr.Append(token);
\r
599 SysTryReturnResult(NID_CNT, r == E_SUCCESS, E_SYSTEM, "string append failed.");
\r
600 r = inputExpr.Append("'");
\r
601 SysTryReturnResult(NID_CNT, r == E_SUCCESS, E_SYSTEM, "string append failed.");
\r
607 // It replaces osp column name with slp column name.
\r
608 // StringTokenizer is used to parse input expression, by using delimater "'", to differentiate column and value.
\r
609 // As values may also contain column names
\r
610 // Only column names are replaced but not values(values may contain column names)
\r
611 // Ex: 1. where author = syam_author_01 2. where album = jalsa_album_name_01.
\r
614 _ContentSearchImpl::ReplaceString(String ospColumnName, String slpColumnName) const
\r
616 String delim = L"'"; //Delimeters is ' .
\r
617 result r = E_SUCCESS;
\r
618 bool isColReplaceReq = true;
\r
620 String inputExpr = __inputExpr;
\r
622 // Create a StringTokenizer instance
\r
623 StringTokenizer strTok(inputExpr, delim);
\r
627 while (strTok.HasMoreTokens())
\r
629 r = strTok.GetNextToken(token); // Osp, StringTokenizer, Sample, code
\r
630 SysTryReturnResult(NID_CNT, r == E_SUCCESS, E_SYSTEM, "string GetNextToken() failed.");
\r
631 if (isColReplaceReq) //column name
\r
633 isColReplaceReq = false;
\r
634 r = token.Replace(ospColumnName, slpColumnName);
\r
635 SysTryReturnResult(NID_CNT, r == E_SUCCESS, E_SYSTEM, "string replace() failed.");
\r
636 r = inputExpr.Append(token);
\r
637 SysTryReturnResult(NID_CNT, r == E_SUCCESS, E_SYSTEM, "string append failed.");
\r
639 else // value of the column
\r
641 isColReplaceReq = true;
\r
642 r = inputExpr.Append("'");
\r
643 SysTryReturnResult(NID_CNT, r == E_SUCCESS, E_SYSTEM, "string append failed.");
\r
644 r = inputExpr.Append(token);
\r
645 SysTryReturnResult(NID_CNT, r == E_SUCCESS, E_SYSTEM, "string append failed.");
\r
646 r = inputExpr.Append("'");
\r
647 SysTryReturnResult(NID_CNT, r == E_SUCCESS, E_SYSTEM, "string append failed.");
\r
650 __inputExpr.Clear();
\r
651 r = __inputExpr.Insert(inputExpr, 0);
\r
652 SysTryReturnResult(NID_CNT, r == E_SUCCESS, E_SYSTEM, "string insert() failed.");
\r
657 //Retuns list of search result for the given expression and content type.
\r
659 _ContentSearchImpl::SearchN(int pageNo, int countPerPage, int& totalPageCount, int& totalCount, const String& whereExpr, const String& sortColumn, SortOrder sortOrder) const
\r
661 SysLog(NID_CNT, "pageNo = %d, countPerPage = %d, whereExpr = %ls", pageNo, countPerPage, whereExpr.GetPointer());
\r
665 result r = E_SUCCESS;
\r
666 int ret = MEDIA_CONTENT_ERROR_NONE;
\r
669 __inputColumnName.Clear();
\r
670 __inputExpr.Clear();
\r
671 __inputColumnName = sortColumn;
\r
672 __inputSortOrder = sortOrder;
\r
673 totalPageCount = 0;
\r
676 if (!whereExpr.IsEmpty()) // copy whereExpr if not empty to class variable __inputExpr
\r
678 //r = __inputExpr.Format(QUERY_LENGTH, L"%ls", whereExpr.GetPointer());
\r
679 r = __inputExpr.Append(whereExpr);
\r
680 SysTryReturn(NID_CNT, r == E_SUCCESS, NULL, r, "[%s] __inputExpr.Append Failed as whereExpr is not empty.", GetErrorMessage(r));
\r
682 r = ReplaceOspColumnNameWithSlp();
\r
683 SysTryReturn(NID_CNT, r == E_SUCCESS, NULL, r, "[%s] ReplaceOspColumnNameWithSlp for InputExpr Failed.", GetErrorMessage(r));
\r
685 SysLog(NID_CNT, "After replace __inputExpr = %ls", __inputExpr.GetPointer());
\r
687 if ((__inputColumnName.IsEmpty()) && ((__inputSortOrder == SORT_ORDER_ASCENDING) || (__inputSortOrder == SORT_ORDER_DESCENDING)))
\r
689 SysLog(NID_CNT, "sort column name is empty and sort oder is not none. so,E_INVALID_ARG occured.");
\r
690 SetLastResult(E_INVALID_ARG);
\r
695 std::unique_ptr<ArrayList, AllElementsDeleter> pFinalOutList(new (std::nothrow) ArrayList());
\r
696 SysTryReturn(NID_CNT, pFinalOutList.get() != null, NULL, E_OUT_OF_MEMORY, "[E_OUT_OF_MEMORY] Failed to construct ArrayList.");
\r
698 r = pFinalOutList->Construct();
\r
699 SysTryReturn(NID_CNT, !IsFailed(r), NULL, r, "[%s] Failed to construct ArrayList.", GetErrorMessage(r));
\r
701 __pFinalOutList = std::move(pFinalOutList);
\r
703 r = CreateQueryFilter(true);
\r
704 SysTryReturn(NID_CNT, !IsFailed(r), NULL, r, "[%s] Failed to perform CreateQueryFilter operation.", GetErrorMessage(r));
\r
706 ret = media_info_get_media_count_from_db(*(__pFilterHandle.get()), &totalCount);
\r
707 r = MapCoreErrorToNativeResult(ret);
\r
708 SysTryReturn(NID_CNT, r == E_SUCCESS , NULL, r, "[%s] Failed to perform media_info_get_media_count_from_db operation.", GetErrorMessage(r));
\r
710 SysLog(NID_CNT, "totalCount is [%d] for media_info_get_media_count_from_db", totalCount);
\r
712 if (totalCount > 0)
\r
714 if ((totalCount % countPerPage) == 0)
\r
716 totalPageCount = totalCount / countPerPage;
\r
720 totalPageCount = (totalCount / countPerPage) + 1;
\r
723 SysTryReturn(NID_CNT, ((pageNo >= 1) && (pageNo <= totalPageCount)) , NULL, E_INVALID_ARG, "[E_INVALID_ARG] (pageNo < 1) || (pageNo > totalPageCount).");
\r
725 offset = (pageNo * countPerPage) - countPerPage;
\r
727 SysLog(NID_CNT, " SearchN totalCount [%d] totalPageCount[%d] __countPerPage[%d] __pageNo[%d] offset[%d]",
\r
728 totalCount, totalPageCount, countPerPage, pageNo, offset);
\r
730 ret = media_filter_set_offset(*(__pFilterHandle.get()), offset, countPerPage);
\r
731 r = MapCoreErrorToNativeResult(ret);
\r
732 SysTryReturn(NID_CNT, r == E_SUCCESS, NULL, r,
\r
733 "[%s] Failed to perform media_filter_set_offset operation.", GetErrorMessage(r));
\r
735 r = ExecuteAndFillFinalOutList();
\r
736 SysTryReturn(NID_CNT, r == E_SUCCESS, NULL, E_SYSTEM, "[E_SYSTEM] ExecuteAndFillFinalOutList Failed.");
\r
738 else if (pageNo > 1)
\r
741 SysTryReturn(NID_CNT, r == E_SUCCESS, NULL, r, "[E_INVALID_ARG] (pageNo > 1) and (totalcount = 0).");
\r
745 return __pFinalOutList.release();
\r
748 // Fills final result list
\r
750 _ContentSearchImpl::ExecuteAndFillFinalOutList(void) const
\r
752 SysLog(NID_CNT, "Enter\n");
\r
754 int ret = MEDIA_CONTENT_ERROR_NONE;
\r
755 result r = E_SUCCESS;
\r
757 std::unique_ptr<GList, SearchGListDeleter> pItemList;
\r
758 GList* pTemp = NULL;
\r
759 std::unique_ptr<media_info_s, SearchMediaHandleDeleter> pMediaHandle;
\r
761 ContentInfo::_ContentData* pContentData = null;
\r
762 ImageContentInfo::_ImageContentData* pImageContentData = null;
\r
763 AudioContentInfo::_AudioContentData* pAudioContentData = null;
\r
764 VideoContentInfo::_VideoContentData* pVideoContentData = null;
\r
766 std::unique_ptr<ImageContentInfo> pImageContentInfo;
\r
767 std::unique_ptr<AudioContentInfo> pAudioContentInfo;
\r
768 std::unique_ptr<VideoContentInfo> pVideoContentInfo;
\r
769 std::unique_ptr<OtherContentInfo> pOtherContentInfo;
\r
771 std::unique_ptr<ContentSearchResult> pContentSearchResult;
\r
773 pTemp = pItemList.get();
\r
775 ret = media_info_foreach_media_from_db(*(__pFilterHandle.get()), MediaItemCb, &pTemp);
\r
776 r = MapCoreErrorToNativeResult(ret);
\r
777 SysTryReturnResult(NID_CNT, r == E_SUCCESS, r, "Failed to perform media_info_foreach_media_from_db operation.");
\r
779 SysTryReturnResult(NID_CNT, pTemp != NULL, r, "media_info_foreach_media_from_db pTemp is null.");
\r
781 media_content_type_e mediaType = MEDIA_CONTENT_TYPE_OTHERS;
\r
783 for (int idx = 0; idx < (int)g_list_length(pTemp); idx++)
\r
785 pMediaHandle.reset(static_cast<media_info_h>(g_list_nth_data(pTemp, idx)));
\r
787 ret = media_info_get_media_type(pMediaHandle.get(), &mediaType);
\r
788 r = MapCoreErrorToNativeResult(ret);
\r
789 SysTryReturnResult(NID_CNT, !IsFailed(r), r, "Failed to perform media_info_get_media_type.");
\r
793 case MEDIA_CONTENT_TYPE_OTHERS:
\r
794 //memset(&contentData, 0, sizeof(contentData));
\r
796 pOtherContentInfo = std::unique_ptr<OtherContentInfo>(new (std::nothrow) OtherContentInfo);
\r
797 SysTryReturnResult(NID_CNT, pOtherContentInfo.get() != null, E_OUT_OF_MEMORY, "Failed to create pOtherContentInfo.");
\r
799 pContentData = pOtherContentInfo->GetContentData();
\r
800 SysTryReturnResult(NID_CNT, pContentData != null, E_OUT_OF_MEMORY, "The memory is insufficient.");
\r
802 r = _ContentUtility::FillContentData(pMediaHandle.get(), pContentData);
\r
803 SysTryReturnResult(NID_CNT, !IsFailed(r), r, "Failed to perform FillContentData operation.");
\r
806 pContentSearchResult = std::unique_ptr<ContentSearchResult>(new (std::nothrow) ContentSearchResult);
\r
807 SysTryReturnResult(NID_CNT, pContentSearchResult.get() != null, E_OUT_OF_MEMORY, "Failed to create pContentSearchResult.");
\r
809 pContentSearchResult->SetContentType(CONTENT_TYPE_OTHER);
\r
810 pContentSearchResult->SetContentInfo(pOtherContentInfo.release());
\r
812 // Shallow copy, adds just the pointer: not the element
\r
814 r = __pFinalOutList->Add(*(pContentSearchResult.release()));
\r
815 SysTryReturnResult(NID_CNT, !IsFailed(r), r, "Failed to perform Add operation for ArrayList.");
\r
817 //pOtherContentInfo = null;
\r
818 //pContentSearchResult = null;
\r
819 //_ContentUtility::DeleteContentData(&contentData);
\r
821 case MEDIA_CONTENT_TYPE_IMAGE:
\r
822 //memset(&contentData, 0, sizeof(contentData));
\r
823 //memset(&imageContentData, 0, sizeof(imageContentData));
\r
825 pImageContentInfo = std::unique_ptr<ImageContentInfo>(new (std::nothrow) ImageContentInfo);
\r
826 SysTryReturnResult(NID_CNT, pImageContentInfo.get() != null, E_OUT_OF_MEMORY, "Failed to create pImageContentInfo.");
\r
828 pContentData = pImageContentInfo->GetContentData();
\r
829 SysTryReturnResult(NID_CNT, pContentData != null, E_OUT_OF_MEMORY, "The memory is insufficient.");
\r
831 pImageContentData = pImageContentInfo->GetImageContentData();
\r
832 SysTryReturnResult(NID_CNT, pImageContentData != null, E_OUT_OF_MEMORY, "The memory is insufficient.");
\r
834 r = _ContentUtility::FillContentData(pMediaHandle.get(), pContentData);
\r
835 SysTryReturnResult(NID_CNT, !IsFailed(r), r, "Failed to perform FillContentData operation.");
\r
837 r = _ContentUtility::FillImageContentData(pMediaHandle.get(), pImageContentData);
\r
838 SysTryReturnResult(NID_CNT, !IsFailed(r), r, "Failed to perform GetDataFromImageTable operation.");
\r
840 pContentSearchResult = std::unique_ptr<ContentSearchResult>(new (std::nothrow) ContentSearchResult);
\r
841 SysTryReturnResult(NID_CNT, pContentSearchResult.get() != null, E_OUT_OF_MEMORY, "Failed to create pContentSearchResult.");
\r
843 pContentSearchResult->SetContentType(CONTENT_TYPE_IMAGE);
\r
844 pContentSearchResult->SetContentInfo(pImageContentInfo.release());
\r
846 // Shallow copy, adds just the pointer: not the element
\r
848 r = __pFinalOutList->Add(*(pContentSearchResult.release()));
\r
849 SysTryReturnResult(NID_CNT, !IsFailed(r), r, "Failed to perform Add operation for ArrayList.");
\r
850 //pImageContentInfo = null;
\r
851 //pContentSearchResult = null;
\r
852 //_ContentUtility::DeleteContentData(&contentData);
\r
854 case MEDIA_CONTENT_TYPE_MUSIC:
\r
856 case MEDIA_CONTENT_TYPE_SOUND:
\r
857 //memset(&contentData, 0, sizeof(contentData));
\r
858 //memset(&audioContentData, 0, sizeof(audioContentData));
\r
860 pAudioContentInfo = std::unique_ptr<AudioContentInfo>(new (std::nothrow) AudioContentInfo);
\r
861 SysTryReturnResult(NID_CNT, pAudioContentInfo.get() != null, E_OUT_OF_MEMORY, "Failed to create pAudioContentInfo.");
\r
863 pContentData = pAudioContentInfo->GetContentData();
\r
864 SysTryReturnResult(NID_CNT, pContentData != null, E_OUT_OF_MEMORY, "The memory is insufficient.");
\r
866 pAudioContentData = pAudioContentInfo->GetAudioContentData();
\r
867 SysTryReturnResult(NID_CNT, pAudioContentData != null, E_OUT_OF_MEMORY, "The memory is insufficient.");
\r
869 r = _ContentUtility::FillContentData(pMediaHandle.get(), pContentData);
\r
870 SysTryReturnResult(NID_CNT, !IsFailed(r), r, "Failed to perform FillContentData operation.");
\r
872 r = _ContentUtility::FillAudioContentData(pMediaHandle.get(), pAudioContentData);
\r
873 SysTryReturnResult(NID_CNT, !IsFailed(r), r, "Failed to perform FillAudioContentData operation.");
\r
875 pContentSearchResult = std::unique_ptr<ContentSearchResult>(new (std::nothrow) ContentSearchResult);
\r
876 SysTryReturnResult(NID_CNT, pContentSearchResult.get() != null, E_OUT_OF_MEMORY, "Failed to create pContentSearchResult.");
\r
878 pContentSearchResult->SetContentType(CONTENT_TYPE_AUDIO);
\r
879 pContentSearchResult->SetContentInfo(pAudioContentInfo.release());
\r
881 // Shallow copy, adds just the pointer: not the element
\r
883 r = __pFinalOutList->Add(*(pContentSearchResult.release()));
\r
884 SysTryReturnResult(NID_CNT, !IsFailed(r), r, "Failed to perform Add operation for ArrayList.");
\r
886 //pAudioContentInfo = null;
\r
887 //pContentSearchResult = null;
\r
888 //_ContentUtility::DeleteContentData(&contentData);
\r
889 //_ContentUtility::DeleteAudioContentData(&audioContentData);
\r
891 case MEDIA_CONTENT_TYPE_VIDEO:
\r
892 //memset(&contentData, 0, sizeof(contentData));
\r
893 //memset(&videoContentData, 0, sizeof(videoContentData));
\r
895 pVideoContentInfo = std::unique_ptr<VideoContentInfo>(new (std::nothrow) VideoContentInfo);
\r
896 SysTryReturnResult(NID_CNT, pVideoContentInfo.get() != null, E_OUT_OF_MEMORY, "Failed to create pVideoContentInfo.");
\r
898 pContentData = pVideoContentInfo->GetContentData();
\r
899 SysTryReturnResult(NID_CNT, pContentData != null, E_OUT_OF_MEMORY, "The memory is insufficient.");
\r
901 pVideoContentData = pVideoContentInfo->GetVideoContentData();
\r
902 SysTryReturnResult(NID_CNT, pVideoContentData != null, E_OUT_OF_MEMORY, "The memory is insufficient.");
\r
904 r = _ContentUtility::FillContentData(pMediaHandle.get(), pContentData);
\r
905 SysTryReturnResult(NID_CNT, !IsFailed(r), r, "Failed to perform FillContentData operation.");
\r
907 r = _ContentUtility::FillVideoContentData(pMediaHandle.get(), pVideoContentData);
\r
908 SysTryReturnResult(NID_CNT, !IsFailed(r), r, "Failed to perform FillVideoContentData operation.");
\r
910 pContentSearchResult = std::unique_ptr<ContentSearchResult>(new (std::nothrow) ContentSearchResult);
\r
911 SysTryReturnResult(NID_CNT, pContentSearchResult.get() != null, E_OUT_OF_MEMORY, "Failed to create pContentSearchResult.");
\r
913 pContentSearchResult->SetContentType(CONTENT_TYPE_VIDEO);
\r
914 pContentSearchResult->SetContentInfo(pVideoContentInfo.release());
\r
916 // Shallow copy, adds just the pointer: not the element
\r
918 r = __pFinalOutList->Add(*(pContentSearchResult.release()));
\r
919 SysTryReturnResult(NID_CNT, !IsFailed(r), r, "Failed to perform Add operation for ArrayList.");
\r
921 //pVideoContentInfo = null;
\r
922 //pContentSearchResult = null;
\r
923 //_ContentUtility::DeleteContentData(&contentData);
\r
924 //_ContentUtility::DeleteVideoContentData(&videoContentData);
\r
933 // returns given column value list in the requested order
\r
935 _ContentSearchImpl::GetValueListN(const String& sortColumn, SortOrder sortOrder)
\r
937 SysLog(NID_CNT, "inputColumn = %ls", sortColumn.GetPointer());
\r
940 result r = E_SUCCESS;
\r
944 __inputColumnName.Clear();
\r
945 __inputExpr.Clear();
\r
947 __inputColumnName = sortColumn;
\r
948 __inputSortOrder = sortOrder;
\r
950 String ospColumnName(L"");
\r
951 String slpColumnName(L"");
\r
953 String columnName(__inputColumnName);
\r
955 if ((__inputColumnName.IsEmpty()) && ((__inputSortOrder == SORT_ORDER_ASCENDING) || (__inputSortOrder == SORT_ORDER_DESCENDING)))
\r
957 SysLog(NID_CNT, "sort column name is empty and sort oder is not none. so,E_INVALID_ARG occured.");
\r
958 SetLastResult(E_INVALID_ARG);
\r
963 std::unique_ptr<ArrayList, AllElementsDeleter> pFinalOutList(new (std::nothrow) ArrayList());
\r
964 SysTryReturn(NID_CNT, pFinalOutList.get() != null, NULL, E_OUT_OF_MEMORY, "[E_OUT_OF_MEMORY] Failed to construct ArrayList.");
\r
966 r = pFinalOutList->Construct();
\r
967 SysTryReturn(NID_CNT, !IsFailed(r), NULL, E_OUT_OF_MEMORY, "[E_OUT_OF_MEMORY] Failed to construct ArrayList.");
\r
969 __pFinalOutList = std::move(pFinalOutList);
\r
971 switch (__contentType)
\r
973 case CONTENT_TYPE_OTHER:
\r
975 case CONTENT_TYPE_IMAGE:
\r
976 maxCols = MAX_QUERY_COLUMNS_FOR_IMAGE_OTHERS;
\r
978 case CONTENT_TYPE_VIDEO:
\r
979 maxCols = MAX_QUERY_COLUMNS_FOR_VIDEO;
\r
981 case CONTENT_TYPE_AUDIO:
\r
983 case CONTENT_TYPE_ALL:
\r
984 maxCols = MAX_QUERY_COLUMNS;
\r
990 for (colIndex = 0; colIndex < maxCols; colIndex++)
\r
992 ospColumnName.Clear();
\r
993 slpColumnName.Clear();
\r
995 ospColumnName = dbfieldinfo[colIndex].dbFieldOspName ;
\r
996 slpColumnName = dbfieldinfo[colIndex].dbFieldSlpName ;
\r
998 ospColumnName.ToUpper();
\r
999 columnName.ToUpper();
\r
1000 if (columnName == ospColumnName)
\r
1002 r = FillColumnsList(colIndex);
\r
1003 SysTryReturn(NID_CNT, r == E_SUCCESS, NULL, r, "[%s] FillColumnsList Failed.", GetErrorMessage(r));
\r
1007 if (colIndex == maxCols)
\r
1009 r = E_INVALID_ARG;
\r
1010 SysTryReturn(NID_CNT, r == E_SUCCESS, NULL, r, "[E_INVALID_ARG] invalid column.");
\r
1014 return __pFinalOutList.release();
\r
1017 // returns given column value list in the requested order
\r
1018 Collection::IList*
\r
1019 _ContentSearchImpl::GetValueListN(int pageNo, int countPerPage, int& totalPageCount, int& totalCount, const String& sortColumn, SortOrder sortOrder) const
\r
1021 SysLog(NID_CNT, "pageNo = %d, countPerPage = %d, inputColumn = %ls", pageNo, countPerPage, sortColumn.GetPointer());
\r
1023 ClearLastResult();
\r
1025 result r = E_SUCCESS;
\r
1029 __inputColumnName.Clear();
\r
1030 __inputExpr.Clear();
\r
1032 __inputColumnName = sortColumn;
\r
1033 __inputSortOrder = sortOrder;
\r
1035 String ospColumnName(L"");
\r
1036 String slpColumnName(L"");
\r
1038 String columnName(__inputColumnName);
\r
1040 if ((__inputColumnName.IsEmpty()) && ((__inputSortOrder == SORT_ORDER_ASCENDING) || (__inputSortOrder == SORT_ORDER_DESCENDING)))
\r
1042 SysLog(NID_CNT, "sort column name is empty and sort oder is not none. so,E_INVALID_ARG occured.");
\r
1043 SetLastResult(E_INVALID_ARG);
\r
1048 std::unique_ptr<ArrayList, AllElementsDeleter> pFinalOutList(new (std::nothrow) ArrayList());
\r
1049 SysTryReturn(NID_CNT, pFinalOutList.get() != null, NULL, E_OUT_OF_MEMORY, "[E_OUT_OF_MEMORY] Failed to construct ArrayList.");
\r
1051 r = pFinalOutList->Construct();
\r
1052 SysTryReturn(NID_CNT, !IsFailed(r), NULL, r, "[%s] Failed to construct ArrayList.", GetErrorMessage(r));
\r
1054 __pFinalOutList = std::move(pFinalOutList);
\r
1056 switch (__contentType)
\r
1058 case CONTENT_TYPE_OTHER:
\r
1060 case CONTENT_TYPE_IMAGE:
\r
1061 maxCols = MAX_QUERY_COLUMNS_FOR_IMAGE_OTHERS;
\r
1063 case CONTENT_TYPE_VIDEO:
\r
1064 maxCols = MAX_QUERY_COLUMNS_FOR_VIDEO;
\r
1066 case CONTENT_TYPE_AUDIO:
\r
1068 case CONTENT_TYPE_ALL:
\r
1069 maxCols = MAX_QUERY_COLUMNS;
\r
1075 for (colIndex = 0; colIndex < maxCols; colIndex++)
\r
1077 ospColumnName.Clear();
\r
1078 slpColumnName.Clear();
\r
1080 ospColumnName = dbfieldinfo[colIndex].dbFieldOspName ;
\r
1081 slpColumnName = dbfieldinfo[colIndex].dbFieldSlpName ;
\r
1083 ospColumnName.ToUpper();
\r
1084 columnName.ToUpper();
\r
1085 if (columnName == ospColumnName)
\r
1087 r = FillColumnsList(pageNo, countPerPage, totalPageCount, totalCount, colIndex);
\r
1088 SysTryReturn(NID_CNT, r == E_SUCCESS, NULL, r, "[%s] FillColumnsList Failed.", GetErrorMessage(r));
\r
1092 if (colIndex == maxCols)
\r
1094 r = E_INVALID_ARG;
\r
1095 SysTryReturn(NID_CNT, r == E_SUCCESS, NULL, r, "[E_INVALID_ARG] invalid column.");
\r
1099 return __pFinalOutList.release();
\r
1102 // prepares query expression to be used in group api. colIndex is mapped to actual group value.
\r
1104 _ContentSearchImpl::GetIndexAndCreateQueryExp(int colIndex) const
\r
1106 media_group_e groupIndex = MEDIA_CONTENT_GROUP_DISPLAY_NAME;;
\r
1109 case 0://"ContentType", "MEDIA_TYPE"
\r
1110 groupIndex = MEDIA_CONTENT_GROUP_TYPE;
\r
1111 __inputExpr = "MEDIA_TYPE IS NOT NULL";
\r
1113 case 1://"ContentFileName", "MEDIA_DISPLAY_NAME"
\r
1114 groupIndex = MEDIA_CONTENT_GROUP_DISPLAY_NAME;
\r
1115 __inputExpr = "MEDIA_DISPLAY_NAME IS NOT NULL";
\r
1117 case 2://"ContentName", "MEDIA_CONTENT_NAME"
\r
1118 groupIndex = MEDIA_CONTENT_GROUP_CONTENT_NAME;
\r
1119 __inputExpr = "MEDIA_CONTENT_NAME IS NOT NULL";
\r
1121 case 3://"Category", "MEDIA_CATEGORY"
\r
1122 groupIndex = MEDIA_CONTENT_GROUP_CATEGORY;
\r
1123 __inputExpr = "MEDIA_CATEGORY IS NOT NULL";
\r
1125 case 4://"Author", "MEDIA_AUTHOR"
\r
1126 groupIndex = MEDIA_CONTENT_GROUP_AUTHOR;
\r
1127 __inputExpr = "MEDIA_AUTHOR IS NOT NULL";
\r
1129 case 5://"keyword", "MEDIA_KEYWORD"
\r
1130 groupIndex = MEDIA_CONTENT_GROUP_KEYWORD;
\r
1131 __inputExpr = "MEDIA_KEYWORD IS NOT NULL";
\r
1133 case 6://"Provider", "MEDIA_PROVIDER"
\r
1134 groupIndex = MEDIA_CONTENT_GROUP_PROVIDER;
\r
1135 __inputExpr = "MEDIA_PROVIDER IS NOT NULL";
\r
1137 case 7://"Rating", "MEDIA_AGE_RATING"
\r
1138 groupIndex = MEDIA_CONTENT_GROUP_AGE_RATING;
\r
1139 __inputExpr = "MEDIA_AGE_RATING IS NOT NULL";
\r
1141 case 8://"LocationTag", "MEDIA_LOCATION_TAG"
\r
1142 groupIndex = MEDIA_CONTENT_GROUP_LOCATION_TAG;
\r
1143 __inputExpr = "MEDIA_LOCATION_TAG IS NOT NULL";
\r
1145 case 9://"ContentSize", "MEDIA_SIZE"
\r
1146 groupIndex = MEDIA_CONTENT_GROUP_SIZE;
\r
1147 __inputExpr = "MEDIA_SIZE IS NOT NULL";
\r
1149 case 10://"DateTime", "MEDIA_ADDED_TIME"
\r
1150 groupIndex = MEDIA_CONTENT_GROUP_ADDED_TIME;
\r
1151 __inputExpr = "MEDIA_ADDED_TIME IS NOT NULL";
\r
1153 case 11://"Latitude", "MEDIA_LATITUDE"
\r
1154 groupIndex = MEDIA_CONTENT_GROUP_LATITUDE;
\r
1155 __inputExpr = "MEDIA_LATITUDE IS NOT NULL";
\r
1157 case 12://"Longitude", "MEDIA_LONGITUDE"
\r
1158 groupIndex = MEDIA_CONTENT_GROUP_LONGITUDE;
\r
1159 __inputExpr = "MEDIA_LONGITUDE IS NOT NULL";
\r
1161 case 13://"Altitude", "MEDIA_ALTITUDE"
\r
1162 groupIndex = MEDIA_CONTENT_GROUP_ALTITUDE;
\r
1163 __inputExpr = "MEDIA_ALTITUDE IS NOT NULL";
\r
1165 case 14://"Title", "MEDIA_TITLE"
\r
1166 groupIndex = MEDIA_CONTENT_GROUP_TITLE;
\r
1167 __inputExpr = "MEDIA_TITLE IS NOT NULL";
\r
1169 case 15://"Artist", "MEDIA_ARTIST"
\r
1170 groupIndex = MEDIA_CONTENT_GROUP_ARTIST;
\r
1171 __inputExpr = "MEDIA_ARTIST IS NOT NULL";
\r
1173 case 16://"Genre", "MEDIA_GENRE"
\r
1174 groupIndex = MEDIA_CONTENT_GROUP_GENRE;
\r
1175 __inputExpr = "MEDIA_GENRE IS NOT NULL";
\r
1177 case 17://"Year", "MEDIA_YEAR"
\r
1178 groupIndex = MEDIA_CONTENT_GROUP_YEAR;
\r
1179 __inputExpr = "MEDIA_YEAR IS NOT NULL";
\r
1181 case 18://"Composer", "MEDIA_COMPOSER"
\r
1182 groupIndex = MEDIA_CONTENT_GROUP_COMPOSER;
\r
1183 __inputExpr = "MEDIA_COMPOSER IS NOT NULL";
\r
1185 case 19://"Album", "MEDIA_ALBUM"
\r
1186 __inputExpr = "MEDIA_ALBUM IS NOT NULL";
\r
1191 return groupIndex;
\r
1194 // Fills given column value list and destroys filter handle
\r
1196 _ContentSearchImpl::FillColumnsList(int colIndex) const
\r
1198 result r = E_SUCCESS;
\r
1199 int ret = MEDIA_CONTENT_ERROR_NONE;
\r
1200 int totalCount = 0;
\r
1201 media_group_e groupIndex = GetIndexAndCreateQueryExp(colIndex);
\r
1203 r = CreateQueryFilter(true);
\r
1204 SysTryReturnResult(NID_CNT, !IsFailed(r), r, "CreateQueryFilter Failed.");
\r
1206 if (colIndex == ALBUM_COLUMN_NUM)
\r
1208 ret = media_album_get_album_count_from_db(*(__pFilterHandle.get()), &totalCount);
\r
1212 ret = media_group_get_group_count_from_db(*(__pFilterHandle.get()), groupIndex, &totalCount);
\r
1214 r = MapCoreErrorToNativeResult(ret);
\r
1215 SysTryReturnResult(NID_CNT, ret == MEDIA_CONTENT_ERROR_NONE, r, "Failed to perform media_album/group count_from_db operation.");
\r
1217 SysLog(NID_CNT, "totalCount = %d for media_album/group count_from_db", totalCount);
\r
1219 if (totalCount > 0)
\r
1221 if (colIndex == ALBUM_COLUMN_NUM)
\r
1223 r = ExecuteAndFillAlbumValues();
\r
1224 SysTryReturnResult(NID_CNT, !IsFailed(r), r, "ExecuteAndFillAlbumValues Failed.");
\r
1228 r = ExecuteAndFillGetValueListN(groupIndex, colIndex);
\r
1229 SysTryReturnResult(NID_CNT, !IsFailed(r), r, "ExecuteAndFillGetValueListN Failed.");
\r
1235 // prepares input expression to be sent for create filter and fills given column value list
\r
1237 _ContentSearchImpl::FillColumnsList(int pageNo, int countPerPage, int& totalPageCount, int& totalCount, int colIndex) const
\r
1239 result r = E_SUCCESS;
\r
1240 int ret = MEDIA_CONTENT_ERROR_NONE;
\r
1242 totalPageCount = 0;
\r
1244 media_group_e groupIndex = GetIndexAndCreateQueryExp(colIndex);
\r
1246 r = CreateQueryFilter(true);
\r
1247 SysTryReturnResult(NID_CNT, !IsFailed(r), r, "CreateQueryFilter Failed.");
\r
1249 if (colIndex == ALBUM_COLUMN_NUM)
\r
1251 ret = media_album_get_album_count_from_db(*(__pFilterHandle.get()), &totalCount);
\r
1255 ret = media_group_get_group_count_from_db(*(__pFilterHandle.get()), groupIndex, &totalCount);
\r
1257 r = MapCoreErrorToNativeResult(ret);
\r
1258 SysTryReturnResult(NID_CNT, ret == MEDIA_CONTENT_ERROR_NONE, r, "Failed to perform media_album/group count_from_db operation.");
\r
1260 SysLog(NID_CNT, "totalCount = %d for media_album/group count_from_db", totalCount);
\r
1262 if (totalCount > 0)
\r
1264 if ((totalCount % countPerPage) == 0)
\r
1266 totalPageCount = totalCount / countPerPage;
\r
1270 totalPageCount = (totalCount / countPerPage) + 1;
\r
1273 if ((pageNo < 1) || (pageNo > totalPageCount))
\r
1275 r = E_INVALID_ARG;
\r
1276 SysTryReturnResult(NID_CNT, !IsFailed(r), r, "(pageNo < 1) || (pageNo > totalPageCount).");
\r
1279 offset = (pageNo * countPerPage) - countPerPage;
\r
1281 SysLog(NID_CNT, "GetValueListN totalCount [%d] totalPageCount[%d] __countPerPage[%d] __pageNo[%d] offset[%d]",
\r
1282 totalCount, totalPageCount, countPerPage, pageNo, offset);
\r
1284 ret = media_filter_set_offset(*(__pFilterHandle.get()),offset,countPerPage);
\r
1285 r = MapCoreErrorToNativeResult(ret);
\r
1286 SysTryReturnResult(NID_CNT, ret == MEDIA_CONTENT_ERROR_NONE, r, "failed to perform media_filter_set_offset operation.");
\r
1288 if (colIndex == ALBUM_COLUMN_NUM)
\r
1290 r = ExecuteAndFillAlbumValues();
\r
1291 SysTryReturnResult(NID_CNT, !IsFailed(r), r, "ExecuteAndFillAlbumValues Failed.");
\r
1295 r = ExecuteAndFillGetValueListN(groupIndex, colIndex);
\r
1296 SysTryReturnResult(NID_CNT, !IsFailed(r), r, "ExecuteAndFillGetValueListN Failed.");
\r
1300 else if (pageNo > 1)
\r
1302 r = E_INVALID_ARG;
\r
1303 SysTryReturnResult(NID_CNT, !IsFailed(r), r, "(pageNo > 1) and (totalcount = 0).");
\r
1309 // fills given column value list for GetValuelistN api
\r
1311 _ContentSearchImpl::ExecuteAndFillGetValueListN(media_group_e groupIndex, int colIndex) const
\r
1313 SysLog(NID_CNT, "Enter\n");
\r
1315 int ret = MEDIA_CONTENT_ERROR_NONE;
\r
1316 result r = E_SUCCESS;
\r
1317 result res = E_SUCCESS;
\r
1318 std::unique_ptr<GList, SearchGListDeleter> pItemList;
\r
1319 GList* pTemp = NULL;
\r
1321 std::unique_ptr<Object> pValue;
\r
1323 DateTime dateTime;
\r
1325 long long contentSize = 0;
\r
1326 long long addedTime = 0;
\r
1329 char *pColumnVal = null;
\r
1330 int contentType = 0;
\r
1332 pTemp = pItemList.get();
\r
1334 ret = media_group_foreach_group_from_db(*(__pFilterHandle.get()), groupIndex, GroupItemCb, &pTemp);
\r
1335 r = MapCoreErrorToNativeResult(ret);
\r
1336 SysTryReturnResult(NID_CNT, r == E_SUCCESS, r, "Failed to perform media_group_foreach_group_from_db operation.");
\r
1338 SysTryReturnResult(NID_CNT, pTemp != NULL, r, "media_info_foreach_media_from_db pTemp is null.");
\r
1340 for (int idx = 0; idx < (int)g_list_length(pTemp); idx++)
\r
1342 SysLog(NID_CNT, "idx = %d and (int)g_list_length(pItemList) = %d", idx, (int)g_list_length(pTemp));
\r
1344 pColumnVal = (char *)g_list_nth_data(pTemp, idx);
\r
1346 String strColVal(pColumnVal);
\r
1348 _ContentUtility::DoSafeFree(pColumnVal);
\r
1350 SysLog(NID_CNT, "pColumnVal = %ls", strColVal.GetPointer());
\r
1354 case 0://"ContentType", "MEDIA_TYPE"
\r
1355 if ((strColVal.CompareTo(L"Unknown") != 0) && (!strColVal.IsEmpty()))
\r
1357 res = Integer::Parse(strColVal, contentType);
\r
1358 SysTryLog(NID_CNT, res == E_SUCCESS, "[%s] Integer parse failed.", GetErrorMessage(res));
\r
1360 switch ((media_content_type_e)contentType)
\r
1362 case MEDIA_CONTENT_TYPE_OTHERS:
\r
1363 pValue.reset(new (std::nothrow) String(CONTENT_TYPE_OTHER));
\r
1364 SysLog(NID_CNT, "mediaType = CONTENT_TYPE_OTHER");
\r
1366 case MEDIA_CONTENT_TYPE_IMAGE:
\r
1367 pValue.reset(new (std::nothrow) String(CONTENT_TYPE_IMAGE));
\r
1368 SysLog(NID_CNT, "mediaType = CONTENT_TYPE_IMAGE");
\r
1370 case MEDIA_CONTENT_TYPE_SOUND:
\r
1372 case MEDIA_CONTENT_TYPE_MUSIC:
\r
1373 pValue.reset(new (std::nothrow) String(CONTENT_TYPE_AUDIO));
\r
1374 SysLog(NID_CNT, "mediaType = CONTENT_TYPE_AUDIO");
\r
1376 case MEDIA_CONTENT_TYPE_VIDEO:
\r
1377 pValue.reset(new (std::nothrow) String(CONTENT_TYPE_VIDEO));
\r
1378 SysLog(NID_CNT, "mediaType = CONTENT_TYPE_VIDEO");
\r
1384 case 1://"ContentFileName", "MEDIA_DISPLAY_NAME"
\r
1386 case 2://"ContentName", "MEDIA_CONTENT_NAME"
\r
1388 case 3://"Category", "MEDIA_CATEGORY"
\r
1390 case 4://"Author", "MEDIA_AUTHOR"
\r
1392 case 5://"keyword", "MEDIA_KEYWORD"
\r
1394 case 6://"Provider", "MEDIA_PROVIDER"
\r
1396 case 7://"Rating", "MEDIA_AGE_RATING"
\r
1398 case 8://"LocationTag", "MEDIA_LOCATION_TAG"
\r
1400 case 14://"Title", "MEDIA_TITLE"
\r
1402 case 15://"Artist", "MEDIA_ARTIST"
\r
1404 case 16://"Genre", "MEDIA_GENRE"
\r
1406 case 17://"Year", "MEDIA_YEAR"
\r
1408 case 18://"Composer", "MEDIA_COMPOSER"
\r
1410 pValue.reset(new (std::nothrow) String(strColVal));
\r
1413 case 9://"ContentSize", "MEDIA_SIZE"
\r
1414 if ((strColVal.CompareTo(L"Unknown") != 0) && (!strColVal.IsEmpty()))
\r
1416 res = LongLong::Parse(strColVal, contentSize);
\r
1417 SysTryLog(NID_CNT, res == E_SUCCESS, "[%s] LongLong parse failed.", GetErrorMessage(res));
\r
1420 pValue.reset(new (std::nothrow) LongLong(contentSize));
\r
1422 case 10://"DateTime", "MEDIA_ADDED_TIME"
\r
1423 if ((strColVal.CompareTo(L"Unknown") != 0) && (!strColVal.IsEmpty()))
\r
1425 res = LongLong::Parse(strColVal, addedTime);
\r
1426 SysTryLog(NID_CNT, res == E_SUCCESS, "[%s] LongLong parse failed.", GetErrorMessage(res));
\r
1429 res = dateTime.SetValue(1970, 1, 1);
\r
1430 SysTryLog(NID_CNT, res == E_SUCCESS, "[%s] dateTime.SetValue failed.", GetErrorMessage(res));
\r
1432 res = dateTime.AddSeconds(addedTime);
\r
1433 SysTryLog(NID_CNT, res == E_SUCCESS, "[%s] dateTime.AddSeconds failed.", GetErrorMessage(res));
\r
1435 SysLog(NID_CNT, "DateTime : %ls", dateTime.ToString().GetPointer());
\r
1437 pValue.reset(new (std::nothrow) DateTime(dateTime));
\r
1440 case 11://"Latitude", "MEDIA_LATITUDE"
\r
1442 case 12://"Longitude", "MEDIA_LONGITUDE"
\r
1444 case 13://"Altitude", "MEDIA_ALTITUDE"
\r
1445 if ((strColVal.CompareTo(L"Unknown") != 0) && (!strColVal.IsEmpty()))
\r
1447 res = Double::Parse(strColVal, dVal);
\r
1448 SysTryLog(NID_CNT, res == E_SUCCESS, "[%s] double parse failed.", GetErrorMessage(res));
\r
1450 pValue.reset(new (std::nothrow) Double(dVal));
\r
1453 case 19://"Album", "MEDIA_ALBUM"
\r
1458 if (pValue.get() != NULL)
\r
1460 r = __pFinalOutList->Add(*(pValue.release()));
\r
1461 SysTryReturnResult(NID_CNT, r == E_SUCCESS, r, "Failed to perform arraylist Add operation.");
\r
1469 _ContentSearchImpl::ExecuteAndFillAlbumValues(void) const
\r
1471 int ret = MEDIA_CONTENT_ERROR_NONE;
\r
1472 result r = E_SUCCESS;
\r
1473 std::unique_ptr<GList, SearchGListDeleter> pItemList;
\r
1474 GList* pTemp = NULL;
\r
1475 std::unique_ptr<media_album_s, AlbumHandleDeleter> pAlbumHandle;
\r
1477 Object* pValue = NULL;
\r
1478 char* __pAlbumName = NULL;
\r
1479 std::unique_ptr<char, CharDeleter> pAlbumName;
\r
1481 pTemp = pItemList.get();
\r
1483 ret = media_album_foreach_album_from_db(*(__pFilterHandle.get()), AlbumItemCb, &pTemp);
\r
1484 r = MapCoreErrorToNativeResult(ret);
\r
1485 SysTryReturnResult(NID_CNT, r == E_SUCCESS, r, "Failed to perform media_album_foreach_album_from_db operation.");
\r
1486 SysTryReturnResult(NID_CNT, pTemp != NULL, r, "media_info_foreach_media_from_db pTemp is null.");
\r
1488 for (int idx = 0; idx < (int)g_list_length(pTemp); idx++)
\r
1490 pAlbumHandle.reset(static_cast<media_album_h>(g_list_nth_data(pTemp, idx)));
\r
1491 ret = media_album_get_name(pAlbumHandle.get(), &__pAlbumName);
\r
1492 r = MapCoreErrorToNativeResult(ret);
\r
1493 SysTryReturnResult(NID_CNT, !IsFailed(r), r, "Failed to perform media_album_get_name.");
\r
1495 if (__pAlbumName != NULL)
\r
1497 SysLog(NID_CNT, "pColumnVal = %s", __pAlbumName);
\r
1499 pAlbumName.reset(__pAlbumName);
\r
1501 pValue = new (std::nothrow) String(pAlbumName.get());
\r
1502 SysTryReturnResult(NID_CNT, pValue != NULL, E_OUT_OF_MEMORY, "media_info_foreach_media_from_db pTemp is null.");
\r
1505 if (pValue != NULL)
\r
1507 r = __pFinalOutList->Add(*pValue);
\r
1508 SysTryReturnResult(NID_CNT, r == E_SUCCESS, r, "Failed to perform arraylist Add operation.");
\r
1517 _ContentSearchImpl::MapCoreErrorToNativeResult(int reason) const
\r
1519 result r = E_SUCCESS;
\r
1523 case MEDIA_CONTENT_ERROR_NONE:
\r
1527 case MEDIA_CONTENT_ERROR_INVALID_PARAMETER:
\r
1528 r = E_INVALID_ARG;
\r
1529 SysLog(NID_CNT, "MEDIA_CONTENT_ERROR_INVALID_PARAMETER");
\r
1532 case MEDIA_CONTENT_ERROR_DB_FAILED:
\r
1534 SysLog(NID_CNT, "MEDIA_CONTENT_ERROR_DB_FAILED");
\r
1537 case MEDIA_CONTENT_ERROR_OUT_OF_MEMORY:
\r
1538 r = E_OUT_OF_MEMORY;
\r
1539 SysLog(NID_CNT, "MEDIA_CONTENT_ERROR_OUT_OF_MEMORY");
\r
1543 SysLog(NID_CNT, "default");
\r
1550 //Callback function registered to each media info details
\r
1551 // all items are appened to the list
\r
1553 MediaItemCb(media_info_h media, void* pUserdata)
\r
1555 int ret = MEDIA_CONTENT_ERROR_NONE;
\r
1556 media_info_h new_media = NULL;
\r
1557 ret = media_info_clone(&new_media, media);
\r
1558 SysTryLog(NID_CNT, ret == MEDIA_CONTENT_ERROR_NONE, "[E_SYSTEM] Failed to perform media_info_clone");
\r
1560 GList** pList = (GList**)pUserdata;
\r
1561 *pList = g_list_append(*pList, new_media);
\r
1566 //Callback function registered for column values
\r
1567 // all items are appened to the list
\r
1569 GroupItemCb(const char* pGroupName, void* pUserdata)
\r
1571 char* pGrpName = strdup(pGroupName);
\r
1572 GList** pList = (GList**)pUserdata;
\r
1573 *pList = g_list_append(*pList, pGrpName);
\r
1578 //Callback function registered to each media info details
\r
1579 // all items are appened to the list
\r
1581 AlbumItemCb(media_album_h album, void* pUserdata)
\r
1583 int ret = MEDIA_CONTENT_ERROR_NONE;
\r
1584 media_album_h new_album = NULL;
\r
1585 ret = media_album_clone(&new_album, album);
\r
1586 SysTryLog(NID_CNT, ret == MEDIA_CONTENT_ERROR_NONE, "[E_SYSTEM] Failed to perform media_album_clone");
\r
1588 GList** pList = (GList**)pUserdata;
\r
1589 *pList = g_list_append(*pList, new_album);
\r