def registUser(): if request.method == 'POST': #カテゴリとメイン項目を空欄では受け付けない if (len(request.json['user']) != 0 or len(request.json['password']) != 0): #requestで飛んできたカテゴリ、メイン、リンクを変数に格納 name = request.json['user'] password = request.text['password'] #memoListテーブルのセッションを作成 user = User() #格納した変数をそれぞれテーブルのレコードにセットする user.name = name user.passowrd = password #sessionのクエリを発行したので追加してコミットする session.add(User) session.commit() #mypageにレンダリング return render_template('mypage.html', name=session.name) else: #登録に失敗したらリダイレクト return redirect(url_for('/mypage'))
def mypage(): #postリクエストが飛んできたら if request.method == 'POST': #request内のユーザー名、パスワードを変数に格納 name = request.form['name'] password = request.form['password'] #userテーブルのセッションを作成 user = User() #nameカラムがnameのレコードを持ってくる users = session.query(User).\ filter(User.name == name).\ all() #27行目でsessionのクエリを発行したので追加してコミットする session.add(user) session.commit() #持ってきたレコードを順に見ていく for user in users: if (user.password == password): #passwordが合っているのが見つかったら、idとnameを session.name = name #mypageのHTMLをレンダリング return render_template('mypage.html', name=session.name) else: #合ってなかったら、ログイン失敗、リダイレクト return redirect(url_for('index'))
def registMemo(): if request.method == 'POST': #カテゴリとメイン項目を空欄では受け付けない if (len(request.form['category']) != 0 or len(request.form['main']) != 0): #requestで飛んできたカテゴリ、メイン、リンクを変数に格納 category = request.form['category'] main = request.form['main'] link = request.form['link'] #memoListテーブルのセッションを作成 memoList = MemoList() #格納した変数をそれぞれテーブルのレコードにセットする memoList.category = category memoList.main = main memoList.link = link #sessionのクエリを発行したので追加してコミットする session.add(memoList) session.commit() #mypageにレンダリング return render_template('mypage.html', name=session.name) else: #登録に失敗したらリダイレクト return redirect(url_for('/mypage'))
def add_new_record(user_id, game_id, rank, date): user_game_history = UserGameHistory() user_game_history.user_id = user_id user_game_history.game_id = game_id user_game_history.rank = rank user_game_history.date = date session.add(user_game_history) session.commit()
def add_new_user(user_id): try: user = User() user.id = user_id user.strength = INITIAL_RATING session.add(user) session.commit() return user except Exception as e: # TODO: エラーログ出力 print(e)
def offercomplete(): # 特徴量のデータ [1:脂肪を減らしたい2:筋肉を増やしたい, 1:お腹2:腹筋3:腹直筋,未知データ] feature = [[1, 1, 1], [1, 2, 5], [1, 3, 10], [2, 1, 3], [2, 2, 6], [2, 3, 8]] # 正解のデータ 1:脂肪:弱, 2:脂肪:中, 3:脂肪:強, 4:筋肉:弱, 5:筋肉:中, 6:筋肉:強 job = [1, 2, 3, 4, 5, 6] # 予測させるデータ 性別,部位,未知データ(トレーニング前後の体重差分) test_data = [[ request.args.get('sex'), request.args.get('part'), request.args.get('weightdifference') ]] # 学習 clf = svm.SVC(gamma="scale") clf.fit(feature, job) # 学習結果を設定 setno = clf.predict(test_data)[0] # ユーザ情報登録へINSERT session.add( UserRegistration(userid=request.args.get('userid'), sex=request.args.get('sex'), part=request.args.get('part'), age=request.args.get('age'), stature=request.args.get('stature'), beforeweight=request.args.get('beforeweight'), afterweight=request.args.get('afterweight'), trainingenddate=request.args.get('trainingenddate'), endflag="0", createdate=datetime.datetime.now(), updatedate=datetime.datetime.now())) session.commit() # トレーニング実施状況へINSERT session.add( TrainingStatus(userid=request.args.get('userid'), setno=int(setno), traning1status=0, traning2status=0, traning3status=0, endflag="0", createdate=datetime.datetime.now(), updatedate=datetime.datetime.now())) session.commit() # トレーニング実施画面の値設定 tryView(userInfoBase['personaltrainar']['userid'], userInfoBase) return jsonify(userInfoBase)
def modify(contestID): contest_ID = contestID print("modify contest page.") if request.method == "GET": contents = session.query( pm.Problem).filter(pm.Problem.contestID == contest_ID).all() return render_template("modify.html", cont=contents) else: print("modify this contest.") session.query( pm.Problem).filter(pm.Problem.contestID == contest_ID).delete() session.commit() contest_name = request.form["contest_name"] start_date = request.form["start_date"] start_time = request.form["start_time"] end_date = request.form["end_date"] end_time = request.form["end_time"] problems_url = request.form.getlist("problem_url") pr = session.query(pm.Problem).all() for url in problems_url: if len(url) == 0: continue pr = pm.Problem() pr.problemURL = url pr.problem = url.split('/')[5] + url.split('/')[6] pr.contest = contest_name pr.contestID = contest_ID pr.participant = "springroll" pr.start_time = start_date + " " + start_time + ":00" pr.end_time = end_date + " " + end_time + ":00" pr.penalty = 0 pr.last_updated = start_date + " " + start_time + ":00" print(url) session.add(pr) session.commit() return redirect(url_for('contest', contestID=contest_ID))
def createContest(): print("create contest page.") if request.method == "GET": return render_template("create.html") else: contest_name = request.form["contest_name"] start_date = request.form["start_date"] start_time = request.form["start_time"] end_date = request.form["end_date"] end_time = request.form["end_time"] problems_url = request.form.getlist("problem_url") pr = session.query(pm.Problem).all() res_mx = session.query( func.max(pm.Problem.contestID).label("max_contestid")).one() max_contestID = res_mx.max_contestid print(max_contestID) max_contestID += 1 for url in problems_url: pr = pm.Problem() pr.problemURL = url pr.problem = url.split('/')[5] + url.split('/')[6] pr.contest = contest_name pr.contestID = max_contestID pr.participant = "springroll" pr.start_time = start_date + " " + start_time + ":00" pr.end_time = end_date + " " + end_time + ":00" pr.penalty = 0 pr.last_updated = start_date + " " + start_time + ":00" session.add(pr) session.commit() print(pr.contestID) return redirect(url_for('contest', contestID=max_contestID))
from setting import session from user import * user = User() user.name = '太郎' user.age = '20' user.email = '*****@*****.**' users = session.add(user) session.commit() users = session.query(User).all() for user in users : print(user.name)
# セッション変数の取得 from setting import session # Userモデルの取得 from user import * # DBにレコードの追加 user = User() user.name = '太郎' session.add(user) session.commit() # Userテーブルのnameカラムをすべて取得 users = session.query(User).all() for user in users: print(user.name)
g_zaiko.count -= int(nums) if g_zaiko.count <= 0: prin() print('sorry out of stock') prin() continue else: pass yn = input('continue shopping? [y/n] :') if yn == 'y': continue else: prin() print('byebye') prin() break for i in range(len(kago)): g_uriage = session.query(Uriage).filter(Uriage.product_id == kago[i]).one() g_uriage.count += int(count[i]) g_uriage.product_id = num g_uriage.date = date session.add(g_zaiko) session.add(g_uriage) session.commit()
import datetime from history import History from setting import engine if __name__ == "__main__": with open('data/GBPJPY.5.hst', "rb") as f: #Base.metadata.drop_all(bind=ENGINE) Base.metadata.create_all(bind=engine) h = History(f) for record in h: #print("{0} Open:{1} High:{2} Low:{3} Close:{4} Volume:{5} Spread:{6} RealVolume:{7}".format( # time.strftime("%Y/%m/%d %H:%M", time.gmtime(record.ctm)), # record.open, record.high, record.low, record.close, record.volume, record.spread, record.real_volume)) candle = Candle() candle.date = datetime.datetime.fromtimestamp(record.ctm) candle.open = record.open candle.high = record.high candle.low = record.low candle.close = record.close candle.volume = record.volume candle.spread = record.spread candle.realVolume = record.real_volume # DBへ登録 session.add(candle) # コミット session.commit()