# -*- coding: utf-8 -*- 
import libvirt

db = DAL('sqlite://storage.sqlite')       # if not, use SQLite or other DB

from gluon.tools import *
from gluon.contrib.login_methods.pam_auth import pam_auth

auth=Auth(globals(),db)                      # authentication/authorization
auth.settings.login_methods = [pam_auth()]
auth.settings.actions_disabled.append('register')
auth.settings.login_email_validate = False

auth.settings.hmac_key='sha512:de938e97-0ea1-476a-8174-01c183d074ae'
auth.define_tables()                         # creates all needed tables

crud=Crud(globals(),db)                      # for CRUD helpers using auth
service=Service(globals())                   # for json, xml, jsonrpc, xmlrpc, amfrpc

#########################################################################
## Define your tables below, 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
#########################################################################

#virturl='qemu+tls://darkwave:16514/system'
virturl='qemu:///system'
connection = cache.ram(virturl, lambda x=virturl: libvirt.open(x), time_expire=10)