What about a generic sql function for Field? Here is a proof of
concept:
-------------------------
def sql(self, name, data_type, *args):
out = ''
if args:
out = "," + ",".join([str(a) for a in args])
return Expression('%s(%s%s)' % (name, str(self), out), data_type,
self._db)
-------------------------
test = db(db.test.id > 0).select(db.test.number.sql("AVG",'double'))
-------------------------
{{for t in test:}}
{{=str(t._extra['AVG(test.number)'])}}
<br />
{{pass}}
-------------------------
The syntax needs to be cleaned up and integrated better but you get
the idea. What do you think?
On Oct 13, 10:12 pm, mdipierro <[email protected]> wrote:
> On Oct 13, 9:02 pm, "mr.freeze" <[email protected]> wrote:
>
> > This has probably been asked before but why doesn't the Field class
> > have these?:
>
> no
>
> > avg, format, round, mid, len, first, last
>
> > Is it because they are not common to all databases?
>
> yes
>
> probably avg and round should be implemented since they are common.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
