This issue is no longer occurring, so I take back the question for now :)
On Monday, December 7, 2020 at 12:31:09 AM UTC+8 RexE wrote:
> Hello, thank you for the reply. All those lists are the output of:
>
> session.query(Player).all()
>
> For example, here is my code:
>
> player_list = db.query(Player).all()
> ids_only = [p.id for p in player_list]
>
> print('player_list', player_list)
> print('ids_only', ids_only)
>
> Here is the output:
>
> player_list [<Player 1>, <Player 2>, <Player 2>, <Player 1>, <Player
> 2>, <Player 2>]
> ids_only [1, 2, 3, 4, 5, 6]
>
> What I would expect is:
> player_list [<Player 1>, <Player 2>, <Player 3>, <Player 4>, <Player
> 5>, <Player 6>]
>
> Since my __repr__ method just outputs the id, as in my previous post.
>
> Thank you and let me know if I can provide further info.
>
> On Monday, December 7, 2020 at 12:09:28 AM UTC+8 Mike Bayer wrote:
>
>> hey there -
>>
>> it seems pretty likely that the source of objects you are using, which
>> would be the "query" you refer towards, or some process afterwards by which
>> these objects are assembled into the list you are printing, contains the
>> same object instance multiple times, hence you see the same IDs indicated
>> multiple times.
>>
>> The reality of your situation might be much different than this, however
>> the information provided is extremely scant which prevents me from having
>> any better answer.
>>
>>
>>
>> On Sun, Dec 6, 2020, at 9:26 AM, RexE wrote:
>>
>> Hello, I have this base model:
>>
>> class AnyModel(DeclarativeBase):
>> __abstract__ = True
>>
>> id = Column(st.Integer, primary_key=True)
>>
>> def __repr__(self):
>> return '<{} id={}>'.format(self.__class__.__name__, self.id)
>>
>> repr() seems to be printing the incorrect value for my IDs. For example,
>>
>> [<Player 3>, <Player 1>, <Player 2>, <Player 1>]
>> [<Player 3>, <Player 1>, <Player 3>, <Player 4>]
>> etc...
>>
>> The output is seemingly random.
>>
>> Even though I have hundreds of objects in the DB, it always prints out a
>> number that is less than than the number of objects created per commit, and
>> there are duplicates and missing numbers when I query:
>>
>> [<Participant id=2>, <Participant id=1>, <Participant id=3>, <Participant
>> id=2>, <Participant id=3>, <Participant id=5>, <Participant id=8>,
>> <Participant id=3>, <Participant id=8>, <Participant id=3>]
>> if I define the __repr__ on the child class it gives the correct output.
>> even though calling the super() method gives a different result:
>>
>> def __repr__(self):
>> print('in child class dt is correct:', self.id)
>> print('but in base class it is', super().__repr__())
>> return '<{} id={}>'.format(self.__class__.__name__, self.id)
>>
>> But if I rename the method __repr2__ this same issue does not occur :?
>>
>> If I dump the sqlite database, the data all looks fine and consistent.
>> IDs are numbered sequentially 1-100 with no duplicates or gaps.
>>
>> Any ideas? I tried to create a MWE but for some reason this problem only
>> happens in my full-scale app.
>>
>> Thank you!
>>
>>
>> --
>> 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 [email protected].
>> To view this discussion on the web visit
>> https://groups.google.com/d/msgid/sqlalchemy/065d40f8-a146-4766-9ae2-08d406a44b9fn%40googlegroups.com
>>
>> <https://groups.google.com/d/msgid/sqlalchemy/065d40f8-a146-4766-9ae2-08d406a44b9fn%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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/sqlalchemy/3808e202-e5a3-4fa2-a7c8-aff245807c8fn%40googlegroups.com.
