sqltrack.queries module

sqltrack.queries.first_row(client: Client, query: str | SQL, parameters=())

Execute a query and return the first matching row, if any.

Parameters:

• cursor – Cursor to use

• query – Query to execute

• parameters – Optional parameters

sqltrack.queries.first_value(client: Client, query: str | SQL, parameters=())

Execute a query and return the first value of the first matching row, if any.

Parameters:

• cursor – Cursor to use

• query – Query to execute

• parameters – Optional parameters

sqltrack.queries.first_values(client: Client, query: str | SQL, parameters=())

Execute a query and return the first value of each matching row.

Parameters:

• cursor – Cursor to use

• query – Query to execute

• parameters – Optional parameters