Sorry, It was my mistake. We can label that without any issue. *select([testa.c.id.op("&")(15).label("Id")]) *This one will work perfectly.
On Wed, Feb 26, 2020 at 12:35 PM Balukrishnan <baluc...@gmail.com> wrote: > Hi, I need one more help. > By using *select([testa.c.id.op("&")(15)]) *this query i got the result > object but the return value can only accessed by the key '*anon_1'.* > I tried to label (and anon_lalel) this query but most of the times query > fails and the rest the same result(that is label is not getting applied. > I tried these > > - *select([testa.c.id.op.label("Id").("&")(15)]) . => No changes > still the value can only accesses by the key anon_1* > - > *select([testa.c.id.op("&")(15).label("Id")]) . => Error (AttributeError: > Neither 'BinaryExpression' object nor 'Comparator' object has an attribute > 'table') * > - *select([testa.c.id > <http://testa.c.id>.anon_label("Id").op("&")(15)]) . => Error (TypeError: > '_anonymous_label' object is not callable) * > - *select([testa.c.id.op("&")(15).anon_label("Id")]) . **=> Error > (TypeError: '_anonymous_label' object is not callable)* > > How can I label that column with a known name > > On Tuesday, February 25, 2020 at 10:32:22 PM UTC+5:30, Balukrishnan wrote: >> >> Table definition >> >> *from sqlalchemy import * >> testa = Table( >> "testa", >> metadata, >> Column("id", BigInteger, primary_key=True), >> Column("str_var_a", String, nullable=True), >> Colmn("bool_var_a", Boolean, nullable=True), >> ) >> * >> >> and I need to execute a query like. >> >> *select([testa.c.id <http://testa.c.id> & 15])* >> >> But while executing this query getting an error >> >> Traceback (most recent call last): >> File >> "/Users/users_name/Projects/x_men/lib/python3.8/site-packages/sqlalchemy/sql/operators.py", >> line 81, in __and__ >> return self.operate(and_, other) >> File >> "/Users/users_name/Projects/x_men/lib/python3.8/site-packages/sqlalchemy/sql/elements.py", >> line 731, in operate >> return op(self.comparator, *other, **kwargs) >> File >> "/Users/users_name/Projects/x_men/lib/python3.8/site-packages/sqlalchemy/sql/operators.py", >> line 81, in __and__ >> return self.operate(and_, other) >> File "<string>", line 1, in <lambda> >> File >> "/Users/users_name/Projects/x_men/lib/python3.8/site-packages/sqlalchemy/sql/type_api.py", >> line 67, in operate >> return o[0](self.expr, op, *(other + o[1:]), **kwargs) >> File >> "/Users/users_name/Projects/x_men/lib/python3.8/site-packages/sqlalchemy/sql/default_comparator.py", >> line 147, in _conjunction_operate >> return and_(expr, other) >> File >> "/Users/users_name/Projects/x_men/lib/python3.8/site-packages/sqlalchemy/sql/elements.py", >> line 2098, in and_ >> return cls._construct(operators.and_, True_, False_, *clauses) >> File >> "/Users/users_name/Projects/x_men/lib/python3.8/site-packages/sqlalchemy/sql/elements.py", >> line 2028, in _construct >> clauses = [ >> File >> "/Users/users_name/Projects/x_men/lib/python3.8/site-packages/sqlalchemy/sql/elements.py", >> line 2029, in <listcomp> >> _expression_literal_as_text(clause) >> File >> "/Users/users_name/Projects/x_men/lib/python3.8/site-packages/sqlalchemy/sql/elements.py", >> line 4569, in _expression_literal_as_text >> return _literal_as_text(element) >> File >> "/Users/users_name/Projects/x_men/lib/python3.8/site-packages/sqlalchemy/sql/elements.py", >> line 4592, in _literal_as_text >> return _literal_as(element, _no_text_coercion) >> File >> "/Users/users_name/Projects/x_men/lib/python3.8/site-packages/sqlalchemy/sql/elements.py", >> line 4582, in _literal_as >> raise exc.ArgumentError( >> sqlalchemy.exc.ArgumentError: SQL expression object expected, got object of >> type <class 'int'> instead >> >> >> But in Postgres using psql command I can perform the query *SELECT id & >> 15 FROM testa;*. Is there any *support* for this in *sqlalchemy*. >> > -- > SQLAlchemy - > The Python SQL Toolkit and Object Relational Mapper > > http://www.sqlalchemy.org/ > > To post example code, please provide an MCVE: Minimal, Complete, and > Verifiable Example. See http://stackoverflow.com/help/mcve for a full > description. > --- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to sqlalchemy+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/sqlalchemy/7665b7ce-44fc-4a9d-baf6-5175b689e2ab%40googlegroups.com > <https://groups.google.com/d/msgid/sqlalchemy/7665b7ce-44fc-4a9d-baf6-5175b689e2ab%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/sqlalchemy/CAAjPXCMfm1dmvunsaEyPURwHrZ9ZmdG-eQsYdnGeVR8HOOcYkg%40mail.gmail.com.