0

I am following this documentation to access my sqlite database. https://docs.python.org/3/library/sqlite3.html

Using flask I login to my site by typing in my username and password. This takes me to this route:

@app.route('/index')
def index():
    db = get_db_connection()
    cur = db.cursor()
    print(session['userID']) # prints: 1
    print(type(session['userID'])) # prints: <class 'int'>

    query = """SELECT users.firstName, workouts.dateandtime, workouts.id, sets.*, exercises.name FROM users
  JOIN workouts ON users.id = workouts.userID JOIN sets ON workouts.id = sets.workoutID JOIN exercises ON
  sets.exerciseID = exercises.id WHERE users.id = ?"""
   posts_unsorted = cur.execute(query, session['userID']).fetchall()

I get the error:

ValueError: parameters are of unsupported type

I have looked at my database to make sure the id for the user is an <int> and it is. If I type a 1 in place of the ? in my query the execute works but I need ot be able to look up other users.

What am I doing wrong here?

Funlamb
  • 551
  • 7
  • 20

0 Answers0