def post(body):
models.db().execute("""
INSERT INTO BBS (user_id, when_, body) VALUES (?, ?, ?)""", (
models.user().id,
datetime.now(),
sanitize_html(body)))
models.db().commit()
def make_obj(form):
title = form['title']
begin_show = form['begin_show']
end_show = form['end_show']
body = sanitize_html(form['body'])
return {'title': title,
'begin_show': begin_show,
'end_show': end_show,
'body': body}
def make_event_obj(form):
name = form['name']
date = form['date']
loc = form['loc']
deadline = form['deadline']
price = form['price']
description = sanitize_html(form['description'])
when = date + ' 00:00:00'
body = make_event_body(name, loc, deadline, price, description)
return {'when': when,
'body': body}
def make_practice_obj(form):
date = form['date']
begintime = form['begintime']
endtime = form['endtime']
loc = form['loc']
court = form['court']
no = form['no']
price = form['price']
note = sanitize_html(form['note'])
when = date + ' ' + begintime + ':00'
body = make_practice_body(endtime, loc, court, no, price, note)
return {'when': when,
'body': body}
def make_game_obj(form):
name = form['name']
date = form['date']
loc = form['loc']
genre = form['genre']
deadline = form['deadline']
price = form['price']
begin_acceptance = form['begin_acceptance']
begin_game = form['begin_game']
note = sanitize_html(form['note'])
when = date + ' 00:00:00'
body = make_game_body(
name, loc, genre, deadline, price, begin_acceptance, begin_game, note)
return {'when': when,
'body': body}
def update_profile(id, form):
password = get_or_gen_password(form)
check_unique_password(password, id)
sex = sex_atoi(form['sex'])
birthday = form['birthday']
email = form['email']
home = form['home']
car = form['car']
comment = sanitize_html(form['comment'])
profile = dumps({
'birthday': birthday,
'email': email,
'home': home,
'car': car,
'comment': comment
})
models.db().execute('''
UPDATE User
SET password = ?,
sex = ?,
profile = ?
WHERE id = ?''', (password, sex, profile, id))
models.db().commit()
def add_rule():
body = sanitize_html(request.form['body'])
rules.insert(body)
info_message(message=u'規約を追加しましたね。通知とかしたほうがいいんじゃないすか？',
title=u'規約を追加しました')
return redirect(url_for('general.rule'))
