Function sqlite_to_lua

lua/sp.c:6957–7005

}

static int sqlite_to_lua(Lua L, const char *tz, int argc, sqlite3_value **argv)
{
    blob_t b;
    datetime_t d;
    const dttz_t *dt;
    const intv_t *tv;

    for (int i = 0; i < argc; ++i) {
        switch (sqlite3_value_type(argv[i])) {
        case SQLITE_INTEGER:
            luabb_pushinteger(L, sqlite3_value_int64(argv[i]));
            break;
        case SQLITE_FLOAT:
            luabb_pushreal(L, sqlite3_value_double(argv[i]));
            break;
        case SQLITE_BLOB:
            b.data = (void *)sqlite3_value_blob(argv[i]);
            b.length = sqlite3_value_bytes(argv[i]);
            luabb_pushblob(L, &b);
            break;
        case SQLITE_NULL: lua_pushnil(L); break;
        case SQLITE_TEXT:
            luabb_pushcstring(L, (char *)sqlite3_value_text(argv[i]));
            break;
        case SQLITE_DATETIME:
        case SQLITE_DATETIMEUS:
            dt = sqlite3_value_datetime(argv[i]);
            dttz_to_datetime_t(dt, tz, &d);
            luabb_pushdatetime(L, &d);
            break;
        case SQLITE_INTERVAL_YM:
            tv = sqlite3_value_interval(argv[i], SQLITE_INTERVAL_YM);
            luabb_pushintervalym(L, tv);
            break;
        case SQLITE_INTERVAL_DS:
        case SQLITE_INTERVAL_DSUS:
            tv = sqlite3_value_interval(argv[i], SQLITE_INTERVAL_DS);
            luabb_pushintervalds(L, tv);
            break;
        case SQLITE_DECIMAL:
            tv = sqlite3_value_interval(argv[i], SQLITE_DECIMAL);
            luabb_pushdecimal(L, &tv->u.dec);
            break;
        default: return -1;
        }
    }

    return 0;
}

static int emit_sqlite_result(struct sqlclntstate *clnt, sqlite3_context *context)
{