def upload(): upfile = request.files['file'] username = request.form.get('username') print("mmmmmmmmmmmmmmmmmm>>", username, upfile.filename, upfile.filename.replace('..', '')) f = upfile.filename.replace('..', '') f = rename(f, username) path = os.path.join("./boo/static/img/upfiles", f) upfile.save(path) path = path[6:] print(path) u = Users.query.filter(Users.username == username).first() try: print('uuuuu', u) u.img = path db_session.merge(u) db_session.commit() except SQLAlchemyError as err: db_session.rollback() print("Error >>", err) return jsonify({"path": path})
def hate(): l_id = request.values.get('list_id') num = request.values.get('num') feel = request.values.get('feel') lst = Lists.query.filter(Lists.list_id == l_id).first() try: if feel == 'like': if num == 'add': lst.likecnt += 1 else: lst.likecnt -= 1 elif feel == 'hate': if num == 'add': lst.hatecnt -= 1 else: lst.hatecnt += 1 db_session.commit() except Exception as err: print("Error on users>>>", err) db_session.rollback() return redirect('/boo')
def regist_post(): username = request.form.get('username') pw = request.form.get('pw') pw2 = request.form.get('pw2') birthyear = request.form.get('birthyear') birthmonth = request.form.get('birthmonth') birthday = request.form.get('birthday') birthdate = birthyear + getzero(birthmonth) + getzero(birthday) sidogun = request.form.get('sidogun') city = request.form.get('city') addr = sidogun + ' ' + city gender = request.form.get('gender') job = request.form.get('job') email = request.form.get('email') img = None u = Users(username, generate_password_hash(pw), birthdate, addr, gender, job, email, img) try: db_session.add(u) db_session.commit() flash("%s 님, 가입을 환영합니다!" % username) except Exception as err: print("Error on users>>>", err) db_session.rollback() return redirect('/boo')
def comment_delete(cmt_id): print("DDDDDDDDDDDDDDDDD>>>", cmt_id) try: Cmt.query.filter(Cmt.cmt_id == cmt_id).delete() db_session.commit() except SQLAlchemyError as err: db_session.rollback() print("Error!!", err) return jsonify({"result": 'OK'})
def boo_delete(): l_id = request.values.get('list_id') try: Cmt.query.filter(Cmt.list_id == l_id).delete() Lists.query.filter(Lists.list_id == l_id).delete() db_session.commit() except Exception as err: print("Error on users>>>", err) db_session.rollback() return redirect('/boo')
def comment_post(): global user u = Users.query.filter(Users.username == user).first() list_id = request.values.get('list_id') cmt_txt = request.values.get('cmt_txt') (cmt_date, cmt_like, cmt_hate) = (None, None, None) c = Cmt(u.userno, cmt_txt, cmt_date, list_id, cmt_like, cmt_hate) try: db_session.add(c) db_session.commit() except Exception as err: print("Error on users>>>", err) db_session.rollback() return redirect('/boo')
def follow_delete(): username = request.values.get('user') following = request.values.get('following') host = Users.query.filter(Users.username == username).first() guest = Users.query.filter(Users.username == following).first() try: print('삭제삭제삭제삭제삭제삭제삭제삭제삭제삭제삭제삭제') Follow.query.filter(Follow.userno == host.userno, Follow.following == guest.userno).delete() db_session.commit() except Exception as err: print("Error on users>>>", err) db_session.rollback() rd = 'boo/mypage/' + username return redirect(rd)
def follow_post(): username = request.values.get('user') following = request.values.get('following') host = Users.query.filter(Users.username == username).first() guest = Users.query.filter(Users.username == following).first() f = Follow(host.userno, guest.userno) try: db_session.add(f) db_session.commit() except Exception as err: print("Error on users>>>", err) db_session.rollback() rd = 'boo/mypage/' + username return redirect(rd)
def cmt_like(list_id): num = request.values.get('num') cmt_id = request.values.get('cmt_id') cmt = Cmt.query.filter('list_id=:list_id and cmt_id=:cmt_id').params( list_id=list_id, cmt_id=cmt_id).first() try: if num == 'add': cmt.cmt_like += 1 else: cmt.cmt_hate -= 1 db_session.commit() except Exception as err: print("Error on users>>>", err) db_session.rollback() return redirect('/boo')
def write(): global user list_title = request.form.get('list_title') list_txt = request.form.get('list_txt') public = request.form.get('public') (cmt_count, like_cnt, hate_cnt, list_date, isdelete) = (None, None, None, None, None) lid = request.form.get('editId') u = Users.query.filter(Users.username == user).first() lists = Lists(u.userno, list_title, list_txt, cmt_count, like_cnt, hate_cnt, public, list_date, isdelete) l = Lists.query.filter(Lists.list_id == lid).first() print('#########', 'lid====', lid) print('@@@@@@@@@', l) try: if l == None: db_session.add(lists) else: l.list_title = list_title l.list_txt = list_txt if public == 0: l.public = 0 else: l.public = 1 db_session.commit() except Exception as err: print("Error on users>>>", err) db_session.rollback() return redirect('/boo')