execute_scalar
execute_scalar 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.
from pydapper import connect
with connect() as commands:
owner_name = commands.execute_scalar("select name from owner")
print(owner_name)
# Zach Schumacher