Beispiel #1
0
def get_member(member_id):
    db = get_db()
    member_cur = db.execute("""SELECT id, name, email, level from members where id = ?""", (member_id,))
    member = member_cur.fetchone()
    return_value = {'id': member['id'], 'name': member['name'], 'email': member['email'],
                    'level': member['level']}

    return jsonify({'member': return_value})
Beispiel #2
0
def edit_member(member_id):
    db = get_db()
    new_member_data = request.get_json()
    name = new_member_data['name']
    email = new_member_data['email']
    level = new_member_data['level']
    db.execute("""UPDATE members SET name = ?, email = ?, level = ? where id = ?""", (name, email, level, member_id))
    db.commit()

    member_curs = db.execute("""SELECT id, name, email, level from members where id = ?""", (member_id,))
    update_member = member_curs.fetchone()

    return jsonify(
        {'member': {'id': update_member['id'], 'name': update_member['name'], 'email': update_member['email'],
                    'level': update_member['level']}})
Beispiel #3
0
def get_members():
    db = get_db()
    members_curs = db.execute("""SELECT id, name, email, level from members""")
    all_members = members_curs.fetchall()
    return_values = []
    for member in all_members:
        member_dict = dict()
        member_dict['id'] = member['id']
        member_dict['name'] = member['name']
        member_dict['email'] = member['email']
        member_dict['level'] = member['level']
        return_values.append(member_dict)


    return jsonify({'members': return_values,})
Beispiel #4
0
def add_member():
    new_member_data = request.get_json()
    name = new_member_data['name']
    email = new_member_data['email']
    level = new_member_data['level']

    db = get_db()
    db.execute("""INSERT INTO members (name, email, level)
                VALUES (?, ?, ?)""", (name, email, level))
    db.commit()

    member_curs = db.execute("""SELECT id, name, email, level from members WHERE name = ?""", (name,))
    new_member = member_curs.fetchone()

    return jsonify({'member': {'id': new_member['id'], 'name': new_member['name'], 'email': new_member['email'],
                               'level': new_member['level']}})
Beispiel #5
0
def delete_member(member_id):
    db = get_db()
    db.execute("""DELETE FROM members WHERE id = ?""", (member_id,))
    db.commit()

    return jsonify({'message': 'the member has been deleted'})
Beispiel #6
0
def home():
    database_helper.get_db()

    #render_template('static/client.html')
    return render_template('client.html')
Beispiel #7
0
def main():
    db = database_helper.get_db()
    database_helper.init_db()
    return app.send_static_file('client.html')
Beispiel #8
0
def home():
	database_helper.get_db()
Beispiel #9
0
def main():
    db = database_helper.get_db()
    database_helper.init_db()
    #return render_template('static/client.html')
    return app.send_static_file('client.html')
Beispiel #10
0
def home():
	database_helper.get_db()
	return 'This is a front page, looking beautiful'
Beispiel #11
0
def delete_all_tokens():
    c = dh.get_db()
    c.execute("delete from tokens")
    c.commit()
    return json.dumps({"message": "Tokens deleted"})
Beispiel #12
0
def get_all_users():
    c = dh.get_db()
    res = c.execute("select * from users")
    res = res.fetchall()
    return json.dumps({"message": "User List", "data": res})
Beispiel #13
0
def get_tokens():
    c = dh.get_db()
    res = c.execute("select * from tokens")
    res = res.fetchall()
    return json.dumps({"message": "Token List", "data": res})