import sqlite3
import datetime
from datetime import datetime
from datetime import date
from datetime import timedelta
import requests
def request_handler(request):
start = datetime.now()
dt = date.today() + timedelta(days = 1)
end = datetime.combine(dt, datetime.min.time())
user = request['values']['user']
conn = sqlite3.connect(events_db) # connect to that database (will create if it doesn't already exist)
c = conn.cursor()
all_events = c.execute(f'''SELECT title FROM {user}_events WHERE start_time BETWEEN {start} AND {end}; ''')
event_list = [event for event in all_events]
conn.commit() # commit commands
conn.close() # close connection to database
conn = sqlite3.connect(tasks_db) # connect to that database (will create if it doesn't already exist)
c = conn.cursor()
all_tasks = c.execute(f'''SELECT title FROM {user}_tasks WHERE status = "incomplete"; ''')
task_list = [task for task in all_tasks]
conn.commit() # commit commands
conn.close() # close connection to database
It seems like the error is in line all_events = c.execute..., I am just not sure whats wrong. any ideas?
