db = DAL('sqlite://storage.sqlite')
db.define_table(
'interns',
Field('intern_id','id'),
Field('first_name','string',default=""),
Field('last_name','string', default=""),
Field('phone_number', 'string', default=""),
Field('legal_representative', 'string', default=""),
Field('representative_phone_number', 'string', default=""))
db.define_table(
'mentors',
Field('mentor_id','id'),
Field('trading_name','string', default=""),
Field('first_name','string', default=""),
Field('last_name','string', default=""),
Field('phone_number', 'string', default=""),
Field('fax', 'string', default=""),
Field('email', 'string', default=""))
db.define_table(
'internships',
Field('intern_id','reference interns'),
Field('mentor_id','reference mentors'),
Field('course_name','string', default=""),
Field('start_date','date'),
Field('end_date', 'date'))
db.define_table(
'attendances',
Field('intern_id','reference internships', onupdate = 'CASCADE'),
Field('mentor_id','reference internships', onupdate = 'CASCADE'),
Field('attendance_date','date', default=request.now),
Field('clock_in','time'),
Field('clock_out','time' ))
db.interns.first_name.requires = IS_NOT_EMPTY()
db.interns.last_name.requires = IS_NOT_EMPTY()
db.mentors.first_name.requires = IS_NOT_EMPTY()
db.mentors.last_name.requires = IS_NOT_EMPTY()
db.internships.course_name.requires = IS_NOT_EMPTY()
db.mentors.email.requires = [IS_EMAIL(), IS_NOT_IN_DB(db, 'mentors.email')]
My code its like this i want to know how i make a range between the
internships start date and end date like the user just can choose a date
between that not before or after.
--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/web2py/62484bd0-8ed2-4019-8541-3474c16e0d31%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
