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_content.h>
19 #include <media_info_private.h>
20 #include <media_util_private.h>
22 #include <unicode/uscript.h>
23 #include <unicode/uloc.h>
24 #include <unicode/ucol.h>
25 #include <sys/types.h>
31 static attribute_h g_attr_handle = NULL;
32 static attribute_h g_alias_attr_handle = NULL;
33 static MediaSvcHandle *db_handle = NULL;
34 static int ref_count = 0;
35 static GMutex db_mutex;
37 static __thread media_noti_cb_s *g_noti_info = NULL;
39 static int __media_content_create_attr_handle(void);
40 static int __media_content_create_alias_attr_handle(void);
41 static int __media_content_create_attribute_handle(void);
42 static int __media_content_destroy_attribute_handle(void);
44 static int __media_content_create_attr_handle(void)
46 int ret = MEDIA_CONTENT_ERROR_NONE;
48 ret = _media_filter_attribute_create(&g_attr_handle);
49 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
52 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_ID, DB_FIELD_MEDIA_ID);
53 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
55 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_PATH, DB_FIELD_MEDIA_PATH);
56 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
58 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_DISPLAY_NAME, DB_FIELD_MEDIA_DISPLAY_NAME);
59 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
61 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_TYPE, DB_FIELD_MEDIA_TYPE);
62 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
64 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_MIME_TYPE, DB_FIELD_MEDIA_MIME_TYPE);
65 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
67 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_SIZE, DB_FIELD_MEDIA_SIZE);
68 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
70 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_ADDED_TIME, DB_FIELD_MEDIA_ADDED_TIME);
71 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
73 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_MODIFIED_TIME, DB_FIELD_MEDIA_MODIFIED_TIME);
74 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
76 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_TIMELINE, DB_FIELD_MEDIA_TIMELINE);
77 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
79 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_THUMBNAIL_PATH, DB_FIELD_MEDIA_THUMBNAIL_PATH);
80 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
82 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_TITLE, DB_FIELD_MEDIA_TITLE);
83 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
85 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_ALBUM, DB_FIELD_MEDIA_ALBUM);
86 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
88 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_ARTIST, DB_FIELD_MEDIA_ARTIST);
89 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
91 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_ALBUM_ARTIST, DB_FIELD_MEDIA_ALBUM_ARTIST);
92 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
94 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_GENRE, DB_FIELD_MEDIA_GENRE);
95 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
97 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_COMPOSER, DB_FIELD_MEDIA_COMPOSER);
98 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
100 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_YEAR, DB_FIELD_MEDIA_YEAR);
101 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
103 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_RECORDED_DATE, DB_FIELD_MEDIA_RECORDED_DATE);
104 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
106 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_COPYRIGHT, DB_FIELD_MEDIA_COPYRIGHT);
107 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
109 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_TRACK_NUM, DB_FIELD_MEDIA_TRACK_NUM);
110 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
112 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_DESCRIPTION, DB_FIELD_MEDIA_DESCRIPTION);
113 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
115 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_BITRATE, DB_FIELD_MEDIA_BITRATE);
116 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
118 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_BITPERSAMPLE, DB_FIELD_MEDIA_BITPERSAMPLE);
119 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
121 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_SAMPLERATE, DB_FIELD_MEDIA_SAMPLERATE);
122 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
124 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_CHANNEL, DB_FIELD_MEDIA_CHANNEL);
125 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
127 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_DURATION, DB_FIELD_MEDIA_DURATION);
128 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
130 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_LONGITUDE, DB_FIELD_MEDIA_LONGITUDE);
131 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
133 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_LATITUDE, DB_FIELD_MEDIA_LATITUDE);
134 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
136 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_ALTITUDE, DB_FIELD_MEDIA_ALTITUDE);
137 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
139 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_WIDTH, DB_FIELD_MEDIA_WIDTH);
140 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
142 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_HEIGHT, DB_FIELD_MEDIA_HEIGHT);
143 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
145 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_DATETAKEN, DB_FIELD_MEDIA_DATETAKEN);
146 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
148 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_ORIENTATION, DB_FIELD_MEDIA_ORIENTATION);
149 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
151 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_BURST_ID, DB_FIELD_MEDIA_BURST_ID);
152 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
154 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_PLAYED_COUNT, DB_FIELD_MEDIA_PLAYED_COUNT);
155 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
157 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_LAST_PLAYED_TIME, DB_FIELD_MEDIA_LAST_PLAYED_TIME);
158 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
160 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_LAST_PLAYED_POSITION, DB_FIELD_MEDIA_LAST_PLAYED_POSITION);
161 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
163 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_RATING, DB_FIELD_MEDIA_RATING);
164 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
166 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_FAVOURITE, DB_FIELD_MEDIA_FAVOURITE);
167 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
169 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_AUTHOR, DB_FIELD_MEDIA_AUTHOR);
170 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
172 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_PROVIDER, DB_FIELD_MEDIA_PROVIDER);
173 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
175 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_CONTENT_NAME, DB_FIELD_MEDIA_CONTENT_NAME);
176 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
178 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_CATEGORY, DB_FIELD_MEDIA_CATEGORY);
179 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
181 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_LOCATION_TAG, DB_FIELD_MEDIA_LOCATION_TAG);
182 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
184 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_AGE_RATING, DB_FIELD_MEDIA_AGE_RATING);
185 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
187 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_KEYWORD, DB_FIELD_MEDIA_KEYWORD);
188 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
190 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_WEATHER, DB_FIELD_MEDIA_WEATHER);
191 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
193 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_IS_DRM, DB_FIELD_MEDIA_IS_DRM);
194 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
196 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_STORAGE_TYPE, DB_FIELD_MEDIA_STORAGE_TYPE);
197 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
200 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_FILE_NAME_PINYIN, DB_FIELD_MEDIA_FILE_NAME_PINYIN);
201 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
203 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_TITLE_PINYIN, DB_FIELD_MEDIA_TITLE_PINYIN);
204 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
206 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_ALBUM_PINYIN, DB_FIELD_MEDIA_ALBUM_PINYIN);
207 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
209 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_ARTIST_PINYIN, DB_FIELD_MEDIA_ARTIST_PINYIN);
210 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
212 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_ALBUM_ARTIST_PINYIN, DB_FIELD_MEDIA_ALBUM_ARTIST_PINYIN);
213 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
215 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_GENRE_PINYIN, DB_FIELD_MEDIA_GENRE_PINYIN);
216 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
218 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_COMPOSER_PINYIN, DB_FIELD_MEDIA_COMPOSER_PINYIN);
219 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
221 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_COPYRIGHT_PINYIN, DB_FIELD_MEDIA_COPYRIGHT_PINYIN);
222 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
224 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_DESCRIPTION_PINYIN, DB_FIELD_MEDIA_DESCRIPTION_PINYIN);
225 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
227 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_AUTHOR_PINYIN, DB_FIELD_MEDIA_AUTHOR_PINYIN);
228 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
230 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_PROVIDER_PINYIN, DB_FIELD_MEDIA_PROVIDER_PINYIN);
231 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
233 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_CONTENT_NAME_PINYIN, DB_FIELD_MEDIA_CONTENT_NAME_PINYIN);
234 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
236 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_CATEGORY_PINYIN, DB_FIELD_MEDIA_CATEGORY_PINYIN);
237 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
239 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_LOCATION_TAG_PINYIN, DB_FIELD_MEDIA_LOCATION_TAG_PINYIN);
240 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
242 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_AGE_RATING_PINYIN, DB_FIELD_MEDIA_AGE_RATING_PINYIN);
243 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
245 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_KEYWORD_PINYIN, DB_FIELD_MEDIA_KEYWORD_PINYIN);
246 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
249 ret = _media_filter_attribute_add(g_attr_handle, PLAYLIST_NAME, DB_FIELD_PLAYLIST_NAME);
250 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
252 ret = _media_filter_attribute_add(g_attr_handle, PLAYLIST_MEMBER_ORDER, DB_FIELD_PLAYLIST_MEMBER_ORDER);
253 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
256 ret = _media_filter_attribute_add(g_attr_handle, PLAYLIST_MEDIA_COUNT, DB_FIELD_PLAYLIST_MEDIA_COUNT);
257 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
260 ret = _media_filter_attribute_add(g_attr_handle, TAG_NAME, DB_FIELD_TAG_NAME);
261 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
264 ret = _media_filter_attribute_add(g_attr_handle, TAG_MEDIA_COUNT, DB_FIELD_TAG_MEDIA_COUNT);
265 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
268 ret = _media_filter_attribute_add(g_attr_handle, BOOKMARK_MARKED_TIME, DB_FIELD_BOOKMARK_MARKED_TIME);
269 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
272 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_STORAGE_ID, DB_FIELD_STORAGE_ID);
273 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
275 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_STORAGE_PATH, DB_FIELD_STORAGE_PATH);
276 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
281 static int __media_content_create_alias_attr_handle(void)
283 int ret = MEDIA_CONTENT_ERROR_NONE;
285 ret = _media_filter_attribute_create(&g_alias_attr_handle);
286 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
289 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_ID, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ID);
290 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
292 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_PATH, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_PATH);
293 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
295 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_DISPLAY_NAME, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_DISPLAY_NAME);
296 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
298 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_TYPE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_TYPE);
299 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
301 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_MIME_TYPE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_MIME_TYPE);
302 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
304 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_SIZE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_SIZE);
305 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
307 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_ADDED_TIME, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ADDED_TIME);
308 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
310 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_MODIFIED_TIME, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_MODIFIED_TIME);
311 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
313 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_TIMELINE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_TIMELINE);
314 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
316 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_THUMBNAIL_PATH, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_THUMBNAIL_PATH);
317 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
319 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_TITLE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_TITLE);
320 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
322 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_ALBUM, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ALBUM);
323 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
325 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_ARTIST, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ARTIST);
326 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
328 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_ALBUM_ARTIST, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ALBUM_ARTIST);
329 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
331 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_GENRE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_GENRE);
332 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
334 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_COMPOSER, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_COMPOSER);
335 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
337 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_YEAR, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_YEAR);
338 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
340 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_RECORDED_DATE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_RECORDED_DATE);
341 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
343 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_COPYRIGHT, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_COPYRIGHT);
344 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
346 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_TRACK_NUM, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_TRACK_NUM);
347 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
349 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_DESCRIPTION, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_DESCRIPTION);
350 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
352 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_BITRATE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_BITRATE);
353 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
355 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_BITPERSAMPLE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_BITPERSAMPLE);
356 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
358 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_SAMPLERATE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_SAMPLERATE);
359 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
361 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_CHANNEL, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_CHANNEL);
362 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
364 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_DURATION, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_DURATION);
365 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
367 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_LONGITUDE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_LONGITUDE);
368 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
370 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_LATITUDE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_LATITUDE);
371 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
373 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_ALTITUDE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ALTITUDE);
374 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
376 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_WIDTH, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_WIDTH);
377 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
379 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_HEIGHT, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_HEIGHT);
380 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
382 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_DATETAKEN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_DATETAKEN);
383 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
385 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_ORIENTATION, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ORIENTATION);
386 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
388 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_BURST_ID, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_BURST_ID);
389 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
391 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_PLAYED_COUNT, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_PLAYED_COUNT);
392 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
394 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_LAST_PLAYED_TIME, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_LAST_PLAYED_TIME);
395 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
397 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_LAST_PLAYED_POSITION, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_LAST_PLAYED_POSITION);
398 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
400 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_RATING, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_RATING);
401 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
403 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_FAVOURITE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_FAVOURITE);
404 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
406 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_AUTHOR, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_AUTHOR);
407 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
409 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_PROVIDER, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_PROVIDER);
410 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
412 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_CONTENT_NAME, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_CONTENT_NAME);
413 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
415 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_CATEGORY, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_CATEGORY);
416 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
418 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_LOCATION_TAG, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_LOCATION_TAG);
419 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
421 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_AGE_RATING, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_AGE_RATING);
422 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
424 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_KEYWORD, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_KEYWORD);
425 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
427 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_WEATHER, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_WEATHER);
428 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
430 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_IS_DRM, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_IS_DRM);
431 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
433 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_STORAGE_TYPE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_STORAGE_TYPE);
434 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
437 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_FILE_NAME_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_FILE_NAME_PINYIN);
438 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
440 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_TITLE_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_TITLE_PINYIN);
441 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
443 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_ALBUM_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ALBUM_PINYIN);
444 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
446 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_ARTIST_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ARTIST_PINYIN);
447 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
449 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_ALBUM_ARTIST_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ALBUM_ARTIST_PINYIN);
450 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
452 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_GENRE_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_GENRE_PINYIN);
453 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
455 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_COMPOSER_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_COMPOSER_PINYIN);
456 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
458 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_COPYRIGHT_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_COPYRIGHT_PINYIN);
459 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
461 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_DESCRIPTION_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_DESCRIPTION_PINYIN);
462 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
464 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_AUTHOR_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_AUTHOR_PINYIN);
465 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
467 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_PROVIDER_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_PROVIDER_PINYIN);
468 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
470 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_CONTENT_NAME_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_CONTENT_NAME_PINYIN);
471 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
473 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_CATEGORY_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_CATEGORY_PINYIN);
474 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
476 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_LOCATION_TAG_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_LOCATION_TAG_PINYIN);
477 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
479 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_AGE_RATING_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_AGE_RATING_PINYIN);
480 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
482 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_KEYWORD_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_KEYWORD_PINYIN);
483 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
486 ret = _media_filter_attribute_add(g_alias_attr_handle, FOLDER_ID, DB_TABLE_ALIAS_FOLDER"."DB_FIELD_FOLDER_ID);
487 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
489 ret = _media_filter_attribute_add(g_alias_attr_handle, FOLDER_PATH, DB_TABLE_ALIAS_FOLDER"."DB_FIELD_FOLDER_PATH);
490 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
492 ret = _media_filter_attribute_add(g_alias_attr_handle, FOLDER_NAME, DB_TABLE_ALIAS_FOLDER"."DB_FIELD_FOLDER_NAME);
493 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
495 ret = _media_filter_attribute_add(g_alias_attr_handle, FOLDER_MODIFIED_TIME, DB_TABLE_ALIAS_FOLDER"."DB_FIELD_FOLDER_MODIFIED_TIME);
496 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
498 ret = _media_filter_attribute_add(g_alias_attr_handle, FOLDER_STORAGE_TYPE, DB_TABLE_ALIAS_FOLDER"."DB_FIELD_FOLDER_STORAGE_TYPE);
499 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
501 ret = _media_filter_attribute_add(g_alias_attr_handle, FOLDER_NAME_PINYIN, DB_TABLE_ALIAS_FOLDER"."DB_FIELD_FOLDER_NAME_PINYIN);
502 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
504 ret = _media_filter_attribute_add(g_alias_attr_handle, FOLDER_ORDER, DB_TABLE_ALIAS_FOLDER"."DB_FIELD_FOLDER_ORDER);
505 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
507 ret = _media_filter_attribute_add(g_alias_attr_handle, FOLDER_PARENT_FOLDER_ID, DB_TABLE_ALIAS_FOLDER"."DB_FIELD_FOLDER_PARENT_FOLDER_ID);
508 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
510 ret = _media_filter_attribute_add(g_alias_attr_handle, PLAYLIST_NAME, DB_TABLE_ALIAS_PLAYLIST"."DB_FIELD_PLAYLIST_NAME);
511 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
513 ret = _media_filter_attribute_add(g_alias_attr_handle, PLAYLIST_MEMBER_ORDER, DB_TABLE_ALIAS_PLAYLIST_MAP"."DB_FIELD_PLAYLIST_MEMBER_ORDER);
514 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
517 ret = _media_filter_attribute_add(g_alias_attr_handle, TAG_NAME, DB_TABLE_ALIAS_TAG"."DB_FIELD_TAG_NAME);
518 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
521 ret = _media_filter_attribute_add(g_alias_attr_handle, BOOKMARK_MARKED_TIME, DB_TABLE_ALIAS_BOOKMARK"."DB_FIELD_BOOKMARK_MARKED_TIME);
522 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
527 static int __media_content_create_attribute_handle(void)
529 int ret = MEDIA_CONTENT_ERROR_NONE;
531 ret = __media_content_create_attr_handle();
532 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
534 ret = __media_content_create_alias_attr_handle();
535 if(ret != MEDIA_CONTENT_ERROR_NONE)
536 _media_filter_attribute_destory(g_attr_handle);
541 static int __media_content_destroy_attribute_handle(void)
543 int ret = MEDIA_CONTENT_ERROR_NONE;
545 ret = _media_filter_attribute_destory(g_attr_handle);
546 ret = _media_filter_attribute_destory(g_alias_attr_handle);
548 g_attr_handle = NULL;
549 g_alias_attr_handle = NULL;
554 attribute_h _content_get_attirbute_handle(void)
556 return g_attr_handle;
559 attribute_h _content_get_alias_attirbute_handle(void)
561 return g_alias_attr_handle;
564 MediaSvcHandle* _content_get_db_handle(void)
569 int _content_query_prepare(sqlite3_stmt **stmt, char *select_query, char *condition_query, char *option_query)
572 int err = MEDIA_CONTENT_ERROR_NONE;
573 char query[MAX_QUERY_SIZE] = {0, };
574 memset(query, '\0', sizeof(query));
576 media_content_retvm_if(db_handle == NULL, MEDIA_CONTENT_ERROR_DB_FAILED, "database is not connected");
577 media_content_retvm_if(!STRING_VALID(select_query), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "invalid select_query");
579 if(!STRING_VALID(condition_query)) {
580 condition_query = (char *)" ";
583 if(!STRING_VALID(option_query)) {
584 option_query = (char *)" ";
588 //query = sqlite3_mprintf("%s %s %s", select_query, condition_query, option_query);
589 len = snprintf(query, sizeof(query), "%s %s %s", select_query, condition_query, option_query);
590 if (len > 0 && len < MAX_QUERY_SIZE) {
592 } else if (len >= MAX_QUERY_SIZE) {
593 query[MAX_QUERY_SIZE -1] = '\0';
595 media_content_error("snprintf failed");
596 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
599 media_content_sec_debug("Query : [%s]", query);
601 err = sqlite3_prepare_v2((sqlite3*)db_handle, query, strlen(query), stmt, NULL);
604 media_content_error("DB_FAILED(0x%08x) fail to sqlite3_prepare(), %s", MEDIA_CONTENT_ERROR_DB_FAILED, sqlite3_errmsg((sqlite3*)db_handle));
606 if (err == SQLITE_BUSY) {
607 media_content_error(" BUSY ERROR");
608 return MEDIA_CONTENT_ERROR_DB_BUSY;
609 } else if (err == SQLITE_PERM) {
610 media_content_error("PERMISSION EROR");
611 return MEDIA_CONTENT_ERROR_PERMISSION_DENIED;
613 media_content_error("OTHER ERROR");
614 return MEDIA_CONTENT_ERROR_DB_FAILED;
618 return MEDIA_CONTENT_ERROR_NONE;
621 int _content_error_capi(int type, int content_error)
623 if(content_error != MEDIA_CONTENT_ERROR_NONE)
625 media_content_error("[type : %d] content_error : %d ", type, content_error);
629 if(content_error == MS_MEDIA_ERR_NONE)
630 return MEDIA_CONTENT_ERROR_NONE;
632 /* Internal operation error*/
633 else if((content_error == MS_MEDIA_ERR_INVALID_PARAMETER) ||
634 (content_error == MS_MEDIA_ERR_INVALID_PATH) ||
635 (content_error == MS_MEDIA_ERR_THUMB_DUPLICATED_REQUEST))
636 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
638 else if(content_error == MS_MEDIA_ERR_OUT_OF_MEMORY)
639 return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
641 /* DB operation error*/
642 else if(content_error == MS_MEDIA_ERR_DB_BUSY_FAIL)
643 return MEDIA_CONTENT_ERROR_DB_BUSY;
645 else if((content_error <= MS_MEDIA_ERR_DB_CONNECT_FAIL) && (content_error >= MS_MEDIA_ERR_DB_INTERNAL))
646 return MEDIA_CONTENT_ERROR_DB_FAILED;
648 /* IPC operation error*/
649 else if((content_error <= MS_MEDIA_ERR_SOCKET_CONN) && (content_error >= MS_MEDIA_ERR_SOCKET_INTERNAL))
650 return MEDIA_CONTENT_ERROR_NETWORK;
652 /* MEDIA SERVER error*/
653 else if(content_error == MS_MEDIA_ERR_PERMISSION_DENIED)
654 return MEDIA_CONTENT_ERROR_PERMISSION_DENIED;
657 else if(content_error == MS_MEDIA_ERR_THUMB_TOO_BIG)
658 return MEDIA_CONTENT_ERROR_UNSUPPORTED_CONTENT;
661 return MEDIA_CONTENT_ERROR_INVALID_OPERATION;
664 int _content_query_sql(char *query_str)
666 int ret = MEDIA_CONTENT_ERROR_NONE;
668 //DB will be updated by Media Server.
669 ret = media_svc_request_update_db(query_str,tzplatform_getuid(TZ_USER_NAME));
671 return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
674 int media_content_connect(void)
676 int ret = MEDIA_CONTENT_ERROR_NONE;
678 if (g_mutex_trylock(&db_mutex)) {
679 media_content_info("ref count : %d", ref_count);
683 if(db_handle == NULL)
685 ret = __media_content_create_attribute_handle();
686 if(ret == MEDIA_CONTENT_ERROR_NONE) {
687 ret = media_svc_connect(&db_handle,tzplatform_getuid(TZ_USER_NAME), false);
688 ret = _content_error_capi(MEDIA_CONTENT_TYPE, ret);
689 if(ret == MEDIA_CONTENT_ERROR_NONE) {
692 __media_content_destroy_attribute_handle();
695 media_content_error("Internal DB Connection Error");
698 media_content_error("Wrong DB Connection status");
699 ret = MEDIA_CONTENT_ERROR_DB_FAILED;
702 if(db_handle != NULL) {
705 media_content_error("Wrong DB Handle status");
706 ret = MEDIA_CONTENT_ERROR_DB_FAILED;
710 media_content_info("ref count changed to: %d", ref_count);
711 g_mutex_unlock(&db_mutex);
713 media_content_error("mutex is NULL");
714 ret = MEDIA_CONTENT_ERROR_DB_FAILED;
720 int media_content_disconnect(void)
722 int ret = MEDIA_CONTENT_ERROR_NONE;
724 if (g_mutex_trylock(&db_mutex)) {
725 media_content_debug("ref count : %d", ref_count);
728 if(db_handle != NULL) {
731 media_content_error("Wrong DB Handle status");
732 ret = MEDIA_CONTENT_ERROR_DB_FAILED;
737 media_content_error("DB_FAILED(0x%08x) database is not connected", MEDIA_CONTENT_ERROR_DB_FAILED);
738 g_mutex_unlock(&db_mutex);
739 return MEDIA_CONTENT_ERROR_DB_FAILED;
744 if(db_handle != NULL)
746 ret = media_svc_disconnect(db_handle);
747 ret = _content_error_capi(MEDIA_CONTENT_TYPE, ret);
748 if(ret == MEDIA_CONTENT_ERROR_NONE) {
749 ret = __media_content_destroy_attribute_handle();
752 media_content_error("database disconnect fail");
756 media_content_error("Wrong DB Handle status");
757 ret = MEDIA_CONTENT_ERROR_DB_FAILED;
760 g_mutex_unlock(&db_mutex);
762 media_content_info("ref count changed to: %d", ref_count);
767 g_mutex_unlock(&db_mutex);
769 media_content_error("mutex is NULL");
770 ret = MEDIA_CONTENT_ERROR_INVALID_OPERATION;
773 media_content_info("ref count changed to: %d", ref_count);
778 int media_content_scan_file(const char *path)
780 int ret = MEDIA_CONTENT_ERROR_NONE;
781 bool ignore_file = FALSE;
782 bool ignore_dir = FALSE;
783 char *folder_path = NULL;
784 int check_file = MEDIA_CONTENT_ERROR_NONE;
785 char storage_id[MEDIA_CONTENT_UUID_SIZE+1] = {0,};
787 media_content_retvm_if(!STRING_VALID(path), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "invalid path");
789 media_content_sec_debug("Path : %s", path);
791 ret = _media_util_check_ignore_file(path, &ignore_file);
792 media_content_retvm_if(ignore_file == TRUE, MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid path");
794 memset(storage_id, 0x00, sizeof(storage_id));
795 ret = media_svc_get_storage_id(_content_get_db_handle(), path, storage_id);
796 if(ret != MS_MEDIA_ERR_NONE)
798 media_content_error("media_svc_get_storage_id failed : %d", ret);
799 return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
802 check_file = _media_util_check_file_exist(path);
803 if (check_file == MEDIA_CONTENT_ERROR_NONE) {
804 /* This means this path has to be inserted or refreshed */
805 folder_path = g_path_get_dirname(path);
806 ret = _media_util_check_ignore_dir(folder_path, &ignore_dir);
807 SAFE_FREE(folder_path);
809 media_content_retvm_if(ignore_dir == TRUE, MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid folder path");
811 media_svc_storage_type_e storage_type;
813 ret = media_svc_get_storage_type(path, &storage_type, tzplatform_getuid(TZ_USER_NAME));
814 if(ret != MS_MEDIA_ERR_NONE) {
815 media_content_sec_error("media_svc_get_storage_type failed : %d (%s)", ret, path);
816 return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
818 ret = media_svc_check_item_exist_by_path(_content_get_db_handle(), storage_id, path);
819 if (ret == MS_MEDIA_ERR_NONE) {
821 ret = media_svc_refresh_item(_content_get_db_handle(), storage_id, storage_type, path,tzplatform_getuid(TZ_USER_NAME));
822 if(ret != MS_MEDIA_ERR_NONE) {
823 media_content_error("media_svc_refresh_item failed : %d", ret);
824 return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
827 } else if (ret == MS_MEDIA_ERR_DB_NO_RECORD) {
829 ret = media_svc_insert_item_immediately(_content_get_db_handle(), storage_id, storage_type, path,tzplatform_getuid(TZ_USER_NAME));
830 if(ret != MS_MEDIA_ERR_NONE) {
831 if (ret == MS_MEDIA_ERR_DB_CONSTRAINT_FAIL) {
832 media_content_sec_error("This item is already inserted. This may be normal operation because other process already did this (%s)", path);
833 ret = MEDIA_CONTENT_ERROR_NONE;
835 media_content_sec_error("media_svc_insert_item_immediately failed : %d (%s)", ret, path);
838 return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
841 media_content_error("media_svc_check_item_exist_by_path failed : %d", ret);
842 return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
844 } else if (check_file == MEDIA_CONTENT_ERROR_PERMISSION_DENIED) {
845 media_content_error("You have no permission for this file %d", ret);
846 return MEDIA_CONTENT_ERROR_PERMISSION_DENIED;
848 /* This means this path has to be deleted */
849 media_content_debug("This path doesn't exists in file system... So now start to delete it from DB");
850 ret = media_svc_delete_item_by_path(_content_get_db_handle(), storage_id, path, tzplatform_getuid(TZ_USER_NAME));
851 if(ret != MS_MEDIA_ERR_NONE) {
852 media_content_error("media_svc_delete_item_by_path failed : %d", ret);
853 return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
857 return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
860 void _media_content_scan_cb(media_request_result_s* result, void *user_data)
863 media_content_scan_cb_data *cb_data = user_data;
865 err = result->result;
867 if (cb_data && cb_data->callback) {
868 media_content_debug("User callback is being called now");
869 cb_data->callback(err, cb_data->user_data);
877 static int __media_content_check_dir(const char *path)
883 media_content_sec_error("path [%s]", path);
884 media_content_stderror("open dir fail");
886 if (errno == EACCES || errno == EPERM) {
887 return MEDIA_CONTENT_ERROR_PERMISSION_DENIED;
889 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
895 return MEDIA_CONTENT_ERROR_NONE;
898 int media_content_scan_folder(const char *path, bool is_recursive, media_scan_completed_cb callback, void *user_data)
900 int ret = MEDIA_CONTENT_ERROR_NONE;
901 bool ignore_dir = FALSE;
902 char storage_id[MEDIA_CONTENT_UUID_SIZE+1] = {0, };
904 media_content_retvm_if(!STRING_VALID(path), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid path");
906 memset(storage_id, 0x00, sizeof(storage_id));
908 ret = __media_content_check_dir(path);
909 media_content_retvm_if(ret == MEDIA_CONTENT_ERROR_PERMISSION_DENIED, ret, "Permission Denied");
911 ret = _media_util_check_ignore_dir(path, &ignore_dir);
912 media_content_retvm_if(ignore_dir, MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid folder path");
914 media_content_scan_cb_data *cb_data = NULL;
915 cb_data = (media_content_scan_cb_data *)malloc(sizeof(media_content_scan_cb_data));
916 media_content_retvm_if(cb_data == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY");
918 cb_data->callback = callback;
919 cb_data->user_data = user_data;
921 ret = media_svc_get_storage_id(_content_get_db_handle(), path, storage_id);
922 /*FIX ME. need to check ret value?*/
924 ret = media_directory_scanning_async(path, storage_id, is_recursive, _media_content_scan_cb, cb_data, tzplatform_getuid(TZ_USER_NAME));
925 if(ret != MS_MEDIA_ERR_NONE) {
926 media_content_error("media_directory_scanning_async failed : %d", ret);
929 return _content_error_capi(MEDIA_REGISTER_TYPE, ret);
932 int media_content_cancel_scan_folder(const char *path)
934 int ret = MEDIA_CONTENT_ERROR_NONE;
936 ret = media_directory_scanning_cancel(path, tzplatform_getuid(TZ_USER_NAME));
937 if(ret != MS_MEDIA_ERR_NONE) {
938 media_content_error("media_directory_scanning_async failed : %d", ret);
941 return _content_error_capi(MEDIA_REGISTER_TYPE, ret);
944 void _media_content_db_update_noti_cb(
946 media_item_type_e item,
947 media_item_update_type_e update_type,
950 media_type_e content_type,
954 int error_value = MEDIA_CONTENT_ERROR_NONE;
956 media_noti_cb_s *_noti_info = (media_noti_cb_s *)user_data;
958 if(_noti_info != NULL)
960 if (_noti_info->update_noti_cb)
961 _noti_info->update_noti_cb(error_value, pid, item, update_type, content_type, uuid, path, mime_type, _noti_info->user_data);
967 int media_content_set_db_updated_cb(media_content_db_update_cb callback, void *user_data)
969 int ret = MEDIA_CONTENT_ERROR_NONE;
971 media_content_retvm_if(callback == NULL, MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid callback");
972 media_content_retvm_if(g_noti_info != NULL, MEDIA_CONTENT_ERROR_INVALID_OPERATION, "Noti callback is already set");
974 g_noti_info = (media_noti_cb_s*)calloc(1, sizeof(media_noti_cb_s));
975 media_content_retvm_if(g_noti_info == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY");
977 g_noti_info->update_noti_cb = callback;
978 g_noti_info->user_data = user_data;
980 ret = media_db_update_subscribe(_media_content_db_update_noti_cb, (void *)g_noti_info);
982 return _content_error_capi(MEDIA_REGISTER_TYPE, ret);
985 int media_content_unset_db_updated_cb(void)
987 int ret = MEDIA_CONTENT_ERROR_NONE;
989 SAFE_FREE(g_noti_info);
990 ret = media_db_update_unsubscribe();
992 return _content_error_capi(MEDIA_REGISTER_TYPE, ret);