### PART A
Hello, in Python shell I run a Raw SQL and get a One-to-Many list output.
$ python manage.py shell
Python 2.7.3 (default, Apr 10 2013, 05:13:16)
[GCC 4.7.2] on linux2
Type "help", "copyright", "credits" or "license" for more information.
(InteractiveConsole)
>>>
>>>
>>> from navi_polls.models import Word, Altword
>>> from django.db import connection
>>>
>>> cursor = connection.cursor()
>>>
>>> for row in cursor.execute('SELECT navi_polls_word.rosword,
navi_polls_altword.alt_ros_word, navi_polls_altword.votes FROM
navi_polls_altword INNER JOIN navi_polls_word ON
(navi_polls_altword.rosword_id=navi_polls_word.id)'):
... print row
...
*(u'Paper', u'Leaf', 300)*
*(u'Paper', u'Leafy', 0)*
*(u'Page', u'Leafy 2', 18)*
*(u'Page', u'Leafy 3', 50)*
>>>
____________________________________________________________________________________________
### PART B
I don't really understand how to implement this Raw SQL into my Models file
so that it returns the above same
list when I type this in Python shell:
>>> *Altword.objects.vote_order()*
____________________________________________________________________________________________
### PART C
class AltwordManager(models.Manager):
def vote_order(self):
"Returns a 1:M list ordered by votes."
cursor = connection.cursor()
cursor.execute("""
SELECT navi_polls_word.rosword, navi_polls_altword.alt_ros_word,
navi_polls_altword.votes
FROM navi_polls_altword INNER JOIN navi_polls_word
ON (navi_polls_altword.rosword_id=navi_polls_word.id)
""")
return for row in cursor.fetchall()
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/django-users.
For more options, visit https://groups.google.com/groups/opt_out.
