def add_user():
#verifying the role, than adding new user
role = request.form['role']
newuser=users(request.form['username'], request.form['password'], request.form['role'], request.form['projectname'])
db.session.add(newuser)
db.session.flush()
db.session.commit()
userid = str(newuser.user_id)
#adding within this userid all the rooms to the rooms table
conn = psycopg2.connect(
database="vr",
user="******",
host="localhost",
port="5432"
)
cur = conn.cursor()
if role == '2' :
#extracting the floors & rooms from the csv and instert to table
with open('Duplex_A_20110907_rooms_modified.csv', 'r') as f:
reader = csv.reader(f, delimiter=';')
for row in reader:
#print(row[1],row[2])
cur.execute(
" INSERT INTO rooms (userid, floor, room, roomguid) VALUES (%s, %s, %s, %s)",
(userid ,row[1],row[2],row[4])
)
conn.commit()
return redirect('/admin')
else:
return redirect('/admin')
def _admin_users():
if not access.accessible(access.ROLE_ADMINISTRATOR):
return access.redirect()
filters = {}
number_filter = request.args.get("number-filter", 0)
username_filter = request.args.get("username-filter", 0)
email_filter = request.args.get("email-filter", 0)
permissions_filter = request.args.get("permissions-filter", 0)
if number_filter:
filters["number"] = number_filter
if username_filter:
filters["username"] = username_filter
if email_filter:
filters["email"] = email_filter
if permissions_filter:
filters["permissions"] = permissions_filter
sort = {}
sort_type = request.args.get("sort-type", 0)
sort_order = request.args.get("sort-order", 0)
if sort_type:
sort["type"] = sort_type
if sort_order:
sort["order"] = sort_order
users = database.strip_passwords(database.users(filters, sort))
return jsonify(result=users)
def POST(self):
you = require_you()
params = web.input(name='')
unique = True
name = params['name']
if name and name != you.get('name',None):
slug = slugify(name)
for row in dbview.users(db, startkey=slug, endkey=slug):
if slug == row.key:
unique = False
break
if unique:
you['name'] = name
you['slug'] = slug
elif not name and 'name' in you:
# blanking your name makes you anonymous, and makes your page inaccessible
del you['name']
del you['slug']
db[you.id] = you
if unique:
web.redirect('/')
else:
return render('settings', errors="Sorry, that name's taken!", you=you)
def add_user():
#Nutzer mit Namen,pw,Rolle,Projekt anlegen
role = request.form['role']
newuser = users(request.form['username'], request.form['password'],
request.form['role'], request.form['projectname'])
db.session.add(newuser)
db.session.flush()
db.session.commit()
userid = str(newuser.id)
conn = psycopg2.connect(database="project1",
user="******",
host="localhost",
port="5432")
cur = conn.cursor()
if role == '2':
#extracting the floors & rooms from the csv and instert to table
with open('Duplex_A_20110907_rooms.csv', 'r') as f:
reader = csv.reader(f, delimiter=';')
for row in reader:
#print(row[1],row[2])
cur.execute(
" INSERT INTO rooms (userid, floor, room) VALUES (%s, %s, %s)",
(userid, row[1], row[2]))
conn.commit()
return redirect('/admin')
else:
return redirect('/admin')
def get_you():
openid = web.openid.status()
if openid:
key = "user-%s" % openid
if key in db:
return db[key]
else:
from random_name import random_name
from time import time
while True:
unique = True
name = random_name("%s-%d" % (openid,time()))
slug = slugify(name)
for row in dbview.users(db, startkey=slug, endkey=slug):
if slug == row.key:
unique = False
break
if unique:
break
you = {'type':'user', 'openids':[openid], "name":name, "slug":slug}
db[key] = you
return you
def admin_users():
if not access.accessible(access.ROLE_ADMINISTRATOR):
return access.redirect()
print "Users:"
print database.users()
return render_template("admin/users.html", users=database.users())
