On Wednesday, February 7, 2018 at 11:09:09 PM UTC-8, Dave S wrote:
>
>
>
> On Wednesday, February 7, 2018 at 2:08:23 PM UTC-8, Leonel Câmara wrote:
>>
>> Hummm you're right, can I see the code for default/sorted and the 
>> quartermaster table?
>>
>
>
> db.define_table('QuarterMaster', 
>                 Field('IssueYr', 'integer',
>                      requires = [IS_NOT_EMPTY(), IS_INT_IN_RANGE(1965,2018
> , "Not a valid year of issue")],
>                      widget = lambda f, v: SQLFORM.widgets.integer.widget(
> f, v, _autofocus=True)),
>                 Field('StateNm', 'string', default=None, represent=lambda 
> StateNm: StateNm or '', requires=IS_EMPTY_OR(IS_IN_SET(us_states))),
>                 Field('Other', 'string', default=None, represent=lambda 
> Other: Other or '', requires=IS_EMPTY_OR(IS_IN_SET(us_other))),
>                 Field('Mint', 'string', requires=IS_MATCH('^[dpx]*$', 
> error_message="not a valid mint string")),
>                 Field('NumAdded', "integer", compute = lambda r: len(r[
> "Mint"])),
>                 Field('PostDate', "date", requires=IS_DATE(format=
> '%Y-%m-%d', error_message='must be YYYY-MM-DD!'))) 
>
> Some sample rows, via appadmin export as csv:

QuarterMaster.id,QuarterMaster.IssueYr,QuarterMaster.StateNm,QuarterMaster.Other,QuarterMaster.Mint,QuarterMaster.NumAdded,QuarterMaster.PostDate
40,2013,<NULL>,Great Basin,d,1,2016-11-25
41,2012,<NULL>,Hawaii Volcanoes,dd,2,2016-11-25
42,2002,LA,<NULL>,d,1,2016-11-25
43,2009,<NULL>,District of Columbia,d,1,2016-11-25
44,2007,WA,<NULL>,d,1,2016-11-25

/dps

-- 
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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to