From d1c5102c04a4f2745eb808682e575a4f12faa6e1 Mon Sep 17 00:00:00 2001 From: Jon Bergli Heier Date: Sat, 30 Jan 2010 18:34:40 +0100 Subject: Added option to remove missing files from a directory. --- db.c | 20 ++++++++++++++++++++ 1 file changed, 20 insertions(+) (limited to 'db.c') diff --git a/db.c b/db.c index 29ce639..fe8c6a2 100644 --- a/db.c +++ b/db.c @@ -294,6 +294,26 @@ sqlite_uint64 db_get_wallpaper(const char *path) { return 0; } +int db_remove_wallpaper(sqlite_uint64 id) { + sqlite3_stmt *stmt; + int rc; + + rc = sqlite3_prepare_v2(db, "DELETE FROM wallpaper WHERE id = ?", -1, &stmt, NULL); + if(rc != SQLITE_OK) { + return 0; + } + + rc = sqlite3_bind_int64(stmt, 1, id); + if(rc != SQLITE_OK) { + sqlite3_finalize(stmt); + return 0; + } + + rc = sqlite3_step(stmt); + sqlite3_finalize(stmt); + return rc == SQLITE_DONE; +} + int db_get_wallpaper_data(sqlite_uint64 id, struct wallpaper_t *wall) { sqlite3_stmt *stmt; int rc; -- cgit v1.2.3