def signup(): if request.method == 'GET': return render_template('/SignupForm.html') CustomerId = request.form.get('CustomerId') LName = request.form.get('LName') FName = request.form.get('FName') Address = request.form.get('Address') City = request.form.get('City') State = request.form.get('State') ZipCode = request.form.get('ZipCode') Telephone = request.form.get('Telephone') Email = request.form.get('Email') AccountId = request.form.get('AccountId') AccountType = request.form.get('AccountType') CreditCard = request.form.get('CreditCard') credate = datetime.datetime.now().strftime("%Y-%m-%d") if not (CustomerId and LName and FName and Address and City and State and ZipCode and Telephone and Email and AccountId and AccountType and CreditCard): return redirect('/signup') db_class = dbModule.Database() sql = "INSERT INTO gmmovie.customers(CustomerId, LName, FName, Address, City, State, ZipCode, Telephone, Email, \ CreditCard, AccountId, AccountType, AccCreateDate, Rating) \ VALUES('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s', '%d','%s', '%s', %d)" % \ (CustomerId, LName, FName, Address, City, State, ZipCode, Telephone, Email, CreditCard, int(AccountId), AccountType, credate, 1) db_class.execute(sql) db_class.commit() return redirect('/')
def mypage(): if 'user' in session: chk = True db_class = dbModule.Database() sql = "select account_num, account_type, account_crdate \ from customer \ where customer_id='%s'" % session['user'] db_class.execute(sql) accinfo = db_class.cursor.fetchall() sql = "select M.movie_name, M.movie_type, M.number_of_copy, M.rating, M.movie_id \ from ORDER_DATA O, CUSTOMER C, MOVIE M \ where O.customer_id=C.customer_id and C.customer_id='%s' and O.movie_id=M.movie_id and O.return_time is null" % session[ 'user'] db_class.execute(sql) ordmovie = db_class.cursor.fetchall() sql = "select M.movie_name, M.movie_type, M.number_of_copy, M.rating \ from customer C, movie M, queue Q \ where C.customer_id='%s' and C.customer_id=Q.customer_id and M.movie_id=Q.movie_id" % session[ 'user'] db_class.execute(sql) movieque = db_class.cursor.fetchall() return render_template('/main/index.html', ordmovie=ordmovie, movieque=movieque, accinfo=accinfo, fbtn=chk) else: return render_template('/main/login.html')
def send(): input_url = check_intro(request.form['input_u']) if (input_url == ''): return render_template('/main/index.html', result='please input URL!') ascii_url = string_to_myNum(input_url) shorten = make_shorten(ascii_url) db_class = dbModule.Database() sql1 = "SELECT shorten FROM shortenDB.shortenTable WHERE origin_url = '%s'" % input_url; check = db_class.executeAll(sql1) result_msg = '' if check: # 이미 존재하는 url result_msg = 'already done!' else: # 존재하지 않는 url인 경우 새로 추가 print('check 0') check_already = "SELECT count(*) FROM shortenDB.shortenTable WHERE shorten = '%s'" % shorten; sameShortenCnt = db_class.executeAll(check_already) sql = "INSERT INTO shortenDB.shortenTable VALUES('%s','%s',%d)" % ( input_url, shorten, sameShortenCnt[0]['count(*)']) db_class.execute(sql) db_class.commit() result_msg = 'insert is done!' db_class.commit() return render_template('/main/index.html', searchURL='http://' + input_url, result=result_msg, shorten_url='http://127.0.0.1:5000/main/' + shorten)
def register(): if request.method == 'GET': return render_template('/main/register.html') else: db_class = dbModule.Database() cid = request.form['cid'] lname = request.form['lname'] fname = request.form['fname'] address = request.form['address'] city = request.form['city'] state = request.form['state'] zipcode = request.form['zipcode'] telephone = request.form['telephone'] eaddress = request.form['eaddress'] cardnum = request.form['cardnum'] crating = request.form['crating'] accnum = request.form['accnum'] atype = request.form['atype'] crdate = datetime.datetime.now().strftime("%Y-%m-%d") sql = "INSERT INTO DBProject.customer(customer_id, Lname, Fname, address, city, \ state, zipcode, telephone, Email_address, card_num, rating, account_num, \ account_type, account_crdate) \ VALUES('%s', '%s', '%s', '%s', '%s', '%s', '%d', '%s','%s', '%s', '%d', '%d', '%s', '%s')" % ( cid, lname, fname, address, city, state, int(zipcode), telephone, eaddress, cardnum, int(crating), int(accnum), atype, crdate) db_class.execute(sql) db_class.commit() return redirect('/')
def post(self): try: parser = reqparse.RequestParser() parser.add_argument('o_result', type=int) parser.add_argument('o_msg', type=str) parser.add_argument('p_machine_id', type=int) parser.add_argument('p_file_name', type=str) args = parser.parse_args() _result = args['o_result'] _msg = args['o_msg'] _machine_id = args['p_machine_id'] _file_name = args['p_file_name'] db_class = dbModule.Database() data = db_class.executeSp('sp_delete_update_process', (_result, _msg, _machine_id, _file_name)) print(data) if data[0]['O_RESULT'] is 0: return { 'o_result': str(data[0]['O_RESULT']), 'o_msg': str(data[0]['O_MESSAGE']) } else: return { 'o_result': str(data[0]['O_RESULT']), 'o_msg': str(data[0]['O_MESSAGE']) } except Exception as e: return {'o_result': 99, 'o_msg': str(e)}
def findMoviebyword(): if request.method == 'GET': return render_template('/main/findbyword.html') else: if request.form['word']=='': return''' <script> alert("단어를 입력해 주세요"); location.href="/" </script> ''' else: db_class= dbModule.Database() words=request.form['word'].split(',') result=[] if(len(words)==1): sql = "select movie_name from movie where movie_name like '%%"+words[0]+"%%'" db_class.execute(sql) result = db_class.cursor.fetchall() else: sql = "select movie_name from movie where movie_name like '%%"+words[0]+"%%' and movie_name like '%%"+words[1]+"%%'" db_class.execute(sql) result = db_class.cursor.fetchall() return render_template('/main/index.html',findmovieword=result, words=words)
def PriceChange(): db_class = dbModule.Database() #평균값. avg_tmon = [] avg_naver = [] avg_auction = [] avg_interpark = [] for i in range(7): print(sevenWeek[i]) avg_tmon.append( db_class.selectAvgDataAsShopPerDay('Nintendo_TB', 'TMON', sevenWeek[i])) avg_naver.append( db_class.selectAvgDataAsShopPerDay('Nintendo_TB', 'SSG', sevenWeek[i])) avg_auction.append( db_class.selectAvgDataAsShopPerDay('Nintendo_TB', 'Auction', sevenWeek[i])) avg_interpark.append( db_class.selectAvgDataAsShopPerDay('Nintendo_TB', 'Interpark', sevenWeek[i])) return render_template('main/PriceChange.html', resultTmon=avg_tmon, resultNaver=avg_naver, resultAuction=avg_auction, resultInterpark=avg_interpark)
def post(self): try: parser = reqparse.RequestParser() parser.add_argument('o_result', type=int) parser.add_argument('o_msg', type=str) parser.add_argument('p_machine_id', type=int) parser.add_argument('p_error_cd', type=str) parser.add_argument('p_error_msg', type=str) parser.add_argument('p_fix_yn', type=str) args = parser.parse_args() _result = args['o_result'] _msg = args['o_msg'] _machine_id = args['p_machine_id'] _error_cd = args['p_error_cd'] _error_msg = args['p_error_msg'] _fix_yn = args['p_fix_yn'] db_class = dbModule.Database() data = db_class.executeSp('sp_insert_errer_info', (_result, _msg, _machine_id, _error_cd, _error_msg, _fix_yn)) print(data) if data[0]['O_RESULT'] is 0: return {'o_result': str(data[0]['O_RESULT']), 'o_msg': str(data[0]['O_MESSAGE'])} else: return {'o_result': str(data[0]['O_RESULT']), 'o_msg': str(data[0]['O_MESSAGE'])} except Exception as e: return {'o_result': 99, 'o_msg': str(e)}
def register(): if request.method=='GET': return render_template('/main/register.html') else: db_class= dbModule.Database() customerid=request.form['customerid'] lastname=request.form['lastname'] firstname=request.form['firstname'] address=request.form['address'] city=request.form['city'] state=request.form['state'] zipcode=request.form['zipcode'] telephone=request.form['telephone'] accountnum=request.form['accountnum'] accounttype=request.form['accounttype'] email=request.form['email'] creditcard=request.form['creditcard'] createdate=datetime.datetime.now().strftime("%Y-%m-%d") sql = "INSERT INTO movie.customer(customer_id, Lname, Fname, address, city, state, zip_code, telephone, account_num, account_type,customer_email,credit_card,acc_create_date) \ VALUES('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%d', '%s', '%s', '%s', '%s')"% (customerid,lastname,firstname,address,city,state,zipcode,telephone,int(accountnum),accounttype,email,creditcard,createdate) db_class.execute(sql) db_class.commit() return redirect('/')
def findMoviebyActor(): if request.method == 'GET': return render_template('/main/findbyactor.html') else: if request.form['actor']=='': return''' <script> alert("배우 이름을 입력해 주세요"); location.href="/" </script> ''' else: db_class= dbModule.Database() actors=request.form['actor'].split(',') result=[] if len(actors)==1: sql = "select m.movie_name, a.actor_name from movie m, actor_movie_table amt, actor a \ where m.movie_id=amt.movie_id and amt.actor_id=a.actor_id and a.actor_name='%s'"%actors[0] else: sql = "select distinct m.movie_name, a1.actor_name, a2.actor_name from movie m, actor_movie_table amt, actor a1, actor a2 where m.movie_id=amt.movie_id and \ m.movie_id in(select amt1.movie_id from actor_movie_table amt1 where a1.actor_id=amt1.actor_id and a1.actor_name='%s') and \ m.movie_id in(select amt2.movie_id from actor_movie_table amt2 where a2.actor_id=amt2.actor_id and a2.actor_name='%s')"%(actors[0],actors[1]) db_class.execute(sql) result = db_class.cursor.fetchall() return render_template('/main/index.html',findmovieactor=result,actors=actors)
def post(self): try: parser = reqparse.RequestParser() parser.add_argument('o_result', type=int) parser.add_argument('o_msg', type=str) parser.add_argument('p_machine_id', type=int) parser.add_argument('p_version_info', type=str) args = parser.parse_args() _result = args['o_result'] _msg = args['o_msg'] _machine_id = args['p_machine_id'] _version_info = args['p_version_info'] db_class = dbModule.Database() data = db_class.executeSp( 'sp_select_update_process', (_result, _msg, _machine_id, _version_info)) print(data) if len(data) > 0: return data else: return [{'machine_id': -1}] except Exception as e: return {'o_result': 99, 'o_msg': str(e)}
def post(self): try: parser = reqparse.RequestParser() parser.add_argument('o_result', type=int) parser.add_argument('o_msg', type=str) parser.add_argument('p_file_info_list', type=str) args = parser.parse_args() _result = args['o_result'] _msg = args['o_msg'] _file_info_list = args['p_file_info_list'] db_class = dbModule.Database() json_data = json.loads(_file_info_list) for item in json_data: print(item) data = db_class.executeSp( 'sp_update_del_yn', (_result, _msg, item['filename'], 'Y')) if data[0]['O_RESULT'] is 0: return { 'o_result': str(data[0]['O_RESULT']), 'o_msg': str(data[0]['O_MESSAGE']) } else: return { 'o_result': str(data[0]['O_RESULT']), 'o_msg': str(data[0]['O_MESSAGE']) } except Exception as e: return {'o_result': 99, 'o_msg': str(e)}
def rateMovie(): order_id = request.form.get('OrderId') rating = request.form.get('Rating') db_class = dbModule.Database() sql = "UPDATE ORDERS SET ORating = " + rating + " WHERE OrderId=" + order_id + ";" db_class.cursor.execute(sql) db_class.commit() return redirect('/')
def post(self, machine_id, status): db_class = dbModule.Database() db_class.execute(''' update master set machine_status = "%s", upd_dt = now() where machine_id = %d ''' % (status, machine_id)) db_class.commit()
def dataremove(): db_class = dbModule.Database() sql = "DELETE FROM coffee" db_class.execute(sql) db_class.commit() return render_template('/main/index.html')
def showMovieList(): sql = "SELECT * FROM MOVIES" db_class = dbModule.Database() cnt = db_class.cursor.execute(sql) if cnt > 0: movie = db_class.cursor.fetchall() return render_template('/MovieForm.html', result=movie) return render_template('/MovieForm.html', result='')
def select_data(): db_class = dbModule.Database() sql = "SELECT idx, test \ FROM testTable" row = db_class.executeAll(sql) # print(row) return row
def select(): db_class = dbModule.Database() row = select_data() return render_template('/test/test.html', result=row, resultData=row if len(row) < 1 else row[0], resultUPDATE=None)
def handle_shorten(name): db_class = dbModule.Database() sql1 = "SELECT origin_url FROM shortenDB.shortenTable WHERE shorten = '%s'" % name; check = db_class.executeAll(sql1) if(check): print('http://'+check[0]['origin_url']) return redirect('http://'+check[0]['origin_url']) else: return render_template('/main/index.html')
def findBestsellerMovie(): db_class= dbModule.Database() sql = "select movie_name, number_of_copy from movie where number_of_copy > 4" db_class.execute(sql) result= db_class.cursor.fetchall() return render_template('/main/index.html',bestsellingmovies=result)
def index(): db_class= dbModule.Database() sql = "SELECT * FROM movie" db_class.execute(sql) movielist= db_class.cursor.fetchall() return render_template('/main/index.html',movielist=movielist)
def index(): chk = True db_class = dbModule.Database() sql = "SELECT * FROM movie" db_class.execute(sql) entmovie = db_class.cursor.fetchall() return render_template('/main/index.html', entmovie=entmovie, initstate=chk)
def select(): db_class = dbModule.Database() sql = "SELECT density, target \ FROM ISIADB.coffee" row = db_class.executeAll(sql) print(row) return render_template('/main/index.html', result=None, densityData=row[0])
def post(self): try: parser = reqparse.RequestParser() parser.add_argument('o_result', type=int) parser.add_argument('o_msg', type=str) parser.add_argument('p_machine_id', type=int) parser.add_argument('p_design_type', type=int) parser.add_argument('p_total_print_cnt', type=int) parser.add_argument('p_print_cnt', type=int) parser.add_argument('p_print_file_name', type=str) parser.add_argument('p_file_name_1', type=str) parser.add_argument('p_file_name_2', type=str) parser.add_argument('p_file_name_3', type=str) parser.add_argument('p_file_name_4', type=str) parser.add_argument('p_file_name_5', type=str) parser.add_argument('p_file_name_6', type=str) parser.add_argument('p_file_name_7', type=str) parser.add_argument('p_file_name_8', type=str) parser.add_argument('p_file_name_9', type=str) parser.add_argument('p_file_name_10', type=str) args = parser.parse_args() _result = args['o_result'] _msg = args['o_msg'] _machine_id = args['p_machine_id'] _design_type = args['p_design_type'] _total_print_cnt = args['p_total_print_cnt'] _print_cnt = args['p_print_cnt'] _print_file_name = args['p_print_file_name'] _file_name_1 = args['p_file_name_1'] _file_name_2 = args['p_file_name_2'] _file_name_3 = args['p_file_name_3'] _file_name_4 = args['p_file_name_4'] _file_name_5 = args['p_file_name_5'] _file_name_6 = args['p_file_name_6'] _file_name_7 = args['p_file_name_7'] _file_name_8 = args['p_file_name_8'] _file_name_9 = args['p_file_name_9'] _file_name_10 = args['p_file_name_10'] db_class = dbModule.Database() data = db_class.executeSp('sp_insert_print_info', (_result, _msg, _machine_id, _design_type, _total_print_cnt, _print_cnt, _print_file_name, _file_name_1, _file_name_2, _file_name_3, _file_name_4, _file_name_5, _file_name_6, _file_name_7, _file_name_8, _file_name_9, _file_name_10)) print(data) if data[0]['O_RESULT'] is 0: return {'o_result': str(data[0]['O_RESULT']), 'o_msg': str(data[0]['O_MESSAGE'])} else: return {'o_result': str(data[0]['O_RESULT']), 'o_msg': str(data[0]['O_MESSAGE'])} except Exception as e: return {'o_result': 99, 'o_msg': str(e)}
def showOrder(): db_class = dbModule.Database() sql = "select AccountId from customers where CustomerId=%s;" db_class.cursor.execute(sql, session['logged_in']['CustomerId']) account_id = db_class.cursor.fetchone() sql2 = "select OrderId, MovieName, Date_Time, Return_Date, ORating from movies, " \ "orders where MovieId=OmovieId and OAccountId ="+str(account_id['AccountId'])+" ORDER BY OrderId;" cnt = db_class.cursor.execute(sql2) if cnt > 0: order = db_class.cursor.fetchall() return render_template('/RateForm.html', result=order) return render_template('/RateForm.html', result='noorder')
def insert(): db_class = dbModule.Database() sql = "INSERT INTO testDB.testTable(test) \ VALUES('%s')" % ('testData') db_class.execute(sql) db_class.commit() return render_template('/layout.html', result='insert is done!', resultData=None, resultUPDATE=None)
def insert(): db_class= dbModule.Database() sql = "INSERT INTO flask_test.testTable(test) VALUES('테스트');" db_class.execute(sql) db_class.commit() return render_template('/test/test.html', result='insert is done!', resultData=None, resultUPDATE=None)
def insert(): db_class = dbModule.Database() sql = ("INSERT INTO testDB.testTable(test) \ VALUES('%s')" % ("testData")) db_class.execute(sql) db_class.commit() return render_template("/test/test.html", result="insert is done!", resultData=None, resultUPDATE=None)
def showBestSeller(): sql = "SELECT MovieName FROM MOVIES WHERE NumCopies > 2;" db_class = dbModule.Database() cnt = db_class.cursor.execute(sql) if cnt > 0: movie = db_class.cursor.fetchall() movieList = '' for i in range(0, cnt): if i == (cnt - 1): movieList += movie[i]['MovieName'] else: movieList += movie[i]['MovieName'] + ', ' return render_template('/Result.html', result=movieList, method='best') return render_template('/Result.html', result='nomovie')
def select(): db_class = dbModule.Database() sql = "SELECT * \ FROM team02.board_qna" row = db_class.executeAll(sql) return render_template( '/main/index.html', result=None, resultDatas=row, # 해당 지점에서 전송 resultUPDATE=None)