def insert_tweet(parent_tweet_id, name, text, image_path, create_at): conn = con.mysql_connect() cursor = conn.cursor() if (parent_tweet_id is None and image_path is None): mySql_insert_query = """INSERT INTO tweet (name,text, create_at) VALUES ( '""" + \ name+"""', '"""+text+"""', '"""+create_at+"""')""" elif (image_path is None): mySql_insert_query = """INSERT INTO tweet (parent_tweet_id, name,text, create_at) VALUES ( '""" + parent_tweet_id + """', '""" + name + """', '""" + text + """', '""" + create_at + """')""" elif (parent_tweet_id is None): mySql_insert_query = """INSERT INTO tweet (name,text, image_path, create_at) VALUES ( '""" + \ name+"""', '"""+text+"""', '"""+image_path+"""', '"""+create_at+"""')""" else: mySql_insert_query = """INSERT INTO tweet (parent_tweet_id, name,text, image_path, create_at) VALUES ( '""" + \ parent_tweet_id+"""','"""+name+"""', '"""+text + \ """', '"""+image_path+"""','"""+create_at+"""')""" try: cursor.execute(mySql_insert_query) conn.commit() return "success" except: conn.rollback() return "failed"
def get_users(): conn = con.mysql_connect() cursor = conn.cursor() fetch_user = """ SELECT * FROM nf_users; """ cursor.execute(fetch_user) result = cursor.fetchall() return result
def get_tweet(): # fetchall tweet from database conn = con.mysql_connect() cursor = conn.cursor() fetch_tweet = """ SELECT * FROM tweet; """ cursor.execute(fetch_tweet) result = cursor.fetchall() return result
def get_reply_count(parent_tweet_id): #counting replies for every tweets conn = con.mysql_connect() cursor = conn.cursor() reply_count = """ SELECT COUNT(*) FROM tweet WHERE parent_tweet_id = '""" + str(parent_tweet_id) + """' """ cursor.execute(reply_count) result = cursor.fetchall() cursor.close() return result
def check_db(email): conn = con.mysql_connect() cursor = conn.cursor() fetch_user = """ SELECT * FROM nf_users; """ cursor.execute(fetch_user) result = cursor.fetchall() for r in result: if (r[2] == email): return "success" else: continue
def sign_in(email, password): conn = con.mysql_connect() cursor = conn.cursor() fetch_user = """ SELECT * FROM nf_users; """ cursor.execute(fetch_user) result = cursor.fetchall() for r in result: if (r[2] == email): if (r[3] == password): id = r[0] return id else: continue
def insert_movies(name, link, description, category_id, image_path): conn = con.mysql_connect() cursor = conn.cursor() mySql_insert_query = """INSERT INTO nf_movies (name, link, description, category_id, image_path) VALUES ( '"""+name+"""', '""" + \ link+"""', '"""+description+"""','"""+category_id+ \ """','"""+image_path+"""')""" try: cursor.execute(mySql_insert_query) conn.commit() return "success" except Exception as e: print(e) conn.rollback() return "failed" conn.close()
def insert_user(name, email, password, con_password): conn = con.mysql_connect() cursor = conn.cursor() if ("@" in email): if (password == con_password): mySql_insert_query = """INSERT INTO nf_users (name, email, password) VALUES ( '"""+name+"""', '""" + \ email+"""', '"""+password+"""')""" try: cursor.execute(mySql_insert_query) conn.commit() get_id = """ SELECT id FROM nf_users WHERE email = '""" + email + """' """ cursor.execute(get_id) id = cursor.fetchall() return id except Exception as e: print( '<script>window.alert("Your email has an account and jump to LOGIN page");</script>' ) print( '<script>window.location.replace("http://localhost/netflix_project/login.py");</script>' ) print(e) conn.rollback() return "failed" conn.close() else: print( '<script>window.alert("Please type in password properly");</script>' ) print( '<script>window.location.replace("http://localhost/netflix_project/signup.py");</script>' ) return else: print( '<script>window.alert("Please type in proper email address");</script>' ) return