1 /*
2  * Copyright (C) 2024-2024 Huawei Device Co., Ltd.
3  * Licensed under the Apache License, Version 2.0 (the "License");
4  * you may not use this file except in compliance with the License.
5  * You may obtain a copy of the License at
6  *
7  * http://www.apache.org/licenses/LICENSE-2.0
8  *
9  * Unless required by applicable law or agreed to in writing, software
10  * distributed under the License is distributed on an "AS IS" BASIS,
11  * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
12  * See the License for the specific language governing permissions and
13  * limitations under the License.
14  */
15 #define MLOG_TAG "MediaLibraryStoryTest"
16 
17 #include "medialibrary_story_test.h"
18 
19 #include "datashare_result_set.h"
20 #include "get_self_permissions.h"
21 #include "media_log.h"
22 #include "medialibrary_data_manager.h"
23 #include "medialibrary_errno.h"
24 #include "medialibrary_unittest_utils.h"
25 #include "result_set_utils.h"
26 #include "story_album_column.h"
27 #include "story_cover_info_column.h"
28 #include "story_play_info_column.h"
29 #include "user_photography_info_column.h"
30 #include "vision_album_column.h"
31 #include "uri.h"
32 
33 using namespace std;
34 using namespace testing::ext;
35 
36 namespace OHOS {
37 namespace Media {
ClearStoryData()38 void ClearStoryData()
39 {
40     DataShare::DataSharePredicates predicates;
41     Uri storyAlbumUri(URI_HIGHLIGHT_ALBUM);
42     MediaLibraryCommand storyAlbumCmd(storyAlbumUri);
43     Uri storyCoverUri(URI_HIGHLIGHT_COVER_INFO);
44     MediaLibraryCommand storyCoverCmd(storyCoverUri);
45     Uri storyPlayUri(URI_HIGHLIGHT_PLAY_INFO);
46     MediaLibraryCommand storyPlayCmd(storyPlayUri);
47     Uri userPhotoGraphyUri(URI_USER_PHOTOGRAPHY_INFO);
48     MediaLibraryCommand userPhotoGraphyCmd(userPhotoGraphyUri);
49     MediaLibraryDataManager::GetInstance()->Delete(storyAlbumCmd, predicates);
50     MediaLibraryDataManager::GetInstance()->Delete(storyCoverCmd, predicates);
51     MediaLibraryDataManager::GetInstance()->Delete(storyPlayCmd, predicates);
52     MediaLibraryDataManager::GetInstance()->Delete(userPhotoGraphyCmd, predicates);
53 }
54 
SetUpTestCase(void)55 void MediaLibraryStoryTest::SetUpTestCase(void)
56 {
57     MEDIA_INFO_LOG("Story_Test::Start");
58     MediaLibraryUnitTestUtils::Init();
59 }
60 
TearDownTestCase(void)61 void MediaLibraryStoryTest::TearDownTestCase(void)
62 {
63     ClearStoryData();
64     MEDIA_INFO_LOG("Story_Test::End");
65 }
66 
SetUp(void)67 void MediaLibraryStoryTest::SetUp(void)
68 {
69     MediaLibraryUnitTestUtils::CleanTestFiles();
70     MediaLibraryUnitTestUtils::CleanBundlePermission();
71     MediaLibraryUnitTestUtils::InitRootDirs();
72     MediaLibraryUnitTestUtils::Init();
73     ClearStoryData();
74 }
75 
TearDown(void)76 void MediaLibraryStoryTest::TearDown(void) {}
77 
78 HWTEST_F(MediaLibraryStoryTest, Story_InsertAlbum_Test_001, TestSize.Level0)
79 {
80     MEDIA_INFO_LOG("Story_InsertAlbum_Test_001::Start");
81     Uri storyAlbumUri(URI_HIGHLIGHT_ALBUM);
82     MediaLibraryCommand cmd(storyAlbumUri);
83     DataShare::DataShareValuesBucket valuesBucket;
84     valuesBucket.Put(ALBUM_ID, 1);
85     valuesBucket.Put(AI_ALBUM_ID, 1);
86     valuesBucket.Put(SUB_TITLE, "2024.03.20 ~ 03.21");
87     valuesBucket.Put(CLUSTER_TYPE, "2");
88     valuesBucket.Put(CLUSTER_SUB_TYPE, "3");
89     valuesBucket.Put(CLUSTER_CONDITION, "地点");
90     valuesBucket.Put(MIN_DATE_ADDED, 1432973383179);
91     valuesBucket.Put(MAX_DATE_ADDED, 1432973383180);
92     valuesBucket.Put(GENERATE_TIME, 1432973383181);
93     valuesBucket.Put(HIGHLIGHT_VERSION, 1);
94     valuesBucket.Put(REMARKS, "2");
95     valuesBucket.Put(HIGHLIGHT_STATUS, 1);
96     valuesBucket.Put(HIGHLIGHT_INSERT_PIC_COUNT, 3);
97     valuesBucket.Put(HIGHLIGHT_REMOVE_PIC_COUNT, 3);
98     valuesBucket.Put(HIGHLIGHT_SHARE_SCREENSHOT_COUNT, 5);
99     valuesBucket.Put(HIGHLIGHT_SHARE_COVER_COUNT, 6);
100     valuesBucket.Put(HIGHLIGHT_RENAME_COUNT, 7);
101     valuesBucket.Put(HIGHLIGHT_CHANGE_COVER_COUNT, 7);
102     valuesBucket.Put(HIGHLIGHT_RENDER_VIEWED_TIMES, 5);
103     valuesBucket.Put(HIGHLIGHT_RENDER_VIEWED_DURATION, 5);
104     valuesBucket.Put(HIGHLIGHT_ART_LAYOUT_VIEWED_TIMES, 6);
105     valuesBucket.Put(HIGHLIGHT_ART_LAYOUT_VIEWED_DURATION, 6);
106     valuesBucket.Put(HIGHLIGHT_MUSIC_EDIT_COUNT, 3);
107     valuesBucket.Put(HIGHLIGHT_FILTER_EDIT_COUNT, 4);
108     valuesBucket.Put(HIGHLIGHT_IS_MUTED, false);
109     valuesBucket.Put(HIGHLIGHT_IS_FAVORITE, true);
110     valuesBucket.Put(HIGHLIGHT_THEME, "生日");
111     auto retVal = MediaLibraryDataManager::GetInstance()->Insert(cmd, valuesBucket);
112     EXPECT_GT(retVal, 0);
113     MEDIA_INFO_LOG("Story_InsertAlbum_Test_001::retVal = %{public}d. End", retVal);
114 }
115 
116 HWTEST_F(MediaLibraryStoryTest, Story_UpdateAlbum_Test_001, TestSize.Level0)
117 {
118     MEDIA_INFO_LOG("Story_UpdateAlbum_Test_001::Start");
119     Uri storyAlbumUri(URI_HIGHLIGHT_ALBUM);
120     MediaLibraryCommand cmd(storyAlbumUri);
121     DataShare::DataShareValuesBucket valuesBucket;
122     valuesBucket.Put(ALBUM_ID, 2);
123     valuesBucket.Put(AI_ALBUM_ID, 2);
124     valuesBucket.Put(SUB_TITLE, "2024.03.20 ~ 03.21");
125     valuesBucket.Put(CLUSTER_TYPE, "2");
126     valuesBucket.Put(CLUSTER_SUB_TYPE, "7");
127     valuesBucket.Put(CLUSTER_CONDITION, "地点");
128     valuesBucket.Put(MIN_DATE_ADDED, 1432973383179);
129     valuesBucket.Put(MAX_DATE_ADDED, 1432973383184);
130     valuesBucket.Put(GENERATE_TIME, 1432973383181);
131     valuesBucket.Put(HIGHLIGHT_VERSION, 1);
132     MediaLibraryDataManager::GetInstance()->Insert(cmd, valuesBucket);
133     DataShare::DataShareValuesBucket updateValues;
134     updateValues.Put(CLUSTER_SUB_TYPE, "4");
135     updateValues.Put(CLUSTER_CONDITION, "美食");
136     DataShare::DataSharePredicates predicates;
137     predicates.EqualTo(ALBUM_ID, to_string(2));
138     auto retVal = MediaLibraryDataManager::GetInstance()->Update(cmd, updateValues, predicates);
139     EXPECT_EQ((retVal == 1), true);
140     vector<string> columns;
141     columns.push_back(CLUSTER_CONDITION);
142     int errCode = 0;
143     auto queryResultSet = MediaLibraryDataManager::GetInstance()->Query(cmd, columns, predicates, errCode);
144     shared_ptr<DataShare::DataShareResultSet> resultSet = make_shared<DataShare::DataShareResultSet>(queryResultSet);
145     int count;
146     resultSet->GetRowCount(count);
147     EXPECT_GT(count, 0);
148     resultSet->GoToFirstRow();
149     string condition;
150     resultSet->GetString(0, condition);
151     MEDIA_INFO_LOG("Story_UpdateAlbum_Test_001::condition = %{public}s. End",
152         condition.c_str());
153 }
154 
155 HWTEST_F(MediaLibraryStoryTest, Story_DeleteAlbum_Test_001, TestSize.Level0)
156 {
157     MEDIA_INFO_LOG("Story_DeleteAlbum_Test_001::Start");
158     Uri storyAlbumUri(URI_HIGHLIGHT_ALBUM);
159     MediaLibraryCommand cmd(storyAlbumUri);
160     DataShare::DataShareValuesBucket valuesBucket;
161     valuesBucket.Put(ALBUM_ID, 3);
162     valuesBucket.Put(AI_ALBUM_ID, 3);
163     valuesBucket.Put(SUB_TITLE, "2024.03.20 ~ 03.21");
164     valuesBucket.Put(CLUSTER_TYPE, "2");
165     valuesBucket.Put(CLUSTER_SUB_TYPE, "5");
166     valuesBucket.Put(CLUSTER_CONDITION, "地点");
167     valuesBucket.Put(MIN_DATE_ADDED, 1432973383179);
168     valuesBucket.Put(MAX_DATE_ADDED, 1432973383150);
169     valuesBucket.Put(GENERATE_TIME, 1432973383181);
170     valuesBucket.Put(HIGHLIGHT_VERSION, 2);
171     valuesBucket.Put(HIGHLIGHT_MUSIC_EDIT_COUNT, 3);
172     valuesBucket.Put(HIGHLIGHT_FILTER_EDIT_COUNT, 4);
173     valuesBucket.Put(HIGHLIGHT_IS_MUTED, false);
174     valuesBucket.Put(HIGHLIGHT_IS_FAVORITE, true);
175     valuesBucket.Put(HIGHLIGHT_THEME, "生日");
176     MediaLibraryDataManager::GetInstance()->Insert(cmd, valuesBucket);
177     DataShare::DataSharePredicates predicates;
178     predicates.EqualTo(ALBUM_ID, to_string(3));
179     auto retVal = MediaLibraryDataManager::GetInstance()->Delete(cmd, predicates);
180     EXPECT_EQ((retVal == 1), true);
181     MEDIA_INFO_LOG("Story_DeleteAlbum_Test_001::retVal = %{public}d. End", retVal);
182 }
183 
184 HWTEST_F(MediaLibraryStoryTest, Story_InsertCoverInfo_Test_001, TestSize.Level0)
185 {
186     MEDIA_INFO_LOG("Story_InsertCoverInfo_Test_001::Start");
187     Uri storyCoverUri(URI_HIGHLIGHT_COVER_INFO);
188     MediaLibraryCommand cmd(storyCoverUri);
189     DataShare::DataShareValuesBucket valuesBucket;
190     valuesBucket.Put(ALBUM_ID, 1);
191     valuesBucket.Put(RATIO, "2:1");
192     valuesBucket.Put(BACKGROUND, "file://media/Photo/1/1/1.jpg");
193     valuesBucket.Put(FOREGROUND, "file://media/Photo/1/1/2.jpg");
194     valuesBucket.Put(WORDART, "file://media/Photo/1/1/3.jpg");
195     valuesBucket.Put(IS_COVERED, 0);
196     valuesBucket.Put(COLOR, "black");
197     valuesBucket.Put(RADIUS, 1);
198     valuesBucket.Put(SATURATION, 6.5);
199     valuesBucket.Put(BRIGHTNESS, 6.5);
200     valuesBucket.Put(TITLE_SCALE_X, 5.5);
201     valuesBucket.Put(TITLE_SCALE_Y, 5.5);
202     valuesBucket.Put(TITLE_RECT_HEIGHT, 50.0);
203     valuesBucket.Put(TITLE_RECT_HEIGHT, 60.5);
204     valuesBucket.Put(BACKGROUND_SCALE_X, 6.5);
205     valuesBucket.Put(BACKGROUND_SCALE_Y, 6.5);
206     valuesBucket.Put(BACKGROUND_RECT_HEIGHT, 6.5);
207     valuesBucket.Put(BACKGROUND_RECT_WIDTH, 6.5);
208     valuesBucket.Put(COVER_ALGO_VERSION, 2);
209     auto retVal = MediaLibraryDataManager::GetInstance()->Insert(cmd, valuesBucket);
210     EXPECT_GT(retVal, 0);
211     MEDIA_INFO_LOG("Story_InsertCoverInfo_Test_001::retVal = %{public}d. End", retVal);
212 }
213 
214 HWTEST_F(MediaLibraryStoryTest, Story_UpdateCoverInfo_Test_001, TestSize.Level0)
215 {
216     MEDIA_INFO_LOG("Story_UpdateCoverInfo_Test_001::Start");
217     Uri storyCoverUri(URI_HIGHLIGHT_COVER_INFO);
218     MediaLibraryCommand cmd(storyCoverUri);
219     DataShare::DataShareValuesBucket valuesBucket;
220     valuesBucket.Put(ALBUM_ID, 1);
221     valuesBucket.Put(RATIO, "2:1");
222     valuesBucket.Put(BACKGROUND, "file://media/Photo/1/2/1.jpg");
223     valuesBucket.Put(FOREGROUND, "file://media/Photo/1/2/2.jpg");
224     valuesBucket.Put(WORDART, "file://media/Photo/1/2/3.jpg");
225     valuesBucket.Put(COLOR, "black");
226     MediaLibraryDataManager::GetInstance()->Insert(cmd, valuesBucket);
227     DataShare::DataShareValuesBucket updateValues;
228     updateValues.Put(COLOR, "blue");
229     DataShare::DataSharePredicates predicates;
230     predicates.EqualTo(ALBUM_ID, to_string(1));
231     auto retVal = MediaLibraryDataManager::GetInstance()->Update(cmd, updateValues, predicates);
232     EXPECT_EQ((retVal == 1), true);
233     vector<string> columns;
234     columns.push_back(COLOR);
235     int errCode = 0;
236     auto queryResultSet = MediaLibraryDataManager::GetInstance()->Query(cmd, columns, predicates, errCode);
237     shared_ptr<DataShare::DataShareResultSet> resultSet = make_shared<DataShare::DataShareResultSet>(queryResultSet);
238     int count;
239     resultSet->GetRowCount(count);
240     EXPECT_GT(count, 0);
241     resultSet->GoToFirstRow();
242     string color;
243     resultSet->GetString(0, color);
244     MEDIA_INFO_LOG("Story_UpdateCoverInfo_Test_001::color = %{public}s. End", color.c_str());
245 }
246 
247 HWTEST_F(MediaLibraryStoryTest, Story_DeleteCoverInfo_Test_001, TestSize.Level0)
248 {
249     MEDIA_INFO_LOG("Story_DeleteCoverInfo_Test_001::Start");
250     Uri storyCoverUri(URI_HIGHLIGHT_COVER_INFO);
251     MediaLibraryCommand cmd(storyCoverUri);
252     DataShare::DataShareValuesBucket valuesBucket;
253     valuesBucket.Put(ALBUM_ID, 1);
254     valuesBucket.Put(RATIO, "3:1");
255     valuesBucket.Put(BACKGROUND, "file://media/Photo/1/1/1.jpg");
256     valuesBucket.Put(FOREGROUND, "file://media/Photo/1/1/2.jpg");
257     valuesBucket.Put(WORDART, "file://media/Photo/1/1/3.jpg");
258     valuesBucket.Put(COLOR, "black");
259     MediaLibraryDataManager::GetInstance()->Insert(cmd, valuesBucket);
260     DataShare::DataSharePredicates predicates;
261     predicates.EqualTo(ALBUM_ID, to_string(1));
262     auto retVal = MediaLibraryDataManager::GetInstance()->Delete(cmd, predicates);
263     EXPECT_EQ((retVal == 1), true);
264     MEDIA_INFO_LOG("Story_DeleteCoverInfo_Test_001::retVal = %{public}d. End", retVal);
265 }
266 
267 HWTEST_F(MediaLibraryStoryTest, Story_InsertPlayInfo_Test_001, TestSize.Level0)
268 {
269     MEDIA_INFO_LOG("Story_InsertPlayInfo_Test_001::Start");
270     Uri storyPlayUri(URI_HIGHLIGHT_PLAY_INFO);
271     MediaLibraryCommand cmd(storyPlayUri);
272     DataShare::DataShareValuesBucket valuesBucket;
273     valuesBucket.Put(ALBUM_ID, 1);
274     valuesBucket.Put(MUSIC, "11");
275     valuesBucket.Put(FILTER, 1);
276     valuesBucket.Put(HIGHLIGHT_PLAY_INFO, "file://media/Photo/1/1/2.jpg");
277     valuesBucket.Put(IS_CHOSEN, 1);
278     valuesBucket.Put(PLAY_INFO_VERSION, 2);
279     auto retVal = MediaLibraryDataManager::GetInstance()->Insert(cmd, valuesBucket);
280     EXPECT_GT(retVal, 0);
281     MEDIA_INFO_LOG("Story_InsertPlayInfo_Test_001::retVal = %{public}d. End", retVal);
282 }
283 
284 HWTEST_F(MediaLibraryStoryTest, Story_UpdatePlayInfo_Test_001, TestSize.Level0)
285 {
286     MEDIA_INFO_LOG("Story_UpdatePlayInfo_Test_001::Start");
287     Uri storyPlayUri(URI_HIGHLIGHT_PLAY_INFO);
288     MediaLibraryCommand cmd(storyPlayUri);
289     DataShare::DataShareValuesBucket valuesBucket;
290     valuesBucket.Put(ALBUM_ID, 2);
291     valuesBucket.Put(MUSIC, "11");
292     valuesBucket.Put(FILTER, 2);
293     valuesBucket.Put(HIGHLIGHT_PLAY_INFO, "file://media/Photo/1/1/2.jpg");
294     valuesBucket.Put(IS_CHOSEN, 1);
295     valuesBucket.Put(PLAY_INFO_VERSION, 2);
296     MediaLibraryDataManager::GetInstance()->Insert(cmd, valuesBucket);
297     DataShare::DataShareValuesBucket updateValues;
298     updateValues.Put(MUSIC, "22");
299     DataShare::DataSharePredicates predicates;
300     predicates.EqualTo(ALBUM_ID, to_string(2));
301     auto retVal = MediaLibraryDataManager::GetInstance()->Update(cmd, updateValues, predicates);
302     EXPECT_EQ((retVal == 1), true);
303     vector<string> columns;
304     columns.push_back(MUSIC);
305     int errCode = 0;
306     auto queryResultSet = MediaLibraryDataManager::GetInstance()->Query(cmd, columns, predicates, errCode);
307     shared_ptr<DataShare::DataShareResultSet> resultSet = make_shared<DataShare::DataShareResultSet>(queryResultSet);
308     int count;
309     resultSet->GetRowCount(count);
310     EXPECT_GT(count, 0);
311     resultSet->GoToFirstRow();
312     string music;
313     resultSet->GetString(0, music);
314     MEDIA_INFO_LOG("Story_UpdatePlayInfo_Test_001::color = %{public}s. End", music.c_str());
315 }
316 
317 HWTEST_F(MediaLibraryStoryTest, Story_DeletePlayInfo_Test_001, TestSize.Level0)
318 {
319     MEDIA_INFO_LOG("Story_DeletePlayInfo_Test_001::Start");
320     Uri storyPlayUri(URI_HIGHLIGHT_PLAY_INFO);
321     MediaLibraryCommand cmd(storyPlayUri);
322     DataShare::DataShareValuesBucket valuesBucket;
323     valuesBucket.Put(ALBUM_ID, 3);
324     valuesBucket.Put(MUSIC, "11");
325     valuesBucket.Put(FILTER, 2);
326     valuesBucket.Put(HIGHLIGHT_PLAY_INFO, "file://media/Photo/1/1/2.jpg");
327     valuesBucket.Put(IS_CHOSEN, 0);
328     valuesBucket.Put(PLAY_INFO_VERSION, 3);
329     MediaLibraryDataManager::GetInstance()->Insert(cmd, valuesBucket);
330     DataShare::DataSharePredicates predicates;
331     predicates.EqualTo(ALBUM_ID, to_string(3));
332     auto retVal = MediaLibraryDataManager::GetInstance()->Delete(cmd, predicates);
333     EXPECT_EQ((retVal == 1), true);
334     MEDIA_INFO_LOG("Story_DeletePlayInfo_Test_001::retVal = %{public}d. End", retVal);
335 }
336 
337 HWTEST_F(MediaLibraryStoryTest, Story_InsertUserGraphyInfo_Test_001, TestSize.Level0)
338 {
339     MEDIA_INFO_LOG("Story_InsertUserGraphyInfo_Test_001::Start");
340     Uri userPhotoGraphyUri(URI_USER_PHOTOGRAPHY_INFO);
341     MediaLibraryCommand cmd(userPhotoGraphyUri);
342     DataShare::DataShareValuesBucket valuesBucket;
343     valuesBucket.Put(AVERAGE_AESTHETICS_SCORE, 5);
344     valuesBucket.Put(CAPTURE_AESTHETICS_SCORE, 6);
345     valuesBucket.Put(AVERAGE_AESTHETICS_COUNT, 7);
346     valuesBucket.Put(CAPTURE_AESTHETICS_COUNT, 7);
347     valuesBucket.Put(CALCULATE_TIME_START, 1432973383181);
348     valuesBucket.Put(CALCULATE_TIME_END, 1432973383181);
349     auto retVal = MediaLibraryDataManager::GetInstance()->Insert(cmd, valuesBucket);
350     EXPECT_GT(retVal, 0);
351     MEDIA_INFO_LOG("Story_InsertUserGraphyInfo_Test_001::retVal = %{public}d. End", retVal);
352 }
353 
354 HWTEST_F(MediaLibraryStoryTest, Story_UpdateUserGraphyInfo_Test_001, TestSize.Level0)
355 {
356     MEDIA_INFO_LOG("Story_UpdateUserGraphyInfo_Test_001::Start");
357     Uri userPhotoGraphyUri(URI_USER_PHOTOGRAPHY_INFO);
358     MediaLibraryCommand cmd(userPhotoGraphyUri);
359     DataShare::DataShareValuesBucket valuesBucket;
360     valuesBucket.Put(AVERAGE_AESTHETICS_SCORE, 5);
361     valuesBucket.Put(CAPTURE_AESTHETICS_SCORE, 6);
362     valuesBucket.Put(AVERAGE_AESTHETICS_COUNT, 8);
363     valuesBucket.Put(CAPTURE_AESTHETICS_COUNT, 8);
364     valuesBucket.Put(CALCULATE_TIME_START, 1432973383181);
365     valuesBucket.Put(CALCULATE_TIME_END, 1432973383181);
366     MediaLibraryDataManager::GetInstance()->Insert(cmd, valuesBucket);
367     DataShare::DataShareValuesBucket updateValues;
368     updateValues.Put(CAPTURE_AESTHETICS_COUNT, 10);
369     DataShare::DataSharePredicates predicates;
370     predicates.EqualTo(AVERAGE_AESTHETICS_SCORE, to_string(5));
371     auto retVal = MediaLibraryDataManager::GetInstance()->Update(cmd, updateValues, predicates);
372     EXPECT_EQ((retVal == 1), true);
373     vector<string> columns;
374     columns.push_back(CAPTURE_AESTHETICS_COUNT);
375     int errCode = 0;
376     auto queryResultSet = MediaLibraryDataManager::GetInstance()->Query(cmd, columns, predicates, errCode);
377     shared_ptr<DataShare::DataShareResultSet> resultSet = make_shared<DataShare::DataShareResultSet>(queryResultSet);
378     int count;
379     resultSet->GetRowCount(count);
380     EXPECT_GT(count, 0);
381     resultSet->GoToFirstRow();
382     resultSet->GetInt(0, count);
383     MEDIA_INFO_LOG("Story_UpdateUserGraphyInfo_Test_001::color = %{public}d. End", count);
384 }
385 
386 HWTEST_F(MediaLibraryStoryTest, Story_DeleteUserGraphyInfo_Test_001, TestSize.Level0)
387 {
388     MEDIA_INFO_LOG("Story_DeleteUserGraphyInfo_Test_001::Start");
389     Uri userPhotoGraphyUri(URI_USER_PHOTOGRAPHY_INFO);
390     MediaLibraryCommand cmd(userPhotoGraphyUri);
391     DataShare::DataShareValuesBucket valuesBucket;
392     valuesBucket.Put(AVERAGE_AESTHETICS_SCORE, 5);
393     valuesBucket.Put(CAPTURE_AESTHETICS_SCORE, 6);
394     valuesBucket.Put(AVERAGE_AESTHETICS_COUNT, 10);
395     valuesBucket.Put(CAPTURE_AESTHETICS_COUNT, 10);
396     valuesBucket.Put(CALCULATE_TIME_START, 1432973383181);
397     valuesBucket.Put(CALCULATE_TIME_END, 1432973383181);
398     MediaLibraryDataManager::GetInstance()->Insert(cmd, valuesBucket);
399     DataShare::DataSharePredicates predicates;
400     predicates.EqualTo(AVERAGE_AESTHETICS_SCORE, to_string(5));
401     auto retVal = MediaLibraryDataManager::GetInstance()->Delete(cmd, predicates);
402     EXPECT_EQ((retVal == 1), true);
403     MEDIA_INFO_LOG("Story_DeleteUserGraphyInfo_Test_001::retVal = %{public}d. End", retVal);
404 }
405 } // namespace OHOS
406 } // namespace Media