Re: dictfetchall(cursor) - What kind of sorcery is this?

Thanks for the link I will study it.

But I still would like some help with printing and visualizing that "desc" data just to make sure it's not Voodoo.  :)

I don't really know how to print that out, MVC is confusing me.  Can you give me a hint which file I need to input my "print desc" LOC?

models.py , views.py or my html template file?

On Wednesday, September 4, 2013 9:55:13 PM UTC+2, Pepsodent Cola wrote:

I borrowed the dictfetchall(cursor) code directly from Djangoproject.com and it works with my code.

But what kind of sorcery is this?  How can I output the contents of desc?  I want to see what that data looks like.

    desc = cursor.description

Because I can't follow what's going on here.

    for col in desc

#_______________________________________________________________________________

https://docs.djangoproject.com/en/1.6/topics/db/sql/#connections-and-cursors

def dictfetchall(cursor):

    "Returns all rows from a cursor as a dict."

    desc = cursor.description

    return [

        dict(zip([col[0] for col in desc], row))

        for row in cursor.fetchall()

    ]

#_______________________________________________________________________________

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)

        """)

        #row = cursor.fetchall()

        row = dictfetchall(cursor)

        return row

#_______________________________________________________________________________

--
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 django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
For more options, visit https://groups.google.com/groups/opt_out.