password = request.form['password']
users_list = db_interaction.get_users()
username = request.form['user']
user = db_interaction.get_user_info(username)

for u in user_list:
    us = ''.join(u)
    if username == us:
        flag = 1
        break
    else:
        flag = 0

if flag == 0:
    return render_template('index.html')

else:
    pas= ''.join(db_interaction.get_user_pass(username))
    if pas == password: #correctly logged in
        f = []
        id = 0
        session['user'] = username
        for field in user:
            if i == 3:
                id = field
                break
            else:
                f[i] = ''.join(field)
                i = i+1

        notif = Notification()
        link = notif.get_subscribe_link(str(id))
        check_auth = db_interaction.get_auth(username)
        check_auth= ''.join(check_auth)
        session['password'] = f[1]
        session['email'] = f[2]
        session['id'] = id
        session['link'] = link
        if(check_auth == 'N'): #not authenticated with jawbone API (no json)
            session['auth'] = ""
            return render_template('personal.html', user=username, password=f[1], email=f[2], id=id, link=link, auth="")
        else: #authenticated with jawbone
            date = db_interaction.get_date(username)
            date_db = str(date_db)
            d = date_db.replace('(', '')
            j= d.replace(')', '')
            ddb = j.replace(',','')
            date_curr = datetime.datetime.today().day
            if ddb is None: #no data has ever been saved in database
                db_interaction.set_sleeps(username, sleep_timestamp[0], sleep_timestamp[1], sleep_timestamp[2], sleep_timestamp[3], sleep_timestamp[4], sleep_timestamp[5], sleep_timestamp[6])
                db_interaction.set_wakes(username, wake_timestamp[0], wake_timestamp[1], wake_timestamp[2], wake_timestamp[3], wake_timestamp[4], wake_timestamp[5], wake_timestamp[6])
                db_interaction.set_kcals(username, kcal[0], kcal[1], kcal[2], kcal[3], kcal[4], kcal[5], kcal[6])
                session['auth'] = "authenticated"
                return render_template('personal.html', user=username, password=f[1], email=f[2], id=f[3], link=link, auth="authenticated"
                                                         day7="7daysAgo", day6="6daysAgo", day5="5daysAgo", day4="4daysAgo", day3="3daysAgo", day2="2daysAgo", day1="1dayAgo",
                                                         cal7=kcal[6], cal6=kcal[5], cal5=kcal[4], cal4=kcal[3], cal3=kcal[2], cal2=kcal[1], cal1=kcal[0], auth="authenticated",
                                                         sleep7=sleep_timestamp[6], sleep6=sleep_timestamp[5], sleep5=sleep_timestamp[4], sleep4=sleep_timestamp[3], sleep3=sleep_timestamp[2],
                                                         sleep2=sleep_timestamp[1], sleep1=sleep_timestamp[0], wake7=wake_timestamp[6], wake6=wake_timestamp[5], wake5=wake_timestamp[4],
                                                         wake3=wake_timestamp[2], wake2=wake_timestamp[1], wake1=wake_timestamp[0], wake4=wake_timestamp[3])
            elif str(ddb) != str(date_curr): #date in db is not current date of today
                db_interaction.set_sleeps(username, sleep_timestamp[0], sleep_timestamp[1], sleep_timestamp[2], sleep_timestamp[3], sleep_timestamp[4], sleep_timestamp[5], sleep_timestamp[6])
                db_interaction.set_wakes(username, wake_timestamp[0], wake_timestamp[1], wake_timestamp[2], wake_timestamp[3], wake_timestamp[4], wake_timestamp[5], wake_timestamp[6])
                db_interaction.set_kcals(username, kcal[0], kcal[1], kcal[2], kcal[3], kcal[4], kcal[5], kcal[6])
                session['auth'] = "authenticated"
                return render_template('personal.html', user=username, password=f[1], email=f[2], id=f[3], link=link, auth="authenticated"
                                                         day7="7daysAgo", day6="6daysAgo", day5="5daysAgo", day4="4daysAgo", day3="3daysAgo", day2="2daysAgo", day1="1dayAgo",
                                                         cal7=kcal[6], cal6=kcal[5], cal5=kcal[4], cal4=kcal[3], cal3=kcal[2], cal2=kcal[1], cal1=kcal[0], auth="authenticated",
                                                         sleep7=sleep_timestamp[6], sleep6=sleep_timestamp[5], sleep5=sleep_timestamp[4], sleep4=sleep_timestamp[3], sleep3=sleep_timestamp[2],
                                                         sleep2=sleep_timestamp[1], sleep1=sleep_timestamp[0], wake7=wake_timestamp[6], wake6=wake_timestamp[5], wake5=wake_timestamp[4],
                                                         wake3=wake_timestamp[2], wake2=wake_timestamp[1], wake1=wake_timestamp[0], wake4=wake_timestamp[3])
            else: #data has been saved in the same day
                sleep = db_interaction.get_sleep(username)
                wake = db_interaction.get_wake(username)
                if sleep is None: #algorithm hasn't been run yet
                    db_interaction.set_sleeps(username, sleep_timestamp[0], sleep_timestamp[1], sleep_timestamp[2], sleep_timestamp[3], sleep_timestamp[4], sleep_timestamp[5], sleep_timestamp[6])
                    db_interaction.set_wakes(username, wake_timestamp[0], wake_timestamp[1], wake_timestamp[2], wake_timestamp[3], wake_timestamp[4], wake_timestamp[5], wake_timestamp[6])
                    db_interaction.set_kcals(username, kcal[0], kcal[1], kcal[2], kcal[3], kcal[4], kcal[5], kcal[6])
                    session['auth'] = "authenticated"
                    return render_template('personal.html', user=username, password=f[1], email=f[2], id=f[3], link=link, auth="authenticated"
                                                             day7="7daysAgo", day6="6daysAgo", day5="5daysAgo", day4="4daysAgo", day3="3daysAgo", day2="2daysAgo", day1="1dayAgo",
                                                             cal7=kcal[6], cal6=kcal[5], cal5=kcal[4], cal4=kcal[3], cal3=kcal[2], cal2=kcal[1], cal1=kcal[0], auth="authenticated",
                                                             sleep7=sleep_timestamp[6], sleep6=sleep_timestamp[5], sleep5=sleep_timestamp[4], sleep4=sleep_timestamp[3], sleep3=sleep_timestamp[2],
                                                             sleep2=sleep_timestamp[1], sleep1=sleep_timestamp[0], wake7=wake_timestamp[6], wake6=wake_timestamp[5], wake5=wake_timestamp[4],
                                                             wake3=wake_timestamp[2], wake2=wake_timestamp[1], wake1=wake_timestamp[0], wake4=wake_timestamp[3])
                else: #algorithm ran
                    db_interaction.set_sleeps(username, sleep_timestamp[0], sleep_timestamp[1], sleep_timestamp[2], sleep_timestamp[3], sleep_timestamp[4], sleep_timestamp[5], sleep_timestamp[6])
                    db_interaction.set_wakes(username, wake_timestamp[0], wake_timestamp[1], wake_timestamp[2], wake_timestamp[3], wake_timestamp[4], wake_timestamp[5], wake_timestamp[6])
                    db_interaction.set_kcals(username, kcal[0], kcal[1], kcal[2], kcal[3], kcal[4], kcal[5], kcal[6])
                    session['auth'] = "authenticated"
                    session['sleep'] = sleep
                    session['wake'] = wake
                    return render_template('personal_page.html', user=username, password=f[1], email=f[2], id=f[3], link=link, auth="authenticated", sleep=sleep, wake=wake,
                                                             day7="7daysAgo", day6="6daysAgo", day5="5daysAgo", day4="4daysAgo", day3="3daysAgo", day2="2daysAgo", day1="1dayAgo",
                                                             cal7=kcal[6], cal6=kcal[5], cal5=kcal[4], cal4=kcal[3], cal3=kcal[2], cal2=kcal[1], cal1=kcal[0], auth="authenticated",
                                                             sleep7=sleep_timestamp[6], sleep6=sleep_timestamp[5], sleep5=sleep_timestamp[4], sleep4=sleep_timestamp[3], sleep3=sleep_timestamp[2],
                                                             sleep2=sleep_timestamp[1], sleep1=sleep_timestamp[0], wake7=wake_timestamp[6], wake6=wake_timestamp[5], wake5=wake_timestamp[4],
                                                              wake3=wake_timestamp[2], wake2=wake_timestamp[1], wake1=wake_timestamp[0], wake4=wake_timestamp[3])
    else: #wrong identification
        return render_template('signin.html');