app.py

from flask import Flask,render_template,request,redirect,session,flash,redirect
import mysql.connector
import os
import tweepy
import api
import ml
import math
import matching

app= Flask(__name__)
app.secret_key=os.urandom(24)
 
conn=mysql.connector.connect(host="remotemysql.com",user="9YwiYaINDg",password="**********",database="9YwiYaINDg")
cursor=conn.cursor()





@app.route('/register')
def register():
    return render_template('register.html')



@app.route('/login')
def login():
    return render_template('login.html')

@app.route('/home')
def home():
    if 'user_id' in session:
        return render_template('home.html')
    else:
        return redirect('/')
   

@app.route("/loginvalidation", methods=['POST'])
def loginval():
    global email
    global password
    email=request.form.get('email')
    password=request.form.get('password')
    cursor.execute("""SELECT * FROM `users` WHERE `email` LIKE '{}' AND `password` LIKE '{}'""".format(email,password))
    users=cursor.fetchall()
  
    if len(users)>0:
        session['user_id']=users[0][0]
        flash('account logged in')
        return render_template('home.html')
        
    else:
        return redirect('/login')


    


@app.route('/add_user',methods=['POST'])
def add_user():
    global name    
    global phone_number
    global gender
    global twitter_id
    global email
    global password
    name=request.form.get('username')
    email=request.form.get('useremail')
    password=request.form.get('userpassword')
    phone_number=request.form.get('userphone')
    gender=request.form.get('gender')
    twitter_id=request.form.get('twitter_id')
    cursor.execute("""INSERT INTO `users` (`user_id`,`name`,`email`,`password`,`phone_number`,`gender`,`twitter_id`) VALUES (NULL,'{}','{}','{}','{}','{}','{}')""".format(name,email,password,phone_number,gender,twitter_id))
    conn.commit()

    cursor.execute("""SELECT * FROM `users`  WHERE `email` LIKE '{}' AND `password` LIKE '{}' """.format(email,password))
    user=cursor.fetchone()
    twitter_id = user[6]
    a=api.twitter_api(twitter_id)
    #print(a)
    res=ml.predict(a)
    per_map={0:'ENFJ', 1:'ENFP', 2:'ENTJ', 3:'ENTP', 4:'ESFJ', 5:'ESFP', 6:'ESTJ', 7:'ESTP', 8:'INFJ', 9:'INFP', 10:'INTJ', 11:'INTP', 12:'ISFJ', 13:'ISFP', 14:'ISTJ', 15:'ISTP'}

    personality_index =per_map[res]
    print(personality_index)
    cursor.execute("""SELECT * FROM `users`  WHERE `email` LIKE '{}' AND `password` LIKE '{}' """.format(email,password))
    user=cursor.fetchone()
    cursor.execute("""UPDATE `users` set personality_index='{}' WHERE email='{}' """.format(personality_index,email))
    conn.commit()
    #flash('account created')
    return redirect('/login')


@app.route('/logout')
def logout():
    session.pop('user_id')
    return redirect('/')

@app.route('/form')
def form():
    return render_template('form.html')

@app.route('/home', methods=['POST'])
def form_data():
    global result
    if request.method=="POST":
        req=request.form
        movie=req['movie']
        music=req['music']
        sport=req['sport']
        choice=req['choice']
        result=movie+music+sport+choice
        cursor.execute("""SELECT * FROM `users`  WHERE `email` LIKE '{}' AND `password` LIKE '{}' """.format(email,password))
        user=cursor.fetchone()
        cursor.execute("""UPDATE `users` set results='{}' WHERE email='{}' """.format(result,email))
        conn.commit()
        conn.commit()
        return render_template('home.html')


@app.route('/map1')
def map1():    
    return render_template('map1.html')

@app.route('/map2', methods=['GET','POST'])
def map2():
    if request.method=="POST":
        req=request.form
        scoords=req['scoords']
        ecoords=req['ecoords']
        #print(scoords,ecoords)
        cursor.execute("""SELECT * FROM `users`  WHERE `email` LIKE '{}' AND `password` LIKE '{}' """.format(email,password))
        user=cursor.fetchone()
        pooling=1
        cursor.execute("""UPDATE `users` set pooling='{}' WHERE email='{}' """.format(pooling,email))
        cursor.execute("""UPDATE `users` set starting_coords='{}' WHERE email='{}' """.format(scoords,email))
        cursor.execute("""UPDATE `users` set ending_coords='{}' WHERE email='{}' """.format(ecoords,email))
        conn.commit()
    
    # cursor.execute("""SELECT * FROM `users`  WHERE `email` LIKE '{}' AND `password` LIKE '{}' """.format(email,password))
    # user=cursor.fetchone()
    # A = user[10]
    # B = user[11]
    # #print(A,B)
    # ll1=A.split(',')
    # ll2=B.split(',')
    # ll1=ll1[::-1]
    # ll2=ll2[::-1]
    # a1=(ll1[0),ll1[1])
    # a2=(ll2[0],ll2[1])
    # cursor.execute("""SELECT * FROM `users`""")
    # users=cursor.fetchall()
    # start={record[1]: record[10] for record in users}
    # end={record[1]: record[11] for record in users}
    # print(start)

    cursor.execute("""SELECT * FROM `users`  WHERE `email` LIKE '{}' AND `password` LIKE '{}' """.format(email,password))
    user=cursor.fetchone()
    cursor.execute("""SELECT * FROM `users` """)
    records = cursor.fetchall()
    u1=(user[1],user[7])
    u2=(user[1],user[8])
    d1= {record[1]: record[7] for record in records}
    d2= {record[1]: record[8] for record in records}
    ss=matching.match(u2,d2)
    print(ss)
    # #latitudes and longitudes respectively (a1,a2),(b1,b2)
    

    
    #     li=matching.personality(u1,d1)

    #     if len(li)>4:
    #         mate=matching.match(u3,d3)
    #     else:
    #         mate=matching.match(u2,d2)    
    cursor.execute("""SELECT * FROM `users`  WHERE `name` LIKE '{}' """.format(ss))
    usr_phn=cursor.fetchone()
    phn=usr_phn[4]
    pooling=0
    cursor.execute("""UPDATE `users` set pooling='{}' WHERE email='{}' """.format(pooling,email))
    return render_template('map2.html',ss=ss,phn=phn)


@app.route('/',methods=['GET', 'POST'])
def index():
    return render_template('home.html')




if __name__ == '__main__':
    app.run(debug=True)