Python get_db Examples

Example #1

File: select_student.py Project: Chicago18/team-12

def show_student_selection(username):
    """Displayroute."""
    cma_db = model.get_db()
    children = get_children(cma_db, username)

    if flask.request.method == 'POST':
        firstname = flask.request.form.get('firstname', False)
        lastname = flask.request.form.get('lastname', False)
        username = flask.request.form.get('username', False)
        password = flask.request.form.get('password', False)

        cma_db = model.get_db()
        add_account(cursor=cma_db.cursor(),
                    username=username,
                    firstname=firstname,
                    lastname=lastname,
                    password=password,
                    acc_type="p")

        flask.session['username'] = username
        return flask.render_template("student_selection.html",
                                     username=username,
                                     children=children)

    return flask.render_template("student_selection.html",
                                 username=username,
                                 children=children)

Example #2

File: lesson1.py Project: Chicago18/team-12

def show_student_portal_lesson1(username):
    if 'username' not in flask.session:
        return flask.redirect(flask.url_for('show_login_page'))
    cma_db = model.get_db()
    logname = flask.session["username"]

    return flask.render_template("lesson1.html", logname=username)

Example #3

File: parent.py Project: Chicago18/team-12

def show_parent_portal(username, childname):
    if 'username' not in flask.session:
        return flask.redirect(flask.url_for('show_login_page'))
    cma_db = model.get_db()
    logname = flask.session["username"]

    return flask.render_template("parent.html",
                                 logname=username,
                                 child=childname)

Example #4

def show_admin_selection(username):
    if 'username' not in flask.session:
        return flask.redirect(flask.url_for('show_login_page'))

    cma_db = model.get_db()
    logname = flask.session["username"]

    student_firstname = flask.request.form.get('firstname', False)
    student_lastname = flask.request.form.get('lastname', False)

    return flask.render_template("admin_student.html",
                                 logname=username,
                                 firstname=student_firstname,
                                 lastname=student_lastname)

Example #5

File: register.py Project: Chicago18/team-12

def show_register():
    """Display /account/create route."""
    if flask.request.method == 'POST':
        firstname = flask.request.form.get('firstname', False)
        lastname = flask.request.form.get('lastname', False)
        username = flask.request.form.get('username', False)
        password = flask.request.form.get('password', False)

        cma_db = model.get_db()
        add_account(cursor=cma_db.cursor(),
                    username=username,
                    firstname=firstname,
                    lastname=lastname,
                    password=password,
                    acc_type="p")

        flask.session['username'] = username
        return flask.redirect(flask.url_for('show_login'))

    return flask.render_template("register.html")

Example #6

File: student_progress.py Project: Chicago18/team-12

def show_student_progress(username, childname):
    """Display /account/create route."""
    if flask.request.method == 'POST':
        firstname = flask.request.form.get('firstname', False)
        lastname = flask.request.form.get('lastname', False)
        username = flask.request.form.get('username', False)
        password = flask.request.form.get('password', False)

        cma_db = model.get_db()
        add_account(cursor=cma_db.cursor(),
                    username=username,
                    firstname=firstname,
                    lastname=lastname,
                    password=password,
                    acc_type="p")

        flask.session['username'] = username
        return flask.render_template(("parent.html"),
                                     logname=username,
                                     child=firstname)

    return flask.render_template("student_progress.html",
                                 child=childname,
                                 username=username)

Example #7

File: get_parent_info.py Project: Chicago18/team-12

def get_parent_info(username):
    cursor = model.get_db()
    parent_info = cursor.execute('''SELECT * FROM parent WEHRE username=?''',
                                 (username, )).fetchall()