Here is some test code. It prints the type of testfield as decimal;
and the type of summary(sumtest) as float.
model:
db.define_table('test',
Field('testfield', 'decimal(8,2)'))
controller:
db.test.insert(testfield=3.2)
db.test.insert(testfield=7.8)
db.commit()
test1=db(db.test.testfield<5).select()[0]
print(test1.testfield, type(test1.testfield))
sumtest=db.test.testfield.sum()
summary=db(db.test.testfield>0).select(sumtest).first()
print(summary(sumtest), type(summary(sumtest)))
On Jun 17, 9:56 pm, Massimo Di Pierro <massimo.dipie...@gmail.com>
wrote:
> unless there is a bug, Field('name','decimal(5,2)') will always treat
> the number as decimal.Decimal at the web2py level. The problem is how
> is it stored in the database. If the database supports decimal is it
> stored accordingly. If the database does not (sqlite) that it is
> converted to float and stored as float.
>
> I am not sure I answered the question. perhaps I misunderstood.
>
> On Jun 17, 12:54 pm, apple <simo...@gmail.com> wrote:
>
>
>
>
>
>
>
> > Yes sqlite.
>
> > The book says "SQLite does not handle the decimal type so internally
> > we treat it as a double". However wouldn't it be logical to convert it
> > back to decimal if that is what my tabledef says?
>
> > On Jun 17, 6:40 pm, Anthony <abasta...@gmail.com> wrote:
>
> > > On Friday, June 17, 2011 1:13:26 PM UTC-4, apple wrote:
>
> > > > I am using the DAL to aggregate SUM a decimal field and the result is
> > > > a float. Shouldn't the DAL keep it in same format as the underlying
> > > > field?
>
> > > Are you using SQLite? As far as I know, it doesn't support decimal fields,
> > > so I think web2py has to treat them as doubles.
> > > Seehttp://web2py.com/book/default/chapter/06#DAL,-Table,-Field.
>
> > > Anthony
