def insert_batch_file(filename):
db = db_if.get_db()
table = db['events']
infile = open(filename,'r')
for line in infile.readlines():
row = line.split(',')
if len(row) == 4:
table.insert(dict(action=row[0], value=row[1], date=row[2], time=row[3]))
elif len(row) == 3:
table.insert(dict(action=row[0], value=row[1], date=row[2]))
else:
pass
print "successfully added"
def print_table_contents(tab):
db = db_if.get_db()
table = db[tab]
print "table " + tab + ":"
for key in table.columns:
print "{:<10}".format(key),
print
for row in table:
for val in row.itervalues():
print "{:<10}".format(val),
print
print
def insert_event(activity, value):
db = db_if.get_db()
table = db['events']
# table.insert(dict(name='brush', val=1, date=time.strftime("%x"), time=time.strftime("%X")))
table.insert(dict(action=activity, value=value, date=time.strftime("%x"), time=time.strftime("%X")))
print "successfully added"
def delete_tables():
db = db_if.get_db()
for tab in db.tables:
db[tab].delete()