Function dbtable_where

lua/sp.c:2622–2655

    return dbstmt;
}
static int dbtable_where(lua_State *lua)
{
    SP sp = getsp(lua);

    int nargs = lua_gettop(lua);
    if (nargs != 2) {
        luabb_error(lua, sp, "wrong number of arguments to 'where'");
        return 2;
    }
    luaL_checkudata(lua, 1, dbtypes.dbtable);

    const dbtable_t *tbl = lua_topointer(lua, 1);
    char n1[MAXTABLELEN], separator[2], n2[MAXTABLELEN];
    query_tbl_name(tbl->table_name, n1, separator, n2);
    const char *condition = lua_tostring(lua, 2);
    strbuf *sql = strbuf_new();
    if (condition && strlen(condition))
        strbuf_appendf(sql, "select * from %s%s\"%s\" where %s", n1, separator,
                       n2, condition);
    else
        strbuf_appendf(sql, "select * from %s%s\"%s\"", n1, separator, n2);
    db_reset(lua);
    sqlite3_stmt *stmt = NULL;
    int rc = lua_prepare_sql(sp, strbuf_buf(sql), &stmt);
    strbuf_free(sql);
    if (rc) {
        lua_pushnil(lua);
        lua_pushinteger(lua, rc); /* Failure return code. */
        return 2;
    }
    new_dbstmt(lua, sp, stmt);
    lua_pushnumber(lua, 0);
    return 2;
}

static inline const char *bad_handle()
{