Function sqlSelectInt

sqlite_wrap.c:219–232

Wrapper for sqlGenericQuery() to do a SELECT and return directly * the integer of the first row, or zero on error. */

/* Wrapper for sqlGenericQuery() to do a SELECT and return directly
 * the integer of the first row, or zero on error. */
int64_t sqlSelectInt(sqlite3 *dbhandle, const char *sql, ...) {
    sqlRow row;
    int64_t i = 0;
    va_list ap;
    va_start(ap,sql);
    int rc = sqlGenericQuery(dbhandle,&row,sql,ap);
    if (rc == SQLITE_ROW) {
        sqlNextRow(&row);
        i = row.col[0].i;
        sqlEnd(&row);
    }
    va_end(ap);
    return i;
}

/* ==========================================================================
 * Key value store abstraction. This implements a trivial KV store on top