Oh! I should add - when do a len() on the results of query.all() - I Get *1* until I change the display_name
On Fri, Aug 2, 2019 at 2:10 PM Michael P. McDonnell <bzaks1...@gmail.com> wrote: > So when I generate the query with SQL Alchemy (using the ORM) I get the > following: > > SELECT game_leaderboard.game_id, game_leaderboard.person_id, > game_leaderboard.display_name, game_leaderboard.total_tasks, > game_leaderboard.tasks_completed, game_leaderboard.duration > FROM game_leaderboard > WHERE game_leaderboard.game_id = %(game_id_1)s > Data: game_id='5184b7eb-b687-4471-8aa9-7b6715b7a9aa' > > I get the following result: > [ > { > "total_tasks": 2, > "display_name": "Auto Test ", > "tasks_completed": 2, > "person_id": "96736b38-b854-403c-90d8-0701c23efe55", > "duration": "0:08:00", > "game_id": "5184b7eb-b687-4471-8aa9-7b6715b7a9aa" > } > ] > > However when I run this same query (generated) in psql: > odyssey=# SELECT game_leaderboard.game_id, game_leaderboard.person_id, > game_leaderboard.display_name, game_leaderboard.total_tasks, > game_leaderboard.tasks_completed, game_leaderboard.duration > FROM game_leaderboard > WHERE game_leaderboard.game_id = '5184b7eb-b687-4471-8aa9-7b6715b7a9aa'; > game_id | person_id > | display_name | total_tasks | tasks_completed | duration > > --------------------------------------+--------------------------------------+--------------+-------------+-----------------+---------- > 5184b7eb-b687-4471-8aa9-7b6715b7a9aa | > 96736b38-b854-403c-90d8-0701c23efe55 | Auto Test | 2 | > 2 | 00:08:00 > 5184b7eb-b687-4471-8aa9-7b6715b7a9aa | > ac370ba6-0ea8-4068-8cac-0337b6807481 | Auto Test | 2 | > 2 | 00:16:00 > > I have determined however - if I change the "display_name" to something > different between the two people, I suddenly get 2 results from query.all() > > This is doing a query on a VIEW. > > Any ideas on where I can start looking at this? > > -- 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/CAHmCLHpxjezSeMHaOh-aZogTGq5DvvSkx1vzkwxJyEv%3DZo%2BXuw%40mail.gmail.com.