pypipython-3.x95% confidence\u2191 63

ObjectNotExecutableError when executing any SQL query using AsyncEngine

Full error message

I'm using async_engine. When I try to execute anything:

async with self.async_engine.connect() as con:
    query = "SELECT id, name FROM item LIMIT 50;"
    result = await con.execute(f"{query}")

I'm getting:

Exception has occurred: ObjectNotExecutableError
Not an executable object: 'SELECT id, name FROM item LIMIT 50;'

This question was asked before by user @stilmaniac but it is now deleted from SO.

I found it in Google Search cache, here is copy.

I have the same issue so I'm reasking it, but the original version is below:

I'm trying to create tables from metadata as follows:

Base = declarative_base()

properties = Table(
    'properties', Base.metadata,
    # ...
    Column('geolocation', Geography(geometry_type='POINT', srid=4326)),
    # ... 
)

engine = create_async_engine("postgresql+asyncpg://user:password@postgres/")
async with engine.begin() as conn:
    await conn.run_sync(Base.metadata.create_all)

Gives me the following error:

sqlalchemy.exc.ObjectNotExecutableError: Not an executable object: 'CREATE INDEX "idx_properties_geolocation" ON "properties" USING GIST ("geolocation")'

Considering this doc

Versions:

OS: macOS 11.4 ARM
SQLAlchemy: 1.4.22
Python: 3.6

Solutionsource: stackoverflow \u2197

As the exception message suggests, the str 'SELECT id, name FROM item LIMIT 50;' is not an executable object. To make it executable, wrap it with sqlalchemy.text. from sqlalchemy import text async with self.async_engine.connect() as con: query = "SELECT id, name FROM item LIMIT 50;" result = await con.execute(text(query)) async.connection.execute requires that its statement argument [...] is always an object that is in both the ClauseElement and Executable hierarchies, including: Select Insert, Update, Delete TextClause and TextualSelect DDL and objects which inherit from DDLElement The synchronous connection.execute method permits raw strings, but this is deprecated in v1.4 and has been removed in SQLAlchemy 2.0.

API access

Get this solution programmatically \u2014 free, no authentication.

curl https://depscope.dev/api/error/f7e53d02b9328d6138c8813e1b4fd5b1d84f74f8d4c85331501f66c9784de4fe

hash \u00b7 f7e53d02b9328d6138c8813e1b4fd5b1d84f74f8d4c85331501f66c9784de4fe