def signup_modal(): form_data = request.json email = form_data['email'] password = form_data['password'] cfpassword = form_data['cfpassword'] name = form_data['name'] phone_number = form_data['phone'] nickname = form_data['nickname'] address = form_data['address'] u = Users(email, password, name, phone_number, nickname, address) print(u) try: db_session.add(u) db_session.commit() except Exception as err: print(err) db_session.rollback() if "Duplicate" in str(err): data = {} data['error'] = 'error' data['email'] = u.email print(data) return jsonify(data) print(u.email) return jsonify(u.email)
def sign_up_post(): email = request.form.get('email') name = request.form.get('name') password = request.form.get('password') password2 = request.form.get('password2') print('email=', email, 'name=', name, 'passwd=', password, 'pw2=', password2) if password != password2: flash("암호를 정확히 입력하세요!!") return render_template("sign_up3.html", email=email, name=name) else: token = s.dumps(email, salt='email_confirm') print('token>>>', token) link = url_for('confirm_email', token=token, _external=True) print('link>>>>', link) send_email(to=email, subject='hey', msg=link) print('mail sent') p = Patient(name, email, password, True) print(p) try: db_session.add(p) db_session.commit() except: db_session.rollback() flash("%s 님, 메일을 보냈으니 확인 해주세요." % name) return redirect("/login")
def dbchangepwd(): pwd = request.json loginuser = session.get('loginUser') userinfo = Users.query.filter(Users.user_no == loginuser['userid']).first() print(">>>>>>>>>>>>>>", pwd['pwd']) u = Users(userinfo.email, pwd['pwd'], userinfo.name, userinfo.phone_number, userinfo.nickname, userinfo.address) u.user_no = loginuser["userid"] # u.email = userinfo.email # u.password = pwd # u.name = userinfo.name # u.phone_number = userinfo.phone_number # u.nickname = userinfo.nickname # u.address = userinfo.address print(u) try: db_session.merge(u) db_session.commit() except Exception as err: print(err) db_session.rollback() if "Duplicate" in str(err): data = {} data['error'] = 'error' return jsonify(data) return jsonify("OK")
def songs2(): # a1 = Album.query.filter(Album.albumid == '10242994').one() a1 = Album(albumid='TTT-a1', title='TTT-a1') song1 = Song(songno='TTT2', title='TTT2 Title') song1.album = a1 db_session.add(song1) db_session.commit() print("songs2>>", song1) return "OK"
def mycoms_delete(myalbumid): print("DDDDDDDDDDDDDDDDD>>>", request.form.get('mycomid')) try: Mycom.query.filter(Mycom.id == request.form.get('mycomid')).delete() db_session.commit() except SQLAlchemyError as err: db_session.rollback() print("Error!!", err) return jsonify({"result": 'OK'})
def delmemo(userid, id): dmemo = Memo.query.filter('user_id =:userid and id=:id').params(userid=userid, id=id).first() try: db_session.delete(dmemo) db_session.commit() print("-----------SUCCESSFULLY DELETED MEMO---------------") return '' except Exception as err: db_session.rollback() print("Failed to delete the memo", err) return ''
def delpost(userid, postid): dpost = Post.query.filter('postid=:postid and user_id = :userid').params(postid=postid, userid=userid).first() try: db_session.delete(dpost) db_session.commit() print("-------------------------------------------------Delete success") return '' except Exception as err: db_session.rollback() print("\n\n\n--------------------------Fail Delete", err, "\n\n\n\n") return ''
def ttt_delete(myalbumid): try: # db_session.query(Ttt). Ttt.query.filter(Ttt.id == myalbumid).delete() db_session.commit() except SQLAlchemyError as err: db_session.rollback() print("Error!!", err) return jsonify({"result": 'OK'})
def myalbum_post(): songno = request.form.get('songno') myalbum = Myalbum(session.get('loginUser').get('userid'), songno) try: db_session.add(myalbum) db_session.commit() except SQLAlchemyError as err: db_session.rollback() print("Error!!", err) return jsonify({"result": 'OK'})
def delchecklist(userid, ids): print("delete view") dchecklist = Checklist.query.filter('user_id=:userid and id=:id').params(userid=userid,id=ids).first() print("checklist to delete >>>>>>>>> ", dchecklist) try: db_session.delete(dchecklist) db_session.commit() print("-------------------------------------------------Delete success") return jsonify({'status':'success'}) except Exception as err: db_session.rollback() print("\n\n\n--------------------------Fail Delete", err, "\n\n\n\n") return ''
def ttt_post(myalbumid): content = request.form.get('content') mycom = Ttt(myalbumid, session.get('loginUser').get('userid'), content) try: db_session.add(mycom) db_session.commit() except SQLAlchemyError as err: db_session.rollback() print("Error!!", err) return jsonify({"result": 'OK', 'mycom': mycom.json()})
def del_board(boardid): print(request.form.get('boardid')) try: Board.query.filter( Board.board_id == request.form.get('boardid')).delete() BoardInstrument.query.filter(BoardInstrument.id > 0).filter( BoardInstrument.board_id == request.form.get('boardid')).delete() db_session.commit() except SQLAlchemyError as err: db_session.rollback() print("Error!!", err) return jsonify({"result": 'OK'})
def confirm_email(token): try: email = s.loads(token, salt='email_confirm', max_age=100) except SignatureExpired: # max_age를 넘기면 delete from table하기. return '<h1>유효기간이 만료되었습니다. 다시 가입해주세요. </h1>' user = Patient.query.filter_by( email=email).first() #의사도 추가. first_or_404() 가 뭔지 알아보기. if user.confirmed: flash('이미 가입 처리 된 계정입니다. 로그인 해주세요.') else: user.confirmed = True db_session.add(user) db_session.commit() flash('가입 처리가 완료되었습니다. 감사합니다.') return redirect('/login')
def save(userid): j={} savelst = request.json print("sssssssssssssssssssssssssssssssssssssssssss> ", savelst['checklist'], len(savelst['checklist'])) savelst['checklist'] = ",".join(savelst['checklist']) c = Checklist(userid, savelst['name'], savelst['checklist']) try: db_session.add(c) db_session.commit() print("checklist data inserted") j['status'] = 'success' except Exception as err: db_session.rollback() print("Error?>>>>>>>", err) j['status'] = 'fail' return jsonify(j)
def new_post(): form = PostForm() if session.get('loginUser'): loginUser = session.get('loginUser') else: session['next'] = request.url return redirect('/login') if session.get('loginUser') and form.validate_on_submit(): post = Post(form.title.data, form.content.data, loginUser.get('userid')) try: db_session.add(post) db_session.commit() flash('Your post has been created!', 'success') except: db_session.rollback() return redirect(url_for('posting')) return render_template('create.htm', title="New Post", form=form)
def editmemolist(userid, id): req = request.json userid = session['loginUser']['userid'] name = req['name'] content = req['content'] print("name>>", name, "content>>", content) memo = Memo(userid, name, content) memo.id = id try: db_session.merge(memo) db_session.commit() print("Update Success!!!!!!!!!!!!!!!!!!!!!!!!!!!!!") return jsonify({'status':'success'}) except Exception as err: db_session.rollback() print("\n \n \n Error!!!!!!!!!!!!!!!!!!!!!!", err) return jsonify({'status':'fail'})
def postmemo(): mJson = {} memoJson = request.json print("\n\n\n\n\n\n", memoJson) userid = session['loginUser']['userid'] title = memoJson['name'] memo = memoJson['content'] m = Memo(userid, title, memo) try: db_session.add(m) db_session.commit() mJson['status'] = 'success' print("Done!!!!!!!!!!!!!!!!!!!!!!!!!!!!!") except Exception as err: db_session.rollback() mJson['status'] = 'fail' print("\n \n \n Error!!!!!!!!!!!!!!!!!!!!!!", err) return jsonify(mJson)
def editchecklist(userid, id): req = request.json userid = session['loginUser']['userid'] name = req['name'] content = ",".join(req['content']) print("name>>", name, "content>>", content) check = Checklist(userid, name, content) print("check>>>>>",check) check.id = id try: db_session.merge(check) db_session.commit() print("Update Success!!!!!!!!!!!!!!!!!!!!!!!!!!!!!") return jsonify({'status':'success'}) except Exception as err: db_session.rollback() print("\n \n \n Error!!!!!!!!!!!!!!!!!!!!!!", err) return jsonify({'status':'fail'})
def sqltest(): ret = 'OK' try: # u = User('*****@*****.**', 'hong') # db_session.add(u) # u = User.query.filter(User.id == 10).first() # print("user.id=", u.id) # db_session.delete(u) # u.email = '*****@*****.**' # db_session.add(u) s = db_session() result = s.execute( 'select id, email, nickname from User where id > :id', {'id': 10}) Record = namedtuple('User', result.keys()) rrr = result.fetchall() print(">>", type(result), result.keys(), rrr) records = [Record(*r) for r in rrr] for r in records: print(r, r.nickname, type(r)) s.close() ret = records db_session.commit() # ret = User.query.all() # ret = User.query.filter(User.id > 5) except SQLAlchemyError as sqlerr: db_session.rollback() print("SqlError>>", sqlerr) # except: # print("Error!!") # finally: # db_session.close() # return "RET=" + str(ret) return render_template('main.html', userlist=ret)
def regist_post(): email = request.form.get('email') passwd = request.form.get('passwd') passwd2 = request.form.get('passwd2') nickname = request.form.get('nickname') if passwd != passwd2: flash("암호를 정확히 입력하세요!!") return render_template("regist.html", email=email, nickname=nickname) else: u = User(email, passwd, nickname, True) try: db_session.add(u) db_session.commit() except: db_session.rollback() flash("%s 님, 가입을 환영합니다!" % nickname) return redirect("/login")
def addref(): aid = 'TTT-a1' a1 = Album.query.filter(Album.albumid == aid) print("a1=----------->>", a1, a1.count()) if a1.count() == 0: a1 = Album(albumid=aid, title='TTT-album') else: a1 = a1.one() song1 = Song(songno='TTT3', title='TTT3 Title') song1.album = a1 # 1 : n # song1.albums = [ a1, a2 ] db_session.add(song1) db_session.commit() print("song1=", song1) return "OK"
def register_post(): register = RegistrationForm() if register.validate_on_submit(): flash('Account created for {}'.format(register.username.data), 'success') u = User(register.password.data, register.email.data, register.username.data) try: db_session.add(u) db_session.commit() print("data inserted") except: db_session.rollback() return redirect('/login') return render_template('register.htm', title='Register Page', register=register)
def idx(): ret = 'OK' try: # Create(insert) u = User('*****@*****.**', 'hong') db_session.add(u) print("user.id=", u.id) # Read(select)1 # u = User.query.filter(User.id == 1).first() # lst = User.query.all() # Read(select)2 # s = db_session() # result = s.execute('select id, email, nickname from User where id > :id', {'id':1}) # Record = namedtuple("User", result.keys()) # rrr = result.fetchall() # print(">>", type(result), result.keys(), rrr) # records = [Record(*r) for r in rrr] # for r in records: # print(r, r.nickname, type(r)) # s.close() db_session.commit() # ret = User.query.all() except SQLAlchemyError as sqlerr: db_session.rollback() print("SqlError>>", sqlerr) except: print("Error!!") finally: db_session.close() # return "RET=" + str(ret) return render_template('main.html', userlist=ret)
def mycoms_post(myalbumid): if not session.get('loginUser'): session['next'] = request.url return redirect('/login') loginUser = session.get('loginUser') content = request.form.get('content') cmt = Mycom(myalbumid, loginUser.get('userid'), content) cmt.content = content # cmt.id = 7 print("77777777777777777777777777777777777777777777777>>", cmt.id) try: # db_session.add(cmt) db_session.merge(cmt) db_session.commit() except SQLAlchemyError as err: db_session.rollback() print("Error!!", err) return jsonify({"result": 'OK'})
def upload(): upfile = request.files['file'] # aa.jpg myalbumid = request.form.get('myalbumid') print("mmmmmmmmmmmmmmmmmm>>", myalbumid) try: filename = upfile.filename.replace('..', '') path = rename(os.path.join("./helloflask/static/upfiles", filename)) upfile.save(path) path = path[12:] myalbum = Myalbum.query.filter("id=:id").params(id=myalbumid).first() myalbum.upfile = path db_session.merge(myalbum) db_session.commit() except SQLAlchemyError as err: db_session.rollback() print("Error >>", err) return jsonify({"path": path})
def edit(userid, id): userid=session['loginUser']['userid'] title = request.form.get('title') print("title>>", title) content = request.form.get('content') print("content>>", content) post = Post(title, content, userid) print(post) post.postid = id try: db_session.merge(post) db_session.commit() print("Update Success!!!!!!!!!!!!!!!!!!!!!!!!!!!!!") return redirect('/posting') except Exception as err: db_session.rollback() print("\n \n \n Error!!!!!!!!!!!!!!!!!!!!!!", err) return render_template('writelayout.htm', title="Revise", userid=userid, postid=id, action="/write/edit/{}/{}".format(userid, id), mode="revision")
def log_write(): pat_id = session['loginUser']['userid'] request_list = request.form print(">>>>>>>>>>>>>>>>>>>>>>>>", request_list) pattern = re.compile("[0-9]+") data_list = [] date = None for i, k in enumerate(request_list): data = {} if i == 0: date = request_list[k] else: kk = re.findall(pattern, k)[0] data['pat_id'] = pat_id data['usercol_id'] = kk data['value'] = request_list[k] data['date'] = date data_list.append(data) print("<<<<<<<<<<<<<<<<<<<<<<<<<<", data_list) # Log table에 executemany try: db_session.bulk_insert_mappings(Log, data_list) db_session.commit() # custom_res = Response("Custom Response", 200, {'message': 'success'}) custom_res = {"code": 200, "message": "sucess"} except SQLAlchemyError as sqlerr: db_session.rollback() # custom_res = Response("Custom Response", 500, {'message': sqlerr}) custom_res = {"code": 500, "message": sqlerr} return jsonify(custom_res)
def postwrite(): loginUser = session.get('loginUser') userid = session['loginUser']['userid'] title = request.form.get('title') content = request.form.get('content') # if select: print("ccc>> ", content) print("title>> ", title) print("userid>>", userid) post = Post(title, content, userid) try: db_session.add(post) db_session.commit() print("Done!!!!!!!!!!!!!!!!!!!!!!!!!!!!!") except Exception as err: db_session.rollback() print("\n \n \n Error!!!!!!!!!!!!!!!!!!!!!!", err) return redirect('/posting')
def register_post(): register = RegistrationForm() if register.validate_on_submit(): flash('Account created for {}'.format(register.username.data), 'success') u = User(register.password.data, register.email.data, register.username.data) try: subject = "회원가입 메일" mail = "회원가입을 축하합니다" # s = URLSafeTimedSerializer('The_Key') # QQQ secret key 바꾸기 # token = s.dumps(register.email.data, salt = 'email_confirm') # confirm_email(token) # link = url_for('confirm_email', token = token, _external = True) send_email(subject, mail ,register.email.data) db_session.add(u) db_session.commit() print("data inserted") except Exception as err: db_session.rollback() print("ROLL BACK FOR REGISTER", err) return redirect('/login') return render_template('register.htm', title='Register Page', register = register)
def signup_modal(): email = request.form.get('email') password = request.form.get('password') cfpassword = request.form.get('cfpassword') name = request.form.get('name') phone_number = request.form.get('phone') nickname = request.form.get('nickname') address = request.form.get('address') if password != cfpassword: flash("암호를 입력주세요!!!") else: u = User(email, password, name, phone_number, nickname, address) print(u) try: db_session.add(u) db_session.commit() except Exception as err: print(err) db_session.rollback() return redirect('/perform')