take one value out of fetchone sqlalchemy query result [duplicate]

Question

from a lambda function in AWS I am calling a stored procedure in Snowflake. I run python code and use sqlalchemy and snowflake.sqlalchemy modules to call the snowflake stored proc. the stored procedure queries a table with one row and one column, does a simple calculation and returns a single value. The code looks like this:

result=connection.execute('CALL TEST_GET_PARAMS(8,8);')
sql='select * from CALCRESULT;'
rows = result.fetchone()
print(rows)
print (type(rows))

the return looks like this:

(160.0,)
<class 'sqlalchemy.engine.result.RowProxy'>

However, I want to value to be an int value without the ( ) and ,

I am assuming my problem is in the use of fetchone and then how take the first column out of the result, but I don't know how to do it.

Any suggestions?

score 1 · Accepted Answer · 2020-06-10 07:43:47Z

1

The RowProxy object returned by result.fetchone() permits dictionary-style access of columns within.

For example, if the lone column inside your CALCRESULT table is called COLUMN_NAME then you can use this to retrieve just its value:

>>> […]
>>> row = result.fetchone()

>>> value = row["COLUMN_NAME"]
>>> print(value)
160.0

edited Jun 10, 2020 at 7:43

answered Jun 10, 2020 at 7:38

user13472370

Sign up to request clarification or add additional context in comments.

Comments

Yashraj Jain · Accepted Answer · 2020-06-10 07:35:53Z

0

You can try using fetchmany(size=1) inplace of fetchone().And define the size limit according to your column requirement.

answered Jun 10, 2020 at 7:35

Yashraj Jain

1082 silver badges8 bronze badges

Collectives™ on Stack Overflow

take one value out of fetchone sqlalchemy query result [duplicate]

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related