diff options
| author | minje.ahn <minje.ahn@samsung.com> | 2023-02-17 10:48:57 +0900 |
|---|---|---|
| committer | Minje ahn <minje.ahn@samsung.com> | 2023-03-13 07:02:19 +0000 |
| commit | 49f68a087631234e51a1b8134f50e363804f0112 (patch) | |
| tree | f9b85b69df45c89bfa1e2d23a2ac6bd4a6a08eb9 | |
| parent | bbd31d1aee71ff60d55e6f4debc1ec74a43f74f7 (diff) | |
| download | libmedia-service-49f68a087631234e51a1b8134f50e363804f0112.tar.gz libmedia-service-49f68a087631234e51a1b8134f50e363804f0112.tar.bz2 libmedia-service-49f68a087631234e51a1b8134f50e363804f0112.zip | |
Change '%q' to %Qaccepted/tizen/unified/20230316.045746
Change-Id: I20fd9399fa108be39a399c3805deb2d1f2d5e22c
Signed-off-by: minje.ahn <minje.ahn@samsung.com>
| -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 |