def confilm():
'''
確認ページ
'''
if request.method == "GET":
return render_template('confilm.html', session=session)
else:
# name が unique かチェック
name = session.get('name')
member_name = MemberContent.query.filter_by(name=name).first()
if member_name:
return redirect(url_for('complete', status='user_notunique'))
# email が unique かチェック
email = session.get('email')
member_email = MemberContent.query.filter_by(email=email).first()
if member_email:
return redirect(url_for('complete', status='email_notunique'))
# birthdayの取得
birthday = datetime.datetime.strptime(session.get('birthday'),
'%Y-%m-%d')
# DBへ登録
try:
content = MemberContent(name, email, birthday)
db_session.add(content)
db_session.commit()
return redirect(url_for('complete', status='success'))
except Exception as e:
return redirect(url_for('complete', status='dbcommit_failed'))
def create_tags(self, tags, commit=False):
if not tags:
return self
tags = [tag.lower() for tag in tags]
tags = set(tags)
# delete old tags
for tag in self.tags:
db_session.delete(tag)
cls = get_remote_side_class(self, 'tags')
ref_name = get_remote_side(self, 'tags')
# create new tags
for t in tags:
tag = cls()
tag.name = t
setattr(tag, ref_name, self.id)
db_session.add(tag)
cache.delete_tags(self)
if commit:
db_session.commit()
return self
def add():
feature = request.form["feature"]
details = request.form["details"]
content = FeatureContent(feature, details, datetime.now())
db_session.add(content)
db_session.commit()
return redirect(url_for("index"))
def print(self):
printer.write_string_to_printer(str(self))
sleep(5)
#printer.write_string_to_printer(str(self.print_no_fiscal()))
self.print_date = datetime.now()
db_session.add(self)
db_session.commit()
def req():
if request.method == "POST":
teacher_id = request.form["teacher_id"]
lecture = Lecture(teacher_id, datetime.now())
db_session.add(lecture)
db_session.commit()
return redirect(url_for("mypage"))
def add():
title = request.form["title"]
body = request.form["body"]
content = OnegaiContent(title, body, datetime.now())
db_session.add(content)
db_session.commit()
return redirect(url_for("index"))
def add_post():
if ("name" in session):
if (not session["name"] == None):
app.add_template_global(name="status", f="login")
if (request.form["title"]) and (request.form["body"]):
title = request.form["title"]
body = request.form["body"]
check_title = db_session.query(BlogContent).filter_by(
title=title).first()
if check_title:
message = title + "は既に使われています"
return render_template("add_post.html",
message=message,
title=title,
body=body)
else:
post_data = BlogContent(title, body)
db_session.add(post_data)
db_session.commit()
return redirect(url_for("post", title=title))
else:
if request.form["title"]:
return render_template("add_post.html",
title=request.form["title"])
if request.form["body"]:
return render_template("add_post.html",
body=request.form["body"])
if (not request.form["title"]) and (not request.form["body"]):
return redirect(url_for("add"))
else:
return redirect(url_for("login"))
def index():
if request.method == 'GET':
if "user_name" in session:
name = session["user_name"]
posts = Post.query.order_by(Post.due, Post.title).all()
all_user = User.query.order_by(User.user_name).all()
title_name = 'index'
return render_template("index.html",
name=name,
posts=posts,
all_user=all_user,
today=date.today(),
title_name=title_name)
else:
return redirect(url_for("top", status="logout"))
else:
title = request.form.get('title')
detail = request.form.get('detail')
due = request.form.get('due')
due = datetime.strptime(due, '%Y-%m-%d')
user_name = session['user_name']
new_post = Post(title=title,
detail=detail,
due=due,
user_name=user_name)
db_session.add(new_post)
db_session.commit()
db_session.close()
return redirect('/index')
def add():
title = request.form["title"]
body = request.form["body"]
content = KitsuneContest(title, body, datetime.now())
db_session.add(content)
db_session.commit()
return index()
def add():
title = request.form['title']
content = PostIt(title, datetime.now())
print(f'{title}のPOSTを確認')
db_session.add(content)
db_session.commit()
return index()
def new_user():
return_data = {'errors': [], 'message': [], 'data': {}}
try:
data = request.get_json(force=True)
except Exception as e:
return_data['errors'].append(
'There was a problem with the request. Please try again')
return_data['errors'].append(e.args)
return jsonify(return_data)
validate_user_form(data, return_data)
#check to see if validation returned any errors
if return_data['errors']:
print('there were errors')
return jsonify(return_data)
# if no errors go ahead and create the user
user = User(first_name=return_data['data']['first_name'],
last_name=return_data['data']['last_name'],
phone=return_data['data']['phone'],
email=return_data['data']['email'])
db_session.add(user)
db_session.commit()
return jsonify({'message': 'this worked'})
def add():
name = request.form['name']
type = request.form['type']
content = CourtInfo(name, type, datetime.now())
db_session.add(content)
db_session.commit()
return redirect(url_for('index'))
def reset():
selected_osechi = OsechiWishes.query.filter(OsechiWishes.want != 0).all()
for i in selected_osechi:
i.want = 0
db_session.add(i)
db_session.commit()
return start()
def add():
title = request.form["title"]
body = request.form["body"]
content = YarukotoList(title, body)
db_session.add(content)
db_session.commit()
return redirect(url_for("index"))
def add():
title = request.form['title']
body = request.form['body']
content = WishContent(title, body, datetime.now())
db_session.add(content)
db_session.commit()
return redirect(url_for('index'))
def add_agenda():
project_id = int(session["project_id"])
agenda = request.form["agenda"]
content = AgendaContent(project_id, agenda, False, datetime.now())
db_session.add(content)
db_session.commit()
return redirect(url_for("agenda", project_id=project_id))
def post():
answer = request.form["answer"]
id = request.form['id']
update_status = OsechiWishes.query.filter(OsechiWishes.id == id).first()
update_status.want = 1 if answer == 'yes' else 2
db_session.add(update_status)
db_session.commit()
return question()
def post_comments():
comment = Comments()
comment.question_id = request.form['question_id']
comment.content = request.form['content']
db_session.add(comment)
db_session.commit()
return redirect(url_for('question_detail',
question_id=comment.question_id))
def rate(self, request):
rating = request.form.get('rate')
ratingText = request.form.get('text')
ratingText = None if ratingText == '' else ratingText
db_session.add(ShopRatings(rating, ratingText))
db_session.commit()
self.avg_rating = db_session.query(
func.avg(ShopRatings.rating).label('average')).first().average
return jsonify(status='success')
def add_comment():
project_id = int(session["project_id"])
agenda_id = int(session["agenda_id"])
comment = request.form["comment"]
content = CommentContent(project_id, agenda_id, comment, datetime.now())
db_session.add(content)
db_session.commit()
return redirect(url_for("comment", agenda_id=agenda_id))
def review():
if request.method == "POST":
teacher_id = request.form["teacher_id"]
rating = request.form["rating"]
text = request.form["text"]
review = Review(teacher_id, rating, text, datetime.now())
db_session.add(review)
db_session.commit()
return redirect(url_for("mypage"))
def add():
if "user_name" in session:
userid = session["user_name"]
kamoku = request.form["kamoku"]
kiroku = request.form["kiroku"]
time = request.form["time"]
content = studyuser(userid, kamoku, kiroku, time, datetime.now())
db_session.add(content)
db_session.commit()
return redirect(url_for("study"))
def question_new():
question_title = request.form["question_title"]
question_content = request.form["question_content"]
question = Questions()
question.title = question_title
question.content = question_content
db_session.add(question)
db_session.commit()
return redirect(url_for('top'))
def patch_question(question_id):
question = Questions.query.filter_by(id=question_id).first()
question.title = request.form['question_title']
question.content = request.form['question_content']
db_session.add(question)
db_session.commit()
return jsonify({
'id': question.id,
'title': question.title,
'content': question.content,
})
def patch_comments_edit(comment_id):
comment = db_session.query(Comments).filter(
Comments.id == comment_id).first()
comment.content = request.form['content']
db_session.add(comment)
db_session.commit()
return jsonify({
'id': comment.id,
'question_id': comment.question_id,
'content': comment.content,
})
def post_sample(sampler_name=None):
"""
Post matrix to sample
"""
job_id = func.make_id(sampler_name)
job = Job(job_id=job_id,
sampler=sampler_name,
state=c.waiting,
date=datetime.datetime.now())
db_session.add(job)
db_session.commit()
return jsonify(dict(job_id=job_id))
def register():
userid = request.form['userid']
username = request.form['username']
email = request.form['email']
password = request.form['password']
if userid is not None and username is not None and password is not None:
user = Users(userid, username, email, generate_password_hash(password))
db_session.add(user)
db_session.commit()
return render_template('manage/login.html')
flash("账号密码不能为空", 'error')
return render_template('manage/register.html')
def new_garden():
request_content = request.json
name = request_content.get('name')
owner = request_content.get('owner')
lat = request_content.get('latitude')
lon = request_content.get('longitude')
g = Garden(name=name, owner=int(owner), lat=lat, lon=lon)
db_session.add(g)
db_session.commit()
return '', 200
def register():
user_name = request.form["user"]
user = User.query.filter_by(user=user_name).first()
if user:
return redirect(url_for("new",status="exist_user"))
else:
password = request.form["password"]
hashed_password = sha256((user_name + password + key.SALT).encode("utf-8")).hexdigest()
user = User(user_name, hashed_password)
db_session.add(user)
db_session.commit()
session["user_name"] = user_name
return redirect(url_for("index"))
def add_data():
t = " ".join(map(str, request.json['timestamps']))
k = " ".join(request.json['keys'])
print(type(request.json["joy_sadness"]))
print(request.json["keys"])
c = TapRecord(request.json["error_count"], t, k, request.json["name"], \
request.json["sentence_length"], request.json["joy_sadness"], \
request.json["anger_fear"], request.json["trust_disgust"], \
request.json["interest_distraction"], request.json["impression_pessimism"])
db_session.add(c)
db_session.commit()
print(request.json)
return "success"
def add():
obj = json.loads(request.data, "utf-8")
for i in obj:
print obj[i] # @todo: debug
table_apk = TableApk()
table_apk.app_id = obj['appId']
table_apk.version = obj['version']
table_apk.version_code = obj['versionCode']
table_apk.filename = obj['appId'] + '.apk'
table_app = TableApp(obj)
table_app.apks = [table_apk]
db_session.add(table_app)
db_session.commit()
app_id = obj["appId"]
return jsonify(app=dict(id=1, appId=app_id))
def create_persona():
p = Persona()
db_session.add(p)
db_session.commit()
return 'POST Persona'
def update_persona():
p = Persona()
db_session.add(p)
db_dession.commit()
return "Update persona"
