conn.execute(
"CREATE TABLE IF NOT EXISTS calls (type TEXT, date TEXT, number TEXT, name TEXT, duration TEXT);"
)
conn.execute(
"CREATE TABLE IF NOT EXISTS contacts (number TEXT, name TEXT);")
dump_parse_save_unique(["sms", "calls", "contacts"])
print('Dump!')
@app.route('/')
def index():
return redirect(url_for('dashboard'))
@app.route('/dashboard')
def dashboard():
dumps = sql_load(["sms", "calls", "contacts"])
# print(dumps)
return render_template("dashboard.html.j2", dumps=dumps)
# don't put these into "ifmain"
scheduler.init_app(app)
scheduler.start()
scheduler.run_job('dump_update')
if __name__ == '__main__':
app.run(debug=True)
