amplifico/models/db.py

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

import time

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

## app configuration made easy. Look inside private/appconfig.ini
from gluon.contrib.appconfig import AppConfig
## once in production, remove reload=True to gain full speed
myconf = AppConfig(reload=True)


if not request.env.web2py_runtime_gae:
	## if NOT running on Google App Engine use SQLite or other DB
	db = DAL(myconf.take('db.uri'), pool_size=myconf.take('db.pool_size', cast=int), check_reserved=['all'])
else:
	## connect to Google BigTable (optional 'google:datastore://namespace')
	db = DAL('google:datastore+ndb')
	## 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 []
## choose a style for forms
response.formstyle = myconf.take('forms.formstyle')  # or 'bootstrap3_stacked' or 'bootstrap2' or other
response.form_label_separator = myconf.take('forms.separator')


## (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, Service, PluginManager

auth = Auth(db)
service = Service()
plugins = PluginManager()

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

## configure email
mail = auth.settings.mailer
mail.settings.server = 'logging' if request.is_local else myconf.take('smtp.server')
mail.settings.sender = myconf.take('smtp.sender')
mail.settings.login = myconf.take('smtp.login')

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

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

## Tabelas para Imagens
db.define_table(
	'imagem',
	Field(
		'arquivo',
		'upload',
		required=True,
		uploadseparate=True,
		notnull=True,
	),
	Field(
		'data_upload',
		default=int(time.strftime('%s', time.localtime())),
		update=int(time.strftime('%s', time.localtime())),
		writable=False,
		readable=False,
		notnull=True,
	),
	Field(
		'autor',
		default='Alguém',
	),
	Field(
		'fonte',
	),
	Field(
		'licenca',
		requires=IS_IN_SET([
			('cr','Todos direitos reservados'),
			('pd','Domínio público'), 
			('cc0','CC Zero'), 
			('cc-by','CC Atribuição'),
			('cc-by-sa','CC Atribuição-CompartilhaIgual'),
			('cc-by-nd','CC Atribuição-SemDerivações'),
			('cc-by-nc','CC Atribuição-NãoComercial'),
			('cc-by-nc-sa','CC Atribuição-NãoComercial-CompartilhaIgual'),
			('cc-by-nc-nd','CC Atribuição-SemDerivações-SemDerivados'),
		]),
	),
	Field(
		'votos',
		'integer',
		default=0,
		writable=False,
		readable=False,
	),
)

db.imagem.arquivo.requires = IS_NOT_EMPTY()
## /Tabelas para Imagens

## Tabelas para Textos
db.define_table(
	'texto',
	Field(
		'conteudo',
		'text',
		required=True,
		notnull=True,
	),
	Field(
		'data_upload',
		default=int(time.strftime('%s', time.localtime())),
		update=int(time.strftime('%s', time.localtime())),
		writable=False,
		readable=False,
		notnull=True,
	),
	Field(
		'autor',
		default='Alguém',
	),
	Field(
		'fonte',
	),
	Field(
		'licenca',
		requires=IS_IN_SET([
			('cr','Todos direitos reservados'),
			('pd','Domínio público'), 
			('cc0','CC Zero'), 
			('cc-by','CC Atribuição'),
			('cc-by-sa','CC Atribuição-CompartilhaIgual'),
			('cc-by-nd','CC Atribuição-SemDerivações'),
			('cc-by-nc','CC Atribuição-NãoComercial'),
			('cc-by-nc-sa','CC Atribuição-NãoComercial-CompartilhaIgual'),
			('cc-by-nc-nd','CC Atribuição-SemDerivações-SemDerivados'),
		]),
	),
	Field(
		'votos',
		'integer',
		default=0,
		writable=False,
		readable=False,
	),
)

db.texto.conteudo.requires = IS_NOT_EMPTY()
## /Tabelas para Textos

## Tabela para Tags
db.define_table(
	'tag',
	Field(
		'tag',
		'string',
		required=True,
		notnull=True,
	),
)

db.tag.tag.requires = IS_NOT_EMPTY()
## /Tabela para Tags

## Tabela para Votos
db.define_table(
	'voto',
	Field(
		'id_user',
		'integer',
	),
	Field(
		'id_item',
		'integer',
	),
)

## /Tabela para Votos

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