# -*- 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')
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'

#########################################################################
## 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, hmac_key=Auth.get_or_create_key())
crud, service, plugins = Crud(db), Service(), PluginManager()

## create all tables needed by auth if not custom tables
auth.define_tables()

## 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')

#########################################################################
## 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
#########################################################################


##Table for uploading the documents
db.define_table('Document',
   Field('Name', unique=True, label=T("Document Name")),
   Field('File','upload', label=T("File")),
   Field('UserId',db.auth_user, default=auth.user_id, label=T("User ID")),
   #Field('UserIdaa', db.auth_user.id , label=T("User ID")),
   Field('Date','datetime', default=request.now, label=T("Date")),
   format = '%(Name)s')

db.define_table('Document_Annotaion',
   #db.Document.id,
   Field('DocumentId', db.Document, label=T("Document ID")),
   Field('UserId',db.auth_user, default=auth.user_id, label=T("User ID")),
   Field('Date', 'datetime', default=request.now,label=T("Date Annotated")),
   Field('DocType', label=T("Document Type")),
   Field('Comment', 'text', label=T("Comment")))
      # s3mgr.model.add_component(table,
                                 # joinby=dict(Document=
                                               # "Document_id"))

    
   
db.define_table('Phrase',
   Field('DocumentId', db.Document,label=T("Document Id")),
   Field('PhraseContent', 'text',label=T("Phrase Content")),
   Field('DocumentContent', 'text',default=db.Document.File ,label=T("Document Content")),
   Field('UserId',db.auth_user, default=auth.user_id,label=T("User Id")),
   Field('Date','datetime', default=request.now, label=T("Date")),
   format = '%(PhraseContent)s')
   
db.define_table('Phrase_Annotaion',
   Field('PhraseId', db.Phrase, label=T("Phrase Id")),
   #Field('Phrase', db.PhraseContent, label=T("Phrase")),
   Field('Comment', 'text', label=T("Comment")),
   Field('TermId', label=T("Term Id")),
   Field('UserId',db.auth_user, default=auth.user_id, label=T("User Id")),
   Field('Date', 'datetime',default=request.now, label=T("Date")))

db.define_table('user',
   Field('Name'))   

db.define_table('FIBO',
    Field('TermContent', label=T("FIBO Term")),
    Field('Date','datetime',default=request.now, label=T("Date")))

db.Document.Name.requires = IS_NOT_IN_DB(db, db.Document.Name)
db.Document_Annotaion.DocumentId.requires = IS_IN_DB(db, db.Document.id, '%(Name)s')
db.Phrase.DocumentId.requires = IS_IN_DB(db, db.Document.id, '%(Name)s')
db.Phrase_Annotaion.PhraseId.requires = IS_IN_DB(db, db.Phrase.id,'%(PhraseContent)s')
db.Document.UserId.requires = IS_IN_DB(db, db.auth_user.id)
db.Phrase_Annotaion.TermId.requires = IS_IN_DB(db, db.FIBO.TermContent)

#db.Document_Annotation.author.requires = IS_NOT_EMPTY()
#db.Document_Annotation.email.requires = IS_EMAIL()
#db.Document_Annotation.body.requires = IS_NOT_EMPTY()

db.Document_Annotaion.DocumentId.writable = db.Document_Annotaion.DocumentId.readable = False
db.Phrase.DocumentId.writable = False
db.Phrase_Annotaion.PhraseId.writable = False
db.Document.Date.writable = False
db.Document.UserId.writable = False
db.Document_Annotaion.Date.writable = False
db.Document_Annotaion.UserId.writable = False
db.Phrase.Date.writable = False
db.Phrase.UserId.writable = False
db.Phrase_Annotaion.Date.writable = False
db.Phrase_Annotaion.UserId.writable = False
db.FIBO.Date.writable = False