Hello,

I have a stored procedure which creates a cursor for a query, and also 
returns the total count for the (unlimited) query. The query itself can be 
mapped to my model if ran through the raw method of the manager. However, 
I'm interested in using the procedure, rather than 2 separate queries for 
the count and the instances.

The documentation indicates that I should use the connection.cursor method 
for invoking custom sql. My initial plan is to first execute the procedure, 
which would return the count and open the query cursor, and then execute a 
'fetch all' for that cursor (I doubt 'fetch next' would be better, since the 
result is stuffed into the django cursor anyway, but I could be wrong here). 
But after I fetch from the query cursor, how do I initialize my model 
objects with the data from that cursor?

-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To post to this group, send email to django-us...@googlegroups.com.
To unsubscribe from this group, send email to 
django-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/django-users?hl=en.

Reply via email to