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 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 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 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 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 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 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 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 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 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 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 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')
def sendboard(): all_data = request.json print(all_data) practice_sche = all_data["practice_sche"] perform_sche = all_data["perform_sche"] board_id = all_data["board_id"] userinfo = session.get('loginUser') userid = userinfo["userid"] title = all_data['title'] # duedate = all_data['duedate'] money = all_data['money'] practice = all_data['practice_time'] perform = all_data['perform_time'] prac_address = all_data['practice_address'] perf_address = all_data['perform_address'] detail_textarea = all_data['detail_info'] song_textarea = all_data['song_info'] costume = all_data['costume'] qualification = all_data["qualification"] gender = all_data["gen"] instruments = all_data["instruments"] practice_mapx = all_data["practice_mapx"] practice_mapy = all_data["practice_mapy"] perform_mapx = all_data["perform_mapx"] perform_mapy = all_data["perform_mapy"] isdone = 0 area_number = check_area(perf_address) print(title, money, practice, perform, prac_address, perf_address, detail_textarea, song_textarea, costume, qualification, gender, instruments, practice_mapx, practice_mapy, perform_mapx, perform_mapy, area_number) if (board_id != ""): b = Board(title, qualification, gender, money, practice_sche, practice, perform_sche, perform, costume, prac_address, practice_mapx, practice_mapy, perf_address, area_number, perform_mapx, perform_mapy, detail_textarea, song_textarea, userid, isdone) b.board_id = board_id try: db_session.merge(b) BoardInstrument.query.filter(BoardInstrument.id > 0).filter( BoardInstrument.board_id == board_id).delete() for j in instruments: iid = j['iid'] person = j['person'] inst = BoardInstrument(b.board_id, iid, person) db_session.merge(inst) db_session.commit() # inst = BoardInstrument(b.board_id, instruments.in) except Exception as err: print(err) db_session.rollback() return str(b.board_id) else: b = Board(title, qualification, gender, money, practice_sche, practice, perform_sche, perform, costume, prac_address, practice_mapx, practice_mapy, perf_address, area_number, perform_mapx, perform_mapy, detail_textarea, song_textarea, userid, isdone) print("else>>>>") try: db_session.add(b) db_session.commit() for j in instruments: iid = j['iid'] person = j['person'] inst = BoardInstrument(b.board_id, iid, person) db_session.add(inst) db_session.commit() except Exception as err: print(err) db_session.rollback() return str(b.board_id)
def write(): print("::::::") isAdded = False doc_id = session['loginUser']['userid'] patients_list = Doc_Pat.query.filter(Doc_Pat.doc_id == doc_id).all() immutableMultiDict = request.form jsonData = immutableMultiDict.to_dict(flat=False) request_data_list = [jsonData[d] for i, d in enumerate(jsonData)] pat_id = int(request_data_list.pop(0)[0]) discode = int(request_data_list.pop(0)[0]) col_list = [int(col_id) for col_id in request_data_list.pop(0)] # 기존 환자인지 체크 for patient in patients_list: if (patient.get_json()['id'] == pat_id): isAdded = True break # 신규 환자 추가 if (isAdded == False): dp = Doc_Pat(pat_id, doc_id) try: db_session.add(dp) db_session.commit() except SQLAlchemyError as sqlerr: db_session.rollback() # 환자의 진단된 질병코드가 있는지 확인 및 추가 assigned_discode_list = DocPat_Disc.query.join( Doc_Pat, DocPat_Disc.docpat_id == Doc_Pat.id).filter( Doc_Pat.pat_id == pat_id).all() assigned_docpat = Doc_Pat.query.filter( Doc_Pat.pat_id == pat_id and Doc_Pat.doc_id == doc_id).first() assigned_docpat_id = assigned_docpat.get_json()['id'] # req의 discode가 전체가 아니라, 특정한 discode가 왔고, 그 것이 등록이 안 되어 있을 때 추가 if (discode != 0): assigned_discode_id_list = [ assigned_discode.get_json()['discode_id'] for assigned_discode in assigned_discode_list ] if (discode not in assigned_discode_id_list): dpd = DocPat_Disc(assigned_docpat_id, discode) try: db_session.add(dpd) db_session.commit() except SQLAlchemyError as sqlerr: db_session.rollback() # 리퀘스트 칼럼 data_list = [{ 'pat_id': pat_id, 'usercol_id': col_id } for col_id in col_list] # 기존 칼럼 확인 및 새로 추가할 칼럼으로만 데이터 구성 patuser_col_list_from_db = Pat_Usercol.query.filter( Pat_Usercol.pat_id == pat_id).all() patuser_col_list_from_db_min = [ col_list.get_json()['usercol_id'] for col_list in patuser_col_list_from_db ] input_data_list = [] if (len(patuser_col_list_from_db_min) != 0): for data in data_list: if data['usercol_id'] in patuser_col_list_from_db_min: patuser_col_list_from_db_min.remove(data['usercol_id']) else: input_data_list.append(data) delete_data_list = [{ 'pat_id': pat_id, 'usercol_id': col } for col in patuser_col_list_from_db_min] # 삭제할 데이터가 있으면 delete if (len(delete_data_list) != 0): for delete_data in delete_data_list: # pu = Pat_Usercol(delete_data['pat_id'], delete_data['usercol_id']) delete_col = Pat_Usercol.query.filter( Pat_Usercol.pat_id == delete_data['pat_id'], Pat_Usercol.usercol_id == delete_data['usercol_id']).first() delete_col_id = delete_col.get_json()['id'] try: # db_session.delete(pu) Pat_Usercol.query.filter_by(id=delete_col_id).delete() db_session.commit() custom_res = {"code": 200, "message": "sucess"} # QQQ SQLAlchemyError define 에러 해결하기. except: db_session.rollback() custom_res = {"code": 500, "message": "eerrorr"} # 데이터가 있으면 입력 if len(input_data_list) != 0: try: db_session.bulk_insert_mappings(Pat_Usercol, input_data_list) db_session.commit() custom_res = {"code": 200, "message": "sucess"} except SQLAlchemyError as sqlerr: db_session.rollback() custom_res = {"code": 500, "message": sqlerr} else: custom_res = {"code": 200, "message": "sucess"} return jsonify(custom_res)
def insert_data(v): item = db_session.query(Table).filter_by(code=v['code']).first() if item == None: data = Table(v['code'], v['data']) db_session.add(data) db_session.commit()