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 #ifndef OHOS_MEDIA_DATATRANSFER_GALLERY_DB_UPGRADE_H 16 #define OHOS_MEDIA_DATATRANSFER_GALLERY_DB_UPGRADE_H 17 18 #include "rdb_store.h" 19 #include "db_upgrade_utils.h" 20 21 namespace OHOS::Media { 22 namespace DataTransfer { 23 class GalleryDbUpgrade { 24 public: 25 int32_t OnUpgrade(NativeRdb::RdbStore &store); 26 27 private: 28 int32_t AddPhotoQualityOfGalleryMedia(NativeRdb::RdbStore &store); 29 int32_t AddRelativeBucketIdOfGalleryAlbum(NativeRdb::RdbStore &store); 30 31 private: 32 // Note: The column photo_quality's default value is 0. 33 // But we should set it to 1 for the existing data. 34 const std::string SQL_GALLERY_MEDIA_TABLE_ADD_PHOTO_QUALITY = "\ 35 ALTER TABLE gallery_media ADD COLUMN photo_quality INTEGER DEFAULT 1;"; 36 const std::string SQL_GALLERY_ALBUM_TABLE_ADD_RELATIVE_BUCKET_ID = "\ 37 ALTER TABLE gallery_album ADD COLUMN relativeBucketId TEXT;"; 38 39 private: 40 DbUpgradeUtils dbUpgradeUtils_; 41 }; 42 } // namespace DataTransfer 43 } // namespace OHOS::Media 44 #endif // OHOS_MEDIA_DATATRANSFER_GALLERY_DB_UPGRADE_H