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')
