Example #1
0
def awards_home():
    ''' This view page list all awards in awards table.
        This page doesn't allow editing.
    '''
    conn, cur = getDb()
    awards = award.Awards(conn, cur)
    
    # limit, page and order args
    # required for each table page
    limit = int(request.args['limit']) if 'limit' in request.args else 10
    page = int(request.args['page']) if 'page' in request.args else 0
    offset = page*limit
    sortby = request.args['sortby'] if 'sortby' in request.args else 'name'
    order = request.args['order'] if 'order' in request.args else 'asc'
    
    sortby={'attr':'name', 'property':'asc'}   
    
    # check search value
    if 'name' in request.args:
        search_name = request.args['name']
        award_list, total = awards.get_awards_search_by('name', search_name, limit=limit, offset=offset)
    else:
        award_list, total = awards.get_awards(limit=limit, offset=offset)
    return render_template('awards_home.html', awardtable=award.awardtable, 
                        awards=award_list,
			total=total, limit=limit, page=page, sortby=sortby)
def teamrosters_home():
    conn, cur = getDb()
    teamrosters = teamroster.Teamrosters(conn, cur)
    print('TEAMROSTERS PAGE')
    if request.method == 'GET':
        print ('GET REQUEST', request.args)
        limit = int(request.args['limit']) if 'limit' in request.args else 10
        page = int(request.args['page']) if 'page' in request.args else 0
        
        offset = page*limit
        
        

    # check search value
    if 'team_name' in request.args:
        search_name = request.args['team_name']
        teamroster_list,total = teamrosters.get_teamrosters_search_by('name', search_name,  limit, offset)        
        
    else:

        teamroster_list, total = teamrosters.get_teamrosters(limit, offset)
    
    return render_template('teamrosters_home.html', teamrostertable=teamroster.teamrostertable, 
			teamrosters=teamroster_list, 
			total=total, limit=limit, page=page)


    return render_template('leagues_home.html', leaguetable=league.leaguetable, leagues=l, total=total, 
                limit=limit, page=page, sortby=sortby)
def teamroster_page():
    if 'username' not in session:
        return render_template('error.html', err_code=401)
    conn, cur = getDb()
    teamrosters = teamroster.Teamrosters(conn, cur)
    players = player.Players(conn, cur)
    teams = team.Teams(conn, cur)
    print('TEAMROSTERS PAGE')
    if request.method == 'GET':
        print ('GET REQUEST', request.args)
        limit = int(request.args['limit']) if 'limit' in request.args else 10
        page = int(request.args['page']) if 'page' in request.args else 0
        
        offset = page*limit
        print('page:',page,'limit',limit,'offset',offset)
        
 
        teamroster_list, total = teamrosters.get_teamrosters(limit, offset)
        player_list, pp = players.get_players(100,0)
        team_list,tp = teams.get_teams(100,0)
        
        return render_template('teamrosters.html', teamrostertable=teamroster.teamrostertable, 
			teamrosters=teamroster_list, players=player_list, teams=team_list, 
			total=total, limit=limit, page=page)
    elif request.method == 'POST':
        print('ADD TEAMROSTER')
        player_id = request.form['player']
        team_id = request.form['team']
        limit = int(request.form['limit']) if 'limit' in request.form else 10
        page = int(request.form['page']) if 'page' in request.form else 0
        offset = page*limit
        teamroster_obj = teamroster.Teamroster(player_id, team_id)
        teamrosters.add_teamroster(teamroster_obj)
        
        teamroster_list, total= teamrosters.get_teamrosters(limit,offset)
        player_list,pp = players.get_players(100,0)
        team_list,tp = teams.get_teams(100,0)
        
        return render_template('teamrosters.html', teamrostertable=teamroster.teamrostertable, 
			teamrosters=teamroster_list, players=player_list, teams=team_list, 
			total=total, limit=limit, page=page)

    elif request.method == 'DEL':
        print ('DELETE REQUEST:TEAMROSTERS PAGE')
        print (request.form)
        idlist = request.form.getlist('ids[]')
        print ('IDS: ', idlist)
        if idlist == []:
            try:
                idlist = [request.form['id']]
                print ('IDS: ', idlist)
            except:
                return json.dumps({'status':'OK', 'idlist':idlist})

        print ('IDS: ', idlist)
        print(json.dumps({'status':'OK', 'idlist':idlist}))
        for _id in idlist:
            print (_id)
            teamrosters.delete_teamroster(_id)
        return json.dumps({'status':'OK', 'idlist':idlist})
def teamroster_from_id(teamroster_id):
    if 'username' not in session:
        return render_template('error.html', err_code=401)
    conn, cur = getDb()
    teamrosters = teamroster.Teamrosters(conn, cur)
    players=player.Players(conn,cur)
    teams=team.Teams(conn,cur)
    
    if request.method == 'GET':
        l = teamrosters.get_teamroster(teamroster_id)
        if l:
            return json.dumps({'status':'OK', 'teamroster':l.getAttrs()})
        else:
            return json.dumps({'status':'FAILED'})
    elif request.method == 'POST':
        print("POST METHOD REQUEST")
        lid = request.form['id']
        player_id = request.form['player']
        team_id = request.form['team']
        
        limit = int(request.form['limit']) if 'limit' in request.form else 10
        page = int(request.form['page']) if 'page' in request.form else 0
        offset = page*limit
        
        teamroster_obj = teamroster.Teamroster(player_id,team_id)
       
        teamrosters.update_teamroster(lid,teamroster_obj)
        
        teamroster_list, total= teamrosters.get_teamrosters(limit,offset)
        player_list,pp = players.get_players(100,0)
        team_list,tp = teams.get_teams(100,0)
        
        return render_template('teamrosters.html', teamrostertable=teamroster.teamrostertable, 
			teamrosters=teamroster_list, players=player_list, teams=team_list, 
			total=total, limit=limit, page=page)
def search_award_stat(key):
    '''Routing function for search award_stat by its name.

    *GET request* renders the award_stats.html with award_stat comes from the search result.
    '''
    if 'username' not in session:
        return render_template('error.html', err_code=401)

    conn, cur = getDb()
    award_stats = award_stat.AwardStats(conn, cur)
    awards = award.Awards(conn, cur)
    players = player.Players(conn, cur)
    seasons = season.Seasons(conn, cur)

    limit = int(request.args['limit']) if 'limit' in request.args else 10
    page = int(request.args['page']) if 'page' in request.args else 0

    sortby = request.args['sortby'] if 'sortby' in request.args else 'name'
    order = request.args['order'] if 'order' in request.args else 'asc'
    
    offset = page*limit
    
    award_stat_list, total = award_stats.get_award_stats_search_by('name', key, limit, offset)
    award_list, ta = awards.get_awards(limit, offset)
    player_list,tp = players.get_players(100,0) # get list object
    season_list = seasons.get_seasons() # get list object
    sortby={'attr':'name', 'property':'asc'}
    return render_template('award_stats.html', award_stattable=award_stat.award_stattable, 
                    award_stats=award_stat_list, awards=award_list, seasons=season_list, players=player_list, 
                    total=total, limit=limit, page=page, sortby=sortby)
Example #6
0
def search_coach(key):
    '''Routing function for search coach by its name.

    *GET request* renders the countries.html with coaches comes from the search result.
    '''
    if 'username' not in session:
        return render_template('error.html', err_code=401)
    
    conn, cur = getDb()
    coaches = coach.Coaches(conn, cur)
    countries = country.Countries(conn, cur)

    
    limit = int(request.args['limit']) if 'limit' in request.args else 10
    page = int(request.args['page']) if 'page' in request.args else 0
    
    offset = page*limit
    print('page:',page,'limit',limit,'offset',offset)
    sortby = request.args['sortby'] if 'sortby' in request.args else 'name'
    order = request.args['order'] if 'order' in request.args else 'asc'
    
    l, total_coaches = coaches.get_coaches_search_by('name', key, limit, offset)
    c, total_countries = countries.get_countries()

    sortby={'attr':'name', 'property':'asc'}

    return render_template('coaches.html', coachtable=coach.coachtable, coaches=l, countries=c, total=total_coaches,
            limit=limit, page=page)
Example #7
0
def coaches_home():
    ''' Routing function for coaches-home page. 

    This view page lists all coaches in coaches table.
    This page doesn't allow editing.
    '''
    conn, cur = getDb()
    coaches = coach.Coaches(conn, cur)
    countries = country.Countries(conn, cur)
    print('coaches PAGE')
    if request.method == 'GET':
        # handle GET request
        limit = int(request.args['limit']) if 'limit' in request.args else 10
        page = int(request.args['page']) if 'page' in request.args else 0
        
        offset = page*limit
        print('page:',page,'limit',limit,'offset',offset)
        sortby = request.args['sortby'] if 'sortby' in request.args else 'name'
        order = request.args['order'] if 'order' in request.args else 'asc'

        l, total_coaches = coaches.get_coaches()

        sortby={'attr':'name', 'property':'asc'}

        # check search value
        if 'name' in request.args:
            search_name = request.args['name']
            l, total_coaches = coaches.get_coaches_search_by('name', search_name, limit, offset)
        else:
            l, total_coaches = coaches.get_coaches(limit, offset)
        return render_template('coaches_home.html', coachtable=coach.coachtable, coaches=l, total=total_coaches,
                limit=limit, page=page)
Example #8
0
def countries_home():
    ''' Routing function for countries-home page. 
    
    This view page lists all countries in countries table.
    This page doesn't allow editing.
    '''

    conn, cur = getDb()
    countries = country.Countries(conn, cur)
    print('countries PAGE for normal user')
        
    # limit, page and order args
    # required for each table page if pagination used !
    limit = int(request.args['limit']) if 'limit' in request.args else 10
    page = int(request.args['page']) if 'page' in request.args else 0
    offset = page*limit
    sortby = request.args['sortby'] if 'sortby' in request.args else 'name'
    order = request.args['order'] if 'order' in request.args else 'asc'
        
    # check search value
    if 'name' in request.args:
        search_name = request.args['name']
        c, total = countries.get_countries_by('name', search_name, limit=limit, offset=offset)
    else:
        c, total = countries.get_countries(limit=limit, offset=offset)
    
    return render_template('countries_home.html', countrytable=country.countrytable,
            countries=c, total=total, limit=limit, page=page, sortby=sortby)
Example #9
0
def updateUser():
    """Routing function for updating user. This url allows only POST request.
    
    Updates the user which attributes recieved from *request.form* and returns the JSON object.
    
    :returns: status and error
    :rtype: JSON object
    """
    if "username" not in session:
        return abort(403)

    conn, cur = getDb()

    username = request.form["username"]
    if session["username"] != username:
        return abort(403)

    password = request.form["password"]
    passwordnew = request.form["passwordnew"]

    users = user.Users(conn, cur)
    muser = users.get_user(username)
    if password == muser.password:
        muser.password = passwordnew
        try:
            users.update_user(username, muser)
            return json.dumps({"status": "OK", "user": username, "pass": passwordnew})
        except:
            error = sys.exc_info()[0]
            return json.dumps({"status": "FAILED", "error": error})
    else:
        error = "The password you entered is wrong!"
        return json.dumps({"status": "FAILED", "error": error})
Example #10
0
def signin():
    """Routing function for signin page."""
    conn, cur = getDb()
    error = None
    roles = None

    if request.method == "POST":
        username = request.form["username"]
        password = request.form["password"]

        if login_success(username, password):
            error = "Logged in!"
            cur.execute("SELECT role, lastlogin FROM users WHERE username='******';" % username)
            role, lastlogin = cur.fetchone()
            g.role = role
            g.lastlogin = lastlogin
            session["username"] = request.form["username"]

            now = getCurrTimeStr()
            cur.execute("UPDATE users SET lastlogin='******' WHERE username='******'" % (now, username))
            cur.execute("UPDATE users SET online=TRUE WHERE username='******'" % username)
            conn.commit()
        else:
            error = "Invalid username or password!"

    if "username" in session:
        username = session["username"]
        cur.execute("SELECT role, lastlogin FROM users WHERE username='******';" % username)
        role, lastlogin = cur.fetchone()
        g.role = role
        g.lastlogin = lastlogin

    return render_template("signin.html")
Example #11
0
def signup():
    """Routing function for signup page. 
    
    It allows only *POST* request.
    If the valid values are gotten from the request.form then new user is created and inserted 
    to the db.
    """
    if request.method == "POST":
        try:
            conn, cur = getDb()

            username = request.form["username"]
            password = request.form["password"]
            email = str(request.form["email"])
            role = request.form["role"]
            regtime = getCurrTimeStr()
            lastlogin = regtime
            online = False

            usr = user.User(username, password, email, role, lastlogin, regtime, online)
            users = user.Users(conn, cur)
            users.add_user(usr)

            return redirect(url_for("admin"))
        except IntegrityError:
            conn.rollback()
            roles = None
            error = "This username already registered."
            return render_template("adminpanel.html", error=error, roles=roles)
        else:
            conn.rollback()
            error = sys.exc_info()[0]
            roles = None
            return render_template("adminpanel.html", error=error, roles=roles)
Example #12
0
def schedule_home():
    conn, cur = getDb()
    schedules = schedule.Schedules(conn, cur)
    teams = team.Teams(conn, cur)
    seasons = season.Seasons(conn, cur)
    leagues = league.Leagues(conn, cur)
    print("SCHEDULES PAGE")
    if request.method == "GET":
        # handle GET request
        print("GET REQUEST", request.args)
        limit = int(request.args["limit"]) if "limit" in request.args else 10
        page = int(request.args["page"]) if "page" in request.args else 0

        offset = page * limit
        print("page:", page, "limit", limit, "offset", offset)
        sortby = request.args["sortby"] if "sortby" in request.args else "name"
        order = request.args["order"] if "order" in request.args else "asc"

        if "name" in request.args:
            search_name = request.args["name"]
            l, total = schedules.get_schedules_search_by("name", search_name, limit=limit, offset=offset)
        else:
            l, total = schedules.get_schedules(limit=limit, offset=offset)
    return render_template(
        "schedules_home.html",
        scheduletable=schedule.scheduletable,
        schedules=l,
        total=total,
        limit=limit,
        page=page,
        sortby=sortby,
    )
Example #13
0
def leagues_home():
    ''' Routing function for leagues-home page. 

    This view page lists all leagues in leagues table.
    This page doesn't allow editing.
    '''
    conn, cur = getDb()
    leagues = league.Leagues(conn, cur)
    countries = country.Countries(conn, cur)
    
    # limit, page and order args
    # required for each table page
    limit = int(request.args['limit']) if 'limit' in request.args else 10
    page = int(request.args['page']) if 'page' in request.args else 0
    offset = page*limit
    sortby = request.args['sortby'] if 'sortby' in request.args else 'name'
    order = request.args['order'] if 'order' in request.args else 'asc'
        
    sortby={'attr':'name', 'property':'asc'}
   
    # check search value
    if 'name' in request.args:
        search_name = request.args['name']
        l, total = leagues.get_leagues_search_by('name', search_name, limit=limit, offset=offset)
    else:
        l, total = leagues.get_leagues(limit=limit, offset=offset)
    return render_template('leagues_home.html', leaguetable=league.leaguetable, leagues=l, total=total, 
                limit=limit, page=page, sortby=sortby)
Example #14
0
def search_schedule(key):
    if "username" not in session:
        return render_template("error.html", err_code=401)

    conn, cur = getDb()
    schedules = schedule.Schedules(conn, cur)
    teams = team.Teams(conn, cur)
    seasons = season.Seasons(conn, cur)
    leagues = league.Leagues(conn, cur)

    limit = int(request.args["limit"]) if "limit" in request.args else 10
    page = int(request.args["page"]) if "page" in request.args else 0

    sortby = request.args["sortby"] if "sortby" in request.args else "name"
    order = request.args["order"] if "order" in request.args else "asc"

    offset = page * limit

    schedule_list, total = schedules.get_schedules_search_by("name", key, limit, offset)
    team_list, tp = teams.get_teams(100, 0)  # get list object
    season_list = seasons.get_seasons()  # get list object
    league_list, tk = leagues.get_leagues(100, 0)
    sortby = {"attr": "name", "property": "asc"}
    return render_template(
        "schedules.html",
        scheduletable=schedule.scheduletable,
        schedules=schedule_list,
        seasons=season_list,
        teams=team_list,
        leagues=league_list,
        total=total,
        limit=limit,
        page=page,
        sortby=sortby,
    )
Example #15
0
def view_country(country_name):
    '''Routing function for country info page.

    This view renders the country_page.html with the general information and 
    related table statistics for given country.

    :param country_name: name of the country, string
    '''
    conn, cur = getDb()
    countries = country.Countries(conn, cur)

    c = countries.get_country_name(country_name)
    if c is None:
        # return not found error 
        return render_template('error.html', err_code=404)

    # else render country page with required args
    leagues = league.Leagues(conn, cur)

    league_list, total = leagues.get_leagues_by('country_id', c._id)
    league_dict = {'leagues':league_list,
                    'total': total
                    }

    coaches = coach.Coaches(conn, cur)
    coach_list, total = coaches.get_coaches_by('country_id', c._id)
    coaches_dict = {'coaches':coach_list,
                    'total': total
                    }

    return render_template('country_page.html', country=c, 
            league_dict=league_dict, player_dict=None, coach_dict=coaches_dict)
Example #16
0
def coach_from_id(lid):
    '''Routing function for getting coach from its id.
    
    *GET request* returns JSON object.

    *POST request* updates coach which has id equal to the *lid* with the 
    values recieved from the request.form. After all it renders coaches.html

    :param lid: id of the coach, int
    '''
    if 'username' not in session:
        return render_template('error.html', err_code=401)
    
    conn, cur = getDb()
    coaches = coach.Coaches(conn, cur)
    countries = country.Countries(conn, cur)
    
    if request.method == 'GET':
        # handle GET request
        # return json object
        l= coaches.get_coach(lid)
        if l:
            return json.dumps({'status':'OK', 'coach':l.getAttrs()})
        else:
            return json.dumps({'status':'FAILED'})
    elif request.method == 'POST':
        # handle POST request
        # UPDATE item
        print("POST METHOD REQUEST")
        lid = request.form['id']
        name = request.form['name']
        surname = request.form['surname']
        country_id = request.form['country']
        coach_img = request.files['file']

        limit = int(request.form['limit']) if 'limit' in request.form else 10
        page = int(request.form['page']) if 'page' in request.form else 0
        offset = page*limit
        order = request.form['sortby'] if 'sortby' in request.form else 'name'
        order = request.form['order'] if 'order' in request.form else 'asc'

        lg = coach.Coach(name, surname, country_id)
        coaches.update_coach(lid, lg)
        
        # save image to path
        # image path should start with appname:
        #      real_save_path = 'final4' + <save_path>
        # because app runs in the upper folder.
        if coach_img:
            # get generated image path for new coach object
            save_path = lg.img_path(lid)
            coach_img.save(app.config['APP_FOLDER']+save_path)

        l, total_coaches = coaches.get_coaches()
        c, total_countries  = countries.get_countries()

        sortby={'attr':'name', 'property':'asc'}

        return render_template('coaches.html', coachtable=coach.coachtable, coaches=l, countries=c, total=total_coaches,
                limit=limit, page=page)
Example #17
0
def search_season(key):
    if 'username' not in session:
        return render_template('error.html', err_code=401)
        
    conn, cur = getDb()
    seasons = season.Seasons(conn, cur)
    result = seasons.get_seasons_by(key, 'name')
    return render_template('seasons.html', seasontable=season.seasontable, seasons=result)
Example #18
0
def login_success(username, password):
    conn, cur = getDb()
    cur.execute("SELECT * FROM users WHERE username='******' AND password='******'" % (username, password) )
    user = cur.fetchone()

    if user:
        return True

    return False
Example #19
0
def users():
    """Routing function for users page."""
    conn, cur = getDb()
    usr = user.Users(conn, cur)
    users = usr.get_users()

    if "username" in session:
        g.role = "admin"
    return render_template("users.html", users=users, error=None, usertable=user.usertable)
Example #20
0
def schedule_from_id(schedule_id):
    if "username" not in session:
        return render_template("error.html", err_code=401)

    conn, cur = getDb()
    schedules = schedule.Schedules(conn, cur)
    teams = team.Teams(conn, cur)
    seasons = season.Seasons(conn, cur)
    leagues = league.Leagues(conn, cur)

    if request.method == "GET":
        # handle GET request
        schedule_obj = schedules.get_schedule(schedule_id)
        if schedule_obj:
            return json.dumps({"status": "OK", "schedule": schedule_obj.getAttrs()})
        else:
            return json.dumps({"status": "FAILED"})
    elif request.method == "POST":
        # handle POST request
        print("POST METHOD REQUEST")
        schedule_id = request.form["id"]
        date = request.form["date"]
        saloon = request.form["saloon"]
        score1 = request.form["score1"]
        score2 = request.form["score2"]
        state = request.form["state"]
        team1_id = request.form["team1_name"]
        team2_id = request.form["team2_name"]
        league_id = request.form["league_name"]
        season_id = request.form["season_year"]
        # limit: number of result showing each page
        # offset: selectedpage x limit
        limit = int(request.form["limit"]) if "limit" in request.form else 10
        page = int(request.form["page"]) if "page" in request.form else 0
        offset = page * limit
        order = request.form["sortby"] if "sortby" in request.form else "name"
        order = request.form["order"] if "order" in request.form else "asc"
        schedule_obj = schedule.Schedule(team1_id, team2_id, season_id, league_id, date, saloon, score1, score2, state)
        schedules.update_schedule(schedule_id, schedule_obj)

        schedule_list, total = schedules.get_schedules(limit, offset)
        team_list, tp = teams.get_teams(100, 0)  # get list object
        season_list = seasons.get_seasons()  # get list object
        league_list, tk = leagues.get_leagues(100, 0)
        sortby = {"attr": "name", "property": "asc"}
        return render_template(
            "schedules.html",
            scheduletable=schedule.scheduletable,
            schedules=schedule_list,
            seasons=season_list,
            teams=team_list,
            leagues=league_list,
            total=total,
            limit=limit,
            page=page,
            sortby=sortby,
        )
Example #21
0
def profile(username):
    """Routing function for user profile page.
    Renders *templates/profile.html* for user which has given username.

    :param username: username string
    """
    conn, cur = getDb()
    usr = user.Users(conn, cur)
    puser = usr.get_user(username)
    return render_template("profile.html", user=puser, usertable=user.usertable)
Example #22
0
def get_match_from_id(match_id):
    '''Routing function for getting match from its id.
    
    *GET request* returns JSON object.

    *POST request* updates match which has id equal to the *lid* with the 
    values recieved from the request.form. After all it renders matches.html

    :param lid: id of the match, int
    '''
    conn, cur = getDb()
    matches = match.Matches(conn, cur)
    schedules = schedule.Schedules(conn, cur)
    
    if request.method == 'GET':
        # handle GET request
        match_obj= matches.get_match(match_id)
        if match_obj:
            return json.dumps({'status':'OK', 'match':match_obj.getAttrs()})
        else:
            return json.dumps({'status':'FAILED'})
    elif request.method == 'POST':
        # handle POST request
        print("POST METHOD REQUEST")
        print(request.form)
        schedule_id = request.form['schedule'] #FK
        #T1_name = request.form['T1_name']
        #T2_name = request.form['T2_name']
        T1_3PT = request.form['T1_3PT']
        T1_2PT = request.form['T1_2PT']
        T1_block = request.form['T1_block']
        T1_reb = request.form['T1_reb']
        T1_rate = request.form['T1_rate']
        T2_3PT = request.form['T2_3PT']
        T2_2PT = request.form['T2_2PT']
        T2_block = request.form['T2_block']
        T2_reb = request.form['T2_reb']
        T2_rate = request.form['T2_rate']
 
        # limit: number of result showing each page
        # offset: selectedpage x limit
        limit = int(request.form['limit']) if 'limit' in request.form else 10
        page = int(request.form['page']) if 'page' in request.form else 0
        offset = page*limit
        order = request.form['sortby'] if 'sortby' in request.form else 'name'
        order = request.form['order'] if 'order' in request.form else 'asc'
        
        match_obj = match.Match(schedule_id, T1_3PT, T1_2PT, T1_block, T1_reb, T1_rate, T2_3PT, T2_2PT, T2_block, T2_reb, T2_rate)
        matches.update_match(match_id, match_obj)
        
        match_list, total = matches.get_matches(limit, offset)
        schedule_list, ts = schedules.get_schedules() # get list object
        sortby={'attr':'name', 'property':'asc'}
        return render_template('matches.html', matchtable=match.matchtable, matches=match_list,
			schedules=schedule_list, total=total, limit=limit, page=page, sortby=sortby)
Example #23
0
def seasons_home():
    conn, cur = getDb()
    seasons = season.Seasons(conn, cur)
    print('SEASONS PAGE')
    if request.method == 'GET':
        if 'name' in request.args:
            search_name = request.args['name']
            l = seasons.get_seasons_by(search_name, 'name')
            #l = seasons.get_seasons_search_by('name', search_name)
        else:
            l = seasons.get_seasons()
        
        return render_template('seasons_home.html', seasontable=season.seasontable, seasons=l)
def award_stat_from_id(award_stat_id):
    '''Routing function for getting award_stat from its id.
    
    *GET request* returns JSON object.

    *POST request* updates award_stat which has id equal to the *lid* with the 
    values recieved from the request.form. After all it renders award_stats.html

    :param lid: id of the award_stat, int
    '''
    if 'username' not in session:
        return render_template('error.html', err_code=401)
    
    conn, cur = getDb()
    award_stats = award_stat.AwardStats(conn, cur)
    awards = award.Awards(conn, cur)
    players = player.Players(conn, cur)
    seasons = season.Seasons(conn, cur)
    
    if request.method == 'GET':
        # handle GET request
        award_stat_obj= award_stats.get_award_stat(award_stat_id)
        if award_stat_obj:
            return json.dumps({'status':'OK', 'award_stat':award_stat_obj.getAttrs()})
        else:
            return json.dumps({'status':'FAILED'})
    elif request.method == 'POST':
        # handle POST request
        print("POST METHOD REQUEST")
        award_stat_id = request.form['id']
        award_id = request.form['award_name']
        player_id = request.form['player_name']
        season_id = request.form['season_year']
        # limit: number of result showing each page
        # offset: selectedpage x limit
        limit = int(request.form['limit']) if 'limit' in request.form else 10
        page = int(request.form['page']) if 'page' in request.form else 0
        offset = page*limit
        order = request.form['sortby'] if 'sortby' in request.form else 'name'
        order = request.form['order'] if 'order' in request.form else 'asc'
        award_stat_obj = award_stat.AwardStat(award_id, player_id, season_id)
        award_stats.update_award_stat(award_stat_id, award_stat_obj)
        
        award_stat_list, total = award_stats.get_award_stats(limit, offset)
        award_list, ta = awards.get_awards(limit, offset)
        player_list,tp = players.get_players(100,0) # get list object
        season_list = seasons.get_seasons() # get list object
        sortby={'attr':'name', 'property':'asc'}
        return render_template('award_stats.html', award_stattable=award_stat.award_stattable, 
			award_stats=award_stat_list, awards=award_list, seasons=season_list, players=player_list, 
			total=total, limit=limit, page=page, sortby=sortby)
Example #25
0
def admin():
    """Routing function for admin page. 
    This page allows *POST* and *GET* requests.
    
    *GET request:* If the user signed in adminpanel page is rendered. 
    Otherwise signin page is rendered.

    *POST request:* Checks the request.form values for registered 
    users. If the values are valid it adds user to the session and 
    renders the adminpanel. Otherwise error message is flashed.
    """
    conn, cur = getDb()
    error = None
    roles = None

    if request.method == "POST":
        username = request.form["username"]
        password = request.form["password"]

        if login_success(username, password):
            error = "Logged in!"
            query = "SELECT role, lastlogin FROM users WHERE username=%s"
            cur.execute(query, (username,))
            role, lastlogin = cur.fetchone()
            g.role = role
            g.lastlogin = lastlogin
            session["username"] = request.form["username"]

            now = getCurrTimeStr()
            query = "UPDATE users SET lastlogin=%s WHERE username=%s"
            cur.execute(query, (now, username))
            query = "UPDATE users SET online=TRUE WHERE username=%s"
            cur.execute(query, (username,))
            conn.commit()
        else:
            error = "Invalid username or password!"

    if "username" in session:
        username = session["username"]
        query = "SELECT role, lastlogin FROM users WHERE username=%s"
        cur.execute(query, (username,))
        role, lastlogin = cur.fetchone()
        g.role = role
        g.lastlogin = lastlogin
    else:
        flash("Wrong username or password")
        return render_template("signin.html")

    return render_template("adminpanel.html", error=error, roles=roles)
Example #26
0
def view_schedule(schedule_id):
    conn, cur = getDb()

    schedules = schedule.Schedules(conn, cur)
    teams = team.Teams(conn, cur)
    seasons = season.Seasons(conn, cur)
    leagues = league.Leagues(conn, cur)

    l = schedules.get_schedule(schedule_id)
    if l is None:
        # return not found error
        return render_template("error.html", err_code=404)

    # else render country page with required args

    return render_template("schedule_page.html", schedule=l)
Example #27
0
def logout():
    """Routing function for logout page.
    
    When this page called if there is a user logged in, then the user removed from the session.
    
    After all it redirects to the home page.
    """
    conn, cur = getDb()
    if "username" in session:
        username = session["username"]
        query = "UPDATE users SET online=FALSE WHERE username=%s"
        cur.execute(query, (username,))
        conn.commit()
    g.role = "guest"
    session.pop("username", None)
    return redirect(url_for("home"))
Example #28
0
def view_award(award_id):
    '''Routing function for award info page.
    
    It renders the award_page.html with related statistical information.
    '''
    conn, cur = getDb()

    awards = award.Awards(conn, cur)

    l = awards.get_award(award_id)
    if l is None:
        # return not found error 
        return render_template('error.html', err_code=404)

    # else render country page with required args

    return render_template('award_page.html', award=l)
Example #29
0
def view_match(match_id):
    '''Routing function for match info page.
    
    It renders the match_page.html with related statistical information.
    '''
    conn, cur = getDb()
    
    matches = match.Matches(conn, cur)
    schedules = schedule.Schedules(conn, cur)
    
    l = matches.get_match(match_id)
    if l is None:
        # return not found error 
        return render_template('error.html', err_code=404)

    # else render country page with required args

    return render_template('match_page.html', match=l)
Example #30
0
def league_from_id(lid):
    '''Routing function for getting league from its id.
    
    *GET request* returns JSON object.

    *POST request* updates league which has id equal to the *lid* with the 
    values recieved from the request.form. After all it renders leagues.html

    :param lid: id of the league, int
    '''
    if 'username' not in session:
        return render_template('error.html', err_code=401)
    conn, cur = getDb()
    leagues = league.Leagues(conn, cur)
    countries = country.Countries(conn, cur)
    
    if request.method == 'GET':
        # handle GET request
        l= leagues.get_league(lid)
        if l:
            return json.dumps({'status':'OK', 'league':l.getAttrs()})
        else:
            return json.dumps({'status':'FAILED'})
    elif request.method == 'POST':
        # handle POST request
        print("POST METHOD REQUEST")
        lid = request.form['id']
        name = request.form['name']
        country_id = request.form['country']
        # limit: number of result showing each page
        # offset: selectedpage x limit
        limit = int(request.form['limit']) if 'limit' in request.form else 10
        page = int(request.form['page']) if 'page' in request.form else 0
        offset = page*limit
        order = request.form['sortby'] if 'sortby' in request.form else 'name'
        order = request.form['order'] if 'order' in request.form else 'asc'
        lg = league.League(name, country_id)
        leagues.update_league(lid, lg)
        
        l, total = leagues.get_leagues(limit, offset)
        c, total_countries = countries.get_countries()
        sortby={'attr':'name', 'property':'asc'}
        return render_template('leagues.html', leaguetable=league.leaguetable, leagues=l, countries=c, total=total, 
                                limit=limit, page=page, sortby=sortby)