1 /* 2 * Copyright (C) 2021-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 INTERFACES_INNERKITS_NATIVE_INCLUDE_MEDIA_DATA_ABILITY_CONST_H_ 17 #define INTERFACES_INNERKITS_NATIVE_INCLUDE_MEDIA_DATA_ABILITY_CONST_H_ 18 19 #include <map> 20 21 #include "medialibrary_type_const.h" 22 #include "media_column.h" 23 24 namespace OHOS { 25 namespace Media { 26 27 const int32_t MEDIA_RDB_VERSION = 351; 28 29 enum { 30 VERSION_ADD_CLOUD = 2, 31 VERSION_ADD_META_MODIFED = 3, 32 VERSION_MODIFY_SYNC_STATUS = 4, 33 VERSION_ADD_API10_TABLE = 5, 34 VERSION_MODIFY_DELETE_TRIGGER = 6, 35 VERSION_ADD_CLOUD_VERSION = 7, 36 VERSION_UPDATE_CLOUD_PATH = 8, 37 VERSION_UPDATE_API10_TABLE = 9, 38 VERSION_ADD_TABLE_TYPE = 10, 39 VERSION_ADD_PACKAGE_NAME = 11, 40 VERSION_ADD_CLOUD_ALBUM = 12, 41 VERSION_ADD_CAMERA_SHOT_KEY = 13, 42 /** 43 * Remove album count triggers for batch operation performance, 44 * update PhotoAlbum.count by a query and an update(in a single transaction of course) 45 * if number of assets in an album changes. 46 */ 47 VERSION_REMOVE_ALBUM_COUNT_TRIGGER = 14, 48 VERSION_ADD_ALL_EXIF = 15, 49 VERSION_ADD_UPDATE_CLOUD_SYNC_TRIGGER = 16, 50 VERSION_ADD_YEAR_MONTH_DAY = 17, 51 VERSION_UPDATE_YEAR_MONTH_DAY = 18, 52 VERSION_ADD_VISION_TABLE = 20, 53 VERSION_ADD_PHOTO_EDIT_TIME = 21, 54 VERSION_ADD_SHOOTING_MODE = 22, 55 VERSION_FIX_INDEX_ORDER = 23, 56 VERSION_ADD_FACE_TABLE = 24, 57 VERSION_ADD_HIDDEN_VIEW_COLUMNS = 26, 58 VERSION_ADD_HIDDEN_TIME = 27, 59 VERSION_ADD_LAST_VISIT_TIME = 28, 60 VERSION_ADD_LOCATION_TABLE = 29, 61 VERSION_ADD_ALBUM_ORDER = 30, 62 VERSION_ADD_SOURCE_ALBUM_TRIGGER = 31, 63 VERSION_ADD_VISION_ALBUM = 32, 64 VERSION_ADD_AESTHETIC_COMPOSITION_TABLE = 33, 65 VERSION_ADD_FORM_MAP = 34, 66 VERSION_UPDATE_LOCATION_TABLE = 35, 67 VERSION_ADD_PHOTO_CLEAN_FLAG_AND_THUMB_STATUS = 36, 68 VERSION_ADD_SEARCH_TABLE = 37, 69 VERSION_FIX_DOCS_PATH = 38, 70 VERSION_ADD_SALIENCY_TABLE = 39, 71 VERSION_UPDATE_SOURCE_ALBUM_TRIGGER = 40, 72 VERSION_ADD_IMAGE_VIDEO_COUNT = 41, 73 VERSION_ADD_SCHPT_HIDDEN_TIME_INDEX = 42, 74 VERSION_ADD_SHOOTING_MODE_TAG = 43, 75 VERSION_CLEAR_LABEL_DATA = 44, 76 VERSION_ADD_PORTRAIT_IN_ALBUM = 45, 77 VERSION_UPDATE_GEO_TABLE = 46, 78 VERSION_REOMOVE_SOURCE_ALBUM_TO_ANALYSIS = 47, 79 VERSION_ADD_MULTISTAGES_CAPTURE = 48, 80 VERSION_UPDATE_DATE_TO_MILLISECOND = 49, 81 VERSION_ADD_HAS_ASTC = 50, 82 VERSION_ADD_ADDRESS_DESCRIPTION = 51, 83 VERSION_UPDATE_SPEC_FOR_ADD_SCREENSHOT = 52, 84 VERSION_MOVE_SOURCE_ALBUM_TO_PHOTO_ALBUM_AND_ADD_COLUMNS = 53, 85 VERSION_ADD_CLOUD_ID_INDEX = 54, 86 VERSION_UPDATE_PHOTOS_MDIRTY_TRIGGER = 55, 87 VERSION_ALBUM_REFRESH = 56, 88 VERSION_ADD_FAVORITE_INDEX = 57, 89 VERSION_MODIFY_SOURCE_ALBUM_TRIGGERS = 58, 90 VERSION_ADD_IS_LOCAL_ALBUM = 59, 91 VERSION_ADD_MISSING_UPDATES = 60, 92 VERSION_UPDATE_MDIRTY_TRIGGER_FOR_SDIRTY = 61, 93 VERSION_ADD_STOYR_TABLE = 62, 94 VERSION_ADD_HEAD_AND_POSE_TABLE = 63, 95 VERSION_ADD_OWNER_APPID = 64, 96 VERSION_SHOOTING_MODE_CLOUD = 65, 97 VERSION_ADD_IS_COVER_SATISFIED_COLUMN = 66, 98 VERSION_ADD_VIDEO_LABEL_TABEL = 67, 99 VERSION_ADD_SEGMENTATION_COLUMNS = 68, 100 VERSION_UPDATE_SEARCH_INDEX = 69, 101 VERSION_UPDATE_HIGHLIGHT_TABLE = 70, 102 VERSION_UPDATE_HIGHLIGHT_COVER_TABLE = 71, 103 VERSION_CREATE_PHOTOS_EXT_TABLE = 72, 104 VERSION_UPDATE_VIDEO_LABEL_TABEL = 73, 105 VERSION_ADD_FACE_OCCLUSION_AND_POSE_TYPE_COLUMN = 74, 106 VERSION_MOVE_KVDB = 75, 107 VERSION_ADD_DYNAMIC_RANGE_TYPE = 76, 108 VERSION_UPDATE_PHOTO_ALBUM_BUNDLENAME = 77, 109 VERSION_UPDATE_PHOTO_ALBUM_TIGGER = 78, 110 VERSION_ADD_THUMB_LCD_SIZE_COLUMN = 79, 111 VERSION_ADD_MOVING_PHOTO_EFFECT_MODE = 80, 112 VERSION_UPDATE_HIGHLIGHT_TABLE_PRIMARY_KEY = 81, 113 VERSION_UPDATE_VISION_TRIGGER_FOR_VIDEO_LABEL = 82, 114 VERSION_ADD_IS_TEMP = 83, 115 VERSION_ADD_OWNER_APPID_TO_FILES_TABLE = 84, 116 VERSION_ADD_IS_TEMP_TO_TRIGGER = 85, 117 VERSION_UPDATE_ANALYSIS_TABLES = 86, 118 VERSION_UPDATE_PHOTO_THUMBNAIL_READY = 87, 119 VERSION_ADD_FRONT_CAMERA_TYPE = 88, 120 PHOTOS_CREATE_DISPLAYNAME_INDEX = 89, 121 VERSION_PORTRAIT_COVER_SELECTION_ADD_COLUMNS = 90, 122 VERSION_ADD_BURST_COVER_LEVEL_AND_BURST_KEY = 91, 123 VERSION_ADD_COVER_POSITION = 92, 124 VERSION_ADD_SCHPT_READY_INEDX = 93, 125 VERSION_UPDATE_PORTRAIT_COVER_SELECTION_COLUMNS = 94, 126 VERSION_ADD_APP_URI_PERMISSION_INFO = 95, 127 VERSION_UPDATE_SOURCE_ALBUM_AND_ALBUM_BUNDLENAME_TRIGGERS = 96, 128 VERSION_CREATE_BURSTKEY_INDEX = 98, 129 VERSION_UPDATE_PHOTO_INDEX_FOR_ALBUM_COUNT_COVER = 99, 130 VERSION_UPDATE_VIDEO_LABEL_TABLE_FOR_SUB_LABEL_TYPE = 100, 131 VERSION_UPGRADE_THUMBNAIL = 101, 132 VISION_UPDATE_DATA_ADDED_INDEX = 102, 133 VISION_UPDATE_SEARCH_INDEX_TRIGGER = 103, 134 VISION_UPDATE_MULTI_CROP_INFO = 104, 135 VISION_ADD_ORIGINAL_SUBTYPE = 105, 136 VERSION_UPDATE_BURST_DIRTY = 106, 137 VERSION_UDAPTE_DATA_UNIQUE = 107, 138 VERSION_ADD_DETAIL_TIME = 108, 139 VERSION_ADD_VIDEO_FACE_TABLE = 109, 140 VERSION_ADD_OWNER_ALBUM_ID = 110, 141 VERSION_CLOUD_ENAHCNEMENT = 111, 142 VERSION_UPDATE_MDIRTY_TRIGGER_FOR_UPLOADING_MOVING_PHOTO = 112, 143 VERSION_MOVE_AUDIOS = 113, 144 VERSION_ADD_INDEX_FOR_FILEID = 114, 145 VERSION_ADD_OCR_CARD_COLUMNS = 115, 146 VERSION_UPDATE_AOI = 116, 147 VERSION_UPDATE_VIDEO_FACE_TABLE = 117, 148 VERSION_ADD_SUPPORTED_WATERMARK_TYPE = 118, 149 VERSION_FIX_PHOTO_SCHPT_MEDIA_TYPE_INDEX = 119, 150 VERSION_UPDATE_INDEX_FOR_COVER = 120, 151 VERSION_ADD_ANALYSIS_ALBUM_TOTAL_TABLE = 121, 152 VERSION_ADD_THUMBNAIL_VISIBLE = 122, 153 VERSION_ADD_METARECOVERY = 123, 154 VERSION_UPDATE_SEARCH_INDEX_TRIGGER_FOR_CLEAN_FLAG = 124, 155 VERSION_ADD_COVER_PLAY_SERVICE_VERSION = 125, 156 VERSION_ADD_HIGHLIGHT_MAP_TABLES = 126, 157 VERSION_COMPAT_LIVE_PHOTO = 127, 158 VERSION_CREATE_TAB_OLD_PHOTOS = 128, 159 VERSION_ADD_HIGHLIGHT_TRIGGER = 129, 160 VERSION_ALTER_THUMBNAIL_VISIBLE = 130, 161 VERSION_ADD_HIGHLIGHT_VIDEO_COUNT_CAN_PACK = 131, 162 VERSION_ADD_GEO_DEFAULT_VALUE = 132, 163 VERSION_HDR_AND_CLOUD_ENHANCEMENT_FIX = 133, 164 VERSION_THUMBNAIL_READY_FIX = 134, 165 VERSION_UPDATE_DATETAKEN_AND_DETAILTIME = 135, 166 VERSION_UPDATE_SOURCE_PHOTO_ALBUM_TRIGGER = 136, 167 VERSION_UPDATE_URIPERMISSION_SOURCE_TOKEN_AND_TARGET_TOKEN = 137, 168 VERSION_ADD_READY_COUNT_INDEX = 138, 169 VERSION_FIX_PICTURE_LCD_SIZE = 139, 170 VERSION_FIX_DATE_ADDED_INDEX = 140, 171 VERSION_UPDATE_NEW_SOURCE_PHOTO_ALBUM_TRIGGER = 141, 172 VERSION_REVERT_FIX_DATE_ADDED_INDEX = 142, 173 VERSION_UPDATE_SEARCH_STATUS_TRIGGER_FOR_OWNER_ALBUM_ID = 143, 174 VERSION_ADD_CLOUD_ENHANCEMENT_ALBUM_INDEX = 144, 175 VERSION_HIGHLIGHT_CHANGE_FUNCTION = 145, 176 VERSION_ADD_PHOTO_DATEADD_INDEX = 146, 177 VERSION_ADD_ALBUM_INDEX = 147, 178 VERSION_REFRESH_PERMISSION_APPID = 148, 179 VERSION_UPDATE_PHOTOS_DATE_AND_IDX = 149, 180 VERSION_ADD_CHECK_FLAG = 150, 181 VERSION_ADD_HIGHLIGHT_ANALYSIS_PROGRESS = 151, 182 VERSION_FIX_SOURCE_PHOTO_ALBUM_DATE_MODIFIED = 152, 183 VERSION_UPDATE_LATITUDE_AND_LONGITUDE_DEFAULT_NULL = 153, 184 VERSION_ADD_REFRESH_ALBUM_STATUS_COLUMN = 154, 185 VERSION_FIX_SOURCE_ALBUM_UPDATE_TRIGGER_TO_USE_LPATH = 155, 186 VERSION_UPDATE_PHOTOS_DATE_IDX = 156, 187 VERSION_UPDATE_MEDIA_TYPE_AND_THUMBNAIL_READY_IDX = 157, 188 VERSION_FIX_PHOTO_QUALITY_CLONED = 158, 189 VERSION_ADD_STAGE_VIDEO_TASK_STATUS = 159, 190 VERSION_HIGHLIGHT_SUBTITLE = 160, 191 VERSION_ADD_IS_AUTO = 161, 192 VERSION_ADD_MEDIA_SUFFIX_COLUMN = 162, 193 VERSION_UPDATE_SOURCE_PHOTO_ALBUM_TRIGGER_AGAIN = 163, 194 VERSION_ADD_MEDIA_IS_RECENT_SHOW_COLUMN = 164, 195 VERSION_CREATE_TAB_FACARD_PHOTOS = 165, // ABANDONED 196 VERSION_FIX_SOURCE_ALBUM_CREATE_TRIGGERS_TO_USE_LPATH = 166, 197 VERSION_ADD_ALBUM_PLUGIN_BUNDLE_NAME = 167, 198 VERSION_ADD_FOREGROUND_ANALYSIS = 168, 199 VERSION_HIGHLIGHT_MOVING_PHOTO = 169, 200 VERSION_UPDATE_LOCATION_KNOWLEDGE_INDEX = 170, 201 VERSION_IMAGE_FACE_TAG_ID_INDEX = 171, 202 VERSION_ADD_GROUP_TAG_INDEX = 172, 203 VERSION_ANALYZE_PHOTOS = 173, 204 VERSION_CREATE_TAB_ASSET_ALBUM_OPERATION = 174, 205 VERSION_MDIRTY_TRIGGER_UPLOAD_DETAIL_TIME = 175, 206 VERSION_CREATE_OPERATION_ALBUM_UPDATE_TRIGGER = 176, 207 VERSION_ADD_ANALYSIS_PHOTO_MAP_MAP_ASSET_INDEX = 177, 208 VERSION_UPDATE_MDIRTY_TRIGGER_FOR_TDIRTY = 178, 209 VERSION_ADD_ALBUM_SUBTYPE_AND_NAME_INDEX = 179, 210 VERSION_FIX_DB_UPGRADE_FROM_API15 = 250, 211 VERSION_CREATE_TAB_ASSET_ALBUM_OPERATION_FOR_SYNC = 251, 212 VERSION_CREATE_TAB_FACARD_PHOTOS_RETRY = 252, 213 VERSION_UPDATE_SEARCH_STATUS_TRIGGER_FOR_IS_FAVORITE = 253, 214 VERSION_UPGRADE_ANALYSIS_UPDATE_SEARCH_TRIGGER = 254, 215 VERSION_ADD_DC_ANALYSIS = 255, 216 VERSION_CLOUD_MEDIA_UPGRADE = 256, 217 VERSION_ADD_VISIT_COUNT = 257, 218 VERSION_CREATE_TAB_CUSTOM_RECORDS = 258, 219 VERSION_FIX_TAB_EXT_DIRTY_DATA = 259, 220 VERSION_ADD_DC_ANALYSIS_INDEX_UPDATE = 260, 221 VERSION_ADD_IS_RECTIFICATION_COVER = 261, 222 VERSION_ADD_COVER_URI_SOURCE = 262, 223 VERSION_FIX_ORIENTATION_180_DIRTY_THUMBNAIL = 263, 224 VERSION_ADD_PHOTO_ALBUM_REFRESH_COLUMNS = 264, 225 VERSION_ADD_EDITDATA_SIZE_COLUMN = 265, 226 VERSION_ADD_AESTHETICS_SCORE_FIELDS = 266, 227 VERSION_ADD_INDEX_FOR_PHOTO_SORT = 267, 228 VERSION_ADD_HIGHLIGHT_LOCATION = 268, 229 VERSION_ADD_PHOTO_QUERY_THUMBNAIL_WHITE_BLOCKS_INDEX = 269, 230 VERSION_ADD_PRIORITY_COLUMN = 270, 231 VERSION_ADD_ALBUMS_ORDER_KEYS_COLUMNS = 271, 232 VERSION_ADD_IS_PRIMARY_FACE = 272, 233 VERSION_DROP_PHOTO_INSERT_SOURCE_PHOTO_TRIGGER = 273, 234 VERSION_SHOOTING_MODE_ALBUM_SECOND_INTERATION = 274, 235 VERSION_FIX_DB_UPGRADE_FROM_API18 = 275, 236 VERSION_READD_INSERT_TRIGGER = 276, 237 VERSION_ADD_BEST_FACE_BOUNDING = 277, 238 VERSION_TRANSFER_OWNERAPPID_TO_TOKENID = 278, 239 VERSION_ADD_GROUP_VERSION = 279, 240 VERSION_ADD_SEARCH_TAG = 280, 241 VERSION_ADD_EXIF_ROTATE_COLUMN_AND_SET_VALUE = 281, 242 VERSION_FIX_DB_UPGRADE_TO_API20 = 350, 243 VERSION_UPDATE_PHOTO_ALBUM_DATEMODIFIED_TIGGER = 351, 244 }; 245 enum { 246 MEDIA_API_VERSION_DEFAULT = 8, 247 MEDIA_API_VERSION_V9, 248 MEDIA_API_VERSION_V10, 249 }; 250 251 enum CloudFilePosition { 252 POSITION_LOCAL = 1 << 0, 253 POSITION_CLOUD = 1 << 1, 254 }; 255 256 const std::string MEDIA_LIBRARY_VERSION = "1.0"; 257 258 const int32_t DEVICE_SYNCSTATUSING = 0; 259 const int32_t DEVICE_SYNCSTATUS_COMPLETE = 1; 260 261 const std::string MEDIALIBRARY_TABLE = "Files"; 262 const std::string SMARTALBUM_TABLE = "SmartAlbum"; 263 const std::string SMARTALBUM_MAP_TABLE = "SmartMap"; 264 const std::string CATEGORY_SMARTALBUM_MAP_TABLE = "CategorySmartAlbumMap"; 265 const std::string MEDIATYPE_DIRECTORY_TABLE = "MediaTypeDirectory"; 266 const std::string DEVICE_TABLE = "Device"; 267 const std::string BUNDLE_PERMISSION_TABLE = "BundlePermission"; 268 const std::string MEDIA_DATA_ABILITY_DB_NAME = "media_library.db"; 269 270 const std::string BUNDLE_NAME = "com.ohos.medialibrary.medialibrarydata"; 271 272 constexpr int64_t AGING_TIME = 30LL * 60 * 60 * 24 * 1000; 273 274 const std::string MEDIA_DATA_DB_ID = "file_id"; 275 const std::string MEDIA_DATA_DB_URI = "uri"; 276 const std::string MEDIA_DATA_DB_FILE_PATH = "data"; 277 const std::string MEDIA_DATA_DB_SIZE = "size"; 278 const std::string MEDIA_DATA_DB_PARENT_ID = "parent"; 279 const std::string MEDIA_DATA_DB_DATE_MODIFIED = "date_modified"; 280 const std::string MEDIA_DATA_DB_DATE_MODIFIED_S = "date_modified_s"; 281 const std::string MEDIA_DATA_DB_DATE_MODIFIED_MS = "date_modified_ms"; 282 const std::string MEDIA_DATA_DB_DATE_MODIFIED_TO_SECOND = "CAST(date_modified / 1000 AS BIGINT) AS date_modified_s"; 283 const std::string MEDIA_DATA_DB_DATE_ADDED = "date_added"; 284 const std::string MEDIA_DATA_DB_DATE_ADDED_S = "date_added_s"; 285 const std::string MEDIA_DATA_DB_DATE_ADDED_MS = "date_added_ms"; 286 const std::string MEDIA_DATA_DB_DATE_ADDED_TO_SECOND = "CAST(date_added / 1000 AS BIGINT) AS date_added_s"; 287 const std::string MEDIA_DATA_DB_MIME_TYPE = "mime_type"; 288 const std::string MEDIA_DATA_DB_TITLE = "title"; 289 const std::string MEDIA_DATA_DB_DESCRIPTION = "description"; 290 const std::string MEDIA_DATA_DB_NAME = "display_name"; 291 const std::string MEDIA_DATA_DB_ORIENTATION = "orientation"; 292 const std::string MEDIA_DATA_DB_LATITUDE = "latitude"; 293 const std::string MEDIA_DATA_DB_LONGITUDE = "longitude"; 294 const std::string MEDIA_DATA_DB_DATE_TAKEN = "date_taken"; 295 const std::string MEDIA_DATA_DB_DATE_TAKEN_S = "date_taken_s"; 296 const std::string MEDIA_DATA_DB_DATE_TAKEN_MS = "date_taken_ms"; 297 const std::string MEDIA_DATA_DB_DATE_TAKEN_TO_SECOND = "CAST(date_taken / 1000 AS BIGINT) AS date_taken_s"; 298 const std::string MEDIA_DATA_DB_THUMBNAIL = "thumbnail"; 299 const std::string MEDIA_DATA_DB_THUMB_ASTC = "astc"; 300 const std::string MEDIA_DATA_DB_HAS_ASTC = "has_astc"; // This attribute has been replaced by "thumbnail_ready" 301 const std::string MEDIA_DATA_DB_CONTENT_CREATE_TIME = "content_create_time"; 302 const std::string MEDIA_DATA_DB_POSITION = "position"; 303 const std::string MEDIA_DATA_DB_DIRTY = "dirty"; 304 const std::string MEDIA_DATA_DB_CLOUD_ID = "cloud_id"; 305 const std::string MEDIA_DATA_DB_META_DATE_MODIFIED = "meta_date_modified"; 306 const std::string MEDIA_DATA_DB_SYNC_STATUS = "sync_status"; 307 const std::string MEDIA_DATA_DB_THUMBNAIL_READY = "thumbnail_ready"; 308 const std::string MEDIA_DATA_DB_ALL_EXIF = "all_exif"; 309 const std::string MEDIA_DATA_DB_SHOOTING_MODE = "shooting_mode"; 310 const std::string MEDIA_DATA_DB_SHOOTING_MODE_TAG = "shooting_mode_tag"; 311 const std::string MEDIA_DATA_DB_PHOTOS_LATITUDE = "photos." + MEDIA_DATA_DB_LATITUDE; 312 const std::string MEDIA_DATA_DB_PHOTOS_LONGITUDE = "photos." + MEDIA_DATA_DB_LONGITUDE; 313 const std::string MEDIA_DATA_DB_USER_OPERATION = "user_operation"; 314 const std::string MEDIA_DATA_DB_RENAME_OPERATION = "rename_operation"; 315 const std::string MEDIA_DATA_DB_COVER_SATISFIED = "is_cover_satisfied"; 316 317 const std::string MEDIA_DATA_DB_LCD = "lcd"; 318 const std::string MEDIA_DATA_DB_BUCKET_ID = "bucket_id"; 319 const std::string MEDIA_DATA_DB_BUCKET_NAME = "bucket_display_name"; 320 const std::string MEDIA_DATA_DB_DURATION = "duration"; 321 const std::string MEDIA_DATA_DB_ARTIST = "artist"; 322 323 const std::string MEDIA_DATA_DB_AUDIO_ALBUM = "audio_album"; 324 const std::string MEDIA_DATA_DB_MEDIA_TYPE = "media_type"; 325 326 const std::string MEDIA_DATA_DB_HEIGHT = "height"; 327 const std::string MEDIA_DATA_DB_WIDTH = "width"; 328 const std::string MEDIA_DATA_DB_OWNER_PACKAGE = "owner_package"; 329 const std::string MEDIA_DATA_DB_OWNER_APPID = "owner_appid"; 330 const std::string MEDIA_DATA_DB_PACKAGE_NAME = "package_name"; 331 332 const std::string MEDIA_DATA_DB_IS_FAV = "is_favorite"; 333 const std::string MEDIA_DATA_DB_IS_TRASH = "is_trash"; 334 const std::string MEDIA_DATA_DB_RECYCLE_PATH = "recycle_path"; 335 const std::string MEDIA_DATA_DB_DATE_TRASHED = "date_trashed"; 336 const std::string MEDIA_DATA_DB_DATE_TRASHED_S = "date_trashed_s"; 337 const std::string MEDIA_DATA_DB_DATE_TRASHED_MS = "date_trashed_ms"; 338 const std::string MEDIA_DATA_DB_DATE_TRASHED_TO_SECOND = "CAST(date_trashed / 1000 AS BIGINT) AS date_trashed_s"; 339 const std::string MEDIA_DATA_DB_IS_PENDING = "is_pending"; 340 const std::string MEDIA_DATA_DB_TIME_PENDING = "time_pending"; 341 const std::string MEDIA_DATA_DB_RELATIVE_PATH = "relative_path"; 342 const std::string MEDIA_DATA_DB_VOLUME_NAME = "volume_name"; 343 const std::string MEDIA_DATA_DB_SELF_ID = "self_id"; 344 const std::string MEDIA_DATA_DB_DEVICE_NAME = "device_name"; 345 346 const std::string MEDIA_DATA_DB_ALBUM = "album"; 347 const std::string MEDIA_DATA_DB_ALBUM_ID = "album_id"; 348 const std::string MEDIA_DATA_DB_REFERENCE_ALBUM_ID = "reference_album_id"; 349 const std::string MEDIA_DATA_DB_ALBUM_NAME = "album_name"; 350 const std::string MEDIA_DATA_DB_COUNT = "count"; 351 const std::string MEDIA_DATA_BUNDLENAME = "bundle_name"; 352 const std::string MEDIA_DATA_DB_IS_LOCAL = "is_local"; 353 354 const std::string MEDIA_DATA_CALLING_UID = "calling_uid"; 355 356 const std::map<std::string, std::string> DATE_TRANSITION_MAP = { 357 { MEDIA_DATA_DB_DATE_MODIFIED_MS, MEDIA_DATA_DB_DATE_MODIFIED }, 358 { MEDIA_DATA_DB_DATE_ADDED_MS, MEDIA_DATA_DB_DATE_ADDED }, 359 { MEDIA_DATA_DB_DATE_TRASHED_MS, MEDIA_DATA_DB_DATE_TRASHED }, 360 { MEDIA_DATA_DB_DATE_TAKEN_MS, MEDIA_DATA_DB_DATE_TAKEN }, 361 }; 362 363 const std::string MEDIA_DATA_DB_ALARM_URI = "alarm_uri"; 364 365 const std::string MEDIA_DATA_DB_PHOTO_ID = "photo_id"; 366 const std::string MEDIA_DATA_DB_PHOTO_QUALITY = "photo_quality"; 367 const std::string MEDIA_DATA_DB_STAGE_VIDEO_TASK_STATUS = "stage_video_task_status"; 368 369 const std::string MEDIA_COLUMN_COUNT = "count(*)"; 370 const std::string MEDIA_COLUMN_COUNT_1 = "count(1)"; 371 const std::string MEDIA_SUM_SIZE = "sum(size)"; 372 373 const std::string PHOTO_INDEX = "photo_index"; 374 375 const std::string PERMISSION_ID = "id"; 376 const std::string PERMISSION_BUNDLE_NAME = "bundle_name"; 377 const std::string PERMISSION_FILE_ID = "file_id"; 378 const std::string PERMISSION_MODE = "mode"; 379 const std::string PERMISSION_TABLE_TYPE = "table_type"; 380 381 const std::string ALBUM_TABLE = "album"; 382 const std::string ALBUM_VIEW_NAME = "Album"; 383 384 const std::string ASSETMAP_VIEW_NAME = "AssetMap"; 385 386 const std::string IMAGE_ASSET_TYPE = "image"; 387 const std::string VIDEO_ASSET_TYPE = "video"; 388 const std::string AUDIO_ASSET_TYPE = "audio"; 389 390 // Caution: Keep same definition as MediaColumn! Only for where clause check in API9 getAlbums and album.getFileAssets 391 const std::string COMPAT_ALBUM_SUBTYPE = "album_subtype"; 392 const std::string COMPAT_HIDDEN = "hidden"; 393 const std::string COMPAT_PHOTO_SYNC_STATUS = "sync_status"; 394 const std::string COMPAT_FILE_SUBTYPE = "subtype"; 395 const std::string COMPAT_CAMERA_SHOT_KEY = "camera_shot_key"; 396 397 // system relativePath and albumName, use for API9 compatible API10 398 const std::string CAMERA_PATH = "Camera/"; 399 const std::string SCREEN_SHOT_PATH = "Pictures/Screenshots/"; 400 const std::string SCREEN_RECORD_PATH = "Videos/ScreenRecordings/"; 401 402 const std::string CAMERA_ALBUM_NAME = "Camera"; 403 const std::string SCREEN_SHOT_ALBUM_NAME = "Screenshots"; 404 const std::string SCREEN_RECORD_ALBUM_NAME = "ScreenRecordings"; 405 406 // extension 407 const std::string ASSET_EXTENTION = "extention"; 408 409 // edit param 410 const std::string EDIT_DATA_REQUEST = "edit_data_request"; // MEDIA_OPERN_KEYWORD=EDIT_DATA_REQUEST 411 const std::string SOURCE_REQUEST = "source_request"; // MEDIA_OPERN_KEYWORD=SOURCE_REQUEST 412 const std::string COMMIT_REQUEST = "commit_request"; // MEDIA_OPERN_KEYWORD=COMMIT_REQUEST 413 const std::string EDIT_DATA = "edit_data"; 414 const std::string COMPATIBLE_FORMAT = "compatible_format"; 415 const std::string FORMAT_VERSION = "format_version"; 416 const std::string APP_ID = "app_id"; 417 418 // write cache 419 const std::string CACHE_FILE_NAME = "cache_file_name"; 420 const std::string CACHE_MOVING_PHOTO_VIDEO_NAME = "cache_moving_photo_video_name"; 421 422 // moving photo param 423 const std::string CREATE_MOVING_PHOTO_VIDEO = "create_video"; 424 const std::string OPEN_MOVING_PHOTO_VIDEO = "open_video"; // MEDIA_MOVING_PHOTO_OPRN_KEYWORD=OPEN_MOVING_PHOTO_VIDEO 425 const std::string OPEN_PRIVATE_MOVING_PHOTO_METADATA = "open_metadata"; 426 const std::string OPEN_PRIVATE_LIVE_PHOTO = "open_private_live_photo"; 427 const std::string OPEN_MOVING_PHOTO_VIDEO_CLOUD = "open_moving_photo_video_cloud"; 428 const std::string NOTIFY_VIDEO_SAVE_FINISHED = "notify_video_save_finished"; // movingPhoto video save finish 429 430 // db sandbox directory 431 const std::string MEDIA_DB_DIR = "/data/medialibrary/database"; 432 433 // slave medialibrary db file path 434 const std::string MEDIA_DB_FILE_SLAVE = "/data/storage/el2/database/rdb/media_library_slave.db"; 435 const std::string MEDIA_DB_FILE_SLAVE_SHM = "/data/storage/el2/database/rdb/media_library_slave.db-shm"; 436 const std::string MEDIA_DB_FILE_SLAVE_WAL = "/data/storage/el2/database/rdb/media_library_slave.db-wal"; 437 438 // requestId for generating thumbnail in batches 439 const std::string THUMBNAIL_BATCH_GENERATE_REQUEST_ID = "thumbnail_request_id"; 440 const std::string IMAGE_FILE_TYPE = "image_file_type"; 441 442 const std::string RESTORE_REQUEST_ASTC_GENERATE_COUNT = "restore_request_astc_generate_count"; 443 } // namespace Media 444 } // namespace OHOS 445 446 #endif // INTERFACES_INNERKITS_NATIVE_INCLUDE_MEDIA_DATA_ABILITY_CONST_H_ 447