def test_db_reset():
mydb = db_manager()
mydb.create()
mydb.reset()
assert_true(len(list(mydb.retrieve_all())) is 0)
mydb.insert('testoh', 'landsat', date.today())
mydb.reset()
assert_true(len(list(mydb.retrieve_all())) is 0)
def test_date_conversion():
mydb = db_manager()
mydb.create()
mydb.reset()
mydb.insert('testoh', 'landsat', date.today())
print(date.today)
res = mydb.retrieve_all()
for row in res:
assert_true(db_manager.string_to_date(row[3]) == date.today())
mydb.reset()
def test_insertion_retrieval():
mydb = db_manager()
mydb.create()
mydb.reset()
mydb.insert('testoh', 'landsat', date.today())
res = mydb.retrieve_all()
assert_true(len(list(res)) is 1)
for row in res:
assert_true(type(row[1]) is str)
assert_true(len(row[1]) > 0)
assert_true(type(row[2]) is str)
assert_true(len(row[2]) > 0)
assert_true(type(row[3]) is str)
assert_true(len(row[3]) > 0)
# mydb.insert('', '', '')
# for row in res:
# assert_true(type(row[1]) is str)
# assert_true(type(row[2]) is str)
# assert_true(type(row[3]) is str)
# assert_true(len(row[3]) > 0)
# print(row)
mydb.reset()
def test_db_init():
try:
mydb = db_manager()
except e:
pass
assert_true(mydb is not None)
from flask import Flask, request, session, g, redirect, url_for, abort, render_template, flash
from homeDictator.db import db_manager
from homeDictator.log import log
from homeDictator.activity import activity
from homeDictator.standings import standings
from datetime import date
from subprocess import Popen
app = Flask(__name__,
template_folder="../homeDictator/templates",
static_folder="../homeDictator/static")
mydb = db_manager()
@app.route("/", methods=['GET', 'POST'])
def index():
if request.method == 'POST':
n = request.form['nome']
a = request.form['attivita']
mydb.insert(n, a, date.today())
res = mydb.retrieve_last()
lista = []
for row in res:
lista.append(log(row))
res = mydb.get_activities()
attivita = activity.get_activities()
lista_attivita = mydb.get_activities()
punteggi = standings()
for at in lista_attivita:
a = at[0]