While we are talking about this topic.
Is it appropriate to be able to put calculated fields into the model.
ie
SQLFIELD('totalprice',eval('quantity * price'))
or something.
This way we can simply call these calculated fields in our views or selects.
I realise the selects would be harder as these objects would need to be
grafted on after the database portion.
But using this sort of syntax we could develop very rich comprehenive
database models that utilise the database store and then the fast calc
abilities of python to provide an easy interface to keeping complex fields
in one place.
The other usage could be a derived calc field.
is
SQLFIELD('quarter',eval('Qtr' + sjsDate_to_quarter(created_at)))
So this field could call a function called sjsDate_to_quarter() and return a
string like ie '"Qtr1 '09" or "Qtr4 '08" etc depending on the created_at
date.
This is getting into the realms of the old data dictionaries that I used to
use in the early ninties. However they were very good for creating the DATA
MODEL not just the storage model that SQLDB does at the moment.
PS. These
On Fri, May 15, 2009 at 2:29 PM, mdipierro <mdipie...@cs.depaul.edu> wrote:
>
> Notice that by default that field has id "album_thumbnail"
>
> so you can do form the view
>
> <script>
> $(document).ready(function(){$('#album_thumbnail').class('multi');});
> </script>
>
>
> On May 14, 7:59 pm, Tito Garrido <titogarr...@gmail.com> wrote:
> > Is there a way to set attributes of a field on model?
> >
> > Like:
> > db.define_table('album',
> > SQLField('name',"string",length=50,default=""),
> > SQLField("thumbnail","upload",default="",autodelete=True,*
> > attr=dict(class='multi')*), <-----
> > SQLField("description","text",default=""),
> > SQLField("date","date",),
> > SQLField("ativo","boolean")
> >
> > anything like that?
> >
> > Thanks!
> >
> > Tito
> >
> > --
> > Linux User #387870
> > .........____
> > .... _/_õ|__|
> > ..º[ .-.___.-._| . . . .
> > .__( o)__( o).:_______
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
