From 1fb83045e8acecdff82138ab7b2a72805f78f5ea Mon Sep 17 00:00:00 2001 From: Minje Ahn Date: Thu, 8 Sep 2016 09:42:25 +0900 Subject: [PATCH] Ignore query when conflict occur Change-Id: I4cee4cf2e1ed3ac5f4f13d0c9b3596f053a676e2 Signed-off-by: Minje Ahn --- src/common/media-svc-media-folder.c | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) diff --git a/src/common/media-svc-media-folder.c b/src/common/media-svc-media-folder.c index 1599d90..bbf80fe 100755 --- a/src/common/media-svc-media-folder.c +++ b/src/common/media-svc-media-folder.c @@ -196,8 +196,9 @@ static int __media_svc_append_folder(const char *storage_id, media_svc_storage_t char *folder_name_pinyin = NULL; if (_media_svc_check_pinyin_support()) _media_svc_get_pinyin_str(folder_name, &folder_name_pinyin); - - char *sql = sqlite3_mprintf("INSERT INTO %s (folder_uuid, path, name, storage_uuid, storage_type, modified_time, name_pinyin, parent_folder_uuid) \ + /* Sometime SQLITE3 returns NO_RECORD, so need to consider conflict case.. */ + media_svc_debug("UNIQUE:path[%s], storage_uuid[%s]", folder_path, storage_id); + char *sql = sqlite3_mprintf("INSERT OR IGNORE INTO %s (folder_uuid, path, name, storage_uuid, storage_type, modified_time, name_pinyin, parent_folder_uuid) \ values (%Q, %Q, %Q, %Q, '%d', '%d', %Q, %Q); ", MEDIA_SVC_DB_TABLE_FOLDER, folder_id, folder_path, folder_name, storage_id, storage_type, folder_modified_date, folder_name_pinyin, parent_folder_uuid); -- 2.7.4