Found it. It was an "open circuit" between the keyboard and chair, as
usual.
The lambda computes the year of the swim meet, offset by 122 days (because
their seasons begin on Sept 1 instead of Jan 1). However in my haste I
typed "date" as the last method called, not "year". Oops.
Datetime.year returns the value of the year. But datetime.date returns a
function, not a value, hence my "compute" field got NOTHING. My problem is
now solved, and I have the pleasure of marking my own description as the
"best" one! Hooray for me!
-- Joe B.
On Monday, March 24, 2014 1:20:59 PM UTC-7, Joe Barnhart wrote:
>
> I'm trying to auto-populate a field when a table entry is created. Of
> course, web2py has a feature, the "compute=" clause, just for this purpose!
> But... in my case at least, the feature is not working.
>
> OK -- full disclosure of the only weird thing going on in my design... I
> have pushed all table definitions into module files instead of loading them
> from the model directory. It saves a lot of time as I have large tables,
> and a bunch of them. So here is my table:
>
> @classmethod
> def createTable(cls,db):
> import datetime as dt
> db.define_table("meet",
> Field("id_club", "reference club", label="Host club"),
> Field("id_venue", "reference venue", label="Venue",
> ondelete="SET NULL"),
> Field("id_lsc", "reference lsc", label="Swimming association",
> ondelete="SET NULL"),
> Field("title", "string", label="Additional Name",comment="ex:
> Spooktacular Halloween meet"),
> Field("name", "string",comment="ex: WA Zone 3 C/B/BB+"),
> Field("sanction", "string", label="Sanction Number"),
> Field("info", "text",label="Information",comment="To be shown
> on meet homepage"),
> Field("start_date", "date", label="Starting
> date",comment="First day of meet"),
>
> ... blah, blah, blah... lots of fields here...
>
> Field("season", compute=lambda r: ((r['start_date'] or
> dt.datetime.now())+dt.timedelta(122)).date),
> current.auth.signature,
> format="%(name)s",
> migrate=current.settings.migrate)
>
>
>
> The table works perfectly except the compute field of "season" is never
> populated. I know for a fact the lambda is run, because when I had
> "datetime" imported into the wrong scope I got a walkback when this line
> was executed. But for some reason, the result of this calculation is never
> entered into the database when the row is created.
>
> Any ideas??
>
> -- Joe B.
>
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
