# -*- coding: utf-8 -*-
""" access

    setup the connection to the databases.
    Define constants for the different role

"""
# Migration flags
MIGRATE = False
MIGRATE_USER = False

# Roles
ID_ADMIN, ADMIN, DEF_ADMIN = 1, "admin", "administrators, team leader,..."
ID_USER, USER, DEF_USER = 2, "user", "project leader,..."

#.............................................................................
#
# MYSQL database
#

try:
    mysql = DBURIS[request.application]
    db = DAL(mysql, lazy_tables=False, migrate_enabled=MIGRATE, pool_size=10)
except:
    raise HTTP(500, T("Can't access the MySQL database !!!"))

#.............................................................................
#
# virtual database
#

virtdb = DAL(None)