python sqlalchemy, get only one column problem

Question

Hello I want to get only one query column using only Table.select(), but I am having a problem

guild_id= 807887608943738881
guild = meta_data.tables['guild_'+str(guild_id)] 

a= engine.execute(guild.select([guild.c.age]).where(guild.c.user_id== user_id)).fetchall()
print(a)

This code returns this

sqlalchemy.exc.ArgumentError: SQL expression for WHERE/HAVING role expected, got [Column('age', INTEGER(display_width=11), table=<guild_807887608943738881>)].

What's wrong with the age column?

You are using legacy constructs that may be confusing a more current version of SQLAlchemy. Try with engine.connect() as conn: followed by a = conn.execute(select(guild.c.age).where(guild.c.user_id == user_id)).all() — Gord Thompson
– Gord Thompson, Commented Jul 3, 2022 at 23:40

Yaakov Bressler · Accepted Answer · 2022-07-03 20:37:58Z

1

It appears you are applying an illegal comparison in your where clause, as per this note in the documentation 3rd party integration issue. My first suggestion would be to verify the type in the columns. But since they match (as per your comment), my next thought is to rearrange your query syntax – perhaps your query is attempting to apply a filter on an already instantiated query (which does not allow filtering on additional fields):

# Build your query according to v2.0 selector
q = guild.select(guild.c.age).where(guild.c.user_id== user_id)

# Get your results
res = engine.execute(q).fetchall()

edited Jul 3, 2022 at 20:37

answered Jul 3, 2022 at 14:12

Yaakov Bressler

12.7k5 gold badges66 silver badges96 bronze badges

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

4 Comments

Mr. Nom4ik Over a year ago

no, data types are fine

Yaakov Bressler Over a year ago

I updated my solution @Cergey2202 -- let me know if this solves it for you. If not, I have some other ideas.

Mr. Nom4ik Over a year ago

unfortunately that didn't help either.

Yaakov Bressler Over a year ago

Same error? @Cergey2202

Collectives™ on Stack Overflow

python sqlalchemy, get only one column problem

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related