I think it is just my vision problems, but I can't find where you are
calling the method 'ptot' in your view.
to debug, I would add this in my view (after instantiating with your line:
player = Player.objects.filter(p_uffl__icontains=q):
.
my_total=player.ptot # -- if I was debugging in an IDE, I would put a
breakpoint here and step over and then check the value ##
.
.
return render_to_response('search_results.html',
{'player': player, 'query':q, 'my_total':my_total})
and in your template, just for debug add:
<br> Here is my total: {{my_total}}<br>
On Tue, Sep 8, 2009 at 11:29 AM, Slammer <walter.kirkw...@gmail.com> wrote:
>
> FYI, I'm a beginner, I'm having trouble with custom methods, I'm
> using an existing database which is used for a fantasy football
> site, the primary data return is a list of players for a particular
> team, I've done that fine, but the score for those players is in a
> different table, So to return the list of players with their current
> scores I tried to create a custom method as such in my models.py
>
> class Player(models.Model):
> p_keyid = models.IntegerField(primary_key=True)
> p_lname = models.CharField(max_length=135)
> #bla bla bla more fieldnames
> ...
>
>
> def ptot(self):
> from django.db import connection
> cursor = connection.cursor()
> cursor.execute("""
> SELECT sum(s_total) s_total from score where s_pno =
> %s""", [self.p_keyid])
> #return [row[0] for row in cursor.fetchone()]
> #return [self.__class__(*row) for row in cursor.fetchone()]
> return u'S=%s' % (self.__class(*row).s_total)
>
> As you can see I've tried a bunch of ways to return the related score
> total, none have worked.
>
> in my views.py I have
> def search_roster(request):
> if 'q' in request.GET and request.GET['q']:
> q = request.GET['q']
> player = Player.objects.filter(p_uffl__icontains=q)
> return render_to_response('search_results.html',
> {'player': player, 'query':q})
> else:
> return render_to_response('search_form.html',
> {'error': True})
>
> in my search_results.html I have
> <p>Team Listing for: <strong>{{ query }}</strong></p>
> {% if player %}
> <p>Found {{ player|length }} player{{ player|pluralize }}.</p>
> <ul>
> <table border=1>
> <tr><td>Pos</td><td>Name</td>
> <td>NFL</td><td>Value</td>
> <td>Score</td></tr>
> {% for player in player %}
> <tr><td>{{ player.p_pos }}</td><td>{{ player.p_lname }}</td>
> <td>{{ player.p_nfl }}</td><td>{{ player.p_val }}</td><td>
> {{ player.ptot }}</td></tr>
> {% endfor %}
> </table>
> </ul>
> {% else %}
> <p>No players matched your search criteria.</p>
> {% endif %}
>
> My questions are this, when I just want a single field return for a
> custom method how do you form the return statement, in my case I'm
> wanting what ever I alias the sum of s_total. After which how does
> that value get successfully called from the html template. All of it
> works but I never get a return value
>
> or is there an easier way to do this? thanks in advance
>
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
