[Tutor] set the BETWEEN range in the SQL query using the python datetime function

[Norman Khine]

thank you, it was simpler than what i was trying to do, here is the
revised version:

http://pastie.org/2115586

one thing i am getting an error is on like 103, in that if, i change
(http://pastie.org/2115615):

-plt.legend(('Income - GBP', 'Discounts', 'Google AdWords - GBP',
'Commission - %s GBP' % (total_commission)),
+plt.legend(('Income - GBP', 'Discounts', 'Google AdWords - %s GBP',
'Commission - %s GBP' % (total_adwords, total_commission)),
            'upper right', shadow=True)

i get the following traceback:

Traceback (most recent call last):
  File "commission.py", line 119, in <module>
    plt.legend(('Income - GBP', 'Discounts', 'Google AdWords - %s
GBP', 'Commission - %s GBP' % (total_adwords, total_commission)),
TypeError: not all arguments converted during string formatting

what am i missing?

thanks

norman

On Fri, Jun 24, 2011 at 12:18 PM, Peter Otten <__peter__ at web.de> wrote:
> Norman Khine wrote:
>
>> hello, i have this code http://pastie.org/2112997
>>
>> but i am not sure how to make the date range so that i get a list
>> based on the daily totals not the results i am now getting:
>>
>> (2L, Decimal('173.958344'), Decimal('159.966349')) 2011-06-23 00:00:00
>> 2011-06-23 23:59:59
>> (2L, Decimal('173.958344'), Decimal('159.966349')) 2011-06-22 00:00:00
>> 2011-06-23 23:59:59
>
> What should the result look like? Can you give a simplified example with
> input and output data?
>
>> the problem is that i am unsure how best to set the BETWEEN range in
>> the SQL query using the python datetime function.
>
> My guess is that you can move more of the problem from Python into SQL if
> you add a GROUP BY clause.
>
>
> _______________________________________________
> Tutor maillist  -  Tutor at python.org
> To unsubscribe or change subscription options:
> http://mail.python.org/mailman/listinfo/tutor
>



--
˙ʇı ɹoɟ ƃuıʎɐd ǝɹ,noʎ ʍou puɐ ǝɔıoɥɔ ɐ ʞooʇ ı ʇɐɥʇ sı 'ʇlnɔıɟɟıp sı ʇɐɥʍ
˙uʍop ǝpısdn p,uɹnʇ pןɹoʍ ǝɥʇ ǝǝs noʎ 'ʇuǝɯɐן sǝɯıʇ ǝɥʇ puɐ 'ʇuǝʇuoɔ
ǝq s,ʇǝן ʇǝʎ
%>>> "".join( [ {'*':'@','^':'.'}.get(c,None) or
chr(97+(ord(c)-83)%26) for c in ",adym,*)&uzq^zqf" ] )