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