Example #1
0
db = DAL('sqlite://storage.db')

from gluon.tools import Auth
auth = Auth(db)
auth.settings.table_user_name = 'auth_user'
auth.settings.extra_fields['auth_user'] = [
    Field('Address', 'string', notnull=True),
    Field('city', 'string', notnull=True),
    Field('phone')
]

auth.define_tables(username=True)
auth.verify_Email = True

db.define_table('Main',
                Field('User', 'string', requires=[IS_ALPHANUMERIC()]),
                Field('Rest', 'string', requires=[IS_ALPHANUMERIC()]),
                Field('Cuisine', 'string', requires=IS_NOT_EMPTY()),
                Field('Rating', 'integer', requires=IS_NOT_EMPTY()),
                Field('City', 'string', requires=IS_NOT_EMPTY()),
                Field('Logo', 'upload'),
                format='%(Rest)s')

db.define_table('TheOrder', Field('Rest', 'string', requires=IS_NOT_EMPTY()),
                Field('Foodit', 'string', requires=IS_NOT_EMPTY()),
                Field('Price', 'integer', requires=IS_NOT_EMPTY()))

db.define_table(
    'Menu',
    Field('Menu_id', 'reference Main'),
    Field('Rest', 'string'),