diff options
Diffstat (limited to 'src/common')
| -rwxr-xr-x | src/common/media-svc-album.c | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/src/common/media-svc-album.c b/src/common/media-svc-album.c index 451d6ff..fd87656 100755 --- a/src/common/media-svc-album.c +++ b/src/common/media-svc-album.c @@ -34,10 +34,10 @@ int _media_svc_get_album_id(sqlite3 *handle, const char *album, const char *arti media_svc_retvm_if(album == NULL, MS_MEDIA_ERR_INVALID_PARAMETER, "album is NULL"); - if (artist != NULL) - sql = sqlite3_mprintf("SELECT album_id FROM %s WHERE name = '%q' AND artist = '%q';", DB_TABLE_ALBUM, album, artist); + if (artist) + sql = sqlite3_mprintf("SELECT album_id FROM %s WHERE name=%Q AND artist=%Q", DB_TABLE_ALBUM, album, artist); else - sql = sqlite3_mprintf("SELECT album_id FROM %s WHERE name = '%q' AND artist IS NULL;", DB_TABLE_ALBUM, album); + sql = sqlite3_mprintf("SELECT album_id FROM %s WHERE name=%Q AND artist IS NULL", DB_TABLE_ALBUM, album); ret = _media_svc_sql_prepare_to_step(handle, sql, &sql_stmt); @@ -61,7 +61,7 @@ int _media_svc_append_album(sqlite3 *handle, bool is_direct, const char *album, { int ret = MS_MEDIA_ERR_NONE; - char *sql = sqlite3_mprintf("INSERT INTO %s (name, artist, album_art) values (%Q, %Q, %Q);", DB_TABLE_ALBUM, album, artist, album_art); + char *sql = sqlite3_mprintf("INSERT INTO %s(name, artist, album_art) VALUES (%Q, %Q, %Q);", DB_TABLE_ALBUM, album, artist, album_art); if (is_direct) ret = _media_svc_sql_query_direct(sql, uid); else |