OK, I'll put together a case later today. On Aug 4, 8:24 am, Michael Bayer <mike...@zzzcomputing.com> wrote: > nothing wrong with the code I see, and I am noticing that to recreate your > test is taking me longer than one minute, so please provide a fully > reproducing test case. > > On Aug 4, 2010, at 11:14 AM, Bryan wrote: > > > Same behavior with 0.6.3. > > > On Aug 3, 4:17 pm, Michael Bayer <mike...@zzzcomputing.com> wrote: > >> On Aug 3, 2010, at 5:00 PM, Bryan wrote: > > >>> Python 2.5.4 > >>> MySQL python 1.2.3c1 > >>> sqlalchemy 0.5.2 > > >> just curious can you try with SQLA 0.6.3 ? > > >>> Here is the actual code. It references my object model etc so it > >>> won't run for you, but just in case I made a mistake converting it to > >>> a simplified version of the problem here it is: > > >>> dollars = func.if_(EmpTime.actTotal != None, EmpTime.actTotal, > >>> EmpTime.estTotal, type_=types.Numeric) > >>> q = orm.query( > >>> Account.code, > >>> func.lower(TimeType.shortName), > >>> func.sum(EmpTime.hours), > >>> func.sum(dollars, type_=types.Numeric) > >>> ) > >>> q = q.join(EmpTime.acc).join(EmpTime.timeType) > >>> q = q.group_by(Account.code).group_by(TimeType.shortName) > >>> q = q.filter(EmpTime.day >= start) > >>> q = q.filter(EmpTime.day <= end) > >>> q = q.filter(EmpTime.jobId == jobId) > >>> labor = q.all() > > >>> On Aug 3, 1:26 pm, Michael Bayer <mike...@zzzcomputing.com> wrote: > >>>> On Aug 3, 2010, at 2:56 PM, Bryan wrote: > > >>>>> This returns a Decimal type for c2, which is what I want: > >>>>> c1 = literal(5, type_=Numeric) > >>>>> c2 = func.sum(c1, type_=Numeric) > > >>>>> This returns a Float type for c2, but I'm telling c1 that it is a > >>>>> Numeric. How can I get a decimal returned when using an if function? > >>>>> c1 = func.if_(Table.foo != None, Table.foo, Table.bar, type_=Numeric) > >>>>> c2 = func.sum(c1, type_=Numeric) > > >>>> I see nothing wrong with that code. Can I get some SQLA version / > >>>> database backend / DBAPI details ? > > >>>>> -- > >>>>> You received this message because you are subscribed to the Google > >>>>> Groups "sqlalchemy" group. > >>>>> To post to this group, send email to sqlalch...@googlegroups.com. > >>>>> To unsubscribe from this group, send email to > >>>>> sqlalchemy+unsubscr...@googlegroups.com. > >>>>> For more options, visit this group > >>>>> athttp://groups.google.com/group/sqlalchemy?hl=en. > > >>> -- > >>> You received this message because you are subscribed to the Google Groups > >>> "sqlalchemy" group. > >>> To post to this group, send email to sqlalch...@googlegroups.com. > >>> To unsubscribe from this group, send email to > >>> sqlalchemy+unsubscr...@googlegroups.com. > >>> For more options, visit this group > >>> athttp://groups.google.com/group/sqlalchemy?hl=en. > > > -- > > You received this message because you are subscribed to the Google Groups > > "sqlalchemy" group. > > To post to this group, send email to sqlalch...@googlegroups.com. > > To unsubscribe from this group, send email to > > sqlalchemy+unsubscr...@googlegroups.com. > > For more options, visit this group > > athttp://groups.google.com/group/sqlalchemy?hl=en.
-- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.