SQLalechemy query returns object instead of value

Question

I want to get all the values from the row for a query, however when I run the below code it returns an object instead of the values:

Session = sessionmaker()
Session.configure(bind=engine)  #
session = Session()

class Player(Base):
    __tablename__ = 'player_alc'
    id = Column(Integer, Sequence('user_id_seq'), primary_key=True)
    name = Column(String(50))
    country= Column(String(50))
    first_name = Column(String(50))
    last_name= Column(String(50))


class Player_Mapping(Base):
    __tablename__ = 'player_external_id_mapping_alc'
    external_id = Column(String(50), nullable=False, primary_key=True)
    external_source_name = Column(String(50), nullable=False, primary_key=True)
    id = Column(Integer, ForeignKey('player_alc.id'))
    Player = relationship("Player", back_populates="player_mapping")

Player.player_mapping = relationship(
"Player_Mapping",  back_populates="Player")


query= session.query(Player_Mapping).filter_by(external_id=external_id, external_source_name=external_source_name).one()

Above code returns the following value for the query:

ORM_classes.Player_Mapping object at 0x0000016119E24D30>

Ilja Everilä · Accepted Answer · 2019-04-02 14:41:47Z

2

You are asking for the object, right here:

session.query(Player_Mapping)

You can access all the fields through the returned object though, for example query.Player or query.external_source_name.

If you want to explicitly get the columns rather than an object, you can use:

session.query(Player_Mapping.Player, Player_Mapping.external_source_name)

edited Apr 2, 2019 at 14:41

Ilja Everilä

53.4k9 gold badges138 silver badges142 bronze badges

answered Apr 2, 2019 at 12:31

Mahi

22.5k23 gold badges91 silver badges130 bronze badges

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

Collectives™ on Stack Overflow

SQLalechemy query returns object instead of value

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related