2 * Copyright (c) 2011 Samsung Electronics Co., Ltd All Rights Reserved
4 * Licensed under the Apache License, Version 2.0 (the "License");
5 * you may not use this file except in compliance with the License.
6 * You may obtain a copy of the License at
8 * http://www.apache.org/licenses/LICENSE-2.0
10 * Unless required by applicable law or agreed to in writing, software
11 * distributed under the License is distributed on an "AS IS" BASIS,
12 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
13 * See the License for the specific language governing permissions and
14 * limitations under the License.
18 #include <media_info_private.h>
19 #include <media_util_private.h>
22 static attribute_h g_attr_handle = NULL;
23 static attribute_h g_alias_attr_handle = NULL;
24 static MediaSvcHandle *db_handle = NULL;
25 static int ref_count = 0;
26 static GMutex db_mutex;
27 static uid_t content_g_uid = 0;
30 static int __media_content_create_attr_handle(void);
31 static int __media_content_create_alias_attr_handle(void);
32 static int __media_content_create_attribute_handle(void);
34 static int __media_content_create_attribute_handles(void);
35 static int __media_content_destroy_attribute_handle(void);
40 char *platform_alias_attr;
41 } media_content_attribute_info_s;
43 static media_content_attribute_info_s g_content_attrs_info[] = {
45 {MEDIA_ID, DB_FIELD_MEDIA_ID, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ID},
46 {MEDIA_PATH, DB_FIELD_MEDIA_PATH, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_PATH},
47 {MEDIA_DISPLAY_NAME, DB_FIELD_MEDIA_DISPLAY_NAME, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_DISPLAY_NAME},
48 {MEDIA_TYPE, DB_FIELD_MEDIA_TYPE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_TYPE},
49 {MEDIA_MIME_TYPE, DB_FIELD_MEDIA_MIME_TYPE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_MIME_TYPE},
50 {MEDIA_SIZE, DB_FIELD_MEDIA_SIZE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_SIZE},
51 {MEDIA_ADDED_TIME, DB_FIELD_MEDIA_ADDED_TIME, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ADDED_TIME},
52 {MEDIA_MODIFIED_TIME, DB_FIELD_MEDIA_MODIFIED_TIME, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_MODIFIED_TIME},
53 {MEDIA_TIMELINE, DB_FIELD_MEDIA_TIMELINE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_TIMELINE},
54 {MEDIA_THUMBNAIL_PATH, DB_FIELD_MEDIA_THUMBNAIL_PATH, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_THUMBNAIL_PATH},
55 {MEDIA_TITLE, DB_FIELD_MEDIA_TITLE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_TITLE},
56 {MEDIA_ALBUM, DB_FIELD_MEDIA_ALBUM, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ALBUM},
57 {MEDIA_ARTIST, DB_FIELD_MEDIA_ARTIST, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ARTIST},
58 {MEDIA_ALBUM_ARTIST, DB_FIELD_MEDIA_ALBUM_ARTIST, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ALBUM_ARTIST},
59 {MEDIA_GENRE, DB_FIELD_MEDIA_GENRE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_GENRE},
60 {MEDIA_COMPOSER, DB_FIELD_MEDIA_COMPOSER, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_COMPOSER},
61 {MEDIA_YEAR, DB_FIELD_MEDIA_YEAR, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_YEAR},
62 {MEDIA_RECORDED_DATE, DB_FIELD_MEDIA_RECORDED_DATE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_RECORDED_DATE},
63 {MEDIA_COPYRIGHT, DB_FIELD_MEDIA_COPYRIGHT, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_COPYRIGHT},
64 {MEDIA_TRACK_NUM, DB_FIELD_MEDIA_TRACK_NUM, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_TRACK_NUM},
65 {MEDIA_DESCRIPTION, DB_FIELD_MEDIA_DESCRIPTION, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_DESCRIPTION},
66 {MEDIA_BITRATE, DB_FIELD_MEDIA_BITRATE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_BITRATE},
67 {MEDIA_BITPERSAMPLE, DB_FIELD_MEDIA_BITPERSAMPLE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_BITPERSAMPLE},
68 {MEDIA_SAMPLERATE, DB_FIELD_MEDIA_SAMPLERATE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_SAMPLERATE},
69 {MEDIA_CHANNEL, DB_FIELD_MEDIA_CHANNEL, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_CHANNEL},
70 {MEDIA_DURATION, DB_FIELD_MEDIA_DURATION, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_DURATION},
71 {MEDIA_LONGITUDE, DB_FIELD_MEDIA_LONGITUDE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_LONGITUDE},
72 {MEDIA_LATITUDE, DB_FIELD_MEDIA_LATITUDE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_LATITUDE},
73 {MEDIA_ALTITUDE, DB_FIELD_MEDIA_ALTITUDE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ALTITUDE},
74 {MEDIA_WIDTH, DB_FIELD_MEDIA_WIDTH, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_WIDTH},
75 {MEDIA_HEIGHT, DB_FIELD_MEDIA_HEIGHT, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_HEIGHT},
76 {MEDIA_DATETAKEN, DB_FIELD_MEDIA_DATETAKEN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_DATETAKEN},
77 {MEDIA_ORIENTATION, DB_FIELD_MEDIA_ORIENTATION, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ORIENTATION},
78 {MEDIA_BURST_ID, DB_FIELD_MEDIA_BURST_ID, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_BURST_ID},
79 {MEDIA_PLAYED_COUNT, DB_FIELD_MEDIA_PLAYED_COUNT, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_PLAYED_COUNT},
80 {MEDIA_LAST_PLAYED_TIME, DB_FIELD_MEDIA_LAST_PLAYED_TIME, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_LAST_PLAYED_TIME},
81 {MEDIA_LAST_PLAYED_POSITION, DB_FIELD_MEDIA_LAST_PLAYED_POSITION, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_LAST_PLAYED_POSITION},
82 {MEDIA_RATING, DB_FIELD_MEDIA_RATING, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_RATING},
83 {MEDIA_FAVOURITE, DB_FIELD_MEDIA_FAVOURITE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_FAVOURITE},
84 {MEDIA_AUTHOR, DB_FIELD_MEDIA_AUTHOR, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_AUTHOR},
85 {MEDIA_PROVIDER, DB_FIELD_MEDIA_PROVIDER, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_PROVIDER},
86 {MEDIA_CONTENT_NAME, DB_FIELD_MEDIA_CONTENT_NAME, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_CONTENT_NAME},
87 {MEDIA_CATEGORY, DB_FIELD_MEDIA_CATEGORY, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_CATEGORY},
88 {MEDIA_LOCATION_TAG, DB_FIELD_MEDIA_LOCATION_TAG, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_LOCATION_TAG},
89 {MEDIA_AGE_RATING, DB_FIELD_MEDIA_AGE_RATING, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_AGE_RATING},
90 {MEDIA_KEYWORD, DB_FIELD_MEDIA_KEYWORD, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_KEYWORD},
91 {MEDIA_WEATHER, DB_FIELD_MEDIA_WEATHER, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_WEATHER},
92 {MEDIA_IS_DRM, DB_FIELD_MEDIA_IS_DRM, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_IS_DRM},
93 {MEDIA_STORAGE_TYPE, DB_FIELD_MEDIA_STORAGE_TYPE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_STORAGE_TYPE},
94 {MEDIA_360, DB_FIELD_MEDIA_360, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_360},
97 {MEDIA_FILE_NAME_PINYIN, DB_FIELD_MEDIA_FILE_NAME_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_FILE_NAME_PINYIN},
98 {MEDIA_TITLE_PINYIN, DB_FIELD_MEDIA_TITLE_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_TITLE_PINYIN},
99 {MEDIA_ALBUM_PINYIN, DB_FIELD_MEDIA_ALBUM_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ALBUM_PINYIN},
100 {MEDIA_ARTIST_PINYIN, DB_FIELD_MEDIA_ARTIST_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ARTIST_PINYIN},
101 {MEDIA_ALBUM_ARTIST_PINYIN, DB_FIELD_MEDIA_ALBUM_ARTIST_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ALBUM_ARTIST_PINYIN},
102 {MEDIA_GENRE_PINYIN, DB_FIELD_MEDIA_GENRE_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_GENRE_PINYIN},
103 {MEDIA_COMPOSER_PINYIN, DB_FIELD_MEDIA_COMPOSER_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_COMPOSER_PINYIN},
104 {MEDIA_COPYRIGHT_PINYIN, DB_FIELD_MEDIA_COPYRIGHT_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_COPYRIGHT_PINYIN},
105 {MEDIA_DESCRIPTION_PINYIN, DB_FIELD_MEDIA_DESCRIPTION_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_DESCRIPTION_PINYIN},
106 {MEDIA_AUTHOR_PINYIN, DB_FIELD_MEDIA_AUTHOR_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_AUTHOR_PINYIN},
107 {MEDIA_PROVIDER_PINYIN, DB_FIELD_MEDIA_PROVIDER_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_PROVIDER_PINYIN},
108 {MEDIA_CONTENT_NAME_PINYIN, DB_FIELD_MEDIA_CONTENT_NAME_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_CONTENT_NAME_PINYIN},
109 {MEDIA_CATEGORY_PINYIN, DB_FIELD_MEDIA_CATEGORY_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_CATEGORY_PINYIN},
110 {MEDIA_LOCATION_TAG_PINYIN, DB_FIELD_MEDIA_LOCATION_TAG_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_LOCATION_TAG_PINYIN},
111 {MEDIA_AGE_RATING_PINYIN, DB_FIELD_MEDIA_AGE_RATING_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_AGE_RATING_PINYIN},
112 {MEDIA_KEYWORD_PINYIN, DB_FIELD_MEDIA_KEYWORD_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_KEYWORD_PINYIN},
115 {FOLDER_ID, NULL, DB_TABLE_ALIAS_FOLDER"."DB_FIELD_FOLDER_ID},
116 {FOLDER_PATH, NULL, DB_TABLE_ALIAS_FOLDER"."DB_FIELD_FOLDER_PATH},
117 {FOLDER_NAME, NULL, DB_TABLE_ALIAS_FOLDER"."DB_FIELD_FOLDER_NAME},
118 {FOLDER_MODIFIED_TIME, NULL, DB_TABLE_ALIAS_FOLDER"."DB_FIELD_FOLDER_MODIFIED_TIME},
119 {FOLDER_STORAGE_TYPE, NULL, DB_TABLE_ALIAS_FOLDER"."DB_FIELD_FOLDER_STORAGE_TYPE},
120 {FOLDER_NAME_PINYIN, NULL, DB_TABLE_ALIAS_FOLDER"."DB_FIELD_FOLDER_NAME_PINYIN},
121 {FOLDER_ORDER, NULL, DB_TABLE_ALIAS_FOLDER"."DB_FIELD_FOLDER_ORDER},
124 {MEDIA_PLAYLIST_ID, DB_FIELD_PLAYLIST_ID, NULL},
125 {PLAYLIST_NAME, DB_FIELD_PLAYLIST_NAME, DB_TABLE_ALIAS_PLAYLIST"."DB_FIELD_PLAYLIST_NAME},
126 {PLAYLIST_MEMBER_ORDER, DB_FIELD_PLAYLIST_MEMBER_ORDER, DB_TABLE_ALIAS_PLAYLIST_MAP"."DB_FIELD_PLAYLIST_MEMBER_ORDER},
129 {PLAYLIST_MEDIA_COUNT, DB_FIELD_PLAYLIST_MEDIA_COUNT, NULL},
132 {MEDIA_TAG_ID, DB_FIELD_TAG_ID, NULL},
133 {TAG_NAME, DB_FIELD_TAG_NAME, DB_TABLE_ALIAS_TAG"."DB_FIELD_TAG_NAME},
136 {TAG_MEDIA_COUNT, DB_FIELD_TAG_MEDIA_COUNT, NULL},
139 {MEDIA_BOOKMARK_ID, DB_FIELD_BOOKMARK_ID, DB_TABLE_ALIAS_BOOKMARK"."DB_FIELD_BOOKMARK_ID},
140 {BOOKMARK_MARKED_TIME, DB_FIELD_BOOKMARK_MARKED_TIME, DB_TABLE_ALIAS_BOOKMARK"."DB_FIELD_BOOKMARK_MARKED_TIME},
141 {BOOKMARK_NAME, DB_FIELD_BOOKMARK_NAME, DB_TABLE_ALIAS_BOOKMARK"."DB_FIELD_BOOKMARK_NAME},
144 {MEDIA_STORAGE_ID, DB_FIELD_STORAGE_ID, NULL},
145 {MEDIA_STORAGE_PATH, DB_FIELD_STORAGE_PATH, NULL},
148 {MEDIA_FACE_ID, DB_FIELD_FACE_ID, DB_TABLE_ALIAS_FACE"."DB_FIELD_FACE_ID},
149 {MEDIA_FACE_TAG, DB_FIELD_FACE_TAG, DB_TABLE_ALIAS_FACE"."DB_FIELD_FACE_TAG},
151 #ifdef _USE_SENIOR_MODE
152 {MEDIA_CONTACT, DB_FIELD_MEDIA_CONTACT, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_CONTACT},
153 {MEDIA_APP_DATA, DB_FIELD_MEDIA_APP_DATA, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_APP_DATA},
155 #ifdef _USE_TVPD_MODE
156 {MEDIA_FOLDER_ID, DB_FIELD_MEDIA_FOLDER_ID, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_FOLDER_ID},
157 {MEDIA_STITCHED_INFO, DB_FIELD_MEDIA_STITCHED_INFO, NULL},
158 {MEDIA_MODIFIED_MONTH, DB_FIELD_MEDIA_MODIFIED_MONTH, NULL},
159 {MEDIA_MODIFIED_DATE, DB_FIELD_MEDIA_MODIFIED_DATE, NULL},
162 {PVR_DURATION, DB_FIELD_PVR_DURATION, NULL},
163 {PVR_TIME_ZONE, DB_FIELD_PVR_TIME_ZONE, NULL},
164 {PVR_PTC, DB_FIELD_PVR_PTC, NULL},
165 {PVR_MAJOR, DB_FIELD_PVR_MAJOR, NULL},
166 {PVR_MINOR, DB_FIELD_PVR_MINOR, NULL},
167 {PVR_CHANNEL_TYPE, DB_FIELD_PVR_CHANNEL_TYPE, NULL},
168 {PVR_CHANNEL_NAME, DB_FIELD_PVR_CHANNEL_NAME, NULL},
169 {PVR_CHANNEL_NUM, DB_FIELD_PVR_CHANNEL_NUM, NULL},
170 {PVR_PROGRAM_TITLE, DB_FIELD_PVR_PROGRAM_TITLE, NULL},
171 {PVR_PROGRAM_NUM, DB_FIELD_PVR_PROGRAM_NUM, NULL},
172 {PVR_PROGRAM_CRID, DB_FIELD_PVR_PROGRAM_CRID, NULL},
173 {PVR_GUIDANCE, DB_FIELD_PVR_GUIDANCE, NULL},
174 {PVR_SYNOPSIS, DB_FIELD_PVR_SYNOPSIS, NULL},
175 {PVR_GENRE, DB_FIELD_PVR_GENRE, NULL},
176 {PVR_LANGUAGE, DB_FIELD_PVR_LANGUAGE, NULL},
177 {PVR_EMBARGO_TIME, DB_FIELD_PVR_EMBARGO_TIME, NULL},
178 {PVR_EXPIRY_TIME, DB_FIELD_PVR_EXPIRY_TIME, NULL},
179 {PVR_START_TIME, DB_FIELD_PVR_START_TIME, NULL},
180 {PVR_PROGRAM_START_TIME, DB_FIELD_PVR_PROGRAM_START_TIME, NULL},
181 {PVR_PROGRAM_END_TIME, DB_FIELD_PVR_PROGRAM_END_TIME, NULL},
182 {PVR_PROGRAM_DATE, DB_FIELD_PVR_PROGRAM_DATE, NULL},
183 {PVR_PARENTAL_RATING, DB_FIELD_PVR_PARENTAL_RATING, NULL},
184 {PVR_TIMER_RECORD, DB_FIELD_PVR_TIMER_RECORD, NULL},
185 {PVR_SERIES_RECORD, DB_FIELD_PVR_SERIES_RECORD, NULL},
186 {PVR_HD, DB_FIELD_PVR_HD, NULL},
187 {PVR_SUBTITLE, DB_FIELD_PVR_SUBTITLE, NULL},
188 {PVR_TTX, DB_FIELD_PVR_TTX, NULL},
189 {PVR_AD, DB_FIELD_PVR_AD, NULL},
190 {PVR_TTX, DB_FIELD_PVR_TTX, NULL},
191 {PVR_DATA_SERVICE, DB_FIELD_PVR_DATA_SERVICE, NULL},
192 {PVR_CONTENT_LOCK, DB_FIELD_PVR_CONTENT_LOCK, NULL},
193 {PVR_CONTENT_WATCH, DB_FIELD_PVR_CONTENT_WATCH, NULL},
194 {PVR_CONTENT_HAS_AUDIO_ONLY, DB_FIELD_PVR_HAS_AUDIO_ONLY, NULL},
195 {PVR_CONTENT_IS_LOCAL_RECORD, DB_FIELD_PVR_IS_LOCAL_RECORD, NULL},
196 {PVR_CONTENT_RESOLUTION, DB_FIELD_PVR_RESOLUTION, NULL},
197 {PVR_CONTENT_ASPECTRATIO, DB_FIELD_PVR_ASPECTRATIO, NULL},
198 {PVR_MODIFIED_MONTH, DB_FIELD_PVR_MODIFIED_DATE, NULL},
199 {PVR_MODIFIED_DATE, DB_FIELD_PVR_MODIFIED_DATE, NULL},
200 {PVR_SPORTS_TYPE, DB_FIELD_PVR_SPORTS_TYPE, NULL},
201 {PVR_GUIDANCE_LENGTH, DB_FIELD_PVR_GUIDANCE_LENGTH, NULL},
202 {PVR_TVMODE, DB_FIELD_PVR_TVMODE, NULL},
203 {PVR_PLAY_COUNT, DB_FIELD_PVR_PLAY_COUNT, NULL},
204 {PVR_PRIVATE_DATA, DB_FIELD_PVR_PRIVATE_DATA, NULL},
207 {UHD_CONTENT_TITLE, DB_FIELD_UHD_CONTENT_TITLE, NULL},
208 {UHD_RELEASE_DATE, DB_FIELD_UHD_RELEASE_DATE, NULL},
209 {UHD_SUB_TYPE, DB_FIELD_UHD_SUB_TYPE, NULL},
210 {UHD_FILE_NAME, DB_FIELD_UHD_FILE_NAME, NULL},
211 {UHD_FOLDER_ID, DB_FIELD_FOLDER_ID, NULL},
212 {UHD_PLAYED_COUNT, DB_FIELD_UHD_PLAYED_COUNT, NULL},
217 static int __media_content_create_attr_handle(void)
219 int ret = MEDIA_CONTENT_ERROR_NONE;
221 ret = _media_filter_attribute_create(&g_attr_handle);
222 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
225 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_ID, DB_FIELD_MEDIA_ID);
226 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
228 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_PATH, DB_FIELD_MEDIA_PATH);
229 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
231 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_DISPLAY_NAME, DB_FIELD_MEDIA_DISPLAY_NAME);
232 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
234 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_TYPE, DB_FIELD_MEDIA_TYPE);
235 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
237 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_MIME_TYPE, DB_FIELD_MEDIA_MIME_TYPE);
238 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
240 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_SIZE, DB_FIELD_MEDIA_SIZE);
241 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
243 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_ADDED_TIME, DB_FIELD_MEDIA_ADDED_TIME);
244 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
246 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_MODIFIED_TIME, DB_FIELD_MEDIA_MODIFIED_TIME);
247 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
249 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_TIMELINE, DB_FIELD_MEDIA_TIMELINE);
250 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
252 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_THUMBNAIL_PATH, DB_FIELD_MEDIA_THUMBNAIL_PATH);
253 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
255 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_TITLE, DB_FIELD_MEDIA_TITLE);
256 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
258 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_ALBUM, DB_FIELD_MEDIA_ALBUM);
259 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
261 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_ARTIST, DB_FIELD_MEDIA_ARTIST);
262 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
264 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_ALBUM_ARTIST, DB_FIELD_MEDIA_ALBUM_ARTIST);
265 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
267 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_GENRE, DB_FIELD_MEDIA_GENRE);
268 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
270 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_COMPOSER, DB_FIELD_MEDIA_COMPOSER);
271 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
273 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_YEAR, DB_FIELD_MEDIA_YEAR);
274 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
276 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_RECORDED_DATE, DB_FIELD_MEDIA_RECORDED_DATE);
277 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
279 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_COPYRIGHT, DB_FIELD_MEDIA_COPYRIGHT);
280 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
282 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_TRACK_NUM, DB_FIELD_MEDIA_TRACK_NUM);
283 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
285 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_DESCRIPTION, DB_FIELD_MEDIA_DESCRIPTION);
286 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
288 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_BITRATE, DB_FIELD_MEDIA_BITRATE);
289 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
291 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_BITPERSAMPLE, DB_FIELD_MEDIA_BITPERSAMPLE);
292 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
294 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_SAMPLERATE, DB_FIELD_MEDIA_SAMPLERATE);
295 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
297 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_CHANNEL, DB_FIELD_MEDIA_CHANNEL);
298 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
300 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_DURATION, DB_FIELD_MEDIA_DURATION);
301 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
303 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_LONGITUDE, DB_FIELD_MEDIA_LONGITUDE);
304 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
306 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_LATITUDE, DB_FIELD_MEDIA_LATITUDE);
307 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
309 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_ALTITUDE, DB_FIELD_MEDIA_ALTITUDE);
310 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
312 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_WIDTH, DB_FIELD_MEDIA_WIDTH);
313 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
315 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_HEIGHT, DB_FIELD_MEDIA_HEIGHT);
316 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
318 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_DATETAKEN, DB_FIELD_MEDIA_DATETAKEN);
319 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
321 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_ORIENTATION, DB_FIELD_MEDIA_ORIENTATION);
322 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
324 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_BURST_ID, DB_FIELD_MEDIA_BURST_ID);
325 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
327 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_PLAYED_COUNT, DB_FIELD_MEDIA_PLAYED_COUNT);
328 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
330 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_LAST_PLAYED_TIME, DB_FIELD_MEDIA_LAST_PLAYED_TIME);
331 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
333 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_LAST_PLAYED_POSITION, DB_FIELD_MEDIA_LAST_PLAYED_POSITION);
334 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
336 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_RATING, DB_FIELD_MEDIA_RATING);
337 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
339 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_FAVOURITE, DB_FIELD_MEDIA_FAVOURITE);
340 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
342 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_AUTHOR, DB_FIELD_MEDIA_AUTHOR);
343 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
345 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_PROVIDER, DB_FIELD_MEDIA_PROVIDER);
346 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
348 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_CONTENT_NAME, DB_FIELD_MEDIA_CONTENT_NAME);
349 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
351 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_CATEGORY, DB_FIELD_MEDIA_CATEGORY);
352 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
354 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_LOCATION_TAG, DB_FIELD_MEDIA_LOCATION_TAG);
355 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
357 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_AGE_RATING, DB_FIELD_MEDIA_AGE_RATING);
358 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
360 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_KEYWORD, DB_FIELD_MEDIA_KEYWORD);
361 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
363 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_WEATHER, DB_FIELD_MEDIA_WEATHER);
364 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
366 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_IS_DRM, DB_FIELD_MEDIA_IS_DRM);
367 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
369 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_STORAGE_TYPE, DB_FIELD_MEDIA_STORAGE_TYPE);
370 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
372 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_360, DB_FIELD_MEDIA_360);
373 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
376 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_FILE_NAME_PINYIN, DB_FIELD_MEDIA_FILE_NAME_PINYIN);
377 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
379 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_TITLE_PINYIN, DB_FIELD_MEDIA_TITLE_PINYIN);
380 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
382 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_ALBUM_PINYIN, DB_FIELD_MEDIA_ALBUM_PINYIN);
383 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
385 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_ARTIST_PINYIN, DB_FIELD_MEDIA_ARTIST_PINYIN);
386 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
388 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_ALBUM_ARTIST_PINYIN, DB_FIELD_MEDIA_ALBUM_ARTIST_PINYIN);
389 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
391 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_GENRE_PINYIN, DB_FIELD_MEDIA_GENRE_PINYIN);
392 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
394 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_COMPOSER_PINYIN, DB_FIELD_MEDIA_COMPOSER_PINYIN);
395 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
397 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_COPYRIGHT_PINYIN, DB_FIELD_MEDIA_COPYRIGHT_PINYIN);
398 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
400 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_DESCRIPTION_PINYIN, DB_FIELD_MEDIA_DESCRIPTION_PINYIN);
401 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
403 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_AUTHOR_PINYIN, DB_FIELD_MEDIA_AUTHOR_PINYIN);
404 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
406 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_PROVIDER_PINYIN, DB_FIELD_MEDIA_PROVIDER_PINYIN);
407 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
409 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_CONTENT_NAME_PINYIN, DB_FIELD_MEDIA_CONTENT_NAME_PINYIN);
410 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
412 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_CATEGORY_PINYIN, DB_FIELD_MEDIA_CATEGORY_PINYIN);
413 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
415 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_LOCATION_TAG_PINYIN, DB_FIELD_MEDIA_LOCATION_TAG_PINYIN);
416 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
418 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_AGE_RATING_PINYIN, DB_FIELD_MEDIA_AGE_RATING_PINYIN);
419 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
421 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_KEYWORD_PINYIN, DB_FIELD_MEDIA_KEYWORD_PINYIN);
422 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
425 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_PLAYLIST_ID, DB_FIELD_PLAYLIST_ID);
426 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
428 ret = _media_filter_attribute_add(g_attr_handle, PLAYLIST_NAME, DB_FIELD_PLAYLIST_NAME);
429 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
431 ret = _media_filter_attribute_add(g_attr_handle, PLAYLIST_MEMBER_ORDER, DB_FIELD_PLAYLIST_MEMBER_ORDER);
432 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
435 ret = _media_filter_attribute_add(g_attr_handle, PLAYLIST_MEDIA_COUNT, DB_FIELD_PLAYLIST_MEDIA_COUNT);
436 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
439 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_TAG_ID, DB_FIELD_TAG_ID);
440 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
442 ret = _media_filter_attribute_add(g_attr_handle, TAG_NAME, DB_FIELD_TAG_NAME);
443 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
446 ret = _media_filter_attribute_add(g_attr_handle, TAG_MEDIA_COUNT, DB_FIELD_TAG_MEDIA_COUNT);
447 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
450 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_BOOKMARK_ID, DB_FIELD_BOOKMARK_ID);
451 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
453 ret = _media_filter_attribute_add(g_attr_handle, BOOKMARK_MARKED_TIME, DB_FIELD_BOOKMARK_MARKED_TIME);
454 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
456 ret = _media_filter_attribute_add(g_attr_handle, BOOKMARK_NAME, DB_FIELD_BOOKMARK_NAME);
457 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
460 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_STORAGE_ID, DB_FIELD_STORAGE_ID);
461 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
463 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_STORAGE_PATH, DB_FIELD_STORAGE_PATH);
464 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
467 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_FACE_TAG, DB_FIELD_FACE_TAG);
468 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
470 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_FACE_ID, DB_FIELD_FACE_ID);
471 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
473 #ifdef _USE_SENIOR_MODE
474 if (_media_content_is_support_senior_mode()) {
475 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_CONTACT, DB_FIELD_MEDIA_CONTACT);
476 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
478 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_APP_DATA, DB_FIELD_MEDIA_APP_DATA);
479 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
482 #ifdef _USE_TVPD_MODE
483 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_FOLDER_ID, DB_FIELD_MEDIA_FOLDER_ID);
484 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
486 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_STITCHED_INFO, DB_FIELD_MEDIA_STITCHED_INFO);
487 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
489 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_MODIFIED_MONTH, DB_FIELD_MEDIA_MODIFIED_MONTH);
490 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
492 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_MODIFIED_DATE, DB_FIELD_MEDIA_MODIFIED_DATE);
493 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
496 ret = _media_filter_attribute_add(g_attr_handle, PVR_DURATION, DB_FIELD_PVR_DURATION);
497 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
499 ret = _media_filter_attribute_add(g_attr_handle, PVR_TIME_ZONE, DB_FIELD_PVR_TIME_ZONE);
500 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
502 ret = _media_filter_attribute_add(g_attr_handle, PVR_PTC, DB_FIELD_PVR_PTC);
503 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
505 ret = _media_filter_attribute_add(g_attr_handle, PVR_MAJOR, DB_FIELD_PVR_MAJOR);
506 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
508 ret = _media_filter_attribute_add(g_attr_handle, PVR_MINOR, DB_FIELD_PVR_MINOR);
509 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
511 ret = _media_filter_attribute_add(g_attr_handle, PVR_CHANNEL_TYPE, DB_FIELD_PVR_CHANNEL_TYPE);
512 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
514 ret = _media_filter_attribute_add(g_attr_handle, PVR_CHANNEL_NAME, DB_FIELD_PVR_CHANNEL_NAME);
515 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
517 ret = _media_filter_attribute_add(g_attr_handle, PVR_CHANNEL_NUM, DB_FIELD_PVR_CHANNEL_NUM);
518 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
520 ret = _media_filter_attribute_add(g_attr_handle, PVR_PROGRAM_TITLE, DB_FIELD_PVR_PROGRAM_TITLE);
521 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
523 ret = _media_filter_attribute_add(g_attr_handle, PVR_PROGRAM_NUM, DB_FIELD_PVR_PROGRAM_NUM);
524 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
526 ret = _media_filter_attribute_add(g_attr_handle, PVR_PROGRAM_CRID, DB_FIELD_PVR_PROGRAM_CRID);
527 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
529 ret = _media_filter_attribute_add(g_attr_handle, PVR_GUIDANCE, DB_FIELD_PVR_GUIDANCE);
530 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
532 ret = _media_filter_attribute_add(g_attr_handle, PVR_SYNOPSIS, DB_FIELD_PVR_SYNOPSIS);
533 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
535 ret = _media_filter_attribute_add(g_attr_handle, PVR_GENRE, DB_FIELD_PVR_GENRE);
536 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
538 ret = _media_filter_attribute_add(g_attr_handle, PVR_LANGUAGE, DB_FIELD_PVR_LANGUAGE);
539 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
541 ret = _media_filter_attribute_add(g_attr_handle, PVR_EMBARGO_TIME, DB_FIELD_PVR_EMBARGO_TIME);
542 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
544 ret = _media_filter_attribute_add(g_attr_handle, PVR_EXPIRY_TIME, DB_FIELD_PVR_EXPIRY_TIME);
545 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
547 ret = _media_filter_attribute_add(g_attr_handle, PVR_START_TIME, DB_FIELD_PVR_START_TIME);
548 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
550 ret = _media_filter_attribute_add(g_attr_handle, PVR_PROGRAM_START_TIME, DB_FIELD_PVR_PROGRAM_START_TIME);
551 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
553 ret = _media_filter_attribute_add(g_attr_handle, PVR_PROGRAM_END_TIME, DB_FIELD_PVR_PROGRAM_END_TIME);
554 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
556 ret = _media_filter_attribute_add(g_attr_handle, PVR_PROGRAM_DATE, DB_FIELD_PVR_PROGRAM_DATE);
557 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
559 ret = _media_filter_attribute_add(g_attr_handle, PVR_PARENTAL_RATING, DB_FIELD_PVR_PARENTAL_RATING);
560 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
562 ret = _media_filter_attribute_add(g_attr_handle, PVR_TIMER_RECORD, DB_FIELD_PVR_TIMER_RECORD);
563 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
565 ret = _media_filter_attribute_add(g_attr_handle, PVR_SERIES_RECORD, DB_FIELD_PVR_SERIES_RECORD);
566 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
568 ret = _media_filter_attribute_add(g_attr_handle, PVR_HD, DB_FIELD_PVR_HD);
569 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
571 ret = _media_filter_attribute_add(g_attr_handle, PVR_SUBTITLE, DB_FIELD_PVR_SUBTITLE);
572 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
574 ret = _media_filter_attribute_add(g_attr_handle, PVR_TTX, DB_FIELD_PVR_TTX);
575 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
577 ret = _media_filter_attribute_add(g_attr_handle, PVR_AD, DB_FIELD_PVR_AD);
578 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
580 ret = _media_filter_attribute_add(g_attr_handle, PVR_TTX, DB_FIELD_PVR_TTX);
581 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
583 ret = _media_filter_attribute_add(g_attr_handle, PVR_DATA_SERVICE, DB_FIELD_PVR_DATA_SERVICE);
584 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
586 ret = _media_filter_attribute_add(g_attr_handle, PVR_CONTENT_LOCK, DB_FIELD_PVR_CONTENT_LOCK);
587 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
589 ret = _media_filter_attribute_add(g_attr_handle, PVR_CONTENT_WATCH, DB_FIELD_PVR_CONTENT_WATCH);
590 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
592 ret = _media_filter_attribute_add(g_attr_handle, PVR_CONTENT_HAS_AUDIO_ONLY, DB_FIELD_PVR_HAS_AUDIO_ONLY);
593 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
595 ret = _media_filter_attribute_add(g_attr_handle, PVR_CONTENT_IS_LOCAL_RECORD, DB_FIELD_PVR_IS_LOCAL_RECORD);
596 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
598 ret = _media_filter_attribute_add(g_attr_handle, PVR_CONTENT_RESOLUTION, DB_FIELD_PVR_RESOLUTION);
599 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
601 ret = _media_filter_attribute_add(g_attr_handle, PVR_CONTENT_ASPECTRATIO, DB_FIELD_PVR_ASPECTRATIO);
602 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
604 ret = _media_filter_attribute_add(g_attr_handle, PVR_MODIFIED_MONTH, DB_FIELD_PVR_MODIFIED_DATE);
605 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
607 ret = _media_filter_attribute_add(g_attr_handle, PVR_MODIFIED_DATE, DB_FIELD_PVR_MODIFIED_DATE);
608 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
610 ret = _media_filter_attribute_add(g_attr_handle, PVR_SPORTS_TYPE, DB_FIELD_PVR_SPORTS_TYPE);
611 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
613 ret = _media_filter_attribute_add(g_attr_handle, PVR_GUIDANCE_LENGTH, DB_FIELD_PVR_GUIDANCE_LENGTH);
614 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
616 ret = _media_filter_attribute_add(g_attr_handle, PVR_TVMODE, DB_FIELD_PVR_TVMODE);
617 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
619 ret = _media_filter_attribute_add(g_attr_handle, PVR_PLAY_COUNT, DB_FIELD_PVR_PLAY_COUNT);
620 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
622 ret = _media_filter_attribute_add(g_attr_handle, PVR_PRIVATE_DATA, DB_FIELD_PVR_PRIVATE_DATA);
623 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
626 ret = _media_filter_attribute_add(g_attr_handle, UHD_CONTENT_TITLE, DB_FIELD_UHD_CONTENT_TITLE);
627 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
629 ret = _media_filter_attribute_add(g_attr_handle, UHD_RELEASE_DATE, DB_FIELD_UHD_RELEASE_DATE);
630 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
632 ret = _media_filter_attribute_add(g_attr_handle, UHD_SUB_TYPE, DB_FIELD_UHD_SUB_TYPE);
633 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
635 ret = _media_filter_attribute_add(g_attr_handle, UHD_FILE_NAME, DB_FIELD_UHD_FILE_NAME);
636 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
638 ret = _media_filter_attribute_add(g_attr_handle, UHD_FOLDER_ID, DB_FIELD_FOLDER_ID);
639 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
641 ret = _media_filter_attribute_add(g_attr_handle, UHD_PLAYED_COUNT, DB_FIELD_UHD_PLAYED_COUNT);
642 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
647 static int __media_content_create_alias_attr_handle(void)
649 int ret = MEDIA_CONTENT_ERROR_NONE;
651 ret = _media_filter_attribute_create(&g_alias_attr_handle);
652 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
655 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_ID, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ID);
656 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
658 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_PATH, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_PATH);
659 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
661 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_DISPLAY_NAME, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_DISPLAY_NAME);
662 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
664 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_TYPE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_TYPE);
665 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
667 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_MIME_TYPE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_MIME_TYPE);
668 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
670 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_SIZE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_SIZE);
671 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
673 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_ADDED_TIME, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ADDED_TIME);
674 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
676 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_MODIFIED_TIME, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_MODIFIED_TIME);
677 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
679 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_TIMELINE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_TIMELINE);
680 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
681 #ifdef _USE_TVPD_MODE
682 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_FOLDER_ID, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_FOLDER_ID);
683 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
686 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_THUMBNAIL_PATH, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_THUMBNAIL_PATH);
687 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
689 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_TITLE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_TITLE);
690 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
692 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_ALBUM, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ALBUM);
693 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
695 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_ARTIST, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ARTIST);
696 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
698 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_ALBUM_ARTIST, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ALBUM_ARTIST);
699 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
701 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_GENRE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_GENRE);
702 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
704 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_COMPOSER, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_COMPOSER);
705 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
707 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_YEAR, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_YEAR);
708 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
710 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_RECORDED_DATE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_RECORDED_DATE);
711 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
713 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_COPYRIGHT, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_COPYRIGHT);
714 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
716 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_TRACK_NUM, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_TRACK_NUM);
717 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
719 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_DESCRIPTION, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_DESCRIPTION);
720 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
722 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_BITRATE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_BITRATE);
723 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
725 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_BITPERSAMPLE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_BITPERSAMPLE);
726 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
728 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_SAMPLERATE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_SAMPLERATE);
729 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
731 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_CHANNEL, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_CHANNEL);
732 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
734 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_DURATION, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_DURATION);
735 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
737 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_LONGITUDE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_LONGITUDE);
738 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
740 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_LATITUDE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_LATITUDE);
741 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
743 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_ALTITUDE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ALTITUDE);
744 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
746 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_WIDTH, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_WIDTH);
747 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
749 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_HEIGHT, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_HEIGHT);
750 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
752 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_DATETAKEN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_DATETAKEN);
753 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
755 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_ORIENTATION, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ORIENTATION);
756 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
758 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_BURST_ID, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_BURST_ID);
759 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
761 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_PLAYED_COUNT, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_PLAYED_COUNT);
762 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
764 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_LAST_PLAYED_TIME, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_LAST_PLAYED_TIME);
765 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
767 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_LAST_PLAYED_POSITION, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_LAST_PLAYED_POSITION);
768 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
770 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_RATING, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_RATING);
771 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
773 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_FAVOURITE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_FAVOURITE);
774 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
776 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_AUTHOR, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_AUTHOR);
777 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
779 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_PROVIDER, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_PROVIDER);
780 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
782 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_CONTENT_NAME, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_CONTENT_NAME);
783 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
785 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_CATEGORY, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_CATEGORY);
786 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
788 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_LOCATION_TAG, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_LOCATION_TAG);
789 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
791 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_AGE_RATING, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_AGE_RATING);
792 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
794 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_KEYWORD, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_KEYWORD);
795 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
797 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_WEATHER, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_WEATHER);
798 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
800 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_IS_DRM, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_IS_DRM);
801 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
803 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_STORAGE_TYPE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_STORAGE_TYPE);
804 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
806 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_360, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_360);
807 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
809 #ifdef _USE_SENIOR_MODE
810 if (_media_content_is_support_senior_mode()) {
811 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_CONTACT, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_CONTACT);
812 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
814 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_APP_DATA, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_APP_DATA);
815 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
820 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_FILE_NAME_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_FILE_NAME_PINYIN);
821 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
823 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_TITLE_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_TITLE_PINYIN);
824 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
826 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_ALBUM_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ALBUM_PINYIN);
827 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
829 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_ARTIST_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ARTIST_PINYIN);
830 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
832 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_ALBUM_ARTIST_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ALBUM_ARTIST_PINYIN);
833 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
835 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_GENRE_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_GENRE_PINYIN);
836 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
838 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_COMPOSER_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_COMPOSER_PINYIN);
839 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
841 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_COPYRIGHT_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_COPYRIGHT_PINYIN);
842 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
844 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_DESCRIPTION_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_DESCRIPTION_PINYIN);
845 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
847 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_AUTHOR_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_AUTHOR_PINYIN);
848 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
850 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_PROVIDER_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_PROVIDER_PINYIN);
851 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
853 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_CONTENT_NAME_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_CONTENT_NAME_PINYIN);
854 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
856 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_CATEGORY_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_CATEGORY_PINYIN);
857 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
859 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_LOCATION_TAG_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_LOCATION_TAG_PINYIN);
860 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
862 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_AGE_RATING_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_AGE_RATING_PINYIN);
863 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
865 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_KEYWORD_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_KEYWORD_PINYIN);
866 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
869 ret = _media_filter_attribute_add(g_alias_attr_handle, FOLDER_ID, DB_TABLE_ALIAS_FOLDER"."DB_FIELD_FOLDER_ID);
870 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
872 ret = _media_filter_attribute_add(g_alias_attr_handle, FOLDER_PATH, DB_TABLE_ALIAS_FOLDER"."DB_FIELD_FOLDER_PATH);
873 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
875 ret = _media_filter_attribute_add(g_alias_attr_handle, FOLDER_NAME, DB_TABLE_ALIAS_FOLDER"."DB_FIELD_FOLDER_NAME);
876 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
878 ret = _media_filter_attribute_add(g_alias_attr_handle, FOLDER_MODIFIED_TIME, DB_TABLE_ALIAS_FOLDER"."DB_FIELD_FOLDER_MODIFIED_TIME);
879 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
881 ret = _media_filter_attribute_add(g_alias_attr_handle, FOLDER_STORAGE_TYPE, DB_TABLE_ALIAS_FOLDER"."DB_FIELD_FOLDER_STORAGE_TYPE);
882 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
884 ret = _media_filter_attribute_add(g_alias_attr_handle, FOLDER_NAME_PINYIN, DB_TABLE_ALIAS_FOLDER"."DB_FIELD_FOLDER_NAME_PINYIN);
885 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
887 ret = _media_filter_attribute_add(g_alias_attr_handle, FOLDER_ORDER, DB_TABLE_ALIAS_FOLDER"."DB_FIELD_FOLDER_ORDER);
888 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
890 ret = _media_filter_attribute_add(g_alias_attr_handle, FOLDER_PARENT_FOLDER_ID, DB_TABLE_ALIAS_FOLDER"."DB_FIELD_FOLDER_PARENT_FOLDER_ID);
891 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
894 ret = _media_filter_attribute_add(g_alias_attr_handle, PLAYLIST_NAME, DB_TABLE_ALIAS_PLAYLIST"."DB_FIELD_PLAYLIST_NAME);
895 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
897 ret = _media_filter_attribute_add(g_alias_attr_handle, PLAYLIST_MEMBER_ORDER, DB_TABLE_ALIAS_PLAYLIST_MAP"."DB_FIELD_PLAYLIST_MEMBER_ORDER);
898 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
901 ret = _media_filter_attribute_add(g_alias_attr_handle, TAG_NAME, DB_TABLE_ALIAS_TAG"."DB_FIELD_TAG_NAME);
902 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
905 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_BOOKMARK_ID, DB_TABLE_ALIAS_BOOKMARK"."DB_FIELD_BOOKMARK_ID);
906 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
908 ret = _media_filter_attribute_add(g_alias_attr_handle, BOOKMARK_MARKED_TIME, DB_TABLE_ALIAS_BOOKMARK"."DB_FIELD_BOOKMARK_MARKED_TIME);
909 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
911 ret = _media_filter_attribute_add(g_alias_attr_handle, BOOKMARK_NAME, DB_TABLE_ALIAS_BOOKMARK"."DB_FIELD_BOOKMARK_NAME);
912 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
915 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_FACE_TAG, DB_TABLE_ALIAS_FACE"."DB_FIELD_FACE_TAG);
916 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
918 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_FACE_ID, DB_TABLE_ALIAS_FACE"."DB_FIELD_FACE_ID);
919 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
924 static int __media_content_create_attribute_handle(void)
926 int ret = MEDIA_CONTENT_ERROR_NONE;
928 ret = __media_content_create_attr_handle();
929 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
931 ret = __media_content_create_alias_attr_handle();
932 if (ret != MEDIA_CONTENT_ERROR_NONE)
933 _media_filter_attribute_destory(g_attr_handle);
939 static int __media_content_create_attribute_handles(void)
941 int ret = MEDIA_CONTENT_ERROR_NONE;
944 char *_attr_user = NULL;
945 char *_attr_platform = NULL;
946 char *_alias_attr_user = NULL;
947 char *_alias_attr_platform = NULL;
949 ret = _media_filter_attribute_create(&g_attr_handle);
950 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
952 ret = _media_filter_attribute_create(&g_alias_attr_handle);
953 if (ret != MEDIA_CONTENT_ERROR_NONE)
956 attribute_s *_attr = (attribute_s*)g_attr_handle;
957 attribute_s *_alias_attr = (attribute_s*)g_alias_attr_handle;
959 count = sizeof(g_content_attrs_info) / sizeof((g_content_attrs_info)[0]);
961 for (idx = 0; idx < count; idx++) {
963 _attr_platform = NULL;
964 _alias_attr_user = NULL;
965 _alias_attr_platform = NULL;
967 if (STRING_VALID(g_content_attrs_info[idx].user_attr)) {
969 if (STRING_VALID(g_content_attrs_info[idx].platform_attr)) {
970 _attr_user = g_strdup(g_content_attrs_info[idx].user_attr);
971 _attr_platform = g_strdup(g_content_attrs_info[idx].platform_attr);
973 if (_attr_user == NULL || _attr_platform == NULL) {
974 SAFE_G_FREE(_attr_user);
975 SAFE_G_FREE(_attr_platform);
976 media_content_error("OUT_OF_MEMORY(0x%08x)", MEDIA_CONTENT_ERROR_OUT_OF_MEMORY);
977 ret = MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
981 g_hash_table_insert(_attr->attr_map, _attr_user, _attr_platform);
986 if (STRING_VALID(g_content_attrs_info[idx].platform_alias_attr)) {
987 _alias_attr_user = g_strdup(g_content_attrs_info[idx].user_attr);
988 _alias_attr_platform = g_strdup(g_content_attrs_info[idx].platform_alias_attr);
990 if (_alias_attr_user == NULL || _alias_attr_platform == NULL) {
991 SAFE_G_FREE(_alias_attr_user);
992 SAFE_G_FREE(_alias_attr_platform);
993 media_content_error("OUT_OF_MEMORY(0x%08x)", MEDIA_CONTENT_ERROR_OUT_OF_MEMORY);
994 ret = MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
998 g_hash_table_insert(_alias_attr->attr_map, _alias_attr_user, _alias_attr_platform);
1001 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
1002 ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
1010 media_content_error("Fail media_content_create_attribute_handles");
1011 __media_content_destroy_attribute_handle();
1016 static int __media_content_destroy_attribute_handle(void)
1018 int ret = MEDIA_CONTENT_ERROR_NONE;
1020 ret = _media_filter_attribute_destory(g_attr_handle);
1021 ret = _media_filter_attribute_destory(g_alias_attr_handle);
1023 g_attr_handle = NULL;
1024 g_alias_attr_handle = NULL;
1029 attribute_h _content_get_attirbute_handle(void)
1031 return g_attr_handle;
1034 attribute_h _content_get_alias_attirbute_handle(void)
1036 return g_alias_attr_handle;
1039 MediaSvcHandle* _content_get_db_handle(void)
1044 uid_t _content_get_uid(void)
1046 if (content_g_uid == 0)
1047 return tzplatform_getuid(TZ_USER_NAME);
1049 return content_g_uid;
1052 int _content_query_prepare(sqlite3_stmt **stmt, char *select_query, char *condition_query, char *option_query)
1055 int err = MEDIA_CONTENT_ERROR_NONE;
1056 char query[MAX_QUERY_SIZE] = {0, };
1057 memset(query, '\0', sizeof(query));
1059 media_content_retvm_if(db_handle == NULL, MEDIA_CONTENT_ERROR_DB_FAILED, "database is not connected");
1060 media_content_retvm_if(!STRING_VALID(select_query), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "invalid select_query");
1062 if (!STRING_VALID(condition_query))
1063 condition_query = (char *)" ";
1065 if (!STRING_VALID(option_query))
1066 option_query = (char *)" ";
1068 /*query = sqlite3_mprintf("%s %s %s", select_query, condition_query, option_query);*/
1069 len = snprintf(query, sizeof(query), "%s %s %s", select_query, condition_query, option_query);
1070 if (len > 0 && len < sizeof(query))
1072 else if (len >= sizeof(query))
1073 query[MAX_QUERY_SIZE -1] = '\0';
1075 media_content_error("snprintf failed");
1076 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
1079 media_content_sec_debug("Query : [%s]", query);
1081 err = sqlite3_prepare_v2((sqlite3*)db_handle, query, strlen(query), stmt, NULL);
1082 if (err != SQLITE_OK) {
1083 media_content_error("DB_FAILED(0x%08x) fail to sqlite3_prepare(), %s", MEDIA_CONTENT_ERROR_DB_FAILED, sqlite3_errmsg((sqlite3*)db_handle));
1085 if (err == SQLITE_BUSY) {
1086 media_content_error(" BUSY ERROR");
1087 return MEDIA_CONTENT_ERROR_DB_BUSY;
1088 } else if (err == SQLITE_PERM) {
1089 media_content_error("PERMISSION EROR");
1090 return MEDIA_CONTENT_ERROR_PERMISSION_DENIED;
1092 media_content_error("OTHER ERROR");
1093 return MEDIA_CONTENT_ERROR_DB_FAILED;
1097 return MEDIA_CONTENT_ERROR_NONE;
1100 #ifdef _USE_SENIOR_MODE
1101 int _content_query_prepare_by_union_select(sqlite3_stmt **stmt, char *select_query1, char *condition_query1, char *option_query1, char *select_query2, char *condition_query2, char *option_query2)
1104 int err = MEDIA_CONTENT_ERROR_NONE;
1105 char query[MAX_QUERY_SIZE] = {0, };
1106 memset(query, '\0', sizeof(query));
1108 media_content_retvm_if(db_handle == NULL, MEDIA_CONTENT_ERROR_DB_FAILED, "database is not connected");
1109 media_content_retvm_if(!STRING_VALID(select_query1), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "invalid select_query1");
1110 media_content_retvm_if(!STRING_VALID(select_query2), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "invalid select_query2");
1112 if (!STRING_VALID(condition_query1))
1113 condition_query1 = (char *)" ";
1115 if (!STRING_VALID(option_query1))
1116 option_query1 = (char *)" ";
1118 if (!STRING_VALID(condition_query2))
1119 condition_query2 = (char *)" ";
1121 if (!STRING_VALID(option_query2))
1122 option_query2 = (char *)" ";
1124 len = snprintf(query, sizeof(query), "SELECT * FROM (%s %s %s) as table1 UNION ALL SELECT * FROM (%s %s %s) as table2",
1125 select_query1, condition_query1, option_query1, select_query2, condition_query2, option_query2);
1126 if (len > 0 && len < sizeof(query)) {
1128 } else if (len >= sizeof(query)) {
1129 query[MAX_QUERY_SIZE -1] = '\0';
1131 media_content_error("snprintf failed");
1132 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
1135 media_content_sec_debug("Query : [%s]", query);
1137 err = sqlite3_prepare_v2((sqlite3*)db_handle, query, strlen(query), stmt, NULL);
1138 if (err != SQLITE_OK) {
1139 media_content_error("DB_FAILED(0x%08x) fail to sqlite3_prepare(), %s", MEDIA_CONTENT_ERROR_DB_FAILED, sqlite3_errmsg((sqlite3*)db_handle));
1141 if (err == SQLITE_BUSY) {
1142 media_content_error(" BUSY ERROR");
1143 return MEDIA_CONTENT_ERROR_DB_BUSY;
1144 } else if (err == SQLITE_PERM) {
1145 media_content_error("PERMISSION EROR");
1146 return MEDIA_CONTENT_ERROR_PERMISSION_DENIED;
1148 media_content_error("OTHER ERROR");
1149 return MEDIA_CONTENT_ERROR_DB_FAILED;
1153 return MEDIA_CONTENT_ERROR_NONE;
1157 int _content_error_capi(int type, int content_error)
1159 if (content_error != MEDIA_CONTENT_ERROR_NONE)
1160 media_content_error("[type : %d] content_error : %d ", type, content_error);
1163 if (content_error == MS_MEDIA_ERR_NONE)
1164 return MEDIA_CONTENT_ERROR_NONE;
1166 /* Internal operation error*/
1167 else if ((content_error == MS_MEDIA_ERR_INVALID_PARAMETER) ||
1168 (content_error == MS_MEDIA_ERR_INVALID_PATH) ||
1169 (content_error == MS_MEDIA_ERR_THUMB_DUPLICATED_REQUEST))
1170 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
1172 else if (content_error == MS_MEDIA_ERR_OUT_OF_MEMORY)
1173 return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
1175 /* DB operation error*/
1176 else if (content_error == MS_MEDIA_ERR_DB_BUSY_FAIL)
1177 return MEDIA_CONTENT_ERROR_DB_BUSY;
1179 else if ((content_error <= MS_MEDIA_ERR_DB_CONNECT_FAIL) && (content_error >= MS_MEDIA_ERR_DB_INTERNAL))
1180 return MEDIA_CONTENT_ERROR_DB_FAILED;
1182 /* IPC operation error*/
1183 else if ((content_error <= MS_MEDIA_ERR_SOCKET_CONN) && (content_error >= MS_MEDIA_ERR_SOCKET_INTERNAL))
1184 return MEDIA_CONTENT_ERROR_NETWORK;
1186 /* MEDIA SERVER error*/
1187 else if (content_error == MS_MEDIA_ERR_PERMISSION_DENIED)
1188 return MEDIA_CONTENT_ERROR_PERMISSION_DENIED;
1190 /* Thumbnail error*/
1191 else if ((content_error == MS_MEDIA_ERR_THUMB_TOO_BIG) || (content_error == MS_MEDIA_ERR_THUMB_UNSUPPORTED))
1192 return MEDIA_CONTENT_ERROR_UNSUPPORTED_CONTENT;
1195 return MEDIA_CONTENT_ERROR_INVALID_OPERATION;
1198 int _content_query_sql(char *query_str)
1200 int ret = MEDIA_CONTENT_ERROR_NONE;
1202 /*DB will be updated by Media Server.*/
1203 ret = media_svc_request_update_db(query_str, _content_get_uid());
1205 return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
1208 int media_content_connect(void)
1210 int ret = MEDIA_CONTENT_ERROR_NONE;
1212 g_mutex_lock(&db_mutex);
1213 media_content_info("ref count : %d", ref_count);
1215 if (ref_count == 0) {
1216 if (db_handle == NULL) {
1217 ret = __media_content_create_attribute_handles();
1218 if (ret == MEDIA_CONTENT_ERROR_NONE) {
1219 ret = media_svc_connect(&db_handle, _content_get_uid(), false);
1220 ret = _content_error_capi(MEDIA_CONTENT_TYPE, ret);
1221 if (ret == MEDIA_CONTENT_ERROR_NONE)
1224 __media_content_destroy_attribute_handle();
1227 media_content_error("Internal DB Connection Error");
1230 media_content_error("Wrong DB Connection status");
1231 ret = MEDIA_CONTENT_ERROR_DB_FAILED;
1234 if (db_handle != NULL) {
1237 media_content_error("Wrong DB Handle status");
1238 ret = MEDIA_CONTENT_ERROR_DB_FAILED;
1242 media_content_info("ref count changed to: %d", ref_count);
1243 g_mutex_unlock(&db_mutex);
1248 int media_content_connect_with_uid(uid_t uid)
1250 media_content_sec_debug("media_content_connect_with_uid [%d]", uid);
1251 content_g_uid = uid;
1253 return media_content_connect();
1256 int media_content_disconnect(void)
1258 int ret = MEDIA_CONTENT_ERROR_NONE;
1260 g_mutex_lock(&db_mutex);
1261 media_content_debug("ref count : %d", ref_count);
1262 if (ref_count > 0) {
1263 if (db_handle != NULL) {
1266 media_content_error("Wrong DB Handle status");
1267 ret = MEDIA_CONTENT_ERROR_DB_FAILED;
1270 media_content_error("DB_FAILED(0x%08x) database is not connected", MEDIA_CONTENT_ERROR_DB_FAILED);
1271 g_mutex_unlock(&db_mutex);
1272 return MEDIA_CONTENT_ERROR_DB_FAILED;
1275 if (ref_count == 0) {
1276 if (db_handle != NULL) {
1277 ret = media_svc_disconnect(db_handle);
1278 ret = _content_error_capi(MEDIA_CONTENT_TYPE, ret);
1279 if (ret == MEDIA_CONTENT_ERROR_NONE) {
1280 ret = __media_content_destroy_attribute_handle();
1283 media_content_error("database disconnect fail");
1287 media_content_error("Wrong DB Handle status");
1288 ret = MEDIA_CONTENT_ERROR_DB_FAILED;
1291 g_mutex_unlock(&db_mutex);
1293 media_content_info("ref count changed to: %d", ref_count);
1298 g_mutex_unlock(&db_mutex);
1300 media_content_info("ref count changed to: %d", ref_count);
1305 int media_content_scan_file(const char *path)
1307 int ret = MEDIA_CONTENT_ERROR_NONE;
1308 bool ignore_file = FALSE;
1309 bool ignore_dir = FALSE;
1310 char *folder_path = NULL;
1311 int check_file = MEDIA_CONTENT_ERROR_NONE;
1312 char storage_id[MEDIA_CONTENT_UUID_SIZE+1] = {0,};
1313 char repl_path[MAX_PATH_LEN] = {0,};
1315 media_content_retvm_if(!STRING_VALID(path), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "invalid path");
1317 media_content_sec_debug("Path : %s", path);
1319 memset(repl_path, 0, sizeof(repl_path));
1320 ret = _media_content_replace_path(path, repl_path);
1321 media_content_retvm_if(!STRING_VALID(repl_path), MEDIA_CONTENT_ERROR_INVALID_OPERATION, "path replacement failed");
1323 ret = _media_util_check_ignore_file(repl_path, &ignore_file);
1324 media_content_retvm_if(ignore_file == TRUE, MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid path");
1326 memset(storage_id, 0x00, sizeof(storage_id));
1327 ret = media_svc_get_storage_id(_content_get_db_handle(), repl_path, storage_id, _content_get_uid());
1328 if (ret != MS_MEDIA_ERR_NONE) {
1329 media_content_error("media_svc_get_storage_id failed : %d", ret);
1330 return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
1333 check_file = _media_util_check_file_exist(repl_path);
1334 if (check_file == MEDIA_CONTENT_ERROR_NONE) {
1335 /* This means this path has to be inserted or refreshed */
1336 folder_path = g_path_get_dirname(repl_path);
1337 ret = _media_util_check_ignore_dir(folder_path, &ignore_dir);
1338 SAFE_FREE(folder_path);
1340 media_content_retvm_if(ignore_dir == TRUE, MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid folder path");
1342 media_content_retvm_if(!_media_util_check_support_media_type(repl_path), MEDIA_CONTENT_ERROR_NOT_SUPPORTED, "Unsupported media type");
1344 media_svc_storage_type_e storage_type;
1346 ret = media_svc_get_storage_type(repl_path, &storage_type, _content_get_uid());
1347 if (ret != MS_MEDIA_ERR_NONE) {
1348 media_content_sec_error("media_svc_get_storage_type failed : %d (%s)", ret, repl_path);
1349 return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
1351 ret = media_svc_check_item_exist_by_path(_content_get_db_handle(), storage_id, repl_path);
1352 if (ret == MS_MEDIA_ERR_NONE) {
1354 ret = media_svc_refresh_item(_content_get_db_handle(), storage_id, storage_type, repl_path, _content_get_uid());
1355 if (ret != MS_MEDIA_ERR_NONE) {
1356 media_content_error("media_svc_refresh_item failed : %d", ret);
1357 return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
1360 } else if (ret == MS_MEDIA_ERR_DB_NO_RECORD) {
1362 ret = media_svc_insert_item_immediately(_content_get_db_handle(), storage_id, storage_type, repl_path, _content_get_uid());
1363 if (ret != MS_MEDIA_ERR_NONE) {
1364 if (ret == MS_MEDIA_ERR_DB_CONSTRAINT_FAIL) {
1365 media_content_sec_error("This item is already inserted. This may be normal operation because other process already did this (%s)", repl_path);
1366 ret = MEDIA_CONTENT_ERROR_NONE;
1368 media_content_sec_error("media_svc_insert_item_immediately failed : %d (%s)", ret, repl_path);
1371 return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
1374 media_content_error("media_svc_check_item_exist_by_path failed : %d", ret);
1375 return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
1377 } else if (check_file == MEDIA_CONTENT_ERROR_PERMISSION_DENIED) {
1378 media_content_error("You have no permission for this file %d", ret);
1379 return MEDIA_CONTENT_ERROR_PERMISSION_DENIED;
1381 /* This means this path has to be deleted */
1382 media_content_debug("This path doesn't exists in file system... So now start to delete it from DB");
1383 ret = media_svc_delete_item_by_path(_content_get_db_handle(), storage_id, repl_path, _content_get_uid());
1384 if (ret != MS_MEDIA_ERR_NONE) {
1385 if (ret == MS_MEDIA_ERR_DB_NO_RECORD) {
1386 media_content_error("Does not exist in media DB also... So, this is an invalid parameter");
1387 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
1390 media_content_error("media_svc_delete_item_by_path failed : %d", ret);
1391 return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
1395 return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
1398 void _media_content_scan_cb(media_request_result_s* result, void *user_data)
1401 media_content_scan_cb_data *cb_data = user_data;
1403 err = _content_error_capi(MEDIA_REGISTER_TYPE, result->result);
1404 #ifdef _USE_TVPD_MODE
1405 if (result->request_type != MEDIA_REQUEST_SCAN_COMPLETE &&
1406 result->request_type != MEDIA_REQUEST_SCAN_PARTIAL) {
1407 if (cb_data && cb_data->callback) {
1408 media_content_debug("begin:User callback is being called now, result=%d", err);
1409 cb_data->callback(err, cb_data->user_data);
1410 media_content_debug("end:User callback is being called now, result=%d", err);
1416 if (cb_data && cb_data->callback) {
1417 media_content_debug("User callback is being called now");
1418 cb_data->callback(err, cb_data->user_data);
1427 #ifdef _USE_TVPD_MODE
1428 void _media_content_scan_cb_v2(media_request_result_s* result, void *user_data)
1431 media_content_scan_cb_data_v2 *cb_data = user_data;
1432 media_content_complete_phase_e complete_phase = -1;
1434 media_content_debug("cb_data is NULL");
1435 err = _content_error_capi(MEDIA_REGISTER_TYPE, result->result);
1436 media_content_debug("result is %d", err);
1438 if (result->request_type == MEDIA_REQUEST_SCAN_PARTIAL)
1439 complete_phase = MEDIA_CONTENT_SCAN_PARTIAL_COMPLETE;
1440 else if (result->request_type == MEDIA_REQUEST_SCAN_COMPLETE)
1441 complete_phase = MEDIA_CONTENT_SCAN_COMPLETE;
1442 else if (result->request_type == MEDIA_REQUEST_EXTRACT_COMPLETE)
1443 complete_phase = MEDIA_CONTENT_EXTRACT_COMPLETE;
1445 if (cb_data && cb_data->callback)
1446 cb_data->callback(err, complete_phase, cb_data->user_data);
1448 media_content_debug("run error");
1450 if ((result->request_type != MEDIA_REQUEST_SCAN_COMPLETE) &&
1451 (result->request_type != MEDIA_REQUEST_SCAN_PARTIAL))
1458 static int __media_content_check_dir(const char *path)
1462 char *origin = NULL;
1463 #ifndef _USE_TVPD_MODE
1464 char result_path[MAX_PATH_LEN] = {0, };
1468 media_content_sec_error("path [%s]", path);
1469 media_content_stderror("open dir fail");
1471 if (errno == EACCES || errno == EPERM)
1472 return MEDIA_CONTENT_ERROR_PERMISSION_DENIED;
1474 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
1479 /* Check symbolic link directory */
1480 real = realpath(path, NULL);
1481 /* remove if suffix is '/' */
1482 if (g_str_has_suffix(path, "/"))
1483 origin = g_strndup(path, strlen(path) - 1);
1485 origin = g_strdup(path);
1487 #ifdef _USE_TVPD_MODE
1488 if (g_strcmp0(real, origin) != 0) {
1489 media_content_error("symbolic link(directory)");
1490 media_content_sec_debug("path[%s] real[%s]", origin, real);
1493 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
1496 if (g_str_has_prefix(real, MEDIA_SHARE_PATH)) {
1497 /* If shared dirctory, it should be change path to TZ_USER_SHARE from realpath */
1498 snprintf(result_path, MAX_PATH_LEN, "%s%s", tzplatform_getenv(TZ_USER_MEDIASHARED), real + strlen(MEDIA_SHARE_PATH));
1499 if (g_strcmp0(result_path, origin) != 0) {
1500 media_content_error("symbolic link(directory)");
1501 media_content_sec_debug("path[%s] real[%s]", origin, real);
1504 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
1507 if (g_strcmp0(real, origin) != 0) {
1508 media_content_error("symbolic link(directory)");
1509 media_content_sec_debug("path[%s] real[%s]", origin, real);
1512 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
1520 return MEDIA_CONTENT_ERROR_NONE;
1523 int media_content_scan_folder(const char *path, bool is_recursive, media_scan_completed_cb callback, void *user_data)
1525 int ret = MEDIA_CONTENT_ERROR_NONE;
1526 bool ignore_dir = FALSE;
1527 char storage_id[MEDIA_CONTENT_UUID_SIZE+1] = {0, };
1528 char repl_path[MAX_PATH_LEN] = {0, };
1529 media_svc_storage_type_e storage_type = MEDIA_SVC_STORAGE_MAX;
1531 media_content_retvm_if(!STRING_VALID(path), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid path");
1532 memset(repl_path, 0, sizeof(repl_path));
1533 ret = _media_content_replace_path(path, repl_path);
1534 media_content_retvm_if(!STRING_VALID(repl_path), MEDIA_CONTENT_ERROR_INVALID_OPERATION, "path replacement failed");
1536 memset(storage_id, 0x00, sizeof(storage_id));
1538 ret = __media_content_check_dir(repl_path);
1539 media_content_retvm_if(ret == MEDIA_CONTENT_ERROR_PERMISSION_DENIED, ret, "Permission Denied");
1540 media_content_retvm_if(ret == MEDIA_CONTENT_ERROR_INVALID_PARAMETER, ret, "invalid path[%s]", repl_path);
1542 if (ret == MEDIA_CONTENT_ERROR_NONE) {
1543 /* If directory exist check that's ignore directory or not*/
1544 ret = _media_util_check_ignore_dir(repl_path, &ignore_dir);
1545 media_content_retvm_if(ignore_dir == TRUE, MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid folder path");
1547 /* This means this folder has to be deleted */
1548 /* Or, it is real invalid path.. check storage type */
1549 ret = media_svc_get_storage_type(repl_path, &storage_type, _content_get_uid());
1550 if (ret != MS_MEDIA_ERR_NONE) {
1551 media_content_sec_error("media_svc_get_storage_type failed : %d (%s)", ret, repl_path);
1552 return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
1555 media_content_debug("This path doesn't exists in file system... So will be deleted it from DB");
1558 ret = media_svc_get_storage_id(_content_get_db_handle(), repl_path, storage_id, _content_get_uid());
1559 if (ret != MS_MEDIA_ERR_NONE) {
1560 media_content_error("media_svc_get_storage_id failed : %d", ret);
1561 return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
1564 media_content_scan_cb_data *cb_data = NULL;
1565 cb_data = (media_content_scan_cb_data *)malloc(sizeof(media_content_scan_cb_data));
1566 media_content_retvm_if(cb_data == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY");
1568 cb_data->callback = callback;
1569 cb_data->user_data = user_data;
1571 ret = media_directory_scanning_async(repl_path, storage_id, is_recursive, _media_content_scan_cb, cb_data, _content_get_uid());
1572 if (ret != MS_MEDIA_ERR_NONE) {
1573 media_content_error("media_directory_scanning_async failed : %d", ret);
1577 return _content_error_capi(MEDIA_REGISTER_TYPE, ret);
1580 #ifdef _USE_TVPD_MODE
1581 int media_content_scan_folder_v2(const char *path, bool is_recursive, media_scan_completed_cb_v2 callback, void *user_data)
1583 int ret = MEDIA_CONTENT_ERROR_NONE;
1584 bool ignore_dir = FALSE;
1585 char storage_id[MEDIA_CONTENT_UUID_SIZE+1] = {0, };
1587 media_content_retvm_if(!STRING_VALID(path), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid path");
1588 memset(storage_id, 0x00, sizeof(storage_id));
1590 ret = _media_util_check_ignore_dir(path, &ignore_dir);
1591 media_content_retvm_if(ignore_dir, MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid folder path");
1593 ret = __media_content_check_dir(path);
1594 media_content_retvm_if(ret == MEDIA_CONTENT_ERROR_PERMISSION_DENIED, ret, "Permission Denied");
1595 media_content_retvm_if(ret == MEDIA_CONTENT_ERROR_INVALID_PARAMETER, ret, "invalid path[%s]", path);
1597 media_content_scan_cb_data_v2* cb_data = NULL;
1598 cb_data = (media_content_scan_cb_data_v2*)malloc(sizeof(media_content_scan_cb_data_v2));
1599 media_content_retvm_if(cb_data == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY");
1601 cb_data->callback = callback;
1602 cb_data->user_data = user_data;
1604 ret = media_svc_get_storage_id(_content_get_db_handle(), path, storage_id, _content_get_uid());
1605 /*FIX ME. need to check ret value?*/
1607 ret = media_directory_scanning_async(path, storage_id, is_recursive, _media_content_scan_cb_v2, cb_data, _content_get_uid());
1608 if (ret != MS_MEDIA_ERR_NONE)
1609 media_content_error("media_directory_scanning_async failed : %d", ret);
1611 return _content_error_capi(MEDIA_REGISTER_TYPE, ret);
1615 int media_content_cancel_scan_folder(const char *path)
1617 int ret = MEDIA_CONTENT_ERROR_NONE;
1618 char repl_path[MAX_PATH_LEN] = {0, };
1620 media_content_retvm_if(!STRING_VALID(path), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid path");
1622 memset(repl_path, 0, sizeof(repl_path));
1623 ret = _media_content_replace_path(path, repl_path);
1624 media_content_retvm_if(!STRING_VALID(repl_path), MEDIA_CONTENT_ERROR_INVALID_OPERATION, "path replacement failed");
1626 ret = media_directory_scanning_cancel(repl_path, _content_get_uid());
1627 if (ret != MS_MEDIA_ERR_NONE)
1628 media_content_error("media_directory_scanning_async failed : %d", ret);
1630 return _content_error_capi(MEDIA_REGISTER_TYPE, ret);
1633 void _media_content_db_update_noti_cb(
1635 media_item_type_e item,
1636 media_item_update_type_e update_type,
1639 media_type_e content_type,
1643 int error_value = MEDIA_CONTENT_ERROR_NONE;
1645 media_noti_cb_s *_noti_info = (media_noti_cb_s *)user_data;
1647 if (_noti_info != NULL) {
1648 if (_noti_info->update_noti_cb)
1649 _noti_info->update_noti_cb(error_value, pid, item, update_type, content_type, uuid, path, mime_type, _noti_info->user_data);
1655 int media_content_add_db_updated_cb(media_content_db_update_cb callback, void *user_data, media_content_noti_h *noti_handle)
1657 int ret = MEDIA_CONTENT_ERROR_NONE;
1658 media_noti_cb_s *noti_info = NULL;
1660 if (noti_handle == NULL) {
1661 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
1662 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
1665 if (callback == NULL) {
1666 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
1667 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
1670 noti_info = (media_noti_cb_s *)calloc(1, sizeof(media_noti_cb_s));
1671 if (noti_info == NULL) {
1672 media_content_error("Failed to create noti info");
1673 return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
1676 noti_info->update_noti_cb = callback;
1677 noti_info->user_data = user_data;
1679 ret = media_db_update_subscribe_internal((MediaNotiHandle*)noti_handle, _media_content_db_update_noti_cb, (void *)noti_info);
1681 return _content_error_capi(MEDIA_REGISTER_TYPE, ret);
1684 void __media_content_clear_user_data(void *user_data)
1686 media_noti_cb_s *noti_info = user_data;
1688 SAFE_FREE(noti_info);
1693 int media_content_remove_db_updated_cb(media_content_noti_h noti_handle)
1695 int ret = MEDIA_CONTENT_ERROR_NONE;
1697 ret = media_db_update_unsubscribe_internal((MediaNotiHandle)noti_handle, __media_content_clear_user_data);
1699 return _content_error_capi(MEDIA_REGISTER_TYPE, ret);
1701 #ifdef _USE_TVPD_MODE
1702 GMutex* _content_get_db_mutex(void)