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 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 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 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 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 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 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 = OnegaiContent(title, body, datetime.now())
db_session.add(content)
db_session.commit()
return redirect(url_for("index"))
def delete():
id_list = request.form.getlist("delete")
for id in id_list:
content = OnegaiContent.query.filter_by(id=id).first()
db_session.delete(content)
db_session.commit()
return redirect(url_for("index"))
def delete():
id_list = request.form.getlist('delete')
for id in id_list:
content = WishContent.query.filter_by(id=id).first()
db_session.delete(content)
db_session.commit()
return redirect(url_for('index'))
def edit_update(title):
if ("name" in session):
if (not session["name"] == None):
app.add_template_global(name="status", f="login")
post = db_session.query(BlogContent).filter_by(title=title).first()
if post:
if (request.form["title"]) and (request.form["body"]):
new_title = request.form["title"]
new_body = request.form["body"]
if (title == new_title):
post.body = new_body
db_session.commit()
return redirect(url_for("post", title=title))
else:
post_check = db_session.query(BlogContent).filter_by(
title=new_title).first()
if post_check:
message = new_title + "は既に使われています"
return render_template("edit_post.html",
post=post_check,
message=message)
else:
post.title = new_title
post.body = new_body
db_session.commit()
return redirect(url_for("post", title=new_title))
else:
return redirect(url_for("edit", title=title))
else:
return redirect(url_for("index"))
else:
return redirect(url_for("login"))
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():
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 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 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 update():
# 変更をかけるレコードを.query.filter_by(id=request.form["update"])で絞り込む
content = Dream.query.filter_by(id=request.form["update"]).first()
content.title = request.form["title"]
content.body = request.form["body"]
db_session.commit()
return redirect(url_for("index"))
def update(app_id):
print request.data
obj = json.loads(request.data, "utf-8")
table_app = TableApp.query.filter_by(app_id=app_id).first()
if table_app is not None:
table_app.app_id = obj['appId']
table_app.title = obj['title']
table_app.creator = obj['creator']
table_app.creator_id = obj['creatorId']
table_app.package_name = obj['packageName']
table_app.version = obj['version']
table_app.version_code = obj['versionCode']
table_app.rating = obj['rating']
table_app.promo_text = obj['promoText']
table_app.ratings_count = obj['ratingsCount']
table_app.install_size = obj['installSize']
table_app.downloads_count_text = obj['downloadsCountText']
table_app.permission_id_list = obj['permissionIdList']
table_app.permission_num = obj['permissionNum']
table_app.category_name = obj['category']
table_app.contact_email = obj['contactEmail']
table_app.contact_website = obj['contactWebsite']
table_app.recent_changes = obj['recentChanges']
table_app.description = obj['description']
table_app.price_currency = obj['priceCurrency']
table_app.updated_on = datetime.utcnow()
db_session.commit(table_app)
return jsonify(id=app_id, exists="true")
def update(app_id):
print request.data
obj = json.loads(request.data, "utf-8")
table_app = TableApp.query.filter_by(app_id=app_id).first()
if table_app is not None:
table_app.app_id = obj['appId']
table_app.title = obj['title']
table_app.creator = obj['creator']
table_app.creator_id = obj['creatorId']
table_app.package_name = obj['packageName']
table_app.version = obj['version']
table_app.version_code = obj['versionCode']
table_app.rating = obj['rating']
table_app.promo_text = obj['promoText']
table_app.ratings_count = obj['ratingsCount']
table_app.install_size = obj['installSize']
table_app.downloads_count_text = obj['downloadsCountText']
table_app.permission_id_list = obj['permissionIdList']
table_app.permission_num = obj['permissionNum']
table_app.category_name = obj['category']
table_app.contact_email = obj['contactEmail']
table_app.contact_website = obj['contactWebsite']
table_app.recent_changes = obj['recentChanges']
table_app.description = obj['description']
table_app.price_currency = obj['priceCurrency']
table_app.updated_on = datetime.utcnow()
db_session.commit(table_app)
return jsonify(id=app_id, exists="true")
def delete():
id_list = request.form.getlist("delete")
for id in id_list:
content = KitsuneContest.query.filter_by(id=id).first()
db_session.delete(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 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 update():
try:
prob_con = PaperContent.query.filter_by(
id=request.form.get("prob")).first()
prob_con.prob = 1 #probのDB更新
db_session.add(prob_con)
except AttributeError:
pass
try:
sol_con = PaperContent.query.filter_by(
id=request.form.get("sol")).first()
sol_con.sol = 1 #solのDB更新
db_session.add(sol_con)
except AttributeError:
pass
try:
app_con = PaperContent.query.filter_by(
id=request.form.get("app")).first()
app_con.app = 1 #appのDB更新
db_session.add(app_con)
except AttributeError:
pass
db_session.commit()
return redirect(url_for("index"))
def update(id):
content = studyuser.query.filter_by(id=id).first()
content.kamoku = request.form["kamoku"]
content.kiroku = request.form["kiroku"]
content.time = request.form["time"]
db_session.commit()
return redirect(url_for("study"))
def delete_agenda():
project_id = int(session["project_id"])
content = AgendaContent.query.filter_by(
id=request.form.get("delete", None)).first()
db_session.delete(content)
db_session.commit()
return redirect(url_for("agenda", project_id=project_id))
def update_comment():
project_id = int(session["project_id"])
agenda_id = int(session["agenda_id"])
content = CommentContent.query.filter_by(id=request.form["update"]).first()
content.comment = request.form["update_comment"]
db_session.commit()
return redirect(url_for("comment", agenda_id=agenda_id))
def downloaded(app_id):
table_apk = TableApk.query.filter_by(app_id=app_id).first()
if table_apk is not None:
table_apk.downloaded_flag = True
table_apk.updated_on = datetime.utcnow()
db_session.commit()
return jsonify(app_id=app_id, done="true")
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 delete_comment():
project_id = int(session["project_id"])
agenda_id = int(session["agenda_id"])
content = CommentContent.query.filter_by(
id=request.form.get("delete", None)).first()
db_session.delete(content)
db_session.commit()
return redirect(url_for("comment", agenda_id=agenda_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 downloaded(app_id):
table_apk = TableApk.query.filter_by(app_id=app_id).first()
if table_apk is not None:
table_apk.downloaded_flag = True
table_apk.updated_on = datetime.utcnow()
db_session.commit()
return jsonify(app_id=app_id, done="true")
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():
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'
