sqlite: allow returning `ArrayBufferView`s from user-defined functions · nodejs/node@3999786

Attempting to write an unsupported data type to SQLite will result in an

exception.

| SQLite | JavaScript |

| --------- | -------------------- |

| `NULL` | {null} |

| `INTEGER` | {number} or {bigint} |

| `REAL` | {number} |

| `TEXT` | {string} |

| `BLOB` | {Uint8Array} |

| SQLite | JavaScript |

| --------- | -------------------------- |

| `NULL` | {null} |

| `INTEGER` | {number} or {bigint} |

| `REAL` | {number} |

| `TEXT` | {string} |

| `BLOB` | {TypedArray} or {DataView} |

## `sqlite.constants`

} else if (result->IsString()) {

Utf8Value val(isolate, result.As<String>());

sqlite3_result_text(ctx, *val, val.length(), SQLITE_TRANSIENT);

} else if (result->IsUint8Array()) {

} else if (result->IsArrayBufferView()) {

ArrayBufferViewContents<uint8_t> buf(result);

sqlite3_result_blob(ctx, buf.data(), buf.length(), SQLITE_TRANSIENT);

} else if (result->IsBigInt()) {

db.function('retString', () => { return 'foo'; });

db.function('retBigInt', () => { return 5n; });

db.function('retUint8Array', () => { return new Uint8Array([1, 2, 3]); });

db.function('retArrayBufferView', () => {

const arrayBuffer = new Uint8Array([1, 2, 3]).buffer;

return new DataView(arrayBuffer);

});

const stmt = db.prepare(`SELECT

retUndefined() AS retUndefined,

retNull() AS retNull,

retNumber() AS retNumber,

retString() AS retString,

retBigInt() AS retBigInt,

retUint8Array() AS retUint8Array

retUint8Array() AS retUint8Array,

retArrayBufferView() AS retArrayBufferView

`);

assert.deepStrictEqual(stmt.get(), {

__proto__: null,

retString: 'foo',

retBigInt: 5,

retUint8Array: new Uint8Array([1, 2, 3]),

retArrayBufferView: new Uint8Array([1, 2, 3]),

});

});