execute_scalar_async
execute_scalar_async
executes the query, and returns the first column of the first row in the result set returned by
the query. The additional columns or rows are ignored.
Parameters🔗
name | type | description | optional | default |
---|---|---|---|---|
sql | str |
the sql query str to execute | ||
param | ParamType |
params to substitute in the query | None |
Example🔗
Get the name of the first task owner in the database.
import asyncio
from pydapper import connect_async
async def main():
async with connect_async() as commands:
owner_name = await commands.execute_scalar_async("select name from owner")
print(owner_name)
# Zach Schumacher
asyncio.run(main())