a = Account.query.filter_by(username=username).first()
c = Context.query.filter_by(name=context).first()
note = Note(a.id, c.id, kind, content)
note.latitude = float(latitude) * det1
note.longitude = float(longitude) * det2
note.created_at = date
note.modified_at = date
# created_at += datetime.timedelta(seconds=100)
print "create note: %s" % note
db.session.add(note)
db.session.commit()
if media_kind:
media = Media(note.id, media_kind, media_title, media_url)
media.created_at = date
# created_at += datetime.timedelta(seconds=60)
print "create media: %s" % media
db.session.add(media)
db.session.commit()
n = feedback_sheet.cell('A1').value
for i in range(2,2+n):
table_name = feedback_sheet.cell('B' + str(i)).value
row_id = feedback_sheet.cell('C' + str(i)).value
kind = feedback_sheet.cell('D' + str(i)).value
content = feedback_sheet.cell('E' + str(i)).value
username = feedback_sheet.cell('F' + str(i)).value
if id:
a = Account.query.filter_by(username=username).first()
