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)
