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