SQLite ValueError: parameters are of unsupported type

user_15170432 0
Viewed 999

I have used this code in my program:

def insert(self, table, params):
  keys = ', '.join(params.keys())
  values = params.values()

  query = f"INSERT INTO songs ({keys}) VALUES (?, ?);" 
  print(keys)
  print(query)
  print(values)

  self.cur.execute(query , values)
  self.conn.commit()

  return self.cur.lastrowid

Which prints

name, filehash
INSERT INTO songs (name, filehash) VALUES (?, ?);
dict_values(['testaudio8.mp3', 
'BA614A989B7BCF44E38D00EEFFE96F2D8BD6677D'])

but returns the error:

self.cur.execute(query , values)
ValueError: parameters are of unsupported type

I want to insert the values from dict_values into the question marks but I get the error. Can anyone help please?

sqlite sql python
2 Answers

what you need to do is

# skip a few connect code etc 
cur = con.cursor 

values = ("nameToInsert", "fileHash") # <-- Tuple 

cur.execute("INSERT INTO songs (name, filehash) VALUES (?, ?)", values)

Also if you have just one value, you need to pass it like so:

value = ("onlyValue", ) # see the ,

Otherwise it won't work.

user_4343610

Store keys, values in tuple

def insert(self, table, params):
  keys = tuple((params.keys())
  values = tuple(params.values())

  query = f"INSERT INTO songs ({keys}) VALUES (?, ?);" 
  print(keys)
  print(query)
  print(values)

  self.cur.execute(query , values)
  self.conn.commit()

  return self.cur.lastrowid
user_178135390
Related