On Tue, Mar 10, 2009 at 5:30 PM, timc3 <t...@timc3.com> wrote:
>
> Well I tried that:
>
> def get_perm(self, *args, **kwargs):
> from django.db import connection
> cursor = connection.cursor()
> cursor.execute("""
> SELECT * FROM permfindernew(2, 132);
> """)
> result_list = []
> for row in cursor.fetchall():
> result_list.append(row)
> return result_list
>
> And the result was:
>
> In [1]: m = MediaItem.objects.get_perm()
>
> In [2]: m
> Out[2]:
> [(132,
> u'Tsunami_by_hokusai_19th_century.jpg',
> u'Tsunami_by_hokusai_19th_century.jpg',
> u'',
> u'',
> datetime.datetime(2009, 2, 17, 16, 54, 38, 892350),
> None,
> u'tsunami-by-hokusai-19th-century-jpg',
> u'c4a6afe0a71e3632',
> 3,
> u'[]',
> 5,
> False,
> False,
> False,
> True,
> True,
> 1,
> u'',
> 1,
> None,
> False,
> 1,
> "'19th':4,9 'hokusai':3,8 'tsunami':1,6 'century.jpg':5,10")]
>
> So is that the list that you are talking about?
> >
>
I'm assuming those values corropond tot he fields on the model, any reason
you can't do:
self.model(**cursor.fetchone())
Alex
--
"I disapprove of what you say, but I will defend to the death your right to
say it." --Voltaire
"The people's good is the highest law."--Cicero
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-users@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
-~----------~----~----~----~------~----~------~--~---
