diff options
author | Minje Ahn <minje.ahn@samsung.com> | 2020-07-27 13:02:22 +0900 |
---|---|---|
committer | Minje Ahn <minje.ahn@samsung.com> | 2020-07-27 13:02:22 +0900 |
commit | 2757e6b0e3b3d4b0d1280eedf2372bfc3c9645b7 (patch) | |
tree | 8ef379d8e7d1c09cb106148cc357d0b4df37fdb2 | |
parent | a67dcb5819f558b9409a3e03c0301c1a52230f16 (diff) | |
download | libmedia-service-accepted/tizen_5.5_unified.tar.gz libmedia-service-accepted/tizen_5.5_unified.tar.bz2 libmedia-service-accepted/tizen_5.5_unified.zip |
Restore deleted triggerssubmit/tizen_5.5_wearable_hotfix/20201026.184303submit/tizen_5.5/20200728.033326accepted/tizen/5.5/unified/wearable/hotfix/20201027.115526accepted/tizen/5.5/unified/20200729.230630tizen_5.5_wearable_hotfixtizen_5.5accepted/tizen_5.5_unified_wearable_hotfixaccepted/tizen_5.5_unified
Restore deleted triggers when DB upgrade v6 to v8.
Deleted trigger list:
playlist_map_cleanup_media
tag_map_cleanup_media
bookmark_cleanup_media
album_cleanup_media
Change-Id: I00c12da984a5a637309c314a1e97ac42f3a20ca1
Signed-off-by: Minje Ahn <minje.ahn@samsung.com>
-rwxr-xr-x | src/common/media-svc-db-utils.c | 36 |
1 files changed, 36 insertions, 0 deletions
diff --git a/src/common/media-svc-db-utils.c b/src/common/media-svc-db-utils.c index 2e73eaf..1e9542e 100755 --- a/src/common/media-svc-db-utils.c +++ b/src/common/media-svc-db-utils.c @@ -1308,6 +1308,42 @@ static int __media_svc_db_upgrade(sqlite3 *db_handle, int cur_version, uid_t uid media_svc_error("_media_svc_sql_query failed"); goto ERROR; } + + sql = sqlite3_mprintf(MEDIA_SVC_DB_QUERY_TRIGGER, "playlist_map_cleanup_media", MEDIA_SVC_DB_TABLE_MEDIA, MEDIA_SVC_DB_TABLE_PLAYLIST_MAP, "media_id", "media_id"); + + ret = _media_svc_sql_query(sql, uid); + SQLITE3_SAFE_FREE(sql); + if (ret != MS_MEDIA_ERR_NONE) { + media_svc_error("_media_svc_sql_query failed"); + goto ERROR; + } + + sql = sqlite3_mprintf(MEDIA_SVC_DB_QUERY_TRIGGER, "tag_map_cleanup_media", MEDIA_SVC_DB_TABLE_MEDIA, MEDIA_SVC_DB_TABLE_TAG_MAP, "media_id", "media_id"); + + ret = _media_svc_sql_query(sql, uid); + SQLITE3_SAFE_FREE(sql); + if (ret != MS_MEDIA_ERR_NONE) { + media_svc_error("_media_svc_sql_query failed"); + goto ERROR; + } + + sql = sqlite3_mprintf(MEDIA_SVC_DB_QUERY_TRIGGER, "bookmark_cleanup_media", MEDIA_SVC_DB_TABLE_MEDIA, MEDIA_SVC_DB_TABLE_BOOKMARK, "media_id", "media_id"); + + ret = _media_svc_sql_query(sql, uid); + SQLITE3_SAFE_FREE(sql); + if (ret != MS_MEDIA_ERR_NONE) { + media_svc_error("_media_svc_sql_query failed"); + goto ERROR; + } + + sql = sqlite3_mprintf(MEDIA_SVC_DB_QUERY_TRIGGER_WITH_COUNT, "album_cleanup_media", MEDIA_SVC_DB_TABLE_MEDIA, MEDIA_SVC_DB_TABLE_ALBUM, MEDIA_SVC_DB_TABLE_MEDIA, "album_id", "album_id", "album_id", "album_id"); + + ret = _media_svc_sql_query(sql, uid); + SQLITE3_SAFE_FREE(sql); + if (ret != MS_MEDIA_ERR_NONE) { + media_svc_error("_media_svc_sql_query failed"); + goto ERROR; + } } /* Rebuilding view */ |