Have you tried making manual formatting, i.e.
val1 = 'col1'
val2 = 'col2'
op = '>'
# Python 2.6+ string formatting
.extra(where=["{0} {1} {2}".format(val1, op, val2)])
On Jul 25, 2:28 am, David <ww...@yahoo.com> wrote:
> anybody likes to give me help? thanks so much.
>
> On Jul 24, 4:23 pm, David <ww...@yahoo.com> wrote:
>
> > I used this syntax
>
> > .extra(where=['%s >= %s - %s'], params=['criteria1_metric1',
> > 'criteria1_metric2', 'criteria1_value'])
>
> > however I got error.
>
> > On Jul 24, 4:16 pm, David <ww...@yahoo.com> wrote:
>
> > > Here comes a new problem. I do not know which columns' values to use;
> > > all I know is that they are represented with variables. These
> > > variables are
>
> > > col_var_1, condition_operator, col_var_2, manipulation_operator,
> > > constant_value
>
> > > where:
> > > col_var_1: col1, or col2, or col3, etc
> > > condition_operator: >, >=, <, =, etc
> > > col_var_2: col1, or col2, etc
> > > manipulation_operator: +, -, x, /
> > > constant_value: float value
>
> > > in the where clause, I have to use these variables. What's the
> > > syntax?
>
> > > any help? thanks so much.
>
> > > On Jul 24, 2:39 pm, David <ww...@yahoo.com> wrote:
>
> > > > Great. I go to pick up extra() to use.
>
> > > > Thanks Tim.
>
> > > > On Jul 24, 2:33 pm, Tim Chase <django.us...@tim.thechases.com> wrote:
>
> > > > > > Such a transformation is fine. I found that my Django has no F().
> > > > > > Checking the Django doc I saw that this new feature is "New in
> > > > > > Django
> > > > > > Development version".
>
> > > > > > So I have to wait for the new version? Are there any other ways to
> > > > > > create such a filter?
> > > > > >> col1_value >= col2_value * 2
>
> > > > > >> something like col1__gte=F('col2') * 2
>
> > > > > You can always fall back to the .extra() method[1]:
>
> > > > > results = MyFoo.objects.extra(where=[
> > > > > "col1_value >= col2_value * 2",
> > > > > ])
>
> > > > > which is how it was done back in the day before ya'll young
> > > > > whippersnappers had such fancy shenanigans as F() objects...and
> > > > > to get data, we walked up hill, in the snow. Both ways. ;-)
>
> > > > > -tim
>
> > > > > [1]http://docs.djangoproject.com/en/dev/ref/models/querysets/#extra-sele...text
> > > > > -
>
> > > > - Show quoted text -- Hide quoted text -
>
> > > - Show quoted text -- Hide quoted text -
>
> > - Show quoted text -
>
>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
