Mget
Bun

method

sqlite.StatementSync.get

...anonymousParameters: SQLInputValue[]
): undefined | Record<string, SQLOutputValue>;

This method executes a prepared statement and returns the first result as an object. If the prepared statement does not return any results, this method returns undefined. The prepared statement parameters are bound using the values in namedParameters and anonymousParameters.

@param anonymousParameters

Zero or more values to bind to anonymous parameters.

@returns

An object corresponding to the first row returned by executing the prepared statement. The keys and values of the object correspond to the column names and values of the row. If no rows were returned from the database then this method returns undefined.

namedParameters: Record<string, SQLInputValue>,
...anonymousParameters: SQLInputValue[]
): undefined | Record<string, SQLOutputValue>;

This method executes a prepared statement and returns the first result as an object. If the prepared statement does not return any results, this method returns undefined. The prepared statement parameters are bound using the values in namedParameters and anonymousParameters.

@param namedParameters

An optional object used to bind named parameters. The keys of this object are used to configure the mapping.

@param anonymousParameters

Zero or more values to bind to anonymous parameters.

@returns

An object corresponding to the first row returned by executing the prepared statement. The keys and values of the object correspond to the column names and values of the row. If no rows were returned from the database then this method returns undefined.

Referenced types

type SQLInputValue = null | number | bigint | string | NodeJS.ArrayBufferView
type SQLOutputValue = null | number | bigint | string | Uint8Array