diff options
Diffstat (limited to 'src/badge_setting_service.c')
| -rw-r--r-- | src/badge_setting_service.c | 61 |
1 files changed, 61 insertions, 0 deletions
diff --git a/src/badge_setting_service.c b/src/badge_setting_service.c index 3a5e7f4..9a61b7d 100644 --- a/src/badge_setting_service.c +++ b/src/badge_setting_service.c @@ -693,3 +693,64 @@ out: return ret; } +EXPORT_API int badge_setting_arrange_tables(uid_t uid) +{ + int ret = BADGE_ERROR_NONE; + int sqlret; + sqlite3 *db = NULL; + char *sqlbuf = NULL; + + sqlret = db_util_open(BADGE_DB_PATH, &db, 0); + if (sqlret != SQLITE_OK || !db) { + ERR("Failed to db_util_open [%d]", sqlret); + if (sqlret == SQLITE_PERM) + return BADGE_ERROR_PERMISSION_DENIED; + return BADGE_ERROR_FROM_DB; + } + + sqlbuf = sqlite3_mprintf("DELETE FROM %Q WHERE pkgname not in " + "(SELECT pkgname FROM %Q) AND uid = %d", + BADGE_TABLE_NAME, BADGE_SETTING_DB_TABLE, uid); + if (sqlbuf == NULL) { + /* LCOV_EXCL_START */ + ERR("Failed to alloc query"); + ret = BADGE_ERROR_OUT_OF_MEMORY; + goto out; + /* LCOV_EXCL_STOP */ + } + + ret = badge_db_exec(db, sqlbuf, NULL); + if (ret != BADGE_ERROR_NONE) + goto out; + + if (sqlbuf) { + sqlite3_free(sqlbuf); + sqlbuf = NULL; + } + + sqlbuf = sqlite3_mprintf("DELETE FROM %Q WHERE pkgname not in " + "(SELECT pkgname FROM %Q) AND uid = %d", + BADGE_OPTION_TABLE_NAME, BADGE_SETTING_DB_TABLE, + uid); + if (sqlbuf == NULL) { + /* LCOV_EXCL_START */ + ERR("Failed to alloc query"); + ret = BADGE_ERROR_OUT_OF_MEMORY; + goto out; + /* LCOV_EXCL_STOP */ + } + + ret = badge_db_exec(db, sqlbuf, NULL); + +out: + if (sqlbuf) + sqlite3_free(sqlbuf); + + if (db) { + sqlret = db_util_close(db); + if (sqlret != SQLITE_OK) + WARN("Failed to db_util_close [%d]", sqlret); + } + + return ret; +} |