Hello
I'm using an autoloaded table, mapped to a view in Postgre DB.
class MyStats(Entity):
"""Mapping for view"""
using_options(tablename = 'stats_view', autoload = True)
using_mapper_options(primary_key=['date', 'owner'])
When I'm trying to query some rows with "start" and "offset"
statements, I'm running into a strange issue.
I'm doing the following thing:
metadata.bind.echo = True
query = MyStats.query()
qry_res = query[0:50]
In the log displayed correct query with " LIMIT 50 OFFSET 0" statement
in the end. When I'm executing query from log in the pgAdmin - all OK,
I'm having 50 rows fetched.
But in Python qry_res contains 13 rows only.
Is there any possibility to receive more debug information (e.g.
physically fetched rows).
Regards,
Paul
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"SQLElixir" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/sqlelixir?hl=en
-~----------~----~----~----~------~----~------~--~---
