@sqlrooms/app-runtime / executeReadonlyQuery

Function: executeReadonlyQuery()

executeReadonlyQuery(__namedParameters): Promise<{ rows: Record<string, unknown>[]; columns: object[]; rowCount: number; truncated: boolean; executionMs?: number; }>

Parameters

Parameter	Type
__namedParameters	{ request: { sql: string; params?: unknown[]; maxRows?: number; }; getState: () => HtmlAppRuntimeSliceState & HtmlAppRuntimeQueryState; timeoutMs: number; maxRows: number; }
__namedParameters.request	{ sql: string; params?: unknown[]; maxRows?: number; }
__namedParameters.request.sql	string
__namedParameters.request.params?	unknown[]
__namedParameters.request.maxRows?	number
__namedParameters.getState	() => HtmlAppRuntimeSliceState & HtmlAppRuntimeQueryState
__namedParameters.timeoutMs	number
__namedParameters.maxRows	number

Returns

Promise<{ rows: Record<string, unknown>[]; columns: object[]; rowCount: number; truncated: boolean; executionMs?: number; }>