diff --git a/web/database/utils/db-utils.js b/web/database/utils/db-utils.js new file mode 100644 --- /dev/null +++ b/web/database/utils/db-utils.js @@ -0,0 +1,25 @@ +// @flow + +function parseSQLiteQueryResult(result: QueryExecResult): T[] { + const { columns, values } = result; + return values.map(rowResult => { + const row: any = Object.fromEntries( + columns.map((key, index) => [key, rowResult[index]]), + ); + return row; + }); +} + +// NOTE: sql.js has behavior that when there are multiple statements in query +// e.g. "statement1; statement2; statement3;" +// and statement2 will not return anything, the result will be: +// [result1, result3], not [result1, undefined, result3] +function parseSQLiteResult( + rawResult: $ReadOnlyArray, +): T[][] { + return rawResult.map((queryResult: QueryExecResult) => + parseSQLiteQueryResult(queryResult), + ); +} + +export { parseSQLiteResult };