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>
21 #include <media_content_internal.h>
23 #include <unicode/uscript.h>
24 #include <unicode/uloc.h>
25 #include <unicode/ucol.h>
26 #include <sys/types.h>
33 #include <cynara-client.h>
34 #include <cynara-session.h>
35 #include <cynara-error.h>
36 #include <cynara-creds-socket.h>
38 static attribute_h g_attr_handle = NULL;
39 static attribute_h g_alias_attr_handle = NULL;
40 static MediaSvcHandle *db_handle = NULL;
41 static int ref_count = 0;
42 static GMutex db_mutex;
44 #define SCM_SECURITY 0x03
47 static cynara *_cynara = NULL;
48 G_LOCK_DEFINE_STATIC(cynara_mutex);
50 static __thread media_noti_cb_s *g_noti_info = NULL;
52 static int __media_content_create_attr_handle(void);
53 static int __media_content_create_alias_attr_handle(void);
54 static int __media_content_create_attribute_handle(void);
55 static int __media_content_destroy_attribute_handle(void);
57 static int __media_content_create_attr_handle(void)
59 int ret = MEDIA_CONTENT_ERROR_NONE;
61 ret = _media_filter_attribute_create(&g_attr_handle);
62 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
65 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_ID, DB_FIELD_MEDIA_ID);
66 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
68 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_PATH, DB_FIELD_MEDIA_PATH);
69 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
71 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_DISPLAY_NAME, DB_FIELD_MEDIA_DISPLAY_NAME);
72 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
74 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_TYPE, DB_FIELD_MEDIA_TYPE);
75 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
77 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_MIME_TYPE, DB_FIELD_MEDIA_MIME_TYPE);
78 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
80 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_SIZE, DB_FIELD_MEDIA_SIZE);
81 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
83 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_ADDED_TIME, DB_FIELD_MEDIA_ADDED_TIME);
84 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
86 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_MODIFIED_TIME, DB_FIELD_MEDIA_MODIFIED_TIME);
87 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
89 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_TIMELINE, DB_FIELD_MEDIA_TIMELINE);
90 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
92 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_THUMBNAIL_PATH, DB_FIELD_MEDIA_THUMBNAIL_PATH);
93 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
95 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_TITLE, DB_FIELD_MEDIA_TITLE);
96 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
98 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_ALBUM, DB_FIELD_MEDIA_ALBUM);
99 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
101 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_ARTIST, DB_FIELD_MEDIA_ARTIST);
102 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
104 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_ALBUM_ARTIST, DB_FIELD_MEDIA_ALBUM_ARTIST);
105 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
107 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_GENRE, DB_FIELD_MEDIA_GENRE);
108 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
110 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_COMPOSER, DB_FIELD_MEDIA_COMPOSER);
111 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
113 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_YEAR, DB_FIELD_MEDIA_YEAR);
114 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
116 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_RECORDED_DATE, DB_FIELD_MEDIA_RECORDED_DATE);
117 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
119 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_COPYRIGHT, DB_FIELD_MEDIA_COPYRIGHT);
120 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
122 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_TRACK_NUM, DB_FIELD_MEDIA_TRACK_NUM);
123 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
125 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_DESCRIPTION, DB_FIELD_MEDIA_DESCRIPTION);
126 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
128 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_BITRATE, DB_FIELD_MEDIA_BITRATE);
129 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
131 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_BITPERSAMPLE, DB_FIELD_MEDIA_BITPERSAMPLE);
132 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
134 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_SAMPLERATE, DB_FIELD_MEDIA_SAMPLERATE);
135 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
137 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_CHANNEL, DB_FIELD_MEDIA_CHANNEL);
138 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
140 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_DURATION, DB_FIELD_MEDIA_DURATION);
141 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
143 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_LONGITUDE, DB_FIELD_MEDIA_LONGITUDE);
144 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
146 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_LATITUDE, DB_FIELD_MEDIA_LATITUDE);
147 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
149 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_ALTITUDE, DB_FIELD_MEDIA_ALTITUDE);
150 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
152 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_WIDTH, DB_FIELD_MEDIA_WIDTH);
153 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
155 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_HEIGHT, DB_FIELD_MEDIA_HEIGHT);
156 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
158 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_DATETAKEN, DB_FIELD_MEDIA_DATETAKEN);
159 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
161 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_ORIENTATION, DB_FIELD_MEDIA_ORIENTATION);
162 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
164 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_BURST_ID, DB_FIELD_MEDIA_BURST_ID);
165 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
167 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_PLAYED_COUNT, DB_FIELD_MEDIA_PLAYED_COUNT);
168 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
170 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_LAST_PLAYED_TIME, DB_FIELD_MEDIA_LAST_PLAYED_TIME);
171 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
173 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_LAST_PLAYED_POSITION, DB_FIELD_MEDIA_LAST_PLAYED_POSITION);
174 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
176 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_RATING, DB_FIELD_MEDIA_RATING);
177 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
179 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_FAVOURITE, DB_FIELD_MEDIA_FAVOURITE);
180 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
182 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_AUTHOR, DB_FIELD_MEDIA_AUTHOR);
183 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
185 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_PROVIDER, DB_FIELD_MEDIA_PROVIDER);
186 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
188 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_CONTENT_NAME, DB_FIELD_MEDIA_CONTENT_NAME);
189 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
191 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_CATEGORY, DB_FIELD_MEDIA_CATEGORY);
192 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
194 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_LOCATION_TAG, DB_FIELD_MEDIA_LOCATION_TAG);
195 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
197 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_AGE_RATING, DB_FIELD_MEDIA_AGE_RATING);
198 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
200 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_KEYWORD, DB_FIELD_MEDIA_KEYWORD);
201 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
203 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_WEATHER, DB_FIELD_MEDIA_WEATHER);
204 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
206 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_IS_DRM, DB_FIELD_MEDIA_IS_DRM);
207 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
209 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_STORAGE_TYPE, DB_FIELD_MEDIA_STORAGE_TYPE);
210 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
213 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_FILE_NAME_PINYIN, DB_FIELD_MEDIA_FILE_NAME_PINYIN);
214 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
216 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_TITLE_PINYIN, DB_FIELD_MEDIA_TITLE_PINYIN);
217 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
219 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_ALBUM_PINYIN, DB_FIELD_MEDIA_ALBUM_PINYIN);
220 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
222 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_ARTIST_PINYIN, DB_FIELD_MEDIA_ARTIST_PINYIN);
223 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
225 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_ALBUM_ARTIST_PINYIN, DB_FIELD_MEDIA_ALBUM_ARTIST_PINYIN);
226 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
228 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_GENRE_PINYIN, DB_FIELD_MEDIA_GENRE_PINYIN);
229 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
231 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_COMPOSER_PINYIN, DB_FIELD_MEDIA_COMPOSER_PINYIN);
232 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
234 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_COPYRIGHT_PINYIN, DB_FIELD_MEDIA_COPYRIGHT_PINYIN);
235 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
237 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_DESCRIPTION_PINYIN, DB_FIELD_MEDIA_DESCRIPTION_PINYIN);
238 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
240 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_AUTHOR_PINYIN, DB_FIELD_MEDIA_AUTHOR_PINYIN);
241 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
243 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_PROVIDER_PINYIN, DB_FIELD_MEDIA_PROVIDER_PINYIN);
244 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
246 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_CONTENT_NAME_PINYIN, DB_FIELD_MEDIA_CONTENT_NAME_PINYIN);
247 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
249 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_CATEGORY_PINYIN, DB_FIELD_MEDIA_CATEGORY_PINYIN);
250 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
252 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_LOCATION_TAG_PINYIN, DB_FIELD_MEDIA_LOCATION_TAG_PINYIN);
253 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
255 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_AGE_RATING_PINYIN, DB_FIELD_MEDIA_AGE_RATING_PINYIN);
256 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
258 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_KEYWORD_PINYIN, DB_FIELD_MEDIA_KEYWORD_PINYIN);
259 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
262 ret = _media_filter_attribute_add(g_attr_handle, PLAYLIST_NAME, DB_FIELD_PLAYLIST_NAME);
263 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
265 ret = _media_filter_attribute_add(g_attr_handle, PLAYLIST_MEMBER_ORDER, DB_FIELD_PLAYLIST_MEMBER_ORDER);
266 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
269 ret = _media_filter_attribute_add(g_attr_handle, PLAYLIST_MEDIA_COUNT, DB_FIELD_PLAYLIST_MEDIA_COUNT);
270 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
273 ret = _media_filter_attribute_add(g_attr_handle, TAG_NAME, DB_FIELD_TAG_NAME);
274 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
277 ret = _media_filter_attribute_add(g_attr_handle, TAG_MEDIA_COUNT, DB_FIELD_TAG_MEDIA_COUNT);
278 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
281 ret = _media_filter_attribute_add(g_attr_handle, BOOKMARK_MARKED_TIME, DB_FIELD_BOOKMARK_MARKED_TIME);
282 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
284 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_360, DB_FIELD_MEDIA_360);
285 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
288 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_STORAGE_ID, DB_FIELD_STORAGE_ID);
289 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
291 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_STORAGE_PATH, DB_FIELD_STORAGE_PATH);
292 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
295 ret = _media_filter_attribute_add(g_attr_handle, MEDIA_FACE_TAG, DB_FIELD_FACE_TAG);
296 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
301 static int __media_content_create_alias_attr_handle(void)
303 int ret = MEDIA_CONTENT_ERROR_NONE;
305 ret = _media_filter_attribute_create(&g_alias_attr_handle);
306 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
309 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_ID, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ID);
310 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
312 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_PATH, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_PATH);
313 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
315 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_DISPLAY_NAME, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_DISPLAY_NAME);
316 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
318 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_TYPE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_TYPE);
319 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
321 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_MIME_TYPE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_MIME_TYPE);
322 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
324 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_SIZE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_SIZE);
325 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
327 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_ADDED_TIME, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ADDED_TIME);
328 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
330 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_MODIFIED_TIME, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_MODIFIED_TIME);
331 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
333 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_TIMELINE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_TIMELINE);
334 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
336 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_THUMBNAIL_PATH, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_THUMBNAIL_PATH);
337 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
339 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_TITLE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_TITLE);
340 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
342 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_ALBUM, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ALBUM);
343 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
345 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_ARTIST, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ARTIST);
346 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
348 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_ALBUM_ARTIST, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ALBUM_ARTIST);
349 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
351 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_GENRE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_GENRE);
352 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
354 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_COMPOSER, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_COMPOSER);
355 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
357 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_YEAR, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_YEAR);
358 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
360 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_RECORDED_DATE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_RECORDED_DATE);
361 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
363 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_COPYRIGHT, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_COPYRIGHT);
364 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
366 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_TRACK_NUM, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_TRACK_NUM);
367 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
369 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_DESCRIPTION, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_DESCRIPTION);
370 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
372 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_BITRATE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_BITRATE);
373 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
375 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_BITPERSAMPLE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_BITPERSAMPLE);
376 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
378 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_SAMPLERATE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_SAMPLERATE);
379 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
381 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_CHANNEL, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_CHANNEL);
382 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
384 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_DURATION, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_DURATION);
385 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
387 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_LONGITUDE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_LONGITUDE);
388 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
390 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_LATITUDE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_LATITUDE);
391 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
393 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_ALTITUDE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ALTITUDE);
394 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
396 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_WIDTH, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_WIDTH);
397 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
399 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_HEIGHT, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_HEIGHT);
400 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
402 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_DATETAKEN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_DATETAKEN);
403 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
405 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_ORIENTATION, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ORIENTATION);
406 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
408 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_BURST_ID, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_BURST_ID);
409 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
411 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_PLAYED_COUNT, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_PLAYED_COUNT);
412 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
414 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_LAST_PLAYED_TIME, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_LAST_PLAYED_TIME);
415 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
417 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_LAST_PLAYED_POSITION, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_LAST_PLAYED_POSITION);
418 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
420 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_RATING, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_RATING);
421 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
423 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_FAVOURITE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_FAVOURITE);
424 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
426 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_AUTHOR, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_AUTHOR);
427 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
429 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_PROVIDER, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_PROVIDER);
430 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
432 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_CONTENT_NAME, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_CONTENT_NAME);
433 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
435 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_CATEGORY, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_CATEGORY);
436 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
438 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_LOCATION_TAG, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_LOCATION_TAG);
439 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
441 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_AGE_RATING, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_AGE_RATING);
442 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
444 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_KEYWORD, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_KEYWORD);
445 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
447 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_WEATHER, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_WEATHER);
448 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
450 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_IS_DRM, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_IS_DRM);
451 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
453 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_STORAGE_TYPE, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_STORAGE_TYPE);
454 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
456 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_360, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_360);
457 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
460 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_FILE_NAME_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_FILE_NAME_PINYIN);
461 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
463 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_TITLE_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_TITLE_PINYIN);
464 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
466 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_ALBUM_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ALBUM_PINYIN);
467 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
469 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_ARTIST_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ARTIST_PINYIN);
470 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
472 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_ALBUM_ARTIST_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ALBUM_ARTIST_PINYIN);
473 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
475 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_GENRE_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_GENRE_PINYIN);
476 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
478 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_COMPOSER_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_COMPOSER_PINYIN);
479 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
481 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_COPYRIGHT_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_COPYRIGHT_PINYIN);
482 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
484 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_DESCRIPTION_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_DESCRIPTION_PINYIN);
485 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
487 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_AUTHOR_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_AUTHOR_PINYIN);
488 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
490 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_PROVIDER_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_PROVIDER_PINYIN);
491 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
493 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_CONTENT_NAME_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_CONTENT_NAME_PINYIN);
494 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
496 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_CATEGORY_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_CATEGORY_PINYIN);
497 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
499 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_LOCATION_TAG_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_LOCATION_TAG_PINYIN);
500 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
502 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_AGE_RATING_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_AGE_RATING_PINYIN);
503 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
505 ret = _media_filter_attribute_add(g_alias_attr_handle, MEDIA_KEYWORD_PINYIN, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_KEYWORD_PINYIN);
506 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
509 ret = _media_filter_attribute_add(g_alias_attr_handle, FOLDER_ID, DB_TABLE_ALIAS_FOLDER"."DB_FIELD_FOLDER_ID);
510 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
512 ret = _media_filter_attribute_add(g_alias_attr_handle, FOLDER_PATH, DB_TABLE_ALIAS_FOLDER"."DB_FIELD_FOLDER_PATH);
513 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
515 ret = _media_filter_attribute_add(g_alias_attr_handle, FOLDER_NAME, DB_TABLE_ALIAS_FOLDER"."DB_FIELD_FOLDER_NAME);
516 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
518 ret = _media_filter_attribute_add(g_alias_attr_handle, FOLDER_MODIFIED_TIME, DB_TABLE_ALIAS_FOLDER"."DB_FIELD_FOLDER_MODIFIED_TIME);
519 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
521 ret = _media_filter_attribute_add(g_alias_attr_handle, FOLDER_STORAGE_TYPE, DB_TABLE_ALIAS_FOLDER"."DB_FIELD_FOLDER_STORAGE_TYPE);
522 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
524 ret = _media_filter_attribute_add(g_alias_attr_handle, FOLDER_NAME_PINYIN, DB_TABLE_ALIAS_FOLDER"."DB_FIELD_FOLDER_NAME_PINYIN);
525 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
527 ret = _media_filter_attribute_add(g_alias_attr_handle, FOLDER_ORDER, DB_TABLE_ALIAS_FOLDER"."DB_FIELD_FOLDER_ORDER);
528 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
530 ret = _media_filter_attribute_add(g_alias_attr_handle, FOLDER_PARENT_FOLDER_ID, DB_TABLE_ALIAS_FOLDER"."DB_FIELD_FOLDER_PARENT_FOLDER_ID);
531 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
533 ret = _media_filter_attribute_add(g_alias_attr_handle, PLAYLIST_NAME, DB_TABLE_ALIAS_PLAYLIST"."DB_FIELD_PLAYLIST_NAME);
534 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
536 ret = _media_filter_attribute_add(g_alias_attr_handle, PLAYLIST_MEMBER_ORDER, DB_TABLE_ALIAS_PLAYLIST_MAP"."DB_FIELD_PLAYLIST_MEMBER_ORDER);
537 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
540 ret = _media_filter_attribute_add(g_alias_attr_handle, TAG_NAME, DB_TABLE_ALIAS_TAG"."DB_FIELD_TAG_NAME);
541 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
544 ret = _media_filter_attribute_add(g_alias_attr_handle, BOOKMARK_MARKED_TIME, DB_TABLE_ALIAS_BOOKMARK"."DB_FIELD_BOOKMARK_MARKED_TIME);
545 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
550 static int __media_content_create_attribute_handle(void)
552 int ret = MEDIA_CONTENT_ERROR_NONE;
554 ret = __media_content_create_attr_handle();
555 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
557 ret = __media_content_create_alias_attr_handle();
558 if (ret != MEDIA_CONTENT_ERROR_NONE)
559 _media_filter_attribute_destory(g_attr_handle);
564 static int __media_content_destroy_attribute_handle(void)
566 int ret = MEDIA_CONTENT_ERROR_NONE;
568 ret = _media_filter_attribute_destory(g_attr_handle);
569 ret = _media_filter_attribute_destory(g_alias_attr_handle);
571 g_attr_handle = NULL;
572 g_alias_attr_handle = NULL;
577 /* Temporary Code [remove after inserted gid patch by security part] */
578 int __media_content_cynara_check(const char *privilege)
580 int ret = MEDIA_CONTENT_ERROR_NONE;
582 char *session = NULL;
584 char c_uid[20] = {0, };
587 char buf[255] = {0, };
589 ret = cynara_initialize(&_cynara, NULL);
590 if (ret != CYNARA_API_SUCCESS) {
591 media_content_error("cynara_initialize", ret);
592 return MEDIA_CONTENT_ERROR_INVALID_OPERATION;
595 snprintf(c_uid, sizeof(c_uid), "%d", tzplatform_getuid(TZ_USER_NAME));
599 session = cynara_session_from_pid(pid);
600 if (session == NULL) {
601 media_content_error("cynara_session_from_pid failed");
602 return MEDIA_CONTENT_ERROR_INVALID_OPERATION;
605 pFile = fopen("/proc/self/attr/current", "r");
607 smack = fgets(buf, sizeof(buf), pFile);
611 media_content_error("current info read failed");
612 return MEDIA_CONTENT_ERROR_INVALID_OPERATION;
615 G_LOCK(cynara_mutex);
616 result = cynara_check(_cynara, smack, session, c_uid, privilege);
617 G_UNLOCK(cynara_mutex);
619 if (result != CYNARA_API_ACCESS_ALLOWED)
620 media_content_error("cynara_check", result);
624 cynara_finish(_cynara);
627 return result == CYNARA_API_ACCESS_ALLOWED ? MEDIA_CONTENT_ERROR_NONE : MEDIA_CONTENT_ERROR_PERMISSION_DENIED;
630 attribute_h _content_get_attirbute_handle(void)
632 return g_attr_handle;
635 attribute_h _content_get_alias_attirbute_handle(void)
637 return g_alias_attr_handle;
640 MediaSvcHandle* _content_get_db_handle(void)
645 int _content_query_prepare(sqlite3_stmt **stmt, char *select_query, char *condition_query, char *option_query)
648 int err = MEDIA_CONTENT_ERROR_NONE;
649 char query[MAX_QUERY_SIZE] = {0, };
650 memset(query, '\0', sizeof(query));
652 media_content_retvm_if(db_handle == NULL, MEDIA_CONTENT_ERROR_DB_FAILED, "database is not connected");
653 media_content_retvm_if(!STRING_VALID(select_query), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "invalid select_query");
655 if (!STRING_VALID(condition_query))
656 condition_query = (char *)" ";
658 if (!STRING_VALID(option_query))
659 option_query = (char *)" ";
661 /*query = sqlite3_mprintf("%s %s %s", select_query, condition_query, option_query);*/
662 len = snprintf(query, sizeof(query), "%s %s %s", select_query, condition_query, option_query);
663 if (len > 0 && len < MAX_QUERY_SIZE)
665 else if (len >= MAX_QUERY_SIZE)
666 query[MAX_QUERY_SIZE -1] = '\0';
668 media_content_error("snprintf failed");
669 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
672 media_content_sec_debug("Query : [%s]", query);
674 err = sqlite3_prepare_v2((sqlite3*)db_handle, query, strlen(query), stmt, NULL);
675 if (err != SQLITE_OK) {
676 media_content_error("DB_FAILED(0x%08x) fail to sqlite3_prepare(), %s", MEDIA_CONTENT_ERROR_DB_FAILED, sqlite3_errmsg((sqlite3*)db_handle));
678 if (err == SQLITE_BUSY) {
679 media_content_error(" BUSY ERROR");
680 return MEDIA_CONTENT_ERROR_DB_BUSY;
681 } else if (err == SQLITE_PERM) {
682 media_content_error("PERMISSION EROR");
683 return MEDIA_CONTENT_ERROR_PERMISSION_DENIED;
685 media_content_error("OTHER ERROR");
686 return MEDIA_CONTENT_ERROR_DB_FAILED;
690 return MEDIA_CONTENT_ERROR_NONE;
693 int _content_error_capi(int type, int content_error)
695 if (content_error != MEDIA_CONTENT_ERROR_NONE)
696 media_content_error("[type : %d] content_error : %d ", type, content_error);
699 if (content_error == MS_MEDIA_ERR_NONE)
700 return MEDIA_CONTENT_ERROR_NONE;
702 /* Internal operation error*/
703 else if ((content_error == MS_MEDIA_ERR_INVALID_PARAMETER) ||
704 (content_error == MS_MEDIA_ERR_INVALID_PATH) ||
705 (content_error == MS_MEDIA_ERR_THUMB_DUPLICATED_REQUEST))
706 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
708 else if (content_error == MS_MEDIA_ERR_OUT_OF_MEMORY)
709 return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
711 /* DB operation error*/
712 else if (content_error == MS_MEDIA_ERR_DB_BUSY_FAIL)
713 return MEDIA_CONTENT_ERROR_DB_BUSY;
715 else if ((content_error <= MS_MEDIA_ERR_DB_CONNECT_FAIL) && (content_error >= MS_MEDIA_ERR_DB_INTERNAL))
716 return MEDIA_CONTENT_ERROR_DB_FAILED;
718 /* IPC operation error*/
719 else if ((content_error <= MS_MEDIA_ERR_SOCKET_CONN) && (content_error >= MS_MEDIA_ERR_SOCKET_INTERNAL))
720 return MEDIA_CONTENT_ERROR_NETWORK;
722 /* MEDIA SERVER error*/
723 else if (content_error == MS_MEDIA_ERR_PERMISSION_DENIED)
724 return MEDIA_CONTENT_ERROR_PERMISSION_DENIED;
727 else if (content_error == MS_MEDIA_ERR_THUMB_TOO_BIG)
728 return MEDIA_CONTENT_ERROR_UNSUPPORTED_CONTENT;
731 return MEDIA_CONTENT_ERROR_INVALID_OPERATION;
734 int _content_query_sql(char *query_str)
736 int ret = MEDIA_CONTENT_ERROR_NONE;
738 /*DB will be updated by Media Server.*/
739 ret = media_svc_request_update_db(query_str, tzplatform_getuid(TZ_USER_NAME));
741 return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
744 int media_content_connect(void)
746 int ret = MEDIA_CONTENT_ERROR_NONE;
748 if (g_mutex_trylock(&db_mutex)) {
749 media_content_info("ref count : %d", ref_count);
751 if (ref_count == 0) {
752 if (db_handle == NULL) {
753 ret = __media_content_create_attribute_handle();
754 if (ret == MEDIA_CONTENT_ERROR_NONE) {
755 ret = media_svc_connect(&db_handle, tzplatform_getuid(TZ_USER_NAME), false);
756 ret = _content_error_capi(MEDIA_CONTENT_TYPE, ret);
757 if (ret == MEDIA_CONTENT_ERROR_NONE)
760 __media_content_destroy_attribute_handle();
763 media_content_error("Internal DB Connection Error");
766 media_content_error("Wrong DB Connection status");
767 ret = MEDIA_CONTENT_ERROR_DB_FAILED;
770 if (db_handle != NULL) {
773 media_content_error("Wrong DB Handle status");
774 ret = MEDIA_CONTENT_ERROR_DB_FAILED;
778 media_content_info("ref count changed to: %d", ref_count);
779 g_mutex_unlock(&db_mutex);
781 media_content_error("mutex is NULL");
782 ret = MEDIA_CONTENT_ERROR_DB_FAILED;
788 int media_content_disconnect(void)
790 int ret = MEDIA_CONTENT_ERROR_NONE;
792 if (g_mutex_trylock(&db_mutex)) {
793 media_content_debug("ref count : %d", ref_count);
795 if (db_handle != NULL) {
798 media_content_error("Wrong DB Handle status");
799 ret = MEDIA_CONTENT_ERROR_DB_FAILED;
802 media_content_error("DB_FAILED(0x%08x) database is not connected", MEDIA_CONTENT_ERROR_DB_FAILED);
803 g_mutex_unlock(&db_mutex);
804 return MEDIA_CONTENT_ERROR_DB_FAILED;
807 if (ref_count == 0) {
808 if (db_handle != NULL) {
809 ret = media_svc_disconnect(db_handle);
810 ret = _content_error_capi(MEDIA_CONTENT_TYPE, ret);
811 if (ret == MEDIA_CONTENT_ERROR_NONE) {
812 ret = __media_content_destroy_attribute_handle();
815 media_content_error("database disconnect fail");
819 media_content_error("Wrong DB Handle status");
820 ret = MEDIA_CONTENT_ERROR_DB_FAILED;
823 g_mutex_unlock(&db_mutex);
825 media_content_info("ref count changed to: %d", ref_count);
830 g_mutex_unlock(&db_mutex);
832 media_content_error("mutex is NULL");
833 ret = MEDIA_CONTENT_ERROR_INVALID_OPERATION;
836 media_content_info("ref count changed to: %d", ref_count);
841 int media_content_scan_file(const char *path)
843 int ret = MEDIA_CONTENT_ERROR_NONE;
844 bool ignore_file = FALSE;
845 bool ignore_dir = FALSE;
846 char *folder_path = NULL;
847 int check_file = MEDIA_CONTENT_ERROR_NONE;
848 char storage_id[MEDIA_CONTENT_UUID_SIZE+1] = {0,};
850 media_content_retvm_if(!STRING_VALID(path), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "invalid path");
852 media_content_sec_debug("Path : %s", path);
854 ret = _media_util_check_ignore_file(path, &ignore_file);
855 media_content_retvm_if(ignore_file == TRUE, MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid path");
857 memset(storage_id, 0x00, sizeof(storage_id));
858 ret = media_svc_get_storage_id(_content_get_db_handle(), path, storage_id);
859 if (ret != MS_MEDIA_ERR_NONE) {
860 media_content_error("media_svc_get_storage_id failed : %d", ret);
861 return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
864 check_file = _media_util_check_file_exist(path);
865 if (check_file == MEDIA_CONTENT_ERROR_NONE) {
866 /* This means this path has to be inserted or refreshed */
867 folder_path = g_path_get_dirname(path);
868 ret = _media_util_check_ignore_dir(folder_path, &ignore_dir);
869 SAFE_FREE(folder_path);
871 media_content_retvm_if(ignore_dir == TRUE, MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid folder path");
873 media_svc_storage_type_e storage_type;
875 ret = media_svc_get_storage_type(path, &storage_type, tzplatform_getuid(TZ_USER_NAME));
876 if (ret != MS_MEDIA_ERR_NONE) {
877 media_content_sec_error("media_svc_get_storage_type failed : %d (%s)", ret, path);
878 return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
880 ret = media_svc_check_item_exist_by_path(_content_get_db_handle(), storage_id, path);
881 if (ret == MS_MEDIA_ERR_NONE) {
883 ret = media_svc_refresh_item(_content_get_db_handle(), storage_id, storage_type, path, tzplatform_getuid(TZ_USER_NAME));
884 if (ret != MS_MEDIA_ERR_NONE) {
885 media_content_error("media_svc_refresh_item failed : %d", ret);
886 return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
889 } else if (ret == MS_MEDIA_ERR_DB_NO_RECORD) {
891 ret = media_svc_insert_item_immediately(_content_get_db_handle(), storage_id, storage_type, path, tzplatform_getuid(TZ_USER_NAME));
892 if (ret != MS_MEDIA_ERR_NONE) {
893 if (ret == MS_MEDIA_ERR_DB_CONSTRAINT_FAIL) {
894 media_content_sec_error("This item is already inserted. This may be normal operation because other process already did this (%s)", path);
895 ret = MEDIA_CONTENT_ERROR_NONE;
897 media_content_sec_error("media_svc_insert_item_immediately failed : %d (%s)", ret, path);
900 return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
903 media_content_error("media_svc_check_item_exist_by_path failed : %d", ret);
904 return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
906 } else if (check_file == MEDIA_CONTENT_ERROR_PERMISSION_DENIED) {
907 media_content_error("You have no permission for this file %d", ret);
908 return MEDIA_CONTENT_ERROR_PERMISSION_DENIED;
910 /* This means this path has to be deleted */
911 media_content_debug("This path doesn't exists in file system... So now start to delete it from DB");
912 ret = media_svc_delete_item_by_path(_content_get_db_handle(), storage_id, path, tzplatform_getuid(TZ_USER_NAME));
913 if (ret != MS_MEDIA_ERR_NONE) {
914 media_content_error("media_svc_delete_item_by_path failed : %d", ret);
915 return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
919 return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
922 void _media_content_scan_cb(media_request_result_s* result, void *user_data)
925 media_content_scan_cb_data *cb_data = user_data;
927 err = result->result;
929 if (cb_data && cb_data->callback) {
930 media_content_debug("User callback is being called now");
931 cb_data->callback(err, cb_data->user_data);
939 static int __media_content_check_dir(const char *path)
945 media_content_sec_error("path [%s]", path);
946 media_content_stderror("open dir fail");
948 if (errno == EACCES || errno == EPERM)
949 return MEDIA_CONTENT_ERROR_PERMISSION_DENIED;
951 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
956 return MEDIA_CONTENT_ERROR_NONE;
959 int media_content_scan_folder(const char *path, bool is_recursive, media_scan_completed_cb callback, void *user_data)
961 int ret = MEDIA_CONTENT_ERROR_NONE;
962 bool ignore_dir = FALSE;
963 char storage_id[MEDIA_CONTENT_UUID_SIZE+1] = {0, };
965 media_content_retvm_if(!STRING_VALID(path), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid path");
967 /* Temporary Code [remove after inserted gid patch by security part] */
968 if (strncmp(path, "/opt/media", strlen("/opt/media")) == 0) {
969 ret = __media_content_cynara_check("http://tizen.org/privilege/externalstorage");
970 media_content_retvm_if(ret == MEDIA_CONTENT_ERROR_PERMISSION_DENIED, ret, "Permission Denied");
972 ret = __media_content_cynara_check("http://tizen.org/privilege/mediastorage");
973 media_content_retvm_if(ret == MEDIA_CONTENT_ERROR_PERMISSION_DENIED, ret, "Permission Denied");
976 memset(storage_id, 0x00, sizeof(storage_id));
978 ret = __media_content_check_dir(path);
979 media_content_retvm_if(ret == MEDIA_CONTENT_ERROR_PERMISSION_DENIED, ret, "Permission Denied");
981 if (ret == MEDIA_CONTENT_ERROR_NONE) {
982 /* If directory exist check that's ignore directory or not*/
983 ret = _media_util_check_ignore_dir(path, &ignore_dir);
984 media_content_retvm_if(ignore_dir == TRUE, MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid folder path");
986 /* This means this folder has to be deleted */
987 media_content_debug("This path doesn't exists in file system... So will be deleted it from DB");
990 media_content_scan_cb_data *cb_data = NULL;
991 cb_data = (media_content_scan_cb_data *)malloc(sizeof(media_content_scan_cb_data));
992 media_content_retvm_if(cb_data == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY");
994 cb_data->callback = callback;
995 cb_data->user_data = user_data;
997 ret = media_svc_get_storage_id(_content_get_db_handle(), path, storage_id);
998 /*FIX ME. need to check ret value?*/
1000 ret = media_directory_scanning_async(path, storage_id, is_recursive, _media_content_scan_cb, cb_data, tzplatform_getuid(TZ_USER_NAME));
1001 if (ret != MS_MEDIA_ERR_NONE)
1002 media_content_error("media_directory_scanning_async failed : %d", ret);
1004 return _content_error_capi(MEDIA_REGISTER_TYPE, ret);
1007 int media_content_cancel_scan_folder(const char *path)
1009 int ret = MEDIA_CONTENT_ERROR_NONE;
1011 ret = media_directory_scanning_cancel(path, tzplatform_getuid(TZ_USER_NAME));
1012 if (ret != MS_MEDIA_ERR_NONE)
1013 media_content_error("media_directory_scanning_async failed : %d", ret);
1015 return _content_error_capi(MEDIA_REGISTER_TYPE, ret);
1018 void _media_content_db_update_noti_cb(
1020 media_item_type_e item,
1021 media_item_update_type_e update_type,
1024 media_type_e content_type,
1028 int error_value = MEDIA_CONTENT_ERROR_NONE;
1030 media_noti_cb_s *_noti_info = (media_noti_cb_s *)user_data;
1032 if (_noti_info != NULL) {
1033 if (_noti_info->update_noti_cb)
1034 _noti_info->update_noti_cb(error_value, pid, item, update_type, content_type, uuid, path, mime_type, _noti_info->user_data);
1040 int media_content_set_db_updated_cb(media_content_db_update_cb callback, void *user_data)
1042 int ret = MEDIA_CONTENT_ERROR_NONE;
1044 media_content_retvm_if(callback == NULL, MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid callback");
1045 media_content_retvm_if(g_noti_info != NULL, MEDIA_CONTENT_ERROR_INVALID_OPERATION, "Noti callback is already set");
1047 g_noti_info = (media_noti_cb_s *)calloc(1, sizeof(media_noti_cb_s));
1048 media_content_retvm_if(g_noti_info == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY");
1050 g_noti_info->update_noti_cb = callback;
1051 g_noti_info->user_data = user_data;
1053 ret = media_db_update_subscribe(_media_content_db_update_noti_cb, (void *)g_noti_info);
1055 return _content_error_capi(MEDIA_REGISTER_TYPE, ret);
1058 int media_content_unset_db_updated_cb(void)
1060 int ret = MEDIA_CONTENT_ERROR_NONE;
1062 SAFE_FREE(g_noti_info);
1063 ret = media_db_update_unsubscribe();
1065 return _content_error_capi(MEDIA_REGISTER_TYPE, ret);
1068 int media_content_set_db_updated_cb_v2(media_content_noti_h *noti_handle, media_content_db_update_cb callback, void *user_data)
1070 int ret = MEDIA_CONTENT_ERROR_NONE;
1071 media_noti_cb_s *noti_info = NULL;
1073 if (noti_handle == NULL) {
1074 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
1075 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
1078 if (callback == NULL) {
1079 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
1080 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
1083 noti_info = (media_noti_cb_s *)calloc(1, sizeof(media_noti_cb_s));
1084 if (noti_info == NULL) {
1085 media_content_error("Failed to create noti info");
1086 return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
1089 noti_info->update_noti_cb = callback;
1090 noti_info->user_data = user_data;
1092 ret = media_db_update_subscribe_internal((MediaNotiHandle*)noti_handle, _media_content_db_update_noti_cb, (void *)noti_info);
1094 return _content_error_capi(MEDIA_REGISTER_TYPE, ret);
1097 int media_content_add_db_updated_cb(media_content_db_update_cb callback, void *user_data, media_content_noti_h *noti_handle)
1099 int ret = MEDIA_CONTENT_ERROR_NONE;
1100 media_noti_cb_s *noti_info = NULL;
1102 if (noti_handle == NULL) {
1103 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
1104 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
1107 if (callback == NULL) {
1108 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
1109 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
1112 noti_info = (media_noti_cb_s *)calloc(1, sizeof(media_noti_cb_s));
1113 if (noti_info == NULL) {
1114 media_content_error("Failed to create noti info");
1115 return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
1118 noti_info->update_noti_cb = callback;
1119 noti_info->user_data = user_data;
1121 ret = media_db_update_subscribe_internal((MediaNotiHandle*)noti_handle, _media_content_db_update_noti_cb, (void *)noti_info);
1123 return _content_error_capi(MEDIA_REGISTER_TYPE, ret);
1126 void __media_content_clear_user_data(void *user_data)
1128 media_noti_cb_s *noti_info = user_data;
1130 SAFE_FREE(noti_info);
1135 int media_content_unset_db_updated_cb_v2(media_content_noti_h noti_handle)
1137 int ret = MEDIA_CONTENT_ERROR_NONE;
1139 ret = media_db_update_unsubscribe_internal((MediaNotiHandle)noti_handle, __media_content_clear_user_data);
1141 return _content_error_capi(MEDIA_REGISTER_TYPE, ret);
1145 int media_content_remove_db_updated_cb(media_content_noti_h noti_handle)
1147 int ret = MEDIA_CONTENT_ERROR_NONE;
1149 ret = media_db_update_unsubscribe_internal((MediaNotiHandle)noti_handle, __media_content_clear_user_data);
1151 return _content_error_capi(MEDIA_REGISTER_TYPE, ret);