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)
