def insert_acks(self, user, acks, haiku): ack_time = Util.adjust_ack_ts(datetime.datetime.now(pytz.utc)) conn = Util.get_db_conn() cur = conn.cursor() for ack in acks: cur.execute( "INSERT INTO ack (msg, inserted_at, user_email) VALUES (%s, %s, %s)", (ack, ack_time, user)) haiku = haiku.rstrip() if len(haiku) > 0: cur.execute( "INSERT INTO ack (msg, inserted_at, user_email) VALUES (%s, %s, %s)", (haiku, ack_time, user)) conn.commit() cur.close() conn.close()
def do_get(self, handler): handler.send_response(200) handler.send_header('Content-type', 'text/html') handler.end_headers() self.common_headers(handler.wfile) self.write(handler.wfile, "<body>") user_email = Auth.get_user_email(handler) self.menu_bar(handler.wfile) num_acks, bounty = self.just_inserted(handler) if num_acks != 0: self.ack_butterbar(handler.wfile, '%d peer ack(s) saved :thumb-up:' % (num_acks)) elif bounty: self.ack_butterbar(handler.wfile, 'bounty saved :thumb-up:') now = datetime.datetime.now(pytz.utc) adjusted = Util.adjust_ack_ts(now) self.report_header( handler.wfile, Util.report(adjusted, slack=False), generate_links=False, msg="Sending acks for week:", ) self.generate_bounty_pane(handler.wfile) msg = """ <p1>How did they poke their head above the Roach's high expectations this week? <p> <form action=/ack method=post accept-charset="UTF-8"> <fieldset id="fieldset" disabled="true"> One ack per line:<br><textarea name=ack rows="10" cols="80"></textarea> <p> Haiku (one multi-line ack):<br><textarea name=haiku rows="4" cols="80"></textarea><br> <input type=submit><br> </fieldset> <fieldset id="fieldset-eng-updates" disabled="true"> Engineering updates: <img src="question-mark.png" height="16px" title="Suggest eng updates to Peter. Brag about your PR, your friend's PR, shout about a scary issue."> <br><textarea name=eng-updates rows="4" cols="80"></textarea><br> <input type=submit><br> </fieldset> </form> """ self.write(handler.wfile, msg) self.write(handler.wfile, "<p>Suggested eng updates:<br>") userID = Auth.get_user_email(handler) if userID is None: self.write(handler.wfile, "Not logged in") else: self.write(handler.wfile, "\n<table>\n") now = datetime.datetime.now(pytz.utc) report = Util.report(now) eng_updates = DB.get_eng_updates(report, None) for update in eng_updates: self.render_eng_update(handler.wfile, update) self.write(handler.wfile, "\n</table>\n") self.write(handler.wfile, "\n</body></html>\n")