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())