app.py

from operator import and_
from flask import Flask, render_template, request, flash, redirect, url_for,make_response,session
from flask_sqlalchemy import SQLAlchemy
import os
from werkzeug.security import generate_password_hash,check_password_hash
import psycopg2
from datetime import datetime
from flask_mail import Mail,Message
from itsdangerous import URLSafeTimedSerializer,SignatureExpired,BadSignature
from flask_login import LoginManager,UserMixin, login_manager,logout_user,current_user,AnonymousUserMixin,login_user
from flask_login.utils import login_required
app = Flask(__name__)
mail=Mail(app)
app.config['MAIL_SERVER']='smtp.gmail.com'
app.config['MAIL_PORT']=465
app.config['MAIL_USERNAME']=os.environ['EMAIL125']
app.config['MAIL_PASSWORD']=os.environ['PASSWORD125']
# app.config['MAIL_USERNAME']=''
# app.config['MAIL_PASSWORD']=''
app.config['MAIL_USE_TLS']=False
app.config['MAIL_USE_SSL']=True
mail=Mail(app)
s = URLSafeTimedSerializer(os.environ['SECRET_KEY_AUTH'])
# s = URLSafeTimedSerializer('khdfgsdhfgdsf')
app.config['SECRET_KEY'] = os.environ['SECRET_KEY']
# app.config['SECRET_KEY'] = 'hjhghg'

app.config['SQLALCHEMY_DATABASE_URI'] = os.environ["DATABASE_URL"]
# app.config['SQLALCHEMY_DATABASE_URI'] = 'postgresql://postgres:test123@localhost/flaskmovie'
app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False
db = SQLAlchemy(app)
login_manager = LoginManager()
login_manager.init_app(app)
login_manager.login_view = 'login'
class Anonymous(AnonymousUserMixin):
  def __init__(self):
    self.username = 'Guest'
app.secret_key = 'ye ye'
class User_Basic_infos(db.Model,UserMixin):
    __tablename__ = 'userbasicinfos'
    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String, unique=True)
    password = db.Column(db.String, nullable=False)
    email = db.Column(db.String, unique=True)
    flags = db.Column(db.Boolean, default=False)
    usernamefull = db.Column(db.String,default="NOT_SET")
    Location = db.Column(db.String,default="NOT_SET")
    Bio = db.Column(db.String,default="NOT_SET")
    Image_Str = db.Column(db.String,default="1")
    Designation = db.Column(db.String,default="NOT_SET")
    phone = db.Column(db.String,default="NOT_SET")
    Instagram = db.Column(db.String,default="NOT_SET")
    Facebook = db.Column(db.String,default="NOT_SET")
    Twitter = db.Column(db.String,default="NOT_SET")
    Github = db.Column(db.String,default="NOT_SET")
    Linkdin = db.Column(db.String,default="NOT_SET")
    website = db.Column(db.String,default="NOT_SET")
    DOB = db.Column(db.Date,default='08-01-2003')
    def __repr__(self) -> str:
        return f"{self.id} - {self.username}"
    def verify_password(self, pwd):
        return check_password_hash(self.password, pwd)
class Forum_Questions(db.Model):
    __tablename__ = "forum_questions"
    id = db.Column(db.Integer,primary_key=True)
    user_id = db.Column(db.Integer,db.ForeignKey("userbasicinfos.id"))
    title = db.Column(db.String)
    discription = db.Column(db.String)
    time = db.Column(db.Date,default=datetime.now)
    def __repr__(self) -> str:
        return f"{self.id} - {self.user_id}"
class Forum_Questions_Reply(db.Model):
    __tablename__ = "forum_questions_replays"
    id = db.Column(db.Integer,primary_key=True)
    user_id = db.Column(db.Integer,db.ForeignKey("userbasicinfos.id"))
    flag = db.Column(db.Integer,db.ForeignKey("forum_questions.id"))
    discription = db.Column(db.String)
    time = db.Column(db.Date,default=datetime.now)
    def __repr__(self) -> str:
        return f"{self.id} - {self.user_id}"
class likeDetailss(db.Model):
    __tablename__ = 'likedetailss'
    id = db.Column(db.Integer, primary_key=True)
    userid = db.Column(db.Integer, db.ForeignKey('userbasicinfos.id'))
    forumid = db.Column(db.Integer, db.ForeignKey('forum_questions.id'))
    def __repr__(self) -> str:
        return f"{self.forumid} - {self.userid}"
@login_manager.user_loader
def load_user(user_id):
    return User_Basic_infos.query.get(int(user_id))
@app.route('/')
def home():
    return render_template('index.html')

@app.route('/signin', methods=['POST', 'GET'])
def signin():
    global usn
    global psd
    global em
    if request.method == 'POST':
        try:
            usn = request.form['usn']
            psd = request.form['psd']
            em = request.form['em']
            check_if_exsisit_email = User_Basic_infos.query.filter_by(email=em).first()
            check_if_exsisit_username = User_Basic_infos.query.filter_by(username=usn).first()
            hashed_Value = generate_password_hash(psd)
            check_if_exsisit_password = User_Basic_infos.query.filter_by(password=hashed_Value).first()
            if not check_if_exsisit_email and not check_if_exsisit_username and not check_if_exsisit_password:
                hashed_Value = generate_password_hash(psd)
                print(hashed_Value)
                print(check_password_hash(hashed_Value,psd))
                token = s.dumps({"Email":em,"Password":hashed_Value,"Username":usn},salt='email-confirm')
                print(token)
                msg = Message('Hello',sender =os.environ['EMAIL125'],recipients = [em])
                link = url_for('confirm_email',token=token,_external=True)
                msg.body = 'Your Token Is {}'.format(link)
                mail.send(msg)
                flash('Check Mail For Authentication')
                return render_template('index.html',flag=1)
            else:
                flash('User Already Exist')
                return render_template('index.html',flag=1)
        except Exception as e:
            print(e)
            flash('Use Diffrent Username and Password')
            return render_template('index.html',flag=1)

    return render_template('index.html')

@app.route('/confirm_email/<token>')
def confirm_email(token):
    try:
        data = s.loads(token , salt='email-confirm',max_age=60)
        conf = User_Basic_infos(username=data["Username"],email=data["Email"],password=data["Password"],flags=True)
        db.session.add(conf)
        db.session.commit()
    except SignatureExpired:
        return "The Token Is Expired"
    except BadSignature:
        return "The token is invalid"
    return "This email worked"
@app.route('/login', methods=['GET', 'POST'])
def login():
    if request.method == 'POST':
        global eml
        global usnl
        usnl = request.form['usnl']
        psdl = request.form['psdl']
        eml = request.form['eml']
        hashed_Value = generate_password_hash(psdl)
        print(hashed_Value)
        try:
            cheking = User_Basic_infos.query.filter_by(username=usnl,email=eml,flags =True).first()
            print(check_password_hash(cheking.password,psdl))
            if not cheking:
                flash('Username and Email Are Incorrect')
                return render_template('index.html',flag=2)
            elif cheking and check_password_hash(cheking.password,psdl):
                login_user(cheking)
                session['visits']=cheking.id
                print("LOl",cheking.id)
                # resp = make_response()
                # resp.set_cookie('userID', cheking.id)
                # print("--->>>",request.cookies.get('userID'))
                # flash('login In Succesfully')
                user = User_Basic_infos.query.filter_by(id=session.get('visits')).first()
                return render_template('forums.html',user=user)
            else:
                flash('Password Is Incorrect')
                return render_template('index.html',flag=2)
        except Exception as e:
            print(e)
            flash('Username and Password Are Incorrect')
            return render_template('index.html',flag=2)
    return render_template('index.html')
@app.route('/askque', methods=['GET','POST'])
@login_required
def askque():
    if request.method == 'POST':
        topic = request.form['tpc']
        Discription = request.form['tpcdisc']
        askingquestion = Forum_Questions(user_id=session.get('visits'),title=topic,discription=Discription)
        db.session.add(askingquestion)
        db.session.commit()
        user_profile = User_Basic_infos.query.filter_by(id=session.get('visits')).first()
    flash('Question Ask')
    return render_template('forums.html',flag =1,user = user_profile)
@app.route('/editprofile', methods=['GET','POST'])
@login_required
def editprofile(): 
    if request.method == 'POST':
        user_profile = User_Basic_infos.query.filter_by(id=session.get('visits')).first()
        # image_data = request.form.get("image_data")
        # text_data = request.form.get("text_data")
        # Location_data = request.form.get("Location_data")
        # Bio_data = request.form.get("Bio_data")
        # DOB_data = request.form.get("DOB_data")
        # Designation_data = request.form.get("Designation_data")
        image_data = request.form["imgsrc"]
        text_data = request.form["username"]
        Location_data = request.form["Location"]
        Bio_data = request.form["bio"]
        DOB_data = request.form["dob"]
        Designation_data = request.form["desig"]
        phone = request.form["Phone_Number"]
        Instagram = request.form["Instagram"]
        Facebook = request.form["Facebook"]
        Twitter = request.form["Twitter"]
        Github = request.form["Github"]
        Linkdin = request.form["Linkdin"]
        website = request.form["website"]
        user_profile.Image_Str = image_data
        user_profile.usernamefull = text_data
        user_profile.Location=Location_data
        user_profile.Bio=Bio_data
        user_profile.DOB=DOB_data
        user_profile.Designation=Designation_data
        user_profile.phone=phone
        user_profile.Instagram=Instagram
        user_profile.Facebook=Facebook
        user_profile.Twitter=Twitter
        user_profile.Github=Github
        user_profile.Linkdin=Linkdin
        user_profile.website=website
        db.session.add(user_profile)
        db.session.commit()
        print(image_data,text_data,Location_data,Bio_data,DOB_data,Designation_data)
        print("HEY THERE ITS WORKING YAYA")
        flash('Profile Edit Succesfully')
        return render_template('forums.html',flag =2,user = user_profile)
    user_profile = User_Basic_infos.query.filter_by(id=session.get('visits')).first()
    return render_template('forums.html',flag =20,user = user_profile)
@app.route('/logout')
@login_required
def logout():
    logout_user()
    flash('Logout Succesfully')
    return render_template('index.html',flag=1)
@app.route('/forum')
@login_required
def forum():
    user =list(db.session.query(User_Basic_infos.Image_Str,User_Basic_infos.username,User_Basic_infos.id)
                                .join(Forum_Questions, User_Basic_infos.id == Forum_Questions.user_id)
                                .all())
    temp_like = db.session.execute('SELECT COUNT (likeDetailss.forumid),forum_questions.id , forum_questions.title,forum_questions.discription FROM likeDetailss RIGHT JOIN forum_questions ON likeDetailss.forumid = forum_questions.id GROUP BY forum_questions.id ORDER BY forum_questions.id').fetchall()
    lenghts=len(temp_like)
    te = session.get('visits')
    flgs_db = db.session.execute(f'SELECT likeDetailss.forumid FROM likeDetailss RIGHT JOIN forum_questions ON likeDetailss.userid = {te} AND forum_questions.id = likeDetailss.forumid').fetchall()
    return render_template('test.html',ques=temp_like,user=user,total_len=lenghts,like=flgs_db,curruser=session.get('visits'))
@app.route('/forum/<int:id>',methods=['GET','POST'])
@login_required
def forum_id(id):
    forum_gg = Forum_Questions.query.filter_by(id=id).first()
    user =list(db.session.query(User_Basic_infos.Image_Str,User_Basic_infos.username)
                                .join(Forum_Questions, User_Basic_infos.id == forum_gg.user_id)
                                .first())
    users =list(db.session.query(User_Basic_infos.Image_Str,User_Basic_infos.username,Forum_Questions_Reply.discription).join(Forum_Questions_Reply,and_(Forum_Questions_Reply.flag==id , User_Basic_infos.id == Forum_Questions_Reply.user_id)).all())
    print(users)
    return render_template('bbg.html',ques=forum_gg,user=user,users=users,lenghtsq=len(users))

@app.route('/userprofile/<string:username>',methods=['GET','POST'])
def userprofile(username):
    if request.method == 'POST':
        user = User_Basic_infos.query.filter_by(username=username).first()
        if not user:
            return "Not Fund"
        return render_template('user_profile.html',user=user)
    user = User_Basic_infos.query.filter_by(username=username).first()
    if not user:
        return "Not Fund"
    return render_template('user_profile.html',user=user)

@app.route('/replay/<int:id>',methods=['GET','POST'])
@login_required
def replay(id):
    if request.method == 'POST':
        comment = request.form["ncom"]
        replay_msg = Forum_Questions_Reply(user_id=session.get('visits'),flag=id,discription=comment)
        db.session.add(replay_msg)
        db.session.commit()
        print(comment)
        return redirect(f'/forum/{id}')
@app.route('/reset_link',methods=['GET','POST'])
def reset_link():
    if request.method == 'POST':
        reset_email = request.form['emailforget']
        cheking = User_Basic_infos.query.filter_by(email=reset_email,flags =True).first()
        if not cheking:
            return "User Doesn't Exist"
        reset_token = s.dumps({"Email":reset_email},salt='email-reset')
        print(reset_token)
        msg = Message('Hello',sender =os.environ['EMAIL125'],recipients = [reset_email])
        link = url_for('reset_password',token=reset_token,_external=True)
        msg.body = 'Your Token Is {}'.format(link)
        mail.send(msg)
        return "Check Mail For Reset Password"
        # return render_template('Search_bar.html')
@app.route('/reset_password/<token>',methods=['GET','POST'])
def reset_password(token):
    try:
        data = s.loads(token , salt='email-reset',max_age=60)
        if request.method == 'GET':
            user_profile = User_Basic_infos.query.filter_by(email=data["Email"]).first()
            return render_template('Search_bar.html',token=token,user=user_profile)
        # conf = User_Basic_infos(username=data["Username"],email=data["Email"],password=data["Password"],flags=True)
        # db.session.add(conf)
        # db.session.commit()
        if request.method == 'POST':
            reset_password=request.form["reset_password"]
            print(reset_password)
            hashed_Value = generate_password_hash(reset_password)
            print(hashed_Value)
            print(data["Email"])
            user_profile = User_Basic_infos.query.filter_by(email=data["Email"]).first()
            user_profile.password = hashed_Value
            db.session.add(user_profile)
            db.session.commit()
            return redirect('/')
    except SignatureExpired:
        return "The Token Is Expired"
    except BadSignature:
        return "The token is invalid"
    return "This email worked"
@app.route('/like', methods=['GET','POST'])
def like():
    if request.method == 'POST':
        res=int(request.form.get('data'))
        lk = likeDetailss(userid=session.get('visits'),forumid=res)
        db.session.add(lk)
        db.session.commit()
    return "render"
@app.route('/dislike', methods=['GET','POST'])
def dislike():
    if request.method == 'POST':
        res=int(request.form.get('data'))
        db.session.query(likeDetailss).filter(and_(likeDetailss.forumid==int(res),likeDetailss.userid== session.get('visits'))).delete()
        db.session.commit()
    return "render"
@app.route('/deletepost',methods=['GET','POST'])
def deletepost():
    if request.method == 'POST':
        re = request.form.get('data')
        res = int(re)
        print(res)
        db.session.execute(f'DELETE FROM likeDetailss WHERE forumid={res}')
        db.session.commit()
        db.session.execute(f'DELETE FROM forum_questions_replays WHERE flag={res}')
        db.session.commit()
        db.session.execute(f'DELETE FROM Forum_Questions WHERE id={res}')
        db.session.commit()
        
        print(res)
    return "render"
if(__name__)=='__main__':
    app.run(debug=True)