distinguishing json column of RowProxy in SQLAlchemy?

Question

For example, when I execute following code, resulting data type is str:

result = engine.execute('''
  SELECT CAST('{"foo": "bar"}' as JSON) as `json`
''')
row = result.fetchone()
json = row[0]
type(json)

An json column value having type of str is not so much meta-programming friendly.

Question

Is there any way to fetch information from the result (or, an instance of ResultProxy) what each column's type was?

env

MySQL: 8.0.11
SQLAlchemy: 1.3.0
pymysql: 0.9.3

Ilja Everilä · Accepted Answer · 2019-03-13 08:48:23Z

2

You can at least achieve it by explicitly telling SQLAlchemy that the result is JSON:

from sqlalchemy.types import JSON

stmt = text('''SELECT CAST('{"foo": "bar"}' as JSON) as `json`''')
stmt = stmt.columns(json=JSON)

row = engine.execute(stmt).fetchone()
type(row.json)

answered Mar 13, 2019 at 8:48

Ilja Everilä

53.4k9 gold badges138 silver badges142 bronze badges

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

Collectives™ on Stack Overflow

distinguishing json column of RowProxy in SQLAlchemy?

Question

env

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

Question

env

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related