def main_menu(): print("-" * 40) print(" Main Menu") print("-" * 40) print("User ID is", this_u_id) print("0 means not logged in yet, other number means logged in already") f.writing("Printing main menu - Request user response\n") if this_u_id: method = input(''' 0 = Account Profile 2 = Show Seenits 3 = Exit ''') else: method = input(''' 1 = Login 3 = Exit ''') if method == '1': f.writing("Response: 1 - Login\n") login() elif method == '2': f.writing("Response: 2 - Show Seenits\n") show_seenits() elif method == '0': f.writing("Response: 0 - Account Profile\n") account_profile() else: f.writing("Response: 3 - Exit\n") exit()
def read_all(): with conn: try: c.execute('SELECT * FROM user') users = c.fetchall() f.writing("read all users successfully\n") print ("read successfully") return users except: f.writing("read all users error\n") print("read error")
def read_all(post_id): with conn: try: c.execute("SELECT * FROM post_upvote WHERE post_id=" + str(post_id)) items = c.fetchall() f.writing("read all post upvote successfully\n") print ("read successfully") return items except: f.writing("read all post upvote error\n") print("read error")
def read_all(): with conn: try: c.execute('SELECT * FROM seenit') items = c.fetchall() f.writing("read all seenits successfully\n") print("seenit read successfully") return items except: f.writing("read all seenits error\n") print("seenit read error")
def build_database(): f.writing("Build database\n") db.create_tables() db.insert_users() db.insert_seenits() db.insert_posts() db.insert_comments() db.insert_post_upvote() db.show_seenits() db.show_posts() db.show_comments() db.show_post_upvotes()
def read_one(id): query = "SELECT * FROM post_upvote WHERE pu_id=" + str(id) with conn: try: c.execute(query) items = c.fetchall() item = items[0] f.writing("read one post upvote successfully\n") print ("read successfully") return item except: f.writing("read one post upvote error\n") print("read error")
def delete(id): query = "DELETE FROM post_upvote WHERE pu_id=" + str(id) # print (query) with conn: try: c.execute(query) f.writing("delete post upvote successfully\n") print ("delete successfully") conn.commit() except: conn.rollback() f.writing("delete post upvote error\n") print ("delete error")
def insert(id, post_id, author_id): query = "INSERT INTO post_upvote (pu_id, post_id, author_id) VALUES (" + str(id) + "," + str(post_id) + "," + str(author_id) + ")" # print (query) with conn: try: c.execute(query) f.writing("insert post upvote successfully\n") print ("insert successfully") conn.commit() except: conn.rollback() f.writing("insert post upvote error\n") print ("insert error")
def read_one(id): query = "SELECT * FROM seenit WHERE s_id=" + str(id) with conn: try: c.execute(query) items = c.fetchall() item = items[0] f.writing("read one seenit successfully\n") print("seenit read successfully") return item except: f.writing("read one seenit error\n") print("seenit read error")
def delete(id): query = "DELETE FROM seenit WHERE s_id=" + str(id) # print (query) with conn: try: c.execute(query) f.writing("delete seenit successfully\n") print("seenit delete successfully") conn.commit() except: conn.rollback() f.writing("delete seenit error\n") print("seenit delete error")
def delete(s_id): query = "DELETE FROM post WHERE p_id={}".format(s_id) # print (query) with conn: try: c.execute(query) f.writing("delete post successfully\n") print("post delete successfully") conn.commit() except: conn.rollback() f.writing("delete post error\n") print("post delete error")
def read_one(u_id): query = "SELECT * FROM user WHERE u_id=" + str(u_id) with conn: try: c.execute(query) users = c.fetchall() user_info = users[0] f.writing("read one user successfully\n") print ("User Info read successfully") return user_info except: f.writing("read one user error\n") print("User Info read error")
def read_all(seenit_id): query = "SELECT * FROM post WHERE seenit_id=" + str(seenit_id) # print (query) with conn: try: c.execute(query) items = c.fetchall() # print (items) f.writing("read all posts successfully\n") print("post read successfully") return items except: f.writing("read all posts error\n") print("post read error")
def insert(id, category, creater_id): query = "INSERT INTO seenit (s_id, category, creater_id) VALUES (" + str( id) + ",'" + category + "','" + str(creater_id) + "')" # print (query) with conn: try: c.execute(query) f.writing("insert seenit successfully\n") print("seenit insert successfully") conn.commit() except: conn.rollback() f.writing("insert seenit error\n") print("seenit insert error")
def update(id, content): query = "UPDATE comment SET c_content='" + content + "' WHERE c_id=" + str( id) # print (query) with conn: try: c.execute(query) f.writing("update comment sucessfully\n") print("update successfully") conn.commit() except: conn.rollback() f.writing("update comment error\n") print("update error")
def login(name, pwd): h_pwd = crypt.crypt(pwd,salt) query = "SELECT u_id FROM user WHERE u_name='" + name + "'AND pwd='" + h_pwd + "'" with conn: try: c.execute(query) users = c.fetchall() _id = users[0][0] f.writing("login successfully\n") print ("login successfully") return _id except: f.writing("login error\n") print("login error")
def insert(id, name, email, pwd): h_pwd = crypt.crypt(pwd,salt) query = "INSERT INTO user (u_id, u_name, pwd, email) VALUES (" + str(id) + ",'" + name + "','" + h_pwd + "','" + email + "')" # print (query) with conn: try: c.execute(query) f.writing("insert user successfully\n") print ("insert successfully") conn.commit() except: conn.rollback() f.writing("insert user error\n") print ("insert error")
def insert(id, content, post_id, author_id): query = "INSERT INTO comment (c_id, c_content, post_id, author_id) VALUES (" + str( id) + ",'" + content + "'," + str(post_id) + "," + str(author_id) + ")" # print (query) with conn: try: c.execute(query) f.writing("Insert comment successfully\n") print("insert successfully") conn.commit() except: conn.rollback() f.writing("Insert comment error\n") print("insert error")
def delete_comment(p_id): f.writing("delete_comment request user response - Please input id of the one you choose\n") c_id = input("Please input id of the one you choose:") f.writing("Response: ") f.writing(c_id) f.writing("\n") comment.delete(c_id) show_comments(p_id)
def delete_seenit(): f.writing("delete_seenit request user reponse - Please input id of the one you choose\n") s_id = input("Please input id of the one you choose:") f.writing("Response: ") f.writing(s_id) f.writing("\n") seenit.delete(s_id) show_seenits()
def update(id, content): query = "UPDATE post SET p_content='" + content + "' WHERE p_id=" + str(id) # print (query) with conn: try: c.execute(query) f.writing("update post successfully\n") print("post update successfully") conn.commit() except: conn.rollback() f.writing("update post error\n") print("post update error") # read_all(1)
def update(id, name, pwd, email): h_pwd = crypt.crypt(pwd,salt) query = "UPDATE user SET u_name='" + name + "', pwd='" + h_pwd + "', email='" + email + "' WHERE u_id=" + str(id) print (query) with conn: try: c.execute(query) f.writing("update user successfully\n") print ("update successfully") conn.commit() except: conn.rollback() f.writing("update user error\n") print ("update error") # insert(7,'b','b@email')
def show_post(): f.writing("show_post request user response - Please input id of the one you choose\n") p_id = input("Please input id of the one you choose:") f.writing("Response: ") f.writing(p_id) f.writing("\n") _post = post.read_one(p_id) print(_post) comment_and_vote_menu(p_id)
def show_seenit(): f.writing("show_seenit request user reponse - Please input id of the one you choose\n") s_id = input("Please input id of the one you choose:") f.writing("Response: ") f.writing(s_id) f.writing("\n") _seenit = seenit.read_one(s_id) print(_seenit) show_posts(s_id)
def update(id, category): query = "UPDATE seenit SET category='" + category + "' WHERE s_id=" + str( id) # print (query) with conn: try: c.execute(query) f.writing("update seenit successfully\n") print("seenit update successfully") conn.commit() except: conn.rollback() f.writing("update seenit error\n") print("seenit update error") # update(6,'testtest')
def insert_comment(p_id): global new_c_id f.writing("insert_comment request user response - Please input your comment\n") content = input("Please input your comment:") f.writing("Response: ") f.writing(content) f.writing("\n") comment.insert(new_c_id, content, p_id, this_u_id) new_c_id += 1 show_comments(p_id)
def insert_post(s_id): global new_p_id f.writing("insert_post request user response - Please input your post\n") content = input("Please input your post:") f.writing("Response: ") f.writing(content) f.writing("\n") post.insert(new_p_id, content, s_id, this_u_id) new_p_id += 1 show_posts(s_id)
def insert_seenit(): global new_s_id f.writing("insert_seenit request user response - Please describe your seenit\n") category = input("Please describe your seenit:") f.writing("Response: ") f.writing(category) f.writing("\n") seenit.insert(new_s_id, category, this_u_id) new_s_id += 1 show_seenits()
def comment_and_vote_menu(p_id): print("-" * 40) print(" Comment/Vote Menu") print("-" * 40) f.writing("Print comment_and_vote_menu menu - Request user response\n") method = input(''' 1 = Show Comments 2 = Show Votes 3 = Main Menu 4 = Exit ''') if method == '1': f.writing("Response: 1 - Show Comments\n") show_comments(p_id) elif method == '2': f.writing("Response: 2 - Show votes\n") show_votes('post', p_id) elif method == '4': f.writing("Response: 4 - Exit\n") exit() else: f.writing("Response: 3 - Main Menu\n") main_menu()
def delete_vote(table, vote, id): f.writing("delete_vote request user response: Please input id of the one you want to delete\n") v_id = input("Please input id of the one you want to delete:") f.writing("Response: ") f.writing(v_id) f.writing("\n") if table == 'post': if vote == 'up': pu.delete(v_id) else: pd.delete(v_id) show_votes('post', id) else: if vote == 'up': cu.delete(v_id) else: cd.delete(v_id) show_comment(id)