# -*- coding: utf-8 -*-

#########################################################################
## This scaffolding model makes your app work on Google App Engine too
## File is released under public domain and you can use without limitations
#########################################################################

## if SSL/HTTPS is properly configured and you want all HTTP requests to
## be redirected to HTTPS, uncomment the line below:
# request.requires_https()

if not request.env.web2py_runtime_gae:
    ## if NOT running on Google App Engine use SQLite or other DB
    db = DAL('sqlite://storage.sqlite',pool_size=1,check_reserved=['all'])
else:
    ## connect to Google BigTable (optional 'google:datastore://namespace')
    db = DAL('google:datastore')
    ## store sessions and tickets there
    session.connect(request, response, db=db)
    ## or store session in Memcache, Redis, etc.
    ## from gluon.contrib.memdb import MEMDB
    ## from google.appengine.api.memcache import Client
    ## session.connect(request, response, db = MEMDB(Client()))

## by default give a view/generic.extension to all actions from localhost
## none otherwise. a pattern can be 'controller/function.extension'
response.generic_patterns = ['*'] if request.is_local else []
## (optional) optimize handling of static files
# response.optimize_css = 'concat,minify,inline'
# response.optimize_js = 'concat,minify,inline'
## (optional) static assets folder versioning
# response.static_version = '0.0.0'
#########################################################################
## Here is sample code if you need for
## - email capabilities
## - authentication (registration, login, logout, ... )
## - authorization (role based authorization)
## - services (xml, csv, json, xmlrpc, jsonrpc, amf, rss)
## - old style crud actions
## (more options discussed in gluon/tools.py)
#########################################################################

from gluon.tools import Auth, Crud, Service, PluginManager, prettydate
auth = Auth(db)
crud, service, plugins = Crud(db), Service(), PluginManager()

## create all tables needed by auth if not custom tables
auth.define_tables(username=False, signature=False)

## configure email
mail = auth.settings.mailer
mail.settings.server = 'logging' or 'smtp.gmail.com:587'
mail.settings.sender = 'you@gmail.com'
mail.settings.login = 'username:password'

## configure auth policy
auth.settings.registration_requires_verification = False
auth.settings.registration_requires_approval = False
auth.settings.reset_password_requires_verification = True

## if you need to use OpenID, Facebook, MySpace, Twitter, Linkedin, etc.
## register with janrain.com, write your domain:api_key in private/janrain.key
from gluon.contrib.login_methods.rpx_account import use_janrain
use_janrain(auth, filename='private/janrain.key')

from gluon.contrib.login_methods.gae_google_account import GaeGoogleAccount
auth.settings.login_form = GaeGoogleAccount()

#########################################################################
## Define your tables below (or better in another model file) for example
##
## >>> db.define_table('mytable',Field('myfield','string'))
##
## Fields can be 'string','text','password','integer','double','boolean'
##       'date','time','datetime','blob','upload', 'reference TABLENAME'
## There is an implicit 'id integer autoincrement' field
## Consult manual for more options, validators, etc.
##
## More API examples for controllers:
##
## >>> db.mytable.insert(myfield='value')
## >>> rows=db(db.mytable.myfield=='value').select(db.mytable.ALL)
## >>> for row in rows: print row.id, row.myfield
#########################################################################

## after defining tables, uncomment below to enable auditing
# auth.enable_record_versioning(db)
import time
import datetime
import logging

db.define_table('tehtava',
  # viitataan viikko-tauluun
  Field('vt', 'reference viikko', required=True),
  # Käytetään radio-buttoneita eikä alasvetovalikkoa
  Field('taso', 'integer', requires=IS_IN_SET([1, 3, 5]), widget=SQLFORM.widgets.radio.widget),
  # Label määrää lomakekentän tekstin
  Field('url', 'string',  length=1024, required=True, label="Toimivan ohjelman osoite"),
  # upload-kenttä ei toimi Google App Enginessa jos käyttää SQLFORMia. Laiska kooderi 
  # ei jaksanut kirjoittaa lomakekoodia käsin
  #  Field('url_zip', 'upload', required=True, label="Lähdekoodi zip-paketissa"),
  Field('url_zip', 'string',  length=1024, required=True,label="Lähdekoodin zip-paketin osoite"),
  Field('kommentti', 'text', required=False),
  # Viitataan autentikoinnissa käytettävään tauluun
  Field('palauttaja', 'reference auth_user', required=True),
  Field('aika', 'integer', required=True, label="Tekemiseen kulunut aika tunteina"),
  # lambda-funktio laskee suoraan 
  Field('palautusaika', 'datetime', required=True, compute=lambda x: datetime.datetime.fromtimestamp(time.time()+3*60*60).strftime('%Y-%m-%d %H:%M:%S') ))

  
db.define_table('viikko',
  Field('viikko', 'integer', required=True, unique=True),
  Field('nimi', 'string', required=True),
  Field('deadline', 'datetime', required=True, unique=True))
   
db.define_table('palaute', 
  Field('tehtava', 'reference tehtava', required=True),
  Field('palaute', 'text', required=False),
  Field('arvosana', 'integer', required=False, requires=IS_IN_SET([0, 1, 2, 3, 4, 5])),
  Field('arvosteluaika', 'datetime', required=True, compute=lambda x: datetime.datetime.fromtimestamp(time.time()+3*60*60).strftime('%Y-%m-%d %H:%M:%S')),
  Field('arvostelija', 'reference auth_user', required=True))

# vaaditaan, että syötettävää tehtävää vastaava viikko on olemassa ja muotoillaan sopiva alasvetovalikko  
db.tehtava.vt.requires = IS_IN_DB(db, db.viikko.id, '%(viikko)s %(nimi)s %(deadline)s')

db.palaute.tehtava.requires = IS_IN_DB(db, db.tehtava.id,'%(taso)s %(url)s')
  
db.tehtava.palauttaja.requires = IS_IN_DB(db, db.auth_user.id,'%(first_name)s %(last_name)s')
db.palaute.arvostelija.requires = IS_IN_DB(db, db.auth_user.id,'%(first_name)s %(last_name)s')
# aika saa olla 1 ja 100 väliltä
db.tehtava.aika.requires = IS_INT_IN_RANGE(1, 100)
db.tehtava.url.requires = IS_URL()
db.tehtava.url_zip.requires = IS_URL()

# falseksi merkittyjä ei näytetä lomakkeella vaan hoidetaan muuten
# joko oletusarvoilla tai käsittelijässä
db.tehtava.vt.writable = db.tehtava.vt.readable = False
db.tehtava.palauttaja.writable = db.tehtava.palauttaja.readable = False
db.palaute.arvostelija.writable = db.palaute.arvostelija.readable = False
db.tehtava.palautusaika.writable = db.tehtava.palautusaika.readable = False
db.palaute.arvosteluaika.writable = db.palaute.arvosteluaika.readable = False
db.palaute.tehtava.writable = db.palaute.tehtava.readable = False