From 052d350b194e0963271c057a26cc79952b9cf66b Mon Sep 17 00:00:00 2001 From: Max Kellermann Date: Fri, 12 Dec 2014 20:39:36 +0100 Subject: sticker/Database: move SQLite helpers to lib/sqlite/Util.hxx --- src/lib/sqlite/Util.hxx | 80 +++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 80 insertions(+) create mode 100644 src/lib/sqlite/Util.hxx (limited to 'src/lib/sqlite/Util.hxx') diff --git a/src/lib/sqlite/Util.hxx b/src/lib/sqlite/Util.hxx new file mode 100644 index 000000000..539a6653c --- /dev/null +++ b/src/lib/sqlite/Util.hxx @@ -0,0 +1,80 @@ +/* + * Copyright (C) 2003-2014 The Music Player Daemon Project + * http://www.musicpd.org + * + * This program is free software; you can redistribute it and/or modify + * it under the terms of the GNU General Public License as published by + * the Free Software Foundation; either version 2 of the License, or + * (at your option) any later version. + * + * This program is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + * GNU General Public License for more details. + * + * You should have received a copy of the GNU General Public License along + * with this program; if not, write to the Free Software Foundation, Inc., + * 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA. + */ + +#ifndef MPD_SQLITE_UTIL_HXX +#define MPD_SQLITE_UTIL_HXX + +#include "Domain.hxx" +#include "Log.hxx" + +#include + +#include + +static void +LogError(sqlite3 *db, const char *msg) +{ + FormatError(sqlite_domain, "%s: %s", msg, sqlite3_errmsg(db)); +} + +static void +LogError(sqlite3_stmt *stmt, const char *msg) +{ + LogError(sqlite3_db_handle(stmt), msg); +} + +static bool +Bind(sqlite3_stmt *stmt, unsigned i, const char *value) +{ + int result = sqlite3_bind_text(stmt, i, value, -1, nullptr); + if (result != SQLITE_OK) { + LogError(stmt, "sqlite3_bind_text() failed"); + return false; + } + + return true; +} + +template +static bool +BindAll2(gcc_unused sqlite3_stmt *stmt, gcc_unused unsigned i) +{ + assert(int(i - 1) == sqlite3_bind_parameter_count(stmt)); + + return true; +} + +template +static bool +BindAll2(sqlite3_stmt *stmt, unsigned i, const char *value, Args&&... args) +{ + return Bind(stmt, i, value) && + BindAll2(stmt, i + 1, std::forward(args)...); +} + +template +static bool +BindAll(sqlite3_stmt *stmt, Args&&... args) +{ + assert(int(sizeof...(args)) == sqlite3_bind_parameter_count(stmt)); + + return BindAll2(stmt, 1, std::forward(args)...); +} + +#endif -- cgit v1.2.3