1 /* 2 * Copyright (C) 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 BACKUP_CONST_COLUMN_H 17 #define BACKUP_CONST_COLUMN_H 18 19 #include "backup_const.h" 20 #include "media_smart_album_column.h" 21 22 namespace OHOS { 23 namespace Media { 24 const int32_t IS_LOCAL_TRUE = 1; 25 const int32_t RENAME_OPERATION_RENAMED = 1; 26 const std::string DEFAULT_BACKUP_VERSION = "backup1.0"; 27 const std::string GALLERY_TABLE_MERGE_FACE = "merge_face"; 28 const std::string GALLERY_TABLE_MERGE_TAG = "merge_tag"; 29 const std::string GALLERY_TABLE_MEDIA = "gallery_media"; 30 const std::string GALLERY_TABLE_FACE = "face"; 31 const std::string GALLERY_TAG_ID = "tag_id"; 32 const std::string GALLERY_FACE_ID = "face_id"; 33 const std::string GALLERY_GROUP_TAG = "merge_tag.group_tag"; 34 const std::string GALLERY_TAG_NAME = "merge_tag.tag_name"; 35 const std::string GALLERY_USER_OPERATION = "merge_tag.user_operation"; 36 const std::string GALLERY_RENAME_OPERATION = "merge_tag.rename_operation"; 37 const std::string GALLERY_SCALE_X = "merge_face.scale_x"; 38 const std::string GALLERY_SCALE_Y = "merge_face.scale_y"; 39 const std::string GALLERY_SCALE_WIDTH = "merge_face.scale_width"; 40 const std::string GALLERY_SCALE_HEIGHT = "merge_face.scale_height"; 41 const std::string GALLERY_PITCH = "merge_face.pitch"; 42 const std::string GALLERY_YAW = "merge_face.yaw"; 43 const std::string GALLERY_ROLL = "merge_face.roll"; 44 const std::string GALLERY_PROB = "merge_face.prob"; 45 const std::string GALLERY_TOTAL_FACE = "merge_face.total_face"; 46 const std::string GALLERY_MERGE_FACE_HASH = GALLERY_TABLE_MERGE_FACE + "." + GALLERY_HASH; 47 const std::string GALLERY_MERGE_FACE_TAG_ID = GALLERY_TABLE_MERGE_FACE + "." + GALLERY_TAG_ID; 48 const std::string GALLERY_MERGE_TAG_TAG_ID = GALLERY_TABLE_MERGE_TAG + "." + GALLERY_TAG_ID; 49 const std::string GALLERY_MEDIA_ID = GALLERY_TABLE_MEDIA + "." + GALLERY_ID; 50 const std::string GALLERY_MEDIA_HASH = GALLERY_TABLE_MEDIA + "." + GALLERY_HASH; 51 const std::string GALLERY_FACE_HASH = GALLERY_TABLE_FACE + "." + GALLERY_HASH; 52 const std::string GALLERY_MERGE_FACE_FACE_ID = GALLERY_TABLE_MERGE_FACE + "." + GALLERY_FACE_ID; 53 const std::string GALLERY_FACE_FACE_ID = GALLERY_TABLE_FACE + "." + GALLERY_FACE_ID; 54 const std::string E_VERSION = "-1"; 55 const std::string TAG_ID_PREFIX = "ser_"; 56 const std::string TAG_ID_UNPROCESSED = "-1"; 57 58 /* AnalysisSearchIndex TBL COL_NAME */ 59 const std::string ANALYSIS_SEARCH_INDEX_TABLE = "tab_analysis_search_index"; 60 const std::string SEARCH_IDX_COL_ID = "id"; // INTEGER 61 const std::string SEARCH_IDX_COL_FILE_ID = "file_id"; // INT 62 const std::string SEARCH_IDX_COL_DATA = "data"; // TEXT 63 const std::string SEARCH_IDX_COL_DISPLAY_NAME = "display_name"; // TEXT 64 const std::string SEARCH_IDX_COL_LATITUDE = "latitude"; // DOUBLE 65 const std::string SEARCH_IDX_COL_LONGITUDE = "longitude"; // DOUBLE 66 const std::string SEARCH_IDX_COL_DATE_MODIFIED = "date_modified"; // BIGINT 67 const std::string SEARCH_IDX_COL_PHOTO_STATUS = "photo_status"; // INT 68 const std::string SEARCH_IDX_COL_CV_STATUS = "cv_status"; // INT 69 const std::string SEARCH_IDX_COL_GEO_STATUS = "geo_status"; // INT 70 const std::string SEARCH_IDX_COL_VERSION = "version"; // INT 71 const std::string SEARCH_IDX_COL_SYSTEM_LANGUAGE = "system_language"; // TEXT 72 73 /* AnalysisAlbum TBL COL_NAME */ 74 const std::string ANALYSIS_COL_ALBUM_ID = "album_id"; 75 const std::string ANALYSIS_COL_ALBUM_TYPE = "album_type"; 76 const std::string ANALYSIS_COL_ALBUM_SUBTYPE = "album_subtype"; 77 const std::string ANALYSIS_COL_ALBUM_NAME = "album_name"; 78 const std::string ANALYSIS_COL_COVER_URI = "cover_uri"; 79 const std::string ANALYSIS_COL_COUNT = "count"; 80 const std::string ANALYSIS_COL_DATE_MODIFIED = "date_modified"; 81 const std::string ANALYSIS_COL_RANK = "rank"; 82 const std::string ANALYSIS_COL_TAG_ID = "tag_id"; 83 const std::string ANALYSIS_COL_USER_OPERATION = "user_operation"; 84 const std::string ANALYSIS_COL_GROUP_TAG = "group_tag"; 85 const std::string ANALYSIS_COL_USER_DISPLAY_LEVEL = "user_display_level"; 86 const std::string ANALYSIS_COL_IS_ME = "is_me"; 87 const std::string ANALYSIS_COL_IS_REMOVED = "is_removed"; 88 const std::string ANALYSIS_COL_RENAME_OPERATION = "rename_operation"; 89 const std::string ANALYSIS_COL_IS_LOCAL = "is_local"; 90 const std::string ANALYSIS_COL_IS_COVER_SATISFIED = "is_cover_satisfied"; 91 92 /* FaceTag TBL COL_NAME */ 93 const std::string FACE_TAG_COL_ID = "id"; 94 const std::string FACE_TAG_COL_TAG_ID = "tag_id"; 95 const std::string FACE_TAG_COL_TAG_NAME = "tag_name"; 96 const std::string FACE_TAG_COL_USER_OPERATION = "user_operation"; 97 const std::string FACE_TAG_COL_GROUP_TAG = "group_tag"; 98 const std::string FACE_TAG_COL_RENAME_OPERATION = "rename_operation"; 99 const std::string FACE_TAG_COL_CENTER_FEATURES = "center_features"; 100 const std::string FACE_TAG_COL_TAG_VERSION = "tag_version"; 101 const std::string FACE_TAG_COL_USER_DISPLAY_LEVEL = "user_display_level"; 102 const std::string FACE_TAG_COL_TAG_ORDER = "tag_order"; 103 const std::string FACE_TAG_COL_IS_ME = "is_me"; 104 const std::string FACE_TAG_COL_COVER_URI = "cover_uri"; 105 const std::string FACE_TAG_COL_COUNT = "count"; 106 const std::string FACE_TAG_COL_DATE_MODIFY = "date_modify"; 107 const std::string FACE_TAG_COL_ALBUM_TYPE = "album_type"; 108 const std::string FACE_TAG_COL_IS_REMOVED = "is_removed"; 109 const std::string FACE_TAG_COL_ANALYSIS_VERSION = "analysis_version"; 110 111 // image_face_tbl COL_NAME 112 const std::string IMAGE_FACE_COL_ID = "id"; 113 const std::string IMAGE_FACE_COL_FILE_ID = "file_id"; 114 const std::string IMAGE_FACE_COL_FACE_ID = "face_id"; 115 const std::string IMAGE_FACE_COL_TAG_ID = "tag_id"; 116 const std::string IMAGE_FACE_COL_SCALE_X = "scale_x"; 117 const std::string IMAGE_FACE_COL_SCALE_Y = "scale_y"; 118 const std::string IMAGE_FACE_COL_SCALE_WIDTH = "scale_width"; 119 const std::string IMAGE_FACE_COL_SCALE_HEIGHT = "scale_height"; 120 const std::string IMAGE_FACE_COL_LANDMARKS = "landmarks"; 121 const std::string IMAGE_FACE_COL_PITCH = "pitch"; 122 const std::string IMAGE_FACE_COL_YAW = "yaw"; 123 const std::string IMAGE_FACE_COL_ROLL = "roll"; 124 const std::string IMAGE_FACE_COL_PROB = "prob"; 125 const std::string IMAGE_FACE_COL_TOTAL_FACES = "total_faces"; 126 const std::string IMAGE_FACE_COL_FACE_VERSION = "face_version"; 127 const std::string IMAGE_FACE_COL_FEATURES_VERSION = "features_version"; 128 const std::string IMAGE_FACE_COL_FEATURES = "features"; 129 const std::string IMAGE_FACE_COL_FACE_OCCLUSION = "face_occlusion"; 130 const std::string IMAGE_FACE_COL_ANALYSIS_VERSION = "analysis_version"; 131 const std::string IMAGE_FACE_COL_BEAUTY_BOUNDER_X = "beauty_bounder_x"; 132 const std::string IMAGE_FACE_COL_BEAUTY_BOUNDER_Y = "beauty_bounder_y"; 133 const std::string IMAGE_FACE_COL_BEAUTY_BOUNDER_WIDTH = "beauty_bounder_width"; 134 const std::string IMAGE_FACE_COL_BEAUTY_BOUNDER_HEIGHT = "beauty_bounder_height"; 135 const std::string IMAGE_FACE_COL_AESTHETICS_SCORE = "aesthetics_score"; 136 const std::string IMAGE_FACE_COL_BEAUTY_BOUNDER_VERSION = "beauty_bounder_version"; 137 const std::string IMAGE_FACE_COL_IS_EXCLUDED = "is_excluded"; 138 const std::string ANALYSIS_ALBUM_SUBTYPE = "album_subtype"; 139 const std::string IMAGE_FACE_COL_FACE_CLARITY = "face_clarity"; 140 const std::string IMAGE_FACE_COL_FACE_LUMINANCE = "face_luminance"; 141 const std::string IMAGE_FACE_COL_FACE_SATURATION = "face_saturation"; 142 const std::string IMAGE_FACE_COL_FACE_EYE_CLOSE = "face_eye_close"; 143 const std::string IMAGE_FACE_COL_FACE_EXPRESSION = "face_expression"; 144 const std::string IMAGE_FACE_COL_PREFERRED_GRADE = "preferred_grade"; 145 const std::string IMAGE_FACE_COL_JOINT_BEAUTY_BOUNDER_X = "joint_beauty_bounder_x"; 146 const std::string IMAGE_FACE_COL_JOINT_BEAUTY_BOUNDER_Y = "joint_beauty_bounder_y"; 147 const std::string IMAGE_FACE_COL_JOINT_BEAUTY_BOUNDER_WIDTH = "joint_beauty_bounder_width"; 148 const std::string IMAGE_FACE_COL_JOINT_BEAUTY_BOUNDER_HEIGHT = "joint_beauty_bounder_height"; 149 const std::string IMAGE_FACE_COL_GROUP_VERSION = "group_version"; 150 151 152 // video_face_tbl COL_NAME 153 const std::string ANALYSIS_VIDEO_FACE_TABLE = "tab_analysis_video_face"; 154 const std::string VIDEO_FACE_COL_ID = "id"; 155 const std::string VIDEO_FACE_COL_FILE_ID = "file_id"; 156 const std::string VIDEO_FACE_COL_FACE_ID = "face_id"; 157 const std::string VIDEO_FACE_COL_TAG_ID = "tag_id"; 158 const std::string VIDEO_FACE_COL_SCALE_X = "scale_x"; 159 const std::string VIDEO_FACE_COL_SCALE_Y = "scale_y"; 160 const std::string VIDEO_FACE_COL_SCALE_WIDTH = "scale_width"; 161 const std::string VIDEO_FACE_COL_SCALE_HEIGHT = "scale_height"; 162 const std::string VIDEO_FACE_COL_LANDMARKS = "landmarks"; 163 const std::string VIDEO_FACE_COL_PITCH = "pitch"; 164 const std::string VIDEO_FACE_COL_YAW = "yaw"; 165 const std::string VIDEO_FACE_COL_ROLL = "roll"; 166 const std::string VIDEO_FACE_COL_PROB = "prob"; 167 const std::string VIDEO_FACE_COL_TOTAL_FACES = "total_faces"; 168 const std::string VIDEO_FACE_COL_FRAME_ID = "frame_id"; 169 const std::string VIDEO_FACE_COL_FRAME_TIMESTAMP = "frame_timestamp"; 170 const std::string VIDEO_FACE_COL_TRACKS = "tracks"; 171 const std::string VIDEO_FACE_COL_ALGO_VERSION = "algo_version"; 172 const std::string VIDEO_FACE_COL_FEATURES = "features"; 173 const std::string VIDEO_FACE_COL_ANALYSIS_VERSION = "analysis_version"; 174 175 // beauty_score_tbl COL_NAME 176 const std::string ANALYSIS_BEAUTY_SCORE_TABLE = "tab_analysis_aesthetics_score"; 177 const std::string BEAUTY_SCORE_COL_ID = "id"; 178 const std::string BEAUTY_SCORE_COL_FILE_ID = "file_id"; 179 const std::string BEAUTY_SCORE_COL_AESTHETICS_SCORE = "aesthetics_score"; 180 const std::string BEAUTY_SCORE_COL_AESTHETICS_VERSION = "aesthetics_version"; 181 const std::string BEAUTY_SCORE_COL_PROB = "prob"; 182 const std::string BEAUTY_SCORE_COL_ANALYSIS_VERSION = "analysis_version"; 183 const std::string BEAUTY_SCORE_COL_SELECTED_FLAG = "selected_flag"; 184 const std::string BEAUTY_SCORE_COL_SELECTED_ALGO_VERSION = "selected_algo_version"; 185 const std::string BEAUTY_SCORE_COL_SELECTED_STATUS = "selected_status"; 186 const std::string BEAUTY_SCORE_COL_NEGATIVE_FLAG = "negative_flag"; 187 const std::string BEAUTY_SCORE_COL_NEGATIVE_ALGO_VERSION = "negative_algo_version"; 188 const std::string BEAUTY_SCORE_COL_AESTHETICS_ALL_VERSION = "aesthetics_all_version"; 189 const std::string BEAUTY_SCORE_COL_AESTHETICS_SCORE_ALL = "aesthetics_score_all"; 190 const std::string BEAUTY_SCORE_COL_IS_FILTERED_HARD = "is_filtered_hard"; 191 const std::string BEAUTY_SCORE_COL_CLARITY_SCORE_ALL = "clarity_score_all"; 192 const std::string BEAUTY_SCORE_COL_SATURATION_SCORE_ALL = "saturation_score_all"; 193 const std::string BEAUTY_SCORE_COL_LUMINANCE_SCORE_ALL = "luminance_score_all"; 194 const std::string BEAUTY_SCORE_COL_SEMANTICS_SCORE = "semantics_score"; 195 const std::string BEAUTY_SCORE_COL_IS_BLACK_WHITE_STRIPE = "is_black_white_stripe"; 196 const std::string BEAUTY_SCORE_COL_IS_BLURRY = "is_blurry"; 197 const std::string BEAUTY_SCORE_COL_IS_MOSAIC = "is_mosaic"; 198 199 200 const std::string QUERY_FACE_TAG_COUNT = "SELECT count(1) AS count FROM " + VISION_FACE_TAG_TABLE; 201 const std::string QUERY_IMAGE_FACE_COUNT = "SELECT count(1) AS count FROM " + VISION_IMAGE_FACE_TABLE; 202 const std::string QUERY_VIDEO_FACE_COUNT = "SELECT count(1) AS count FROM " + VISION_VIDEO_FACE_TABLE; 203 const std::string QUERY_BEAUTY_SCORE_COUNT = "SELECT count(1) AS count FROM " + VISION_AESTHETICS_TABLE; 204 205 const std::string CREATE_FACE_TAG_INDEX = 206 "CREATE INDEX IF NOT EXISTS face_clone_tag_index ON tab_analysis_face_tag (tag_id)"; 207 208 const std::string GALLERY_TAG_NAME_NOT_NULL_OR_EMPTY = GALLERY_TAG_NAME + " IS NOT NULL AND " + GALLERY_TAG_NAME + 209 " != ''"; 210 const std::string GALLERY_TAG_WITH_PHOTOS = "EXISTS (SELECT 1 FROM " + GALLERY_TABLE_MERGE_FACE + " INNER JOIN \ 211 gallery_media ON " + GALLERY_MERGE_FACE_HASH + " = gallery_media.hash WHERE " + LOCAL_PHOTOS_WHERE_CLAUSE + 212 " AND " + GALLERY_MERGE_FACE_TAG_ID + " = " + GALLERY_MERGE_TAG_TAG_ID + ")"; 213 214 const std::string GALLERY_TAG_WITH_CLOUD_PHOTOS = "EXISTS (SELECT 1 FROM " + GALLERY_TABLE_MERGE_FACE + " INNER JOIN \ 215 gallery_media ON " + GALLERY_MERGE_FACE_HASH + " = gallery_media.hash WHERE " + ALL_PHOTOS_WHERE_CLAUSE + " AND " + 216 GALLERY_MERGE_FACE_TAG_ID + " = " + GALLERY_MERGE_TAG_TAG_ID + ")"; 217 218 const std::string GALLERY_PORTRAIT_ALBUM_TABLE = GALLERY_TABLE_MERGE_TAG + " WHERE " + 219 GALLERY_TAG_NAME_NOT_NULL_OR_EMPTY + " AND " + GALLERY_TAG_WITH_PHOTOS; 220 221 const std::string GALLERY_PORTRAIT_ALBUM_TABLE_WITH_CLOUD = GALLERY_TABLE_MERGE_TAG + " WHERE " + 222 GALLERY_TAG_NAME_NOT_NULL_OR_EMPTY + " AND " + GALLERY_TAG_WITH_CLOUD_PHOTOS; 223 224 const std::string QUERY_GALLERY_PORTRAIT_ALBUM_COUNT = "SELECT count(1) as count FROM " + GALLERY_PORTRAIT_ALBUM_TABLE; 225 226 const std::string QUERY_GALLERY_PORTRAIT_ALBUM_WITH_CLOUD_COUNT = "SELECT count(1) as count FROM " + 227 GALLERY_PORTRAIT_ALBUM_TABLE_WITH_CLOUD; 228 229 // Path related 230 const std::string INTERNAL_PREFIX = "/storage/emulated"; 231 constexpr int32_t INTERNAL_PREFIX_LEVEL = 4; 232 constexpr int32_t SD_PREFIX_LEVEL = 3; 233 const std::string APP_TWIN_DATA_PREFIX = "/AppTwinData"; 234 const std::string CLONE_STAT_EDIT_DATA_DIR = "/storage/media/local/files/.editData/"; 235 const std::string CLONE_STAT_RDB_DIR = "/data/storage/el2/database/rdb/"; 236 const std::string CLONE_STAT_KVDB_DIR = "/data/storage/el2/database/kvdb/"; 237 const std::string CLONE_STAT_HIGHLIGHT_DIR = "/storage/media/local/files/highlight/"; 238 const std::string DEFAULT_PATH_PREFIX = "/storage"; 239 } // namespace Media 240 } // namespace OHOS 241 242 #endif // BACKUP_CONST_COLUMN_H