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 
16 #ifndef FRAMEWORKS_SERVICES_MEDIA_MULTI_STAGES_CAPTURE_INCLUDE_STORY_DB_SQLS_H
17 #define FRAMEWORKS_SERVICES_MEDIA_MULTI_STAGES_CAPTURE_INCLUDE_STORY_DB_SQLS_H
18 
19 #include "story_album_column.h"
20 #include "story_cover_info_column.h"
21 #include "story_play_info_column.h"
22 #include "user_photography_info_column.h"
23 #include "vision_album_column.h"
24 
25 namespace OHOS {
26 namespace Media {
27 const std::string CREATE_HIGHLIGHT_ALBUM_TABLE =
28     "CREATE TABLE IF NOT EXISTS " + HIGHLIGHT_ALBUM_TABLE + " ( " +
29     ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " +
30     ALBUM_ID + " INTEGER, " +
31     AI_ALBUM_ID + " INTEGER, " +
32     SUB_TITLE + " TEXT, " +
33     CLUSTER_TYPE + " TEXT NOT NULL, " +
34     CLUSTER_SUB_TYPE + " TEXT NOT NULL, " +
35     CLUSTER_CONDITION + " TEXT NOT NULL, " +
36     MIN_DATE_ADDED + " BIGINT, " +
37     MAX_DATE_ADDED + " BIGINT, " +
38     GENERATE_TIME + " BIGINT DEFAULT 0, " +
39     HIGHLIGHT_VERSION + " INT NOT NULL, " +
40     REMARKS + " TEXT, " +
41     HIGHLIGHT_STATUS + " INT, " +
42     HIGHLIGHT_INSERT_PIC_COUNT + " INT DEFAULT 0, " +
43     HIGHLIGHT_REMOVE_PIC_COUNT + " INT DEFAULT 0, " +
44     HIGHLIGHT_SHARE_SCREENSHOT_COUNT + " INT DEFAULT 0, " +
45     HIGHLIGHT_SHARE_COVER_COUNT + " INT DEFAULT 0, " +
46     HIGHLIGHT_RENAME_COUNT + " INT DEFAULT 0, " +
47     HIGHLIGHT_CHANGE_COVER_COUNT + " INT DEFAULT 0, " +
48     HIGHLIGHT_RENDER_VIEWED_TIMES + " INT DEFAULT 0, " +
49     HIGHLIGHT_RENDER_VIEWED_DURATION + " BIGINT DEFAULT 0, " +
50     HIGHLIGHT_ART_LAYOUT_VIEWED_TIMES + " INT DEFAULT 0, " +
51     HIGHLIGHT_ART_LAYOUT_VIEWED_DURATION + " BIGINT DEFAULT 0, " +
52     HIGHLIGHT_MUSIC_EDIT_COUNT + " INT DEFAULT 0, " +
53     HIGHLIGHT_FILTER_EDIT_COUNT + " INT DEFAULT 0, " +
54     HIGHLIGHT_IS_MUTED + " BOOL, " +
55     HIGHLIGHT_IS_FAVORITE + " BOOL, " +
56     HIGHLIGHT_THEME + " TEXT) ";
57 
58 const std::string CREATE_HIGHLIGHT_COVER_INFO_TABLE =
59     "CREATE TABLE IF NOT EXISTS " + HIGHLIGHT_COVER_INFO_TABLE + " ( " +
60     ALBUM_ID + " INTEGER, " +
61     RATIO + " TEXT, " +
62     BACKGROUND + " TEXT, " +
63     FOREGROUND + " TEXT, " +
64     WORDART + " TEXT, " +
65     IS_COVERED + " BOOL, " +
66     COLOR + " TEXT, " +
67     RADIUS + " INT, " +
68     SATURATION + " REAL, " +
69     BRIGHTNESS + " REAL, " +
70     BACKGROUND_COLOR_TYPE + " INT, " +
71     SHADOW_LEVEL + " INT, " +
72     TITLE_SCALE_X + " REAL, " +
73     TITLE_SCALE_Y + " REAL, " +
74     TITLE_RECT_WIDTH + " REAL, " +
75     TITLE_RECT_HEIGHT + " REAL, " +
76     BACKGROUND_SCALE_X + " REAL, " +
77     BACKGROUND_SCALE_Y + " REAL, " +
78     BACKGROUND_RECT_WIDTH + " REAL, " +
79     BACKGROUND_RECT_HEIGHT + " REAL, " +
80     LAYOUT_INDEX + " INT, " +
81     COVER_ALGO_VERSION + " INT, " +
82     COVER_KEY + " TEXT, " +
83     COVER_SERVICE_VERSION + " INT DEFAULT 0, " +
84     "PRIMARY KEY (" + ALBUM_ID + "," + RATIO + ")) ";
85 
86 const std::string CREATE_HIGHLIGHT_PLAY_INFO_TABLE =
87     "CREATE TABLE IF NOT EXISTS " + HIGHLIGHT_PLAY_INFO_TABLE + " ( " +
88     ALBUM_ID + " INTEGER, " +
89     PLAY_INFO_ID + " INTEGER, " +
90     MUSIC + " TEXT, " +
91     FILTER + " INT, " +
92     HIGHLIGHT_PLAY_INFO + " TEXT, " +
93     IS_CHOSEN + " BOOL, " +
94     PLAY_INFO_VERSION + " INT, " +
95     HIGHLIGHTING_ALGO_VERSION + " TEXT, " +
96     CAMERA_MOVEMENT_ALGO_VERSION + " TEXT, " +
97     TRANSITION_ALGO_VERSION + " TEXT, " +
98     PLAY_SERVICE_VERSION + " INT DEFAULT 0, " +
99     "PRIMARY KEY (" + ALBUM_ID + "," + PLAY_INFO_ID + ")) ";
100 
101 const std::string CREATE_USER_PHOTOGRAPHY_INFO_TABLE =
102     "CREATE TABLE IF NOT EXISTS " + USER_PHOTOGRAPHY_INFO_TABLE + " ( " +
103     AVERAGE_AESTHETICS_SCORE + " INT, " +
104     CAPTURE_AESTHETICS_SCORE + " INT, " +
105     AVERAGE_AESTHETICS_COUNT + " INT, " +
106     CAPTURE_AESTHETICS_COUNT + " INT, " +
107     CALCULATE_TIME_START + " BIGINT, " +
108     CALCULATE_TIME_END + " BIGINT) ";
109 
110 const std::string CREATE_ANALYSIS_ALBUM_ASET_MAP_TABLE =
111     "CREATE TABLE IF NOT EXISTS " + ANALYSIS_ALBUM_ASSET_MAP_TABLE + " ( " +
112     HIGHLIGHT_MAP_ALBUM + " INT, " +
113     HIGHLIGHT_MAP_ASSET + " INT, " +
114     "PRIMARY KEY (" + HIGHLIGHT_MAP_ALBUM + "," + HIGHLIGHT_MAP_ASSET + ")) ";
115 
116 const std::string CREATE_ANALYSIS_ASSET_SD_MAP_TABLE =
117     "CREATE TABLE IF NOT EXISTS " + ANALYSIS_ASSET_SD_MAP_TABLE + " ( " +
118     MAP_ASSET_SOURCE + " INT, " +
119     MAP_ASSET_DESTINATION + " INT, " +
120     "PRIMARY KEY (" + MAP_ASSET_SOURCE + "," + MAP_ASSET_DESTINATION + ")) ";
121 } // namespace Media
122 } // namespace OHOS
123 #endif  // FRAMEWORKS_SERVICES_MEDIA_MULTI_STAGES_CAPTURE_INCLUDE_STORY_DB_SQLS_H