#########################################################################
## This scaffolding model makes your app work on Google App Engine too
#########################################################################

from gluon.settings import settings

# if running on Google App Engine
if settings.web2py_runtime_gae:
    from gluon.contrib.gql import *
    # connect to Google BigTable
    db = DAL('gae')
    # and store sessions there
    session.connect(request, response, db=db)
else:
    # if not, use SQLite or other DB
    db = DAL('sqlite://storage.sqlite')

db.define_table(
    'users',
    Field('name'),
    Field('email')
    )

# ONE (users) TO MANY (dogs)

db.define_table(
    'dogs',
    Field('owner_id', db.users),
    Field('name'),
    Field('type'),
    Field('vaccinated', 'boolean', default=False),
    Field('picture', 'upload', default=''),
    )

db.define_table(
    'products',
    Field('name'),
    Field('description', 'text')
    )

# MANY (users) TO MANY (purchases)

db.define_table(
    'purchases',
    Field('buyer_id', db.users),
    Field('product_id', db.products),
    Field('quantity', 'integer')
    )

# if running on Google App Engine
if settings.web2py_runtime_gae:
    # quick hack to skip the join
    purchased = None
else:
    # use a joined view
    purchased = (db.users.id == db.purchases.buyer_id) & (db.products.id
                 == db.purchases.product_id)

db.users.name.requires = IS_NOT_EMPTY()
db.users.email.requires = [IS_EMAIL(), IS_NOT_IN_DB(db, 'users.email')]
db.dogs.owner_id.requires = IS_IN_DB(db, 'users.id', 'users.name')
db.dogs.name.requires = IS_NOT_EMPTY()
db.dogs.type.requires = IS_IN_SET(['small', 'medium', 'large'])
db.purchases.buyer_id.requires = IS_IN_DB(db, 'users.id', 'users.name')
db.purchases.product_id.requires = IS_IN_DB(db, 'products.id',
        'products.name')
db.purchases.quantity.requires = IS_INT_IN_RANGE(0, 10)