def post(self, id=None): indicator = dict() for param_name in fields: if param_name == "username": indicator[param_name] = self.current_user elif param_name == "event": indicator[param_name] = "".join([self.get_argument('event%s' % i) for i in range(1, 4)]) else: indicator[param_name] = self.get_argument(param_name) logging.debug("indicator = %s", indicator) if id: indicator["id"] = id db_execute(update_sql, indicator) self.redirect("/") else: try: db_execute(insert_sql, indicator) except Exception as e: logging.exception("Got exception while adding record.") if e.message == "column date is not unique": self.set_flash_message("error", "The record for %s is existed." % indicator['date']) self.redirect('/add') else: raise e else: self.redirect("/")
def post(self, username=None): user = {} for f in [field for field in fields_user if field != "event_map"]: if username and f == "password": continue user[f] = self.get_argument(f) user["event_map"] = ",".join([self.get_argument("event%s" % i) for i in range(1, 4)]) if not username: user["password"] = sha256_crypt.encrypt(user["password"]) try: if username: db_execute(update_sql_user, user) else: db_execute(insert_sql_user, user) except Exception as e: logging.exception("Got exception while adding user") if e.message == "column username is not unique": self.set_flash_message("error", "The user with name %s is existed." % user["username"]) self.redirect('/signup') else: raise e else: self.set_secure_cookie('user', user["username"]) self.redirect('/')
def get(self, id): db_execute("delete from indicator where id = ?", [id]) self.redirect('/')
#!/usr/bin/python # -*- coding: utf8 -*- from database import db_execute import csv from app import insert_sql with open('data.csv', 'rb') as csvfile: reader = csv.reader(csvfile) reader.next() for row in reader: indicator = {} indicator['date'] = row[0] indicator['username'] = row[1] indicator['morning_temp'] = row[2] indicator['night_temp'] = row[3] indicator['morning_weight'] = row[4] indicator['night_weight'] = row[5] indicator['note'] = row[6] indicator['period_start'] = row[7] indicator['event'] = row[8] db_execute(insert_sql, indicator)