Debug using JS console possible?

[Robert-M-Muench]

I want to query the current DuckDB (connection) from the JS console for debugging, but I can't determine how to get the result from the promise. Does anyone have a tip on how to do that?

→ (async() → {const t = await vg. coordinator () exec("show result_table"); console. log(t.toString()) ;})();
* › Promise {[[PromiseState]l: "pending", [[PromiseResult]l: undefined}
→ vg. coordinator (). exec("show result_table"). then(result → console.log(result.toString()))
+ › Promise {[[PromiseState]]: "pending", [[PromiseResult]]: undefined}

[jheer]

If you have access to the Coordinator, you can issue queries through vg.coordinator().exec(...) (for queries that do not return anything!) or vg.coordinator().query(sql, options) for queries that return a table.

Or, if you'd rather bypass the Coordinator's internal query manager (and related caching and consolidation), you can get the current database connector using vg.coordinator().databaseConnector(). You can then query DuckDB directly using connector.query(queryObject). The queryObject argument has the shape { type, sql }, where sql is the SQL query string and type is the return type: one of 'exec' (return nothing), 'arrow' (Apache Arrow table), or 'json' (vanilla JS objects). The query method is async, so you'll have to await the resulting Promise.

[Robert-M-Muench]

Using the query() doesn't help, still just get a promise:

Same for the databaseConnector() approach:

That's precisely my problem. I don't want to promise, but the SQL result is a string.

[jheer]

That's strange. I've had no problem doing this so long as I include await, which should cause you to get the Promise result once complete, not the Promise itself. Maybe double check what you're getting after each chained call? Or if all else fails, await the result of the first await and see what you're getting?

Also: note that if you are using the db connector, you can't pass the SQL string directly. As I described above, you need to provide an object of the form { type, sql }, such as databaseConnector.query({ type: 'json', sql: 'SELECT * ...' }).